1 -- ============LICENSE_START==========================================
3 -- ===================================================================
4 -- Copyright (C) 2017-2018 AT&T Intellectual Property. All rights reserved.
5 -- ===================================================================
7 -- Unless otherwise specified, all software contained herein is licensed
8 -- under the Apache License, Version 2.0 (the License);
9 -- you may not use this software except in compliance with the License.
10 -- You may obtain a copy of the License at
12 -- http://www.apache.org/licenses/LICENSE-2.0
14 -- Unless required by applicable law or agreed to in writing, software
15 -- distributed under the License is distributed on an "AS IS" BASIS,
16 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
17 -- See the License for the specific language governing permissions and
18 -- limitations under the License.
20 -- ECOMP is a trademark and service mark of AT&T Intellectual Property.
21 -- ============LICENSE_END============================================
23 CREATE DATABASE IF NOT EXISTS `sdnctl` /*!40100 DEFAULT CHARACTER SET latin1 */;
26 SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
27 SET @@SESSION.SQL_LOG_BIN= 0;
30 -- Table structure for table `ACTION_LEVEL_REFERENCE`
33 DROP TABLE IF EXISTS `ACTION_LEVEL_REFERENCE`;
34 /*!40101 SET @saved_cs_client = @@character_set_client */;
35 /*!40101 SET character_set_client = utf8 */;
36 CREATE TABLE `ACTION_LEVEL_REFERENCE` (
37 `ACTION_LEVEL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
38 `ACTION_IDENTIFIER` varchar(50) NOT NULL,
39 `ACTION_LEVEL` varchar(50) NOT NULL,
40 UNIQUE KEY `ACTION_LEVEL_REFERENCE_ID` (`ACTION_LEVEL_REFERENCE_ID`)
41 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
42 /*!40101 SET character_set_client = @saved_cs_client */;
45 -- Table structure for table `ASDC_ARTIFACTS`
48 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
49 /*!40101 SET @saved_cs_client = @@character_set_client */;
50 /*!40101 SET character_set_client = utf8 */;
51 CREATE TABLE `ASDC_ARTIFACTS` (
52 `ASDC_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
53 `SERVICE_UUID` varchar(50) DEFAULT NULL,
54 `DISTRIBUTION_ID` varchar(50) DEFAULT NULL,
55 `SERVICE_NAME` varchar(255) DEFAULT NULL,
56 `SERVICE_DESCRIPTION` varchar(255) DEFAULT NULL,
57 `RESOURCE_UUID` varchar(255) DEFAULT NULL,
58 `RESOURCE_INSTANCE_NAME` varchar(255) DEFAULT NULL,
59 `RESOURCE_NAME` varchar(255) DEFAULT NULL,
60 `RESOURCE_VERSION` varchar(50) DEFAULT NULL,
61 `RESOURCE_TYPE` varchar(50) DEFAULT NULL,
62 `ARTIFACT_UUID` varchar(50) DEFAULT NULL,
63 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
64 `ARTIFACT_VERSION` varchar(25) DEFAULT NULL,
65 `ARTIFACT_DESCRIPTION` varchar(255) DEFAULT NULL,
66 `INTERNAL_VERSION` int(11) DEFAULT NULL,
67 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
68 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
69 `ARTIFACT_CONTENT` longtext,
70 PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
71 UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
72 ) ENGINE=InnoDB AUTO_INCREMENT=1412 DEFAULT CHARSET=latin1;
73 /*!40101 SET character_set_client = @saved_cs_client */;
76 -- Table structure for table `ASDC_REFERENCE`
79 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
80 /*!40101 SET @saved_cs_client = @@character_set_client */;
81 /*!40101 SET character_set_client = utf8 */;
82 CREATE TABLE `ASDC_REFERENCE` (
83 `ASDC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
84 `VNF_TYPE` varchar(50) DEFAULT NULL,
85 `VNFC_TYPE` varchar(50) DEFAULT NULL,
86 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
87 `ACTION` varchar(50) DEFAULT NULL,
88 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
89 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
90 PRIMARY KEY (`ASDC_REFERENCE_ID`),
91 UNIQUE KEY `ASDC_REFERENCE_ID` (`ASDC_REFERENCE_ID`)
92 ) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=latin1;
93 /*!40101 SET character_set_client = @saved_cs_client */;
96 -- Table structure for table `CONFIGFILES`
99 DROP TABLE IF EXISTS `CONFIGFILES`;
100 /*!40101 SET @saved_cs_client = @@character_set_client */;
101 /*!40101 SET character_set_client = utf8 */;
102 CREATE TABLE `CONFIGFILES` (
103 `CONFIG_FILE_ID` int(11) NOT NULL AUTO_INCREMENT,
104 `EXTERNAL_VERSION` varchar(50) DEFAULT NULL,
105 `DATA_SOURCE` varchar(25) DEFAULT NULL,
106 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
107 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
108 `VNF_TYPE` varchar(50) DEFAULT NULL,
109 `VNFC_TYPE` varchar(50) DEFAULT NULL,
110 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
111 `FILE_NAME` varchar(255) DEFAULT NULL,
112 `FILE_CONTENT` longtext,
113 `ACTION` varchar(50) DEFAULT NULL,
114 `VNF_ID` varchar(50) DEFAULT NULL,
115 `VM_NAME` varchar(50) DEFAULT NULL,
116 `VNF_NAME` varchar(50) DEFAULT NULL,
117 PRIMARY KEY (`CONFIG_FILE_ID`),
118 UNIQUE KEY `CONFIG_FILE_ID` (`CONFIG_FILE_ID`)
119 ) ENGINE=InnoDB AUTO_INCREMENT=688 DEFAULT CHARSET=latin1;
120 /*!40101 SET character_set_client = @saved_cs_client */;
123 -- Table structure for table `CONFIGURE_ACTION_DG`
126 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
127 /*!40101 SET @saved_cs_client = @@character_set_client */;
128 /*!40101 SET character_set_client = utf8 */;
129 CREATE TABLE `CONFIGURE_ACTION_DG` (
130 `CONFIGURE_ACTION_DG_ID` int(11) NOT NULL AUTO_INCREMENT,
131 `VNF_TYPE` varchar(50) DEFAULT NULL,
132 `ACTION` varchar(50) DEFAULT NULL,
133 `GENERATE_CONFIG_DG` varchar(50) DEFAULT NULL,
134 `DOWNLOAD_CONFIG_DG` varchar(50) DEFAULT NULL,
135 PRIMARY KEY (`CONFIGURE_ACTION_DG_ID`),
136 UNIQUE KEY ` CONFIGURE_ACTION_DG_ID` (`CONFIGURE_ACTION_DG_ID`)
137 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
138 /*!40101 SET character_set_client = @saved_cs_client */;
141 -- Table structure for table `CONFIG_FILE_REFERENCE`
144 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
145 /*!40101 SET @saved_cs_client = @@character_set_client */;
146 /*!40101 SET character_set_client = utf8 */;
147 CREATE TABLE `CONFIG_FILE_REFERENCE` (
148 `CONFIG_FILE_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
149 `SITE_LOCATION` varchar(50) DEFAULT NULL,
150 `VNF_TYPE` varchar(50) DEFAULT NULL,
151 `IMPORT_TYPE` varchar(50) DEFAULT NULL,
152 `FILE_TYPE` varchar(50) DEFAULT NULL,
153 `SOURCE_SERVER_NAME` varchar(255) DEFAULT NULL,
154 `SOURCE_FILE_PATH` varchar(255) DEFAULT NULL,
155 `TARGET_FILE_PATH` varchar(255) DEFAULT NULL,
156 `NAME` varchar(50) DEFAULT NULL,
157 `FILE_NAME` varchar(255) DEFAULT NULL,
158 PRIMARY KEY (`CONFIG_FILE_REFERENCE_ID`),
159 UNIQUE KEY `CONFIG_FILE_REFERENCE_ID` (`CONFIG_FILE_REFERENCE_ID`)
160 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
161 /*!40101 SET character_set_client = @saved_cs_client */;
164 -- Table structure for table `CONFIG_TRANSACTION_LOG`
167 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
168 /*!40101 SET @saved_cs_client = @@character_set_client */;
169 /*!40101 SET character_set_client = utf8 */;
170 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
171 `CONFIG_TRANSACTION_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
172 `REQUEST_ID` varchar(50) DEFAULT NULL,
173 `MESSAGE_TYPE` varchar(50) DEFAULT NULL,
174 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
176 PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
177 UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
178 ) ENGINE=InnoDB AUTO_INCREMENT=1074 DEFAULT CHARSET=latin1;
179 /*!40101 SET character_set_client = @saved_cs_client */;
182 -- Table structure for table `DEVICE_AUTHENTICATION`
185 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
186 /*!40101 SET @saved_cs_client = @@character_set_client */;
187 /*!40101 SET character_set_client = utf8 */;
188 CREATE TABLE `DEVICE_AUTHENTICATION` (
189 `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
190 `VNF_TYPE` varchar(50) DEFAULT NULL,
191 `USER_NAME` varchar(50) DEFAULT NULL,
192 `PASSWORD` varchar(100) DEFAULT NULL,
193 `PORT_NUMBER` int(11) DEFAULT NULL,
194 PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
195 UNIQUE KEY `DEVICE_AUTHENTICATION_ID` (`DEVICE_AUTHENTICATION_ID`)
196 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
197 /*!40101 SET character_set_client = @saved_cs_client */;
200 -- Temporary view structure for view `DEVICE_CONFIGURATION`
203 DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
204 /*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
205 SET @saved_cs_client = @@character_set_client;
206 SET character_set_client = utf8;
207 /*!50001 CREATE VIEW `DEVICE_CONFIGURATION` AS SELECT
208 1 AS `UPLOAD_CONFIG_ID`,
210 1 AS `ORIGINATOR_ID`,
211 1 AS `SERVICE_DESCRIPTION`,
219 1 AS `HOST_IP_ADDRESS`,
220 1 AS `CONFIG_INDICATOR`,
221 1 AS `PENDING_DELETE`,
223 SET character_set_client = @saved_cs_client;
226 -- Table structure for table `DEVICE_INTERFACE_LOG`
229 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
230 /*!40101 SET @saved_cs_client = @@character_set_client */;
231 /*!40101 SET character_set_client = utf8 */;
232 CREATE TABLE `DEVICE_INTERFACE_LOG` (
233 `DEVICE_INTERFACE_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
234 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
235 `REQUEST_ID` varchar(50) DEFAULT NULL,
236 `CREATION_DATE` datetime NOT NULL,
238 PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
239 UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
240 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
241 /*!40101 SET character_set_client = @saved_cs_client */;
244 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
247 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
248 /*!40101 SET @saved_cs_client = @@character_set_client */;
249 /*!40101 SET character_set_client = utf8 */;
250 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
251 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
252 `VNF_TYPE` varchar(50) DEFAULT NULL,
253 `PROTOCOL` varchar(50) DEFAULT NULL,
254 `MODULE` varchar(50) DEFAULT NULL,
255 `DG_RPC` varchar(50) DEFAULT NULL,
256 PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
257 UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`),
258 UNIQUE KEY `VNF_TYPE` (`VNF_TYPE`)
259 ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
260 /*!40101 SET character_set_client = @saved_cs_client */;
263 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
266 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
267 /*!40101 SET @saved_cs_client = @@character_set_client */;
268 /*!40101 SET character_set_client = utf8 */;
269 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
270 `DOWNLOAD_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
271 `VNF_TYPE` varchar(50) NOT NULL,
272 `PROTOCOL` varchar(50) NOT NULL,
274 PRIMARY KEY (`DOWNLOAD_CONFIG_TEMPLATE_ID`),
275 UNIQUE KEY `DOWNLOAD_CONFIG_TEMPLATE_ID` (`DOWNLOAD_CONFIG_TEMPLATE_ID`)
276 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
277 /*!40101 SET character_set_client = @saved_cs_client */;
280 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
283 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
284 /*!40101 SET @saved_cs_client = @@character_set_client */;
285 /*!40101 SET character_set_client = utf8 */;
286 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
287 `DOWNLOAD_DG_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
288 `PROTOCOL` varchar(50) NOT NULL,
289 `DOWNLOAD_CONFIG_DG` varchar(50) NOT NULL,
290 PRIMARY KEY (`DOWNLOAD_DG_REFERENCE_ID`),
291 UNIQUE KEY ` DOWNLOAD_DG_REFERENCE_ID` (`DOWNLOAD_DG_REFERENCE_ID`)
292 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
293 /*!40101 SET character_set_client = @saved_cs_client */;
296 -- Table structure for table `DT_ACTION_STATUS`
299 DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
300 /*!40101 SET @saved_cs_client = @@character_set_client */;
301 /*!40101 SET character_set_client = utf8 */;
302 CREATE TABLE `DT_ACTION_STATUS` (
303 `DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
304 `ACTION` varchar(50) NOT NULL,
305 `VNF_TYPE` varchar(50) DEFAULT NULL,
306 `VNFC_TYPE` varchar(50) DEFAULT NULL,
307 `USER` varchar(50) NOT NULL,
308 `TECHNOLOGY` varchar(50) DEFAULT NULL,
309 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
310 `STATUS` varchar(50) NOT NULL,
311 PRIMARY KEY (`DT_ACTION_STATUS_ID`),
312 UNIQUE KEY `DT_ACTION_STATUS_ID` (`DT_ACTION_STATUS_ID`)
313 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
314 /*!40101 SET character_set_client = @saved_cs_client */;
317 -- Table structure for table `DT_ARTIFACT_REFERENCE`
320 DROP TABLE IF EXISTS `DT_ARTIFACT_REFERENCE`;
321 /*!40101 SET @saved_cs_client = @@character_set_client */;
322 /*!40101 SET character_set_client = utf8 */;
323 CREATE TABLE `DT_ARTIFACT_REFERENCE` (
324 `DT_ARTIFACT_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
325 `PROTOCOL` varchar(50) DEFAULT NULL,
326 `ACTION` varchar(50) DEFAULT NULL,
327 `ARTIFACT_TYPE` varchar(50) NOT NULL,
328 `ARTIFACT_PRIORITY` int(11) NOT NULL,
329 PRIMARY KEY (`DT_ARTIFACT_REFERENCE_ID`),
330 UNIQUE KEY `DT_ARTIFACT_REFERENCE_ID` (`DT_ARTIFACT_REFERENCE_ID`)
331 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
332 /*!40101 SET character_set_client = @saved_cs_client */;
335 -- Table structure for table `DT_ARTIFACT_TRACKING`
338 DROP TABLE IF EXISTS `DT_ARTIFACT_TRACKING`;
339 /*!40101 SET @saved_cs_client = @@character_set_client */;
340 /*!40101 SET character_set_client = utf8 */;
341 CREATE TABLE `DT_ARTIFACT_TRACKING` (
342 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL AUTO_INCREMENT,
343 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
344 `ASDC_REFERENCE_ID` int(11) DEFAULT NULL,
345 `USER` varchar(50) NOT NULL,
346 `TECHNOLOGY` varchar(50) DEFAULT NULL,
347 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
348 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
349 `ARTIFACT_STATUS` varchar(50) NOT NULL,
350 `IN_CART` varchar(50) DEFAULT NULL,
351 `PROTOCOL` varchar(50) DEFAULT NULL,
352 PRIMARY KEY (`DT_ARTIFACT_TRACKING_ID`),
353 UNIQUE KEY `DT_ARTIFACT_TRACKING_ID` (`DT_ARTIFACT_TRACKING_ID`)
354 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
355 /*!40101 SET character_set_client = @saved_cs_client */;
358 -- Table structure for table `DT_GUI_REFERENCE`
361 DROP TABLE IF EXISTS `DT_GUI_REFERENCE`;
362 /*!40101 SET @saved_cs_client = @@character_set_client */;
363 /*!40101 SET character_set_client = utf8 */;
364 CREATE TABLE `DT_GUI_REFERENCE` (
365 `DT_GUI_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
366 `GUI_NAME` varchar(50) NOT NULL,
367 `FIELD_NAME` varchar(50) NOT NULL,
368 `VALUE` varchar(50) NOT NULL,
369 `USER` varchar(50) NOT NULL,
370 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
371 `PROTOCOL` varchar(50) DEFAULT NULL,
372 `ACTION` varchar(50) DEFAULT NULL,
373 PRIMARY KEY (`DT_GUI_REFERENCE_ID`),
374 UNIQUE KEY `DT_GUI_REFERENCE_ID` (`DT_GUI_REFERENCE_ID`)
375 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
376 /*!40101 SET character_set_client = @saved_cs_client */;
379 -- Table structure for table `DT_STATUS_RELATIONSHIP`
382 DROP TABLE IF EXISTS `DT_STATUS_RELATIONSHIP`;
383 /*!40101 SET @saved_cs_client = @@character_set_client */;
384 /*!40101 SET character_set_client = utf8 */;
385 CREATE TABLE `DT_STATUS_RELATIONSHIP` (
386 `DT_STATUS_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
387 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL,
388 `DT_ACTION_STATUS_ID` int(11) NOT NULL,
389 PRIMARY KEY (`DT_STATUS_RELATIONSHIP_ID`),
390 UNIQUE KEY `DT_STATUS_RELATIONSHIP_ID` (`DT_STATUS_RELATIONSHIP_ID`),
391 KEY `IE_DT_STATUS_RELATIONSHIP` (`DT_ARTIFACT_TRACKING_ID`),
392 KEY `IE2_DT_STATUS_RELATIONSHIP` (`DT_ACTION_STATUS_ID`),
393 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,
394 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
395 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
396 /*!40101 SET character_set_client = @saved_cs_client */;
399 -- Table structure for table `GET_CONFIG_TEMPLATE`
402 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
403 /*!40101 SET @saved_cs_client = @@character_set_client */;
404 /*!40101 SET character_set_client = utf8 */;
405 CREATE TABLE `GET_CONFIG_TEMPLATE` (
406 `GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
407 `VNF_TYPE` varchar(50) NOT NULL,
408 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL,
409 `XML_PROCESSING` varchar(1) DEFAULT NULL,
410 `XML_PROTOCOL` varchar(30) DEFAULT NULL,
412 PRIMARY KEY (`GET_CONFIG_TEMPLATE_ID`),
413 UNIQUE KEY `GET_CONFIG_TEMPLATE_ID` (`GET_CONFIG_TEMPLATE_ID`),
414 KEY `get_config_template_ibfk_1` (`DEVICE_INTERFACE_PROTOCOL_ID`),
415 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
416 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
417 /*!40101 SET character_set_client = @saved_cs_client */;
420 -- Table structure for table `MULTISTEP_FLOW_REFERENCE`
423 DROP TABLE IF EXISTS `MULTISTEP_FLOW_REFERENCE`;
424 /*!40101 SET @saved_cs_client = @@character_set_client */;
425 /*!40101 SET character_set_client = utf8 */;
426 CREATE TABLE `MULTISTEP_FLOW_REFERENCE` (
427 `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
428 `ACTION` varchar(50) NOT NULL,
429 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
430 `VNF_TYPE` varchar(50) DEFAULT NULL,
431 `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
432 `CATEGORY` varchar(50) DEFAULT NULL,
433 `GENERATION_NODE` varchar(50) DEFAULT NULL,
434 `EXECUTION_NODE` varchar(50) DEFAULT NULL,
435 `CREATOR` varchar(50) DEFAULT NULL,
436 `UPDATED_DATE` datetime DEFAULT NULL,
437 UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)
438 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
439 /*!40101 SET character_set_client = @saved_cs_client */;
442 -- Table structure for table `NODE_TYPES`
445 DROP TABLE IF EXISTS `NODE_TYPES`;
446 /*!40101 SET @saved_cs_client = @@character_set_client */;
447 /*!40101 SET character_set_client = utf8 */;
448 CREATE TABLE `NODE_TYPES` (
449 `nodetype` varchar(80) NOT NULL,
450 PRIMARY KEY (`nodetype`)
451 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
452 /*!40101 SET character_set_client = @saved_cs_client */;
455 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
458 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
459 /*!40101 SET @saved_cs_client = @@character_set_client */;
460 /*!40101 SET character_set_client = utf8 */;
461 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
462 `PREPARE_FILE_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
463 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
464 `REQUEST_ID` varchar(255) DEFAULT NULL,
465 `CONFIG_FILE_ID` int(11) DEFAULT NULL,
466 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
467 PRIMARY KEY (`PREPARE_FILE_RELATIONSHIP_ID`),
468 UNIQUE KEY `PREPARE_FILE_RELATIONSHIP_ID` (`PREPARE_FILE_RELATIONSHIP_ID`),
469 KEY `ie_prepare_file_relationship` (`CONFIG_FILE_ID`),
470 KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
471 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
472 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
473 ) ENGINE=InnoDB AUTO_INCREMENT=558 DEFAULT CHARSET=latin1;
474 /*!40101 SET character_set_client = @saved_cs_client */;
477 -- Table structure for table `PROCESS_FLOW_REFERENCE`
480 DROP TABLE IF EXISTS `PROCESS_FLOW_REFERENCE`;
481 /*!40101 SET @saved_cs_client = @@character_set_client */;
482 /*!40101 SET character_set_client = utf8 */;
483 CREATE TABLE `PROCESS_FLOW_REFERENCE` (
484 `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
485 `ACTION` varchar(50) NOT NULL,
486 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
487 `PROTOCOL` varchar(50) DEFAULT NULL,
488 `EXECUTION_TYPE` varchar(100) NOT NULL,
489 `EXECUTION_MODULE` varchar(100) NOT NULL,
490 `EXECUTION_RPC` varchar(100) NOT NULL,
491 `UPDATED_DATE` datetime DEFAULT NULL,
492 `GET_RUNNING_CONFIG` varchar(50) DEFAULT NULL,
493 PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),
494 UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)
495 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
496 /*!40101 SET character_set_client = @saved_cs_client */;
499 -- Table structure for table `PROTOCOL_REFERENCE`
502 DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
503 /*!40101 SET @saved_cs_client = @@character_set_client */;
504 /*!40101 SET character_set_client = utf8 */;
505 CREATE TABLE `PROTOCOL_REFERENCE` (
506 `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
507 `ACTION` varchar(50) NOT NULL,
508 `VNF_TYPE` varchar(50) DEFAULT NULL,
509 `PROTOCOL` varchar(50) DEFAULT NULL,
510 `UPDATED_DATE` datetime DEFAULT NULL,
511 `TEMPLATE` varchar(45) DEFAULT NULL,
512 `ACTION_LEVEL` varchar(45) DEFAULT NULL,
513 PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
514 UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
515 ) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;
516 /*!40101 SET character_set_client = @saved_cs_client */;
519 -- Table structure for table `REQUEST_ARTIFACTS`
522 DROP TABLE IF EXISTS `REQUEST_ARTIFACTS`;
523 /*!40101 SET @saved_cs_client = @@character_set_client */;
524 /*!40101 SET character_set_client = utf8 */;
525 CREATE TABLE `REQUEST_ARTIFACTS` (
526 `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
527 `REQUEST_ID` varchar(50) NOT NULL,
528 `ACTION` varchar(50) NOT NULL,
529 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
530 `VNF_TYPE` varchar(50) DEFAULT NULL,
531 `CATEGORY` varchar(50) NOT NULL,
532 `ARTIFACT_CONTENT` longtext,
533 `UPDATED_DATE` datetime DEFAULT NULL,
534 PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
535 UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
536 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
537 /*!40101 SET character_set_client = @saved_cs_client */;
540 -- Table structure for table `SVC_LOGIC`
543 DROP TABLE IF EXISTS `SVC_LOGIC`;
544 /*!40101 SET @saved_cs_client = @@character_set_client */;
545 /*!40101 SET character_set_client = utf8 */;
546 CREATE TABLE `SVC_LOGIC` (
547 `module` varchar(80) NOT NULL,
548 `rpc` varchar(80) NOT NULL,
549 `version` varchar(40) NOT NULL,
550 `mode` varchar(5) NOT NULL,
551 `active` varchar(1) NOT NULL,
553 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
554 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
555 /*!40101 SET character_set_client = @saved_cs_client */;
558 -- Table structure for table `UPLOAD_CONFIG`
561 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
562 /*!40101 SET @saved_cs_client = @@character_set_client */;
563 /*!40101 SET character_set_client = utf8 */;
564 CREATE TABLE `UPLOAD_CONFIG` (
565 `UPLOAD_CONFIG_ID` int(11) NOT NULL AUTO_INCREMENT,
566 `REQUEST_ID` varchar(50) DEFAULT NULL,
567 `ORIGINATOR_ID` varchar(50) DEFAULT NULL,
568 `SERVICE_DESCRIPTION` varchar(100) DEFAULT NULL,
569 `ACTION` varchar(50) DEFAULT NULL,
570 `UPLOAD_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
571 `VNF_ID` varchar(50) DEFAULT NULL,
572 `VNF_NAME` varchar(50) DEFAULT NULL,
573 `VM_NAME` varchar(50) DEFAULT NULL,
574 `VNF_TYPE` varchar(50) DEFAULT NULL,
575 `VNFC_TYPE` varchar(50) DEFAULT NULL,
576 `HOST_IP_ADDRESS` varchar(50) DEFAULT NULL,
577 `CONFIG_INDICATOR` varchar(25) DEFAULT NULL,
578 `PENDING_DELETE` varchar(1) DEFAULT NULL,
580 PRIMARY KEY (`UPLOAD_CONFIG_ID`),
581 UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
582 ) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=latin1;
583 /*!40101 SET character_set_client = @saved_cs_client */;
586 -- Table structure for table `VNFC_DG_MAPPING`
589 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
590 /*!40101 SET @saved_cs_client = @@character_set_client */;
591 /*!40101 SET character_set_client = utf8 */;
592 CREATE TABLE `VNFC_DG_MAPPING` (
593 `ACTION` varchar(50) DEFAULT NULL,
594 `API_VERSION` varchar(10) DEFAULT NULL,
595 `VNF_TYPE` varchar(50) DEFAULT NULL,
596 `VNFC_TYPE` varchar(50) DEFAULT NULL,
597 `DG_NAME` varchar(50) NOT NULL,
598 `DG_VERSION` varchar(50) DEFAULT NULL,
599 `DG_MODULE` varchar(50) NOT NULL,
600 UNIQUE KEY `INPUT_CONSTRAINT` (`ACTION`,`API_VERSION`,`VNF_TYPE`,`VNFC_TYPE`)
601 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
602 /*!40101 SET character_set_client = @saved_cs_client */;
605 -- Table structure for table `VNFC_REFERENCE`
608 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
609 /*!40101 SET @saved_cs_client = @@character_set_client */;
610 /*!40101 SET character_set_client = utf8 */;
611 CREATE TABLE `VNFC_REFERENCE` (
612 `VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
613 `ACTION` varchar(50) NOT NULL,
614 `VNF_TYPE` varchar(50) NOT NULL,
615 `VM_INSTANCE` int(11) NOT NULL,
616 `VNFC_INSTANCE` int(11) NOT NULL,
617 `VNFC_TYPE` varchar(50) NOT NULL,
618 `VNFC_FUNCTION_CODE` varchar(50) NOT NULL,
619 `IPADDRESS_V4_OAM_VIP` varchar(50) DEFAULT NULL,
620 `TEMPLATE_ID` varchar(100) DEFAULT NULL,
621 `GROUP_NOTATION_TYPE` varchar(50) DEFAULT NULL,
622 `GROUP_NOTATION_VALUE` varchar(50) DEFAULT NULL,
623 PRIMARY KEY (`VNFC_REFERENCE_ID`),
624 UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
625 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
626 /*!40101 SET character_set_client = @saved_cs_client */;
629 -- Table structure for table `VNF_DG_MAPPING`
632 DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
633 /*!40101 SET @saved_cs_client = @@character_set_client */;
634 /*!40101 SET character_set_client = utf8 */;
635 CREATE TABLE `VNF_DG_MAPPING` (
636 `action` varchar(50) NOT NULL,
637 `api_version` varchar(50) DEFAULT NULL,
638 `vnf_type` varchar(50) DEFAULT NULL,
639 `vnf_version` varchar(50) DEFAULT NULL,
640 `dg_name` varchar(50) NOT NULL,
641 `dg_version` varchar(50) DEFAULT NULL,
642 `dg_module` varchar(50) NOT NULL,
643 UNIQUE KEY `INPUT_CONSTRAINT` (`action`,`api_version`,`vnf_type`,`vnf_version`)
644 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
645 /*!40101 SET character_set_client = @saved_cs_client */;
648 -- Table structure for table `VNF_LOCK_MANAGEMENT`
651 DROP TABLE IF EXISTS `VNF_LOCK_MANAGEMENT`;
652 /*!40101 SET @saved_cs_client = @@character_set_client */;
653 /*!40101 SET character_set_client = utf8 */;
654 CREATE TABLE `VNF_LOCK_MANAGEMENT` (
655 `RESOURCE_ID` varchar(50) NOT NULL,
656 `OWNER_ID` varchar(50) DEFAULT NULL,
657 `UPDATED` bigint(20) unsigned NOT NULL,
658 `TIMEOUT` int(10) unsigned NOT NULL,
659 `VER` int(10) unsigned NOT NULL DEFAULT '1',
660 PRIMARY KEY (`RESOURCE_ID`)
661 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
662 /*!40101 SET character_set_client = @saved_cs_client */;
665 -- Table structure for table `VNF_STATE_MANAGEMENT`
668 DROP TABLE IF EXISTS `VNF_STATE_MANAGEMENT`;
669 /*!40101 SET @saved_cs_client = @@character_set_client */;
670 /*!40101 SET character_set_client = utf8 */;
671 CREATE TABLE `VNF_STATE_MANAGEMENT` (
672 `VNF_ID` varchar(50) NOT NULL,
673 `STATE` varchar(50) NOT NULL,
674 `OWNER_ID` varchar(255) DEFAULT NULL,
675 `UPDATED` bigint(20) unsigned NOT NULL,
676 `VER` int(10) unsigned NOT NULL DEFAULT '1',
677 PRIMARY KEY (`VNF_ID`)
678 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
680 DROP TABLE IF EXISTS `TRANSACTIONS`;
681 CREATE TABLE `TRANSACTIONS` (
682 `TRANSACTION_ID` varchar(75) NOT NULL,
683 `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
684 `REQUEST_ID` varchar(256) NOT NULL,
685 `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
686 `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
687 `START_TIME` datetime(3) NOT NULL,
688 `END_TIME` datetime(3) DEFAULT NULL,
689 `TARGET_ID` varchar(256) ,
690 `TARGET_TYPE` varchar(256) DEFAULT NULL,
691 `OPERATION` varchar(256) NOT NULL,
692 `RESULT_CODE` int(11) DEFAULT NULL,
694 `STATE` varchar(50) NOT NULL,
695 `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
696 `VNFC_NAME` varchar(256) DEFAULT NULL,
697 `VSERVER_ID` varchar(256) DEFAULT NULL,
698 `VF_MODULE_ID` varchar(256) DEFAULT NULL,
699 `MODE` varchar(50) NOT NULL,
700 PRIMARY KEY (`TRANSACTION_ID`)
701 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
704 SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;