3 ALTER TABLE collection_resource_customization
4 ADD FOREIGN KEY ( CR_MODEL_UUID)
5 REFERENCES collection_resource(MODEL_UUID)
8 ALTER TABLE vnf_resource_customization
10 INSTANCE_GROUP_MODEL_UUID varchar(200);
13 ALTER TABLE instance_group
14 ADD FOREIGN KEY ( CR_MODEL_UUID)
15 REFERENCES collection_resource(MODEL_UUID)
19 ALTER TABLE collection_resource_customization_to_service
20 ADD FOREIGN KEY (service_model_uuid)
21 REFERENCES service(MODEL_UUID)
24 ALTER TABLE allotted_resource_customization_to_service
25 ADD FOREIGN KEY (service_model_uuid)
26 REFERENCES service(MODEL_UUID)
30 ALTER TABLE vnf_resource_customization_to_service
31 ADD FOREIGN KEY (service_model_uuid)
32 REFERENCES service(MODEL_UUID)
36 ALTER TABLE network_resource_customization_to_service
37 ADD FOREIGN KEY (service_model_uuid)
38 REFERENCES service(MODEL_UUID)
42 ALTER TABLE network_resource_customization_to_service
43 ADD FOREIGN KEY (resource_model_customization_uuid)
44 REFERENCES network_resource_customization(model_customization_uuid)
47 ALTER TABLE vnf_resource_customization_to_service
48 ADD FOREIGN KEY (resource_model_customization_uuid)
49 REFERENCES vnf_resource_customization(model_customization_uuid)
52 ALTER TABLE allotted_resource_customization_to_service
53 ADD FOREIGN KEY (resource_model_customization_uuid)
54 REFERENCES allotted_resource_customization(model_customization_uuid)
57 ALTER TABLE collection_resource_customization_to_service
58 ADD FOREIGN KEY (resource_model_customization_uuid)
59 REFERENCES collection_resource_customization(model_customization_uuid)
62 INSERT INTO network_resource_customization_to_service SELECT service_model_uuid,resource_model_customization_uuid
63 FROM service_to_resource_customizations WHERE model_type = 'network' and service_model_uuid in(select model_uuid from service)
64 AND resource_model_customization_uuid in ( SELECT MODEL_CUSTOMIZATION_UUID from network_resource_customization);
66 INSERT INTO allotted_resource_customization_to_service SELECT service_model_uuid,resource_model_customization_uuid
67 FROM service_to_resource_customizations WHERE model_type = 'allottedResource' and service_model_uuid in(select model_uuid from service)
68 AND resource_model_customization_uuid in ( SELECT MODEL_CUSTOMIZATION_UUID from allotted_resource_customization);
70 INSERT INTO vnf_resource_customization_to_service SELECT service_model_uuid,resource_model_customization_uuid
71 FROM service_to_resource_customizations WHERE model_type = 'vnf' and service_model_uuid in(select model_uuid from service)
72 AND resource_model_customization_uuid in ( SELECT MODEL_CUSTOMIZATION_UUID from vnf_resource_customization);
74 DROP TABLE service_to_resource_customizations;
77 INSERT INTO vnf_recipe (VNF_TYPE, ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
79 ('GR-API-DEFAULT', 'createInstance', '1', 'Gr api recipe to create vnf', '/mso/async/services/WorkflowActionBB', 180),
80 ('GR-API-DEFAULT', 'deleteInstance', '1', 'Gr api recipe to delete vnf', '/mso/async/services/WorkflowActionBB', 180),
81 ('GR-API-DEFAULT', 'updateInstance', '1', 'Gr api recipe to update vnf', '/mso/async/services/WorkflowActionBB', 180),
82 ('GR-API-DEFAULT', 'replaceInstance', '1', 'Gr api recipe to replace vnf', '/mso/async/services/WorkflowActionBB', 180),
83 ('GR-API-DEFAULT', 'inPlaceSoftwareUpdate', '1', 'Gr api recipe to do an in place software update', '/mso/async/services/WorkflowActionBB', 180),
84 ('GR-API-DEFAULT', 'applyUpdatedConfig', '1', 'Gr api recipe to apply updated config', '/mso/async/services/WorkflowActionBB', 180);
87 SET vnf_type = 'VNF-API-DEFAULT'
88 WHERE vnf_type = 'VID_DEFAULT';
91 SET description = 'Vnf api recipe to create vnf'
92 WHERE description = 'VID_DEFAULT recipe to create VNF if no custom BPMN flow is found';
95 SET description = 'Vnf api recipe to delete vnf'
96 WHERE description = 'VID_DEFAULT recipe to delete VNF if no custom BPMN flow is found';
99 SET description = 'Vnf api recipe to update vnf'
100 WHERE description = 'VID_DEFAULT update';
103 SET description = 'Vnf api recipe to replace vnf'
104 WHERE description = 'VID_DEFAULT replace';
107 SET description = 'Vnf api recipe to do an in place software update'
108 WHERE description = 'VID_DEFAULT inPlaceSoftwareUpdate';
111 SET description = 'Vnf api recipe to apply updated config'
112 WHERE description = 'VID_DEFAULT applyUpdatedConfig';
114 INSERT INTO service (MODEL_UUID, MODEL_NAME, MODEL_INVARIANT_UUID, MODEL_VERSION, DESCRIPTION)
116 ('DummyGRApiDefaultModelUUID?', 'GR-API-DEFAULT', 'DummyGRApiDefaultModelInvariantUUID?', '1.0', 'Gr api service for VID to use for infra APIH orchestration');
119 SET model_name = 'VNF-API-DEFAULT',
120 description = 'Vnf api service for VID to use for infra APIH orchestration'
121 WHERE model_name = 'VID_DEFAULT';
123 INSERT INTO service_recipe (ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, SERVICE_MODEL_UUID)
125 ('activateInstance', '1.0', 'Gr api recipe to activate service-instance', '/mso/async/services/WorkflowActionBB', 180, 'DummyGRApiDefaultModelUUID?'),
126 ('createInstance', '1.0', 'Gr api recipe to create service-instance', '/mso/async/services/WorkflowActionBB', 180, 'DummyGRApiDefaultModelUUID?'),
127 ('deactivateInstance', '1.0', 'Gr api recipe to deactivate service-instance', '/mso/async/services/WorkflowActionBB', 180, 'DummyGRApiDefaultModelUUID?'),
128 ('deleteInstance', '1.0', 'Gr api recipe to delete service-instance', '/mso/async/services/WorkflowActionBB', 180, 'DummyGRApiDefaultModelUUID?');
130 UPDATE service_recipe
131 SET description = 'Vnf api recipe to activate service-instance'
132 WHERE description = 'VID_DEFAULT activate';
134 UPDATE service_recipe
135 SET description = 'Vnf api recipe to create service-instance'
136 WHERE description = 'VID_DEFAULT recipe to create service-instance if no custom BPMN flow is found';
138 UPDATE service_recipe
139 SET description = 'Vnf api recipe to deactivate service-instance'
140 WHERE description = 'VID_DEFAULT deactivate';
142 UPDATE service_recipe
143 SET description = 'Vnf api recipe to delete service-instance'
144 WHERE description = 'VID_DEFAULT recipe to delete service-instance if no custom BPMN flow is found';
146 INSERT INTO vnf_components_recipe (VNF_COMPONENT_TYPE, ACTION, VERSION, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, VF_MODULE_MODEL_UUID)
148 ('volumeGroup', 'createInstance', '1', 'Gr api recipe to create volume-group', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
149 ('volumeGroup', 'deleteInstance', '1', 'Gr api recipe to delete volume-group', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
150 ('volumeGroup', 'updateInstance', '1', 'Gr api recipe to update volume-group', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
151 ('vfModule', 'createInstance', '1', 'Gr api recipe to create vf-module', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
152 ('vfModule', 'deleteInstance', '1', 'Gr api recipe to delete vf-module', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
153 ('vfModule', 'updateInstance', '1', 'Gr api recipe to update vf-module', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
154 ('vfModule', 'replaceInstance', '1', 'Gr api recipe to replace vf-module', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT');
156 UPDATE vnf_components_recipe
157 SET vf_module_model_uuid = 'VNF-API-DEFAULT'
158 WHERE vf_module_model_uuid = 'VID_DEFAULT';
160 UPDATE vnf_components_recipe
161 SET description = 'Vnf api recipe to create volume-group'
162 WHERE description = 'VID_DEFAULT recipe to create volume-group if no custom BPMN flow is found';
164 UPDATE vnf_components_recipe
165 SET description = 'Vnf api recipe to delete volume-group'
166 WHERE description = 'VID_DEFAULT recipe to delete volume-group if no custom BPMN flow is found';
168 UPDATE vnf_components_recipe
169 SET description = 'Vnf api recipe to update volume-group'
170 WHERE description = 'VID_DEFAULT recipe to update volume-group if no custom BPMN flow is found';
172 UPDATE vnf_components_recipe
173 SET description = 'Vnf api recipe to create vf-module'
174 WHERE description = 'VID_DEFAULT recipe to create vf-module if no custom BPMN flow is found';
176 UPDATE vnf_components_recipe
177 SET description = 'Vnf api recipe to delete vf-module'
178 WHERE description = 'VID_DEFAULT recipe to delete vf-module if no custom BPMN flow is found';
180 UPDATE vnf_components_recipe
181 SET description = 'Vnf api recipe to update vf-module'
182 WHERE description = 'VID_DEFAULT recipe to update vf-module if no custom BPMN flow is found';
184 UPDATE vnf_components_recipe
185 SET description = 'Vnf api recipe to replace vf-module'
186 WHERE description = 'VID_DEFAULT vfModule replace';
188 INSERT INTO network_recipe (MODEL_NAME, ACTION, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, VERSION_STR)
190 ('GR-API-DEFAULT', 'createInstance', 'Gr api recipe to create network', '/mso/async/services/WorkflowActionBB', 180, '1.0'),
191 ('GR-API-DEFAULT', 'updateInstance', 'Gr api recipe to update network', '/mso/async/services/WorkflowActionBB', 180, '1.0'),
192 ('GR-API-DEFAULT', 'deleteInstance', 'Gr api recipe to delete network', '/mso/async/services/WorkflowActionBB', 180, '1.0');
194 UPDATE network_recipe
195 SET model_name = 'VNF-API-DEFAULT'
196 WHERE model_name = 'VID_DEFAULT';
198 UPDATE network_recipe
199 SET description = 'Vnf api recipe to create network'
200 WHERE description = 'VID_DEFAULT recipe to create network if no custom BPMN flow is found';
202 UPDATE network_recipe
203 SET description = 'Vnf api recipe to update network'
204 WHERE description = 'VID_DEFAULT recipe to update network if no custom BPMN flow is found';
206 UPDATE network_recipe
207 SET description = 'Vnf api recipe to delete network'
208 WHERE description = 'VID_DEFAULT recipe to delete network if no custom BPMN flow is found';