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 `APPC_AUTHENTICATION`
48 DROP TABLE IF EXISTS `APPC_AUTHENTICATION`;
49 /*!40101 SET @saved_cs_client = @@character_set_client */;
50 /*!40101 SET character_set_client = utf8 */;
51 CREATE TABLE `APPC_AUTHENTICATION` (
52 `APPC_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
53 `VNF_TYPE` varchar(255) DEFAULT NULL,
54 `PROTOCOL` varchar(255) DEFAULT NULL,
55 `ACTION` varchar(255) DEFAULT NULL,
56 `USER_NAME` varchar(255) DEFAULT NULL,
57 `PASSWORD` varchar(255) DEFAULT NULL,
58 `PORT_NUMBER` int(11) DEFAULT NULL,
59 `URL` varchar(1024) DEFAULT NULL,
60 PRIMARY KEY (`APPC_AUTHENTICATION_ID`),
61 UNIQUE KEY `VNF_TYPE` (`VNF_TYPE`),
62 KEY `PROTOCOL` (`PROTOCOL`),
63 KEY `ACTION` (`ACTION`)
64 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
65 /*!40101 SET character_set_client = @saved_cs_client */;
68 -- Table structure for table `ASDC_ARTIFACTS`
71 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
72 /*!40101 SET @saved_cs_client = @@character_set_client */;
73 /*!40101 SET character_set_client = utf8 */;
74 CREATE TABLE `ASDC_ARTIFACTS` (
75 `ASDC_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
76 `SERVICE_UUID` varchar(50) DEFAULT NULL,
77 `DISTRIBUTION_ID` varchar(50) DEFAULT NULL,
78 `SERVICE_NAME` varchar(255) DEFAULT NULL,
79 `SERVICE_DESCRIPTION` varchar(255) DEFAULT NULL,
80 `RESOURCE_UUID` varchar(255) DEFAULT NULL,
81 `RESOURCE_INSTANCE_NAME` varchar(255) DEFAULT NULL,
82 `RESOURCE_NAME` varchar(255) DEFAULT NULL,
83 `RESOURCE_VERSION` varchar(50) DEFAULT NULL,
84 `RESOURCE_TYPE` varchar(50) DEFAULT NULL,
85 `ARTIFACT_UUID` varchar(50) DEFAULT NULL,
86 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
87 `ARTIFACT_VERSION` varchar(25) DEFAULT NULL,
88 `ARTIFACT_DESCRIPTION` varchar(255) DEFAULT NULL,
89 `INTERNAL_VERSION` int(11) DEFAULT NULL,
90 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
91 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
92 `ARTIFACT_CONTENT` longtext,
93 PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
94 UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
95 ) ENGINE=InnoDB AUTO_INCREMENT=1412 DEFAULT CHARSET=latin1;
96 /*!40101 SET character_set_client = @saved_cs_client */;
99 -- Table structure for table `ASDC_REFERENCE`
102 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
103 /*!40101 SET @saved_cs_client = @@character_set_client */;
104 /*!40101 SET character_set_client = utf8 */;
105 CREATE TABLE `ASDC_REFERENCE` (
106 `ASDC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
107 `VNF_TYPE` varchar(150) DEFAULT NULL,
108 `VNFC_TYPE` varchar(50) DEFAULT NULL,
109 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
110 `ACTION` varchar(50) DEFAULT NULL,
111 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
112 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
113 PRIMARY KEY (`ASDC_REFERENCE_ID`),
114 UNIQUE KEY `ASDC_REFERENCE_ID` (`ASDC_REFERENCE_ID`)
115 ) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=latin1;
116 /*!40101 SET character_set_client = @saved_cs_client */;
119 -- Table structure for table `CONFIGFILES`
122 DROP TABLE IF EXISTS `CONFIGFILES`;
123 /*!40101 SET @saved_cs_client = @@character_set_client */;
124 /*!40101 SET character_set_client = utf8 */;
125 CREATE TABLE `CONFIGFILES` (
126 `CONFIG_FILE_ID` int(11) NOT NULL AUTO_INCREMENT,
127 `EXTERNAL_VERSION` varchar(50) DEFAULT NULL,
128 `DATA_SOURCE` varchar(25) DEFAULT NULL,
129 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
130 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
131 `VNF_TYPE` varchar(150) DEFAULT NULL,
132 `VNFC_TYPE` varchar(50) DEFAULT NULL,
133 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
134 `FILE_NAME` varchar(255) DEFAULT NULL,
135 `FILE_CONTENT` longtext,
136 `ACTION` varchar(50) DEFAULT NULL,
137 `VNF_ID` varchar(50) DEFAULT NULL,
138 `VM_NAME` varchar(50) DEFAULT NULL,
139 `VNF_NAME` varchar(50) DEFAULT NULL,
140 PRIMARY KEY (`CONFIG_FILE_ID`),
141 UNIQUE KEY `CONFIG_FILE_ID` (`CONFIG_FILE_ID`)
142 ) ENGINE=InnoDB AUTO_INCREMENT=688 DEFAULT CHARSET=latin1;
143 /*!40101 SET character_set_client = @saved_cs_client */;
146 -- Table structure for table `CONFIGURE_ACTION_DG`
149 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
150 /*!40101 SET @saved_cs_client = @@character_set_client */;
151 /*!40101 SET character_set_client = utf8 */;
152 CREATE TABLE `CONFIGURE_ACTION_DG` (
153 `CONFIGURE_ACTION_DG_ID` int(11) NOT NULL AUTO_INCREMENT,
154 `VNF_TYPE` varchar(150) DEFAULT NULL,
155 `ACTION` varchar(50) DEFAULT NULL,
156 `GENERATE_CONFIG_DG` varchar(50) DEFAULT NULL,
157 `DOWNLOAD_CONFIG_DG` varchar(50) DEFAULT NULL,
158 PRIMARY KEY (`CONFIGURE_ACTION_DG_ID`),
159 UNIQUE KEY ` CONFIGURE_ACTION_DG_ID` (`CONFIGURE_ACTION_DG_ID`)
160 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
161 /*!40101 SET character_set_client = @saved_cs_client */;
164 -- Table structure for table `CONFIG_FILE_REFERENCE`
167 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
168 /*!40101 SET @saved_cs_client = @@character_set_client */;
169 /*!40101 SET character_set_client = utf8 */;
170 CREATE TABLE `CONFIG_FILE_REFERENCE` (
171 `CONFIG_FILE_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
172 `SITE_LOCATION` varchar(50) DEFAULT NULL,
173 `VNF_TYPE` varchar(150) DEFAULT NULL,
174 `IMPORT_TYPE` varchar(50) DEFAULT NULL,
175 `FILE_TYPE` varchar(50) DEFAULT NULL,
176 `SOURCE_SERVER_NAME` varchar(255) DEFAULT NULL,
177 `SOURCE_FILE_PATH` varchar(255) DEFAULT NULL,
178 `TARGET_FILE_PATH` varchar(255) DEFAULT NULL,
179 `NAME` varchar(50) DEFAULT NULL,
180 `FILE_NAME` varchar(255) DEFAULT NULL,
181 PRIMARY KEY (`CONFIG_FILE_REFERENCE_ID`),
182 UNIQUE KEY `CONFIG_FILE_REFERENCE_ID` (`CONFIG_FILE_REFERENCE_ID`)
183 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
184 /*!40101 SET character_set_client = @saved_cs_client */;
187 -- Table structure for table `CONFIG_TRANSACTION_LOG`
190 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
191 /*!40101 SET @saved_cs_client = @@character_set_client */;
192 /*!40101 SET character_set_client = utf8 */;
193 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
194 `CONFIG_TRANSACTION_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
195 `REQUEST_ID` varchar(50) DEFAULT NULL,
196 `MESSAGE_TYPE` varchar(50) DEFAULT NULL,
197 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
199 PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
200 UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
201 ) ENGINE=InnoDB AUTO_INCREMENT=7872 DEFAULT CHARSET=latin1;
202 /*!40101 SET character_set_client = @saved_cs_client */;
205 -- Table structure for table `DEVICE_AUTHENTICATION`
208 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
209 /*!40101 SET @saved_cs_client = @@character_set_client */;
210 /*!40101 SET character_set_client = utf8 */;
211 CREATE TABLE `DEVICE_AUTHENTICATION` (
212 `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
213 `VNF_TYPE` varchar(150) DEFAULT NULL,
214 `PROTOCOL` varchar(150) DEFAULT NULL,
215 `ACTION` varchar(150) DEFAULT NULL,
216 `USER_NAME` varchar(50) DEFAULT NULL,
217 `PASSWORD` varchar(100) DEFAULT NULL,
218 `PORT_NUMBER` int(11) DEFAULT NULL,
219 `URL` varchar(150) DEFAULT NULL,
220 PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
221 UNIQUE KEY `DEVICE_AUTHENTICATION_ID` (`DEVICE_AUTHENTICATION_ID`)
222 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
223 /*!40101 SET character_set_client = @saved_cs_client */;
226 -- Temporary view structure for view `DEVICE_CONFIGURATION`
229 DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
230 /*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
231 SET @saved_cs_client = @@character_set_client;
232 SET character_set_client = utf8;
233 /*!50001 CREATE VIEW `DEVICE_CONFIGURATION` AS SELECT
234 1 AS `UPLOAD_CONFIG_ID`,
236 1 AS `ORIGINATOR_ID`,
237 1 AS `SERVICE_DESCRIPTION`,
245 1 AS `HOST_IP_ADDRESS`,
246 1 AS `CONFIG_INDICATOR`,
247 1 AS `PENDING_DELETE`,
249 SET character_set_client = @saved_cs_client;
252 -- Table structure for table `DEVICE_INTERFACE_LOG`
255 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
256 /*!40101 SET @saved_cs_client = @@character_set_client */;
257 /*!40101 SET character_set_client = utf8 */;
258 CREATE TABLE `DEVICE_INTERFACE_LOG` (
259 `DEVICE_INTERFACE_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
260 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
261 `REQUEST_ID` varchar(50) DEFAULT NULL,
262 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
264 PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
265 UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
266 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
267 /*!40101 SET character_set_client = @saved_cs_client */;
270 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
273 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
274 /*!40101 SET @saved_cs_client = @@character_set_client */;
275 /*!40101 SET character_set_client = utf8 */;
276 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
277 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
278 `VNF_TYPE` varchar(150) DEFAULT NULL,
279 `PROTOCOL` varchar(50) DEFAULT NULL,
280 `MODULE` varchar(50) DEFAULT NULL,
281 `DG_RPC` varchar(50) DEFAULT NULL,
282 PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
283 UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`),
284 UNIQUE KEY `VNF_TYPE` (`VNF_TYPE`)
285 ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
286 /*!40101 SET character_set_client = @saved_cs_client */;
289 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
292 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
293 /*!40101 SET @saved_cs_client = @@character_set_client */;
294 /*!40101 SET character_set_client = utf8 */;
295 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
296 `DOWNLOAD_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
297 `VNF_TYPE` varchar(150) DEFAULT NULL,
298 `PROTOCOL` varchar(50) NOT NULL,
300 PRIMARY KEY (`DOWNLOAD_CONFIG_TEMPLATE_ID`),
301 UNIQUE KEY `DOWNLOAD_CONFIG_TEMPLATE_ID` (`DOWNLOAD_CONFIG_TEMPLATE_ID`)
302 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
303 /*!40101 SET character_set_client = @saved_cs_client */;
306 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
309 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
310 /*!40101 SET @saved_cs_client = @@character_set_client */;
311 /*!40101 SET character_set_client = utf8 */;
312 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
313 `DOWNLOAD_DG_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
314 `PROTOCOL` varchar(50) NOT NULL,
315 `DOWNLOAD_CONFIG_DG` varchar(50) NOT NULL,
316 PRIMARY KEY (`DOWNLOAD_DG_REFERENCE_ID`),
317 UNIQUE KEY ` DOWNLOAD_DG_REFERENCE_ID` (`DOWNLOAD_DG_REFERENCE_ID`)
318 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
319 /*!40101 SET character_set_client = @saved_cs_client */;
322 -- Table structure for table `DT_ACTION_STATUS`
325 DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
326 /*!40101 SET @saved_cs_client = @@character_set_client */;
327 /*!40101 SET character_set_client = utf8 */;
328 CREATE TABLE `DT_ACTION_STATUS` (
329 `DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
330 `ACTION` varchar(50) NOT NULL,
331 `VNF_TYPE` varchar(150) DEFAULT NULL,
332 `VNFC_TYPE` varchar(50) DEFAULT NULL,
333 `USER` varchar(50) NOT NULL,
334 `TECHNOLOGY` varchar(50) DEFAULT NULL,
335 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
336 `STATUS` varchar(50) NOT NULL,
337 PRIMARY KEY (`DT_ACTION_STATUS_ID`),
338 UNIQUE KEY `DT_ACTION_STATUS_ID` (`DT_ACTION_STATUS_ID`)
339 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
340 /*!40101 SET character_set_client = @saved_cs_client */;
343 -- Table structure for table `DT_ARTIFACT_REFERENCE`
346 DROP TABLE IF EXISTS `DT_ARTIFACT_REFERENCE`;
347 /*!40101 SET @saved_cs_client = @@character_set_client */;
348 /*!40101 SET character_set_client = utf8 */;
349 CREATE TABLE `DT_ARTIFACT_REFERENCE` (
350 `DT_ARTIFACT_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
351 `PROTOCOL` varchar(50) DEFAULT NULL,
352 `ACTION` varchar(50) DEFAULT NULL,
353 `ARTIFACT_TYPE` varchar(50) NOT NULL,
354 `ARTIFACT_PRIORITY` int(11) NOT NULL,
355 PRIMARY KEY (`DT_ARTIFACT_REFERENCE_ID`),
356 UNIQUE KEY `DT_ARTIFACT_REFERENCE_ID` (`DT_ARTIFACT_REFERENCE_ID`)
357 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
358 /*!40101 SET character_set_client = @saved_cs_client */;
361 -- Table structure for table `DT_ARTIFACT_TRACKING`
364 DROP TABLE IF EXISTS `DT_ARTIFACT_TRACKING`;
365 /*!40101 SET @saved_cs_client = @@character_set_client */;
366 /*!40101 SET character_set_client = utf8 */;
367 CREATE TABLE `DT_ARTIFACT_TRACKING` (
368 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL AUTO_INCREMENT,
369 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
370 `ASDC_REFERENCE_ID` int(11) DEFAULT NULL,
371 `USER` varchar(50) NOT NULL,
372 `TECHNOLOGY` varchar(50) DEFAULT NULL,
373 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
374 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
375 `ARTIFACT_STATUS` varchar(50) NOT NULL,
376 `IN_CART` varchar(50) DEFAULT NULL,
377 `PROTOCOL` varchar(50) DEFAULT NULL,
378 PRIMARY KEY (`DT_ARTIFACT_TRACKING_ID`),
379 UNIQUE KEY `DT_ARTIFACT_TRACKING_ID` (`DT_ARTIFACT_TRACKING_ID`)
380 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
381 /*!40101 SET character_set_client = @saved_cs_client */;
384 -- Table structure for table `DT_GUI_REFERENCE`
387 DROP TABLE IF EXISTS `DT_GUI_REFERENCE`;
388 /*!40101 SET @saved_cs_client = @@character_set_client */;
389 /*!40101 SET character_set_client = utf8 */;
390 CREATE TABLE `DT_GUI_REFERENCE` (
391 `DT_GUI_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
392 `GUI_NAME` varchar(50) NOT NULL,
393 `FIELD_NAME` varchar(50) NOT NULL,
394 `VALUE` varchar(50) NOT NULL,
395 `USER` varchar(50) NOT NULL,
396 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
397 `PROTOCOL` varchar(50) DEFAULT NULL,
398 `ACTION` varchar(50) DEFAULT NULL,
399 PRIMARY KEY (`DT_GUI_REFERENCE_ID`),
400 UNIQUE KEY `DT_GUI_REFERENCE_ID` (`DT_GUI_REFERENCE_ID`)
401 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
402 /*!40101 SET character_set_client = @saved_cs_client */;
405 -- Table structure for table `DT_STATUS_RELATIONSHIP`
408 DROP TABLE IF EXISTS `DT_STATUS_RELATIONSHIP`;
409 /*!40101 SET @saved_cs_client = @@character_set_client */;
410 /*!40101 SET character_set_client = utf8 */;
411 CREATE TABLE `DT_STATUS_RELATIONSHIP` (
412 `DT_STATUS_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
413 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL,
414 `DT_ACTION_STATUS_ID` int(11) NOT NULL,
415 PRIMARY KEY (`DT_STATUS_RELATIONSHIP_ID`),
416 UNIQUE KEY `DT_STATUS_RELATIONSHIP_ID` (`DT_STATUS_RELATIONSHIP_ID`),
417 KEY `IE_DT_STATUS_RELATIONSHIP` (`DT_ARTIFACT_TRACKING_ID`),
418 KEY `IE2_DT_STATUS_RELATIONSHIP` (`DT_ACTION_STATUS_ID`),
419 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,
420 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
421 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
422 /*!40101 SET character_set_client = @saved_cs_client */;
425 -- Table structure for table `GET_CONFIG_TEMPLATE`
428 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
429 /*!40101 SET @saved_cs_client = @@character_set_client */;
430 /*!40101 SET character_set_client = utf8 */;
431 CREATE TABLE `GET_CONFIG_TEMPLATE` (
432 `GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
433 `VNF_TYPE` varchar(150) DEFAULT NULL,
434 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL,
435 `XML_PROCESSING` varchar(1) DEFAULT NULL,
436 `XML_PROTOCOL` varchar(30) DEFAULT NULL,
438 PRIMARY KEY (`GET_CONFIG_TEMPLATE_ID`),
439 UNIQUE KEY `GET_CONFIG_TEMPLATE_ID` (`GET_CONFIG_TEMPLATE_ID`),
440 KEY `get_config_template_ibfk_1` (`DEVICE_INTERFACE_PROTOCOL_ID`),
441 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
442 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
443 /*!40101 SET character_set_client = @saved_cs_client */;
446 -- Table structure for table `MULTISTEP_FLOW_REFERENCE`
449 DROP TABLE IF EXISTS `MULTISTEP_FLOW_REFERENCE`;
450 /*!40101 SET @saved_cs_client = @@character_set_client */;
451 /*!40101 SET character_set_client = utf8 */;
452 CREATE TABLE `MULTISTEP_FLOW_REFERENCE` (
453 `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
454 `ACTION` varchar(50) NOT NULL,
455 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
456 `VNF_TYPE` varchar(150) DEFAULT NULL,
457 `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
458 `CATEGORY` varchar(50) DEFAULT NULL,
459 `GENERATION_NODE` varchar(50) DEFAULT NULL,
460 `EXECUTION_NODE` varchar(50) DEFAULT NULL,
461 `CREATOR` varchar(50) DEFAULT NULL,
462 `UPDATED_DATE` datetime DEFAULT NULL,
463 UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)
464 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
465 /*!40101 SET character_set_client = @saved_cs_client */;
468 -- Table structure for table `NODE_TYPES`
471 DROP TABLE IF EXISTS `NODE_TYPES`;
472 /*!40101 SET @saved_cs_client = @@character_set_client */;
473 /*!40101 SET character_set_client = utf8 */;
474 CREATE TABLE `NODE_TYPES` (
475 `nodetype` varchar(80) NOT NULL,
476 PRIMARY KEY (`nodetype`)
477 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
478 /*!40101 SET character_set_client = @saved_cs_client */;
481 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
484 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
485 /*!40101 SET @saved_cs_client = @@character_set_client */;
486 /*!40101 SET character_set_client = utf8 */;
487 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
488 `PREPARE_FILE_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
489 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
490 `REQUEST_ID` varchar(255) DEFAULT NULL,
491 `CONFIG_FILE_ID` int(11) DEFAULT NULL,
492 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
493 PRIMARY KEY (`PREPARE_FILE_RELATIONSHIP_ID`),
494 UNIQUE KEY `PREPARE_FILE_RELATIONSHIP_ID` (`PREPARE_FILE_RELATIONSHIP_ID`),
495 KEY `ie_prepare_file_relationship` (`CONFIG_FILE_ID`),
496 KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
497 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
498 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
499 ) ENGINE=InnoDB AUTO_INCREMENT=558 DEFAULT CHARSET=latin1;
500 /*!40101 SET character_set_client = @saved_cs_client */;
503 -- Table structure for table `PROCESS_FLOW_REFERENCE`
506 DROP TABLE IF EXISTS `PROCESS_FLOW_REFERENCE`;
507 /*!40101 SET @saved_cs_client = @@character_set_client */;
508 /*!40101 SET character_set_client = utf8 */;
509 CREATE TABLE `PROCESS_FLOW_REFERENCE` (
510 `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
511 `ACTION` varchar(50) NOT NULL,
512 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
513 `PROTOCOL` varchar(50) DEFAULT NULL,
514 `EXECUTION_TYPE` varchar(100) NOT NULL,
515 `EXECUTION_MODULE` varchar(100) NOT NULL,
516 `EXECUTION_RPC` varchar(100) NOT NULL,
517 `UPDATED_DATE` datetime DEFAULT NULL,
518 `GET_RUNNING_CONFIG` varchar(50) DEFAULT NULL,
519 PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),
520 UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)
521 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
522 /*!40101 SET character_set_client = @saved_cs_client */;
525 -- Table structure for table `PROTOCOL_REFERENCE`
528 DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
529 /*!40101 SET @saved_cs_client = @@character_set_client */;
530 /*!40101 SET character_set_client = utf8 */;
531 CREATE TABLE `PROTOCOL_REFERENCE` (
532 `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
533 `ACTION` varchar(50) NOT NULL,
534 `VNF_TYPE` varchar(150) DEFAULT NULL,
535 `PROTOCOL` varchar(50) DEFAULT NULL,
536 `UPDATED_DATE` datetime DEFAULT NULL,
537 `TEMPLATE` varchar(45) DEFAULT NULL,
538 `ACTION_LEVEL` varchar(45) DEFAULT NULL,
539 PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
540 UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
541 ) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;
542 /*!40101 SET character_set_client = @saved_cs_client */;
545 -- Table structure for table `REQUEST_ARTIFACTS`
548 DROP TABLE IF EXISTS `REQUEST_ARTIFACTS`;
549 /*!40101 SET @saved_cs_client = @@character_set_client */;
550 /*!40101 SET character_set_client = utf8 */;
551 CREATE TABLE `REQUEST_ARTIFACTS` (
552 `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
553 `REQUEST_ID` varchar(50) NOT NULL,
554 `ACTION` varchar(50) NOT NULL,
555 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
556 `VNF_TYPE` varchar(150) DEFAULT NULL,
557 `CATEGORY` varchar(50) NOT NULL,
558 `ARTIFACT_CONTENT` longtext,
559 `UPDATED_DATE` datetime DEFAULT NULL,
560 PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
561 UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
562 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
563 /*!40101 SET character_set_client = @saved_cs_client */;
566 -- Table structure for table `SVC_LOGIC`
569 DROP TABLE IF EXISTS `SVC_LOGIC`;
570 /*!40101 SET @saved_cs_client = @@character_set_client */;
571 /*!40101 SET character_set_client = utf8 */;
572 CREATE TABLE `SVC_LOGIC` (
573 `module` varchar(80) NOT NULL,
574 `rpc` varchar(80) NOT NULL,
575 `version` varchar(40) NOT NULL,
576 `mode` varchar(5) NOT NULL,
577 `active` varchar(1) NOT NULL,
579 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
580 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
581 /*!40101 SET character_set_client = @saved_cs_client */;
584 -- Table structure for table `TRANSACTIONS`
587 DROP TABLE IF EXISTS `TRANSACTIONS`;
588 /*!40101 SET @saved_cs_client = @@character_set_client */;
589 /*!40101 SET character_set_client = utf8 */;
590 CREATE TABLE `TRANSACTIONS` (
591 `TRANSACTION_ID` varchar(75) NOT NULL,
592 `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
593 `REQUEST_ID` varchar(256) NOT NULL,
594 `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
595 `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
596 `START_TIME` datetime(3) NOT NULL,
597 `END_TIME` datetime(3) DEFAULT NULL,
598 `TARGET_ID` varchar(256) DEFAULT NULL,
599 `TARGET_TYPE` varchar(256) DEFAULT NULL,
600 `OPERATION` varchar(256) NOT NULL,
601 `RESULT_CODE` int(11) DEFAULT NULL,
603 `STATE` varchar(50) NOT NULL,
604 `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
605 `VNFC_NAME` varchar(256) DEFAULT NULL,
606 `VSERVER_ID` varchar(256) DEFAULT NULL,
607 `VF_MODULE_ID` varchar(256) DEFAULT NULL,
608 `MODE` varchar(50) NOT NULL,
609 PRIMARY KEY (`TRANSACTION_ID`)
610 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
611 /*!40101 SET character_set_client = @saved_cs_client */;
614 -- Table structure for table `UPLOAD_CONFIG`
617 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
618 /*!40101 SET @saved_cs_client = @@character_set_client */;
619 /*!40101 SET character_set_client = utf8 */;
620 CREATE TABLE `UPLOAD_CONFIG` (
621 `UPLOAD_CONFIG_ID` int(11) NOT NULL AUTO_INCREMENT,
622 `REQUEST_ID` varchar(50) DEFAULT NULL,
623 `ORIGINATOR_ID` varchar(50) DEFAULT NULL,
624 `SERVICE_DESCRIPTION` varchar(100) DEFAULT NULL,
625 `ACTION` varchar(50) DEFAULT NULL,
626 `UPLOAD_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
627 `VNF_ID` varchar(50) DEFAULT NULL,
628 `VNF_NAME` varchar(50) DEFAULT NULL,
629 `VM_NAME` varchar(50) DEFAULT NULL,
630 `VNF_TYPE` varchar(150) DEFAULT NULL,
631 `VNFC_TYPE` varchar(50) DEFAULT NULL,
632 `HOST_IP_ADDRESS` varchar(50) DEFAULT NULL,
633 `CONFIG_INDICATOR` varchar(25) DEFAULT NULL,
634 `PENDING_DELETE` varchar(1) DEFAULT NULL,
636 PRIMARY KEY (`UPLOAD_CONFIG_ID`),
637 UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
638 ) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=latin1;
639 /*!40101 SET character_set_client = @saved_cs_client */;
642 -- Table structure for table `VNFC_DG_MAPPING`
645 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
646 /*!40101 SET @saved_cs_client = @@character_set_client */;
647 /*!40101 SET character_set_client = utf8 */;
648 CREATE TABLE `VNFC_DG_MAPPING` (
649 `ACTION` varchar(50) DEFAULT NULL,
650 `API_VERSION` varchar(10) DEFAULT NULL,
651 `VNF_TYPE` varchar(150) DEFAULT NULL,
652 `VNFC_TYPE` varchar(50) DEFAULT NULL,
653 `DG_NAME` varchar(50) NOT NULL,
654 `DG_VERSION` varchar(50) DEFAULT NULL,
655 `DG_MODULE` varchar(50) NOT NULL,
656 UNIQUE KEY `INPUT_CONSTRAINT` (`ACTION`,`API_VERSION`,`VNF_TYPE`,`VNFC_TYPE`)
657 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
658 /*!40101 SET character_set_client = @saved_cs_client */;
661 -- Table structure for table `VNFC_REFERENCE`
664 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
665 /*!40101 SET @saved_cs_client = @@character_set_client */;
666 /*!40101 SET character_set_client = utf8 */;
667 CREATE TABLE `VNFC_REFERENCE` (
668 `VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
669 `ACTION` varchar(50) NOT NULL,
670 `VNF_TYPE` varchar(150) DEFAULT NULL,
671 `VM_INSTANCE` int(11) NOT NULL,
672 `VNFC_INSTANCE` int(11) NOT NULL,
673 `VNFC_TYPE` varchar(50) NOT NULL,
674 `VNFC_FUNCTION_CODE` varchar(50) NOT NULL,
675 `IPADDRESS_V4_OAM_VIP` varchar(50) DEFAULT NULL,
676 `TEMPLATE_ID` varchar(100) DEFAULT NULL,
677 `GROUP_NOTATION_TYPE` varchar(50) DEFAULT NULL,
678 `GROUP_NOTATION_VALUE` varchar(50) DEFAULT NULL,
679 PRIMARY KEY (`VNFC_REFERENCE_ID`),
680 UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
681 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
682 /*!40101 SET character_set_client = @saved_cs_client */;
685 -- Table structure for table `VNF_DG_MAPPING`
688 DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
689 /*!40101 SET @saved_cs_client = @@character_set_client */;
690 /*!40101 SET character_set_client = utf8 */;
691 CREATE TABLE `VNF_DG_MAPPING` (
692 `action` varchar(50) NOT NULL,
693 `api_version` varchar(50) DEFAULT NULL,
694 `VNF_TYPE` varchar(150) DEFAULT NULL,
695 `vnf_version` varchar(50) DEFAULT NULL,
696 `dg_name` varchar(50) NOT NULL,
697 `dg_version` varchar(50) DEFAULT NULL,
698 `dg_module` varchar(50) NOT NULL,
699 UNIQUE KEY `INPUT_CONSTRAINT` (`action`,`api_version`,`vnf_type`,`vnf_version`)
700 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
701 /*!40101 SET character_set_client = @saved_cs_client */;
704 -- Table structure for table `VNF_LOCK_MANAGEMENT`
707 DROP TABLE IF EXISTS `VNF_LOCK_MANAGEMENT`;
708 /*!40101 SET @saved_cs_client = @@character_set_client */;
709 /*!40101 SET character_set_client = utf8 */;
710 CREATE TABLE `VNF_LOCK_MANAGEMENT` (
711 `RESOURCE_ID` varchar(50) NOT NULL,
712 `OWNER_ID` varchar(50) DEFAULT NULL,
713 `UPDATED` bigint(20) unsigned NOT NULL,
714 `TIMEOUT` int(10) unsigned NOT NULL,
715 `VER` int(10) unsigned NOT NULL DEFAULT '1',
716 PRIMARY KEY (`RESOURCE_ID`)
717 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
718 /*!40101 SET character_set_client = @saved_cs_client */;
721 -- Table structure for table `VNF_STATE_MANAGEMENT`
724 DROP TABLE IF EXISTS `VNF_STATE_MANAGEMENT`;
725 /*!40101 SET @saved_cs_client = @@character_set_client */;
726 /*!40101 SET character_set_client = utf8 */;
727 CREATE TABLE `VNF_STATE_MANAGEMENT` (
728 `VNF_ID` varchar(50) NOT NULL,
729 `STATE` varchar(50) NOT NULL,
730 `OWNER_ID` varchar(255) DEFAULT NULL,
731 `UPDATED` bigint(20) unsigned NOT NULL,
732 `VER` int(10) unsigned NOT NULL DEFAULT '1',
733 PRIMARY KEY (`VNF_ID`)
734 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
736 DROP TABLE IF EXISTS `TRANSACTIONS`;
737 CREATE TABLE `TRANSACTIONS` (
738 `TRANSACTION_ID` varchar(75) NOT NULL,
739 `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
740 `REQUEST_ID` varchar(256) NOT NULL,
741 `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
742 `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
743 `START_TIME` datetime(3) NOT NULL,
744 `END_TIME` datetime(3) DEFAULT NULL,
745 `TARGET_ID` varchar(256) ,
746 `TARGET_TYPE` varchar(256) DEFAULT NULL,
747 `OPERATION` varchar(256) NOT NULL,
748 `RESULT_CODE` int(11) DEFAULT NULL,
750 `STATE` varchar(50) NOT NULL,
751 `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
752 `VNFC_NAME` varchar(256) DEFAULT NULL,
753 `VSERVER_ID` varchar(256) DEFAULT NULL,
754 `VF_MODULE_ID` varchar(256) DEFAULT NULL,
755 `MODE` varchar(50) NOT NULL,
756 PRIMARY KEY (`TRANSACTION_ID`)
757 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
760 SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;