3 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
4 `id` INT(11) NOT NULL AUTO_INCREMENT,
5 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
6 `MACRO_ACTION` VARCHAR(200) NOT NULL,
7 `ACTION` VARCHAR(200) NOT NULL,
8 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
9 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 0,
10 `MIN_API_VERSION` DOUBLE NOT NULL,
11 `MAX_API_VERSION` DOUBLE NULL,
13 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC, `MACRO_ACTION` ASC))
15 DEFAULT CHARACTER SET = latin1;
17 CREATE TABLE IF NOT EXISTS building_block_detail (
18 id INT(11) AUTO_INCREMENT,
19 BUILDING_BLOCK_NAME VARCHAR(200) NOT NULL,
20 RESOURCE_TYPE VARCHAR(25) NOT NULL,
21 TARGET_ACTION VARCHAR(25) NOT NULL,
23 UNIQUE INDEX `UK_building_block_name`(`BUILDING_BLOCK_NAME`))
25 DEFAULT CHARACTER SET = latin1;
27 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
28 `id` INT(11) NOT NULL AUTO_INCREMENT,
29 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
30 `SEQ_NO` INT(11) NOT NULL,
31 `FLOW_NAME` VARCHAR(200) NOT NULL,
32 `FLOW_VERSION` DOUBLE NOT NULL,
33 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
35 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
36 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
37 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
38 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
39 ON DELETE CASCADE ON UPDATE CASCADE
41 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
43 create table `allotted_resource` (
44 `model_uuid` varchar(200) not null,
45 `model_invariant_uuid` varchar(200) not null,
46 `model_version` varchar(20) not null,
47 `model_name` varchar(200) not null,
48 `tosca_node_type` varchar(200) default null,
49 `subcategory` varchar(200) default null,
50 `description` varchar(1200) default null,
51 `creation_timestamp` datetime not null default current_timestamp,
52 primary key (`model_uuid`)
53 ) engine=innodb default charset=latin1;
58 create table `allotted_resource_customization` (
59 `model_customization_uuid` varchar(200) not null,
60 `model_instance_name` varchar(200) not null,
61 `providing_service_model_uuid` varchar(200) default null,
62 `providing_service_model_invariant_uuid` varchar(200) default null,
63 `providing_service_model_name` varchar(200) default null,
64 `target_network_role` varchar(200) default null,
65 `nf_type` varchar(200) default null,
66 `nf_role` varchar(200) default null,
67 `nf_function` varchar(200) default null,
68 `nf_naming_code` varchar(200) default null,
69 `min_instances` int(11) default null,
70 `max_instances` int(11) default null,
71 `ar_model_uuid` varchar(200) not null,
72 `resource_input` varchar(20000) default null,
73 `creation_timestamp` datetime not null default current_timestamp,
74 primary key (`model_customization_uuid`),
75 key `fk_allotted_resource_customization__allotted_resource1_idx` (`ar_model_uuid`),
76 constraint `fk_allotted_resource_customization__allotted_resource1` foreign key (`ar_model_uuid`) references `allotted_resource` (`model_uuid`) on delete cascade on update cascade
77 ) engine=innodb default charset=latin1;
82 create table `heat_environment` (
83 `artifact_uuid` varchar(200) not null,
84 `name` varchar(100) not null,
85 `version` varchar(20) not null,
86 `description` varchar(1200) default null,
87 `body` longtext not null,
88 `artifact_checksum` varchar(200) not null default 'manual record',
89 `creation_timestamp` datetime not null default current_timestamp,
90 primary key (`artifact_uuid`)
91 ) engine=innodb default charset=latin1;
95 create table `heat_files` (
96 `artifact_uuid` varchar(200) not null,
97 `name` varchar(200) not null,
98 `version` varchar(20) not null,
99 `description` varchar(1200) default null,
100 `body` longtext not null,
101 `artifact_checksum` varchar(200) not null default 'manual record',
102 `creation_timestamp` datetime not null default current_timestamp,
103 primary key (`artifact_uuid`)
104 ) engine=innodb default charset=latin1;
109 create table `heat_template` (
110 `artifact_uuid` varchar(200) not null,
111 `name` varchar(200) not null,
112 `version` varchar(20) not null,
113 `description` varchar(1200) default null,
114 `body` longtext not null,
115 `timeout_minutes` int(11) default null,
116 `artifact_checksum` varchar(200) not null default 'manual record',
117 `creation_timestamp` datetime not null default current_timestamp,
118 primary key (`artifact_uuid`)
119 ) engine=innodb default charset=latin1;
123 create table `heat_nested_template` (
124 `parent_heat_template_uuid` varchar(200) not null,
125 `child_heat_template_uuid` varchar(200) not null,
126 `provider_resource_file` varchar(100) default null,
127 primary key (`parent_heat_template_uuid`,`child_heat_template_uuid`),
128 key `fk_heat_nested_template__heat_template2_idx` (`child_heat_template_uuid`),
129 constraint `fk_heat_nested_template__child_heat_temp_uuid__heat_template1` foreign key (`child_heat_template_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade,
130 constraint `fk_heat_nested_template__parent_heat_temp_uuid__heat_template1` foreign key (`parent_heat_template_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
131 ) engine=innodb default charset=latin1;
136 create table `heat_template_params` (
137 `heat_template_artifact_uuid` varchar(200) not null,
138 `param_name` varchar(100) not null,
139 `is_required` bit(1) not null,
140 `param_type` varchar(20) default null,
141 `param_alias` varchar(45) default null,
142 primary key (`heat_template_artifact_uuid`,`param_name`),
143 constraint `fk_heat_template_params__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
144 ) engine=innodb default charset=latin1;
148 create table `network_recipe` (
149 `id` int(11) not null auto_increment,
150 `model_name` varchar(20) not null,
151 `action` varchar(50) not null,
152 `description` varchar(1200) default null,
153 `orchestration_uri` varchar(256) not null,
154 `network_param_xsd` varchar(2048) default null,
155 `recipe_timeout` int(11) default null,
156 `service_type` varchar(45) default null,
157 `creation_timestamp` datetime not null default current_timestamp,
158 `version_str` varchar(20) not null,
160 unique key `uk_rl4f296i0p8lyokxveaiwkayi` (`model_name`,`action`,`version_str`)
161 ) engine=innodb auto_increment=178 default charset=latin1;
166 create table `temp_network_heat_template_lookup` (
167 `network_resource_model_name` varchar(200) not null,
168 `heat_template_artifact_uuid` varchar(200) null,
169 `aic_version_min` varchar(20) null,
170 `aic_version_max` varchar(20) default null,
171 primary key (`network_resource_model_name`),
172 key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
173 constraint `fk_temp_network_heat_template_lookup__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade
174 ) engine=innodb default charset=latin1;
178 create table `network_resource` (
179 `model_uuid` varchar(200) not null,
180 `model_name` varchar(200) not null,
181 `model_invariant_uuid` varchar(200) default null,
182 `description` varchar(1200) default null,
183 `heat_template_artifact_uuid` varchar(200) null,
184 `neutron_network_type` varchar(20) default null,
185 `model_version` varchar(20) default null,
186 `tosca_node_type` varchar(200) default null,
187 `aic_version_min` varchar(20) null,
188 `aic_version_max` varchar(20) default null,
189 `orchestration_mode` varchar(20) default 'heat',
190 `resource_category` varchar(20) default null,
191 `resource_sub_category` varchar(20) default null,
192 `creation_timestamp` datetime not null default current_timestamp,
193 primary key (`model_uuid`),
194 key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
195 key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
196 constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade
197 ) engine=innodb default charset=latin1;
203 create table `network_resource_customization` (
204 `model_customization_uuid` varchar(200) not null,
205 `model_instance_name` varchar(200) not null,
206 `network_technology` varchar(45) default null,
207 `network_type` varchar(45) default null,
208 `network_role` varchar(200) default null,
209 `network_scope` varchar(45) default null,
210 `creation_timestamp` datetime not null default current_timestamp,
211 `network_resource_model_uuid` varchar(200) not null,
212 `resource_input` varchar(20000) default null,
213 primary key (`model_customization_uuid`),
214 key `fk_network_resource_customization__network_resource1_idx` (`network_resource_model_uuid`),
215 constraint `fk_network_resource_customization__network_resource1` foreign key (`network_resource_model_uuid`) references `network_resource` (`model_uuid`) on delete cascade on update cascade
216 ) engine=innodb default charset=latin1;
222 create table `tosca_csar` (
223 `artifact_uuid` varchar(200) not null,
224 `name` varchar(200) not null,
225 `version` varchar(20) not null,
226 `description` varchar(1200) default null,
227 `artifact_checksum` varchar(200) not null,
228 `url` varchar(200) not null,
229 `creation_timestamp` datetime not null default current_timestamp,
230 primary key (`artifact_uuid`)
231 ) engine=innodb default charset=latin1;
236 create table `service` (
237 `model_uuid` varchar(200) not null,
238 `model_name` varchar(200) not null,
239 `model_invariant_uuid` varchar(200) not null,
240 `model_version` varchar(20) not null,
241 `description` varchar(1200) default null,
242 `creation_timestamp` datetime not null default current_timestamp,
243 `tosca_csar_artifact_uuid` varchar(200) default null,
244 `service_type` varchar(200) default null,
245 `service_role` varchar(200) default null,
246 `environment_context` varchar(200) default null,
247 `workload_context` varchar(200) default null,
248 `service_category` varchar(200) default null,
249 `resource_order` varchar(200) default null,
250 primary key (`model_uuid`),
251 key `fk_service__tosca_csar1_idx` (`tosca_csar_artifact_uuid`),
252 constraint `fk_service__tosca_csar1` foreign key (`tosca_csar_artifact_uuid`) references `tosca_csar` (`artifact_uuid`) on delete cascade on update cascade
253 ) engine=innodb default charset=latin1;
257 create table `service_recipe` (
258 `id` int(11) not null auto_increment,
259 `action` varchar(50) not null,
260 `version_str` varchar(20) default null,
261 `description` varchar(1200) default null,
262 `orchestration_uri` varchar(256) not null,
263 `service_param_xsd` varchar(2048) default null,
264 `recipe_timeout` int(11) default null,
265 `service_timeout_interim` int(11) default null,
266 `creation_timestamp` datetime not null default current_timestamp,
267 `service_model_uuid` varchar(200) not null,
269 unique key `uk_7fav5dkux2v8g9d2i5ymudlgc` (`service_model_uuid`,`action`),
270 key `fk_service_recipe__service1_idx` (`service_model_uuid`),
271 constraint `fk_service_recipe__service1` foreign key (`service_model_uuid`) references `service` (`model_uuid`) on delete cascade on update cascade
272 ) engine=innodb auto_increment=86 default charset=latin1;
276 create table `vnf_resource` (
277 `orchestration_mode` varchar(20) not null default 'heat',
278 `description` varchar(1200) default null,
279 `creation_timestamp` datetime not null default current_timestamp,
280 `model_uuid` varchar(200) not null,
281 `aic_version_min` varchar(20) default null,
282 `aic_version_max` varchar(20) default null,
283 `model_invariant_uuid` varchar(200) default null,
284 `model_version` varchar(20) not null,
285 `model_name` varchar(200) default null,
286 `tosca_node_type` varchar(200) default null,
287 `resource_category` varchar(200) default null,
288 `resource_sub_category` varchar(200) default null,
289 `heat_template_artifact_uuid` varchar(200) default null,
290 primary key (`model_uuid`),
291 key `fk_vnf_resource__heat_template1` (`heat_template_artifact_uuid`),
292 constraint `fk_vnf_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
293 ) engine=innodb default charset=latin1;
298 create table `vf_module` (
299 `model_uuid` varchar(200) not null,
300 `model_invariant_uuid` varchar(200) default null,
301 `model_version` varchar(20) not null,
302 `model_name` varchar(200) not null,
303 `description` varchar(1200) default null,
304 `is_base` int(11) not null,
305 `heat_template_artifact_uuid` varchar(200) default null,
306 `vol_heat_template_artifact_uuid` varchar(200) default null,
307 `creation_timestamp` datetime not null default current_timestamp,
308 `vnf_resource_model_uuid` varchar(200) not null,
309 primary key (`model_uuid`,`vnf_resource_model_uuid`),
310 key `fk_vf_module__vnf_resource1_idx` (`vnf_resource_model_uuid`),
311 key `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`heat_template_artifact_uuid`),
312 key `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`vol_heat_template_artifact_uuid`),
313 constraint `fk_vf_module__heat_template_art_uuid__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade,
314 constraint `fk_vf_module__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade,
315 constraint `fk_vf_module__vol_heat_template_art_uuid__heat_template2` foreign key (`vol_heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
316 ) engine=innodb default charset=latin1;
320 /*!40101 set @saved_cs_client = @@character_set_client */;
321 /*!40101 set character_set_client = utf8 */;
322 create table `vf_module_customization` (
323 `model_customization_uuid` varchar(200) not null,
324 `label` varchar(200) default null,
325 `initial_count` int(11) default '0',
326 `min_instances` int(11) default '0',
327 `max_instances` int(11) default null,
328 `availability_zone_count` int(11) default null,
329 `heat_environment_artifact_uuid` varchar(200) default null,
330 `vol_environment_artifact_uuid` varchar(200) default null,
331 `creation_timestamp` datetime not null default current_timestamp,
332 `vf_module_model_uuid` varchar(200) not null,
333 primary key (`model_customization_uuid`),
334 key `fk_vf_module_customization__vf_module1_idx` (`vf_module_model_uuid`),
335 key `fk_vf_module_customization__heat_env__heat_environment1_idx` (`heat_environment_artifact_uuid`),
336 key `fk_vf_module_customization__vol_env__heat_environment2_idx` (`vol_environment_artifact_uuid`),
337 constraint `fk_vf_module_customization__heat_env__heat_environment1` foreign key (`heat_environment_artifact_uuid`) references `heat_environment` (`artifact_uuid`) on delete cascade on update cascade,
338 constraint `fk_vf_module_customization__vf_module1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade,
339 constraint `fk_vf_module_customization__vol_env__heat_environment2` foreign key (`vol_environment_artifact_uuid`) references `heat_environment` (`artifact_uuid`) on delete cascade on update cascade
340 ) engine=innodb default charset=latin1;
341 /*!40101 set character_set_client = @saved_cs_client */;
344 -- table structure for table `vf_module_to_heat_files`
348 /*!40101 set @saved_cs_client = @@character_set_client */;
349 /*!40101 set character_set_client = utf8 */;
350 create table `vf_module_to_heat_files` (
351 `vf_module_model_uuid` varchar(200) not null,
352 `heat_files_artifact_uuid` varchar(200) not null,
353 primary key (`vf_module_model_uuid`,`heat_files_artifact_uuid`),
354 key `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`heat_files_artifact_uuid`),
355 constraint `fk_vf_module_to_heat_files__heat_files__artifact_uuid1` foreign key (`heat_files_artifact_uuid`) references `heat_files` (`artifact_uuid`) on delete cascade on update cascade,
356 constraint `fk_vf_module_to_heat_files__vf_module__model_uuid1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade
357 ) engine=innodb default charset=latin1 comment='il fait ce qu''il dit';
358 /*!40101 set character_set_client = @saved_cs_client */;
361 -- table structure for table `vnf_components`
365 /*!40101 set @saved_cs_client = @@character_set_client */;
366 /*!40101 set character_set_client = utf8 */;
367 create table `vnf_components` (
368 `vnf_id` int(11) not null,
369 `component_type` varchar(20) not null,
370 `heat_template_id` int(11) default null,
371 `heat_environment_id` int(11) default null,
372 `creation_timestamp` datetime not null default current_timestamp,
373 primary key (`vnf_id`,`component_type`)
374 ) engine=innodb default charset=latin1;
375 /*!40101 set character_set_client = @saved_cs_client */;
378 -- table structure for table `vnf_components_recipe`
383 create table `vnf_components_recipe` (
384 `id` int(11) not null auto_increment,
385 `vnf_type` varchar(200) default null,
386 `vnf_component_type` varchar(45) not null,
387 `action` varchar(50) not null,
388 `service_type` varchar(45) default null,
389 `version` varchar(20) not null,
390 `description` varchar(1200) default null,
391 `orchestration_uri` varchar(256) not null,
392 `vnf_component_param_xsd` varchar(2048) default null,
393 `recipe_timeout` int(11) default null,
394 `creation_timestamp` datetime default current_timestamp,
395 `vf_module_model_uuid` varchar(200) default null,
397 unique key `uk_4dpdwddaaclhc11wxsb7h59ma` (`vf_module_model_uuid`,`vnf_component_type`,`action`,`version`)
398 ) engine=innodb auto_increment=26 default charset=latin1;
403 create table `vnf_recipe` (
404 `id` int(11) not null auto_increment,
405 `vnf_type` varchar(200) default null,
406 `action` varchar(50) not null,
407 `service_type` varchar(45) default null,
408 `version_str` varchar(20) not null,
409 `description` varchar(1200) default null,
410 `orchestration_uri` varchar(256) not null,
411 `vnf_param_xsd` varchar(2048) default null,
412 `recipe_timeout` int(11) default null,
413 `creation_timestamp` datetime default current_timestamp,
414 `vf_module_id` varchar(100) default null,
416 unique key `uk_f3tvqau498vrifq3cr8qnigkr` (`vf_module_id`,`action`,`version_str`)
417 ) engine=innodb auto_increment=10006 default charset=latin1;
426 create table `vnf_resource_customization` (
427 `model_customization_uuid` varchar(200) not null,
428 `model_instance_name` varchar(200) not null,
429 `min_instances` int(11) default null,
430 `max_instances` int(11) default null,
431 `availability_zone_max_count` int(11) default null,
432 `nf_type` varchar(200) default null,
433 `nf_role` varchar(200) default null,
434 `nf_function` varchar(200) default null,
435 `nf_naming_code` varchar(200) default null,
436 `creation_timestamp` datetime not null default current_timestamp,
437 `vnf_resource_model_uuid` varchar(200) not null,
438 `multi_stage_design` varchar(20) default null,
439 `resource_input` varchar(20000) default null,
440 primary key (`model_customization_uuid`),
441 key `fk_vnf_resource_customization__vnf_resource1_idx` (`vnf_resource_model_uuid`),
442 constraint `fk_vnf_resource_customization__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade
443 ) engine=innodb default charset=latin1;
448 create table `vnf_res_custom_to_vf_module_custom` (
449 `vnf_resource_cust_model_customization_uuid` varchar(200) not null,
450 `vf_module_cust_model_customization_uuid` varchar(200) not null,
451 `creation_timestamp` datetime not null default current_timestamp,
452 primary key (`vnf_resource_cust_model_customization_uuid`,`vf_module_cust_model_customization_uuid`),
453 key `fk_vnf_res_custom_to_vf_module_custom__vf_module_customizat_idx` (`vf_module_cust_model_customization_uuid`),
454 constraint `fk_vnf_res_custom_to_vf_module_custom__vf_module_customization1` foreign key (`vf_module_cust_model_customization_uuid`) references `vf_module_customization` (`model_customization_uuid`) on delete cascade on update cascade,
455 constraint `fk_vnf_res_custom_to_vf_module_custom__vnf_resource_customiza1` foreign key (`vnf_resource_cust_model_customization_uuid`) references `vnf_resource_customization` (`model_customization_uuid`) on delete cascade on update cascade
456 ) engine=innodb default charset=latin1;
459 create table if not exists external_service_to_internal_model_mapping (
461 service_name varchar(200) not null,
462 product_flavor varchar(200) null,
463 subscription_service_type varchar(200) not null,
464 service_model_uuid varchar(200) not null,
466 unique index uk_external_service_to_internal_model_mapping
467 (service_name asc, product_flavor asc, service_model_uuid asc));
469 create table if not exists `collection_resource` (
470 model_uuid varchar(200) not null,
471 model_name varchar(200) not null,
472 model_invariant_uuid varchar(200) not null,
473 model_version varchar(20) not null,
474 tosca_node_type varchar(200) not null,
475 description varchar(200),
476 creation_timestamp datetime not null default current_timestamp,
477 primary key (`model_uuid`)
478 )engine=innodb default charset=latin1;
480 create table if not exists `collection_resource_customization` (
481 model_customization_uuid varchar(200) not null,
482 model_instance_name varchar(200) not null,
483 role varchar(200) NULL,
484 object_type varchar(200) not null,
485 function varchar(200) NULL,
486 collection_resource_type varchar(200) NULL,
487 creation_timestamp datetime not null default current_timestamp,
488 cr_model_uuid varchar(200) not null,
489 primary key (`model_customization_uuid`)
490 )engine=innodb default charset=latin1;
492 create table if not exists `instance_group` (
493 model_uuid varchar(200) not null,
494 model_name varchar(200) not null,
495 model_invariant_uuid varchar(200) not null,
496 model_version varchar(20) not null,
497 tosca_node_type varchar(200) NULL,
498 role varchar(200) not null,
499 object_type varchar(200) not null,
500 creation_timestamp datetime not null default current_timestamp,
501 cr_model_uuid varchar(200) not null,
502 instance_group_type varchar(200) not null,
503 primary key (`model_uuid`)
504 )engine=innodb default charset=latin1;
506 create table if not exists `collection_resource_instance_group_customization` (
507 `collection_resource_customization_model_uuid` varchar(200) not null,
508 `instance_group_model_uuid` varchar(200) not null,
509 `function` varchar(200) null,
510 `description` varchar(1200) null,
511 `subinterface_network_quantity` int(11) null,
512 `creation_timestamp` datetime not null default current_timestamp,
513 primary key (`collection_resource_customization_model_uuid`, `instance_group_model_uuid`),
514 index `fk_collection_resource_instance_group_customization__instan_idx` (`instance_group_model_uuid` asc),
515 constraint `fk_collection_resource_instance_group_customization__collecti1`
516 foreign key (`collection_resource_customization_model_uuid`)
517 references `collection_resource_customization` (`model_customization_uuid`)
520 constraint `fk_collection_resource_instance_group_customization__instance1`
521 foreign key (`instance_group_model_uuid`)
522 references `instance_group` (`model_uuid`)
526 default character set = latin1;
528 create table if not exists `vnfc_instance_group_customization` (
529 `vnf_resource_customization_model_uuid` varchar(200) not null,
530 `instance_group_model_uuid` varchar(200) not null,
531 `function` varchar(200) null,
532 `description` varchar(1200) null,
533 `creation_timestamp` datetime not null default current_timestamp,
534 primary key (`vnf_resource_customization_model_uuid`, `instance_group_model_uuid`),
535 index `fk_vnfc_instance_group_customization__instance_group1_idx` (`instance_group_model_uuid` asc),
536 constraint `fk_vnfc_instance_group_customization__vnf_resource_customizat1`
537 foreign key (`vnf_resource_customization_model_uuid`)
538 references `vnf_resource_customization` (`model_customization_uuid`)
541 constraint `fk_vnfc_instance_group_customization__instance_group1`
542 foreign key (`instance_group_model_uuid`)
543 references `instance_group` (`model_uuid`)
547 default character set = latin1;
549 create table if not exists `configuration`
550 ( `model_uuid` varchar(200) not null,
551 `model_invariant_uuid` varchar(200) not null,
552 `model_version` varchar(20) not null,
553 `model_name` varchar(200) not null,
554 `tosca_node_type` varchar(200) not null,
555 `description` varchar(1200) null,
556 `creation_timestamp` datetime not null default current_timestamp,
557 primary key (`model_uuid`))
558 engine = innodb auto_increment = 20654
559 default character set = latin1;
561 CREATE TABLE IF NOT EXISTS `service_proxy_customization` (
562 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
563 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
564 `MODEL_UUID` VARCHAR(200) NOT NULL,
565 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
566 `MODEL_VERSION` VARCHAR(20) NOT NULL,
567 `MODEL_NAME` VARCHAR(200) NOT NULL,
568 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
569 `DESCRIPTION` VARCHAR(1200) NULL,
570 `SOURCE_SERVICE_MODEL_UUID` VARCHAR(200) NOT NULL,
571 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
572 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
573 INDEX `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID` ASC),
574 UNIQUE INDEX `UK_service_proxy_customization` (`MODEL_CUSTOMIZATION_UUID` ASC),
575 INDEX `fk_service_proxy_customization__serv_prox_to_serv` (`MODEL_CUSTOMIZATION_UUID` ASC),
576 CONSTRAINT `fk_service_proxy_resource_customization__service1`
577 FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`)
578 REFERENCES `service` (`MODEL_UUID`)
582 AUTO_INCREMENT = 20654
583 DEFAULT CHARACTER SET = latin1;
585 create table if not exists `configuration_customization` (
586 `model_customization_uuid` varchar(200) not null,
587 `model_instance_name` varchar(200) not null,
588 `configuration_type` varchar(200) null,
589 `configuration_role` varchar(200) null,
590 `configuration_function` varchar(200) null,
591 `creation_timestamp` datetime not null default current_timestamp,
592 `configuration_model_uuid` varchar(200) not null,
593 `service_proxy_customization_model_customization_uuid` varchar(200) null,
594 `configuration_customization_model_customization_uuid` varchar(200) null,
595 primary key (`model_customization_uuid`),
596 index `fk_configuration_customization__configuration_idx` (`configuration_model_uuid` asc),
597 index `fk_configuration_customization__service_proxy_customization_idx`
598 (`service_proxy_customization_model_customization_uuid` asc),
599 index `fk_configuration_customization__configuration_customization_idx`
600 (`configuration_customization_model_customization_uuid` asc),
601 constraint `fk_configuration_resource_customization__configuration_resour1`
602 foreign key (`configuration_model_uuid`) references `configuration` (`model_uuid`)
603 on delete cascade on update cascade,
604 constraint `fk_configuration_customization__service_proxy_customization1` foreign
605 key (`service_proxy_customization_model_customization_uuid`) references
606 `service_proxy_customization` (`model_customization_uuid`)
607 on delete cascade on update cascade, constraint
608 `fk_configuration_customization__configuration_customization1` foreign
609 key (`configuration_customization_model_customization_uuid`) references
610 `configuration_customization` (`model_customization_uuid`)
611 on delete cascade on update cascade)
613 auto_increment =20654
614 default character set = latin1;
617 create table `service_proxy_customization_to_service` (
618 `service_model_uuid` varchar(200) not null,
619 `resource_model_customization_uuid` varchar(200) not null,
620 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
621 )engine=innodb default charset=latin1;
624 create table `configuration_customization_to_service` (
625 `service_model_uuid` varchar(200) not null,
626 `resource_model_customization_uuid` varchar(200) not null,
627 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
628 )engine=innodb default charset=latin1;
631 create table if not exists `collection_resource_customization_to_service` (
632 `service_model_uuid` varchar(200) not null,
633 `resource_model_customization_uuid` varchar(200) not null,
634 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
635 )engine=innodb default charset=latin1;
638 create table `network_resource_customization_to_service` (
639 `service_model_uuid` varchar(200) not null,
640 `resource_model_customization_uuid` varchar(200) not null,
641 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
642 )engine=innodb default charset=latin1;
644 create table `vnf_resource_customization_to_service` (
645 `service_model_uuid` varchar(200) not null,
646 `resource_model_customization_uuid` varchar(200) not null,
647 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
648 )engine=innodb default charset=latin1;
650 create table `allotted_resource_customization_to_service` (
651 `service_model_uuid` varchar(200) not null,
652 `resource_model_customization_uuid` varchar(200) not null,
653 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
654 )engine=innodb default charset=latin1;
658 create table ar_recipe (
659 ID INT(11) not null auto_increment,
660 MODEL_NAME VARCHAR(200) NOT NULL,
661 `ACTION` VARCHAR(200) NOT NULL,
662 VERSION_STR VARCHAR(200) NOT NULL,
663 SERVICE_TYPE VARCHAR(200),
664 DESCRIPTION VARCHAR(200),
665 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
666 AR_PARAM_XSD VARCHAR(200),
667 RECIPE_TIMEOUT INT(10),
668 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
670 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
671 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
673 alter table collection_resource_customization
674 add foreign key ( cr_model_uuid)
675 references collection_resource(model_uuid)
678 alter table vnf_resource_customization
680 instance_group_model_uuid varchar(200);
682 alter table network_resource_customization
684 instance_group_model_uuid varchar(200);
687 alter table network_resource_customization
688 add foreign key ( instance_group_model_uuid)
689 references instance_group(model_uuid)
692 alter table collection_resource_customization_to_service
693 add foreign key (service_model_uuid)
694 references service(model_uuid)
697 alter table allotted_resource_customization_to_service
698 add foreign key (service_model_uuid)
699 references service(model_uuid)
703 alter table vnf_resource_customization_to_service
704 add foreign key (service_model_uuid)
705 references service(model_uuid)
709 alter table network_resource_customization_to_service
710 add foreign key (service_model_uuid)
711 references service(model_uuid)
715 alter table network_resource_customization_to_service
716 add foreign key (resource_model_customization_uuid)
717 references network_resource_customization(model_customization_uuid)
720 alter table vnf_resource_customization_to_service
721 add foreign key (resource_model_customization_uuid)
722 references vnf_resource_customization(model_customization_uuid)
725 alter table allotted_resource_customization_to_service
726 add foreign key (resource_model_customization_uuid)
727 references allotted_resource_customization(model_customization_uuid)
730 alter table collection_resource_customization_to_service
731 add foreign key (resource_model_customization_uuid)
732 references collection_resource_customization(model_customization_uuid)
736 create table if not exists `collection_network_resource_customization` (
737 `model_customization_uuid` varchar(200) not null,
738 `model_instance_name` varchar(200) not null,
739 `network_technology` varchar(45) null,
740 `network_type` varchar(45) null,
741 `network_role` varchar(200) null,
742 `network_scope` varchar(45) null,
743 `creation_timestamp` datetime not null default current_timestamp,
744 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
745 `crc_model_customization_uuid` varchar(200) not null, primary key
746 (`model_customization_uuid`, `crc_model_customization_uuid`),
747 index `fk_collection_net_resource_customization__network_resource1_idx`
748 (`network_resource_model_uuid` asc), index
749 `fk_collection_net_resource_customization__instance_group1_idx`
750 (`instance_group_model_uuid` asc), index
751 `fk_col_net_res_customization__collection_res_customization_idx`
752 (`crc_model_customization_uuid` asc), constraint
753 `fk_collection_net_resource_customization__network_resource10` foreign
754 key (`network_resource_model_uuid`) references
755 `network_resource` (`model_uuid`) on delete cascade on
756 update cascade, constraint
757 `fk_collection_net_resource_customization__instance_group10` foreign key
758 (`instance_group_model_uuid`) references `instance_group`
759 (`model_uuid`) on delete cascade on update cascade, constraint
760 `fk_collection_network_resource_customization__collection_reso1` foreign
761 key (`crc_model_customization_uuid`) references
762 `collection_resource_customization`
763 (`model_customization_uuid`) on delete cascade on update cascade) engine
764 = innodb default character set = latin1;
766 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
767 `id` INT(11) NOT NULL AUTO_INCREMENT,
768 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
769 `MACRO_ACTION` VARCHAR(200) NOT NULL,
770 `ACTION` VARCHAR(200) NOT NULL,
771 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
772 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 1,
773 `MIN_API_VERSION` DOUBLE NOT NULL,
774 `MAX_API_VERSION` DOUBLE NULL,
776 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC, `MACRO_ACTION` ASC))
778 DEFAULT CHARACTER SET = latin1;
780 CREATE TABLE IF NOT EXISTS orchestration_status_state_transition_directive (
781 id INT(11) AUTO_INCREMENT,
782 RESOURCE_TYPE VARCHAR(25) NOT NULL,
783 ORCHESTRATION_STATUS VARCHAR(25) NOT NULL,
784 TARGET_ACTION VARCHAR(25) NOT NULL,
785 FLOW_DIRECTIVE VARCHAR(25) NOT NULL,
787 UNIQUE KEY UK_orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION))
789 DEFAULT CHARACTER SET = latin1;
791 create table if not exists model_recipe (
792 `ID` INT(11) NOT NULL AUTO_INCREMENT,
794 `ACTION` VARCHAR(40),
795 `SCHEMA_VERSION` VARCHAR(40),
796 `DESCRIPTION` VARCHAR(40),
797 `ORCHESTRATION_URI` VARCHAR(20),
798 `MODEL_PARAM_XSD` VARCHAR(20),
799 `RECIPE_TIMEOUT` INT(11),
800 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
802 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
803 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
805 create table if not exists model (
806 `ID` INT(11) NOT NULL AUTO_INCREMENT,
807 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
808 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
809 `MODEL_INVARIANT_ID` VARCHAR(40),
810 `MODEL_NAME` VARCHAR(40),
811 `MODEL_TYPE` VARCHAR(20),
812 `MODEL_VERSION` VARCHAR(20),
813 `MODEL_VERSION_ID` VARCHAR(40),
814 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
817 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
818 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
819 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
821 CREATE TABLE IF NOT EXISTS `controller_selection_reference` (
822 `VNF_TYPE` VARCHAR(50) NOT NULL,
823 `CONTROLLER_NAME` VARCHAR(100) NOT NULL,
824 `ACTION_CATEGORY` VARCHAR(15) NOT NULL,
825 PRIMARY KEY (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`)
828 ALTER TABLE `vnf_recipe`
829 CHANGE COLUMN `VNF_TYPE` `NF_ROLE` VARCHAR(200) NULL DEFAULT NULL ;
831 CREATE TABLE IF NOT EXISTS `identity_services` (
832 `ID` varchar(50) NOT NULL,
833 `IDENTITY_URL` varchar(200) DEFAULT NULL,
834 `MSO_ID` varchar(255) DEFAULT NULL,
835 `MSO_PASS` varchar(255) DEFAULT NULL,
836 `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL,
837 `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL,
838 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
839 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
840 `TENANT_METADATA` tinyint(1) DEFAULT 0,
841 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
842 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
843 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
844 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
845 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
849 CREATE TABLE IF NOT EXISTS `cloudify_managers` (
850 `ID` varchar(50) NOT NULL,
851 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
852 `USERNAME` varchar(255) DEFAULT NULL,
853 `PASSWORD` varchar(255) DEFAULT NULL,
854 `VERSION` varchar(20) DEFAULT NULL,
855 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
856 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
857 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
861 CREATE TABLE IF NOT EXISTS `cloud_sites` (
862 `ID` varchar(50) NOT NULL,
863 `REGION_ID` varchar(11) DEFAULT NULL,
864 `IDENTITY_SERVICE_ID` varchar(50) DEFAULT NULL,
865 `CLOUD_VERSION` varchar(20) DEFAULT NULL,
866 `CLLI` varchar(11) DEFAULT NULL,
867 `CLOUDIFY_ID` varchar(50) DEFAULT NULL,
868 `PLATFORM` varchar(50) DEFAULT NULL,
869 `ORCHESTRATOR` varchar(50) DEFAULT NULL,
870 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
871 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
872 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
874 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
875 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)
878 CREATE TABLE IF NOT EXISTS vnfc_customization (
879 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
880 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
881 `MODEL_UUID` VARCHAR(200) NOT NULL,
882 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
883 `MODEL_VERSION` VARCHAR(20) NOT NULL,
884 `MODEL_NAME` VARCHAR(200) NOT NULL,
885 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
886 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
887 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
888 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`))
890 AUTO_INCREMENT = 20654
891 DEFAULT CHARACTER SET = latin1;
893 CREATE TABLE IF NOT EXISTS cvnfc_customization (
894 `ID` INT(11) NOT NULL AUTO_INCREMENT,
895 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
896 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
897 `MODEL_UUID` VARCHAR(200) NOT NULL,
898 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
899 `MODEL_VERSION` VARCHAR(20) NOT NULL,
900 `MODEL_NAME` VARCHAR(200) NOT NULL,
901 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
902 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
903 `NFC_FUNCTION` VARCHAR(200) NULL,
904 `NFC_NAMING_CODE` VARCHAR(200) NULL,
905 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
906 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
907 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
908 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL, PRIMARY KEY (`ID`), INDEX `fk_cvnfc_customization__vf_module_customization1_idx` (`VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` ASC), INDEX `fk_cvnfc_customization__vnfc_customization1_idx` (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID` ASC), INDEX `fk_cvnfc_customization__vnf_resource_customization1_idx` (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC), UNIQUE INDEX `UK_cvnfc_customization` (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC, `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` ASC, `MODEL_CUSTOMIZATION_UUID` ASC), INDEX `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID` ASC), CONSTRAINT `fk_cvnfc_customization__vf_module_customization1` FOREIGN KEY (`VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID`) REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`) ON
910 UPDATE CASCADE, CONSTRAINT `fk_cvnfc_customization__vnfc_customization1` FOREIGN KEY (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`) REFERENCES `vnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON
912 UPDATE CASCADE, CONSTRAINT `fk_cvnfc_customization__vnf_resource_customization1` FOREIGN KEY (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`) REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON
914 UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = latin1;
917 CREATE TABLE IF NOT EXISTS vnf_vfmodule_cvnfc_configuration_customization (
918 `ID` INT(11) NOT NULL AUTO_INCREMENT,
919 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
920 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
921 `VF_MODULE_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
922 `CVNFC_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
923 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
924 `CONFIGURATION_TYPE` VARCHAR(200) NULL,
925 `CONFIGURATION_ROLE` VARCHAR(200) NULL,
926 `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
927 `POLICY_NAME` VARCHAR(200) NULL,
928 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
929 `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
931 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
932 UNIQUE INDEX `UK_vnf_vfmodule_cvnfc_configuration_customization` (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC , `VF_MODULE_MODEL_CUSTOMIZATION_UUID` ASC , `CVNFC_MODEL_CUSTOMIZATION_UUID` ASC , `MODEL_CUSTOMIZATION_UUID` ASC),
933 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__cvnfc_cust1_idx` (`CVNFC_MODEL_CUSTOMIZATION_UUID` ASC),
934 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vf_module_cust_idx` (`VF_MODULE_MODEL_CUSTOMIZATION_UUID` ASC),
935 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vnf_res_cust_idx` (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC),
936 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
937 REFERENCES `configuration` (`MODEL_UUID`)
938 ON DELETE CASCADE ON UPDATE CASCADE,
939 CONSTRAINT `fk_cvnfc_configuration_customization__cvnfc_customization1` FOREIGN KEY (`CVNFC_MODEL_CUSTOMIZATION_UUID`)
940 REFERENCES `cvnfc_customization` (`MODEL_CUSTOMIZATION_UUID`)
941 ON DELETE CASCADE ON UPDATE CASCADE,
942 CONSTRAINT `fk_vnf_configuration_cvnfc_customization__vf_module_customiza1` FOREIGN KEY (`VF_MODULE_MODEL_CUSTOMIZATION_UUID`)
943 REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`)
944 ON DELETE CASCADE ON UPDATE CASCADE,
945 CONSTRAINT `fk_vfmodule_cvnfc_configuration_customization__vnf_resource_c1` FOREIGN KEY (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`)
946 REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`)
947 ON DELETE CASCADE ON UPDATE CASCADE
948 ) ENGINE=INNODB AUTO_INCREMENT=20654 DEFAULT CHARACTER SET=LATIN1;