2 --------START Catalog DB SCHEMA --------
4 set foreign_key_checks=0;
5 DROP TABLE IF EXISTS `allotted_resource`;
6 /*!40101 SET @saved_cs_client = @@character_set_client */;
7 /*!40101 SET character_set_client = utf8 */;
8 CREATE TABLE `allotted_resource` (
9 `MODEL_UUID` varchar(200) NOT NULL,
10 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
11 `MODEL_VERSION` varchar(20) NOT NULL,
12 `MODEL_NAME` varchar(200) NOT NULL,
13 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
14 `SUBCATEGORY` varchar(200) DEFAULT NULL,
15 `DESCRIPTION` varchar(1200) DEFAULT NULL,
16 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
17 PRIMARY KEY (`MODEL_UUID`)
18 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
19 /*!40101 SET character_set_client = @saved_cs_client */;
22 -- Table structure for table `allotted_resource_customization`
25 DROP TABLE IF EXISTS `allotted_resource_customization`;
26 /*!40101 SET @saved_cs_client = @@character_set_client */;
27 /*!40101 SET character_set_client = utf8 */;
28 CREATE TABLE `allotted_resource_customization` (
29 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
30 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
31 `PROVIDING_SERVICE_MODEL_UUID` varchar(200) DEFAULT NULL,
32 `PROVIDING_SERVICE_MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
33 `PROVIDING_SERVICE_MODEL_NAME` varchar(200) DEFAULT NULL,
34 `TARGET_NETWORK_ROLE` varchar(200) DEFAULT NULL,
35 `NF_TYPE` varchar(200) DEFAULT NULL,
36 `NF_ROLE` varchar(200) DEFAULT NULL,
37 `NF_FUNCTION` varchar(200) DEFAULT NULL,
38 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
39 `MIN_INSTANCES` int(11) DEFAULT NULL,
40 `MAX_INSTANCES` int(11) DEFAULT NULL,
41 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
42 `AR_MODEL_UUID` varchar(200) NOT NULL,
43 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
44 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
45 KEY `fk_allotted_resource_customization__allotted_resource1_idx` (`AR_MODEL_UUID`),
46 CONSTRAINT `fk_allotted_resource_customization__allotted_resource1` FOREIGN KEY (`AR_MODEL_UUID`) REFERENCES `allotted_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
47 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48 /*!40101 SET character_set_client = @saved_cs_client */;
51 -- Table structure for table `allotted_resource_customization_to_service`
54 DROP TABLE IF EXISTS `allotted_resource_customization_to_service`;
55 /*!40101 SET @saved_cs_client = @@character_set_client */;
56 /*!40101 SET character_set_client = utf8 */;
57 CREATE TABLE `allotted_resource_customization_to_service` (
58 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
59 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
60 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
61 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
62 CONSTRAINT `allotted_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
63 CONSTRAINT `allotted_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `allotted_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
64 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65 /*!40101 SET character_set_client = @saved_cs_client */;
68 -- Table structure for table `ar_recipe`
71 DROP TABLE IF EXISTS `ar_recipe`;
72 /*!40101 SET @saved_cs_client = @@character_set_client */;
73 /*!40101 SET character_set_client = utf8 */;
74 CREATE TABLE `ar_recipe` (
75 `ID` int(11) NOT NULL AUTO_INCREMENT,
76 `MODEL_NAME` varchar(200) NOT NULL,
77 `ACTION` varchar(200) NOT NULL,
78 `VERSION_STR` varchar(200) NOT NULL,
79 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
80 `DESCRIPTION` varchar(200) DEFAULT NULL,
81 `ORCHESTRATION_URI` varchar(200) NOT NULL,
82 `AR_PARAM_XSD` varchar(200) DEFAULT NULL,
83 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
84 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
86 UNIQUE KEY `uk_ar_recipe` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
87 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88 /*!40101 SET character_set_client = @saved_cs_client */;
91 -- Table structure for table `building_block_detail`
94 DROP TABLE IF EXISTS `building_block_detail`;
95 /*!40101 SET @saved_cs_client = @@character_set_client */;
96 /*!40101 SET character_set_client = utf8 */;
97 CREATE TABLE `building_block_detail` (
98 `id` int(11) NOT NULL AUTO_INCREMENT,
99 `BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
100 `RESOURCE_TYPE` varchar(25) NOT NULL,
101 `TARGET_ACTION` varchar(25) NOT NULL,
103 UNIQUE KEY `UK_building_block_name` (`BUILDING_BLOCK_NAME`)
104 ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
105 /*!40101 SET character_set_client = @saved_cs_client */;
108 -- Table structure for table `cloud_sites`
111 DROP TABLE IF EXISTS `cloud_sites`;
112 /*!40101 SET @saved_cs_client = @@character_set_client */;
113 /*!40101 SET character_set_client = utf8 */;
114 CREATE TABLE `cloud_sites` (
115 `ID` varchar(50) NOT NULL,
116 `REGION_ID` varchar(11) DEFAULT NULL,
117 `IDENTITY_SERVICE_ID` varchar(50) DEFAULT NULL,
118 `CLOUD_VERSION` varchar(20) DEFAULT NULL,
119 `CLLI` varchar(11) DEFAULT NULL,
120 `CLOUDIFY_ID` varchar(50) DEFAULT NULL,
121 `PLATFORM` varchar(50) DEFAULT NULL,
122 `ORCHESTRATOR` varchar(50) DEFAULT NULL,
123 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
124 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
125 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
127 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
128 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)
129 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
130 /*!40101 SET character_set_client = @saved_cs_client */;
133 -- Table structure for table `cloudify_managers`
136 DROP TABLE IF EXISTS `cloudify_managers`;
137 /*!40101 SET @saved_cs_client = @@character_set_client */;
138 /*!40101 SET character_set_client = utf8 */;
139 CREATE TABLE `cloudify_managers` (
140 `ID` varchar(50) NOT NULL,
141 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
142 `USERNAME` varchar(255) DEFAULT NULL,
143 `PASSWORD` varchar(255) DEFAULT NULL,
144 `VERSION` varchar(20) DEFAULT NULL,
145 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
146 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
147 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
149 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
150 /*!40101 SET character_set_client = @saved_cs_client */;
153 -- Table structure for table `collection_network_resource_customization`
156 DROP TABLE IF EXISTS `collection_network_resource_customization`;
157 /*!40101 SET @saved_cs_client = @@character_set_client */;
158 /*!40101 SET character_set_client = utf8 */;
159 CREATE TABLE `collection_network_resource_customization` (
160 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
161 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
162 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
163 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
164 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
165 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
166 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
167 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
168 `INSTANCE_GROUP_MODEL_UUID` varchar(200) DEFAULT NULL,
169 `CRC_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
170 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`,`CRC_MODEL_CUSTOMIZATION_UUID`),
171 KEY `fk_collection_net_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
172 KEY `fk_collection_net_resource_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
173 KEY `fk_col_net_res_customization__collection_res_customization_idx` (`CRC_MODEL_CUSTOMIZATION_UUID`),
174 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,
175 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,
176 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
177 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
178 /*!40101 SET character_set_client = @saved_cs_client */;
181 -- Table structure for table `collection_resource`
184 DROP TABLE IF EXISTS `collection_resource`;
185 /*!40101 SET @saved_cs_client = @@character_set_client */;
186 /*!40101 SET character_set_client = utf8 */;
187 CREATE TABLE `collection_resource` (
188 `MODEL_UUID` varchar(200) NOT NULL,
189 `MODEL_NAME` varchar(200) NOT NULL,
190 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
191 `MODEL_VERSION` varchar(20) NOT NULL,
192 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
193 `DESCRIPTION` varchar(1200) DEFAULT NULL,
194 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
195 PRIMARY KEY (`MODEL_UUID`)
196 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
197 /*!40101 SET character_set_client = @saved_cs_client */;
200 -- Table structure for table `collection_resource_customization`
203 DROP TABLE IF EXISTS `collection_resource_customization`;
204 /*!40101 SET @saved_cs_client = @@character_set_client */;
205 /*!40101 SET character_set_client = utf8 */;
206 CREATE TABLE `collection_resource_customization` (
207 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
208 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
209 `role` varchar(200) DEFAULT NULL,
210 `object_type` varchar(200) NOT NULL,
211 `function` varchar(200) DEFAULT NULL,
212 `collection_resource_type` varchar(200) DEFAULT NULL,
213 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
214 `CR_MODEL_UUID` varchar(200) NOT NULL,
215 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
216 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`),
217 CONSTRAINT `collection_resource_customization_ibfk_1` FOREIGN KEY (`CR_MODEL_UUID`) REFERENCES `collection_resource` (`MODEL_UUID`) ON DELETE CASCADE
218 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
219 /*!40101 SET character_set_client = @saved_cs_client */;
222 -- Table structure for table `collection_resource_customization_to_service`
225 DROP TABLE IF EXISTS `collection_resource_customization_to_service`;
226 /*!40101 SET @saved_cs_client = @@character_set_client */;
227 /*!40101 SET character_set_client = utf8 */;
228 CREATE TABLE `collection_resource_customization_to_service` (
229 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
230 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
231 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
232 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
233 CONSTRAINT `collection_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
234 CONSTRAINT `collection_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `collection_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
235 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
236 /*!40101 SET character_set_client = @saved_cs_client */;
239 -- Table structure for table `collection_resource_instance_group_customization`
242 DROP TABLE IF EXISTS `collection_resource_instance_group_customization`;
243 /*!40101 SET @saved_cs_client = @@character_set_client */;
244 /*!40101 SET character_set_client = utf8 */;
245 CREATE TABLE `collection_resource_instance_group_customization` (
246 `COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID` varchar(200) NOT NULL,
247 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
248 `FUNCTION` varchar(200) DEFAULT NULL,
249 `DESCRIPTION` varchar(1200) DEFAULT NULL,
250 `SUBINTERFACE_NETWORK_QUANTITY` int(11) DEFAULT NULL,
251 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
252 PRIMARY KEY (`COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID`,`INSTANCE_GROUP_MODEL_UUID`),
253 KEY `fk_collection_resource_instance_group_customization__instan_idx` (`INSTANCE_GROUP_MODEL_UUID`),
254 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,
255 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
256 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
257 /*!40101 SET character_set_client = @saved_cs_client */;
260 -- Table structure for table `configuration`
263 DROP TABLE IF EXISTS `configuration`;
264 /*!40101 SET @saved_cs_client = @@character_set_client */;
265 /*!40101 SET character_set_client = utf8 */;
266 CREATE TABLE `configuration` (
267 `MODEL_UUID` varchar(200) NOT NULL,
268 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
269 `MODEL_VERSION` varchar(20) NOT NULL,
270 `MODEL_NAME` varchar(200) NOT NULL,
271 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
272 `DESCRIPTION` varchar(1200) DEFAULT NULL,
273 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
274 PRIMARY KEY (`MODEL_UUID`)
275 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
276 /*!40101 SET character_set_client = @saved_cs_client */;
279 -- Table structure for table `configuration_customization`
282 DROP TABLE IF EXISTS `configuration_customization`;
283 /*!40101 SET @saved_cs_client = @@character_set_client */;
284 /*!40101 SET character_set_client = utf8 */;
285 CREATE TABLE `configuration_customization` (
286 `ID` int(11) NOT NULL AUTO_INCREMENT,
287 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
288 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
289 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
290 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
291 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
292 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
293 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
294 `SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
295 `CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
296 `SERVICE_MODEL_UUID` varchar(200),
298 KEY `fk_configuration_customization__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
299 KEY `fk_configuration_customization__service_idx` (`SERVICE_MODEL_UUID`),
300 UNIQUE KEY `uk_configuration_customization` (`MODEL_CUSTOMIZATION_UUID` ASC, `SERVICE_MODEL_UUID` ASC),
301 CONSTRAINT `fk_configuration_customization__configuration1` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
302 REFERENCES `configuration` (`MODEL_UUID`)
303 ON DELETE CASCADE ON UPDATE CASCADE,
304 CONSTRAINT `fk_configuration_customization__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`)
305 REFERENCES `service` (`MODEL_UUID`)
306 ON DELETE CASCADE ON UPDATE CASCADE
307 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
308 /*!40101 SET character_set_client = @saved_cs_client */;
311 -- Table structure for table `controller_selection_reference`
314 DROP TABLE IF EXISTS `controller_selection_reference`;
315 /*!40101 SET @saved_cs_client = @@character_set_client */;
316 /*!40101 SET character_set_client = utf8 */;
317 CREATE TABLE `controller_selection_reference` (
318 `VNF_TYPE` varchar(50) NOT NULL,
319 `CONTROLLER_NAME` varchar(100) NOT NULL,
320 `ACTION_CATEGORY` varchar(15) NOT NULL,
321 PRIMARY KEY (`VNF_TYPE`,`CONTROLLER_NAME`,`ACTION_CATEGORY`)
322 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
323 /*!40101 SET character_set_client = @saved_cs_client */;
326 -- Table structure for table `cvnfc_configuration_customization`
329 DROP TABLE IF EXISTS `cvnfc_configuration_customization`;
330 /*!40101 SET @saved_cs_client = @@character_set_client */;
331 /*!40101 SET character_set_client = utf8 */;
332 CREATE TABLE `cvnfc_configuration_customization` (
333 `ID` int(11) NOT NULL AUTO_INCREMENT,
334 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
335 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
336 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
337 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
338 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
339 `POLICY_NAME` varchar(200) DEFAULT NULL,
340 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
341 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
342 `CVNFC_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
344 KEY `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
345 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
346 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
347 /*!40101 SET character_set_client = @saved_cs_client */;
350 -- Table structure for table `cvnfc_customization`
353 DROP TABLE IF EXISTS `cvnfc_customization`;
354 /*!40101 SET @saved_cs_client = @@character_set_client */;
355 /*!40101 SET character_set_client = utf8 */;
356 CREATE TABLE `cvnfc_customization` (
357 `ID` int(11) NOT NULL AUTO_INCREMENT,
358 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
359 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
360 `MODEL_UUID` varchar(200) NOT NULL,
361 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
362 `MODEL_VERSION` varchar(20) NOT NULL,
363 `MODEL_NAME` varchar(200) NOT NULL,
364 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
365 `DESCRIPTION` varchar(1200) DEFAULT NULL,
366 `NFC_FUNCTION` varchar(200) DEFAULT NULL,
367 `NFC_NAMING_CODE` varchar(200) DEFAULT NULL,
368 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
369 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
370 `VF_MODULE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
372 KEY `fk_cvnfc_customization__vnfc_customization1_idx` (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`),
373 KEY `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID`),
374 KEY `fk_cvnfc_customization_to_vf_module_resource_customization` (`VF_MODULE_CUSTOMIZATION_ID`),
375 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,
376 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
377 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
378 /*!40101 SET character_set_client = @saved_cs_client */;
381 -- Table structure for table `external_service_to_internal_model_mapping`
384 DROP TABLE IF EXISTS `external_service_to_internal_model_mapping`;
385 /*!40101 SET @saved_cs_client = @@character_set_client */;
386 /*!40101 SET character_set_client = utf8 */;
387 CREATE TABLE `external_service_to_internal_model_mapping` (
388 `id` int(11) NOT NULL AUTO_INCREMENT,
389 `SERVICE_NAME` varchar(200) NOT NULL,
390 `PRODUCT_FLAVOR` varchar(200) DEFAULT NULL,
391 `SUBSCRIPTION_SERVICE_TYPE` varchar(200) NOT NULL,
392 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
394 UNIQUE KEY `UK_external_service_to_internal_model_mapping` (`SERVICE_NAME`,`PRODUCT_FLAVOR`,`SERVICE_MODEL_UUID`)
395 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
396 /*!40101 SET character_set_client = @saved_cs_client */;
399 -- Table structure for table `flyway_schema_history`
402 DROP TABLE IF EXISTS `flyway_schema_history`;
403 /*!40101 SET @saved_cs_client = @@character_set_client */;
404 /*!40101 SET character_set_client = utf8 */;
405 CREATE TABLE `flyway_schema_history` (
406 `installed_rank` int(11) NOT NULL,
407 `version` varchar(50) DEFAULT NULL,
408 `description` varchar(200) NOT NULL,
409 `type` varchar(20) NOT NULL,
410 `script` varchar(1000) NOT NULL,
411 `checksum` int(11) DEFAULT NULL,
412 `installed_by` varchar(100) NOT NULL,
413 `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
414 `execution_time` int(11) NOT NULL,
415 `success` tinyint(1) NOT NULL,
416 PRIMARY KEY (`installed_rank`),
417 KEY `flyway_schema_history_s_idx` (`success`)
418 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
419 /*!40101 SET character_set_client = @saved_cs_client */;
422 -- Table structure for table `heat_environment`
425 DROP TABLE IF EXISTS `heat_environment`;
426 /*!40101 SET @saved_cs_client = @@character_set_client */;
427 /*!40101 SET character_set_client = utf8 */;
428 CREATE TABLE `heat_environment` (
429 `ARTIFACT_UUID` varchar(200) NOT NULL,
430 `NAME` varchar(100) NOT NULL,
431 `VERSION` varchar(20) NOT NULL,
432 `DESCRIPTION` varchar(1200) DEFAULT NULL,
433 `BODY` longtext NOT NULL,
434 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
435 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
436 PRIMARY KEY (`ARTIFACT_UUID`)
437 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
438 /*!40101 SET character_set_client = @saved_cs_client */;
441 -- Table structure for table `heat_files`
444 DROP TABLE IF EXISTS `heat_files`;
445 /*!40101 SET @saved_cs_client = @@character_set_client */;
446 /*!40101 SET character_set_client = utf8 */;
447 CREATE TABLE `heat_files` (
448 `ARTIFACT_UUID` varchar(200) NOT NULL,
449 `NAME` varchar(200) NOT NULL,
450 `VERSION` varchar(20) NOT NULL,
451 `DESCRIPTION` varchar(1200) DEFAULT NULL,
452 `BODY` longtext NOT NULL,
453 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
454 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
455 PRIMARY KEY (`ARTIFACT_UUID`)
456 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
457 /*!40101 SET character_set_client = @saved_cs_client */;
460 -- Table structure for table `heat_nested_template`
463 DROP TABLE IF EXISTS `heat_nested_template`;
464 /*!40101 SET @saved_cs_client = @@character_set_client */;
465 /*!40101 SET character_set_client = utf8 */;
466 CREATE TABLE `heat_nested_template` (
467 `PARENT_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
468 `CHILD_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
469 `PROVIDER_RESOURCE_FILE` varchar(100) DEFAULT NULL,
470 PRIMARY KEY (`PARENT_HEAT_TEMPLATE_UUID`,`CHILD_HEAT_TEMPLATE_UUID`),
471 KEY `fk_heat_nested_template__heat_template2_idx` (`CHILD_HEAT_TEMPLATE_UUID`),
472 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,
473 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
474 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
475 /*!40101 SET character_set_client = @saved_cs_client */;
478 -- Table structure for table `heat_template`
481 DROP TABLE IF EXISTS `heat_template`;
482 /*!40101 SET @saved_cs_client = @@character_set_client */;
483 /*!40101 SET character_set_client = utf8 */;
484 CREATE TABLE `heat_template` (
485 `ARTIFACT_UUID` varchar(200) NOT NULL,
486 `NAME` varchar(200) NOT NULL,
487 `VERSION` varchar(20) NOT NULL,
488 `DESCRIPTION` varchar(1200) DEFAULT NULL,
489 `BODY` longtext NOT NULL,
490 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
491 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
492 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
493 PRIMARY KEY (`ARTIFACT_UUID`)
494 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
495 /*!40101 SET character_set_client = @saved_cs_client */;
498 -- Table structure for table `heat_template_params`
501 DROP TABLE IF EXISTS `heat_template_params`;
502 /*!40101 SET @saved_cs_client = @@character_set_client */;
503 /*!40101 SET character_set_client = utf8 */;
504 CREATE TABLE `heat_template_params` (
505 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NOT NULL,
506 `PARAM_NAME` varchar(100) NOT NULL,
507 `IS_REQUIRED` bit(1) NOT NULL,
508 `PARAM_TYPE` varchar(20) DEFAULT NULL,
509 `PARAM_ALIAS` varchar(45) DEFAULT NULL,
510 PRIMARY KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`,`PARAM_NAME`),
511 CONSTRAINT `fk_heat_template_params__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
512 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
513 /*!40101 SET character_set_client = @saved_cs_client */;
516 -- Table structure for table `identity_services`
519 DROP TABLE IF EXISTS `identity_services`;
520 /*!40101 SET @saved_cs_client = @@character_set_client */;
521 /*!40101 SET character_set_client = utf8 */;
522 CREATE TABLE `identity_services` (
523 `ID` varchar(50) NOT NULL,
524 `IDENTITY_URL` varchar(200) DEFAULT NULL,
525 `MSO_ID` varchar(255) DEFAULT NULL,
526 `MSO_PASS` varchar(255) DEFAULT NULL,
527 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
528 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
529 `TENANT_METADATA` tinyint(1) DEFAULT '0',
530 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
531 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
532 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
533 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
534 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
535 `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL,
536 `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL,
538 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
539 /*!40101 SET character_set_client = @saved_cs_client */;
542 -- Table structure for table `instance_group`
545 DROP TABLE IF EXISTS `instance_group`;
546 /*!40101 SET @saved_cs_client = @@character_set_client */;
547 /*!40101 SET character_set_client = utf8 */;
548 CREATE TABLE `instance_group` (
549 `MODEL_UUID` varchar(200) NOT NULL,
550 `MODEL_NAME` varchar(200) NOT NULL,
551 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
552 `MODEL_VERSION` varchar(20) NOT NULL,
553 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
554 `ROLE` varchar(200) NOT NULL,
555 `OBJECT_TYPE` varchar(200) NOT NULL,
556 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
557 `CR_MODEL_UUID` varchar(200) DEFAULT NULL,
558 `INSTANCE_GROUP_TYPE` varchar(200) NOT NULL,
559 PRIMARY KEY (`MODEL_UUID`),
560 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`)
561 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
562 /*!40101 SET character_set_client = @saved_cs_client */;
565 -- Table structure for table `model`
568 DROP TABLE IF EXISTS `model`;
569 /*!40101 SET @saved_cs_client = @@character_set_client */;
570 /*!40101 SET character_set_client = utf8 */;
571 CREATE TABLE `model` (
572 `ID` int(11) NOT NULL AUTO_INCREMENT,
573 `MODEL_CUSTOMIZATION_ID` varchar(40) DEFAULT NULL,
574 `MODEL_CUSTOMIZATION_NAME` varchar(40) DEFAULT NULL,
575 `MODEL_INVARIANT_ID` varchar(40) DEFAULT NULL,
576 `MODEL_NAME` varchar(40) DEFAULT NULL,
577 `MODEL_TYPE` varchar(20) DEFAULT NULL,
578 `MODEL_VERSION` varchar(20) DEFAULT NULL,
579 `MODEL_VERSION_ID` varchar(40) DEFAULT NULL,
580 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
581 `RECIPE` int(11) DEFAULT NULL,
583 UNIQUE KEY `uk1_model` (`MODEL_TYPE`,`MODEL_VERSION_ID`),
584 KEY `RECIPE` (`RECIPE`),
585 CONSTRAINT `model_ibfk_1` FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
586 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
587 /*!40101 SET character_set_client = @saved_cs_client */;
590 -- Table structure for table `model_recipe`
593 DROP TABLE IF EXISTS `model_recipe`;
594 /*!40101 SET @saved_cs_client = @@character_set_client */;
595 /*!40101 SET character_set_client = utf8 */;
596 CREATE TABLE `model_recipe` (
597 `ID` int(11) NOT NULL AUTO_INCREMENT,
598 `MODEL_ID` int(11) DEFAULT NULL,
599 `ACTION` varchar(40) DEFAULT NULL,
600 `SCHEMA_VERSION` varchar(40) DEFAULT NULL,
601 `DESCRIPTION` varchar(40) DEFAULT NULL,
602 `ORCHESTRATION_URI` varchar(20) DEFAULT NULL,
603 `MODEL_PARAM_XSD` varchar(20) DEFAULT NULL,
604 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
605 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
607 UNIQUE KEY `uk1_model_recipe` (`MODEL_ID`,`ACTION`)
608 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
609 /*!40101 SET character_set_client = @saved_cs_client */;
612 -- Table structure for table `network_recipe`
615 DROP TABLE IF EXISTS `network_recipe`;
616 /*!40101 SET @saved_cs_client = @@character_set_client */;
617 /*!40101 SET character_set_client = utf8 */;
618 CREATE TABLE `network_recipe` (
619 `id` int(11) NOT NULL AUTO_INCREMENT,
620 `MODEL_NAME` varchar(20) NOT NULL,
621 `ACTION` varchar(50) NOT NULL,
622 `DESCRIPTION` varchar(1200) DEFAULT NULL,
623 `ORCHESTRATION_URI` varchar(256) NOT NULL,
624 `NETWORK_PARAM_XSD` varchar(2048) DEFAULT NULL,
625 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
626 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
627 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
628 `VERSION_STR` varchar(20) NOT NULL,
629 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
630 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
632 UNIQUE KEY `UK_rl4f296i0p8lyokxveaiwkayi` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
633 ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
634 /*!40101 SET character_set_client = @saved_cs_client */;
637 -- Table structure for table `network_resource`
640 DROP TABLE IF EXISTS `network_resource`;
641 /*!40101 SET @saved_cs_client = @@character_set_client */;
642 /*!40101 SET character_set_client = utf8 */;
643 CREATE TABLE `network_resource` (
644 `MODEL_UUID` varchar(200) NOT NULL,
645 `MODEL_NAME` varchar(200) NOT NULL,
646 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
647 `DESCRIPTION` varchar(1200) DEFAULT NULL,
648 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
649 `NEUTRON_NETWORK_TYPE` varchar(20) DEFAULT NULL,
650 `MODEL_VERSION` varchar(20) DEFAULT NULL,
651 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
652 `AIC_VERSION_MIN` varchar(20) NULL,
653 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
654 `ORCHESTRATION_MODE` varchar(20) DEFAULT 'HEAT',
655 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
656 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
657 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
658 PRIMARY KEY (`MODEL_UUID`),
659 KEY `fk_network_resource__temp_network_heat_template_lookup1_idx` (`MODEL_NAME`),
660 KEY `fk_network_resource__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
661 CONSTRAINT `fk_network_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE NO ACTION ON UPDATE CASCADE,
662 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
663 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
664 /*!40101 SET character_set_client = @saved_cs_client */;
667 -- Table structure for table `network_resource_customization`
670 DROP TABLE IF EXISTS `network_resource_customization`;
671 /*!40101 SET @saved_cs_client = @@character_set_client */;
672 /*!40101 SET character_set_client = utf8 */;
673 CREATE TABLE `network_resource_customization` (
674 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
675 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
676 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
677 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
678 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
679 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
680 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
681 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
682 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
683 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
684 KEY `fk_network_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
685 CONSTRAINT `fk_network_resource_customization__network_resource1` FOREIGN KEY (`NETWORK_RESOURCE_MODEL_UUID`) REFERENCES `network_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
686 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
687 /*!40101 SET character_set_client = @saved_cs_client */;
690 -- Table structure for table `network_resource_customization_to_service`
693 DROP TABLE IF EXISTS `network_resource_customization_to_service`;
694 /*!40101 SET @saved_cs_client = @@character_set_client */;
695 /*!40101 SET character_set_client = utf8 */;
696 CREATE TABLE `network_resource_customization_to_service` (
697 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
698 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
699 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
700 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
701 CONSTRAINT `network_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
702 CONSTRAINT `network_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `network_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
703 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
704 /*!40101 SET character_set_client = @saved_cs_client */;
707 -- Table structure for table `northbound_request_ref_lookup`
710 DROP TABLE IF EXISTS `northbound_request_ref_lookup`;
711 /*!40101 SET @saved_cs_client = @@character_set_client */;
712 /*!40101 SET character_set_client = utf8 */;
713 CREATE TABLE `northbound_request_ref_lookup` (
714 `id` int(11) NOT NULL AUTO_INCREMENT,
715 `REQUEST_SCOPE` varchar(200) NOT NULL,
716 `MACRO_ACTION` varchar(200) NOT NULL,
717 `ACTION` varchar(200) NOT NULL,
718 `IS_ALACARTE` tinyint(1) NOT NULL DEFAULT '0',
719 `MIN_API_VERSION` double NOT NULL,
720 `MAX_API_VERSION` double DEFAULT NULL,
721 `IS_TOPLEVELFLOW` tinyint(1) DEFAULT NULL,
722 `CLOUD_OWNER` varchar(200) NOT NULL,
724 UNIQUE KEY `UK_northbound_request_ref_lookup` (`MIN_API_VERSION`,`REQUEST_SCOPE`,`ACTION`,`IS_ALACARTE`,`MACRO_ACTION`,`CLOUD_OWNER`)
725 ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;
726 /*!40101 SET character_set_client = @saved_cs_client */;
729 -- Table structure for table `orchestration_flow_reference`
732 DROP TABLE IF EXISTS `orchestration_flow_reference`;
733 /*!40101 SET @saved_cs_client = @@character_set_client */;
734 /*!40101 SET character_set_client = utf8 */;
735 CREATE TABLE `orchestration_flow_reference` (
736 `id` int(11) NOT NULL AUTO_INCREMENT,
737 `COMPOSITE_ACTION` varchar(200) NOT NULL,
738 `SEQ_NO` int(11) NOT NULL,
739 `FLOW_NAME` varchar(200) NOT NULL,
740 `FLOW_VERSION` double NOT 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 PRIMARY KEY (`MODEL_UUID`),
810 KEY `fk_service__tosca_csar1_idx` (`TOSCA_CSAR_ARTIFACT_UUID`),
811 CONSTRAINT `fk_service__tosca_csar1` FOREIGN KEY (`TOSCA_CSAR_ARTIFACT_UUID`) REFERENCES `tosca_csar` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
812 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
813 /*!40101 SET character_set_client = @saved_cs_client */;
816 -- Table structure for table `service_proxy_customization`
819 DROP TABLE IF EXISTS `service_proxy_customization`;
820 /*!40101 SET @saved_cs_client = @@character_set_client */;
821 /*!40101 SET character_set_client = utf8 */;
822 CREATE TABLE `service_proxy_customization` (
823 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
824 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
825 `MODEL_UUID` varchar(200) NOT NULL,
826 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
827 `MODEL_VERSION` varchar(20) NOT NULL,
828 `MODEL_NAME` varchar(200) NOT NULL,
829 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
830 `DESCRIPTION` varchar(1200) DEFAULT NULL,
831 `SOURCE_SERVICE_MODEL_UUID` varchar(200) NOT NULL,
832 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
833 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
834 KEY `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID`),
835 CONSTRAINT `fk_service_proxy_resource_customization__service1` FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
836 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
837 /*!40101 SET character_set_client = @saved_cs_client */;
840 -- Table structure for table `service_proxy_customization_to_service`
843 DROP TABLE IF EXISTS `service_proxy_customization_to_service`;
844 /*!40101 SET @saved_cs_client = @@character_set_client */;
845 /*!40101 SET character_set_client = utf8 */;
846 CREATE TABLE `service_proxy_customization_to_service` (
847 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
848 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
849 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
850 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
851 /*!40101 SET character_set_client = @saved_cs_client */;
854 -- Table structure for table `service_recipe`
857 DROP TABLE IF EXISTS `service_recipe`;
858 /*!40101 SET @saved_cs_client = @@character_set_client */;
859 /*!40101 SET character_set_client = utf8 */;
860 CREATE TABLE `service_recipe` (
861 `id` int(11) NOT NULL AUTO_INCREMENT,
862 `ACTION` varchar(50) NOT NULL,
863 `VERSION_STR` varchar(20) DEFAULT NULL,
864 `DESCRIPTION` varchar(1200) DEFAULT NULL,
865 `ORCHESTRATION_URI` varchar(256) NOT NULL,
866 `SERVICE_PARAM_XSD` varchar(2048) DEFAULT NULL,
867 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
868 `SERVICE_TIMEOUT_INTERIM` int(11) DEFAULT NULL,
869 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
870 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
872 UNIQUE KEY `UK_7fav5dkux2v8g9d2i5ymudlgc` (`SERVICE_MODEL_UUID`,`ACTION`),
873 KEY `fk_service_recipe__service1_idx` (`SERVICE_MODEL_UUID`),
874 CONSTRAINT `fk_service_recipe__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
875 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
876 /*!40101 SET character_set_client = @saved_cs_client */;
879 -- Table structure for table `temp_network_heat_template_lookup`
882 DROP TABLE IF EXISTS `temp_network_heat_template_lookup`;
883 /*!40101 SET @saved_cs_client = @@character_set_client */;
884 /*!40101 SET character_set_client = utf8 */;
885 CREATE TABLE `temp_network_heat_template_lookup` (
886 `NETWORK_RESOURCE_MODEL_NAME` varchar(200) NOT NULL,
887 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
888 `AIC_VERSION_MIN` varchar(20) NULL,
889 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
890 PRIMARY KEY (`NETWORK_RESOURCE_MODEL_NAME`),
891 KEY `fk_temp_network_heat_template_lookup__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
892 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
893 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
894 /*!40101 SET character_set_client = @saved_cs_client */;
897 -- Table structure for table `tosca_csar`
900 DROP TABLE IF EXISTS `tosca_csar`;
901 /*!40101 SET @saved_cs_client = @@character_set_client */;
902 /*!40101 SET character_set_client = utf8 */;
903 CREATE TABLE `tosca_csar` (
904 `ARTIFACT_UUID` varchar(200) NOT NULL,
905 `NAME` varchar(200) NOT NULL,
906 `VERSION` varchar(20) NOT NULL,
907 `DESCRIPTION` varchar(1200) DEFAULT NULL,
908 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL,
909 `URL` varchar(200) NOT NULL,
910 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
911 PRIMARY KEY (`ARTIFACT_UUID`)
912 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
913 /*!40101 SET character_set_client = @saved_cs_client */;
916 -- Table structure for table `vf_module`
919 DROP TABLE IF EXISTS `vf_module`;
920 /*!40101 SET @saved_cs_client = @@character_set_client */;
921 /*!40101 SET character_set_client = utf8 */;
922 CREATE TABLE `vf_module` (
923 `MODEL_UUID` varchar(200) NOT NULL,
924 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
925 `MODEL_VERSION` varchar(20) NOT NULL,
926 `MODEL_NAME` varchar(200) NOT NULL,
927 `DESCRIPTION` varchar(1200) DEFAULT NULL,
928 `IS_BASE` tinyint(1) NOT NULL,
929 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
930 `VOL_HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
931 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
932 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
933 PRIMARY KEY (`MODEL_UUID`,`VNF_RESOURCE_MODEL_UUID`),
934 KEY `fk_vf_module__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
935 KEY `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
936 KEY `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`VOL_HEAT_TEMPLATE_ARTIFACT_UUID`),
937 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,
938 CONSTRAINT `fk_vf_module__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
939 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
940 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
941 /*!40101 SET character_set_client = @saved_cs_client */;
944 -- Table structure for table `vf_module_customization`
947 DROP TABLE IF EXISTS `vf_module_customization`;
948 /*!40101 SET @saved_cs_client = @@character_set_client */;
949 /*!40101 SET character_set_client = utf8 */;
950 CREATE TABLE `vf_module_customization` (
951 `ID` int(13) NOT NULL AUTO_INCREMENT,
952 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
953 `LABEL` varchar(200) DEFAULT NULL,
954 `INITIAL_COUNT` int(11) DEFAULT '0',
955 `MIN_INSTANCES` int(11) DEFAULT '0',
956 `MAX_INSTANCES` int(11) DEFAULT NULL,
957 `AVAILABILITY_ZONE_COUNT` int(11) DEFAULT NULL,
958 `HEAT_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
959 `VOL_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
960 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
961 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
962 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
964 KEY `fk_vf_module_customization__vf_module1_idx` (`VF_MODULE_MODEL_UUID`),
965 KEY `fk_vf_module_customization__heat_env__heat_environment1_idx` (`HEAT_ENVIRONMENT_ARTIFACT_UUID`),
966 KEY `fk_vf_module_customization__vol_env__heat_environment2_idx` (`VOL_ENVIRONMENT_ARTIFACT_UUID`),
967 KEY `fk_vf_module_customization_to_vnf_resource_customization` (`VNF_RESOURCE_CUSTOMIZATION_ID`),
968 KEY `vf_module_customization_model_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
969 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,
970 CONSTRAINT `fk_vf_module_customization__vf_module1` FOREIGN KEY (`VF_MODULE_MODEL_UUID`) REFERENCES `vf_module` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
971 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,
972 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
973 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
974 /*!40101 SET character_set_client = @saved_cs_client */;
977 -- Table structure for table `vf_module_to_heat_files`
980 DROP TABLE IF EXISTS `vf_module_to_heat_files`;
981 /*!40101 SET @saved_cs_client = @@character_set_client */;
982 /*!40101 SET character_set_client = utf8 */;
983 CREATE TABLE `vf_module_to_heat_files` (
984 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
985 `HEAT_FILES_ARTIFACT_UUID` varchar(200) NOT NULL,
986 PRIMARY KEY (`VF_MODULE_MODEL_UUID`,`HEAT_FILES_ARTIFACT_UUID`),
987 KEY `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`HEAT_FILES_ARTIFACT_UUID`),
988 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,
989 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
990 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='il fait ce qu''il dit';
991 /*!40101 SET character_set_client = @saved_cs_client */;
994 -- Table structure for table `vnf_components`
997 DROP TABLE IF EXISTS `vnf_components`;
998 /*!40101 SET @saved_cs_client = @@character_set_client */;
999 /*!40101 SET character_set_client = utf8 */;
1000 CREATE TABLE `vnf_components` (
1001 `VNF_ID` int(11) NOT NULL,
1002 `COMPONENT_TYPE` varchar(20) NOT NULL,
1003 `HEAT_TEMPLATE_ID` int(11) DEFAULT NULL,
1004 `HEAT_ENVIRONMENT_ID` int(11) DEFAULT NULL,
1005 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1006 PRIMARY KEY (`VNF_ID`,`COMPONENT_TYPE`)
1007 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1008 /*!40101 SET character_set_client = @saved_cs_client */;
1011 -- Table structure for table `vnf_components_recipe`
1014 DROP TABLE IF EXISTS `vnf_components_recipe`;
1015 /*!40101 SET @saved_cs_client = @@character_set_client */;
1016 /*!40101 SET character_set_client = utf8 */;
1017 CREATE TABLE `vnf_components_recipe` (
1018 `id` int(11) NOT NULL AUTO_INCREMENT,
1019 `VNF_TYPE` varchar(200) DEFAULT NULL,
1020 `VNF_COMPONENT_TYPE` varchar(45) NOT NULL,
1021 `ACTION` varchar(50) NOT NULL,
1022 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1023 `VERSION` varchar(20) NOT NULL,
1024 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1025 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1026 `VNF_COMPONENT_PARAM_XSD` varchar(2048) DEFAULT NULL,
1027 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1028 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1029 `VF_MODULE_MODEL_UUID` varchar(200) DEFAULT NULL,
1031 UNIQUE KEY `UK_4dpdwddaaclhc11wxsb7h59ma` (`VF_MODULE_MODEL_UUID`,`VNF_COMPONENT_TYPE`,`ACTION`,`VERSION`)
1032 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
1033 /*!40101 SET character_set_client = @saved_cs_client */;
1036 -- Table structure for table `vnf_recipe`
1039 DROP TABLE IF EXISTS `vnf_recipe`;
1040 /*!40101 SET @saved_cs_client = @@character_set_client */;
1041 /*!40101 SET character_set_client = utf8 */;
1042 CREATE TABLE `vnf_recipe` (
1043 `id` int(11) NOT NULL AUTO_INCREMENT,
1044 `NF_ROLE` varchar(200) DEFAULT NULL,
1045 `ACTION` varchar(50) NOT NULL,
1046 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1047 `VERSION_STR` varchar(20) NOT NULL,
1048 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1049 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1050 `VNF_PARAM_XSD` varchar(2048) DEFAULT NULL,
1051 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1052 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1053 `VF_MODULE_ID` varchar(100) DEFAULT NULL,
1055 UNIQUE KEY `UK_f3tvqau498vrifq3cr8qnigkr` (`VF_MODULE_ID`,`ACTION`,`VERSION_STR`)
1056 ) ENGINE=InnoDB AUTO_INCREMENT=10015 DEFAULT CHARSET=latin1;
1057 /*!40101 SET character_set_client = @saved_cs_client */;
1060 -- Table structure for table `vnf_resource`
1063 DROP TABLE IF EXISTS `vnf_resource`;
1064 /*!40101 SET @saved_cs_client = @@character_set_client */;
1065 /*!40101 SET character_set_client = utf8 */;
1066 CREATE TABLE `vnf_resource` (
1067 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
1068 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1069 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1070 `MODEL_UUID` varchar(200) NOT NULL,
1071 `AIC_VERSION_MIN` varchar(20) DEFAULT NULL,
1072 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
1073 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1074 `MODEL_VERSION` varchar(20) NOT NULL,
1075 `MODEL_NAME` varchar(200) DEFAULT NULL,
1076 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1077 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
1078 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1079 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1080 PRIMARY KEY (`MODEL_UUID`),
1081 KEY `fk_vnf_resource__heat_template1` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
1082 CONSTRAINT `fk_vnf_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1083 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1084 /*!40101 SET character_set_client = @saved_cs_client */;
1087 -- Table structure for table `vnf_resource_customization`
1090 DROP TABLE IF EXISTS `vnf_resource_customization`;
1091 /*!40101 SET @saved_cs_client = @@character_set_client */;
1092 /*!40101 SET character_set_client = utf8 */;
1093 CREATE TABLE `vnf_resource_customization` (
1094 `ID` int(13) NOT NULL AUTO_INCREMENT,
1095 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1096 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1097 `MIN_INSTANCES` int(11) DEFAULT NULL,
1098 `MAX_INSTANCES` int(11) DEFAULT NULL,
1099 `AVAILABILITY_ZONE_MAX_COUNT` int(11) DEFAULT NULL,
1100 `NF_TYPE` varchar(200) DEFAULT NULL,
1101 `NF_ROLE` varchar(200) DEFAULT NULL,
1102 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1103 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1104 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1105 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
1106 `CDS_BLUEPRINT_NAME` varchar(200) default null,
1107 `CDS_BLUEPRINT_VERSION` varchar(20) default null,
1108 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1109 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1110 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1111 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1113 UNIQUE KEY `UK_vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`,`SERVICE_MODEL_UUID`),
1114 KEY `fk_vnf_resource_customization__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
1115 KEY `fk_vnf_resource_customization_to_service` (`SERVICE_MODEL_UUID`),
1116 KEY `vnf_resource_customization_mod_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
1117 CONSTRAINT `fk_vnf_resource_customization__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1118 CONSTRAINT `fk_vnf_resource_customization_to_service` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1119 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1120 /*!40101 SET character_set_client = @saved_cs_client */;
1123 -- Table structure for table `vnfc_customization`
1126 DROP TABLE IF EXISTS `vnfc_customization`;
1127 /*!40101 SET @saved_cs_client = @@character_set_client */;
1128 /*!40101 SET character_set_client = utf8 */;
1129 CREATE TABLE `vnfc_customization` (
1130 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1131 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1132 `MODEL_UUID` varchar(200) NOT NULL,
1133 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
1134 `MODEL_VERSION` varchar(20) NOT NULL,
1135 `MODEL_NAME` varchar(200) NOT NULL,
1136 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
1137 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1138 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1139 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`)
1140 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1141 /*!40101 SET character_set_client = @saved_cs_client */;
1144 -- Table structure for table `vnfc_instance_group_customization`
1147 DROP TABLE IF EXISTS `vnfc_instance_group_customization`;
1148 /*!40101 SET @saved_cs_client = @@character_set_client */;
1149 /*!40101 SET character_set_client = utf8 */;
1150 CREATE TABLE `vnfc_instance_group_customization` (
1151 `ID` int(13) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1152 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) NOT NULL,
1153 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
1154 `FUNCTION` varchar(200) DEFAULT NULL,
1155 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1156 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1157 KEY `fk_vnfc_instance_group_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
1158 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,
1159 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
1160 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1161 set foreign_key_checks=1;
1163 CREATE TABLE IF NOT EXISTS `pnf_resource` (
1164 `ORCHESTRATION_MODE` varchar(20) DEFAULT NULL,
1165 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1166 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1167 `MODEL_UUID` varchar(200) NOT NULL,
1168 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1169 `MODEL_VERSION` varchar(20) NOT NULL,
1170 `MODEL_NAME` varchar(200) DEFAULT NULL,
1171 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1172 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1173 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1174 PRIMARY KEY (`MODEL_UUID`)
1175 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1177 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
1178 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1179 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1180 `NF_TYPE` varchar(200) DEFAULT NULL,
1181 `NF_ROLE` varchar(200) DEFAULT NULL,
1182 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1183 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1184 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1185 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1186 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1187 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
1188 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
1189 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
1190 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1191 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
1192 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
1193 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1194 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1196 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
1197 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1198 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1199 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
1200 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
1203 CREATE TABLE IF NOT EXISTS `workflow` (
1204 `ID` int(11) NOT NULL AUTO_INCREMENT,
1205 `ARTIFACT_UUID` varchar(200) NOT NULL,
1206 `ARTIFACT_NAME` varchar(200) NOT NULL,
1207 `NAME` varchar(200) NOT NULL,
1208 `OPERATION_NAME` varchar(200) DEFAULT NULL,
1209 `VERSION` double NOT NULL,
1210 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1211 `BODY` longtext DEFAULT NULL,
1212 `RESOURCE_TARGET` varchar(200) NOT NULL,
1213 `SOURCE` varchar(200) NOT NULL,
1214 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
1215 `ARTIFACT_CHECKSUM` varchar(200) DEFAULT 'MANUAL RECORD',
1216 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT current_timestamp(),
1218 UNIQUE KEY `UK_workflow` (`ARTIFACT_UUID`,`NAME`,`VERSION`,`SOURCE`)
1219 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1221 CREATE TABLE IF NOT EXISTS `vnf_resource_to_workflow` (
1222 `ID` int(11) NOT NULL AUTO_INCREMENT,
1223 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1224 `WORKFLOW_ID` int(11) NOT NULL,
1226 UNIQUE KEY `UK_vnf_resource_to_workflow` (`VNF_RESOURCE_MODEL_UUID`,`WORKFLOW_ID`),
1227 KEY `fk_vnf_resource_to_workflow__workflow1_idx` (`WORKFLOW_ID`),
1228 KEY `fk_vnf_resource_to_workflow__vnf_res_mod_uuid_idx` (`VNF_RESOURCE_MODEL_UUID`),
1229 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,
1230 CONSTRAINT `fk_vnf_resource_to_workflow__workflow1` FOREIGN KEY (`WORKFLOW_ID`) REFERENCES `workflow` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
1231 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1233 CREATE TABLE IF NOT EXISTS `activity_spec` (
1234 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1235 `NAME` VARCHAR(200) NOT NULL,
1236 `DESCRIPTION` VARCHAR(1200) NOT NULL,
1237 `VERSION` DOUBLE NOT NULL,
1238 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1240 UNIQUE INDEX `UK_activity_spec` (`NAME` ASC, `VERSION` ASC))
1242 DEFAULT CHARACTER SET = latin1;
1244 CREATE TABLE IF NOT EXISTS `user_parameters` (
1245 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1246 `NAME` VARCHAR(200) NOT NULL,
1247 `PAYLOAD_LOCATION` VARCHAR(500) NULL,
1248 `LABEL` VARCHAR(200) NOT NULL,
1249 `TYPE` VARCHAR(200) NOT NULL,
1250 `DESCRIPTION` VARCHAR(1200) NULL,
1251 `IS_REQUIRED` TINYINT(1) NOT NULL,
1252 `MAX_LENGTH` INT(11) NULL,
1253 `ALLOWABLE_CHARS` VARCHAR(200) NULL,
1254 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1256 UNIQUE INDEX `UK_user_parameters` (`NAME` ASC))
1258 DEFAULT CHARACTER SET = latin1;
1260 CREATE TABLE IF NOT EXISTS `workflow_activity_spec_sequence` (
1261 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1262 `WORKFLOW_ID` INT(11) NOT NULL,
1263 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1264 `SEQ_NO` INT(11) NOT NULL,
1266 UNIQUE INDEX `UK_workflow_activity_spec_sequence` (`WORKFLOW_ID` ASC, `ACTIVITY_SPEC_ID` ASC, `SEQ_NO` ASC),
1267 INDEX `fk_workflow_activity_spec_sequence__activity_spec_idx` (`ACTIVITY_SPEC_ID` ASC),
1268 INDEX `fk_workflow_activity_spec_sequence__workflow_actifact_uuid_idx` (`WORKFLOW_ID` ASC),
1269 CONSTRAINT `fk_workflow_activity_spec_sequence__activity_spec1`
1270 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1271 REFERENCES `activity_spec` (`ID`)
1274 CONSTRAINT `fk_workflow_activity_spec_sequence__workflow1`
1275 FOREIGN KEY (`WORKFLOW_ID`)
1276 REFERENCES `workflow` (`ID`)
1280 DEFAULT CHARACTER SET = latin1;
1282 CREATE TABLE IF NOT EXISTS `activity_spec_parameters` (
1283 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1284 `NAME` VARCHAR(200) NOT NULL,
1285 `TYPE` VARCHAR(200) NOT NULL,
1286 `DIRECTION` VARCHAR(200) NULL,
1287 `DESCRIPTION` VARCHAR(1200) NULL,
1288 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1290 UNIQUE INDEX `UK_activity_spec_parameters` (`NAME` ASC, `DIRECTION` ASC))
1292 DEFAULT CHARACTER SET = latin1;
1294 CREATE TABLE IF NOT EXISTS `activity_spec_categories` (
1295 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1296 `NAME` VARCHAR(200) NOT NULL,
1298 UNIQUE INDEX `UK_activity_spec_categories` (`NAME` ASC))
1300 DEFAULT CHARACTER SET = latin1;
1302 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_categories` (
1303 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1304 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1305 `ACTIVITY_SPEC_CATEGORIES_ID` INT(11) NOT NULL,
1307 UNIQUE INDEX `UK_activity_spec_to_activity_spec_categories` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1308 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx` (`ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1309 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx1` (`ACTIVITY_SPEC_ID` ASC),
1310 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec1`
1311 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1312 REFERENCES `activity_spec` (`ID`)
1315 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec_c1`
1316 FOREIGN KEY (`ACTIVITY_SPEC_CATEGORIES_ID`)
1317 REFERENCES `activity_spec_categories` (`ID`)
1321 DEFAULT CHARACTER SET = latin1;
1323 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_parameters` (
1324 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1325 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1326 `ACTIVITY_SPEC_PARAMETERS_ID` INT(11) NOT NULL,
1328 INDEX `fk_activity_spec_to_activity_spec_params__act_sp_param_id_idx` (`ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1329 UNIQUE INDEX `UK_activity_spec_to_activity_spec_parameters` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1330 INDEX `fk_activity_spec_to_activity_spec_parameters__act_spec_id_idx` (`ACTIVITY_SPEC_ID` ASC),
1331 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activity_spec_1`
1332 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1333 REFERENCES `activity_spec` (`ID`)
1336 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activ_spec_param1`
1337 FOREIGN KEY (`ACTIVITY_SPEC_PARAMETERS_ID`)
1338 REFERENCES `activity_spec_parameters` (`ID`)
1342 DEFAULT CHARACTER SET = latin1;
1344 CREATE TABLE IF NOT EXISTS `activity_spec_to_user_parameters` (
1345 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1346 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1347 `USER_PARAMETERS_ID` INT(11) NOT NULL,
1349 UNIQUE INDEX `UK_activity_spec_to_user_parameters` (`ACTIVITY_SPEC_ID` ASC, `USER_PARAMETERS_ID` ASC),
1350 INDEX `fk_activity_spec_to_user_parameters__user_parameters1_idx` (`USER_PARAMETERS_ID` ASC),
1351 INDEX `fk_activity_spec_to_user_parameters__activity_spec1_idx` (`ACTIVITY_SPEC_ID` ASC),
1352 CONSTRAINT `fk_activity_spec_to_user_parameters__activity_spec1`
1353 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1354 REFERENCES `activity_spec` (`ID`)
1357 CONSTRAINT `fk_activity_spec_to_user_parameters__user_parameters1`
1358 FOREIGN KEY (`USER_PARAMETERS_ID`)
1359 REFERENCES `user_parameters` (`ID`)
1363 DEFAULT CHARACTER SET = latin1;
1366 --------START Request DB SCHEMA --------
1367 CREATE DATABASE requestdb;
1371 CREATE TABLE `active_requests` (
1372 `REQUEST_ID` varchar(45) NOT NULL,
1373 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1374 `SERVICE_INSTANCE_ID` varchar(50) NOT NULL,
1375 `SUBSCRIBER_NAME` varchar(200) DEFAULT NULL,
1376 `REQUEST_URI` varchar(255) DEFAULT NULL,
1377 `SERVICE_TYPE` varchar(65) NOT NULL,
1378 `REQUEST_ACTION` varchar(45) NOT NULL,
1379 `NOTIFICATION_URL` varchar(255) DEFAULT NULL,
1380 `REQUEST_ID_IN_PROGRESS` varchar(45) DEFAULT NULL,
1381 `START_TIME` datetime DEFAULT NULL,
1382 `MODIFY_TIME` datetime DEFAULT NULL,
1383 `COMPLETION_TIME` datetime DEFAULT NULL,
1384 `RESPONSE_CODE` varchar(20) DEFAULT NULL,
1385 `RESPONSE_BODY` longtext,
1386 `STATUS` varchar(25) DEFAULT NULL,
1387 `SERVICE_REQUEST_TIMEOUT` datetime DEFAULT NULL,
1388 `FINAL_ERROR_CODE` varchar(20) DEFAULT NULL,
1389 `FINAL_ERROR_MESSAGE` varchar(2000) DEFAULT NULL,
1390 `ORDER_NUMBER` varchar(45) DEFAULT NULL,
1391 `SOURCE` varchar(20) DEFAULT NULL,
1392 `RESPONSE_STATUS` varchar(25) DEFAULT NULL,
1393 `ORDER_VERSION` varchar(20) DEFAULT NULL,
1394 `LAST_MODIFIED_BY` varchar(20) DEFAULT NULL,
1395 `MOCARS_TICKET_NUM` varchar(200) DEFAULT NULL,
1396 `REQUEST_BODY` longtext,
1397 `REQUEST_SUB_ACTION` varchar(45) DEFAULT NULL,
1398 `SDNC_CALLBACK_BPEL_URL` varchar(255) DEFAULT NULL,
1399 `FEATURE_TYPE` varchar(255) DEFAULT NULL,
1400 `FEATURE_INSTANCE_ID` varchar(255) DEFAULT NULL,
1401 `REQUEST_TYPE` varchar(255) DEFAULT NULL,
1402 `INTERIM_COMPLETION_TIME` datetime DEFAULT NULL,
1403 `INTERIM_STAGE_COMPLETION` int(11) DEFAULT NULL,
1404 `SERVICE_NAME_VERSION_ID` varchar(50) DEFAULT NULL,
1405 `GLOBAL_SUBSCRIBER_ID` varchar(255) DEFAULT NULL,
1406 `SERVICE_ID` varchar(50) DEFAULT NULL,
1407 `SERVICE_VERSION` varchar(10) DEFAULT NULL,
1408 `CORRELATOR` varchar(50) DEFAULT NULL,
1409 PRIMARY KEY (`REQUEST_ID`),
1410 UNIQUE KEY `UK_f0hdk7xbw5mb2trnxx0fvlh3x` (`CLIENT_REQUEST_ID`)
1411 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1413 CREATE TABLE `infra_active_requests` (
1414 `REQUEST_ID` varchar(45) NOT NULL,
1415 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1416 `ACTION` varchar(45) DEFAULT NULL,
1417 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
1418 `STATUS_MESSAGE` longtext DEFAULT NULL,
1419 `PROGRESS` bigint(20) DEFAULT NULL,
1420 `START_TIME` datetime DEFAULT NULL,
1421 `END_TIME` datetime DEFAULT NULL,
1422 `SOURCE` varchar(45) DEFAULT NULL,
1423 `VNF_ID` varchar(45) DEFAULT NULL,
1424 `VNF_NAME` varchar(80) DEFAULT NULL,
1425 `VNF_TYPE` varchar(200) DEFAULT NULL,
1426 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1427 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
1428 `TENANT_ID` varchar(45) DEFAULT NULL,
1429 `PROV_STATUS` varchar(20) DEFAULT NULL,
1430 `VNF_PARAMS` longtext,
1431 `VNF_OUTPUTS` longtext,
1432 `REQUEST_BODY` longtext,
1433 `RESPONSE_BODY` longtext,
1434 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
1435 `MODIFY_TIME` datetime DEFAULT NULL,
1436 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
1437 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
1438 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
1439 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
1440 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
1441 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
1442 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
1443 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
1444 `CALLBACK_URL` varchar(200) DEFAULT NULL,
1445 `CORRELATOR` varchar(80) DEFAULT NULL,
1446 `NETWORK_ID` varchar(45) DEFAULT NULL,
1447 `NETWORK_NAME` varchar(80) DEFAULT NULL,
1448 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
1449 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
1450 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
1451 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
1452 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
1453 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
1454 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
1455 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
1456 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
1457 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
1458 `REQUEST_URL` varchar(500) DEFAULT NULL,
1459 PRIMARY KEY (`REQUEST_ID`),
1460 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
1461 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1463 CREATE TABLE `archived_infra_requests` (
1464 `REQUEST_ID` varchar(45) NOT NULL,
1465 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1466 `ACTION` varchar(45) DEFAULT NULL,
1467 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
1468 `STATUS_MESSAGE` longtext DEFAULT NULL,
1469 `PROGRESS` bigint(20) DEFAULT NULL,
1470 `START_TIME` datetime DEFAULT NULL,
1471 `END_TIME` datetime DEFAULT NULL,
1472 `SOURCE` varchar(45) DEFAULT NULL,
1473 `VNF_ID` varchar(45) DEFAULT NULL,
1474 `VNF_NAME` varchar(80) DEFAULT NULL,
1475 `VNF_TYPE` varchar(200) DEFAULT NULL,
1476 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1477 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
1478 `TENANT_ID` varchar(45) DEFAULT NULL,
1479 `PROV_STATUS` varchar(20) DEFAULT NULL,
1480 `VNF_PARAMS` longtext,
1481 `VNF_OUTPUTS` longtext,
1482 `REQUEST_BODY` longtext,
1483 `RESPONSE_BODY` longtext,
1484 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
1485 `MODIFY_TIME` datetime DEFAULT NULL,
1486 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
1487 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
1488 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
1489 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
1490 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
1491 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
1492 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
1493 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
1494 `CALLBACK_URL` varchar(200) DEFAULT NULL,
1495 `CORRELATOR` varchar(80) DEFAULT NULL,
1496 `NETWORK_ID` varchar(45) DEFAULT NULL,
1497 `NETWORK_NAME` varchar(80) DEFAULT NULL,
1498 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
1499 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
1500 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
1501 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
1502 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
1503 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
1504 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
1505 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
1506 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
1507 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
1508 `REQUEST_URL` varchar(500) DEFAULT NULL,
1509 PRIMARY KEY (`REQUEST_ID`),
1510 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d72h` (`CLIENT_REQUEST_ID`)
1511 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1513 CREATE TABLE `site_status` (
1514 `SITE_NAME` varchar(255) NOT NULL,
1515 `STATUS` bit(1) DEFAULT NULL,
1516 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1517 PRIMARY KEY (`SITE_NAME`)
1518 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1520 CREATE TABLE `watchdog_distributionid_status` (
1521 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1522 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1523 `LOCK_VERSION` int NOT NULL,
1524 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1525 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1526 PRIMARY KEY (`DISTRIBUTION_ID`)
1527 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1529 CREATE TABLE `watchdog_per_component_distribution_status` (
1530 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1531 `COMPONENT_NAME` varchar(45) NOT NULL,
1532 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
1533 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1534 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1535 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
1536 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1537 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1539 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
1540 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1541 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1542 `DISTRIBUTION_NOTIFICATION` LONGTEXT NULL,
1543 `CONSUMER_ID` varchar(200) NULL,
1544 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1545 `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1546 PRIMARY KEY (`DISTRIBUTION_ID`,`SERVICE_MODEL_VERSION_ID`)
1547 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1549 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
1550 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1551 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1552 `REQUEST_ID` varchar(45) NOT NULL,
1553 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
1554 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
1555 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
1556 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
1557 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1558 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1559 `VNF_OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1560 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
1561 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1563 CREATE TABLE `activate_operational_env_per_distributionid_status` (
1564 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1565 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1566 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
1567 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1568 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1569 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1570 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1571 `REQUEST_ID` varchar(45) NOT NULL,
1572 PRIMARY KEY (`DISTRIBUTION_ID`),
1573 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
1574 CONSTRAINT `fk_activate_op_env_per_distributionid_status__aoesmds1` FOREIGN KEY (`OPERATIONAL_ENV_ID`, `SERVICE_MODEL_VERSION_ID`, `REQUEST_ID`) REFERENCES `activate_operational_env_service_model_distribution_status` (`OPERATIONAL_ENV_ID`, `SERVICE_MODEL_VERSION_ID`, `REQUEST_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1575 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1577 create table operation_status (
1578 SERVICE_ID varchar(255) not null,
1579 OPERATION_ID varchar(255) not null,
1580 SERVICE_NAME varchar(255),
1581 OPERATION_TYPE varchar(255),
1582 USER_ID varchar(255),
1583 RESULT varchar(255),
1584 OPERATION_CONTENT varchar(255),
1585 PROGRESS varchar(255),
1586 REASON varchar(255),
1587 OPERATE_AT datetime NOT NULL,
1588 FINISHED_AT datetime NOT NULL,
1589 primary key (SERVICE_ID,OPERATION_ID)
1590 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1592 create table resource_operation_status (
1593 SERVICE_ID varchar(255) not null,
1594 OPERATION_ID varchar(255) not null,
1595 RESOURCE_TEMPLATE_UUID varchar(255) not null,
1596 OPER_TYPE varchar(255),
1597 RESOURCE_INSTANCE_ID varchar(255),
1598 JOB_ID varchar(255),
1599 STATUS varchar(255),
1600 PROGRESS varchar(255),
1601 ERROR_CODE varchar(255) ,
1602 STATUS_DESCRIPOTION varchar(255) ,
1603 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
1604 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1606 create table if not exists model_recipe (
1607 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1609 `ACTION` VARCHAR(40),
1610 `SCHEMA_VERSION` VARCHAR(40),
1611 `DESCRIPTION` VARCHAR(40),
1612 `ORCHESTRATION_URI` VARCHAR(20),
1613 `MODEL_PARAM_XSD` VARCHAR(20),
1614 `RECIPE_TIMEOUT` INT(11),
1615 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1617 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
1618 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1620 create table if not exists model (
1621 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1622 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
1623 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
1624 `MODEL_INVARIANT_ID` VARCHAR(40),
1625 `MODEL_NAME` VARCHAR(40),
1626 `MODEL_TYPE` VARCHAR(20),
1627 `MODEL_VERSION` VARCHAR(20),
1628 `MODEL_VERSION_ID` VARCHAR(40),
1629 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1632 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
1633 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1634 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;