summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorEric Multanen <eric.w.multanen@intel.com>2018-12-08 00:04:54 -0800
committerEric Multanen <eric.w.multanen@intel.com>2018-12-10 18:07:01 -0800
commit090cb77be5c347cc764920fea491a149b5380bcf (patch)
tree5bc1690fb5b3d3513663e44e4a95587698beb5ba
parentb19a518ceecc27255505616eed878abcff260f25 (diff)
fix homing_instances table create
specify the catalogdb in the script to create the homing_instances table. Renamed file to begin with 'V' instead of 'v' Not sure if that matters or not. Change-Id: I35533ae5e22c23b8c1817fe8c373e40fa434f873 Issue-ID: SO-1306 Signed-off-by: Eric Multanen <eric.w.multanen@intel.com>
-rw-r--r--adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.21__AddHomingTables.sql (renamed from adapters/mso-catalog-db-adapter/src/main/resources/db/migration/v4.21_AddHomingTables.sql)4
1 files changed, 3 insertions, 1 deletions
diff --git a/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/v4.21_AddHomingTables.sql b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.21__AddHomingTables.sql
index a2ebe04ed8..1725028104 100644
--- a/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/v4.21_AddHomingTables.sql
+++ b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.21__AddHomingTables.sql
@@ -1,7 +1,9 @@
+use catalogdb;
+
CREATE TABLE IF NOT EXISTS `homing_instances` (
`SERVICE_INSTANCE_ID` varchar(50) NOT NULL,
`CLOUD_OWNER` VARCHAR(200) NOT NULL,
`CLOUD_REGION_ID` VARCHAR(200) NOT NULL,
`OOF_DIRECTIVES` longtext NULL DEFAULT NULL,
PRIMARY KEY (`SERVICE_INSTANCE_ID`)
-) ; \ No newline at end of file
+) ;