2 create table `allotted_resource` (
3 `model_uuid` varchar(200) not null,
4 `model_invariant_uuid` varchar(200) not null,
5 `model_version` varchar(20) not null,
6 `model_name` varchar(200) not null,
7 `tosca_node_type` varchar(200) default null,
8 `subcategory` varchar(200) default null,
9 `description` varchar(1200) default null,
10 `creation_timestamp` datetime not null default current_timestamp,
11 primary key (`model_uuid`)
12 ) engine=innodb default charset=latin1;
17 create table `allotted_resource_customization` (
18 `model_customization_uuid` varchar(200) not null,
19 `model_instance_name` varchar(200) not null,
20 `providing_service_model_uuid` varchar(200) default null,
21 `providing_service_model_invariant_uuid` varchar(200) default null,
22 `providing_service_model_name` varchar(200) default null,
23 `target_network_role` varchar(200) default null,
24 `nf_type` varchar(200) default null,
25 `nf_role` varchar(200) default null,
26 `nf_function` varchar(200) default null,
27 `nf_naming_code` varchar(200) default null,
28 `min_instances` int(11) default null,
29 `max_instances` int(11) default null,
30 `ar_model_uuid` varchar(200) not null,
31 `creation_timestamp` datetime not null default current_timestamp,
32 primary key (`model_customization_uuid`),
33 key `fk_allotted_resource_customization__allotted_resource1_idx` (`ar_model_uuid`),
34 constraint `fk_allotted_resource_customization__allotted_resource1` foreign key (`ar_model_uuid`) references `allotted_resource` (`model_uuid`) on delete cascade on update cascade
35 ) engine=innodb default charset=latin1;
40 create table `heat_environment` (
41 `artifact_uuid` varchar(200) not null,
42 `name` varchar(100) not null,
43 `version` varchar(20) not null,
44 `description` varchar(1200) default null,
45 `body` longtext not null,
46 `artifact_checksum` varchar(200) not null default 'manual record',
47 `creation_timestamp` datetime not null default current_timestamp,
48 primary key (`artifact_uuid`)
49 ) engine=innodb default charset=latin1;
53 create table `heat_files` (
54 `artifact_uuid` varchar(200) not null,
55 `name` varchar(200) not null,
56 `version` varchar(20) not null,
57 `description` varchar(1200) default null,
58 `body` longtext not null,
59 `artifact_checksum` varchar(200) not null default 'manual record',
60 `creation_timestamp` datetime not null default current_timestamp,
61 primary key (`artifact_uuid`)
62 ) engine=innodb default charset=latin1;
67 create table `heat_template` (
68 `artifact_uuid` varchar(200) not null,
69 `name` varchar(200) not null,
70 `version` varchar(20) not null,
71 `description` varchar(1200) default null,
72 `body` longtext not null,
73 `timeout_minutes` int(11) default null,
74 `artifact_checksum` varchar(200) not null default 'manual record',
75 `creation_timestamp` datetime not null default current_timestamp,
76 primary key (`artifact_uuid`)
77 ) engine=innodb default charset=latin1;
81 create table `heat_nested_template` (
82 `parent_heat_template_uuid` varchar(200) not null,
83 `child_heat_template_uuid` varchar(200) not null,
84 `provider_resource_file` varchar(100) default null,
85 primary key (`parent_heat_template_uuid`,`child_heat_template_uuid`),
86 key `fk_heat_nested_template__heat_template2_idx` (`child_heat_template_uuid`),
87 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,
88 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
89 ) engine=innodb default charset=latin1;
94 create table `heat_template_params` (
95 `heat_template_artifact_uuid` varchar(200) not null,
96 `param_name` varchar(100) not null,
97 `is_required` bit(1) not null,
98 `param_type` varchar(20) default null,
99 `param_alias` varchar(45) default null,
100 primary key (`heat_template_artifact_uuid`,`param_name`),
101 constraint `fk_heat_template_params__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
102 ) engine=innodb default charset=latin1;
106 create table `network_recipe` (
107 `id` int(11) not null auto_increment,
108 `model_name` varchar(20) not null,
109 `action` varchar(50) not null,
110 `description` varchar(1200) default null,
111 `orchestration_uri` varchar(256) not null,
112 `network_param_xsd` varchar(2048) default null,
113 `recipe_timeout` int(11) default null,
114 `service_type` varchar(45) default null,
115 `creation_timestamp` datetime not null default current_timestamp,
116 `version_str` varchar(20) not null,
118 unique key `uk_rl4f296i0p8lyokxveaiwkayi` (`model_name`,`action`,`version_str`)
119 ) engine=innodb auto_increment=178 default charset=latin1;
124 create table `temp_network_heat_template_lookup` (
125 `network_resource_model_name` varchar(200) not null,
126 `heat_template_artifact_uuid` varchar(200) not null,
127 `aic_version_min` varchar(20) not null,
128 `aic_version_max` varchar(20) default null,
129 primary key (`network_resource_model_name`),
130 key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
131 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
132 ) engine=innodb default charset=latin1;
136 create table `network_resource` (
137 `model_uuid` varchar(200) not null,
138 `model_name` varchar(200) not null,
139 `model_invariant_uuid` varchar(200) default null,
140 `description` varchar(1200) default null,
141 `heat_template_artifact_uuid` varchar(200) not null,
142 `neutron_network_type` varchar(20) default null,
143 `model_version` varchar(20) default null,
144 `tosca_node_type` varchar(200) default null,
145 `aic_version_min` varchar(20) not null,
146 `aic_version_max` varchar(20) default null,
147 `orchestration_mode` varchar(20) default 'heat',
148 `resource_category` varchar(20) default null,
149 `resource_sub_category` varchar(20) default null,
150 `creation_timestamp` datetime not null default current_timestamp,
151 primary key (`model_uuid`),
152 key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
153 key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
154 constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade,
155 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
156 ) engine=innodb default charset=latin1;
162 create table `network_resource_customization` (
163 `model_customization_uuid` varchar(200) not null,
164 `model_instance_name` varchar(200) not null,
165 `network_technology` varchar(45) default null,
166 `network_type` varchar(45) default null,
167 `network_role` varchar(200) default null,
168 `network_scope` varchar(45) default null,
169 `creation_timestamp` datetime not null default current_timestamp,
170 `network_resource_model_uuid` varchar(200) not null,
171 primary key (`model_customization_uuid`),
172 key `fk_network_resource_customization__network_resource1_idx` (`network_resource_model_uuid`),
173 constraint `fk_network_resource_customization__network_resource1` foreign key (`network_resource_model_uuid`) references `network_resource` (`model_uuid`) on delete cascade on update cascade
174 ) engine=innodb default charset=latin1;
180 create table `tosca_csar` (
181 `artifact_uuid` varchar(200) not null,
182 `name` varchar(200) not null,
183 `version` varchar(20) not null,
184 `description` varchar(1200) default null,
185 `artifact_checksum` varchar(200) not null,
186 `url` varchar(200) not null,
187 `creation_timestamp` datetime not null default current_timestamp,
188 primary key (`artifact_uuid`)
189 ) engine=innodb default charset=latin1;
194 create table `service` (
195 `model_uuid` varchar(200) not null,
196 `model_name` varchar(200) not null,
197 `model_invariant_uuid` varchar(200) not null,
198 `model_version` varchar(20) not null,
199 `description` varchar(1200) default null,
200 `creation_timestamp` datetime not null default current_timestamp,
201 `tosca_csar_artifact_uuid` varchar(200) default null,
202 `service_type` varchar(200) default null,
203 `service_role` varchar(200) default null,
204 `environment_context` varchar(200) default null,
205 `workload_context` varchar(200) default null,
206 primary key (`model_uuid`),
207 key `fk_service__tosca_csar1_idx` (`tosca_csar_artifact_uuid`),
208 constraint `fk_service__tosca_csar1` foreign key (`tosca_csar_artifact_uuid`) references `tosca_csar` (`artifact_uuid`) on delete cascade on update cascade
209 ) engine=innodb default charset=latin1;
213 create table `service_recipe` (
214 `id` int(11) not null auto_increment,
215 `action` varchar(50) not null,
216 `version_str` varchar(20) default null,
217 `description` varchar(1200) default null,
218 `orchestration_uri` varchar(256) not null,
219 `service_param_xsd` varchar(2048) default null,
220 `recipe_timeout` int(11) default null,
221 `service_timeout_interim` int(11) default null,
222 `creation_timestamp` datetime not null default current_timestamp,
223 `service_model_uuid` varchar(200) not null,
225 unique key `uk_7fav5dkux2v8g9d2i5ymudlgc` (`service_model_uuid`,`action`),
226 key `fk_service_recipe__service1_idx` (`service_model_uuid`),
227 constraint `fk_service_recipe__service1` foreign key (`service_model_uuid`) references `service` (`model_uuid`) on delete cascade on update cascade
228 ) engine=innodb auto_increment=86 default charset=latin1;
232 create table `vnf_resource` (
233 `orchestration_mode` varchar(20) not null default 'heat',
234 `description` varchar(1200) default null,
235 `creation_timestamp` datetime not null default current_timestamp,
236 `model_uuid` varchar(200) not null,
237 `aic_version_min` varchar(20) default null,
238 `aic_version_max` varchar(20) default null,
239 `model_invariant_uuid` varchar(200) default null,
240 `model_version` varchar(20) not null,
241 `model_name` varchar(200) default null,
242 `tosca_node_type` varchar(200) default null,
243 `resource_category` varchar(200) default null,
244 `resource_sub_category` varchar(200) default null,
245 `heat_template_artifact_uuid` varchar(200) default null,
246 primary key (`model_uuid`),
247 key `fk_vnf_resource__heat_template1` (`heat_template_artifact_uuid`),
248 constraint `fk_vnf_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
249 ) engine=innodb default charset=latin1;
254 create table `vf_module` (
255 `model_uuid` varchar(200) not null,
256 `model_invariant_uuid` varchar(200) default null,
257 `model_version` varchar(20) not null,
258 `model_name` varchar(200) not null,
259 `description` varchar(1200) default null,
260 `is_base` int(11) not null,
261 `heat_template_artifact_uuid` varchar(200) default null,
262 `vol_heat_template_artifact_uuid` varchar(200) default null,
263 `creation_timestamp` datetime not null default current_timestamp,
264 `vnf_resource_model_uuid` varchar(200) not null,
265 primary key (`model_uuid`,`vnf_resource_model_uuid`),
266 key `fk_vf_module__vnf_resource1_idx` (`vnf_resource_model_uuid`),
267 key `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`heat_template_artifact_uuid`),
268 key `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`vol_heat_template_artifact_uuid`),
269 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,
270 constraint `fk_vf_module__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade,
271 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
272 ) engine=innodb default charset=latin1;
276 /*!40101 set @saved_cs_client = @@character_set_client */;
277 /*!40101 set character_set_client = utf8 */;
278 create table `vf_module_customization` (
279 `model_customization_uuid` varchar(200) not null,
280 `label` varchar(200) default null,
281 `initial_count` int(11) default '0',
282 `min_instances` int(11) default '0',
283 `max_instances` int(11) default null,
284 `availability_zone_count` int(11) default null,
285 `heat_environment_artifact_uuid` varchar(200) default null,
286 `vol_environment_artifact_uuid` varchar(200) default null,
287 `creation_timestamp` datetime not null default current_timestamp,
288 `vf_module_model_uuid` varchar(200) not null,
289 primary key (`model_customization_uuid`),
290 key `fk_vf_module_customization__vf_module1_idx` (`vf_module_model_uuid`),
291 key `fk_vf_module_customization__heat_env__heat_environment1_idx` (`heat_environment_artifact_uuid`),
292 key `fk_vf_module_customization__vol_env__heat_environment2_idx` (`vol_environment_artifact_uuid`),
293 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,
294 constraint `fk_vf_module_customization__vf_module1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade,
295 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
296 ) engine=innodb default charset=latin1;
297 /*!40101 set character_set_client = @saved_cs_client */;
303 create table `vf_module_to_heat_files` (
304 `vf_module_model_uuid` varchar(200) not null,
305 `heat_files_artifact_uuid` varchar(200) not null,
306 primary key (`vf_module_model_uuid`,`heat_files_artifact_uuid`),
307 key `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`heat_files_artifact_uuid`),
308 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,
309 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
310 ) engine=innodb default charset=latin1 comment='il fait ce qu''il dit';
315 create table `vnf_components` (
316 `vnf_id` int(11) not null,
317 `component_type` varchar(20) not null,
318 `heat_template_id` int(11) default null,
319 `heat_environment_id` int(11) default null,
320 `creation_timestamp` datetime not null default current_timestamp,
321 primary key (`vnf_id`,`component_type`)
322 ) engine=innodb default charset=latin1;
327 create table `vnf_components_recipe` (
328 `id` int(11) not null auto_increment,
329 `vnf_type` varchar(200) default null,
330 `vnf_component_type` varchar(45) not null,
331 `action` varchar(50) not null,
332 `service_type` varchar(45) default null,
333 `version` varchar(20) not null,
334 `description` varchar(1200) default null,
335 `orchestration_uri` varchar(256) not null,
336 `vnf_component_param_xsd` varchar(2048) default null,
337 `recipe_timeout` int(11) default null,
338 `creation_timestamp` datetime default current_timestamp,
339 `vf_module_model_uuid` varchar(200) default null,
341 unique key `uk_4dpdwddaaclhc11wxsb7h59ma` (`vf_module_model_uuid`,`vnf_component_type`,`action`,`version`)
342 ) engine=innodb auto_increment=26 default charset=latin1;
347 create table `vnf_recipe` (
348 `id` int(11) not null auto_increment,
349 `vnf_type` varchar(200) default null,
350 `action` varchar(50) not null,
351 `service_type` varchar(45) default null,
352 `version_str` varchar(20) not null,
353 `description` varchar(1200) default null,
354 `orchestration_uri` varchar(256) not null,
355 `vnf_param_xsd` varchar(2048) default null,
356 `recipe_timeout` int(11) default null,
357 `creation_timestamp` datetime default current_timestamp,
358 `vf_module_id` varchar(100) default null,
360 unique key `uk_f3tvqau498vrifq3cr8qnigkr` (`vf_module_id`,`action`,`version_str`)
361 ) engine=innodb auto_increment=10006 default charset=latin1;
364 ALTER TABLE `catalogdb`.`vnf_recipe`
365 CHANGE COLUMN `VNF_TYPE` `NF_ROLE` VARCHAR(200) NULL DEFAULT NULL ;
371 create table `vnf_resource_customization` (
372 `model_customization_uuid` varchar(200) not null,
373 `model_instance_name` varchar(200) not null,
374 `min_instances` int(11) default null,
375 `max_instances` int(11) default null,
376 `availability_zone_max_count` int(11) default null,
377 `nf_type` varchar(200) default null,
378 `nf_role` varchar(200) default null,
379 `nf_function` varchar(200) default null,
380 `nf_naming_code` varchar(200) default null,
381 `creation_timestamp` datetime not null default current_timestamp,
382 `vnf_resource_model_uuid` varchar(200) not null,
383 `multi_stage_design` varchar(20) default null,
384 primary key (`model_customization_uuid`),
385 key `fk_vnf_resource_customization__vnf_resource1_idx` (`vnf_resource_model_uuid`),
386 constraint `fk_vnf_resource_customization__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade
387 ) engine=innodb default charset=latin1;
392 create table `vnf_res_custom_to_vf_module_custom` (
393 `vnf_resource_cust_model_customization_uuid` varchar(200) not null,
394 `vf_module_cust_model_customization_uuid` varchar(200) not null,
395 `creation_timestamp` datetime not null default current_timestamp,
396 primary key (`vnf_resource_cust_model_customization_uuid`,`vf_module_cust_model_customization_uuid`),
397 key `fk_vnf_res_custom_to_vf_module_custom__vf_module_customizat_idx` (`vf_module_cust_model_customization_uuid`),
398 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,
399 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
400 ) engine=innodb default charset=latin1;
403 create table if not exists external_service_to_internal_model_mapping (
405 service_name varchar(200) not null,
406 product_flavor varchar(200) null,
407 subscription_service_type varchar(200) not null,
408 service_model_uuid varchar(200) not null,
410 unique index uk_external_service_to_internal_model_mapping
411 (service_name asc, product_flavor asc, service_model_uuid asc));
413 create table if not exists `collection_resource` (
414 model_uuid varchar(200) not null,
415 model_name varchar(200) not null,
416 model_invariant_uuid varchar(200) not null,
417 model_version varchar(20) not null,
418 tosca_node_type varchar(200) not null,
419 description varchar(200),
420 creation_timestamp datetime not null default current_timestamp,
421 primary key (`model_uuid`)
422 )engine=innodb default charset=latin1;
424 create table if not exists `collection_resource_customization` (
425 model_customization_uuid varchar(200) not null,
426 model_instance_name varchar(200) not null,
427 role varchar(200) NULL,
428 object_type varchar(200) not null,
429 function varchar(200) NULL,
430 collection_resource_type varchar(200) NULL,
431 creation_timestamp datetime not null default current_timestamp,
432 cr_model_uuid varchar(200) not null,
433 primary key (`model_customization_uuid`)
434 )engine=innodb default charset=latin1;
436 create table if not exists `instance_group` (
437 model_uuid varchar(200) not null,
438 model_name varchar(200) not null,
439 model_invariant_uuid varchar(200) not null,
440 model_version varchar(20) not null,
441 tosca_node_type varchar(200) NULL,
442 role varchar(200) not null,
443 object_type varchar(200) not null,
444 creation_timestamp datetime not null default current_timestamp,
445 cr_model_uuid varchar(200) not null,
446 instance_group_type varchar(200) not null,
447 primary key (`model_uuid`)
448 )engine=innodb default charset=latin1;
450 create table if not exists `collection_resource_instance_group_customization` (
451 `collection_resource_customization_model_uuid` varchar(200) not null,
452 `instance_group_model_uuid` varchar(200) not null,
453 `function` varchar(200) null,
454 `description` varchar(1200) null,
455 `subinterface_network_quantity` int(11) null,
456 `creation_timestamp` datetime not null default current_timestamp,
457 primary key (`collection_resource_customization_model_uuid`, `instance_group_model_uuid`),
458 index `fk_collection_resource_instance_group_customization__instan_idx` (`instance_group_model_uuid` asc),
459 constraint `fk_collection_resource_instance_group_customization__collecti1`
460 foreign key (`collection_resource_customization_model_uuid`)
461 references `collection_resource_customization` (`model_customization_uuid`)
464 constraint `fk_collection_resource_instance_group_customization__instance1`
465 foreign key (`instance_group_model_uuid`)
466 references `instance_group` (`model_uuid`)
470 default character set = latin1;
472 create table if not exists `vnfc_instance_group_customization` (
473 `vnf_resource_customization_model_uuid` varchar(200) not null,
474 `instance_group_model_uuid` varchar(200) not null,
475 `function` varchar(200) null,
476 `description` varchar(1200) null,
477 `creation_timestamp` datetime not null default current_timestamp,
478 primary key (`vnf_resource_customization_model_uuid`, `instance_group_model_uuid`),
479 index `fk_vnfc_instance_group_customization__instance_group1_idx` (`instance_group_model_uuid` asc),
480 constraint `fk_vnfc_instance_group_customization__vnf_resource_customizat1`
481 foreign key (`vnf_resource_customization_model_uuid`)
482 references `vnf_resource_customization` (`model_customization_uuid`)
485 constraint `fk_vnfc_instance_group_customization__instance_group1`
486 foreign key (`instance_group_model_uuid`)
487 references `instance_group` (`model_uuid`)
491 default character set = latin1;
493 create table if not exists `configuration`
494 ( `model_uuid` varchar(200) not null,
495 `model_invariant_uuid` varchar(200) not null,
496 `model_version` varchar(20) not null,
497 `model_name` varchar(200) not null,
498 `tosca_node_type` varchar(200) not null,
499 `description` varchar(1200) null,
500 `creation_timestamp` datetime not null default current_timestamp,
501 primary key (`model_uuid`))
502 engine = innodb auto_increment = 20654
503 default character set = latin1;
505 create table if not exists `service_proxy` (
506 `model_uuid` varchar(200) not null,
507 `model_invariant_uuid` varchar(200) not null,
508 `model_version` varchar(20) not null,
509 `model_name` varchar(200) not null,
510 `description` varchar(1200) null,
511 `creation_timestamp` datetime not null default current_timestamp,
512 primary key (`model_uuid`))
513 engine = innodb auto_increment = 20654
514 default character set = latin1;
516 create table if not exists `service_proxy_customization` (
517 `model_customization_uuid` varchar(200) not null,
518 `model_instance_name` varchar(200) not null,
519 `tosca_node_type` varchar(200) not null,
520 `source_service_model_uuid` varchar(200) not null,
521 `creation_timestamp` datetime not null default current_timestamp,
522 `service_proxy_model_uuid` varchar(200) not null,
523 primary key (`model_customization_uuid`),
524 index `fk_service_proxy_customization__service_proxy1_idx` (`service_proxy_model_uuid` asc),
525 index `fk_service_proxy_customization__service1_idx` (`source_service_model_uuid` asc),
526 constraint`fk_spr_customization__service_proxy_resource1`
527 foreign key (`service_proxy_model_uuid`) references `service_proxy` (`model_uuid`)
528 on delete cascade on update cascade,
529 constraint `fk_service_proxy_resource_customization__service1`
530 foreign key (`source_service_model_uuid`) references `service`
531 (`model_uuid`) on delete cascade on update cascade)
533 auto_increment = 20654
534 default character set = latin1;
536 create table if not exists `configuration_customization` (
537 `model_customization_uuid` varchar(200) not null,
538 `model_instance_name` varchar(200) not null,
539 `configuration_type` varchar(200) null,
540 `configuration_role` varchar(200) null,
541 `configuration_function` varchar(200) null,
542 `creation_timestamp` datetime not null default current_timestamp,
543 `configuration_model_uuid` varchar(200) not null,
544 `service_proxy_customization_model_customization_uuid` varchar(200) null,
545 `configuration_customization_model_customization_uuid` varchar(200) null,
546 primary key (`model_customization_uuid`),
547 index `fk_configuration_customization__configuration_idx` (`configuration_model_uuid` asc),
548 index `fk_configuration_customization__service_proxy_customization_idx`
549 (`service_proxy_customization_model_customization_uuid` asc),
550 index `fk_configuration_customization__configuration_customization_idx`
551 (`configuration_customization_model_customization_uuid` asc),
552 constraint `fk_configuration_resource_customization__configuration_resour1`
553 foreign key (`configuration_model_uuid`) references `configuration` (`model_uuid`)
554 on delete cascade on update cascade,
555 constraint `fk_configuration_customization__service_proxy_customization1` foreign
556 key (`service_proxy_customization_model_customization_uuid`) references
557 `service_proxy_customization` (`model_customization_uuid`)
558 on delete cascade on update cascade, constraint
559 `fk_configuration_customization__configuration_customization1` foreign
560 key (`configuration_customization_model_customization_uuid`) references
561 `configuration_customization` (`model_customization_uuid`)
562 on delete cascade on update cascade)
564 auto_increment =20654
565 default character set = latin1;
568 create table `service_proxy_customization_to_service` (
569 `service_model_uuid` varchar(200) not null,
570 `resource_model_customization_uuid` varchar(200) not null,
571 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
572 )engine=innodb default charset=latin1;
575 create table `configuration_customization_to_service` (
576 `service_model_uuid` varchar(200) not null,
577 `resource_model_customization_uuid` varchar(200) not null,
578 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
579 )engine=innodb default charset=latin1;
582 create table if not exists `collection_resource_customization_to_service` (
583 `service_model_uuid` varchar(200) not null,
584 `resource_model_customization_uuid` varchar(200) not null,
585 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
586 )engine=innodb default charset=latin1;
589 create table `network_resource_customization_to_service` (
590 `service_model_uuid` varchar(200) not null,
591 `resource_model_customization_uuid` varchar(200) not null,
592 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
593 )engine=innodb default charset=latin1;
595 create table `vnf_resource_customization_to_service` (
596 `service_model_uuid` varchar(200) not null,
597 `resource_model_customization_uuid` varchar(200) not null,
598 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
599 )engine=innodb default charset=latin1;
601 create table `allotted_resource_customization_to_service` (
602 `service_model_uuid` varchar(200) not null,
603 `resource_model_customization_uuid` varchar(200) not null,
604 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
605 )engine=innodb default charset=latin1;
608 alter table collection_resource_customization
609 add foreign key ( cr_model_uuid)
610 references collection_resource(model_uuid)
613 alter table vnf_resource_customization
615 instance_group_model_uuid varchar(200);
617 alter table network_resource_customization
619 instance_group_model_uuid varchar(200);
622 alter table network_resource_customization
623 add foreign key ( instance_group_model_uuid)
624 references instance_group(model_uuid)
627 alter table collection_resource_customization_to_service
628 add foreign key (service_model_uuid)
629 references service(model_uuid)
632 alter table allotted_resource_customization_to_service
633 add foreign key (service_model_uuid)
634 references service(model_uuid)
638 alter table vnf_resource_customization_to_service
639 add foreign key (service_model_uuid)
640 references service(model_uuid)
644 alter table network_resource_customization_to_service
645 add foreign key (service_model_uuid)
646 references service(model_uuid)
650 alter table network_resource_customization_to_service
651 add foreign key (resource_model_customization_uuid)
652 references network_resource_customization(model_customization_uuid)
655 alter table vnf_resource_customization_to_service
656 add foreign key (resource_model_customization_uuid)
657 references vnf_resource_customization(model_customization_uuid)
660 alter table allotted_resource_customization_to_service
661 add foreign key (resource_model_customization_uuid)
662 references allotted_resource_customization(model_customization_uuid)
665 alter table collection_resource_customization_to_service
666 add foreign key (resource_model_customization_uuid)
667 references collection_resource_customization(model_customization_uuid)
670 create table ar_recipe (
671 ID INT(11) not null auto_increment,
672 MODEL_NAME VARCHAR(200) NOT NULL,
673 `ACTION` VARCHAR(200) NOT NULL,
674 VERSION_STR VARCHAR(200) NOT NULL,
675 SERVICE_TYPE VARCHAR(200),
676 DESCRIPTION VARCHAR(200),
677 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
678 AR_PARAM_XSD VARCHAR(200),
679 RECIPE_TIMEOUT INT(10),
680 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
682 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
683 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
685 create table if not exists `collection_network_resource_customization` (
686 `model_customization_uuid` varchar(200) not null,
687 `model_instance_name` varchar(200) not null,
688 `network_technology` varchar(45) null,
689 `network_type` varchar(45) null,
690 `network_role` varchar(200) null,
691 `network_scope` varchar(45) null,
692 `creation_timestamp` datetime not null default current_timestamp,
693 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
694 `crc_model_customization_uuid` varchar(200) not null, primary key
695 (`model_customization_uuid`, `crc_model_customization_uuid`),
696 index `fk_collection_net_resource_customization__network_resource1_idx`
697 (`network_resource_model_uuid` asc), index
698 `fk_collection_net_resource_customization__instance_group1_idx`
699 (`instance_group_model_uuid` asc), index
700 `fk_col_net_res_customization__collection_res_customization_idx`
701 (`crc_model_customization_uuid` asc), constraint
702 `fk_collection_net_resource_customization__network_resource10` foreign
703 key (`network_resource_model_uuid`) references
704 `network_resource` (`model_uuid`) on delete cascade on
705 update cascade, constraint
706 `fk_collection_net_resource_customization__instance_group10` foreign key
707 (`instance_group_model_uuid`) references `instance_group`
708 (`model_uuid`) on delete cascade on update cascade, constraint
709 `fk_collection_network_resource_customization__collection_reso1` foreign
710 key (`crc_model_customization_uuid`) references
711 `collection_resource_customization`
712 (`model_customization_uuid`) on delete cascade on update cascade) engine
713 = innodb default character set = latin1;
715 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
716 `id` INT(11) NOT NULL AUTO_INCREMENT,
717 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
718 `ACTION` VARCHAR(200) NOT NULL,
719 `MACRO_ACTION` VARCHAR(200) NOT NULL,
720 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
721 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 0,
722 `MIN_API_VERSION` DOUBLE NOT NULL,
723 `MAX_API_VERSION` DOUBLE NULL,
725 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC))
727 DEFAULT CHARACTER SET = latin1;
729 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
730 `id` INT(11) NOT NULL AUTO_INCREMENT,
731 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
732 `SEQ_NO` INT(11) NOT NULL,
733 `FLOW_NAME` VARCHAR(200) NOT NULL,
734 `FLOW_VERSION` DOUBLE NOT NULL,
735 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
737 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
738 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
739 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
740 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
741 ON DELETE CASCADE ON UPDATE CASCADE)
742 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
744 CREATE TABLE IF NOT EXISTS `rainy_day_handler_macro` (
745 `id` INT(11) NOT NULL AUTO_INCREMENT,
746 `FLOW_NAME` VARCHAR(200) NOT NULL,
747 `SERVICE_TYPE` VARCHAR(200) NOT NULL,
748 `VNF_TYPE` VARCHAR(200) NOT NULL,
749 `ERROR_CODE` VARCHAR(200) NOT NULL,
750 `WORK_STEP` VARCHAR(200) NOT NULL,
751 `POLICY` VARCHAR(200) NOT NULL,
754 DEFAULT CHARACTER SET = latin1;
756 create table if not exists model_recipe (
757 `ID` INT(11) NOT NULL AUTO_INCREMENT,
759 `ACTION` VARCHAR(40),
760 `SCHEMA_VERSION` VARCHAR(40),
761 `DESCRIPTION` VARCHAR(40),
762 `ORCHESTRATION_URI` VARCHAR(20),
763 `MODEL_PARAM_XSD` VARCHAR(20),
764 `RECIPE_TIMEOUT` INT(11),
765 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
767 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
768 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
770 create table if not exists model (
771 `ID` INT(11) NOT NULL AUTO_INCREMENT,
772 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
773 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
774 `MODEL_INVARIANT_ID` VARCHAR(40),
775 `MODEL_NAME` VARCHAR(40),
776 `MODEL_TYPE` VARCHAR(20),
777 `MODEL_VERSION` VARCHAR(20),
778 `MODEL_VERSION_ID` VARCHAR(40),
779 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
782 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
783 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
784 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;