================= tosca =======================

INSERT INTO catalogdb.tosca_csar
(ARTIFACT_UUID, NAME, VERSION, ARTIFACT_CHECKSUM, URL, DESCRIPTION, CREATION_TIMESTAMP)
VALUES('8e1c39f0-623c-422f-85a0-459315dff8fc', 'service-Sotnvpninfraservice-csar.csar', '1', 'ODQ3YzMyZDA1OGI5ZWU3YTlkY2M2MmY4NjBkZDMxMmM=', '/sdc/v1/catalog/services/SOTNVPNInfraService/1.0/artifacts/service-Sotnvpninfraservice-csar.csar', 'TOSCA definition package of the asset', '2018-09-17 10:14:22.000');



INSERT INTO catalogdb.tosca_csar
(ARTIFACT_UUID, NAME, VERSION, ARTIFACT_CHECKSUM, URL, DESCRIPTION, CREATION_TIMESTAMP)
VALUES('950c9dcd-d1d2-4a93-a11e-fb6e2668954f', 'service-Siteservice-csar.csar', '1', 'ODQ3YzMyZDA1OGI5ZWU3YTlkY2M2MmY4NjBkZDMxMmM=', '/sdc/v1/catalog/services/Siteservice/1.0/artifacts/service-Siteservice-csar.csar', 'TOSCA definition package of the asset', '2018-09-17 10:14:22.000');

INSERT INTO catalogdb.tosca_csar
(ARTIFACT_UUID, NAME, VERSION, ARTIFACT_CHECKSUM, URL, DESCRIPTION, CREATION_TIMESTAMP)
VALUES('456efd70-6072-45fe-b049-4148679cfadb', 'service-Sdwanvpninfraservice-csar.csar', '1', 'ODQ3YzMyZDA1OGI5ZWU3YTlkY2M2MmY4NjBkZDMxMmM=', '/sdc/v1/catalog/services/SDWANVPNInfraService/1.0/artifacts/service-Sdwanvpninfraservice-csar.csar', 'TOSCA definition package of the asset', '2018-09-17 10:14:22.000');

================== service ==========================

INSERT into catalogdb.service
(MODEL_UUID, MODEL_NAME, MODEL_VERSION, DESCRIPTION, TOSCA_CSAR_ARTIFACT_UUID, CREATION_TIMESTAMP, MODEL_INVARIANT_UUID, SERVICE_CATEGORY, SERVICE_TYPE, SERVICE_ROLE, ENVIRONMENT_CONTEXT, WORKLOAD_CONTEXT)
VALUES('0bad8c92-7d22-49f0-b092-b64e6ca564a7', 'SOTNVPNInfraService', '1.0', 'SOTNVPNInfraService', '8e1c39f0-623c-422f-85a0-459315dff8fc', '2018-09-17 10:14:22.000', '69161960-515b-4bf3-91f1-313b813f5e1d', 'E2E Service', '', '', 'General_Revenue-Bearing', 'Production');

INSERT into catalogdb.service
(MODEL_UUID, MODEL_NAME, MODEL_VERSION, DESCRIPTION, TOSCA_CSAR_ARTIFACT_UUID, CREATION_TIMESTAMP, MODEL_INVARIANT_UUID, SERVICE_CATEGORY, SERVICE_TYPE, SERVICE_ROLE, ENVIRONMENT_CONTEXT, WORKLOAD_CONTEXT)
VALUES('4b7d8d01-60b6-46f7-9572-ad2c142d6acb', 'SiteService', '1.0', 'SiteService', '950c9dcd-d1d2-4a93-a11e-fb6e2668954f', '2018-09-17 10:14:22.000', '6f8fcc57-74b9-44d6-afd5-dfbbffd63c03', 'E2E Service', '', '', 'General_Revenue-Bearing', 'Production');

