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

   1 -- MSO Catalog DB: table 'service-recipe' ----\r
   2 -- should update a row for create instance\r
   3 UPDATE mso_catalog.service_recipe\r
   4 SET ORCHESTRATION_URI = "/mso/async/services/CreateGenericALaCarteServiceInstance"\r
   5 WHERE SERVICE_ID = 4\r
   6   AND ACTION = 'createInstance';\r
   7   \r
   8 -- should update a row for delete instance\r
   9 UPDATE mso_catalog.service_recipe\r
  10 SET ORCHESTRATION_URI = "/mso/async/services/DeleteGenericALaCarteServiceInstance"\r
  11 WHERE SERVICE_ID = 4\r
  12   AND ACTION = 'deleteInstance';  \r
  13   \r
  14 SET SQL_SAFE_UPDATES = 0;\r
  15 \r
  16 -- 1 coordinate this change with Dmitry when updating labs \r
  17 UPDATE mso_catalog.service_recipe\r
  18 SET orchestration_uri = "/mso/async/services/CreateGenericMacroServiceNetworkVnf"\r
  19 WHERE orchestration_uri = "/mso/async/services/CreateViprAtmService";\r
  20 \r
  21 UPDATE mso_catalog.service_recipe\r
  22 SET orchestration_uri = "/mso/async/services/DeleteGenericMacroServiceNetworkVnf"\r
  23 WHERE orchestration_uri = "/mso/async/services/DeleteViprAtmService";\r
  24 \r
  25 -- 2 network_recipe\r
  26 UPDATE mso_catalog.network_recipe\r
  27 SET orchestration_uri = '/mso/async/services/UpdateNetworkInstance'\r
  28 WHERE network_type = 'VID_DEFAULT' AND action = 'updateInstance';\r
  29 \r
  30 SET SQL_SAFE_UPDATES = 1;