2 --------START Catalog DB SCHEMA --------
5 set foreign_key_checks=0;
6 DROP TABLE IF EXISTS `allotted_resource`;
7 /*!40101 SET @saved_cs_client = @@character_set_client */;
8 /*!40101 SET character_set_client = utf8 */;
9 CREATE TABLE `allotted_resource` (
10 `MODEL_UUID` varchar(200) NOT NULL,
11 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
12 `MODEL_VERSION` varchar(20) NOT NULL,
13 `MODEL_NAME` varchar(200) NOT NULL,
14 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
15 `SUBCATEGORY` varchar(200) DEFAULT NULL,
16 `DESCRIPTION` varchar(1200) DEFAULT NULL,
17 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
18 PRIMARY KEY (`MODEL_UUID`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
20 /*!40101 SET character_set_client = @saved_cs_client */;
23 -- Table structure for table `allotted_resource_customization`
26 DROP TABLE IF EXISTS `allotted_resource_customization`;
27 /*!40101 SET @saved_cs_client = @@character_set_client */;
28 /*!40101 SET character_set_client = utf8 */;
29 CREATE TABLE `allotted_resource_customization` (
30 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
31 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
32 `PROVIDING_SERVICE_MODEL_UUID` varchar(200) DEFAULT NULL,
33 `PROVIDING_SERVICE_MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
34 `PROVIDING_SERVICE_MODEL_NAME` varchar(200) DEFAULT NULL,
35 `TARGET_NETWORK_ROLE` varchar(200) DEFAULT NULL,
36 `NF_TYPE` varchar(200) DEFAULT NULL,
37 `NF_ROLE` varchar(200) DEFAULT NULL,
38 `NF_FUNCTION` varchar(200) DEFAULT NULL,
39 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
40 `MIN_INSTANCES` int(11) DEFAULT NULL,
41 `MAX_INSTANCES` int(11) DEFAULT NULL,
42 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
43 `AR_MODEL_UUID` varchar(200) NOT NULL,
44 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
45 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
46 KEY `fk_allotted_resource_customization__allotted_resource1_idx` (`AR_MODEL_UUID`),
47 CONSTRAINT `fk_allotted_resource_customization__allotted_resource1` FOREIGN KEY (`AR_MODEL_UUID`) REFERENCES `allotted_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
48 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49 /*!40101 SET character_set_client = @saved_cs_client */;
52 -- Table structure for table `allotted_resource_customization_to_service`
55 DROP TABLE IF EXISTS `allotted_resource_customization_to_service`;
56 /*!40101 SET @saved_cs_client = @@character_set_client */;
57 /*!40101 SET character_set_client = utf8 */;
58 CREATE TABLE `allotted_resource_customization_to_service` (
59 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
60 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
61 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
62 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
63 CONSTRAINT `allotted_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
64 CONSTRAINT `allotted_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `allotted_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
65 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66 /*!40101 SET character_set_client = @saved_cs_client */;
69 -- Table structure for table `ar_recipe`
72 DROP TABLE IF EXISTS `ar_recipe`;
73 /*!40101 SET @saved_cs_client = @@character_set_client */;
74 /*!40101 SET character_set_client = utf8 */;
75 CREATE TABLE `ar_recipe` (
76 `ID` int(11) NOT NULL AUTO_INCREMENT,
77 `MODEL_NAME` varchar(200) NOT NULL,
78 `ACTION` varchar(200) NOT NULL,
79 `VERSION_STR` varchar(200) NOT NULL,
80 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
81 `DESCRIPTION` varchar(200) DEFAULT NULL,
82 `ORCHESTRATION_URI` varchar(200) NOT NULL,
83 `AR_PARAM_XSD` varchar(200) DEFAULT NULL,
84 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
85 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
87 UNIQUE KEY `uk_ar_recipe` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
88 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
89 /*!40101 SET character_set_client = @saved_cs_client */;
92 -- Table structure for table `building_block_detail`
95 DROP TABLE IF EXISTS `building_block_detail`;
96 /*!40101 SET @saved_cs_client = @@character_set_client */;
97 /*!40101 SET character_set_client = utf8 */;
98 CREATE TABLE `building_block_detail` (
99 `id` int(11) NOT NULL AUTO_INCREMENT,
100 `BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
101 `RESOURCE_TYPE` varchar(25) NOT NULL,
102 `TARGET_ACTION` varchar(25) NOT NULL,
104 UNIQUE KEY `UK_building_block_name` (`BUILDING_BLOCK_NAME`)
105 ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
106 /*!40101 SET character_set_client = @saved_cs_client */;
109 -- Table structure for table `cloud_sites`
112 DROP TABLE IF EXISTS `cloud_sites`;
113 /*!40101 SET @saved_cs_client = @@character_set_client */;
114 /*!40101 SET character_set_client = utf8 */;
115 CREATE TABLE `cloud_sites` (
116 `ID` varchar(50) NOT NULL,
117 `REGION_ID` varchar(11) DEFAULT NULL,
118 `IDENTITY_SERVICE_ID` varchar(50) DEFAULT NULL,
119 `CLOUD_VERSION` varchar(20) DEFAULT NULL,
120 `CLLI` varchar(11) DEFAULT NULL,
121 `CLOUDIFY_ID` varchar(50) DEFAULT NULL,
122 `PLATFORM` varchar(50) DEFAULT NULL,
123 `ORCHESTRATOR` varchar(50) DEFAULT NULL,
124 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
125 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
126 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
128 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
129 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)
130 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
131 /*!40101 SET character_set_client = @saved_cs_client */;
134 -- Table structure for table `cloudify_managers`
137 DROP TABLE IF EXISTS `cloudify_managers`;
138 /*!40101 SET @saved_cs_client = @@character_set_client */;
139 /*!40101 SET character_set_client = utf8 */;
140 CREATE TABLE `cloudify_managers` (
141 `ID` varchar(50) NOT NULL,
142 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
143 `USERNAME` varchar(255) DEFAULT NULL,
144 `PASSWORD` varchar(255) DEFAULT NULL,
145 `VERSION` varchar(20) DEFAULT NULL,
146 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
147 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
148 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
150 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
151 /*!40101 SET character_set_client = @saved_cs_client */;
154 -- Table structure for table `collection_network_resource_customization`
157 DROP TABLE IF EXISTS `collection_network_resource_customization`;
158 /*!40101 SET @saved_cs_client = @@character_set_client */;
159 /*!40101 SET character_set_client = utf8 */;
160 CREATE TABLE `collection_network_resource_customization` (
161 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
162 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
163 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
164 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
165 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
166 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
167 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
168 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
169 `INSTANCE_GROUP_MODEL_UUID` varchar(200) DEFAULT NULL,
170 `CRC_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
171 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`,`CRC_MODEL_CUSTOMIZATION_UUID`),
172 KEY `fk_collection_net_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
173 KEY `fk_collection_net_resource_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
174 KEY `fk_col_net_res_customization__collection_res_customization_idx` (`CRC_MODEL_CUSTOMIZATION_UUID`),
175 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,
176 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,
177 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
178 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
179 /*!40101 SET character_set_client = @saved_cs_client */;
182 -- Table structure for table `collection_resource`
185 DROP TABLE IF EXISTS `collection_resource`;
186 /*!40101 SET @saved_cs_client = @@character_set_client */;
187 /*!40101 SET character_set_client = utf8 */;
188 CREATE TABLE `collection_resource` (
189 `MODEL_UUID` varchar(200) NOT NULL,
190 `MODEL_NAME` varchar(200) NOT NULL,
191 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
192 `MODEL_VERSION` varchar(20) NOT NULL,
193 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
194 `DESCRIPTION` varchar(1200) DEFAULT NULL,
195 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
196 PRIMARY KEY (`MODEL_UUID`)
197 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
198 /*!40101 SET character_set_client = @saved_cs_client */;
201 -- Table structure for table `collection_resource_customization`
204 DROP TABLE IF EXISTS `collection_resource_customization`;
205 /*!40101 SET @saved_cs_client = @@character_set_client */;
206 /*!40101 SET character_set_client = utf8 */;
207 CREATE TABLE `collection_resource_customization` (
208 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
209 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
210 `role` varchar(200) DEFAULT NULL,
211 `object_type` varchar(200) NOT NULL,
212 `function` varchar(200) DEFAULT NULL,
213 `collection_resource_type` varchar(200) DEFAULT NULL,
214 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
215 `CR_MODEL_UUID` varchar(200) NOT NULL,
216 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
217 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`),
218 CONSTRAINT `collection_resource_customization_ibfk_1` FOREIGN KEY (`CR_MODEL_UUID`) REFERENCES `collection_resource` (`MODEL_UUID`) ON DELETE CASCADE
219 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
220 /*!40101 SET character_set_client = @saved_cs_client */;
223 -- Table structure for table `collection_resource_customization_to_service`
226 DROP TABLE IF EXISTS `collection_resource_customization_to_service`;
227 /*!40101 SET @saved_cs_client = @@character_set_client */;
228 /*!40101 SET character_set_client = utf8 */;
229 CREATE TABLE `collection_resource_customization_to_service` (
230 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
231 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
232 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
233 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
234 CONSTRAINT `collection_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
235 CONSTRAINT `collection_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `collection_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
236 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
237 /*!40101 SET character_set_client = @saved_cs_client */;
240 -- Table structure for table `collection_resource_instance_group_customization`
243 DROP TABLE IF EXISTS `collection_resource_instance_group_customization`;
244 /*!40101 SET @saved_cs_client = @@character_set_client */;
245 /*!40101 SET character_set_client = utf8 */;
246 CREATE TABLE `collection_resource_instance_group_customization` (
247 `COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID` varchar(200) NOT NULL,
248 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
249 `FUNCTION` varchar(200) DEFAULT NULL,
250 `DESCRIPTION` varchar(1200) DEFAULT NULL,
251 `SUBINTERFACE_NETWORK_QUANTITY` int(11) DEFAULT NULL,
252 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
253 PRIMARY KEY (`COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID`,`INSTANCE_GROUP_MODEL_UUID`),
254 KEY `fk_collection_resource_instance_group_customization__instan_idx` (`INSTANCE_GROUP_MODEL_UUID`),
255 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,
256 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
257 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
258 /*!40101 SET character_set_client = @saved_cs_client */;
261 -- Table structure for table `configuration`
264 DROP TABLE IF EXISTS `configuration`;
265 /*!40101 SET @saved_cs_client = @@character_set_client */;
266 /*!40101 SET character_set_client = utf8 */;
267 CREATE TABLE `configuration` (
268 `MODEL_UUID` varchar(200) NOT NULL,
269 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
270 `MODEL_VERSION` varchar(20) NOT NULL,
271 `MODEL_NAME` varchar(200) NOT NULL,
272 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
273 `DESCRIPTION` varchar(1200) DEFAULT NULL,
274 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
275 PRIMARY KEY (`MODEL_UUID`)
276 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
277 /*!40101 SET character_set_client = @saved_cs_client */;
280 -- Table structure for table `configuration_customization`
283 DROP TABLE IF EXISTS `configuration_customization`;
284 /*!40101 SET @saved_cs_client = @@character_set_client */;
285 /*!40101 SET character_set_client = utf8 */;
286 CREATE TABLE `configuration_customization` (
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_UUID` varchar(200) DEFAULT NULL,
296 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
297 KEY `fk_configuration_customization__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
298 KEY `fk_configuration_customization__service_proxy_customization_idx` (`SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID`),
299 KEY `fk_configuration_customization__configuration_customization_idx` (`CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID`),
300 CONSTRAINT `fk_configuration_customization__configuration_customization1` FOREIGN KEY (`CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID`) REFERENCES `configuration_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
301 CONSTRAINT `fk_configuration_resource_customization__configuration_resour1` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
302 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
303 /*!40101 SET character_set_client = @saved_cs_client */;
306 -- Table structure for table `configuration_customization_to_service`
309 DROP TABLE IF EXISTS `configuration_customization_to_service`;
310 /*!40101 SET @saved_cs_client = @@character_set_client */;
311 /*!40101 SET character_set_client = utf8 */;
312 CREATE TABLE `configuration_customization_to_service` (
313 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
314 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
315 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
316 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
317 /*!40101 SET character_set_client = @saved_cs_client */;
320 -- Table structure for table `controller_selection_reference`
323 DROP TABLE IF EXISTS `controller_selection_reference`;
324 /*!40101 SET @saved_cs_client = @@character_set_client */;
325 /*!40101 SET character_set_client = utf8 */;
326 CREATE TABLE `controller_selection_reference` (
327 `VNF_TYPE` varchar(50) NOT NULL,
328 `CONTROLLER_NAME` varchar(100) NOT NULL,
329 `ACTION_CATEGORY` varchar(15) NOT NULL,
330 PRIMARY KEY (`VNF_TYPE`,`CONTROLLER_NAME`,`ACTION_CATEGORY`)
331 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
332 /*!40101 SET character_set_client = @saved_cs_client */;
335 -- Table structure for table `cvnfc_configuration_customization`
338 DROP TABLE IF EXISTS `cvnfc_configuration_customization`;
339 /*!40101 SET @saved_cs_client = @@character_set_client */;
340 /*!40101 SET character_set_client = utf8 */;
341 CREATE TABLE `cvnfc_configuration_customization` (
342 `ID` int(11) NOT NULL AUTO_INCREMENT,
343 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
344 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
345 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
346 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
347 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
348 `POLICY_NAME` varchar(200) DEFAULT NULL,
349 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
350 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
351 `CVNFC_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
353 KEY `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
354 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
355 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
356 /*!40101 SET character_set_client = @saved_cs_client */;
359 -- Table structure for table `cvnfc_customization`
362 DROP TABLE IF EXISTS `cvnfc_customization`;
363 /*!40101 SET @saved_cs_client = @@character_set_client */;
364 /*!40101 SET character_set_client = utf8 */;
365 CREATE TABLE `cvnfc_customization` (
366 `ID` int(11) NOT NULL AUTO_INCREMENT,
367 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
368 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
369 `MODEL_UUID` varchar(200) NOT NULL,
370 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
371 `MODEL_VERSION` varchar(20) NOT NULL,
372 `MODEL_NAME` varchar(200) NOT NULL,
373 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
374 `DESCRIPTION` varchar(1200) DEFAULT NULL,
375 `NFC_FUNCTION` varchar(200) DEFAULT NULL,
376 `NFC_NAMING_CODE` varchar(200) DEFAULT NULL,
377 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
378 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
379 `VF_MODULE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
381 KEY `fk_cvnfc_customization__vnfc_customization1_idx` (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`),
382 KEY `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID`),
383 KEY `fk_cvnfc_customization_to_vf_module_resource_customization` (`VF_MODULE_CUSTOMIZATION_ID`),
384 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,
385 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
386 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
387 /*!40101 SET character_set_client = @saved_cs_client */;
390 -- Table structure for table `external_service_to_internal_model_mapping`
393 DROP TABLE IF EXISTS `external_service_to_internal_model_mapping`;
394 /*!40101 SET @saved_cs_client = @@character_set_client */;
395 /*!40101 SET character_set_client = utf8 */;
396 CREATE TABLE `external_service_to_internal_model_mapping` (
397 `id` int(11) NOT NULL AUTO_INCREMENT,
398 `SERVICE_NAME` varchar(200) NOT NULL,
399 `PRODUCT_FLAVOR` varchar(200) DEFAULT NULL,
400 `SUBSCRIPTION_SERVICE_TYPE` varchar(200) NOT NULL,
401 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
403 UNIQUE KEY `UK_external_service_to_internal_model_mapping` (`SERVICE_NAME`,`PRODUCT_FLAVOR`,`SERVICE_MODEL_UUID`)
404 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
405 /*!40101 SET character_set_client = @saved_cs_client */;
408 -- Table structure for table `flyway_schema_history`
411 DROP TABLE IF EXISTS `flyway_schema_history`;
412 /*!40101 SET @saved_cs_client = @@character_set_client */;
413 /*!40101 SET character_set_client = utf8 */;
414 CREATE TABLE `flyway_schema_history` (
415 `installed_rank` int(11) NOT NULL,
416 `version` varchar(50) DEFAULT NULL,
417 `description` varchar(200) NOT NULL,
418 `type` varchar(20) NOT NULL,
419 `script` varchar(1000) NOT NULL,
420 `checksum` int(11) DEFAULT NULL,
421 `installed_by` varchar(100) NOT NULL,
422 `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
423 `execution_time` int(11) NOT NULL,
424 `success` tinyint(1) NOT NULL,
425 PRIMARY KEY (`installed_rank`),
426 KEY `flyway_schema_history_s_idx` (`success`)
427 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
428 /*!40101 SET character_set_client = @saved_cs_client */;
431 -- Table structure for table `heat_environment`
434 DROP TABLE IF EXISTS `heat_environment`;
435 /*!40101 SET @saved_cs_client = @@character_set_client */;
436 /*!40101 SET character_set_client = utf8 */;
437 CREATE TABLE `heat_environment` (
438 `ARTIFACT_UUID` varchar(200) NOT NULL,
439 `NAME` varchar(100) NOT NULL,
440 `VERSION` varchar(20) NOT NULL,
441 `DESCRIPTION` varchar(1200) DEFAULT NULL,
442 `BODY` longtext NOT NULL,
443 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
444 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
445 PRIMARY KEY (`ARTIFACT_UUID`)
446 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
447 /*!40101 SET character_set_client = @saved_cs_client */;
450 -- Table structure for table `heat_files`
453 DROP TABLE IF EXISTS `heat_files`;
454 /*!40101 SET @saved_cs_client = @@character_set_client */;
455 /*!40101 SET character_set_client = utf8 */;
456 CREATE TABLE `heat_files` (
457 `ARTIFACT_UUID` varchar(200) NOT NULL,
458 `NAME` varchar(200) NOT NULL,
459 `VERSION` varchar(20) NOT NULL,
460 `DESCRIPTION` varchar(1200) DEFAULT NULL,
461 `BODY` longtext NOT NULL,
462 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
463 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
464 PRIMARY KEY (`ARTIFACT_UUID`)
465 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
466 /*!40101 SET character_set_client = @saved_cs_client */;
469 -- Table structure for table `heat_nested_template`
472 DROP TABLE IF EXISTS `heat_nested_template`;
473 /*!40101 SET @saved_cs_client = @@character_set_client */;
474 /*!40101 SET character_set_client = utf8 */;
475 CREATE TABLE `heat_nested_template` (
476 `PARENT_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
477 `CHILD_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
478 `PROVIDER_RESOURCE_FILE` varchar(100) DEFAULT NULL,
479 PRIMARY KEY (`PARENT_HEAT_TEMPLATE_UUID`,`CHILD_HEAT_TEMPLATE_UUID`),
480 KEY `fk_heat_nested_template__heat_template2_idx` (`CHILD_HEAT_TEMPLATE_UUID`),
481 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,
482 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
483 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
484 /*!40101 SET character_set_client = @saved_cs_client */;
487 -- Table structure for table `heat_template`
490 DROP TABLE IF EXISTS `heat_template`;
491 /*!40101 SET @saved_cs_client = @@character_set_client */;
492 /*!40101 SET character_set_client = utf8 */;
493 CREATE TABLE `heat_template` (
494 `ARTIFACT_UUID` varchar(200) NOT NULL,
495 `NAME` varchar(200) NOT NULL,
496 `VERSION` varchar(20) NOT NULL,
497 `DESCRIPTION` varchar(1200) DEFAULT NULL,
498 `BODY` longtext NOT NULL,
499 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
500 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
501 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
502 PRIMARY KEY (`ARTIFACT_UUID`)
503 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
504 /*!40101 SET character_set_client = @saved_cs_client */;
507 -- Table structure for table `heat_template_params`
510 DROP TABLE IF EXISTS `heat_template_params`;
511 /*!40101 SET @saved_cs_client = @@character_set_client */;
512 /*!40101 SET character_set_client = utf8 */;
513 CREATE TABLE `heat_template_params` (
514 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NOT NULL,
515 `PARAM_NAME` varchar(100) NOT NULL,
516 `IS_REQUIRED` bit(1) NOT NULL,
517 `PARAM_TYPE` varchar(20) DEFAULT NULL,
518 `PARAM_ALIAS` varchar(45) DEFAULT NULL,
519 PRIMARY KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`,`PARAM_NAME`),
520 CONSTRAINT `fk_heat_template_params__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
521 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
522 /*!40101 SET character_set_client = @saved_cs_client */;
525 -- Table structure for table `identity_services`
528 DROP TABLE IF EXISTS `identity_services`;
529 /*!40101 SET @saved_cs_client = @@character_set_client */;
530 /*!40101 SET character_set_client = utf8 */;
531 CREATE TABLE `identity_services` (
532 `ID` varchar(50) NOT NULL,
533 `IDENTITY_URL` varchar(200) DEFAULT NULL,
534 `MSO_ID` varchar(255) DEFAULT NULL,
535 `MSO_PASS` varchar(255) DEFAULT NULL,
536 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
537 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
538 `TENANT_METADATA` tinyint(1) DEFAULT '0',
539 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
540 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
541 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
542 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
543 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
544 `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL,
545 `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL,
547 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
548 /*!40101 SET character_set_client = @saved_cs_client */;
551 -- Table structure for table `instance_group`
554 DROP TABLE IF EXISTS `instance_group`;
555 /*!40101 SET @saved_cs_client = @@character_set_client */;
556 /*!40101 SET character_set_client = utf8 */;
557 CREATE TABLE `instance_group` (
558 `MODEL_UUID` varchar(200) NOT NULL,
559 `MODEL_NAME` varchar(200) NOT NULL,
560 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
561 `MODEL_VERSION` varchar(20) NOT NULL,
562 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
563 `ROLE` varchar(200) NOT NULL,
564 `OBJECT_TYPE` varchar(200) NOT NULL,
565 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
566 `CR_MODEL_UUID` varchar(200) DEFAULT NULL,
567 `INSTANCE_GROUP_TYPE` varchar(200) NOT NULL,
568 PRIMARY KEY (`MODEL_UUID`),
569 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`)
570 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
571 /*!40101 SET character_set_client = @saved_cs_client */;
574 -- Table structure for table `model`
577 DROP TABLE IF EXISTS `model`;
578 /*!40101 SET @saved_cs_client = @@character_set_client */;
579 /*!40101 SET character_set_client = utf8 */;
580 CREATE TABLE `model` (
581 `ID` int(11) NOT NULL AUTO_INCREMENT,
582 `MODEL_CUSTOMIZATION_ID` varchar(40) DEFAULT NULL,
583 `MODEL_CUSTOMIZATION_NAME` varchar(40) DEFAULT NULL,
584 `MODEL_INVARIANT_ID` varchar(40) DEFAULT NULL,
585 `MODEL_NAME` varchar(40) DEFAULT NULL,
586 `MODEL_TYPE` varchar(20) DEFAULT NULL,
587 `MODEL_VERSION` varchar(20) DEFAULT NULL,
588 `MODEL_VERSION_ID` varchar(40) DEFAULT NULL,
589 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
590 `RECIPE` int(11) DEFAULT NULL,
592 UNIQUE KEY `uk1_model` (`MODEL_TYPE`,`MODEL_VERSION_ID`),
593 KEY `RECIPE` (`RECIPE`),
594 CONSTRAINT `model_ibfk_1` FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
595 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
596 /*!40101 SET character_set_client = @saved_cs_client */;
599 -- Table structure for table `model_recipe`
602 DROP TABLE IF EXISTS `model_recipe`;
603 /*!40101 SET @saved_cs_client = @@character_set_client */;
604 /*!40101 SET character_set_client = utf8 */;
605 CREATE TABLE `model_recipe` (
606 `ID` int(11) NOT NULL AUTO_INCREMENT,
607 `MODEL_ID` int(11) DEFAULT NULL,
608 `ACTION` varchar(40) DEFAULT NULL,
609 `SCHEMA_VERSION` varchar(40) DEFAULT NULL,
610 `DESCRIPTION` varchar(40) DEFAULT NULL,
611 `ORCHESTRATION_URI` varchar(20) DEFAULT NULL,
612 `MODEL_PARAM_XSD` varchar(20) DEFAULT NULL,
613 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
614 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
616 UNIQUE KEY `uk1_model_recipe` (`MODEL_ID`,`ACTION`)
617 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
618 /*!40101 SET character_set_client = @saved_cs_client */;
621 -- Table structure for table `network_recipe`
624 DROP TABLE IF EXISTS `network_recipe`;
625 /*!40101 SET @saved_cs_client = @@character_set_client */;
626 /*!40101 SET character_set_client = utf8 */;
627 CREATE TABLE `network_recipe` (
628 `id` int(11) NOT NULL AUTO_INCREMENT,
629 `MODEL_NAME` varchar(20) NOT NULL,
630 `ACTION` varchar(50) NOT NULL,
631 `DESCRIPTION` varchar(1200) DEFAULT NULL,
632 `ORCHESTRATION_URI` varchar(256) NOT NULL,
633 `NETWORK_PARAM_XSD` varchar(2048) DEFAULT NULL,
634 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
635 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
636 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
637 `VERSION_STR` varchar(20) NOT NULL,
638 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
639 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
641 UNIQUE KEY `UK_rl4f296i0p8lyokxveaiwkayi` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
642 ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
643 /*!40101 SET character_set_client = @saved_cs_client */;
646 -- Table structure for table `network_resource`
649 DROP TABLE IF EXISTS `network_resource`;
650 /*!40101 SET @saved_cs_client = @@character_set_client */;
651 /*!40101 SET character_set_client = utf8 */;
652 CREATE TABLE `network_resource` (
653 `MODEL_UUID` varchar(200) NOT NULL,
654 `MODEL_NAME` varchar(200) NOT NULL,
655 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
656 `DESCRIPTION` varchar(1200) DEFAULT NULL,
657 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
658 `NEUTRON_NETWORK_TYPE` varchar(20) DEFAULT NULL,
659 `MODEL_VERSION` varchar(20) DEFAULT NULL,
660 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
661 `AIC_VERSION_MIN` varchar(20) NULL,
662 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
663 `ORCHESTRATION_MODE` varchar(20) DEFAULT 'HEAT',
664 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
665 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
666 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
667 PRIMARY KEY (`MODEL_UUID`),
668 KEY `fk_network_resource__temp_network_heat_template_lookup1_idx` (`MODEL_NAME`),
669 KEY `fk_network_resource__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
670 CONSTRAINT `fk_network_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE NO ACTION ON UPDATE CASCADE,
671 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
672 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
673 /*!40101 SET character_set_client = @saved_cs_client */;
676 -- Table structure for table `network_resource_customization`
679 DROP TABLE IF EXISTS `network_resource_customization`;
680 /*!40101 SET @saved_cs_client = @@character_set_client */;
681 /*!40101 SET character_set_client = utf8 */;
682 CREATE TABLE `network_resource_customization` (
683 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
684 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
685 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
686 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
687 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
688 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
689 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
690 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
691 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
692 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
693 KEY `fk_network_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
694 CONSTRAINT `fk_network_resource_customization__network_resource1` FOREIGN KEY (`NETWORK_RESOURCE_MODEL_UUID`) REFERENCES `network_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
695 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
696 /*!40101 SET character_set_client = @saved_cs_client */;
699 -- Table structure for table `network_resource_customization_to_service`
702 DROP TABLE IF EXISTS `network_resource_customization_to_service`;
703 /*!40101 SET @saved_cs_client = @@character_set_client */;
704 /*!40101 SET character_set_client = utf8 */;
705 CREATE TABLE `network_resource_customization_to_service` (
706 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
707 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
708 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
709 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
710 CONSTRAINT `network_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
711 CONSTRAINT `network_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `network_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
712 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
713 /*!40101 SET character_set_client = @saved_cs_client */;
716 -- Table structure for table `northbound_request_ref_lookup`
719 DROP TABLE IF EXISTS `northbound_request_ref_lookup`;
720 /*!40101 SET @saved_cs_client = @@character_set_client */;
721 /*!40101 SET character_set_client = utf8 */;
722 CREATE TABLE `northbound_request_ref_lookup` (
723 `id` int(11) NOT NULL AUTO_INCREMENT,
724 `REQUEST_SCOPE` varchar(200) NOT NULL,
725 `MACRO_ACTION` varchar(200) NOT NULL,
726 `ACTION` varchar(200) NOT NULL,
727 `IS_ALACARTE` tinyint(1) NOT NULL DEFAULT '0',
728 `MIN_API_VERSION` double NOT NULL,
729 `MAX_API_VERSION` double DEFAULT NULL,
730 `IS_TOPLEVELFLOW` tinyint(1) DEFAULT NULL,
731 `CLOUD_OWNER` varchar(200) NOT NULL,
733 UNIQUE KEY `UK_northbound_request_ref_lookup` (`MIN_API_VERSION`,`REQUEST_SCOPE`,`ACTION`,`IS_ALACARTE`,`MACRO_ACTION`,`CLOUD_OWNER`)
734 ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;
735 /*!40101 SET character_set_client = @saved_cs_client */;
738 -- Table structure for table `orchestration_flow_reference`
741 DROP TABLE IF EXISTS `orchestration_flow_reference`;
742 /*!40101 SET @saved_cs_client = @@character_set_client */;
743 /*!40101 SET character_set_client = utf8 */;
744 CREATE TABLE `orchestration_flow_reference` (
745 `id` int(11) NOT NULL AUTO_INCREMENT,
746 `COMPOSITE_ACTION` varchar(200) NOT NULL,
747 `SEQ_NO` int(11) NOT NULL,
748 `FLOW_NAME` varchar(200) NOT NULL,
749 `FLOW_VERSION` double NOT NULL,
750 `NB_REQ_REF_LOOKUP_ID` int(11) NOT NULL,
752 UNIQUE KEY `UK_orchestration_flow_reference` (`COMPOSITE_ACTION`,`FLOW_NAME`,`SEQ_NO`,`NB_REQ_REF_LOOKUP_ID`),
753 KEY `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID`),
754 KEY `fk_orchestration_flow_reference__building_block_detail` (`FLOW_NAME`),
755 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
756 ) ENGINE=InnoDB AUTO_INCREMENT=398 DEFAULT CHARSET=latin1;
757 /*!40101 SET character_set_client = @saved_cs_client */;
760 -- Table structure for table `orchestration_status_state_transition_directive`
763 DROP TABLE IF EXISTS `orchestration_status_state_transition_directive`;
764 /*!40101 SET @saved_cs_client = @@character_set_client */;
765 /*!40101 SET character_set_client = utf8 */;
766 CREATE TABLE `orchestration_status_state_transition_directive` (
767 `id` int(11) NOT NULL AUTO_INCREMENT,
768 `RESOURCE_TYPE` varchar(25) NOT NULL,
769 `ORCHESTRATION_STATUS` varchar(25) NOT NULL,
770 `TARGET_ACTION` varchar(25) NOT NULL,
771 `FLOW_DIRECTIVE` varchar(25) NOT NULL,
773 UNIQUE KEY `UK_orchestration_status_state_transition_directive` (`RESOURCE_TYPE`,`ORCHESTRATION_STATUS`,`TARGET_ACTION`)
774 ) ENGINE=InnoDB AUTO_INCREMENT=686 DEFAULT CHARSET=latin1;
775 /*!40101 SET character_set_client = @saved_cs_client */;
778 -- Table structure for table `rainy_day_handler_macro`
781 DROP TABLE IF EXISTS `rainy_day_handler_macro`;
782 /*!40101 SET @saved_cs_client = @@character_set_client */;
783 /*!40101 SET character_set_client = utf8 */;
784 CREATE TABLE `rainy_day_handler_macro` (
785 `id` int(11) NOT NULL AUTO_INCREMENT,
786 `FLOW_NAME` varchar(200) NOT NULL,
787 `SERVICE_TYPE` varchar(200) NOT NULL,
788 `VNF_TYPE` varchar(200) NOT NULL,
789 `ERROR_CODE` varchar(200) NOT NULL,
790 `WORK_STEP` varchar(200) NOT NULL,
791 `POLICY` varchar(200) NOT NULL,
792 `SECONDARY_POLICY` varchar(200) DEFAULT NULL,
794 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
795 /*!40101 SET character_set_client = @saved_cs_client */;
798 -- Table structure for table `service`
801 DROP TABLE IF EXISTS `service`;
802 /*!40101 SET @saved_cs_client = @@character_set_client */;
803 /*!40101 SET character_set_client = utf8 */;
804 CREATE TABLE `service` (
805 `MODEL_UUID` varchar(200) NOT NULL,
806 `MODEL_NAME` varchar(200) NOT NULL,
807 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
808 `MODEL_VERSION` varchar(20) NOT NULL,
809 `DESCRIPTION` varchar(1200) DEFAULT NULL,
810 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
811 `TOSCA_CSAR_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
812 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
813 `SERVICE_ROLE` varchar(200) DEFAULT NULL,
814 `ENVIRONMENT_CONTEXT` varchar(200) DEFAULT NULL,
815 `WORKLOAD_CONTEXT` varchar(200) DEFAULT NULL,
816 `SERVICE_CATEGORY` varchar(200) DEFAULT NULL,
817 `RESOURCE_ORDER` varchar(200) default NULL,
818 PRIMARY KEY (`MODEL_UUID`),
819 KEY `fk_service__tosca_csar1_idx` (`TOSCA_CSAR_ARTIFACT_UUID`),
820 CONSTRAINT `fk_service__tosca_csar1` FOREIGN KEY (`TOSCA_CSAR_ARTIFACT_UUID`) REFERENCES `tosca_csar` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
821 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
822 /*!40101 SET character_set_client = @saved_cs_client */;
825 -- Table structure for table `service_proxy_customization`
828 DROP TABLE IF EXISTS `service_proxy_customization`;
829 /*!40101 SET @saved_cs_client = @@character_set_client */;
830 /*!40101 SET character_set_client = utf8 */;
831 CREATE TABLE `service_proxy_customization` (
832 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
833 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
834 `MODEL_UUID` varchar(200) NOT NULL,
835 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
836 `MODEL_VERSION` varchar(20) NOT NULL,
837 `MODEL_NAME` varchar(200) NOT NULL,
838 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
839 `DESCRIPTION` varchar(1200) DEFAULT NULL,
840 `SOURCE_SERVICE_MODEL_UUID` varchar(200) NOT NULL,
841 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
842 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
843 KEY `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID`),
844 CONSTRAINT `fk_service_proxy_resource_customization__service1` FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
845 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
846 /*!40101 SET character_set_client = @saved_cs_client */;
849 -- Table structure for table `service_proxy_customization_to_service`
852 DROP TABLE IF EXISTS `service_proxy_customization_to_service`;
853 /*!40101 SET @saved_cs_client = @@character_set_client */;
854 /*!40101 SET character_set_client = utf8 */;
855 CREATE TABLE `service_proxy_customization_to_service` (
856 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
857 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
858 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
859 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
860 /*!40101 SET character_set_client = @saved_cs_client */;
863 -- Table structure for table `service_recipe`
866 DROP TABLE IF EXISTS `service_recipe`;
867 /*!40101 SET @saved_cs_client = @@character_set_client */;
868 /*!40101 SET character_set_client = utf8 */;
869 CREATE TABLE `service_recipe` (
870 `id` int(11) NOT NULL AUTO_INCREMENT,
871 `ACTION` varchar(50) NOT NULL,
872 `VERSION_STR` varchar(20) DEFAULT NULL,
873 `DESCRIPTION` varchar(1200) DEFAULT NULL,
874 `ORCHESTRATION_URI` varchar(256) NOT NULL,
875 `SERVICE_PARAM_XSD` varchar(2048) DEFAULT NULL,
876 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
877 `SERVICE_TIMEOUT_INTERIM` int(11) DEFAULT NULL,
878 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
879 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
881 UNIQUE KEY `UK_7fav5dkux2v8g9d2i5ymudlgc` (`SERVICE_MODEL_UUID`,`ACTION`),
882 KEY `fk_service_recipe__service1_idx` (`SERVICE_MODEL_UUID`),
883 CONSTRAINT `fk_service_recipe__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
884 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
885 /*!40101 SET character_set_client = @saved_cs_client */;
888 -- Table structure for table `temp_network_heat_template_lookup`
891 DROP TABLE IF EXISTS `temp_network_heat_template_lookup`;
892 /*!40101 SET @saved_cs_client = @@character_set_client */;
893 /*!40101 SET character_set_client = utf8 */;
894 CREATE TABLE `temp_network_heat_template_lookup` (
895 `NETWORK_RESOURCE_MODEL_NAME` varchar(200) NOT NULL,
896 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
897 `AIC_VERSION_MIN` varchar(20) NULL,
898 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
899 PRIMARY KEY (`NETWORK_RESOURCE_MODEL_NAME`),
900 KEY `fk_temp_network_heat_template_lookup__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
901 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
902 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
903 /*!40101 SET character_set_client = @saved_cs_client */;
906 -- Table structure for table `tosca_csar`
909 DROP TABLE IF EXISTS `tosca_csar`;
910 /*!40101 SET @saved_cs_client = @@character_set_client */;
911 /*!40101 SET character_set_client = utf8 */;
912 CREATE TABLE `tosca_csar` (
913 `ARTIFACT_UUID` varchar(200) NOT NULL,
914 `NAME` varchar(200) NOT NULL,
915 `VERSION` varchar(20) NOT NULL,
916 `DESCRIPTION` varchar(1200) DEFAULT NULL,
917 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL,
918 `URL` varchar(200) NOT NULL,
919 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
920 PRIMARY KEY (`ARTIFACT_UUID`)
921 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
922 /*!40101 SET character_set_client = @saved_cs_client */;
925 -- Table structure for table `vf_module`
928 DROP TABLE IF EXISTS `vf_module`;
929 /*!40101 SET @saved_cs_client = @@character_set_client */;
930 /*!40101 SET character_set_client = utf8 */;
931 CREATE TABLE `vf_module` (
932 `MODEL_UUID` varchar(200) NOT NULL,
933 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
934 `MODEL_VERSION` varchar(20) NOT NULL,
935 `MODEL_NAME` varchar(200) NOT NULL,
936 `DESCRIPTION` varchar(1200) DEFAULT NULL,
937 `IS_BASE` tinyint(1) NOT NULL,
938 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
939 `VOL_HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
940 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
941 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
942 PRIMARY KEY (`MODEL_UUID`,`VNF_RESOURCE_MODEL_UUID`),
943 KEY `fk_vf_module__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
944 KEY `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
945 KEY `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`VOL_HEAT_TEMPLATE_ARTIFACT_UUID`),
946 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,
947 CONSTRAINT `fk_vf_module__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
948 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
949 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
950 /*!40101 SET character_set_client = @saved_cs_client */;
953 -- Table structure for table `vf_module_customization`
956 DROP TABLE IF EXISTS `vf_module_customization`;
957 /*!40101 SET @saved_cs_client = @@character_set_client */;
958 /*!40101 SET character_set_client = utf8 */;
959 CREATE TABLE `vf_module_customization` (
960 `ID` int(13) NOT NULL AUTO_INCREMENT,
961 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
962 `LABEL` varchar(200) DEFAULT NULL,
963 `INITIAL_COUNT` int(11) DEFAULT '0',
964 `MIN_INSTANCES` int(11) DEFAULT '0',
965 `MAX_INSTANCES` int(11) DEFAULT NULL,
966 `AVAILABILITY_ZONE_COUNT` int(11) DEFAULT NULL,
967 `HEAT_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
968 `VOL_ENVIRONMENT_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
969 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
970 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
971 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
973 KEY `fk_vf_module_customization__vf_module1_idx` (`VF_MODULE_MODEL_UUID`),
974 KEY `fk_vf_module_customization__heat_env__heat_environment1_idx` (`HEAT_ENVIRONMENT_ARTIFACT_UUID`),
975 KEY `fk_vf_module_customization__vol_env__heat_environment2_idx` (`VOL_ENVIRONMENT_ARTIFACT_UUID`),
976 KEY `fk_vf_module_customization_to_vnf_resource_customization` (`VNF_RESOURCE_CUSTOMIZATION_ID`),
977 KEY `vf_module_customization_model_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
978 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,
979 CONSTRAINT `fk_vf_module_customization__vf_module1` FOREIGN KEY (`VF_MODULE_MODEL_UUID`) REFERENCES `vf_module` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
980 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,
981 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
982 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
983 /*!40101 SET character_set_client = @saved_cs_client */;
986 -- Table structure for table `vf_module_to_heat_files`
989 DROP TABLE IF EXISTS `vf_module_to_heat_files`;
990 /*!40101 SET @saved_cs_client = @@character_set_client */;
991 /*!40101 SET character_set_client = utf8 */;
992 CREATE TABLE `vf_module_to_heat_files` (
993 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
994 `HEAT_FILES_ARTIFACT_UUID` varchar(200) NOT NULL,
995 PRIMARY KEY (`VF_MODULE_MODEL_UUID`,`HEAT_FILES_ARTIFACT_UUID`),
996 KEY `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`HEAT_FILES_ARTIFACT_UUID`),
997 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,
998 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
999 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='il fait ce qu''il dit';
1000 /*!40101 SET character_set_client = @saved_cs_client */;
1003 -- Table structure for table `vnf_components`
1006 DROP TABLE IF EXISTS `vnf_components`;
1007 /*!40101 SET @saved_cs_client = @@character_set_client */;
1008 /*!40101 SET character_set_client = utf8 */;
1009 CREATE TABLE `vnf_components` (
1010 `VNF_ID` int(11) NOT NULL,
1011 `COMPONENT_TYPE` varchar(20) NOT NULL,
1012 `HEAT_TEMPLATE_ID` int(11) DEFAULT NULL,
1013 `HEAT_ENVIRONMENT_ID` int(11) DEFAULT NULL,
1014 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1015 PRIMARY KEY (`VNF_ID`,`COMPONENT_TYPE`)
1016 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1017 /*!40101 SET character_set_client = @saved_cs_client */;
1020 -- Table structure for table `vnf_components_recipe`
1023 DROP TABLE IF EXISTS `vnf_components_recipe`;
1024 /*!40101 SET @saved_cs_client = @@character_set_client */;
1025 /*!40101 SET character_set_client = utf8 */;
1026 CREATE TABLE `vnf_components_recipe` (
1027 `id` int(11) NOT NULL AUTO_INCREMENT,
1028 `VNF_TYPE` varchar(200) DEFAULT NULL,
1029 `VNF_COMPONENT_TYPE` varchar(45) NOT NULL,
1030 `ACTION` varchar(50) NOT NULL,
1031 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1032 `VERSION` varchar(20) NOT NULL,
1033 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1034 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1035 `VNF_COMPONENT_PARAM_XSD` varchar(2048) DEFAULT NULL,
1036 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1037 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1038 `VF_MODULE_MODEL_UUID` varchar(200) DEFAULT NULL,
1040 UNIQUE KEY `UK_4dpdwddaaclhc11wxsb7h59ma` (`VF_MODULE_MODEL_UUID`,`VNF_COMPONENT_TYPE`,`ACTION`,`VERSION`)
1041 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
1042 /*!40101 SET character_set_client = @saved_cs_client */;
1045 -- Table structure for table `vnf_recipe`
1048 DROP TABLE IF EXISTS `vnf_recipe`;
1049 /*!40101 SET @saved_cs_client = @@character_set_client */;
1050 /*!40101 SET character_set_client = utf8 */;
1051 CREATE TABLE `vnf_recipe` (
1052 `id` int(11) NOT NULL AUTO_INCREMENT,
1053 `NF_ROLE` varchar(200) DEFAULT NULL,
1054 `ACTION` varchar(50) NOT NULL,
1055 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1056 `VERSION_STR` varchar(20) NOT NULL,
1057 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1058 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1059 `VNF_PARAM_XSD` varchar(2048) DEFAULT NULL,
1060 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1061 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1062 `VF_MODULE_ID` varchar(100) DEFAULT NULL,
1064 UNIQUE KEY `UK_f3tvqau498vrifq3cr8qnigkr` (`VF_MODULE_ID`,`ACTION`,`VERSION_STR`)
1065 ) ENGINE=InnoDB AUTO_INCREMENT=10015 DEFAULT CHARSET=latin1;
1066 /*!40101 SET character_set_client = @saved_cs_client */;
1069 -- Table structure for table `vnf_resource`
1072 DROP TABLE IF EXISTS `vnf_resource`;
1073 /*!40101 SET @saved_cs_client = @@character_set_client */;
1074 /*!40101 SET character_set_client = utf8 */;
1075 CREATE TABLE `vnf_resource` (
1076 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
1077 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1078 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1079 `MODEL_UUID` varchar(200) NOT NULL,
1080 `AIC_VERSION_MIN` varchar(20) DEFAULT NULL,
1081 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
1082 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1083 `MODEL_VERSION` varchar(20) NOT NULL,
1084 `MODEL_NAME` varchar(200) DEFAULT NULL,
1085 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1086 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
1087 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1088 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1089 PRIMARY KEY (`MODEL_UUID`),
1090 KEY `fk_vnf_resource__heat_template1` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
1091 CONSTRAINT `fk_vnf_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1092 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1093 /*!40101 SET character_set_client = @saved_cs_client */;
1096 -- Table structure for table `vnf_resource_customization`
1099 DROP TABLE IF EXISTS `vnf_resource_customization`;
1100 /*!40101 SET @saved_cs_client = @@character_set_client */;
1101 /*!40101 SET character_set_client = utf8 */;
1102 CREATE TABLE `vnf_resource_customization` (
1103 `ID` int(13) NOT NULL AUTO_INCREMENT,
1104 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1105 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1106 `MIN_INSTANCES` int(11) DEFAULT NULL,
1107 `MAX_INSTANCES` int(11) DEFAULT NULL,
1108 `AVAILABILITY_ZONE_MAX_COUNT` int(11) DEFAULT NULL,
1109 `NF_TYPE` varchar(200) DEFAULT NULL,
1110 `NF_ROLE` varchar(200) DEFAULT NULL,
1111 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1112 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1113 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1114 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
1115 `CDS_BLUEPRINT_NAME` varchar(200) default null,
1116 `CDS_BLUEPRINT_VERSION` varchar(20) default null,
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,
1121 UNIQUE KEY `UK_vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`,`SERVICE_MODEL_UUID`),
1122 KEY `fk_vnf_resource_customization__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
1123 KEY `fk_vnf_resource_customization_to_service` (`SERVICE_MODEL_UUID`),
1124 KEY `vnf_resource_customization_mod_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
1125 CONSTRAINT `fk_vnf_resource_customization__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1126 CONSTRAINT `fk_vnf_resource_customization_to_service` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1127 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1128 /*!40101 SET character_set_client = @saved_cs_client */;
1131 -- Table structure for table `vnfc_customization`
1134 DROP TABLE IF EXISTS `vnfc_customization`;
1135 /*!40101 SET @saved_cs_client = @@character_set_client */;
1136 /*!40101 SET character_set_client = utf8 */;
1137 CREATE TABLE `vnfc_customization` (
1138 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1139 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1140 `MODEL_UUID` varchar(200) NOT NULL,
1141 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
1142 `MODEL_VERSION` varchar(20) NOT NULL,
1143 `MODEL_NAME` varchar(200) NOT NULL,
1144 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
1145 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1146 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1147 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`)
1148 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1149 /*!40101 SET character_set_client = @saved_cs_client */;
1152 -- Table structure for table `vnfc_instance_group_customization`
1155 DROP TABLE IF EXISTS `vnfc_instance_group_customization`;
1156 /*!40101 SET @saved_cs_client = @@character_set_client */;
1157 /*!40101 SET character_set_client = utf8 */;
1158 CREATE TABLE `vnfc_instance_group_customization` (
1159 `ID` int(13) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1160 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) NOT NULL,
1161 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
1162 `FUNCTION` varchar(200) DEFAULT NULL,
1163 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1164 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1165 KEY `fk_vnfc_instance_group_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
1166 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,
1167 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
1168 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1169 set foreign_key_checks=1;
1171 CREATE TABLE IF NOT EXISTS `pnf_resource` (
1172 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
1173 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1174 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1175 `MODEL_UUID` varchar(200) NOT NULL,
1176 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1177 `MODEL_VERSION` varchar(20) NOT NULL,
1178 `MODEL_NAME` varchar(200) DEFAULT NULL,
1179 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1180 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1181 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1182 PRIMARY KEY (`MODEL_UUID`)
1183 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1185 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
1186 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1187 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1188 `NF_TYPE` varchar(200) DEFAULT NULL,
1189 `NF_ROLE` varchar(200) DEFAULT NULL,
1190 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1191 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1192 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1193 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1194 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1195 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
1196 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
1197 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
1198 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
1199 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
1200 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1201 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1203 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
1204 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1205 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1206 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
1207 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
1209 --------START Request DB SCHEMA --------
1210 CREATE DATABASE requestdb;
1214 CREATE TABLE `active_requests` (
1215 `REQUEST_ID` varchar(45) NOT NULL,
1216 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1217 `SERVICE_INSTANCE_ID` varchar(50) NOT NULL,
1218 `SUBSCRIBER_NAME` varchar(200) DEFAULT NULL,
1219 `REQUEST_URI` varchar(255) DEFAULT NULL,
1220 `SERVICE_TYPE` varchar(65) NOT NULL,
1221 `REQUEST_ACTION` varchar(45) NOT NULL,
1222 `NOTIFICATION_URL` varchar(255) DEFAULT NULL,
1223 `REQUEST_ID_IN_PROGRESS` varchar(45) DEFAULT NULL,
1224 `START_TIME` datetime DEFAULT NULL,
1225 `MODIFY_TIME` datetime DEFAULT NULL,
1226 `COMPLETION_TIME` datetime DEFAULT NULL,
1227 `RESPONSE_CODE` varchar(20) DEFAULT NULL,
1228 `RESPONSE_BODY` longtext,
1229 `STATUS` varchar(25) DEFAULT NULL,
1230 `SERVICE_REQUEST_TIMEOUT` datetime DEFAULT NULL,
1231 `FINAL_ERROR_CODE` varchar(20) DEFAULT NULL,
1232 `FINAL_ERROR_MESSAGE` varchar(2000) DEFAULT NULL,
1233 `ORDER_NUMBER` varchar(45) DEFAULT NULL,
1234 `SOURCE` varchar(20) DEFAULT NULL,
1235 `RESPONSE_STATUS` varchar(25) DEFAULT NULL,
1236 `ORDER_VERSION` varchar(20) DEFAULT NULL,
1237 `LAST_MODIFIED_BY` varchar(20) DEFAULT NULL,
1238 `MOCARS_TICKET_NUM` varchar(200) DEFAULT NULL,
1239 `REQUEST_BODY` longtext,
1240 `REQUEST_SUB_ACTION` varchar(45) DEFAULT NULL,
1241 `SDNC_CALLBACK_BPEL_URL` varchar(255) DEFAULT NULL,
1242 `FEATURE_TYPE` varchar(255) DEFAULT NULL,
1243 `FEATURE_INSTANCE_ID` varchar(255) DEFAULT NULL,
1244 `REQUEST_TYPE` varchar(255) DEFAULT NULL,
1245 `INTERIM_COMPLETION_TIME` datetime DEFAULT NULL,
1246 `INTERIM_STAGE_COMPLETION` int(11) DEFAULT NULL,
1247 `SERVICE_NAME_VERSION_ID` varchar(50) DEFAULT NULL,
1248 `GLOBAL_SUBSCRIBER_ID` varchar(255) DEFAULT NULL,
1249 `SERVICE_ID` varchar(50) DEFAULT NULL,
1250 `SERVICE_VERSION` varchar(10) DEFAULT NULL,
1251 `CORRELATOR` varchar(50) DEFAULT NULL,
1252 PRIMARY KEY (`REQUEST_ID`),
1253 UNIQUE KEY `UK_f0hdk7xbw5mb2trnxx0fvlh3x` (`CLIENT_REQUEST_ID`)
1254 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1256 CREATE TABLE `infra_active_requests` (
1257 `REQUEST_ID` varchar(45) NOT NULL,
1258 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1259 `ACTION` varchar(45) DEFAULT NULL,
1260 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
1261 `STATUS_MESSAGE` longtext DEFAULT NULL,
1262 `PROGRESS` bigint(20) DEFAULT NULL,
1263 `START_TIME` datetime DEFAULT NULL,
1264 `END_TIME` datetime DEFAULT NULL,
1265 `SOURCE` varchar(45) DEFAULT NULL,
1266 `VNF_ID` varchar(45) DEFAULT NULL,
1267 `VNF_NAME` varchar(80) DEFAULT NULL,
1268 `VNF_TYPE` varchar(200) DEFAULT NULL,
1269 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1270 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
1271 `TENANT_ID` varchar(45) DEFAULT NULL,
1272 `PROV_STATUS` varchar(20) DEFAULT NULL,
1273 `VNF_PARAMS` longtext,
1274 `VNF_OUTPUTS` longtext,
1275 `REQUEST_BODY` longtext,
1276 `RESPONSE_BODY` longtext,
1277 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
1278 `MODIFY_TIME` datetime DEFAULT NULL,
1279 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
1280 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
1281 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
1282 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
1283 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
1284 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
1285 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
1286 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
1287 `CALLBACK_URL` varchar(200) DEFAULT NULL,
1288 `CORRELATOR` varchar(80) DEFAULT NULL,
1289 `NETWORK_ID` varchar(45) DEFAULT NULL,
1290 `NETWORK_NAME` varchar(80) DEFAULT NULL,
1291 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
1292 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
1293 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
1294 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
1295 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
1296 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
1297 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
1298 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
1299 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
1300 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
1301 `REQUEST_URL` varchar(500) DEFAULT NULL,
1302 PRIMARY KEY (`REQUEST_ID`),
1303 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
1304 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1306 CREATE TABLE `archived_infra_requests` (
1307 `REQUEST_ID` varchar(45) NOT NULL,
1308 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1309 `ACTION` varchar(45) DEFAULT NULL,
1310 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
1311 `STATUS_MESSAGE` longtext DEFAULT NULL,
1312 `PROGRESS` bigint(20) DEFAULT NULL,
1313 `START_TIME` datetime DEFAULT NULL,
1314 `END_TIME` datetime DEFAULT NULL,
1315 `SOURCE` varchar(45) DEFAULT NULL,
1316 `VNF_ID` varchar(45) DEFAULT NULL,
1317 `VNF_NAME` varchar(80) DEFAULT NULL,
1318 `VNF_TYPE` varchar(200) DEFAULT NULL,
1319 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1320 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
1321 `TENANT_ID` varchar(45) DEFAULT NULL,
1322 `PROV_STATUS` varchar(20) DEFAULT NULL,
1323 `VNF_PARAMS` longtext,
1324 `VNF_OUTPUTS` longtext,
1325 `REQUEST_BODY` longtext,
1326 `RESPONSE_BODY` longtext,
1327 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
1328 `MODIFY_TIME` datetime DEFAULT NULL,
1329 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
1330 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
1331 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
1332 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
1333 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
1334 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
1335 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
1336 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
1337 `CALLBACK_URL` varchar(200) DEFAULT NULL,
1338 `CORRELATOR` varchar(80) DEFAULT NULL,
1339 `NETWORK_ID` varchar(45) DEFAULT NULL,
1340 `NETWORK_NAME` varchar(80) DEFAULT NULL,
1341 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
1342 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
1343 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
1344 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
1345 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
1346 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
1347 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
1348 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
1349 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
1350 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
1351 `REQUEST_URL` varchar(500) DEFAULT NULL,
1352 PRIMARY KEY (`REQUEST_ID`),
1353 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d72h` (`CLIENT_REQUEST_ID`)
1354 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1356 CREATE TABLE `site_status` (
1357 `SITE_NAME` varchar(255) NOT NULL,
1358 `STATUS` bit(1) DEFAULT NULL,
1359 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1360 PRIMARY KEY (`SITE_NAME`)
1361 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1363 CREATE TABLE `watchdog_distributionid_status` (
1364 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1365 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1366 `LOCK_VERSION` int NOT NULL,
1367 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1368 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1369 PRIMARY KEY (`DISTRIBUTION_ID`)
1370 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1372 CREATE TABLE `watchdog_per_component_distribution_status` (
1373 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1374 `COMPONENT_NAME` varchar(45) NOT NULL,
1375 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
1376 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1377 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1378 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
1379 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1380 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1382 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
1383 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1384 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1385 `DISTRIBUTION_NOTIFICATION` LONGTEXT NULL,
1386 `CONSUMER_ID` varchar(200) NULL,
1387 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1388 `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1389 PRIMARY KEY (`DISTRIBUTION_ID`,`SERVICE_MODEL_VERSION_ID`)
1390 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1392 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
1393 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1394 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1395 `REQUEST_ID` varchar(45) NOT NULL,
1396 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
1397 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
1398 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
1399 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
1400 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1401 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1402 `VNF_OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1403 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
1404 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1406 CREATE TABLE `activate_operational_env_per_distributionid_status` (
1407 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1408 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1409 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
1410 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1411 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1412 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1413 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1414 `REQUEST_ID` varchar(45) NOT NULL,
1415 PRIMARY KEY (`DISTRIBUTION_ID`),
1416 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
1417 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
1418 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1420 create table operation_status (
1421 SERVICE_ID varchar(255) not null,
1422 OPERATION_ID varchar(255) not null,
1423 SERVICE_NAME varchar(255),
1424 OPERATION_TYPE varchar(255),
1425 USER_ID varchar(255),
1426 RESULT varchar(255),
1427 OPERATION_CONTENT varchar(255),
1428 PROGRESS varchar(255),
1429 REASON varchar(255),
1430 OPERATE_AT datetime NOT NULL,
1431 FINISHED_AT datetime NOT NULL,
1432 primary key (SERVICE_ID,OPERATION_ID)
1433 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1435 create table resource_operation_status (
1436 SERVICE_ID varchar(255) not null,
1437 OPERATION_ID varchar(255) not null,
1438 RESOURCE_TEMPLATE_UUID varchar(255) not null,
1439 OPER_TYPE varchar(255),
1440 RESOURCE_INSTANCE_ID varchar(255),
1441 JOB_ID varchar(255),
1442 STATUS varchar(255),
1443 PROGRESS varchar(255),
1444 ERROR_CODE varchar(255) ,
1445 STATUS_DESCRIPOTION varchar(255) ,
1446 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
1447 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1449 create table if not exists model_recipe (
1450 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1452 `ACTION` VARCHAR(40),
1453 `SCHEMA_VERSION` VARCHAR(40),
1454 `DESCRIPTION` VARCHAR(40),
1455 `ORCHESTRATION_URI` VARCHAR(20),
1456 `MODEL_PARAM_XSD` VARCHAR(20),
1457 `RECIPE_TIMEOUT` INT(11),
1458 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1460 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
1461 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1463 create table if not exists model (
1464 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1465 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
1466 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
1467 `MODEL_INVARIANT_ID` VARCHAR(40),
1468 `MODEL_NAME` VARCHAR(40),
1469 `MODEL_TYPE` VARCHAR(20),
1470 `MODEL_VERSION` VARCHAR(20),
1471 `MODEL_VERSION_ID` VARCHAR(40),
1472 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1475 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
1476 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1477 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;