INSERT into catalogdb.service
(MODEL_UUID, MODEL_NAME, MODEL_VERSION, DESCRIPTION, TOSCA_CSAR_ARTIFACT_UUID, CREATION_TIMESTAMP, MODEL_INVARIANT_UUID, SERVICE_CATEGORY, SERVICE_TYPE, SERVICE_ROLE, ENVIRONMENT_CONTEXT, WORKLOAD_CONTEXT)
VALUES('633fbce8-bb0e-41c1-b7e6-c52744144baf', 'SDWANVPNInfraService', '1.0', 'SDWANVPNInfraService', '456efd70-6072-45fe-b049-4148679cfadb', '2018-09-17 10:14:22.000', 'e02147e2-65e1-4ac3-b5ca-7d7a60ca9cf4', 'E2E Service', '', '', 'General_Revenue-Bearing', 'Production');

====================== sotn resource ======================


INSERT INTO catalogdb.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, RESOURCE_CATEGORY, RESOURCE_SUB_CATEGORY)
VALUES('313cea40-b174-4440-8bff-c6d4897de740', 'SOTNConnectivity', '471dbec3-ec15-491d-8599-058c9fe179ad', 'Represents a sotn Connectivity', '', '', '', 'org.openecomp.resource.SOTN.Connectivity', '', '', 'HEAT', CURRENT_TIMESTAMP, '', '');

fk_network_resource__heat_template1
fk_network_resource__temp_network_heat_template_lookup__mod_nm1


INSERT INTO catalogdb.network_resource_customization
(MODEL_CUSTOMIZATION_UUID, MODEL_INSTANCE_NAME, NETWORK_TECHNOLOGY, NETWORK_TYPE, NETWORK_ROLE, NETWORK_SCOPE, CREATION_TIMESTAMP, NETWORK_RESOURCE_MODEL_UUID)
VALUES('40c93581-4274-4060-b70f-6cba1e546e53', 'SOTNConnectivity', '', '', '', '', CURRENT_TIMESTAMP, '313cea40-b174-4440-8bff-c6d4897de740');

INSERT INTO catalogdb.network_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('0bad8c92-7d22-49f0-b092-b64e6ca564a7', '40c93581-4274-4060-b70f-6cba1e546e53');



=============================sdwan resource========================================


INSERT INTO catalogdb.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, RESOURCE_CATEGORY, RESOURCE_SUB_CATEGORY)
VALUES('32fef2b5-bffe-4997-b011-b5dee8ec78ca', 'SDWANConnectivity', '7b4e2f58-f6b4-431f-86af-2d6c7107e866', 'Represents SDWAN Connectivity.', '', '', '', 'org.openecomp.resource.SDWAN.Connectivity', '', '', 'HEAT', CURRENT_TIMESTAMP, '', '');

INSERT INTO catalogdb.network_resource_customization
(MODEL_CUSTOMIZATION_UUID, MODEL_INSTANCE_NAME, NETWORK_TECHNOLOGY, NETWORK_TYPE, NETWORK_ROLE, NETWORK_SCOPE, CREATION_TIMESTAMP, NETWORK_RESOURCE_MODEL_UUID)
VALUES('c05de2cd-9a3e-47c4-bf22-ab7ec46658c9', 'SDWANConnectivity', '', '', '', '', CURRENT_TIMESTAMP, '32fef2b5-bffe-4997-b011-b5dee8ec78ca');

INSERT INTO catalogdb.network_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('633fbce8-bb0e-41c1-b7e6-c52744144baf', 'c05de2cd-9a3e-47c4-bf22-ab7ec46658c9');
==============================site service resource ===========================================


INSERT INTO catalogdb.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, RESOURCE_CATEGORY, RESOURCE_SUB_CATEGORY)
VALUES('HEAT', '', CURRENT_TIMESTAMP, '', '', '', '', '', '', '', '', '', '');

INSERT INTO catalogdb.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, INSTANCE_GROUP_MODEL_UUID)
VALUES('', '', 0, 0, 0, '', '', '', '', CURRENT_TIMESTAMP, '', '', '');

INSERT INTO catalogdb.vnf_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('', '');

INSERT INTO catalogdb.vnf_recipe
(NF_ROLE, `ACTION`, SERVICE_TYPE, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, VNF_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP, VF_MODULE_ID)
VALUES('', '', '', '', '', '', '', 0, CURRENT_TIMESTAMP, '');


