DDDD

来源：互联网发布：ubuntu安装时怎么分区编辑：程序博客网时间：2024/06/09 18:10

CREATE TABLE TBL_CAPACITY_LUN_WEEKLY (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`RESOURCE_ID` VARCHAR(50) NOT NULL,
`TOTAL_CAPACITY` DOUBLE NOT NULL,
`USED_CAPACITY` DOUBLE NOT NULL,
`TIRE0_USED_CAPACITY` DOUBLE,
`TIRE1_USED_CAPACITY` DOUBLE,
`TIRE2_USED_CAPACITY` DOUBLE,
`AGGREGATED_TIME` BIGINT(20) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `PK` (`ID`)
)
;

CREATE TABLE TBL_CAPACITY_LUN_MONTHLY (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`RESOURCE_ID` VARCHAR(50) NOT NULL,
`TOTAL_CAPACITY` DOUBLE NOT NULL,
`USED_CAPACITY` DOUBLE NOT NULL,
`TIRE0_USED_CAPACITY` DOUBLE,
`TIRE1_USED_CAPACITY` DOUBLE,
`TIRE2_USED_CAPACITY` DOUBLE,
`AGGREGATED_TIME` BIGINT(20) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `PK` (`ID`)
)
;

CREATE TABLE TBL_CAPACITY_LUN_SEASONLY (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`RESOURCE_ID` VARCHAR(50) NOT NULL,
`TOTAL_CAPACITY` DOUBLE NOT NULL,
`USED_CAPACITY` DOUBLE NOT NULL,
`TIRE0_USED_CAPACITY` DOUBLE,
`TIRE1_USED_CAPACITY` DOUBLE,
`TIRE2_USED_CAPACITY` DOUBLE,
`AGGREGATED_TIME` BIGINT(20) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `PK` (`ID`)
)
;

CREATE TABLE TBL_CAPACITY_LUN_YEARLY (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`RESOURCE_ID` VARCHAR(50) NOT NULL,
`TOTAL_CAPACITY` DOUBLE NOT NULL,
`USED_CAPACITY` DOUBLE NOT NULL,
`TIRE0_USED_CAPACITY` DOUBLE,
`TIRE1_USED_CAPACITY` DOUBLE,
`TIRE2_USED_CAPACITY` DOUBLE,
`AGGREGATED_TIME` BIGINT(20) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `PK` (`ID`)
)
;

DROP TABLE IF EXISTS TBL_CAPACITY_DISK_WEEKLY;
DROP TABLE IF EXISTS TBL_CAPACITY_DISK_MONTHLY;
DROP TABLE IF EXISTS TBL_CAPACITY_DISK_SEASONLY;
DROP TABLE IF EXISTS TBL_CAPACITY_DISK_YEARLY;

CREATE TABLE TBL_CAPACITY_DISK_WEEKLY (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`RESOURCE_ID` VARCHAR(50) NOT NULL,
`TOTAL_CAPACITY` DOUBLE NOT NULL,
`USED_CAPACITY` DOUBLE NOT NULL,
`AGGREGATED_TIME` BIGINT(20) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `PK` (`ID`)
)
;