2 --------START Catalog DB SCHEMA --------
5 create table `allotted_resource` (
6 `model_uuid` varchar(200) not null,
7 `model_invariant_uuid` varchar(200) not null,
8 `model_version` varchar(20) not null,
9 `model_name` varchar(200) not null,
10 `tosca_node_type` varchar(200) default null,
11 `subcategory` varchar(200) default null,
12 `description` varchar(1200) default null,
13 `creation_timestamp` datetime not null default current_timestamp,
14 primary key (`model_uuid`)
15 ) engine=innodb default charset=latin1;
20 create table `allotted_resource_customization` (
21 `model_customization_uuid` varchar(200) not null,
22 `model_instance_name` varchar(200) not null,
23 `providing_service_model_uuid` varchar(200) default null,
24 `providing_service_model_invariant_uuid` varchar(200) default null,
25 `providing_service_model_name` varchar(200) default null,
26 `target_network_role` varchar(200) default null,
27 `nf_type` varchar(200) default null,
28 `nf_role` varchar(200) default null,
29 `nf_function` varchar(200) default null,
30 `nf_naming_code` varchar(200) default null,
31 `min_instances` int(11) default null,
32 `max_instances` int(11) default null,
33 `ar_model_uuid` varchar(200) not null,
34 `resource_input` varchar(20000) default null,
35 `creation_timestamp` datetime not null default current_timestamp,
36 primary key (`model_customization_uuid`),
37 key `fk_allotted_resource_customization__allotted_resource1_idx` (`ar_model_uuid`),
38 constraint `fk_allotted_resource_customization__allotted_resource1` foreign key (`ar_model_uuid`) references `allotted_resource` (`model_uuid`) on delete cascade on update cascade
39 ) engine=innodb default charset=latin1;
44 create table `heat_environment` (
45 `artifact_uuid` varchar(200) not null,
46 `name` varchar(100) not null,
47 `version` varchar(20) not null,
48 `description` varchar(1200) default null,
49 `body` longtext not null,
50 `artifact_checksum` varchar(200) not null default 'manual record',
51 `creation_timestamp` datetime not null default current_timestamp,
52 primary key (`artifact_uuid`)
53 ) engine=innodb default charset=latin1;
57 create table `heat_files` (
58 `artifact_uuid` varchar(200) not null,
59 `name` varchar(200) not null,
60 `version` varchar(20) not null,
61 `description` varchar(1200) default null,
62 `body` longtext not null,
63 `artifact_checksum` varchar(200) not null default 'manual record',
64 `creation_timestamp` datetime not null default current_timestamp,
65 primary key (`artifact_uuid`)
66 ) engine=innodb default charset=latin1;
71 create table `heat_template` (
72 `artifact_uuid` varchar(200) not null,
73 `name` varchar(200) not null,
74 `version` varchar(20) not null,
75 `description` varchar(1200) default null,
76 `body` longtext not null,
77 `timeout_minutes` int(11) default null,
78 `artifact_checksum` varchar(200) not null default 'manual record',
79 `creation_timestamp` datetime not null default current_timestamp,
80 primary key (`artifact_uuid`)
81 ) engine=innodb default charset=latin1;
85 create table `heat_nested_template` (
86 `parent_heat_template_uuid` varchar(200) not null,
87 `child_heat_template_uuid` varchar(200) not null,
88 `provider_resource_file` varchar(100) default null,
89 primary key (`parent_heat_template_uuid`,`child_heat_template_uuid`),
90 key `fk_heat_nested_template__heat_template2_idx` (`child_heat_template_uuid`),
91 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,
92 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
93 ) engine=innodb default charset=latin1;
98 create table `heat_template_params` (
99 `heat_template_artifact_uuid` varchar(200) not null,
100 `param_name` varchar(100) not null,
101 `is_required` bit(1) not null,
102 `param_type` varchar(20) default null,
103 `param_alias` varchar(45) default null,
104 primary key (`heat_template_artifact_uuid`,`param_name`),
105 constraint `fk_heat_template_params__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
106 ) engine=innodb default charset=latin1;
110 create table `network_recipe` (
111 `id` int(11) not null auto_increment,
112 `model_name` varchar(20) not null,
113 `action` varchar(50) not null,
114 `description` varchar(1200) default null,
115 `orchestration_uri` varchar(256) not null,
116 `network_param_xsd` varchar(2048) default null,
117 `recipe_timeout` int(11) default null,
118 `service_type` varchar(45) default null,
119 `creation_timestamp` datetime not null default current_timestamp,
120 `version_str` varchar(20) not null,
122 unique key `uk_rl4f296i0p8lyokxveaiwkayi` (`model_name`,`action`,`version_str`)
123 ) engine=innodb auto_increment=178 default charset=latin1;
128 create table `temp_network_heat_template_lookup` (
129 `network_resource_model_name` varchar(200) not null,
130 `heat_template_artifact_uuid` varchar(200) not null,
131 `aic_version_min` varchar(20) not null,
132 `aic_version_max` varchar(20) default null,
133 primary key (`network_resource_model_name`),
134 key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
135 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
136 ) engine=innodb default charset=latin1;
140 create table `network_resource` (
141 `model_uuid` varchar(200) not null,
142 `model_name` varchar(200) not null,
143 `model_invariant_uuid` varchar(200) default null,
144 `description` varchar(1200) default null,
145 `heat_template_artifact_uuid` varchar(200) null,
146 `neutron_network_type` varchar(20) default null,
147 `model_version` varchar(20) default null,
148 `tosca_node_type` varchar(200) default null,
149 `aic_version_min` varchar(20) null,
150 `aic_version_max` varchar(20) default null,
151 `orchestration_mode` varchar(20) default 'heat',
152 `resource_category` varchar(20) default null,
153 `resource_sub_category` varchar(20) default null,
154 `creation_timestamp` datetime not null default current_timestamp,
155 primary key (`model_uuid`),
156 key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
157 key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
158 constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade
159 ) engine=innodb default charset=latin1;
165 create table `network_resource_customization` (
166 `model_customization_uuid` varchar(200) not null,
167 `model_instance_name` varchar(200) not null,
168 `network_technology` varchar(45) default null,
169 `network_type` varchar(45) default null,
170 `network_role` varchar(200) default null,
171 `network_scope` varchar(45) default null,
172 `creation_timestamp` datetime not null default current_timestamp,
173 `network_resource_model_uuid` varchar(200) not null,
174 `resource_input` varchar(20000) default null,
175 primary key (`model_customization_uuid`),
176 key `fk_network_resource_customization__network_resource1_idx` (`network_resource_model_uuid`),
177 constraint `fk_network_resource_customization__network_resource1` foreign key (`network_resource_model_uuid`) references `network_resource` (`model_uuid`) on delete cascade on update cascade
178 ) engine=innodb default charset=latin1;
184 create table `tosca_csar` (
185 `artifact_uuid` varchar(200) not null,
186 `name` varchar(200) not null,
187 `version` varchar(20) not null,
188 `description` varchar(1200) default null,
189 `artifact_checksum` varchar(200) not null,
190 `url` varchar(200) not null,
191 `creation_timestamp` datetime not null default current_timestamp,
192 primary key (`artifact_uuid`)
193 ) engine=innodb default charset=latin1;
198 create table `service` (
199 `model_uuid` varchar(200) not null,
200 `model_name` varchar(200) not null,
201 `model_invariant_uuid` varchar(200) not null,
202 `model_version` varchar(20) not null,
203 `description` varchar(1200) default null,
204 `creation_timestamp` datetime not null default current_timestamp,
205 `tosca_csar_artifact_uuid` varchar(200) default null,
206 `service_type` varchar(200) default null,
207 `service_role` varchar(200) default null,
208 `environment_context` varchar(200) default null,
209 `workload_context` varchar(200) default null,
210 `service_category` varchar(200) default null,
211 `resource_order` varchar(200) default null,
212 primary key (`model_uuid`),
213 key `fk_service__tosca_csar1_idx` (`tosca_csar_artifact_uuid`),
214 constraint `fk_service__tosca_csar1` foreign key (`tosca_csar_artifact_uuid`) references `tosca_csar` (`artifact_uuid`) on delete cascade on update cascade
215 ) engine=innodb default charset=latin1;
219 create table `service_recipe` (
220 `id` int(11) not null auto_increment,
221 `action` varchar(50) not null,
222 `version_str` varchar(20) default null,
223 `description` varchar(1200) default null,
224 `orchestration_uri` varchar(256) not null,
225 `service_param_xsd` varchar(2048) default null,
226 `recipe_timeout` int(11) default null,
227 `service_timeout_interim` int(11) default null,
228 `creation_timestamp` datetime not null default current_timestamp,
229 `service_model_uuid` varchar(200) not null,
231 unique key `uk_7fav5dkux2v8g9d2i5ymudlgc` (`service_model_uuid`,`action`),
232 key `fk_service_recipe__service1_idx` (`service_model_uuid`),
233 constraint `fk_service_recipe__service1` foreign key (`service_model_uuid`) references `service` (`model_uuid`) on delete cascade on update cascade
234 ) engine=innodb auto_increment=86 default charset=latin1;
238 create table `vnf_resource` (
239 `orchestration_mode` varchar(20) not null default 'heat',
240 `description` varchar(1200) default null,
241 `creation_timestamp` datetime not null default current_timestamp,
242 `model_uuid` varchar(200) not null,
243 `aic_version_min` varchar(20) default null,
244 `aic_version_max` varchar(20) default null,
245 `model_invariant_uuid` varchar(200) default null,
246 `model_version` varchar(20) not null,
247 `model_name` varchar(200) default null,
248 `tosca_node_type` varchar(200) default null,
249 `resource_category` varchar(200) default null,
250 `resource_sub_category` varchar(200) default null,
251 `heat_template_artifact_uuid` varchar(200) default null,
252 primary key (`model_uuid`),
253 key `fk_vnf_resource__heat_template1` (`heat_template_artifact_uuid`),
254 constraint `fk_vnf_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
255 ) engine=innodb default charset=latin1;
260 create table `vf_module` (
261 `model_uuid` varchar(200) not null,
262 `model_invariant_uuid` varchar(200) default null,
263 `model_version` varchar(20) not null,
264 `model_name` varchar(200) not null,
265 `description` varchar(1200) default null,
266 `is_base` int(11) not null,
267 `heat_template_artifact_uuid` varchar(200) default null,
268 `vol_heat_template_artifact_uuid` varchar(200) default null,
269 `creation_timestamp` datetime not null default current_timestamp,
270 `vnf_resource_model_uuid` varchar(200) not null,
271 primary key (`model_uuid`,`vnf_resource_model_uuid`),
272 key `fk_vf_module__vnf_resource1_idx` (`vnf_resource_model_uuid`),
273 key `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`heat_template_artifact_uuid`),
274 key `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`vol_heat_template_artifact_uuid`),
275 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,
276 constraint `fk_vf_module__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade,
277 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
278 ) engine=innodb default charset=latin1;
282 /*!40101 set @saved_cs_client = @@character_set_client */;
283 /*!40101 set character_set_client = utf8 */;
284 create table `vf_module_customization` (
285 `model_customization_uuid` varchar(200) not null,
286 `label` varchar(200) default null,
287 `initial_count` int(11) default '0',
288 `min_instances` int(11) default '0',
289 `max_instances` int(11) default null,
290 `availability_zone_count` int(11) default null,
291 `heat_environment_artifact_uuid` varchar(200) default null,
292 `vol_environment_artifact_uuid` varchar(200) default null,
293 `creation_timestamp` datetime not null default current_timestamp,
294 `vf_module_model_uuid` varchar(200) not null,
295 primary key (`model_customization_uuid`),
296 key `fk_vf_module_customization__vf_module1_idx` (`vf_module_model_uuid`),
297 key `fk_vf_module_customization__heat_env__heat_environment1_idx` (`heat_environment_artifact_uuid`),
298 key `fk_vf_module_customization__vol_env__heat_environment2_idx` (`vol_environment_artifact_uuid`),
299 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,
300 constraint `fk_vf_module_customization__vf_module1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade,
301 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
302 ) engine=innodb default charset=latin1;
303 /*!40101 set character_set_client = @saved_cs_client */;
306 -- table structure for table `vf_module_to_heat_files`
310 /*!40101 set @saved_cs_client = @@character_set_client */;
311 /*!40101 set character_set_client = utf8 */;
312 create table `vf_module_to_heat_files` (
313 `vf_module_model_uuid` varchar(200) not null,
314 `heat_files_artifact_uuid` varchar(200) not null,
315 primary key (`vf_module_model_uuid`,`heat_files_artifact_uuid`),
316 key `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`heat_files_artifact_uuid`),
317 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,
318 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
319 ) engine=innodb default charset=latin1 comment='il fait ce qu''il dit';
320 /*!40101 set character_set_client = @saved_cs_client */;
323 -- table structure for table `vnf_components`
327 /*!40101 set @saved_cs_client = @@character_set_client */;
328 /*!40101 set character_set_client = utf8 */;
329 create table `vnf_components` (
330 `vnf_id` int(11) not null,
331 `component_type` varchar(20) not null,
332 `heat_template_id` int(11) default null,
333 `heat_environment_id` int(11) default null,
334 `creation_timestamp` datetime not null default current_timestamp,
335 primary key (`vnf_id`,`component_type`)
336 ) engine=innodb default charset=latin1;
337 /*!40101 set character_set_client = @saved_cs_client */;
340 -- table structure for table `vnf_components_recipe`
345 create table `vnf_components_recipe` (
346 `id` int(11) not null auto_increment,
347 `vnf_type` varchar(200) default null,
348 `vnf_component_type` varchar(45) not null,
349 `action` varchar(50) not null,
350 `service_type` varchar(45) default null,
351 `version` varchar(20) not null,
352 `description` varchar(1200) default null,
353 `orchestration_uri` varchar(256) not null,
354 `vnf_component_param_xsd` varchar(2048) default null,
355 `recipe_timeout` int(11) default null,
356 `creation_timestamp` datetime default current_timestamp,
357 `vf_module_model_uuid` varchar(200) default null,
359 unique key `uk_4dpdwddaaclhc11wxsb7h59ma` (`vf_module_model_uuid`,`vnf_component_type`,`action`,`version`)
360 ) engine=innodb auto_increment=26 default charset=latin1;
365 create table `vnf_recipe` (
366 `id` int(11) not null auto_increment,
367 `vnf_type` varchar(200) default null,
368 `action` varchar(50) not null,
369 `service_type` varchar(45) default null,
370 `version_str` varchar(20) not null,
371 `description` varchar(1200) default null,
372 `orchestration_uri` varchar(256) not null,
373 `vnf_param_xsd` varchar(2048) default null,
374 `recipe_timeout` int(11) default null,
375 `creation_timestamp` datetime default current_timestamp,
376 `vf_module_id` varchar(100) default null,
378 unique key `uk_f3tvqau498vrifq3cr8qnigkr` (`vf_module_id`,`action`,`version_str`)
379 ) engine=innodb auto_increment=10006 default charset=latin1;
388 create table `vnf_resource_customization` (
389 `model_customization_uuid` varchar(200) not null,
390 `model_instance_name` varchar(200) not null,
391 `min_instances` int(11) default null,
392 `max_instances` int(11) default null,
393 `availability_zone_max_count` int(11) default null,
394 `nf_type` varchar(200) default null,
395 `nf_role` varchar(200) default null,
396 `nf_function` varchar(200) default null,
397 `nf_naming_code` varchar(200) default null,
398 `creation_timestamp` datetime not null default current_timestamp,
399 `vnf_resource_model_uuid` varchar(200) not null,
400 `multi_stage_design` varchar(20) default null,
401 `resource_input` varchar(20000) default null,
402 `cds_blueprint_name` varchar(200) default null,
403 `cds_blueprint_version` varchar(20) default null,
404 primary key (`model_customization_uuid`),
405 key `fk_vnf_resource_customization__vnf_resource1_idx` (`vnf_resource_model_uuid`),
406 constraint `fk_vnf_resource_customization__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade
407 ) engine=innodb default charset=latin1;
412 create table `vnf_res_custom_to_vf_module_custom` (
413 `vnf_resource_cust_model_customization_uuid` varchar(200) not null,
414 `vf_module_cust_model_customization_uuid` varchar(200) not null,
415 `creation_timestamp` datetime not null default current_timestamp,
416 primary key (`vnf_resource_cust_model_customization_uuid`,`vf_module_cust_model_customization_uuid`),
417 key `fk_vnf_res_custom_to_vf_module_custom__vf_module_customizat_idx` (`vf_module_cust_model_customization_uuid`),
418 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,
419 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
420 ) engine=innodb default charset=latin1;
423 create table if not exists external_service_to_internal_model_mapping (
424 id int(11) not null auto_increment,
425 service_name varchar(200) not null,
426 product_flavor varchar(200) null,
427 subscription_service_type varchar(200) not null,
428 service_model_uuid varchar(200) not null,
430 unique index uk_external_service_to_internal_model_mapping
431 (service_name asc, product_flavor asc, service_model_uuid asc));
433 create table if not exists `collection_resource` (
434 model_uuid varchar(200) not null,
435 model_name varchar(200) not null,
436 model_invariant_uuid varchar(200) not null,
437 model_version varchar(20) not null,
438 tosca_node_type varchar(200) not null,
439 description varchar(200),
440 creation_timestamp datetime not null default current_timestamp,
441 primary key (`model_uuid`)
442 )engine=innodb default charset=latin1;
444 create table if not exists `collection_resource_customization` (
445 model_customization_uuid varchar(200) not null,
446 model_instance_name varchar(200) not null,
447 role varchar(200) NULL,
448 object_type varchar(200) not null,
449 function varchar(200) NULL,
450 collection_resource_type varchar(200) NULL,
451 creation_timestamp datetime not null default current_timestamp,
452 cr_model_uuid varchar(200) not null,
453 primary key (`model_customization_uuid`)
454 )engine=innodb default charset=latin1;
456 create table if not exists `instance_group` (
457 model_uuid varchar(200) not null,
458 model_name varchar(200) not null,
459 model_invariant_uuid varchar(200) not null,
460 model_version varchar(20) not null,
461 tosca_node_type varchar(200) NULL,
462 role varchar(200) not null,
463 object_type varchar(200) not null,
464 creation_timestamp datetime not null default current_timestamp,
465 cr_model_uuid varchar(200) NULL,
466 instance_group_type varchar(200) not null,
467 primary key (`model_uuid`)
468 )engine=innodb default charset=latin1;
470 create table if not exists `collection_resource_instance_group_customization` (
471 `collection_resource_customization_model_uuid` varchar(200) not null,
472 `instance_group_model_uuid` varchar(200) not null,
473 `function` varchar(200) null,
474 `description` varchar(1200) null,
475 `subinterface_network_quantity` int(11) null,
476 `creation_timestamp` datetime not null default current_timestamp,
477 primary key (`collection_resource_customization_model_uuid`, `instance_group_model_uuid`),
478 index `fk_collection_resource_instance_group_customization__instan_idx` (`instance_group_model_uuid` asc),
479 constraint `fk_collection_resource_instance_group_customization__collecti1`
480 foreign key (`collection_resource_customization_model_uuid`)
481 references `collection_resource_customization` (`model_customization_uuid`)
484 constraint `fk_collection_resource_instance_group_customization__instance1`
485 foreign key (`instance_group_model_uuid`)
486 references `instance_group` (`model_uuid`)
490 default character set = latin1;
492 create table if not exists `vnfc_instance_group_customization` (
493 `vnf_resource_customization_model_uuid` varchar(200) not null,
494 `instance_group_model_uuid` varchar(200) not null,
495 `function` varchar(200) null,
496 `description` varchar(1200) null,
497 `creation_timestamp` datetime not null default current_timestamp,
498 primary key (`vnf_resource_customization_model_uuid`, `instance_group_model_uuid`),
499 index `fk_vnfc_instance_group_customization__instance_group1_idx` (`instance_group_model_uuid` asc),
500 constraint `fk_vnfc_instance_group_customization__vnf_resource_customizat1`
501 foreign key (`vnf_resource_customization_model_uuid`)
502 references `vnf_resource_customization` (`model_customization_uuid`)
505 constraint `fk_vnfc_instance_group_customization__instance_group1`
506 foreign key (`instance_group_model_uuid`)
507 references `instance_group` (`model_uuid`)
511 default character set = latin1;
513 create table if not exists `configuration`
514 ( `model_uuid` varchar(200) not null,
515 `model_invariant_uuid` varchar(200) not null,
516 `model_version` varchar(20) not null,
517 `model_name` varchar(200) not null,
518 `tosca_node_type` varchar(200) not null,
519 `description` varchar(1200) null,
520 `creation_timestamp` datetime not null default current_timestamp,
521 primary key (`model_uuid`))
522 engine = innodb auto_increment = 20654
523 default character set = latin1;
525 CREATE TABLE IF NOT EXISTS `service_proxy_customization` (
526 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
527 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
528 `MODEL_UUID` VARCHAR(200) NOT NULL,
529 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
530 `MODEL_VERSION` VARCHAR(20) NOT NULL,
531 `MODEL_NAME` VARCHAR(200) NOT NULL,
532 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
533 `DESCRIPTION` VARCHAR(1200) NULL,
534 `SOURCE_SERVICE_MODEL_UUID` VARCHAR(200) NOT NULL,
535 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
536 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
537 INDEX `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID` ASC),
538 UNIQUE INDEX `UK_service_proxy_customization` (`MODEL_CUSTOMIZATION_UUID` ASC),
539 INDEX `fk_service_proxy_customization__serv_prox_to_serv` (`MODEL_CUSTOMIZATION_UUID` ASC),
540 CONSTRAINT `fk_service_proxy_resource_customization__service1`
541 FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`)
542 REFERENCES `service` (`MODEL_UUID`)
546 AUTO_INCREMENT = 20654
547 DEFAULT CHARACTER SET = latin1;
549 create table if not exists `configuration_customization` (
550 `model_customization_uuid` varchar(200) not null,
551 `model_instance_name` varchar(200) not null,
552 `configuration_type` varchar(200) null,
553 `configuration_role` varchar(200) null,
554 `configuration_function` varchar(200) null,
555 `creation_timestamp` datetime not null default current_timestamp,
556 `configuration_model_uuid` varchar(200) not null,
557 `service_proxy_customization_model_customization_uuid` varchar(200) null,
558 `configuration_customization_model_customization_uuid` varchar(200) null,
559 primary key (`model_customization_uuid`),
560 index `fk_configuration_customization__configuration_idx` (`configuration_model_uuid` asc),
561 index `fk_configuration_customization__configuration_customization_idx`
562 (`configuration_customization_model_customization_uuid` asc),
563 constraint `fk_configuration_resource_customization__configuration_resour1`
564 foreign key (`configuration_model_uuid`) references `configuration` (`model_uuid`)
565 on delete cascade on update cascade,
566 constraint `fk_configuration_customization__configuration_customization1`
567 foreign key (`configuration_customization_model_customization_uuid`) references
568 `configuration_customization` (`model_customization_uuid`)
569 on delete cascade on update cascade)
571 auto_increment =20654
572 default character set = latin1;
575 create table `service_proxy_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 `configuration_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 if not exists `collection_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;
596 create table `network_resource_customization_to_service` (
597 `service_model_uuid` varchar(200) not null,
598 `resource_model_customization_uuid` varchar(200) not null,
599 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
600 )engine=innodb default charset=latin1;
602 create table `vnf_resource_customization_to_service` (
603 `service_model_uuid` varchar(200) not null,
604 `resource_model_customization_uuid` varchar(200) not null,
605 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
606 )engine=innodb default charset=latin1;
608 create table `allotted_resource_customization_to_service` (
609 `service_model_uuid` varchar(200) not null,
610 `resource_model_customization_uuid` varchar(200) not null,
611 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
612 )engine=innodb default charset=latin1;
617 create table ar_recipe (
618 ID INT(11) not null auto_increment,
619 MODEL_NAME VARCHAR(200) NOT NULL,
620 `ACTION` VARCHAR(200) NOT NULL,
621 VERSION_STR VARCHAR(200) NOT NULL,
622 SERVICE_TYPE VARCHAR(200),
623 DESCRIPTION VARCHAR(200),
624 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
625 AR_PARAM_XSD VARCHAR(200),
626 RECIPE_TIMEOUT INT(10),
627 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
629 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
630 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
632 alter table collection_resource_customization
633 add foreign key ( cr_model_uuid)
634 references collection_resource(model_uuid)
637 alter table vnf_resource_customization
639 instance_group_model_uuid varchar(200);
641 alter table network_resource_customization
643 instance_group_model_uuid varchar(200);
646 alter table network_resource_customization
647 add foreign key ( instance_group_model_uuid)
648 references instance_group(model_uuid)
651 alter table collection_resource_customization_to_service
652 add foreign key (service_model_uuid)
653 references service(model_uuid)
656 alter table allotted_resource_customization_to_service
657 add foreign key (service_model_uuid)
658 references service(model_uuid)
662 alter table vnf_resource_customization_to_service
663 add foreign key (service_model_uuid)
664 references service(model_uuid)
668 alter table network_resource_customization_to_service
669 add foreign key (service_model_uuid)
670 references service(model_uuid)
674 alter table network_resource_customization_to_service
675 add foreign key (resource_model_customization_uuid)
676 references network_resource_customization(model_customization_uuid)
679 alter table vnf_resource_customization_to_service
680 add foreign key (resource_model_customization_uuid)
681 references vnf_resource_customization(model_customization_uuid)
684 alter table allotted_resource_customization_to_service
685 add foreign key (resource_model_customization_uuid)
686 references allotted_resource_customization(model_customization_uuid)
689 alter table collection_resource_customization_to_service
690 add foreign key (resource_model_customization_uuid)
691 references collection_resource_customization(model_customization_uuid)
695 create table if not exists `collection_network_resource_customization` (
696 `model_customization_uuid` varchar(200) not null,
697 `model_instance_name` varchar(200) not null,
698 `network_technology` varchar(45) null,
699 `network_type` varchar(45) null,
700 `network_role` varchar(200) null,
701 `network_scope` varchar(45) null,
702 `creation_timestamp` datetime not null default current_timestamp,
703 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
704 `crc_model_customization_uuid` varchar(200) not null, primary key
705 (`model_customization_uuid`, `crc_model_customization_uuid`),
706 index `fk_collection_net_resource_customization__network_resource1_idx`
707 (`network_resource_model_uuid` asc), index
708 `fk_collection_net_resource_customization__instance_group1_idx`
709 (`instance_group_model_uuid` asc), index
710 `fk_col_net_res_customization__collection_res_customization_idx`
711 (`crc_model_customization_uuid` asc), constraint
712 `fk_collection_net_resource_customization__network_resource10` foreign
713 key (`network_resource_model_uuid`) references
714 `network_resource` (`model_uuid`) on delete cascade on
715 update cascade, constraint
716 `fk_collection_net_resource_customization__instance_group10` foreign key
717 (`instance_group_model_uuid`) references `instance_group`
718 (`model_uuid`) on delete cascade on update cascade, constraint
719 `fk_collection_network_resource_customization__collection_reso1` foreign
720 key (`crc_model_customization_uuid`) references
721 `collection_resource_customization`
722 (`model_customization_uuid`) on delete cascade on update cascade) engine
723 = innodb default character set = latin1;
725 CREATE TABLE IF NOT EXISTS `rainy_day_handler_macro` (
726 `id` INT(11) NOT NULL AUTO_INCREMENT,
727 `FLOW_NAME` VARCHAR(200) NOT NULL,
728 `SERVICE_TYPE` VARCHAR(200) NOT NULL,
729 `VNF_TYPE` VARCHAR(200) NOT NULL,
730 `ERROR_CODE` VARCHAR(200) NOT NULL,
731 `WORK_STEP` VARCHAR(200) NOT NULL,
732 `POLICY` VARCHAR(200) NOT NULL,
735 DEFAULT CHARACTER SET = latin1;
737 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
738 `id` INT(11) NOT NULL AUTO_INCREMENT,
739 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
740 `ACTION` VARCHAR(200) NOT NULL,
741 `MACRO_ACTION` VARCHAR(200) NOT NULL,
742 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
743 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 0,
744 `MIN_API_VERSION` DOUBLE NOT NULL,
745 `MAX_API_VERSION` DOUBLE NULL,
747 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC))
749 DEFAULT CHARACTER SET = latin1;
751 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
752 `id` INT(11) NOT NULL AUTO_INCREMENT,
753 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
754 `SEQ_NO` INT(11) NOT NULL,
755 `FLOW_NAME` VARCHAR(200) NOT NULL,
756 `FLOW_VERSION` DOUBLE NOT NULL,
757 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
759 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
760 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
761 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
762 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
763 ON DELETE CASCADE ON UPDATE CASCADE)
764 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
766 CREATE TABLE IF NOT EXISTS vnfc_customization (
767 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
768 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
769 `MODEL_UUID` VARCHAR(200) NOT NULL,
770 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
771 `MODEL_VERSION` VARCHAR(20) NOT NULL,
772 `MODEL_NAME` VARCHAR(200) NOT NULL,
773 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
774 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
775 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
776 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`))
778 AUTO_INCREMENT = 20654
779 DEFAULT CHARACTER SET = latin1;
781 CREATE TABLE IF NOT EXISTS cvnfc_customization (
782 `ID` INT(11) NOT NULL AUTO_INCREMENT,
783 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
784 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
785 `MODEL_UUID` VARCHAR(200) NOT NULL,
786 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
787 `MODEL_VERSION` VARCHAR(20) NOT NULL,
788 `MODEL_NAME` VARCHAR(200) NOT NULL,
789 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
790 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
791 `NFC_FUNCTION` VARCHAR(200) NULL,
792 `NFC_NAMING_CODE` VARCHAR(200) NULL,
793 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
794 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
795 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
796 `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
798 UPDATE CASCADE, CONSTRAINT `fk_cvnfc_customization__vnfc_customization1` FOREIGN KEY (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`) REFERENCES `vnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON
800 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
802 UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = latin1;
805 CREATE TABLE IF NOT EXISTS vnf_vfmodule_cvnfc_configuration_customization (
806 `ID` INT(11) NOT NULL AUTO_INCREMENT,
807 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
808 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
809 `VF_MODULE_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
810 `CVNFC_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
811 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
812 `CONFIGURATION_TYPE` VARCHAR(200) NULL,
813 `CONFIGURATION_ROLE` VARCHAR(200) NULL,
814 `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
815 `POLICY_NAME` VARCHAR(200) NULL,
816 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
817 `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
819 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
820 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),
821 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__cvnfc_cust1_idx` (`CVNFC_MODEL_CUSTOMIZATION_UUID` ASC),
822 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vf_module_cust_idx` (`VF_MODULE_MODEL_CUSTOMIZATION_UUID` ASC),
823 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vnf_res_cust_idx` (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC),
824 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
825 REFERENCES `configuration` (`MODEL_UUID`)
826 ON DELETE CASCADE ON UPDATE CASCADE,
827 CONSTRAINT `fk_cvnfc_configuration_customization__cvnfc_customization1` FOREIGN KEY (`CVNFC_MODEL_CUSTOMIZATION_UUID`)
828 REFERENCES `cvnfc_customization` (`MODEL_CUSTOMIZATION_UUID`)
829 ON DELETE CASCADE ON UPDATE CASCADE,
830 CONSTRAINT `fk_vnf_configuration_cvnfc_customization__vf_module_customiza1` FOREIGN KEY (`VF_MODULE_MODEL_CUSTOMIZATION_UUID`)
831 REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`)
832 ON DELETE CASCADE ON UPDATE CASCADE,
833 CONSTRAINT `fk_vfmodule_cvnfc_configuration_customization__vnf_resource_c1` FOREIGN KEY (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`)
834 REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`)
835 ON DELETE CASCADE ON UPDATE CASCADE
836 ) ENGINE=INNODB AUTO_INCREMENT=20654 DEFAULT CHARACTER SET=LATIN1;
839 CREATE TABLE IF NOT EXISTS `pnf_resource` (
840 `ORCHESTRATION_MODE` varchar(20) DEFAULT NULL,
841 `DESCRIPTION` varchar(1200) DEFAULT NULL,
842 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
843 `MODEL_UUID` varchar(200) NOT NULL,
844 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
845 `MODEL_VERSION` varchar(20) NOT NULL,
846 `MODEL_NAME` varchar(200) DEFAULT NULL,
847 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
848 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
849 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
850 PRIMARY KEY (`MODEL_UUID`)
851 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
853 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
854 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
855 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
856 `NF_TYPE` varchar(200) DEFAULT NULL,
857 `NF_ROLE` varchar(200) DEFAULT NULL,
858 `NF_FUNCTION` varchar(200) DEFAULT NULL,
859 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
860 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
861 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
862 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
863 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
864 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
865 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
866 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
867 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
868 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
869 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
871 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
872 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
873 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
874 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
875 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
877 --------START Request DB SCHEMA --------
878 CREATE DATABASE requestdb;
882 CREATE TABLE `active_requests` (
883 `REQUEST_ID` varchar(45) NOT NULL,
884 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
885 `SERVICE_INSTANCE_ID` varchar(50) NOT NULL,
886 `SUBSCRIBER_NAME` varchar(200) DEFAULT NULL,
887 `REQUEST_URI` varchar(255) DEFAULT NULL,
888 `SERVICE_TYPE` varchar(65) NOT NULL,
889 `REQUEST_ACTION` varchar(45) NOT NULL,
890 `NOTIFICATION_URL` varchar(255) DEFAULT NULL,
891 `REQUEST_ID_IN_PROGRESS` varchar(45) DEFAULT NULL,
892 `START_TIME` datetime DEFAULT NULL,
893 `MODIFY_TIME` datetime DEFAULT NULL,
894 `COMPLETION_TIME` datetime DEFAULT NULL,
895 `RESPONSE_CODE` varchar(20) DEFAULT NULL,
896 `RESPONSE_BODY` longtext,
897 `STATUS` varchar(25) DEFAULT NULL,
898 `SERVICE_REQUEST_TIMEOUT` datetime DEFAULT NULL,
899 `FINAL_ERROR_CODE` varchar(20) DEFAULT NULL,
900 `FINAL_ERROR_MESSAGE` varchar(2000) DEFAULT NULL,
901 `ORDER_NUMBER` varchar(45) DEFAULT NULL,
902 `SOURCE` varchar(20) DEFAULT NULL,
903 `RESPONSE_STATUS` varchar(25) DEFAULT NULL,
904 `ORDER_VERSION` varchar(20) DEFAULT NULL,
905 `LAST_MODIFIED_BY` varchar(20) DEFAULT NULL,
906 `MOCARS_TICKET_NUM` varchar(200) DEFAULT NULL,
907 `REQUEST_BODY` longtext,
908 `REQUEST_SUB_ACTION` varchar(45) DEFAULT NULL,
909 `SDNC_CALLBACK_BPEL_URL` varchar(255) DEFAULT NULL,
910 `FEATURE_TYPE` varchar(255) DEFAULT NULL,
911 `FEATURE_INSTANCE_ID` varchar(255) DEFAULT NULL,
912 `REQUEST_TYPE` varchar(255) DEFAULT NULL,
913 `INTERIM_COMPLETION_TIME` datetime DEFAULT NULL,
914 `INTERIM_STAGE_COMPLETION` int(11) DEFAULT NULL,
915 `SERVICE_NAME_VERSION_ID` varchar(50) DEFAULT NULL,
916 `GLOBAL_SUBSCRIBER_ID` varchar(255) DEFAULT NULL,
917 `SERVICE_ID` varchar(50) DEFAULT NULL,
918 `SERVICE_VERSION` varchar(10) DEFAULT NULL,
919 `CORRELATOR` varchar(50) DEFAULT NULL,
920 PRIMARY KEY (`REQUEST_ID`),
921 UNIQUE KEY `UK_f0hdk7xbw5mb2trnxx0fvlh3x` (`CLIENT_REQUEST_ID`)
922 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
924 CREATE TABLE `infra_active_requests` (
925 `REQUEST_ID` varchar(45) NOT NULL,
926 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
927 `ACTION` varchar(45) DEFAULT NULL,
928 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
929 `STATUS_MESSAGE` longtext DEFAULT NULL,
930 `PROGRESS` bigint(20) DEFAULT NULL,
931 `START_TIME` datetime DEFAULT NULL,
932 `END_TIME` datetime DEFAULT NULL,
933 `SOURCE` varchar(45) DEFAULT NULL,
934 `VNF_ID` varchar(45) DEFAULT NULL,
935 `VNF_NAME` varchar(80) DEFAULT NULL,
936 `VNF_TYPE` varchar(200) DEFAULT NULL,
937 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
938 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
939 `TENANT_ID` varchar(45) DEFAULT NULL,
940 `PROV_STATUS` varchar(20) DEFAULT NULL,
941 `VNF_PARAMS` longtext,
942 `VNF_OUTPUTS` longtext,
943 `REQUEST_BODY` longtext,
944 `RESPONSE_BODY` longtext,
945 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
946 `MODIFY_TIME` datetime DEFAULT NULL,
947 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
948 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
949 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
950 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
951 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
952 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
953 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
954 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
955 `CALLBACK_URL` varchar(200) DEFAULT NULL,
956 `CORRELATOR` varchar(80) DEFAULT NULL,
957 `NETWORK_ID` varchar(45) DEFAULT NULL,
958 `NETWORK_NAME` varchar(80) DEFAULT NULL,
959 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
960 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
961 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
962 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
963 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
964 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
965 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
966 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
967 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
968 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
969 `REQUEST_URL` varchar(500) DEFAULT NULL,
970 PRIMARY KEY (`REQUEST_ID`),
971 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
972 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
974 CREATE TABLE `archived_infra_requests` (
975 `REQUEST_ID` varchar(45) NOT NULL,
976 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
977 `ACTION` varchar(45) DEFAULT NULL,
978 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
979 `STATUS_MESSAGE` longtext DEFAULT NULL,
980 `PROGRESS` bigint(20) DEFAULT NULL,
981 `START_TIME` datetime DEFAULT NULL,
982 `END_TIME` datetime DEFAULT NULL,
983 `SOURCE` varchar(45) DEFAULT NULL,
984 `VNF_ID` varchar(45) DEFAULT NULL,
985 `VNF_NAME` varchar(80) DEFAULT NULL,
986 `VNF_TYPE` varchar(200) DEFAULT NULL,
987 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
988 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
989 `TENANT_ID` varchar(45) DEFAULT NULL,
990 `PROV_STATUS` varchar(20) DEFAULT NULL,
991 `VNF_PARAMS` longtext,
992 `VNF_OUTPUTS` longtext,
993 `REQUEST_BODY` longtext,
994 `RESPONSE_BODY` longtext,
995 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
996 `MODIFY_TIME` datetime DEFAULT NULL,
997 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
998 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
999 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
1000 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
1001 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
1002 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
1003 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
1004 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
1005 `CALLBACK_URL` varchar(200) DEFAULT NULL,
1006 `CORRELATOR` varchar(80) DEFAULT NULL,
1007 `NETWORK_ID` varchar(45) DEFAULT NULL,
1008 `NETWORK_NAME` varchar(80) DEFAULT NULL,
1009 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
1010 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
1011 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
1012 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
1013 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
1014 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
1015 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
1016 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
1017 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
1018 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
1019 `REQUEST_URL` varchar(500) DEFAULT NULL,
1020 PRIMARY KEY (`REQUEST_ID`),
1021 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d72h` (`CLIENT_REQUEST_ID`)
1022 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1024 CREATE TABLE `site_status` (
1025 `SITE_NAME` varchar(255) NOT NULL,
1026 `STATUS` bit(1) DEFAULT NULL,
1027 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1028 PRIMARY KEY (`SITE_NAME`)
1029 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1031 CREATE TABLE `watchdog_distributionid_status` (
1032 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1033 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1034 `LOCK_VERSION` int NOT NULL,
1035 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1036 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1037 PRIMARY KEY (`DISTRIBUTION_ID`)
1038 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1040 CREATE TABLE `watchdog_per_component_distribution_status` (
1041 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1042 `COMPONENT_NAME` varchar(45) NOT NULL,
1043 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
1044 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1045 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1046 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
1047 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1048 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1050 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
1051 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1052 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1053 `DISTRIBUTION_NOTIFICATION` LONGTEXT NULL,
1054 `CONSUMER_ID` varchar(200) NULL,
1055 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1056 `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1057 PRIMARY KEY (`DISTRIBUTION_ID`,`SERVICE_MODEL_VERSION_ID`)
1058 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1060 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
1061 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1062 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1063 `REQUEST_ID` varchar(45) NOT NULL,
1064 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
1065 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
1066 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
1067 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
1068 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1069 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1070 `VNF_OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1071 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
1072 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1074 CREATE TABLE `activate_operational_env_per_distributionid_status` (
1075 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1076 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1077 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
1078 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1079 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1080 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1081 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1082 `REQUEST_ID` varchar(45) NOT NULL,
1083 PRIMARY KEY (`DISTRIBUTION_ID`),
1084 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
1085 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
1086 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1088 create table operation_status (
1089 SERVICE_ID varchar(255) not null,
1090 OPERATION_ID varchar(255) not null,
1091 SERVICE_NAME varchar(255),
1092 OPERATION_TYPE varchar(255),
1093 USER_ID varchar(255),
1094 RESULT varchar(255),
1095 OPERATION_CONTENT varchar(255),
1096 PROGRESS varchar(255),
1097 REASON varchar(255),
1098 OPERATE_AT datetime NOT NULL,
1099 FINISHED_AT datetime NOT NULL,
1100 primary key (SERVICE_ID,OPERATION_ID)
1101 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1103 create table resource_operation_status (
1104 SERVICE_ID varchar(255) not null,
1105 OPERATION_ID varchar(255) not null,
1106 RESOURCE_TEMPLATE_UUID varchar(255) not null,
1107 OPER_TYPE varchar(255),
1108 RESOURCE_INSTANCE_ID varchar(255),
1109 JOB_ID varchar(255),
1110 STATUS varchar(255),
1111 PROGRESS varchar(255),
1112 ERROR_CODE varchar(255) ,
1113 STATUS_DESCRIPOTION varchar(255) ,
1114 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
1115 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1117 create table if not exists model_recipe (
1118 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1120 `ACTION` VARCHAR(40),
1121 `SCHEMA_VERSION` VARCHAR(40),
1122 `DESCRIPTION` VARCHAR(40),
1123 `ORCHESTRATION_URI` VARCHAR(20),
1124 `MODEL_PARAM_XSD` VARCHAR(20),
1125 `RECIPE_TIMEOUT` INT(11),
1126 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1128 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
1129 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1131 create table if not exists model (
1132 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1133 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
1134 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
1135 `MODEL_INVARIANT_ID` VARCHAR(40),
1136 `MODEL_NAME` VARCHAR(40),
1137 `MODEL_TYPE` VARCHAR(20),
1138 `MODEL_VERSION` VARCHAR(20),
1139 `MODEL_VERSION_ID` VARCHAR(40),
1140 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1143 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
1144 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1145 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1147 ALTER TABLE `catalogdb`.`vnf_recipe`
1148 CHANGE COLUMN `VNF_TYPE` `NF_ROLE` VARCHAR(200) NULL DEFAULT NULL ;