dsa

CREATE TABLE TBL_CAPACITY_STORAGEPOOL_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_STORAGEPOOL_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_STORAGEPOOL_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_STORAGEARRAY_WEEKLY;
DROP TABLE IF EXISTS TBL_CAPACITY_STORAGEARRAY_MONTHLY;
DROP TABLE IF EXISTS TBL_CAPACITY_STORAGEARRAY_SEASONLY;
DROP TABLE IF EXISTS TBL_CAPACITY_STORAGEARRAY_YEARLY;

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

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

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