2 insert into heat_files(artifact_uuid, name, version, description, body, artifact_checksum, creation_timestamp) values
3 ('00535bdd-0878-4478-b95a-c575c742bfb0', 'nimbus-ethernet-gw', '1', 'created from csar', 'DEVICE=$dev\nBOOTPROTO=none\nNM_CONTROLLED=no\nIPADDR=$ip\nNETMASK=$netmask\nGATEWAY=$gateway\n', 'MANUAL RECORD', '2017-01-21 23:56:43');
6 insert into tosca_csar(artifact_uuid, name, version, description, artifact_checksum, url, creation_timestamp) values
7 ('0513f839-459d-46b6-aa3d-2edfef89a079', 'service-Ciservicee3756aea561a-csar.csar', '1', 'TOSCA definition package of the asset', 'YTk1MmY2MGVlNzVhYTU4YjgzYjliMjNjMmM3NzU1NDc=', '/sdc/v1/catalog/services/Ciservicee3756aea561a/1.0/artifacts/service-Ciservicee3756aea561a-csar.csar', '2017-11-27 11:38:27');
10 insert into service(model_uuid, model_name, model_invariant_uuid, model_version, description, creation_timestamp, tosca_csar_artifact_uuid, service_type, service_role, environment_context, workload_context) values
11 ('5df8b6de-2083-11e7-93ae-92361f002671', 'MSOTADevInfra_vSAMP10a_Service', '9647dfc4-2083-11e7-93ae-92361f002671', '1.0', 'MSO aLaCarte Vfmodule with addon', '2017-04-14 13:42:39', '0513f839-459d-46b6-aa3d-2edfef89a079', 'NA', 'NA', 'Luna', 'Oxygen');
13 insert into service(model_uuid, model_name, model_invariant_uuid, model_version, description, creation_timestamp, tosca_csar_artifact_uuid, service_type, service_role, environment_context, workload_context) values
14 ('5df8b6de-2083-11e7-93ae-92361f002672', 'MSOTADevInfra_vSAMP10a_Service', '9647dfc4-2083-11e7-93ae-92361f002671', '2.0', 'MSO aLaCarte Vfmodule with addon', '2017-04-14 13:42:39', null, 'NA', 'NA', 'Luna', 'Oxygen');
16 insert into service(model_uuid, model_name, model_invariant_uuid, model_version, description, creation_timestamp, tosca_csar_artifact_uuid, service_type, service_role, environment_context, workload_context) values
17 ('5df8b6de-2083-11e7-93ae-92361f002673', 'MSOTADevInfra_vSAMP10a_Service', '9647dfc4-2083-11e7-93ae-92361f002671', '2.1', 'MSO aLaCarte Vfmodule with addon', '2017-04-14 13:42:39', null, 'NA', 'NA', 'Luna', 'Oxygen');
20 insert into service(model_uuid, model_name, model_invariant_uuid, model_version, description, creation_timestamp, tosca_csar_artifact_uuid, service_type, service_role, environment_context, workload_context) values
21 ('5df8b6de-2083-11e7-93ae-92361f002674', 'MSOTADevInfra_vSAMP10a_Service', '9647dfc4-2083-11e7-93ae-92361f002671', '2.1.1', 'MSO aLaCarte Vfmodule with addon', '2017-04-14 13:42:39', null, 'NA', 'NA', 'Luna', 'Oxygen');
22 insert into service(model_uuid, model_name, model_invariant_uuid, model_version, description, creation_timestamp, tosca_csar_artifact_uuid, service_type, service_role, environment_context, workload_context) values
23 ('5df8b6de-2083-11e7-93ae-92361f002675', 'MSOTADevInfra_vSAMP10a_Service', '9647dfc4-2083-11e7-93ae-92361f002671', '2.1.2', 'MSO aLaCarte Vfmodule with addon', '2017-04-14 13:42:39', null, 'NA', 'NA', 'Luna', 'Oxygen');
26 insert into service_recipe(id, action, version_str, description, orchestration_uri, service_param_xsd, recipe_timeout, service_timeout_interim, creation_timestamp, service_model_uuid) values
27 ('1', 'createInstance', '1', 'MSOTADevInfra aLaCarte', '/mso/async/services/CreateGenericALaCarteServiceInstance', null, '180', '0', '2017-04-14 19:18:20', '5df8b6de-2083-11e7-93ae-92361f002671');
29 insert into heat_template(artifact_uuid, name, version, description, body, timeout_minutes, artifact_checksum, creation_timestamp) values
30 ('ff874603-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56'),
31 ('ff87482f-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56'),
32 ('aa874603-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56');
35 insert into heat_template_params(heat_template_artifact_uuid, param_name, is_required, param_type, param_alias) values
36 ('ff874603-4222-11e7-9252-005056850d2e', 'availability_zone_0', 1, 'string', ''),
37 ('ff874603-4222-11e7-9252-005056850d2e', 'exn_direct_net_fqdn',1, 'string', ''),
38 ('ff874603-4222-11e7-9252-005056850d2e', 'exn_hsl_net_fqdn', 1, 'string', '');
40 insert into heat_environment(artifact_uuid, name, version, description, body, artifact_checksum, creation_timestamp) values
41 ('fefb1601-4222-11e7-9252-005056850d2e', 'module_nso.env', '2', 'Auto-generated HEAT Environment deployment artifact', 'parameters:\n availability_zone_0: \"alln-zone-1\"\n nso_flavor_name: \"citeis.1vCPUx2GB\"\n nso_image_name: \"RHEL-6.8-BASE-20160912\"\n nso_name_0: \"zrdm3vamp01nso001\"\n nso_oam_ip_0: \"172.18.25.175\"\n nso_oam_net_gw: \"172.18.25.1\"\n nso_oam_net_mask: \"255.255.255.0\"\n nso_sec_grp_id: \"36f48d82-f099-4437-bfbc-70d9e5d420d1\"\n nso_srv_grp_id: \"e431c477-5bd1-476a-bfa9-e4ce16b8356b\"\n oam_net_id: \"nso_oam\"\n vf_module_id: \"145cd730797234b4a40aa99335abc143\"\n vnf_id: \"730797234b4a40aa99335157b02871cd\"\n vnf_name: \"Mobisupport\"\n', 'MWI2ODY0Yjc1NDJjNWU1NjdkMTAyMjVkNzFmZDU0MzA=', '2017-11-27 08:42:58'),
42 ('fefb1751-4333-11e7-9252-005056850d2e', 'module_nso.env', '2', 'Auto-generated HEAT Environment deployment artifact', 'parameters:\n availability_zone_0: \"alln-zone-1\"\n nso_flavor_name: \"citeis.1vCPUx2GB\"\n nso_image_name: \"RHEL-6.8-BASE-20160912\"\n nso_name_0: \"zrdm3vamp01nso001\"\n nso_oam_ip_0: \"172.18.25.175\"\n nso_oam_net_gw: \"172.18.25.1\"\n nso_oam_net_mask: \"255.255.255.0\"\n nso_sec_grp_id: \"36f48d82-f099-4437-bfbc-70d9e5d420d1\"\n nso_srv_grp_id: \"e431c477-5bd1-476a-bfa9-e4ce16b8356b\"\n oam_net_id: \"nso_oam\"\n vf_module_id: \"145cd730797234b4a40aa99335abc143\"\n vnf_id: \"730797234b4a40aa99335157b02871cd\"\n vnf_name: \"Mobisupport\"\n', 'MWI2ODY0Yjc1NDJjNWU1NjdkMTAyMjVkNzFmZDU0MzA=', '2017-11-27 08:42:58');
44 insert into vnf_resource(orchestration_mode, description, creation_timestamp, model_uuid, aic_version_min, aic_version_max, model_invariant_uuid, model_version, model_name, tosca_node_type, heat_template_artifact_uuid) values
45 ('HEAT', '1607 vSAMP10a - inherent network', '2017-04-14 21:46:28', 'ff2ae348-214a-11e7-93ae-92361f002671', '', '', '2fff5b20-214b-11e7-93ae-92361f002671', '1.0', 'vSAMP10a', 'VF', null);
47 insert into vnf_resource_customization(model_customization_uuid, model_instance_name, min_instances, max_instances, availability_zone_max_count, nf_type, nf_role, nf_function, nf_naming_code, creation_timestamp, vnf_resource_model_uuid, multi_stage_design, cds_blueprint_name, cds_blueprint_version) values
48 ('68dc9a92-214c-11e7-93ae-92361f002671', 'vSAMP10a 1', '0', '0', '0', 'vSAMP', 'vSAMP', 'vSAMP', 'vSAMP', '2017-05-26 15:08:24', 'ff2ae348-214a-11e7-93ae-92361f002671', null, "test_configuration_restconf", "1.0.0");
50 insert into vf_module(model_uuid, model_invariant_uuid, model_version, model_name, description, is_base, heat_template_artifact_uuid, vol_heat_template_artifact_uuid, creation_timestamp, vnf_resource_model_uuid) values
52 ('20c4431c-246d-11e7-93ae-92361f002671', '78ca26d0-246d-11e7-93ae-92361f002671', '2', 'vSAMP10aDEV::base::module-0', 'vSAMP10a DEV Base', '1', 'ff874603-4222-11e7-9252-005056850d2e', null, '2016-09-14 18:19:56', 'ff2ae348-214a-11e7-93ae-92361f002671'),
53 ('066de97e-253e-11e7-93ae-92361f002671', '64efd51a-2544-11e7-93ae-92361f002671', '2', 'vSAMP10aDEV::PCM::module-1', 'vSAMP10a DEV PCM', '0', 'ff87482f-4222-11e7-9252-005056850d2e', null, '2016-09-14 18:19:56', 'ff2ae348-214a-11e7-93ae-92361f002671');
56 insert into vf_module_customization(model_customization_uuid, label, initial_count, min_instances, max_instances, availability_zone_count, heat_environment_artifact_uuid, vol_environment_artifact_uuid, creation_timestamp, vf_module_model_uuid) values
57 ('cb82ffd8-252a-11e7-93ae-92361f002671', 'base', '1', '0', '0', '0', 'fefb1601-4222-11e7-9252-005056850d2e', null, '2017-05-26 15:08:23', '20c4431c-246d-11e7-93ae-92361f002671'),
58 ('b4ea86b4-253f-11e7-93ae-92361f002671', 'PCM', '0', '0', '0', '0', 'fefb1751-4333-11e7-9252-005056850d2e', null, '2017-05-26 15:08:23', '066de97e-253e-11e7-93ae-92361f002671');
61 insert into vnf_res_custom_to_vf_module_custom(vnf_resource_cust_model_customization_uuid, vf_module_cust_model_customization_uuid, creation_timestamp) values
62 ('68dc9a92-214c-11e7-93ae-92361f002671', 'cb82ffd8-252a-11e7-93ae-92361f002671', '2017-05-26 15:08:24'),
63 ('68dc9a92-214c-11e7-93ae-92361f002671', 'b4ea86b4-253f-11e7-93ae-92361f002671', '2017-05-26 15:08:24');
65 insert into allotted_resource(model_uuid, model_invariant_uuid, model_version, model_name, tosca_node_type, subcategory, description, creation_timestamp) values
66 ('f6b7d4c6-e8a4-46e2-81bc-31cad5072842', 'b7a1b78e-6b6b-4b36-9698-8c9530da14af', '1.0', 'Tunnel_Xconn', '', '', '', '2017-05-26 15:08:24');
68 insert into allotted_resource_customization(model_customization_uuid, model_instance_name, providing_service_model_invariant_uuid, target_network_role, nf_type, nf_role, nf_function, nf_naming_code, min_instances, max_instances, ar_model_uuid, creation_timestamp) values
69 ('367a8ba9-057a-4506-b106-fbae818597c6', 'Sec_Tunnel_Xconn 11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'f6b7d4c6-e8a4-46e2-81bc-31cad5072842', TIMESTAMP '2017-01-20 16:14:20.0');
72 insert into temp_network_heat_template_lookup(network_resource_model_name, heat_template_artifact_uuid, aic_version_min, aic_version_max) values
73 ('CONTRAIL30_GNDIRECT', 'ff874603-4222-11e7-9252-005056850d2e', '3', '3');
75 insert into network_resource(model_uuid, model_name, model_invariant_uuid, description, heat_template_artifact_uuid, neutron_network_type, model_version, tosca_node_type, aic_version_min, aic_version_max, orchestration_mode, creation_timestamp) values
76 ('10b36f65-f4e6-4be6-ae49-9596dc1c47fc', 'CONTRAIL30_GNDIRECT', 'ce4ff476-9641-4e60-b4d5-b4abbec1271d', 'Contrail 30 GNDIRECT NW', 'aa874603-4222-11e7-9252-005056850d2e', 'BASIC', '1.0', '', '3.0', '', 'HEAT', '2017-01-17 20:35:05');
77 insert into network_resource(model_uuid, model_name, model_invariant_uuid, description, heat_template_artifact_uuid, neutron_network_type, model_version, tosca_node_type, aic_version_min, aic_version_max, orchestration_mode, creation_timestamp) values
78 ('10b36f65-f4e6-4be6-ae49-9596dc1c47fy', 'CONTRAIL30_GNDIRECT', 'ce4ff476-9641-4e60-b4d5-b4abbec1271d', 'Contrail 30 GNDIRECT NW', 'aa874603-4222-11e7-9252-005056850d2e', 'BASIC', '2.0', '', '3.0', '', 'HEAT', '2017-01-17 20:35:05');
80 insert into network_resource(model_uuid, model_name, model_invariant_uuid, description, heat_template_artifact_uuid, neutron_network_type, model_version, tosca_node_type, aic_version_min, aic_version_max, orchestration_mode, creation_timestamp) values
81 ('10b36f65-f4e6-4be6-ae49-9596dc1c47fx', 'CONTRAIL30_GNDIRECT', 'ce4ff476-9641-4e60-b4d5-b4abbec1271d', 'Contrail 30 GNDIRECT NW', 'aa874603-4222-11e7-9252-005056850d2e', 'BASIC', '3.0', '', '3.0', '', 'HEAT', '2017-01-17 20:35:05');
83 insert into network_resource(model_uuid, model_name, model_invariant_uuid, description, heat_template_artifact_uuid, neutron_network_type, model_version, tosca_node_type, aic_version_min, aic_version_max, orchestration_mode, creation_timestamp) values
84 ('10b36f65-f4e6-4be6-ae49-9596dc1c47fz', 'CONTRAIL30_GNDIRECT', 'ce4ff476-9641-4e60-b4d5-b4abbec1271d', 'Contrail 30 GNDIRECT NW', 'aa874603-4222-11e7-9252-005056850d2e', 'BASIC', '3.1', '', '3.0', '', 'HEAT', '2017-01-17 20:35:05');
87 insert into network_resource_customization(model_customization_uuid, model_instance_name, network_technology, network_type, network_role, network_scope, creation_timestamp, network_resource_model_uuid) values
88 ('3bdbb104-476c-483e-9f8b-c095b3d308ac', 'CONTRAIL30_GNDIRECT 9', '', '', '', '', '2017-04-19 14:28:32', '10b36f65-f4e6-4be6-ae49-9596dc1c47fc');
90 insert into instance_group(model_uuid, model_name, model_invariant_uuid, model_version, tosca_node_type, role, object_type, cr_model_uuid, instance_group_type) values
91 ('21e43a7c-d823-4f5b-a427-5235f63035ff', 'dror_cr_network_resource_1806..NetworkCollection..0', '81c94263-c01e-4046-b0c7-51878d658eab', '1', 'org.openecomp.groups.NetworkCollection', 'SUB_INTERFACE', 'L3_NETWORK', '5e3fca45-e2d8-4987-bef1-016d9bda1a8c', 'L3_NETWORK');
93 insert into collection_resource(model_uuid, model_name, model_invariant_uuid, model_version, tosca_node_type, description) values
94 ('5e3fca45-e2d8-4987-bef1-016d9bda1a8c', 'Dror_CR_Network_Resource_1806', 'fe243154-ac18-405f-94c2-ef629d26b8bb', '2.0', 'org.openecomp.resource.cr.DrorCrNetworkResource1806', 'Creation date: 07/25/18');
96 insert into collection_resource_customization(model_customization_uuid, model_instance_name, role, object_type, function, collection_resource_type, cr_model_uuid) values
97 ('c51096a4-6081-41f4-a540-3ed015a8064a', 'Dror_CR_Network_Resource_1806', 'Dror2', 'NetworkCollection', 'Dror1', 'Dror3', '5e3fca45-e2d8-4987-bef1-016d9bda1a8c');
99 insert into collection_network_resource_customization(model_customization_uuid, model_instance_name, network_technology, network_type, network_role, network_scope, network_resource_model_uuid, instance_group_model_uuid, crc_model_customization_uuid) values
100 ('3bdbb104-ffff-483e-9f8b-c095b3d30844', 'ExtVL 0', 'CONTRAIL', 'L3-NETWORK', '', '', '10b36f65-f4e6-4be6-ae49-9596dc1c47fz', '21e43a7c-d823-4f5b-a427-5235f63035ff', 'c51096a4-6081-41f4-a540-3ed015a8064a'),
101 ('3bdbb104-ffff-483e-9f8b-c095b3d3068c', 'ExtVL 01', 'CONTRAIL', 'L3-NETWORK', '', '', '10b36f65-f4e6-4be6-ae49-9596dc1c47fz', '21e43a7c-d823-4f5b-a427-5235f63035ff', 'c51096a4-6081-41f4-a540-3ed015a8064a');
103 insert into vnf_resource(orchestration_mode, description, creation_timestamp, model_uuid, aic_version_min, aic_version_max, model_invariant_uuid, model_version, model_name, tosca_node_type, heat_template_artifact_uuid) values
104 ('HEAT', '1607 vSAMP10a - inherent network', '2017-04-14 21:46:28', 'ff2ae348-214a-11e7-93ae-92361f002672', '', '', '2fff5b20-214b-11e7-93ae-92361f002671', '2.0', 'vSAMP10a', 'VF', null);
107 insert into vnf_resource_customization(model_customization_uuid, model_instance_name, min_instances, max_instances, availability_zone_max_count, nf_type, nf_role, nf_function, nf_naming_code, creation_timestamp, vnf_resource_model_uuid, multi_stage_design) values
108 ('68dc9a92-214c-11e7-93ae-92361f002672', 'vSAMP10a 2', '0', '0', '0', 'vSAMP', 'vSAMP', 'vSAMP', 'vSAMP', '2017-05-26 15:08:24', 'ff2ae348-214a-11e7-93ae-92361f002672', null);
114 insert into vf_module(model_uuid, model_invariant_uuid, model_version, model_name, description, is_base, heat_template_artifact_uuid, vol_heat_template_artifact_uuid, creation_timestamp, vnf_resource_model_uuid) values
116 ('20c4431c-246d-11e7-93ae-92361f002672', '78ca26d0-246d-11e7-93ae-92361f002671', '2', 'vSAMP10aDEV::base::module-0', 'vSAMP10a DEV Base', '1', 'ff874603-4222-11e7-9252-005056850d2e', null, '2016-09-14 18:19:56', 'ff2ae348-214a-11e7-93ae-92361f002671'),
117 ('066de97e-253e-11e7-93ae-92361f002672', '64efd51a-2544-11e7-93ae-92361f002671', '2', 'vSAMP10aDEV::PCM::module-1', 'vSAMP10a DEV PCM', '0', 'ff87482f-4222-11e7-9252-005056850d2e', null, '2016-09-14 18:19:56', 'ff2ae348-214a-11e7-93ae-92361f002671'),
118 ('066de97e-253e-11e7-93ae-92361f002673', '64efd51a-2544-11e7-93ae-92361f002671', '3', 'vSAMP10aDEV::PCM::module-1', 'vSAMP10a DEV PCM', '0', 'ff87482f-4222-11e7-9252-005056850d2e', null, '2016-09-14 18:19:54', 'ff2ae348-214a-11e7-93ae-92361f002671'),
119 ('066de97e-253e-11e7-93ae-92361f002674', '64efd51a-2544-11e7-93ae-92361f002671', '3.1', 'vSAMP10aDEV::PCM::module-1', 'vSAMP10a DEV PCM', '0', 'ff87482f-4222-11e7-9252-005056850d2e', null, '2016-09-14 18:19:56', 'ff2ae348-214a-11e7-93ae-92361f002671'),
120 ('066de97e-253e-11e7-93ae-92361f002675', '64efd51a-2544-11e7-93ae-92361f002671', '3.1.1', 'vSAMP10aDEV::PCM::module-1', 'vSAMP10a DEV PCM', '0', 'ff87482f-4222-11e7-9252-005056850d2e', null, '2016-09-14 18:19:56', 'ff2ae348-214a-11e7-93ae-92361f002671');
124 insert into vf_module_customization(model_customization_uuid, label, initial_count, min_instances, max_instances, availability_zone_count, heat_environment_artifact_uuid, vol_environment_artifact_uuid, creation_timestamp, vf_module_model_uuid) values
125 ('cb82ffd8-252a-11e7-93ae-92361f002672', 'base', '1', '0', '0', '0', 'fefb1601-4222-11e7-9252-005056850d2e', null, '2017-05-26 15:08:23', '20c4431c-246d-11e7-93ae-92361f002672'),
126 ('b4ea86b4-253f-11e7-93ae-92361f002672', 'PCM', '0', '0', '0', '0', 'fefb1751-4333-11e7-9252-005056850d2e', null, '2017-05-26 15:08:23', '066de97e-253e-11e7-93ae-92361f002672');
129 insert into vnf_res_custom_to_vf_module_custom(vnf_resource_cust_model_customization_uuid, vf_module_cust_model_customization_uuid, creation_timestamp) values
130 ('68dc9a92-214c-11e7-93ae-92361f002672', 'cb82ffd8-252a-11e7-93ae-92361f002672', '2017-05-26 15:08:24'),
131 ('68dc9a92-214c-11e7-93ae-92361f002672', 'b4ea86b4-253f-11e7-93ae-92361f002672', '2017-05-26 15:08:24');
135 insert into vf_module_to_heat_files(vf_module_model_uuid, heat_files_artifact_uuid) values
136 ('20c4431c-246d-11e7-93ae-92361f002671', '00535bdd-0878-4478-b95a-c575c742bfb0'),
137 ('066de97e-253e-11e7-93ae-92361f002671', '00535bdd-0878-4478-b95a-c575c742bfb0');
140 insert into network_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
141 ('5df8b6de-2083-11e7-93ae-92361f002671', '3bdbb104-476c-483e-9f8b-c095b3d308ac'),
142 ('5df8b6de-2083-11e7-93ae-92361f002672', '3bdbb104-476c-483e-9f8b-c095b3d308ac');
145 insert into vnf_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
146 ('5df8b6de-2083-11e7-93ae-92361f002671', '68dc9a92-214c-11e7-93ae-92361f002671'),
147 ('5df8b6de-2083-11e7-93ae-92361f002672', '68dc9a92-214c-11e7-93ae-92361f002672');
149 insert into allotted_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
150 ('5df8b6de-2083-11e7-93ae-92361f002671', '367a8ba9-057a-4506-b106-fbae818597c6' ),
151 ('5df8b6de-2083-11e7-93ae-92361f002672', '367a8ba9-057a-4506-b106-fbae818597c6');
155 insert into vnf_recipe(id, nf_role, action, service_type, version_str, description, orchestration_uri, vnf_param_xsd, recipe_timeout, creation_timestamp, vf_module_id) values
156 ('61', '*', 'CREATE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/workflow/services/CreateGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
157 ('63', '*', 'DELETE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/async/services/deleteGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
158 ('65', '*', 'UPDATE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/workflow/services/updateGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
159 ('67', '*', 'CREATE_VF_MODULE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/async/services/CreateVfModule', '', '180', '2016-06-03 10:14:10', '*'),
160 ('69', '*', 'DELETE_VF_MODULE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/async/services/DeleteVfModule', '', '180', '2016-06-03 10:14:10', '*'),
161 ('71', '*', 'UPDATE_VF_MODULE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/async/services/UpdateVfModule', '', '180', '2016-06-03 10:14:10', '*'),
162 ('77', 'VID_DEFAULT', 'createInstance', '', '1', 'VID_DEFAULT recipe to create VNF if no custom BPMN flow is found', '/mso/async/services/CreateVnfInfra', '', '180', '2016-09-14 19:18:20', ''),
163 ('78', 'VID_DEFAULT', 'deleteInstance', '', '1', 'VID_DEFAULT recipe to delete VNF if no custom BPMN flow is found', '/mso/async/services/DeleteVnfInfra', '', '180', '2016-09-14 19:18:20', ''),
164 ('81', 'VID_DEFAULT', 'updateInstance', '', '1', 'VID_DEFAULT update', '/mso/async/services/UpdateVnfInfra', '', '180', '2017-07-28 18:19:39', ''),
165 ('85', 'VID_DEFAULT', 'replaceInstance', '', '1', 'VID_DEFAULT replace', '/mso/async/services/ReplaceVnfInfra', '', '180', '2017-07-28 18:19:45', ''),
166 ('10000', 'VID_DEFAULT', 'inPlaceSoftwareUpdate', '', '1', 'VID_DEFAULT inPlaceSoftwareUpdate', '/mso/async/services/VnfInPlaceUpdate', '', '180', '2017-10-25 18:19:45', ''),
167 ('10001', 'VID_DEFAULT', 'applyUpdatedConfig', '', '1', 'VID_DEFAULT applyUpdatedConfig', '/mso/async/services/VnfConfigUpdate', '', '180', '2017-10-25 18:19:45', '');
170 insert into vnf_components(vnf_id, component_type, heat_template_id, heat_environment_id, creation_timestamp) values
171 ('13961', 'VOLUME', '13843', '13961', '2016-05-19 20:22:02');
173 insert into vnf_components_recipe(id, vnf_type, vnf_component_type, action, service_type, version, description, orchestration_uri, vnf_component_param_xsd, recipe_timeout, creation_timestamp, vf_module_model_uuid) values
174 ('5', '*', 'VOLUME_GROUP', 'CREATE', '', '1', 'Recipe Match All for VF Modules if no custom flow exists', '/mso/async/services/createCinderVolumeV1', '', '180', '2016-06-03 10:15:11', ''),
175 ('7', '*', 'VOLUME_GROUP', 'DELETE', '', '1', 'Recipe Match All for VF Modules if no custom flow exists', '/mso/async/services/deleteCinderVolumeV1', '', '180', '2016-06-03 10:15:11', ''),
176 ('9', '*', 'VOLUME_GROUP', 'UPDATE', '', '1', 'Recipe Match All for VF Modules if no custom flow exists', '/mso/async/services/updateCinderVolumeV1', '', '180', '2016-06-03 10:15:11', ''),
177 ('13', '', 'VOLUME_GROUP', 'DELETE_VF_MODULE_VOL', '', '1', 'Recipe Match All for VF Modules if no custom flow exists', '/mso/async/services/DeleteVfModuleVolume', '', '180', '2016-06-03 10:15:11', '*'),
178 ('15', '', 'VOLUME_GROUP', 'UPDATE_VF_MODULE_VOL', '', '1', 'Recipe Match All for VF Modules if no custom flow exists', '/mso/async/services/UpdateVfModuleVolume', '', '180', '2016-06-03 10:15:11', '*'),
179 ('16', '', 'volumeGroup', 'createInstance', '', '1', 'VID_DEFAULT recipe to create volume-group if no custom BPMN flow is found', '/mso/async/services/CreateVfModuleVolumeInfraV1', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'),
180 ('17', '', 'volumeGroup', 'deleteInstance', '', '1', 'VID_DEFAULT recipe to delete volume-group if no custom BPMN flow is found', '/mso/async/services/DeleteVfModuleVolumeInfraV1', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'),
181 ('18', '', 'volumeGroup', 'updateInstance', '', '1', 'VID_DEFAULT recipe to update volume-group if no custom BPMN flow is found', '/mso/async/services/UpdateVfModuleVolumeInfraV1', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'),
182 ('19', '', 'vfModule', 'createInstance', '', '1', 'VID_DEFAULT recipe to create vf-module if no custom BPMN flow is found', '/mso/async/services/CreateVfModuleInfra', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'),
183 ('20', '', 'vfModule', 'deleteInstance', '', '1', 'VID_DEFAULT recipe to delete vf-module if no custom BPMN flow is found', '/mso/async/services/DeleteVfModuleInfra', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'),
184 ('21', '', 'vfModule', 'updateInstance', '', '1', 'VID_DEFAULT recipe to update vf-module if no custom BPMN flow is found', '/mso/async/services/UpdateVfModuleInfra', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'),
185 ('25', '', 'vfModule', 'replaceInstance', '', '1', 'VID_DEFAULT vfModule replace', '/mso/async/services/ReplaceVfModuleInfra', '', '180', '2017-07-28 18:25:06', 'VID_DEFAULT');
187 insert into network_recipe(id, model_name, action, description, orchestration_uri, network_param_xsd, recipe_timeout, service_type, creation_timestamp, version_str) values
188 ('1', 'CONTRAIL_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
189 ('2', 'CONTRAIL_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
190 ('3', 'CONTRAIL_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
191 ('4', 'CONTRAIL_SHARED', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
192 ('5', 'CONTRAIL_SHARED', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
193 ('6', 'CONTRAIL_SHARED', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
194 ('7', 'CONTRAIL_EXTERNAL', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
195 ('8', 'CONTRAIL_EXTERNAL', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
196 ('9', 'CONTRAIL_EXTERNAL', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
197 ('10', 'CONTRAIL30_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
198 ('11', 'CONTRAIL30_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
199 ('12', 'CONTRAIL30_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
200 ('13', 'NEUTRON_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-06-01 19:54:51', '1'),
201 ('17', 'VID_DEFAULT', 'createInstance', 'VID_DEFAULT recipe to create network if no custom BPMN flow is found', '/mso/async/services/CreateNetworkInstance', '', '180', '', '2016-09-14 19:18:20', '1.0'),
202 ('18', 'VID_DEFAULT', 'updateInstance', 'VID_DEFAULT recipe to update network if no custom BPMN flow is found', '/mso/async/services/UpdateNetworkInstance', '', '180', '', '2016-09-14 19:18:20', '1.0'),
203 ('19', 'VID_DEFAULT', 'deleteInstance', 'VID_DEFAULT recipe to delete network if no custom BPMN flow is found', '/mso/async/services/DeleteNetworkInstance', '', '180', '', '2016-09-14 19:18:20', '1.0'),
204 ('124', 'CONTRAIL30_MPSCE', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
205 ('126', 'CONTRAIL30_MPSCE', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
206 ('128', 'CONTRAIL30_MPSCE', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
207 ('141', 'CONTRAIL30_L2NODHCP', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
208 ('144', 'CONTRAIL30_L2NODHCP', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
209 ('147', 'CONTRAIL30_L2NODHCP', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
210 ('169', 'CONTRAIL30_GNDIRECT', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
211 ('172', 'CONTRAIL30_GNDIRECT', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
212 ('175', 'CONTRAIL30_GNDIRECT', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
213 ('176', 'NEUTRON_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1'),
214 ('177', 'NEUTRON_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1');
216 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, IS_TOPLEVELFLOW, MIN_API_VERSION, MAX_API_VERSION) VALUES
217 ('Service-Create', 'createInstance', 'Service', true, true, '7','7'),
218 ('Service-Delete', 'deleteInstance', 'Service', true, true, '7','7'),
219 ('Service-Macro-Assign', 'assignInstance', 'Service', false, true, '7','7'),
220 ('Service-Macro-Activate', 'activateInstance', 'Service', false, true, '7','7'),
221 ('Service-Macro-Unassign', 'unassignInstance', 'Service', false, true, '7','7'),
222 ('Service-Macro-Create', 'createInstance', 'Service', false, true, '7','7'),
223 ('Service-Macro-Delete', 'deleteInstance', 'Service', false, true, '7','7'),
224 ('Network-Create', 'createInstance', 'Network', true, true, '7','7'),
225 ('Network-Delete', 'deleteInstance', 'Network', true, true, '7','7'),
226 ('VNF-Macro-Recreate', 'replaceInstance', 'Vnf', false, false, '7','7'),
227 ('VNF-Macro-Replace', 'internalReplace', 'Vnf', false, false, '7','7'),
228 ('VNF-Create', 'createInstance', 'Vnf', true, true, '7', '7'),
229 ('VNF-Delete', 'deleteInstance', 'Vnf', true, true, '7', '7'),
230 ('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true, true, '7','7'),
231 ('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true, true, '7','7'),
232 ('VFModule-Create', 'createInstance', 'VfModule', true, true, '7','7'),
233 ('VFModule-Delete', 'deleteInstance', 'VfModule', true, true, '7','7'),
234 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, true, '7','7'),
235 ('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false, true, '7','7'),
236 ('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false, true, '7','7');
238 INSERT INTO building_block_detail (BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
240 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
241 ('AssignVnfBB', 'VNF', 'ASSIGN'),
242 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
243 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
244 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
245 ('AssignNetwork1802BB', 'NETWORK', 'ASSIGN'),
246 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
247 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
248 ('UnassignVolumeGroupBB', 'VOLUME_GROUP', 'UNASSIGN'),
249 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
250 ('UnassignNetwork1802BB', 'NETWORK', 'UNASSIGN'),
251 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
252 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
253 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
254 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
255 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
256 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
257 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
258 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
259 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
260 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
261 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
262 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
263 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGE_MODEL'),
264 ('ChangeModelVnfBB', 'VNF', 'CHANGE_MODEL'),
265 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGE_MODEL'),
266 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
267 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
268 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
269 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
270 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
271 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
272 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
273 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
274 ('AssignAndActivateVpnBondingLinksBB', 'CUSTOM', 'CUSTOM'),
275 ('AvpnAssignServiceInstanceBB', 'CUSTOM', 'CUSTOM'),
276 ('CreateCustomerVpnBindingBB', 'CUSTOM', 'CUSTOM'),
277 ('SniroHoming', 'CUSTOM', 'CUSTOM'),
278 ('DeactivateAndUnassignVpnBondingLinksBB', 'CUSTOM', 'CUSTOM'),
279 ('DeactivateNetworkCollectionBB', 'CUSTOM', 'CUSTOM'),
280 ('AAICheckVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
281 ('AAISetVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
282 ('AAIUnsetVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
283 ('SDNOVnfHealthCheckBB', 'CUSTOM', 'CUSTOM'),
284 ('VNF-Macro-Replace', 'CUSTOM', 'CUSTOM'),
285 ('HomingBB', 'CUSTOM', 'CUSTOM');
287 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
288 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')),
289 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')),
290 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete')),
291 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete')),
292 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
293 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
294 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
295 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
296 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
297 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
298 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
299 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
300 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
301 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
302 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
303 ('Service-Macro-Activate', '7', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
304 ('Service-Macro-Activate', '8', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
305 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
306 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
307 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
308 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
309 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
310 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
311 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
312 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
313 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
314 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
315 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
316 ('Service-Macro-Create', '7', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
317 ('Service-Macro-Create', '8', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
318 ('Service-Macro-Create', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
319 ('Service-Macro-Create', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
320 ('Service-Macro-Create', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
321 ('Service-Macro-Create', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
322 ('Service-Macro-Create', '13', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
323 ('Service-Macro-Create', '14', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
324 ('Service-Macro-Create', '15', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
325 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
326 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
327 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
328 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
329 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
330 ('Service-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
331 ('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
332 ('Service-Macro-Delete', '8', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
333 ('Service-Macro-Delete', '9', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
334 ('Service-Macro-Delete', '10', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
335 ('Service-Macro-Delete', '11', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
336 ('Service-Macro-Delete', '12', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
337 ('Service-Macro-Delete', '13', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
338 ('Service-Macro-Delete', '14', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
339 ('Network-Create', '1', 'AssignNetwork1802BB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
340 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
341 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
342 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
343 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
344 ('Network-Delete', '3', 'UnassignNetwork1802BB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
345 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create')),
346 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create')),
347 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete')),
348 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete')),
349 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
350 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
351 ('VNF-Macro-Recreate', '3', 'VNF-Macro-Replace', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
352 ('VNF-Macro-Recreate', '4', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
353 ('VNF-Macro-Recreate', '5', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
354 ('VNF-Macro-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
355 ('VNF-Macro-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
356 ('VNF-Macro-Replace', '3', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
357 ('VNF-Macro-Replace', '4', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
358 ('VNF-Macro-Replace', '5', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
359 ('VNF-Macro-Replace', '6', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
360 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
361 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
362 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
363 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
364 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
365 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
366 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
367 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
368 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
369 ('VFModule-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
370 ('VFModule-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
371 ('VFModule-Delete', '3', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
372 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete')),
373 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete')),
374 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
375 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
376 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
377 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
378 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
379 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
380 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
381 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
382 ('NetworkCollection-Macro-Delete', '4', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete'));
384 INSERT INTO orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
386 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
387 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
388 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
389 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
390 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
391 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
392 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
393 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
394 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
395 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
396 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
397 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
398 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
399 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
400 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
401 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
402 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
403 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
404 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
405 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
406 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
407 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
408 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
409 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
410 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
411 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
412 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
413 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
414 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
415 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
416 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
417 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
418 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
419 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
420 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
421 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
422 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
423 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
424 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
425 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
426 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
427 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
428 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
429 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
430 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
431 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
432 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
433 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
434 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
435 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
436 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
437 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
438 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
439 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
440 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
441 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
442 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
443 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
444 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
445 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
446 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
447 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
448 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
449 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
450 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
451 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
452 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
453 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
454 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
455 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
456 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
457 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
458 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
459 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
460 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
461 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
462 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
463 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
464 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
465 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
466 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
467 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
468 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
469 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
470 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
471 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
472 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
473 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
474 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
475 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
476 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
477 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
478 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
479 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
480 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
481 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
482 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
483 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
484 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
485 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
486 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
487 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
488 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
489 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
490 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
491 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
492 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
493 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
494 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
495 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
496 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
497 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
498 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
499 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
500 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
501 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
502 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
503 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
504 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
505 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
506 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
507 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
508 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
509 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
510 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
511 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
512 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
513 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
514 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
515 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
516 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
517 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
518 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
519 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
520 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
521 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
522 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
523 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
524 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
525 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
526 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
527 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
528 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
529 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
530 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
531 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
532 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
533 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
534 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
535 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
536 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
537 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
538 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
539 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
540 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
541 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
542 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
543 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
544 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
545 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
546 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
547 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
548 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
549 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
550 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
551 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
552 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
553 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
554 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
555 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
556 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
557 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
558 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
559 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
560 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
561 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
562 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
563 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
564 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
565 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
566 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
567 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
568 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
569 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
570 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
571 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
572 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
573 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
574 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
575 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
576 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
577 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
578 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
579 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
580 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
581 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
582 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
583 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
584 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
585 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
586 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
587 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
588 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
589 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
590 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
591 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
592 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
593 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
594 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
595 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
596 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
597 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
598 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
599 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
600 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
601 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
602 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
603 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
604 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
605 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
606 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
607 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
608 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
609 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
610 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
611 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
612 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
613 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
614 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
615 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
616 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
617 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
618 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
619 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
620 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
621 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
622 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
623 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
624 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
625 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
626 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
627 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
628 ('NETWORK', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
629 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
630 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
631 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
632 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
633 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
634 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
635 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
636 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
637 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
638 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
639 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
640 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
641 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
642 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
643 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
644 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
645 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
646 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
647 ('CUSTOM', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
648 ('CUSTOM', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
649 ('CUSTOM', 'CREATED', 'CUSTOM', 'CONTINUE'),
650 ('CUSTOM', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
651 ('CUSTOM', 'PENDING', 'CUSTOM', 'CONTINUE'),
652 ('CUSTOM', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
653 ('CUSTOM', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
654 ('CUSTOM', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
655 ('CUSTOM', 'PRECREATED', 'CUSTOM', 'CONTINUE');
657 INSERT INTO `cloudify_managers` (`ID`, `CLOUDIFY_URL`, `USERNAME`, `PASSWORD`, `VERSION`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('mtn13', 'http://localhost:28090/v2.0', 'm93945', '93937EA01B94A10A49279D4572B48369', NULL, 'MSO_USER', '2018-07-17 14:05:08', '2018-07-17 14:05:08');
659 INSERT INTO `identity_services` (`ID`, `IDENTITY_URL`, `MSO_ID`, `MSO_PASS`, `PROJECT_DOMAIN_NAME`, `USER_DOMAIN_NAME`, `ADMIN_TENANT`, `MEMBER_ROLE`, `TENANT_METADATA`, `IDENTITY_SERVER_TYPE`, `IDENTITY_AUTHENTICATION_TYPE`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('MTN13', 'http://localhost:28090/v2.0', 'm93945', '93937EA01B94A10A49279D4572B48369', NULL, NULL, 'admin', 'admin', 1, 'KEYSTONE', 'USERNAME_PASSWORD', 'MSO_USER', '2018-07-17 14:02:33', '2018-07-17 14:02:33');
661 INSERT INTO `cloud_sites` (`ID`, `REGION_ID`, `IDENTITY_SERVICE_ID`, `CLOUD_VERSION`, `CLLI`, `CLOUDIFY_ID`, `PLATFORM`, `ORCHESTRATOR`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('mtn13', 'mtn13', 'MTN13', '2.5', 'MDT13', 'mtn13', NULL, 'orchestrator', 'MSO_USER', '2018-07-17 14:06:28', '2018-07-17 14:06:28');
663 INSERT INTO `controller_selection_reference` (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`) VALUES
664 ('vLoadBalancerMS/vLoadBalancerMS 0', 'APPC', 'ConfigScaleOut'),
665 ('vLoadBalancerMS/vLoadBalancerMS 0', 'APPC', 'HealthCheck');
667 INSERT INTO `configuration`
669 `model_invariant_uuid`,
674 `creation_timestamp`)
675 VALUES ( 'c59a41ca-9b3b-11e8-98d0-529269fb1459',
676 '15881e64-9b3c-11e8-98d0-529269fb1459',
679 'testToscaModelType',
680 'testConfigurationDescription',
681 '2018-07-17 14:05:08' );
684 INSERT INTO `vnfc_customization`
685 (`model_customization_uuid`,
686 `model_instance_name`,
688 `model_invariant_uuid`,
693 `creation_timestamp`)
694 VALUES ( '9bcce658-9b37-11e8-98d0-529269fb1459',
695 'testModelInstanceName',
696 'b25735fe-9b37-11e8-98d0-529269fb1459',
697 'ba7e6ef0-9b37-11e8-98d0-529269fb1459',
701 'testVnfcCustomizationDescription',
702 '2018-07-17 14:05:08');
704 INSERT INTO `cvnfc_customization`
706 `model_customization_uuid`,
707 `model_instance_name`,
709 `model_invariant_uuid`,
716 `creation_timestamp`,
717 `vnf_resource_cust_model_customization_uuid`,
718 `vf_module_cust_model_customization_uuid`,
719 `vnfc_cust_model_customization_uuid`)
721 '9bcce658-9b37-11e8-98d0-529269fb1459',
722 'testModelInstanceName',
723 'b25735fe-9b37-11e8-98d0-529269fb1459',
724 'ba7e6ef0-9b37-11e8-98d0-529269fb1459',
728 'testCvnfcCustomzationDescription',
731 '2018-07-17 14:05:08',
732 '68dc9a92-214c-11e7-93ae-92361f002671',
733 'cb82ffd8-252a-11e7-93ae-92361f002671',
734 '9bcce658-9b37-11e8-98d0-529269fb1459');
736 INSERT INTO vnf_vfmodule_cvnfc_configuration_customization
738 model_customization_uuid,
739 CVNFC_CUSTOMIZATION_ID,
743 configuration_function,
746 configuration_model_uuid)
748 '7bcce658-9b37-11e8-98d0-529269fb1450',
750 'testModelInstanceName',
751 'testConfigurationType',
752 'testConfigurationRole',
753 'testConfigurationFunction',
755 '2018-07-17 14:05:08',
756 'c59a41ca-9b3b-11e8-98d0-529269fb1459');
758 insert into service(model_uuid, model_name, model_invariant_uuid, model_version, description, creation_timestamp, tosca_csar_artifact_uuid, service_type, service_role, environment_context, workload_context) values
759 ('5df8b6de-2083-11e7-93ae-92361f002676', 'PNF_routing_service', '9647dfc4-2083-11e7-93ae-92361f002676', '1.0', 'PNF service', '2019-03-08 12:00:29', null, 'NA', 'NA', 'Luna', 'Oxygen');
761 insert into pnf_resource(orchestration_mode, description, creation_timestamp, model_uuid, model_invariant_uuid, model_version, model_name, tosca_node_type) values
762 ('', 'PNF routing', '2019-03-08 12:00:28', 'ff2ae348-214a-11e7-93ae-92361f002680', '2fff5b20-214b-11e7-93ae-92361f002680', '1.0', 'PNF resource', null);
764 insert into pnf_resource_customization(model_customization_uuid, model_instance_name, nf_type, nf_role, nf_function, nf_naming_code, creation_timestamp, pnf_resource_model_uuid, multi_stage_design, cds_blueprint_name, cds_blueprint_version) values
765 ('68dc9a92-214c-11e7-93ae-92361f002680', 'PNF routing', 'routing', 'routing', 'routing', 'routing', '2019-03-08 12:00:29', 'ff2ae348-214a-11e7-93ae-92361f002680', null, "test_configuration_restconf", "1.0.0");
767 insert into pnf_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
768 ('5df8b6de-2083-11e7-93ae-92361f002676', '68dc9a92-214c-11e7-93ae-92361f002680');