== resource table
INSERT INTO catalogdb.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, RESOURCE_CATEGORY, RESOURCE_SUB_CATEGORY)
VALUES('HEAT', 'site wan vf', CURRENT_TIMESTAMP, 'c0d8e2a7-1e31-430e-a9e1-76822114b80f', '', '', 'fb2d8c05-6dec-4cdf-9cd6-a22a0ba2556f', '1.0', 'SiteWANVF', 'org.openecomp.resource.vf.Sitewanvf', '', 'Configuration', 'Configuration');

fk_vnf_resource__heat_template1

INSERT INTO catalogdb.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, RESOURCE_CATEGORY, RESOURCE_SUB_CATEGORY)
VALUES('HEAT', 'deviceVF', CURRENT_TIMESTAMP, 'd94f359a-dbca-40ec-85a9-9b0a09ec0f2f', '', '', '998a1fb9-86c8-405d-bb43-fa472276fd42', '1.0', 'deviceVF', 'org.openecomp.resource.vf.Devicevf', '', 'Configuration', 'Configuration');


INSERT INTO catalogdb.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, RESOURCE_CATEGORY, RESOURCE_SUB_CATEGORY)
VALUES('HEAT', 'siteVF', CURRENT_TIMESTAMP, '4d345e9f-763b-4941-b4bc-b775cca3f108', '', '', '9a309f1c-9cc1-409b-b9b5-6646ba95ee23', '1.0', 'siteVF', 'org.openecomp.resource.vf.Sitevf', '', 'Configuration', 'Configuration');

(duplicate)
INSERT INTO catalogdb.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, RESOURCE_CATEGORY, RESOURCE_SUB_CATEGORY)
VALUES('HEAT', 'site wan vf', CURRENT_TIMESTAMP, 'c0d8e2a7-1e31-430e-a9e1-76822114b80f', '', '', 'fb2d8c05-6dec-4cdf-9cd6-a22a0ba2556f', '1.0', 'SiteWANVF', 'org.openecomp.resource.vf.Sitewanvf', '', 'Configuration', 'Configuration');



== vnf resource customization

INSERT INTO catalogdb.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, INSTANCE_GROUP_MODEL_UUID)
VALUES('58f0efbc-e9f0-4635-b97d-464e6f93bbff', 'mpls', 0, 0, 0, 'VF', '', '', '', CURRENT_TIMESTAMP, 'c0d8e2a7-1e31-430e-a9e1-76822114b80f', '', '');


INSERT INTO catalogdb.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, INSTANCE_GROUP_MODEL_UUID)
VALUES('596d3984-2929-49e1-9d43-cb2bc71e9dde', 'deviceVF', 0, 0, 0, 'VF', '', '', '', CURRENT_TIMESTAMP, 'd94f359a-dbca-40ec-85a9-9b0a09ec0f2f', '', '');


INSERT INTO catalogdb.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, INSTANCE_GROUP_MODEL_UUID)
VALUES('b4822f64-7295-4e51-a535-479828ed4959', 'siteVF', 0, 0, 0, 'VF', '', '', '', CURRENT_TIMESTAMP, '4d345e9f-763b-4941-b4bc-b775cca3f108', '', '');


INSERT INTO catalogdb.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, INSTANCE_GROUP_MODEL_UUID)
VALUES('f04e49be-c99e-484b-9840-10a086608164', 'internet', 0, 0, 0, 'VF', '', '', '', CURRENT_TIMESTAMP, 'c0d8e2a7-1e31-430e-a9e1-76822114b80f', '', '');




=== vnf customization to service ===

INSERT INTO catalogdb.vnf_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('4b7d8d01-60b6-46f7-9572-ad2c142d6acb', '58f0efbc-e9f0-4635-b97d-464e6f93bbff');


INSERT INTO catalogdb.vnf_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('4b7d8d01-60b6-46f7-9572-ad2c142d6acb', '596d3984-2929-49e1-9d43-cb2bc71e9dde');


INSERT INTO catalogdb.vnf_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('4b7d8d01-60b6-46f7-9572-ad2c142d6acb', 'b4822f64-7295-4e51-a535-479828ed4959');


