diff options
| author |   Jerry Flood <jflood@att.com> | 2020-02-11 06:20:54 -0500 |
|---|---|---|
| committer | Jerry Flood <jflood@att.com> | 2020-02-12 06:00:51 -0500 |
| commit | 673f9ae920aa038588c1e401d47cb885243a0f70 (patch) | |
| tree | 5abcd7e5d44fd5d81db7b8d3da1c3da33cc9da2a /cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql | |
| parent | 29482785f9e18a1100fe0ea4695dfaf348e60aa6 (diff) | |
Update schema creation to be schema agnostic
Issue-ID: OPTFRA-684
Change-Id: Idcb851c2ae16fdc7fd68e59fe9e23f25a2f7776b
Signed-off-by: Jerry Flood <jflood@att.com>
Diffstat (limited to 'cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql')
| -rw-r--r-- | cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql b/cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql index d91a17e..803276a 100644 --- a/cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql +++ b/cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql @@ -1,6 +1,5 @@ -CREATE SCHEMA IF NOT EXISTS `optimizer` DEFAULT CHARACTER SET utf8 ; -CREATE TABLE IF NOT EXISTS `optimizer`.`request` ( +CREATE TABLE IF NOT EXISTS `request` ( uuid BINARY(16) NOT NULL, request LONGTEXT NOT NULL, created_time BIGINT(20) NULL DEFAULT NULL, @@ -12,7 +11,7 @@ CREATE TABLE IF NOT EXISTS `optimizer`.`request` ( ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -CREATE TABLE IF NOT EXISTS `optimizer`.`response` ( +CREATE TABLE IF NOT EXISTS `response` ( uuid BINARY(16) NOT NULL, response LONGTEXT NULL DEFAULT NULL, delivered_time BIGINT(20) NULL DEFAULT NULL, @@ -21,7 +20,7 @@ ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -CREATE TABLE IF NOT EXISTS `optimizer`.`topology` ( +CREATE TABLE IF NOT EXISTS `topology` ( uuid BINARY(16) NOT NULL, topology LONGTEXT NULL DEFAULT NULL, topology_start BIGINT(20) NULL DEFAULT NULL, @@ -32,7 +31,7 @@ CREATE TABLE IF NOT EXISTS `optimizer`.`topology` ( ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -CREATE TABLE IF NOT EXISTS `optimizer`.`tickets` ( +CREATE TABLE IF NOT EXISTS `tickets` ( uuid BINARY(16) NOT NULL, tickets LONGTEXT NULL DEFAULT NULL, tickets_start BIGINT(20) NULL DEFAULT NULL, @@ -43,7 +42,7 @@ CREATE TABLE IF NOT EXISTS `optimizer`.`tickets` ( ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -CREATE TABLE IF NOT EXISTS `optimizer`.`optimizer` ( +CREATE TABLE IF NOT EXISTS `optimizer` ( uuid BINARY(16) NOT NULL, optimize_response LONGTEXT NULL DEFAULT NULL, optimize_start BIGINT(20) NULL DEFAULT NULL, |