1 set foreign_key_checks=0;
2 DROP TABLE IF EXISTS `allotted_resource`;
3 /*!40101 SET @saved_cs_client = @@character_set_client */;
4 /*!40101 SET character_set_client = utf8 */;
5 CREATE TABLE `allotted_resource` (
6 `MODEL_UUID` varchar(200) NOT NULL,
7 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
8 `MODEL_VERSION` varchar(20) NOT NULL,
9 `MODEL_NAME` varchar(200) NOT NULL,
10 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
11 `SUBCATEGORY` varchar(200) DEFAULT NULL,
12 `DESCRIPTION` varchar(1200) DEFAULT NULL,
13 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
14 PRIMARY KEY (`MODEL_UUID`)
15 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16 /*!40101 SET character_set_client = @saved_cs_client */;
19 -- Table structure for table `allotted_resource_customization`
22 DROP TABLE IF EXISTS `allotted_resource_customization`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `allotted_resource_customization` (
26 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
27 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
28 `PROVIDING_SERVICE_MODEL_UUID` varchar(200) DEFAULT NULL,
29 `PROVIDING_SERVICE_MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
30 `PROVIDING_SERVICE_MODEL_NAME` varchar(200) DEFAULT NULL,
31 `TARGET_NETWORK_ROLE` varchar(200) DEFAULT NULL,
32 `NF_TYPE` varchar(200) DEFAULT NULL,
33 `NF_ROLE` varchar(200) DEFAULT NULL,
34 `NF_FUNCTION` varchar(200) DEFAULT NULL,
35 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
36 `MIN_INSTANCES` int(11) DEFAULT NULL,
37 `MAX_INSTANCES` int(11) DEFAULT NULL,
38 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
39 `AR_MODEL_UUID` varchar(200) NOT NULL,
40 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
41 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
42 KEY `fk_allotted_resource_customization__allotted_resource1_idx` (`AR_MODEL_UUID`),
43 CONSTRAINT `fk_allotted_resource_customization__allotted_resource1` FOREIGN KEY (`AR_MODEL_UUID`) REFERENCES `allotted_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
44 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45 /*!40101 SET character_set_client = @saved_cs_client */;
48 -- Table structure for table `allotted_resource_customization_to_service`
51 DROP TABLE IF EXISTS `allotted_resource_customization_to_service`;
52 /*!40101 SET @saved_cs_client = @@character_set_client */;
53 /*!40101 SET character_set_client = utf8 */;
54 CREATE TABLE `allotted_resource_customization_to_service` (
55 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
56 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
57 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
58 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
59 CONSTRAINT `allotted_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
60 CONSTRAINT `allotted_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `allotted_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
61 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62 /*!40101 SET character_set_client = @saved_cs_client */;
65 -- Table structure for table `ar_recipe`
68 DROP TABLE IF EXISTS `ar_recipe`;
69 /*!40101 SET @saved_cs_client = @@character_set_client */;
70 /*!40101 SET character_set_client = utf8 */;
71 CREATE TABLE `ar_recipe` (
72 `ID` int(11) NOT NULL AUTO_INCREMENT,
73 `MODEL_NAME` varchar(200) NOT NULL,
74 `ACTION` varchar(200) NOT NULL,
75 `VERSION_STR` varchar(200) NOT NULL,
76 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
77 `DESCRIPTION` varchar(200) DEFAULT NULL,
78 `ORCHESTRATION_URI` varchar(200) NOT NULL,
79 `AR_PARAM_XSD` varchar(200) DEFAULT NULL,
80 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
81 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
83 UNIQUE KEY `uk_ar_recipe` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
84 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85 /*!40101 SET character_set_client = @saved_cs_client */;
88 -- Table structure for table `building_block_detail`
91 DROP TABLE IF EXISTS `building_block_detail`;
92 /*!40101 SET @saved_cs_client = @@character_set_client */;
93 /*!40101 SET character_set_client = utf8 */;
94 CREATE TABLE `building_block_detail` (
95 `id` int(11) NOT NULL AUTO_INCREMENT,
96 `BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
97 `RESOURCE_TYPE` varchar(25) NOT NULL,
98 `TARGET_ACTION` varchar(25) NOT NULL,
100 UNIQUE KEY `UK_building_block_name` (`BUILDING_BLOCK_NAME`)
101 ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
102 /*!40101 SET character_set_client = @saved_cs_client */;
105 -- Table structure for table `cloud_sites`
108 DROP TABLE IF EXISTS `cloud_sites`;
109 /*!40101 SET @saved_cs_client = @@character_set_client */;
110 /*!40101 SET character_set_client = utf8 */;
111 CREATE TABLE `cloud_sites` (
112 `ID` varchar(50) NOT NULL,
113 `REGION_ID` varchar(11) DEFAULT NULL,
114 `IDENTITY_SERVICE_ID` varchar(50) DEFAULT NULL,
115 `CLOUD_VERSION` varchar(20) DEFAULT NULL,
116 `CLLI` varchar(11) DEFAULT NULL,
117 `CLOUDIFY_ID` varchar(50) DEFAULT NULL,
118 `PLATFORM` varchar(50) DEFAULT NULL,
119 `ORCHESTRATOR` varchar(50) DEFAULT NULL,
120 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
121 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
122 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
123 `SUPPORT_FABRIC` bit(1) NOT NULL DEFAULT 1,
124 `CLOUD_OWNER` varchar(225) NOT NULL,
126 KEY `FK_cloud_sites_identity_services` (`IDENTITY_SERVICE_ID`),
127 CONSTRAINT `FK_cloud_sites_identity_services` FOREIGN KEY (`IDENTITY_SERVICE_ID`) REFERENCES `identity_services` (`ID`)
128 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
129 /*!40101 SET character_set_client = @saved_cs_client */;
132 -- Table structure for table `cloudify_managers`
135 DROP TABLE IF EXISTS `cloudify_managers`;
136 /*!40101 SET @saved_cs_client = @@character_set_client */;
137 /*!40101 SET character_set_client = utf8 */;
138 CREATE TABLE `cloudify_managers` (
139 `ID` varchar(50) NOT NULL,
140 `CLOUDIFY_URL` varchar(200) DEFAULT NULL,
141 `USERNAME` varchar(255) DEFAULT NULL,
142 `PASSWORD` varchar(255) DEFAULT NULL,
143 `VERSION` varchar(20) DEFAULT NULL,
144 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
145 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
146 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
148 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
149 /*!40101 SET character_set_client = @saved_cs_client */;
152 -- Table structure for table `collection_network_resource_customization`
155 DROP TABLE IF EXISTS `collection_network_resource_customization`;
156 /*!40101 SET @saved_cs_client = @@character_set_client */;
157 /*!40101 SET character_set_client = utf8 */;
158 CREATE TABLE `collection_network_resource_customization` (
159 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
160 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
161 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
162 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
163 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
164 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
165 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
166 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
167 `INSTANCE_GROUP_MODEL_UUID` varchar(200) DEFAULT NULL,
168 `CRC_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
169 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`,`CRC_MODEL_CUSTOMIZATION_UUID`),
170 KEY `fk_collection_net_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
171 KEY `fk_collection_net_resource_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
172 KEY `fk_col_net_res_customization__collection_res_customization_idx` (`CRC_MODEL_CUSTOMIZATION_UUID`),
173 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,
174 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,
175 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
176 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
177 /*!40101 SET character_set_client = @saved_cs_client */;
180 -- Table structure for table `collection_resource`
183 DROP TABLE IF EXISTS `collection_resource`;
184 /*!40101 SET @saved_cs_client = @@character_set_client */;
185 /*!40101 SET character_set_client = utf8 */;
186 CREATE TABLE `collection_resource` (
187 `MODEL_UUID` varchar(200) NOT NULL,
188 `MODEL_NAME` varchar(200) NOT NULL,
189 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
190 `MODEL_VERSION` varchar(20) NOT NULL,
191 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
192 `DESCRIPTION` varchar(1200) DEFAULT NULL,
193 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
194 PRIMARY KEY (`MODEL_UUID`)
195 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196 /*!40101 SET character_set_client = @saved_cs_client */;
199 -- Table structure for table `collection_resource_customization`
202 DROP TABLE IF EXISTS `collection_resource_customization`;
203 /*!40101 SET @saved_cs_client = @@character_set_client */;
204 /*!40101 SET character_set_client = utf8 */;
205 CREATE TABLE `collection_resource_customization` (
206 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
207 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
208 `role` varchar(200) DEFAULT NULL,
209 `object_type` varchar(200) NOT NULL,
210 `function` varchar(200) DEFAULT NULL,
211 `collection_resource_type` varchar(200) DEFAULT NULL,
212 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
213 `CR_MODEL_UUID` varchar(200) NOT NULL,
214 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
215 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`),
216 CONSTRAINT `collection_resource_customization_ibfk_1` FOREIGN KEY (`CR_MODEL_UUID`) REFERENCES `collection_resource` (`MODEL_UUID`) ON DELETE CASCADE
217 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
218 /*!40101 SET character_set_client = @saved_cs_client */;
221 -- Table structure for table `collection_resource_customization_to_service`
224 DROP TABLE IF EXISTS `collection_resource_customization_to_service`;
225 /*!40101 SET @saved_cs_client = @@character_set_client */;
226 /*!40101 SET character_set_client = utf8 */;
227 CREATE TABLE `collection_resource_customization_to_service` (
228 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
229 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
230 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
231 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
232 CONSTRAINT `collection_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
233 CONSTRAINT `collection_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `collection_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
234 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
235 /*!40101 SET character_set_client = @saved_cs_client */;
238 -- Table structure for table `collection_resource_instance_group_customization`
241 DROP TABLE IF EXISTS `collection_resource_instance_group_customization`;
242 /*!40101 SET @saved_cs_client = @@character_set_client */;
243 /*!40101 SET character_set_client = utf8 */;
244 CREATE TABLE `collection_resource_instance_group_customization` (
245 `COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID` varchar(200) NOT NULL,
246 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
247 `FUNCTION` varchar(200) DEFAULT NULL,
248 `DESCRIPTION` varchar(1200) DEFAULT NULL,
249 `SUBINTERFACE_NETWORK_QUANTITY` int(11) DEFAULT NULL,
250 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
251 PRIMARY KEY (`COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID`,`INSTANCE_GROUP_MODEL_UUID`),
252 KEY `fk_collection_resource_instance_group_customization__instan_idx` (`INSTANCE_GROUP_MODEL_UUID`),
253 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,
254 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
255 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
256 /*!40101 SET character_set_client = @saved_cs_client */;
259 -- Table structure for table `configuration`
262 DROP TABLE IF EXISTS `configuration`;
263 /*!40101 SET @saved_cs_client = @@character_set_client */;
264 /*!40101 SET character_set_client = utf8 */;
265 CREATE TABLE `configuration` (
266 `MODEL_UUID` varchar(200) NOT NULL,
267 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
268 `MODEL_VERSION` varchar(20) NOT NULL,
269 `MODEL_NAME` varchar(200) NOT NULL,
270 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
271 `DESCRIPTION` varchar(1200) DEFAULT NULL,
272 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
273 PRIMARY KEY (`MODEL_UUID`)
274 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
275 /*!40101 SET character_set_client = @saved_cs_client */;
278 -- Table structure for table `configuration_customization`
281 DROP TABLE IF EXISTS `configuration_customization`;
282 /*!40101 SET @saved_cs_client = @@character_set_client */;
283 /*!40101 SET character_set_client = utf8 */;
284 CREATE TABLE `configuration_customization` (
285 `ID` int(11) NOT NULL AUTO_INCREMENT,
286 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
287 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
288 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
289 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
290 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
291 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
292 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
293 `SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
294 `CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
295 `SERVICE_MODEL_UUID` varchar(200),
297 KEY `fk_configuration_customization__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
298 KEY `fk_configuration_customization__service_idx` (`SERVICE_MODEL_UUID`),
299 UNIQUE KEY `uk_configuration_customization` (`MODEL_CUSTOMIZATION_UUID` ASC, `SERVICE_MODEL_UUID` ASC),
300 CONSTRAINT `fk_configuration_customization__configuration1` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
301 REFERENCES `configuration` (`MODEL_UUID`)
302 ON DELETE CASCADE ON UPDATE CASCADE,
303 CONSTRAINT `fk_configuration_customization__service1` FOREIGN KEY (`SERVICE_MODEL_UUID`)
304 REFERENCES `service` (`MODEL_UUID`)
305 ON DELETE CASCADE ON UPDATE CASCADE
306 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
307 /*!40101 SET character_set_client = @saved_cs_client */;
310 -- Table structure for table `controller_selection_reference`
313 DROP TABLE IF EXISTS `controller_selection_reference`;
314 /*!40101 SET @saved_cs_client = @@character_set_client */;
315 /*!40101 SET character_set_client = utf8 */;
316 CREATE TABLE `controller_selection_reference` (
317 `VNF_TYPE` varchar(50) NOT NULL,
318 `CONTROLLER_NAME` varchar(100) NOT NULL,
319 `ACTION_CATEGORY` varchar(15) NOT NULL,
320 PRIMARY KEY (`VNF_TYPE`,`CONTROLLER_NAME`,`ACTION_CATEGORY`)
321 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
322 /*!40101 SET character_set_client = @saved_cs_client */;
325 -- Table structure for table `cvnfc_configuration_customization`
328 DROP TABLE IF EXISTS `cvnfc_configuration_customization`;
329 /*!40101 SET @saved_cs_client = @@character_set_client */;
330 /*!40101 SET character_set_client = utf8 */;
331 CREATE TABLE `cvnfc_configuration_customization` (
332 `ID` int(11) NOT NULL AUTO_INCREMENT,
333 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
334 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
335 `CONFIGURATION_TYPE` varchar(200) DEFAULT NULL,
336 `CONFIGURATION_ROLE` varchar(200) DEFAULT NULL,
337 `CONFIGURATION_FUNCTION` varchar(200) DEFAULT NULL,
338 `POLICY_NAME` varchar(200) DEFAULT NULL,
339 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
340 `CONFIGURATION_MODEL_UUID` varchar(200) NOT NULL,
341 `CVNFC_CUSTOMIZATION_ID` int(11) DEFAULT NULL,
343 KEY `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID`),
344 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
345 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
346 /*!40101 SET character_set_client = @saved_cs_client */;
349 -- Table structure for table `cvnfc_customization`
352 DROP TABLE IF EXISTS `cvnfc_customization`;
353 /*!40101 SET @saved_cs_client = @@character_set_client */;
354 /*!40101 SET character_set_client = utf8 */;
355 CREATE TABLE `cvnfc_customization` (
356 `ID` int(11) NOT NULL AUTO_INCREMENT,
357 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
358 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
359 `MODEL_UUID` varchar(200) NOT NULL,
360 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
361 `MODEL_VERSION` varchar(20) NOT NULL,
362 `MODEL_NAME` varchar(200) NOT NULL,
363 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
364 `DESCRIPTION` varchar(1200) DEFAULT NULL,
365 `NFC_FUNCTION` varchar(200) DEFAULT NULL,
366 `NFC_NAMING_CODE` varchar(200) DEFAULT NULL,
367 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
368 `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` varchar(200) DEFAULT NULL,
369 `VF_MODULE_CUSTOMIZATION_ID` int(13) DEFAULT NULL,
371 KEY `fk_cvnfc_customization__vnfc_customization1_idx` (`VNFC_CUST_MODEL_CUSTOMIZATION_UUID`),
372 KEY `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID`),
373 KEY `fk_cvnfc_customization_to_vf_module_resource_customization` (`VF_MODULE_CUSTOMIZATION_ID`),
374 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,
375 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
376 ) ENGINE=InnoDB AUTO_INCREMENT=20655 DEFAULT CHARSET=latin1;
377 /*!40101 SET character_set_client = @saved_cs_client */;
380 -- Table structure for table `external_service_to_internal_model_mapping`
383 DROP TABLE IF EXISTS `external_service_to_internal_model_mapping`;
384 /*!40101 SET @saved_cs_client = @@character_set_client */;
385 /*!40101 SET character_set_client = utf8 */;
386 CREATE TABLE `external_service_to_internal_model_mapping` (
387 `id` int(11) NOT NULL AUTO_INCREMENT,
388 `SERVICE_NAME` varchar(200) NOT NULL,
389 `PRODUCT_FLAVOR` varchar(200) DEFAULT NULL,
390 `SUBSCRIPTION_SERVICE_TYPE` varchar(200) NOT NULL,
391 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
393 UNIQUE KEY `UK_external_service_to_internal_model_mapping` (`SERVICE_NAME`,`PRODUCT_FLAVOR`,`SERVICE_MODEL_UUID`)
394 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
395 /*!40101 SET character_set_client = @saved_cs_client */;
398 -- Table structure for table `flyway_schema_history`
401 DROP TABLE IF EXISTS `flyway_schema_history`;
402 /*!40101 SET @saved_cs_client = @@character_set_client */;
403 /*!40101 SET character_set_client = utf8 */;
404 CREATE TABLE `flyway_schema_history` (
405 `installed_rank` int(11) NOT NULL,
406 `version` varchar(50) DEFAULT NULL,
407 `description` varchar(200) NOT NULL,
408 `type` varchar(20) NOT NULL,
409 `script` varchar(1000) NOT NULL,
410 `checksum` int(11) DEFAULT NULL,
411 `installed_by` varchar(100) NOT NULL,
412 `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
413 `execution_time` int(11) NOT NULL,
414 `success` tinyint(1) NOT NULL,
415 PRIMARY KEY (`installed_rank`),
416 KEY `flyway_schema_history_s_idx` (`success`)
417 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
418 /*!40101 SET character_set_client = @saved_cs_client */;
421 -- Table structure for table `heat_environment`
424 DROP TABLE IF EXISTS `heat_environment`;
425 /*!40101 SET @saved_cs_client = @@character_set_client */;
426 /*!40101 SET character_set_client = utf8 */;
427 CREATE TABLE `heat_environment` (
428 `ARTIFACT_UUID` varchar(200) NOT NULL,
429 `NAME` varchar(100) NOT NULL,
430 `VERSION` varchar(20) NOT NULL,
431 `DESCRIPTION` varchar(1200) DEFAULT NULL,
432 `BODY` longtext NOT NULL,
433 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
434 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
435 PRIMARY KEY (`ARTIFACT_UUID`)
436 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
437 /*!40101 SET character_set_client = @saved_cs_client */;
440 -- Table structure for table `heat_files`
443 DROP TABLE IF EXISTS `heat_files`;
444 /*!40101 SET @saved_cs_client = @@character_set_client */;
445 /*!40101 SET character_set_client = utf8 */;
446 CREATE TABLE `heat_files` (
447 `ARTIFACT_UUID` varchar(200) NOT NULL,
448 `NAME` varchar(200) NOT NULL,
449 `VERSION` varchar(20) NOT NULL,
450 `DESCRIPTION` varchar(1200) DEFAULT NULL,
451 `BODY` longtext NOT NULL,
452 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
453 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
454 PRIMARY KEY (`ARTIFACT_UUID`)
455 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
456 /*!40101 SET character_set_client = @saved_cs_client */;
459 -- Table structure for table `heat_nested_template`
462 DROP TABLE IF EXISTS `heat_nested_template`;
463 /*!40101 SET @saved_cs_client = @@character_set_client */;
464 /*!40101 SET character_set_client = utf8 */;
465 CREATE TABLE `heat_nested_template` (
466 `PARENT_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
467 `CHILD_HEAT_TEMPLATE_UUID` varchar(200) NOT NULL,
468 `PROVIDER_RESOURCE_FILE` varchar(100) DEFAULT NULL,
469 PRIMARY KEY (`PARENT_HEAT_TEMPLATE_UUID`,`CHILD_HEAT_TEMPLATE_UUID`),
470 KEY `fk_heat_nested_template__heat_template2_idx` (`CHILD_HEAT_TEMPLATE_UUID`),
471 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,
472 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
473 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
474 /*!40101 SET character_set_client = @saved_cs_client */;
477 -- Table structure for table `heat_template`
480 DROP TABLE IF EXISTS `heat_template`;
481 /*!40101 SET @saved_cs_client = @@character_set_client */;
482 /*!40101 SET character_set_client = utf8 */;
483 CREATE TABLE `heat_template` (
484 `ARTIFACT_UUID` varchar(200) NOT NULL,
485 `NAME` varchar(200) NOT NULL,
486 `VERSION` varchar(20) NOT NULL,
487 `DESCRIPTION` varchar(1200) DEFAULT NULL,
488 `BODY` longtext NOT NULL,
489 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
490 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
491 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
492 PRIMARY KEY (`ARTIFACT_UUID`)
493 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
494 /*!40101 SET character_set_client = @saved_cs_client */;
497 -- Table structure for table `heat_template_params`
500 DROP TABLE IF EXISTS `heat_template_params`;
501 /*!40101 SET @saved_cs_client = @@character_set_client */;
502 /*!40101 SET character_set_client = utf8 */;
503 CREATE TABLE `heat_template_params` (
504 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NOT NULL,
505 `PARAM_NAME` varchar(100) NOT NULL,
506 `IS_REQUIRED` bit(1) NOT NULL,
507 `PARAM_TYPE` varchar(20) DEFAULT NULL,
508 `PARAM_ALIAS` varchar(45) DEFAULT NULL,
509 PRIMARY KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`,`PARAM_NAME`),
510 CONSTRAINT `fk_heat_template_params__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
511 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
512 /*!40101 SET character_set_client = @saved_cs_client */;
515 -- Table structure for table `identity_services`
518 DROP TABLE IF EXISTS `identity_services`;
519 /*!40101 SET @saved_cs_client = @@character_set_client */;
520 /*!40101 SET character_set_client = utf8 */;
521 CREATE TABLE `identity_services` (
522 `ID` varchar(50) NOT NULL,
523 `IDENTITY_URL` varchar(200) DEFAULT NULL,
524 `MSO_ID` varchar(255) DEFAULT NULL,
525 `MSO_PASS` varchar(255) DEFAULT NULL,
526 `ADMIN_TENANT` varchar(50) DEFAULT NULL,
527 `MEMBER_ROLE` varchar(50) DEFAULT NULL,
528 `TENANT_METADATA` tinyint(1) DEFAULT '0',
529 `IDENTITY_SERVER_TYPE` varchar(50) DEFAULT NULL,
530 `IDENTITY_AUTHENTICATION_TYPE` varchar(50) DEFAULT NULL,
531 `LAST_UPDATED_BY` varchar(120) DEFAULT NULL,
532 `CREATION_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
533 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
534 `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL,
535 `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL,
537 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
538 /*!40101 SET character_set_client = @saved_cs_client */;
541 -- Table structure for table `instance_group`
544 DROP TABLE IF EXISTS `instance_group`;
545 /*!40101 SET @saved_cs_client = @@character_set_client */;
546 /*!40101 SET character_set_client = utf8 */;
547 CREATE TABLE `instance_group` (
548 `MODEL_UUID` varchar(200) NOT NULL,
549 `MODEL_NAME` varchar(200) NOT NULL,
550 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
551 `MODEL_VERSION` varchar(20) NOT NULL,
552 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
553 `ROLE` varchar(200) NOT NULL,
554 `OBJECT_TYPE` varchar(200) NOT NULL,
555 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
556 `CR_MODEL_UUID` varchar(200) DEFAULT NULL,
557 `INSTANCE_GROUP_TYPE` varchar(200) NOT NULL,
558 PRIMARY KEY (`MODEL_UUID`),
559 KEY `CR_MODEL_UUID` (`CR_MODEL_UUID`)
560 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
561 /*!40101 SET character_set_client = @saved_cs_client */;
564 -- Table structure for table `model`
567 DROP TABLE IF EXISTS `model`;
568 /*!40101 SET @saved_cs_client = @@character_set_client */;
569 /*!40101 SET character_set_client = utf8 */;
570 CREATE TABLE `model` (
571 `ID` int(11) NOT NULL AUTO_INCREMENT,
572 `MODEL_CUSTOMIZATION_ID` varchar(40) DEFAULT NULL,
573 `MODEL_CUSTOMIZATION_NAME` varchar(40) DEFAULT NULL,
574 `MODEL_INVARIANT_ID` varchar(40) DEFAULT NULL,
575 `MODEL_NAME` varchar(40) DEFAULT NULL,
576 `MODEL_TYPE` varchar(20) DEFAULT NULL,
577 `MODEL_VERSION` varchar(20) DEFAULT NULL,
578 `MODEL_VERSION_ID` varchar(40) DEFAULT NULL,
579 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
580 `RECIPE` int(11) DEFAULT NULL,
582 UNIQUE KEY `uk1_model` (`MODEL_TYPE`,`MODEL_VERSION_ID`),
583 KEY `RECIPE` (`RECIPE`),
584 CONSTRAINT `model_ibfk_1` FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
585 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
586 /*!40101 SET character_set_client = @saved_cs_client */;
589 -- Table structure for table `model_recipe`
592 DROP TABLE IF EXISTS `model_recipe`;
593 /*!40101 SET @saved_cs_client = @@character_set_client */;
594 /*!40101 SET character_set_client = utf8 */;
595 CREATE TABLE `model_recipe` (
596 `ID` int(11) NOT NULL AUTO_INCREMENT,
597 `MODEL_ID` int(11) DEFAULT NULL,
598 `ACTION` varchar(40) DEFAULT NULL,
599 `SCHEMA_VERSION` varchar(40) DEFAULT NULL,
600 `DESCRIPTION` varchar(40) DEFAULT NULL,
601 `ORCHESTRATION_URI` varchar(20) DEFAULT NULL,
602 `MODEL_PARAM_XSD` varchar(20) DEFAULT NULL,
603 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
604 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
606 UNIQUE KEY `uk1_model_recipe` (`MODEL_ID`,`ACTION`)
607 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
608 /*!40101 SET character_set_client = @saved_cs_client */;
611 -- Table structure for table `network_recipe`
614 DROP TABLE IF EXISTS `network_recipe`;
615 /*!40101 SET @saved_cs_client = @@character_set_client */;
616 /*!40101 SET character_set_client = utf8 */;
617 CREATE TABLE `network_recipe` (
618 `id` int(11) NOT NULL AUTO_INCREMENT,
619 `MODEL_NAME` varchar(20) NOT NULL,
620 `ACTION` varchar(50) NOT NULL,
621 `DESCRIPTION` varchar(1200) DEFAULT NULL,
622 `ORCHESTRATION_URI` varchar(256) NOT NULL,
623 `NETWORK_PARAM_XSD` varchar(2048) DEFAULT NULL,
624 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
625 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
626 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
627 `VERSION_STR` varchar(20) NOT NULL,
628 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
629 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
631 UNIQUE KEY `UK_rl4f296i0p8lyokxveaiwkayi` (`MODEL_NAME`,`ACTION`,`VERSION_STR`)
632 ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
633 /*!40101 SET character_set_client = @saved_cs_client */;
636 -- Table structure for table `network_resource`
639 DROP TABLE IF EXISTS `network_resource`;
640 /*!40101 SET @saved_cs_client = @@character_set_client */;
641 /*!40101 SET character_set_client = utf8 */;
642 CREATE TABLE `network_resource` (
643 `MODEL_UUID` varchar(200) NOT NULL,
644 `MODEL_NAME` varchar(200) NOT NULL,
645 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
646 `DESCRIPTION` varchar(1200) DEFAULT NULL,
647 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) NULL,
648 `NEUTRON_NETWORK_TYPE` varchar(20) DEFAULT NULL,
649 `MODEL_VERSION` varchar(20) DEFAULT NULL,
650 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
651 `AIC_VERSION_MIN` varchar(20) NULL,
652 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
653 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
654 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
655 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
656 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
657 PRIMARY KEY (`MODEL_UUID`),
658 KEY `fk_network_resource__temp_network_heat_template_lookup1_idx` (`MODEL_NAME`),
659 KEY `fk_network_resource__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
660 CONSTRAINT `fk_network_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE NO ACTION ON UPDATE CASCADE,
661 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
662 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
663 /*!40101 SET character_set_client = @saved_cs_client */;
666 -- Table structure for table `network_resource_customization`
669 DROP TABLE IF EXISTS `network_resource_customization`;
670 /*!40101 SET @saved_cs_client = @@character_set_client */;
671 /*!40101 SET character_set_client = utf8 */;
672 CREATE TABLE `network_resource_customization` (
673 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
674 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
675 `NETWORK_TECHNOLOGY` varchar(45) DEFAULT NULL,
676 `NETWORK_TYPE` varchar(45) DEFAULT NULL,
677 `NETWORK_ROLE` varchar(200) DEFAULT NULL,
678 `NETWORK_SCOPE` varchar(45) DEFAULT NULL,
679 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
680 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
681 `NETWORK_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
682 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
683 KEY `fk_network_resource_customization__network_resource1_idx` (`NETWORK_RESOURCE_MODEL_UUID`),
684 CONSTRAINT `fk_network_resource_customization__network_resource1` FOREIGN KEY (`NETWORK_RESOURCE_MODEL_UUID`) REFERENCES `network_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
685 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
686 /*!40101 SET character_set_client = @saved_cs_client */;
689 -- Table structure for table `network_resource_customization_to_service`
692 DROP TABLE IF EXISTS `network_resource_customization_to_service`;
693 /*!40101 SET @saved_cs_client = @@character_set_client */;
694 /*!40101 SET character_set_client = utf8 */;
695 CREATE TABLE `network_resource_customization_to_service` (
696 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
697 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
698 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
699 KEY `RESOURCE_MODEL_CUSTOMIZATION_UUID` (`RESOURCE_MODEL_CUSTOMIZATION_UUID`),
700 CONSTRAINT `network_resource_customization_to_service_ibfk_1` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE,
701 CONSTRAINT `network_resource_customization_to_service_ibfk_2` FOREIGN KEY (`RESOURCE_MODEL_CUSTOMIZATION_UUID`) REFERENCES `network_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE
702 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
703 /*!40101 SET character_set_client = @saved_cs_client */;
706 -- Table structure for table `northbound_request_ref_lookup`
709 DROP TABLE IF EXISTS `northbound_request_ref_lookup`;
710 /*!40101 SET @saved_cs_client = @@character_set_client */;
711 /*!40101 SET character_set_client = utf8 */;
712 CREATE TABLE `northbound_request_ref_lookup` (
713 `id` int(11) NOT NULL AUTO_INCREMENT,
714 `REQUEST_SCOPE` varchar(200) NOT NULL,
715 `MACRO_ACTION` varchar(200) NOT NULL,
716 `ACTION` varchar(200) NOT NULL,
717 `IS_ALACARTE` tinyint(1) NOT NULL DEFAULT '0',
718 `MIN_API_VERSION` double NOT NULL,
719 `MAX_API_VERSION` double DEFAULT NULL,
720 `IS_TOPLEVELFLOW` tinyint(1) DEFAULT NULL,
721 `CLOUD_OWNER` varchar(200) NOT NULL,
723 UNIQUE KEY `UK_northbound_request_ref_lookup` (`MIN_API_VERSION`,`REQUEST_SCOPE`,`ACTION`,`IS_ALACARTE`,`MACRO_ACTION`,`CLOUD_OWNER`)
724 ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;
725 /*!40101 SET character_set_client = @saved_cs_client */;
728 -- Table structure for table `orchestration_flow_reference`
731 DROP TABLE IF EXISTS `orchestration_flow_reference`;
732 /*!40101 SET @saved_cs_client = @@character_set_client */;
733 /*!40101 SET character_set_client = utf8 */;
734 CREATE TABLE `orchestration_flow_reference` (
735 `id` int(11) NOT NULL AUTO_INCREMENT,
736 `COMPOSITE_ACTION` varchar(200) NOT NULL,
737 `SEQ_NO` int(11) NOT NULL,
738 `FLOW_NAME` varchar(200) NOT NULL,
739 `FLOW_VERSION` double NOT NULL,
740 `SCOPE` varchar(200) DEFAULT NULL,
741 `ACTION` varchar(200) DEFAULT NULL,
742 `NB_REQ_REF_LOOKUP_ID` int(11) NOT NULL,
744 UNIQUE KEY `UK_orchestration_flow_reference` (`COMPOSITE_ACTION`,`FLOW_NAME`,`SEQ_NO`,`NB_REQ_REF_LOOKUP_ID`),
745 KEY `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID`),
746 KEY `fk_orchestration_flow_reference__building_block_detail` (`FLOW_NAME`),
747 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
748 ) ENGINE=InnoDB AUTO_INCREMENT=398 DEFAULT CHARSET=latin1;
749 /*!40101 SET character_set_client = @saved_cs_client */;
752 -- Table structure for table `orchestration_status_state_transition_directive`
755 DROP TABLE IF EXISTS `orchestration_status_state_transition_directive`;
756 /*!40101 SET @saved_cs_client = @@character_set_client */;
757 /*!40101 SET character_set_client = utf8 */;
758 CREATE TABLE `orchestration_status_state_transition_directive` (
759 `id` int(11) NOT NULL AUTO_INCREMENT,
760 `RESOURCE_TYPE` varchar(25) NOT NULL,
761 `ORCHESTRATION_STATUS` varchar(25) NOT NULL,
762 `TARGET_ACTION` varchar(25) NOT NULL,
763 `FLOW_DIRECTIVE` varchar(25) NOT NULL,
765 UNIQUE KEY `UK_orchestration_status_state_transition_directive` (`RESOURCE_TYPE`,`ORCHESTRATION_STATUS`,`TARGET_ACTION`)
766 ) ENGINE=InnoDB AUTO_INCREMENT=686 DEFAULT CHARSET=latin1;
767 /*!40101 SET character_set_client = @saved_cs_client */;
770 -- Table structure for table `rainy_day_handler_macro`
773 DROP TABLE IF EXISTS `rainy_day_handler_macro`;
774 /*!40101 SET @saved_cs_client = @@character_set_client */;
775 /*!40101 SET character_set_client = utf8 */;
776 CREATE TABLE `rainy_day_handler_macro` (
777 `id` int(11) NOT NULL AUTO_INCREMENT,
778 `FLOW_NAME` varchar(200) NOT NULL,
779 `SERVICE_TYPE` varchar(200) NOT NULL,
780 `VNF_TYPE` varchar(200) NOT NULL,
781 `ERROR_CODE` varchar(200) NOT NULL,
782 `WORK_STEP` varchar(200) NOT NULL,
783 `POLICY` varchar(200) NOT NULL,
784 `SECONDARY_POLICY` varchar(200) DEFAULT NULL,
786 ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
787 /*!40101 SET character_set_client = @saved_cs_client */;
790 -- Table structure for table `service`
793 DROP TABLE IF EXISTS `service`;
794 /*!40101 SET @saved_cs_client = @@character_set_client */;
795 /*!40101 SET character_set_client = utf8 */;
796 CREATE TABLE `service` (
797 `MODEL_UUID` varchar(200) NOT NULL,
798 `MODEL_NAME` varchar(200) NOT NULL,
799 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
800 `MODEL_VERSION` varchar(20) NOT NULL,
801 `DESCRIPTION` varchar(1200) DEFAULT NULL,
802 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
803 `TOSCA_CSAR_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
804 `SERVICE_TYPE` varchar(200) DEFAULT NULL,
805 `SERVICE_ROLE` varchar(200) DEFAULT NULL,
806 `SERVICE_FUNCTION` varchar(200) DEFAULT NULL,
807 `ENVIRONMENT_CONTEXT` varchar(200) DEFAULT NULL,
808 `WORKLOAD_CONTEXT` varchar(200) DEFAULT NULL,
809 `SERVICE_CATEGORY` varchar(200) DEFAULT NULL,
810 `RESOURCE_ORDER` varchar(200) default NULL,
811 `OVERALL_DISTRIBUTION_STATUS` varchar(45),
812 `ONAP_GENERATED_NAMING` TINYINT(1) DEFAULT NULL,
813 `NAMING_POLICY` varchar(200) DEFAULT NULL,
814 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
815 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
816 `CONTROLLER_ACTOR` varchar(200) DEFAULT NULL,
817 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
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) NOT NULL DEFAULT '0',
964 `MIN_INSTANCES` int(11) NOT NULL 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,
972 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
974 KEY `fk_vf_module_customization__vf_module1_idx` (`VF_MODULE_MODEL_UUID`),
975 KEY `fk_vf_module_customization__heat_env__heat_environment1_idx` (`HEAT_ENVIRONMENT_ARTIFACT_UUID`),
976 KEY `fk_vf_module_customization__vol_env__heat_environment2_idx` (`VOL_ENVIRONMENT_ARTIFACT_UUID`),
977 KEY `fk_vf_module_customization_to_vnf_resource_customization` (`VNF_RESOURCE_CUSTOMIZATION_ID`),
978 KEY `vf_module_customization_model_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
979 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,
980 CONSTRAINT `fk_vf_module_customization__vf_module1` FOREIGN KEY (`VF_MODULE_MODEL_UUID`) REFERENCES `vf_module` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
981 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,
982 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
983 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
984 /*!40101 SET character_set_client = @saved_cs_client */;
987 -- Table structure for table `vf_module_to_heat_files`
990 DROP TABLE IF EXISTS `vf_module_to_heat_files`;
991 /*!40101 SET @saved_cs_client = @@character_set_client */;
992 /*!40101 SET character_set_client = utf8 */;
993 CREATE TABLE `vf_module_to_heat_files` (
994 `VF_MODULE_MODEL_UUID` varchar(200) NOT NULL,
995 `HEAT_FILES_ARTIFACT_UUID` varchar(200) NOT NULL,
996 PRIMARY KEY (`VF_MODULE_MODEL_UUID`,`HEAT_FILES_ARTIFACT_UUID`),
997 KEY `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`HEAT_FILES_ARTIFACT_UUID`),
998 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,
999 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
1000 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='il fait ce qu''il dit';
1001 /*!40101 SET character_set_client = @saved_cs_client */;
1004 -- Table structure for table `vnf_components`
1007 DROP TABLE IF EXISTS `vnf_components`;
1008 /*!40101 SET @saved_cs_client = @@character_set_client */;
1009 /*!40101 SET character_set_client = utf8 */;
1010 CREATE TABLE `vnf_components` (
1011 `VNF_ID` int(11) NOT NULL,
1012 `COMPONENT_TYPE` varchar(20) NOT NULL,
1013 `HEAT_TEMPLATE_ID` int(11) DEFAULT NULL,
1014 `HEAT_ENVIRONMENT_ID` int(11) DEFAULT NULL,
1015 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1016 PRIMARY KEY (`VNF_ID`,`COMPONENT_TYPE`)
1017 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1018 /*!40101 SET character_set_client = @saved_cs_client */;
1021 -- Table structure for table `vnf_components_recipe`
1024 DROP TABLE IF EXISTS `vnf_components_recipe`;
1025 /*!40101 SET @saved_cs_client = @@character_set_client */;
1026 /*!40101 SET character_set_client = utf8 */;
1027 CREATE TABLE `vnf_components_recipe` (
1028 `id` int(11) NOT NULL AUTO_INCREMENT,
1029 `VNF_TYPE` varchar(200) DEFAULT NULL,
1030 `VNF_COMPONENT_TYPE` varchar(45) NOT NULL,
1031 `ACTION` varchar(50) NOT NULL,
1032 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1033 `VERSION` varchar(20) NOT NULL,
1034 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1035 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1036 `VNF_COMPONENT_PARAM_XSD` varchar(2048) DEFAULT NULL,
1037 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1038 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1039 `VF_MODULE_MODEL_UUID` varchar(200) DEFAULT NULL,
1041 UNIQUE KEY `UK_4dpdwddaaclhc11wxsb7h59ma` (`VF_MODULE_MODEL_UUID`,`VNF_COMPONENT_TYPE`,`ACTION`,`VERSION`)
1042 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
1043 /*!40101 SET character_set_client = @saved_cs_client */;
1046 -- Table structure for table `vnf_recipe`
1049 DROP TABLE IF EXISTS `vnf_recipe`;
1050 /*!40101 SET @saved_cs_client = @@character_set_client */;
1051 /*!40101 SET character_set_client = utf8 */;
1052 CREATE TABLE `vnf_recipe` (
1053 `id` int(11) NOT NULL AUTO_INCREMENT,
1054 `NF_ROLE` varchar(200) DEFAULT NULL,
1055 `ACTION` varchar(50) NOT NULL,
1056 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
1057 `VERSION_STR` varchar(20) NOT NULL,
1058 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1059 `ORCHESTRATION_URI` varchar(256) NOT NULL,
1060 `VNF_PARAM_XSD` varchar(2048) DEFAULT NULL,
1061 `RECIPE_TIMEOUT` int(11) DEFAULT NULL,
1062 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP,
1063 `VF_MODULE_ID` varchar(100) DEFAULT NULL,
1065 UNIQUE KEY `UK_f3tvqau498vrifq3cr8qnigkr` (`VF_MODULE_ID`,`ACTION`,`VERSION_STR`)
1066 ) ENGINE=InnoDB AUTO_INCREMENT=10015 DEFAULT CHARSET=latin1;
1067 /*!40101 SET character_set_client = @saved_cs_client */;
1070 -- Table structure for table `vnf_resource`
1073 DROP TABLE IF EXISTS `vnf_resource`;
1074 /*!40101 SET @saved_cs_client = @@character_set_client */;
1075 /*!40101 SET character_set_client = utf8 */;
1076 CREATE TABLE `vnf_resource` (
1077 `ORCHESTRATION_MODE` varchar(20) NOT NULL DEFAULT 'HEAT',
1078 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1079 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1080 `MODEL_UUID` varchar(200) NOT NULL,
1081 `AIC_VERSION_MIN` varchar(20) DEFAULT NULL,
1082 `AIC_VERSION_MAX` varchar(20) DEFAULT NULL,
1083 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1084 `MODEL_VERSION` varchar(20) NOT NULL,
1085 `MODEL_NAME` varchar(200) DEFAULT NULL,
1086 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1087 `HEAT_TEMPLATE_ARTIFACT_UUID` varchar(200) DEFAULT NULL,
1088 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1089 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1090 PRIMARY KEY (`MODEL_UUID`),
1091 KEY `fk_vnf_resource__heat_template1` (`HEAT_TEMPLATE_ARTIFACT_UUID`),
1092 CONSTRAINT `fk_vnf_resource__heat_template1` FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`) REFERENCES `heat_template` (`ARTIFACT_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1093 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1094 /*!40101 SET character_set_client = @saved_cs_client */;
1097 -- Table structure for table `vnf_resource_customization`
1100 DROP TABLE IF EXISTS `vnf_resource_customization`;
1101 /*!40101 SET @saved_cs_client = @@character_set_client */;
1102 /*!40101 SET character_set_client = utf8 */;
1103 CREATE TABLE `vnf_resource_customization` (
1104 `ID` int(13) NOT NULL AUTO_INCREMENT,
1105 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1106 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1107 `MIN_INSTANCES` int(11) DEFAULT NULL,
1108 `MAX_INSTANCES` int(11) DEFAULT NULL,
1109 `AVAILABILITY_ZONE_MAX_COUNT` int(11) DEFAULT NULL,
1110 `NF_TYPE` varchar(200) DEFAULT NULL,
1111 `NF_ROLE` varchar(200) DEFAULT NULL,
1112 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1113 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1114 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1115 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
1116 `CDS_BLUEPRINT_NAME` varchar(200) default null,
1117 `CDS_BLUEPRINT_VERSION` varchar(20) default null,
1118 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1119 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1120 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1121 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1122 `NF_DATA_VALID` tinyint(1) DEFAULT '0',
1123 `VNFCINSTANCEGROUP_ORDER` varchar(200) default NULL,
1124 `CONTROLLER_ACTOR` varchar(200) DEFAULT NULL,
1126 UNIQUE KEY `UK_vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`,`SERVICE_MODEL_UUID`),
1127 KEY `fk_vnf_resource_customization__vnf_resource1_idx` (`VNF_RESOURCE_MODEL_UUID`),
1128 KEY `fk_vnf_resource_customization_to_service` (`SERVICE_MODEL_UUID`),
1129 KEY `vnf_resource_customization_mod_cust_uuid_idx` (`MODEL_CUSTOMIZATION_UUID`),
1130 CONSTRAINT `fk_vnf_resource_customization__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1131 CONSTRAINT `fk_vnf_resource_customization_to_service` FOREIGN KEY (`SERVICE_MODEL_UUID`) REFERENCES `service` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1132 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1133 /*!40101 SET character_set_client = @saved_cs_client */;
1136 -- Table structure for table `vnfc_customization`
1139 DROP TABLE IF EXISTS `vnfc_customization`;
1140 /*!40101 SET @saved_cs_client = @@character_set_client */;
1141 /*!40101 SET character_set_client = utf8 */;
1142 CREATE TABLE `vnfc_customization` (
1143 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1144 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1145 `MODEL_UUID` varchar(200) NOT NULL,
1146 `MODEL_INVARIANT_UUID` varchar(200) NOT NULL,
1147 `MODEL_VERSION` varchar(20) NOT NULL,
1148 `MODEL_NAME` varchar(200) NOT NULL,
1149 `TOSCA_NODE_TYPE` varchar(200) NOT NULL,
1150 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1151 `RESOURCE_INPUT` varchar(20000) DEFAULT NULL,
1152 `VNFC_INSTANCE_GROUP_CUSTOMIZATION_ID` integer DEFAULT NULL,
1153 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1154 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`)
1155 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1156 /*!40101 SET character_set_client = @saved_cs_client */;
1159 -- Table structure for table `vnfc_instance_group_customization`
1162 DROP TABLE IF EXISTS `vnfc_instance_group_customization`;
1163 /*!40101 SET @saved_cs_client = @@character_set_client */;
1164 /*!40101 SET character_set_client = utf8 */;
1165 CREATE TABLE `vnfc_instance_group_customization` (
1166 `ID` int(13) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1167 `VNF_RESOURCE_CUSTOMIZATION_ID` int(13) NOT NULL,
1168 `INSTANCE_GROUP_MODEL_UUID` varchar(200) NOT NULL,
1169 `FUNCTION` varchar(200) DEFAULT NULL,
1170 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1171 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1172 KEY `fk_vnfc_instance_group_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID`),
1173 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,
1174 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
1175 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1176 set foreign_key_checks=1;
1178 CREATE TABLE IF NOT EXISTS `pnf_resource` (
1179 `ORCHESTRATION_MODE` varchar(20) DEFAULT NULL,
1180 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1181 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1182 `MODEL_UUID` varchar(200) NOT NULL,
1183 `MODEL_INVARIANT_UUID` varchar(200) DEFAULT NULL,
1184 `MODEL_VERSION` varchar(20) NOT NULL,
1185 `MODEL_NAME` varchar(200) DEFAULT NULL,
1186 `TOSCA_NODE_TYPE` varchar(200) DEFAULT NULL,
1187 `RESOURCE_CATEGORY` varchar(200) DEFAULT NULL,
1188 `RESOURCE_SUB_CATEGORY` varchar(200) DEFAULT NULL,
1189 PRIMARY KEY (`MODEL_UUID`)
1190 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1192 CREATE TABLE IF NOT EXISTS `pnf_resource_customization` (
1193 `MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1194 `MODEL_INSTANCE_NAME` varchar(200) NOT NULL,
1195 `NF_TYPE` varchar(200) DEFAULT NULL,
1196 `NF_ROLE` varchar(200) DEFAULT NULL,
1197 `NF_FUNCTION` varchar(200) DEFAULT NULL,
1198 `NF_NAMING_CODE` varchar(200) DEFAULT NULL,
1199 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1200 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1201 `MULTI_STAGE_DESIGN` varchar(20) DEFAULT NULL,
1202 `RESOURCE_INPUT` varchar(2000) DEFAULT NULL,
1203 `CDS_BLUEPRINT_NAME` varchar(200) DEFAULT NULL,
1204 `CDS_BLUEPRINT_VERSION` varchar(20) DEFAULT NULL,
1205 `SKIP_POST_INSTANTIATION_CONFIGURATION` boolean default true,
1206 `CONTROLLER_ACTOR` varchar(200) DEFAULT NULL,
1207 `DEFAULT_SOFTWARE_VERSION` varchar(4000) DEFAULT NULL,
1208 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
1209 KEY `fk_pnf_resource_customization__pnf_resource1_idx` (`PNF_RESOURCE_MODEL_UUID`),
1210 CONSTRAINT `fk_pnf_resource_customization__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
1211 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1213 CREATE TABLE IF NOT EXISTS `pnf_resource_customization_to_service` (
1214 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
1215 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
1216 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
1217 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
1219 CREATE TABLE IF NOT EXISTS `workflow` (
1220 `ID` int(11) NOT NULL AUTO_INCREMENT,
1221 `ARTIFACT_UUID` varchar(200) NOT NULL,
1222 `ARTIFACT_NAME` varchar(200) NOT NULL,
1223 `NAME` varchar(200) NOT NULL,
1224 `OPERATION_NAME` varchar(200) DEFAULT NULL,
1225 `VERSION` double NOT NULL,
1226 `DESCRIPTION` varchar(1200) DEFAULT NULL,
1227 `BODY` longtext DEFAULT NULL,
1228 `RESOURCE_TARGET` varchar(200) NOT NULL,
1229 `SOURCE` varchar(200) NOT NULL,
1230 `TIMEOUT_MINUTES` int(11) DEFAULT NULL,
1231 `ARTIFACT_CHECKSUM` varchar(200) NOT NULL DEFAULT 'MANUAL RECORD',
1232 `CREATION_TIMESTAMP` datetime NOT NULL DEFAULT current_timestamp(),
1234 UNIQUE KEY `UK_workflow` (`ARTIFACT_UUID`,`NAME`,`VERSION`,`SOURCE`)
1235 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1237 CREATE TABLE IF NOT EXISTS `vnf_resource_to_workflow` (
1238 `ID` int(11) NOT NULL AUTO_INCREMENT,
1239 `VNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1240 `WORKFLOW_ID` int(11) NOT NULL,
1242 UNIQUE KEY `UK_vnf_resource_to_workflow` (`VNF_RESOURCE_MODEL_UUID`,`WORKFLOW_ID`),
1243 KEY `fk_vnf_resource_to_workflow__workflow1_idx` (`WORKFLOW_ID`),
1244 KEY `fk_vnf_resource_to_workflow__vnf_res_mod_uuid_idx` (`VNF_RESOURCE_MODEL_UUID`),
1245 CONSTRAINT `fk_vnf_resource_to_workflow__vnf_resource1` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1246 CONSTRAINT `fk_vnf_resource_to_workflow__workflow1` FOREIGN KEY (`WORKFLOW_ID`) REFERENCES `workflow` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
1247 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1249 CREATE TABLE IF NOT EXISTS `pnf_resource_to_workflow` (
1250 `ID` int(11) NOT NULL AUTO_INCREMENT,
1251 `PNF_RESOURCE_MODEL_UUID` varchar(200) NOT NULL,
1252 `WORKFLOW_ID` int(11) NOT NULL,
1254 UNIQUE KEY `UK_pnf_resource_to_workflow` (`PNF_RESOURCE_MODEL_UUID`,`WORKFLOW_ID`),
1255 KEY `fk_pnf_resource_to_workflow__workflow1_idx` (`WORKFLOW_ID`),
1256 KEY `fk_pnf_resource_to_workflow__pnf_res_mod_uuid_idx` (`PNF_RESOURCE_MODEL_UUID`),
1257 CONSTRAINT `fk_pnf_resource_to_workflow__pnf_resource1` FOREIGN KEY (`PNF_RESOURCE_MODEL_UUID`) REFERENCES `pnf_resource` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
1258 CONSTRAINT `fk_pnf_resource_to_workflow__workflow1` FOREIGN KEY (`WORKFLOW_ID`) REFERENCES `workflow` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
1259 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1261 CREATE TABLE IF NOT EXISTS `activity_spec` (
1262 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1263 `NAME` VARCHAR(200) NOT NULL,
1264 `DESCRIPTION` VARCHAR(1200) NOT NULL,
1265 `VERSION` DOUBLE NOT NULL,
1266 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1268 UNIQUE INDEX `UK_activity_spec` (`NAME` ASC, `VERSION` ASC))
1270 DEFAULT CHARACTER SET = latin1;
1272 CREATE TABLE IF NOT EXISTS `user_parameters` (
1273 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1274 `NAME` VARCHAR(200) NOT NULL,
1275 `PAYLOAD_LOCATION` VARCHAR(500) NULL,
1276 `LABEL` VARCHAR(200) NOT NULL,
1277 `TYPE` VARCHAR(200) NOT NULL,
1278 `DESCRIPTION` VARCHAR(1200) NULL,
1279 `IS_REQUIRED` TINYINT(1) NOT NULL,
1280 `MAX_LENGTH` INT(11) NULL,
1281 `ALLOWABLE_CHARS` VARCHAR(200) NULL,
1282 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1284 UNIQUE INDEX `UK_user_parameters` (`NAME` ASC))
1286 DEFAULT CHARACTER SET = latin1;
1288 CREATE TABLE IF NOT EXISTS `workflow_activity_spec_sequence` (
1289 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1290 `WORKFLOW_ID` INT(11) NOT NULL,
1291 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1292 `SEQ_NO` INT(11) NOT NULL,
1294 UNIQUE INDEX `UK_workflow_activity_spec_sequence` (`WORKFLOW_ID` ASC, `ACTIVITY_SPEC_ID` ASC, `SEQ_NO` ASC),
1295 INDEX `fk_workflow_activity_spec_sequence__activity_spec_idx` (`ACTIVITY_SPEC_ID` ASC),
1296 INDEX `fk_workflow_activity_spec_sequence__workflow_actifact_uuid_idx` (`WORKFLOW_ID` ASC),
1297 CONSTRAINT `fk_workflow_activity_spec_sequence__activity_spec1`
1298 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1299 REFERENCES `activity_spec` (`ID`)
1302 CONSTRAINT `fk_workflow_activity_spec_sequence__workflow1`
1303 FOREIGN KEY (`WORKFLOW_ID`)
1304 REFERENCES `workflow` (`ID`)
1308 DEFAULT CHARACTER SET = latin1;
1310 CREATE TABLE IF NOT EXISTS `activity_spec_parameters` (
1311 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1312 `NAME` VARCHAR(200) NOT NULL,
1313 `TYPE` VARCHAR(200) NOT NULL,
1314 `DIRECTION` VARCHAR(200) NULL,
1315 `DESCRIPTION` VARCHAR(1200) NULL,
1316 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
1318 UNIQUE INDEX `UK_activity_spec_parameters` (`NAME` ASC, `DIRECTION` ASC))
1320 DEFAULT CHARACTER SET = latin1;
1322 CREATE TABLE IF NOT EXISTS `activity_spec_categories` (
1323 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1324 `NAME` VARCHAR(200) NOT NULL,
1326 UNIQUE INDEX `UK_activity_spec_categories` (`NAME` ASC))
1328 DEFAULT CHARACTER SET = latin1;
1330 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_categories` (
1331 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1332 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1333 `ACTIVITY_SPEC_CATEGORIES_ID` INT(11) NOT NULL,
1335 UNIQUE INDEX `UK_activity_spec_to_activity_spec_categories` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1336 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx` (`ACTIVITY_SPEC_CATEGORIES_ID` ASC),
1337 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx1` (`ACTIVITY_SPEC_ID` ASC),
1338 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec1`
1339 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1340 REFERENCES `activity_spec` (`ID`)
1343 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec_c1`
1344 FOREIGN KEY (`ACTIVITY_SPEC_CATEGORIES_ID`)
1345 REFERENCES `activity_spec_categories` (`ID`)
1349 DEFAULT CHARACTER SET = latin1;
1351 CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_parameters` (
1352 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1353 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1354 `ACTIVITY_SPEC_PARAMETERS_ID` INT(11) NOT NULL,
1356 INDEX `fk_activity_spec_to_activity_spec_params__act_sp_param_id_idx` (`ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1357 UNIQUE INDEX `UK_activity_spec_to_activity_spec_parameters` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_PARAMETERS_ID` ASC),
1358 INDEX `fk_activity_spec_to_activity_spec_parameters__act_spec_id_idx` (`ACTIVITY_SPEC_ID` ASC),
1359 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activity_spec_1`
1360 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1361 REFERENCES `activity_spec` (`ID`)
1364 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activ_spec_param1`
1365 FOREIGN KEY (`ACTIVITY_SPEC_PARAMETERS_ID`)
1366 REFERENCES `activity_spec_parameters` (`ID`)
1370 DEFAULT CHARACTER SET = latin1;
1372 CREATE TABLE IF NOT EXISTS `activity_spec_to_user_parameters` (
1373 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1374 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
1375 `USER_PARAMETERS_ID` INT(11) NOT NULL,
1377 UNIQUE INDEX `UK_activity_spec_to_user_parameters` (`ACTIVITY_SPEC_ID` ASC, `USER_PARAMETERS_ID` ASC),
1378 INDEX `fk_activity_spec_to_user_parameters__user_parameters1_idx` (`USER_PARAMETERS_ID` ASC),
1379 INDEX `fk_activity_spec_to_user_parameters__activity_spec1_idx` (`ACTIVITY_SPEC_ID` ASC),
1380 CONSTRAINT `fk_activity_spec_to_user_parameters__activity_spec1`
1381 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
1382 REFERENCES `activity_spec` (`ID`)
1385 CONSTRAINT `fk_activity_spec_to_user_parameters__user_parameters1`
1386 FOREIGN KEY (`USER_PARAMETERS_ID`)
1387 REFERENCES `user_parameters` (`ID`)
1391 DEFAULT CHARACTER SET = latin1;
1394 -- Table structure for table `bbname_selection_reference`
1397 DROP TABLE IF EXISTS `bbname_selection_reference`;
1398 CREATE TABLE IF NOT EXISTS `bbname_selection_reference` (
1399 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1400 `CONTROLLER_ACTOR` varchar(200) NOT NULL ,
1401 `SCOPE` varchar(200) NOT NULL,
1402 `ACTION` varchar(200) NOT NULL,
1403 `BB_NAME` varchar(200) NOT NULL,
1405 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1407 CREATE TABLE IF NOT EXISTS `processing_flags` (
1408 `ID` INT(11) NOT NULL AUTO_INCREMENT,
1409 `FLAG` varchar(200) NOT NULL,
1410 `VALUE` varchar(200) NOT NULL,
1411 `ENDPOINT` varchar(200) NOT NULL,
1412 `DESCRIPTION` longtext NOT NULL,
1413 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
1414 `UPDATE_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
1416 UNIQUE KEY `UK_processing_flags` (`FLAG`)
1417 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1419 CREATE TABLE IF NOT EXISTS `building_block_rollback` (
1420 `ID` INT NOT NULL AUTO_INCREMENT,
1421 `BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
1422 `ACTION` varchar(200) null,
1423 `ROLLBACK_BUILDING_BLOCK_NAME` varchar(200) NOT NULL,
1424 `ROLLBACK_ACTION` varchar(200) NULL,
1426 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;