aboutsummaryrefslogtreecommitdiffstats
path: root/cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql
diff options
context:
space:
mode:
authorJerry Flood <jflood@att.com>2019-03-19 07:19:56 -0400
committerJerry Flood <jflood@att.com>2019-03-19 19:02:03 +0000
commit0e1571aa50b192ec0d9881ce0a4fa8f6e683f47d (patch)
tree092b4b91c56238d917f22451af4a8039d2f9f293 /cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql
parentca6b4dad4d74ce7a46ec7bf1b0c54a3947f3e970 (diff)
Update changelogs for init containers
Issue-ID: OPTFRA-459 Change-Id: Ia8bb43cf9d2b1063d836d6af7a1ff188d900cda4 Signed-off-by: Jerry Flood <jflood@att.com>
Diffstat (limited to 'cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql')
-rw-r--r--cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql51
1 files changed, 0 insertions, 51 deletions
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;