From 0e1571aa50b192ec0d9881ce0a4fa8f6e683f47d Mon Sep 17 00:00:00 2001 From: Jerry Flood Date: Tue, 19 Mar 2019 07:19:56 -0400 Subject: Update changelogs for init containers Issue-ID: OPTFRA-459 Change-Id: Ia8bb43cf9d2b1063d836d6af7a1ff188d900cda4 Signed-off-by: Jerry Flood --- .../optimizer-dbchanges/onap-cmso-v1-schema.sql | 51 ---------------------- 1 file changed, 51 deletions(-) delete mode 100644 cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql (limited to 'cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql') diff --git a/cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql b/cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql deleted file mode 100644 index d6e225b..0000000 --- a/cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql +++ /dev/null @@ -1,51 +0,0 @@ -CREATE SCHEMA IF NOT EXISTS `optimizer` DEFAULT CHARACTER SET utf8 ; - -CREATE TABLE IF NOT EXISTS `optimizer`.`request` ( - uuid BINARY(16) NOT NULL, - request LONGTEXT NOT NULL, - created_time BIGINT(20) NULL DEFAULT NULL, - request_start BIGINT(20) NULL DEFAULT NULL, - request_end BIGINT(20) NULL DEFAULT NULL, - status VARCHAR(45) NULL DEFAULT NULL, - PRIMARY KEY (`uuid`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE IF NOT EXISTS `optimizer`.`response` ( - uuid BINARY(16) NOT NULL, - repsonse LONGTEXT NULL DEFAULT NULL, - delivered_time BIGINT(20) NULL DEFAULT NULL, - PRIMARY KEY (`uuid`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - - -CREATE TABLE IF NOT EXISTS `optimizer`.`topology` ( - uuid BINARY(16) NOT NULL, - topology LONGTEXT NULL DEFAULT NULL, - topology_start BIGINT(20) NULL DEFAULT NULL, - topology_end BIGINT(20) NULL DEFAULT NULL, - topology_retries INT NULL DEFAULT NULL, - PRIMARY KEY (`uuid`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE IF NOT EXISTS `optimizer`.`tickets` ( - uuid BINARY(16) NOT NULL, - tickets LONGTEXT NULL DEFAULT NULL, - tickets_start BIGINT(20) NULL DEFAULT NULL, - tickets_end BIGINT(20) NULL DEFAULT NULL, - tickets_retries INT NULL DEFAULT NULL, - PRIMARY KEY (`uuid`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE IF NOT EXISTS `optimizer`.`optimizer` ( - uuid BINARY(16) NOT NULL, - optimize_response LONGTEXT NULL DEFAULT NULL, - optimize_start BIGINT(20) NULL DEFAULT NULL, - optimize_end BIGINT(20) NULL DEFAULT NULL, - optimize_retries INT NULL DEFAULT NULL, - PRIMARY KEY (`uuid`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; -- cgit 1.2.3-korg