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` (
521 `model_uuid` varchar(200) not null,
522 `model_invariant_uuid` varchar(200) not null,
523 `model_version` varchar(20) not null,
524 `model_name` varchar(200) not null,
525 `description` varchar(1200) null,
526 `creation_timestamp` datetime not null default current_timestamp,
527 primary key (`model_uuid`))
528 engine = innodb auto_increment = 20654
529 default character set = latin1;
531 create table if not exists `service_proxy_customization` (
532 `model_customization_uuid` varchar(200) not null,
533 `model_instance_name` varchar(200) not null,
534 `tosca_node_type` varchar(200) not null,
535 `source_service_model_uuid` varchar(200) not null,
536 `creation_timestamp` datetime not null default current_timestamp,
537 `service_proxy_model_uuid` varchar(200) not null,
538 primary key (`model_customization_uuid`),
539 index `fk_service_proxy_customization__service_proxy1_idx` (`service_proxy_model_uuid` asc),
540 index `fk_service_proxy_customization__service1_idx` (`source_service_model_uuid` asc),
541 constraint`fk_spr_customization__service_proxy_resource1`
542 foreign key (`service_proxy_model_uuid`) references `service_proxy` (`model_uuid`)
543 on delete cascade on update cascade,
544 constraint `fk_service_proxy_resource_customization__service1`
545 foreign key (`source_service_model_uuid`) references `service`
546 (`model_uuid`) on delete cascade on update cascade)
548 auto_increment = 20654
549 default character set = latin1;
551 create table if not exists `configuration_customization` (
552 `model_customization_uuid` varchar(200) not null,
553 `model_instance_name` varchar(200) not null,
554 `configuration_type` varchar(200) null,
555 `configuration_role` varchar(200) null,
556 `configuration_function` varchar(200) null,
557 `creation_timestamp` datetime not null default current_timestamp,
558 `configuration_model_uuid` varchar(200) not null,
559 `service_proxy_customization_model_customization_uuid` varchar(200) null,
560 `configuration_customization_model_customization_uuid` varchar(200) null,
561 primary key (`model_customization_uuid`),
562 index `fk_configuration_customization__configuration_idx` (`configuration_model_uuid` asc),
563 index `fk_configuration_customization__service_proxy_customization_idx`
564 (`service_proxy_customization_model_customization_uuid` asc),
565 index `fk_configuration_customization__configuration_customization_idx`
566 (`configuration_customization_model_customization_uuid` asc),
567 constraint `fk_configuration_resource_customization__configuration_resour1`
568 foreign key (`configuration_model_uuid`) references `configuration` (`model_uuid`)
569 on delete cascade on update cascade,
570 constraint `fk_configuration_customization__service_proxy_customization1` foreign
571 key (`service_proxy_customization_model_customization_uuid`) references
572 `service_proxy_customization` (`model_customization_uuid`)
573 on delete cascade on update cascade, constraint
574 `fk_configuration_customization__configuration_customization1` foreign
575 key (`configuration_customization_model_customization_uuid`) references
576 `configuration_customization` (`model_customization_uuid`)
577 on delete cascade on update cascade)
579 auto_increment =20654
580 default character set = latin1;
583 create table `service_proxy_customization_to_service` (
584 `service_model_uuid` varchar(200) not null,
585 `resource_model_customization_uuid` varchar(200) not null,
586 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
587 )engine=innodb default charset=latin1;
590 create table `configuration_customization_to_service` (
591 `service_model_uuid` varchar(200) not null,
592 `resource_model_customization_uuid` varchar(200) not null,
593 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
594 )engine=innodb default charset=latin1;
597 create table if not exists `collection_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;
604 create table `network_resource_customization_to_service` (
605 `service_model_uuid` varchar(200) not null,
606 `resource_model_customization_uuid` varchar(200) not null,
607 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
608 )engine=innodb default charset=latin1;
610 create table `vnf_resource_customization_to_service` (
611 `service_model_uuid` varchar(200) not null,
612 `resource_model_customization_uuid` varchar(200) not null,
613 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
614 )engine=innodb default charset=latin1;
616 create table `allotted_resource_customization_to_service` (
617 `service_model_uuid` varchar(200) not null,
618 `resource_model_customization_uuid` varchar(200) not null,
619 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
620 )engine=innodb default charset=latin1;
624 create table ar_recipe (
625 ID INT(11) not null auto_increment,
626 MODEL_NAME VARCHAR(200) NOT NULL,
627 `ACTION` VARCHAR(200) NOT NULL,
628 VERSION_STR VARCHAR(200) NOT NULL,
629 SERVICE_TYPE VARCHAR(200),
630 DESCRIPTION VARCHAR(200),
631 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
632 AR_PARAM_XSD VARCHAR(200),
633 RECIPE_TIMEOUT INT(10),
634 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
636 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
637 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
639 alter table collection_resource_customization
640 add foreign key ( cr_model_uuid)
641 references collection_resource(model_uuid)
644 alter table vnf_resource_customization
646 instance_group_model_uuid varchar(200);
648 alter table network_resource_customization
650 instance_group_model_uuid varchar(200);
653 alter table network_resource_customization
654 add foreign key ( instance_group_model_uuid)
655 references instance_group(model_uuid)
658 alter table collection_resource_customization_to_service
659 add foreign key (service_model_uuid)
660 references service(model_uuid)
663 alter table allotted_resource_customization_to_service
664 add foreign key (service_model_uuid)
665 references service(model_uuid)
669 alter table vnf_resource_customization_to_service
670 add foreign key (service_model_uuid)
671 references service(model_uuid)
675 alter table network_resource_customization_to_service
676 add foreign key (service_model_uuid)
677 references service(model_uuid)
681 alter table network_resource_customization_to_service
682 add foreign key (resource_model_customization_uuid)
683 references network_resource_customization(model_customization_uuid)
686 alter table vnf_resource_customization_to_service
687 add foreign key (resource_model_customization_uuid)
688 references vnf_resource_customization(model_customization_uuid)
691 alter table allotted_resource_customization_to_service
692 add foreign key (resource_model_customization_uuid)
693 references allotted_resource_customization(model_customization_uuid)
696 alter table collection_resource_customization_to_service
697 add foreign key (resource_model_customization_uuid)
698 references collection_resource_customization(model_customization_uuid)
702 create table if not exists `collection_network_resource_customization` (
703 `model_customization_uuid` varchar(200) not null,
704 `model_instance_name` varchar(200) not null,
705 `network_technology` varchar(45) null,
706 `network_type` varchar(45) null,
707 `network_role` varchar(200) null,
708 `network_scope` varchar(45) null,
709 `creation_timestamp` datetime not null default current_timestamp,
710 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
711 `crc_model_customization_uuid` varchar(200) not null, primary key
712 (`model_customization_uuid`, `crc_model_customization_uuid`),
713 index `fk_collection_net_resource_customization__network_resource1_idx`
714 (`network_resource_model_uuid` asc), index
715 `fk_collection_net_resource_customization__instance_group1_idx`
716 (`instance_group_model_uuid` asc), index
717 `fk_col_net_res_customization__collection_res_customization_idx`
718 (`crc_model_customization_uuid` asc), constraint
719 `fk_collection_net_resource_customization__network_resource10` foreign
720 key (`network_resource_model_uuid`) references
721 `network_resource` (`model_uuid`) on delete cascade on
722 update cascade, constraint
723 `fk_collection_net_resource_customization__instance_group10` foreign key
724 (`instance_group_model_uuid`) references `instance_group`
725 (`model_uuid`) on delete cascade on update cascade, constraint
726 `fk_collection_network_resource_customization__collection_reso1` foreign
727 key (`crc_model_customization_uuid`) references
728 `collection_resource_customization`
729 (`model_customization_uuid`) on delete cascade on update cascade) engine
730 = innodb default character set = latin1;
732 CREATE TABLE IF NOT EXISTS `rainy_day_handler_macro` (
733 `id` INT(11) NOT NULL AUTO_INCREMENT,
734 `FLOW_NAME` VARCHAR(200) NOT NULL,
735 `SERVICE_TYPE` VARCHAR(200) NOT NULL,
736 `VNF_TYPE` VARCHAR(200) NOT NULL,
737 `ERROR_CODE` VARCHAR(200) NOT NULL,
738 `WORK_STEP` VARCHAR(200) NOT NULL,
739 `POLICY` VARCHAR(200) NOT NULL,
742 DEFAULT CHARACTER SET = latin1;
744 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
745 `id` INT(11) NOT NULL AUTO_INCREMENT,
746 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
747 `ACTION` VARCHAR(200) NOT NULL,
748 `MACRO_ACTION` VARCHAR(200) NOT NULL,
749 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
750 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 0,
751 `MIN_API_VERSION` DOUBLE NOT NULL,
752 `MAX_API_VERSION` DOUBLE NULL,
754 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC))
756 DEFAULT CHARACTER SET = latin1;
758 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
759 `id` INT(11) NOT NULL AUTO_INCREMENT,
760 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
761 `SEQ_NO` INT(11) NOT NULL,
762 `FLOW_NAME` VARCHAR(200) NOT NULL,
763 `FLOW_VERSION` DOUBLE NOT NULL,
764 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
766 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
767 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
768 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
769 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
770 ON DELETE CASCADE ON UPDATE CASCADE)
771 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
773 CREATE TABLE IF NOT EXISTS vnfc_customization (
774 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
775 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
776 `MODEL_UUID` VARCHAR(200) NOT NULL,
777 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
778 `MODEL_VERSION` VARCHAR(20) NOT NULL,
779 `MODEL_NAME` VARCHAR(200) NOT NULL,
780 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
781 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
782 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
783 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`))
785 AUTO_INCREMENT = 20654
786 DEFAULT CHARACTER SET = latin1;
788 CREATE TABLE IF NOT EXISTS cvnfc_customization (
789 `ID` INT(11) NOT NULL AUTO_INCREMENT,
790 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
791 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
792 `MODEL_UUID` VARCHAR(200) NOT NULL,
793 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
794 `MODEL_VERSION` VARCHAR(20) NOT NULL,
795 `MODEL_NAME` VARCHAR(200) NOT NULL,
796 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
797 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
798 `NFC_FUNCTION` VARCHAR(200) NULL,
799 `NFC_NAMING_CODE` VARCHAR(200) NULL,
800 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
801 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
802 `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
803 `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
805 UPDATE CASCADE, CONSTRAINT `fk_cvnfc_customization__vnfc_customization1` FOREIGN KEY (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`) REFERENCES `vnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON
807 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
809 UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = latin1;
811 CREATE TABLE IF NOT EXISTS vnf_vfmodule_cvnfc_configuration_customization (
812 `ID` INT(11) NOT NULL AUTO_INCREMENT,
813 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
814 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
815 `VF_MODULE_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
816 `CVNFC_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
817 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
818 `CONFIGURATION_TYPE` VARCHAR(200) NULL,
819 `CONFIGURATION_ROLE` VARCHAR(200) NULL,
820 `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
821 `POLICY_NAME` VARCHAR(200) NULL,
822 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
823 `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
825 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
826 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),
827 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__cvnfc_cust1_idx` (`CVNFC_MODEL_CUSTOMIZATION_UUID` ASC),
828 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vf_module_cust_idx` (`VF_MODULE_MODEL_CUSTOMIZATION_UUID` ASC),
829 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vnf_res_cust_idx` (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC),
830 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
831 REFERENCES `configuration` (`MODEL_UUID`)
832 ON DELETE CASCADE ON UPDATE CASCADE,
833 CONSTRAINT `fk_cvnfc_configuration_customization__cvnfc_customization1` FOREIGN KEY (`CVNFC_MODEL_CUSTOMIZATION_UUID`)
834 REFERENCES `cvnfc_customization` (`MODEL_CUSTOMIZATION_UUID`)
835 ON DELETE CASCADE ON UPDATE CASCADE,
836 CONSTRAINT `fk_vnf_configuration_cvnfc_customization__vf_module_customiza1` FOREIGN KEY (`VF_MODULE_MODEL_CUSTOMIZATION_UUID`)
837 REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`)
838 ON DELETE CASCADE ON UPDATE CASCADE,
839 CONSTRAINT `fk_vfmodule_cvnfc_configuration_customization__vnf_resource_c1` FOREIGN KEY (`VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`)
840 REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`)
841 ON DELETE CASCADE ON UPDATE CASCADE
842 ) ENGINE=INNODB AUTO_INCREMENT=20654 DEFAULT CHARACTER SET=LATIN1;
844 --------START Request DB SCHEMA --------
845 CREATE DATABASE requestdb;
849 CREATE TABLE `infra_active_requests` (
850 `REQUEST_ID` varchar(45) NOT NULL,
851 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
852 `ACTION` varchar(45) DEFAULT NULL,
853 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
854 `STATUS_MESSAGE` longtext DEFAULT NULL,
855 `PROGRESS` bigint(20) DEFAULT NULL,
856 `START_TIME` datetime DEFAULT NULL,
857 `END_TIME` datetime DEFAULT NULL,
858 `SOURCE` varchar(45) DEFAULT NULL,
859 `VNF_ID` varchar(45) DEFAULT NULL,
860 `VNF_NAME` varchar(80) DEFAULT NULL,
861 `VNF_TYPE` varchar(200) DEFAULT NULL,
862 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
863 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
864 `TENANT_ID` varchar(45) DEFAULT NULL,
865 `PROV_STATUS` varchar(20) DEFAULT NULL,
866 `VNF_PARAMS` longtext,
867 `VNF_OUTPUTS` longtext,
868 `REQUEST_BODY` longtext,
869 `RESPONSE_BODY` longtext,
870 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
871 `MODIFY_TIME` datetime DEFAULT NULL,
872 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
873 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
874 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
875 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
876 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
877 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
878 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
879 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
880 `CALLBACK_URL` varchar(200) DEFAULT NULL,
881 `CORRELATOR` varchar(80) DEFAULT NULL,
882 `NETWORK_ID` varchar(45) DEFAULT NULL,
883 `NETWORK_NAME` varchar(80) DEFAULT NULL,
884 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
885 `REQUEST_SCOPE` varchar(45) NOT NULL DEFAULT 'unknown',
886 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
887 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
888 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
889 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
890 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
891 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
892 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
893 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
894 PRIMARY KEY (`REQUEST_ID`),
895 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
896 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
898 CREATE TABLE `archived_infra_requests` (
899 `REQUEST_ID` varchar(45) NOT NULL,
900 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
901 `ACTION` varchar(45) DEFAULT NULL,
902 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
903 `STATUS_MESSAGE` longtext DEFAULT NULL,
904 `PROGRESS` bigint(20) DEFAULT NULL,
905 `START_TIME` datetime DEFAULT NULL,
906 `END_TIME` datetime DEFAULT NULL,
907 `SOURCE` varchar(45) DEFAULT NULL,
908 `VNF_ID` varchar(45) DEFAULT NULL,
909 `VNF_NAME` varchar(80) DEFAULT NULL,
910 `VNF_TYPE` varchar(200) DEFAULT NULL,
911 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
912 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
913 `TENANT_ID` varchar(45) DEFAULT NULL,
914 `PROV_STATUS` varchar(20) DEFAULT NULL,
915 `VNF_PARAMS` longtext,
916 `VNF_OUTPUTS` longtext,
917 `REQUEST_BODY` longtext,
918 `RESPONSE_BODY` longtext,
919 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
920 `MODIFY_TIME` datetime DEFAULT NULL,
921 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
922 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
923 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
924 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
925 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
926 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
927 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
928 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
929 `CALLBACK_URL` varchar(200) DEFAULT NULL,
930 `CORRELATOR` varchar(80) DEFAULT NULL,
931 `NETWORK_ID` varchar(45) DEFAULT NULL,
932 `NETWORK_NAME` varchar(80) DEFAULT NULL,
933 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
934 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
935 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
936 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
937 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
938 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
939 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
940 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
941 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
942 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
943 PRIMARY KEY (`REQUEST_ID`),
944 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d59h` (`CLIENT_REQUEST_ID`)
945 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
947 CREATE TABLE `site_status` (
948 `SITE_NAME` varchar(255) NOT NULL,
949 `STATUS` bit(1) DEFAULT NULL,
950 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
951 PRIMARY KEY (`SITE_NAME`)
952 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
954 CREATE TABLE `watchdog_distributionid_status` (
955 `DISTRIBUTION_ID` varchar(45) NOT NULL,
956 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
957 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
958 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
959 PRIMARY KEY (`DISTRIBUTION_ID`)
960 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
962 CREATE TABLE `watchdog_per_component_distribution_status` (
963 `DISTRIBUTION_ID` varchar(45) NOT NULL,
964 `COMPONENT_NAME` varchar(45) NOT NULL,
965 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
966 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
967 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
968 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
969 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
970 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
972 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
973 `DISTRIBUTION_ID` varchar(45) NOT NULL,
974 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
975 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
976 `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
977 PRIMARY KEY (`DISTRIBUTION_ID`,`SERVICE_MODEL_VERSION_ID`)
978 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
980 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
981 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
982 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
983 `REQUEST_ID` varchar(45) NOT NULL,
984 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
985 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
986 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
987 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
988 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
989 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
990 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
991 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
993 CREATE TABLE `activate_operational_env_per_distributionid_status` (
994 `DISTRIBUTION_ID` varchar(45) NOT NULL,
995 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
996 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
997 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
998 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
999 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1000 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1001 `REQUEST_ID` varchar(45) NOT NULL,
1002 PRIMARY KEY (`DISTRIBUTION_ID`),
1003 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
1004 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
1005 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1007 create table operation_status (
1008 SERVICE_ID varchar(255) not null,
1009 OPERATION_ID varchar(255) not null,
1010 SERVICE_NAME varchar(255),
1011 OPERATION_TYPE varchar(255),
1012 USER_ID varchar(255),
1013 RESULT varchar(255),
1014 OPERATION_CONTENT varchar(255),
1015 PROGRESS varchar(255),
1016 REASON varchar(255),
1017 OPERATE_AT datetime NOT NULL,
1018 FINISHED_AT datetime NOT NULL,
1019 primary key (SERVICE_ID,OPERATION_ID)
1020 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1022 create table resource_operation_status (
1023 SERVICE_ID varchar(255) not null,
1024 OPERATION_ID varchar(255) not null,
1025 RESOURCE_TEMPLATE_UUID varchar(255) not null,
1026 OPER_TYPE varchar(255),
1027 RESOURCE_INSTANCE_ID varchar(255),
1028 JOB_ID varchar(255),
1029 STATUS varchar(255),
1030 PROGRESS varchar(255),
1031 ERROR_CODE varchar(255) ,
1032 STATUS_DESCRIPOTION varchar(255) ,
1033 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
1034 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1036 create table if not exists model_recipe (
1037 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1039 `ACTION` VARCHAR(40),
1040 `SCHEMA_VERSION` VARCHAR(40),
1041 `DESCRIPTION` VARCHAR(40),
1042 `ORCHESTRATION_URI` VARCHAR(20),
1043 `MODEL_PARAM_XSD` VARCHAR(20),
1044 `RECIPE_TIMEOUT` INT(11),
1045 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1047 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
1048 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1050 create table if not exists model (
1051 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1052 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
1053 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
1054 `MODEL_INVARIANT_ID` VARCHAR(40),
1055 `MODEL_NAME` VARCHAR(40),
1056 `MODEL_TYPE` VARCHAR(20),
1057 `MODEL_VERSION` VARCHAR(20),
1058 `MODEL_VERSION_ID` VARCHAR(40),
1059 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1062 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
1063 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1064 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;