dsa

CREATE TABLE TBL_CAPACITY_DISK_MONTHLY (
  `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`)
)
;

CREATE TABLE TBL_CAPACITY_DISK_SEASONLY (
  `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`)
)
;

CREATE TABLE TBL_CAPACITY_DISK_YEARLY (
  `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`)
)
;

 

DROP TABLE IF EXISTS TBL_CAPACITY_STORAGEPOOL_WEEKLY;
DROP TABLE IF EXISTS TBL_CAPACITY_STORAGEPOOL_MONTHLY;
DROP TABLE IF EXISTS TBL_CAPACITY_STORAGEPOOL_SEASONLY;
DROP TABLE IF EXISTS TBL_CAPACITY_STORAGEPOOL_YEARLY;

CREATE TABLE TBL_CAPACITY_STORAGEPOOL_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`)
)
;