Blame - mso-catalog-db/src/test/resources/data.sql - onap/so

blob: 0913aef01b782467ffeee0e4fbdd2477b1e9ef89 [file] [log] [blame]

Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	1
				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');
				4
				5
				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');
				8
				9
				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');
				12
				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');
				15
				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');
				18
				19
				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');
				24
				25
				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');
				28
				29	insert into heat_template(artifact_uuid, name, version, description, body, timeout_minutes, artifact_checksum, creation_timestamp) values
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	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');
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	33
				34
				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', '');
				39
				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');
				43
				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);
				46
Benjamin, Max (mb388a)	86f04e1	2019-04-02 22:54:57 -0400	[diff] [blame]	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,SERVICE_MODEL_UUID) 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,'5df8b6de-2083-11e7-93ae-92361f002671');
				49
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	50
				51	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
				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
				57	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
				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
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	61	insert into allotted_resource(model_uuid, model_invariant_uuid, model_version, model_name, tosca_node_type, subcategory, description, creation_timestamp) values
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	62	('f6b7d4c6-e8a4-46e2-81bc-31cad5072842', 'b7a1b78e-6b6b-4b36-9698-8c9530da14af', '1.0', 'Tunnel_Xconn', '', '', '', '2017-05-26 15:08:24');
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	63
				64	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
				65	('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');
				66
				67
				68	insert into temp_network_heat_template_lookup(network_resource_model_name, heat_template_artifact_uuid, aic_version_min, aic_version_max) values
				69	('CONTRAIL30_GNDIRECT', 'ff874603-4222-11e7-9252-005056850d2e', '3', '3');
				70
				71	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
				72	('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');
				73	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
				74	('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');
				75
				76	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
				77	('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');
				78
				79	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
				80	('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');
				81
				82
				83	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
				84	('3bdbb104-476c-483e-9f8b-c095b3d308ac', 'CONTRAIL30_GNDIRECT 9', '', '', '', '', '2017-04-19 14:28:32', '10b36f65-f4e6-4be6-ae49-9596dc1c47fc');
				85
