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 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
284 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
285 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
286 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
287 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
288 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
289 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
290 `SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
291 `CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
292 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
293 KEY `fk_configuration_customization__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
294 KEY `fk_configuration_customization__service_proxy_customization_idx` (`SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID`),
295 KEY `fk_configuration_customization__configuration_customization_idx` (`CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID`),
296 CONSTRAINT `fk_configuration_customization__configuration_customization1` FOREIGN KEY (`CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID`) REFERENCES `configuration_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
297 CONSTRAINT `fk_configuration_resource_customization__configuration_resour1` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
298 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
299 /*!40101 SET character_set_client = @saved_cs_client */;
302 -- Table structure for table `configuration_customization_to_service`
305 DROP TABLE IF EXISTS `configuration_customization_to_service`;
306 /*!40101 SET @saved_cs_client = @@character_set_client */;
307 /*!40101 SET character_set_client = utf8 */;
308 CREATE TABLE `configuration_customization_to_service` (
309 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
310 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
311 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
312 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
313 /*!40101 SET character_set_client = @saved_cs_client */;
316 -- Table structure for table `controller_selection_reference`
319 DROP TABLE IF EXISTS `controller_selection_reference`;
320 /*!40101 SET @saved_cs_client = @@character_set_client */;
321 /*!40101 SET character_set_client = utf8 */;
322 CREATE TABLE `controller_selection_reference` (
323 `VNF_TYPE` varchar(50) NOT NULL,
324 `CONTROLLER_NAME` varchar(100) NOT NULL,
325 `ACTION_CATEGORY` varchar(15) NOT NULL,
326 PRIMARY KEY (`VNF_TYPE`,`CONTROLLER_NAME`,`ACTION_CATEGORY`)
327 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
328 /*!40101 SET character_set_client = @saved_cs_client */;
331 -- Table structure for table `cvnfc_configuration_customization`
334 DROP TABLE IF EXISTS `cvnfc_configuration_customization`;
335 /*!40101 SET @saved_cs_client = @@character_set_client */;
336 /*!40101 SET character_set_client = utf8 */;
337 CREATE TABLE `cvnfc_configuration_customization` (
338 `ID` int(11) NOT NULL AUTO_INCREMENT,
339 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
340 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
341 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
342 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
343 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
344 `POLICY_NAME` varchar(200) DEFAULT NULL,
345 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
346 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
347 `CVNFC_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
349 KEY `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
350 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
351 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
352 /*!40101 SET character_set_client = @saved_cs_client */;
355 -- Table structure for table `cvnfc_customization`
358 DROP TABLE IF EXISTS `cvnfc_customization`;
359 /*!40101 SET @saved_cs_client = @@character_set_client */;
360 /*!40101 SET character_set_client = utf8 */;
361 CREATE TABLE `cvnfc_customization` (
362 `ID` int(11) NOT NULL AUTO_INCREMENT,
363 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
364 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
365 `MODEL_UUID` varchar(200) NOT NULL,
366 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
367 `MODEL_VERSION` varchar(20) NOT NULL,
368 `MODEL_NAME` varchar(200) NOT NULL,
369 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
370 `DESCRIPTION` varchar(1200) DEFAULT NULL,
371 `NFC_FUNCTION` varchar(200) DEFAULT NULL,
372 `NFC_NAMING_CODE` varchar(200) DEFAULT NULL,
373 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
374 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
375 `VF_MODULE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
377 KEY `fk_cvnfc_customization__vnfc_customization1_idx` (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`),
378 KEY `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID`),
379 KEY `fk_cvnfc_customization_to_vf_module_resource_customization` (`VF_MODULE_CUSTOMIZATION_ID`),
380 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,
381 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
382 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
383 /*!40101 SET character_set_client = @saved_cs_client */;
386 -- Table structure for table `external_service_to_internal_model_mapping`
389 DROP TABLE IF EXISTS `external_service_to_internal_model_mapping`;
390 /*!40101 SET @saved_cs_client = @@character_set_client */;
391 /*!40101 SET character_set_client = utf8 */;
392 CREATE TABLE `external_service_to_internal_model_mapping` (
393 `id` int(11) NOT NULL AUTO_INCREMENT,
394 `SERVICE_NAME` varchar(200) NOT NULL,
395 `PRODUCT_FLAVOR` varchar(200) DEFAULT NULL,
396 `SUBSCRIPTION_SERVICE_TYPE` varchar(200) NOT NULL,
397 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
399 UNIQUE KEY `UK_external_service_to_internal_model_mapping` (`SERVICE_NAME`,`PRODUCT_FLAVOR`,`SERVICE_MODEL_UUID`)
400 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
401 /*!40101 SET character_set_client = @saved_cs_client */;
404 -- Table structure for table `flyway_schema_history`
407 DROP TABLE IF EXISTS `flyway_schema_history`;
408 /*!40101 SET @saved_cs_client = @@character_set_client */;
409 /*!40101 SET character_set_client = utf8 */;
410 CREATE TABLE `flyway_schema_history` (
411 `installed_rank` int(11) NOT NULL,
412 `version` varchar(50) DEFAULT NULL,
413 `description` varchar(200) NOT NULL,
414 `type` varchar(20) NOT NULL,
415 `script` varchar(1000) NOT NULL,
416 `checksum` int(11) DEFAULT NULL,
417 `installed_by` varchar(100) NOT NULL,
418 `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
419 `execution_time` int(11) NOT NULL,
420 `success` tinyint(1) NOT NULL,
421 PRIMARY KEY (`installed_rank`),
422 KEY `flyway_schema_history_s_idx` (`success`)
423 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
424 /*!40101 SET character_set_client = @saved_cs_client */;
427 -- Table structure for table `heat_environment`
430 DROP TABLE IF EXISTS `heat_environment`;
431 /*!40101 SET @saved_cs_client = @@character_set_client */;
432 /*!40101 SET character_set_client = utf8 */;
433 CREATE TABLE `heat_environment` (
434 `ARTIFACT_UUID` varchar(200) NOT NULL,
435 `NAME` varchar(100) NOT NULL,
436 `VERSION` varchar(20) NOT NULL,
437 `DESCRIPTION` varchar(1200) DEFAULT NULL,
438 `BODY` longtext NOT NULL,
439 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
440 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
441 PRIMARY KEY (`ARTIFACT_UUID`)
442 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
443 /*!40101 SET character_set_client = @saved_cs_client */;
446 -- Table structure for table `heat_files`
449 DROP TABLE IF EXISTS `heat_files`;
450 /*!40101 SET @saved_cs_client = @@character_set_client */;
451 /*!40101 SET character_set_client = utf8 */;
452 CREATE TABLE `heat_files` (
453 `ARTIFACT_UUID` varchar(200) NOT NULL,
454 `NAME` varchar(200) NOT NULL,
455 `VERSION` varchar(20) NOT NULL,
456 `DESCRIPTION` varchar(1200) DEFAULT NULL,
457 `BODY` longtext NOT NULL,
458 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
459 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
460 PRIMARY KEY (`ARTIFACT_UUID`)
461 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
462 /*!40101 SET character_set_client = @saved_cs_client */;
465 -- Table structure for table `heat_nested_template`
468 DROP TABLE IF EXISTS `heat_nested_template`;
469 /*!40101 SET @saved_cs_client = @@character_set_client */;
470 /*!40101 SET character_set_client = utf8 */;
471 CREATE TABLE `heat_nested_template` (
472 `PARENT_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
473 `CHILD_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
474 `PROVIDER_RESOURCE_FILE` varchar(100) DEFAULT NULL,
475 PRIMARY KEY (`PARENT_HEAT_TEMPLATE_UUID`,`CHILD_HEAT_TEMPLATE_UUID`),
476 KEY `fk_heat_nested_template__heat_template2_idx` (`CHILD_HEAT_TEMPLATE_UUID`),
477 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,
478 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
479 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
480 /*!40101 SET character_set_client = @saved_cs_client */;
483 -- Table structure for table `heat_template`
486 DROP TABLE IF EXISTS `heat_template`;
487 /*!40101 SET @saved_cs_client = @@character_set_client */;
488 /*!40101 SET character_set_client = utf8 */;
489 CREATE TABLE `heat_template` (
490 `ARTIFACT_UUID` varchar(200) NOT NULL,
491 `NAME` varchar(200) NOT NULL,
492 `VERSION` varchar(20) NOT NULL,
493 `DESCRIPTION` varchar(1200) DEFAULT NULL,
494 `BODY` longtext NOT NULL,
495 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
496 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
497 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
498 PRIMARY KEY (`ARTIFACT_UUID`)
499 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
500 /*!40101 SET character_set_client = @saved_cs_client */;
503 -- Table structure for table `heat_template_params`
506 DROP TABLE IF EXISTS `heat_template_params`;
507 /*!40101 SET @saved_cs_client = @@character_set_client */;
508 /*!40101 SET character_set_client = utf8 */;
509 CREATE TABLE `heat_template_params` (
510 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NOT NULL,
511 `PARAM_NAME` varchar(100) NOT NULL,
512 `IS_REQUIRED` bit(1) NOT NULL,
513 `PARAM_TYPE` varchar(20) DEFAULT NULL,
514 `PARAM_ALIAS` varchar(45) DEFAULT NULL,
515 PRIMARY KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`,`PARAM_NAME`),
516 CONSTRAINT `fk_heat_template_params__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
517 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
518 /*!40101 SET character_set_client = @saved_cs_client */;
521 -- Table structure for table `identity_services`
524 DROP TABLE IF EXISTS `identity_services`;
525 /*!40101 SET @saved_cs_client = @@character_set_client */;
526 /*!40101 SET character_set_client = utf8 */;
527 CREATE TABLE `identity_services` (
528 `ID` varchar(50) NOT NULL,
529 `IDENTITY_URL` varchar(200) DEFAULT NULL,
530 `MSO_ID` varchar(255) DEFAULT NULL,
531 `MSO_PASS` varchar(255) DEFAULT NULL,
532 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
533 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
534 `TENANT_METADATA` tinyint(1) DEFAULT '0',
535 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
536 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
537 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
538 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
539 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
540 `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL,
541 `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL,
543 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
544 /*!40101 SET character_set_client = @saved_cs_client */;
547 -- Table structure for table `instance_group`
550 DROP TABLE IF EXISTS `instance_group`;
551 /*!40101 SET @saved_cs_client = @@character_set_client */;
552 /*!40101 SET character_set_client = utf8 */;
553 CREATE TABLE `instance_group` (
554 `MODEL_UUID` varchar(200) NOT NULL,
555 `MODEL_NAME` varchar(200) NOT NULL,
556 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
557 `MODEL_VERSION` varchar(20) NOT NULL,
558 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
559 `ROLE` varchar(200) NOT NULL,
560 `OBJECT_TYPE` varchar(200) NOT NULL,
561 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
562 `CR_MODEL_UUID` varchar(200) DEFAULT NULL,
563 `INSTANCE_GROUP_TYPE` varchar(200) NOT NULL,
564 PRIMARY KEY (`MODEL_UUID`),
565 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`)
566 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
567 /*!40101 SET character_set_client = @saved_cs_client */;
570 -- Table structure for table `model`
573 DROP TABLE IF EXISTS `model`;
574 /*!40101 SET @saved_cs_client = @@character_set_client */;
575 /*!40101 SET character_set_client = utf8 */;
576 CREATE TABLE `model` (
577 `ID` int(11) NOT NULL AUTO_INCREMENT,
578 `MODEL_CUSTOMIZATION_ID` varchar(40) DEFAULT NULL,
579 `MODEL_CUSTOMIZATION_NAME` varchar(40) DEFAULT NULL,
580 `MODEL_INVARIANT_ID` varchar(40) DEFAULT NULL,
581 `MODEL_NAME` varchar(40) DEFAULT NULL,
582 `MODEL_TYPE` varchar(20) DEFAULT NULL,
583 `MODEL_VERSION` varchar(20) DEFAULT NULL,
584 `MODEL_VERSION_ID` varchar(40) DEFAULT NULL,
585 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
586 `RECIPE` int(11) DEFAULT NULL,
588 UNIQUE KEY `uk1_model` (`MODEL_TYPE`,`MODEL_VERSION_ID`),
589 KEY `RECIPE` (`RECIPE`),
590 CONSTRAINT `model_ibfk_1` FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
591 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
592 /*!40101 SET character_set_client = @saved_cs_client */;
595 -- Table structure for table `model_recipe`
598 DROP TABLE IF EXISTS `model_recipe`;
599 /*!40101 SET @saved_cs_client = @@character_set_client */;
600 /*!40101 SET character_set_client = utf8 */;
601 CREATE TABLE `model_recipe` (
602 `ID` int(11) NOT NULL AUTO_INCREMENT,
603 `MODEL_ID` int(11) DEFAULT NULL,
604 `ACTION` varchar(40) DEFAULT NULL,
605 `SCHEMA_VERSION` varchar(40) DEFAULT NULL,
606 `DESCRIPTION` varchar(40) DEFAULT NULL,
607 `ORCHESTRATION_URI` varchar(20) DEFAULT NULL,
608 `MODEL_PARAM_XSD` varchar(20) DEFAULT NULL,
609 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
610 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
612 UNIQUE KEY `uk1_model_recipe` (`MODEL_ID`,`ACTION`)
613 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
614 /*!40101 SET character_set_client = @saved_cs_client */;
617 -- Table structure for table `network_recipe`
620 DROP TABLE IF EXISTS `network_recipe`;
621 /*!40101 SET @saved_cs_client = @@character_set_client */;
622 /*!40101 SET character_set_client = utf8 */;
623 CREATE TABLE `network_recipe` (
624 `id` int(11) NOT NULL AUTO_INCREMENT,
625 `MODEL_NAME` varchar(20) NOT NULL,
626 `ACTION` varchar(50) NOT NULL,
627 `DESCRIPTION` varchar(1200) DEFAULT NULL,
628 `ORCHESTRATION_URI` varchar(256) NOT NULL,
629 `NETWORK_PARAM_XSD` varchar(2048) DEFAULT NULL,
630 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
631 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
632 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
633 `VERSION_STR` varchar(20) NOT NULL,
634 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
635 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
637 UNIQUE KEY `UK_rl4f296i0p8lyokxveaiwkayi` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
638 ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
639 /*!40101 SET character_set_client = @saved_cs_client */;
642 -- Table structure for table `network_resource`
645 DROP TABLE IF EXISTS `network_resource`;
646 /*!40101 SET @saved_cs_client = @@character_set_client */;
647 /*!40101 SET character_set_client = utf8 */;
648 CREATE TABLE `network_resource` (
649 `MODEL_UUID` varchar(200) NOT NULL,
650 `MODEL_NAME` varchar(200) NOT NULL,
651 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
652 `DESCRIPTION` varchar(1200) DEFAULT NULL,
653 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
654 `NEUTRON_NETWORK_TYPE` varchar(20) DEFAULT NULL,
655 `MODEL_VERSION` varchar(20) DEFAULT NULL,
656 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
657 `AIC_VERSION_MIN` varchar(20) NULL,
658 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
659 `ORCHESTRATION_MODE` varchar(20) DEFAULT 'HEAT',
660 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
661 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
662 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
663 PRIMARY KEY (`MODEL_UUID`),
664 KEY `fk_network_resource__temp_network_heat_template_lookup1_idx` (`MODEL_NAME`),
665 KEY `fk_network_resource__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
666 CONSTRAINT `fk_network_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE NO ACTION ON UPDATE CASCADE,
667 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
668 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
669 /*!40101 SET character_set_client = @saved_cs_client */;
672 -- Table structure for table `network_resource_customization`
675 DROP TABLE IF EXISTS `network_resource_customization`;
676 /*!40101 SET @saved_cs_client = @@character_set_client */;
677 /*!40101 SET character_set_client = utf8 */;
678 CREATE TABLE `network_resource_customization` (
679 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
680 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
681 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
682 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
683 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
684 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
685 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
686 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
687 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
688 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
689 KEY `fk_network_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
690 CONSTRAINT `fk_network_resource_customization__network_resource1` FOREIGN KEY (`NETWORK_RESOURCE_MODEL_UUID`) REFERENCES `network_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
691 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
692 /*!40101 SET character_set_client = @saved_cs_client */;
695 -- Table structure for table `network_resource_customization_to_service`
698 DROP TABLE IF EXISTS `network_resource_customization_to_service`;
699 /*!40101 SET @saved_cs_client = @@character_set_client */;
700 /*!40101 SET character_set_client = utf8 */;
701 CREATE TABLE `network_resource_customization_to_service` (
702 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
703 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
704 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
705 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
706 CONSTRAINT `network_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
707 CONSTRAINT `network_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `network_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
708 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
709 /*!40101 SET character_set_client = @saved_cs_client */;
712 -- Table structure for table `northbound_request_ref_lookup`
715 DROP TABLE IF EXISTS `northbound_request_ref_lookup`;
716 /*!40101 SET @saved_cs_client = @@character_set_client */;
717 /*!40101 SET character_set_client = utf8 */;
718 CREATE TABLE `northbound_request_ref_lookup` (
719 `id` int(11) NOT NULL AUTO_INCREMENT,
720 `REQUEST_SCOPE` varchar(200) NOT NULL,
721 `MACRO_ACTION` varchar(200) NOT NULL,
722 `ACTION` varchar(200) NOT NULL,
723 `IS_ALACARTE` tinyint(1) NOT NULL DEFAULT '0',
724 `MIN_API_VERSION` double NOT NULL,
725 `MAX_API_VERSION` double DEFAULT NULL,
726 `IS_TOPLEVELFLOW` tinyint(1) DEFAULT NULL,
727 `CLOUD_OWNER` varchar(200) NOT NULL,
729 UNIQUE KEY `UK_northbound_request_ref_lookup` (`MIN_API_VERSION`,`REQUEST_SCOPE`,`ACTION`,`IS_ALACARTE`,`MACRO_ACTION`,`CLOUD_OWNER`)
730 ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;
731 /*!40101 SET character_set_client = @saved_cs_client */;
734 -- Table structure for table `orchestration_flow_reference`
737 DROP TABLE IF EXISTS `orchestration_flow_reference`;
738 /*!40101 SET @saved_cs_client = @@character_set_client */;
739 /*!40101 SET character_set_client = utf8 */;
740 CREATE TABLE `orchestration_flow_reference` (
741 `id` int(11) NOT NULL AUTO_INCREMENT,
742 `COMPOSITE_ACTION` varchar(200) NOT NULL,
743 `SEQ_NO` int(11) NOT NULL,
744 `FLOW_NAME` varchar(200) NOT NULL,
745 `FLOW_VERSION` double NOT NULL,
746 `NB_REQ_REF_LOOKUP_ID` int(11) NOT NULL,
748 UNIQUE KEY `UK_orchestration_flow_reference` (`COMPOSITE_ACTION`,`FLOW_NAME`,`SEQ_NO`,`NB_REQ_REF_LOOKUP_ID`),
749 KEY `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID`),
750 KEY `fk_orchestration_flow_reference__building_block_detail` (`FLOW_NAME`),
751 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
752 ) ENGINE=InnoDB AUTO_INCREMENT=398 DEFAULT CHARSET=latin1;
753 /*!40101 SET character_set_client = @saved_cs_client */;
756 -- Table structure for table `orchestration_status_state_transition_directive`
759 DROP TABLE IF EXISTS `orchestration_status_state_transition_directive`;
760 /*!40101 SET @saved_cs_client = @@character_set_client */;
761 /*!40101 SET character_set_client = utf8 */;
762 CREATE TABLE `orchestration_status_state_transition_directive` (
763 `id` int(11) NOT NULL AUTO_INCREMENT,
764 `RESOURCE_TYPE` varchar(25) NOT NULL,
765 `ORCHESTRATION_STATUS` varchar(25) NOT NULL,
766 `TARGET_ACTION` varchar(25) NOT NULL,
767 `FLOW_DIRECTIVE` varchar(25) NOT NULL,
769 UNIQUE KEY `UK_orchestration_status_state_transition_directive` (`RESOURCE_TYPE`,`ORCHESTRATION_STATUS`,`TARGET_ACTION`)
770 ) ENGINE=InnoDB AUTO_INCREMENT=686 DEFAULT CHARSET=latin1;
771 /*!40101 SET character_set_client = @saved_cs_client */;
774 -- Table structure for table `rainy_day_handler_macro`
777 DROP TABLE IF EXISTS `rainy_day_handler_macro`;
778 /*!40101 SET @saved_cs_client = @@character_set_client */;
779 /*!40101 SET character_set_client = utf8 */;
780 CREATE TABLE `rainy_day_handler_macro` (
781 `id` int(11) NOT NULL AUTO_INCREMENT,
782 `FLOW_NAME` varchar(200) NOT NULL,
783 `SERVICE_TYPE` varchar(200) NOT NULL,
784 `VNF_TYPE` varchar(200) NOT NULL,
785 `ERROR_CODE` varchar(200) NOT NULL,
786 `WORK_STEP` varchar(200) NOT NULL,
787 `POLICY` varchar(200) NOT NULL,
788 `SECONDARY_POLICY` varchar(200) DEFAULT NULL,
790 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
791 /*!40101 SET character_set_client = @saved_cs_client */;
794 -- Table structure for table `service`
797 DROP TABLE IF EXISTS `service`;
798 /*!40101 SET @saved_cs_client = @@character_set_client */;
799 /*!40101 SET character_set_client = utf8 */;
800 CREATE TABLE `service` (
801 `MODEL_UUID` varchar(200) NOT NULL,
802 `MODEL_NAME` varchar(200) NOT NULL,
803 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
804 `MODEL_VERSION` varchar(20) NOT NULL,
805 `DESCRIPTION` varchar(1200) DEFAULT NULL,
806 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
807 `TOSCA_CSAR_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
808 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
809 `SERVICE_ROLE` varchar(200) DEFAULT NULL,
810 `ENVIRONMENT_CONTEXT` varchar(200) DEFAULT NULL,
811 `WORKLOAD_CONTEXT` varchar(200) DEFAULT NULL,
812 `SERVICE_CATEGORY` varchar(200) DEFAULT NULL,
813 `RESOURCE_ORDER` varchar(200) default NULL,
814 PRIMARY KEY (`MODEL_UUID`),
815 KEY `fk_service__tosca_csar1_idx` (`TOSCA_CSAR_ARTIFACT_UUID`),
816 CONSTRAINT `fk_service__tosca_csar1` FOREIGN KEY (`TOSCA_CSAR_ARTIFACT_UUID`) REFERENCES `tosca_csar` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
817 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
818 /*!40101 SET character_set_client = @saved_cs_client */;
821 -- Table structure for table `service_proxy_customization`
824 DROP TABLE IF EXISTS `service_proxy_customization`;
825 /*!40101 SET @saved_cs_client = @@character_set_client */;
826 /*!40101 SET character_set_client = utf8 */;
827 CREATE TABLE `service_proxy_customization` (
828 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
829 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
830 `MODEL_UUID` varchar(200) NOT NULL,
831 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
832 `MODEL_VERSION` varchar(20) NOT NULL,
833 `MODEL_NAME` varchar(200) NOT NULL,
834 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
835 `DESCRIPTION` varchar(1200) DEFAULT NULL,
836 `SOURCE_SERVICE_MODEL_UUID` varchar(200) NOT NULL,
837 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
838 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
839 KEY `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID`),
840 CONSTRAINT `fk_service_proxy_resource_customization__service1` FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
841 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
842 /*!40101 SET character_set_client = @saved_cs_client */;
845 -- Table structure for table `service_proxy_customization_to_service`
848 DROP TABLE IF EXISTS `service_proxy_customization_to_service`;
849 /*!40101 SET @saved_cs_client = @@character_set_client */;
850 /*!40101 SET character_set_client = utf8 */;
851 CREATE TABLE `service_proxy_customization_to_service` (
852 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
853 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
854 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
855 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
856 /*!40101 SET character_set_client = @saved_cs_client */;
859 -- Table structure for table `service_recipe`
862 DROP TABLE IF EXISTS `service_recipe`;
863 /*!40101 SET @saved_cs_client = @@character_set_client */;
864 /*!40101 SET character_set_client = utf8 */;
865 CREATE TABLE `service_recipe` (
866 `id` int(11) NOT NULL AUTO_INCREMENT,
867 `ACTION` varchar(50) NOT NULL,
868 `VERSION_STR` varchar(20) DEFAULT NULL,
869 `DESCRIPTION` varchar(1200) DEFAULT NULL,
870 `ORCHESTRATION_URI` varchar(256) NOT NULL,
871 `SERVICE_PARAM_XSD` varchar(2048) DEFAULT NULL,
872 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
873 `SERVICE_TIMEOUT_INTERIM` int(11) DEFAULT NULL,
874 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
875 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
877 UNIQUE KEY `UK_7fav5dkux2v8g9d2i5ymudlgc` (`SERVICE_MODEL_UUID`,`ACTION`),
878 KEY `fk_service_recipe__service1_idx` (`SERVICE_MODEL_UUID`),
879 CONSTRAINT `fk_service_recipe__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
880 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
881 /*!40101 SET character_set_client = @saved_cs_client */;
884 -- Table structure for table `temp_network_heat_template_lookup`
887 DROP TABLE IF EXISTS `temp_network_heat_template_lookup`;
888 /*!40101 SET @saved_cs_client = @@character_set_client */;
889 /*!40101 SET character_set_client = utf8 */;
890 CREATE TABLE `temp_network_heat_template_lookup` (
891 `NETWORK_RESOURCE_MODEL_NAME` varchar(200) NOT NULL,
892 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
893 `AIC_VERSION_MIN` varchar(20) NULL,
894 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
895 PRIMARY KEY (`NETWORK_RESOURCE_MODEL_NAME`),
896 KEY `fk_temp_network_heat_template_lookup__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
897 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
898 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
899 /*!40101 SET character_set_client = @saved_cs_client */;
902 -- Table structure for table `tosca_csar`
905 DROP TABLE IF EXISTS `tosca_csar`;
906 /*!40101 SET @saved_cs_client = @@character_set_client */;
907 /*!40101 SET character_set_client = utf8 */;
908 CREATE TABLE `tosca_csar` (
909 `ARTIFACT_UUID` varchar(200) NOT NULL,
910 `NAME` varchar(200) NOT NULL,
911 `VERSION` varchar(20) NOT NULL,
912 `DESCRIPTION` varchar(1200) DEFAULT NULL,
913 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL,
914 `URL` varchar(200) NOT NULL,
915 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
916 PRIMARY KEY (`ARTIFACT_UUID`)
917 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
918 /*!40101 SET character_set_client = @saved_cs_client */;
921 -- Table structure for table `vf_module`
924 DROP TABLE IF EXISTS `vf_module`;
925 /*!40101 SET @saved_cs_client = @@character_set_client */;
926 /*!40101 SET character_set_client = utf8 */;
927 CREATE TABLE `vf_module` (
928 `MODEL_UUID` varchar(200) NOT NULL,
929 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
930 `MODEL_VERSION` varchar(20) NOT NULL,
931 `MODEL_NAME` varchar(200) NOT NULL,
932 `DESCRIPTION` varchar(1200) DEFAULT NULL,
933 `IS_BASE` tinyint(1) NOT NULL,
934 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
935 `VOL_HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
936 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
937 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
938 PRIMARY KEY (`MODEL_UUID`,`VNF_RESOURCE_MODEL_UUID`),
939 KEY `fk_vf_module__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
940 KEY `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
941 KEY `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`VOL_HEAT_TEMPLATE_ARTIFACT_UUID`),
942 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,
943 CONSTRAINT `fk_vf_module__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
944 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
945 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
946 /*!40101 SET character_set_client = @saved_cs_client */;
949 -- Table structure for table `vf_module_customization`
952 DROP TABLE IF EXISTS `vf_module_customization`;
953 /*!40101 SET @saved_cs_client = @@character_set_client */;
954 /*!40101 SET character_set_client = utf8 */;
955 CREATE TABLE `vf_module_customization` (
956 `ID` int(13) NOT NULL AUTO_INCREMENT,
957 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
958 `LABEL` varchar(200) DEFAULT NULL,
959 `INITIAL_COUNT` int(11) DEFAULT '0',
960 `MIN_INSTANCES` int(11) DEFAULT '0',
961 `MAX_INSTANCES` int(11) DEFAULT NULL,
962 `AVAILABILITY_ZONE_COUNT` int(11) DEFAULT NULL,
963 `HEAT_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
964 `VOL_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
965 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
966 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
967 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
969 KEY `fk_vf_module_customization__vf_module1_idx` (`VF_MODULE_MODEL_UUID`),
970 KEY `fk_vf_module_customization__heat_env__heat_environment1_idx` (`HEAT_ENVIRONMENT_ARTIFACT_UUID`),
971 KEY `fk_vf_module_customization__vol_env__heat_environment2_idx` (`VOL_ENVIRONMENT_ARTIFACT_UUID`),
972 KEY `fk_vf_module_customization_to_vnf_resource_customization` (`VNF_RESOURCE_CUSTOMIZATION_ID`),
973 KEY `vf_module_customization_model_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
974 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,
975 CONSTRAINT `fk_vf_module_customization__vf_module1` FOREIGN KEY (`VF_MODULE_MODEL_UUID`) REFERENCES `vf_module` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
976 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,
977 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
978 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
979 /*!40101 SET character_set_client = @saved_cs_client */;
982 -- Table structure for table `vf_module_to_heat_files`
985 DROP TABLE IF EXISTS `vf_module_to_heat_files`;
986 /*!40101 SET @saved_cs_client = @@character_set_client */;
987 /*!40101 SET character_set_client = utf8 */;
988 CREATE TABLE `vf_module_to_heat_files` (
989 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
990 `HEAT_FILES_ARTIFACT_UUID` varchar(200) NOT NULL,
991 PRIMARY KEY (`VF_MODULE_MODEL_UUID`,`HEAT_FILES_ARTIFACT_UUID`),
992 KEY `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`HEAT_FILES_ARTIFACT_UUID`),
993 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,
994 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
995 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='il fait ce qu''il dit';
996 /*!40101 SET character_set_client = @saved_cs_client */;
999 -- Table structure for table `vnf_components`
1002 DROP TABLE IF EXISTS `vnf_components`;
1003 /*!40101 SET @saved_cs_client = @@character_set_client */;
1004 /*!40101 SET character_set_client = utf8 */;
1005 CREATE TABLE `vnf_components` (
1006 `VNF_ID` int(11) NOT NULL,
1007 `COMPONENT_TYPE` varchar(20) NOT NULL,
1008 `HEAT_TEMPLATE_ID` int(11) DEFAULT NULL,
1009 `HEAT_ENVIRONMENT_ID` int(11) DEFAULT NULL,
1010 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1011 PRIMARY KEY (`VNF_ID`,`COMPONENT_TYPE`)
1012 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1013 /*!40101 SET character_set_client = @saved_cs_client */;
1016 -- Table structure for table `vnf_components_recipe`
1019 DROP TABLE IF EXISTS `vnf_components_recipe`;
1020 /*!40101 SET @saved_cs_client = @@character_set_client */;
1021 /*!40101 SET character_set_client = utf8 */;
1022 CREATE TABLE `vnf_components_recipe` (
1023 `id` int(11) NOT NULL AUTO_INCREMENT,
1024 `VNF_TYPE` varchar(200) DEFAULT NULL,
1025 `VNF_COMPONENT_TYPE` varchar(45) NOT NULL,
1026 `ACTION` varchar(50) NOT NULL,
1027 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1028 `VERSION` varchar(20) NOT NULL,
1029 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1030 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1031 `VNF_COMPONENT_PARAM_XSD` varchar(2048) DEFAULT NULL,
1032 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1033 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1034 `VF_MODULE_MODEL_UUID` varchar(200) DEFAULT NULL,
1036 UNIQUE KEY `UK_4dpdwddaaclhc11wxsb7h59ma` (`VF_MODULE_MODEL_UUID`,`VNF_COMPONENT_TYPE`,`ACTION`,`VERSION`)
1037 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
1038 /*!40101 SET character_set_client = @saved_cs_client */;
1041 -- Table structure for table `vnf_recipe`
1044 DROP TABLE IF EXISTS `vnf_recipe`;
1045 /*!40101 SET @saved_cs_client = @@character_set_client */;
1046 /*!40101 SET character_set_client = utf8 */;
1047 CREATE TABLE `vnf_recipe` (
1048 `id` int(11) NOT NULL AUTO_INCREMENT,
1049 `NF_ROLE` varchar(200) DEFAULT NULL,
1050 `ACTION` varchar(50) NOT NULL,
1051 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1052 `VERSION_STR` varchar(20) NOT NULL,
1053 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1054 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1055 `VNF_PARAM_XSD` varchar(2048) DEFAULT NULL,
1056 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1057 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1058 `VF_MODULE_ID` varchar(100) DEFAULT NULL,
1060 UNIQUE KEY `UK_f3tvqau498vrifq3cr8qnigkr` (`VF_MODULE_ID`,`ACTION`,`VERSION_STR`)
1061 ) ENGINE=InnoDB AUTO_INCREMENT=10015 DEFAULT CHARSET=latin1;
1062 /*!40101 SET character_set_client = @saved_cs_client */;
1065 -- Table structure for table `vnf_resource`
1068 DROP TABLE IF EXISTS `vnf_resource`;
1069 /*!40101 SET @saved_cs_client = @@character_set_client */;
1070 /*!40101 SET character_set_client = utf8 */;
1071 CREATE TABLE `vnf_resource` (
1072 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
1073 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1074 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1075 `MODEL_UUID` varchar(200) NOT NULL,
1076 `AIC_VERSION_MIN` varchar(20) DEFAULT NULL,
1077 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
1078 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1079 `MODEL_VERSION` varchar(20) NOT NULL,
1080 `MODEL_NAME` varchar(200) DEFAULT NULL,
1081 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1082 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
1083 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1084 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1085 PRIMARY KEY (`MODEL_UUID`),
1086 KEY `fk_vnf_resource__heat_template1` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
1087 CONSTRAINT `fk_vnf_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1088 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1089 /*!40101 SET character_set_client = @saved_cs_client */;
1092 -- Table structure for table `vnf_resource_customization`
1095 DROP TABLE IF EXISTS `vnf_resource_customization`;
1096 /*!40101 SET @saved_cs_client = @@character_set_client */;
1097 /*!40101 SET character_set_client = utf8 */;
1098 CREATE TABLE `vnf_resource_customization` (
1099 `ID` int(13) NOT NULL AUTO_INCREMENT,
1100 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1101 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1102 `MIN_INSTANCES` int(11) DEFAULT NULL,
1103 `MAX_INSTANCES` int(11) DEFAULT NULL,
1104 `AVAILABILITY_ZONE_MAX_COUNT` int(11) DEFAULT NULL,
1105 `NF_TYPE` varchar(200) DEFAULT NULL,
1106 `NF_ROLE` varchar(200) DEFAULT NULL,
1107 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1108 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1109 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1110 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
1111 `CDS_BLUEPRINT_NAME` varchar(200) default null,
1112 `CDS_BLUEPRINT_VERSION` varchar(20) default null,
1113 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1114 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1115 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1116 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1118 UNIQUE KEY `UK_vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`,`SERVICE_MODEL_UUID`),
1119 KEY `fk_vnf_resource_customization__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
1120 KEY `fk_vnf_resource_customization_to_service` (`SERVICE_MODEL_UUID`),
1121 KEY `vnf_resource_customization_mod_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
1122 CONSTRAINT `fk_vnf_resource_customization__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1123 CONSTRAINT `fk_vnf_resource_customization_to_service` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1124 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1125 /*!40101 SET character_set_client = @saved_cs_client */;
1128 -- Table structure for table `vnfc_customization`
1131 DROP TABLE IF EXISTS `vnfc_customization`;
1132 /*!40101 SET @saved_cs_client = @@character_set_client */;
1133 /*!40101 SET character_set_client = utf8 */;
1134 CREATE TABLE `vnfc_customization` (
1135 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1136 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1137 `MODEL_UUID` varchar(200) NOT NULL,
1138 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
1139 `MODEL_VERSION` varchar(20) NOT NULL,
1140 `MODEL_NAME` varchar(200) NOT NULL,
1141 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
1142 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1143 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1144 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`)
1145 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1146 /*!40101 SET character_set_client = @saved_cs_client */;
1149 -- Table structure for table `vnfc_instance_group_customization`
1152 DROP TABLE IF EXISTS `vnfc_instance_group_customization`;
1153 /*!40101 SET @saved_cs_client = @@character_set_client */;
1154 /*!40101 SET character_set_client = utf8 */;
1155 CREATE TABLE `vnfc_instance_group_customization` (
1156 `ID` int(13) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1157 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) NOT NULL,
1158 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
1159 `FUNCTION` varchar(200) DEFAULT NULL,
1160 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1161 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1162 KEY `fk_vnfc_instance_group_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
1163 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,
1164 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
1165 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1166 set foreign_key_checks=1;
1168 CREATE TABLE IF NOT EXISTS `pnf_resource` (
1169 `ORCHESTRATION_MODE` varchar(20) DEFAULT NULL,
1170 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1171 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1172 `MODEL_UUID` varchar(200) NOT NULL,
1173 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1174 `MODEL_VERSION` varchar(20) NOT NULL,
1175 `MODEL_NAME` varchar(200) DEFAULT NULL,
1176 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1177 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1178 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1179 PRIMARY KEY (`MODEL_UUID`)
1180 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1182 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
1183 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1184 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1185 `NF_TYPE` varchar(200) DEFAULT NULL,
1186 `NF_ROLE` varchar(200) DEFAULT NULL,
1187 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1188 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1189 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1190 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1191 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1192 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
1193 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
1194 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
1195 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1196 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
1197 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
1198 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1199 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1201 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
1202 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1203 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1204 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
1205 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
1207 CREATE TABLE IF NOT EXISTS `workflow` (
1208 `ID` int(11) NOT NULL AUTO_INCREMENT,
1209 `ARTIFACT_UUID` varchar(200) NOT NULL,
1210 `ARTIFACT_NAME` varchar(200) NOT NULL,
1211 `NAME` varchar(200) NOT NULL,
1212 `OPERATION_NAME` varchar(200) DEFAULT NULL,
1213 `VERSION` double NOT NULL,
1214 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1215 `BODY` longtext DEFAULT NULL,
1216 `RESOURCE_TARGET` varchar(200) NOT NULL,
1217 `SOURCE` varchar(200) NOT NULL,
1218 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
1219 `ARTIFACT_CHECKSUM` varchar(200) DEFAULT 'MANUAL RECORD',
1220 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT current_timestamp(),
1222 UNIQUE KEY `UK_workflow` (`ARTIFACT_UUID`,`NAME`,`VERSION`,`SOURCE`)
1223 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1225 CREATE TABLE IF NOT EXISTS `vnf_resource_to_workflow` (
1226 `ID` int(11) NOT NULL AUTO_INCREMENT,
1227 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1228 `WORKFLOW_ID` int(11) NOT NULL,
1230 UNIQUE KEY `UK_vnf_resource_to_workflow` (`VNF_RESOURCE_MODEL_UUID`,`WORKFLOW_ID`),
1231 KEY `fk_vnf_resource_to_workflow__workflow1_idx` (`WORKFLOW_ID`),
1232 KEY `fk_vnf_resource_to_workflow__vnf_res_mod_uuid_idx` (`VNF_RESOURCE_MODEL_UUID`),
1233 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,
1234 CONSTRAINT `fk_vnf_resource_to_workflow__workflow1` FOREIGN KEY (`WORKFLOW_ID`) REFERENCES `workflow` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
1235 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1237 CREATE TABLE IF NOT EXISTS `activity_spec` (
1238 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1239 `NAME` VARCHAR(200) NOT NULL,
1240 `DESCRIPTION` VARCHAR(1200) NOT NULL,
1241 `VERSION` DOUBLE NOT NULL,
1242 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1244 UNIQUE INDEX `UK_activity_spec` (`NAME` ASC, `VERSION` ASC))
1246 DEFAULT CHARACTER SET = latin1;
1248 CREATE TABLE IF NOT EXISTS `user_parameters` (
1249 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1250 `NAME` VARCHAR(200) NOT NULL,
1251 `PAYLOAD_LOCATION` VARCHAR(500) NULL,
1252 `LABEL` VARCHAR(200) NOT NULL,
1253 `TYPE` VARCHAR(200) NOT NULL,
1254 `DESCRIPTION` VARCHAR(1200) NULL,
1255 `IS_REQUIRED` TINYINT(1) NOT NULL,
1256 `MAX_LENGTH` INT(11) NULL,
1257 `ALLOWABLE_CHARS` VARCHAR(200) NULL,
1258 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1260 UNIQUE INDEX `UK_user_parameters` (`NAME` ASC))
1262 DEFAULT CHARACTER SET = latin1;
1264 CREATE TABLE IF NOT EXISTS `workflow_activity_spec_sequence` (
1265 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1266 `WORKFLOW_ID` INT(11) NOT NULL,
1267 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1268 `SEQ_NO` INT(11) NOT NULL,
1270 UNIQUE INDEX `UK_workflow_activity_spec_sequence` (`WORKFLOW_ID` ASC, `ACTIVITY_SPEC_ID` ASC, `SEQ_NO` ASC),
1271 INDEX `fk_workflow_activity_spec_sequence__activity_spec_idx` (`ACTIVITY_SPEC_ID` ASC),
1272 INDEX `fk_workflow_activity_spec_sequence__workflow_actifact_uuid_idx` (`WORKFLOW_ID` ASC),
1273 CONSTRAINT `fk_workflow_activity_spec_sequence__activity_spec1`
1274 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1275 REFERENCES `activity_spec` (`ID`)
1278 CONSTRAINT `fk_workflow_activity_spec_sequence__workflow1`
1279 FOREIGN KEY (`WORKFLOW_ID`)
1280 REFERENCES `workflow` (`ID`)
1284 DEFAULT CHARACTER SET = latin1;
1286 CREATE TABLE IF NOT EXISTS `activity_spec_parameters` (
1287 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1288 `NAME` VARCHAR(200) NOT NULL,
1289 `TYPE` VARCHAR(200) NOT NULL,
1290 `DIRECTION` VARCHAR(200) NULL,
1291 `DESCRIPTION` VARCHAR(1200) NULL,
1292 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1294 UNIQUE INDEX `UK_activity_spec_parameters` (`NAME` ASC, `DIRECTION` ASC))
1296 DEFAULT CHARACTER SET = latin1;
1298 CREATE TABLE IF NOT EXISTS `activity_spec_categories` (
1299 `ID` INT(11) NOT NULL,
1300 `NAME` VARCHAR(200) NOT NULL,
1302 UNIQUE INDEX `UK_activity_spec_categories` (`NAME` ASC))
1304 DEFAULT CHARACTER SET = latin1;
1306 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_categories` (
1307 `ID` INT(11) NOT NULL,
1308 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1309 `ACTIVITY_SPEC_CATEGORIES_ID` INT(11) NOT NULL,
1311 UNIQUE INDEX `UK_activity_spec_to_activity_spec_categories` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1312 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx` (`ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1313 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx1` (`ACTIVITY_SPEC_ID` ASC),
1314 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec1`
1315 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1316 REFERENCES `activity_spec` (`ID`)
1319 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec_c1`
1320 FOREIGN KEY (`ACTIVITY_SPEC_CATEGORIES_ID`)
1321 REFERENCES `activity_spec_categories` (`ID`)
1325 DEFAULT CHARACTER SET = latin1;
1327 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_parameters` (
1328 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1329 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1330 `ACTIVITY_SPEC_PARAMETERS_ID` INT(11) NOT NULL,
1332 INDEX `fk_activity_spec_to_activity_spec_params__act_sp_param_id_idx` (`ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1333 UNIQUE INDEX `UK_activity_spec_to_activity_spec_parameters` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1334 INDEX `fk_activity_spec_to_activity_spec_parameters__act_spec_id_idx` (`ACTIVITY_SPEC_ID` ASC),
1335 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activity_spec_1`
1336 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1337 REFERENCES `activity_spec` (`ID`)
1340 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activ_spec_param1`
1341 FOREIGN KEY (`ACTIVITY_SPEC_PARAMETERS_ID`)
1342 REFERENCES `activity_spec_parameters` (`ID`)
1346 DEFAULT CHARACTER SET = latin1;
1348 CREATE TABLE IF NOT EXISTS `activity_spec_to_user_parameters` (
1349 `ID` INT(11) NOT NULL,
1350 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1351 `USER_PARAMETERS_ID` INT(11) NOT NULL,
1353 UNIQUE INDEX `UK_activity_spec_to_user_parameters` (`ACTIVITY_SPEC_ID` ASC, `USER_PARAMETERS_ID` ASC),
1354 INDEX `fk_activity_spec_to_user_parameters__user_parameters1_idx` (`USER_PARAMETERS_ID` ASC),
1355 INDEX `fk_activity_spec_to_user_parameters__activity_spec1_idx` (`ACTIVITY_SPEC_ID` ASC),
1356 CONSTRAINT `fk_activity_spec_to_user_parameters__activity_spec1`
1357 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1358 REFERENCES `activity_spec` (`ID`)
1361 CONSTRAINT `fk_activity_spec_to_user_parameters__user_parameters1`
1362 FOREIGN KEY (`USER_PARAMETERS_ID`)
1363 REFERENCES `user_parameters` (`ID`)
1367 DEFAULT CHARACTER SET = latin1;