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/cmso-dbchangelog | |
| 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/cmso-dbchangelog')
5 files changed, 0 insertions, 6 deletions
diff --git a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1-schema.sql b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1-schema.sql index 470cb3d..3c75563 100644 --- a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1-schema.sql +++ b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1-schema.sql @@ -1,6 +1,4 @@ -CREATE DATABASE IF NOT EXISTS CMSO; -USE CMSO; CREATE TABLE IF NOT EXISTS DOMAINS ( domain VARCHAR(256) NOT NULL, diff --git a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql index 639a030..b77490d 100644 --- a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql +++ b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql @@ -1,4 +1,3 @@ -USE CMSO; -- Schedules Add UUID column ALTER TABLE SCHEDULES ADD COLUMN uuid BINARY(16) NOT NULL FIRST; diff --git a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-ids.sql b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-ids.sql index 5522f64..b6df3ae 100644 --- a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-ids.sql +++ b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-ids.sql @@ -1,4 +1,3 @@ -USE CMSO; -- -------------------------------------------------------------- -- DROP ALL OF THE INTENGER IDs diff --git a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-indices.sql b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-indices.sql index ec74432..75df726 100644 --- a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-indices.sql +++ b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-indices.sql @@ -1,4 +1,3 @@ -USE CMSO; -- ----------------------------------------------------- -- DROP THE FOREIGN KEYS THAT USE INT IDs diff --git a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-restore-indices.sql b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-restore-indices.sql index 0cb224a..19b9eca 100644 --- a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-restore-indices.sql +++ b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-restore-indices.sql @@ -1,4 +1,3 @@ -USE CMSO; -- ----------------------------------------------------- -- UPDATE THE PRIMARY KEYS |