1 --------START Catalog DB SCHEMA --------
4 create table `allotted_resource` (
5 `model_uuid` varchar(200) not null,
6 `model_invariant_uuid` varchar(200) not null,
7 `model_version` varchar(20) not null,
8 `model_name` varchar(200) not null,
9 `tosca_node_type` varchar(200) default null,
10 `subcategory` varchar(200) default null,
11 `description` varchar(1200) default null,
12 `creation_timestamp` datetime not null default current_timestamp,
13 primary key (`model_uuid`)
14 ) engine=innodb default charset=latin1;
19 create table `allotted_resource_customization` (
20 `model_customization_uuid` varchar(200) not null,
21 `model_instance_name` varchar(200) not null,
22 `providing_service_model_uuid` varchar(200) default null,
23 `providing_service_model_invariant_uuid` varchar(200) default null,
24 `providing_service_model_name` varchar(200) default null,
25 `target_network_role` varchar(200) default null,
26 `nf_type` varchar(200) default null,
27 `nf_role` varchar(200) default null,
28 `nf_function` varchar(200) default null,
29 `nf_naming_code` varchar(200) default null,
30 `min_instances` int(11) default null,
31 `max_instances` int(11) default null,
32 `ar_model_uuid` varchar(200) not null,
33 `resource_input` varchar(20000) default null,
34 `creation_timestamp` datetime not null default current_timestamp,
35 primary key (`model_customization_uuid`),
36 key `fk_allotted_resource_customization__allotted_resource1_idx` (`ar_model_uuid`),
37 constraint `fk_allotted_resource_customization__allotted_resource1` foreign key (`ar_model_uuid`) references `allotted_resource` (`model_uuid`) on delete cascade on update cascade
38 ) engine=innodb default charset=latin1;
43 create table `heat_environment` (
44 `artifact_uuid` varchar(200) not null,
45 `name` varchar(100) not null,
46 `version` varchar(20) not null,
47 `description` varchar(1200) default null,
48 `body` longtext not null,
49 `artifact_checksum` varchar(200) not null default 'manual record',
50 `creation_timestamp` datetime not null default current_timestamp,
51 primary key (`artifact_uuid`)
52 ) engine=innodb default charset=latin1;
56 create table `heat_files` (
57 `artifact_uuid` varchar(200) not null,
58 `name` varchar(200) not null,
59 `version` varchar(20) not null,
60 `description` varchar(1200) default null,
61 `body` longtext not null,
62 `artifact_checksum` varchar(200) not null default 'manual record',
63 `creation_timestamp` datetime not null default current_timestamp,
64 primary key (`artifact_uuid`)
65 ) engine=innodb default charset=latin1;
70 create table `heat_template` (
71 `artifact_uuid` varchar(200) not null,
72 `name` varchar(200) not null,
73 `version` varchar(20) not null,
74 `description` varchar(1200) default null,
75 `body` longtext not null,
76 `timeout_minutes` int(11) default null,
77 `artifact_checksum` varchar(200) not null default 'manual record',
78 `creation_timestamp` datetime not null default current_timestamp,
79 primary key (`artifact_uuid`)
80 ) engine=innodb default charset=latin1;
84 create table `heat_nested_template` (
85 `parent_heat_template_uuid` varchar(200) not null,
86 `child_heat_template_uuid` varchar(200) not null,
87 `provider_resource_file` varchar(100) default null,
88 primary key (`parent_heat_template_uuid`,`child_heat_template_uuid`),
89 key `fk_heat_nested_template__heat_template2_idx` (`child_heat_template_uuid`),
90 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,
91 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
92 ) engine=innodb default charset=latin1;
97 create table `heat_template_params` (
98 `heat_template_artifact_uuid` varchar(200) not null,
99 `param_name` varchar(100) not null,
100 `is_required` bit(1) not null,
101 `param_type` varchar(20) default null,
102 `param_alias` varchar(45) default null,
103 primary key (`heat_template_artifact_uuid`,`param_name`),
104 constraint `fk_heat_template_params__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
105 ) engine=innodb default charset=latin1;
109 create table `network_recipe` (
110 `id` int(11) not null auto_increment,
111 `model_name` varchar(20) not null,
112 `action` varchar(50) not null,
113 `description` varchar(1200) default null,
114 `orchestration_uri` varchar(256) not null,
115 `network_param_xsd` varchar(2048) default null,
116 `recipe_timeout` int(11) default null,
117 `service_type` varchar(45) default null,
118 `creation_timestamp` datetime not null default current_timestamp,
119 `version_str` varchar(20) not null,
121 unique key `uk_rl4f296i0p8lyokxveaiwkayi` (`model_name`,`action`,`version_str`)
122 ) engine=innodb auto_increment=178 default charset=latin1;
127 create table `temp_network_heat_template_lookup` (
128 `network_resource_model_name` varchar(200) not null,
129 `heat_template_artifact_uuid` varchar(200) not null,
130 `aic_version_min` varchar(20) not null,
131 `aic_version_max` varchar(20) default null,
132 primary key (`network_resource_model_name`),
133 key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
134 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
135 ) engine=innodb default charset=latin1;
139 create table `network_resource` (
140 `model_uuid` varchar(200) not null,
141 `model_name` varchar(200) not null,
142 `model_invariant_uuid` varchar(200) default null,
143 `description` varchar(1200) default null,
144 `heat_template_artifact_uuid` varchar(200) null,
145 `neutron_network_type` varchar(20) default null,
146 `model_version` varchar(20) default null,
147 `tosca_node_type` varchar(200) default null,
148 `aic_version_min` varchar(20) null,
149 `aic_version_max` varchar(20) default null,
150 `orchestration_mode` varchar(20) default 'heat',
151 `resource_category` varchar(20) default null,
152 `resource_sub_category` varchar(20) default null,
153 `creation_timestamp` datetime not null default current_timestamp,
154 primary key (`model_uuid`),
155 key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
156 key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
157 constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade
158 ) engine=innodb default charset=latin1;
164 create table `network_resource_customization` (
165 `model_customization_uuid` varchar(200) not null,
166 `model_instance_name` varchar(200) not null,
167 `network_technology` varchar(45) default null,
168 `network_type` varchar(45) default null,
169 `network_role` varchar(200) default null,
170 `network_scope` varchar(45) default null,
171 `creation_timestamp` datetime not null default current_timestamp,
172 `network_resource_model_uuid` varchar(200) not null,
173 `resource_input` varchar(20000) default null,
174 primary key (`model_customization_uuid`),
175 key `fk_network_resource_customization__network_resource1_idx` (`network_resource_model_uuid`),
176 constraint `fk_network_resource_customization__network_resource1` foreign key (`network_resource_model_uuid`) references `network_resource` (`model_uuid`) on delete cascade on update cascade
177 ) engine=innodb default charset=latin1;
183 create table `tosca_csar` (
184 `artifact_uuid` varchar(200) not null,
185 `name` varchar(200) not null,
186 `version` varchar(20) not null,
187 `description` varchar(1200) default null,
188 `artifact_checksum` varchar(200) not null,
189 `url` varchar(200) not null,
190 `creation_timestamp` datetime not null default current_timestamp,
191 primary key (`artifact_uuid`)
192 ) engine=innodb default charset=latin1;
197 create table `service` (
198 `model_uuid` varchar(200) not null,
199 `model_name` varchar(200) not null,
200 `model_invariant_uuid` varchar(200) not null,
201 `model_version` varchar(20) not null,
202 `description` varchar(1200) default null,
203 `creation_timestamp` datetime not null default current_timestamp,
204 `tosca_csar_artifact_uuid` varchar(200) default null,
205 `service_type` varchar(200) default null,
206 `service_role` varchar(200) default null,
207 `environment_context` varchar(200) default null,
208 `workload_context` varchar(200) default null,
209 `service_category` varchar(200) default null,
210 `resource_order` varchar(200) default null,
211 primary key (`model_uuid`),
212 key `fk_service__tosca_csar1_idx` (`tosca_csar_artifact_uuid`),
213 constraint `fk_service__tosca_csar1` foreign key (`tosca_csar_artifact_uuid`) references `tosca_csar` (`artifact_uuid`) on delete cascade on update cascade
214 ) engine=innodb default charset=latin1;
218 create table `service_recipe` (
219 `id` int(11) not null auto_increment,
220 `action` varchar(50) not null,
221 `version_str` varchar(20) default null,
222 `description` varchar(1200) default null,
223 `orchestration_uri` varchar(256) not null,
224 `service_param_xsd` varchar(2048) default null,
225 `recipe_timeout` int(11) default null,
226 `service_timeout_interim` int(11) default null,
227 `creation_timestamp` datetime not null default current_timestamp,
228 `service_model_uuid` varchar(200) not null,
230 unique key `uk_7fav5dkux2v8g9d2i5ymudlgc` (`service_model_uuid`,`action`),
231 key `fk_service_recipe__service1_idx` (`service_model_uuid`),
232 constraint `fk_service_recipe__service1` foreign key (`service_model_uuid`) references `service` (`model_uuid`) on delete cascade on update cascade
233 ) engine=innodb auto_increment=86 default charset=latin1;
237 create table `vnf_resource` (
238 `orchestration_mode` varchar(20) not null default 'heat',
239 `description` varchar(1200) default null,
240 `creation_timestamp` datetime not null default current_timestamp,
241 `model_uuid` varchar(200) not null,
242 `aic_version_min` varchar(20) default null,
243 `aic_version_max` varchar(20) default null,
244 `model_invariant_uuid` varchar(200) default null,
245 `model_version` varchar(20) not null,
246 `model_name` varchar(200) default null,
247 `tosca_node_type` varchar(200) default null,
248 `resource_category` varchar(200) default null,
249 `resource_sub_category` varchar(200) default null,
250 `heat_template_artifact_uuid` varchar(200) default null,
251 primary key (`model_uuid`),
252 key `fk_vnf_resource__heat_template1` (`heat_template_artifact_uuid`),
253 constraint `fk_vnf_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
254 ) engine=innodb default charset=latin1;
259 create table `vf_module` (
260 `model_uuid` varchar(200) not null,
261 `model_invariant_uuid` varchar(200) default null,
262 `model_version` varchar(20) not null,
263 `model_name` varchar(200) not null,
264 `description` varchar(1200) default null,
265 `is_base` int(11) not null,
266 `heat_template_artifact_uuid` varchar(200) default null,
267 `vol_heat_template_artifact_uuid` varchar(200) default null,
268 `creation_timestamp` datetime not null default current_timestamp,
269 `vnf_resource_model_uuid` varchar(200) not null,
270 primary key (`model_uuid`,`vnf_resource_model_uuid`),
271 key `fk_vf_module__vnf_resource1_idx` (`vnf_resource_model_uuid`),
272 key `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`heat_template_artifact_uuid`),
273 key `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`vol_heat_template_artifact_uuid`),
274 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,
275 constraint `fk_vf_module__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade,
276 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
277 ) engine=innodb default charset=latin1;
281 /*!40101 set @saved_cs_client = @@character_set_client */;
282 /*!40101 set character_set_client = utf8 */;
283 create table `vf_module_customization` (
284 `model_customization_uuid` varchar(200) not null,
285 `label` varchar(200) default null,
286 `initial_count` int(11) default '0',
287 `min_instances` int(11) default '0',
288 `max_instances` int(11) default null,
289 `availability_zone_count` int(11) default null,
290 `heat_environment_artifact_uuid` varchar(200) default null,
291 `vol_environment_artifact_uuid` varchar(200) default null,
292 `creation_timestamp` datetime not null default current_timestamp,
293 `vf_module_model_uuid` varchar(200) not null,
294 primary key (`model_customization_uuid`),
295 key `fk_vf_module_customization__vf_module1_idx` (`vf_module_model_uuid`),
296 key `fk_vf_module_customization__heat_env__heat_environment1_idx` (`heat_environment_artifact_uuid`),
297 key `fk_vf_module_customization__vol_env__heat_environment2_idx` (`vol_environment_artifact_uuid`),
298 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,
299 constraint `fk_vf_module_customization__vf_module1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade,
300 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
301 ) engine=innodb default charset=latin1;
302 /*!40101 set character_set_client = @saved_cs_client */;
305 -- table structure for table `vf_module_to_heat_files`
309 /*!40101 set @saved_cs_client = @@character_set_client */;
310 /*!40101 set character_set_client = utf8 */;
311 create table `vf_module_to_heat_files` (
312 `vf_module_model_uuid` varchar(200) not null,
313 `heat_files_artifact_uuid` varchar(200) not null,
314 primary key (`vf_module_model_uuid`,`heat_files_artifact_uuid`),
315 key `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`heat_files_artifact_uuid`),
316 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,
317 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
318 ) engine=innodb default charset=latin1 comment='il fait ce qu''il dit';
319 /*!40101 set character_set_client = @saved_cs_client */;
322 -- table structure for table `vnf_components`
326 /*!40101 set @saved_cs_client = @@character_set_client */;
327 /*!40101 set character_set_client = utf8 */;
328 create table `vnf_components` (
329 `vnf_id` int(11) not null,
330 `component_type` varchar(20) not null,
331 `heat_template_id` int(11) default null,
332 `heat_environment_id` int(11) default null,
333 `creation_timestamp` datetime not null default current_timestamp,
334 primary key (`vnf_id`,`component_type`)
335 ) engine=innodb default charset=latin1;
336 /*!40101 set character_set_client = @saved_cs_client */;
339 -- table structure for table `vnf_components_recipe`
344 create table `vnf_components_recipe` (
345 `id` int(11) not null auto_increment,
346 `vnf_type` varchar(200) default null,
347 `vnf_component_type` varchar(45) not null,
348 `action` varchar(50) not null,
349 `service_type` varchar(45) default null,
350 `version` varchar(20) not null,
351 `description` varchar(1200) default null,
352 `orchestration_uri` varchar(256) not null,
353 `vnf_component_param_xsd` varchar(2048) default null,
354 `recipe_timeout` int(11) default null,
355 `creation_timestamp` datetime default current_timestamp,
356 `vf_module_model_uuid` varchar(200) default null,
358 unique key `uk_4dpdwddaaclhc11wxsb7h59ma` (`vf_module_model_uuid`,`vnf_component_type`,`action`,`version`)
359 ) engine=innodb auto_increment=26 default charset=latin1;
364 create table `vnf_recipe` (
365 `id` int(11) not null auto_increment,
366 `nf_role` varchar(200) default null,
367 `action` varchar(50) not null,
368 `service_type` varchar(45) default null,
369 `version_str` varchar(20) not null,
370 `description` varchar(1200) default null,
371 `orchestration_uri` varchar(256) not null,
372 `vnf_param_xsd` varchar(2048) default null,
373 `recipe_timeout` int(11) default null,
374 `creation_timestamp` datetime default current_timestamp,
375 `vf_module_id` varchar(100) default null,
377 unique key `uk_f3tvqau498vrifq3cr8qnigkr` (`vf_module_id`,`action`,`version_str`)
378 ) engine=innodb auto_increment=10006 default charset=latin1;
387 create table `vnf_resource_customization` (
388 `model_customization_uuid` varchar(200) not null,
389 `model_instance_name` varchar(200) not null,
390 `min_instances` int(11) default null,
391 `max_instances` int(11) default null,
392 `availability_zone_max_count` int(11) default null,
393 `nf_type` varchar(200) default null,
394 `nf_role` varchar(200) default null,
395 `nf_function` varchar(200) default null,
396 `nf_naming_code` varchar(200) default null,
397 `creation_timestamp` datetime not null default current_timestamp,
398 `vnf_resource_model_uuid` varchar(200) not null,
399 `multi_stage_design` varchar(20) default null,
400 `resource_input` varchar(20000) default null,
401 primary key (`model_customization_uuid`),
402 key `fk_vnf_resource_customization__vnf_resource1_idx` (`vnf_resource_model_uuid`),
403 constraint `fk_vnf_resource_customization__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade
404 ) engine=innodb default charset=latin1;
409 create table `vnf_res_custom_to_vf_module_custom` (
410 `vnf_resource_cust_model_customization_uuid` varchar(200) not null,
411 `vf_module_cust_model_customization_uuid` varchar(200) not null,
412 `creation_timestamp` datetime not null default current_timestamp,
413 primary key (`vnf_resource_cust_model_customization_uuid`,`vf_module_cust_model_customization_uuid`),
414 key `fk_vnf_res_custom_to_vf_module_custom__vf_module_customizat_idx` (`vf_module_cust_model_customization_uuid`),
415 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,
416 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
417 ) engine=innodb default charset=latin1;
420 create table if not exists `external_service_to_internal_model_mapping` (
422 service_name varchar(200) not null,
423 product_flavor varchar(200) null,
424 subscription_service_type varchar(200) not null,
425 service_model_uuid varchar(200) not null,
427 unique index uk_external_service_to_internal_model_mapping
428 (service_name asc, product_flavor asc, service_model_uuid asc));
430 create table if not exists `collection_resource` (
431 model_uuid varchar(200) not null,
432 model_name varchar(200) not null,
433 model_invariant_uuid varchar(200) not null,
434 model_version varchar(20) not null,
435 tosca_node_type varchar(200) not null,
436 description varchar(200),
437 creation_timestamp datetime not null default current_timestamp,
438 primary key (`model_uuid`)
439 )engine=innodb default charset=latin1;
441 create table if not exists `collection_resource_customization` (
442 model_customization_uuid varchar(200) not null,
443 model_instance_name varchar(200) not null,
444 role varchar(200) NULL,
445 object_type varchar(200) not null,
446 function varchar(200) NULL,
447 collection_resource_type varchar(200) NULL,
448 creation_timestamp datetime not null default current_timestamp,
449 cr_model_uuid varchar(200) not null,
450 primary key (`model_customization_uuid`)
451 )engine=innodb default charset=latin1;
453 create table if not exists `instance_group` (
454 model_uuid varchar(200) not null,
455 model_name varchar(200) not null,
456 model_invariant_uuid varchar(200) not null,
457 model_version varchar(20) not null,
458 tosca_node_type varchar(200) NULL,
459 role varchar(200) not null,
460 object_type varchar(200) not null,
461 creation_timestamp datetime not null default current_timestamp,
462 cr_model_uuid varchar(200) not null,
463 instance_group_type varchar(200) not null,
464 primary key (`model_uuid`)
465 )engine=innodb default charset=latin1;
468 create table if not exists `collection_resource_instance_group_customization` (
469 `collection_resource_customization_model_uuid` varchar(200) not null,
470 `instance_group_model_uuid` varchar(200) not null,
471 `function` varchar(200) null,
472 `description` varchar(1200) null,
473 `subinterface_network_quantity` int(11) null,
474 `creation_timestamp` datetime not null default current_timestamp,
475 primary key (`collection_resource_customization_model_uuid`, `instance_group_model_uuid`),
476 index `fk_collection_resource_instance_group_customization__instan_idx` (`instance_group_model_uuid` asc),
477 constraint `fk_collection_resource_instance_group_customization__collecti1`
478 foreign key (`collection_resource_customization_model_uuid`)
479 references `collection_resource_customization` (`model_customization_uuid`)
482 constraint `fk_collection_resource_instance_group_customization__instance1`
483 foreign key (`instance_group_model_uuid`)
484 references `instance_group` (`model_uuid`)
488 default character set = latin1;
490 create table if not exists `vnfc_instance_group_customization` (
491 `vnf_resource_customization_model_uuid` varchar(200) not null,
492 `instance_group_model_uuid` varchar(200) not null,
493 `function` varchar(200) null,
494 `description` varchar(1200) null,
495 `creation_timestamp` datetime not null default current_timestamp,
496 primary key (`vnf_resource_customization_model_uuid`, `instance_group_model_uuid`),
497 index `fk_vnfc_instance_group_customization__instance_group1_idx` (`instance_group_model_uuid` asc),
498 constraint `fk_vnfc_instance_group_customization__vnf_resource_customizat1`
499 foreign key (`vnf_resource_customization_model_uuid`)
500 references `vnf_resource_customization` (`model_customization_uuid`)
503 constraint `fk_vnfc_instance_group_customization__instance_group1`
504 foreign key (`instance_group_model_uuid`)
505 references `instance_group` (`model_uuid`)
509 default character set = latin1;
511 create table if not exists `configuration`
512 ( `model_uuid` varchar(200) not null,
513 `model_invariant_uuid` varchar(200) not null,
514 `model_version` varchar(20) not null,
515 `model_name` varchar(200) not null,
516 `tosca_node_type` varchar(200) not null,
517 `description` varchar(1200) null,
518 `creation_timestamp` datetime not null default current_timestamp,
519 primary key (`model_uuid`))
520 engine = innodb auto_increment = 20654
521 default character set = latin1;
523 CREATE TABLE IF NOT EXISTS `service_proxy_customization` (
524 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
525 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
526 `MODEL_UUID` VARCHAR(200) NOT NULL,
527 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
528 `MODEL_VERSION` VARCHAR(20) NOT NULL,
529 `MODEL_NAME` VARCHAR(200) NOT NULL,
530 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
531 `DESCRIPTION` VARCHAR(1200) NULL,
532 `SOURCE_SERVICE_MODEL_UUID` VARCHAR(200) NOT NULL,
533 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
534 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
535 INDEX `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID` ASC),
536 UNIQUE INDEX `UK_service_proxy_customization` (`MODEL_CUSTOMIZATION_UUID` ASC),
537 INDEX `fk_service_proxy_customization__serv_prox_to_serv` (`MODEL_CUSTOMIZATION_UUID` ASC),
538 CONSTRAINT `fk_service_proxy_resource_customization__service1`
539 FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`)
540 REFERENCES `service` (`MODEL_UUID`)
544 AUTO_INCREMENT = 20654
545 DEFAULT CHARACTER SET = latin1;
547 create table if not exists `configuration_customization` (
548 `model_customization_uuid` varchar(200) not null,
549 `model_instance_name` varchar(200) not null,
550 `configuration_type` varchar(200) null,
551 `configuration_role` varchar(200) null,
552 `configuration_function` varchar(200) null,
553 `creation_timestamp` datetime not null default current_timestamp,
554 `configuration_model_uuid` varchar(200) not null,
555 `service_proxy_customization_model_customization_uuid` varchar(200) null,
556 `configuration_customization_model_customization_uuid` varchar(200) null,
557 primary key (`model_customization_uuid`),
558 index `fk_configuration_customization__configuration_idx` (`configuration_model_uuid` asc),
559 index `fk_configuration_customization__configuration_customization_idx`
560 (`configuration_customization_model_customization_uuid` asc),
561 constraint `fk_configuration_resource_customization__configuration_resour1`
562 foreign key (`configuration_model_uuid`) references `configuration` (`model_uuid`)
563 on delete cascade on update cascade,
564 constraint `fk_configuration_customization__configuration_customization1`
565 foreign key (`configuration_customization_model_customization_uuid`) references
566 `configuration_customization` (`model_customization_uuid`)
567 on delete cascade on update cascade)
569 auto_increment =20654
570 default character set = latin1;
573 create table `service_proxy_customization_to_service` (
574 `service_model_uuid` varchar(200) not null,
575 `resource_model_customization_uuid` varchar(200) not null,
576 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
577 )engine=innodb default charset=latin1;
580 create table `configuration_customization_to_service` (
581 `service_model_uuid` varchar(200) not null,
582 `resource_model_customization_uuid` varchar(200) not null,
583 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
584 )engine=innodb default charset=latin1;
587 create table if not exists `collection_resource_customization_to_service` (
588 `service_model_uuid` varchar(200) not null,
589 `resource_model_customization_uuid` varchar(200) not null,
590 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
591 )engine=innodb default charset=latin1;
594 create table `network_resource_customization_to_service` (
595 `service_model_uuid` varchar(200) not null,
596 `resource_model_customization_uuid` varchar(200) not null,
597 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
598 )engine=innodb default charset=latin1;
600 create table `vnf_resource_customization_to_service` (
601 `service_model_uuid` varchar(200) not null,
602 `resource_model_customization_uuid` varchar(200) not null,
603 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
604 )engine=innodb default charset=latin1;
606 create table `allotted_resource_customization_to_service` (
607 `service_model_uuid` varchar(200) not null,
608 `resource_model_customization_uuid` varchar(200) not null,
609 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
610 )engine=innodb default charset=latin1;
614 create table ar_recipe (
615 ID INT(11) not null auto_increment,
616 MODEL_NAME VARCHAR(200) NOT NULL,
617 `ACTION` VARCHAR(200) NOT NULL,
618 VERSION_STR VARCHAR(200) NOT NULL,
619 SERVICE_TYPE VARCHAR(200),
620 DESCRIPTION VARCHAR(200),
621 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
622 AR_PARAM_XSD VARCHAR(200),
623 RECIPE_TIMEOUT INT(10),
624 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
626 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
627 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
629 alter table collection_resource_customization
630 add foreign key ( cr_model_uuid)
631 references collection_resource(model_uuid)
634 alter table vnf_resource_customization
636 instance_group_model_uuid varchar(200);
638 alter table network_resource_customization
640 instance_group_model_uuid varchar(200);
643 alter table network_resource_customization
644 add foreign key ( instance_group_model_uuid)
645 references instance_group(model_uuid)
648 alter table collection_resource_customization_to_service
649 add foreign key (service_model_uuid)
650 references service(model_uuid)
653 alter table allotted_resource_customization_to_service
654 add foreign key (service_model_uuid)
655 references service(model_uuid)
659 alter table vnf_resource_customization_to_service
660 add foreign key (service_model_uuid)
661 references service(model_uuid)
665 alter table network_resource_customization_to_service
666 add foreign key (service_model_uuid)
667 references service(model_uuid)
671 alter table network_resource_customization_to_service
672 add foreign key (resource_model_customization_uuid)
673 references network_resource_customization(model_customization_uuid)
676 alter table vnf_resource_customization_to_service
677 add foreign key (resource_model_customization_uuid)
678 references vnf_resource_customization(model_customization_uuid)
681 alter table allotted_resource_customization_to_service
682 add foreign key (resource_model_customization_uuid)
683 references allotted_resource_customization(model_customization_uuid)
686 alter table collection_resource_customization_to_service
687 add foreign key (resource_model_customization_uuid)
688 references collection_resource_customization(model_customization_uuid)
692 create table if not exists `collection_network_resource_customization` (
693 `model_customization_uuid` varchar(200) not null,
694 `model_instance_name` varchar(200) not null,
695 `network_technology` varchar(45) null,
696 `network_type` varchar(45) null,
697 `network_role` varchar(200) null,
698 `network_scope` varchar(45) null,
699 `creation_timestamp` datetime not null default current_timestamp,
700 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
701 `crc_model_customization_uuid` varchar(200) not null, primary key
702 (`model_customization_uuid`, `crc_model_customization_uuid`),
703 index `fk_collection_net_resource_customization__network_resource1_idx`
704 (`network_resource_model_uuid` asc), index
705 `fk_collection_net_resource_customization__instance_group1_idx`
706 (`instance_group_model_uuid` asc), index
707 `fk_col_net_res_customization__collection_res_customization_idx`
708 (`crc_model_customization_uuid` asc), constraint
709 `fk_collection_net_resource_customization__network_resource10` foreign
710 key (`network_resource_model_uuid`) references
711 `network_resource` (`model_uuid`) on delete cascade on
712 update cascade, constraint
713 `fk_collection_net_resource_customization__instance_group10` foreign key
714 (`instance_group_model_uuid`) references `instance_group`
715 (`model_uuid`) on delete cascade on update cascade, constraint
716 `fk_collection_network_resource_customization__collection_reso1` foreign
717 key (`crc_model_customization_uuid`) references
718 `collection_resource_customization`
719 (`model_customization_uuid`) on delete cascade on update cascade) engine
720 = innodb default character set = latin1;
722 CREATE TABLE IF NOT EXISTS `rainy_day_handler_macro` (
723 `id` INT(11) NOT NULL AUTO_INCREMENT,
724 `FLOW_NAME` VARCHAR(200) NOT NULL,
725 `SERVICE_TYPE` VARCHAR(200) NOT NULL,
726 `VNF_TYPE` VARCHAR(200) NOT NULL,
727 `ERROR_CODE` VARCHAR(200) NOT NULL,
728 `WORK_STEP` VARCHAR(200) NOT NULL,
729 `POLICY` VARCHAR(200) NOT NULL,
732 DEFAULT CHARACTER SET = latin1;
734 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
735 `id` INT(11) NOT NULL AUTO_INCREMENT,
736 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
737 `ACTION` VARCHAR(200) NOT NULL,
738 `MACRO_ACTION` VARCHAR(200) NOT NULL,
739 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
740 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 0,
741 `MIN_API_VERSION` DOUBLE NOT NULL,
742 `MAX_API_VERSION` DOUBLE NULL,
744 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC))
746 DEFAULT CHARACTER SET = latin1;
748 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
749 `id` INT(11) NOT NULL AUTO_INCREMENT,
750 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
751 `SEQ_NO` INT(11) NOT NULL,
752 `FLOW_NAME` VARCHAR(200) NOT NULL,
753 `FLOW_VERSION` DOUBLE NOT NULL,
754 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
756 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
757 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
758 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
759 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
760 ON DELETE CASCADE ON UPDATE CASCADE)
761 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
763 CREATE TABLE IF NOT EXISTS vnfc_customization (
764 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
765 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
766 `MODEL_UUID` VARCHAR(200) NOT NULL,
767 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
768 `MODEL_VERSION` VARCHAR(20) NOT NULL,
769 `MODEL_NAME` VARCHAR(200) NOT NULL,
770 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
771 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
772 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
773 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`))
775 AUTO_INCREMENT = 20654
776 DEFAULT CHARACTER SET = latin1;
778 CREATE TABLE IF NOT EXISTS cvnfc_customization (
779 `ID` INT(11) NOT NULL AUTO_INCREMENT,
780 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
781 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
782 `MODEL_UUID` VARCHAR(200) NOT NULL,
783 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
784 `MODEL_VERSION` VARCHAR(20) NOT NULL,
785 `MODEL_NAME` VARCHAR(200) NOT NULL,
786 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
787 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
788 `NFC_FUNCTION` VARCHAR(200) NULL,
789 `NFC_NAMING_CODE` VARCHAR(200) NULL,
790 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
791 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
792 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
793 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
795 INDEX `fk_cvnfc_customization__vf_module_customization1_idx` (
796 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` ASC
798 INDEX `fk_cvnfc_customization__vnfc_customization1_idx` (
799 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` ASC
801 INDEX `fk_cvnfc_customization__vnf_resource_customization1_idx` (
802 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC
804 UNIQUE INDEX `UK_cvnfc_customization` (
805 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC,
806 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` ASC,
807 `MODEL_CUSTOMIZATION_UUID` ASC
809 INDEX `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID` ASC),
810 CONSTRAINT `fk_cvnfc_customization__vf_module_customization1` FOREIGN KEY (
811 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID`
812 ) REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
813 CONSTRAINT `fk_cvnfc_customization__vnfc_customization1` FOREIGN KEY (
814 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID`
815 ) REFERENCES `vnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
816 CONSTRAINT `fk_cvnfc_customization__vnf_resource_customization1` FOREIGN KEY (
817 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`
818 ) REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
819 ) ENGINE = InnoDB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = latin1;
821 CREATE TABLE IF NOT EXISTS vnf_vfmodule_cvnfc_configuration_customization (
822 `ID` INT(11) NOT NULL AUTO_INCREMENT,
823 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
824 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
825 `CONFIGURATION_TYPE` VARCHAR(200) NULL,
826 `CONFIGURATION_ROLE` VARCHAR(200) NULL,
827 `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
828 `POLICY_NAME` VARCHAR(200) NULL,
829 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
830 `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
831 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) DEFAULT NULL,
832 `VF_MODULE_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) DEFAULT NULL,
833 `CVNFC_CUSTOMIZATION_ID` INT(11) DEFAULT NULL,
835 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
837 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
838 REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
839 ) ENGINE = INNODB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = LATIN1;
841 CREATE TABLE IF NOT EXISTS `pnf_resource` (
842 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
843 `DESCRIPTION` varchar(1200) DEFAULT NULL,
844 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
845 `MODEL_UUID` varchar(200) NOT NULL,
846 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
847 `MODEL_VERSION` varchar(20) NOT NULL,
848 `MODEL_NAME` varchar(200) DEFAULT NULL,
849 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
850 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
851 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
852 PRIMARY KEY (`MODEL_UUID`)
853 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
855 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
856 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
857 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
858 `NF_TYPE` varchar(200) DEFAULT NULL,
859 `NF_ROLE` varchar(200) DEFAULT NULL,
860 `NF_FUNCTION` varchar(200) DEFAULT NULL,
861 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
862 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
863 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
864 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
865 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
866 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
867 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
868 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
869 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
870 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
871 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
873 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
874 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
875 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
876 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
877 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
878 --------START Request DB SCHEMA --------
879 CREATE DATABASE requestdb;
883 CREATE TABLE `infra_active_requests` (
884 `REQUEST_ID` varchar(45) NOT NULL,
885 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
886 `ACTION` varchar(45) DEFAULT NULL,
887 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
888 `STATUS_MESSAGE` longtext DEFAULT NULL,
889 `PROGRESS` bigint(20) DEFAULT NULL,
890 `START_TIME` datetime DEFAULT NULL,
891 `END_TIME` datetime DEFAULT NULL,
892 `SOURCE` varchar(45) DEFAULT NULL,
893 `VNF_ID` varchar(45) DEFAULT NULL,
894 `VNF_NAME` varchar(80) DEFAULT NULL,
895 `VNF_TYPE` varchar(200) DEFAULT NULL,
896 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
897 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
898 `TENANT_ID` varchar(45) DEFAULT NULL,
899 `PROV_STATUS` varchar(20) DEFAULT NULL,
900 `VNF_PARAMS` longtext,
901 `VNF_OUTPUTS` longtext,
902 `REQUEST_BODY` longtext,
903 `RESPONSE_BODY` longtext,
904 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
905 `MODIFY_TIME` datetime DEFAULT NULL,
906 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
907 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
908 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
909 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
910 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
911 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
912 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
913 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
914 `CALLBACK_URL` varchar(200) DEFAULT NULL,
915 `CORRELATOR` varchar(80) DEFAULT NULL,
916 `NETWORK_ID` varchar(45) DEFAULT NULL,
917 `NETWORK_NAME` varchar(80) DEFAULT NULL,
918 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
919 `REQUEST_SCOPE` varchar(45) NOT NULL DEFAULT 'unknown',
920 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
921 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
922 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
923 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
924 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
925 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
926 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
927 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
928 `REQUEST_URL` varchar(500) DEFAULT NULL,
929 PRIMARY KEY (`REQUEST_ID`),
930 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
931 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
933 CREATE TABLE `archived_infra_requests` (
934 `REQUEST_ID` varchar(45) NOT NULL,
935 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
936 `ACTION` varchar(45) DEFAULT NULL,
937 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
938 `STATUS_MESSAGE` longtext DEFAULT NULL,
939 `PROGRESS` bigint(20) DEFAULT NULL,
940 `START_TIME` datetime DEFAULT NULL,
941 `END_TIME` datetime DEFAULT NULL,
942 `SOURCE` varchar(45) DEFAULT NULL,
943 `VNF_ID` varchar(45) DEFAULT NULL,
944 `VNF_NAME` varchar(80) DEFAULT NULL,
945 `VNF_TYPE` varchar(200) DEFAULT NULL,
946 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
947 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
948 `TENANT_ID` varchar(45) DEFAULT NULL,
949 `PROV_STATUS` varchar(20) DEFAULT NULL,
950 `VNF_PARAMS` longtext,
951 `VNF_OUTPUTS` longtext,
952 `REQUEST_BODY` longtext,
953 `RESPONSE_BODY` longtext,
954 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
955 `MODIFY_TIME` datetime DEFAULT NULL,
956 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
957 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
958 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
959 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
960 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
961 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
962 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
963 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
964 `CALLBACK_URL` varchar(200) DEFAULT NULL,
965 `CORRELATOR` varchar(80) DEFAULT NULL,
966 `NETWORK_ID` varchar(45) DEFAULT NULL,
967 `NETWORK_NAME` varchar(80) DEFAULT NULL,
968 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
969 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
970 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
971 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
972 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
973 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
974 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
975 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
976 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
977 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
978 `REQUEST_URL` varchar(500) DEFAULT NULL,
979 PRIMARY KEY (`REQUEST_ID`),
980 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d59h` (`CLIENT_REQUEST_ID`)
981 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
983 CREATE TABLE `site_status` (
984 `SITE_NAME` varchar(255) NOT NULL,
985 `STATUS` bit(1) DEFAULT NULL,
986 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
987 PRIMARY KEY (`SITE_NAME`)
988 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
990 CREATE TABLE `watchdog_distributionid_status` (
991 `DISTRIBUTION_ID` varchar(45) NOT NULL,
992 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
993 `LOCK_VERSION` int NOT NULL,
994 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
995 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
996 PRIMARY KEY (`DISTRIBUTION_ID`)
997 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
999 CREATE TABLE `watchdog_per_component_distribution_status` (
1000 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1001 `COMPONENT_NAME` varchar(45) NOT NULL,
1002 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
1003 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1004 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1005 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
1006 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1007 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1009 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
1010 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1011 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1012 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1013 `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1014 PRIMARY KEY (`DISTRIBUTION_ID`,`SERVICE_MODEL_VERSION_ID`)
1015 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1017 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
1018 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1019 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1020 `REQUEST_ID` varchar(45) NOT NULL,
1021 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
1022 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
1023 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
1024 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
1025 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1026 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1027 `VNF_OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1028 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
1029 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1031 CREATE TABLE `activate_operational_env_per_distributionid_status` (
1032 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1033 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1034 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
1035 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1036 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1037 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1038 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1039 `REQUEST_ID` varchar(45) NOT NULL,
1040 PRIMARY KEY (`DISTRIBUTION_ID`),
1041 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
1042 CONSTRAINT `fk_activate_op_env_per_distributionid_status__aoesmds1` FOREIGN KEY (`OPERATIONAL_ENV_ID`, `SERVICE_MODEL_VERSION_ID`, `REQUEST_ID`) REFERENCES `activate_operational_env_service_model_distribution_status` (`OPERATIONAL_ENV_ID`, `SERVICE_MODEL_VERSION_ID`, `REQUEST_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1043 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1045 create table operation_status (
1046 SERVICE_ID varchar(255) not null,
1047 OPERATION_ID varchar(255) not null,
1048 SERVICE_NAME varchar(255),
1049 OPERATION_TYPE varchar(255),
1050 USER_ID varchar(255),
1051 RESULT varchar(255),
1052 OPERATION_CONTENT varchar(255),
1053 PROGRESS varchar(255),
1054 REASON varchar(255),
1055 OPERATE_AT datetime NOT NULL,
1056 FINISHED_AT datetime NOT NULL,
1057 primary key (SERVICE_ID,OPERATION_ID)
1058 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1060 create table resource_operation_status (
1061 SERVICE_ID varchar(255) not null,
1062 OPERATION_ID varchar(255) not null,
1063 RESOURCE_TEMPLATE_UUID varchar(255) not null,
1064 OPER_TYPE varchar(255),
1065 RESOURCE_INSTANCE_ID varchar(255),
1066 JOB_ID varchar(255),
1067 STATUS varchar(255),
1068 PROGRESS varchar(255),
1069 ERROR_CODE varchar(255) ,
1070 STATUS_DESCRIPOTION varchar(255) ,
1071 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
1072 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1074 create table if not exists model_recipe (
1075 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1077 `ACTION` VARCHAR(40),
1078 `SCHEMA_VERSION` VARCHAR(40),
1079 `DESCRIPTION` VARCHAR(40),
1080 `ORCHESTRATION_URI` VARCHAR(20),
1081 `MODEL_PARAM_XSD` VARCHAR(20),
1082 `RECIPE_TIMEOUT` INT(11),
1083 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1085 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
1086 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1088 create table if not exists model (
1089 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1090 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
1091 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
1092 `MODEL_INVARIANT_ID` VARCHAR(40),
1093 `MODEL_NAME` VARCHAR(40),
1094 `MODEL_TYPE` VARCHAR(20),
1095 `MODEL_VERSION` VARCHAR(20),
1096 `MODEL_VERSION_ID` VARCHAR(40),
1097 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1100 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
1101 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1102 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;