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

blob: 31f59203ca2a12faa926206957e8545908049ad9 [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'),
				269	('AssignAndActivateVpnBondingLinksBB', 'CUSTOM', 'CUSTOM'),
				270	('AvpnAssignServiceInstanceBB', 'CUSTOM', 'CUSTOM'),
				271	('CreateCustomerVpnBindingBB', 'CUSTOM', 'CUSTOM'),
				272	('SniroHoming', 'CUSTOM', 'CUSTOM'),
				273	('DeactivateAndUnassignVpnBondingLinksBB', 'CUSTOM', 'CUSTOM'),
				274	('DeactivateNetworkCollectionBB', 'CUSTOM', 'CUSTOM'),
				275	('AAICheckVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
				276	('AAISetVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
				277	('AAIUnsetVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
				278	('SDNOVnfHealthCheckBB', 'CUSTOM', 'CUSTOM'),
				279	('VNF-Macro-Replace', 'CUSTOM', 'CUSTOM'),
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	280	('HomingBB', 'CUSTOM', 'CUSTOM');
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	281
				282	INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
				283	('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')),
				284	('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')),
				285	('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete')),
				286	('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete')),
				287	('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				288	('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				289	('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				290	('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				291	('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign')),
				292	('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				293	('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				294	('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				295	('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				296	('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				297	('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				298	('Service-Macro-Activate', '7', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				299	('Service-Macro-Activate', '8', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate')),
				300	('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				301	('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				302	('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				303	('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				304	('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign')),
				305	('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				306	('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				307	('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				308	('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				309	('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				310	('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				311	('Service-Macro-Create', '7', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				312	('Service-Macro-Create', '8', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				313	('Service-Macro-Create', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				314	('Service-Macro-Create', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				315	('Service-Macro-Create', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				316	('Service-Macro-Create', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				317	('Service-Macro-Create', '13', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				318	('Service-Macro-Create', '14', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				319	('Service-Macro-Create', '15', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create')),
				320	('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				321	('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				322	('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				323	('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				324	('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				325	('Service-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				326	('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				327	('Service-Macro-Delete', '8', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				328	('Service-Macro-Delete', '9', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				329	('Service-Macro-Delete', '10', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				330	('Service-Macro-Delete', '11', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				331	('Service-Macro-Delete', '12', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				332	('Service-Macro-Delete', '13', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				333	('Service-Macro-Delete', '14', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
				334	('Network-Create', '1', 'AssignNetwork1802BB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
				335	('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
				336	('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create')),
				337	('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
				338	('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
				339	('Network-Delete', '3', 'UnassignNetwork1802BB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete')),
				340	('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create')),
				341	('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create')),
				342	('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete')),
				343	('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete')),
				344	('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				345	('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				346	('VNF-Macro-Recreate', '3', 'VNF-Macro-Replace', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				347	('VNF-Macro-Recreate', '4', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				348	('VNF-Macro-Recreate', '5', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate')),
				349	('VNF-Macro-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				350	('VNF-Macro-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				351	('VNF-Macro-Replace', '3', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				352	('VNF-Macro-Replace', '4', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				353	('VNF-Macro-Replace', '5', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				354	('VNF-Macro-Replace', '6', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace')),
				355	('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
				356	('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
				357	('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create')),
				358	('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
				359	('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
				360	('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete')),
				361	('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
				362	('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
				363	('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create')),
				364	('VFModule-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
				365	('VFModule-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
				366	('VFModule-Delete', '3', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete')),
				367	('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete')),
				368	('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete')),
				369	('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				370	('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				371	('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				372	('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				373	('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create')),
				374	('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
				375	('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
				376	('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]	377	('NetworkCollection-Macro-Delete', '4', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete')),
				378	('InstanceGroup-Create', '1', 'CreateInstanceGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'InstanceGroup-Create')),
				379	('InstanceGroup-Delete', '1', 'DeleteInstanceGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'InstanceGroup-Delete')),
				380	('InstanceGroupMembers-Add', '1', 'AddInstanceGroupMembersBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'InstanceGroupMembers-Add')),
				381	('InstanceGroupmembers-Remove', '1', 'RemoveInstanceGroupMembersBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'InstanceGroupMembers-Remove'));
				382
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	383
				384	INSERT INTO orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
				385	VALUES
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	386	('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				387	('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				388	('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				389	('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				390	('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
				391	('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
				392	('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
				393	('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
				394	('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
				395	('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
				396	('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				397	('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				398	('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				399	('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				400	('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
				401	('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
				402	('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
				403	('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
				404	('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
				405	('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
				406	('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				407	('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				408	('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				409	('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				410	('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
				411	('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
				412	('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
				413	('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
				414	('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
				415	('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
				416	('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
				417	('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
				418	('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
				419	('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
				420	('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
				421	('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
				422	('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
				423	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
				424	('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
				425	('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
				426	('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
				427	('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
				428	('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
				429	('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
				430	('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
				431	('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				432	('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				433	('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				434	('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				435	('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
				436	('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
				437	('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
				438	('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
				439	('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
				440	('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
				441	('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				442	('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				443	('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				444	('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				445	('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
				446	('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
				447	('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
				448	('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
				449	('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
				450	('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
				451	('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				452	('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				453	('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				454	('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				455	('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
				456	('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
				457	('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
				458	('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
				459	('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
				460	('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
				461	('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
				462	('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
				463	('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
				464	('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
				465	('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
				466	('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
				467	('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
				468	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
				469	('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
				470	('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
				471	('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
				472	('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
				473	('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
				474	('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
				475	('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
				476	('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				477	('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				478	('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				479	('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				480	('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
				481	('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				482	('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				483	('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				484	('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				485	('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
				486	('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
				487	('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
				488	('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
				489	('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
				490	('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
				491	('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
				492	('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
				493	('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
				494	('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
				495	('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
				496	('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				497	('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				498	('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				499	('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				500	('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
				501	('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				502	('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				503	('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				504	('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				505	('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
				506	('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
				507	('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
				508	('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
				509	('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
				510	('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
				511	('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
				512	('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
				513	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
				514	('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
				515	('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
				516	('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
				517	('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
				518	('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
				519	('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
				520	('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
				521	('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				522	('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				523	('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				524	('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				525	('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
				526	('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
				527	('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				528	('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
				529	('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				530	('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				531	('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				532	('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				533	('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				534	('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				535	('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				536	('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				537	('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				538	('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				539	('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				540	('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
				541	('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				542	('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				543	('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				544	('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				545	('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
				546	('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
				547	('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
				548	('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
				549	('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				550	('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				551	('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				552	('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				553	('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
				554	('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				555	('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
				556	('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
				557	('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
				558	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
				559	('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
				560	('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
				561	('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
				562	('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
				563	('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
				564	('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
				565	('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
				566	('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
				567	('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
				568	('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
				569	('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
				570	('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
				571	('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
				572	('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
				573	('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
				574	('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
				575	('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
				576	('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
				577	('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
				578	('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
				579	('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
				580	('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
				581	('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
				582	('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
				583	('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
				584	('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
				585	('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
				586	('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
				587	('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
				588	('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
				589	('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
				590	('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
				591	('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
				592	('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
				593	('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
				594	('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
				595	('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
				596	('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
				597	('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
				598	('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
				599	('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
				600	('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
				601	('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
				602	('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
				603	('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
				604	('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
				605	('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
				606	('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
				607	('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
				608	('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	609	('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
Benjamin, Max (mb388a)	61affc6	2018-11-05 11:00:36 -0500	[diff] [blame]	610	('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
				611	('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
				612	('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
				613	('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
				614	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
				615	('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
				616	('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
				617	('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
				618	('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
				619	('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
				620	('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
				621	('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
				622	('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
				623	('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
				624	('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
				625	('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
				626	('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
				627	('VF_MODULE', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
				628	('NETWORK', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'),
				629	('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
				630	('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
				631	('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
				632	('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
				633	('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
				634	('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
				635	('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
				636	('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
				637	('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
				638	('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
				639	('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
				640	('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
				641	('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
				642	('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
				643	('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
				644	('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
				645	('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
Benjamin, Max (mb388a)	5a6a6de	2018-07-30 15:56:09 -0400	[diff] [blame]	646	('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
				647	('CUSTOM', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
				648	('CUSTOM', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
				649	('CUSTOM', 'CREATED', 'CUSTOM', 'CONTINUE'),
				650	('CUSTOM', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
				651	('CUSTOM', 'PENDING', 'CUSTOM', 'CONTINUE'),
				652	('CUSTOM', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
				653	('CUSTOM', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
				654	('CUSTOM', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
				655	('CUSTOM', 'PRECREATED', 'CUSTOM', 'CONTINUE');
Benjamin, Max (mb388a)	a81aef2	2018-08-13 09:48:57 -0400	[diff] [blame]	656
Benjamin, Max (mb388a)	a81aef2	2018-08-13 09:48:57 -0400	[diff] [blame]	657	INSERT INTO `cloudify_managers` (`ID`, `CLOUDIFY_URL`, `USERNAME`, `PASSWORD`, `VERSION`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('mtn13', 'http://localhost:28090/v2.0', 'm93945', '93937EA01B94A10A49279D4572B48369', NULL, 'MSO_USER', '2018-07-17 14:05:08', '2018-07-17 14:05:08');
				658
Benjamin, Max (mb388a)	37547ac	2018-11-16 12:23:48 -0500	[diff] [blame]	659	INSERT INTO `identity_services` (`ID`, `IDENTITY_URL`, `MSO_ID`, `MSO_PASS`, `PROJECT_DOMAIN_NAME`, `USER_DOMAIN_NAME`, `ADMIN_TENANT`, `MEMBER_ROLE`, `TENANT_METADATA`, `IDENTITY_SERVER_TYPE`, `IDENTITY_AUTHENTICATION_TYPE`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('MTN13', 'http://localhost:28090/v2.0', 'm93945', '93937EA01B94A10A49279D4572B48369', NULL, NULL, 'admin', 'admin', 1, 'KEYSTONE', 'USERNAME_PASSWORD', 'MSO_USER', '2018-07-17 14:02:33', '2018-07-17 14:02:33');
Benjamin, Max (mb388a)	a81aef2	2018-08-13 09:48:57 -0400	[diff] [blame]	660
Prema Bhatt	474b175	2018-08-10 15:54:13 -0700	[diff] [blame]	661	INSERT INTO `cloud_sites` (`ID`, `REGION_ID`, `IDENTITY_SERVICE_ID`, `CLOUD_VERSION`, `CLLI`, `CLOUDIFY_ID`, `PLATFORM`, `ORCHESTRATOR`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('mtn13', 'mtn13', 'MTN13', '2.5', 'MDT13', 'mtn13', NULL, 'orchestrator', 'MSO_USER', '2018-07-17 14:06:28', '2018-07-17 14:06:28');
				662
				663	INSERT INTO `controller_selection_reference` (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`) VALUES
Rob Daugherty	add0df0	2018-08-30 14:26:55 -0400	[diff] [blame]	664	('vLoadBalancerMS/vLoadBalancerMS 0', 'APPC', 'ConfigScaleOut'),
				665	('vLoadBalancerMS/vLoadBalancerMS 0', 'APPC', 'HealthCheck');
Benjamin, Max (mb388a)	69455a2	2018-09-04 11:21:02 -0400	[diff] [blame]	666
				667	INSERT INTO `configuration`
				668	(`model_uuid`,
				669	`model_invariant_uuid`,
				670	`model_version`,
				671	`model_name`,
				672	`tosca_node_type`,
				673	`description`,
				674	`creation_timestamp`)
				675	VALUES ( 'c59a41ca-9b3b-11e8-98d0-529269fb1459',
				676	'15881e64-9b3c-11e8-98d0-529269fb1459',
				677	'testModelVersion',
				678	'testModelName',
				679	'testToscaModelType',
				680	'testConfigurationDescription',
				681	'2018-07-17 14:05:08' );
				682
				683
				684	INSERT INTO `vnfc_customization`
				685	(`model_customization_uuid`,
				686	`model_instance_name`,
				687	`model_uuid`,
				688	`model_invariant_uuid`,
				689	`model_version`,
				690	`model_name`,
				691	`tosca_node_type`,
				692	`description`,
				693	`creation_timestamp`)
				694	VALUES ( '9bcce658-9b37-11e8-98d0-529269fb1459',
				695	'testModelInstanceName',
				696	'b25735fe-9b37-11e8-98d0-529269fb1459',
				697	'ba7e6ef0-9b37-11e8-98d0-529269fb1459',
				698	'testModelVersion',
				699	'testModelName',
				700	'toscaNodeType',
				701	'testVnfcCustomizationDescription',
				702	'2018-07-17 14:05:08');
				703
				704	INSERT INTO `cvnfc_customization`
				705	(`id`,
				706	`model_customization_uuid`,
				707	`model_instance_name`,
				708	`model_uuid`,
				709	`model_invariant_uuid`,
				710	`model_version`,
				711	`model_name`,
				712	`tosca_node_type`,
				713	`description`,
				714	`nfc_function`,
				715	`nfc_naming_code`,
				716	`creation_timestamp`,
Benjamin, Max (mb388a)	69455a2	2018-09-04 11:21:02 -0400	[diff] [blame]	717	`vnfc_cust_model_customization_uuid`)
				718	VALUES ( '1',
				719	'9bcce658-9b37-11e8-98d0-529269fb1459',
				720	'testModelInstanceName',
				721	'b25735fe-9b37-11e8-98d0-529269fb1459',
				722	'ba7e6ef0-9b37-11e8-98d0-529269fb1459',
				723	'testModelVersion',
				724	'testModelName',
				725	'testToscaNodeType',
				726	'testCvnfcCustomzationDescription',
				727	'testNfcFunction',
				728	'testNfcNamingCode',
				729	'2018-07-17 14:05:08',
Benjamin, Max (mb388a)	69455a2	2018-09-04 11:21:02 -0400	[diff] [blame]	730	'9bcce658-9b37-11e8-98d0-529269fb1459');
				731
eeginux	53bb2f2	2019-03-09 00:57:00 +0000	[diff] [blame]	732	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
				733	('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');
				734
				735	insert into pnf_resource(orchestration_mode, description, creation_timestamp, model_uuid, model_invariant_uuid, model_version, model_name, tosca_node_type) values
				736	('', 'PNF routing', '2019-03-08 12:00:28', 'ff2ae348-214a-11e7-93ae-92361f002680', '2fff5b20-214b-11e7-93ae-92361f002680', '1.0', 'PNF resource', null);
				737
				738	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
				739	('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");
				740
				741	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]	742	('5df8b6de-2083-11e7-93ae-92361f002676', '68dc9a92-214c-11e7-93ae-92361f002680');
Elena Kuleshov	eeaa957	2019-04-08 01:17:53 -0400	[diff] [blame]	743
				744	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]	745	('5b0c4322-643d-4c9f-b184-4516049e99b1', 'testingWorkflow.bpmn', 'testingWorkflow', 'create', 1, 'Test Workflow', null, 'vnf', 'sdc');
Elena Kuleshov	fd4d683	2019-04-08 22:08:29 -0400	[diff] [blame]	746
				747	insert into vnf_resource_to_workflow(vnf_resource_model_uuid, workflow_id) values
				748	('ff2ae348-214a-11e7-93ae-92361f002671', '1');
				749
				750	insert into activity_spec(name, description, version) values
				751	('testActivity1', 'Test Activity 1', 1);
				752
				753	insert into workflow_activity_spec_sequence(workflow_id, activity_spec_id, seq_no) values
				754	(1, 1, 1);
Bonkur, Venkat (vb8416)	0091579	2019-04-10 21:10:01 -0400	[diff] [blame]	755
				756	INSERT INTO activity_spec (NAME, DESCRIPTION, VERSION)
				757	VALUES
				758	('VNFSetInMaintFlagActivity','Activity to Set InMaint Flag in A&AI',1.0),
				759	('VNFCheckPserversLockedFlagActivity','Activity Check Pservers Locked Flag VNF',1.0),
				760	('VNFCheckInMaintFlagActivity','Activity CheckIn Maint Flag on VNF',1.0),
				761	('VNFCheckClosedLoopDisabledFlagActivity','Activity Check Closed Loop Disabled Flag on VNF',1.0),
				762	('VNFSetClosedLoopDisabledFlagActivity','Activity Set Closed Loop Disabled Flag on VNF',1.0),
				763	('VNFUnsetClosedLoopDisabledFlagActivity','Activity Unset Closed Loop Disabled Flag on VNF',1.0),
				764	('VNFLockActivity','Activity Lock on VNF',1.0),
				765	('VNFUnlockActivity','Activity UnLock on VNF',1.0),
				766	('VNFStopActivity','Activity Stop on VNF',1.0),
				767	('VNFStartActivity','Activity Start on VNF',1.0),
				768	('VNFSnapShotActivity','Activity Snap Shot on VNF',1.0),
				769	('FlowCompleteActivity','Activity Complete on VNF',1.0),
				770	('PauseForManualTaskActivity','Activity Pause For Manual Task on VNF',1.0),
				771	('DistributeTrafficActivity','Activity Distribute Traffic on VNF',1.0),
				772	('DistributeTrafficCheckActivity','Activity Distribute Traffic Check on VNF',1.0),
				773	('VNFHealthCheckActivity','Activity Health Check on VNF',1.0),
				774	('VNFQuiesceTrafficActivity','Activity Quiesce Traffic on VNF',1.0),
				775	('VNFResumeTrafficActivity','Activity Resume Traffic on VNF',1.0),
				776	('VNFUnsetInMaintFlagActivity','Activity Unset InMaint Flag on VNF',1.0),
				777	('VNFUpgradeBackupActivity','Activity Upgrade Backup on VNF',1.0),
				778	('VNFUpgradePostCheckActivity','Activity Upgrade Post Check on VNF',1.0),
				779	('VNFUpgradePreCheckActivity','Activity Upgrade PreCheck on VNF',1.0),
				780	('VNFUpgradeSoftwareActivity','Activity UpgradeS oftware on VNF',1.0),
				781	('VnfInPlaceSoftwareUpdate','Activity InPlace Software Update on VNF',1.0);
				782
				783	INSERT INTO activity_spec_categories (NAME)
				784	VALUES ('VNF');
				785
				786	INSERT INTO activity_spec_to_activity_spec_categories(ACTIVITY_SPEC_ID, ACTIVITY_SPEC_CATEGORIES_ID)
				787	VALUES
				788	((select ID from activity_spec where NAME='VNFSetInMaintFlagActivity' and VERSION=1.0),
				789	(select ID from activity_spec_categories where NAME='VNF')),
				790	((select ID from activity_spec where NAME='VNFCheckPserversLockedFlagActivity' and VERSION=1.0),
				791	(select ID from activity_spec_categories where NAME='VNF')),
				792	((select ID from activity_spec where NAME='VNFCheckInMaintFlagActivity' and VERSION=1.0),
				793	(select ID from activity_spec_categories where NAME='VNF')),
				794	((select ID from activity_spec where NAME='VNFCheckClosedLoopDisabledFlagActivity' and VERSION=1.0),
				795	(select ID from activity_spec_categories where NAME='VNF')),
				796	((select ID from activity_spec where NAME='VNFSetClosedLoopDisabledFlagActivity' and VERSION=1.0),
				797	(select ID from activity_spec_categories where NAME='VNF')),
				798	((select ID from activity_spec where NAME='VNFUnsetClosedLoopDisabledFlagActivity' and VERSION=1.0),
				799	(select ID from activity_spec_categories where NAME='VNF')),
				800	((select ID from activity_spec where NAME='VNFLockActivity' and VERSION=1.0),
				801	(select ID from activity_spec_categories where NAME='VNF')),
				802	((select ID from activity_spec where NAME='VNFUnlockActivity' and VERSION=1.0),
				803	(select ID from activity_spec_categories where NAME='VNF')),
				804	((select ID from activity_spec where NAME='VNFStopActivity' and VERSION=1.0),
				805	(select ID from activity_spec_categories where NAME='VNF')),
				806	((select ID from activity_spec where NAME='VNFStartActivity' and VERSION=1.0),
				807	(select ID from activity_spec_categories where NAME='VNF')),
				808	((select ID from activity_spec where NAME='VNFSnapShotActivity' and VERSION=1.0),
				809	(select ID from activity_spec_categories where NAME='VNF')),
				810	((select ID from activity_spec where NAME='FlowCompleteActivity' and VERSION=1.0),
				811	(select ID from activity_spec_categories where NAME='VNF')),
				812	((select ID from activity_spec where NAME='PauseForManualTaskActivity' and VERSION=1.0),
				813	(select ID from activity_spec_categories where NAME='VNF')),
				814	((select ID from activity_spec where NAME='DistributeTrafficActivity' and VERSION=1.0),
				815	(select ID from activity_spec_categories where NAME='VNF')),
				816	((select ID from activity_spec where NAME='DistributeTrafficCheckActivity' and VERSION=1.0),
				817	(select ID from activity_spec_categories where NAME='VNF')),
				818	((select ID from activity_spec where NAME='VNFHealthCheckActivity' and VERSION=1.0),
				819	(select ID from activity_spec_categories where NAME='VNF')),
				820	((select ID from activity_spec where NAME='VNFQuiesceTrafficActivity' and VERSION=1.0),
				821	(select ID from activity_spec_categories where NAME='VNF')),
				822	((select ID from activity_spec where NAME='VNFResumeTrafficActivity' and VERSION=1.0),
				823	(select ID from activity_spec_categories where NAME='VNF')),
				824	((select ID from activity_spec where NAME='VNFUnsetInMaintFlagActivity' and VERSION=1.0),
				825	(select ID from activity_spec_categories where NAME='VNF')),
				826	((select ID from activity_spec where NAME='VNFUpgradeBackupActivity' and VERSION=1.0),
				827	(select ID from activity_spec_categories where NAME='VNF')),
				828	((select ID from activity_spec where NAME='VNFUpgradePostCheckActivity' and VERSION=1.0),
				829	(select ID from activity_spec_categories where NAME='VNF')),
				830	((select ID from activity_spec where NAME='VNFUpgradePreCheckActivity' and VERSION=1.0),
				831	(select ID from activity_spec_categories where NAME='VNF')),
				832	((select ID from activity_spec where NAME='VNFUpgradeSoftwareActivity' and VERSION=1.0),
				833	(select ID from activity_spec_categories where NAME='VNF')),
				834	((select ID from activity_spec where NAME='VnfInPlaceSoftwareUpdate' and VERSION=1.0),
				835	(select ID from activity_spec_categories where NAME='VNF'));
				836
				837	INSERT INTO activity_spec_parameters (NAME, TYPE, DIRECTION, DESCRIPTION)
				838	VALUES('WorkflowException','WorkflowException','output','Description');
				839
				840	INSERT INTO activity_spec_to_activity_spec_parameters( ACTIVITY_SPEC_ID, ACTIVITY_SPEC_PARAMETERS_ID)
				841	VALUES
				842	((select ID from activity_spec where NAME='VNFSetInMaintFlagActivity' and VERSION=1.0),
				843	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				844	((select ID from activity_spec where NAME='VNFCheckPserversLockedFlagActivity' and VERSION=1.0),
				845	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				846	((select ID from activity_spec where NAME='VNFCheckInMaintFlagActivity' and VERSION=1.0),
				847	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				848	((select ID from activity_spec where NAME='VNFCheckClosedLoopDisabledFlagActivity' and VERSION=1.0),
				849	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				850	((select ID from activity_spec where NAME='VNFSetClosedLoopDisabledFlagActivity' and VERSION=1.0),
				851	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				852	((select ID from activity_spec where NAME='VNFUnsetClosedLoopDisabledFlagActivity' and VERSION=1.0),
				853	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				854	((select ID from activity_spec where NAME='VNFLockActivity' and VERSION=1.0),
				855	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				856	((select ID from activity_spec where NAME='VNFUnlockActivity' and VERSION=1.0),
				857	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				858	((select ID from activity_spec where NAME='VNFStopActivity' and VERSION=1.0),
				859	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				860	((select ID from activity_spec where NAME='VNFStartActivity' and VERSION=1.0),
				861	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				862	((select ID from activity_spec where NAME='VNFSnapShotActivity' and VERSION=1.0),
				863	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				864	((select ID from activity_spec where NAME='FlowCompleteActivity' and VERSION=1.0),
				865	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				866	((select ID from activity_spec where NAME='PauseForManualTaskActivity' and VERSION=1.0),
				867	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				868	((select ID from activity_spec where NAME='DistributeTrafficActivity' and VERSION=1.0),
				869	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				870	((select ID from activity_spec where NAME='DistributeTrafficCheckActivity' and VERSION=1.0),
				871	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output')),
				872	((select ID from activity_spec where NAME='VNFHealthCheckActivity' 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='VNFQuiesceTrafficActivity' 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='VNFResumeTrafficActivity' 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='VNFUnsetInMaintFlagActivity' 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='VNFUpgradeBackupActivity' 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='VNFUpgradePostCheckActivity' 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='VNFUpgradePreCheckActivity' 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='VNFUpgradeSoftwareActivity' and VERSION=1.0),
				887	(select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='output'));
				888
				889	INSERT INTO `user_parameters`(`NAME`,`PAYLOAD_LOCATION`,`LABEL`,`TYPE`,`DESCRIPTION`,`IS_REQUIRED`,`MAX_LENGTH`,`ALLOWABLE_CHARS`)
				890	VALUES
				891	('cloudOwner','cloudConfiguration','Cloud Owner','text','',1,7,''),
				892	('operations_timeout','userParams','Operations Timeout','text','',1,50,''),
				893	('existing_software_version','userParams','Existing Software Version','text','',1,50,''),
				894	('tenantId','cloudConfiguration','Tenant/Project ID','text','',1,36,''),
				895	('new_software_version','userParams','New Software Version','text','',1,50,''),
				896	('lcpCloudRegionId','cloudConfiguration','Cloud Region ID','text','',1,7,'');
				897
				898	INSERT INTO `activity_spec_to_user_parameters`(`ACTIVITY_SPEC_ID`,`USER_PARAMETERS_ID`)
				899	VALUES
				900	((select ID from activity_spec where NAME='VNFStopActivity' and VERSION=1.0),
				901	(select ID from user_parameters where NAME='lcpCloudRegionId')),
				902	((select ID from activity_spec where NAME='VNFStopActivity' and VERSION=1.0),
				903	(select ID from user_parameters where NAME='tenantId')),
				904	((select ID from activity_spec where NAME='VNFStartActivity' and VERSION=1.0),
				905	(select ID from user_parameters where NAME='lcpCloudRegionId')),
				906	((select ID from activity_spec where NAME='VNFStartActivity' and VERSION=1.0),
				907	(select ID from user_parameters where NAME='tenantId')),
				908	((select ID from activity_spec where NAME='VNFSnapShotActivity' and VERSION=1.0),
				909	(select ID from user_parameters where NAME='lcpCloudRegionId')),
				910	((select ID from activity_spec where NAME='VNFSnapShotActivity' and VERSION=1.0),
				911	(select ID from user_parameters where NAME='tenantId')),
				912	((select ID from activity_spec where NAME='VNFQuiesceTrafficActivity' and VERSION=1.0),
				913	(select ID from user_parameters where NAME='operations_timeout')),
				914	((select ID from activity_spec where NAME='VNFUpgradeBackupActivity' and VERSION=1.0),
				915	(select ID from user_parameters where NAME='existing_software_version')),
				916	((select ID from activity_spec where NAME='VNFUpgradeBackupActivity' and VERSION=1.0),
				917	(select ID from user_parameters where NAME='new_software_version')),
				918	((select ID from activity_spec where NAME='VNFUpgradePostCheckActivity' and VERSION=1.0),
				919	(select ID from user_parameters where NAME='existing_software_version')),
				920	((select ID from activity_spec where NAME='VNFUpgradePostCheckActivity' and VERSION=1.0),
				921	(select ID from user_parameters where NAME='new_software_version')),
				922	((select ID from activity_spec where NAME='VNFUpgradePreCheckActivity' and VERSION=1.0),
				923	(select ID from user_parameters where NAME='existing_software_version')),
				924	((select ID from activity_spec where NAME='VNFUpgradePreCheckActivity' and VERSION=1.0),
				925	(select ID from user_parameters where NAME='new_software_version')),
				926	((select ID from activity_spec where NAME='VNFUpgradeSoftwareActivity' and VERSION=1.0),
				927	(select ID from user_parameters where NAME='existing_software_version')),
				928	((select ID from activity_spec where NAME='VNFUpgradeSoftwareActivity' and VERSION=1.0),
				929	(select ID from user_parameters where NAME='new_software_version'));