1 -- ============LICENSE_START==========================================
3 -- ===================================================================
4 -- Copyright (C) 2018-2019 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============================================
24 -- Current Database: `sdnctl`
27 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sdnctl` /*!40100 DEFAULT CHARACTER SET latin1 */;
32 -- Table structure for table `ACTION_LEVEL_REFERENCE`
35 DROP TABLE IF EXISTS `ACTION_LEVEL_REFERENCE`;
36 /*!40101 SET @saved_cs_client = @@character_set_client */;
37 /*!40101 SET character_set_client = utf8 */;
38 CREATE TABLE `ACTION_LEVEL_REFERENCE` (
39 `ACTION_LEVEL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
40 `ACTION_IDENTIFIER` varchar(50) NOT NULL,
41 `ACTION_LEVEL` varchar(50) NOT NULL,
42 UNIQUE KEY `ACTION_LEVEL_REFERENCE_ID` (`ACTION_LEVEL_REFERENCE_ID`)
43 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
44 /*!40101 SET character_set_client = @saved_cs_client */;
47 -- Table structure for table `APPC_APP_PARAM`
50 DROP TABLE IF EXISTS `APPC_APP_PARAM`;
51 /*!40101 SET @saved_cs_client = @@character_set_client */;
52 /*!40101 SET character_set_client = utf8 */;
53 CREATE TABLE `APPC_APP_PARAM` (
54 `APPC_APP_PARAM_ID` int(11) NOT NULL AUTO_INCREMENT,
55 `PARAM_KEY` varchar(50) NOT NULL,
56 `PARAM_VALUE` varchar(50) NOT NULL,
57 UNIQUE KEY `APPC_APP_PARAM_ID` (`APPC_APP_PARAM_ID`)
58 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
59 /*!40101 SET character_set_client = @saved_cs_client */;
62 -- Table structure for table `APPC_HEALTH`
65 DROP TABLE IF EXISTS `APPC_HEALTH`;
66 /*!40101 SET @saved_cs_client = @@character_set_client */;
67 /*!40101 SET character_set_client = utf8 */;
68 CREATE TABLE `APPC_HEALTH` (
69 `APPC_HEALTH_ID` int(11) NOT NULL AUTO_INCREMENT,
70 `HEALTHY` varchar(30) NOT NULL,
71 PRIMARY KEY (`APPC_HEALTH_ID`)
72 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
73 /*!40101 SET character_set_client = @saved_cs_client */;
76 -- Table structure for table `ASDC_ARTIFACTS`
79 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
80 /*!40101 SET @saved_cs_client = @@character_set_client */;
81 /*!40101 SET character_set_client = utf8 */;
82 CREATE TABLE `ASDC_ARTIFACTS` (
83 `ASDC_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
84 `SERVICE_UUID` varchar(50) DEFAULT NULL,
85 `DISTRIBUTION_ID` varchar(50) DEFAULT NULL,
86 `SERVICE_NAME` varchar(255) DEFAULT NULL,
87 `SERVICE_DESCRIPTION` varchar(255) DEFAULT NULL,
88 `RESOURCE_UUID` varchar(255) DEFAULT NULL,
89 `RESOURCE_INSTANCE_NAME` varchar(255) DEFAULT NULL,
90 `RESOURCE_NAME` varchar(255) DEFAULT NULL,
91 `RESOURCE_VERSION` varchar(50) DEFAULT NULL,
92 `RESOURCE_TYPE` varchar(50) DEFAULT NULL,
93 `ARTIFACT_UUID` varchar(50) DEFAULT NULL,
94 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
95 `ARTIFACT_VERSION` varchar(25) DEFAULT NULL,
96 `ARTIFACT_DESCRIPTION` varchar(255) DEFAULT NULL,
97 `INTERNAL_VERSION` int(11) DEFAULT NULL,
98 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
99 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
100 `ARTIFACT_CONTENT` longtext,
101 PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
102 UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
103 ) ENGINE=InnoDB AUTO_INCREMENT=5093 DEFAULT CHARSET=latin1;
104 /*!40101 SET character_set_client = @saved_cs_client */;
107 -- Table structure for table `ASDC_REFERENCE`
110 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
111 /*!40101 SET @saved_cs_client = @@character_set_client */;
112 /*!40101 SET character_set_client = utf8 */;
113 CREATE TABLE `ASDC_REFERENCE` (
114 `ASDC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
115 `VNF_TYPE` varchar(150) DEFAULT NULL,
116 `VNFC_TYPE` varchar(50) DEFAULT NULL,
117 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
118 `ACTION` varchar(50) DEFAULT NULL,
119 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
120 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
121 PRIMARY KEY (`ASDC_REFERENCE_ID`),
122 UNIQUE KEY `ASDC_REFERENCE_ID` (`ASDC_REFERENCE_ID`)
123 ) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=latin1;
124 /*!40101 SET character_set_client = @saved_cs_client */;
127 -- Table structure for table `CONFIGFILES`
130 DROP TABLE IF EXISTS `CONFIGFILES`;
131 /*!40101 SET @saved_cs_client = @@character_set_client */;
132 /*!40101 SET character_set_client = utf8 */;
133 CREATE TABLE `CONFIGFILES` (
134 `CONFIG_FILE_ID` int(11) NOT NULL AUTO_INCREMENT,
135 `EXTERNAL_VERSION` varchar(50) DEFAULT NULL,
136 `DATA_SOURCE` varchar(25) DEFAULT NULL,
137 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
138 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
139 `VNF_TYPE` varchar(150) DEFAULT NULL,
140 `VNFC_TYPE` varchar(50) DEFAULT NULL,
141 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
142 `FILE_NAME` varchar(255) DEFAULT NULL,
143 `FILE_CONTENT` longtext,
144 `ACTION` varchar(50) DEFAULT NULL,
145 `VNF_ID` varchar(50) DEFAULT NULL,
146 `VM_NAME` varchar(50) DEFAULT NULL,
147 `VNF_NAME` varchar(50) DEFAULT NULL,
148 PRIMARY KEY (`CONFIG_FILE_ID`),
149 UNIQUE KEY `CONFIG_FILE_ID` (`CONFIG_FILE_ID`)
150 ) ENGINE=InnoDB AUTO_INCREMENT=5751 DEFAULT CHARSET=latin1;
151 /*!40101 SET character_set_client = @saved_cs_client */;
154 -- Table structure for table `CONFIGURE_ACTION_DG`
157 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
158 /*!40101 SET @saved_cs_client = @@character_set_client */;
159 /*!40101 SET character_set_client = utf8 */;
160 CREATE TABLE `CONFIGURE_ACTION_DG` (
161 `CONFIGURE_ACTION_DG_ID` int(11) NOT NULL AUTO_INCREMENT,
162 `VNF_TYPE` varchar(150) DEFAULT NULL,
163 `ACTION` varchar(50) DEFAULT NULL,
164 `GENERATE_CONFIG_DG` varchar(50) DEFAULT NULL,
165 `DOWNLOAD_CONFIG_DG` varchar(50) DEFAULT NULL,
166 PRIMARY KEY (`CONFIGURE_ACTION_DG_ID`),
167 UNIQUE KEY ` CONFIGURE_ACTION_DG_ID` (`CONFIGURE_ACTION_DG_ID`)
168 ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
169 /*!40101 SET character_set_client = @saved_cs_client */;
172 -- Table structure for table `CONFIG_FILE_REFERENCE`
175 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
176 /*!40101 SET @saved_cs_client = @@character_set_client */;
177 /*!40101 SET character_set_client = utf8 */;
178 CREATE TABLE `CONFIG_FILE_REFERENCE` (
179 `CONFIG_FILE_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
180 `SITE_LOCATION` varchar(50) DEFAULT NULL,
181 `VNF_TYPE` varchar(150) DEFAULT NULL,
182 `IMPORT_TYPE` varchar(50) DEFAULT NULL,
183 `FILE_TYPE` varchar(50) DEFAULT NULL,
184 `SOURCE_SERVER_NAME` varchar(255) DEFAULT NULL,
185 `SOURCE_FILE_PATH` varchar(255) DEFAULT NULL,
186 `TARGET_FILE_PATH` varchar(255) DEFAULT NULL,
187 `NAME` varchar(50) DEFAULT NULL,
188 `FILE_NAME` varchar(255) DEFAULT NULL,
189 PRIMARY KEY (`CONFIG_FILE_REFERENCE_ID`),
190 UNIQUE KEY `CONFIG_FILE_REFERENCE_ID` (`CONFIG_FILE_REFERENCE_ID`)
191 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
192 /*!40101 SET character_set_client = @saved_cs_client */;
195 -- Table structure for table `CONFIG_TRANSACTION_LOG`
198 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
199 /*!40101 SET @saved_cs_client = @@character_set_client */;
200 /*!40101 SET character_set_client = utf8 */;
201 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
202 `CONFIG_TRANSACTION_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
203 `REQUEST_ID` varchar(50) DEFAULT NULL,
204 `MESSAGE_TYPE` varchar(50) DEFAULT NULL,
205 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
207 PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
208 UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
209 ) ENGINE=InnoDB AUTO_INCREMENT=40247 DEFAULT CHARSET=latin1;
210 /*!40101 SET character_set_client = @saved_cs_client */;
213 -- Table structure for table `DEVICE_AUTHENTICATION`
216 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
217 /*!40101 SET @saved_cs_client = @@character_set_client */;
218 /*!40101 SET character_set_client = utf8 */;
219 CREATE TABLE `DEVICE_AUTHENTICATION` (
220 `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
221 `VNF_TYPE` varchar(255) NOT NULL,
222 `PROTOCOL` varchar(255) NOT NULL,
223 `ACTION` varchar(255) NOT NULL,
224 `USER_NAME` varchar(255) DEFAULT NULL,
225 `PASSWORD` varchar(255) DEFAULT NULL,
226 `PORT_NUMBER` int(11) DEFAULT NULL,
227 `URL` varchar(256) DEFAULT NULL,
228 PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
229 UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`,`URL`),
230 KEY `PROTOCOL` (`PROTOCOL`),
231 KEY `ACTION` (`ACTION`)
232 ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;
233 /*!40101 SET character_set_client = @saved_cs_client */;
236 -- Temporary table structure for view `DEVICE_CONFIGURATION`
239 DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
240 /*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
241 SET @saved_cs_client = @@character_set_client;
242 SET character_set_client = utf8;
243 /*!50001 CREATE VIEW `DEVICE_CONFIGURATION` AS SELECT
244 1 AS `UPLOAD_CONFIG_ID`,
246 1 AS `ORIGINATOR_ID`,
247 1 AS `SERVICE_DESCRIPTION`,
255 1 AS `HOST_IP_ADDRESS`,
256 1 AS `CONFIG_INDICATOR`,
257 1 AS `PENDING_DELETE`,
259 SET character_set_client = @saved_cs_client;
262 -- Table structure for table `DEVICE_INTERFACE_LOG`
265 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
266 /*!40101 SET @saved_cs_client = @@character_set_client */;
267 /*!40101 SET character_set_client = utf8 */;
268 CREATE TABLE `DEVICE_INTERFACE_LOG` (
269 `DEVICE_INTERFACE_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
270 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
271 `REQUEST_ID` varchar(50) DEFAULT NULL,
272 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
274 PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
275 UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
276 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
277 /*!40101 SET character_set_client = @saved_cs_client */;
280 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
283 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
284 /*!40101 SET @saved_cs_client = @@character_set_client */;
285 /*!40101 SET character_set_client = utf8 */;
286 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
287 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
288 `VNF_TYPE` varchar(150) DEFAULT NULL,
289 `PROTOCOL` varchar(50) DEFAULT NULL,
290 `MODULE` varchar(50) DEFAULT NULL,
291 `DG_RPC` varchar(50) DEFAULT NULL,
292 PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
293 UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`)
294 ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
295 /*!40101 SET character_set_client = @saved_cs_client */;
298 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
301 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
302 /*!40101 SET @saved_cs_client = @@character_set_client */;
303 /*!40101 SET character_set_client = utf8 */;
304 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
305 `DOWNLOAD_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
306 `VNF_TYPE` varchar(150) DEFAULT NULL,
307 `PROTOCOL` varchar(50) NOT NULL,
309 PRIMARY KEY (`DOWNLOAD_CONFIG_TEMPLATE_ID`),
310 UNIQUE KEY `DOWNLOAD_CONFIG_TEMPLATE_ID` (`DOWNLOAD_CONFIG_TEMPLATE_ID`)
311 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
312 /*!40101 SET character_set_client = @saved_cs_client */;
315 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
318 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
319 /*!40101 SET @saved_cs_client = @@character_set_client */;
320 /*!40101 SET character_set_client = utf8 */;
321 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
322 `DOWNLOAD_DG_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
323 `PROTOCOL` varchar(50) NOT NULL,
324 `DOWNLOAD_CONFIG_DG` varchar(50) NOT NULL,
325 PRIMARY KEY (`DOWNLOAD_DG_REFERENCE_ID`),
326 UNIQUE KEY ` DOWNLOAD_DG_REFERENCE_ID` (`DOWNLOAD_DG_REFERENCE_ID`)
327 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
328 /*!40101 SET character_set_client = @saved_cs_client */;
331 -- Table structure for table `DT_ACTION_STATUS`
334 DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
335 /*!40101 SET @saved_cs_client = @@character_set_client */;
336 /*!40101 SET character_set_client = utf8 */;
337 CREATE TABLE `DT_ACTION_STATUS` (
338 `DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
339 `ACTION` varchar(50) NOT NULL,
340 `VNF_TYPE` varchar(150) DEFAULT NULL,
341 `VNFC_TYPE` varchar(50) DEFAULT NULL,
342 `USER` varchar(50) NOT NULL,
343 `TECHNOLOGY` varchar(50) DEFAULT NULL,
344 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
345 `STATUS` varchar(50) NOT NULL,
346 PRIMARY KEY (`DT_ACTION_STATUS_ID`),
347 UNIQUE KEY `DT_ACTION_STATUS_ID` (`DT_ACTION_STATUS_ID`)
348 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
349 /*!40101 SET character_set_client = @saved_cs_client */;
352 -- Table structure for table `DT_ARTIFACT_REFERENCE`
355 DROP TABLE IF EXISTS `DT_ARTIFACT_REFERENCE`;
356 /*!40101 SET @saved_cs_client = @@character_set_client */;
357 /*!40101 SET character_set_client = utf8 */;
358 CREATE TABLE `DT_ARTIFACT_REFERENCE` (
359 `DT_ARTIFACT_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
360 `PROTOCOL` varchar(50) DEFAULT NULL,
361 `ACTION` varchar(50) DEFAULT NULL,
362 `ARTIFACT_TYPE` varchar(50) NOT NULL,
363 `ARTIFACT_PRIORITY` int(11) NOT NULL,
364 PRIMARY KEY (`DT_ARTIFACT_REFERENCE_ID`),
365 UNIQUE KEY `DT_ARTIFACT_REFERENCE_ID` (`DT_ARTIFACT_REFERENCE_ID`)
366 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
367 /*!40101 SET character_set_client = @saved_cs_client */;
370 -- Table structure for table `DT_ARTIFACT_TRACKING`
373 DROP TABLE IF EXISTS `DT_ARTIFACT_TRACKING`;
374 /*!40101 SET @saved_cs_client = @@character_set_client */;
375 /*!40101 SET character_set_client = utf8 */;
376 CREATE TABLE `DT_ARTIFACT_TRACKING` (
377 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL AUTO_INCREMENT,
378 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
379 `ASDC_REFERENCE_ID` int(11) DEFAULT NULL,
380 `USER` varchar(50) NOT NULL,
381 `TECHNOLOGY` varchar(50) DEFAULT NULL,
382 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
383 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
384 `ARTIFACT_STATUS` varchar(50) NOT NULL,
385 `IN_CART` varchar(50) DEFAULT NULL,
386 `PROTOCOL` varchar(50) DEFAULT NULL,
387 PRIMARY KEY (`DT_ARTIFACT_TRACKING_ID`),
388 UNIQUE KEY `DT_ARTIFACT_TRACKING_ID` (`DT_ARTIFACT_TRACKING_ID`)
389 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
390 /*!40101 SET character_set_client = @saved_cs_client */;
393 -- Table structure for table `DT_GUI_REFERENCE`
396 DROP TABLE IF EXISTS `DT_GUI_REFERENCE`;
397 /*!40101 SET @saved_cs_client = @@character_set_client */;
398 /*!40101 SET character_set_client = utf8 */;
399 CREATE TABLE `DT_GUI_REFERENCE` (
400 `DT_GUI_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
401 `GUI_NAME` varchar(50) NOT NULL,
402 `FIELD_NAME` varchar(50) NOT NULL,
403 `VALUE` varchar(50) NOT NULL,
404 `USER` varchar(50) NOT NULL,
405 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
406 `PROTOCOL` varchar(50) DEFAULT NULL,
407 `ACTION` varchar(50) DEFAULT NULL,
408 PRIMARY KEY (`DT_GUI_REFERENCE_ID`),
409 UNIQUE KEY `DT_GUI_REFERENCE_ID` (`DT_GUI_REFERENCE_ID`)
410 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
411 /*!40101 SET character_set_client = @saved_cs_client */;
414 -- Table structure for table `DT_STATUS_RELATIONSHIP`
417 DROP TABLE IF EXISTS `DT_STATUS_RELATIONSHIP`;
418 /*!40101 SET @saved_cs_client = @@character_set_client */;
419 /*!40101 SET character_set_client = utf8 */;
420 CREATE TABLE `DT_STATUS_RELATIONSHIP` (
421 `DT_STATUS_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
422 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL,
423 `DT_ACTION_STATUS_ID` int(11) NOT NULL,
424 PRIMARY KEY (`DT_STATUS_RELATIONSHIP_ID`),
425 UNIQUE KEY `DT_STATUS_RELATIONSHIP_ID` (`DT_STATUS_RELATIONSHIP_ID`),
426 KEY `IE_DT_STATUS_RELATIONSHIP` (`DT_ARTIFACT_TRACKING_ID`),
427 KEY `IE2_DT_STATUS_RELATIONSHIP` (`DT_ACTION_STATUS_ID`),
428 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,
429 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
430 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
431 /*!40101 SET character_set_client = @saved_cs_client */;
434 -- Table structure for table `DT_USER_PERMISSIONS`
437 DROP TABLE IF EXISTS `DT_USER_PERMISSIONS`;
438 /*!40101 SET @saved_cs_client = @@character_set_client */;
439 /*!40101 SET character_set_client = utf8 */;
440 CREATE TABLE sdnctl.`DT_USER_PERMISSIONS` (
441 `DT_USER_PERMISSION_ID` int(11) NOT NULL AUTO_INCREMENT,
442 `VNF_TYPE` varchar(255) NOT NULL,
443 `USER_ID` varchar(255) DEFAULT NULL,
444 `PERMISSION` varchar(255) DEFAULT NULL,
445 `DATE_MODIFIED` datetime(3) DEFAULT NULL,
446 `MODIFIER` varchar(255) DEFAULT NULL,
447 PRIMARY KEY (`DT_USER_PERMISSION_ID`),
448 UNIQUE KEY `VNF_USER_UNIQ` (`VNF_TYPE`,`USER_ID`)
449 ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
450 /*!40101 SET character_set_client = @saved_cs_client */;
452 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
453 /*!40101 SET character_set_client = @saved_cs_client */;
456 -- Table structure for table `GET_CONFIG_TEMPLATE`
459 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
460 /*!40101 SET @saved_cs_client = @@character_set_client */;
461 /*!40101 SET character_set_client = utf8 */;
462 CREATE TABLE `GET_CONFIG_TEMPLATE` (
463 `GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
464 `VNF_TYPE` varchar(150) DEFAULT NULL,
465 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL,
466 `XML_PROCESSING` varchar(1) DEFAULT NULL,
467 `XML_PROTOCOL` varchar(30) DEFAULT NULL,
469 PRIMARY KEY (`GET_CONFIG_TEMPLATE_ID`),
470 UNIQUE KEY `GET_CONFIG_TEMPLATE_ID` (`GET_CONFIG_TEMPLATE_ID`),
471 KEY `get_config_template_ibfk_1` (`DEVICE_INTERFACE_PROTOCOL_ID`),
472 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
473 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
474 /*!40101 SET character_set_client = @saved_cs_client */;
477 -- Table structure for table `MULTISTEP_FLOW_REFERENCE`
480 DROP TABLE IF EXISTS `MULTISTEP_FLOW_REFERENCE`;
481 /*!40101 SET @saved_cs_client = @@character_set_client */;
482 /*!40101 SET character_set_client = utf8 */;
483 CREATE TABLE `MULTISTEP_FLOW_REFERENCE` (
484 `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
485 `ACTION` varchar(50) NOT NULL,
486 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
487 `VNF_TYPE` varchar(150) DEFAULT NULL,
488 `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
489 `CATEGORY` varchar(50) DEFAULT NULL,
490 `GENERATION_NODE` varchar(50) DEFAULT NULL,
491 `EXECUTION_NODE` varchar(50) DEFAULT NULL,
492 `CREATOR` varchar(50) DEFAULT NULL,
493 `UPDATED_DATE` datetime DEFAULT NULL,
494 UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)
495 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
496 /*!40101 SET character_set_client = @saved_cs_client */;
499 -- Table structure for table `NODE_TYPES`
502 DROP TABLE IF EXISTS `NODE_TYPES`;
503 /*!40101 SET @saved_cs_client = @@character_set_client */;
504 /*!40101 SET character_set_client = utf8 */;
505 CREATE TABLE `NODE_TYPES` (
506 `nodetype` varchar(80) NOT NULL,
507 PRIMARY KEY (`nodetype`)
508 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
509 /*!40101 SET character_set_client = @saved_cs_client */;
512 -- Table structure for table `OPS_AIC_REGIONS`
515 DROP TABLE IF EXISTS `OPS_AIC_REGIONS`;
516 /*!40101 SET @saved_cs_client = @@character_set_client */;
517 /*!40101 SET character_set_client = utf8 */;
518 CREATE TABLE `OPS_AIC_REGIONS` (
519 `REGION_ID` varchar(16) NOT NULL,
520 `IDENTITY_URL` varchar(256) NOT NULL,
521 `HOST_DISCOVERY` varchar(3) NOT NULL DEFAULT 'NO',
522 `ADMIN_TENANT_ID` varchar(64) DEFAULT NULL,
523 `ADMIN_TENANT_NAME` varchar(64) DEFAULT 'admin',
524 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
525 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
526 PRIMARY KEY (`REGION_ID`)
527 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
528 /*!40101 SET character_set_client = @saved_cs_client */;
531 -- Table structure for table `OPS_AIC_HOSTS`
534 DROP TABLE IF EXISTS `OPS_AIC_HOSTS`;
535 /*!40101 SET @saved_cs_client = @@character_set_client */;
536 /*!40101 SET character_set_client = utf8 */;
537 CREATE TABLE `OPS_AIC_HOSTS` (
538 `REGION_ID` varchar(16) NOT NULL,
539 `HOST` varchar(64) NOT NULL,
540 `HOST_IP` varchar(64) DEFAULT NULL,
541 `EQUIPMENT_VENDOR` varchar(32) DEFAULT NULL,
542 `EQUIPMENT_PRODUCT` varchar(32) DEFAULT NULL,
543 `EQUIPMENT_MODEL` varchar(32) DEFAULT NULL,
544 `EQUIPMENT_VERSION` varchar(32) DEFAULT NULL,
545 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
546 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
547 PRIMARY KEY (`REGION_ID`,`HOST`),
548 CONSTRAINT `fk_aic_hosts` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
549 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
550 /*!40101 SET character_set_client = @saved_cs_client */;
553 -- Table structure for table `OPS_AIC_SCHEDULER_EVENTS`
556 DROP TABLE IF EXISTS `OPS_AIC_SCHEDULER_EVENTS`;
557 /*!40101 SET @saved_cs_client = @@character_set_client */;
558 /*!40101 SET character_set_client = utf8 */;
559 CREATE TABLE `OPS_AIC_SCHEDULER_EVENTS` (
560 `REGION_ID` varchar(16) NOT NULL,
561 `HOST` varchar(64) NOT NULL DEFAULT '',
562 `STATE` enum('COMPLETE','PROGRESS') DEFAULT NULL,
563 `STATUS` enum('SUCCESS','FAILED','PARTIAL') DEFAULT NULL,
564 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
565 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
566 `RUNTIME` varchar(8) NOT NULL DEFAULT '',
567 `RETRIES` int(11) NOT NULL DEFAULT '0',
568 `ERROR` varchar(256) DEFAULT NULL,
569 PRIMARY KEY (`REGION_ID`,`HOST`),
570 CONSTRAINT `fk_aic_sch_events` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
571 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
572 /*!40101 SET character_set_client = @saved_cs_client */;
575 -- Table structure for table `OPS_EXPORT_SCRIPT`
578 DROP TABLE IF EXISTS `OPS_EXPORT_SCRIPT`;
579 /*!40101 SET @saved_cs_client = @@character_set_client */;
580 /*!40101 SET character_set_client = utf8 */;
581 CREATE TABLE `OPS_EXPORT_SCRIPT` (
582 `ID` varchar(15) NOT NULL,
583 `SCRIPT` text NOT NULL,
584 `CREATEDON` datetime NOT NULL,
585 `CREATEDBY` varchar(10) NOT NULL,
587 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
588 /*!40101 SET character_set_client = @saved_cs_client */;
591 -- Table structure for table `OPS_HCAGGMETRICS`
594 DROP TABLE IF EXISTS `OPS_HCAGGMETRICS`;
595 /*!40101 SET @saved_cs_client = @@character_set_client */;
596 /*!40101 SET character_set_client = utf8 */;
597 CREATE TABLE `OPS_HCAGGMETRICS` (
598 `ID` int(11) NOT NULL AUTO_INCREMENT,
599 `AGG_TIME` datetime DEFAULT NULL,
600 `CNT` int(11) DEFAULT NULL,
601 `HCCODE` varchar(45) DEFAULT NULL,
602 `SUCCESS` varchar(20) DEFAULT NULL,
603 `MIN_DUR` float DEFAULT NULL,
604 `AVG_DUR` float DEFAULT NULL,
605 `MAX_DUR` float DEFAULT NULL,
606 `STDDEV_DUR` float DEFAULT NULL,
607 `SDNOINSTANCE` varchar(45) DEFAULT NULL,
608 `HCNODETYPE` varchar(45) DEFAULT NULL,
609 `CLIENTNAME` varchar(45) DEFAULT NULL,
611 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
612 /*!40101 SET character_set_client = @saved_cs_client */;
615 -- Table structure for table `OPS_HCGROUPS`
618 DROP TABLE IF EXISTS `OPS_HCGROUPS`;
619 /*!40101 SET @saved_cs_client = @@character_set_client */;
620 /*!40101 SET character_set_client = utf8 */;
621 CREATE TABLE `OPS_HCGROUPS` (
622 `HCGROUPID` int(11) NOT NULL AUTO_INCREMENT,
623 `HCCODE` varchar(45) NOT NULL,
624 `CHCCODE` varchar(45) NOT NULL,
625 `EXECPRIORITY` int(11) DEFAULT NULL,
626 `CREATEDBY` varchar(45) DEFAULT NULL,
627 `CREATEDON` datetime DEFAULT NULL,
628 `UPDATEDON` datetime DEFAULT NULL,
629 `UPDATEDBY` varchar(45) DEFAULT NULL,
630 PRIMARY KEY (`HCGROUPID`)
631 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
632 /*!40101 SET character_set_client = @saved_cs_client */;
635 -- Table structure for table `OPS_HCRESPARCHIVE`
638 DROP TABLE IF EXISTS `OPS_HCRESPARCHIVE`;
639 /*!40101 SET @saved_cs_client = @@character_set_client */;
640 /*!40101 SET character_set_client = utf8 */;
641 CREATE TABLE `OPS_HCRESPARCHIVE` (
642 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
643 `HCTRANSID` varchar(128) DEFAULT NULL,
644 `REFHCTRANSID` varchar(128) DEFAULT NULL,
645 `SDNOTRANSID` varchar(255) DEFAULT NULL,
646 `HOSTIP` varchar(45) DEFAULT NULL,
647 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
648 `HCRESPONSE` longtext,
649 `CREATEDON` datetime DEFAULT NULL,
650 `SDNOINSTANCE` varchar(45) NOT NULL,
651 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
652 `DMAAPSENT` varchar(1) NOT NULL DEFAULT 'N',
653 `NODETYPE` varchar(45) DEFAULT NULL,
654 `HCCODE` varchar(45) DEFAULT NULL,
655 `USERID` varchar(10) DEFAULT NULL,
656 `CLIENTNAME` varchar(45) DEFAULT NULL,
657 `HDSTARTTIME` datetime DEFAULT NULL,
658 `HDENDTIME` datetime DEFAULT NULL,
659 PRIMARY KEY (`HCRESPONSEID`),
660 KEY `hctransid_idx` (`HCTRANSID`),
661 KEY `sdnotransid_idx` (`SDNOTRANSID`),
662 KEY `clientname_idx` (`CLIENTNAME`),
663 KEY `nodetype_idx` (`NODETYPE`),
664 KEY `hccode_idx` (`HCCODE`),
665 KEY `hostip_idx` (`HOSTIP`),
666 KEY `createdon_idx` (`CREATEDON`)
667 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
668 /*!40101 SET character_set_client = @saved_cs_client */;
671 -- Table structure for table `OPS_HCRESPCACHE`
674 DROP TABLE IF EXISTS `OPS_HCRESPCACHE`;
675 /*!40101 SET @saved_cs_client = @@character_set_client */;
676 /*!40101 SET character_set_client = utf8 */;
677 CREATE TABLE `OPS_HCRESPCACHE` (
678 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
679 `SDNOTRANSID` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
680 `HOSTIP` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
681 `HCRESPONSESTATUS` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
682 `HCRESPONSE` longtext CHARACTER SET utf8,
683 `CREATEDON` datetime DEFAULT NULL,
684 `SDNOINSTANCE` varchar(45) CHARACTER SET utf8 NOT NULL,
685 `SDNOINSTANCESERVER` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
686 `DMAAPSENT` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
687 `NODETYPE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
688 `HCCODE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
689 `USERID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
690 `CLIENTNAME` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
691 `HDSTARTTIME` datetime DEFAULT NULL,
692 `HDENDTIME` datetime DEFAULT NULL,
693 `CACHEEXPIRETIME` datetime DEFAULT NULL,
694 `HDEXPECTEDENDTIME` datetime DEFAULT NULL,
695 PRIMARY KEY (`HCRESPONSEID`),
696 KEY `cacheexpiretime_idx` (`CACHEEXPIRETIME`),
697 KEY `hdexpectedendtime_idx` (`HDEXPECTEDENDTIME`),
698 KEY `hdendtime_idx` (`HDENDTIME`),
699 KEY `hdstarttime_idx` (`HDSTARTTIME`)
700 ) ENGINE=InnoDB AUTO_INCREMENT=383 DEFAULT CHARSET=latin1;
701 /*!40101 SET character_set_client = @saved_cs_client */;
704 -- Temporary table structure for view `OPS_HCRESPCACHEVIEW`
707 DROP TABLE IF EXISTS `OPS_HCRESPCACHEVIEW`;
708 /*!50001 DROP VIEW IF EXISTS `OPS_HCRESPCACHEVIEW`*/;
709 SET @saved_cs_client = @@character_set_client;
710 SET character_set_client = utf8;
711 /*!50001 CREATE VIEW `OPS_HCRESPCACHEVIEW` AS SELECT
716 1 AS `HCRESPONSESTATUS`,
720 1 AS `SDNOINSTANCESERVER`,
728 1 AS `CACHEEXPIRETIME`,
729 1 AS `HDEXPECTEDENDTIME`*/;
730 SET character_set_client = @saved_cs_client;
733 -- Table structure for table `OPS_HCRESPCOMPACT`
736 DROP TABLE IF EXISTS `OPS_HCRESPCOMPACT`;
737 /*!40101 SET @saved_cs_client = @@character_set_client */;
738 /*!40101 SET character_set_client = utf8 */;
739 CREATE TABLE `OPS_HCRESPCOMPACT` (
740 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
741 `HCTRANSID` varchar(128) DEFAULT NULL,
742 `HOSTIP` varchar(45) DEFAULT NULL,
743 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
744 `SDNOINSTANCE` varchar(45) NOT NULL,
745 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
746 `NODETYPE` varchar(45) DEFAULT NULL,
747 `HCCODE` varchar(45) DEFAULT NULL,
748 `USERID` varchar(10) DEFAULT NULL,
749 `CLIENTNAME` varchar(45) DEFAULT NULL,
750 `HDSTARTTIME` datetime DEFAULT NULL,
751 `HDENDTIME` datetime DEFAULT NULL,
752 PRIMARY KEY (`HCRESPONSEID`),
753 KEY `clientname_idx` (`CLIENTNAME`),
754 KEY `nodetype_idx` (`NODETYPE`),
755 KEY `hccode_idx` (`HCCODE`),
756 KEY `hcresponsestatus_idx` (`HCRESPONSESTATUS`),
757 KEY `hdstarttime_idx` (`HDSTARTTIME`),
758 KEY `hdendtime_idx` (`HDENDTIME`)
759 ) ENGINE=InnoDB AUTO_INCREMENT=15378 DEFAULT CHARSET=utf8;
760 /*!40101 SET character_set_client = @saved_cs_client */;
763 -- Table structure for table `OPS_HCTYPES`
766 DROP TABLE IF EXISTS `OPS_HCTYPES`;
767 /*!40101 SET @saved_cs_client = @@character_set_client */;
768 /*!40101 SET character_set_client = utf8 */;
769 CREATE TABLE `OPS_HCTYPES` (
770 `HCTYPEID` int(11) NOT NULL AUTO_INCREMENT,
771 `HCCODE` varchar(45) DEFAULT NULL,
772 `HCDESCR` varchar(45) DEFAULT NULL,
773 `HCNODETYPE` varchar(45) DEFAULT NULL,
774 `NODETYPEVERSION` varchar(15) DEFAULT NULL,
775 `STACKLEVEL` varchar(15) DEFAULT 'VM',
776 `ACTIVE` varchar(5) DEFAULT NULL,
777 `EXECPRIORITY` int(11) DEFAULT NULL,
778 `SBINTERFACE` varchar(45) DEFAULT 'ssh',
779 `SELECTABLE` varchar(2) DEFAULT 'Y',
780 `EXECTIME` int(11) DEFAULT '10' COMMENT 'expected execution time in secs',
781 `DEFAULT4NODETYPE` varchar(2) DEFAULT 'N' COMMENT 'default HD for this nodetype',
782 `CACHEDURATION` int(5) DEFAULT '2' COMMENT 'cache default is in minutes',
783 `LOGCMDRESP2DB` varchar(2) DEFAULT 'Y',
784 `VERSIONCHKHD` varchar(45) DEFAULT NULL,
785 `SBIALTSRVR` varchar(255) DEFAULT NULL,
786 `CREATEDON` datetime DEFAULT NULL,
787 `CREATEDBY` varchar(15) DEFAULT NULL,
788 `UPDATEDON` datetime DEFAULT NULL,
789 `UPDATEDBY` varchar(15) DEFAULT NULL,
790 PRIMARY KEY (`HCTYPEID`),
791 KEY `hcnodetype_idx` (`HCNODETYPE`),
792 KEY `hccode_idx` (`HCCODE`),
793 KEY `active_idx` (`ACTIVE`),
794 KEY `default4nodetype_idx` (`DEFAULT4NODETYPE`)
795 ) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;
796 /*!40101 SET character_set_client = @saved_cs_client */;
799 -- Temporary table structure for view `OPS_HCVIEW`
802 DROP TABLE IF EXISTS `OPS_HCVIEW`;
803 /*!50001 DROP VIEW IF EXISTS `OPS_HCVIEW`*/;
804 SET @saved_cs_client = @@character_set_client;
805 SET character_set_client = utf8;
806 /*!50001 CREATE VIEW `OPS_HCVIEW` AS SELECT
825 SET character_set_client = @saved_cs_client;
828 -- Table structure for table `OPS_HEALTHCHECK`
831 DROP TABLE IF EXISTS `OPS_HEALTHCHECK`;
832 /*!40101 SET @saved_cs_client = @@character_set_client */;
833 /*!40101 SET character_set_client = utf8 */;
834 CREATE TABLE `OPS_HEALTHCHECK` (
835 `HCID` int(11) NOT NULL AUTO_INCREMENT,
836 `HCCODE` varchar(45) DEFAULT NULL,
837 `COMMAND` varchar(512) DEFAULT NULL,
838 `ACTIVE` varchar(1) DEFAULT 'N',
839 `PROMPTCHECK` varchar(32) DEFAULT NULL,
840 `EXECPRIORITY` int(11) DEFAULT NULL,
841 `TIMEOUT` int(11) DEFAULT NULL,
842 `PATTERNMATCH` varchar(512) DEFAULT NULL,
843 `FLIPRXRSLT` varchar(45) NOT NULL DEFAULT 'N',
844 `EXITONFAIL` varchar(6) DEFAULT 'N',
845 `SENDCMDRESP` varchar(5) DEFAULT 'Y',
846 `MANUALEFFORT` int(11) DEFAULT '2' COMMENT 'manual execution estimate in mins',
847 `COMMANDDESC` varchar(100) DEFAULT NULL,
848 `VERSION` varchar(45) DEFAULT 'none',
849 `CREATEDON` datetime DEFAULT NULL,
850 `CREATEDBY` varchar(15) DEFAULT NULL,
851 `UPDATEDON` datetime DEFAULT NULL,
852 `UPDATEDBY` varchar(15) DEFAULT NULL,
853 PRIMARY KEY (`HCID`),
854 KEY `hccode_idx` (`HCCODE`),
855 KEY `active_idx` (`ACTIVE`)
856 ) ENGINE=InnoDB AUTO_INCREMENT=445 DEFAULT CHARSET=latin1;
857 /*!40101 SET character_set_client = @saved_cs_client */;
860 -- Table structure for table `OPS_HEALTHCHECKRESPONSE`
863 DROP TABLE IF EXISTS `OPS_HEALTHCHECKRESPONSE`;
864 /*!40101 SET @saved_cs_client = @@character_set_client */;
865 /*!40101 SET character_set_client = utf8 */;
866 CREATE TABLE `OPS_HEALTHCHECKRESPONSE` (
867 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
868 `HCTRANSID` varchar(128) DEFAULT NULL,
869 `REFHCTRANSID` varchar(128) DEFAULT NULL,
870 `SDNOTRANSID` varchar(255) DEFAULT NULL,
871 `HOSTIP` varchar(45) DEFAULT NULL,
872 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
873 `HCRESPONSE` longtext,
874 `CREATEDON` datetime DEFAULT NULL,
875 `SDNOINSTANCE` varchar(45) NOT NULL,
876 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
877 `DMAAPSENT` varchar(1) NOT NULL DEFAULT 'N',
878 `NODETYPE` varchar(45) DEFAULT NULL,
879 `HCCODE` varchar(45) DEFAULT NULL,
880 `USERID` varchar(10) DEFAULT NULL,
881 `CLIENTNAME` varchar(45) DEFAULT NULL,
882 `HDSTARTTIME` datetime DEFAULT NULL,
883 `HDENDTIME` datetime DEFAULT NULL,
884 PRIMARY KEY (`HCRESPONSEID`),
885 KEY `hctransid_idx` (`HCTRANSID`),
886 KEY `sdnotransid_idx` (`SDNOTRANSID`),
887 KEY `clientname_idx` (`CLIENTNAME`),
888 KEY `nodetype_idx` (`NODETYPE`),
889 KEY `hccode_idx` (`HCCODE`),
890 KEY `hostip_idx` (`HOSTIP`),
891 KEY `createdon_idx` (`CREATEDON`)
892 ) ENGINE=InnoDB AUTO_INCREMENT=15380 DEFAULT CHARSET=utf8;
893 /*!40101 SET character_set_client = @saved_cs_client */;
894 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
895 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
896 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
897 /*!50003 SET character_set_client = latin1 */ ;
898 /*!50003 SET character_set_results = latin1 */ ;
899 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
900 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
901 /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
903 /*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `OPS_HEALTHCHECKRESPONSE_BEFORE_INSERT` BEFORE INSERT ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
905 declare reftransid varchar(128);
907 declare ahostip varchar(45);
908 declare ahdcode varchar(45);
909 declare ahdendtime datetime;
910 declare ahdstarttime datetime;
911 declare acacheexpiretime datetime;
912 declare hdexectime INT DEFAULT 5;
913 declare hdexpectedendtime datetime;
914 declare nowtime datetime;
915 declare acacheduration INT;
916 declare maxtimeintbl INT DEFAULT 1800;
918 SET nowtime:=utc_timestamp();
919 SET ahdcode:=NEW.HCCODE;
920 SET ahostip:=NEW.HOSTIP;
921 SET reftransid:=trim(NEW.REFHCTRANSID);
922 SET new.CREATEDON = nowtime;
923 SET new.HDSTARTTIME = nowtime;
925 delete from OPS_HCRESPCACHE where HDENDTIME is null AND time_to_sec(timediff(nowtime, HDSTARTTIME))>maxtimeintbl;
927 IF (reftransid is null) then
928 select CACHEDURATION, EXECTIME into acacheduration, hdexectime from OPS_HCTYPES where HCCODE=ahdcode;
929 select count(*) into ccount from OPS_HCRESPCACHE where HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0;
931 select HDSTARTTIME, HDENDTIME, CACHEEXPIRETIME into ahdstarttime, ahdendtime, acacheexpiretime from OPS_HCRESPCACHE where
932 HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0 order by HDENDTIME desc limit 1 ;
933 select time_to_sec(timediff(ahdendtime, ahdstarttime)) into hdexectime;
936 if (acacheduration > 0) then
937 set hdexpectedendtime = nowtime + INTERVAL hdexectime second;
938 insert into OPS_HCRESPCACHE(HCRESPONSEID,SDNOTRANSID,HOSTIP,HCRESPONSESTATUS,HCRESPONSE,CREATEDON,SDNOINSTANCE,SDNOINSTANCESERVER,DMAAPSENT,
939 NODETYPE,HCCODE,USERID,CLIENTNAME,HDSTARTTIME,HDENDTIME,CACHEEXPIRETIME,HDEXPECTEDENDTIME)
940 VALUES(NEW.HCRESPONSEID,NEW.SDNOTRANSID,NEW.HOSTIP,null,null,nowtime,NEW.SDNOINSTANCE,NEW.SDNOINSTANCESERVER,NEW.DMAAPSENT,
941 NEW.NODETYPE,NEW.HCCODE,NEW.USERID,NEW.CLIENTNAME,NEW.HDSTARTTIME,null,null,hdexpectedendtime);
947 /*!50003 SET sql_mode = @saved_sql_mode */ ;
948 /*!50003 SET character_set_client = @saved_cs_client */ ;
949 /*!50003 SET character_set_results = @saved_cs_results */ ;
950 /*!50003 SET collation_connection = @saved_col_connection */ ;
951 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
952 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
953 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
954 /*!50003 SET character_set_client = latin1 */ ;
955 /*!50003 SET character_set_results = latin1 */ ;
956 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
957 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
958 /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
960 /*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `sdnctl`.`OPS_HEALTHCHECKRESPONSE_BEFORE_UPDATE` BEFORE UPDATE ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
962 Declare aduration INT;
963 declare reftransid varchar(128);
964 DECLARE cachetime datetime;
965 declare ahostip varchar(45);
966 declare ahdcode varchar(45);
967 declare ahdendtime datetime;
969 SET ahdcode:=NEW.HCCODE;
970 SET ahostip:=NEW.HOSTIP;
971 SET ahdendtime:=NEW.HDENDTIME;
972 SET reftransid:=trim(NEW.REFHCTRANSID);
974 if (NEW.DMAAPSENT in ('U','Y')) then
975 update OPS_HCRESPCACHE
976 set DMAAPSENT=NEW.DMAAPSENT where OLD.SDNOTRANSID=NEW.SDNOTRANSID and OLD.CREATEDON=NEW.CREATEDON;
977 ELSEIF (reftransid is null and OLD.HCRESPONSESTATUS is null) then
978 select cacheduration into aduration from OPS_HCTYPES where HCCODE=ahdcode;
979 if (aduration > 0) then
980 select ahdendtime + INTERVAL aduration MINUTE into cachetime from OPS_HCTYPES where HCCODE=ahdcode;
981 update OPS_HCRESPCACHE
982 set HCRESPONSESTATUS=NEW.HCRESPONSESTATUS,HCRESPONSE=NEW.HCRESPONSE,HDENDTIME=NEW.HDENDTIME,CACHEEXPIRETIME=cachetime,HDEXPECTEDENDTIME=null
983 where SDNOTRANSID=NEW.SDNOTRANSID and CREATEDON=NEW.CREATEDON;
984 insert into OPS_HCRESPCOMPACT (HCRESPONSEID, HCTRANSID, HOSTIP, HCRESPONSESTATUS, SDNOINSTANCE, SDNOINSTANCESERVER, NODETYPE, HCCODE, USERID, CLIENTNAME, HDSTARTTIME, HDENDTIME)
985 values(NEW.HCRESPONSEID, NEW.HCTRANSID, NEW.HOSTIP, NEW.HCRESPONSESTATUS, NEW.SDNOINSTANCE, NEW.SDNOINSTANCESERVER, NEW.NODETYPE, NEW.HCCODE, NEW.USERID, NEW.CLIENTNAME, NEW.HDSTARTTIME, NEW.HDENDTIME);
990 /*!50003 SET sql_mode = @saved_sql_mode */ ;
991 /*!50003 SET character_set_client = @saved_cs_client */ ;
992 /*!50003 SET character_set_results = @saved_cs_results */ ;
993 /*!50003 SET collation_connection = @saved_col_connection */ ;
996 -- Table structure for table `OPS_MAPNODETYPES`
999 DROP TABLE IF EXISTS `OPS_MAPNODETYPES`;
1000 /*!40101 SET @saved_cs_client = @@character_set_client */;
1001 /*!40101 SET character_set_client = utf8 */;
1002 CREATE TABLE `OPS_MAPNODETYPES` (
1003 `ID` int(11) NOT NULL AUTO_INCREMENT,
1004 `INNODETYPE` varchar(45) DEFAULT NULL COMMENT 'nodetype value in incoming API',
1005 `TBLNODETYPE` varchar(45) DEFAULT NULL COMMENT 'nodetype value as stored in db',
1007 KEY `tablnodetype_idx` (`TBLNODETYPE`)
1008 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1009 /*!40101 SET character_set_client = @saved_cs_client */;
1012 -- Table structure for table `OPS_NODEINFO`
1015 DROP TABLE IF EXISTS `OPS_NODEINFO`;
1016 /*!40101 SET @saved_cs_client = @@character_set_client */;
1017 /*!40101 SET character_set_client = utf8 */;
1018 CREATE TABLE `OPS_NODEINFO` (
1019 `NODEID` int(11) NOT NULL AUTO_INCREMENT,
1020 `NODETYPE` varchar(255) DEFAULT NULL,
1021 `HOSTIP` varchar(45) DEFAULT NULL,
1022 `STACKLEVEL` varchar(15) DEFAULT 'VM',
1023 `HOSTUSER` varchar(45) DEFAULT NULL,
1024 `HOSTPASSWORD` varchar(45) DEFAULT NULL,
1025 `PROMPTCMD` varchar(256) DEFAULT NULL,
1026 `PREPROMPTSTRS` varchar(45) DEFAULT NULL COMMENT 'Strings to send before login prompt',
1027 `LABNODETYPE` varchar(256) DEFAULT NULL,
1028 `MULTIVERSIONS` varchar(2) DEFAULT 'N',
1029 `JUMPSERVERIP` varchar(45) DEFAULT NULL,
1030 `JUMPSERVERUSER` varchar(45) DEFAULT NULL,
1031 `JUMPSERVERPASSWORD` varchar(45) DEFAULT NULL,
1032 `VSERVERID` varchar(128) DEFAULT NULL,
1033 `SELFSERVLINK` varchar(1024) DEFAULT NULL,
1034 `TENANTID` varchar(128) DEFAULT NULL,
1035 `IDENTITYURL` varchar(1024) DEFAULT NULL,
1036 PRIMARY KEY (`NODEID`),
1037 KEY `hostname_idx` (`NODETYPE`)
1038 ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
1039 /*!40101 SET character_set_client = @saved_cs_client */;
1042 -- Table structure for table `OPS_NODETYPE2SDNO`
1045 DROP TABLE IF EXISTS `OPS_NODETYPE2SDNO`;
1046 /*!40101 SET @saved_cs_client = @@character_set_client */;
1047 /*!40101 SET character_set_client = utf8 */;
1048 CREATE TABLE `OPS_NODETYPE2SDNO` (
1049 `VNFTYPEID` int(11) NOT NULL AUTO_INCREMENT,
1050 `VNFTYPECODE` varchar(45) DEFAULT NULL,
1051 `VNFTYPENAME` varchar(256) DEFAULT NULL,
1052 `VNFCLLI` varchar(20) DEFAULT NULL,
1053 `DEFAULT_4_UNK_CLLI` varchar(2) DEFAULT NULL,
1054 `SDNOINSTANCE` varchar(45) NOT NULL,
1055 PRIMARY KEY (`VNFTYPEID`)
1056 ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
1057 /*!40101 SET character_set_client = @saved_cs_client */;
1060 -- Table structure for table `OPS_NODE_PROPERTIES`
1063 DROP TABLE IF EXISTS `OPS_NODE_PROPERTIES`;
1064 /*!40101 SET @saved_cs_client = @@character_set_client */;
1065 /*!40101 SET character_set_client = utf8 */;
1066 CREATE TABLE `OPS_NODE_PROPERTIES` (
1067 `NODETYPE` varchar(64) NOT NULL,
1068 `PROPERTY` varchar(64) NOT NULL,
1069 `VALUE` varchar(128) NOT NULL,
1070 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1071 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1072 PRIMARY KEY (`NODETYPE`,`PROPERTY`)
1073 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1074 /*!40101 SET character_set_client = @saved_cs_client */;
1077 -- Table structure for table `OPS_SDNOINFO`
1080 DROP TABLE IF EXISTS `OPS_SDNOINFO`;
1081 /*!40101 SET @saved_cs_client = @@character_set_client */;
1082 /*!40101 SET character_set_client = utf8 */;
1083 CREATE TABLE `OPS_SDNOINFO` (
1084 `SDNOID` int(11) NOT NULL AUTO_INCREMENT,
1085 `SDNOINSTANCE` varchar(45) DEFAULT NULL,
1086 `URI` varchar(1000) NOT NULL,
1087 PRIMARY KEY (`SDNOID`),
1088 UNIQUE KEY `SDNOINSTANCE_UNIQUE` (`SDNOINSTANCE`)
1089 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
1090 /*!40101 SET character_set_client = @saved_cs_client */;
1093 -- Table structure for table `OPS_SQLMGR`
1096 DROP TABLE IF EXISTS `OPS_SQLMGR`;
1097 /*!40101 SET @saved_cs_client = @@character_set_client */;
1098 /*!40101 SET character_set_client = utf8 */;
1099 CREATE TABLE `OPS_SQLMGR` (
1100 `SQLID` int(11) NOT NULL AUTO_INCREMENT,
1102 `SQLSTATUS` int(11) DEFAULT '0',
1103 `COMMENTS` varchar(255) DEFAULT NULL,
1104 `CREATEDBY` varchar(15) DEFAULT NULL,
1105 `CREATEDON` datetime DEFAULT NULL,
1106 PRIMARY KEY (`SQLID`)
1107 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1108 /*!40101 SET character_set_client = @saved_cs_client */;
1111 -- Table structure for table `OPS_TRUSTED_PARTNER`
1114 DROP TABLE IF EXISTS `OPS_TRUSTED_PARTNER`;
1115 /*!40101 SET @saved_cs_client = @@character_set_client */;
1116 /*!40101 SET character_set_client = utf8 */;
1117 CREATE TABLE `OPS_TRUSTED_PARTNER` (
1118 `PARTNERID` int(11) NOT NULL AUTO_INCREMENT,
1119 `PARTNER_NAME` varchar(256) NOT NULL,
1120 `PARTNER_PUBLIC_KEY` varchar(1024) DEFAULT NULL,
1121 PRIMARY KEY (`PARTNERID`)
1122 ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
1123 /*!40101 SET character_set_client = @saved_cs_client */;
1126 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
1129 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
1130 /*!40101 SET @saved_cs_client = @@character_set_client */;
1131 /*!40101 SET character_set_client = utf8 */;
1132 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
1133 `PREPARE_FILE_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
1134 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
1135 `REQUEST_ID` varchar(255) DEFAULT NULL,
1136 `CONFIG_FILE_ID` int(11) DEFAULT NULL,
1137 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
1138 PRIMARY KEY (`PREPARE_FILE_RELATIONSHIP_ID`),
1139 UNIQUE KEY `PREPARE_FILE_RELATIONSHIP_ID` (`PREPARE_FILE_RELATIONSHIP_ID`),
1140 KEY `ie_prepare_file_relationship` (`CONFIG_FILE_ID`),
1141 KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
1142 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
1143 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
1144 ) ENGINE=InnoDB AUTO_INCREMENT=8607 DEFAULT CHARSET=latin1;
1145 /*!40101 SET character_set_client = @saved_cs_client */;
1148 -- Table structure for table `PROCESS_FLOW_REFERENCE`
1151 DROP TABLE IF EXISTS `PROCESS_FLOW_REFERENCE`;
1152 /*!40101 SET @saved_cs_client = @@character_set_client */;
1153 /*!40101 SET character_set_client = utf8 */;
1154 CREATE TABLE `PROCESS_FLOW_REFERENCE` (
1155 `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1156 `ACTION` varchar(50) NOT NULL,
1157 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
1158 `PROTOCOL` varchar(50) DEFAULT NULL,
1159 `EXECUTION_TYPE` varchar(100) NOT NULL,
1160 `EXECUTION_MODULE` varchar(100) NOT NULL,
1161 `EXECUTION_RPC` varchar(100) NOT NULL,
1162 `UPDATED_DATE` datetime DEFAULT NULL,
1163 `GET_RUNNING_CONFIG` varchar(50) DEFAULT NULL,
1164 PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),
1165 UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)
1166 ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
1167 /*!40101 SET character_set_client = @saved_cs_client */;
1170 -- Table structure for table `PROTOCOL_REFERENCE`
1173 DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
1174 /*!40101 SET @saved_cs_client = @@character_set_client */;
1175 /*!40101 SET character_set_client = utf8 */;
1176 CREATE TABLE `PROTOCOL_REFERENCE` (
1177 `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1178 `ACTION` varchar(50) NOT NULL,
1179 `VNF_TYPE` varchar(150) DEFAULT NULL,
1180 `PROTOCOL` varchar(50) DEFAULT NULL,
1181 `UPDATED_DATE` datetime DEFAULT NULL,
1182 `TEMPLATE` varchar(45) DEFAULT NULL,
1183 `ACTION_LEVEL` varchar(45) DEFAULT NULL,
1184 PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
1185 UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
1186 ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;
1187 /*!40101 SET character_set_client = @saved_cs_client */;
1190 -- Table structure for table `REQUEST_ARTIFACTS`
1193 DROP TABLE IF EXISTS `REQUEST_ARTIFACTS`;
1194 /*!40101 SET @saved_cs_client = @@character_set_client */;
1195 /*!40101 SET character_set_client = utf8 */;
1196 CREATE TABLE `REQUEST_ARTIFACTS` (
1197 `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
1198 `REQUEST_ID` varchar(50) NOT NULL,
1199 `ACTION` varchar(50) NOT NULL,
1200 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
1201 `VNF_TYPE` varchar(150) DEFAULT NULL,
1202 `CATEGORY` varchar(50) NOT NULL,
1203 `ARTIFACT_CONTENT` longtext,
1204 `UPDATED_DATE` datetime DEFAULT NULL,
1205 PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
1206 UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
1207 ) ENGINE=InnoDB AUTO_INCREMENT=10273 DEFAULT CHARSET=latin1;
1208 /*!40101 SET character_set_client = @saved_cs_client */;
1211 -- Table structure for table `SVC_LOGIC`
1214 DROP TABLE IF EXISTS `SVC_LOGIC`;
1215 /*!40101 SET @saved_cs_client = @@character_set_client */;
1216 /*!40101 SET character_set_client = utf8 */;
1217 CREATE TABLE `SVC_LOGIC` (
1218 `module` varchar(80) NOT NULL,
1219 `rpc` varchar(80) NOT NULL,
1220 `version` varchar(40) NOT NULL,
1221 `mode` varchar(5) NOT NULL,
1222 `active` varchar(1) NOT NULL,
1224 `md5sum` varchar(32) NOT NULL DEFAULT '',
1225 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
1226 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1227 /*!40101 SET character_set_client = @saved_cs_client */;
1230 -- Table structure for table `TRANSACTIONS`
1233 DROP TABLE IF EXISTS `TRANSACTIONS`;
1234 /*!40101 SET @saved_cs_client = @@character_set_client */;
1235 /*!40101 SET character_set_client = utf8 */;
1236 CREATE TABLE `TRANSACTIONS` (
1237 `TRANSACTION_ID` varchar(75) NOT NULL,
1238 `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
1239 `REQUEST_ID` varchar(256) NOT NULL,
1240 `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
1241 `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
1242 `START_TIME` datetime(3) NOT NULL,
1243 `END_TIME` datetime(3) DEFAULT NULL,
1244 `TARGET_ID` varchar(256) DEFAULT NULL,
1245 `TARGET_TYPE` varchar(256) DEFAULT NULL,
1246 `OPERATION` varchar(256) NOT NULL,
1247 `RESULT_CODE` int(11) DEFAULT NULL,
1249 `STATE` varchar(50) NOT NULL,
1250 `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
1251 `VNFC_NAME` varchar(256) DEFAULT NULL,
1252 `VSERVER_ID` varchar(256) DEFAULT NULL,
1253 `VF_MODULE_ID` varchar(256) DEFAULT NULL,
1254 `MODE` varchar(50) NOT NULL,
1255 PRIMARY KEY (`TRANSACTION_ID`)
1256 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1257 /*!40101 SET character_set_client = @saved_cs_client */;
1260 -- Table structure for table `UPLOAD_CONFIG`
1263 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
1264 /*!40101 SET @saved_cs_client = @@character_set_client */;
1265 /*!40101 SET character_set_client = utf8 */;
1266 CREATE TABLE `UPLOAD_CONFIG` (
1267 `UPLOAD_CONFIG_ID` int(11) NOT NULL AUTO_INCREMENT,
1268 `REQUEST_ID` varchar(50) DEFAULT NULL,
1269 `ORIGINATOR_ID` varchar(50) DEFAULT NULL,
1270 `SERVICE_DESCRIPTION` varchar(100) DEFAULT NULL,
1271 `ACTION` varchar(50) DEFAULT NULL,
1272 `UPLOAD_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1273 `VNF_ID` varchar(50) DEFAULT NULL,
1274 `VNF_NAME` varchar(50) DEFAULT NULL,
1275 `VM_NAME` varchar(50) DEFAULT NULL,
1276 `VNF_TYPE` varchar(150) DEFAULT NULL,
1277 `VNFC_TYPE` varchar(50) DEFAULT NULL,
1278 `HOST_IP_ADDRESS` varchar(50) DEFAULT NULL,
1279 `CONFIG_INDICATOR` varchar(25) DEFAULT NULL,
1280 `PENDING_DELETE` varchar(1) DEFAULT NULL,
1282 PRIMARY KEY (`UPLOAD_CONFIG_ID`),
1283 UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`),
1284 KEY `VNF_ID` (`VNF_ID`)
1285 ) ENGINE=InnoDB AUTO_INCREMENT=1656 DEFAULT CHARSET=latin1;
1286 /*!40101 SET character_set_client = @saved_cs_client */;
1289 -- Table structure for table `VNFC_DG_MAPPING`
1292 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
1293 /*!40101 SET @saved_cs_client = @@character_set_client */;
1294 /*!40101 SET character_set_client = utf8 */;
1295 CREATE TABLE `VNFC_DG_MAPPING` (
1296 `VNFC_DG_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
1297 `ACTION` varchar(50) DEFAULT NULL,
1298 `API_VERSION` varchar(10) DEFAULT NULL,
1299 `VNF_TYPE` varchar(150) DEFAULT NULL,
1300 `VNFC_TYPE` varchar(50) DEFAULT NULL,
1301 `DG_NAME` varchar(50) NOT NULL,
1302 `DG_VERSION` varchar(50) DEFAULT NULL,
1303 `DG_MODULE` varchar(50) NOT NULL,
1304 PRIMARY KEY (`VNFC_DG_MAPPING_ID`)
1305 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
1306 /*!40101 SET character_set_client = @saved_cs_client */;
1309 -- Table structure for table `VNFC_REFERENCE`
1312 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
1313 /*!40101 SET @saved_cs_client = @@character_set_client */;
1314 /*!40101 SET character_set_client = utf8 */;
1315 CREATE TABLE `VNFC_REFERENCE` (
1316 `VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1317 `ACTION` varchar(50) NOT NULL,
1318 `VNF_TYPE` varchar(150) DEFAULT NULL,
1319 `VM_INSTANCE` int(11) NOT NULL,
1320 `VNFC_INSTANCE` int(11) NOT NULL,
1321 `VNFC_TYPE` varchar(50) NOT NULL,
1322 `VNFC_FUNCTION_CODE` varchar(50) NOT NULL,
1323 `IPADDRESS_V4_OAM_VIP` varchar(50) DEFAULT NULL,
1324 `GROUP_NOTATION_TYPE` varchar(50) DEFAULT NULL,
1325 `GROUP_NOTATION_VALUE` varchar(50) DEFAULT NULL,
1326 `TEMPLATE_ID` varchar(100) DEFAULT NULL,
1327 PRIMARY KEY (`VNFC_REFERENCE_ID`),
1328 UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
1329 ) ENGINE=InnoDB AUTO_INCREMENT=688 DEFAULT CHARSET=latin1;
1330 /*!40101 SET character_set_client = @saved_cs_client */;
1333 -- Table structure for table `VNF_DG_MAPPING`
1336 DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
1337 /*!40101 SET @saved_cs_client = @@character_set_client */;
1338 /*!40101 SET character_set_client = utf8 */;
1339 CREATE TABLE `VNF_DG_MAPPING` (
1340 `VNF_DG_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
1341 `ACTION` varchar(50) NOT NULL,
1342 `API_VERSION` varchar(50) DEFAULT NULL,
1343 `VNF_TYPE` varchar(150) DEFAULT NULL,
1344 `VNF_VERSION` varchar(50) DEFAULT NULL,
1345 `DG_NAME` varchar(50) NOT NULL,
1346 `DG_VERSION` varchar(50) DEFAULT NULL,
1347 `DG_MODULE` varchar(50) NOT NULL,
1348 PRIMARY KEY (`VNF_DG_MAPPING_ID`)
1349 ) ENGINE=InnoDB AUTO_INCREMENT=576 DEFAULT CHARSET=latin1;
1350 /*!40101 SET character_set_client = @saved_cs_client */;
1353 -- Table structure for table `VNF_LOCK_MANAGEMENT`
1356 DROP TABLE IF EXISTS `VNF_LOCK_MANAGEMENT`;
1357 /*!40101 SET @saved_cs_client = @@character_set_client */;
1358 /*!40101 SET character_set_client = utf8 */;
1359 CREATE TABLE `VNF_LOCK_MANAGEMENT` (
1360 `RESOURCE_ID` varchar(50) NOT NULL,
1361 `OWNER_ID` varchar(255) DEFAULT NULL,
1362 `UPDATED` bigint(20) unsigned NOT NULL,
1363 `TIMEOUT` int(10) unsigned NOT NULL,
1364 `VER` int(10) unsigned NOT NULL DEFAULT '1',
1365 PRIMARY KEY (`RESOURCE_ID`)
1366 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1367 /*!40101 SET character_set_client = @saved_cs_client */;
1370 -- Table structure for table `VNF_STATE_MANAGEMENT`
1373 DROP TABLE IF EXISTS `VNF_STATE_MANAGEMENT`;
1374 /*!40101 SET @saved_cs_client = @@character_set_client */;
1375 /*!40101 SET character_set_client = utf8 */;
1376 CREATE TABLE `VNF_STATE_MANAGEMENT` (
1377 `VNF_ID` varchar(50) NOT NULL,
1378 `STATE` varchar(50) NOT NULL,
1379 `OWNER_ID` varchar(255) DEFAULT NULL,
1380 `UPDATED` bigint(20) unsigned NOT NULL,
1381 `VER` int(10) unsigned NOT NULL DEFAULT '1',
1382 PRIMARY KEY (`VNF_ID`)
1383 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1384 /*!40101 SET character_set_client = @saved_cs_client */;
1386 SET FOREIGN_KEY_CHECKS = 1;
1388 -- Current Database: `sdnctl`
1394 -- Final view structure for view `DEVICE_CONFIGURATION`
1397 /*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
1398 /*!50001 SET @saved_cs_client = @@character_set_client */;
1399 /*!50001 SET @saved_cs_results = @@character_set_results */;
1400 /*!50001 SET @saved_col_connection = @@collation_connection */;
1401 /*!50001 SET character_set_client = utf8 */;
1402 /*!50001 SET character_set_results = utf8 */;
1403 /*!50001 SET collation_connection = utf8_general_ci */;
1404 /*!50001 CREATE ALGORITHM=UNDEFINED */
1405 /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
1406 /*!50001 VIEW `DEVICE_CONFIGURATION` AS select 1 AS `UPLOAD_CONFIG_ID`,1 AS `REQUEST_ID`,1 AS `ORIGINATOR_ID`,1 AS `SERVICE_DESCRIPTION`,1 AS `ACTION`,1 AS `UPLOAD_DATE`,1 AS `VNF_ID`,1 AS `VNF_NAME`,1 AS `VM_NAME`,1 AS `VNF_TYPE`,1 AS `VNFC_TYPE`,1 AS `HOST_IP_ADDRESS`,1 AS `CONFIG_INDICATOR`,1 AS `PENDING_DELETE`,1 AS `CONTENT` */;
1407 /*!50001 SET character_set_client = @saved_cs_client */;
1408 /*!50001 SET character_set_results = @saved_cs_results */;
1409 /*!50001 SET collation_connection = @saved_col_connection */;
1412 -- Final view structure for view `OPS_HCRESPCACHEVIEW`
1415 /*!50001 DROP VIEW IF EXISTS `OPS_HCRESPCACHEVIEW`*/;
1416 /*!50001 SET @saved_cs_client = @@character_set_client */;
1417 /*!50001 SET @saved_cs_results = @@character_set_results */;
1418 /*!50001 SET @saved_col_connection = @@collation_connection */;
1419 /*!50001 SET character_set_client = utf8 */;
1420 /*!50001 SET character_set_results = utf8 */;
1421 /*!50001 SET collation_connection = utf8_general_ci */;
1422 /*!50001 CREATE ALGORITHM=UNDEFINED */
1423 /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
1424 /*!50001 VIEW `OPS_HCRESPCACHEVIEW` AS select 1 AS `ACTIVE`,1 AS `HCRESPONSEID`,1 AS `SDNOTRANSID`,1 AS `HOSTIP`,1 AS `HCRESPONSESTATUS`,1 AS `HCRESPONSE`,1 AS `CREATEDON`,1 AS `SDNOINSTANCE`,1 AS `SDNOINSTANCESERVER`,1 AS `DMAAPSENT`,1 AS `NODETYPE`,1 AS `HCCODE`,1 AS `USERID`,1 AS `CLIENTNAME`,1 AS `HDSTARTTIME`,1 AS `HDENDTIME`,1 AS `CACHEEXPIRETIME`,1 AS `HDEXPECTEDENDTIME` */;
1425 /*!50001 SET character_set_client = @saved_cs_client */;
1426 /*!50001 SET character_set_results = @saved_cs_results */;
1427 /*!50001 SET collation_connection = @saved_col_connection */;
1430 -- Final view structure for view `OPS_HCVIEW`
1433 /*!50001 DROP VIEW IF EXISTS `OPS_HCVIEW`*/;
1434 /*!50001 SET @saved_cs_client = @@character_set_client */;
1435 /*!50001 SET @saved_cs_results = @@character_set_results */;
1436 /*!50001 SET @saved_col_connection = @@collation_connection */;
1437 /*!50001 SET character_set_client = utf8 */;
1438 /*!50001 SET character_set_results = utf8 */;
1439 /*!50001 SET collation_connection = utf8_general_ci */;
1440 /*!50001 CREATE ALGORITHM=UNDEFINED */
1441 /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
1442 /*!50001 VIEW `OPS_HCVIEW` AS select 1 AS `HCCODE`,1 AS `CHCCODE`,1 AS `HCNODETYPE2`,1 AS `STACKLEVEL`,1 AS `SBINTERFACE`,1 AS `COMMAND`,1 AS `COMMANDDESC`,1 AS `EXITONFAIL`,1 AS `PATTERNMATCH`,1 AS `TIMEOUT`,1 AS `PROMPTCHECK`,1 AS `SENDCMDRESP`,1 AS `MANUALEFFORT`,1 AS `FLIPRXRSLT`,1 AS `EXECPRIORITY`,1 AS `VERSION`,1 AS `GPRIORITY`,1 AS `HCNODETYPE` */;
1443 /*!50001 SET character_set_client = @saved_cs_client */;
1444 /*!50001 SET character_set_results = @saved_cs_results */;
1445 /*!50001 SET collation_connection = @saved_col_connection */;