2 --------START Catalog DB SCHEMA --------
5 create table `allotted_resource` (
6 `model_uuid` varchar(200) not null,
7 `model_invariant_uuid` varchar(200) not null,
8 `model_version` varchar(20) not null,
9 `model_name` varchar(200) not null,
10 `tosca_node_type` varchar(200) default null,
11 `subcategory` varchar(200) default null,
12 `description` varchar(1200) default null,
13 `creation_timestamp` datetime not null default current_timestamp,
14 primary key (`model_uuid`)
15 ) engine=innodb default charset=latin1;
20 create table `allotted_resource_customization` (
21 `model_customization_uuid` varchar(200) not null,
22 `model_instance_name` varchar(200) not null,
23 `providing_service_model_uuid` varchar(200) default null,
24 `providing_service_model_invariant_uuid` varchar(200) default null,
25 `providing_service_model_name` varchar(200) default null,
26 `target_network_role` varchar(200) default null,
27 `nf_type` varchar(200) default null,
28 `nf_role` varchar(200) default null,
29 `nf_function` varchar(200) default null,
30 `nf_naming_code` varchar(200) default null,
31 `min_instances` int(11) default null,
32 `max_instances` int(11) default null,
33 `ar_model_uuid` varchar(200) not null,
34 `creation_timestamp` datetime not null default current_timestamp,
35 primary key (`model_customization_uuid`),
36 key `fk_allotted_resource_customization__allotted_resource1_idx` (`ar_model_uuid`),
37 constraint `fk_allotted_resource_customization__allotted_resource1` foreign key (`ar_model_uuid`) references `allotted_resource` (`model_uuid`) on delete cascade on update cascade
38 ) engine=innodb default charset=latin1;
43 create table `heat_environment` (
44 `artifact_uuid` varchar(200) not null,
45 `name` varchar(100) not null,
46 `version` varchar(20) not null,
47 `description` varchar(1200) default null,
48 `body` longtext not null,
49 `artifact_checksum` varchar(200) not null default 'manual record',
50 `creation_timestamp` datetime not null default current_timestamp,
51 primary key (`artifact_uuid`)
52 ) engine=innodb default charset=latin1;
56 create table `heat_files` (
57 `artifact_uuid` varchar(200) not null,
58 `name` varchar(200) not null,
59 `version` varchar(20) not null,
60 `description` varchar(1200) default null,
61 `body` longtext not null,
62 `artifact_checksum` varchar(200) not null default 'manual record',
63 `creation_timestamp` datetime not null default current_timestamp,
64 primary key (`artifact_uuid`)
65 ) engine=innodb default charset=latin1;
70 create table `heat_template` (
71 `artifact_uuid` varchar(200) not null,
72 `name` varchar(200) not null,
73 `version` varchar(20) not null,
74 `description` varchar(1200) default null,
75 `body` longtext not null,
76 `timeout_minutes` int(11) default null,
77 `artifact_checksum` varchar(200) not null default 'manual record',
78 `creation_timestamp` datetime not null default current_timestamp,
79 primary key (`artifact_uuid`)
80 ) engine=innodb default charset=latin1;
84 create table `heat_nested_template` (
85 `parent_heat_template_uuid` varchar(200) not null,
86 `child_heat_template_uuid` varchar(200) not null,
87 `provider_resource_file` varchar(100) default null,
88 primary key (`parent_heat_template_uuid`,`child_heat_template_uuid`),
89 key `fk_heat_nested_template__heat_template2_idx` (`child_heat_template_uuid`),
90 constraint `fk_heat_nested_template__child_heat_temp_uuid__heat_template1` foreign key (`child_heat_template_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade,
91 constraint `fk_heat_nested_template__parent_heat_temp_uuid__heat_template1` foreign key (`parent_heat_template_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
92 ) engine=innodb default charset=latin1;
97 create table `heat_template_params` (
98 `heat_template_artifact_uuid` varchar(200) not null,
99 `param_name` varchar(100) not null,
100 `is_required` bit(1) not null,
101 `param_type` varchar(20) default null,
102 `param_alias` varchar(45) default null,
103 primary key (`heat_template_artifact_uuid`,`param_name`),
104 constraint `fk_heat_template_params__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
105 ) engine=innodb default charset=latin1;
109 create table `network_recipe` (
110 `id` int(11) not null auto_increment,
111 `model_name` varchar(20) not null,
112 `action` varchar(50) not null,
113 `description` varchar(1200) default null,
114 `orchestration_uri` varchar(256) not null,
115 `network_param_xsd` varchar(2048) default null,
116 `recipe_timeout` int(11) default null,
117 `service_type` varchar(45) default null,
118 `creation_timestamp` datetime not null default current_timestamp,
119 `version_str` varchar(20) not null,
121 unique key `uk_rl4f296i0p8lyokxveaiwkayi` (`model_name`,`action`,`version_str`)
122 ) engine=innodb auto_increment=178 default charset=latin1;
127 create table `temp_network_heat_template_lookup` (
128 `network_resource_model_name` varchar(200) not null,
129 `heat_template_artifact_uuid` varchar(200) not null,
130 `aic_version_min` varchar(20) not null,
131 `aic_version_max` varchar(20) default null,
132 primary key (`network_resource_model_name`),
133 key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
134 constraint `fk_temp_network_heat_template_lookup__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade
135 ) engine=innodb default charset=latin1;
139 create table `network_resource` (
140 `model_uuid` varchar(200) not null,
141 `model_name` varchar(200) not null,
142 `model_invariant_uuid` varchar(200) default null,
143 `description` varchar(1200) default null,
144 `heat_template_artifact_uuid` varchar(200) not null,
145 `neutron_network_type` varchar(20) default null,
146 `model_version` varchar(20) default null,
147 `tosca_node_type` varchar(200) default null,
148 `aic_version_min` varchar(20) not null,
149 `aic_version_max` varchar(20) default null,
150 `orchestration_mode` varchar(20) default 'heat',
151 `resource_category` varchar(20) default null,
152 `resource_sub_category` varchar(20) default null,
153 `creation_timestamp` datetime not null default current_timestamp,
154 primary key (`model_uuid`),
155 key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
156 key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
157 constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade,
158 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
159 ) engine=innodb default charset=latin1;
165 create table `network_resource_customization` (
166 `model_customization_uuid` varchar(200) not null,
167 `model_instance_name` varchar(200) not null,
168 `network_technology` varchar(45) default null,
169 `network_type` varchar(45) default null,
170 `network_role` varchar(200) default null,
171 `network_scope` varchar(45) default null,
172 `creation_timestamp` datetime not null default current_timestamp,
173 `network_resource_model_uuid` varchar(200) not null,
174 primary key (`model_customization_uuid`),
175 key `fk_network_resource_customization__network_resource1_idx` (`network_resource_model_uuid`),
176 constraint `fk_network_resource_customization__network_resource1` foreign key (`network_resource_model_uuid`) references `network_resource` (`model_uuid`) on delete cascade on update cascade
177 ) engine=innodb default charset=latin1;
183 create table `tosca_csar` (
184 `artifact_uuid` varchar(200) not null,
185 `name` varchar(200) not null,
186 `version` varchar(20) not null,
187 `description` varchar(1200) default null,
188 `artifact_checksum` varchar(200) not null,
189 `url` varchar(200) not null,
190 `creation_timestamp` datetime not null default current_timestamp,
191 primary key (`artifact_uuid`)
192 ) engine=innodb default charset=latin1;
197 create table `service` (
198 `model_uuid` varchar(200) not null,
199 `model_name` varchar(200) not null,
200 `model_invariant_uuid` varchar(200) not null,
201 `model_version` varchar(20) not null,
202 `description` varchar(1200) default null,
203 `creation_timestamp` datetime not null default current_timestamp,
204 `tosca_csar_artifact_uuid` varchar(200) default null,
205 `service_type` varchar(200) default null,
206 `service_role` varchar(200) default null,
207 `environment_context` varchar(200) default null,
208 `workload_context` varchar(200) default null,
209 `service_category` varchar(200) default null,
210 primary key (`model_uuid`),
211 key `fk_service__tosca_csar1_idx` (`tosca_csar_artifact_uuid`),
212 constraint `fk_service__tosca_csar1` foreign key (`tosca_csar_artifact_uuid`) references `tosca_csar` (`artifact_uuid`) on delete cascade on update cascade
213 ) engine=innodb default charset=latin1;
217 create table `service_recipe` (
218 `id` int(11) not null auto_increment,
219 `action` varchar(50) not null,
220 `version_str` varchar(20) default null,
221 `description` varchar(1200) default null,
222 `orchestration_uri` varchar(256) not null,
223 `service_param_xsd` varchar(2048) default null,
224 `recipe_timeout` int(11) default null,
225 `service_timeout_interim` int(11) default null,
226 `creation_timestamp` datetime not null default current_timestamp,
227 `service_model_uuid` varchar(200) not null,
229 unique key `uk_7fav5dkux2v8g9d2i5ymudlgc` (`service_model_uuid`,`action`),
230 key `fk_service_recipe__service1_idx` (`service_model_uuid`),
231 constraint `fk_service_recipe__service1` foreign key (`service_model_uuid`) references `service` (`model_uuid`) on delete cascade on update cascade
232 ) engine=innodb auto_increment=86 default charset=latin1;
236 create table `vnf_resource` (
237 `orchestration_mode` varchar(20) not null default 'heat',
238 `description` varchar(1200) default null,
239 `creation_timestamp` datetime not null default current_timestamp,
240 `model_uuid` varchar(200) not null,
241 `aic_version_min` varchar(20) default null,
242 `aic_version_max` varchar(20) default null,
243 `model_invariant_uuid` varchar(200) default null,
244 `model_version` varchar(20) not null,
245 `model_name` varchar(200) default null,
246 `tosca_node_type` varchar(200) default null,
247 `resource_category` varchar(200) default null,
248 `resource_sub_category` varchar(200) default null,
249 `heat_template_artifact_uuid` varchar(200) default null,
250 primary key (`model_uuid`),
251 key `fk_vnf_resource__heat_template1` (`heat_template_artifact_uuid`),
252 constraint `fk_vnf_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
253 ) engine=innodb default charset=latin1;
258 create table `vf_module` (
259 `model_uuid` varchar(200) not null,
260 `model_invariant_uuid` varchar(200) default null,
261 `model_version` varchar(20) not null,
262 `model_name` varchar(200) not null,
263 `description` varchar(1200) default null,
264 `is_base` int(11) not null,
265 `heat_template_artifact_uuid` varchar(200) default null,
266 `vol_heat_template_artifact_uuid` varchar(200) default null,
267 `creation_timestamp` datetime not null default current_timestamp,
268 `vnf_resource_model_uuid` varchar(200) not null,
269 primary key (`model_uuid`,`vnf_resource_model_uuid`),
270 key `fk_vf_module__vnf_resource1_idx` (`vnf_resource_model_uuid`),
271 key `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`heat_template_artifact_uuid`),
272 key `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`vol_heat_template_artifact_uuid`),
273 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,
274 constraint `fk_vf_module__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade,
275 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
276 ) engine=innodb default charset=latin1;
280 /*!40101 set @saved_cs_client = @@character_set_client */;
281 /*!40101 set character_set_client = utf8 */;
282 create table `vf_module_customization` (
283 `model_customization_uuid` varchar(200) not null,
284 `label` varchar(200) default null,
285 `initial_count` int(11) default '0',
286 `min_instances` int(11) default '0',
287 `max_instances` int(11) default null,
288 `availability_zone_count` int(11) default null,
289 `heat_environment_artifact_uuid` varchar(200) default null,
290 `vol_environment_artifact_uuid` varchar(200) default null,
291 `creation_timestamp` datetime not null default current_timestamp,
292 `vf_module_model_uuid` varchar(200) not null,
293 primary key (`model_customization_uuid`),
294 key `fk_vf_module_customization__vf_module1_idx` (`vf_module_model_uuid`),
295 key `fk_vf_module_customization__heat_env__heat_environment1_idx` (`heat_environment_artifact_uuid`),
296 key `fk_vf_module_customization__vol_env__heat_environment2_idx` (`vol_environment_artifact_uuid`),
297 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,
298 constraint `fk_vf_module_customization__vf_module1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade,
299 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
300 ) engine=innodb default charset=latin1;
301 /*!40101 set character_set_client = @saved_cs_client */;
304 -- table structure for table `vf_module_to_heat_files`
308 /*!40101 set @saved_cs_client = @@character_set_client */;
309 /*!40101 set character_set_client = utf8 */;
310 create table `vf_module_to_heat_files` (
311 `vf_module_model_uuid` varchar(200) not null,
312 `heat_files_artifact_uuid` varchar(200) not null,
313 primary key (`vf_module_model_uuid`,`heat_files_artifact_uuid`),
314 key `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`heat_files_artifact_uuid`),
315 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,
316 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
317 ) engine=innodb default charset=latin1 comment='il fait ce qu''il dit';
318 /*!40101 set character_set_client = @saved_cs_client */;
321 -- table structure for table `vnf_components`
325 /*!40101 set @saved_cs_client = @@character_set_client */;
326 /*!40101 set character_set_client = utf8 */;
327 create table `vnf_components` (
328 `vnf_id` int(11) not null,
329 `component_type` varchar(20) not null,
330 `heat_template_id` int(11) default null,
331 `heat_environment_id` int(11) default null,
332 `creation_timestamp` datetime not null default current_timestamp,
333 primary key (`vnf_id`,`component_type`)
334 ) engine=innodb default charset=latin1;
335 /*!40101 set character_set_client = @saved_cs_client */;
338 -- table structure for table `vnf_components_recipe`
343 create table `vnf_components_recipe` (
344 `id` int(11) not null auto_increment,
345 `vnf_type` varchar(200) default null,
346 `vnf_component_type` varchar(45) not null,
347 `action` varchar(50) not null,
348 `service_type` varchar(45) default null,
349 `version` varchar(20) not null,
350 `description` varchar(1200) default null,
351 `orchestration_uri` varchar(256) not null,
352 `vnf_component_param_xsd` varchar(2048) default null,
353 `recipe_timeout` int(11) default null,
354 `creation_timestamp` datetime default current_timestamp,
355 `vf_module_model_uuid` varchar(200) default null,
357 unique key `uk_4dpdwddaaclhc11wxsb7h59ma` (`vf_module_model_uuid`,`vnf_component_type`,`action`,`version`)
358 ) engine=innodb auto_increment=26 default charset=latin1;
363 create table `vnf_recipe` (
364 `id` int(11) not null auto_increment,
365 `vnf_type` varchar(200) default null,
366 `action` varchar(50) not null,
367 `service_type` varchar(45) default null,
368 `version_str` varchar(20) not null,
369 `description` varchar(1200) default null,
370 `orchestration_uri` varchar(256) not null,
371 `vnf_param_xsd` varchar(2048) default null,
372 `recipe_timeout` int(11) default null,
373 `creation_timestamp` datetime default current_timestamp,
374 `vf_module_id` varchar(100) default null,
376 unique key `uk_f3tvqau498vrifq3cr8qnigkr` (`vf_module_id`,`action`,`version_str`)
377 ) engine=innodb auto_increment=10006 default charset=latin1;
386 create table `vnf_resource_customization` (
387 `model_customization_uuid` varchar(200) not null,
388 `model_instance_name` varchar(200) not null,
389 `min_instances` int(11) default null,
390 `max_instances` int(11) default null,
391 `availability_zone_max_count` int(11) default null,
392 `nf_type` varchar(200) default null,
393 `nf_role` varchar(200) default null,
394 `nf_function` varchar(200) default null,
395 `nf_naming_code` varchar(200) default null,
396 `creation_timestamp` datetime not null default current_timestamp,
397 `vnf_resource_model_uuid` varchar(200) not null,
398 `multi_stage_design` varchar(20) default null,
399 primary key (`model_customization_uuid`),
400 key `fk_vnf_resource_customization__vnf_resource1_idx` (`vnf_resource_model_uuid`),
401 constraint `fk_vnf_resource_customization__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade
402 ) engine=innodb default charset=latin1;
407 create table `vnf_res_custom_to_vf_module_custom` (
408 `vnf_resource_cust_model_customization_uuid` varchar(200) not null,
409 `vf_module_cust_model_customization_uuid` varchar(200) not null,
410 `creation_timestamp` datetime not null default current_timestamp,
411 primary key (`vnf_resource_cust_model_customization_uuid`,`vf_module_cust_model_customization_uuid`),
412 key `fk_vnf_res_custom_to_vf_module_custom__vf_module_customizat_idx` (`vf_module_cust_model_customization_uuid`),
413 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,
414 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
415 ) engine=innodb default charset=latin1;
418 create table if not exists external_service_to_internal_model_mapping (
419 id int(11) not null auto_increment,
420 service_name varchar(200) not null,
421 product_flavor varchar(200) null,
422 subscription_service_type varchar(200) not null,
423 service_model_uuid varchar(200) not null,
425 unique index uk_external_service_to_internal_model_mapping
426 (service_name asc, product_flavor asc, service_model_uuid asc));
428 create table if not exists `collection_resource` (
429 model_uuid varchar(200) not null,
430 model_name varchar(200) not null,
431 model_invariant_uuid varchar(200) not null,
432 model_version varchar(20) not null,
433 tosca_node_type varchar(200) not null,
434 description varchar(200),
435 creation_timestamp datetime not null default current_timestamp,
436 primary key (`model_uuid`)
437 )engine=innodb default charset=latin1;
439 create table if not exists `collection_resource_customization` (
440 model_customization_uuid varchar(200) not null,
441 model_instance_name varchar(200) not null,
442 role varchar(200) NULL,
443 object_type varchar(200) not null,
444 function varchar(200) NULL,
445 collection_resource_type varchar(200) NULL,
446 creation_timestamp datetime not null default current_timestamp,
447 cr_model_uuid varchar(200) not null,
448 primary key (`model_customization_uuid`)
449 )engine=innodb default charset=latin1;
451 create table if not exists `instance_group` (
452 model_uuid varchar(200) not null,
453 model_name varchar(200) not null,
454 model_invariant_uuid varchar(200) not null,
455 model_version varchar(20) not null,
456 tosca_node_type varchar(200) NULL,
457 role varchar(200) not null,
458 object_type varchar(200) not null,
459 creation_timestamp datetime not null default current_timestamp,
460 cr_model_uuid varchar(200) NULL,
461 instance_group_type varchar(200) not null,
462 primary key (`model_uuid`)
463 )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;
625 create table ar_recipe (
626 ID INT(11) not null auto_increment,
627 MODEL_NAME VARCHAR(200) NOT NULL,
628 `ACTION` VARCHAR(200) NOT NULL,
629 VERSION_STR VARCHAR(200) NOT NULL,
630 SERVICE_TYPE VARCHAR(200),
631 DESCRIPTION VARCHAR(200),
632 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
633 AR_PARAM_XSD VARCHAR(200),
634 RECIPE_TIMEOUT INT(10),
635 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
637 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
638 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
640 alter table collection_resource_customization
641 add foreign key ( cr_model_uuid)
642 references collection_resource(model_uuid)
645 alter table vnf_resource_customization
647 instance_group_model_uuid varchar(200);
649 alter table network_resource_customization
651 instance_group_model_uuid varchar(200);
654 alter table network_resource_customization
655 add foreign key ( instance_group_model_uuid)
656 references instance_group(model_uuid)
659 alter table collection_resource_customization_to_service
660 add foreign key (service_model_uuid)
661 references service(model_uuid)
664 alter table allotted_resource_customization_to_service
665 add foreign key (service_model_uuid)
666 references service(model_uuid)
670 alter table vnf_resource_customization_to_service
671 add foreign key (service_model_uuid)
672 references service(model_uuid)
676 alter table network_resource_customization_to_service
677 add foreign key (service_model_uuid)
678 references service(model_uuid)
682 alter table network_resource_customization_to_service
683 add foreign key (resource_model_customization_uuid)
684 references network_resource_customization(model_customization_uuid)
687 alter table vnf_resource_customization_to_service
688 add foreign key (resource_model_customization_uuid)
689 references vnf_resource_customization(model_customization_uuid)
692 alter table allotted_resource_customization_to_service
693 add foreign key (resource_model_customization_uuid)
694 references allotted_resource_customization(model_customization_uuid)
697 alter table collection_resource_customization_to_service
698 add foreign key (resource_model_customization_uuid)
699 references collection_resource_customization(model_customization_uuid)
703 create table if not exists `collection_network_resource_customization` (
704 `model_customization_uuid` varchar(200) not null,
705 `model_instance_name` varchar(200) not null,
706 `network_technology` varchar(45) null,
707 `network_type` varchar(45) null,
708 `network_role` varchar(200) null,
709 `network_scope` varchar(45) null,
710 `creation_timestamp` datetime not null default current_timestamp,
711 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
712 `crc_model_customization_uuid` varchar(200) not null, primary key
713 (`model_customization_uuid`, `crc_model_customization_uuid`),
714 index `fk_collection_net_resource_customization__network_resource1_idx`
715 (`network_resource_model_uuid` asc), index
716 `fk_collection_net_resource_customization__instance_group1_idx`
717 (`instance_group_model_uuid` asc), index
718 `fk_col_net_res_customization__collection_res_customization_idx`
719 (`crc_model_customization_uuid` asc), constraint
720 `fk_collection_net_resource_customization__network_resource10` foreign
721 key (`network_resource_model_uuid`) references
722 `network_resource` (`model_uuid`) on delete cascade on
723 update cascade, constraint
724 `fk_collection_net_resource_customization__instance_group10` foreign key
725 (`instance_group_model_uuid`) references `instance_group`
726 (`model_uuid`) on delete cascade on update cascade, constraint
727 `fk_collection_network_resource_customization__collection_reso1` foreign
728 key (`crc_model_customization_uuid`) references
729 `collection_resource_customization`
730 (`model_customization_uuid`) on delete cascade on update cascade) engine
731 = innodb default character set = latin1;
733 CREATE TABLE IF NOT EXISTS `rainy_day_handler_macro` (
734 `id` INT(11) NOT NULL AUTO_INCREMENT,
735 `FLOW_NAME` VARCHAR(200) NOT NULL,
736 `SERVICE_TYPE` VARCHAR(200) NOT NULL,
737 `VNF_TYPE` VARCHAR(200) NOT NULL,
738 `ERROR_CODE` VARCHAR(200) NOT NULL,
739 `WORK_STEP` VARCHAR(200) NOT NULL,
740 `POLICY` VARCHAR(200) NOT NULL,
743 DEFAULT CHARACTER SET = latin1;
745 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
746 `id` INT(11) NOT NULL AUTO_INCREMENT,
747 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
748 `ACTION` VARCHAR(200) NOT NULL,
749 `MACRO_ACTION` VARCHAR(200) NOT NULL,
750 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
751 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 0,
752 `MIN_API_VERSION` DOUBLE NOT NULL,
753 `MAX_API_VERSION` DOUBLE NULL,
755 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC))
757 DEFAULT CHARACTER SET = latin1;
759 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
760 `id` INT(11) NOT NULL AUTO_INCREMENT,
761 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
762 `SEQ_NO` INT(11) NOT NULL,
763 `FLOW_NAME` VARCHAR(200) NOT NULL,
764 `FLOW_VERSION` DOUBLE NOT NULL,
765 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
767 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
768 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
769 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
770 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
771 ON DELETE CASCADE ON UPDATE CASCADE)
772 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
774 --------START Request DB SCHEMA --------
775 CREATE DATABASE requestdb;
779 CREATE TABLE `active_requests` (
780 `REQUEST_ID` varchar(45) NOT NULL,
781 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
782 `SERVICE_INSTANCE_ID` varchar(50) NOT NULL,
783 `SUBSCRIBER_NAME` varchar(200) DEFAULT NULL,
784 `REQUEST_URI` varchar(255) DEFAULT NULL,
785 `SERVICE_TYPE` varchar(65) NOT NULL,
786 `REQUEST_ACTION` varchar(45) NOT NULL,
787 `NOTIFICATION_URL` varchar(255) DEFAULT NULL,
788 `REQUEST_ID_IN_PROGRESS` varchar(45) DEFAULT NULL,
789 `START_TIME` datetime DEFAULT NULL,
790 `MODIFY_TIME` datetime DEFAULT NULL,
791 `COMPLETION_TIME` datetime DEFAULT NULL,
792 `RESPONSE_CODE` varchar(20) DEFAULT NULL,
793 `RESPONSE_BODY` longtext,
794 `STATUS` varchar(25) DEFAULT NULL,
795 `SERVICE_REQUEST_TIMEOUT` datetime DEFAULT NULL,
796 `FINAL_ERROR_CODE` varchar(20) DEFAULT NULL,
797 `FINAL_ERROR_MESSAGE` varchar(2000) DEFAULT NULL,
798 `ORDER_NUMBER` varchar(45) DEFAULT NULL,
799 `SOURCE` varchar(20) DEFAULT NULL,
800 `RESPONSE_STATUS` varchar(25) DEFAULT NULL,
801 `ORDER_VERSION` varchar(20) DEFAULT NULL,
802 `LAST_MODIFIED_BY` varchar(20) DEFAULT NULL,
803 `MOCARS_TICKET_NUM` varchar(200) DEFAULT NULL,
804 `REQUEST_BODY` longtext,
805 `REQUEST_SUB_ACTION` varchar(45) DEFAULT NULL,
806 `SDNC_CALLBACK_BPEL_URL` varchar(255) DEFAULT NULL,
807 `FEATURE_TYPE` varchar(255) DEFAULT NULL,
808 `FEATURE_INSTANCE_ID` varchar(255) DEFAULT NULL,
809 `REQUEST_TYPE` varchar(255) DEFAULT NULL,
810 `INTERIM_COMPLETION_TIME` datetime DEFAULT NULL,
811 `INTERIM_STAGE_COMPLETION` int(11) DEFAULT NULL,
812 `SERVICE_NAME_VERSION_ID` varchar(50) DEFAULT NULL,
813 `GLOBAL_SUBSCRIBER_ID` varchar(255) DEFAULT NULL,
814 `SERVICE_ID` varchar(50) DEFAULT NULL,
815 `SERVICE_VERSION` varchar(10) DEFAULT NULL,
816 `CORRELATOR` varchar(50) DEFAULT NULL,
817 PRIMARY KEY (`REQUEST_ID`),
818 UNIQUE KEY `UK_f0hdk7xbw5mb2trnxx0fvlh3x` (`CLIENT_REQUEST_ID`)
819 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
821 CREATE TABLE `infra_active_requests` (
822 `REQUEST_ID` varchar(45) NOT NULL,
823 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
824 `ACTION` varchar(45) DEFAULT NULL,
825 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
826 `STATUS_MESSAGE` longtext DEFAULT NULL,
827 `PROGRESS` bigint(20) DEFAULT NULL,
828 `START_TIME` datetime DEFAULT NULL,
829 `END_TIME` datetime DEFAULT NULL,
830 `SOURCE` varchar(45) DEFAULT NULL,
831 `VNF_ID` varchar(45) DEFAULT NULL,
832 `VNF_NAME` varchar(80) DEFAULT NULL,
833 `VNF_TYPE` varchar(200) DEFAULT NULL,
834 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
835 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
836 `TENANT_ID` varchar(45) DEFAULT NULL,
837 `PROV_STATUS` varchar(20) DEFAULT NULL,
838 `VNF_PARAMS` longtext,
839 `VNF_OUTPUTS` longtext,
840 `REQUEST_BODY` longtext,
841 `RESPONSE_BODY` longtext,
842 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
843 `MODIFY_TIME` datetime DEFAULT NULL,
844 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
845 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
846 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
847 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
848 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
849 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
850 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
851 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
852 `CALLBACK_URL` varchar(200) DEFAULT NULL,
853 `CORRELATOR` varchar(80) DEFAULT NULL,
854 `NETWORK_ID` varchar(45) DEFAULT NULL,
855 `NETWORK_NAME` varchar(80) DEFAULT NULL,
856 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
857 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
858 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
859 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
860 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
861 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
862 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
863 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
864 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
865 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
866 PRIMARY KEY (`REQUEST_ID`),
867 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
868 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
870 CREATE TABLE `archived_infra_requests` (
871 `REQUEST_ID` varchar(45) NOT NULL,
872 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
873 `ACTION` varchar(45) DEFAULT NULL,
874 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
875 `STATUS_MESSAGE` longtext DEFAULT NULL,
876 `PROGRESS` bigint(20) DEFAULT NULL,
877 `START_TIME` datetime DEFAULT NULL,
878 `END_TIME` datetime DEFAULT NULL,
879 `SOURCE` varchar(45) DEFAULT NULL,
880 `VNF_ID` varchar(45) DEFAULT NULL,
881 `VNF_NAME` varchar(80) DEFAULT NULL,
882 `VNF_TYPE` varchar(200) DEFAULT NULL,
883 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
884 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
885 `TENANT_ID` varchar(45) DEFAULT NULL,
886 `PROV_STATUS` varchar(20) DEFAULT NULL,
887 `VNF_PARAMS` longtext,
888 `VNF_OUTPUTS` longtext,
889 `REQUEST_BODY` longtext,
890 `RESPONSE_BODY` longtext,
891 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
892 `MODIFY_TIME` datetime DEFAULT NULL,
893 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
894 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
895 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
896 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
897 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
898 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
899 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
900 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
901 `CALLBACK_URL` varchar(200) DEFAULT NULL,
902 `CORRELATOR` varchar(80) DEFAULT NULL,
903 `NETWORK_ID` varchar(45) DEFAULT NULL,
904 `NETWORK_NAME` varchar(80) DEFAULT NULL,
905 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
906 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
907 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
908 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
909 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
910 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
911 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
912 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
913 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
914 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
915 PRIMARY KEY (`REQUEST_ID`),
916 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d72h` (`CLIENT_REQUEST_ID`)
917 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
919 CREATE TABLE `site_status` (
920 `SITE_NAME` varchar(255) NOT NULL,
921 `STATUS` bit(1) DEFAULT NULL,
922 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
923 PRIMARY KEY (`SITE_NAME`)
924 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
926 CREATE TABLE `watchdog_distributionid_status` (
927 `DISTRIBUTION_ID` varchar(45) NOT NULL,
928 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
929 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
930 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
931 PRIMARY KEY (`DISTRIBUTION_ID`)
932 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
934 CREATE TABLE `watchdog_per_component_distribution_status` (
935 `DISTRIBUTION_ID` varchar(45) NOT NULL,
936 `COMPONENT_NAME` varchar(45) NOT NULL,
937 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
938 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
939 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
940 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
941 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
942 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
944 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
945 `DISTRIBUTION_ID` varchar(45) NOT NULL,
946 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
947 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
948 `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
949 PRIMARY KEY (`DISTRIBUTION_ID`,`SERVICE_MODEL_VERSION_ID`)
950 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
952 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
953 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
954 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
955 `REQUEST_ID` varchar(45) NOT NULL,
956 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
957 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
958 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
959 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
960 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
961 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
962 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
963 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
965 CREATE TABLE `activate_operational_env_per_distributionid_status` (
966 `DISTRIBUTION_ID` varchar(45) NOT NULL,
967 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
968 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
969 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
970 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
971 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
972 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
973 `REQUEST_ID` varchar(45) NOT NULL,
974 PRIMARY KEY (`DISTRIBUTION_ID`),
975 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
976 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
977 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
979 create table operation_status (
980 SERVICE_ID varchar(255) not null,
981 OPERATION_ID varchar(255) not null,
982 SERVICE_NAME varchar(255),
983 OPERATION_TYPE varchar(255),
984 USER_ID varchar(255),
986 OPERATION_CONTENT varchar(255),
987 PROGRESS varchar(255),
989 OPERATE_AT datetime NOT NULL,
990 FINISHED_AT datetime NOT NULL,
991 primary key (SERVICE_ID,OPERATION_ID)
992 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
994 create table resource_operation_status (
995 SERVICE_ID varchar(255) not null,
996 OPERATION_ID varchar(255) not null,
997 RESOURCE_TEMPLATE_UUID varchar(255) not null,
998 OPER_TYPE varchar(255),
999 RESOURCE_INSTANCE_ID varchar(255),
1000 JOB_ID varchar(255),
1001 STATUS varchar(255),
1002 PROGRESS varchar(255),
1003 ERROR_CODE varchar(255) ,
1004 STATUS_DESCRIPOTION varchar(255) ,
1005 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
1006 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1008 create table if not exists model_recipe (
1009 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1011 `ACTION` VARCHAR(40),
1012 `SCHEMA_VERSION` VARCHAR(40),
1013 `DESCRIPTION` VARCHAR(40),
1014 `ORCHESTRATION_URI` VARCHAR(20),
1015 `MODEL_PARAM_XSD` VARCHAR(20),
1016 `RECIPE_TIMEOUT` INT(11),
1017 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1019 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
1020 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1022 create table if not exists model (
1023 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1024 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
1025 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
1026 `MODEL_INVARIANT_ID` VARCHAR(40),
1027 `MODEL_NAME` VARCHAR(40),
1028 `MODEL_TYPE` VARCHAR(20),
1029 `MODEL_VERSION` VARCHAR(20),
1030 `MODEL_VERSION_ID` VARCHAR(40),
1031 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1034 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
1035 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1036 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1038 ALTER TABLE `catalogdb`.`vnf_recipe`
1039 CHANGE COLUMN `VNF_TYPE` `NF_ROLE` VARCHAR(200) NULL DEFAULT NULL ;