diff options
Diffstat (limited to 'packages/root-pack-extras/config-resources/mysql/db-sql-scripts/upgrade/MariaDB-upgrade-1702.37_drop1_to_1707.40_drop1.sql')
-rw-r--r-- | packages/root-pack-extras/config-resources/mysql/db-sql-scripts/upgrade/MariaDB-upgrade-1702.37_drop1_to_1707.40_drop1.sql | 58 |
1 files changed, 29 insertions, 29 deletions
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 b5d862226a..1cadb75d5f 100644 --- 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' ----
--- 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';
-
+-- 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 |