adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V3.6__UpdateNetworkCollectionCatalogDB.sql

   1 use catalogdb;
   2
   3 UPDATE building_block_detail SET RESOURCE_TYPE = "NETWORK_COLLECTION" WHERE BUILDING_BLOCK_NAME = "ActivateNetworkCollectionBB";
   4 UPDATE building_block_detail SET RESOURCE_TYPE = "NETWORK_COLLECTION" WHERE BUILDING_BLOCK_NAME = "CreateNetworkCollectionBB";
   5 UPDATE building_block_detail SET RESOURCE_TYPE = "NETWORK_COLLECTION" WHERE BUILDING_BLOCK_NAME = "DeleteNetworkCollectionBB";
   6 UPDATE building_block_detail SET RESOURCE_TYPE = "NETWORK_COLLECTION" WHERE BUILDING_BLOCK_NAME = "DeactivateNetworkCollectionBB";
   7 UPDATE building_block_detail SET TARGET_ACTION = "DEACTIVATE" WHERE BUILDING_BLOCK_NAME = "DeactivateNetworkCollectionBB";
   8
   9 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
  10 ("NETWORK_COLLECTION", "PRECREATED", "CREATE", "CONTINUE"),
  11 ("NETWORK_COLLECTION", "ASSIGNED", "CREATE", "FAIL"),
  12 ("NETWORK_COLLECTION", "CREATED", "CREATE", "FAIL"),
  13 ("NETWORK_COLLECTION", "ACTIVE", "CREATE", "FAIL"),
  14 ("NETWORK_COLLECTION", "PENDING_CREATE", "CREATE", "FAIL"),
  15 ("NETWORK_COLLECTION", "PENDING_DELETE", "CREATE", "FAIL"),
  16 ("NETWORK_COLLECTION", "PENDING_ACTIVATION", "CREATE", "FAIL"),
  17 ("NETWORK_COLLECTION", "PENDING", "CREATE", "FAIL"),
  18 ("NETWORK_COLLECTION", "INVENTORIED", "CREATE", "SILENT_SUCCESS"),
  19
  20 ("NETWORK_COLLECTION", "PRECREATED", "DELETE", "FAIL"),
  21 ("NETWORK_COLLECTION", "ASSIGNED", "DELETE", "FAIL"),
  22 ("NETWORK_COLLECTION", "CREATED", "DELETE", "FAIL"),
  23 ("NETWORK_COLLECTION", "ACTIVE", "DELETE", "CONTINUE"),
  24 ("NETWORK_COLLECTION", "PENDING_CREATE", "DELETE", "FAIL"),
  25 ("NETWORK_COLLECTION", "PENDING_DELETE", "DELETE", "FAIL"),
  26 ("NETWORK_COLLECTION", "PENDING_ACTIVATION", "DELETE", "FAIL"),
  27 ("NETWORK_COLLECTION", "PENDING", "DELETE", "FAIL"),
  28 ("NETWORK_COLLECTION", "INVENTORIED", "DELETE", "CONTINUE"),
  29
  30 ("NETWORK_COLLECTION", "PRECREATED", "ACTIVE", "FAIL"),
  31 ("NETWORK_COLLECTION", "ASSIGNED", "ACTIVE", "FAIL"),
  32 ("NETWORK_COLLECTION", "CREATED", "ACTIVE", "FAIL"),
  33 ("NETWORK_COLLECTION", "ACTIVE", "ACTIVE", "SILENT_SUCCESS"),
  34 ("NETWORK_COLLECTION", "PENDING_CREATE", "ACTIVE", "FAIL"),
  35 ("NETWORK_COLLECTION", "PENDING_DELETE", "ACTIVE", "FAIL"),
  36 ("NETWORK_COLLECTION", "PENDING_ACTIVATION", "ACTIVE", "FAIL"),
  37 ("NETWORK_COLLECTION", "PENDING", "ACTIVE", "FAIL"),
  38 ("NETWORK_COLLECTION", "INVENTORIED", "ACTIVE", "CONTINUE");