Benjamin, Max (mb388a)	08c27a2	2018-09-17 11:14:35 -0400	[diff] [blame]	86	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
				87	('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');
				88
				89	insert into collection_resource(model_uuid, model_name, model_invariant_uuid, model_version, tosca_node_type, description) values
				90	('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');
				91
				92	insert into collection_resource_customization(model_customization_uuid, model_instance_name, role, object_type, function, collection_resource_type, cr_model_uuid) values
				93	('c51096a4-6081-41f4-a540-3ed015a8064a', 'Dror_CR_Network_Resource_1806', 'Dror2', 'NetworkCollection', 'Dror1', 'Dror3', '5e3fca45-e2d8-4987-bef1-016d9bda1a8c');
				94
				95	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
				96	('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'),
				97	('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');
				98
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	99	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
				100	('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);
				101
				102
Benjamin, Max (mb388a)	4fed69f	2019-04-11 12:24:56 -0400	[diff] [blame]	103	insert into vnf_resource_customization(id, 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,SERVICE_MODEL_UUID) values
				104	('1429', '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,'5df8b6de-2083-11e7-93ae-92361f002672');
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	105
Benjamin, Max (mb388a)	4fed69f	2019-04-11 12:24:56 -0400	[diff] [blame]	106	INSERT INTO vnfc_instance_group_customization (`ID`, `INSTANCE_GROUP_MODEL_UUID`, `FUNCTION`, `VNF_RESOURCE_CUSTOMIZATION_ID`) VALUES
				107	('1450', '21e43a7c-d823-4f5b-a427-5235f63035ff', 'FUNCTION', '1429');
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	108
				109
				110
				111
				112	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
				113
				114	('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'),
				115	('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'),
				116	('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'),
				117	('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'),
				118	('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');
				119
				120
				121
				122	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
				123	('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'),
				124	('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');
				125
				126
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	127
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	128
				129
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	130	insert into vf_module_to_heat_files(vf_module_model_uuid, heat_files_artifact_uuid) values
				131	('20c4431c-246d-11e7-93ae-92361f002671', '00535bdd-0878-4478-b95a-c575c742bfb0'),
				132	('066de97e-253e-11e7-93ae-92361f002671', '00535bdd-0878-4478-b95a-c575c742bfb0');
				133
				134
				135	insert into network_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
				136	('5df8b6de-2083-11e7-93ae-92361f002671', '3bdbb104-476c-483e-9f8b-c095b3d308ac'),
				137	('5df8b6de-2083-11e7-93ae-92361f002672', '3bdbb104-476c-483e-9f8b-c095b3d308ac');
				138
				139
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	140	insert into allotted_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
				141	('5df8b6de-2083-11e7-93ae-92361f002671', '367a8ba9-057a-4506-b106-fbae818597c6' ),
				142	('5df8b6de-2083-11e7-93ae-92361f002672', '367a8ba9-057a-4506-b106-fbae818597c6');
				143
				144
				145
				146	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
				147	('61', '*', 'CREATE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/workflow/services/CreateGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
				148	('63', '*', 'DELETE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/async/services/deleteGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
				149	('65', '*', 'UPDATE', '', '1', 'Recipe Match All for VNFs if no custom flow exists', '/mso/workflow/services/updateGenericVNFV1', '', '180', '2016-06-03 10:14:10', ''),
				150	('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', ''),
				151	('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', ''),
				152	('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', ''),
				153	('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', ''),
				154	('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', ''),
				155	('81', 'VID_DEFAULT', 'updateInstance', '', '1', 'VID_DEFAULT update', '/mso/async/services/UpdateVnfInfra', '', '180', '2017-07-28 18:19:39', ''),
				156	('85', 'VID_DEFAULT', 'replaceInstance', '', '1', 'VID_DEFAULT replace', '/mso/async/services/ReplaceVnfInfra', '', '180', '2017-07-28 18:19:45', ''),
				157	('10000', 'VID_DEFAULT', 'inPlaceSoftwareUpdate', '', '1', 'VID_DEFAULT inPlaceSoftwareUpdate', '/mso/async/services/VnfInPlaceUpdate', '', '180', '2017-10-25 18:19:45', ''),
				158	('10001', 'VID_DEFAULT', 'applyUpdatedConfig', '', '1', 'VID_DEFAULT applyUpdatedConfig', '/mso/async/services/VnfConfigUpdate', '', '180', '2017-10-25 18:19:45', '');
				159
				160
				161	insert into vnf_components(vnf_id, component_type, heat_template_id, heat_environment_id, creation_timestamp) values
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	162	('13961', 'VOLUME', '13843', '13961', '2016-05-19 20:22:02');
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	163
				164	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
				165	('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', ''),
				166	('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', ''),
				167	('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', ''),
				168	('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', '*'),
				169	('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', '*'),
				170	('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'),
				171	('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'),
				172	('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'),
				173	('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'),
				174	('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'),
				175	('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'),
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	176	('25', '', 'vfModule', 'replaceInstance', '', '1', 'VID_DEFAULT vfModule replace', '/mso/async/services/ReplaceVfModuleInfra', '', '180', '2017-07-28 18:25:06', 'VID_DEFAULT');
				177
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	178	insert into network_recipe(id, model_name, action, description, orchestration_uri, network_param_xsd, recipe_timeout, service_type, creation_timestamp, version_str) values
				179	('1', 'CONTRAIL_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				180	('2', 'CONTRAIL_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				181	('3', 'CONTRAIL_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				182	('4', 'CONTRAIL_SHARED', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				183	('5', 'CONTRAIL_SHARED', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				184	('6', 'CONTRAIL_SHARED', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				185	('7', 'CONTRAIL_EXTERNAL', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				186	('8', 'CONTRAIL_EXTERNAL', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				187	('9', 'CONTRAIL_EXTERNAL', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'),
				188	('10', 'CONTRAIL30_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
				189	('11', 'CONTRAIL30_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
				190	('12', 'CONTRAIL30_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-05-26 14:48:13', '1'),
				191	('13', 'NEUTRON_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-06-01 19:54:51', '1'),
				192	('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'),
				193	('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'),
				194	('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'),
				195	('124', 'CONTRAIL30_MPSCE', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
				196	('126', 'CONTRAIL30_MPSCE', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
				197	('128', 'CONTRAIL30_MPSCE', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-10-18 18:47:52', '1'),
				198	('141', 'CONTRAIL30_L2NODHCP', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
				199	('144', 'CONTRAIL30_L2NODHCP', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
				200	('147', 'CONTRAIL30_L2NODHCP', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-01-03 20:12:46', '1'),
				201	('169', 'CONTRAIL30_GNDIRECT', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
				202	('172', 'CONTRAIL30_GNDIRECT', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
				203	('175', 'CONTRAIL30_GNDIRECT', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'),
				204	('176', 'NEUTRON_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1'),
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	205	('177', 'NEUTRON_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1');
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	206
Benjamin, Max (mb388a)	86f04e1	2019-04-02 22:54:57 -0400	[diff] [blame]	207	INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, IS_TOPLEVELFLOW, MIN_API_VERSION, MAX_API_VERSION,cloud_owner) VALUES
				208	('Service-Create', 'createInstance', 'Service', true, true, '7','7','cloudOwner'),
				209	('Service-Delete', 'deleteInstance', 'Service', true, true, '7','7','cloudOwner'),
				210	('Service-Macro-Assign', 'assignInstance', 'Service', false, true, '7','7','cloudOwner'),
				211	('Service-Macro-Activate', 'activateInstance', 'Service', false, true, '7','7','cloudOwner'),
				212	('Service-Macro-Unassign', 'unassignInstance', 'Service', false, true, '7','7','cloudOwner'),
				213	('Service-Macro-Create', 'createInstance', 'Service', false, true, '7','7','cloudOwner'),
				214	('Service-Macro-Delete', 'deleteInstance', 'Service', false, true, '7','7','cloudOwner'),
				215	('Network-Create', 'createInstance', 'Network', true, true, '7','7','cloudOwner'),
				216	('Network-Delete', 'deleteInstance', 'Network', true, true, '7','7','cloudOwner'),
				217	('VNF-Macro-Recreate', 'replaceInstance', 'Vnf', false, false, '7','7','cloudOwner'),
				218	('VNF-Macro-Replace', 'internalReplace', 'Vnf', false, false, '7','7','cloudOwner'),
				219	('VNF-Create', 'createInstance', 'Vnf', true, true, '7', '7','cloudOwner'),
				220	('VNF-Delete', 'deleteInstance', 'Vnf', true, true, '7', '7','cloudOwner'),
				221	('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true, true, '7','7','cloudOwner'),
				222	('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true, true, '7','7','cloudOwner'),
				223	('VFModule-Create', 'createInstance', 'VfModule', true, true, '7','7','cloudOwner'),
				224	('VFModule-Delete', 'deleteInstance', 'VfModule', true, true, '7','7','cloudOwner'),
				225	('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, true, '7','7','cloudOwner'),
				226	('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false, true, '7','7','cloudOwner'),
				227	('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false, true, '7','7','cloudOwner'),
				228	('InstanceGroup-Create', 'createInstance', 'InstanceGroup', true, true, '7','7','cloudOwner'),
				229	('InstanceGroup-Delete', 'deleteInstance', 'InstanceGroup', true, true, '7','7','cloudOwner'),
				230	('InstanceGroupMembers-Add', 'addMembers', 'InstanceGroupMembers', true, true, '7','7','cloudOwner'),
				231	('InstanceGroupMembers-Remove', 'removeMembers', 'InstanceGroupMembers', true, true, '7','7','cloudOwner');
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	232
				233	INSERT INTO building_block_detail (BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
				234	VALUES
				235	('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
				236	('AssignVnfBB', 'VNF', 'ASSIGN'),
				237	('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
				238	('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
				239	('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
				240	('AssignNetwork1802BB', 'NETWORK', 'ASSIGN'),
				241	('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
				242	('UnassignVnfBB', 'VNF', 'UNASSIGN'),
				243	('UnassignVolumeGroupBB', 'VOLUME_GROUP', 'UNASSIGN'),
				244	('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
				245	('UnassignNetwork1802BB', 'NETWORK', 'UNASSIGN'),
				246	('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
				247	('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
				248	('ActivateVnfBB', 'VNF', 'ACTIVATE'),
				249	('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
				250	('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
				251	('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
				252	('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
				253	('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
				254	('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
				255	('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
				256	('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
				257	('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
				258	('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGE_MODEL'),
				259	('ChangeModelVnfBB', 'VNF', 'CHANGE_MODEL'),
				260	('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGE_MODEL'),
				261	('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
				262	('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
				263	('CreateNetworkBB', 'NETWORK', 'CREATE'),
				264	('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
				265	('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
				266	('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
				267	('DeleteNetworkBB', 'NETWORK', 'DELETE'),
				268	('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
Bonkur, Venkat (vb8416)	8e40406	2019-05-20 17:40:21 -0400	[diff] [blame]	269	('AssignAndActivateVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
				270	('AvpnAssignServiceInstanceBB', 'NO_VALIDATE', 'CUSTOM'),
				271	('CreateCustomerVpnBindingBB', 'NO_VALIDATE', 'CUSTOM'),
				272	('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
				273	('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
				274	('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
				275	('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
				276	('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
				277	('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
				278	('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
				279	('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
				280	('HomingBB', 'NO_VALIDATE', 'CUSTOM'),
				281	('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
				282	('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
				283	('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
				284	('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
				285	('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
				286	('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
				287	('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
				288	('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
				289	('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
				290	('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
				291	('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
				292	('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
				293	('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
				294	('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
				295	('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
				296	('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
				297	('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
				298	('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
				299	('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
				300	('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
				301	('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
				302	('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
				303	('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
				304	('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM');
				305
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	306
				307	INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
				308	('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')),
				309	('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')),
				310	('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete')),
				311	('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete')),
				312	('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				313	('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				314	('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				315	('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				316	('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				317	('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				318	('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				319	('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				320	('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				321	('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				322	('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				323	('Service-Macro-Activate', '7', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				324	('Service-Macro-Activate', '8', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				325	('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				326	('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				327	('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				328	('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				329	('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				330	('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				331	('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				332	('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				333	('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				334	('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				335	('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				336	('Service-Macro-Create', '7', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				337	('Service-Macro-Create', '8', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				338	('Service-Macro-Create', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				339	('Service-Macro-Create', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				340	('Service-Macro-Create', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				341	('Service-Macro-Create', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				342	('Service-Macro-Create', '13', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				343	('Service-Macro-Create', '14', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				344	('Service-Macro-Create', '15', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				345	('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				346	('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				347	('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				348	('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				349	('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				350	('Service-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				351	('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				352	('Service-Macro-Delete', '8', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				353	('Service-Macro-Delete', '9', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				354	('Service-Macro-Delete', '10', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				355	('Service-Macro-Delete', '11', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				356	('Service-Macro-Delete', '12', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				357	('Service-Macro-Delete', '13', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				358	('Service-Macro-Delete', '14', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				359	('Network-Create', '1', 'AssignNetwork1802BB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
				360	('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
				361	('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
				362	('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
				363	('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
				364	('Network-Delete', '3', 'UnassignNetwork1802BB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
				365	('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create')),
				366	('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create')),
				367	('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete')),
				368	('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete')),
				369	('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				370	('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				371	('VNF-Macro-Recreate', '3', 'VNF-Macro-Replace', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				372	('VNF-Macro-Recreate', '4', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				373	('VNF-Macro-Recreate', '5', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				374	('VNF-Macro-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				375	('VNF-Macro-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				376	('VNF-Macro-Replace', '3', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				377	('VNF-Macro-Replace', '4', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				378	('VNF-Macro-Replace', '5', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				379	('VNF-Macro-Replace', '6', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				380	('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
				381	('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
				382	('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
				383	('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
				384	('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
				385	('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
				386	('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
				387	('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
				388	('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
				389	('VFModule-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
				390	('VFModule-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
				391	('VFModule-Delete', '3', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
				392	('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete')),
				393	('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete')),
				394	('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				395	('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				396	('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				397	('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				398	('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				399	('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
				400	('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
				401	('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
Benjamin, Max (mb388a)	86f04e1	2019-04-02 22:54:57 -0400	[diff] [blame]	402	('NetworkCollection-Macro-Delete', '4', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
				403	('InstanceGroup-Create', '1', 'CreateInstanceGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'InstanceGroup-Create')),
				404	('InstanceGroup-Delete', '1', 'DeleteInstanceGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'InstanceGroup-Delete')),
				405	('InstanceGroupMembers-Add', '1', 'AddInstanceGroupMembersBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'InstanceGroupMembers-Add')),
				406	('InstanceGroupmembers-Remove', '1', 'RemoveInstanceGroupMembersBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'InstanceGroupMembers-Remove'));
				407
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	408
				409	INSERT INTO orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
				410	VALUES
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	411	('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				412	('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				413	('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				414	('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				415	('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				416	('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
				417	('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
				418	('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
				419	('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
				420	('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
				421	('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				422	('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				423	('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				424	('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				425	('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				426	('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
				427	('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
				428	('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
				429	('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
				430	('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
				431	('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				432	('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				433	('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				434	('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				435	('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				436	('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
				437	('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
				438	('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
				439	('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
				440	('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
				441	('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
				442	('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
				443	('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
				444	('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
				445	('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
				446	('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
				447	('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
				448	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
				449	('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
				450	('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
				451	('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
				452	('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
				453	('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
				454	('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
				455	('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
				456	('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				457	('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				458	('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				459	('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				460	('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				461	('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
				462	('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
				463	('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
				464	('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
				465	('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
				466	('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				467	('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				468	('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				469	('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				470	('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				471	('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
				472	('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
				473	('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
				474	('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
				475	('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
				476	('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				477	('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				478	('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				479	('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				480	('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				481	('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
				482	('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
				483	('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
				484	('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
				485	('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
				486	('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
				487	('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
				488	('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
				489	('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
				490	('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
				491	('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
				492	('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
				493	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
				494	('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
				495	('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
				496	('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
				497	('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
				498	('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
				499	('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
				500	('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
				501	('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				502	('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				503	('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				504	('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				505	('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				506	('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				507	('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				508	('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				509	('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				510	('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				511	('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
				512	('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
				513	('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
				514	('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
				515	('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
				516	('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
				517	('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
				518	('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
				519	('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
				520	('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
				521	('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				522	('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				523	('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				524	('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				525	('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				526	('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				527	('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				528	('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				529	('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				530	('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				531	('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
				532	('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
				533	('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
				534	('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
				535	('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
				536	('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
				537	('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
				538	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
				539	('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
				540	('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
				541	('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
				542	('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
				543	('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
				544	('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
				545	('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
				546	('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				547	('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				548	('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				549	('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				550	('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				551	('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
				552	('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				553	('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
				554	('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				555	('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				556	('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				557	('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				558	('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				559	('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				560	('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				561	('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				562	('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				563	('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				564	('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				565	('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				566	('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				567	('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				568	('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				569	('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				570	('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				571	('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
				572	('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
				573	('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
				574	('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				575	('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				576	('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				577	('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				578	('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
				579	('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				580	('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				581	('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
				582	('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
				583	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
				584	('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
				585	('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
				586	('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
				587	('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
				588	('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
				589	('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
				590	('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
				591	('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
				592	('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
				593	('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
				594	('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
				595	('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
				596	('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
				597	('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
				598	('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
				599	('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
				600	('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
				601	('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
				602	('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
				603	('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
				604	('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
				605	('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
				606	('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
				607	('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
				608	('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
				609	('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
				610	('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
				611	('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
				612	('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
				613	('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
				614	('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
				615	('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
				616	('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
				617	('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
				618	('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
				619	('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
				620	('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
				621	('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
				622	('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
				623	('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
				624	('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
				625	('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
				626	('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
				627	('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
				628	('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
				629	('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
				630	('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
				631	('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
				632	('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
				633	('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	634	('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	635	('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
				636	('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
				637	('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
				638	('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
				639	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
				640	('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
				641	('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
				642	('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
				643	('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
				644	('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
				645	('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
				646	('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
				647	('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
				648	('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
				649	('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
				650	('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
				651	('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
				652	('VF_MODULE', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
				653	('NETWORK', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
				654	('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
				655	('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
				656	('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
				657	('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
				658	('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
				659	('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
				660	('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
				661	('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
				662	('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
				663	('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
				664	('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
				665	('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
				666	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
				667	('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
				668	('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
				669	('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
				670	('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	671	('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
Bonkur, Venkat (vb8416)	8e40406	2019-05-20 17:40:21 -0400	[diff] [blame]	672	('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
				673	('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
				674	('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
				675	('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
				676	('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
				677	('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
				678	('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
				679	('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
				680	('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
Benjamin, Max (mb388a)	a81aef2	2018-08-13 09:48:57 -0400	[diff] [blame]	681
Benjamin, Max (mb388a)	a81aef2	2018-08-13 09:48:57 -0400	[diff] [blame]	682	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');
				683
Benjamin, Max (mb388a)	37547ac	2018-11-16 12:23:48 -0500	[diff] [blame]	684	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');
Benjamin, Max (mb388a)	a81aef2	2018-08-13 09:48:57 -0400	[diff] [blame]	685
Smokowski, Steven	0c6057e	2020-03-19 17:57:25 -0400	[diff] [blame]	686	INSERT INTO `cloud_sites` (`ID`, `REGION_ID`, `IDENTITY_SERVICE_ID`, `CLOUD_VERSION`, `CLLI`, `CLOUDIFY_ID`, `PLATFORM`, `ORCHESTRATOR`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`, `SUPPORT_FABRIC`,`CLOUD_OWNER`) VALUES ('mtn13', 'mtn13', 'MTN13', '2.5', 'MDT13', 'mtn13', NULL, 'orchestrator', 'MSO_USER', '2018-07-17 14:06:28', '2018-07-17 14:06:28', 1,'cloudOwner');
Prema Bhatt	474b175	2018-08-10 15:54:13 -0700	[diff] [blame]	687
				688	INSERT INTO `controller_selection_reference` (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`) VALUES
Rob Daugherty	add0df0	2018-08-30 14:26:55 -0400	[diff] [blame]	689	('vLoadBalancerMS/vLoadBalancerMS 0', 'APPC', 'ConfigScaleOut'),
				690	('vLoadBalancerMS/vLoadBalancerMS 0', 'APPC', 'HealthCheck');
Benjamin, Max (mb388a)	69455a2	2018-09-04 11:21:02 -0400	[diff] [blame]	691
				692	INSERT INTO `configuration`
				693	(`model_uuid`,
				694	`model_invariant_uuid`,
				695	`model_version`,
				696	`model_name`,
				697	`tosca_node_type`,
				698	`description`,
				699	`creation_timestamp`)
				700	VALUES ( 'c59a41ca-9b3b-11e8-98d0-529269fb1459',
				701	'15881e64-9b3c-11e8-98d0-529269fb1459',
				702	'testModelVersion',
				703	'testModelName',
				704	'testToscaModelType',
				705	'testConfigurationDescription',
				706	'2018-07-17 14:05:08' );
				707
				708
				709	INSERT INTO `vnfc_customization`
				710	(`model_customization_uuid`,
				711	`model_instance_name`,
				712	`model_uuid`,
				713	`model_invariant_uuid`,
				714	`model_version`,
				715	`model_name`,
				716	`tosca_node_type`,
				717	`description`,
				718	`creation_timestamp`)
				719	VALUES ( '9bcce658-9b37-11e8-98d0-529269fb1459',
				720	'testModelInstanceName',
				721	'b25735fe-9b37-11e8-98d0-529269fb1459',
				722	'ba7e6ef0-9b37-11e8-98d0-529269fb1459',
				723	'testModelVersion',
				724	'testModelName',
				725	'toscaNodeType',
				726	'testVnfcCustomizationDescription',
				727	'2018-07-17 14:05:08');
				728
				729	INSERT INTO `cvnfc_customization`
				730	(`id`,
				731	`model_customization_uuid`,
				732	`model_instance_name`,
				733	`model_uuid`,
				734	`model_invariant_uuid`,
				735	`model_version`,
				736	`model_name`,
				737	`tosca_node_type`,
				738	`description`,
				739	`nfc_function`,
				740	`nfc_naming_code`,
				741	`creation_timestamp`,
Benjamin, Max (mb388a)	69455a2	2018-09-04 11:21:02 -0400	[diff] [blame]	742	`vnfc_cust_model_customization_uuid`)
				743	VALUES ( '1',
				744	'9bcce658-9b37-11e8-98d0-529269fb1459',
				745	'testModelInstanceName',
				746	'b25735fe-9b37-11e8-98d0-529269fb1459',
				747	'ba7e6ef0-9b37-11e8-98d0-529269fb1459',
				748	'testModelVersion',
				749	'testModelName',
				750	'testToscaNodeType',
				751	'testCvnfcCustomzationDescription',
				752	'testNfcFunction',
				753	'testNfcNamingCode',
				754	'2018-07-17 14:05:08',
Benjamin, Max (mb388a)	69455a2	2018-09-04 11:21:02 -0400	[diff] [blame]	755	'9bcce658-9b37-11e8-98d0-529269fb1459');
				756
eeginux	53bb2f2	2019-03-09 00:57:00 +0000	[diff] [blame]	757	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
				758	('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');
				759
				760	insert into pnf_resource(orchestration_mode, description, creation_timestamp, model_uuid, model_invariant_uuid, model_version, model_name, tosca_node_type) values
				761	('', 'PNF routing', '2019-03-08 12:00:28', 'ff2ae348-214a-11e7-93ae-92361f002680', '2fff5b20-214b-11e7-93ae-92361f002680', '1.0', 'PNF resource', null);
				762
				763	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
				764	('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");
				765
				766	insert into pnf_resource_customization_to_service(service_model_uuid, resource_model_customization_uuid) values
Benjamin, Max (mb388a)	86f04e1	2019-04-02 22:54:57 -0400	[diff] [blame]	767	('5df8b6de-2083-11e7-93ae-92361f002676', '68dc9a92-214c-11e7-93ae-92361f002680');
Elena Kuleshov	eeaa957	2019-04-08 01:17:53 -0400	[diff] [blame]	768
				769	insert into workflow(artifact_uuid, artifact_name, name, operation_name, version, description, body, resource_target, source) values
Elena Kuleshov	a385c0c	2019-05-09 12:27:30 -0400	[diff] [blame]	770	('5b0c4322-643d-4c9f-b184-4516049e99b1', 'testingWorkflow.bpmn', 'testingWorkflow', 'create', 1, 'Test Workflow', null, 'vnf', 'sdc');
Ubuntu	2ce8c8e	2019-12-13 12:05:20 +0800	[diff] [blame]	771	insert into workflow(artifact_uuid, artifact_name, name, operation_name, version, description, body, resource_target, source) values
				772	('b2fd5627-55e4-4f4f-8064-9e6f443e9152','DummyPnfWorkflow','Dummy Pnf Workflow','DummyPnfWorkflow',1.0,'Dummy Pnf Workflow to test custom Pnf workflow',null,'pnf','native');
Elena Kuleshov	fd4d683	2019-04-08 22:08:29 -0400	[diff] [blame]	773
				774	insert into vnf_resource_to_workflow(vnf_resource_model_uuid, workflow_id) values
				775	('ff2ae348-214a-11e7-93ae-92361f002671', '1');
				776
Ubuntu	2ce8c8e	2019-12-13 12:05:20 +0800	[diff] [blame]	777	Insert into pnf_resource_to_workflow (`PNF_RESOURCE_MODEL_UUID`,`WORKFLOW_ID`) values
				778	("ff2ae348-214a-11e7-93ae-92361f002680", 2);
				779
Elena Kuleshov	fd4d683	2019-04-08 22:08:29 -0400	[diff] [blame]	780	insert into activity_spec(name, description, version) values
				781	('testActivity1', 'Test Activity 1', 1);
				782
				783	insert into workflow_activity_spec_sequence(workflow_id, activity_spec_id, seq_no) values
				784	(1, 1, 1);
Bonkur, Venkat (vb8416)	0091579	2019-04-10 21:10:01 -0400	[diff] [blame]	785
				786	INSERT INTO activity_spec (NAME, DESCRIPTION, VERSION)
				787	VALUES
				788	('VNFSetInMaintFlagActivity','Activity to Set InMaint Flag in A&AI',1.0),
				789	('VNFCheckPserversLockedFlagActivity','Activity Check Pservers Locked Flag VNF',1.0),
				790	('VNFCheckInMaintFlagActivity','Activity CheckIn Maint Flag on VNF',1.0),
				791	('VNFCheckClosedLoopDisabledFlagActivity','Activity Check Closed Loop Disabled Flag on VNF',1.0),
				792	('VNFSetClosedLoopDisabledFlagActivity','Activity Set Closed Loop Disabled Flag on VNF',1.0),
				793	('VNFUnsetClosedLoopDisabledFlagActivity','Activity Unset Closed Loop Disabled Flag on VNF',1.0),
				794	('VNFLockActivity','Activity Lock on VNF',1.0),
				795	('VNFUnlockActivity','Activity UnLock on VNF',1.0),
				796	('VNFStopActivity','Activity Stop on VNF',1.0),
				797	('VNFStartActivity','Activity Start on VNF',1.0),
				798	('VNFSnapShotActivity','Activity Snap Shot on VNF',1.0),
				799	('FlowCompleteActivity','Activity Complete on VNF',1.0),
				800	('PauseForManualTaskActivity','Activity Pause For Manual Task on VNF',1.0),
				801	('DistributeTrafficActivity','Activity Distribute Traffic on VNF',1.0),
				802	('DistributeTrafficCheckActivity','Activity Distribute Traffic Check on VNF',1.0),
				803	('VNFHealthCheckActivity','Activity Health Check on VNF',1.0),
				804	('VNFQuiesceTrafficActivity','Activity Quiesce Traffic on VNF',1.0),
				805	('VNFResumeTrafficActivity','Activity Resume Traffic on VNF',1.0),
				806	('VNFUnsetInMaintFlagActivity','Activity Unset InMaint Flag on VNF',1.0),
				807	('VNFUpgradeBackupActivity','Activity Upgrade Backup on VNF',1.0),
				808	('VNFUpgradePostCheckActivity','Activity Upgrade Post Check on VNF',1.0),
				809	('VNFUpgradePreCheckActivity','Activity Upgrade PreCheck on VNF',1.0),
				810	('VNFUpgradeSoftwareActivity','Activity UpgradeS oftware on VNF',1.0),
				811	('VnfInPlaceSoftwareUpdate','Activity InPlace Software Update on VNF',1.0);
				812
				813	INSERT INTO activity_spec_categories (NAME)
				814	VALUES ('VNF');
				815
				816	INSERT INTO activity_spec_to_activity_spec_categories(ACTIVITY_SPEC_ID, ACTIVITY_SPEC_CATEGORIES_ID)
				817	VALUES
				818	((select ID from activity_spec where NAME='VNFSetInMaintFlagActivity' and VERSION=1.0),
				819	(select ID from activity_spec_categories where NAME='VNF')),
				820	((select ID from activity_spec where NAME='VNFCheckPserversLockedFlagActivity' and VERSION=1.0),
				821	(select ID from activity_spec_categories where NAME='VNF')),
				822	((select ID from activity_spec where NAME='VNFCheckInMaintFlagActivity' and VERSION=1.0),
				823	(select ID from activity_spec_categories where NAME='VNF')),
				824	((select ID from activity_spec where NAME='VNFCheckClosedLoopDisabledFlagActivity' and VERSION=1.0),
				825	(select ID from activity_spec_categories where NAME='VNF')),
				826	((select ID from activity_spec where NAME='VNFSetClosedLoopDisabledFlagActivity' and VERSION=1.0),
				827	(select ID from activity_spec_categories where NAME='VNF')),
				828	((select ID from activity_spec where NAME='VNFUnsetClosedLoopDisabledFlagActivity' and VERSION=1.0),
				829	(select ID from activity_spec_categories where NAME='VNF')),
				830	((select ID from activity_spec where NAME='VNFLockActivity' and VERSION=1.0),
				831	(select ID from activity_spec_categories where NAME='VNF')),
				832	((select ID from activity_spec where NAME='VNFUnlockActivity' and VERSION=1.0),
				833	(select ID from activity_spec_categories where NAME='VNF')),
				834	((select ID from activity_spec where NAME='VNFStopActivity' and VERSION=1.0),
				835	(select ID from activity_spec_categories where NAME='VNF')),
				836	((select ID from activity_spec where NAME='VNFStartActivity' and VERSION=1.0),
				837	(select ID from activity_spec_categories where NAME='VNF')),
				838	((select ID from activity_spec where NAME='VNFSnapShotActivity' and VERSION=1.0),
				839	(select ID from activity_spec_categories where NAME='VNF')),
				840	((select ID from activity_spec where NAME='FlowCompleteActivity' and VERSION=1.0),
				841	(select ID from activity_spec_categories where NAME='VNF')),
				842	((select ID from activity_spec where NAME='PauseForManualTaskActivity' and VERSION=1.0),
				843	(select ID from activity_spec_categories where NAME='VNF')),
				844	((select ID from activity_spec where NAME='DistributeTrafficActivity' and VERSION=1.0),
				845	(select ID from activity_spec_categories where NAME='VNF')),
				846	((select ID from activity_spec where NAME='DistributeTrafficCheckActivity' and VERSION=1.0),
				847	(select ID from activity_spec_categories where NAME='VNF')),
				848	((select ID from activity_spec where NAME='VNFHealthCheckActivity' and VERSION=1.0),
				849	(select ID from activity_spec_categories where NAME='VNF')),
				850	((select ID from activity_spec where NAME='VNFQuiesceTrafficActivity' and VERSION=1.0),
				851	(select ID from activity_spec_categories where NAME='VNF')),
				852	((select ID from activity_spec where NAME='VNFResumeTrafficActivity' and VERSION=1.0),
				853	(select ID from activity_spec_categories where NAME='VNF')),
				854	((select ID from activity_spec where NAME='VNFUnsetInMaintFlagActivity' and VERSION=1.0),
				855	(select ID from activity_spec_categories where NAME='VNF')),
				856	((select ID from activity_spec where NAME='VNFUpgradeBackupActivity' and VERSION=1.0),
				857	(select ID from activity_spec_categories where NAME='VNF')),
				858	((select ID from activity_spec where NAME='VNFUpgradePostCheckActivity' and VERSION=1.0),
				859	(select ID from activity_spec_categories where NAME='VNF')),
				860	((select ID from activity_spec where NAME='VNFUpgradePreCheckActivity' and VERSION=1.0),
				861	(select ID from activity_spec_categories where NAME='VNF')),
				862	((select ID from activity_spec where NAME='VNFUpgradeSoftwareActivity' and VERSION=1.0),
				863	(select ID from activity_spec_categories where NAME='VNF')),
				864	((select ID from activity_spec where NAME='VnfInPlaceSoftwareUpdate' and VERSION=1.0),
				865	(select ID from activity_spec_categories where NAME='VNF'));
				866
				867	INSERT INTO activity_spec_parameters (NAME, TYPE, DIRECTION, DESCRIPTION)
				868	VALUES('WorkflowException','WorkflowException','output','Description');
				869
				870	INSERT INTO activity_spec_to_activity_spec_parameters( ACTIVITY_SPEC_ID, ACTIVITY_SPEC_PARAMETERS_ID)
				871	VALUES
				872	((select ID from activity_spec where NAME='VNFSetInMaintFlagActivity' and VERSION=1.0),
				873	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				874	((select ID from activity_spec where NAME='VNFCheckPserversLockedFlagActivity' and VERSION=1.0),
				875	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				876	((select ID from activity_spec where NAME='VNFCheckInMaintFlagActivity' and VERSION=1.0),
				877	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				878	((select ID from activity_spec where NAME='VNFCheckClosedLoopDisabledFlagActivity' and VERSION=1.0),
				879	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				880	((select ID from activity_spec where NAME='VNFSetClosedLoopDisabledFlagActivity' and VERSION=1.0),
				881	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				882	((select ID from activity_spec where NAME='VNFUnsetClosedLoopDisabledFlagActivity' and VERSION=1.0),
				883	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				884	((select ID from activity_spec where NAME='VNFLockActivity' and VERSION=1.0),
				885	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				886	((select ID from activity_spec where NAME='VNFUnlockActivity' and VERSION=1.0),
				887	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				888	((select ID from activity_spec where NAME='VNFStopActivity' and VERSION=1.0),
				889	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				890	((select ID from activity_spec where NAME='VNFStartActivity' and VERSION=1.0),
				891	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				892	((select ID from activity_spec where NAME='VNFSnapShotActivity' and VERSION=1.0),
				893	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				894	((select ID from activity_spec where NAME='FlowCompleteActivity' and VERSION=1.0),
				895	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				896	((select ID from activity_spec where NAME='PauseForManualTaskActivity' and VERSION=1.0),
				897	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				898	((select ID from activity_spec where NAME='DistributeTrafficActivity' and VERSION=1.0),
				899	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				900	((select ID from activity_spec where NAME='DistributeTrafficCheckActivity' and VERSION=1.0),
				901	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				902	((select ID from activity_spec where NAME='VNFHealthCheckActivity' and VERSION=1.0),
				903	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				904	((select ID from activity_spec where NAME='VNFQuiesceTrafficActivity' and VERSION=1.0),
				905	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				906	((select ID from activity_spec where NAME='VNFResumeTrafficActivity' and VERSION=1.0),
				907	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				908	((select ID from activity_spec where NAME='VNFUnsetInMaintFlagActivity' and VERSION=1.0),
				909	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				910	((select ID from activity_spec where NAME='VNFUpgradeBackupActivity' and VERSION=1.0),
				911	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				912	((select ID from activity_spec where NAME='VNFUpgradePostCheckActivity' and VERSION=1.0),
				913	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				914	((select ID from activity_spec where NAME='VNFUpgradePreCheckActivity' and VERSION=1.0),
				915	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				916	((select ID from activity_spec where NAME='VNFUpgradeSoftwareActivity' and VERSION=1.0),
				917	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output'));
				918
				919	INSERT INTO `user_parameters`(`NAME`,`PAYLOAD_LOCATION`,`LABEL`,`TYPE`,`DESCRIPTION`,`IS_REQUIRED`,`MAX_LENGTH`,`ALLOWABLE_CHARS`)
				920	VALUES
				921	('cloudOwner','cloudConfiguration','Cloud Owner','text','',1,7,''),
				922	('operations_timeout','userParams','Operations Timeout','text','',1,50,''),
				923	('existing_software_version','userParams','Existing Software Version','text','',1,50,''),
				924	('tenantId','cloudConfiguration','Tenant/Project ID','text','',1,36,''),
				925	('new_software_version','userParams','New Software Version','text','',1,50,''),
				926	('lcpCloudRegionId','cloudConfiguration','Cloud Region ID','text','',1,7,'');
				927
				928	INSERT INTO `activity_spec_to_user_parameters`(`ACTIVITY_SPEC_ID`,`USER_PARAMETERS_ID`)
				929	VALUES
				930	((select ID from activity_spec where NAME='VNFStopActivity' and VERSION=1.0),
				931	(select ID from user_parameters where NAME='lcpCloudRegionId')),
				932	((select ID from activity_spec where NAME='VNFStopActivity' and VERSION=1.0),
				933	(select ID from user_parameters where NAME='tenantId')),
				934	((select ID from activity_spec where NAME='VNFStartActivity' and VERSION=1.0),
				935	(select ID from user_parameters where NAME='lcpCloudRegionId')),
				936	((select ID from activity_spec where NAME='VNFStartActivity' and VERSION=1.0),
				937	(select ID from user_parameters where NAME='tenantId')),
				938	((select ID from activity_spec where NAME='VNFSnapShotActivity' and VERSION=1.0),
				939	(select ID from user_parameters where NAME='lcpCloudRegionId')),
				940	((select ID from activity_spec where NAME='VNFSnapShotActivity' and VERSION=1.0),
				941	(select ID from user_parameters where NAME='tenantId')),
				942	((select ID from activity_spec where NAME='VNFQuiesceTrafficActivity' and VERSION=1.0),
				943	(select ID from user_parameters where NAME='operations_timeout')),
				944	((select ID from activity_spec where NAME='VNFUpgradeBackupActivity' and VERSION=1.0),
				945	(select ID from user_parameters where NAME='existing_software_version')),
				946	((select ID from activity_spec where NAME='VNFUpgradeBackupActivity' and VERSION=1.0),
				947	(select ID from user_parameters where NAME='new_software_version')),
				948	((select ID from activity_spec where NAME='VNFUpgradePostCheckActivity' and VERSION=1.0),
				949	(select ID from user_parameters where NAME='existing_software_version')),
				950	((select ID from activity_spec where NAME='VNFUpgradePostCheckActivity' and VERSION=1.0),
				951	(select ID from user_parameters where NAME='new_software_version')),
				952	((select ID from activity_spec where NAME='VNFUpgradePreCheckActivity' and VERSION=1.0),
				953	(select ID from user_parameters where NAME='existing_software_version')),
				954	((select ID from activity_spec where NAME='VNFUpgradePreCheckActivity' and VERSION=1.0),
				955	(select ID from user_parameters where NAME='new_software_version')),
				956	((select ID from activity_spec where NAME='VNFUpgradeSoftwareActivity' and VERSION=1.0),
				957	(select ID from user_parameters where NAME='existing_software_version')),
				958	((select ID from activity_spec where NAME='VNFUpgradeSoftwareActivity' and VERSION=1.0),
				959	(select ID from user_parameters where NAME='new_software_version'));
Manamohan	9737ae1	2020-02-17 16:13:45 +0530	[diff] [blame]	960
				961	INSERT INTO bbname_selection_reference (CONTROLLER_ACTOR,SCOPE,ACTION,BB_NAME)
				962	VALUES
				963	('APPC', 'vfModule', 'healthCheck','GenericVnfHealthCheckBB'),
				964	('APPC', 'vfModule', 'configScaleOut','ConfigurationScaleOutBB'),
Kuleshov, Elena	d255e43	2020-04-16 11:02:28 -0400	[diff] [blame]	965	('APPC', 'vnf', 'healthCheck','GenericVnfHealthCheckBB');
				966
				967	INSERT INTO processing_flags (FLAG,VALUE,ENDPOINT,DESCRIPTION)
				968	VALUES
				969	('TESTFLAG', 'NO', 'TESTENDPOINT', 'TEST FLAG');