Containerization feature of SO

[so.git] / packages / root-pack-extras / config-resources / mysql / db-sql-scripts / upgrade / MariaDB-upgrade-1702.37_drop1_to_1707.40_drop1.sql

diff --git a/packages/root-pack-extras/config-resources/mysql/db-sql-scripts/upgrade/MariaDB-upgrade-1702.37_drop1_to_1707.40_drop1.sql b/packages/root-pack-extras/config-resources/mysql/db-sql-scripts/upgrade/MariaDB-upgrade-1702.37_drop1_to_1707.40_drop1.sql
index b5d8622..1cadb75 100644 (file)
--- a/packages/root-pack-extras/config-resources/mysql/db-sql-scripts/upgrade/MariaDB-upgrade-1702.37_drop1_to_1707.40_drop1.sql
+++ b/packages/root-pack-extras/config-resources/mysql/db-sql-scripts/upgrade/MariaDB-upgrade-1702.37_drop1_to_1707.40_drop1.sql
@@ -1,30 +1,30 @@
--- MSO Catalog DB: table 'service-recipe' ----\r
--- should update a row for create instance\r
-UPDATE mso_catalog.service_recipe\r
-SET ORCHESTRATION_URI = "/mso/async/services/CreateGenericALaCarteServiceInstance"\r
-WHERE SERVICE_ID = 4\r
-  AND ACTION = 'createInstance';\r
-  \r
--- should update a row for delete instance\r
-UPDATE mso_catalog.service_recipe\r
-SET ORCHESTRATION_URI = "/mso/async/services/DeleteGenericALaCarteServiceInstance"\r
-WHERE SERVICE_ID = 4\r
-  AND ACTION = 'deleteInstance';  \r
-  \r
-SET SQL_SAFE_UPDATES = 0;\r
-\r
--- 1 coordinate this change with Dmitry when updating labs \r
-UPDATE mso_catalog.service_recipe\r
-SET orchestration_uri = "/mso/async/services/CreateGenericMacroServiceNetworkVnf"\r
-WHERE orchestration_uri = "/mso/async/services/CreateViprAtmService";\r
-\r
-UPDATE mso_catalog.service_recipe\r
-SET orchestration_uri = "/mso/async/services/DeleteGenericMacroServiceNetworkVnf"\r
-WHERE orchestration_uri = "/mso/async/services/DeleteViprAtmService";\r
-\r
--- 2 network_recipe\r
-UPDATE mso_catalog.network_recipe\r
-SET orchestration_uri = '/mso/async/services/UpdateNetworkInstance'\r
-WHERE network_type = 'VID_DEFAULT' AND action = 'updateInstance';\r
-\r
+-- MSO Catalog DB: table 'service-recipe' ----
+-- should update a row for create instance
+UPDATE mso_catalog.service_recipe
+SET ORCHESTRATION_URI = "/mso/async/services/CreateGenericALaCarteServiceInstance"
+WHERE SERVICE_ID = 4
+  AND ACTION = 'createInstance';
+  
+-- should update a row for delete instance
+UPDATE mso_catalog.service_recipe
+SET ORCHESTRATION_URI = "/mso/async/services/DeleteGenericALaCarteServiceInstance"
+WHERE SERVICE_ID = 4
+  AND ACTION = 'deleteInstance';  
+  
+SET SQL_SAFE_UPDATES = 0;
+
+-- 1 coordinate this change with Dmitry when updating labs 
+UPDATE mso_catalog.service_recipe
+SET orchestration_uri = "/mso/async/services/CreateGenericMacroServiceNetworkVnf"
+WHERE orchestration_uri = "/mso/async/services/CreateViprAtmService";
+
+UPDATE mso_catalog.service_recipe
+SET orchestration_uri = "/mso/async/services/DeleteGenericMacroServiceNetworkVnf"
+WHERE orchestration_uri = "/mso/async/services/DeleteViprAtmService";
+
+-- 2 network_recipe
+UPDATE mso_catalog.network_recipe
+SET orchestration_uri = '/mso/async/services/UpdateNetworkInstance'
+WHERE network_type = 'VID_DEFAULT' AND action = 'updateInstance';
+
 SET SQL_SAFE_UPDATES = 1;
\ No newline at end of file