From 090cb77be5c347cc764920fea491a149b5380bcf Mon Sep 17 00:00:00 2001 From: Eric Multanen Date: Sat, 8 Dec 2018 00:04:54 -0800 Subject: [PATCH] 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 --- .../{v4.21_AddHomingTables.sql => V4.21__AddHomingTables.sql} | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) rename adapters/mso-catalog-db-adapter/src/main/resources/db/migration/{v4.21_AddHomingTables.sql => V4.21__AddHomingTables.sql} (92%) 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 similarity index 92% rename from adapters/mso-catalog-db-adapter/src/main/resources/db/migration/v4.21_AddHomingTables.sql rename to 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 +) ; -- 2.16.6