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 `creation_timestamp` datetime not null default current_timestamp,
73 primary key (`model_customization_uuid`),
74 key `fk_allotted_resource_customization__allotted_resource1_idx` (`ar_model_uuid`),
75 constraint `fk_allotted_resource_customization__allotted_resource1` foreign key (`ar_model_uuid`) references `allotted_resource` (`model_uuid`) on delete cascade on update cascade
76 ) engine=innodb default charset=latin1;
81 create table `heat_environment` (
82 `artifact_uuid` varchar(200) not null,
83 `name` varchar(100) not null,
84 `version` varchar(20) not null,
85 `description` varchar(1200) default null,
86 `body` longtext not null,
87 `artifact_checksum` varchar(200) not null default 'manual record',
88 `creation_timestamp` datetime not null default current_timestamp,
89 primary key (`artifact_uuid`)
90 ) engine=innodb default charset=latin1;
94 create table `heat_files` (
95 `artifact_uuid` varchar(200) not null,
96 `name` varchar(200) not null,
97 `version` varchar(20) not null,
98 `description` varchar(1200) default null,
99 `body` longtext not null,
100 `artifact_checksum` varchar(200) not null default 'manual record',
101 `creation_timestamp` datetime not null default current_timestamp,
102 primary key (`artifact_uuid`)
103 ) engine=innodb default charset=latin1;
108 create table `heat_template` (
109 `artifact_uuid` varchar(200) not null,
110 `name` varchar(200) not null,
111 `version` varchar(20) not null,
112 `description` varchar(1200) default null,
113 `body` longtext not null,
114 `timeout_minutes` int(11) default null,
115 `artifact_checksum` varchar(200) not null default 'manual record',
116 `creation_timestamp` datetime not null default current_timestamp,
117 primary key (`artifact_uuid`)
118 ) engine=innodb default charset=latin1;
122 create table `heat_nested_template` (
123 `parent_heat_template_uuid` varchar(200) not null,
124 `child_heat_template_uuid` varchar(200) not null,
125 `provider_resource_file` varchar(100) default null,
126 primary key (`parent_heat_template_uuid`,`child_heat_template_uuid`),
127 key `fk_heat_nested_template__heat_template2_idx` (`child_heat_template_uuid`),
128 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,
129 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
130 ) engine=innodb default charset=latin1;
135 create table `heat_template_params` (
136 `heat_template_artifact_uuid` varchar(200) not null,
137 `param_name` varchar(100) not null,
138 `is_required` bit(1) not null,
139 `param_type` varchar(20) default null,
140 `param_alias` varchar(45) default null,
141 primary key (`heat_template_artifact_uuid`,`param_name`),
142 constraint `fk_heat_template_params__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
143 ) engine=innodb default charset=latin1;
147 create table `network_recipe` (
148 `id` int(11) not null auto_increment,
149 `model_name` varchar(20) not null,
150 `action` varchar(50) not null,
151 `description` varchar(1200) default null,
152 `orchestration_uri` varchar(256) not null,
153 `network_param_xsd` varchar(2048) default null,
154 `recipe_timeout` int(11) default null,
155 `service_type` varchar(45) default null,
156 `creation_timestamp` datetime not null default current_timestamp,
157 `version_str` varchar(20) not null,
159 unique key `uk_rl4f296i0p8lyokxveaiwkayi` (`model_name`,`action`,`version_str`)
160 ) engine=innodb auto_increment=178 default charset=latin1;
165 create table `temp_network_heat_template_lookup` (
166 `network_resource_model_name` varchar(200) not null,
167 `heat_template_artifact_uuid` varchar(200) not null,
168 `aic_version_min` varchar(20) not null,
169 `aic_version_max` varchar(20) default null,
170 primary key (`network_resource_model_name`),
171 key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
172 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
173 ) engine=innodb default charset=latin1;
177 create table `network_resource` (
178 `model_uuid` varchar(200) not null,
179 `model_name` varchar(200) not null,
180 `model_invariant_uuid` varchar(200) default null,
181 `description` varchar(1200) default null,
182 `heat_template_artifact_uuid` varchar(200) not null,
183 `neutron_network_type` varchar(20) default null,
184 `model_version` varchar(20) default null,
185 `tosca_node_type` varchar(200) default null,
186 `aic_version_min` varchar(20) not null,
187 `aic_version_max` varchar(20) default null,
188 `orchestration_mode` varchar(20) default 'heat',
189 `resource_category` varchar(20) default null,
190 `resource_sub_category` varchar(20) default null,
191 `creation_timestamp` datetime not null default current_timestamp,
192 primary key (`model_uuid`),
193 key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
194 key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
195 constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade,
196 constraint `fk_network_resource__temp_network_heat_template_lookup__mod_nm1` foreign key (`model_name`) references `temp_network_heat_template_lookup` (`network_resource_model_name`) on delete no action on update no action
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 primary key (`model_customization_uuid`),
213 key `fk_network_resource_customization__network_resource1_idx` (`network_resource_model_uuid`),
214 constraint `fk_network_resource_customization__network_resource1` foreign key (`network_resource_model_uuid`) references `network_resource` (`model_uuid`) on delete cascade on update cascade
215 ) engine=innodb default charset=latin1;
221 create table `tosca_csar` (
222 `artifact_uuid` varchar(200) not null,
223 `name` varchar(200) not null,
224 `version` varchar(20) not null,
225 `description` varchar(1200) default null,
226 `artifact_checksum` varchar(200) not null,
227 `url` varchar(200) not null,
228 `creation_timestamp` datetime not null default current_timestamp,
229 primary key (`artifact_uuid`)
230 ) engine=innodb default charset=latin1;
235 create table `service` (
236 `model_uuid` varchar(200) not null,
237 `model_name` varchar(200) not null,
238 `model_invariant_uuid` varchar(200) not null,
239 `model_version` varchar(20) not null,
240 `description` varchar(1200) default null,
241 `creation_timestamp` datetime not null default current_timestamp,
242 `tosca_csar_artifact_uuid` varchar(200) default null,
243 `service_type` varchar(200) default null,
244 `service_role` varchar(200) default null,
245 `environment_context` varchar(200) default null,
246 `workload_context` varchar(200) default null,
247 `service_category` varchar(200) default null,
248 primary key (`model_uuid`),
249 key `fk_service__tosca_csar1_idx` (`tosca_csar_artifact_uuid`),
250 constraint `fk_service__tosca_csar1` foreign key (`tosca_csar_artifact_uuid`) references `tosca_csar` (`artifact_uuid`) on delete cascade on update cascade
251 ) engine=innodb default charset=latin1;
255 create table `service_recipe` (
256 `id` int(11) not null auto_increment,
257 `action` varchar(50) not null,
258 `version_str` varchar(20) default null,
259 `description` varchar(1200) default null,
260 `orchestration_uri` varchar(256) not null,
261 `service_param_xsd` varchar(2048) default null,
262 `recipe_timeout` int(11) default null,
263 `service_timeout_interim` int(11) default null,
264 `creation_timestamp` datetime not null default current_timestamp,
265 `service_model_uuid` varchar(200) not null,
267 unique key `uk_7fav5dkux2v8g9d2i5ymudlgc` (`service_model_uuid`,`action`),
268 key `fk_service_recipe__service1_idx` (`service_model_uuid`),
269 constraint `fk_service_recipe__service1` foreign key (`service_model_uuid`) references `service` (`model_uuid`) on delete cascade on update cascade
270 ) engine=innodb auto_increment=86 default charset=latin1;
274 create table `vnf_resource` (
275 `orchestration_mode` varchar(20) not null default 'heat',
276 `description` varchar(1200) default null,
277 `creation_timestamp` datetime not null default current_timestamp,
278 `model_uuid` varchar(200) not null,
279 `aic_version_min` varchar(20) default null,
280 `aic_version_max` varchar(20) default null,
281 `model_invariant_uuid` varchar(200) default null,
282 `model_version` varchar(20) not null,
283 `model_name` varchar(200) default null,
284 `tosca_node_type` varchar(200) default null,
285 `resource_category` varchar(200) default null,
286 `resource_sub_category` varchar(200) default null,
287 `heat_template_artifact_uuid` varchar(200) default null,
288 primary key (`model_uuid`),
289 key `fk_vnf_resource__heat_template1` (`heat_template_artifact_uuid`),
290 constraint `fk_vnf_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
291 ) engine=innodb default charset=latin1;
296 create table `vf_module` (
297 `model_uuid` varchar(200) not null,
298 `model_invariant_uuid` varchar(200) default null,
299 `model_version` varchar(20) not null,
300 `model_name` varchar(200) not null,
301 `description` varchar(1200) default null,
302 `is_base` int(11) not null,
303 `heat_template_artifact_uuid` varchar(200) default null,
304 `vol_heat_template_artifact_uuid` varchar(200) default null,
305 `creation_timestamp` datetime not null default current_timestamp,
306 `vnf_resource_model_uuid` varchar(200) not null,
307 primary key (`model_uuid`,`vnf_resource_model_uuid`),
308 key `fk_vf_module__vnf_resource1_idx` (`vnf_resource_model_uuid`),
309 key `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`heat_template_artifact_uuid`),
310 key `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`vol_heat_template_artifact_uuid`),
311 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,
312 constraint `fk_vf_module__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade,
313 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
314 ) engine=innodb default charset=latin1;
318 /*!40101 set @saved_cs_client = @@character_set_client */;
319 /*!40101 set character_set_client = utf8 */;
320 create table `vf_module_customization` (
321 `model_customization_uuid` varchar(200) not null,
322 `label` varchar(200) default null,
323 `initial_count` int(11) default '0',
324 `min_instances` int(11) default '0',
325 `max_instances` int(11) default null,
326 `availability_zone_count` int(11) default null,
327 `heat_environment_artifact_uuid` varchar(200) default null,
328 `vol_environment_artifact_uuid` varchar(200) default null,
329 `creation_timestamp` datetime not null default current_timestamp,
330 `vf_module_model_uuid` varchar(200) not null,
331 primary key (`model_customization_uuid`),
332 key `fk_vf_module_customization__vf_module1_idx` (`vf_module_model_uuid`),
333 key `fk_vf_module_customization__heat_env__heat_environment1_idx` (`heat_environment_artifact_uuid`),
334 key `fk_vf_module_customization__vol_env__heat_environment2_idx` (`vol_environment_artifact_uuid`),
335 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,
336 constraint `fk_vf_module_customization__vf_module1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade,
337 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
338 ) engine=innodb default charset=latin1;
339 /*!40101 set character_set_client = @saved_cs_client */;
342 -- table structure for table `vf_module_to_heat_files`
346 /*!40101 set @saved_cs_client = @@character_set_client */;
347 /*!40101 set character_set_client = utf8 */;
348 create table `vf_module_to_heat_files` (
349 `vf_module_model_uuid` varchar(200) not null,
350 `heat_files_artifact_uuid` varchar(200) not null,
351 primary key (`vf_module_model_uuid`,`heat_files_artifact_uuid`),
352 key `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`heat_files_artifact_uuid`),
353 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,
354 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
355 ) engine=innodb default charset=latin1 comment='il fait ce qu''il dit';
356 /*!40101 set character_set_client = @saved_cs_client */;
359 -- table structure for table `vnf_components`
363 /*!40101 set @saved_cs_client = @@character_set_client */;
364 /*!40101 set character_set_client = utf8 */;
365 create table `vnf_components` (
366 `vnf_id` int(11) not null,
367 `component_type` varchar(20) not null,
368 `heat_template_id` int(11) default null,
369 `heat_environment_id` int(11) default null,
370 `creation_timestamp` datetime not null default current_timestamp,
371 primary key (`vnf_id`,`component_type`)
372 ) engine=innodb default charset=latin1;
373 /*!40101 set character_set_client = @saved_cs_client */;
376 -- table structure for table `vnf_components_recipe`
381 create table `vnf_components_recipe` (
382 `id` int(11) not null auto_increment,
383 `vnf_type` varchar(200) default null,
384 `vnf_component_type` varchar(45) not null,
385 `action` varchar(50) not null,
386 `service_type` varchar(45) default null,
387 `version` varchar(20) not null,
388 `description` varchar(1200) default null,
389 `orchestration_uri` varchar(256) not null,
390 `vnf_component_param_xsd` varchar(2048) default null,
391 `recipe_timeout` int(11) default null,
392 `creation_timestamp` datetime default current_timestamp,
393 `vf_module_model_uuid` varchar(200) default null,
395 unique key `uk_4dpdwddaaclhc11wxsb7h59ma` (`vf_module_model_uuid`,`vnf_component_type`,`action`,`version`)
396 ) engine=innodb auto_increment=26 default charset=latin1;
401 create table `vnf_recipe` (
402 `id` int(11) not null auto_increment,
403 `vnf_type` varchar(200) default null,
404 `action` varchar(50) not null,
405 `service_type` varchar(45) default null,
406 `version_str` varchar(20) not null,
407 `description` varchar(1200) default null,
408 `orchestration_uri` varchar(256) not null,
409 `vnf_param_xsd` varchar(2048) default null,
410 `recipe_timeout` int(11) default null,
411 `creation_timestamp` datetime default current_timestamp,
412 `vf_module_id` varchar(100) default null,
414 unique key `uk_f3tvqau498vrifq3cr8qnigkr` (`vf_module_id`,`action`,`version_str`)
415 ) engine=innodb auto_increment=10006 default charset=latin1;
424 create table `vnf_resource_customization` (
425 `model_customization_uuid` varchar(200) not null,
426 `model_instance_name` varchar(200) not null,
427 `min_instances` int(11) default null,
428 `max_instances` int(11) default null,
429 `availability_zone_max_count` int(11) default null,
430 `nf_type` varchar(200) default null,
431 `nf_role` varchar(200) default null,
432 `nf_function` varchar(200) default null,
433 `nf_naming_code` varchar(200) default null,
434 `creation_timestamp` datetime not null default current_timestamp,
435 `vnf_resource_model_uuid` varchar(200) not null,
436 `multi_stage_design` varchar(20) default null,
437 primary key (`model_customization_uuid`),
438 key `fk_vnf_resource_customization__vnf_resource1_idx` (`vnf_resource_model_uuid`),
439 constraint `fk_vnf_resource_customization__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade
440 ) engine=innodb default charset=latin1;
445 create table `vnf_res_custom_to_vf_module_custom` (
446 `vnf_resource_cust_model_customization_uuid` varchar(200) not null,
447 `vf_module_cust_model_customization_uuid` varchar(200) not null,
448 `creation_timestamp` datetime not null default current_timestamp,
449 primary key (`vnf_resource_cust_model_customization_uuid`,`vf_module_cust_model_customization_uuid`),
450 key `fk_vnf_res_custom_to_vf_module_custom__vf_module_customizat_idx` (`vf_module_cust_model_customization_uuid`),
451 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,
452 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
453 ) engine=innodb default charset=latin1;
456 create table if not exists external_service_to_internal_model_mapping (
458 service_name varchar(200) not null,
459 product_flavor varchar(200) null,
460 subscription_service_type varchar(200) not null,
461 service_model_uuid varchar(200) not null,
463 unique index uk_external_service_to_internal_model_mapping
464 (service_name asc, product_flavor asc, service_model_uuid asc));
466 create table if not exists `collection_resource` (
467 model_uuid varchar(200) not null,
468 model_name varchar(200) not null,
469 model_invariant_uuid varchar(200) not null,
470 model_version varchar(20) not null,
471 tosca_node_type varchar(200) not null,
472 description varchar(200),
473 creation_timestamp datetime not null default current_timestamp,
474 primary key (`model_uuid`)
475 )engine=innodb default charset=latin1;
477 create table if not exists `collection_resource_customization` (
478 model_customization_uuid varchar(200) not null,
479 model_instance_name varchar(200) not null,
480 role varchar(200) NULL,
481 object_type varchar(200) not null,
482 function varchar(200) NULL,
483 collection_resource_type varchar(200) NULL,
484 creation_timestamp datetime not null default current_timestamp,
485 cr_model_uuid varchar(200) not null,
486 primary key (`model_customization_uuid`)
487 )engine=innodb default charset=latin1;
489 create table if not exists `instance_group` (
490 model_uuid varchar(200) not null,
491 model_name varchar(200) not null,
492 model_invariant_uuid varchar(200) not null,
493 model_version varchar(20) not null,
494 tosca_node_type varchar(200) NULL,
495 role varchar(200) not null,
496 object_type varchar(200) not null,
497 creation_timestamp datetime not null default current_timestamp,
498 cr_model_uuid varchar(200) not null,
499 instance_group_type varchar(200) not null,
500 primary key (`model_uuid`)
501 )engine=innodb default charset=latin1;
503 create table if not exists `collection_resource_instance_group_customization` (
504 `collection_resource_customization_model_uuid` varchar(200) not null,
505 `instance_group_model_uuid` varchar(200) not null,
506 `function` varchar(200) null,
507 `description` varchar(1200) null,
508 `subinterface_network_quantity` int(11) null,
509 `creation_timestamp` datetime not null default current_timestamp,
510 primary key (`collection_resource_customization_model_uuid`, `instance_group_model_uuid`),
511 index `fk_collection_resource_instance_group_customization__instan_idx` (`instance_group_model_uuid` asc),
512 constraint `fk_collection_resource_instance_group_customization__collecti1`
513 foreign key (`collection_resource_customization_model_uuid`)
514 references `collection_resource_customization` (`model_customization_uuid`)
517 constraint `fk_collection_resource_instance_group_customization__instance1`
518 foreign key (`instance_group_model_uuid`)
519 references `instance_group` (`model_uuid`)
523 default character set = latin1;
525 create table if not exists `vnfc_instance_group_customization` (
526 `vnf_resource_customization_model_uuid` varchar(200) not null,
527 `instance_group_model_uuid` varchar(200) not null,
528 `function` varchar(200) null,
529 `description` varchar(1200) null,
530 `creation_timestamp` datetime not null default current_timestamp,
531 primary key (`vnf_resource_customization_model_uuid`, `instance_group_model_uuid`),
532 index `fk_vnfc_instance_group_customization__instance_group1_idx` (`instance_group_model_uuid` asc),
533 constraint `fk_vnfc_instance_group_customization__vnf_resource_customizat1`
534 foreign key (`vnf_resource_customization_model_uuid`)
535 references `vnf_resource_customization` (`model_customization_uuid`)
538 constraint `fk_vnfc_instance_group_customization__instance_group1`
539 foreign key (`instance_group_model_uuid`)
540 references `instance_group` (`model_uuid`)
544 default character set = latin1;
546 create table if not exists `configuration`
547 ( `model_uuid` varchar(200) not null,
548 `model_invariant_uuid` varchar(200) not null,
549 `model_version` varchar(20) not null,
550 `model_name` varchar(200) not null,
551 `tosca_node_type` varchar(200) not null,
552 `description` varchar(1200) null,
553 `creation_timestamp` datetime not null default current_timestamp,
554 primary key (`model_uuid`))
555 engine = innodb auto_increment = 20654
556 default character set = latin1;
558 CREATE TABLE IF NOT EXISTS `service_proxy_customization` (
559 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
560 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
561 `MODEL_UUID` VARCHAR(200) NOT NULL,
562 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
563 `MODEL_VERSION` VARCHAR(20) NOT NULL,
564 `MODEL_NAME` VARCHAR(200) NOT NULL,
565 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
566 `DESCRIPTION` VARCHAR(1200) NULL,
567 `SOURCE_SERVICE_MODEL_UUID` VARCHAR(200) NOT NULL,
568 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
569 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
570 INDEX `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID` ASC),
571 UNIQUE INDEX `UK_service_proxy_customization` (`MODEL_CUSTOMIZATION_UUID` ASC),
572 INDEX `fk_service_proxy_customization__serv_prox_to_serv` (`MODEL_CUSTOMIZATION_UUID` ASC),
573 CONSTRAINT `fk_service_proxy_resource_customization__service1`
574 FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`)
575 REFERENCES `service` (`MODEL_UUID`)
579 AUTO_INCREMENT = 20654
580 DEFAULT CHARACTER SET = latin1;
582 create table if not exists `configuration_customization` (
583 `model_customization_uuid` varchar(200) not null,
584 `model_instance_name` varchar(200) not null,
585 `configuration_type` varchar(200) null,
586 `configuration_role` varchar(200) null,
587 `configuration_function` varchar(200) null,
588 `creation_timestamp` datetime not null default current_timestamp,
589 `configuration_model_uuid` varchar(200) not null,
590 `service_proxy_customization_model_customization_uuid` varchar(200) null,
591 `configuration_customization_model_customization_uuid` varchar(200) null,
592 primary key (`model_customization_uuid`),
593 index `fk_configuration_customization__configuration_idx` (`configuration_model_uuid` asc),
594 index `fk_configuration_customization__service_proxy_customization_idx`
595 (`service_proxy_customization_model_customization_uuid` asc),
596 index `fk_configuration_customization__configuration_customization_idx`
597 (`configuration_customization_model_customization_uuid` asc),
598 constraint `fk_configuration_resource_customization__configuration_resour1`
599 foreign key (`configuration_model_uuid`) references `configuration` (`model_uuid`)
600 on delete cascade on update cascade,
601 constraint `fk_configuration_customization__service_proxy_customization1` foreign
602 key (`service_proxy_customization_model_customization_uuid`) references
603 `service_proxy_customization` (`model_customization_uuid`)
604 on delete cascade on update cascade, constraint
605 `fk_configuration_customization__configuration_customization1` foreign
606 key (`configuration_customization_model_customization_uuid`) references
607 `configuration_customization` (`model_customization_uuid`)
608 on delete cascade on update cascade)
610 auto_increment =20654
611 default character set = latin1;
614 create table `service_proxy_customization_to_service` (
615 `service_model_uuid` varchar(200) not null,
616 `resource_model_customization_uuid` varchar(200) not null,
617 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
618 )engine=innodb default charset=latin1;
621 create table `configuration_customization_to_service` (
622 `service_model_uuid` varchar(200) not null,
623 `resource_model_customization_uuid` varchar(200) not null,
624 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
625 )engine=innodb default charset=latin1;
628 create table if not exists `collection_resource_customization_to_service` (
629 `service_model_uuid` varchar(200) not null,
630 `resource_model_customization_uuid` varchar(200) not null,
631 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
632 )engine=innodb default charset=latin1;
635 create table `network_resource_customization_to_service` (
636 `service_model_uuid` varchar(200) not null,
637 `resource_model_customization_uuid` varchar(200) not null,
638 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
639 )engine=innodb default charset=latin1;
641 create table `vnf_resource_customization_to_service` (
642 `service_model_uuid` varchar(200) not null,
643 `resource_model_customization_uuid` varchar(200) not null,
644 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
645 )engine=innodb default charset=latin1;
647 create table `allotted_resource_customization_to_service` (
648 `service_model_uuid` varchar(200) not null,
649 `resource_model_customization_uuid` varchar(200) not null,
650 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
651 )engine=innodb default charset=latin1;
655 create table ar_recipe (
656 ID INT(11) not null auto_increment,
657 MODEL_NAME VARCHAR(200) NOT NULL,
658 `ACTION` VARCHAR(200) NOT NULL,
659 VERSION_STR VARCHAR(200) NOT NULL,
660 SERVICE_TYPE VARCHAR(200),
661 DESCRIPTION VARCHAR(200),
662 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
663 AR_PARAM_XSD VARCHAR(200),
664 RECIPE_TIMEOUT INT(10),
665 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
667 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
668 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
670 alter table collection_resource_customization
671 add foreign key ( cr_model_uuid)
672 references collection_resource(model_uuid)
675 alter table vnf_resource_customization
677 instance_group_model_uuid varchar(200);
679 alter table network_resource_customization
681 instance_group_model_uuid varchar(200);
684 alter table network_resource_customization
685 add foreign key ( instance_group_model_uuid)
686 references instance_group(model_uuid)
689 alter table collection_resource_customization_to_service
690 add foreign key (service_model_uuid)
691 references service(model_uuid)
694 alter table allotted_resource_customization_to_service
695 add foreign key (service_model_uuid)
696 references service(model_uuid)
700 alter table vnf_resource_customization_to_service
701 add foreign key (service_model_uuid)
702 references service(model_uuid)
706 alter table network_resource_customization_to_service
707 add foreign key (service_model_uuid)
708 references service(model_uuid)
712 alter table network_resource_customization_to_service
713 add foreign key (resource_model_customization_uuid)
714 references network_resource_customization(model_customization_uuid)
717 alter table vnf_resource_customization_to_service
718 add foreign key (resource_model_customization_uuid)
719 references vnf_resource_customization(model_customization_uuid)
722 alter table allotted_resource_customization_to_service
723 add foreign key (resource_model_customization_uuid)
724 references allotted_resource_customization(model_customization_uuid)
727 alter table collection_resource_customization_to_service
728 add foreign key (resource_model_customization_uuid)
729 references collection_resource_customization(model_customization_uuid)
733 create table if not exists `collection_network_resource_customization` (
734 `model_customization_uuid` varchar(200) not null,
735 `model_instance_name` varchar(200) not null,
736 `network_technology` varchar(45) null,
737 `network_type` varchar(45) null,
738 `network_role` varchar(200) null,
739 `network_scope` varchar(45) null,
740 `creation_timestamp` datetime not null default current_timestamp,
741 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
742 `crc_model_customization_uuid` varchar(200) not null, primary key
743 (`model_customization_uuid`, `crc_model_customization_uuid`),
744 index `fk_collection_net_resource_customization__network_resource1_idx`
745 (`network_resource_model_uuid` asc), index
746 `fk_collection_net_resource_customization__instance_group1_idx`
747 (`instance_group_model_uuid` asc), index
748 `fk_col_net_res_customization__collection_res_customization_idx`
749 (`crc_model_customization_uuid` asc), constraint
750 `fk_collection_net_resource_customization__network_resource10` foreign
751 key (`network_resource_model_uuid`) references
752 `network_resource` (`model_uuid`) on delete cascade on
753 update cascade, constraint
754 `fk_collection_net_resource_customization__instance_group10` foreign key
755 (`instance_group_model_uuid`) references `instance_group`
756 (`model_uuid`) on delete cascade on update cascade, constraint
757 `fk_collection_network_resource_customization__collection_reso1` foreign
758 key (`crc_model_customization_uuid`) references
759 `collection_resource_customization`
760 (`model_customization_uuid`) on delete cascade on update cascade) engine
761 = innodb default character set = latin1;
763 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
764 `id` INT(11) NOT NULL AUTO_INCREMENT,
765 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
766 `MACRO_ACTION` VARCHAR(200) NOT NULL,
767 `ACTION` VARCHAR(200) NOT NULL,
768 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
769 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 1,
770 `MIN_API_VERSION` DOUBLE NOT NULL,
771 `MAX_API_VERSION` DOUBLE NULL,
773 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC, `MACRO_ACTION` ASC))
775 DEFAULT CHARACTER SET = latin1;
777 CREATE TABLE IF NOT EXISTS orchestration_status_state_transition_directive (
778 id INT(11) AUTO_INCREMENT,
779 RESOURCE_TYPE VARCHAR(25) NOT NULL,
780 ORCHESTRATION_STATUS VARCHAR(25) NOT NULL,
781 TARGET_ACTION VARCHAR(25) NOT NULL,
782 FLOW_DIRECTIVE VARCHAR(25) NOT NULL,
784 UNIQUE KEY UK_orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION))
786 DEFAULT CHARACTER SET = latin1;
788 create table if not exists model_recipe (
789 `ID` INT(11) NOT NULL AUTO_INCREMENT,
791 `ACTION` VARCHAR(40),
792 `SCHEMA_VERSION` VARCHAR(40),
793 `DESCRIPTION` VARCHAR(40),
794 `ORCHESTRATION_URI` VARCHAR(20),
795 `MODEL_PARAM_XSD` VARCHAR(20),
796 `RECIPE_TIMEOUT` INT(11),
797 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
799 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
800 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
802 create table if not exists model (
803 `ID` INT(11) NOT NULL AUTO_INCREMENT,
804 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
805 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
806 `MODEL_INVARIANT_ID` VARCHAR(40),
807 `MODEL_NAME` VARCHAR(40),
808 `MODEL_TYPE` VARCHAR(20),
809 `MODEL_VERSION` VARCHAR(20),
810 `MODEL_VERSION_ID` VARCHAR(40),
811 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
814 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
815 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
816 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
818 CREATE TABLE IF NOT EXISTS `controller_selection_reference` (
819 `VNF_TYPE` VARCHAR(50) NOT NULL,
820 `CONTROLLER_NAME` VARCHAR(100) NOT NULL,
821 `ACTION_CATEGORY` VARCHAR(15) NOT NULL,
822 PRIMARY KEY (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`)
825 ALTER TABLE `vnf_recipe`
826 CHANGE COLUMN `VNF_TYPE` `NF_ROLE` VARCHAR(200) NULL DEFAULT NULL ;
828 CREATE TABLE IF NOT EXISTS `identity_services` (
829 `ID` varchar(50) NOT NULL,
830 `IDENTITY_URL` varchar(200) DEFAULT NULL,
831 `MSO_ID` varchar(255) DEFAULT NULL,
832 `MSO_PASS` varchar(255) DEFAULT NULL,
833 `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL,
834 `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL,
835 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
836 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
837 `TENANT_METADATA` tinyint(1) DEFAULT 0,
838 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
839 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
840 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
841 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
842 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
846 CREATE TABLE IF NOT EXISTS `cloudify_managers` (
847 `ID` varchar(50) NOT NULL,
848 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
849 `USERNAME` varchar(255) DEFAULT NULL,
850 `PASSWORD` varchar(255) DEFAULT NULL,
851 `VERSION` varchar(20) DEFAULT NULL,
852 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
853 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
854 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
858 CREATE TABLE IF NOT EXISTS `cloud_sites` (
859 `ID` varchar(50) NOT NULL,
860 `REGION_ID` varchar(11) DEFAULT NULL,
861 `IDENTITY_SERVICE_ID` varchar(50) DEFAULT NULL,
862 `CLOUD_VERSION` varchar(20) DEFAULT NULL,
863 `CLLI` varchar(11) DEFAULT NULL,
864 `CLOUDIFY_ID` varchar(50) DEFAULT NULL,
865 `PLATFORM` varchar(50) DEFAULT NULL,
866 `ORCHESTRATOR` varchar(50) DEFAULT NULL,
867 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
868 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
869 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
871 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
872 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)
875 CREATE TABLE IF NOT EXISTS vnfc_customization (
876 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
877 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
878 `MODEL_UUID` VARCHAR(200) NOT NULL,
879 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
880 `MODEL_VERSION` VARCHAR(20) NOT NULL,
881 `MODEL_NAME` VARCHAR(200) NOT NULL,
882 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
883 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
884 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
885 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`))
887 AUTO_INCREMENT = 20654
888 DEFAULT CHARACTER SET = latin1;
890 CREATE TABLE IF NOT EXISTS cvnfc_customization (
891 `ID` INT(11) NOT NULL AUTO_INCREMENT,
892 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
893 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
894 `MODEL_UUID` VARCHAR(200) NOT NULL,
895 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
896 `MODEL_VERSION` VARCHAR(20) NOT NULL,
897 `MODEL_NAME` VARCHAR(200) NOT NULL,
898 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
899 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
900 `NFC_FUNCTION` VARCHAR(200) NULL,
901 `NFC_NAMING_CODE` VARCHAR(200) NULL,
902 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
903 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
904 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
905 `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
907 UPDATE CASCADE, CONSTRAINT `fk_cvnfc_customization__vnfc_customization1` FOREIGN KEY (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`) REFERENCES `vnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON
909 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
911 UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = latin1;
914 CREATE TABLE IF NOT EXISTS vnf_vfmodule_cvnfc_configuration_customization (
915 `ID` INT(11) NOT NULL AUTO_INCREMENT,
916 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
917 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
918 `VF_MODULE_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
919 `CVNFC_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
920 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
921 `CONFIGURATION_TYPE` VARCHAR(200) NULL,
922 `CONFIGURATION_ROLE` VARCHAR(200) NULL,
923 `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
924 `POLICY_NAME` VARCHAR(200) NULL,
925 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
926 `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
928 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
929 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),
930 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__cvnfc_cust1_idx` (`CVNFC_MODEL_CUSTOMIZATION_UUID` ASC),
931 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vf_module_cust_idx` (`VF_MODULE_MODEL_CUSTOMIZATION_UUID` ASC),
932 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vnf_res_cust_idx` (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC),
933 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
934 REFERENCES `configuration` (`MODEL_UUID`)
935 ON DELETE CASCADE ON UPDATE CASCADE,
936 CONSTRAINT `fk_cvnfc_configuration_customization__cvnfc_customization1` FOREIGN KEY (`CVNFC_MODEL_CUSTOMIZATION_UUID`)
937 REFERENCES `cvnfc_customization` (`MODEL_CUSTOMIZATION_UUID`)
938 ON DELETE CASCADE ON UPDATE CASCADE,
939 CONSTRAINT `fk_vnf_configuration_cvnfc_customization__vf_module_customiza1` FOREIGN KEY (`VF_MODULE_MODEL_CUSTOMIZATION_UUID`)
940 REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`)
941 ON DELETE CASCADE ON UPDATE CASCADE,
942 CONSTRAINT `fk_vfmodule_cvnfc_configuration_customization__vnf_resource_c1` FOREIGN KEY (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`)
943 REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`)
944 ON DELETE CASCADE ON UPDATE CASCADE
945 ) ENGINE=INNODB AUTO_INCREMENT=20654 DEFAULT CHARACTER SET=LATIN1;