From 673f9ae920aa038588c1e401d47cb885243a0f70 Mon Sep 17 00:00:00 2001
From: Jerry Flood <jflood@att.com>
Date: Tue, 11 Feb 2020 06:20:54 -0500
Subject: Update schema creation to be schema agnostic

Issue-ID: OPTFRA-684
Change-Id: Idcb851c2ae16fdc7fd68e59fe9e23f25a2f7776b
Signed-off-by: Jerry Flood <jflood@att.com>
---
 .../optimizer-dbchanges/onap-optimizer-v1-schema.sql          | 11 +++++------
 1 file changed, 5 insertions(+), 6 deletions(-)

(limited to 'cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql')

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,
-- 
cgit 1.2.3-korg

