3.0.0 to 3.1.x

alter table server_master add enable_su_yn varchar(1) default 'N' not null;
alter table server_master add root_password varchar(512) null;
alter table application_master add dedicated_authentication_yn varchar(1) default 'N' not null;
alter table middleware_master add dedicated_authentication_yn varchar(1) default 'N' not null;
alter table server_master modify monitoring_cycle VARCHAR(200) NULL COMMENT '모니터링 주기';
alter table server_network_information modify MAC_ADDRESS varchar(50) null comment '맥어드레스';

DROP TABLE IF EXISTS DASHBOARD;
CREATE TABLE DASHBOARD
(
	DASHBOARD_ID         BIGINT NOT NULL AUTO_INCREMENT COMMENT '대쉬보드 아이디',
	PROJECT_ID           BIGINT NULL COMMENT '프로젝트_아이디',
	CONFIG_CONTENTS      TEXT NULL COMMENT '설정 내용',
	USER_ID              BIGINT NULL COMMENT '사용자_아이디',
	PRIMARY KEY (DASHBOARD_ID)
);

CREATE INDEX _DASHBOARD_1 ON DASHBOARD
(
	PROJECT_ID
);

CREATE INDEX _DASHBOARD_2 ON DASHBOARD
(
	USER_ID
);

DROP TABLE IF EXISTS SERVER_RESOURCE_MONITORING;
DROP TABLE IF EXISTS CPU_MONITORING;
DROP TABLE IF EXISTS DISK_MONITORING;
DROP TABLE IF EXISTS MEMORY_MONITORING;

CREATE TABLE CPU_MONITORING
(
	SERVER_INVENTORY_ID  BIGINT NOT NULL COMMENT '서버_인벤토리_아이디',
	MONITORING_DATETIME  DATETIME NOT NULL COMMENT '모니터링 일시',
	SAMPLE_COUNT         INTEGER NULL COMMENT '샘플수',
	CPU_AVG              FLOAT NULL COMMENT '평균값',
	CPU_MAX              FLOAT NULL COMMENT '최대값',
	PRIMARY KEY (SERVER_INVENTORY_ID,MONITORING_DATETIME)
);
CREATE INDEX _CPU_MONITORING_1 ON CPU_MONITORING
(
	SERVER_INVENTORY_ID
);

CREATE TABLE DISK_MONITORING
(
	SERVER_INVENTORY_ID  BIGINT NOT NULL COMMENT '서버_인벤토리_아이디',
	MONITORING_DATETIME  DATETIME NOT NULL COMMENT '모니터링 일시',
	DEVICE_NAME          VARCHAR(200) NOT NULL COMMENT '디바이스 명',
	SAMPLE_COUNT         INTEGER NULL COMMENT '샘플수',
	DISK_AVG             FLOAT NULL COMMENT '평균값',
	DISK_MAX             FLOAT NULL COMMENT '최대값',
	DISK_USAGE_AVG       FLOAT NULL COMMENT '평균 사용량',
	DISK_USAGE_MAX       FLOAT NULL COMMENT '최대 사용량',
	PRIMARY KEY (SERVER_INVENTORY_ID,MONITORING_DATETIME,DEVICE_NAME)
);
CREATE INDEX _DISK_MONITORING_1 ON DISK_MONITORING
(
	SERVER_INVENTORY_ID,
	DEVICE_NAME
);

CREATE TABLE MEMORY_MONITORING
(
	SERVER_INVENTORY_ID  BIGINT NOT NULL COMMENT '서버_인벤토리_아이디',
	MONITORING_DATETIME  DATETIME NOT NULL COMMENT '모니터링 일시',
	SAMPLE_COUNT         INTEGER NULL COMMENT '샘플수',
	MEMORY_AVG           FLOAT NULL COMMENT '평균값',
	MEMORY_MAX           FLOAT NULL COMMENT '최대값',
	MEMORY_USAGE_AVG     FLOAT NULL COMMENT '평균 사용량',
	MEMORY_USAGE_MAX     FLOAT NULL COMMENT '최대 사용량',
	PRIMARY KEY (SERVER_INVENTORY_ID,MONITORING_DATETIME)
);
CREATE INDEX _MEMORY_MONITORING_1 ON MEMORY_MONITORING
(
	SERVER_INVENTORY_ID
);

DROP TABLE IF EXISTS TOPOLOGY_NODE_POSITION;

CREATE TABLE TOPOLOGY_NODE_POSITION
(
	TYPE                 VARCHAR(20) NOT NULL COMMENT '타입',
	TYPE_ID              BIGINT NOT NULL COMMENT '타입 아이디',
	CONFIG_CONTENTS      TEXT NULL COMMENT '설정 내용',
	USER_ID              BIGINT NULL COMMENT '사용자_아이디',
	PRIMARY KEY (TYPE,TYPE_ID)
);

CREATE INDEX _TOPOLOGY_NODE_POSITION_1 ON TOPOLOGY_NODE_POSITION
(
	USER_ID
);