INSERT INTO catalogdb.vnf_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('4b7d8d01-60b6-46f7-9572-ad2c142d6acb', 'f04e49be-c99e-484b-9840-10a086608164');



=== vnf receiope  ====


INSERT INTO catalogdb.vnf_recipe
(NF_ROLE, `ACTION`, SERVICE_TYPE, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, VNF_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP, VF_MODULE_ID)
VALUES('SiteWANVF', 'createInstance	', '', '1.0', 'site wan vf', '/mso/async/services/CreateSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP, 'c0d8e2a7-1e31-430e-a9e1-76822114b80f');

INSERT INTO catalogdb.vnf_recipe
(NF_ROLE, `ACTION`, SERVICE_TYPE, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, VNF_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP, VF_MODULE_ID)
VALUES('SiteWANVF', 'deleteInstance	', '', '1.0', 'site wan vf', '/mso/async/services/DeleteSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP, 'c0d8e2a7-1e31-430e-a9e1-76822114b80f');




INSERT INTO catalogdb.vnf_recipe
(NF_ROLE, `ACTION`, SERVICE_TYPE, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, VNF_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP, VF_MODULE_ID)
VALUES('deviceVF', 'createInstance	', '', '1.0', 'deviceVF', '/mso/async/services/CreateSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP, 'd94f359a-dbca-40ec-85a9-9b0a09ec0f2f');

INSERT INTO catalogdb.vnf_recipe
(NF_ROLE, `ACTION`, SERVICE_TYPE, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, VNF_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP, VF_MODULE_ID)
VALUES('deviceVF', 'deleteInstance	', '', '1.0', 'deviceVF', '/mso/async/services/DeleteSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP, 'd94f359a-dbca-40ec-85a9-9b0a09ec0f2f');




INSERT INTO catalogdb.vnf_recipe
(NF_ROLE, `ACTION`, SERVICE_TYPE, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, VNF_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP, VF_MODULE_ID)
VALUES('siteVF', 'createInstance', '', '1.0', 'siteVF', '/mso/async/services/CreateSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP, '4d345e9f-763b-4941-b4bc-b775cca3f108');

INSERT INTO catalogdb.vnf_recipe
(NF_ROLE, `ACTION`, SERVICE_TYPE, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, VNF_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP, VF_MODULE_ID)
VALUES('siteVF', 'deleteInstance', '', '1.0', 'siteVF', '/mso/async/services/DeleteSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP, '4d345e9f-763b-4941-b4bc-b775cca3f108');



============ allotted resouce ======================


INSERT INTO catalogdb.allotted_resource
(MODEL_UUID, MODEL_INVARIANT_UUID, MODEL_VERSION, MODEL_NAME, TOSCA_NODE_TYPE, SUBCATEGORY, DESCRIPTION, CREATION_TIMESTAMP)
VALUES('70ac94d9-fc53-41a0-bd55-06e003ec15a1', 'd5620297-dacd-4637-a5d2-a2f4b48f3683', '2.0', 'sotnvpnattachmentvF', 'org.openecomp.resource.vf.Sotnvpnattachmentvf', 'Allotted Resource', 'sotnvpnattachmentvF', CURRENT_TIMESTAMP);

INSERT INTO catalogdb.allotted_resource
(MODEL_UUID, MODEL_INVARIANT_UUID, MODEL_VERSION, MODEL_NAME, TOSCA_NODE_TYPE, SUBCATEGORY, DESCRIPTION, CREATION_TIMESTAMP)
VALUES('f60b49ef-bffa-4665-bbc2-84714cc11860', '9184a3bf-4df6-4e98-a45b-9240abfe1866', '2.0', 'sdwanvpnattachmentVF', 'org.openecomp.resource.vf.Sdwanvpnattachmentvf', 'Allotted Resource', 'sdwanvpnattachmentVF', CURRENT_TIMESTAMP);





INSERT INTO catalogdb.allotted_resource_customization
(MODEL_CUSTOMIZATION_UUID, MODEL_INSTANCE_NAME, PROVIDING_SERVICE_MODEL_UUID, PROVIDING_SERVICE_MODEL_INVARIANT_UUID, PROVIDING_SERVICE_MODEL_NAME, TARGET_NETWORK_ROLE, NF_TYPE, NF_ROLE, NF_FUNCTION, NF_NAMING_CODE, MIN_INSTANCES, MAX_INSTANCES, AR_MODEL_UUID, CREATION_TIMESTAMP)
VALUES('aff54a65-9ae7-44ff-8949-efa75bbb54a0', 'sotnvpnattachmentvF', '4b7d8d01-60b6-46f7-9572-ad2c142d6acb', '6f8fcc57-74b9-44d6-afd5-dfbbffd63c03', 'SiteService', '', '', '', '', '', 0, 0, '70ac94d9-fc53-41a0-bd55-06e003ec15a1', CURRENT_TIMESTAMP);

INSERT INTO catalogdb.allotted_resource_customization
(MODEL_CUSTOMIZATION_UUID, MODEL_INSTANCE_NAME, PROVIDING_SERVICE_MODEL_UUID, PROVIDING_SERVICE_MODEL_INVARIANT_UUID, PROVIDING_SERVICE_MODEL_NAME, TARGET_NETWORK_ROLE, NF_TYPE, NF_ROLE, NF_FUNCTION, NF_NAMING_CODE, MIN_INSTANCES, MAX_INSTANCES, AR_MODEL_UUID, CREATION_TIMESTAMP)
VALUES('7c2908cd-612a-4929-9a16-083488069e14', 'sdwanvpnattachmentVF', '4b7d8d01-60b6-46f7-9572-ad2c142d6acb', '6f8fcc57-74b9-44d6-afd5-dfbbffd63c03', 'SiteService', '', '', '', '', '', 0, 0, 'f60b49ef-bffa-4665-bbc2-84714cc11860', CURRENT_TIMESTAMP);



INSERT INTO catalogdb.allotted_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('4b7d8d01-60b6-46f7-9572-ad2c142d6acb', 'aff54a65-9ae7-44ff-8949-efa75bbb54a0');

INSERT INTO catalogdb.allotted_resource_customization_to_service
(SERVICE_MODEL_UUID, RESOURCE_MODEL_CUSTOMIZATION_UUID)
VALUES('4b7d8d01-60b6-46f7-9572-ad2c142d6acb', '7c2908cd-612a-4929-9a16-083488069e14');



INSERT INTO catalogdb.ar_recipe
(MODEL_NAME, `ACTION`, VERSION_STR, SERVICE_TYPE, DESCRIPTION, ORCHESTRATION_URI, AR_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP)
VALUES('sotnvpnattachmentvF', 'createInstance', '2.0', 'VF', 'sotnvpnattachmentvF', '/mso/async/services/CreateSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP);

INSERT INTO catalogdb.ar_recipe
(MODEL_NAME, `ACTION`, VERSION_STR, SERVICE_TYPE, DESCRIPTION, ORCHESTRATION_URI, AR_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP)
VALUES('sotnvpnattachmentvF', 'deleteInstance', '2.0', 'VF', 'sotnvpnattachmentvF', '/mso/async/services/DeleteSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP);


INSERT INTO catalogdb.ar_recipe
(MODEL_NAME, `ACTION`, VERSION_STR, SERVICE_TYPE, DESCRIPTION, ORCHESTRATION_URI, AR_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP)
VALUES('sdwanvpnattachmentVF', 'createInstance', '2.0', 'VF', 'sdwanvpnattachmentVF', '/mso/async/services/CreateSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP);

INSERT INTO catalogdb.ar_recipe
(MODEL_NAME, `ACTION`, VERSION_STR, SERVICE_TYPE, DESCRIPTION, ORCHESTRATION_URI, AR_PARAM_XSD, RECIPE_TIMEOUT, CREATION_TIMESTAMP)
VALUES('sdwanvpnattachmentVF', 'deleteInstance', '2.0', 'VF', 'sdwanvpnattachmentVF', '/mso/async/services/DeleteSDNCNetworkResource', '', 180, CURRENT_TIMESTAMP);