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 `USER_NAME` varchar(50) DEFAULT NULL,
215 `PASSWORD` varchar(100) DEFAULT NULL,
216 `PORT_NUMBER` int(11) DEFAULT NULL,
217 PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
218 UNIQUE KEY `DEVICE_AUTHENTICATION_ID` (`DEVICE_AUTHENTICATION_ID`)
219 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
220 /*!40101 SET character_set_client = @saved_cs_client */;
223 -- Temporary view structure for view `DEVICE_CONFIGURATION`
226 DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
227 /*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
228 SET @saved_cs_client = @@character_set_client;
229 SET character_set_client = utf8;
230 /*!50001 CREATE VIEW `DEVICE_CONFIGURATION` AS SELECT
231 1 AS `UPLOAD_CONFIG_ID`,
233 1 AS `ORIGINATOR_ID`,
234 1 AS `SERVICE_DESCRIPTION`,
242 1 AS `HOST_IP_ADDRESS`,
243 1 AS `CONFIG_INDICATOR`,
244 1 AS `PENDING_DELETE`,
246 SET character_set_client = @saved_cs_client;
249 -- Table structure for table `DEVICE_INTERFACE_LOG`
252 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
253 /*!40101 SET @saved_cs_client = @@character_set_client */;
254 /*!40101 SET character_set_client = utf8 */;
255 CREATE TABLE `DEVICE_INTERFACE_LOG` (
256 `DEVICE_INTERFACE_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
257 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
258 `REQUEST_ID` varchar(50) DEFAULT NULL,
259 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
261 PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
262 UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
263 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
264 /*!40101 SET character_set_client = @saved_cs_client */;
267 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
270 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
271 /*!40101 SET @saved_cs_client = @@character_set_client */;
272 /*!40101 SET character_set_client = utf8 */;
273 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
274 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
275 `VNF_TYPE` varchar(150) DEFAULT NULL,
276 `PROTOCOL` varchar(50) DEFAULT NULL,
277 `MODULE` varchar(50) DEFAULT NULL,
278 `DG_RPC` varchar(50) DEFAULT NULL,
279 PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
280 UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`),
281 UNIQUE KEY `VNF_TYPE` (`VNF_TYPE`)
282 ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
283 /*!40101 SET character_set_client = @saved_cs_client */;
286 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
289 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
290 /*!40101 SET @saved_cs_client = @@character_set_client */;
291 /*!40101 SET character_set_client = utf8 */;
292 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
293 `DOWNLOAD_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
294 `VNF_TYPE` varchar(150) DEFAULT NULL,
295 `PROTOCOL` varchar(50) NOT NULL,
297 PRIMARY KEY (`DOWNLOAD_CONFIG_TEMPLATE_ID`),
298 UNIQUE KEY `DOWNLOAD_CONFIG_TEMPLATE_ID` (`DOWNLOAD_CONFIG_TEMPLATE_ID`)
299 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
300 /*!40101 SET character_set_client = @saved_cs_client */;
303 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
306 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
307 /*!40101 SET @saved_cs_client = @@character_set_client */;
308 /*!40101 SET character_set_client = utf8 */;
309 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
310 `DOWNLOAD_DG_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
311 `PROTOCOL` varchar(50) NOT NULL,
312 `DOWNLOAD_CONFIG_DG` varchar(50) NOT NULL,
313 PRIMARY KEY (`DOWNLOAD_DG_REFERENCE_ID`),
314 UNIQUE KEY ` DOWNLOAD_DG_REFERENCE_ID` (`DOWNLOAD_DG_REFERENCE_ID`)
315 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
316 /*!40101 SET character_set_client = @saved_cs_client */;
319 -- Table structure for table `DT_ACTION_STATUS`
322 DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
323 /*!40101 SET @saved_cs_client = @@character_set_client */;
324 /*!40101 SET character_set_client = utf8 */;
325 CREATE TABLE `DT_ACTION_STATUS` (
326 `DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
327 `ACTION` varchar(50) NOT NULL,
328 `VNF_TYPE` varchar(150) DEFAULT NULL,
329 `VNFC_TYPE` varchar(50) DEFAULT NULL,
330 `USER` varchar(50) NOT NULL,
331 `TECHNOLOGY` varchar(50) DEFAULT NULL,
332 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
333 `STATUS` varchar(50) NOT NULL,
334 PRIMARY KEY (`DT_ACTION_STATUS_ID`),
335 UNIQUE KEY `DT_ACTION_STATUS_ID` (`DT_ACTION_STATUS_ID`)
336 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
337 /*!40101 SET character_set_client = @saved_cs_client */;
340 -- Table structure for table `DT_ARTIFACT_REFERENCE`
343 DROP TABLE IF EXISTS `DT_ARTIFACT_REFERENCE`;
344 /*!40101 SET @saved_cs_client = @@character_set_client */;
345 /*!40101 SET character_set_client = utf8 */;
346 CREATE TABLE `DT_ARTIFACT_REFERENCE` (
347 `DT_ARTIFACT_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
348 `PROTOCOL` varchar(50) DEFAULT NULL,
349 `ACTION` varchar(50) DEFAULT NULL,
350 `ARTIFACT_TYPE` varchar(50) NOT NULL,
351 `ARTIFACT_PRIORITY` int(11) NOT NULL,
352 PRIMARY KEY (`DT_ARTIFACT_REFERENCE_ID`),
353 UNIQUE KEY `DT_ARTIFACT_REFERENCE_ID` (`DT_ARTIFACT_REFERENCE_ID`)
354 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
355 /*!40101 SET character_set_client = @saved_cs_client */;
358 -- Table structure for table `DT_ARTIFACT_TRACKING`
361 DROP TABLE IF EXISTS `DT_ARTIFACT_TRACKING`;
362 /*!40101 SET @saved_cs_client = @@character_set_client */;
363 /*!40101 SET character_set_client = utf8 */;
364 CREATE TABLE `DT_ARTIFACT_TRACKING` (
365 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL AUTO_INCREMENT,
366 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
367 `ASDC_REFERENCE_ID` int(11) DEFAULT NULL,
368 `USER` varchar(50) NOT NULL,
369 `TECHNOLOGY` varchar(50) DEFAULT NULL,
370 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
371 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
372 `ARTIFACT_STATUS` varchar(50) NOT NULL,
373 `IN_CART` varchar(50) DEFAULT NULL,
374 `PROTOCOL` varchar(50) DEFAULT NULL,
375 PRIMARY KEY (`DT_ARTIFACT_TRACKING_ID`),
376 UNIQUE KEY `DT_ARTIFACT_TRACKING_ID` (`DT_ARTIFACT_TRACKING_ID`)
377 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
378 /*!40101 SET character_set_client = @saved_cs_client */;
381 -- Table structure for table `DT_GUI_REFERENCE`
384 DROP TABLE IF EXISTS `DT_GUI_REFERENCE`;
385 /*!40101 SET @saved_cs_client = @@character_set_client */;
386 /*!40101 SET character_set_client = utf8 */;
387 CREATE TABLE `DT_GUI_REFERENCE` (
388 `DT_GUI_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
389 `GUI_NAME` varchar(50) NOT NULL,
390 `FIELD_NAME` varchar(50) NOT NULL,
391 `VALUE` varchar(50) NOT NULL,
392 `USER` varchar(50) NOT NULL,
393 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
394 `PROTOCOL` varchar(50) DEFAULT NULL,
395 `ACTION` varchar(50) DEFAULT NULL,
396 PRIMARY KEY (`DT_GUI_REFERENCE_ID`),
397 UNIQUE KEY `DT_GUI_REFERENCE_ID` (`DT_GUI_REFERENCE_ID`)
398 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
399 /*!40101 SET character_set_client = @saved_cs_client */;
402 -- Table structure for table `DT_STATUS_RELATIONSHIP`
405 DROP TABLE IF EXISTS `DT_STATUS_RELATIONSHIP`;
406 /*!40101 SET @saved_cs_client = @@character_set_client */;
407 /*!40101 SET character_set_client = utf8 */;
408 CREATE TABLE `DT_STATUS_RELATIONSHIP` (
409 `DT_STATUS_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
410 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL,
411 `DT_ACTION_STATUS_ID` int(11) NOT NULL,
412 PRIMARY KEY (`DT_STATUS_RELATIONSHIP_ID`),
413 UNIQUE KEY `DT_STATUS_RELATIONSHIP_ID` (`DT_STATUS_RELATIONSHIP_ID`),
414 KEY `IE_DT_STATUS_RELATIONSHIP` (`DT_ARTIFACT_TRACKING_ID`),
415 KEY `IE2_DT_STATUS_RELATIONSHIP` (`DT_ACTION_STATUS_ID`),
416 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,
417 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
418 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
419 /*!40101 SET character_set_client = @saved_cs_client */;
422 -- Table structure for table `GET_CONFIG_TEMPLATE`
425 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
426 /*!40101 SET @saved_cs_client = @@character_set_client */;
427 /*!40101 SET character_set_client = utf8 */;
428 CREATE TABLE `GET_CONFIG_TEMPLATE` (
429 `GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
430 `VNF_TYPE` varchar(150) DEFAULT NULL,
431 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL,
432 `XML_PROCESSING` varchar(1) DEFAULT NULL,
433 `XML_PROTOCOL` varchar(30) DEFAULT NULL,
435 PRIMARY KEY (`GET_CONFIG_TEMPLATE_ID`),
436 UNIQUE KEY `GET_CONFIG_TEMPLATE_ID` (`GET_CONFIG_TEMPLATE_ID`),
437 KEY `get_config_template_ibfk_1` (`DEVICE_INTERFACE_PROTOCOL_ID`),
438 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
439 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
440 /*!40101 SET character_set_client = @saved_cs_client */;
443 -- Table structure for table `MULTISTEP_FLOW_REFERENCE`
446 DROP TABLE IF EXISTS `MULTISTEP_FLOW_REFERENCE`;
447 /*!40101 SET @saved_cs_client = @@character_set_client */;
448 /*!40101 SET character_set_client = utf8 */;
449 CREATE TABLE `MULTISTEP_FLOW_REFERENCE` (
450 `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
451 `ACTION` varchar(50) NOT NULL,
452 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
453 `VNF_TYPE` varchar(150) DEFAULT NULL,
454 `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
455 `CATEGORY` varchar(50) DEFAULT NULL,
456 `GENERATION_NODE` varchar(50) DEFAULT NULL,
457 `EXECUTION_NODE` varchar(50) DEFAULT NULL,
458 `CREATOR` varchar(50) DEFAULT NULL,
459 `UPDATED_DATE` datetime DEFAULT NULL,
460 UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)
461 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
462 /*!40101 SET character_set_client = @saved_cs_client */;
465 -- Table structure for table `NODE_TYPES`
468 DROP TABLE IF EXISTS `NODE_TYPES`;
469 /*!40101 SET @saved_cs_client = @@character_set_client */;
470 /*!40101 SET character_set_client = utf8 */;
471 CREATE TABLE `NODE_TYPES` (
472 `nodetype` varchar(80) NOT NULL,
473 PRIMARY KEY (`nodetype`)
474 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
475 /*!40101 SET character_set_client = @saved_cs_client */;
478 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
481 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
482 /*!40101 SET @saved_cs_client = @@character_set_client */;
483 /*!40101 SET character_set_client = utf8 */;
484 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
485 `PREPARE_FILE_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
486 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
487 `REQUEST_ID` varchar(255) DEFAULT NULL,
488 `CONFIG_FILE_ID` int(11) DEFAULT NULL,
489 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
490 PRIMARY KEY (`PREPARE_FILE_RELATIONSHIP_ID`),
491 UNIQUE KEY `PREPARE_FILE_RELATIONSHIP_ID` (`PREPARE_FILE_RELATIONSHIP_ID`),
492 KEY `ie_prepare_file_relationship` (`CONFIG_FILE_ID`),
493 KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
494 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
495 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
496 ) ENGINE=InnoDB AUTO_INCREMENT=558 DEFAULT CHARSET=latin1;
497 /*!40101 SET character_set_client = @saved_cs_client */;
500 -- Table structure for table `PROCESS_FLOW_REFERENCE`
503 DROP TABLE IF EXISTS `PROCESS_FLOW_REFERENCE`;
504 /*!40101 SET @saved_cs_client = @@character_set_client */;
505 /*!40101 SET character_set_client = utf8 */;
506 CREATE TABLE `PROCESS_FLOW_REFERENCE` (
507 `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
508 `ACTION` varchar(50) NOT NULL,
509 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
510 `PROTOCOL` varchar(50) DEFAULT NULL,
511 `EXECUTION_TYPE` varchar(100) NOT NULL,
512 `EXECUTION_MODULE` varchar(100) NOT NULL,
513 `EXECUTION_RPC` varchar(100) NOT NULL,
514 `UPDATED_DATE` datetime DEFAULT NULL,
515 `GET_RUNNING_CONFIG` varchar(50) DEFAULT NULL,
516 PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),
517 UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)
518 ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
519 /*!40101 SET character_set_client = @saved_cs_client */;
522 -- Table structure for table `PROTOCOL_REFERENCE`
525 DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
526 /*!40101 SET @saved_cs_client = @@character_set_client */;
527 /*!40101 SET character_set_client = utf8 */;
528 CREATE TABLE `PROTOCOL_REFERENCE` (
529 `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
530 `ACTION` varchar(50) NOT NULL,
531 `VNF_TYPE` varchar(150) DEFAULT NULL,
532 `PROTOCOL` varchar(50) DEFAULT NULL,
533 `UPDATED_DATE` datetime DEFAULT NULL,
534 `TEMPLATE` varchar(45) DEFAULT NULL,
535 `ACTION_LEVEL` varchar(45) DEFAULT NULL,
536 PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
537 UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
538 ) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;
539 /*!40101 SET character_set_client = @saved_cs_client */;
542 -- Table structure for table `REQUEST_ARTIFACTS`
545 DROP TABLE IF EXISTS `REQUEST_ARTIFACTS`;
546 /*!40101 SET @saved_cs_client = @@character_set_client */;
547 /*!40101 SET character_set_client = utf8 */;
548 CREATE TABLE `REQUEST_ARTIFACTS` (
549 `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
550 `REQUEST_ID` varchar(50) NOT NULL,
551 `ACTION` varchar(50) NOT NULL,
552 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
553 `VNF_TYPE` varchar(150) DEFAULT NULL,
554 `CATEGORY` varchar(50) NOT NULL,
555 `ARTIFACT_CONTENT` longtext,
556 `UPDATED_DATE` datetime DEFAULT NULL,
557 PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
558 UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
559 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
560 /*!40101 SET character_set_client = @saved_cs_client */;
563 -- Table structure for table `SVC_LOGIC`
566 DROP TABLE IF EXISTS `SVC_LOGIC`;
567 /*!40101 SET @saved_cs_client = @@character_set_client */;
568 /*!40101 SET character_set_client = utf8 */;
569 CREATE TABLE `SVC_LOGIC` (
570 `module` varchar(80) NOT NULL,
571 `rpc` varchar(80) NOT NULL,
572 `version` varchar(40) NOT NULL,
573 `mode` varchar(5) NOT NULL,
574 `active` varchar(1) NOT NULL,
576 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
577 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
578 /*!40101 SET character_set_client = @saved_cs_client */;
581 -- Table structure for table `TRANSACTIONS`
584 DROP TABLE IF EXISTS `TRANSACTIONS`;
585 /*!40101 SET @saved_cs_client = @@character_set_client */;
586 /*!40101 SET character_set_client = utf8 */;
587 CREATE TABLE `TRANSACTIONS` (
588 `TRANSACTION_ID` varchar(75) NOT NULL,
589 `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
590 `REQUEST_ID` varchar(256) NOT NULL,
591 `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
592 `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
593 `START_TIME` datetime(3) NOT NULL,
594 `END_TIME` datetime(3) DEFAULT NULL,
595 `TARGET_ID` varchar(256) DEFAULT NULL,
596 `TARGET_TYPE` varchar(256) DEFAULT NULL,
597 `OPERATION` varchar(256) NOT NULL,
598 `RESULT_CODE` int(11) DEFAULT NULL,
600 `STATE` varchar(50) NOT NULL,
601 `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
602 `VNFC_NAME` varchar(256) DEFAULT NULL,
603 `VSERVER_ID` varchar(256) DEFAULT NULL,
604 `VF_MODULE_ID` varchar(256) DEFAULT NULL,
605 `MODE` varchar(50) NOT NULL,
606 PRIMARY KEY (`TRANSACTION_ID`)
607 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
608 /*!40101 SET character_set_client = @saved_cs_client */;
611 -- Table structure for table `UPLOAD_CONFIG`
614 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
615 /*!40101 SET @saved_cs_client = @@character_set_client */;
616 /*!40101 SET character_set_client = utf8 */;
617 CREATE TABLE `UPLOAD_CONFIG` (
618 `UPLOAD_CONFIG_ID` int(11) NOT NULL AUTO_INCREMENT,
619 `REQUEST_ID` varchar(50) DEFAULT NULL,
620 `ORIGINATOR_ID` varchar(50) DEFAULT NULL,
621 `SERVICE_DESCRIPTION` varchar(100) DEFAULT NULL,
622 `ACTION` varchar(50) DEFAULT NULL,
623 `UPLOAD_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
624 `VNF_ID` varchar(50) DEFAULT NULL,
625 `VNF_NAME` varchar(50) DEFAULT NULL,
626 `VM_NAME` varchar(50) DEFAULT NULL,
627 `VNF_TYPE` varchar(150) DEFAULT NULL,
628 `VNFC_TYPE` varchar(50) DEFAULT NULL,
629 `HOST_IP_ADDRESS` varchar(50) DEFAULT NULL,
630 `CONFIG_INDICATOR` varchar(25) DEFAULT NULL,
631 `PENDING_DELETE` varchar(1) DEFAULT NULL,
633 PRIMARY KEY (`UPLOAD_CONFIG_ID`),
634 UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
635 ) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=latin1;
636 /*!40101 SET character_set_client = @saved_cs_client */;
639 -- Table structure for table `VNFC_DG_MAPPING`
642 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
643 /*!40101 SET @saved_cs_client = @@character_set_client */;
644 /*!40101 SET character_set_client = utf8 */;
645 CREATE TABLE `VNFC_DG_MAPPING` (
646 `ACTION` varchar(50) DEFAULT NULL,
647 `API_VERSION` varchar(10) DEFAULT NULL,
648 `VNF_TYPE` varchar(150) DEFAULT NULL,
649 `VNFC_TYPE` varchar(50) DEFAULT NULL,
650 `DG_NAME` varchar(50) NOT NULL,
651 `DG_VERSION` varchar(50) DEFAULT NULL,
652 `DG_MODULE` varchar(50) NOT NULL,
653 UNIQUE KEY `INPUT_CONSTRAINT` (`ACTION`,`API_VERSION`,`VNF_TYPE`,`VNFC_TYPE`)
654 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
655 /*!40101 SET character_set_client = @saved_cs_client */;
658 -- Table structure for table `VNFC_REFERENCE`
661 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
662 /*!40101 SET @saved_cs_client = @@character_set_client */;
663 /*!40101 SET character_set_client = utf8 */;
664 CREATE TABLE `VNFC_REFERENCE` (
665 `VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
666 `ACTION` varchar(50) NOT NULL,
667 `VNF_TYPE` varchar(150) DEFAULT NULL,
668 `VM_INSTANCE` int(11) NOT NULL,
669 `VNFC_INSTANCE` int(11) NOT NULL,
670 `VNFC_TYPE` varchar(50) NOT NULL,
671 `VNFC_FUNCTION_CODE` varchar(50) NOT NULL,
672 `IPADDRESS_V4_OAM_VIP` varchar(50) DEFAULT NULL,
673 `TEMPLATE_ID` varchar(100) DEFAULT NULL,
674 `GROUP_NOTATION_TYPE` varchar(50) DEFAULT NULL,
675 `GROUP_NOTATION_VALUE` varchar(50) DEFAULT NULL,
676 PRIMARY KEY (`VNFC_REFERENCE_ID`),
677 UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
678 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
679 /*!40101 SET character_set_client = @saved_cs_client */;
682 -- Table structure for table `VNF_DG_MAPPING`
685 DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
686 /*!40101 SET @saved_cs_client = @@character_set_client */;
687 /*!40101 SET character_set_client = utf8 */;
688 CREATE TABLE `VNF_DG_MAPPING` (
689 `action` varchar(50) NOT NULL,
690 `api_version` varchar(50) DEFAULT NULL,
691 `VNF_TYPE` varchar(150) DEFAULT NULL,
692 `vnf_version` varchar(50) DEFAULT NULL,
693 `dg_name` varchar(50) NOT NULL,
694 `dg_version` varchar(50) DEFAULT NULL,
695 `dg_module` varchar(50) NOT NULL,
696 UNIQUE KEY `INPUT_CONSTRAINT` (`action`,`api_version`,`vnf_type`,`vnf_version`)
697 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
698 /*!40101 SET character_set_client = @saved_cs_client */;
701 -- Table structure for table `VNF_LOCK_MANAGEMENT`
704 DROP TABLE IF EXISTS `VNF_LOCK_MANAGEMENT`;
705 /*!40101 SET @saved_cs_client = @@character_set_client */;
706 /*!40101 SET character_set_client = utf8 */;
707 CREATE TABLE `VNF_LOCK_MANAGEMENT` (
708 `RESOURCE_ID` varchar(50) NOT NULL,
709 `OWNER_ID` varchar(50) DEFAULT NULL,
710 `UPDATED` bigint(20) unsigned NOT NULL,
711 `TIMEOUT` int(10) unsigned NOT NULL,
712 `VER` int(10) unsigned NOT NULL DEFAULT '1',
713 PRIMARY KEY (`RESOURCE_ID`)
714 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
715 /*!40101 SET character_set_client = @saved_cs_client */;
718 -- Table structure for table `VNF_STATE_MANAGEMENT`
721 DROP TABLE IF EXISTS `VNF_STATE_MANAGEMENT`;
722 /*!40101 SET @saved_cs_client = @@character_set_client */;
723 /*!40101 SET character_set_client = utf8 */;
724 CREATE TABLE `VNF_STATE_MANAGEMENT` (
725 `VNF_ID` varchar(50) NOT NULL,
726 `STATE` varchar(50) NOT NULL,
727 `OWNER_ID` varchar(255) DEFAULT NULL,
728 `UPDATED` bigint(20) unsigned NOT NULL,
729 `VER` int(10) unsigned NOT NULL DEFAULT '1',
730 PRIMARY KEY (`VNF_ID`)
731 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
733 DROP TABLE IF EXISTS `TRANSACTIONS`;
734 CREATE TABLE `TRANSACTIONS` (
735 `TRANSACTION_ID` varchar(75) NOT NULL,
736 `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
737 `REQUEST_ID` varchar(256) NOT NULL,
738 `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
739 `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
740 `START_TIME` datetime(3) NOT NULL,
741 `END_TIME` datetime(3) DEFAULT NULL,
742 `TARGET_ID` varchar(256) ,
743 `TARGET_TYPE` varchar(256) DEFAULT NULL,
744 `OPERATION` varchar(256) NOT NULL,
745 `RESULT_CODE` int(11) DEFAULT NULL,
747 `STATE` varchar(50) NOT NULL,
748 `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
749 `VNFC_NAME` varchar(256) DEFAULT NULL,
750 `VSERVER_ID` varchar(256) DEFAULT NULL,
751 `VF_MODULE_ID` varchar(256) DEFAULT NULL,
752 `MODE` varchar(50) NOT NULL,
753 PRIMARY KEY (`TRANSACTION_ID`)
754 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
757 SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;