3 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
4 `id` INT(11) NOT NULL AUTO_INCREMENT,
5 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
6 `MACRO_ACTION` VARCHAR(200) NOT NULL,
7 `ACTION` VARCHAR(200) NOT NULL,
8 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
9 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 0,
10 `MIN_API_VERSION` DOUBLE NOT NULL,
11 `MAX_API_VERSION` DOUBLE NULL,
13 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC, `MACRO_ACTION` ASC))
15 DEFAULT CHARACTER SET = latin1;
17 CREATE TABLE IF NOT EXISTS building_block_detail (
18 id INT(11) AUTO_INCREMENT,
19 BUILDING_BLOCK_NAME VARCHAR(200) NOT NULL,
20 RESOURCE_TYPE VARCHAR(25) NOT NULL,
21 TARGET_ACTION VARCHAR(25) NOT NULL,
23 UNIQUE INDEX `UK_building_block_name`(`BUILDING_BLOCK_NAME`))
25 DEFAULT CHARACTER SET = latin1;
27 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
28 `id` INT(11) NOT NULL AUTO_INCREMENT,
29 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
30 `SEQ_NO` INT(11) NOT NULL,
31 `FLOW_NAME` VARCHAR(200) NOT NULL,
32 `FLOW_VERSION` DOUBLE NOT NULL,
33 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
35 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
36 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
37 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
38 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
39 ON DELETE CASCADE ON UPDATE CASCADE
41 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
43 create table `allotted_resource` (
44 `model_uuid` varchar(200) not null,
45 `model_invariant_uuid` varchar(200) not null,
46 `model_version` varchar(20) not null,
47 `model_name` varchar(200) not null,
48 `tosca_node_type` varchar(200) default null,
49 `subcategory` varchar(200) default null,
50 `description` varchar(1200) default null,
51 `creation_timestamp` datetime not null default current_timestamp,
52 primary key (`model_uuid`)
53 ) engine=innodb default charset=latin1;
58 create table `allotted_resource_customization` (
59 `model_customization_uuid` varchar(200) not null,
60 `model_instance_name` varchar(200) not null,
61 `providing_service_model_uuid` varchar(200) default null,
62 `providing_service_model_invariant_uuid` varchar(200) default null,
63 `providing_service_model_name` varchar(200) default null,
64 `target_network_role` varchar(200) default null,
65 `nf_type` varchar(200) default null,
66 `nf_role` varchar(200) default null,
67 `nf_function` varchar(200) default null,
68 `nf_naming_code` varchar(200) default null,
69 `min_instances` int(11) default null,
70 `max_instances` int(11) default null,
71 `ar_model_uuid` varchar(200) not null,
72 `creation_timestamp` datetime not null default current_timestamp,
73 primary key (`model_customization_uuid`),
74 key `fk_allotted_resource_customization__allotted_resource1_idx` (`ar_model_uuid`),
75 constraint `fk_allotted_resource_customization__allotted_resource1` foreign key (`ar_model_uuid`) references `allotted_resource` (`model_uuid`) on delete cascade on update cascade
76 ) engine=innodb default charset=latin1;
81 create table `heat_environment` (
82 `artifact_uuid` varchar(200) not null,
83 `name` varchar(100) not null,
84 `version` varchar(20) not null,
85 `description` varchar(1200) default null,
86 `body` longtext not null,
87 `artifact_checksum` varchar(200) not null default 'manual record',
88 `creation_timestamp` datetime not null default current_timestamp,
89 primary key (`artifact_uuid`)
90 ) engine=innodb default charset=latin1;
94 create table `heat_files` (
95 `artifact_uuid` varchar(200) not null,
96 `name` varchar(200) not null,
97 `version` varchar(20) not null,
98 `description` varchar(1200) default null,
99 `body` longtext not null,
100 `artifact_checksum` varchar(200) not null default 'manual record',
101 `creation_timestamp` datetime not null default current_timestamp,
102 primary key (`artifact_uuid`)
103 ) engine=innodb default charset=latin1;
108 create table `heat_template` (
109 `artifact_uuid` varchar(200) not null,
110 `name` varchar(200) not null,
111 `version` varchar(20) not null,
112 `description` varchar(1200) default null,
113 `body` longtext not null,
114 `timeout_minutes` int(11) default null,
115 `artifact_checksum` varchar(200) not null default 'manual record',
116 `creation_timestamp` datetime not null default current_timestamp,
117 primary key (`artifact_uuid`)
118 ) engine=innodb default charset=latin1;
122 create table `heat_nested_template` (
123 `parent_heat_template_uuid` varchar(200) not null,
124 `child_heat_template_uuid` varchar(200) not null,
125 `provider_resource_file` varchar(100) default null,
126 primary key (`parent_heat_template_uuid`,`child_heat_template_uuid`),
127 key `fk_heat_nested_template__heat_template2_idx` (`child_heat_template_uuid`),
128 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,
129 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
130 ) engine=innodb default charset=latin1;
135 create table `heat_template_params` (
136 `heat_template_artifact_uuid` varchar(200) not null,
137 `param_name` varchar(100) not null,
138 `is_required` bit(1) not null,
139 `param_type` varchar(20) default null,
140 `param_alias` varchar(45) default null,
141 primary key (`heat_template_artifact_uuid`,`param_name`),
142 constraint `fk_heat_template_params__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
143 ) engine=innodb default charset=latin1;
147 create table `network_recipe` (
148 `id` int(11) not null auto_increment,
149 `model_name` varchar(20) not null,
150 `action` varchar(50) not null,
151 `description` varchar(1200) default null,
152 `orchestration_uri` varchar(256) not null,
153 `network_param_xsd` varchar(2048) default null,
154 `recipe_timeout` int(11) default null,
155 `service_type` varchar(45) default null,
156 `creation_timestamp` datetime not null default current_timestamp,
157 `version_str` varchar(20) not null,
159 unique key `uk_rl4f296i0p8lyokxveaiwkayi` (`model_name`,`action`,`version_str`)
160 ) engine=innodb auto_increment=178 default charset=latin1;
165 create table `temp_network_heat_template_lookup` (
166 `network_resource_model_name` varchar(200) not null,
167 `heat_template_artifact_uuid` varchar(200) not null,
168 `aic_version_min` varchar(20) not null,
169 `aic_version_max` varchar(20) default null,
170 primary key (`network_resource_model_name`),
171 key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
172 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
173 ) engine=innodb default charset=latin1;
177 create table `network_resource` (
178 `model_uuid` varchar(200) not null,
179 `model_name` varchar(200) not null,
180 `model_invariant_uuid` varchar(200) default null,
181 `description` varchar(1200) default null,
182 `heat_template_artifact_uuid` varchar(200) not null,
183 `neutron_network_type` varchar(20) default null,
184 `model_version` varchar(20) default null,
185 `tosca_node_type` varchar(200) default null,
186 `aic_version_min` varchar(20) not null,
187 `aic_version_max` varchar(20) default null,
188 `orchestration_mode` varchar(20) default 'heat',
189 `resource_category` varchar(20) default null,
190 `resource_sub_category` varchar(20) default null,
191 `creation_timestamp` datetime not null default current_timestamp,
192 primary key (`model_uuid`),
193 key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
194 key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
195 constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade,
196 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
197 ) engine=innodb default charset=latin1;
203 create table `network_resource_customization` (
204 `model_customization_uuid` varchar(200) not null,
205 `model_instance_name` varchar(200) not null,
206 `network_technology` varchar(45) default null,
207 `network_type` varchar(45) default null,
208 `network_role` varchar(200) default null,
209 `network_scope` varchar(45) default null,
210 `creation_timestamp` datetime not null default current_timestamp,
211 `network_resource_model_uuid` varchar(200) not null,
212 primary key (`model_customization_uuid`),
213 key `fk_network_resource_customization__network_resource1_idx` (`network_resource_model_uuid`),
214 constraint `fk_network_resource_customization__network_resource1` foreign key (`network_resource_model_uuid`) references `network_resource` (`model_uuid`) on delete cascade on update cascade
215 ) engine=innodb default charset=latin1;
221 create table `tosca_csar` (
222 `artifact_uuid` varchar(200) not null,
223 `name` varchar(200) not null,
224 `version` varchar(20) not null,
225 `description` varchar(1200) default null,
226 `artifact_checksum` varchar(200) not null,
227 `url` varchar(200) not null,
228 `creation_timestamp` datetime not null default current_timestamp,
229 primary key (`artifact_uuid`)
230 ) engine=innodb default charset=latin1;
235 create table `service` (
236 `model_uuid` varchar(200) not null,
237 `model_name` varchar(200) not null,
238 `model_invariant_uuid` varchar(200) not null,
239 `model_version` varchar(20) not null,
240 `description` varchar(1200) default null,
241 `creation_timestamp` datetime not null default current_timestamp,
242 `tosca_csar_artifact_uuid` varchar(200) default null,
243 `service_type` varchar(200) default null,
244 `service_role` varchar(200) default null,
245 `environment_context` varchar(200) default null,
246 `workload_context` varchar(200) default null,
247 `service_category` varchar(200) default null,
248 primary key (`model_uuid`),
249 key `fk_service__tosca_csar1_idx` (`tosca_csar_artifact_uuid`),
250 constraint `fk_service__tosca_csar1` foreign key (`tosca_csar_artifact_uuid`) references `tosca_csar` (`artifact_uuid`) on delete cascade on update cascade
251 ) engine=innodb default charset=latin1;
255 create table `service_recipe` (
256 `id` int(11) not null auto_increment,
257 `action` varchar(50) not null,
258 `version_str` varchar(20) default null,
259 `description` varchar(1200) default null,
260 `orchestration_uri` varchar(256) not null,
261 `service_param_xsd` varchar(2048) default null,
262 `recipe_timeout` int(11) default null,
263 `service_timeout_interim` int(11) default null,
264 `creation_timestamp` datetime not null default current_timestamp,
265 `service_model_uuid` varchar(200) not null,
267 unique key `uk_7fav5dkux2v8g9d2i5ymudlgc` (`service_model_uuid`,`action`),
268 key `fk_service_recipe__service1_idx` (`service_model_uuid`),
269 constraint `fk_service_recipe__service1` foreign key (`service_model_uuid`) references `service` (`model_uuid`) on delete cascade on update cascade
270 ) engine=innodb auto_increment=86 default charset=latin1;
274 create table `vnf_resource` (
275 `orchestration_mode` varchar(20) not null default 'heat',
276 `description` varchar(1200) default null,
277 `creation_timestamp` datetime not null default current_timestamp,
278 `model_uuid` varchar(200) not null,
279 `aic_version_min` varchar(20) default null,
280 `aic_version_max` varchar(20) default null,
281 `model_invariant_uuid` varchar(200) default null,
282 `model_version` varchar(20) not null,
283 `model_name` varchar(200) default null,
284 `tosca_node_type` varchar(200) default null,
285 `resource_category` varchar(200) default null,
286 `resource_sub_category` varchar(200) default null,
287 `heat_template_artifact_uuid` varchar(200) default null,
288 primary key (`model_uuid`),
289 key `fk_vnf_resource__heat_template1` (`heat_template_artifact_uuid`),
290 constraint `fk_vnf_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete cascade on update cascade
291 ) engine=innodb default charset=latin1;
296 create table `vf_module` (
297 `model_uuid` varchar(200) not null,
298 `model_invariant_uuid` varchar(200) default null,
299 `model_version` varchar(20) not null,
300 `model_name` varchar(200) not null,
301 `description` varchar(1200) default null,
302 `is_base` int(11) not null,
303 `heat_template_artifact_uuid` varchar(200) default null,
304 `vol_heat_template_artifact_uuid` varchar(200) default null,
305 `creation_timestamp` datetime not null default current_timestamp,
306 `vnf_resource_model_uuid` varchar(200) not null,
307 primary key (`model_uuid`,`vnf_resource_model_uuid`),
308 key `fk_vf_module__vnf_resource1_idx` (`vnf_resource_model_uuid`),
309 key `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`heat_template_artifact_uuid`),
310 key `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`vol_heat_template_artifact_uuid`),
311 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,
312 constraint `fk_vf_module__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade,
313 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
314 ) engine=innodb default charset=latin1;
318 /*!40101 set @saved_cs_client = @@character_set_client */;
319 /*!40101 set character_set_client = utf8 */;
320 create table `vf_module_customization` (
321 `model_customization_uuid` varchar(200) not null,
322 `label` varchar(200) default null,
323 `initial_count` int(11) default '0',
324 `min_instances` int(11) default '0',
325 `max_instances` int(11) default null,
326 `availability_zone_count` int(11) default null,
327 `heat_environment_artifact_uuid` varchar(200) default null,
328 `vol_environment_artifact_uuid` varchar(200) default null,
329 `creation_timestamp` datetime not null default current_timestamp,
330 `vf_module_model_uuid` varchar(200) not null,
331 primary key (`model_customization_uuid`),
332 key `fk_vf_module_customization__vf_module1_idx` (`vf_module_model_uuid`),
333 key `fk_vf_module_customization__heat_env__heat_environment1_idx` (`heat_environment_artifact_uuid`),
334 key `fk_vf_module_customization__vol_env__heat_environment2_idx` (`vol_environment_artifact_uuid`),
335 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,
336 constraint `fk_vf_module_customization__vf_module1` foreign key (`vf_module_model_uuid`) references `vf_module` (`model_uuid`) on delete cascade on update cascade,
337 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
338 ) engine=innodb default charset=latin1;
339 /*!40101 set character_set_client = @saved_cs_client */;
342 -- table structure for table `vf_module_to_heat_files`
346 /*!40101 set @saved_cs_client = @@character_set_client */;
347 /*!40101 set character_set_client = utf8 */;
348 create table `vf_module_to_heat_files` (
349 `vf_module_model_uuid` varchar(200) not null,
350 `heat_files_artifact_uuid` varchar(200) not null,
351 primary key (`vf_module_model_uuid`,`heat_files_artifact_uuid`),
352 key `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`heat_files_artifact_uuid`),
353 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,
354 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
355 ) engine=innodb default charset=latin1 comment='il fait ce qu''il dit';
356 /*!40101 set character_set_client = @saved_cs_client */;
359 -- table structure for table `vnf_components`
363 /*!40101 set @saved_cs_client = @@character_set_client */;
364 /*!40101 set character_set_client = utf8 */;
365 create table `vnf_components` (
366 `vnf_id` int(11) not null,
367 `component_type` varchar(20) not null,
368 `heat_template_id` int(11) default null,
369 `heat_environment_id` int(11) default null,
370 `creation_timestamp` datetime not null default current_timestamp,
371 primary key (`vnf_id`,`component_type`)
372 ) engine=innodb default charset=latin1;
373 /*!40101 set character_set_client = @saved_cs_client */;
376 -- table structure for table `vnf_components_recipe`
381 create table `vnf_components_recipe` (
382 `id` int(11) not null auto_increment,
383 `vnf_type` varchar(200) default null,
384 `vnf_component_type` varchar(45) not null,
385 `action` varchar(50) not null,
386 `service_type` varchar(45) default null,
387 `version` varchar(20) not null,
388 `description` varchar(1200) default null,
389 `orchestration_uri` varchar(256) not null,
390 `vnf_component_param_xsd` varchar(2048) default null,
391 `recipe_timeout` int(11) default null,
392 `creation_timestamp` datetime default current_timestamp,
393 `vf_module_model_uuid` varchar(200) default null,
395 unique key `uk_4dpdwddaaclhc11wxsb7h59ma` (`vf_module_model_uuid`,`vnf_component_type`,`action`,`version`)
396 ) engine=innodb auto_increment=26 default charset=latin1;
401 create table `vnf_recipe` (
402 `id` int(11) not null auto_increment,
403 `vnf_type` varchar(200) default null,
404 `action` varchar(50) not null,
405 `service_type` varchar(45) default null,
406 `version_str` varchar(20) not null,
407 `description` varchar(1200) default null,
408 `orchestration_uri` varchar(256) not null,
409 `vnf_param_xsd` varchar(2048) default null,
410 `recipe_timeout` int(11) default null,
411 `creation_timestamp` datetime default current_timestamp,
412 `vf_module_id` varchar(100) default null,
414 unique key `uk_f3tvqau498vrifq3cr8qnigkr` (`vf_module_id`,`action`,`version_str`)
415 ) engine=innodb auto_increment=10006 default charset=latin1;
424 create table `vnf_resource_customization` (
425 `model_customization_uuid` varchar(200) not null,
426 `model_instance_name` varchar(200) not null,
427 `min_instances` int(11) default null,
428 `max_instances` int(11) default null,
429 `availability_zone_max_count` int(11) default null,
430 `nf_type` varchar(200) default null,
431 `nf_role` varchar(200) default null,
432 `nf_function` varchar(200) default null,
433 `nf_naming_code` varchar(200) default null,
434 `creation_timestamp` datetime not null default current_timestamp,
435 `vnf_resource_model_uuid` varchar(200) not null,
436 `multi_stage_design` varchar(20) default null,
437 primary key (`model_customization_uuid`),
438 key `fk_vnf_resource_customization__vnf_resource1_idx` (`vnf_resource_model_uuid`),
439 constraint `fk_vnf_resource_customization__vnf_resource1` foreign key (`vnf_resource_model_uuid`) references `vnf_resource` (`model_uuid`) on delete cascade on update cascade
440 ) engine=innodb default charset=latin1;
445 create table `vnf_res_custom_to_vf_module_custom` (
446 `vnf_resource_cust_model_customization_uuid` varchar(200) not null,
447 `vf_module_cust_model_customization_uuid` varchar(200) not null,
448 `creation_timestamp` datetime not null default current_timestamp,
449 primary key (`vnf_resource_cust_model_customization_uuid`,`vf_module_cust_model_customization_uuid`),
450 key `fk_vnf_res_custom_to_vf_module_custom__vf_module_customizat_idx` (`vf_module_cust_model_customization_uuid`),
451 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,
452 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
453 ) engine=innodb default charset=latin1;
456 create table if not exists external_service_to_internal_model_mapping (
458 service_name varchar(200) not null,
459 product_flavor varchar(200) null,
460 subscription_service_type varchar(200) not null,
461 service_model_uuid varchar(200) not null,
463 unique index uk_external_service_to_internal_model_mapping
464 (service_name asc, product_flavor asc, service_model_uuid asc));
466 create table if not exists `collection_resource` (
467 model_uuid varchar(200) not null,
468 model_name varchar(200) not null,
469 model_invariant_uuid varchar(200) not null,
470 model_version varchar(20) not null,
471 tosca_node_type varchar(200) not null,
472 description varchar(200),
473 creation_timestamp datetime not null default current_timestamp,
474 primary key (`model_uuid`)
475 )engine=innodb default charset=latin1;
477 create table if not exists `collection_resource_customization` (
478 model_customization_uuid varchar(200) not null,
479 model_instance_name varchar(200) not null,
480 role varchar(200) NULL,
481 object_type varchar(200) not null,
482 function varchar(200) NULL,
483 collection_resource_type varchar(200) NULL,
484 creation_timestamp datetime not null default current_timestamp,
485 cr_model_uuid varchar(200) not null,
486 primary key (`model_customization_uuid`)
487 )engine=innodb default charset=latin1;
489 create table if not exists `instance_group` (
490 model_uuid varchar(200) not null,
491 model_name varchar(200) not null,
492 model_invariant_uuid varchar(200) not null,
493 model_version varchar(20) not null,
494 tosca_node_type varchar(200) NULL,
495 role varchar(200) not null,
496 object_type varchar(200) not null,
497 creation_timestamp datetime not null default current_timestamp,
498 cr_model_uuid varchar(200) not null,
499 instance_group_type varchar(200) not null,
500 primary key (`model_uuid`)
501 )engine=innodb default charset=latin1;
503 create table if not exists `collection_resource_instance_group_customization` (
504 `collection_resource_customization_model_uuid` varchar(200) not null,
505 `instance_group_model_uuid` varchar(200) not null,
506 `function` varchar(200) null,
507 `description` varchar(1200) null,
508 `subinterface_network_quantity` int(11) null,
509 `creation_timestamp` datetime not null default current_timestamp,
510 primary key (`collection_resource_customization_model_uuid`, `instance_group_model_uuid`),
511 index `fk_collection_resource_instance_group_customization__instan_idx` (`instance_group_model_uuid` asc),
512 constraint `fk_collection_resource_instance_group_customization__collecti1`
513 foreign key (`collection_resource_customization_model_uuid`)
514 references `collection_resource_customization` (`model_customization_uuid`)
517 constraint `fk_collection_resource_instance_group_customization__instance1`
518 foreign key (`instance_group_model_uuid`)
519 references `instance_group` (`model_uuid`)
523 default character set = latin1;
525 create table if not exists `vnfc_instance_group_customization` (
526 `vnf_resource_customization_model_uuid` varchar(200) not null,
527 `instance_group_model_uuid` varchar(200) not null,
528 `function` varchar(200) null,
529 `description` varchar(1200) null,
530 `creation_timestamp` datetime not null default current_timestamp,
531 primary key (`vnf_resource_customization_model_uuid`, `instance_group_model_uuid`),
532 index `fk_vnfc_instance_group_customization__instance_group1_idx` (`instance_group_model_uuid` asc),
533 constraint `fk_vnfc_instance_group_customization__vnf_resource_customizat1`
534 foreign key (`vnf_resource_customization_model_uuid`)
535 references `vnf_resource_customization` (`model_customization_uuid`)
538 constraint `fk_vnfc_instance_group_customization__instance_group1`
539 foreign key (`instance_group_model_uuid`)
540 references `instance_group` (`model_uuid`)
544 default character set = latin1;
546 create table if not exists `configuration`
547 ( `model_uuid` varchar(200) not null,
548 `model_invariant_uuid` varchar(200) not null,
549 `model_version` varchar(20) not null,
550 `model_name` varchar(200) not null,
551 `tosca_node_type` varchar(200) not null,
552 `description` varchar(1200) null,
553 `creation_timestamp` datetime not null default current_timestamp,
554 primary key (`model_uuid`))
555 engine = innodb auto_increment = 20654
556 default character set = latin1;
558 create table if not exists `service_proxy` (
559 `model_uuid` varchar(200) not null,
560 `model_invariant_uuid` varchar(200) not null,
561 `model_version` varchar(20) not null,
562 `model_name` varchar(200) not null,
563 `description` varchar(1200) null,
564 `creation_timestamp` datetime not null default current_timestamp,
565 primary key (`model_uuid`))
566 engine = innodb auto_increment = 20654
567 default character set = latin1;
569 create table if not exists `service_proxy_customization` (
570 `model_customization_uuid` varchar(200) not null,
571 `model_instance_name` varchar(200) not null,
572 `tosca_node_type` varchar(200) not null,
573 `source_service_model_uuid` varchar(200) not null,
574 `creation_timestamp` datetime not null default current_timestamp,
575 `service_proxy_model_uuid` varchar(200) not null,
576 primary key (`model_customization_uuid`),
577 index `fk_service_proxy_customization__service_proxy1_idx` (`service_proxy_model_uuid` asc),
578 index `fk_service_proxy_customization__service1_idx` (`source_service_model_uuid` asc),
579 constraint`fk_spr_customization__service_proxy_resource1`
580 foreign key (`service_proxy_model_uuid`) references `service_proxy` (`model_uuid`)
581 on delete cascade on update cascade,
582 constraint `fk_service_proxy_resource_customization__service1`
583 foreign key (`source_service_model_uuid`) references `service`
584 (`model_uuid`) on delete cascade on update cascade)
586 auto_increment = 20654
587 default character set = latin1;
589 create table if not exists `configuration_customization` (
590 `model_customization_uuid` varchar(200) not null,
591 `model_instance_name` varchar(200) not null,
592 `configuration_type` varchar(200) null,
593 `configuration_role` varchar(200) null,
594 `configuration_function` varchar(200) null,
595 `creation_timestamp` datetime not null default current_timestamp,
596 `configuration_model_uuid` varchar(200) not null,
597 `service_proxy_customization_model_customization_uuid` varchar(200) null,
598 `configuration_customization_model_customization_uuid` varchar(200) null,
599 primary key (`model_customization_uuid`),
600 index `fk_configuration_customization__configuration_idx` (`configuration_model_uuid` asc),
601 index `fk_configuration_customization__service_proxy_customization_idx`
602 (`service_proxy_customization_model_customization_uuid` asc),
603 index `fk_configuration_customization__configuration_customization_idx`
604 (`configuration_customization_model_customization_uuid` asc),
605 constraint `fk_configuration_resource_customization__configuration_resour1`
606 foreign key (`configuration_model_uuid`) references `configuration` (`model_uuid`)
607 on delete cascade on update cascade,
608 constraint `fk_configuration_customization__service_proxy_customization1` foreign
609 key (`service_proxy_customization_model_customization_uuid`) references
610 `service_proxy_customization` (`model_customization_uuid`)
611 on delete cascade on update cascade, constraint
612 `fk_configuration_customization__configuration_customization1` foreign
613 key (`configuration_customization_model_customization_uuid`) references
614 `configuration_customization` (`model_customization_uuid`)
615 on delete cascade on update cascade)
617 auto_increment =20654
618 default character set = latin1;
621 create table `service_proxy_customization_to_service` (
622 `service_model_uuid` varchar(200) not null,
623 `resource_model_customization_uuid` varchar(200) not null,
624 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
625 )engine=innodb default charset=latin1;
628 create table `configuration_customization_to_service` (
629 `service_model_uuid` varchar(200) not null,
630 `resource_model_customization_uuid` varchar(200) not null,
631 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
632 )engine=innodb default charset=latin1;
635 create table if not exists `collection_resource_customization_to_service` (
636 `service_model_uuid` varchar(200) not null,
637 `resource_model_customization_uuid` varchar(200) not null,
638 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
639 )engine=innodb default charset=latin1;
642 create table `network_resource_customization_to_service` (
643 `service_model_uuid` varchar(200) not null,
644 `resource_model_customization_uuid` varchar(200) not null,
645 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
646 )engine=innodb default charset=latin1;
648 create table `vnf_resource_customization_to_service` (
649 `service_model_uuid` varchar(200) not null,
650 `resource_model_customization_uuid` varchar(200) not null,
651 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
652 )engine=innodb default charset=latin1;
654 create table `allotted_resource_customization_to_service` (
655 `service_model_uuid` varchar(200) not null,
656 `resource_model_customization_uuid` varchar(200) not null,
657 primary key (`service_model_uuid`,`resource_model_customization_uuid`)
658 )engine=innodb default charset=latin1;
662 create table ar_recipe (
663 ID INT(11) not null auto_increment,
664 MODEL_NAME VARCHAR(200) NOT NULL,
665 `ACTION` VARCHAR(200) NOT NULL,
666 VERSION_STR VARCHAR(200) NOT NULL,
667 SERVICE_TYPE VARCHAR(200),
668 DESCRIPTION VARCHAR(200),
669 ORCHESTRATION_URI VARCHAR(200) NOT NULL,
670 AR_PARAM_XSD VARCHAR(200),
671 RECIPE_TIMEOUT INT(10),
672 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
674 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
675 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
677 alter table collection_resource_customization
678 add foreign key ( cr_model_uuid)
679 references collection_resource(model_uuid)
682 alter table vnf_resource_customization
684 instance_group_model_uuid varchar(200);
686 alter table network_resource_customization
688 instance_group_model_uuid varchar(200);
691 alter table network_resource_customization
692 add foreign key ( instance_group_model_uuid)
693 references instance_group(model_uuid)
696 alter table collection_resource_customization_to_service
697 add foreign key (service_model_uuid)
698 references service(model_uuid)
701 alter table allotted_resource_customization_to_service
702 add foreign key (service_model_uuid)
703 references service(model_uuid)
707 alter table vnf_resource_customization_to_service
708 add foreign key (service_model_uuid)
709 references service(model_uuid)
713 alter table network_resource_customization_to_service
714 add foreign key (service_model_uuid)
715 references service(model_uuid)
719 alter table network_resource_customization_to_service
720 add foreign key (resource_model_customization_uuid)
721 references network_resource_customization(model_customization_uuid)
724 alter table vnf_resource_customization_to_service
725 add foreign key (resource_model_customization_uuid)
726 references vnf_resource_customization(model_customization_uuid)
729 alter table allotted_resource_customization_to_service
730 add foreign key (resource_model_customization_uuid)
731 references allotted_resource_customization(model_customization_uuid)
734 alter table collection_resource_customization_to_service
735 add foreign key (resource_model_customization_uuid)
736 references collection_resource_customization(model_customization_uuid)
740 create table if not exists `collection_network_resource_customization` (
741 `model_customization_uuid` varchar(200) not null,
742 `model_instance_name` varchar(200) not null,
743 `network_technology` varchar(45) null,
744 `network_type` varchar(45) null,
745 `network_role` varchar(200) null,
746 `network_scope` varchar(45) null,
747 `creation_timestamp` datetime not null default current_timestamp,
748 `network_resource_model_uuid` varchar(200) not null, `instance_group_model_uuid` varchar(200) null,
749 `crc_model_customization_uuid` varchar(200) not null, primary key
750 (`model_customization_uuid`, `crc_model_customization_uuid`),
751 index `fk_collection_net_resource_customization__network_resource1_idx`
752 (`network_resource_model_uuid` asc), index
753 `fk_collection_net_resource_customization__instance_group1_idx`
754 (`instance_group_model_uuid` asc), index
755 `fk_col_net_res_customization__collection_res_customization_idx`
756 (`crc_model_customization_uuid` asc), constraint
757 `fk_collection_net_resource_customization__network_resource10` foreign
758 key (`network_resource_model_uuid`) references
759 `network_resource` (`model_uuid`) on delete cascade on
760 update cascade, constraint
761 `fk_collection_net_resource_customization__instance_group10` foreign key
762 (`instance_group_model_uuid`) references `instance_group`
763 (`model_uuid`) on delete cascade on update cascade, constraint
764 `fk_collection_network_resource_customization__collection_reso1` foreign
765 key (`crc_model_customization_uuid`) references
766 `collection_resource_customization`
767 (`model_customization_uuid`) on delete cascade on update cascade) engine
768 = innodb default character set = latin1;
770 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
771 `id` INT(11) NOT NULL AUTO_INCREMENT,
772 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
773 `MACRO_ACTION` VARCHAR(200) NOT NULL,
774 `ACTION` VARCHAR(200) NOT NULL,
775 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
776 `IS_TOPLEVELFLOW` TINYINT(1) NOT NULL DEFAULT 1,
777 `MIN_API_VERSION` DOUBLE NOT NULL,
778 `MAX_API_VERSION` DOUBLE NULL,
780 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC, `MACRO_ACTION` ASC))
782 DEFAULT CHARACTER SET = latin1;
784 CREATE TABLE IF NOT EXISTS orchestration_status_state_transition_directive (
785 id INT(11) AUTO_INCREMENT,
786 RESOURCE_TYPE VARCHAR(25) NOT NULL,
787 ORCHESTRATION_STATUS VARCHAR(25) NOT NULL,
788 TARGET_ACTION VARCHAR(25) NOT NULL,
789 FLOW_DIRECTIVE VARCHAR(25) NOT NULL,
791 UNIQUE KEY UK_orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION))
793 DEFAULT CHARACTER SET = latin1;
795 create table if not exists model_recipe (
796 `ID` INT(11) NOT NULL AUTO_INCREMENT,
798 `ACTION` VARCHAR(40),
799 `SCHEMA_VERSION` VARCHAR(40),
800 `DESCRIPTION` VARCHAR(40),
801 `ORCHESTRATION_URI` VARCHAR(20),
802 `MODEL_PARAM_XSD` VARCHAR(20),
803 `RECIPE_TIMEOUT` INT(11),
804 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
806 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
807 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
809 create table if not exists model (
810 `ID` INT(11) NOT NULL AUTO_INCREMENT,
811 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
812 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
813 `MODEL_INVARIANT_ID` VARCHAR(40),
814 `MODEL_NAME` VARCHAR(40),
815 `MODEL_TYPE` VARCHAR(20),
816 `MODEL_VERSION` VARCHAR(20),
817 `MODEL_VERSION_ID` VARCHAR(40),
818 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
821 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
822 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
823 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
825 CREATE TABLE IF NOT EXISTS `controller_selection_reference` (
826 `VNF_TYPE` VARCHAR(50) NOT NULL,
827 `CONTROLLER_NAME` VARCHAR(100) NOT NULL,
828 `ACTION_CATEGORY` VARCHAR(15) NOT NULL,
829 PRIMARY KEY (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`)
832 ALTER TABLE `vnf_recipe`
833 CHANGE COLUMN `VNF_TYPE` `NF_ROLE` VARCHAR(200) NULL DEFAULT NULL ;
835 CREATE TABLE IF NOT EXISTS `identity_services` (
836 `ID` varchar(50) NOT NULL,
837 `IDENTITY_URL` varchar(200) DEFAULT NULL,
838 `MSO_ID` varchar(255) DEFAULT NULL,
839 `MSO_PASS` varchar(255) DEFAULT NULL,
840 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
841 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
842 `TENANT_METADATA` tinyint(1) DEFAULT 0,
843 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
844 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
845 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
846 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
847 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
851 CREATE TABLE IF NOT EXISTS `cloudify_managers` (
852 `ID` varchar(50) NOT NULL,
853 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
854 `USERNAME` varchar(255) DEFAULT NULL,
855 `PASSWORD` varchar(255) DEFAULT NULL,
856 `VERSION` varchar(20) DEFAULT NULL,
857 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
858 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
859 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
863 CREATE TABLE IF NOT EXISTS `cloud_sites` (
864 `ID` varchar(50) NOT NULL,
865 `REGION_ID` varchar(11) DEFAULT NULL,
866 `IDENTITY_SERVICE_ID` varchar(50) DEFAULT NULL,
867 `CLOUD_VERSION` varchar(20) DEFAULT NULL,
868 `CLLI` varchar(11) DEFAULT NULL,
869 `CLOUDIFY_ID` varchar(50) DEFAULT NULL,
870 `PLATFORM` varchar(50) DEFAULT NULL,
871 `ORCHESTRATOR` varchar(50) DEFAULT NULL,
872 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
873 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
874 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
876 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
877 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)