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 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1118 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1119 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1120 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1122 UNIQUE KEY `UK_vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`,`SERVICE_MODEL_UUID`),
1123 KEY `fk_vnf_resource_customization__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
1124 KEY `fk_vnf_resource_customization_to_service` (`SERVICE_MODEL_UUID`),
1125 KEY `vnf_resource_customization_mod_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
1126 CONSTRAINT `fk_vnf_resource_customization__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1127 CONSTRAINT `fk_vnf_resource_customization_to_service` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1128 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1129 /*!40101 SET character_set_client = @saved_cs_client */;
1132 -- Table structure for table `vnfc_customization`
1135 DROP TABLE IF EXISTS `vnfc_customization`;
1136 /*!40101 SET @saved_cs_client = @@character_set_client */;
1137 /*!40101 SET character_set_client = utf8 */;
1138 CREATE TABLE `vnfc_customization` (
1139 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1140 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1141 `MODEL_UUID` varchar(200) NOT NULL,
1142 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
1143 `MODEL_VERSION` varchar(20) NOT NULL,
1144 `MODEL_NAME` varchar(200) NOT NULL,
1145 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
1146 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1147 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1148 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`)
1149 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1150 /*!40101 SET character_set_client = @saved_cs_client */;
1153 -- Table structure for table `vnfc_instance_group_customization`
1156 DROP TABLE IF EXISTS `vnfc_instance_group_customization`;
1157 /*!40101 SET @saved_cs_client = @@character_set_client */;
1158 /*!40101 SET character_set_client = utf8 */;
1159 CREATE TABLE `vnfc_instance_group_customization` (
1160 `ID` int(13) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1161 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) NOT NULL,
1162 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
1163 `FUNCTION` varchar(200) DEFAULT NULL,
1164 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1165 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1166 KEY `fk_vnfc_instance_group_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
1167 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,
1168 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
1169 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1170 set foreign_key_checks=1;
1172 CREATE TABLE IF NOT EXISTS `pnf_resource` (
1173 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
1174 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1175 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1176 `MODEL_UUID` varchar(200) NOT NULL,
1177 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1178 `MODEL_VERSION` varchar(20) NOT NULL,
1179 `MODEL_NAME` varchar(200) DEFAULT NULL,
1180 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1181 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1182 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1183 PRIMARY KEY (`MODEL_UUID`)
1184 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1186 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
1187 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1188 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1189 `NF_TYPE` varchar(200) DEFAULT NULL,
1190 `NF_ROLE` varchar(200) DEFAULT NULL,
1191 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1192 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1193 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1194 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1195 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1196 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
1197 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
1198 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
1199 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1200 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
1201 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
1202 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1203 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1205 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
1206 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1207 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1208 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
1209 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
1211 --------START Request DB SCHEMA --------
1212 CREATE DATABASE requestdb;
1216 CREATE TABLE `active_requests` (
1217 `REQUEST_ID` varchar(45) NOT NULL,
1218 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1219 `SERVICE_INSTANCE_ID` varchar(50) NOT NULL,
1220 `SUBSCRIBER_NAME` varchar(200) DEFAULT NULL,
1221 `REQUEST_URI` varchar(255) DEFAULT NULL,
1222 `SERVICE_TYPE` varchar(65) NOT NULL,
1223 `REQUEST_ACTION` varchar(45) NOT NULL,
1224 `NOTIFICATION_URL` varchar(255) DEFAULT NULL,
1225 `REQUEST_ID_IN_PROGRESS` varchar(45) DEFAULT NULL,
1226 `START_TIME` datetime DEFAULT NULL,
1227 `MODIFY_TIME` datetime DEFAULT NULL,
1228 `COMPLETION_TIME` datetime DEFAULT NULL,
1229 `RESPONSE_CODE` varchar(20) DEFAULT NULL,
1230 `RESPONSE_BODY` longtext,
1231 `STATUS` varchar(25) DEFAULT NULL,
1232 `SERVICE_REQUEST_TIMEOUT` datetime DEFAULT NULL,
1233 `FINAL_ERROR_CODE` varchar(20) DEFAULT NULL,
1234 `FINAL_ERROR_MESSAGE` varchar(2000) DEFAULT NULL,
1235 `ORDER_NUMBER` varchar(45) DEFAULT NULL,
1236 `SOURCE` varchar(20) DEFAULT NULL,
1237 `RESPONSE_STATUS` varchar(25) DEFAULT NULL,
1238 `ORDER_VERSION` varchar(20) DEFAULT NULL,
1239 `LAST_MODIFIED_BY` varchar(20) DEFAULT NULL,
1240 `MOCARS_TICKET_NUM` varchar(200) DEFAULT NULL,
1241 `REQUEST_BODY` longtext,
1242 `REQUEST_SUB_ACTION` varchar(45) DEFAULT NULL,
1243 `SDNC_CALLBACK_BPEL_URL` varchar(255) DEFAULT NULL,
1244 `FEATURE_TYPE` varchar(255) DEFAULT NULL,
1245 `FEATURE_INSTANCE_ID` varchar(255) DEFAULT NULL,
1246 `REQUEST_TYPE` varchar(255) DEFAULT NULL,
1247 `INTERIM_COMPLETION_TIME` datetime DEFAULT NULL,
1248 `INTERIM_STAGE_COMPLETION` int(11) DEFAULT NULL,
1249 `SERVICE_NAME_VERSION_ID` varchar(50) DEFAULT NULL,
1250 `GLOBAL_SUBSCRIBER_ID` varchar(255) DEFAULT NULL,
1251 `SERVICE_ID` varchar(50) DEFAULT NULL,
1252 `SERVICE_VERSION` varchar(10) DEFAULT NULL,
1253 `CORRELATOR` varchar(50) DEFAULT NULL,
1254 PRIMARY KEY (`REQUEST_ID`),
1255 UNIQUE KEY `UK_f0hdk7xbw5mb2trnxx0fvlh3x` (`CLIENT_REQUEST_ID`)
1256 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1258 CREATE TABLE `infra_active_requests` (
1259 `REQUEST_ID` varchar(45) NOT NULL,
1260 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1261 `ACTION` varchar(45) DEFAULT NULL,
1262 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
1263 `STATUS_MESSAGE` longtext DEFAULT NULL,
1264 `PROGRESS` bigint(20) DEFAULT NULL,
1265 `START_TIME` datetime DEFAULT NULL,
1266 `END_TIME` datetime DEFAULT NULL,
1267 `SOURCE` varchar(45) DEFAULT NULL,
1268 `VNF_ID` varchar(45) DEFAULT NULL,
1269 `VNF_NAME` varchar(80) DEFAULT NULL,
1270 `VNF_TYPE` varchar(200) DEFAULT NULL,
1271 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1272 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
1273 `TENANT_ID` varchar(45) DEFAULT NULL,
1274 `PROV_STATUS` varchar(20) DEFAULT NULL,
1275 `VNF_PARAMS` longtext,
1276 `VNF_OUTPUTS` longtext,
1277 `REQUEST_BODY` longtext,
1278 `RESPONSE_BODY` longtext,
1279 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
1280 `MODIFY_TIME` datetime DEFAULT NULL,
1281 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
1282 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
1283 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
1284 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
1285 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
1286 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
1287 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
1288 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
1289 `CALLBACK_URL` varchar(200) DEFAULT NULL,
1290 `CORRELATOR` varchar(80) DEFAULT NULL,
1291 `NETWORK_ID` varchar(45) DEFAULT NULL,
1292 `NETWORK_NAME` varchar(80) DEFAULT NULL,
1293 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
1294 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
1295 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
1296 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
1297 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
1298 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
1299 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
1300 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
1301 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
1302 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
1303 `REQUEST_URL` varchar(500) DEFAULT NULL,
1304 PRIMARY KEY (`REQUEST_ID`),
1305 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
1306 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1308 CREATE TABLE `archived_infra_requests` (
1309 `REQUEST_ID` varchar(45) NOT NULL,
1310 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
1311 `ACTION` varchar(45) DEFAULT NULL,
1312 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
1313 `STATUS_MESSAGE` longtext DEFAULT NULL,
1314 `PROGRESS` bigint(20) DEFAULT NULL,
1315 `START_TIME` datetime DEFAULT NULL,
1316 `END_TIME` datetime DEFAULT NULL,
1317 `SOURCE` varchar(45) DEFAULT NULL,
1318 `VNF_ID` varchar(45) DEFAULT NULL,
1319 `VNF_NAME` varchar(80) DEFAULT NULL,
1320 `VNF_TYPE` varchar(200) DEFAULT NULL,
1321 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1322 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
1323 `TENANT_ID` varchar(45) DEFAULT NULL,
1324 `PROV_STATUS` varchar(20) DEFAULT NULL,
1325 `VNF_PARAMS` longtext,
1326 `VNF_OUTPUTS` longtext,
1327 `REQUEST_BODY` longtext,
1328 `RESPONSE_BODY` longtext,
1329 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
1330 `MODIFY_TIME` datetime DEFAULT NULL,
1331 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
1332 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
1333 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
1334 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
1335 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
1336 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
1337 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
1338 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
1339 `CALLBACK_URL` varchar(200) DEFAULT NULL,
1340 `CORRELATOR` varchar(80) DEFAULT NULL,
1341 `NETWORK_ID` varchar(45) DEFAULT NULL,
1342 `NETWORK_NAME` varchar(80) DEFAULT NULL,
1343 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
1344 `REQUEST_SCOPE` varchar(20) NOT NULL DEFAULT 'unknown',
1345 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
1346 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
1347 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
1348 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
1349 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
1350 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
1351 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
1352 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
1353 `REQUEST_URL` varchar(500) DEFAULT NULL,
1354 PRIMARY KEY (`REQUEST_ID`),
1355 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d72h` (`CLIENT_REQUEST_ID`)
1356 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1358 CREATE TABLE `site_status` (
1359 `SITE_NAME` varchar(255) NOT NULL,
1360 `STATUS` bit(1) DEFAULT NULL,
1361 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1362 PRIMARY KEY (`SITE_NAME`)
1363 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1365 CREATE TABLE `watchdog_distributionid_status` (
1366 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1367 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1368 `LOCK_VERSION` int NOT NULL,
1369 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1370 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1371 PRIMARY KEY (`DISTRIBUTION_ID`)
1372 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1374 CREATE TABLE `watchdog_per_component_distribution_status` (
1375 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1376 `COMPONENT_NAME` varchar(45) NOT NULL,
1377 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
1378 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1379 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1380 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
1381 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1382 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1384 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
1385 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1386 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1387 `DISTRIBUTION_NOTIFICATION` LONGTEXT NULL,
1388 `CONSUMER_ID` varchar(200) NULL,
1389 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1390 `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1391 PRIMARY KEY (`DISTRIBUTION_ID`,`SERVICE_MODEL_VERSION_ID`)
1392 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1394 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
1395 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1396 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1397 `REQUEST_ID` varchar(45) NOT NULL,
1398 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
1399 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
1400 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
1401 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
1402 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1403 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1404 `VNF_OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1405 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
1406 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1408 CREATE TABLE `activate_operational_env_per_distributionid_status` (
1409 `DISTRIBUTION_ID` varchar(45) NOT NULL,
1410 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
1411 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
1412 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1413 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1414 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
1415 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
1416 `REQUEST_ID` varchar(45) NOT NULL,
1417 PRIMARY KEY (`DISTRIBUTION_ID`),
1418 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
1419 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
1420 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1422 create table operation_status (
1423 SERVICE_ID varchar(255) not null,
1424 OPERATION_ID varchar(255) not null,
1425 SERVICE_NAME varchar(255),
1426 OPERATION_TYPE varchar(255),
1427 USER_ID varchar(255),
1428 RESULT varchar(255),
1429 OPERATION_CONTENT varchar(255),
1430 PROGRESS varchar(255),
1431 REASON varchar(255),
1432 OPERATE_AT datetime NOT NULL,
1433 FINISHED_AT datetime NOT NULL,
1434 primary key (SERVICE_ID,OPERATION_ID)
1435 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1437 create table resource_operation_status (
1438 SERVICE_ID varchar(255) not null,
1439 OPERATION_ID varchar(255) not null,
1440 RESOURCE_TEMPLATE_UUID varchar(255) not null,
1441 OPER_TYPE varchar(255),
1442 RESOURCE_INSTANCE_ID varchar(255),
1443 JOB_ID varchar(255),
1444 STATUS varchar(255),
1445 PROGRESS varchar(255),
1446 ERROR_CODE varchar(255) ,
1447 STATUS_DESCRIPOTION varchar(255) ,
1448 primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
1449 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1451 create table if not exists model_recipe (
1452 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1454 `ACTION` VARCHAR(40),
1455 `SCHEMA_VERSION` VARCHAR(40),
1456 `DESCRIPTION` VARCHAR(40),
1457 `ORCHESTRATION_URI` VARCHAR(20),
1458 `MODEL_PARAM_XSD` VARCHAR(20),
1459 `RECIPE_TIMEOUT` INT(11),
1460 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1462 CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
1463 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1465 create table if not exists model (
1466 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1467 `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
1468 `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
1469 `MODEL_INVARIANT_ID` VARCHAR(40),
1470 `MODEL_NAME` VARCHAR(40),
1471 `MODEL_TYPE` VARCHAR(20),
1472 `MODEL_VERSION` VARCHAR(20),
1473 `MODEL_VERSION_ID` VARCHAR(40),
1474 `CREATION_TIMESTAMP` datetime not null default current_timestamp,
1477 CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
1478 FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
1479 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;