Gitiles
Code Review Sign In
gerrit.nordix.org / onap / so / add0df04cc24deae1f16a215dffa32393ed586ca / . / mso-catalog-db / src / test / resources / data.sql
blob: 9da6d13e49ffb44b97877c33835e18d1af3f16cf [file] [log] [blame]
Benjamin, Max (mb388a)5a6a6de2018-07-30 15:56:09 -0400[diff] [blame]1
2insert 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');
4
5
6insert 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');
8
9
10insert 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');
12
13insert 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');
15
16insert 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');
18
19
20insert 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');
22insert 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');
24
25
26insert 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');
28
29insert 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');
33
34
35insert 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', '');
39
40insert 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');
43
44insert 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);
46
47insert 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
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);
49
50
51insert 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
53('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'),
54('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');
55
56
57insert 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
58('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'),
59('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');
60
61
62insert into vnf_res_custom_to_vf_module_custom(vnf_resource_cust_model_customization_uuid, vf_module_cust_model_customization_uuid, creation_timestamp) values
63('68dc9a92-214c-11e7-93ae-92361f002671', 'cb82ffd8-252a-11e7-93ae-92361f002671', '2017-05-26 15:08:24'),
64('68dc9a92-214c-11e7-93ae-92361f002671', 'b4ea86b4-253f-11e7-93ae-92361f002671', '2017-05-26 15:08:24');
65
66insert into allotted_resource(model_uuid, model_invariant_uuid, model_version, model_name, tosca_node_type, subcategory, description, creation_timestamp) values
67('f6b7d4c6-e8a4-46e2-81bc-31cad5072842', 'b7a1b78e-6b6b-4b36-9698-8c9530da14af', '1.0', 'Tunnel_Xconn', '', '', '', '2017-05-26 15:08:24');
68
69insert 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
70('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');
71
72
73insert into temp_network_heat_template_lookup(network_resource_model_name, heat_template_artifact_uuid, aic_version_min, aic_version_max) values
74('CONTRAIL30_GNDIRECT', 'ff874603-4222-11e7-9252-005056850d2e', '3', '3');
75
76insert 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
77('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');
78insert 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
79('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
81insert 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
82('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
84insert 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
85('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');
86
87
88insert 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
89('3bdbb104-476c-483e-9f8b-c095b3d308ac', 'CONTRAIL30_GNDIRECT 9', '', '', '', '', '2017-04-19 14:28:32', '10b36f65-f4e6-4be6-ae49-9596dc1c47fc');
90
91insert 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
92('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);
93
94
95insert 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
96('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);
97
98
99
100
101
102insert 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
103
104('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'),
105('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'),
106('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'),
107('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'),
108('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');
109
110
111
112insert 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
113('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'),
114('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');
115
116
117insert into vnf_res_custom_to_vf_module_custom(vnf_resource_cust_model_customization_uuid, vf_module_cust_model_customization_uuid, creation_timestamp) values
118('68dc9a92-214c-11e7-93ae-92361f002672', 'cb82ffd8-252a-11e7-93ae-92361f002672', '2017-05-26 15:08:24'),
119('68dc9a92-214c-11e7-93ae-92361f002672', 'b4ea86b4-253f-11e7-93ae-92361f002672', '2017-05-26 15:08:24');
120
121
122
123insert into vf_module_to_heat_files(vf_module_model_uuid, heat_files_artifact_uuid) values
124('20c4431c-246d-11e7-93ae-92361f002671', '00535bdd-0878-4478-b95a-c575c742bfb0'),
125('066de97e-253e-11e7-93ae-92361f002671', '00535bdd-0878-4478-b95a-c575c742bfb0');
126
127
128insert into network_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
129('5df8b6de-2083-11e7-93ae-92361f002671', '3bdbb104-476c-483e-9f8b-c095b3d308ac'),
130('5df8b6de-2083-11e7-93ae-92361f002672', '3bdbb104-476c-483e-9f8b-c095b3d308ac');
131
132
133insert into vnf_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
134('5df8b6de-2083-11e7-93ae-92361f002671', '68dc9a92-214c-11e7-93ae-92361f002671'),
135('5df8b6de-2083-11e7-93ae-92361f002672', '68dc9a92-214c-11e7-93ae-92361f002672');
136
137insert into allotted_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
138('5df8b6de-2083-11e7-93ae-92361f002671', '367a8ba9-057a-4506-b106-fbae818597c6' ),
139('5df8b6de-2083-11e7-93ae-92361f002672', '367a8ba9-057a-4506-b106-fbae818597c6');
140
141
142
143insert 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
144('61', '*', 'CREATE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/workflow/services/CreateGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
145('63', '*', 'DELETE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/async/services/deleteGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
146('65', '*', 'UPDATE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/workflow/services/updateGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
147('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', '*'),
148('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', '*'),
149('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', '*'),
150('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', ''),
151('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', ''),
152('81', 'VID_DEFAULT', 'updateInstance', '', '1', 'VID_DEFAULT update', '/mso/async/services/UpdateVnfInfra', '', '180', '2017-07-28 18:19:39', ''),
153('85', 'VID_DEFAULT', 'replaceInstance', '', '1', 'VID_DEFAULT replace', '/mso/async/services/ReplaceVnfInfra', '', '180', '2017-07-28 18:19:45', ''),
154('10000', 'VID_DEFAULT', 'inPlaceSoftwareUpdate', '', '1', 'VID_DEFAULT inPlaceSoftwareUpdate', '/mso/async/services/VnfInPlaceUpdate', '', '180', '2017-10-25 18:19:45', ''),
155('10001', 'VID_DEFAULT', 'applyUpdatedConfig', '', '1', 'VID_DEFAULT applyUpdatedConfig', '/mso/async/services/VnfConfigUpdate', '', '180', '2017-10-25 18:19:45', '');
156
157
158insert into vnf_components(vnf_id, component_type, heat_template_id, heat_environment_id, creation_timestamp) values
159('13961', 'VOLUME', '13843', '13961', '2016-05-19 20:22:02');
160
161insert 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
162('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', ''),
163('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', ''),
164('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', ''),
165('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', '*'),
166('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', '*'),
167('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'),
168('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'),
169('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'),
170('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'),
171('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'),
172('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'),
173('25', '', 'vfModule', 'replaceInstance', '', '1', 'VID_DEFAULT vfModule replace', '/mso/async/services/ReplaceVfModuleInfra', '', '180', '2017-07-28 18:25:06', 'VID_DEFAULT');
174
175insert into network_recipe(id, model_name, action, description, orchestration_uri, network_param_xsd, recipe_timeout, service_type, creation_timestamp, version_str) values
176('1', 'CONTRAIL_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
177('2', 'CONTRAIL_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
178('3', 'CONTRAIL_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
179('4', 'CONTRAIL_SHARED', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
180('5', 'CONTRAIL_SHARED', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
181('6', 'CONTRAIL_SHARED', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
182('7', 'CONTRAIL_EXTERNAL', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
183('8', 'CONTRAIL_EXTERNAL', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
184('9', 'CONTRAIL_EXTERNAL', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
185('10', 'CONTRAIL30_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
186('11', 'CONTRAIL30_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
187('12', 'CONTRAIL30_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
188('13', 'NEUTRON_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-06-01 19:54:51', '1'),
189('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'),
190('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'),
191('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'),
192('124', 'CONTRAIL30_MPSCE', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
193('126', 'CONTRAIL30_MPSCE', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
194('128', 'CONTRAIL30_MPSCE', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
195('141', 'CONTRAIL30_L2NODHCP', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
196('144', 'CONTRAIL30_L2NODHCP', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
197('147', 'CONTRAIL30_L2NODHCP', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
198('169', 'CONTRAIL30_GNDIRECT', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
199('172', 'CONTRAIL30_GNDIRECT', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
200('175', 'CONTRAIL30_GNDIRECT', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
201('176', 'NEUTRON_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1'),
202('177', 'NEUTRON_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1');
203
204INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, IS_TOPLEVELFLOW, MIN_API_VERSION, MAX_API_VERSION) VALUES
205('Service-Create', 'createInstance', 'Service', true, true, '7','7'),
206('Service-Delete', 'deleteInstance', 'Service', true, true, '7','7'),
207('Service-Macro-Assign', 'assignInstance', 'Service', false, true, '7','7'),
208('Service-Macro-Activate', 'activateInstance', 'Service', false, true, '7','7'),
209('Service-Macro-Unassign', 'unassignInstance', 'Service', false, true, '7','7'),
210('Service-Macro-Create', 'createInstance', 'Service', false, true, '7','7'),
211('Service-Macro-Delete', 'deleteInstance', 'Service', false, true, '7','7'),
212('Network-Create', 'createInstance', 'Network', true, true, '7','7'),
213('Network-Delete', 'deleteInstance', 'Network', true, true, '7','7'),
214('VNF-Macro-Recreate', 'replaceInstance', 'Vnf', false, false, '7','7'),
215('VNF-Macro-Replace', 'internalReplace', 'Vnf', false, false, '7','7'),
216('VNF-Create', 'createInstance', 'Vnf', true, true, '7', '7'),
217('VNF-Delete', 'deleteInstance', 'Vnf', true, true, '7', '7'),
218('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true, true, '7','7'),
219('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true, true, '7','7'),
220('VFModule-Create', 'createInstance', 'VfModule', true, true, '7','7'),
221('VFModule-Delete', 'deleteInstance', 'VfModule', true, true, '7','7'),
222('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, true, '7','7'),
223('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false, true, '7','7'),
224('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false, true, '7','7');
225
226INSERT INTO building_block_detail (BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
227VALUES
228('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
229('AssignVnfBB', 'VNF', 'ASSIGN'),
230('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
231('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
232('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
233('AssignNetwork1802BB', 'NETWORK', 'ASSIGN'),
234('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
235('UnassignVnfBB', 'VNF', 'UNASSIGN'),
236('UnassignVolumeGroupBB', 'VOLUME_GROUP', 'UNASSIGN'),
237('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
238('UnassignNetwork1802BB', 'NETWORK', 'UNASSIGN'),
239('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
240('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
241('ActivateVnfBB', 'VNF', 'ACTIVATE'),
242('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
243('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
244('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
245('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
246('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
247('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
248('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
249('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
250('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
251('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGE_MODEL'),
252('ChangeModelVnfBB', 'VNF', 'CHANGE_MODEL'),
253('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGE_MODEL'),
254('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
255('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
256('CreateNetworkBB', 'NETWORK', 'CREATE'),
257('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
258('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
259('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
260('DeleteNetworkBB', 'NETWORK', 'DELETE'),
261('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
262('AssignAndActivateVpnBondingLinksBB', 'CUSTOM', 'CUSTOM'),
263('AvpnAssignServiceInstanceBB', 'CUSTOM', 'CUSTOM'),
264('CreateCustomerVpnBindingBB', 'CUSTOM', 'CUSTOM'),
265('SniroHoming', 'CUSTOM', 'CUSTOM'),
266('DeactivateAndUnassignVpnBondingLinksBB', 'CUSTOM', 'CUSTOM'),
267('DeactivateNetworkCollectionBB', 'CUSTOM', 'CUSTOM'),
268('AAICheckVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
269('AAISetVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
270('AAIUnsetVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
271('SDNOVnfHealthCheckBB', 'CUSTOM', 'CUSTOM'),
272('VNF-Macro-Replace', 'CUSTOM', 'CUSTOM'),
273('HomingV2', 'CUSTOM', 'CUSTOM');
274
275INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
276('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')),
277('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')),
278('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete')),
279('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete')),
280('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
281('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
282('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
283('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
284('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
285('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
286('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
287('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
288('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
289('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
290('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
291('Service-Macro-Activate', '7', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
292('Service-Macro-Activate', '8', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
293('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
294('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
295('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
296('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
297('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
298('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
299('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
300('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
301('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
302('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
303('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
304('Service-Macro-Create', '7', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
305('Service-Macro-Create', '8', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
306('Service-Macro-Create', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
307('Service-Macro-Create', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
308('Service-Macro-Create', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
309('Service-Macro-Create', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
310('Service-Macro-Create', '13', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
311('Service-Macro-Create', '14', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
312('Service-Macro-Create', '15', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
313('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
314('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
315('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
316('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
317('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
318('Service-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
319('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
320('Service-Macro-Delete', '8', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
321('Service-Macro-Delete', '9', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
322('Service-Macro-Delete', '10', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
323('Service-Macro-Delete', '11', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
324('Service-Macro-Delete', '12', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
325('Service-Macro-Delete', '13', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
326('Service-Macro-Delete', '14', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
327('Network-Create', '1', 'AssignNetwork1802BB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
328('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
329('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
330('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
331('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
332('Network-Delete', '3', 'UnassignNetwork1802BB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
333('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create')),
334('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create')),
335('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete')),
336('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete')),
337('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
338('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
339('VNF-Macro-Recreate', '3', 'VNF-Macro-Replace', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
340('VNF-Macro-Recreate', '4', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
341('VNF-Macro-Recreate', '5', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
342('VNF-Macro-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
343('VNF-Macro-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
344('VNF-Macro-Replace', '3', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
345('VNF-Macro-Replace', '4', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
346('VNF-Macro-Replace', '5', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
347('VNF-Macro-Replace', '6', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
348('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
349('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
350('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
351('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
352('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
353('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
354('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
355('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
356('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
357('VFModule-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
358('VFModule-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
359('VFModule-Delete', '3', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
360('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete')),
361('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete')),
362('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
363('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
364('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
365('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
366('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
367('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
368('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
369('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
370('NetworkCollection-Macro-Delete', '4', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete'));
371
372INSERT INTO orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
373VALUES
374('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
375('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
376('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
377('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
378('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
379('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
380('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
381('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
382('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
383('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
384('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
385('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
386('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
387('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
388('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
389('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
390('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
391('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
392('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
393('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
394('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
395('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
396('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
397('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
398('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
399('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
400('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
401('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
402('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
403('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
404('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
405('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
406('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
407('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
408('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
409('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
410('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
411('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
412('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
413('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
414('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
415('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
416('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
417('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
418('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
419('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
420('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
421('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
422('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
423('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
424('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
425('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
426('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
427('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
428('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
429('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
430('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
431('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
432('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
433('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
434('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
435('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
436('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
437('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
438('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
439('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
440('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
441('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
442('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
443('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
444('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
445('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
446('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
447('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
448('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
449('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
450('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
451('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
452('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
453('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
454('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
455('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
456('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
457('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
458('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
459('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
460('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
461('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
462('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
463('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
464('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
465('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
466('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
467('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
468('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
469('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
470('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
471('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
472('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
473('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
474('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
475('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
476('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
477('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
478('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
479('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
480('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
481('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
482('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
483('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
484('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
485('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
486('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
487('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
488('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
489('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
490('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
491('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
492('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
493('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
494('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
495('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
496('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
497('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
498('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
499('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
500('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
501('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
502('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
503('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
504('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
505('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
506('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
507('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
508('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
509('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
510('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
511('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
512('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
513('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
514('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
515('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
516('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
517('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
518('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
519('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
520('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
521('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
522('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
523('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
524('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
525('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
526('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
527('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
528('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
529('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
530('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
531('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
532('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
533('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
534('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
535('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
536('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
537('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
538('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
539('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
540('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
541('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
542('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
543('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
544('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
545('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
546('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
547('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
548('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
549('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
550('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
551('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
552('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
553('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
554('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
555('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
556('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
557('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
558('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
559('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
560('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
561('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
562('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
563('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
564('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
565('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
566('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
567('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
568('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
569('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
570('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
571('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
572('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
573('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
574('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
575('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
576('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
577('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
578('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
579('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
580('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
581('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
582('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
583('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
584('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
585('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
586('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
587('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
588('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
589('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
590('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
591('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
592('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
593('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
594('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
595('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
596('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
597('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
598('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
599('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
600('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
601('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
602('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
603('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
604('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
605('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
606('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
607('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
608('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
609('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
610('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
611('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
612('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
613('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
614('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
615('VF_MODULE', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
616('NETWORK', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
617('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
618('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
619('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
620('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
621('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
622('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
623('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
624('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
625('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
626('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
627('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
628('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
629('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
630('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
631('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
632('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
633('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
634('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
635('CUSTOM', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
636('CUSTOM', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
637('CUSTOM', 'CREATED', 'CUSTOM', 'CONTINUE'),
638('CUSTOM', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
639('CUSTOM', 'PENDING', 'CUSTOM', 'CONTINUE'),
640('CUSTOM', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
641('CUSTOM', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
642('CUSTOM', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
643('CUSTOM', 'PRECREATED', 'CUSTOM', 'CONTINUE');
Benjamin, Max (mb388a)a81aef22018-08-13 09:48:57 -0400[diff] [blame]644
Benjamin, Max (mb388a)a81aef22018-08-13 09:48:57 -0400[diff] [blame]645INSERT 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');
646
647INSERT INTO `identity_services` (`ID`, `IDENTITY_URL`, `MSO_ID`, `MSO_PASS`, `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', 'admin', 'admin', 1, 'KEYSTONE', 'USERNAME_PASSWORD', 'MSO_USER', '2018-07-17 14:02:33', '2018-07-17 14:02:33');
648
Prema Bhatt474b1752018-08-10 15:54:13 -0700[diff] [blame]649INSERT 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');
650
651INSERT INTO `controller_selection_reference` (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`) VALUES
Rob Daughertyadd0df02018-08-30 14:26:55 -0400[diff] [blame^]652('vLoadBalancerMS/vLoadBalancerMS 0', 'APPC', 'ConfigScaleOut'),
653('vLoadBalancerMS/vLoadBalancerMS 0', 'APPC', 'HealthCheck');