1 set foreign_key_checks=0;
2 DROP TABLE IF EXISTS `allotted_resource`;
3 /*!40101 SET @saved_cs_client = @@character_set_client */;
4 /*!40101 SET character_set_client = utf8 */;
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;
16 /*!40101 SET character_set_client = @saved_cs_client */;
19 -- Table structure for table `allotted_resource_customization`
22 DROP TABLE IF EXISTS `allotted_resource_customization`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `allotted_resource_customization` (
26 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
27 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
28 `PROVIDING_SERVICE_MODEL_UUID` varchar(200) DEFAULT NULL,
29 `PROVIDING_SERVICE_MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
30 `PROVIDING_SERVICE_MODEL_NAME` varchar(200) DEFAULT NULL,
31 `TARGET_NETWORK_ROLE` varchar(200) DEFAULT NULL,
32 `NF_TYPE` varchar(200) DEFAULT NULL,
33 `NF_ROLE` varchar(200) DEFAULT NULL,
34 `NF_FUNCTION` varchar(200) DEFAULT NULL,
35 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
36 `MIN_INSTANCES` int(11) DEFAULT NULL,
37 `MAX_INSTANCES` int(11) DEFAULT NULL,
38 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
39 `AR_MODEL_UUID` varchar(200) NOT NULL,
40 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
41 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
42 KEY `fk_allotted_resource_customization__allotted_resource1_idx` (`AR_MODEL_UUID`),
43 CONSTRAINT `fk_allotted_resource_customization__allotted_resource1` FOREIGN KEY (`AR_MODEL_UUID`) REFERENCES `allotted_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
44 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45 /*!40101 SET character_set_client = @saved_cs_client */;
48 -- Table structure for table `allotted_resource_customization_to_service`
51 DROP TABLE IF EXISTS `allotted_resource_customization_to_service`;
52 /*!40101 SET @saved_cs_client = @@character_set_client */;
53 /*!40101 SET character_set_client = utf8 */;
54 CREATE TABLE `allotted_resource_customization_to_service` (
55 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
56 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
57 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
58 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
59 CONSTRAINT `allotted_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
60 CONSTRAINT `allotted_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `allotted_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
61 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62 /*!40101 SET character_set_client = @saved_cs_client */;
65 -- Table structure for table `ar_recipe`
68 DROP TABLE IF EXISTS `ar_recipe`;
69 /*!40101 SET @saved_cs_client = @@character_set_client */;
70 /*!40101 SET character_set_client = utf8 */;
71 CREATE TABLE `ar_recipe` (
72 `ID` int(11) NOT NULL AUTO_INCREMENT,
73 `MODEL_NAME` varchar(200) NOT NULL,
74 `ACTION` varchar(200) NOT NULL,
75 `VERSION_STR` varchar(200) NOT NULL,
76 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
77 `DESCRIPTION` varchar(200) DEFAULT NULL,
78 `ORCHESTRATION_URI` varchar(200) NOT NULL,
79 `AR_PARAM_XSD` varchar(200) DEFAULT NULL,
80 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
81 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
83 UNIQUE KEY `uk_ar_recipe` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
84 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85 /*!40101 SET character_set_client = @saved_cs_client */;
88 -- Table structure for table `building_block_detail`
91 DROP TABLE IF EXISTS `building_block_detail`;
92 /*!40101 SET @saved_cs_client = @@character_set_client */;
93 /*!40101 SET character_set_client = utf8 */;
94 CREATE TABLE `building_block_detail` (
95 `id` int(11) NOT NULL AUTO_INCREMENT,
96 `BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
97 `RESOURCE_TYPE` varchar(25) NOT NULL,
98 `TARGET_ACTION` varchar(25) NOT NULL,
100 UNIQUE KEY `UK_building_block_name` (`BUILDING_BLOCK_NAME`)
101 ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
102 /*!40101 SET character_set_client = @saved_cs_client */;
105 -- Table structure for table `cloud_sites`
108 DROP TABLE IF EXISTS `cloud_sites`;
109 /*!40101 SET @saved_cs_client = @@character_set_client */;
110 /*!40101 SET character_set_client = utf8 */;
111 CREATE TABLE `cloud_sites` (
112 `ID` varchar(50) NOT NULL,
113 `REGION_ID` varchar(11) DEFAULT NULL,
114 `IDENTITY_SERVICE_ID` varchar(50) DEFAULT NULL,
115 `CLOUD_VERSION` varchar(20) DEFAULT NULL,
116 `CLLI` varchar(11) DEFAULT NULL,
117 `CLOUDIFY_ID` varchar(50) DEFAULT NULL,
118 `PLATFORM` varchar(50) DEFAULT NULL,
119 `ORCHESTRATOR` varchar(50) DEFAULT NULL,
120 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
121 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
122 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
124 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
125 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)
126 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
127 /*!40101 SET character_set_client = @saved_cs_client */;
130 -- Table structure for table `cloudify_managers`
133 DROP TABLE IF EXISTS `cloudify_managers`;
134 /*!40101 SET @saved_cs_client = @@character_set_client */;
135 /*!40101 SET character_set_client = utf8 */;
136 CREATE TABLE `cloudify_managers` (
137 `ID` varchar(50) NOT NULL,
138 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
139 `USERNAME` varchar(255) DEFAULT NULL,
140 `PASSWORD` varchar(255) DEFAULT NULL,
141 `VERSION` varchar(20) DEFAULT NULL,
142 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
143 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
144 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
146 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147 /*!40101 SET character_set_client = @saved_cs_client */;
150 -- Table structure for table `collection_network_resource_customization`
153 DROP TABLE IF EXISTS `collection_network_resource_customization`;
154 /*!40101 SET @saved_cs_client = @@character_set_client */;
155 /*!40101 SET character_set_client = utf8 */;
156 CREATE TABLE `collection_network_resource_customization` (
157 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
158 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
159 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
160 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
161 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
162 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
163 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
164 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
165 `INSTANCE_GROUP_MODEL_UUID` varchar(200) DEFAULT NULL,
166 `CRC_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
167 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`,`CRC_MODEL_CUSTOMIZATION_UUID`),
168 KEY `fk_collection_net_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
169 KEY `fk_collection_net_resource_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
170 KEY `fk_col_net_res_customization__collection_res_customization_idx` (`CRC_MODEL_CUSTOMIZATION_UUID`),
171 CONSTRAINT `fk_collection_net_resource_customization__instance_group10` FOREIGN KEY (`INSTANCE_GROUP_MODEL_UUID`) REFERENCES `instance_group` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
172 CONSTRAINT `fk_collection_net_resource_customization__network_resource10` FOREIGN KEY (`NETWORK_RESOURCE_MODEL_UUID`) REFERENCES `network_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
173 CONSTRAINT `fk_collection_network_resource_customization__collection_reso1` FOREIGN KEY (`CRC_MODEL_CUSTOMIZATION_UUID`) REFERENCES `collection_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
174 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
175 /*!40101 SET character_set_client = @saved_cs_client */;
178 -- Table structure for table `collection_resource`
181 DROP TABLE IF EXISTS `collection_resource`;
182 /*!40101 SET @saved_cs_client = @@character_set_client */;
183 /*!40101 SET character_set_client = utf8 */;
184 CREATE TABLE `collection_resource` (
185 `MODEL_UUID` varchar(200) NOT NULL,
186 `MODEL_NAME` varchar(200) NOT NULL,
187 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
188 `MODEL_VERSION` varchar(20) NOT NULL,
189 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
190 `DESCRIPTION` varchar(1200) DEFAULT NULL,
191 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
192 PRIMARY KEY (`MODEL_UUID`)
193 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
194 /*!40101 SET character_set_client = @saved_cs_client */;
197 -- Table structure for table `collection_resource_customization`
200 DROP TABLE IF EXISTS `collection_resource_customization`;
201 /*!40101 SET @saved_cs_client = @@character_set_client */;
202 /*!40101 SET character_set_client = utf8 */;
203 CREATE TABLE `collection_resource_customization` (
204 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
205 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
206 `role` varchar(200) DEFAULT NULL,
207 `object_type` varchar(200) NOT NULL,
208 `function` varchar(200) DEFAULT NULL,
209 `collection_resource_type` varchar(200) DEFAULT NULL,
210 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
211 `CR_MODEL_UUID` varchar(200) NOT NULL,
212 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
213 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`),
214 CONSTRAINT `collection_resource_customization_ibfk_1` FOREIGN KEY (`CR_MODEL_UUID`) REFERENCES `collection_resource` (`MODEL_UUID`) ON DELETE CASCADE
215 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
216 /*!40101 SET character_set_client = @saved_cs_client */;
219 -- Table structure for table `collection_resource_customization_to_service`
222 DROP TABLE IF EXISTS `collection_resource_customization_to_service`;
223 /*!40101 SET @saved_cs_client = @@character_set_client */;
224 /*!40101 SET character_set_client = utf8 */;
225 CREATE TABLE `collection_resource_customization_to_service` (
226 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
227 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
228 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
229 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
230 CONSTRAINT `collection_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
231 CONSTRAINT `collection_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `collection_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
232 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
233 /*!40101 SET character_set_client = @saved_cs_client */;
236 -- Table structure for table `collection_resource_instance_group_customization`
239 DROP TABLE IF EXISTS `collection_resource_instance_group_customization`;
240 /*!40101 SET @saved_cs_client = @@character_set_client */;
241 /*!40101 SET character_set_client = utf8 */;
242 CREATE TABLE `collection_resource_instance_group_customization` (
243 `COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID` varchar(200) NOT NULL,
244 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
245 `FUNCTION` varchar(200) DEFAULT NULL,
246 `DESCRIPTION` varchar(1200) DEFAULT NULL,
247 `SUBINTERFACE_NETWORK_QUANTITY` int(11) DEFAULT NULL,
248 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
249 PRIMARY KEY (`COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID`,`INSTANCE_GROUP_MODEL_UUID`),
250 KEY `fk_collection_resource_instance_group_customization__instan_idx` (`INSTANCE_GROUP_MODEL_UUID`),
251 CONSTRAINT `fk_collection_resource_instance_group_customization__collecti1` FOREIGN KEY (`COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID`) REFERENCES `collection_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
252 CONSTRAINT `fk_collection_resource_instance_group_customization__instance1` FOREIGN KEY (`INSTANCE_GROUP_MODEL_UUID`) REFERENCES `instance_group` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
253 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
254 /*!40101 SET character_set_client = @saved_cs_client */;
257 -- Table structure for table `configuration`
260 DROP TABLE IF EXISTS `configuration`;
261 /*!40101 SET @saved_cs_client = @@character_set_client */;
262 /*!40101 SET character_set_client = utf8 */;
263 CREATE TABLE `configuration` (
264 `MODEL_UUID` varchar(200) NOT NULL,
265 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
266 `MODEL_VERSION` varchar(20) NOT NULL,
267 `MODEL_NAME` varchar(200) NOT NULL,
268 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
269 `DESCRIPTION` varchar(1200) DEFAULT NULL,
270 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
271 PRIMARY KEY (`MODEL_UUID`)
272 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
273 /*!40101 SET character_set_client = @saved_cs_client */;
276 -- Table structure for table `configuration_customization`
279 DROP TABLE IF EXISTS `configuration_customization`;
280 /*!40101 SET @saved_cs_client = @@character_set_client */;
281 /*!40101 SET character_set_client = utf8 */;
282 CREATE TABLE `configuration_customization` (
283 `ID` int(11) NOT NULL AUTO_INCREMENT,
284 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
285 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
286 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
287 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
288 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
289 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
290 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
291 `SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
292 `CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
293 `SERVICE_MODEL_UUID` varchar(200),
295 KEY `fk_configuration_customization__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
296 KEY `fk_configuration_customization__service_idx` (`SERVICE_MODEL_UUID`),
297 UNIQUE KEY `uk_configuration_customization` (`MODEL_CUSTOMIZATION_UUID` ASC, `SERVICE_MODEL_UUID` ASC),
298 CONSTRAINT `fk_configuration_customization__configuration1` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
299 REFERENCES `configuration` (`MODEL_UUID`)
300 ON DELETE CASCADE ON UPDATE CASCADE,
301 CONSTRAINT `fk_configuration_customization__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`)
302 REFERENCES `service` (`MODEL_UUID`)
303 ON DELETE CASCADE ON UPDATE CASCADE
304 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
305 /*!40101 SET character_set_client = @saved_cs_client */;
308 -- Table structure for table `controller_selection_reference`
311 DROP TABLE IF EXISTS `controller_selection_reference`;
312 /*!40101 SET @saved_cs_client = @@character_set_client */;
313 /*!40101 SET character_set_client = utf8 */;
314 CREATE TABLE `controller_selection_reference` (
315 `VNF_TYPE` varchar(50) NOT NULL,
316 `CONTROLLER_NAME` varchar(100) NOT NULL,
317 `ACTION_CATEGORY` varchar(15) NOT NULL,
318 PRIMARY KEY (`VNF_TYPE`,`CONTROLLER_NAME`,`ACTION_CATEGORY`)
319 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
320 /*!40101 SET character_set_client = @saved_cs_client */;
323 -- Table structure for table `cvnfc_configuration_customization`
326 DROP TABLE IF EXISTS `cvnfc_configuration_customization`;
327 /*!40101 SET @saved_cs_client = @@character_set_client */;
328 /*!40101 SET character_set_client = utf8 */;
329 CREATE TABLE `cvnfc_configuration_customization` (
330 `ID` int(11) NOT NULL AUTO_INCREMENT,
331 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
332 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
333 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
334 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
335 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
336 `POLICY_NAME` varchar(200) DEFAULT NULL,
337 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
338 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
339 `CVNFC_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
341 KEY `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
342 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
343 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
344 /*!40101 SET character_set_client = @saved_cs_client */;
347 -- Table structure for table `cvnfc_customization`
350 DROP TABLE IF EXISTS `cvnfc_customization`;
351 /*!40101 SET @saved_cs_client = @@character_set_client */;
352 /*!40101 SET character_set_client = utf8 */;
353 CREATE TABLE `cvnfc_customization` (
354 `ID` int(11) NOT NULL AUTO_INCREMENT,
355 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
356 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
357 `MODEL_UUID` varchar(200) NOT NULL,
358 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
359 `MODEL_VERSION` varchar(20) NOT NULL,
360 `MODEL_NAME` varchar(200) NOT NULL,
361 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
362 `DESCRIPTION` varchar(1200) DEFAULT NULL,
363 `NFC_FUNCTION` varchar(200) DEFAULT NULL,
364 `NFC_NAMING_CODE` varchar(200) DEFAULT NULL,
365 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
366 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
367 `VF_MODULE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
369 KEY `fk_cvnfc_customization__vnfc_customization1_idx` (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`),
370 KEY `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID`),
371 KEY `fk_cvnfc_customization_to_vf_module_resource_customization` (`VF_MODULE_CUSTOMIZATION_ID`),
372 CONSTRAINT `fk_cvnfc_customization__vnfc_customization1` FOREIGN KEY (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`) REFERENCES `vnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
373 CONSTRAINT `fk_cvnfc_customization_to_vf_module_resource_customization` FOREIGN KEY (`VF_MODULE_CUSTOMIZATION_ID`) REFERENCES `vf_module_customization` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
374 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
375 /*!40101 SET character_set_client = @saved_cs_client */;
378 -- Table structure for table `external_service_to_internal_model_mapping`
381 DROP TABLE IF EXISTS `external_service_to_internal_model_mapping`;
382 /*!40101 SET @saved_cs_client = @@character_set_client */;
383 /*!40101 SET character_set_client = utf8 */;
384 CREATE TABLE `external_service_to_internal_model_mapping` (
385 `id` int(11) NOT NULL AUTO_INCREMENT,
386 `SERVICE_NAME` varchar(200) NOT NULL,
387 `PRODUCT_FLAVOR` varchar(200) DEFAULT NULL,
388 `SUBSCRIPTION_SERVICE_TYPE` varchar(200) NOT NULL,
389 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
391 UNIQUE KEY `UK_external_service_to_internal_model_mapping` (`SERVICE_NAME`,`PRODUCT_FLAVOR`,`SERVICE_MODEL_UUID`)
392 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
393 /*!40101 SET character_set_client = @saved_cs_client */;
396 -- Table structure for table `flyway_schema_history`
399 DROP TABLE IF EXISTS `flyway_schema_history`;
400 /*!40101 SET @saved_cs_client = @@character_set_client */;
401 /*!40101 SET character_set_client = utf8 */;
402 CREATE TABLE `flyway_schema_history` (
403 `installed_rank` int(11) NOT NULL,
404 `version` varchar(50) DEFAULT NULL,
405 `description` varchar(200) NOT NULL,
406 `type` varchar(20) NOT NULL,
407 `script` varchar(1000) NOT NULL,
408 `checksum` int(11) DEFAULT NULL,
409 `installed_by` varchar(100) NOT NULL,
410 `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
411 `execution_time` int(11) NOT NULL,
412 `success` tinyint(1) NOT NULL,
413 PRIMARY KEY (`installed_rank`),
414 KEY `flyway_schema_history_s_idx` (`success`)
415 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
416 /*!40101 SET character_set_client = @saved_cs_client */;
419 -- Table structure for table `heat_environment`
422 DROP TABLE IF EXISTS `heat_environment`;
423 /*!40101 SET @saved_cs_client = @@character_set_client */;
424 /*!40101 SET character_set_client = utf8 */;
425 CREATE TABLE `heat_environment` (
426 `ARTIFACT_UUID` varchar(200) NOT NULL,
427 `NAME` varchar(100) NOT NULL,
428 `VERSION` varchar(20) NOT NULL,
429 `DESCRIPTION` varchar(1200) DEFAULT NULL,
430 `BODY` longtext NOT NULL,
431 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
432 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
433 PRIMARY KEY (`ARTIFACT_UUID`)
434 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
435 /*!40101 SET character_set_client = @saved_cs_client */;
438 -- Table structure for table `heat_files`
441 DROP TABLE IF EXISTS `heat_files`;
442 /*!40101 SET @saved_cs_client = @@character_set_client */;
443 /*!40101 SET character_set_client = utf8 */;
444 CREATE TABLE `heat_files` (
445 `ARTIFACT_UUID` varchar(200) NOT NULL,
446 `NAME` varchar(200) NOT NULL,
447 `VERSION` varchar(20) NOT NULL,
448 `DESCRIPTION` varchar(1200) DEFAULT NULL,
449 `BODY` longtext NOT NULL,
450 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
451 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
452 PRIMARY KEY (`ARTIFACT_UUID`)
453 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
454 /*!40101 SET character_set_client = @saved_cs_client */;
457 -- Table structure for table `heat_nested_template`
460 DROP TABLE IF EXISTS `heat_nested_template`;
461 /*!40101 SET @saved_cs_client = @@character_set_client */;
462 /*!40101 SET character_set_client = utf8 */;
463 CREATE TABLE `heat_nested_template` (
464 `PARENT_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
465 `CHILD_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
466 `PROVIDER_RESOURCE_FILE` varchar(100) DEFAULT NULL,
467 PRIMARY KEY (`PARENT_HEAT_TEMPLATE_UUID`,`CHILD_HEAT_TEMPLATE_UUID`),
468 KEY `fk_heat_nested_template__heat_template2_idx` (`CHILD_HEAT_TEMPLATE_UUID`),
469 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,
470 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
471 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
472 /*!40101 SET character_set_client = @saved_cs_client */;
475 -- Table structure for table `heat_template`
478 DROP TABLE IF EXISTS `heat_template`;
479 /*!40101 SET @saved_cs_client = @@character_set_client */;
480 /*!40101 SET character_set_client = utf8 */;
481 CREATE TABLE `heat_template` (
482 `ARTIFACT_UUID` varchar(200) NOT NULL,
483 `NAME` varchar(200) NOT NULL,
484 `VERSION` varchar(20) NOT NULL,
485 `DESCRIPTION` varchar(1200) DEFAULT NULL,
486 `BODY` longtext NOT NULL,
487 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
488 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
489 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
490 PRIMARY KEY (`ARTIFACT_UUID`)
491 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
492 /*!40101 SET character_set_client = @saved_cs_client */;
495 -- Table structure for table `heat_template_params`
498 DROP TABLE IF EXISTS `heat_template_params`;
499 /*!40101 SET @saved_cs_client = @@character_set_client */;
500 /*!40101 SET character_set_client = utf8 */;
501 CREATE TABLE `heat_template_params` (
502 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NOT NULL,
503 `PARAM_NAME` varchar(100) NOT NULL,
504 `IS_REQUIRED` bit(1) NOT NULL,
505 `PARAM_TYPE` varchar(20) DEFAULT NULL,
506 `PARAM_ALIAS` varchar(45) DEFAULT NULL,
507 PRIMARY KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`,`PARAM_NAME`),
508 CONSTRAINT `fk_heat_template_params__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
509 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
510 /*!40101 SET character_set_client = @saved_cs_client */;
513 -- Table structure for table `identity_services`
516 DROP TABLE IF EXISTS `identity_services`;
517 /*!40101 SET @saved_cs_client = @@character_set_client */;
518 /*!40101 SET character_set_client = utf8 */;
519 CREATE TABLE `identity_services` (
520 `ID` varchar(50) NOT NULL,
521 `IDENTITY_URL` varchar(200) DEFAULT NULL,
522 `MSO_ID` varchar(255) DEFAULT NULL,
523 `MSO_PASS` varchar(255) DEFAULT NULL,
524 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
525 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
526 `TENANT_METADATA` tinyint(1) DEFAULT '0',
527 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
528 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
529 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
530 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
531 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
532 `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL,
533 `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL,
535 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
536 /*!40101 SET character_set_client = @saved_cs_client */;
539 -- Table structure for table `instance_group`
542 DROP TABLE IF EXISTS `instance_group`;
543 /*!40101 SET @saved_cs_client = @@character_set_client */;
544 /*!40101 SET character_set_client = utf8 */;
545 CREATE TABLE `instance_group` (
546 `MODEL_UUID` varchar(200) NOT NULL,
547 `MODEL_NAME` varchar(200) NOT NULL,
548 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
549 `MODEL_VERSION` varchar(20) NOT NULL,
550 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
551 `ROLE` varchar(200) NOT NULL,
552 `OBJECT_TYPE` varchar(200) NOT NULL,
553 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
554 `CR_MODEL_UUID` varchar(200) DEFAULT NULL,
555 `INSTANCE_GROUP_TYPE` varchar(200) NOT NULL,
556 PRIMARY KEY (`MODEL_UUID`),
557 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`)
558 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
559 /*!40101 SET character_set_client = @saved_cs_client */;
562 -- Table structure for table `model`
565 DROP TABLE IF EXISTS `model`;
566 /*!40101 SET @saved_cs_client = @@character_set_client */;
567 /*!40101 SET character_set_client = utf8 */;
568 CREATE TABLE `model` (
569 `ID` int(11) NOT NULL AUTO_INCREMENT,
570 `MODEL_CUSTOMIZATION_ID` varchar(40) DEFAULT NULL,
571 `MODEL_CUSTOMIZATION_NAME` varchar(40) DEFAULT NULL,
572 `MODEL_INVARIANT_ID` varchar(40) DEFAULT NULL,
573 `MODEL_NAME` varchar(40) DEFAULT NULL,
574 `MODEL_TYPE` varchar(20) DEFAULT NULL,
575 `MODEL_VERSION` varchar(20) DEFAULT NULL,
576 `MODEL_VERSION_ID` varchar(40) DEFAULT NULL,
577 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
578 `RECIPE` int(11) DEFAULT NULL,
580 UNIQUE KEY `uk1_model` (`MODEL_TYPE`,`MODEL_VERSION_ID`),
581 KEY `RECIPE` (`RECIPE`),
582 CONSTRAINT `model_ibfk_1` FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
583 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
584 /*!40101 SET character_set_client = @saved_cs_client */;
587 -- Table structure for table `model_recipe`
590 DROP TABLE IF EXISTS `model_recipe`;
591 /*!40101 SET @saved_cs_client = @@character_set_client */;
592 /*!40101 SET character_set_client = utf8 */;
593 CREATE TABLE `model_recipe` (
594 `ID` int(11) NOT NULL AUTO_INCREMENT,
595 `MODEL_ID` int(11) DEFAULT NULL,
596 `ACTION` varchar(40) DEFAULT NULL,
597 `SCHEMA_VERSION` varchar(40) DEFAULT NULL,
598 `DESCRIPTION` varchar(40) DEFAULT NULL,
599 `ORCHESTRATION_URI` varchar(20) DEFAULT NULL,
600 `MODEL_PARAM_XSD` varchar(20) DEFAULT NULL,
601 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
602 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
604 UNIQUE KEY `uk1_model_recipe` (`MODEL_ID`,`ACTION`)
605 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
606 /*!40101 SET character_set_client = @saved_cs_client */;
609 -- Table structure for table `network_recipe`
612 DROP TABLE IF EXISTS `network_recipe`;
613 /*!40101 SET @saved_cs_client = @@character_set_client */;
614 /*!40101 SET character_set_client = utf8 */;
615 CREATE TABLE `network_recipe` (
616 `id` int(11) NOT NULL AUTO_INCREMENT,
617 `MODEL_NAME` varchar(20) NOT NULL,
618 `ACTION` varchar(50) NOT NULL,
619 `DESCRIPTION` varchar(1200) DEFAULT NULL,
620 `ORCHESTRATION_URI` varchar(256) NOT NULL,
621 `NETWORK_PARAM_XSD` varchar(2048) DEFAULT NULL,
622 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
623 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
624 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
625 `VERSION_STR` varchar(20) NOT NULL,
626 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
627 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
629 UNIQUE KEY `UK_rl4f296i0p8lyokxveaiwkayi` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
630 ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
631 /*!40101 SET character_set_client = @saved_cs_client */;
634 -- Table structure for table `network_resource`
637 DROP TABLE IF EXISTS `network_resource`;
638 /*!40101 SET @saved_cs_client = @@character_set_client */;
639 /*!40101 SET character_set_client = utf8 */;
640 CREATE TABLE `network_resource` (
641 `MODEL_UUID` varchar(200) NOT NULL,
642 `MODEL_NAME` varchar(200) NOT NULL,
643 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
644 `DESCRIPTION` varchar(1200) DEFAULT NULL,
645 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
646 `NEUTRON_NETWORK_TYPE` varchar(20) DEFAULT NULL,
647 `MODEL_VERSION` varchar(20) DEFAULT NULL,
648 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
649 `AIC_VERSION_MIN` varchar(20) NULL,
650 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
651 `ORCHESTRATION_MODE` varchar(20) DEFAULT 'HEAT',
652 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
653 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
654 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
655 PRIMARY KEY (`MODEL_UUID`),
656 KEY `fk_network_resource__temp_network_heat_template_lookup1_idx` (`MODEL_NAME`),
657 KEY `fk_network_resource__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
658 CONSTRAINT `fk_network_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE NO ACTION ON UPDATE CASCADE,
659 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
660 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
661 /*!40101 SET character_set_client = @saved_cs_client */;
664 -- Table structure for table `network_resource_customization`
667 DROP TABLE IF EXISTS `network_resource_customization`;
668 /*!40101 SET @saved_cs_client = @@character_set_client */;
669 /*!40101 SET character_set_client = utf8 */;
670 CREATE TABLE `network_resource_customization` (
671 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
672 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
673 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
674 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
675 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
676 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
677 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
678 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
679 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
680 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
681 KEY `fk_network_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
682 CONSTRAINT `fk_network_resource_customization__network_resource1` FOREIGN KEY (`NETWORK_RESOURCE_MODEL_UUID`) REFERENCES `network_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
683 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
684 /*!40101 SET character_set_client = @saved_cs_client */;
687 -- Table structure for table `network_resource_customization_to_service`
690 DROP TABLE IF EXISTS `network_resource_customization_to_service`;
691 /*!40101 SET @saved_cs_client = @@character_set_client */;
692 /*!40101 SET character_set_client = utf8 */;
693 CREATE TABLE `network_resource_customization_to_service` (
694 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
695 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
696 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
697 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
698 CONSTRAINT `network_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
699 CONSTRAINT `network_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `network_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
700 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
701 /*!40101 SET character_set_client = @saved_cs_client */;
704 -- Table structure for table `northbound_request_ref_lookup`
707 DROP TABLE IF EXISTS `northbound_request_ref_lookup`;
708 /*!40101 SET @saved_cs_client = @@character_set_client */;
709 /*!40101 SET character_set_client = utf8 */;
710 CREATE TABLE `northbound_request_ref_lookup` (
711 `id` int(11) NOT NULL AUTO_INCREMENT,
712 `REQUEST_SCOPE` varchar(200) NOT NULL,
713 `MACRO_ACTION` varchar(200) NOT NULL,
714 `ACTION` varchar(200) NOT NULL,
715 `IS_ALACARTE` tinyint(1) NOT NULL DEFAULT '0',
716 `MIN_API_VERSION` double NOT NULL,
717 `MAX_API_VERSION` double DEFAULT NULL,
718 `IS_TOPLEVELFLOW` tinyint(1) DEFAULT NULL,
719 `CLOUD_OWNER` varchar(200) NOT NULL,
721 UNIQUE KEY `UK_northbound_request_ref_lookup` (`MIN_API_VERSION`,`REQUEST_SCOPE`,`ACTION`,`IS_ALACARTE`,`MACRO_ACTION`,`CLOUD_OWNER`)
722 ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;
723 /*!40101 SET character_set_client = @saved_cs_client */;
726 -- Table structure for table `orchestration_flow_reference`
729 DROP TABLE IF EXISTS `orchestration_flow_reference`;
730 /*!40101 SET @saved_cs_client = @@character_set_client */;
731 /*!40101 SET character_set_client = utf8 */;
732 CREATE TABLE `orchestration_flow_reference` (
733 `id` int(11) NOT NULL AUTO_INCREMENT,
734 `COMPOSITE_ACTION` varchar(200) NOT NULL,
735 `SEQ_NO` int(11) NOT NULL,
736 `FLOW_NAME` varchar(200) NOT NULL,
737 `FLOW_VERSION` double NOT NULL,
738 `NB_REQ_REF_LOOKUP_ID` int(11) NOT NULL,
740 UNIQUE KEY `UK_orchestration_flow_reference` (`COMPOSITE_ACTION`,`FLOW_NAME`,`SEQ_NO`,`NB_REQ_REF_LOOKUP_ID`),
741 KEY `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID`),
742 KEY `fk_orchestration_flow_reference__building_block_detail` (`FLOW_NAME`),
743 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1` FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
744 ) ENGINE=InnoDB AUTO_INCREMENT=398 DEFAULT CHARSET=latin1;
745 /*!40101 SET character_set_client = @saved_cs_client */;
748 -- Table structure for table `orchestration_status_state_transition_directive`
751 DROP TABLE IF EXISTS `orchestration_status_state_transition_directive`;
752 /*!40101 SET @saved_cs_client = @@character_set_client */;
753 /*!40101 SET character_set_client = utf8 */;
754 CREATE TABLE `orchestration_status_state_transition_directive` (
755 `id` int(11) NOT NULL AUTO_INCREMENT,
756 `RESOURCE_TYPE` varchar(25) NOT NULL,
757 `ORCHESTRATION_STATUS` varchar(25) NOT NULL,
758 `TARGET_ACTION` varchar(25) NOT NULL,
759 `FLOW_DIRECTIVE` varchar(25) NOT NULL,
761 UNIQUE KEY `UK_orchestration_status_state_transition_directive` (`RESOURCE_TYPE`,`ORCHESTRATION_STATUS`,`TARGET_ACTION`)
762 ) ENGINE=InnoDB AUTO_INCREMENT=686 DEFAULT CHARSET=latin1;
763 /*!40101 SET character_set_client = @saved_cs_client */;
766 -- Table structure for table `rainy_day_handler_macro`
769 DROP TABLE IF EXISTS `rainy_day_handler_macro`;
770 /*!40101 SET @saved_cs_client = @@character_set_client */;
771 /*!40101 SET character_set_client = utf8 */;
772 CREATE TABLE `rainy_day_handler_macro` (
773 `id` int(11) NOT NULL AUTO_INCREMENT,
774 `FLOW_NAME` varchar(200) NOT NULL,
775 `SERVICE_TYPE` varchar(200) NOT NULL,
776 `VNF_TYPE` varchar(200) NOT NULL,
777 `ERROR_CODE` varchar(200) NOT NULL,
778 `WORK_STEP` varchar(200) NOT NULL,
779 `POLICY` varchar(200) NOT NULL,
780 `SECONDARY_POLICY` varchar(200) DEFAULT NULL,
782 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
783 /*!40101 SET character_set_client = @saved_cs_client */;
786 -- Table structure for table `service`
789 DROP TABLE IF EXISTS `service`;
790 /*!40101 SET @saved_cs_client = @@character_set_client */;
791 /*!40101 SET character_set_client = utf8 */;
792 CREATE TABLE `service` (
793 `MODEL_UUID` varchar(200) NOT NULL,
794 `MODEL_NAME` varchar(200) NOT NULL,
795 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
796 `MODEL_VERSION` varchar(20) NOT NULL,
797 `DESCRIPTION` varchar(1200) DEFAULT NULL,
798 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
799 `TOSCA_CSAR_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
800 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
801 `SERVICE_ROLE` varchar(200) DEFAULT NULL,
802 `ENVIRONMENT_CONTEXT` varchar(200) DEFAULT NULL,
803 `WORKLOAD_CONTEXT` varchar(200) DEFAULT NULL,
804 `SERVICE_CATEGORY` varchar(200) DEFAULT NULL,
805 `RESOURCE_ORDER` varchar(200) default NULL,
806 PRIMARY KEY (`MODEL_UUID`),
807 KEY `fk_service__tosca_csar1_idx` (`TOSCA_CSAR_ARTIFACT_UUID`),
808 CONSTRAINT `fk_service__tosca_csar1` FOREIGN KEY (`TOSCA_CSAR_ARTIFACT_UUID`) REFERENCES `tosca_csar` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
809 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
810 /*!40101 SET character_set_client = @saved_cs_client */;
813 -- Table structure for table `service_proxy_customization`
816 DROP TABLE IF EXISTS `service_proxy_customization`;
817 /*!40101 SET @saved_cs_client = @@character_set_client */;
818 /*!40101 SET character_set_client = utf8 */;
819 CREATE TABLE `service_proxy_customization` (
820 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
821 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
822 `MODEL_UUID` varchar(200) NOT NULL,
823 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
824 `MODEL_VERSION` varchar(20) NOT NULL,
825 `MODEL_NAME` varchar(200) NOT NULL,
826 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
827 `DESCRIPTION` varchar(1200) DEFAULT NULL,
828 `SOURCE_SERVICE_MODEL_UUID` varchar(200) NOT NULL,
829 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
830 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
831 KEY `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID`),
832 CONSTRAINT `fk_service_proxy_resource_customization__service1` FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
833 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
834 /*!40101 SET character_set_client = @saved_cs_client */;
837 -- Table structure for table `service_proxy_customization_to_service`
840 DROP TABLE IF EXISTS `service_proxy_customization_to_service`;
841 /*!40101 SET @saved_cs_client = @@character_set_client */;
842 /*!40101 SET character_set_client = utf8 */;
843 CREATE TABLE `service_proxy_customization_to_service` (
844 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
845 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
846 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
847 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
848 /*!40101 SET character_set_client = @saved_cs_client */;
851 -- Table structure for table `service_recipe`
854 DROP TABLE IF EXISTS `service_recipe`;
855 /*!40101 SET @saved_cs_client = @@character_set_client */;
856 /*!40101 SET character_set_client = utf8 */;
857 CREATE TABLE `service_recipe` (
858 `id` int(11) NOT NULL AUTO_INCREMENT,
859 `ACTION` varchar(50) NOT NULL,
860 `VERSION_STR` varchar(20) DEFAULT NULL,
861 `DESCRIPTION` varchar(1200) DEFAULT NULL,
862 `ORCHESTRATION_URI` varchar(256) NOT NULL,
863 `SERVICE_PARAM_XSD` varchar(2048) DEFAULT NULL,
864 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
865 `SERVICE_TIMEOUT_INTERIM` int(11) DEFAULT NULL,
866 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
867 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
869 UNIQUE KEY `UK_7fav5dkux2v8g9d2i5ymudlgc` (`SERVICE_MODEL_UUID`,`ACTION`),
870 KEY `fk_service_recipe__service1_idx` (`SERVICE_MODEL_UUID`),
871 CONSTRAINT `fk_service_recipe__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
872 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
873 /*!40101 SET character_set_client = @saved_cs_client */;
876 -- Table structure for table `temp_network_heat_template_lookup`
879 DROP TABLE IF EXISTS `temp_network_heat_template_lookup`;
880 /*!40101 SET @saved_cs_client = @@character_set_client */;
881 /*!40101 SET character_set_client = utf8 */;
882 CREATE TABLE `temp_network_heat_template_lookup` (
883 `NETWORK_RESOURCE_MODEL_NAME` varchar(200) NOT NULL,
884 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
885 `AIC_VERSION_MIN` varchar(20) NULL,
886 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
887 PRIMARY KEY (`NETWORK_RESOURCE_MODEL_NAME`),
888 KEY `fk_temp_network_heat_template_lookup__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
889 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
890 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
891 /*!40101 SET character_set_client = @saved_cs_client */;
894 -- Table structure for table `tosca_csar`
897 DROP TABLE IF EXISTS `tosca_csar`;
898 /*!40101 SET @saved_cs_client = @@character_set_client */;
899 /*!40101 SET character_set_client = utf8 */;
900 CREATE TABLE `tosca_csar` (
901 `ARTIFACT_UUID` varchar(200) NOT NULL,
902 `NAME` varchar(200) NOT NULL,
903 `VERSION` varchar(20) NOT NULL,
904 `DESCRIPTION` varchar(1200) DEFAULT NULL,
905 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL,
906 `URL` varchar(200) NOT NULL,
907 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
908 PRIMARY KEY (`ARTIFACT_UUID`)
909 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
910 /*!40101 SET character_set_client = @saved_cs_client */;
913 -- Table structure for table `vf_module`
916 DROP TABLE IF EXISTS `vf_module`;
917 /*!40101 SET @saved_cs_client = @@character_set_client */;
918 /*!40101 SET character_set_client = utf8 */;
919 CREATE TABLE `vf_module` (
920 `MODEL_UUID` varchar(200) NOT NULL,
921 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
922 `MODEL_VERSION` varchar(20) NOT NULL,
923 `MODEL_NAME` varchar(200) NOT NULL,
924 `DESCRIPTION` varchar(1200) DEFAULT NULL,
925 `IS_BASE` tinyint(1) NOT NULL,
926 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
927 `VOL_HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
928 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
929 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
930 PRIMARY KEY (`MODEL_UUID`,`VNF_RESOURCE_MODEL_UUID`),
931 KEY `fk_vf_module__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
932 KEY `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
933 KEY `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`VOL_HEAT_TEMPLATE_ARTIFACT_UUID`),
934 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,
935 CONSTRAINT `fk_vf_module__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
936 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
937 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
938 /*!40101 SET character_set_client = @saved_cs_client */;
941 -- Table structure for table `vf_module_customization`
944 DROP TABLE IF EXISTS `vf_module_customization`;
945 /*!40101 SET @saved_cs_client = @@character_set_client */;
946 /*!40101 SET character_set_client = utf8 */;
947 CREATE TABLE `vf_module_customization` (
948 `ID` int(13) NOT NULL AUTO_INCREMENT,
949 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
950 `LABEL` varchar(200) DEFAULT NULL,
951 `INITIAL_COUNT` int(11) DEFAULT '0',
952 `MIN_INSTANCES` int(11) DEFAULT '0',
953 `MAX_INSTANCES` int(11) DEFAULT NULL,
954 `AVAILABILITY_ZONE_COUNT` int(11) DEFAULT NULL,
955 `HEAT_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
956 `VOL_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
957 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
958 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
959 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
961 KEY `fk_vf_module_customization__vf_module1_idx` (`VF_MODULE_MODEL_UUID`),
962 KEY `fk_vf_module_customization__heat_env__heat_environment1_idx` (`HEAT_ENVIRONMENT_ARTIFACT_UUID`),
963 KEY `fk_vf_module_customization__vol_env__heat_environment2_idx` (`VOL_ENVIRONMENT_ARTIFACT_UUID`),
964 KEY `fk_vf_module_customization_to_vnf_resource_customization` (`VNF_RESOURCE_CUSTOMIZATION_ID`),
965 KEY `vf_module_customization_model_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
966 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,
967 CONSTRAINT `fk_vf_module_customization__vf_module1` FOREIGN KEY (`VF_MODULE_MODEL_UUID`) REFERENCES `vf_module` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
968 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,
969 CONSTRAINT `fk_vf_module_customization_to_vnf_resource_customization` FOREIGN KEY (`VNF_RESOURCE_CUSTOMIZATION_ID`) REFERENCES `vnf_resource_customization` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
970 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
971 /*!40101 SET character_set_client = @saved_cs_client */;
974 -- Table structure for table `vf_module_to_heat_files`
977 DROP TABLE IF EXISTS `vf_module_to_heat_files`;
978 /*!40101 SET @saved_cs_client = @@character_set_client */;
979 /*!40101 SET character_set_client = utf8 */;
980 CREATE TABLE `vf_module_to_heat_files` (
981 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
982 `HEAT_FILES_ARTIFACT_UUID` varchar(200) NOT NULL,
983 PRIMARY KEY (`VF_MODULE_MODEL_UUID`,`HEAT_FILES_ARTIFACT_UUID`),
984 KEY `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`HEAT_FILES_ARTIFACT_UUID`),
985 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,
986 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
987 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='il fait ce qu''il dit';
988 /*!40101 SET character_set_client = @saved_cs_client */;
991 -- Table structure for table `vnf_components`
994 DROP TABLE IF EXISTS `vnf_components`;
995 /*!40101 SET @saved_cs_client = @@character_set_client */;
996 /*!40101 SET character_set_client = utf8 */;
997 CREATE TABLE `vnf_components` (
998 `VNF_ID` int(11) NOT NULL,
999 `COMPONENT_TYPE` varchar(20) NOT NULL,
1000 `HEAT_TEMPLATE_ID` int(11) DEFAULT NULL,
1001 `HEAT_ENVIRONMENT_ID` int(11) DEFAULT NULL,
1002 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1003 PRIMARY KEY (`VNF_ID`,`COMPONENT_TYPE`)
1004 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1005 /*!40101 SET character_set_client = @saved_cs_client */;
1008 -- Table structure for table `vnf_components_recipe`
1011 DROP TABLE IF EXISTS `vnf_components_recipe`;
1012 /*!40101 SET @saved_cs_client = @@character_set_client */;
1013 /*!40101 SET character_set_client = utf8 */;
1014 CREATE TABLE `vnf_components_recipe` (
1015 `id` int(11) NOT NULL AUTO_INCREMENT,
1016 `VNF_TYPE` varchar(200) DEFAULT NULL,
1017 `VNF_COMPONENT_TYPE` varchar(45) NOT NULL,
1018 `ACTION` varchar(50) NOT NULL,
1019 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1020 `VERSION` varchar(20) NOT NULL,
1021 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1022 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1023 `VNF_COMPONENT_PARAM_XSD` varchar(2048) DEFAULT NULL,
1024 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1025 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1026 `VF_MODULE_MODEL_UUID` varchar(200) DEFAULT NULL,
1028 UNIQUE KEY `UK_4dpdwddaaclhc11wxsb7h59ma` (`VF_MODULE_MODEL_UUID`,`VNF_COMPONENT_TYPE`,`ACTION`,`VERSION`)
1029 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
1030 /*!40101 SET character_set_client = @saved_cs_client */;
1033 -- Table structure for table `vnf_recipe`
1036 DROP TABLE IF EXISTS `vnf_recipe`;
1037 /*!40101 SET @saved_cs_client = @@character_set_client */;
1038 /*!40101 SET character_set_client = utf8 */;
1039 CREATE TABLE `vnf_recipe` (
1040 `id` int(11) NOT NULL AUTO_INCREMENT,
1041 `NF_ROLE` varchar(200) DEFAULT NULL,
1042 `ACTION` varchar(50) NOT NULL,
1043 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1044 `VERSION_STR` varchar(20) NOT NULL,
1045 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1046 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1047 `VNF_PARAM_XSD` varchar(2048) DEFAULT NULL,
1048 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1049 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1050 `VF_MODULE_ID` varchar(100) DEFAULT NULL,
1052 UNIQUE KEY `UK_f3tvqau498vrifq3cr8qnigkr` (`VF_MODULE_ID`,`ACTION`,`VERSION_STR`)
1053 ) ENGINE=InnoDB AUTO_INCREMENT=10015 DEFAULT CHARSET=latin1;
1054 /*!40101 SET character_set_client = @saved_cs_client */;
1057 -- Table structure for table `vnf_resource`
1060 DROP TABLE IF EXISTS `vnf_resource`;
1061 /*!40101 SET @saved_cs_client = @@character_set_client */;
1062 /*!40101 SET character_set_client = utf8 */;
1063 CREATE TABLE `vnf_resource` (
1064 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
1065 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1066 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1067 `MODEL_UUID` varchar(200) NOT NULL,
1068 `AIC_VERSION_MIN` varchar(20) DEFAULT NULL,
1069 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
1070 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1071 `MODEL_VERSION` varchar(20) NOT NULL,
1072 `MODEL_NAME` varchar(200) DEFAULT NULL,
1073 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1074 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
1075 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1076 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1077 PRIMARY KEY (`MODEL_UUID`),
1078 KEY `fk_vnf_resource__heat_template1` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
1079 CONSTRAINT `fk_vnf_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1080 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1081 /*!40101 SET character_set_client = @saved_cs_client */;
1084 -- Table structure for table `vnf_resource_customization`
1087 DROP TABLE IF EXISTS `vnf_resource_customization`;
1088 /*!40101 SET @saved_cs_client = @@character_set_client */;
1089 /*!40101 SET character_set_client = utf8 */;
1090 CREATE TABLE `vnf_resource_customization` (
1091 `ID` int(13) NOT NULL AUTO_INCREMENT,
1092 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1093 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1094 `MIN_INSTANCES` int(11) DEFAULT NULL,
1095 `MAX_INSTANCES` int(11) DEFAULT NULL,
1096 `AVAILABILITY_ZONE_MAX_COUNT` int(11) DEFAULT NULL,
1097 `NF_TYPE` varchar(200) DEFAULT NULL,
1098 `NF_ROLE` varchar(200) DEFAULT NULL,
1099 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1100 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1101 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1102 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
1103 `CDS_BLUEPRINT_NAME` varchar(200) default null,
1104 `CDS_BLUEPRINT_VERSION` varchar(20) default null,
1105 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1106 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1107 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1108 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1110 UNIQUE KEY `UK_vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`,`SERVICE_MODEL_UUID`),
1111 KEY `fk_vnf_resource_customization__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
1112 KEY `fk_vnf_resource_customization_to_service` (`SERVICE_MODEL_UUID`),
1113 KEY `vnf_resource_customization_mod_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
1114 CONSTRAINT `fk_vnf_resource_customization__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1115 CONSTRAINT `fk_vnf_resource_customization_to_service` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1116 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1117 /*!40101 SET character_set_client = @saved_cs_client */;
1120 -- Table structure for table `vnfc_customization`
1123 DROP TABLE IF EXISTS `vnfc_customization`;
1124 /*!40101 SET @saved_cs_client = @@character_set_client */;
1125 /*!40101 SET character_set_client = utf8 */;
1126 CREATE TABLE `vnfc_customization` (
1127 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1128 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1129 `MODEL_UUID` varchar(200) NOT NULL,
1130 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
1131 `MODEL_VERSION` varchar(20) NOT NULL,
1132 `MODEL_NAME` varchar(200) NOT NULL,
1133 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
1134 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1135 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1136 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`)
1137 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1138 /*!40101 SET character_set_client = @saved_cs_client */;
1141 -- Table structure for table `vnfc_instance_group_customization`
1144 DROP TABLE IF EXISTS `vnfc_instance_group_customization`;
1145 /*!40101 SET @saved_cs_client = @@character_set_client */;
1146 /*!40101 SET character_set_client = utf8 */;
1147 CREATE TABLE `vnfc_instance_group_customization` (
1148 `ID` int(13) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1149 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) NOT NULL,
1150 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
1151 `FUNCTION` varchar(200) DEFAULT NULL,
1152 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1153 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1154 KEY `fk_vnfc_instance_group_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
1155 CONSTRAINT `fk_vnfc_instance_group_customization__instance_group1` FOREIGN KEY (`INSTANCE_GROUP_MODEL_UUID`) REFERENCES `instance_group` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1156 CONSTRAINT `fk_vnfc_instance_group_customization_vnf_customization` FOREIGN KEY (`VNF_RESOURCE_CUSTOMIZATION_ID`) REFERENCES `vnf_resource_customization` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
1157 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1158 set foreign_key_checks=1;
1160 CREATE TABLE IF NOT EXISTS `pnf_resource` (
1161 `ORCHESTRATION_MODE` varchar(20) DEFAULT NULL,
1162 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1163 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1164 `MODEL_UUID` varchar(200) NOT NULL,
1165 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1166 `MODEL_VERSION` varchar(20) NOT NULL,
1167 `MODEL_NAME` varchar(200) DEFAULT NULL,
1168 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1169 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1170 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1171 PRIMARY KEY (`MODEL_UUID`)
1172 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1174 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
1175 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1176 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1177 `NF_TYPE` varchar(200) DEFAULT NULL,
1178 `NF_ROLE` varchar(200) DEFAULT NULL,
1179 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1180 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1181 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1182 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1183 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1184 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
1185 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
1186 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
1187 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1188 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
1189 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
1190 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1191 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1193 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
1194 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1195 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1196 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
1197 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
1199 CREATE TABLE IF NOT EXISTS `workflow` (
1200 `ID` int(11) NOT NULL AUTO_INCREMENT,
1201 `ARTIFACT_UUID` varchar(200) NOT NULL,
1202 `ARTIFACT_NAME` varchar(200) NOT NULL,
1203 `NAME` varchar(200) NOT NULL,
1204 `OPERATION_NAME` varchar(200) DEFAULT NULL,
1205 `VERSION` double NOT NULL,
1206 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1207 `BODY` longtext DEFAULT NULL,
1208 `RESOURCE_TARGET` varchar(200) NOT NULL,
1209 `SOURCE` varchar(200) NOT NULL,
1210 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
1211 `ARTIFACT_CHECKSUM` varchar(200) DEFAULT 'MANUAL RECORD',
1212 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT current_timestamp(),
1214 UNIQUE KEY `UK_workflow` (`ARTIFACT_UUID`,`NAME`,`VERSION`,`SOURCE`)
1215 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1217 CREATE TABLE IF NOT EXISTS `vnf_resource_to_workflow` (
1218 `ID` int(11) NOT NULL AUTO_INCREMENT,
1219 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1220 `WORKFLOW_ID` int(11) NOT NULL,
1222 UNIQUE KEY `UK_vnf_resource_to_workflow` (`VNF_RESOURCE_MODEL_UUID`,`WORKFLOW_ID`),
1223 KEY `fk_vnf_resource_to_workflow__workflow1_idx` (`WORKFLOW_ID`),
1224 KEY `fk_vnf_resource_to_workflow__vnf_res_mod_uuid_idx` (`VNF_RESOURCE_MODEL_UUID`),
1225 CONSTRAINT `fk_vnf_resource_to_workflow__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1226 CONSTRAINT `fk_vnf_resource_to_workflow__workflow1` FOREIGN KEY (`WORKFLOW_ID`) REFERENCES `workflow` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
1227 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1229 CREATE TABLE IF NOT EXISTS `activity_spec` (
1230 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1231 `NAME` VARCHAR(200) NOT NULL,
1232 `DESCRIPTION` VARCHAR(1200) NOT NULL,
1233 `VERSION` DOUBLE NOT NULL,
1234 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1236 UNIQUE INDEX `UK_activity_spec` (`NAME` ASC, `VERSION` ASC))
1238 DEFAULT CHARACTER SET = latin1;
1240 CREATE TABLE IF NOT EXISTS `user_parameters` (
1241 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1242 `NAME` VARCHAR(200) NOT NULL,
1243 `PAYLOAD_LOCATION` VARCHAR(500) NULL,
1244 `LABEL` VARCHAR(200) NOT NULL,
1245 `TYPE` VARCHAR(200) NOT NULL,
1246 `DESCRIPTION` VARCHAR(1200) NULL,
1247 `IS_REQUIRED` TINYINT(1) NOT NULL,
1248 `MAX_LENGTH` INT(11) NULL,
1249 `ALLOWABLE_CHARS` VARCHAR(200) NULL,
1250 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1252 UNIQUE INDEX `UK_user_parameters` (`NAME` ASC))
1254 DEFAULT CHARACTER SET = latin1;
1256 CREATE TABLE IF NOT EXISTS `workflow_activity_spec_sequence` (
1257 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1258 `WORKFLOW_ID` INT(11) NOT NULL,
1259 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1260 `SEQ_NO` INT(11) NOT NULL,
1262 UNIQUE INDEX `UK_workflow_activity_spec_sequence` (`WORKFLOW_ID` ASC, `ACTIVITY_SPEC_ID` ASC, `SEQ_NO` ASC),
1263 INDEX `fk_workflow_activity_spec_sequence__activity_spec_idx` (`ACTIVITY_SPEC_ID` ASC),
1264 INDEX `fk_workflow_activity_spec_sequence__workflow_actifact_uuid_idx` (`WORKFLOW_ID` ASC),
1265 CONSTRAINT `fk_workflow_activity_spec_sequence__activity_spec1`
1266 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1267 REFERENCES `activity_spec` (`ID`)
1270 CONSTRAINT `fk_workflow_activity_spec_sequence__workflow1`
1271 FOREIGN KEY (`WORKFLOW_ID`)
1272 REFERENCES `workflow` (`ID`)
1276 DEFAULT CHARACTER SET = latin1;
1278 CREATE TABLE IF NOT EXISTS `activity_spec_parameters` (
1279 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1280 `NAME` VARCHAR(200) NOT NULL,
1281 `TYPE` VARCHAR(200) NOT NULL,
1282 `DIRECTION` VARCHAR(200) NULL,
1283 `DESCRIPTION` VARCHAR(1200) NULL,
1284 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1286 UNIQUE INDEX `UK_activity_spec_parameters` (`NAME` ASC, `DIRECTION` ASC))
1288 DEFAULT CHARACTER SET = latin1;
1290 CREATE TABLE IF NOT EXISTS `activity_spec_categories` (
1291 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1292 `NAME` VARCHAR(200) NOT NULL,
1294 UNIQUE INDEX `UK_activity_spec_categories` (`NAME` ASC))
1296 DEFAULT CHARACTER SET = latin1;
1298 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_categories` (
1299 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1300 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1301 `ACTIVITY_SPEC_CATEGORIES_ID` INT(11) NOT NULL,
1303 UNIQUE INDEX `UK_activity_spec_to_activity_spec_categories` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1304 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx` (`ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1305 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx1` (`ACTIVITY_SPEC_ID` ASC),
1306 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec1`
1307 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1308 REFERENCES `activity_spec` (`ID`)
1311 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec_c1`
1312 FOREIGN KEY (`ACTIVITY_SPEC_CATEGORIES_ID`)
1313 REFERENCES `activity_spec_categories` (`ID`)
1317 DEFAULT CHARACTER SET = latin1;
1319 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_parameters` (
1320 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1321 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1322 `ACTIVITY_SPEC_PARAMETERS_ID` INT(11) NOT NULL,
1324 INDEX `fk_activity_spec_to_activity_spec_params__act_sp_param_id_idx` (`ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1325 UNIQUE INDEX `UK_activity_spec_to_activity_spec_parameters` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1326 INDEX `fk_activity_spec_to_activity_spec_parameters__act_spec_id_idx` (`ACTIVITY_SPEC_ID` ASC),
1327 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activity_spec_1`
1328 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1329 REFERENCES `activity_spec` (`ID`)
1332 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activ_spec_param1`
1333 FOREIGN KEY (`ACTIVITY_SPEC_PARAMETERS_ID`)
1334 REFERENCES `activity_spec_parameters` (`ID`)
1338 DEFAULT CHARACTER SET = latin1;
1340 CREATE TABLE IF NOT EXISTS `activity_spec_to_user_parameters` (
1341 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1342 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1343 `USER_PARAMETERS_ID` INT(11) NOT NULL,
1345 UNIQUE INDEX `UK_activity_spec_to_user_parameters` (`ACTIVITY_SPEC_ID` ASC, `USER_PARAMETERS_ID` ASC),
1346 INDEX `fk_activity_spec_to_user_parameters__user_parameters1_idx` (`USER_PARAMETERS_ID` ASC),
1347 INDEX `fk_activity_spec_to_user_parameters__activity_spec1_idx` (`ACTIVITY_SPEC_ID` ASC),
1348 CONSTRAINT `fk_activity_spec_to_user_parameters__activity_spec1`
1349 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1350 REFERENCES `activity_spec` (`ID`)
1353 CONSTRAINT `fk_activity_spec_to_user_parameters__user_parameters1`
1354 FOREIGN KEY (`USER_PARAMETERS_ID`)
1355 REFERENCES `user_parameters` (`ID`)
1359 DEFAULT CHARACTER SET = latin1;