1 CREATE DATABASE IF NOT EXISTS `sdnctl` /*!40100 DEFAULT CHARACTER SET latin1 */;
4 SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
5 SET @@SESSION.SQL_LOG_BIN= 0;
8 -- Table structure for table `ACTION_LEVEL_REFERENCE`
11 DROP TABLE IF EXISTS `ACTION_LEVEL_REFERENCE`;
12 /*!40101 SET @saved_cs_client = @@character_set_client */;
13 /*!40101 SET character_set_client = utf8 */;
14 CREATE TABLE `ACTION_LEVEL_REFERENCE` (
15 `ACTION_LEVEL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
16 `ACTION_IDENTIFIER` varchar(50) NOT NULL,
17 `ACTION_LEVEL` varchar(50) NOT NULL,
18 UNIQUE KEY `ACTION_LEVEL_REFERENCE_ID` (`ACTION_LEVEL_REFERENCE_ID`)
19 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
20 /*!40101 SET character_set_client = @saved_cs_client */;
23 -- Table structure for table `ASDC_ARTIFACTS`
26 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
27 /*!40101 SET @saved_cs_client = @@character_set_client */;
28 /*!40101 SET character_set_client = utf8 */;
29 CREATE TABLE `ASDC_ARTIFACTS` (
30 `ASDC_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
31 `SERVICE_UUID` varchar(50) DEFAULT NULL,
32 `DISTRIBUTION_ID` varchar(50) DEFAULT NULL,
33 `SERVICE_NAME` varchar(255) DEFAULT NULL,
34 `SERVICE_DESCRIPTION` varchar(255) DEFAULT NULL,
35 `RESOURCE_UUID` varchar(255) DEFAULT NULL,
36 `RESOURCE_INSTANCE_NAME` varchar(255) DEFAULT NULL,
37 `RESOURCE_NAME` varchar(255) DEFAULT NULL,
38 `RESOURCE_VERSION` varchar(50) DEFAULT NULL,
39 `RESOURCE_TYPE` varchar(50) DEFAULT NULL,
40 `ARTIFACT_UUID` varchar(50) DEFAULT NULL,
41 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
42 `ARTIFACT_VERSION` varchar(25) DEFAULT NULL,
43 `ARTIFACT_DESCRIPTION` varchar(255) DEFAULT NULL,
44 `INTERNAL_VERSION` int(11) DEFAULT NULL,
45 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
46 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
47 `ARTIFACT_CONTENT` longtext,
48 PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
49 UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
50 ) ENGINE=InnoDB AUTO_INCREMENT=1412 DEFAULT CHARSET=latin1;
51 /*!40101 SET character_set_client = @saved_cs_client */;
54 -- Table structure for table `ASDC_REFERENCE`
57 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
58 /*!40101 SET @saved_cs_client = @@character_set_client */;
59 /*!40101 SET character_set_client = utf8 */;
60 CREATE TABLE `ASDC_REFERENCE` (
61 `ASDC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
62 `VNF_TYPE` varchar(50) DEFAULT NULL,
63 `VNFC_TYPE` varchar(50) DEFAULT NULL,
64 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
65 `ACTION` varchar(50) DEFAULT NULL,
66 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
67 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
68 PRIMARY KEY (`ASDC_REFERENCE_ID`),
69 UNIQUE KEY `ASDC_REFERENCE_ID` (`ASDC_REFERENCE_ID`)
70 ) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=latin1;
71 /*!40101 SET character_set_client = @saved_cs_client */;
74 -- Table structure for table `CONFIGFILES`
77 DROP TABLE IF EXISTS `CONFIGFILES`;
78 /*!40101 SET @saved_cs_client = @@character_set_client */;
79 /*!40101 SET character_set_client = utf8 */;
80 CREATE TABLE `CONFIGFILES` (
81 `CONFIG_FILE_ID` int(11) NOT NULL AUTO_INCREMENT,
82 `EXTERNAL_VERSION` varchar(50) DEFAULT NULL,
83 `DATA_SOURCE` varchar(25) DEFAULT NULL,
84 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
85 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
86 `VNF_TYPE` varchar(50) DEFAULT NULL,
87 `VNFC_TYPE` varchar(50) DEFAULT NULL,
88 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
89 `FILE_NAME` varchar(255) DEFAULT NULL,
90 `FILE_CONTENT` longtext,
91 `ACTION` varchar(50) DEFAULT NULL,
92 `VNF_ID` varchar(50) DEFAULT NULL,
93 `VM_NAME` varchar(50) DEFAULT NULL,
94 `VNF_NAME` varchar(50) DEFAULT NULL,
95 PRIMARY KEY (`CONFIG_FILE_ID`),
96 UNIQUE KEY `CONFIG_FILE_ID` (`CONFIG_FILE_ID`)
97 ) ENGINE=InnoDB AUTO_INCREMENT=688 DEFAULT CHARSET=latin1;
98 /*!40101 SET character_set_client = @saved_cs_client */;
101 -- Table structure for table `CONFIGURE_ACTION_DG`
104 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
105 /*!40101 SET @saved_cs_client = @@character_set_client */;
106 /*!40101 SET character_set_client = utf8 */;
107 CREATE TABLE `CONFIGURE_ACTION_DG` (
108 `CONFIGURE_ACTION_DG_ID` int(11) NOT NULL AUTO_INCREMENT,
109 `VNF_TYPE` varchar(50) DEFAULT NULL,
110 `ACTION` varchar(50) DEFAULT NULL,
111 `GENERATE_CONFIG_DG` varchar(50) DEFAULT NULL,
112 `DOWNLOAD_CONFIG_DG` varchar(50) DEFAULT NULL,
113 PRIMARY KEY (`CONFIGURE_ACTION_DG_ID`),
114 UNIQUE KEY ` CONFIGURE_ACTION_DG_ID` (`CONFIGURE_ACTION_DG_ID`)
115 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
116 /*!40101 SET character_set_client = @saved_cs_client */;
119 -- Table structure for table `CONFIG_FILE_REFERENCE`
122 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
123 /*!40101 SET @saved_cs_client = @@character_set_client */;
124 /*!40101 SET character_set_client = utf8 */;
125 CREATE TABLE `CONFIG_FILE_REFERENCE` (
126 `CONFIG_FILE_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
127 `SITE_LOCATION` varchar(50) DEFAULT NULL,
128 `VNF_TYPE` varchar(50) DEFAULT NULL,
129 `IMPORT_TYPE` varchar(50) DEFAULT NULL,
130 `FILE_TYPE` varchar(50) DEFAULT NULL,
131 `SOURCE_SERVER_NAME` varchar(255) DEFAULT NULL,
132 `SOURCE_FILE_PATH` varchar(255) DEFAULT NULL,
133 `TARGET_FILE_PATH` varchar(255) DEFAULT NULL,
134 `NAME` varchar(50) DEFAULT NULL,
135 `FILE_NAME` varchar(255) DEFAULT NULL,
136 PRIMARY KEY (`CONFIG_FILE_REFERENCE_ID`),
137 UNIQUE KEY `CONFIG_FILE_REFERENCE_ID` (`CONFIG_FILE_REFERENCE_ID`)
138 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
139 /*!40101 SET character_set_client = @saved_cs_client */;
142 -- Table structure for table `CONFIG_TRANSACTION_LOG`
145 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
146 /*!40101 SET @saved_cs_client = @@character_set_client */;
147 /*!40101 SET character_set_client = utf8 */;
148 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
149 `CONFIG_TRANSACTION_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
150 `REQUEST_ID` varchar(50) DEFAULT NULL,
151 `MESSAGE_TYPE` varchar(50) DEFAULT NULL,
152 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
154 PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
155 UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
156 ) ENGINE=InnoDB AUTO_INCREMENT=1074 DEFAULT CHARSET=latin1;
157 /*!40101 SET character_set_client = @saved_cs_client */;
160 -- Table structure for table `DEVICE_AUTHENTICATION`
163 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
164 /*!40101 SET @saved_cs_client = @@character_set_client */;
165 /*!40101 SET character_set_client = utf8 */;
166 CREATE TABLE `DEVICE_AUTHENTICATION` (
167 `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
168 `VNF_TYPE` varchar(50) DEFAULT NULL,
169 `USER_NAME` varchar(50) DEFAULT NULL,
170 `PASSWORD` varchar(100) DEFAULT NULL,
171 `PORT_NUMBER` int(11) DEFAULT NULL,
172 PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
173 UNIQUE KEY `DEVICE_AUTHENTICATION_ID` (`DEVICE_AUTHENTICATION_ID`)
174 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
175 /*!40101 SET character_set_client = @saved_cs_client */;
178 -- Temporary view structure for view `DEVICE_CONFIGURATION`
181 DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
182 /*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
183 SET @saved_cs_client = @@character_set_client;
184 SET character_set_client = utf8;
185 /*!50001 CREATE VIEW `DEVICE_CONFIGURATION` AS SELECT
186 1 AS `UPLOAD_CONFIG_ID`,
188 1 AS `ORIGINATOR_ID`,
189 1 AS `SERVICE_DESCRIPTION`,
197 1 AS `HOST_IP_ADDRESS`,
198 1 AS `CONFIG_INDICATOR`,
199 1 AS `PENDING_DELETE`,
201 SET character_set_client = @saved_cs_client;
204 -- Table structure for table `DEVICE_INTERFACE_LOG`
207 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
208 /*!40101 SET @saved_cs_client = @@character_set_client */;
209 /*!40101 SET character_set_client = utf8 */;
210 CREATE TABLE `DEVICE_INTERFACE_LOG` (
211 `DEVICE_INTERFACE_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
212 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
213 `REQUEST_ID` varchar(50) DEFAULT NULL,
214 `CREATION_DATE` datetime NOT NULL,
216 PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
217 UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
218 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
219 /*!40101 SET character_set_client = @saved_cs_client */;
222 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
225 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
226 /*!40101 SET @saved_cs_client = @@character_set_client */;
227 /*!40101 SET character_set_client = utf8 */;
228 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
229 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
230 `VNF_TYPE` varchar(50) DEFAULT NULL,
231 `PROTOCOL` varchar(50) DEFAULT NULL,
232 `MODULE` varchar(50) DEFAULT NULL,
233 `DG_RPC` varchar(50) DEFAULT NULL,
234 PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
235 UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`),
236 UNIQUE KEY `VNF_TYPE` (`VNF_TYPE`)
237 ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
238 /*!40101 SET character_set_client = @saved_cs_client */;
241 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
244 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
245 /*!40101 SET @saved_cs_client = @@character_set_client */;
246 /*!40101 SET character_set_client = utf8 */;
247 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
248 `DOWNLOAD_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
249 `VNF_TYPE` varchar(50) NOT NULL,
250 `PROTOCOL` varchar(50) NOT NULL,
252 PRIMARY KEY (`DOWNLOAD_CONFIG_TEMPLATE_ID`),
253 UNIQUE KEY `DOWNLOAD_CONFIG_TEMPLATE_ID` (`DOWNLOAD_CONFIG_TEMPLATE_ID`)
254 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
255 /*!40101 SET character_set_client = @saved_cs_client */;
258 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
261 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
262 /*!40101 SET @saved_cs_client = @@character_set_client */;
263 /*!40101 SET character_set_client = utf8 */;
264 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
265 `DOWNLOAD_DG_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
266 `PROTOCOL` varchar(50) NOT NULL,
267 `DOWNLOAD_CONFIG_DG` varchar(50) NOT NULL,
268 PRIMARY KEY (`DOWNLOAD_DG_REFERENCE_ID`),
269 UNIQUE KEY ` DOWNLOAD_DG_REFERENCE_ID` (`DOWNLOAD_DG_REFERENCE_ID`)
270 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
271 /*!40101 SET character_set_client = @saved_cs_client */;
274 -- Table structure for table `DT_ACTION_STATUS`
277 DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
278 /*!40101 SET @saved_cs_client = @@character_set_client */;
279 /*!40101 SET character_set_client = utf8 */;
280 CREATE TABLE `DT_ACTION_STATUS` (
281 `DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
282 `ACTION` varchar(50) NOT NULL,
283 `VNF_TYPE` varchar(50) DEFAULT NULL,
284 `VNFC_TYPE` varchar(50) DEFAULT NULL,
285 `USER` varchar(50) NOT NULL,
286 `TECHNOLOGY` varchar(50) DEFAULT NULL,
287 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
288 `STATUS` varchar(50) NOT NULL,
289 PRIMARY KEY (`DT_ACTION_STATUS_ID`),
290 UNIQUE KEY `DT_ACTION_STATUS_ID` (`DT_ACTION_STATUS_ID`)
291 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
292 /*!40101 SET character_set_client = @saved_cs_client */;
295 -- Table structure for table `DT_ARTIFACT_REFERENCE`
298 DROP TABLE IF EXISTS `DT_ARTIFACT_REFERENCE`;
299 /*!40101 SET @saved_cs_client = @@character_set_client */;
300 /*!40101 SET character_set_client = utf8 */;
301 CREATE TABLE `DT_ARTIFACT_REFERENCE` (
302 `DT_ARTIFACT_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
303 `PROTOCOL` varchar(50) DEFAULT NULL,
304 `ACTION` varchar(50) DEFAULT NULL,
305 `ARTIFACT_TYPE` varchar(50) NOT NULL,
306 `ARTIFACT_PRIORITY` int(11) NOT NULL,
307 PRIMARY KEY (`DT_ARTIFACT_REFERENCE_ID`),
308 UNIQUE KEY `DT_ARTIFACT_REFERENCE_ID` (`DT_ARTIFACT_REFERENCE_ID`)
309 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
310 /*!40101 SET character_set_client = @saved_cs_client */;
313 -- Table structure for table `DT_ARTIFACT_TRACKING`
316 DROP TABLE IF EXISTS `DT_ARTIFACT_TRACKING`;
317 /*!40101 SET @saved_cs_client = @@character_set_client */;
318 /*!40101 SET character_set_client = utf8 */;
319 CREATE TABLE `DT_ARTIFACT_TRACKING` (
320 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL AUTO_INCREMENT,
321 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
322 `ASDC_REFERENCE_ID` int(11) DEFAULT NULL,
323 `USER` varchar(50) NOT NULL,
324 `TECHNOLOGY` varchar(50) DEFAULT NULL,
325 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
326 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
327 `ARTIFACT_STATUS` varchar(50) NOT NULL,
328 `IN_CART` varchar(50) DEFAULT NULL,
329 `PROTOCOL` varchar(50) DEFAULT NULL,
330 PRIMARY KEY (`DT_ARTIFACT_TRACKING_ID`),
331 UNIQUE KEY `DT_ARTIFACT_TRACKING_ID` (`DT_ARTIFACT_TRACKING_ID`)
332 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
333 /*!40101 SET character_set_client = @saved_cs_client */;
336 -- Table structure for table `DT_GUI_REFERENCE`
339 DROP TABLE IF EXISTS `DT_GUI_REFERENCE`;
340 /*!40101 SET @saved_cs_client = @@character_set_client */;
341 /*!40101 SET character_set_client = utf8 */;
342 CREATE TABLE `DT_GUI_REFERENCE` (
343 `DT_GUI_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
344 `GUI_NAME` varchar(50) NOT NULL,
345 `FIELD_NAME` varchar(50) NOT NULL,
346 `VALUE` varchar(50) NOT NULL,
347 `USER` varchar(50) NOT NULL,
348 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
349 `PROTOCOL` varchar(50) DEFAULT NULL,
350 `ACTION` varchar(50) DEFAULT NULL,
351 PRIMARY KEY (`DT_GUI_REFERENCE_ID`),
352 UNIQUE KEY `DT_GUI_REFERENCE_ID` (`DT_GUI_REFERENCE_ID`)
353 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
354 /*!40101 SET character_set_client = @saved_cs_client */;
357 -- Table structure for table `DT_STATUS_RELATIONSHIP`
360 DROP TABLE IF EXISTS `DT_STATUS_RELATIONSHIP`;
361 /*!40101 SET @saved_cs_client = @@character_set_client */;
362 /*!40101 SET character_set_client = utf8 */;
363 CREATE TABLE `DT_STATUS_RELATIONSHIP` (
364 `DT_STATUS_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
365 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL,
366 `DT_ACTION_STATUS_ID` int(11) NOT NULL,
367 PRIMARY KEY (`DT_STATUS_RELATIONSHIP_ID`),
368 UNIQUE KEY `DT_STATUS_RELATIONSHIP_ID` (`DT_STATUS_RELATIONSHIP_ID`),
369 KEY `IE_DT_STATUS_RELATIONSHIP` (`DT_ARTIFACT_TRACKING_ID`),
370 KEY `IE2_DT_STATUS_RELATIONSHIP` (`DT_ACTION_STATUS_ID`),
371 CONSTRAINT `DT_STATUS_RELATIONSHIP_IBFK_1` FOREIGN KEY (`DT_ARTIFACT_TRACKING_ID`) REFERENCES `DT_ARTIFACT_TRACKING` (`DT_ARTIFACT_TRACKING_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
372 CONSTRAINT `DT_STATUS_RELATIONSHIP_IBFK_2` FOREIGN KEY (`DT_ACTION_STATUS_ID`) REFERENCES `DT_ACTION_STATUS` (`DT_ACTION_STATUS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
373 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
374 /*!40101 SET character_set_client = @saved_cs_client */;
377 -- Table structure for table `GET_CONFIG_TEMPLATE`
380 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
381 /*!40101 SET @saved_cs_client = @@character_set_client */;
382 /*!40101 SET character_set_client = utf8 */;
383 CREATE TABLE `GET_CONFIG_TEMPLATE` (
384 `GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
385 `VNF_TYPE` varchar(50) NOT NULL,
386 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL,
387 `XML_PROCESSING` varchar(1) DEFAULT NULL,
388 `XML_PROTOCOL` varchar(30) DEFAULT NULL,
390 PRIMARY KEY (`GET_CONFIG_TEMPLATE_ID`),
391 UNIQUE KEY `GET_CONFIG_TEMPLATE_ID` (`GET_CONFIG_TEMPLATE_ID`),
392 KEY `get_config_template_ibfk_1` (`DEVICE_INTERFACE_PROTOCOL_ID`),
393 CONSTRAINT `get_config_template_ibfk_1` FOREIGN KEY (`DEVICE_INTERFACE_PROTOCOL_ID`) REFERENCES `DEVICE_INTERFACE_PROTOCOL` (`DEVICE_INTERFACE_PROTOCOL_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
394 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
395 /*!40101 SET character_set_client = @saved_cs_client */;
398 -- Table structure for table `MULTISTEP_FLOW_REFERENCE`
401 DROP TABLE IF EXISTS `MULTISTEP_FLOW_REFERENCE`;
402 /*!40101 SET @saved_cs_client = @@character_set_client */;
403 /*!40101 SET character_set_client = utf8 */;
404 CREATE TABLE `MULTISTEP_FLOW_REFERENCE` (
405 `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
406 `ACTION` varchar(50) NOT NULL,
407 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
408 `VNF_TYPE` varchar(50) DEFAULT NULL,
409 `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
410 `CATEGORY` varchar(50) DEFAULT NULL,
411 `GENERATION_NODE` varchar(50) DEFAULT NULL,
412 `EXECUTION_NODE` varchar(50) DEFAULT NULL,
413 `CREATOR` varchar(50) DEFAULT NULL,
414 `UPDATED_DATE` datetime DEFAULT NULL,
415 UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)
416 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
417 /*!40101 SET character_set_client = @saved_cs_client */;
420 -- Table structure for table `NODE_TYPES`
423 DROP TABLE IF EXISTS `NODE_TYPES`;
424 /*!40101 SET @saved_cs_client = @@character_set_client */;
425 /*!40101 SET character_set_client = utf8 */;
426 CREATE TABLE `NODE_TYPES` (
427 `nodetype` varchar(80) NOT NULL,
428 PRIMARY KEY (`nodetype`)
429 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
430 /*!40101 SET character_set_client = @saved_cs_client */;
433 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
436 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
437 /*!40101 SET @saved_cs_client = @@character_set_client */;
438 /*!40101 SET character_set_client = utf8 */;
439 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
440 `PREPARE_FILE_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
441 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
442 `REQUEST_ID` varchar(255) DEFAULT NULL,
443 `CONFIG_FILE_ID` int(11) DEFAULT NULL,
444 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
445 PRIMARY KEY (`PREPARE_FILE_RELATIONSHIP_ID`),
446 UNIQUE KEY `PREPARE_FILE_RELATIONSHIP_ID` (`PREPARE_FILE_RELATIONSHIP_ID`),
447 KEY `ie_prepare_file_relationship` (`CONFIG_FILE_ID`),
448 KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
449 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
450 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
451 ) ENGINE=InnoDB AUTO_INCREMENT=558 DEFAULT CHARSET=latin1;
452 /*!40101 SET character_set_client = @saved_cs_client */;
455 -- Table structure for table `PROCESS_FLOW_REFERENCE`
458 DROP TABLE IF EXISTS `PROCESS_FLOW_REFERENCE`;
459 /*!40101 SET @saved_cs_client = @@character_set_client */;
460 /*!40101 SET character_set_client = utf8 */;
461 CREATE TABLE `PROCESS_FLOW_REFERENCE` (
462 `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
463 `ACTION` varchar(50) NOT NULL,
464 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
465 `PROTOCOL` varchar(50) DEFAULT NULL,
466 `EXECUTION_TYPE` varchar(100) NOT NULL,
467 `EXECUTION_MODULE` varchar(100) NOT NULL,
468 `EXECUTION_RPC` varchar(100) NOT NULL,
469 `UPDATED_DATE` datetime DEFAULT NULL,
470 `GET_RUNNING_CONFIG` varchar(50) DEFAULT NULL,
471 PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),
472 UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)
473 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
474 /*!40101 SET character_set_client = @saved_cs_client */;
477 -- Table structure for table `PROTOCOL_REFERENCE`
480 DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
481 /*!40101 SET @saved_cs_client = @@character_set_client */;
482 /*!40101 SET character_set_client = utf8 */;
483 CREATE TABLE `PROTOCOL_REFERENCE` (
484 `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
485 `ACTION` varchar(50) NOT NULL,
486 `VNF_TYPE` varchar(50) DEFAULT NULL,
487 `PROTOCOL` varchar(50) DEFAULT NULL,
488 `UPDATED_DATE` datetime DEFAULT NULL,
489 `TEMPLATE` varchar(45) DEFAULT NULL,
490 `ACTION_LEVEL` varchar(45) DEFAULT NULL,
491 PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
492 UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
493 ) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;
494 /*!40101 SET character_set_client = @saved_cs_client */;
497 -- Table structure for table `REQUEST_ARTIFACTS`
500 DROP TABLE IF EXISTS `REQUEST_ARTIFACTS`;
501 /*!40101 SET @saved_cs_client = @@character_set_client */;
502 /*!40101 SET character_set_client = utf8 */;
503 CREATE TABLE `REQUEST_ARTIFACTS` (
504 `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
505 `REQUEST_ID` varchar(50) NOT NULL,
506 `ACTION` varchar(50) NOT NULL,
507 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
508 `VNF_TYPE` varchar(50) DEFAULT NULL,
509 `CATEGORY` varchar(50) NOT NULL,
510 `ARTIFACT_CONTENT` longtext,
511 `UPDATED_DATE` datetime DEFAULT NULL,
512 PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
513 UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
514 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
515 /*!40101 SET character_set_client = @saved_cs_client */;
518 -- Table structure for table `SVC_LOGIC`
521 DROP TABLE IF EXISTS `SVC_LOGIC`;
522 /*!40101 SET @saved_cs_client = @@character_set_client */;
523 /*!40101 SET character_set_client = utf8 */;
524 CREATE TABLE `SVC_LOGIC` (
525 `module` varchar(80) NOT NULL,
526 `rpc` varchar(80) NOT NULL,
527 `version` varchar(40) NOT NULL,
528 `mode` varchar(5) NOT NULL,
529 `active` varchar(1) NOT NULL,
531 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
532 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
533 /*!40101 SET character_set_client = @saved_cs_client */;
536 -- Table structure for table `UPLOAD_CONFIG`
539 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
540 /*!40101 SET @saved_cs_client = @@character_set_client */;
541 /*!40101 SET character_set_client = utf8 */;
542 CREATE TABLE `UPLOAD_CONFIG` (
543 `UPLOAD_CONFIG_ID` int(11) NOT NULL AUTO_INCREMENT,
544 `REQUEST_ID` varchar(50) DEFAULT NULL,
545 `ORIGINATOR_ID` varchar(50) DEFAULT NULL,
546 `SERVICE_DESCRIPTION` varchar(100) DEFAULT NULL,
547 `ACTION` varchar(50) DEFAULT NULL,
548 `UPLOAD_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
549 `VNF_ID` varchar(50) DEFAULT NULL,
550 `VNF_NAME` varchar(50) DEFAULT NULL,
551 `VM_NAME` varchar(50) DEFAULT NULL,
552 `VNF_TYPE` varchar(50) DEFAULT NULL,
553 `VNFC_TYPE` varchar(50) DEFAULT NULL,
554 `HOST_IP_ADDRESS` varchar(50) DEFAULT NULL,
555 `CONFIG_INDICATOR` varchar(25) DEFAULT NULL,
556 `PENDING_DELETE` varchar(1) DEFAULT NULL,
558 PRIMARY KEY (`UPLOAD_CONFIG_ID`),
559 UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
560 ) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=latin1;
561 /*!40101 SET character_set_client = @saved_cs_client */;
564 -- Table structure for table `VNFC_DG_MAPPING`
567 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
568 /*!40101 SET @saved_cs_client = @@character_set_client */;
569 /*!40101 SET character_set_client = utf8 */;
570 CREATE TABLE `VNFC_DG_MAPPING` (
571 `ACTION` varchar(50) DEFAULT NULL,
572 `API_VERSION` varchar(10) DEFAULT NULL,
573 `VNF_TYPE` varchar(50) DEFAULT NULL,
574 `VNFC_TYPE` varchar(50) DEFAULT NULL,
575 `DG_NAME` varchar(50) NOT NULL,
576 `DG_VERSION` varchar(50) DEFAULT NULL,
577 `DG_MODULE` varchar(50) NOT NULL,
578 UNIQUE KEY `INPUT_CONSTRAINT` (`ACTION`,`API_VERSION`,`VNF_TYPE`,`VNFC_TYPE`)
579 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
580 /*!40101 SET character_set_client = @saved_cs_client */;
583 -- Table structure for table `VNFC_REFERENCE`
586 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
587 /*!40101 SET @saved_cs_client = @@character_set_client */;
588 /*!40101 SET character_set_client = utf8 */;
589 CREATE TABLE `VNFC_REFERENCE` (
590 `VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
591 `ACTION` varchar(50) NOT NULL,
592 `VNF_TYPE` varchar(50) NOT NULL,
593 `VM_INSTANCE` int(11) NOT NULL,
594 `VNFC_INSTANCE` int(11) NOT NULL,
595 `VNFC_TYPE` varchar(50) NOT NULL,
596 `VNFC_FUNCTION_CODE` varchar(50) NOT NULL,
597 `IPADDRESS_V4_OAM_VIP` varchar(50) DEFAULT NULL,
598 `TEMPLATE_ID` varchar(100) DEFAULT NULL,
599 `GROUP_NOTATION_TYPE` varchar(50) DEFAULT NULL,
600 `GROUP_NOTATION_VALUE` varchar(50) DEFAULT NULL,
601 PRIMARY KEY (`VNFC_REFERENCE_ID`),
602 UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
603 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
604 /*!40101 SET character_set_client = @saved_cs_client */;
607 -- Table structure for table `VNF_DG_MAPPING`
610 DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
611 /*!40101 SET @saved_cs_client = @@character_set_client */;
612 /*!40101 SET character_set_client = utf8 */;
613 CREATE TABLE `VNF_DG_MAPPING` (
614 `action` varchar(50) NOT NULL,
615 `api_version` varchar(50) DEFAULT NULL,
616 `vnf_type` varchar(50) DEFAULT NULL,
617 `vnf_version` varchar(50) DEFAULT NULL,
618 `dg_name` varchar(50) NOT NULL,
619 `dg_version` varchar(50) DEFAULT NULL,
620 `dg_module` varchar(50) NOT NULL,
621 UNIQUE KEY `INPUT_CONSTRAINT` (`action`,`api_version`,`vnf_type`,`vnf_version`)
622 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
623 /*!40101 SET character_set_client = @saved_cs_client */;
626 -- Table structure for table `VNF_LOCK_MANAGEMENT`
629 DROP TABLE IF EXISTS `VNF_LOCK_MANAGEMENT`;
630 /*!40101 SET @saved_cs_client = @@character_set_client */;
631 /*!40101 SET character_set_client = utf8 */;
632 CREATE TABLE `VNF_LOCK_MANAGEMENT` (
633 `RESOURCE_ID` varchar(50) NOT NULL,
634 `OWNER_ID` varchar(50) DEFAULT NULL,
635 `UPDATED` bigint(20) unsigned NOT NULL,
636 `TIMEOUT` int(10) unsigned NOT NULL,
637 `VER` int(10) unsigned NOT NULL DEFAULT '1',
638 PRIMARY KEY (`RESOURCE_ID`)
639 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
640 /*!40101 SET character_set_client = @saved_cs_client */;
643 -- Table structure for table `VNF_STATE_MANAGEMENT`
646 DROP TABLE IF EXISTS `VNF_STATE_MANAGEMENT`;
647 /*!40101 SET @saved_cs_client = @@character_set_client */;
648 /*!40101 SET character_set_client = utf8 */;
649 CREATE TABLE `VNF_STATE_MANAGEMENT` (
650 `VNF_ID` varchar(50) NOT NULL,
651 `STATE` varchar(50) NOT NULL,
652 `OWNER_ID` varchar(255) DEFAULT NULL,
653 `UPDATED` bigint(20) unsigned NOT NULL,
654 `VER` int(10) unsigned NOT NULL DEFAULT '1',
655 PRIMARY KEY (`VNF_ID`)
656 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
658 SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;