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 `creation_timestamp` datetime not null default current_timestamp,
34 primary key (`model_customization_uuid`),
35 key `fk_allotted_resource_customization__allotted_resource1_idx` (`ar_model_uuid`),
36 constraint `fk_allotted_resource_customization__allotted_resource1` foreign key (`ar_model_uuid`) references `allotted_resource` (`model_uuid`) on delete cascade on update cascade
37 ) engine=innodb default charset=latin1;
42 create table `heat_environment` (
43 `artifact_uuid` varchar(200) not null,
44 `name` varchar(100) not null,
45 `version` varchar(20) not null,
46 `description` varchar(1200) default null,
47 `body` longtext not null,
48 `artifact_checksum` varchar(200) not null default 'manual record',
49 `creation_timestamp` datetime not null default current_timestamp,
50 primary key (`artifact_uuid`)
51 ) engine=innodb default charset=latin1;
55 create table `heat_files` (
56 `artifact_uuid` varchar(200) not null,
57 `name` varchar(200) not null,
58 `version` varchar(20) not null,
59 `description` varchar(1200) default null,
60 `body` longtext not null,
61 `artifact_checksum` varchar(200) not null default 'manual record',
62 `creation_timestamp` datetime not null default current_timestamp,
63 primary key (`artifact_uuid`)
64 ) engine=innodb default charset=latin1;
69 create table `heat_template` (
70 `artifact_uuid` varchar(200) not null,
71 `name` varchar(200) not null,
72 `version` varchar(20) not null,
73 `description` varchar(1200) default null,
74 `body` longtext not null,
75 `timeout_minutes` int(11) default null,
76 `artifact_checksum` varchar(200) not null default 'manual record',
77 `creation_timestamp` datetime not null default current_timestamp,
78 primary key (`artifact_uuid`)
79 ) engine=innodb default charset=latin1;
83 create table `heat_nested_template` (
84 `parent_heat_template_uuid` varchar(200) not null,
85 `child_heat_template_uuid` varchar(200) not null,
86 `provider_resource_file` varchar(100) default null,
87 primary key (`parent_heat_template_uuid`,`child_heat_template_uuid`),
88 key `fk_heat_nested_template__heat_template2_idx` (`child_heat_template_uuid`),
89 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,
90 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
91 ) engine=innodb default charset=latin1;
96 create table `heat_template_params` (
97 `heat_template_artifact_uuid` varchar(200) not null,
98 `param_name` varchar(100) not null,
99 `is_required` bit(1) not null,
100 `param_type` varchar(20) default null,
101 `param_alias` varchar(45) default null,
102 primary key (`heat_template_artifact_uuid`,`param_name`),
103 constraint `fk_heat_template_params__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
104 ) engine=innodb default charset=latin1;
108 create table `network_recipe` (
109 `id` int(11) not null auto_increment,
110 `model_name` varchar(20) not null,
111 `action` varchar(50) not null,
112 `description` varchar(1200) default null,
113 `orchestration_uri` varchar(256) not null,
114 `network_param_xsd` varchar(2048) default null,
115 `recipe_timeout` int(11) default null,
116 `service_type` varchar(45) default null,
117 `creation_timestamp` datetime not null default current_timestamp,
118 `version_str` varchar(20) not null,
120 unique key `uk_rl4f296i0p8lyokxveaiwkayi` (`model_name`,`action`,`version_str`)
121 ) engine=innodb auto_increment=178 default charset=latin1;
126 create table `temp_network_heat_template_lookup` (
127 `network_resource_model_name` varchar(200) not null,
128 `heat_template_artifact_uuid` varchar(200) not null,
129 `aic_version_min` varchar(20) not null,
130 `aic_version_max` varchar(20) default null,
131 primary key (`network_resource_model_name`),
132 key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
133 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
134 ) engine=innodb default charset=latin1;
138 create table `network_resource` (
139 `model_uuid` varchar(200) not null,
140 `model_name` varchar(200) not null,
141 `model_invariant_uuid` varchar(200) default null,
142 `description` varchar(1200) default null,
143 `heat_template_artifact_uuid` varchar(200) not null,
144 `neutron_network_type` varchar(20) default null,
145 `model_version` varchar(20) default null,
146 `tosca_node_type` varchar(200) default null,
147 `aic_version_min` varchar(20) not null,
148 `aic_version_max` varchar(20) default null,
149 `orchestration_mode` varchar(20) default 'heat',
150 `resource_category` varchar(20) default null,
151 `resource_sub_category` varchar(20) default null,
152 `creation_timestamp` datetime not null default current_timestamp,
153 primary key (`model_uuid`),
154 key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
155 key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
156 constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade,
157 constraint `fk_network_resource__temp_network_heat_template_lookup__mod_nm1` foreign key (`model_name`) references `temp_network_heat_template_lookup` (`network_resource_model_name`) on delete no action on update no action
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 primary key (`model_customization_uuid`),
174 key `fk_network_resource_customization__network_resource1_idx` (`network_resource_model_uuid`),
175 constraint `fk_network_resource_customization__network_resource1` foreign key (`network_resource_model_uuid`) references `network_resource` (`model_uuid`) on delete cascade on update cascade
176 ) engine=innodb default charset=latin1;
182 create table `tosca_csar` (
183 `artifact_uuid` varchar(200) not null,
184 `name` varchar(200) not null,
185 `version` varchar(20) not null,
186 `description` varchar(1200) default null,
187 `artifact_checksum` varchar(200) not null,
188 `url` varchar(200) not null,
189 `creation_timestamp` datetime not null default current_timestamp,
190 primary key (`artifact_uuid`)
191 ) engine=innodb default charset=latin1;
196 create table `service` (
197 `model_uuid` varchar(200) not null,
198 `model_name` varchar(200) not null,
199 `model_invariant_uuid` varchar(200) not null,
200 `model_version` varchar(20) not null,
201 `description` varchar(1200) default null,
202 `creation_timestamp` datetime not null default current_timestamp,
203 `tosca_csar_artifact_uuid` varchar(200) default null,
204 `service_type` varchar(200) default null,
205 `service_role` varchar(200) default null,
206 `environment_context` varchar(200) default null,
207 `workload_context` varchar(200) default null,
208 `service_category` varchar(200) default null,
209 primary key (`model_uuid`),
210 key `fk_service__tosca_csar1_idx` (`tosca_csar_artifact_uuid`),
211 constraint `fk_service__tosca_csar1` foreign key (`tosca_csar_artifact_uuid`) references `tosca_csar` (`artifact_uuid`) on delete cascade on update cascade
212 ) engine=innodb default charset=latin1;
216 create table `service_recipe` (
217 `id` int(11) not null auto_increment,
218 `action` varchar(50) not null,
219 `version_str` varchar(20) default null,
220 `description` varchar(1200) default null,
221 `orchestration_uri` varchar(256) not null,
222 `service_param_xsd` varchar(2048) default null,
223 `recipe_timeout` int(11) default null,
224 `service_timeout_interim` int(11) default null,
225 `creation_timestamp` datetime not null default current_timestamp,
226 `service_model_uuid` varchar(200) not null,
228 unique key `uk_7fav5dkux2v8g9d2i5ymudlgc` (`service_model_uuid`,`action`),
229 key `fk_service_recipe__service1_idx` (`service_model_uuid`),
230 constraint `fk_service_recipe__service1` foreign key (`service_model_uuid`) references `service` (`model_uuid`) on delete cascade on update cascade
231 ) engine=innodb auto_increment=86 default charset=latin1;
235 create table `vnf_resource` (
236 `orchestration_mode` varchar(20) not null default 'heat',
237 `description` varchar(1200) default null,
238 `creation_timestamp` datetime not null default current_timestamp,
239 `model_uuid` varchar(200) not null,
240 `aic_version_min` varchar(20) default null,
241 `aic_version_max` varchar(20) default null,
242 `model_invariant_uuid` varchar(200) default null,
243 `model_version` varchar(20) not null,
244 `model_name` varchar(200) default null,
245 `tosca_node_type` varchar(200) default null,
246 `resource_category` varchar(200) default null,
247 `resource_sub_category` varchar(200) default null,
248 `heat_template_artifact_uuid` varchar(200) default null,
249 primary key (`model_uuid`),
250 key `fk_vnf_resource__heat_template1` (`heat_template_artifact_uuid`),
251 constraint `fk_vnf_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
252 ) engine=innodb default charset=latin1;
257 create table `vf_module` (
258 `model_uuid` varchar(200) not null,
259 `model_invariant_uuid` varchar(200) default null,
260 `model_version` varchar(20) not null,
261 `model_name` varchar(200) not null,
262 `description` varchar(1200) default null,
263 `is_base` int(11) not null,
264 `heat_template_artifact_uuid` varchar(200) default null,
265 `vol_heat_template_artifact_uuid` varchar(200) default null,
266 `creation_timestamp` datetime not null default current_timestamp,
267 `vnf_resource_model_uuid` varchar(200) not null,
268 primary key (`model_uuid`,`vnf_resource_model_uuid`),
269 key `fk_vf_module__vnf_resource1_idx` (`vnf_resource_model_uuid`),
270 key `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`heat_template_artifact_uuid`),
271 key `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`vol_heat_template_artifact_uuid`),
272 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,
273 constraint `fk_vf_module__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade,
274 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
275 ) engine=innodb default charset=latin1;
279 /*!40101 set @saved_cs_client = @@character_set_client */;
280 /*!40101 set character_set_client = utf8 */;
281 create table `vf_module_customization` (
282 `model_customization_uuid` varchar(200) not null,
283 `label` varchar(200) default null,
284 `initial_count` int(11) default '0',
285 `min_instances` int(11) default '0',
286 `max_instances` int(11) default null,
287 `availability_zone_count` int(11) default null,
288 `heat_environment_artifact_uuid` varchar(200) default null,
289 `vol_environment_artifact_uuid` varchar(200) default null,
290 `creation_timestamp` datetime not null default current_timestamp,
291 `vf_module_model_uuid` varchar(200) not null,
292 primary key (`model_customization_uuid`),
293 key `fk_vf_module_customization__vf_module1_idx` (`vf_module_model_uuid`),
294 key `fk_vf_module_customization__heat_env__heat_environment1_idx` (`heat_environment_artifact_uuid`),
295 key `fk_vf_module_customization__vol_env__heat_environment2_idx` (`vol_environment_artifact_uuid`),
296 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,
297 constraint `fk_vf_module_customization__vf_module1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade,
298 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
299 ) engine=innodb default charset=latin1;
300 /*!40101 set character_set_client = @saved_cs_client */;
303 -- table structure for table `vf_module_to_heat_files`
307 /*!40101 set @saved_cs_client = @@character_set_client */;
308 /*!40101 set character_set_client = utf8 */;
309 create table `vf_module_to_heat_files` (
310 `vf_module_model_uuid` varchar(200) not null,
311 `heat_files_artifact_uuid` varchar(200) not null,
312 primary key (`vf_module_model_uuid`,`heat_files_artifact_uuid`),
313 key `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`heat_files_artifact_uuid`),
314 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,
315 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
316 ) engine=innodb default charset=latin1 comment='il fait ce qu''il dit';
317 /*!40101 set character_set_client = @saved_cs_client */;
320 -- table structure for table `vnf_components`
324 /*!40101 set @saved_cs_client = @@character_set_client */;
325 /*!40101 set character_set_client = utf8 */;
326 create table `vnf_components` (
327 `vnf_id` int(11) not null,
328 `component_type` varchar(20) not null,
329 `heat_template_id` int(11) default null,
330 `heat_environment_id` int(11) default null,
331 `creation_timestamp` datetime not null default current_timestamp,
332 primary key (`vnf_id`,`component_type`)
333 ) engine=innodb default charset=latin1;
334 /*!40101 set character_set_client = @saved_cs_client */;
337 -- table structure for table `vnf_components_recipe`
342 create table `vnf_components_recipe` (
343 `id` int(11) not null auto_increment,
344 `vnf_type` varchar(200) default null,
345 `vnf_component_type` varchar(45) not null,
346 `action` varchar(50) not null,
347 `service_type` varchar(45) default null,
348 `version` varchar(20) not null,
349 `description` varchar(1200) default null,
350 `orchestration_uri` varchar(256) not null,
351 `vnf_component_param_xsd` varchar(2048) default null,
352 `recipe_timeout` int(11) default null,
353 `creation_timestamp` datetime default current_timestamp,
354 `vf_module_model_uuid` varchar(200) default null,
356 unique key `uk_4dpdwddaaclhc11wxsb7h59ma` (`vf_module_model_uuid`,`vnf_component_type`,`action`,`version`)
357 ) engine=innodb auto_increment=26 default charset=latin1;
362 create table `vnf_recipe` (
363 `id` int(11) not null auto_increment,
364 `nf_role` varchar(200) default null,
365 `action` varchar(50) not null,
366 `service_type` varchar(45) default null,
367 `version_str` varchar(20) not null,
368 `description` varchar(1200) default null,
369 `orchestration_uri` varchar(256) not null,
370 `vnf_param_xsd` varchar(2048) default null,
371 `recipe_timeout` int(11) default null,
372 `creation_timestamp` datetime default current_timestamp,
373 `vf_module_id` varchar(100) default null,
375 unique key `uk_f3tvqau498vrifq3cr8qnigkr` (`vf_module_id`,`action`,`version_str`)
376 ) engine=innodb auto_increment=10006 default charset=latin1;
385 create table `vnf_resource_customization` (
386 `model_customization_uuid` varchar(200) not null,
387 `model_instance_name` varchar(200) not null,
388 `min_instances` int(11) default null,
389 `max_instances` int(11) default null,
390 `availability_zone_max_count` int(11) default null,
391 `nf_type` varchar(200) default null,
392 `nf_role` varchar(200) default null,
393 `nf_function` varchar(200) default null,
394 `nf_naming_code` varchar(200) default null,
395 `creation_timestamp` datetime not null default current_timestamp,
396 `vnf_resource_model_uuid` varchar(200) not null,
397 `multi_stage_design` varchar(20) default null,
398 primary key (`model_customization_uuid`),
399 key `fk_vnf_resource_customization__vnf_resource1_idx` (`vnf_resource_model_uuid`),
400 constraint `fk_vnf_resource_customization__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade
401 ) engine=innodb default charset=latin1;
406 create table `vnf_res_custom_to_vf_module_custom` (
407 `vnf_resource_cust_model_customization_uuid` varchar(200) not null,
408 `vf_module_cust_model_customization_uuid` varchar(200) not null,
409 `creation_timestamp` datetime not null default current_timestamp,
410 primary key (`vnf_resource_cust_model_customization_uuid`,`vf_module_cust_model_customization_uuid`),
411 key `fk_vnf_res_custom_to_vf_module_custom__vf_module_customizat_idx` (`vf_module_cust_model_customization_uuid`),
412 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,
413 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
414 ) engine=innodb default charset=latin1;
417 create table if not exists `external_service_to_internal_model_mapping` (
419 service_name varchar(200) not null,
420 product_flavor varchar(200) null,
421 subscription_service_type varchar(200) not null,
422 service_model_uuid varchar(200) not null,
424 unique index uk_external_service_to_internal_model_mapping
425 (service_name asc, product_flavor asc, service_model_uuid asc));
427 create table if not exists `collection_resource` (
428 model_uuid varchar(200) not null,
429 model_name varchar(200) not null,
430 model_invariant_uuid varchar(200) not null,
431 model_version varchar(20) not null,
432 tosca_node_type varchar(200) not null,
433 description varchar(200),
434 creation_timestamp datetime not null default current_timestamp,
435 primary key (`model_uuid`)
436 )engine=innodb default charset=latin1;
438 create table if not exists `collection_resource_customization` (
439 model_customization_uuid varchar(200) not null,
440 model_instance_name varchar(200) not null,
441 role varchar(200) NULL,
442 object_type varchar(200) not null,
443 function varchar(200) NULL,
444 collection_resource_type varchar(200) NULL,
445 creation_timestamp datetime not null default current_timestamp,
446 cr_model_uuid varchar(200) not null,
447 primary key (`model_customization_uuid`)
448 )engine=innodb default charset=latin1;
450 create table if not exists `instance_group` (
451 model_uuid varchar(200) not null,
452 model_name varchar(200) not null,
453 model_invariant_uuid varchar(200) not null,
454 model_version varchar(20) not null,
455 tosca_node_type varchar(200) NULL,
456 role varchar(200) not null,
457 object_type varchar(200) not null,
458 creation_timestamp datetime not null default current_timestamp,
459 cr_model_uuid varchar(200) not null,
460 instance_group_type varchar(200) not null,
461 primary key (`model_uuid`)
462 )engine=innodb default charset=latin1;
465 create table if not exists `collection_resource_instance_group_customization` (
466 `collection_resource_customization_model_uuid` varchar(200) not null,
467 `instance_group_model_uuid` varchar(200) not null,
468 `function` varchar(200) null,
469 `description` varchar(1200) null,
470 `subinterface_network_quantity` int(11) null,
471 `creation_timestamp` datetime not null default current_timestamp,
472 primary key (`collection_resource_customization_model_uuid`, `instance_group_model_uuid`),
473 index `fk_collection_resource_instance_group_customization__instan_idx` (`instance_group_model_uuid` asc),
474 constraint `fk_collection_resource_instance_group_customization__collecti1`
475 foreign key (`collection_resource_customization_model_uuid`)
476 references `collection_resource_customization` (`model_customization_uuid`)
479 constraint `fk_collection_resource_instance_group_customization__instance1`
480 foreign key (`instance_group_model_uuid`)
481 references `instance_group` (`model_uuid`)
485 default character set = latin1;
487 create table if not exists `vnfc_instance_group_customization` (
488 `vnf_resource_customization_model_uuid` varchar(200) not null,
489 `instance_group_model_uuid` varchar(200) not null,
490 `function` varchar(200) null,
491 `description` varchar(1200) null,
492 `creation_timestamp` datetime not null default current_timestamp,
493 primary key (`vnf_resource_customization_model_uuid`, `instance_group_model_uuid`),
494 index `fk_vnfc_instance_group_customization__instance_group1_idx` (`instance_group_model_uuid` asc),
495 constraint `fk_vnfc_instance_group_customization__vnf_resource_customizat1`
496 foreign key (`vnf_resource_customization_model_uuid`)
497 references `vnf_resource_customization` (`model_customization_uuid`)
500 constraint `fk_vnfc_instance_group_customization__instance_group1`
501 foreign key (`instance_group_model_uuid`)
502 references `instance_group` (`model_uuid`)
506 default character set = latin1;
508 create table if not exists `configuration`
509 ( `model_uuid` varchar(200) not null,
510 `model_invariant_uuid` varchar(200) not null,
511 `model_version` varchar(20) not null,
512 `model_name` varchar(200) not null,
513 `tosca_node_type` varchar(200) not null,
514 `description` varchar(1200) null,
515 `creation_timestamp` datetime not null default current_timestamp,
516 primary key (`model_uuid`))
517 engine = innodb auto_increment = 20654
518 default character set = latin1;
520 CREATE TABLE IF NOT EXISTS `service_proxy_customization` (
521 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
522 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
523 `MODEL_UUID` VARCHAR(200) NOT NULL,
524 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
525 `MODEL_VERSION` VARCHAR(20) NOT NULL,
526 `MODEL_NAME` VARCHAR(200) NOT NULL,
527 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
528 `DESCRIPTION` VARCHAR(1200) NULL,
529 `SOURCE_SERVICE_MODEL_UUID` VARCHAR(200) NOT NULL,
530 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
531 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
532 INDEX `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID` ASC),
533 UNIQUE INDEX `UK_service_proxy_customization` (`MODEL_CUSTOMIZATION_UUID` ASC),
534 INDEX `fk_service_proxy_customization__serv_prox_to_serv` (`MODEL_CUSTOMIZATION_UUID` ASC),
535 CONSTRAINT `fk_service_proxy_resource_customization__service1`
536 FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`)
537 REFERENCES `service` (`MODEL_UUID`)
541 AUTO_INCREMENT = 20654
542 DEFAULT CHARACTER SET = latin1;
544 create table if not exists `configuration_customization` (
545 `model_customization_uuid` varchar(200) not null,
546 `model_instance_name` varchar(200) not null,
547 `configuration_type` varchar(200) null,
548 `configuration_role` varchar(200) null,
549 `configuration_function` varchar(200) null,
550 `creation_timestamp` datetime not null default current_timestamp,
551 `configuration_model_uuid` varchar(200) not null,
552 `service_proxy_customization_model_customization_uuid` varchar(200) null,
553 `configuration_customization_model_customization_uuid` varchar(200) null,
554 primary key (`model_customization_uuid`),
555 index `fk_configuration_customization__configuration_idx` (`configuration_model_uuid` asc),
556 index `fk_configuration_customization__configuration_customization_idx`
557 (`configuration_customization_model_customization_uuid` asc),
558 constraint `fk_configuration_resource_customization__configuration_resour1`
559 foreign key (`configuration_model_uuid`) references `configuration` (`model_uuid`)
560 on delete cascade on update cascade,
561 constraint `fk_configuration_customization__configuration_customization1`
562 foreign key (`configuration_customization_model_customization_uuid`) references
563 `configuration_customization` (`model_customization_uuid`)
564 on delete cascade on update cascade)
566 auto_increment =20654
567 default character set = latin1;
570 create table `service_proxy_customization_to_service` (
571 `service_model_uuid` varchar(200) not null,
572 `resource_model_customization_uuid` varchar(200) not null,
573 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
574 )engine=innodb default charset=latin1;
577 create table `configuration_customization_to_service` (
578 `service_model_uuid` varchar(200) not null,
579 `resource_model_customization_uuid` varchar(200) not null,
580 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
581 )engine=innodb default charset=latin1;
584 create table if not exists `collection_resource_customization_to_service` (
585 `service_model_uuid` varchar(200) not null,
586 `resource_model_customization_uuid` varchar(200) not null,
587 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
588 )engine=innodb default charset=latin1;
591 create table `network_resource_customization_to_service` (
592 `service_model_uuid` varchar(200) not null,
593 `resource_model_customization_uuid` varchar(200) not null,
594 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
595 )engine=innodb default charset=latin1;
597 create table `vnf_resource_customization_to_service` (
598 `service_model_uuid` varchar(200) not null,
599 `resource_model_customization_uuid` varchar(200) not null,
600 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
601 )engine=innodb default charset=latin1;
603 create table `allotted_resource_customization_to_service` (
604 `service_model_uuid` varchar(200) not null,
605 `resource_model_customization_uuid` varchar(200) not null,
606 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
607 )engine=innodb default charset=latin1;
611 create table ar_recipe (
612 ID INT(11) not null auto_increment,
613 MODEL_NAME VARCHAR(200) NOT NULL,
614 `ACTION` VARCHAR(200) NOT NULL,
615 VERSION_STR VARCHAR(200) NOT NULL,
616 SERVICE_TYPE VARCHAR(200),
617 DESCRIPTION VARCHAR(200),
618 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
619 AR_PARAM_XSD VARCHAR(200),
620 RECIPE_TIMEOUT INT(10),
621 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
623 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
624 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
626 alter table collection_resource_customization
627 add foreign key ( cr_model_uuid)
628 references collection_resource(model_uuid)
631 alter table vnf_resource_customization
633 instance_group_model_uuid varchar(200);
635 alter table network_resource_customization
637 instance_group_model_uuid varchar(200);
640 alter table network_resource_customization
641 add foreign key ( instance_group_model_uuid)
642 references instance_group(model_uuid)
645 alter table collection_resource_customization_to_service
646 add foreign key (service_model_uuid)
647 references service(model_uuid)
650 alter table allotted_resource_customization_to_service
651 add foreign key (service_model_uuid)
652 references service(model_uuid)
656 alter table vnf_resource_customization_to_service
657 add foreign key (service_model_uuid)
658 references service(model_uuid)
662 alter table network_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 (resource_model_customization_uuid)
670 references network_resource_customization(model_customization_uuid)
673 alter table vnf_resource_customization_to_service
674 add foreign key (resource_model_customization_uuid)
675 references vnf_resource_customization(model_customization_uuid)
678 alter table allotted_resource_customization_to_service
679 add foreign key (resource_model_customization_uuid)
680 references allotted_resource_customization(model_customization_uuid)
683 alter table collection_resource_customization_to_service
684 add foreign key (resource_model_customization_uuid)
685 references collection_resource_customization(model_customization_uuid)
689 create table if not exists `collection_network_resource_customization` (
690 `model_customization_uuid` varchar(200) not null,
691 `model_instance_name` varchar(200) not null,
692 `network_technology` varchar(45) null,
693 `network_type` varchar(45) null,
694 `network_role` varchar(200) null,
695 `network_scope` varchar(45) null,
696 `creation_timestamp` datetime not null default current_timestamp,
697 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
698 `crc_model_customization_uuid` varchar(200) not null, primary key
699 (`model_customization_uuid`, `crc_model_customization_uuid`),
700 index `fk_collection_net_resource_customization__network_resource1_idx`
701 (`network_resource_model_uuid` asc), index
702 `fk_collection_net_resource_customization__instance_group1_idx`
703 (`instance_group_model_uuid` asc), index
704 `fk_col_net_res_customization__collection_res_customization_idx`
705 (`crc_model_customization_uuid` asc), constraint
706 `fk_collection_net_resource_customization__network_resource10` foreign
707 key (`network_resource_model_uuid`) references
708 `network_resource` (`model_uuid`) on delete cascade on
709 update cascade, constraint
710 `fk_collection_net_resource_customization__instance_group10` foreign key
711 (`instance_group_model_uuid`) references `instance_group`
712 (`model_uuid`) on delete cascade on update cascade, constraint
713 `fk_collection_network_resource_customization__collection_reso1` foreign
714 key (`crc_model_customization_uuid`) references
715 `collection_resource_customization`
716 (`model_customization_uuid`) on delete cascade on update cascade) engine
717 = innodb default character set = latin1;
719 CREATE TABLE IF NOT EXISTS `rainy_day_handler_macro` (
720 `id` INT(11) NOT NULL AUTO_INCREMENT,
721 `FLOW_NAME` VARCHAR(200) NOT NULL,
722 `SERVICE_TYPE` VARCHAR(200) NOT NULL,
723 `VNF_TYPE` VARCHAR(200) NOT NULL,
724 `ERROR_CODE` VARCHAR(200) NOT NULL,
725 `WORK_STEP` VARCHAR(200) NOT NULL,
726 `POLICY` VARCHAR(200) NOT NULL,
729 DEFAULT CHARACTER SET = latin1;
731 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
732 `id` INT(11) NOT NULL AUTO_INCREMENT,
733 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
734 `ACTION` VARCHAR(200) NOT NULL,
735 `MACRO_ACTION` VARCHAR(200) NOT NULL,
736 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
737 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 0,
738 `MIN_API_VERSION` DOUBLE NOT NULL,
739 `MAX_API_VERSION` DOUBLE NULL,
741 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC))
743 DEFAULT CHARACTER SET = latin1;
745 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
746 `id` INT(11) NOT NULL AUTO_INCREMENT,
747 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
748 `SEQ_NO` INT(11) NOT NULL,
749 `FLOW_NAME` VARCHAR(200) NOT NULL,
750 `FLOW_VERSION` DOUBLE NOT NULL,
751 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
753 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
754 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
755 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
756 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
757 ON DELETE CASCADE ON UPDATE CASCADE)
758 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
760 CREATE TABLE IF NOT EXISTS vnfc_customization (
761 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
762 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
763 `MODEL_UUID` VARCHAR(200) NOT NULL,
764 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
765 `MODEL_VERSION` VARCHAR(20) NOT NULL,
766 `MODEL_NAME` VARCHAR(200) NOT NULL,
767 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
768 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
769 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
770 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`))
772 AUTO_INCREMENT = 20654
773 DEFAULT CHARACTER SET = latin1;
775 CREATE TABLE IF NOT EXISTS cvnfc_customization (
776 `ID` INT(11) NOT NULL AUTO_INCREMENT,
777 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
778 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
779 `MODEL_UUID` VARCHAR(200) NOT NULL,
780 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
781 `MODEL_VERSION` VARCHAR(20) NOT NULL,
782 `MODEL_NAME` VARCHAR(200) NOT NULL,
783 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
784 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
785 `NFC_FUNCTION` VARCHAR(200) NULL,
786 `NFC_NAMING_CODE` VARCHAR(200) NULL,
787 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
788 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
789 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
790 `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
792 UPDATE CASCADE, CONSTRAINT `fk_cvnfc_customization__vnfc_customization1` FOREIGN KEY (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`) REFERENCES `vnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON
794 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
796 UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = latin1;
798 CREATE TABLE IF NOT EXISTS vnf_vfmodule_cvnfc_configuration_customization (
799 `ID` INT(11) NOT NULL AUTO_INCREMENT,
800 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
801 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
802 `VF_MODULE_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
803 `CVNFC_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
804 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
805 `CONFIGURATION_TYPE` VARCHAR(200) NULL,
806 `CONFIGURATION_ROLE` VARCHAR(200) NULL,
807 `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
808 `POLICY_NAME` VARCHAR(200) NULL,
809 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
810 `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
812 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
813 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),
814 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__cvnfc_cust1_idx` (`CVNFC_MODEL_CUSTOMIZATION_UUID` ASC),
815 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vf_module_cust_idx` (`VF_MODULE_MODEL_CUSTOMIZATION_UUID` ASC),
816 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vnf_res_cust_idx` (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC),
817 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
818 REFERENCES `configuration` (`MODEL_UUID`)
819 ON DELETE CASCADE ON UPDATE CASCADE,
820 CONSTRAINT `fk_cvnfc_configuration_customization__cvnfc_customization1` FOREIGN KEY (`CVNFC_MODEL_CUSTOMIZATION_UUID`)
821 REFERENCES `cvnfc_customization` (`MODEL_CUSTOMIZATION_UUID`)
822 ON DELETE CASCADE ON UPDATE CASCADE,
823 CONSTRAINT `fk_vnf_configuration_cvnfc_customization__vf_module_customiza1` FOREIGN KEY (`VF_MODULE_MODEL_CUSTOMIZATION_UUID`)
824 REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`)
825 ON DELETE CASCADE ON UPDATE CASCADE,
826 CONSTRAINT `fk_vfmodule_cvnfc_configuration_customization__vnf_resource_c1` FOREIGN KEY (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`)
827 REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`)
828 ON DELETE CASCADE ON UPDATE CASCADE
829 ) ENGINE=INNODB AUTO_INCREMENT=20654 DEFAULT CHARACTER SET=LATIN1;
831 --------START Request DB SCHEMA --------
832 CREATE DATABASE requestdb;
836 CREATE TABLE `infra_active_requests` (
837 `REQUEST_ID` varchar(45) NOT NULL,
838 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
839 `ACTION` varchar(45) DEFAULT NULL,
840 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
841 `STATUS_MESSAGE` longtext DEFAULT NULL,
842 `PROGRESS` bigint(20) DEFAULT NULL,
843 `START_TIME` datetime DEFAULT NULL,
844 `END_TIME` datetime DEFAULT NULL,
845 `SOURCE` varchar(45) DEFAULT NULL,
846 `VNF_ID` varchar(45) DEFAULT NULL,
847 `VNF_NAME` varchar(80) DEFAULT NULL,
848 `VNF_TYPE` varchar(200) DEFAULT NULL,
849 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
850 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
851 `TENANT_ID` varchar(45) DEFAULT NULL,
852 `PROV_STATUS` varchar(20) DEFAULT NULL,
853 `VNF_PARAMS` longtext,
854 `VNF_OUTPUTS` longtext,
855 `REQUEST_BODY` longtext,
856 `RESPONSE_BODY` longtext,
857 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
858 `MODIFY_TIME` datetime DEFAULT NULL,
859 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
860 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
861 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
862 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
863 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
864 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
865 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
866 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
867 `CALLBACK_URL` varchar(200) DEFAULT NULL,
868 `CORRELATOR` varchar(80) DEFAULT NULL,
869 `NETWORK_ID` varchar(45) DEFAULT NULL,
870 `NETWORK_NAME` varchar(80) DEFAULT NULL,
871 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
872 `REQUEST_SCOPE` varchar(45) NOT NULL DEFAULT 'unknown',
873 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
874 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
875 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
876 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
877 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
878 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
879 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
880 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
881 `REQUEST_URL` varchar(500) DEFAULT NULL,
882 PRIMARY KEY (`REQUEST_ID`),
883 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
884 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
886 CREATE TABLE `archived_infra_requests` (
887 `REQUEST_ID` varchar(45) NOT NULL,
888 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
889 `ACTION` varchar(45) DEFAULT NULL,
890 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
891 `STATUS_MESSAGE` longtext DEFAULT NULL,
892 `PROGRESS` bigint(20) DEFAULT NULL,
893 `START_TIME` datetime DEFAULT NULL,
894 `END_TIME` datetime DEFAULT NULL,
895 `SOURCE` varchar(45) DEFAULT NULL,
896 `VNF_ID` varchar(45) DEFAULT NULL,
897 `VNF_NAME` varchar(80) DEFAULT NULL,
898 `VNF_TYPE` varchar(200) DEFAULT NULL,
899 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
900 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
901 `TENANT_ID` varchar(45) DEFAULT NULL,
902 `PROV_STATUS` varchar(20) DEFAULT NULL,
903 `VNF_PARAMS` longtext,
904 `VNF_OUTPUTS` longtext,
905 `REQUEST_BODY` longtext,
906 `RESPONSE_BODY` longtext,
907 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
908 `MODIFY_TIME` datetime DEFAULT NULL,
909 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
910 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
911 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
912 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
913 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
914 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
915 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
916 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
917 `CALLBACK_URL` varchar(200) DEFAULT NULL,
918 `CORRELATOR` varchar(80) DEFAULT NULL,
919 `NETWORK_ID` varchar(45) DEFAULT NULL,
920 `NETWORK_NAME` varchar(80) DEFAULT NULL,
921 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
922 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
923 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
924 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
925 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
926 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
927 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
928 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
929 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
930 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
931 `REQUEST_URL` varchar(500) DEFAULT NULL,
932 PRIMARY KEY (`REQUEST_ID`),
933 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d59h` (`CLIENT_REQUEST_ID`)
934 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
936 CREATE TABLE `site_status` (
937 `SITE_NAME` varchar(255) NOT NULL,
938 `STATUS` bit(1) DEFAULT NULL,
939 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
940 PRIMARY KEY (`SITE_NAME`)
941 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
943 CREATE TABLE `watchdog_distributionid_status` (
944 `DISTRIBUTION_ID` varchar(45) NOT NULL,
945 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
946 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
947 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
948 PRIMARY KEY (`DISTRIBUTION_ID`)
949 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
951 CREATE TABLE `watchdog_per_component_distribution_status` (
952 `DISTRIBUTION_ID` varchar(45) NOT NULL,
953 `COMPONENT_NAME` varchar(45) NOT NULL,
954 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
955 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
956 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
957 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
958 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
959 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
961 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
962 `DISTRIBUTION_ID` varchar(45) NOT NULL,
963 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
964 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
965 `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
966 PRIMARY KEY (`DISTRIBUTION_ID`,`SERVICE_MODEL_VERSION_ID`)
967 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
969 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
970 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
971 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
972 `REQUEST_ID` varchar(45) NOT NULL,
973 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
974 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
975 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
976 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
977 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
978 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
979 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
980 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
982 CREATE TABLE `activate_operational_env_per_distributionid_status` (
983 `DISTRIBUTION_ID` varchar(45) NOT NULL,
984 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
985 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
986 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
987 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
988 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
989 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
990 `REQUEST_ID` varchar(45) NOT NULL,
991 PRIMARY KEY (`DISTRIBUTION_ID`),
992 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
993 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
994 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
996 create table operation_status (
997 SERVICE_ID varchar(255) not null,
998 OPERATION_ID varchar(255) not null,
999 SERVICE_NAME varchar(255),
1000 OPERATION_TYPE varchar(255),
1001 USER_ID varchar(255),
1002 RESULT varchar(255),
1003 OPERATION_CONTENT varchar(255),
1004 PROGRESS varchar(255),
1005 REASON varchar(255),
1006 OPERATE_AT datetime NOT NULL,
1007 FINISHED_AT datetime NOT NULL,
1008 primary key (SERVICE_ID,OPERATION_ID)
1009 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1011 create table resource_operation_status (
1012 SERVICE_ID varchar(255) not null,
1013 OPERATION_ID varchar(255) not null,
1014 RESOURCE_TEMPLATE_UUID varchar(255) not null,
1015 OPER_TYPE varchar(255),
1016 RESOURCE_INSTANCE_ID varchar(255),
1017 JOB_ID varchar(255),
1018 STATUS varchar(255),
1019 PROGRESS varchar(255),
1020 ERROR_CODE varchar(255) ,
1021 STATUS_DESCRIPOTION varchar(255) ,
1022 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
1023 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1025 create table if not exists model_recipe (
1026 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1028 `ACTION` VARCHAR(40),
1029 `SCHEMA_VERSION` VARCHAR(40),
1030 `DESCRIPTION` VARCHAR(40),
1031 `ORCHESTRATION_URI` VARCHAR(20),
1032 `MODEL_PARAM_XSD` VARCHAR(20),
1033 `RECIPE_TIMEOUT` INT(11),
1034 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1036 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
1037 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1039 create table if not exists model (
1040 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1041 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
1042 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
1043 `MODEL_INVARIANT_ID` VARCHAR(40),
1044 `MODEL_NAME` VARCHAR(40),
1045 `MODEL_TYPE` VARCHAR(20),
1046 `MODEL_VERSION` VARCHAR(20),
1047 `MODEL_VERSION_ID` VARCHAR(40),
1048 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1051 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
1052 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1053 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;