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,
123 `SUPPORT_FABRIC` bit(1) NOT NULL DEFAULT 1,
125 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
126 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)
127 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
128 /*!40101 SET character_set_client = @saved_cs_client */;
131 -- Table structure for table `cloudify_managers`
134 DROP TABLE IF EXISTS `cloudify_managers`;
135 /*!40101 SET @saved_cs_client = @@character_set_client */;
136 /*!40101 SET character_set_client = utf8 */;
137 CREATE TABLE `cloudify_managers` (
138 `ID` varchar(50) NOT NULL,
139 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
140 `USERNAME` varchar(255) DEFAULT NULL,
141 `PASSWORD` varchar(255) DEFAULT NULL,
142 `VERSION` varchar(20) DEFAULT NULL,
143 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
144 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
145 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
147 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
148 /*!40101 SET character_set_client = @saved_cs_client */;
151 -- Table structure for table `collection_network_resource_customization`
154 DROP TABLE IF EXISTS `collection_network_resource_customization`;
155 /*!40101 SET @saved_cs_client = @@character_set_client */;
156 /*!40101 SET character_set_client = utf8 */;
157 CREATE TABLE `collection_network_resource_customization` (
158 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
159 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
160 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
161 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
162 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
163 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
164 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
165 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
166 `INSTANCE_GROUP_MODEL_UUID` varchar(200) DEFAULT NULL,
167 `CRC_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
168 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`,`CRC_MODEL_CUSTOMIZATION_UUID`),
169 KEY `fk_collection_net_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
170 KEY `fk_collection_net_resource_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
171 KEY `fk_col_net_res_customization__collection_res_customization_idx` (`CRC_MODEL_CUSTOMIZATION_UUID`),
172 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,
173 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,
174 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
175 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
176 /*!40101 SET character_set_client = @saved_cs_client */;
179 -- Table structure for table `collection_resource`
182 DROP TABLE IF EXISTS `collection_resource`;
183 /*!40101 SET @saved_cs_client = @@character_set_client */;
184 /*!40101 SET character_set_client = utf8 */;
185 CREATE TABLE `collection_resource` (
186 `MODEL_UUID` varchar(200) NOT NULL,
187 `MODEL_NAME` varchar(200) NOT NULL,
188 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
189 `MODEL_VERSION` varchar(20) NOT NULL,
190 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
191 `DESCRIPTION` varchar(1200) DEFAULT NULL,
192 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
193 PRIMARY KEY (`MODEL_UUID`)
194 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
195 /*!40101 SET character_set_client = @saved_cs_client */;
198 -- Table structure for table `collection_resource_customization`
201 DROP TABLE IF EXISTS `collection_resource_customization`;
202 /*!40101 SET @saved_cs_client = @@character_set_client */;
203 /*!40101 SET character_set_client = utf8 */;
204 CREATE TABLE `collection_resource_customization` (
205 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
206 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
207 `role` varchar(200) DEFAULT NULL,
208 `object_type` varchar(200) NOT NULL,
209 `function` varchar(200) DEFAULT NULL,
210 `collection_resource_type` varchar(200) DEFAULT NULL,
211 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
212 `CR_MODEL_UUID` varchar(200) NOT NULL,
213 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
214 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`),
215 CONSTRAINT `collection_resource_customization_ibfk_1` FOREIGN KEY (`CR_MODEL_UUID`) REFERENCES `collection_resource` (`MODEL_UUID`) ON DELETE CASCADE
216 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
217 /*!40101 SET character_set_client = @saved_cs_client */;
220 -- Table structure for table `collection_resource_customization_to_service`
223 DROP TABLE IF EXISTS `collection_resource_customization_to_service`;
224 /*!40101 SET @saved_cs_client = @@character_set_client */;
225 /*!40101 SET character_set_client = utf8 */;
226 CREATE TABLE `collection_resource_customization_to_service` (
227 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
228 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
229 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
230 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
231 CONSTRAINT `collection_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
232 CONSTRAINT `collection_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `collection_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
233 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
234 /*!40101 SET character_set_client = @saved_cs_client */;
237 -- Table structure for table `collection_resource_instance_group_customization`
240 DROP TABLE IF EXISTS `collection_resource_instance_group_customization`;
241 /*!40101 SET @saved_cs_client = @@character_set_client */;
242 /*!40101 SET character_set_client = utf8 */;
243 CREATE TABLE `collection_resource_instance_group_customization` (
244 `COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID` varchar(200) NOT NULL,
245 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
246 `FUNCTION` varchar(200) DEFAULT NULL,
247 `DESCRIPTION` varchar(1200) DEFAULT NULL,
248 `SUBINTERFACE_NETWORK_QUANTITY` int(11) DEFAULT NULL,
249 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
250 PRIMARY KEY (`COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID`,`INSTANCE_GROUP_MODEL_UUID`),
251 KEY `fk_collection_resource_instance_group_customization__instan_idx` (`INSTANCE_GROUP_MODEL_UUID`),
252 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,
253 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
254 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
255 /*!40101 SET character_set_client = @saved_cs_client */;
258 -- Table structure for table `configuration`
261 DROP TABLE IF EXISTS `configuration`;
262 /*!40101 SET @saved_cs_client = @@character_set_client */;
263 /*!40101 SET character_set_client = utf8 */;
264 CREATE TABLE `configuration` (
265 `MODEL_UUID` varchar(200) NOT NULL,
266 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
267 `MODEL_VERSION` varchar(20) NOT NULL,
268 `MODEL_NAME` varchar(200) NOT NULL,
269 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
270 `DESCRIPTION` varchar(1200) DEFAULT NULL,
271 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
272 PRIMARY KEY (`MODEL_UUID`)
273 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
274 /*!40101 SET character_set_client = @saved_cs_client */;
277 -- Table structure for table `configuration_customization`
280 DROP TABLE IF EXISTS `configuration_customization`;
281 /*!40101 SET @saved_cs_client = @@character_set_client */;
282 /*!40101 SET character_set_client = utf8 */;
283 CREATE TABLE `configuration_customization` (
284 `ID` int(11) NOT NULL AUTO_INCREMENT,
285 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
286 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
287 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
288 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
289 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
290 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
291 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
292 `SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
293 `CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
294 `SERVICE_MODEL_UUID` varchar(200),
296 KEY `fk_configuration_customization__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
297 KEY `fk_configuration_customization__service_idx` (`SERVICE_MODEL_UUID`),
298 UNIQUE KEY `uk_configuration_customization` (`MODEL_CUSTOMIZATION_UUID` ASC, `SERVICE_MODEL_UUID` ASC),
299 CONSTRAINT `fk_configuration_customization__configuration1` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
300 REFERENCES `configuration` (`MODEL_UUID`)
301 ON DELETE CASCADE ON UPDATE CASCADE,
302 CONSTRAINT `fk_configuration_customization__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`)
303 REFERENCES `service` (`MODEL_UUID`)
304 ON DELETE CASCADE ON UPDATE CASCADE
305 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
306 /*!40101 SET character_set_client = @saved_cs_client */;
309 -- Table structure for table `controller_selection_reference`
312 DROP TABLE IF EXISTS `controller_selection_reference`;
313 /*!40101 SET @saved_cs_client = @@character_set_client */;
314 /*!40101 SET character_set_client = utf8 */;
315 CREATE TABLE `controller_selection_reference` (
316 `VNF_TYPE` varchar(50) NOT NULL,
317 `CONTROLLER_NAME` varchar(100) NOT NULL,
318 `ACTION_CATEGORY` varchar(15) NOT NULL,
319 PRIMARY KEY (`VNF_TYPE`,`CONTROLLER_NAME`,`ACTION_CATEGORY`)
320 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
321 /*!40101 SET character_set_client = @saved_cs_client */;
324 -- Table structure for table `cvnfc_configuration_customization`
327 DROP TABLE IF EXISTS `cvnfc_configuration_customization`;
328 /*!40101 SET @saved_cs_client = @@character_set_client */;
329 /*!40101 SET character_set_client = utf8 */;
330 CREATE TABLE `cvnfc_configuration_customization` (
331 `ID` int(11) NOT NULL AUTO_INCREMENT,
332 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
333 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
334 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
335 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
336 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
337 `POLICY_NAME` varchar(200) DEFAULT NULL,
338 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
339 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
340 `CVNFC_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
342 KEY `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
343 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
344 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
345 /*!40101 SET character_set_client = @saved_cs_client */;
348 -- Table structure for table `cvnfc_customization`
351 DROP TABLE IF EXISTS `cvnfc_customization`;
352 /*!40101 SET @saved_cs_client = @@character_set_client */;
353 /*!40101 SET character_set_client = utf8 */;
354 CREATE TABLE `cvnfc_customization` (
355 `ID` int(11) NOT NULL AUTO_INCREMENT,
356 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
357 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
358 `MODEL_UUID` varchar(200) NOT NULL,
359 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
360 `MODEL_VERSION` varchar(20) NOT NULL,
361 `MODEL_NAME` varchar(200) NOT NULL,
362 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
363 `DESCRIPTION` varchar(1200) DEFAULT NULL,
364 `NFC_FUNCTION` varchar(200) DEFAULT NULL,
365 `NFC_NAMING_CODE` varchar(200) DEFAULT NULL,
366 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
367 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
368 `VF_MODULE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
370 KEY `fk_cvnfc_customization__vnfc_customization1_idx` (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`),
371 KEY `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID`),
372 KEY `fk_cvnfc_customization_to_vf_module_resource_customization` (`VF_MODULE_CUSTOMIZATION_ID`),
373 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,
374 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
375 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
376 /*!40101 SET character_set_client = @saved_cs_client */;
379 -- Table structure for table `external_service_to_internal_model_mapping`
382 DROP TABLE IF EXISTS `external_service_to_internal_model_mapping`;
383 /*!40101 SET @saved_cs_client = @@character_set_client */;
384 /*!40101 SET character_set_client = utf8 */;
385 CREATE TABLE `external_service_to_internal_model_mapping` (
386 `id` int(11) NOT NULL AUTO_INCREMENT,
387 `SERVICE_NAME` varchar(200) NOT NULL,
388 `PRODUCT_FLAVOR` varchar(200) DEFAULT NULL,
389 `SUBSCRIPTION_SERVICE_TYPE` varchar(200) NOT NULL,
390 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
392 UNIQUE KEY `UK_external_service_to_internal_model_mapping` (`SERVICE_NAME`,`PRODUCT_FLAVOR`,`SERVICE_MODEL_UUID`)
393 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
394 /*!40101 SET character_set_client = @saved_cs_client */;
397 -- Table structure for table `flyway_schema_history`
400 DROP TABLE IF EXISTS `flyway_schema_history`;
401 /*!40101 SET @saved_cs_client = @@character_set_client */;
402 /*!40101 SET character_set_client = utf8 */;
403 CREATE TABLE `flyway_schema_history` (
404 `installed_rank` int(11) NOT NULL,
405 `version` varchar(50) DEFAULT NULL,
406 `description` varchar(200) NOT NULL,
407 `type` varchar(20) NOT NULL,
408 `script` varchar(1000) NOT NULL,
409 `checksum` int(11) DEFAULT NULL,
410 `installed_by` varchar(100) NOT NULL,
411 `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
412 `execution_time` int(11) NOT NULL,
413 `success` tinyint(1) NOT NULL,
414 PRIMARY KEY (`installed_rank`),
415 KEY `flyway_schema_history_s_idx` (`success`)
416 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
417 /*!40101 SET character_set_client = @saved_cs_client */;
420 -- Table structure for table `heat_environment`
423 DROP TABLE IF EXISTS `heat_environment`;
424 /*!40101 SET @saved_cs_client = @@character_set_client */;
425 /*!40101 SET character_set_client = utf8 */;
426 CREATE TABLE `heat_environment` (
427 `ARTIFACT_UUID` varchar(200) NOT NULL,
428 `NAME` varchar(100) NOT NULL,
429 `VERSION` varchar(20) NOT NULL,
430 `DESCRIPTION` varchar(1200) DEFAULT NULL,
431 `BODY` longtext NOT NULL,
432 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
433 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
434 PRIMARY KEY (`ARTIFACT_UUID`)
435 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
436 /*!40101 SET character_set_client = @saved_cs_client */;
439 -- Table structure for table `heat_files`
442 DROP TABLE IF EXISTS `heat_files`;
443 /*!40101 SET @saved_cs_client = @@character_set_client */;
444 /*!40101 SET character_set_client = utf8 */;
445 CREATE TABLE `heat_files` (
446 `ARTIFACT_UUID` varchar(200) NOT NULL,
447 `NAME` varchar(200) NOT NULL,
448 `VERSION` varchar(20) NOT NULL,
449 `DESCRIPTION` varchar(1200) DEFAULT NULL,
450 `BODY` longtext NOT NULL,
451 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
452 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
453 PRIMARY KEY (`ARTIFACT_UUID`)
454 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
455 /*!40101 SET character_set_client = @saved_cs_client */;
458 -- Table structure for table `heat_nested_template`
461 DROP TABLE IF EXISTS `heat_nested_template`;
462 /*!40101 SET @saved_cs_client = @@character_set_client */;
463 /*!40101 SET character_set_client = utf8 */;
464 CREATE TABLE `heat_nested_template` (
465 `PARENT_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
466 `CHILD_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
467 `PROVIDER_RESOURCE_FILE` varchar(100) DEFAULT NULL,
468 PRIMARY KEY (`PARENT_HEAT_TEMPLATE_UUID`,`CHILD_HEAT_TEMPLATE_UUID`),
469 KEY `fk_heat_nested_template__heat_template2_idx` (`CHILD_HEAT_TEMPLATE_UUID`),
470 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,
471 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
472 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
473 /*!40101 SET character_set_client = @saved_cs_client */;
476 -- Table structure for table `heat_template`
479 DROP TABLE IF EXISTS `heat_template`;
480 /*!40101 SET @saved_cs_client = @@character_set_client */;
481 /*!40101 SET character_set_client = utf8 */;
482 CREATE TABLE `heat_template` (
483 `ARTIFACT_UUID` varchar(200) NOT NULL,
484 `NAME` varchar(200) NOT NULL,
485 `VERSION` varchar(20) NOT NULL,
486 `DESCRIPTION` varchar(1200) DEFAULT NULL,
487 `BODY` longtext NOT NULL,
488 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
489 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
490 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
491 PRIMARY KEY (`ARTIFACT_UUID`)
492 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
493 /*!40101 SET character_set_client = @saved_cs_client */;
496 -- Table structure for table `heat_template_params`
499 DROP TABLE IF EXISTS `heat_template_params`;
500 /*!40101 SET @saved_cs_client = @@character_set_client */;
501 /*!40101 SET character_set_client = utf8 */;
502 CREATE TABLE `heat_template_params` (
503 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NOT NULL,
504 `PARAM_NAME` varchar(100) NOT NULL,
505 `IS_REQUIRED` bit(1) NOT NULL,
506 `PARAM_TYPE` varchar(20) DEFAULT NULL,
507 `PARAM_ALIAS` varchar(45) DEFAULT NULL,
508 PRIMARY KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`,`PARAM_NAME`),
509 CONSTRAINT `fk_heat_template_params__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
510 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
511 /*!40101 SET character_set_client = @saved_cs_client */;
514 -- Table structure for table `identity_services`
517 DROP TABLE IF EXISTS `identity_services`;
518 /*!40101 SET @saved_cs_client = @@character_set_client */;
519 /*!40101 SET character_set_client = utf8 */;
520 CREATE TABLE `identity_services` (
521 `ID` varchar(50) NOT NULL,
522 `IDENTITY_URL` varchar(200) DEFAULT NULL,
523 `MSO_ID` varchar(255) DEFAULT NULL,
524 `MSO_PASS` varchar(255) DEFAULT NULL,
525 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
526 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
527 `TENANT_METADATA` tinyint(1) DEFAULT '0',
528 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
529 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
530 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
531 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
532 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
533 `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL,
534 `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL,
536 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
537 /*!40101 SET character_set_client = @saved_cs_client */;
540 -- Table structure for table `instance_group`
543 DROP TABLE IF EXISTS `instance_group`;
544 /*!40101 SET @saved_cs_client = @@character_set_client */;
545 /*!40101 SET character_set_client = utf8 */;
546 CREATE TABLE `instance_group` (
547 `MODEL_UUID` varchar(200) NOT NULL,
548 `MODEL_NAME` varchar(200) NOT NULL,
549 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
550 `MODEL_VERSION` varchar(20) NOT NULL,
551 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
552 `ROLE` varchar(200) NOT NULL,
553 `OBJECT_TYPE` varchar(200) NOT NULL,
554 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
555 `CR_MODEL_UUID` varchar(200) DEFAULT NULL,
556 `INSTANCE_GROUP_TYPE` varchar(200) NOT NULL,
557 PRIMARY KEY (`MODEL_UUID`),
558 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`)
559 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
560 /*!40101 SET character_set_client = @saved_cs_client */;
563 -- Table structure for table `model`
566 DROP TABLE IF EXISTS `model`;
567 /*!40101 SET @saved_cs_client = @@character_set_client */;
568 /*!40101 SET character_set_client = utf8 */;
569 CREATE TABLE `model` (
570 `ID` int(11) NOT NULL AUTO_INCREMENT,
571 `MODEL_CUSTOMIZATION_ID` varchar(40) DEFAULT NULL,
572 `MODEL_CUSTOMIZATION_NAME` varchar(40) DEFAULT NULL,
573 `MODEL_INVARIANT_ID` varchar(40) DEFAULT NULL,
574 `MODEL_NAME` varchar(40) DEFAULT NULL,
575 `MODEL_TYPE` varchar(20) DEFAULT NULL,
576 `MODEL_VERSION` varchar(20) DEFAULT NULL,
577 `MODEL_VERSION_ID` varchar(40) DEFAULT NULL,
578 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
579 `RECIPE` int(11) DEFAULT NULL,
581 UNIQUE KEY `uk1_model` (`MODEL_TYPE`,`MODEL_VERSION_ID`),
582 KEY `RECIPE` (`RECIPE`),
583 CONSTRAINT `model_ibfk_1` FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
584 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
585 /*!40101 SET character_set_client = @saved_cs_client */;
588 -- Table structure for table `model_recipe`
591 DROP TABLE IF EXISTS `model_recipe`;
592 /*!40101 SET @saved_cs_client = @@character_set_client */;
593 /*!40101 SET character_set_client = utf8 */;
594 CREATE TABLE `model_recipe` (
595 `ID` int(11) NOT NULL AUTO_INCREMENT,
596 `MODEL_ID` int(11) DEFAULT NULL,
597 `ACTION` varchar(40) DEFAULT NULL,
598 `SCHEMA_VERSION` varchar(40) DEFAULT NULL,
599 `DESCRIPTION` varchar(40) DEFAULT NULL,
600 `ORCHESTRATION_URI` varchar(20) DEFAULT NULL,
601 `MODEL_PARAM_XSD` varchar(20) DEFAULT NULL,
602 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
603 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
605 UNIQUE KEY `uk1_model_recipe` (`MODEL_ID`,`ACTION`)
606 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
607 /*!40101 SET character_set_client = @saved_cs_client */;
610 -- Table structure for table `network_recipe`
613 DROP TABLE IF EXISTS `network_recipe`;
614 /*!40101 SET @saved_cs_client = @@character_set_client */;
615 /*!40101 SET character_set_client = utf8 */;
616 CREATE TABLE `network_recipe` (
617 `id` int(11) NOT NULL AUTO_INCREMENT,
618 `MODEL_NAME` varchar(20) NOT NULL,
619 `ACTION` varchar(50) NOT NULL,
620 `DESCRIPTION` varchar(1200) DEFAULT NULL,
621 `ORCHESTRATION_URI` varchar(256) NOT NULL,
622 `NETWORK_PARAM_XSD` varchar(2048) DEFAULT NULL,
623 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
624 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
625 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
626 `VERSION_STR` varchar(20) NOT NULL,
627 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
628 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
630 UNIQUE KEY `UK_rl4f296i0p8lyokxveaiwkayi` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
631 ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
632 /*!40101 SET character_set_client = @saved_cs_client */;
635 -- Table structure for table `network_resource`
638 DROP TABLE IF EXISTS `network_resource`;
639 /*!40101 SET @saved_cs_client = @@character_set_client */;
640 /*!40101 SET character_set_client = utf8 */;
641 CREATE TABLE `network_resource` (
642 `MODEL_UUID` varchar(200) NOT NULL,
643 `MODEL_NAME` varchar(200) NOT NULL,
644 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
645 `DESCRIPTION` varchar(1200) DEFAULT NULL,
646 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
647 `NEUTRON_NETWORK_TYPE` varchar(20) DEFAULT NULL,
648 `MODEL_VERSION` varchar(20) DEFAULT NULL,
649 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
650 `AIC_VERSION_MIN` varchar(20) NULL,
651 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
652 `ORCHESTRATION_MODE` varchar(20) DEFAULT 'HEAT',
653 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
654 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
655 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
656 PRIMARY KEY (`MODEL_UUID`),
657 KEY `fk_network_resource__temp_network_heat_template_lookup1_idx` (`MODEL_NAME`),
658 KEY `fk_network_resource__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
659 CONSTRAINT `fk_network_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE NO ACTION ON UPDATE CASCADE,
660 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
661 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
662 /*!40101 SET character_set_client = @saved_cs_client */;
665 -- Table structure for table `network_resource_customization`
668 DROP TABLE IF EXISTS `network_resource_customization`;
669 /*!40101 SET @saved_cs_client = @@character_set_client */;
670 /*!40101 SET character_set_client = utf8 */;
671 CREATE TABLE `network_resource_customization` (
672 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
673 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
674 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
675 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
676 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
677 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
678 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
679 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
680 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
681 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
682 KEY `fk_network_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
683 CONSTRAINT `fk_network_resource_customization__network_resource1` FOREIGN KEY (`NETWORK_RESOURCE_MODEL_UUID`) REFERENCES `network_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
684 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
685 /*!40101 SET character_set_client = @saved_cs_client */;
688 -- Table structure for table `network_resource_customization_to_service`
691 DROP TABLE IF EXISTS `network_resource_customization_to_service`;
692 /*!40101 SET @saved_cs_client = @@character_set_client */;
693 /*!40101 SET character_set_client = utf8 */;
694 CREATE TABLE `network_resource_customization_to_service` (
695 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
696 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
697 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
698 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
699 CONSTRAINT `network_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
700 CONSTRAINT `network_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `network_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
701 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
702 /*!40101 SET character_set_client = @saved_cs_client */;
705 -- Table structure for table `northbound_request_ref_lookup`
708 DROP TABLE IF EXISTS `northbound_request_ref_lookup`;
709 /*!40101 SET @saved_cs_client = @@character_set_client */;
710 /*!40101 SET character_set_client = utf8 */;
711 CREATE TABLE `northbound_request_ref_lookup` (
712 `id` int(11) NOT NULL AUTO_INCREMENT,
713 `REQUEST_SCOPE` varchar(200) NOT NULL,
714 `MACRO_ACTION` varchar(200) NOT NULL,
715 `ACTION` varchar(200) NOT NULL,
716 `IS_ALACARTE` tinyint(1) NOT NULL DEFAULT '0',
717 `MIN_API_VERSION` double NOT NULL,
718 `MAX_API_VERSION` double DEFAULT NULL,
719 `IS_TOPLEVELFLOW` tinyint(1) DEFAULT NULL,
720 `CLOUD_OWNER` varchar(200) NOT NULL,
722 UNIQUE KEY `UK_northbound_request_ref_lookup` (`MIN_API_VERSION`,`REQUEST_SCOPE`,`ACTION`,`IS_ALACARTE`,`MACRO_ACTION`,`CLOUD_OWNER`)
723 ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;
724 /*!40101 SET character_set_client = @saved_cs_client */;
727 -- Table structure for table `orchestration_flow_reference`
730 DROP TABLE IF EXISTS `orchestration_flow_reference`;
731 /*!40101 SET @saved_cs_client = @@character_set_client */;
732 /*!40101 SET character_set_client = utf8 */;
733 CREATE TABLE `orchestration_flow_reference` (
734 `id` int(11) NOT NULL AUTO_INCREMENT,
735 `COMPOSITE_ACTION` varchar(200) NOT NULL,
736 `SEQ_NO` int(11) NOT NULL,
737 `FLOW_NAME` varchar(200) NOT NULL,
738 `FLOW_VERSION` double NOT NULL,
739 `SCOPE` varchar(200) DEFAULT NULL,
740 `ACTION` varchar(200) DEFAULT NULL,
741 `NB_REQ_REF_LOOKUP_ID` int(11) NOT NULL,
743 UNIQUE KEY `UK_orchestration_flow_reference` (`COMPOSITE_ACTION`,`FLOW_NAME`,`SEQ_NO`,`NB_REQ_REF_LOOKUP_ID`),
744 KEY `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID`),
745 KEY `fk_orchestration_flow_reference__building_block_detail` (`FLOW_NAME`),
746 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
747 ) ENGINE=InnoDB AUTO_INCREMENT=398 DEFAULT CHARSET=latin1;
748 /*!40101 SET character_set_client = @saved_cs_client */;
751 -- Table structure for table `orchestration_status_state_transition_directive`
754 DROP TABLE IF EXISTS `orchestration_status_state_transition_directive`;
755 /*!40101 SET @saved_cs_client = @@character_set_client */;
756 /*!40101 SET character_set_client = utf8 */;
757 CREATE TABLE `orchestration_status_state_transition_directive` (
758 `id` int(11) NOT NULL AUTO_INCREMENT,
759 `RESOURCE_TYPE` varchar(25) NOT NULL,
760 `ORCHESTRATION_STATUS` varchar(25) NOT NULL,
761 `TARGET_ACTION` varchar(25) NOT NULL,
762 `FLOW_DIRECTIVE` varchar(25) NOT NULL,
764 UNIQUE KEY `UK_orchestration_status_state_transition_directive` (`RESOURCE_TYPE`,`ORCHESTRATION_STATUS`,`TARGET_ACTION`)
765 ) ENGINE=InnoDB AUTO_INCREMENT=686 DEFAULT CHARSET=latin1;
766 /*!40101 SET character_set_client = @saved_cs_client */;
769 -- Table structure for table `rainy_day_handler_macro`
772 DROP TABLE IF EXISTS `rainy_day_handler_macro`;
773 /*!40101 SET @saved_cs_client = @@character_set_client */;
774 /*!40101 SET character_set_client = utf8 */;
775 CREATE TABLE `rainy_day_handler_macro` (
776 `id` int(11) NOT NULL AUTO_INCREMENT,
777 `FLOW_NAME` varchar(200) NOT NULL,
778 `SERVICE_TYPE` varchar(200) NOT NULL,
779 `VNF_TYPE` varchar(200) NOT NULL,
780 `ERROR_CODE` varchar(200) NOT NULL,
781 `WORK_STEP` varchar(200) NOT NULL,
782 `POLICY` varchar(200) NOT NULL,
783 `SECONDARY_POLICY` varchar(200) DEFAULT NULL,
785 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
786 /*!40101 SET character_set_client = @saved_cs_client */;
789 -- Table structure for table `service`
792 DROP TABLE IF EXISTS `service`;
793 /*!40101 SET @saved_cs_client = @@character_set_client */;
794 /*!40101 SET character_set_client = utf8 */;
795 CREATE TABLE `service` (
796 `MODEL_UUID` varchar(200) NOT NULL,
797 `MODEL_NAME` varchar(200) NOT NULL,
798 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
799 `MODEL_VERSION` varchar(20) NOT NULL,
800 `DESCRIPTION` varchar(1200) DEFAULT NULL,
801 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
802 `TOSCA_CSAR_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
803 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
804 `SERVICE_ROLE` varchar(200) DEFAULT NULL,
805 `ENVIRONMENT_CONTEXT` varchar(200) DEFAULT NULL,
806 `WORKLOAD_CONTEXT` varchar(200) DEFAULT NULL,
807 `SERVICE_CATEGORY` varchar(200) DEFAULT NULL,
808 `RESOURCE_ORDER` varchar(200) default NULL,
809 `OVERALL_DISTRIBUTION_STATUS` varchar(45),
810 `ONAP_GENERATED_NAMING` TINYINT(1) DEFAULT NULL,
811 `NAMING_POLICY` varchar(200) DEFAULT NULL,
812 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
813 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
814 `CONTROLLER_ACTOR` varchar(200) DEFAULT NULL,
815 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
816 PRIMARY KEY (`MODEL_UUID`),
817 KEY `fk_service__tosca_csar1_idx` (`TOSCA_CSAR_ARTIFACT_UUID`),
818 CONSTRAINT `fk_service__tosca_csar1` FOREIGN KEY (`TOSCA_CSAR_ARTIFACT_UUID`) REFERENCES `tosca_csar` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
819 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
820 /*!40101 SET character_set_client = @saved_cs_client */;
823 -- Table structure for table `service_proxy_customization`
826 DROP TABLE IF EXISTS `service_proxy_customization`;
827 /*!40101 SET @saved_cs_client = @@character_set_client */;
828 /*!40101 SET character_set_client = utf8 */;
829 CREATE TABLE `service_proxy_customization` (
830 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
831 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
832 `MODEL_UUID` varchar(200) NOT NULL,
833 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
834 `MODEL_VERSION` varchar(20) NOT NULL,
835 `MODEL_NAME` varchar(200) NOT NULL,
836 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
837 `DESCRIPTION` varchar(1200) DEFAULT NULL,
838 `SOURCE_SERVICE_MODEL_UUID` varchar(200) NOT NULL,
839 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
840 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
841 KEY `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID`),
842 CONSTRAINT `fk_service_proxy_resource_customization__service1` FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
843 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
844 /*!40101 SET character_set_client = @saved_cs_client */;
847 -- Table structure for table `service_proxy_customization_to_service`
850 DROP TABLE IF EXISTS `service_proxy_customization_to_service`;
851 /*!40101 SET @saved_cs_client = @@character_set_client */;
852 /*!40101 SET character_set_client = utf8 */;
853 CREATE TABLE `service_proxy_customization_to_service` (
854 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
855 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
856 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
857 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
858 /*!40101 SET character_set_client = @saved_cs_client */;
861 -- Table structure for table `service_recipe`
864 DROP TABLE IF EXISTS `service_recipe`;
865 /*!40101 SET @saved_cs_client = @@character_set_client */;
866 /*!40101 SET character_set_client = utf8 */;
867 CREATE TABLE `service_recipe` (
868 `id` int(11) NOT NULL AUTO_INCREMENT,
869 `ACTION` varchar(50) NOT NULL,
870 `VERSION_STR` varchar(20) DEFAULT NULL,
871 `DESCRIPTION` varchar(1200) DEFAULT NULL,
872 `ORCHESTRATION_URI` varchar(256) NOT NULL,
873 `SERVICE_PARAM_XSD` varchar(2048) DEFAULT NULL,
874 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
875 `SERVICE_TIMEOUT_INTERIM` int(11) DEFAULT NULL,
876 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
877 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
879 UNIQUE KEY `UK_7fav5dkux2v8g9d2i5ymudlgc` (`SERVICE_MODEL_UUID`,`ACTION`),
880 KEY `fk_service_recipe__service1_idx` (`SERVICE_MODEL_UUID`),
881 CONSTRAINT `fk_service_recipe__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
882 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
883 /*!40101 SET character_set_client = @saved_cs_client */;
886 -- Table structure for table `temp_network_heat_template_lookup`
889 DROP TABLE IF EXISTS `temp_network_heat_template_lookup`;
890 /*!40101 SET @saved_cs_client = @@character_set_client */;
891 /*!40101 SET character_set_client = utf8 */;
892 CREATE TABLE `temp_network_heat_template_lookup` (
893 `NETWORK_RESOURCE_MODEL_NAME` varchar(200) NOT NULL,
894 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
895 `AIC_VERSION_MIN` varchar(20) NULL,
896 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
897 PRIMARY KEY (`NETWORK_RESOURCE_MODEL_NAME`),
898 KEY `fk_temp_network_heat_template_lookup__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
899 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
900 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
901 /*!40101 SET character_set_client = @saved_cs_client */;
904 -- Table structure for table `tosca_csar`
907 DROP TABLE IF EXISTS `tosca_csar`;
908 /*!40101 SET @saved_cs_client = @@character_set_client */;
909 /*!40101 SET character_set_client = utf8 */;
910 CREATE TABLE `tosca_csar` (
911 `ARTIFACT_UUID` varchar(200) NOT NULL,
912 `NAME` varchar(200) NOT NULL,
913 `VERSION` varchar(20) NOT NULL,
914 `DESCRIPTION` varchar(1200) DEFAULT NULL,
915 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL,
916 `URL` varchar(200) NOT NULL,
917 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
918 PRIMARY KEY (`ARTIFACT_UUID`)
919 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
920 /*!40101 SET character_set_client = @saved_cs_client */;
923 -- Table structure for table `vf_module`
926 DROP TABLE IF EXISTS `vf_module`;
927 /*!40101 SET @saved_cs_client = @@character_set_client */;
928 /*!40101 SET character_set_client = utf8 */;
929 CREATE TABLE `vf_module` (
930 `MODEL_UUID` varchar(200) NOT NULL,
931 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
932 `MODEL_VERSION` varchar(20) NOT NULL,
933 `MODEL_NAME` varchar(200) NOT NULL,
934 `DESCRIPTION` varchar(1200) DEFAULT NULL,
935 `IS_BASE` tinyint(1) NOT NULL,
936 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
937 `VOL_HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
938 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
939 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
940 PRIMARY KEY (`MODEL_UUID`,`VNF_RESOURCE_MODEL_UUID`),
941 KEY `fk_vf_module__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
942 KEY `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
943 KEY `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`VOL_HEAT_TEMPLATE_ARTIFACT_UUID`),
944 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,
945 CONSTRAINT `fk_vf_module__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
946 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
947 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
948 /*!40101 SET character_set_client = @saved_cs_client */;
951 -- Table structure for table `vf_module_customization`
954 DROP TABLE IF EXISTS `vf_module_customization`;
955 /*!40101 SET @saved_cs_client = @@character_set_client */;
956 /*!40101 SET character_set_client = utf8 */;
957 CREATE TABLE `vf_module_customization` (
958 `ID` int(13) NOT NULL AUTO_INCREMENT,
959 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
960 `LABEL` varchar(200) DEFAULT NULL,
961 `INITIAL_COUNT` int(11) DEFAULT '0',
962 `MIN_INSTANCES` int(11) DEFAULT '0',
963 `MAX_INSTANCES` int(11) DEFAULT NULL,
964 `AVAILABILITY_ZONE_COUNT` int(11) DEFAULT NULL,
965 `HEAT_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
966 `VOL_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
967 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
968 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
969 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
970 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
972 KEY `fk_vf_module_customization__vf_module1_idx` (`VF_MODULE_MODEL_UUID`),
973 KEY `fk_vf_module_customization__heat_env__heat_environment1_idx` (`HEAT_ENVIRONMENT_ARTIFACT_UUID`),
974 KEY `fk_vf_module_customization__vol_env__heat_environment2_idx` (`VOL_ENVIRONMENT_ARTIFACT_UUID`),
975 KEY `fk_vf_module_customization_to_vnf_resource_customization` (`VNF_RESOURCE_CUSTOMIZATION_ID`),
976 KEY `vf_module_customization_model_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
977 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,
978 CONSTRAINT `fk_vf_module_customization__vf_module1` FOREIGN KEY (`VF_MODULE_MODEL_UUID`) REFERENCES `vf_module` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
979 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,
980 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
981 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
982 /*!40101 SET character_set_client = @saved_cs_client */;
985 -- Table structure for table `vf_module_to_heat_files`
988 DROP TABLE IF EXISTS `vf_module_to_heat_files`;
989 /*!40101 SET @saved_cs_client = @@character_set_client */;
990 /*!40101 SET character_set_client = utf8 */;
991 CREATE TABLE `vf_module_to_heat_files` (
992 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
993 `HEAT_FILES_ARTIFACT_UUID` varchar(200) NOT NULL,
994 PRIMARY KEY (`VF_MODULE_MODEL_UUID`,`HEAT_FILES_ARTIFACT_UUID`),
995 KEY `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`HEAT_FILES_ARTIFACT_UUID`),
996 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,
997 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
998 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='il fait ce qu''il dit';
999 /*!40101 SET character_set_client = @saved_cs_client */;
1002 -- Table structure for table `vnf_components`
1005 DROP TABLE IF EXISTS `vnf_components`;
1006 /*!40101 SET @saved_cs_client = @@character_set_client */;
1007 /*!40101 SET character_set_client = utf8 */;
1008 CREATE TABLE `vnf_components` (
1009 `VNF_ID` int(11) NOT NULL,
1010 `COMPONENT_TYPE` varchar(20) NOT NULL,
1011 `HEAT_TEMPLATE_ID` int(11) DEFAULT NULL,
1012 `HEAT_ENVIRONMENT_ID` int(11) DEFAULT NULL,
1013 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1014 PRIMARY KEY (`VNF_ID`,`COMPONENT_TYPE`)
1015 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1016 /*!40101 SET character_set_client = @saved_cs_client */;
1019 -- Table structure for table `vnf_components_recipe`
1022 DROP TABLE IF EXISTS `vnf_components_recipe`;
1023 /*!40101 SET @saved_cs_client = @@character_set_client */;
1024 /*!40101 SET character_set_client = utf8 */;
1025 CREATE TABLE `vnf_components_recipe` (
1026 `id` int(11) NOT NULL AUTO_INCREMENT,
1027 `VNF_TYPE` varchar(200) DEFAULT NULL,
1028 `VNF_COMPONENT_TYPE` varchar(45) NOT NULL,
1029 `ACTION` varchar(50) NOT NULL,
1030 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1031 `VERSION` varchar(20) NOT NULL,
1032 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1033 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1034 `VNF_COMPONENT_PARAM_XSD` varchar(2048) DEFAULT NULL,
1035 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1036 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1037 `VF_MODULE_MODEL_UUID` varchar(200) DEFAULT NULL,
1039 UNIQUE KEY `UK_4dpdwddaaclhc11wxsb7h59ma` (`VF_MODULE_MODEL_UUID`,`VNF_COMPONENT_TYPE`,`ACTION`,`VERSION`)
1040 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
1041 /*!40101 SET character_set_client = @saved_cs_client */;
1044 -- Table structure for table `vnf_recipe`
1047 DROP TABLE IF EXISTS `vnf_recipe`;
1048 /*!40101 SET @saved_cs_client = @@character_set_client */;
1049 /*!40101 SET character_set_client = utf8 */;
1050 CREATE TABLE `vnf_recipe` (
1051 `id` int(11) NOT NULL AUTO_INCREMENT,
1052 `NF_ROLE` varchar(200) DEFAULT NULL,
1053 `ACTION` varchar(50) NOT NULL,
1054 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1055 `VERSION_STR` varchar(20) NOT NULL,
1056 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1057 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1058 `VNF_PARAM_XSD` varchar(2048) DEFAULT NULL,
1059 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1060 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1061 `VF_MODULE_ID` varchar(100) DEFAULT NULL,
1063 UNIQUE KEY `UK_f3tvqau498vrifq3cr8qnigkr` (`VF_MODULE_ID`,`ACTION`,`VERSION_STR`)
1064 ) ENGINE=InnoDB AUTO_INCREMENT=10015 DEFAULT CHARSET=latin1;
1065 /*!40101 SET character_set_client = @saved_cs_client */;
1068 -- Table structure for table `vnf_resource`
1071 DROP TABLE IF EXISTS `vnf_resource`;
1072 /*!40101 SET @saved_cs_client = @@character_set_client */;
1073 /*!40101 SET character_set_client = utf8 */;
1074 CREATE TABLE `vnf_resource` (
1075 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
1076 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1077 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1078 `MODEL_UUID` varchar(200) NOT NULL,
1079 `AIC_VERSION_MIN` varchar(20) DEFAULT NULL,
1080 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
1081 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1082 `MODEL_VERSION` varchar(20) NOT NULL,
1083 `MODEL_NAME` varchar(200) DEFAULT NULL,
1084 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1085 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
1086 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1087 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1088 PRIMARY KEY (`MODEL_UUID`),
1089 KEY `fk_vnf_resource__heat_template1` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
1090 CONSTRAINT `fk_vnf_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1091 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1092 /*!40101 SET character_set_client = @saved_cs_client */;
1095 -- Table structure for table `vnf_resource_customization`
1098 DROP TABLE IF EXISTS `vnf_resource_customization`;
1099 /*!40101 SET @saved_cs_client = @@character_set_client */;
1100 /*!40101 SET character_set_client = utf8 */;
1101 CREATE TABLE `vnf_resource_customization` (
1102 `ID` int(13) NOT NULL AUTO_INCREMENT,
1103 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1104 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1105 `MIN_INSTANCES` int(11) DEFAULT NULL,
1106 `MAX_INSTANCES` int(11) DEFAULT NULL,
1107 `AVAILABILITY_ZONE_MAX_COUNT` int(11) DEFAULT NULL,
1108 `NF_TYPE` varchar(200) DEFAULT NULL,
1109 `NF_ROLE` varchar(200) DEFAULT NULL,
1110 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1111 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1112 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1113 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
1114 `CDS_BLUEPRINT_NAME` varchar(200) default null,
1115 `CDS_BLUEPRINT_VERSION` varchar(20) default null,
1116 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1117 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1118 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1119 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1120 `NF_DATA_VALID` tinyint(1) DEFAULT '0',
1121 `VNFCINSTANCEGROUP_ORDER` varchar(200) default NULL,
1122 `CONTROLLER_ACTOR` varchar(200) DEFAULT NULL,
1124 UNIQUE KEY `UK_vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`,`SERVICE_MODEL_UUID`),
1125 KEY `fk_vnf_resource_customization__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
1126 KEY `fk_vnf_resource_customization_to_service` (`SERVICE_MODEL_UUID`),
1127 KEY `vnf_resource_customization_mod_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
1128 CONSTRAINT `fk_vnf_resource_customization__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1129 CONSTRAINT `fk_vnf_resource_customization_to_service` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1130 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1131 /*!40101 SET character_set_client = @saved_cs_client */;
1134 -- Table structure for table `vnfc_customization`
1137 DROP TABLE IF EXISTS `vnfc_customization`;
1138 /*!40101 SET @saved_cs_client = @@character_set_client */;
1139 /*!40101 SET character_set_client = utf8 */;
1140 CREATE TABLE `vnfc_customization` (
1141 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1142 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1143 `MODEL_UUID` varchar(200) NOT NULL,
1144 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
1145 `MODEL_VERSION` varchar(20) NOT NULL,
1146 `MODEL_NAME` varchar(200) NOT NULL,
1147 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
1148 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1149 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
1150 `VNFC_INSTANCE_GROUP_CUSTOMIZATION_ID` integer DEFAULT NULL,
1151 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1152 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`)
1153 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1154 /*!40101 SET character_set_client = @saved_cs_client */;
1157 -- Table structure for table `vnfc_instance_group_customization`
1160 DROP TABLE IF EXISTS `vnfc_instance_group_customization`;
1161 /*!40101 SET @saved_cs_client = @@character_set_client */;
1162 /*!40101 SET character_set_client = utf8 */;
1163 CREATE TABLE `vnfc_instance_group_customization` (
1164 `ID` int(13) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1165 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) NOT NULL,
1166 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
1167 `FUNCTION` varchar(200) DEFAULT NULL,
1168 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1169 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1170 KEY `fk_vnfc_instance_group_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
1171 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,
1172 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
1173 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1174 set foreign_key_checks=1;
1176 CREATE TABLE IF NOT EXISTS `pnf_resource` (
1177 `ORCHESTRATION_MODE` varchar(20) DEFAULT NULL,
1178 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1179 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1180 `MODEL_UUID` varchar(200) NOT NULL,
1181 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1182 `MODEL_VERSION` varchar(20) NOT NULL,
1183 `MODEL_NAME` varchar(200) DEFAULT NULL,
1184 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1185 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1186 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1187 PRIMARY KEY (`MODEL_UUID`)
1188 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1190 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
1191 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1192 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1193 `NF_TYPE` varchar(200) DEFAULT NULL,
1194 `NF_ROLE` varchar(200) DEFAULT NULL,
1195 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1196 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1197 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1198 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1199 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1200 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
1201 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
1202 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
1203 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1204 `CONTROLLER_ACTOR` varchar(200) DEFAULT NULL,
1205 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
1206 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
1207 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1208 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1210 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
1211 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1212 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1213 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
1214 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
1216 CREATE TABLE IF NOT EXISTS `workflow` (
1217 `ID` int(11) NOT NULL AUTO_INCREMENT,
1218 `ARTIFACT_UUID` varchar(200) NOT NULL,
1219 `ARTIFACT_NAME` varchar(200) NOT NULL,
1220 `NAME` varchar(200) NOT NULL,
1221 `OPERATION_NAME` varchar(200) DEFAULT NULL,
1222 `VERSION` double NOT NULL,
1223 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1224 `BODY` longtext DEFAULT NULL,
1225 `RESOURCE_TARGET` varchar(200) NOT NULL,
1226 `SOURCE` varchar(200) NOT NULL,
1227 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
1228 `ARTIFACT_CHECKSUM` varchar(200) DEFAULT 'MANUAL RECORD',
1229 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT current_timestamp(),
1231 UNIQUE KEY `UK_workflow` (`ARTIFACT_UUID`,`NAME`,`VERSION`,`SOURCE`)
1232 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1234 CREATE TABLE IF NOT EXISTS `vnf_resource_to_workflow` (
1235 `ID` int(11) NOT NULL AUTO_INCREMENT,
1236 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1237 `WORKFLOW_ID` int(11) NOT NULL,
1239 UNIQUE KEY `UK_vnf_resource_to_workflow` (`VNF_RESOURCE_MODEL_UUID`,`WORKFLOW_ID`),
1240 KEY `fk_vnf_resource_to_workflow__workflow1_idx` (`WORKFLOW_ID`),
1241 KEY `fk_vnf_resource_to_workflow__vnf_res_mod_uuid_idx` (`VNF_RESOURCE_MODEL_UUID`),
1242 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,
1243 CONSTRAINT `fk_vnf_resource_to_workflow__workflow1` FOREIGN KEY (`WORKFLOW_ID`) REFERENCES `workflow` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
1244 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1246 CREATE TABLE IF NOT EXISTS `pnf_resource_to_workflow` (
1247 `ID` int(11) NOT NULL AUTO_INCREMENT,
1248 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1249 `WORKFLOW_ID` int(11) NOT NULL,
1251 UNIQUE KEY `UK_pnf_resource_to_workflow` (`PNF_RESOURCE_MODEL_UUID`,`WORKFLOW_ID`),
1252 KEY `fk_pnf_resource_to_workflow__workflow1_idx` (`WORKFLOW_ID`),
1253 KEY `fk_pnf_resource_to_workflow__pnf_res_mod_uuid_idx` (`PNF_RESOURCE_MODEL_UUID`),
1254 CONSTRAINT `fk_pnf_resource_to_workflow__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1255 CONSTRAINT `fk_pnf_resource_to_workflow__workflow1` FOREIGN KEY (`WORKFLOW_ID`) REFERENCES `workflow` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
1256 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1258 CREATE TABLE IF NOT EXISTS `activity_spec` (
1259 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1260 `NAME` VARCHAR(200) NOT NULL,
1261 `DESCRIPTION` VARCHAR(1200) NOT NULL,
1262 `VERSION` DOUBLE NOT NULL,
1263 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1265 UNIQUE INDEX `UK_activity_spec` (`NAME` ASC, `VERSION` ASC))
1267 DEFAULT CHARACTER SET = latin1;
1269 CREATE TABLE IF NOT EXISTS `user_parameters` (
1270 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1271 `NAME` VARCHAR(200) NOT NULL,
1272 `PAYLOAD_LOCATION` VARCHAR(500) NULL,
1273 `LABEL` VARCHAR(200) NOT NULL,
1274 `TYPE` VARCHAR(200) NOT NULL,
1275 `DESCRIPTION` VARCHAR(1200) NULL,
1276 `IS_REQUIRED` TINYINT(1) NOT NULL,
1277 `MAX_LENGTH` INT(11) NULL,
1278 `ALLOWABLE_CHARS` VARCHAR(200) NULL,
1279 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1281 UNIQUE INDEX `UK_user_parameters` (`NAME` ASC))
1283 DEFAULT CHARACTER SET = latin1;
1285 CREATE TABLE IF NOT EXISTS `workflow_activity_spec_sequence` (
1286 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1287 `WORKFLOW_ID` INT(11) NOT NULL,
1288 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1289 `SEQ_NO` INT(11) NOT NULL,
1291 UNIQUE INDEX `UK_workflow_activity_spec_sequence` (`WORKFLOW_ID` ASC, `ACTIVITY_SPEC_ID` ASC, `SEQ_NO` ASC),
1292 INDEX `fk_workflow_activity_spec_sequence__activity_spec_idx` (`ACTIVITY_SPEC_ID` ASC),
1293 INDEX `fk_workflow_activity_spec_sequence__workflow_actifact_uuid_idx` (`WORKFLOW_ID` ASC),
1294 CONSTRAINT `fk_workflow_activity_spec_sequence__activity_spec1`
1295 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1296 REFERENCES `activity_spec` (`ID`)
1299 CONSTRAINT `fk_workflow_activity_spec_sequence__workflow1`
1300 FOREIGN KEY (`WORKFLOW_ID`)
1301 REFERENCES `workflow` (`ID`)
1305 DEFAULT CHARACTER SET = latin1;
1307 CREATE TABLE IF NOT EXISTS `activity_spec_parameters` (
1308 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1309 `NAME` VARCHAR(200) NOT NULL,
1310 `TYPE` VARCHAR(200) NOT NULL,
1311 `DIRECTION` VARCHAR(200) NULL,
1312 `DESCRIPTION` VARCHAR(1200) NULL,
1313 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1315 UNIQUE INDEX `UK_activity_spec_parameters` (`NAME` ASC, `DIRECTION` ASC))
1317 DEFAULT CHARACTER SET = latin1;
1319 CREATE TABLE IF NOT EXISTS `activity_spec_categories` (
1320 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1321 `NAME` VARCHAR(200) NOT NULL,
1323 UNIQUE INDEX `UK_activity_spec_categories` (`NAME` ASC))
1325 DEFAULT CHARACTER SET = latin1;
1327 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_categories` (
1328 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1329 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1330 `ACTIVITY_SPEC_CATEGORIES_ID` INT(11) NOT NULL,
1332 UNIQUE INDEX `UK_activity_spec_to_activity_spec_categories` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1333 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx` (`ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1334 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx1` (`ACTIVITY_SPEC_ID` ASC),
1335 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec1`
1336 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1337 REFERENCES `activity_spec` (`ID`)
1340 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec_c1`
1341 FOREIGN KEY (`ACTIVITY_SPEC_CATEGORIES_ID`)
1342 REFERENCES `activity_spec_categories` (`ID`)
1346 DEFAULT CHARACTER SET = latin1;
1348 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_parameters` (
1349 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1350 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1351 `ACTIVITY_SPEC_PARAMETERS_ID` INT(11) NOT NULL,
1353 INDEX `fk_activity_spec_to_activity_spec_params__act_sp_param_id_idx` (`ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1354 UNIQUE INDEX `UK_activity_spec_to_activity_spec_parameters` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1355 INDEX `fk_activity_spec_to_activity_spec_parameters__act_spec_id_idx` (`ACTIVITY_SPEC_ID` ASC),
1356 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activity_spec_1`
1357 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1358 REFERENCES `activity_spec` (`ID`)
1361 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activ_spec_param1`
1362 FOREIGN KEY (`ACTIVITY_SPEC_PARAMETERS_ID`)
1363 REFERENCES `activity_spec_parameters` (`ID`)
1367 DEFAULT CHARACTER SET = latin1;
1369 CREATE TABLE IF NOT EXISTS `activity_spec_to_user_parameters` (
1370 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1371 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1372 `USER_PARAMETERS_ID` INT(11) NOT NULL,
1374 UNIQUE INDEX `UK_activity_spec_to_user_parameters` (`ACTIVITY_SPEC_ID` ASC, `USER_PARAMETERS_ID` ASC),
1375 INDEX `fk_activity_spec_to_user_parameters__user_parameters1_idx` (`USER_PARAMETERS_ID` ASC),
1376 INDEX `fk_activity_spec_to_user_parameters__activity_spec1_idx` (`ACTIVITY_SPEC_ID` ASC),
1377 CONSTRAINT `fk_activity_spec_to_user_parameters__activity_spec1`
1378 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1379 REFERENCES `activity_spec` (`ID`)
1382 CONSTRAINT `fk_activity_spec_to_user_parameters__user_parameters1`
1383 FOREIGN KEY (`USER_PARAMETERS_ID`)
1384 REFERENCES `user_parameters` (`ID`)
1388 DEFAULT CHARACTER SET = latin1;
1391 -- Table structure for table `bbname_selection_reference`
1394 DROP TABLE IF EXISTS `bbname_selection_reference`;
1395 CREATE TABLE IF NOT EXISTS `bbname_selection_reference` (
1396 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1397 `CONTROLLER_ACTOR` varchar(200) NOT NULL ,
1398 `SCOPE` varchar(200) NOT NULL,
1399 `ACTION` varchar(200) NOT NULL,
1400 `BB_NAME` varchar(200) NOT NULL,
1402 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;