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 /*!32312 IF NOT EXISTS*/ `sdnctl` /*!40100 DEFAULT CHARACTER SET latin1 */;
27 SET FOREIGN_KEY_CHECKS = 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_HEALTH`
48 DROP TABLE IF EXISTS `APPC_HEALTH`;
49 /*!40101 SET @saved_cs_client = @@character_set_client */;
50 /*!40101 SET character_set_client = utf8 */;
51 CREATE TABLE `APPC_HEALTH` (
52 `APPC_HEALTH_ID` int(11) NOT NULL AUTO_INCREMENT,
53 `HEALTHY` varchar(30) NOT NULL,
54 PRIMARY KEY (`APPC_HEALTH_ID`)
55 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
56 /*!40101 SET character_set_client = @saved_cs_client */;
59 -- Table structure for table `ASDC_ARTIFACTS`
62 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
63 /*!40101 SET @saved_cs_client = @@character_set_client */;
64 /*!40101 SET character_set_client = utf8 */;
65 CREATE TABLE `ASDC_ARTIFACTS` (
66 `ASDC_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
67 `SERVICE_UUID` varchar(50) DEFAULT NULL,
68 `DISTRIBUTION_ID` varchar(50) DEFAULT NULL,
69 `SERVICE_NAME` varchar(255) DEFAULT NULL,
70 `SERVICE_DESCRIPTION` varchar(255) DEFAULT NULL,
71 `RESOURCE_UUID` varchar(255) DEFAULT NULL,
72 `RESOURCE_INSTANCE_NAME` varchar(255) DEFAULT NULL,
73 `RESOURCE_NAME` varchar(255) DEFAULT NULL,
74 `RESOURCE_VERSION` varchar(50) DEFAULT NULL,
75 `RESOURCE_TYPE` varchar(50) DEFAULT NULL,
76 `ARTIFACT_UUID` varchar(50) DEFAULT NULL,
77 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
78 `ARTIFACT_VERSION` varchar(25) DEFAULT NULL,
79 `ARTIFACT_DESCRIPTION` varchar(255) DEFAULT NULL,
80 `INTERNAL_VERSION` int(11) DEFAULT NULL,
81 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
82 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
83 `ARTIFACT_CONTENT` longtext,
84 PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
85 UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
86 ) ENGINE=InnoDB AUTO_INCREMENT=1219 DEFAULT CHARSET=latin1;
87 /*!40101 SET character_set_client = @saved_cs_client */;
90 -- Table structure for table `ASDC_REFERENCE`
93 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
94 /*!40101 SET @saved_cs_client = @@character_set_client */;
95 /*!40101 SET character_set_client = utf8 */;
96 CREATE TABLE `ASDC_REFERENCE` (
97 `ASDC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
98 `VNF_TYPE` varchar(150) DEFAULT NULL,
99 `VNFC_TYPE` varchar(50) DEFAULT NULL,
100 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
101 `ACTION` varchar(50) DEFAULT NULL,
102 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
103 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
104 PRIMARY KEY (`ASDC_REFERENCE_ID`),
105 UNIQUE KEY `ASDC_REFERENCE_ID` (`ASDC_REFERENCE_ID`)
106 ) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=latin1;
107 /*!40101 SET character_set_client = @saved_cs_client */;
110 -- Table structure for table `CONFIGFILES`
113 DROP TABLE IF EXISTS `CONFIGFILES`;
114 /*!40101 SET @saved_cs_client = @@character_set_client */;
115 /*!40101 SET character_set_client = utf8 */;
116 CREATE TABLE `CONFIGFILES` (
117 `CONFIG_FILE_ID` int(11) NOT NULL AUTO_INCREMENT,
118 `EXTERNAL_VERSION` varchar(50) DEFAULT NULL,
119 `DATA_SOURCE` varchar(25) DEFAULT NULL,
120 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
121 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
122 `VNF_TYPE` varchar(150) DEFAULT NULL,
123 `VNFC_TYPE` varchar(50) DEFAULT NULL,
124 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
125 `FILE_NAME` varchar(255) DEFAULT NULL,
126 `FILE_CONTENT` longtext,
127 `ACTION` varchar(50) DEFAULT NULL,
128 `VNF_ID` varchar(50) DEFAULT NULL,
129 `VM_NAME` varchar(50) DEFAULT NULL,
130 `VNF_NAME` varchar(50) DEFAULT NULL,
131 PRIMARY KEY (`CONFIG_FILE_ID`),
132 UNIQUE KEY `CONFIG_FILE_ID` (`CONFIG_FILE_ID`)
133 ) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=latin1;
134 /*!40101 SET character_set_client = @saved_cs_client */;
137 -- Table structure for table `CONFIGURE_ACTION_DG`
140 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
141 /*!40101 SET @saved_cs_client = @@character_set_client */;
142 /*!40101 SET character_set_client = utf8 */;
143 CREATE TABLE `CONFIGURE_ACTION_DG` (
144 `CONFIGURE_ACTION_DG_ID` int(11) NOT NULL AUTO_INCREMENT,
145 `VNF_TYPE` varchar(150) DEFAULT NULL,
146 `ACTION` varchar(50) DEFAULT NULL,
147 `GENERATE_CONFIG_DG` varchar(50) DEFAULT NULL,
148 `DOWNLOAD_CONFIG_DG` varchar(50) DEFAULT NULL,
149 PRIMARY KEY (`CONFIGURE_ACTION_DG_ID`),
150 UNIQUE KEY ` CONFIGURE_ACTION_DG_ID` (`CONFIGURE_ACTION_DG_ID`)
151 ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
152 /*!40101 SET character_set_client = @saved_cs_client */;
155 -- Table structure for table `CONFIG_FILE_REFERENCE`
158 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
159 /*!40101 SET @saved_cs_client = @@character_set_client */;
160 /*!40101 SET character_set_client = utf8 */;
161 CREATE TABLE `CONFIG_FILE_REFERENCE` (
162 `CONFIG_FILE_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
163 `SITE_LOCATION` varchar(50) DEFAULT NULL,
164 `VNF_TYPE` varchar(150) DEFAULT NULL,
165 `IMPORT_TYPE` varchar(50) DEFAULT NULL,
166 `FILE_TYPE` varchar(50) DEFAULT NULL,
167 `SOURCE_SERVER_NAME` varchar(255) DEFAULT NULL,
168 `SOURCE_FILE_PATH` varchar(255) DEFAULT NULL,
169 `TARGET_FILE_PATH` varchar(255) DEFAULT NULL,
170 `NAME` varchar(50) DEFAULT NULL,
171 `FILE_NAME` varchar(255) DEFAULT NULL,
172 PRIMARY KEY (`CONFIG_FILE_REFERENCE_ID`),
173 UNIQUE KEY `CONFIG_FILE_REFERENCE_ID` (`CONFIG_FILE_REFERENCE_ID`)
174 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
175 /*!40101 SET character_set_client = @saved_cs_client */;
178 -- Table structure for table `CONFIG_TRANSACTION_LOG`
181 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
182 /*!40101 SET @saved_cs_client = @@character_set_client */;
183 /*!40101 SET character_set_client = utf8 */;
184 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
185 `CONFIG_TRANSACTION_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
186 `REQUEST_ID` varchar(50) DEFAULT NULL,
187 `MESSAGE_TYPE` varchar(50) DEFAULT NULL,
188 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
190 PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
191 UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
192 ) ENGINE=InnoDB AUTO_INCREMENT=6470 DEFAULT CHARSET=latin1;
193 /*!40101 SET character_set_client = @saved_cs_client */;
196 -- Table structure for table `DEVICE_AUTHENTICATION`
199 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
200 /*!40101 SET @saved_cs_client = @@character_set_client */;
201 /*!40101 SET character_set_client = utf8 */;
202 CREATE TABLE `DEVICE_AUTHENTICATION` (
203 `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
204 `VNF_TYPE` varchar(255) NOT NULL,
205 `PROTOCOL` varchar(255) NOT NULL,
206 `ACTION` varchar(255) NOT NULL,
207 `USER_NAME` varchar(255) DEFAULT NULL,
208 `PASSWORD` varchar(255) DEFAULT NULL,
209 `PORT_NUMBER` int(11) DEFAULT NULL,
210 `URL` varchar(1024) DEFAULT NULL,
211 PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
212 UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`),
213 KEY `PROTOCOL` (`PROTOCOL`),
214 KEY `ACTION` (`ACTION`)
215 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
216 /*!40101 SET character_set_client = @saved_cs_client */;
219 -- Temporary table structure for view `DEVICE_CONFIGURATION`
222 DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
223 /*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
224 SET @saved_cs_client = @@character_set_client;
225 SET character_set_client = utf8;
226 /*!50001 CREATE VIEW `DEVICE_CONFIGURATION` AS SELECT
227 1 AS `UPLOAD_CONFIG_ID`,
229 1 AS `ORIGINATOR_ID`,
230 1 AS `SERVICE_DESCRIPTION`,
238 1 AS `HOST_IP_ADDRESS`,
239 1 AS `CONFIG_INDICATOR`,
240 1 AS `PENDING_DELETE`,
242 SET character_set_client = @saved_cs_client;
245 -- Table structure for table `DEVICE_INTERFACE_LOG`
248 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
249 /*!40101 SET @saved_cs_client = @@character_set_client */;
250 /*!40101 SET character_set_client = utf8 */;
251 CREATE TABLE `DEVICE_INTERFACE_LOG` (
252 `DEVICE_INTERFACE_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
253 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
254 `REQUEST_ID` varchar(50) DEFAULT NULL,
255 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
257 PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
258 UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
259 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
260 /*!40101 SET character_set_client = @saved_cs_client */;
263 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
266 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
267 /*!40101 SET @saved_cs_client = @@character_set_client */;
268 /*!40101 SET character_set_client = utf8 */;
269 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
270 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
271 `VNF_TYPE` varchar(150) DEFAULT NULL,
272 `PROTOCOL` varchar(50) DEFAULT NULL,
273 `MODULE` varchar(50) DEFAULT NULL,
274 `DG_RPC` varchar(50) DEFAULT NULL,
275 PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
276 UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`)
277 ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
278 /*!40101 SET character_set_client = @saved_cs_client */;
281 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
284 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
285 /*!40101 SET @saved_cs_client = @@character_set_client */;
286 /*!40101 SET character_set_client = utf8 */;
287 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
288 `DOWNLOAD_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
289 `VNF_TYPE` varchar(150) DEFAULT NULL,
290 `PROTOCOL` varchar(50) NOT NULL,
292 PRIMARY KEY (`DOWNLOAD_CONFIG_TEMPLATE_ID`),
293 UNIQUE KEY `DOWNLOAD_CONFIG_TEMPLATE_ID` (`DOWNLOAD_CONFIG_TEMPLATE_ID`)
294 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
295 /*!40101 SET character_set_client = @saved_cs_client */;
298 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
301 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
302 /*!40101 SET @saved_cs_client = @@character_set_client */;
303 /*!40101 SET character_set_client = utf8 */;
304 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
305 `DOWNLOAD_DG_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
306 `PROTOCOL` varchar(50) NOT NULL,
307 `DOWNLOAD_CONFIG_DG` varchar(50) NOT NULL,
308 PRIMARY KEY (`DOWNLOAD_DG_REFERENCE_ID`),
309 UNIQUE KEY ` DOWNLOAD_DG_REFERENCE_ID` (`DOWNLOAD_DG_REFERENCE_ID`)
310 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
311 /*!40101 SET character_set_client = @saved_cs_client */;
314 -- Table structure for table `DT_ACTION_STATUS`
317 DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
318 /*!40101 SET @saved_cs_client = @@character_set_client */;
319 /*!40101 SET character_set_client = utf8 */;
320 CREATE TABLE `DT_ACTION_STATUS` (
321 `DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
322 `ACTION` varchar(50) NOT NULL,
323 `VNF_TYPE` varchar(150) DEFAULT NULL,
324 `VNFC_TYPE` varchar(50) DEFAULT NULL,
325 `USER` varchar(50) NOT NULL,
326 `TECHNOLOGY` varchar(50) DEFAULT NULL,
327 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
328 `STATUS` varchar(50) NOT NULL,
329 PRIMARY KEY (`DT_ACTION_STATUS_ID`),
330 UNIQUE KEY `DT_ACTION_STATUS_ID` (`DT_ACTION_STATUS_ID`)
331 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
332 /*!40101 SET character_set_client = @saved_cs_client */;
335 -- Table structure for table `DT_ARTIFACT_REFERENCE`
338 DROP TABLE IF EXISTS `DT_ARTIFACT_REFERENCE`;
339 /*!40101 SET @saved_cs_client = @@character_set_client */;
340 /*!40101 SET character_set_client = utf8 */;
341 CREATE TABLE `DT_ARTIFACT_REFERENCE` (
342 `DT_ARTIFACT_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
343 `PROTOCOL` varchar(50) DEFAULT NULL,
344 `ACTION` varchar(50) DEFAULT NULL,
345 `ARTIFACT_TYPE` varchar(50) NOT NULL,
346 `ARTIFACT_PRIORITY` int(11) NOT NULL,
347 PRIMARY KEY (`DT_ARTIFACT_REFERENCE_ID`),
348 UNIQUE KEY `DT_ARTIFACT_REFERENCE_ID` (`DT_ARTIFACT_REFERENCE_ID`)
349 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
350 /*!40101 SET character_set_client = @saved_cs_client */;
353 -- Table structure for table `DT_ARTIFACT_TRACKING`
356 DROP TABLE IF EXISTS `DT_ARTIFACT_TRACKING`;
357 /*!40101 SET @saved_cs_client = @@character_set_client */;
358 /*!40101 SET character_set_client = utf8 */;
359 CREATE TABLE `DT_ARTIFACT_TRACKING` (
360 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL AUTO_INCREMENT,
361 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
362 `ASDC_REFERENCE_ID` int(11) DEFAULT NULL,
363 `USER` varchar(50) NOT NULL,
364 `TECHNOLOGY` varchar(50) DEFAULT NULL,
365 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
366 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
367 `ARTIFACT_STATUS` varchar(50) NOT NULL,
368 `IN_CART` varchar(50) DEFAULT NULL,
369 `PROTOCOL` varchar(50) DEFAULT NULL,
370 PRIMARY KEY (`DT_ARTIFACT_TRACKING_ID`),
371 UNIQUE KEY `DT_ARTIFACT_TRACKING_ID` (`DT_ARTIFACT_TRACKING_ID`)
372 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
373 /*!40101 SET character_set_client = @saved_cs_client */;
376 -- Table structure for table `DT_GUI_REFERENCE`
379 DROP TABLE IF EXISTS `DT_GUI_REFERENCE`;
380 /*!40101 SET @saved_cs_client = @@character_set_client */;
381 /*!40101 SET character_set_client = utf8 */;
382 CREATE TABLE `DT_GUI_REFERENCE` (
383 `DT_GUI_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
384 `GUI_NAME` varchar(50) NOT NULL,
385 `FIELD_NAME` varchar(50) NOT NULL,
386 `VALUE` varchar(50) NOT NULL,
387 `USER` varchar(50) NOT NULL,
388 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
389 `PROTOCOL` varchar(50) DEFAULT NULL,
390 `ACTION` varchar(50) DEFAULT NULL,
391 PRIMARY KEY (`DT_GUI_REFERENCE_ID`),
392 UNIQUE KEY `DT_GUI_REFERENCE_ID` (`DT_GUI_REFERENCE_ID`)
393 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
394 /*!40101 SET character_set_client = @saved_cs_client */;
397 -- Table structure for table `DT_STATUS_RELATIONSHIP`
400 DROP TABLE IF EXISTS `DT_STATUS_RELATIONSHIP`;
401 /*!40101 SET @saved_cs_client = @@character_set_client */;
402 /*!40101 SET character_set_client = utf8 */;
403 CREATE TABLE `DT_STATUS_RELATIONSHIP` (
404 `DT_STATUS_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
405 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL,
406 `DT_ACTION_STATUS_ID` int(11) NOT NULL,
407 PRIMARY KEY (`DT_STATUS_RELATIONSHIP_ID`),
408 UNIQUE KEY `DT_STATUS_RELATIONSHIP_ID` (`DT_STATUS_RELATIONSHIP_ID`),
409 KEY `IE_DT_STATUS_RELATIONSHIP` (`DT_ARTIFACT_TRACKING_ID`),
410 KEY `IE2_DT_STATUS_RELATIONSHIP` (`DT_ACTION_STATUS_ID`),
411 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,
412 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
413 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
414 /*!40101 SET character_set_client = @saved_cs_client */;
417 -- Table structure for table `GET_CONFIG_TEMPLATE`
420 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
421 /*!40101 SET @saved_cs_client = @@character_set_client */;
422 /*!40101 SET character_set_client = utf8 */;
423 CREATE TABLE `GET_CONFIG_TEMPLATE` (
424 `GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
425 `VNF_TYPE` varchar(150) DEFAULT NULL,
426 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL,
427 `XML_PROCESSING` varchar(1) DEFAULT NULL,
428 `XML_PROTOCOL` varchar(30) DEFAULT NULL,
430 PRIMARY KEY (`GET_CONFIG_TEMPLATE_ID`),
431 UNIQUE KEY `GET_CONFIG_TEMPLATE_ID` (`GET_CONFIG_TEMPLATE_ID`),
432 KEY `get_config_template_ibfk_1` (`DEVICE_INTERFACE_PROTOCOL_ID`),
433 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
434 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
435 /*!40101 SET character_set_client = @saved_cs_client */;
438 -- Table structure for table `MULTISTEP_FLOW_REFERENCE`
441 DROP TABLE IF EXISTS `MULTISTEP_FLOW_REFERENCE`;
442 /*!40101 SET @saved_cs_client = @@character_set_client */;
443 /*!40101 SET character_set_client = utf8 */;
444 CREATE TABLE `MULTISTEP_FLOW_REFERENCE` (
445 `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
446 `ACTION` varchar(50) NOT NULL,
447 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
448 `VNF_TYPE` varchar(150) DEFAULT NULL,
449 `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
450 `CATEGORY` varchar(50) DEFAULT NULL,
451 `GENERATION_NODE` varchar(50) DEFAULT NULL,
452 `EXECUTION_NODE` varchar(50) DEFAULT NULL,
453 `CREATOR` varchar(50) DEFAULT NULL,
454 `UPDATED_DATE` datetime DEFAULT NULL,
455 UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)
456 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
457 /*!40101 SET character_set_client = @saved_cs_client */;
460 -- Table structure for table `NODE_TYPES`
463 DROP TABLE IF EXISTS `NODE_TYPES`;
464 /*!40101 SET @saved_cs_client = @@character_set_client */;
465 /*!40101 SET character_set_client = utf8 */;
466 CREATE TABLE `NODE_TYPES` (
467 `nodetype` varchar(80) NOT NULL,
468 PRIMARY KEY (`nodetype`)
469 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
470 /*!40101 SET character_set_client = @saved_cs_client */;
473 -- Table structure for table `OPS_AIC_HOSTS`
476 DROP TABLE IF EXISTS `OPS_AIC_HOSTS`;
477 /*!40101 SET @saved_cs_client = @@character_set_client */;
478 /*!40101 SET character_set_client = utf8 */;
479 CREATE TABLE `OPS_AIC_HOSTS` (
480 `REGION_ID` varchar(16) NOT NULL,
481 `HOST` varchar(64) NOT NULL,
482 `HOST_IP` varchar(64) DEFAULT NULL,
483 `EQUIPMENT_VENDOR` varchar(32) DEFAULT NULL,
484 `EQUIPMENT_PRODUCT` varchar(32) DEFAULT NULL,
485 `EQUIPMENT_MODEL` varchar(32) DEFAULT NULL,
486 `EQUIPMENT_VERSION` varchar(32) DEFAULT NULL,
487 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
488 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
489 PRIMARY KEY (`REGION_ID`,`HOST`),
490 CONSTRAINT `fk_aic_hosts` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
491 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
492 /*!40101 SET character_set_client = @saved_cs_client */;
495 -- Table structure for table `OPS_AIC_REGIONS`
498 DROP TABLE IF EXISTS `OPS_AIC_REGIONS`;
499 /*!40101 SET @saved_cs_client = @@character_set_client */;
500 /*!40101 SET character_set_client = utf8 */;
501 CREATE TABLE `OPS_AIC_REGIONS` (
502 `REGION_ID` varchar(16) NOT NULL,
503 `IDENTITY_URL` varchar(256) NOT NULL,
504 `HOST_DISCOVERY` varchar(3) NOT NULL DEFAULT 'NO',
505 `ADMIN_TENANT_ID` varchar(64) DEFAULT NULL,
506 `ADMIN_TENANT_NAME` varchar(64) DEFAULT 'admin',
507 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
508 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
509 PRIMARY KEY (`REGION_ID`)
510 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
511 /*!40101 SET character_set_client = @saved_cs_client */;
514 -- Table structure for table `OPS_AIC_SCHEDULER_EVENTS`
517 DROP TABLE IF EXISTS `OPS_AIC_SCHEDULER_EVENTS`;
518 /*!40101 SET @saved_cs_client = @@character_set_client */;
519 /*!40101 SET character_set_client = utf8 */;
520 CREATE TABLE `OPS_AIC_SCHEDULER_EVENTS` (
521 `REGION_ID` varchar(16) NOT NULL,
522 `HOST` varchar(64) NOT NULL DEFAULT '',
523 `STATE` enum('COMPLETE','PROGRESS') DEFAULT NULL,
524 `STATUS` enum('SUCCESS','FAILED','PARTIAL') DEFAULT NULL,
525 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
526 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
527 `RUNTIME` varchar(8) NOT NULL DEFAULT '',
528 `RETRIES` int(11) NOT NULL DEFAULT '0',
529 `ERROR` varchar(256) DEFAULT NULL,
530 PRIMARY KEY (`REGION_ID`,`HOST`),
531 CONSTRAINT `fk_aic_sch_events` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
532 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
533 /*!40101 SET character_set_client = @saved_cs_client */;
536 -- Table structure for table `OPS_EXPORT_SCRIPT`
539 DROP TABLE IF EXISTS `OPS_EXPORT_SCRIPT`;
540 /*!40101 SET @saved_cs_client = @@character_set_client */;
541 /*!40101 SET character_set_client = utf8 */;
542 CREATE TABLE `OPS_EXPORT_SCRIPT` (
543 `ID` varchar(15) NOT NULL,
544 `SCRIPT` text NOT NULL,
545 `CREATEDON` datetime NOT NULL,
546 `CREATEDBY` varchar(10) NOT NULL,
548 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
549 /*!40101 SET character_set_client = @saved_cs_client */;
552 -- Table structure for table `OPS_HCAGGMETRICS`
555 DROP TABLE IF EXISTS `OPS_HCAGGMETRICS`;
556 /*!40101 SET @saved_cs_client = @@character_set_client */;
557 /*!40101 SET character_set_client = utf8 */;
558 CREATE TABLE `OPS_HCAGGMETRICS` (
559 `ID` int(11) NOT NULL AUTO_INCREMENT,
560 `AGG_TIME` datetime DEFAULT NULL,
561 `CNT` int(11) DEFAULT NULL,
562 `HCCODE` varchar(45) DEFAULT NULL,
563 `SUCCESS` varchar(20) DEFAULT NULL,
564 `MIN_DUR` float DEFAULT NULL,
565 `AVG_DUR` float DEFAULT NULL,
566 `MAX_DUR` float DEFAULT NULL,
567 `STDDEV_DUR` float DEFAULT NULL,
568 `SDNOINSTANCE` varchar(45) DEFAULT NULL,
569 `HCNODETYPE` varchar(45) DEFAULT NULL,
570 `CLIENTNAME` varchar(45) DEFAULT NULL,
572 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
573 /*!40101 SET character_set_client = @saved_cs_client */;
576 -- Table structure for table `OPS_HCGROUPS`
579 DROP TABLE IF EXISTS `OPS_HCGROUPS`;
580 /*!40101 SET @saved_cs_client = @@character_set_client */;
581 /*!40101 SET character_set_client = utf8 */;
582 CREATE TABLE `OPS_HCGROUPS` (
583 `HCGROUPID` int(11) NOT NULL AUTO_INCREMENT,
584 `HCCODE` varchar(45) NOT NULL,
585 `CHCCODE` varchar(45) NOT NULL,
586 `EXECPRIORITY` int(11) DEFAULT NULL,
587 `CREATEDBY` varchar(45) DEFAULT NULL,
588 `CREATEDON` datetime DEFAULT NULL,
589 `UPDATEDON` datetime DEFAULT NULL,
590 `UPDATEDBY` varchar(45) DEFAULT NULL,
591 PRIMARY KEY (`HCGROUPID`)
592 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
593 /*!40101 SET character_set_client = @saved_cs_client */;
596 -- Table structure for table `OPS_HCRESPARCHIVE`
599 DROP TABLE IF EXISTS `OPS_HCRESPARCHIVE`;
600 /*!40101 SET @saved_cs_client = @@character_set_client */;
601 /*!40101 SET character_set_client = utf8 */;
602 CREATE TABLE `OPS_HCRESPARCHIVE` (
603 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
604 `HCTRANSID` varchar(128) DEFAULT NULL,
605 `REFHCTRANSID` varchar(128) DEFAULT NULL,
606 `SDNOTRANSID` varchar(255) DEFAULT NULL,
607 `HOSTIP` varchar(45) DEFAULT NULL,
608 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
609 `HCRESPONSE` longtext,
610 `CREATEDON` datetime DEFAULT NULL,
611 `SDNOINSTANCE` varchar(45) NOT NULL,
612 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
613 `DMAAPSENT` varchar(1) NOT NULL DEFAULT 'N',
614 `NODETYPE` varchar(45) DEFAULT NULL,
615 `HCCODE` varchar(45) DEFAULT NULL,
616 `USERID` varchar(10) DEFAULT NULL,
617 `CLIENTNAME` varchar(45) DEFAULT NULL,
618 `HDSTARTTIME` datetime DEFAULT NULL,
619 `HDENDTIME` datetime DEFAULT NULL,
620 PRIMARY KEY (`HCRESPONSEID`),
621 KEY `hctransid_idx` (`HCTRANSID`),
622 KEY `sdnotransid_idx` (`SDNOTRANSID`),
623 KEY `clientname_idx` (`CLIENTNAME`),
624 KEY `nodetype_idx` (`NODETYPE`),
625 KEY `hccode_idx` (`HCCODE`),
626 KEY `hostip_idx` (`HOSTIP`),
627 KEY `createdon_idx` (`CREATEDON`)
628 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
629 /*!40101 SET character_set_client = @saved_cs_client */;
632 -- Table structure for table `OPS_HCRESPCACHE`
635 DROP TABLE IF EXISTS `OPS_HCRESPCACHE`;
636 /*!40101 SET @saved_cs_client = @@character_set_client */;
637 /*!40101 SET character_set_client = utf8 */;
638 CREATE TABLE `OPS_HCRESPCACHE` (
639 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
640 `SDNOTRANSID` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
641 `HOSTIP` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
642 `HCRESPONSESTATUS` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
643 `HCRESPONSE` longtext CHARACTER SET utf8,
644 `CREATEDON` datetime DEFAULT NULL,
645 `SDNOINSTANCE` varchar(45) CHARACTER SET utf8 NOT NULL,
646 `SDNOINSTANCESERVER` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
647 `DMAAPSENT` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
648 `NODETYPE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
649 `HCCODE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
650 `USERID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
651 `CLIENTNAME` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
652 `HDSTARTTIME` datetime DEFAULT NULL,
653 `HDENDTIME` datetime DEFAULT NULL,
654 `CACHEEXPIRETIME` datetime DEFAULT NULL,
655 `HDEXPECTEDENDTIME` datetime DEFAULT NULL,
656 PRIMARY KEY (`HCRESPONSEID`),
657 KEY `cacheexpiretime_idx` (`CACHEEXPIRETIME`),
658 KEY `hdexpectedendtime_idx` (`HDEXPECTEDENDTIME`),
659 KEY `hdendtime_idx` (`HDENDTIME`),
660 KEY `hdstarttime_idx` (`HDSTARTTIME`)
661 ) ENGINE=InnoDB AUTO_INCREMENT=383 DEFAULT CHARSET=latin1;
662 /*!40101 SET character_set_client = @saved_cs_client */;
665 -- Temporary table structure for view `OPS_HCRESPCACHEVIEW`
668 DROP TABLE IF EXISTS `OPS_HCRESPCACHEVIEW`;
669 /*!50001 DROP VIEW IF EXISTS `OPS_HCRESPCACHEVIEW`*/;
670 SET @saved_cs_client = @@character_set_client;
671 SET character_set_client = utf8;
672 /*!50001 CREATE VIEW `OPS_HCRESPCACHEVIEW` AS SELECT
677 1 AS `HCRESPONSESTATUS`,
681 1 AS `SDNOINSTANCESERVER`,
689 1 AS `CACHEEXPIRETIME`,
690 1 AS `HDEXPECTEDENDTIME`*/;
691 SET character_set_client = @saved_cs_client;
694 -- Table structure for table `OPS_HCRESPCOMPACT`
697 DROP TABLE IF EXISTS `OPS_HCRESPCOMPACT`;
698 /*!40101 SET @saved_cs_client = @@character_set_client */;
699 /*!40101 SET character_set_client = utf8 */;
700 CREATE TABLE `OPS_HCRESPCOMPACT` (
701 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
702 `HCTRANSID` varchar(128) DEFAULT NULL,
703 `HOSTIP` varchar(45) DEFAULT NULL,
704 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
705 `SDNOINSTANCE` varchar(45) NOT NULL,
706 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
707 `NODETYPE` varchar(45) DEFAULT NULL,
708 `HCCODE` varchar(45) DEFAULT NULL,
709 `USERID` varchar(10) DEFAULT NULL,
710 `CLIENTNAME` varchar(45) DEFAULT NULL,
711 `HDSTARTTIME` datetime DEFAULT NULL,
712 `HDENDTIME` datetime DEFAULT NULL,
713 PRIMARY KEY (`HCRESPONSEID`),
714 KEY `clientname_idx` (`CLIENTNAME`),
715 KEY `nodetype_idx` (`NODETYPE`),
716 KEY `hccode_idx` (`HCCODE`),
717 KEY `hcresponsestatus_idx` (`HCRESPONSESTATUS`),
718 KEY `hdstarttime_idx` (`HDSTARTTIME`),
719 KEY `hdendtime_idx` (`HDENDTIME`)
720 ) ENGINE=InnoDB AUTO_INCREMENT=15378 DEFAULT CHARSET=utf8;
721 /*!40101 SET character_set_client = @saved_cs_client */;
724 -- Table structure for table `OPS_HCTYPES`
727 DROP TABLE IF EXISTS `OPS_HCTYPES`;
728 /*!40101 SET @saved_cs_client = @@character_set_client */;
729 /*!40101 SET character_set_client = utf8 */;
730 CREATE TABLE `OPS_HCTYPES` (
731 `HCTYPEID` int(11) NOT NULL AUTO_INCREMENT,
732 `HCCODE` varchar(45) DEFAULT NULL,
733 `HCDESCR` varchar(45) DEFAULT NULL,
734 `HCNODETYPE` varchar(45) DEFAULT NULL,
735 `NODETYPEVERSION` varchar(15) DEFAULT NULL,
736 `STACKLEVEL` varchar(15) DEFAULT 'VM',
737 `ACTIVE` varchar(5) DEFAULT NULL,
738 `EXECPRIORITY` int(11) DEFAULT NULL,
739 `SBINTERFACE` varchar(45) DEFAULT 'ssh',
740 `SELECTABLE` varchar(2) DEFAULT 'Y',
741 `EXECTIME` int(11) DEFAULT '10' COMMENT 'expected execution time in secs',
742 `DEFAULT4NODETYPE` varchar(2) DEFAULT 'N' COMMENT 'default HD for this nodetype',
743 `CACHEDURATION` int(5) DEFAULT '2' COMMENT 'cache default is in minutes',
744 `LOGCMDRESP2DB` varchar(2) DEFAULT 'Y',
745 `VERSIONCHKHD` varchar(45) DEFAULT NULL,
746 `SBIALTSRVR` varchar(255) DEFAULT NULL,
747 `CREATEDON` datetime DEFAULT NULL,
748 `CREATEDBY` varchar(15) DEFAULT NULL,
749 `UPDATEDON` datetime DEFAULT NULL,
750 `UPDATEDBY` varchar(15) DEFAULT NULL,
751 PRIMARY KEY (`HCTYPEID`),
752 KEY `hcnodetype_idx` (`HCNODETYPE`),
753 KEY `hccode_idx` (`HCCODE`),
754 KEY `active_idx` (`ACTIVE`),
755 KEY `default4nodetype_idx` (`DEFAULT4NODETYPE`)
756 ) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;
757 /*!40101 SET character_set_client = @saved_cs_client */;
760 -- Temporary table structure for view `OPS_HCVIEW`
763 DROP TABLE IF EXISTS `OPS_HCVIEW`;
764 /*!50001 DROP VIEW IF EXISTS `OPS_HCVIEW`*/;
765 SET @saved_cs_client = @@character_set_client;
766 SET character_set_client = utf8;
767 /*!50001 CREATE VIEW `OPS_HCVIEW` AS SELECT
786 SET character_set_client = @saved_cs_client;
789 -- Table structure for table `OPS_HEALTHCHECK`
792 DROP TABLE IF EXISTS `OPS_HEALTHCHECK`;
793 /*!40101 SET @saved_cs_client = @@character_set_client */;
794 /*!40101 SET character_set_client = utf8 */;
795 CREATE TABLE `OPS_HEALTHCHECK` (
796 `HCID` int(11) NOT NULL AUTO_INCREMENT,
797 `HCCODE` varchar(45) DEFAULT NULL,
798 `COMMAND` varchar(512) DEFAULT NULL,
799 `ACTIVE` varchar(1) DEFAULT 'N',
800 `PROMPTCHECK` varchar(32) DEFAULT NULL,
801 `EXECPRIORITY` int(11) DEFAULT NULL,
802 `TIMEOUT` int(11) DEFAULT NULL,
803 `PATTERNMATCH` varchar(512) DEFAULT NULL,
804 `FLIPRXRSLT` varchar(45) NOT NULL DEFAULT 'N',
805 `EXITONFAIL` varchar(6) DEFAULT 'N',
806 `SENDCMDRESP` varchar(5) DEFAULT 'Y',
807 `MANUALEFFORT` int(11) DEFAULT '2' COMMENT 'manual execution estimate in mins',
808 `COMMANDDESC` varchar(100) DEFAULT NULL,
809 `VERSION` varchar(45) DEFAULT 'none',
810 `CREATEDON` datetime DEFAULT NULL,
811 `CREATEDBY` varchar(15) DEFAULT NULL,
812 `UPDATEDON` datetime DEFAULT NULL,
813 `UPDATEDBY` varchar(15) DEFAULT NULL,
814 PRIMARY KEY (`HCID`),
815 KEY `hccode_idx` (`HCCODE`),
816 KEY `active_idx` (`ACTIVE`)
817 ) ENGINE=InnoDB AUTO_INCREMENT=445 DEFAULT CHARSET=latin1;
818 /*!40101 SET character_set_client = @saved_cs_client */;
821 -- Table structure for table `OPS_HEALTHCHECKRESPONSE`
824 DROP TABLE IF EXISTS `OPS_HEALTHCHECKRESPONSE`;
825 /*!40101 SET @saved_cs_client = @@character_set_client */;
826 /*!40101 SET character_set_client = utf8 */;
827 CREATE TABLE `OPS_HEALTHCHECKRESPONSE` (
828 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
829 `HCTRANSID` varchar(128) DEFAULT NULL,
830 `REFHCTRANSID` varchar(128) DEFAULT NULL,
831 `SDNOTRANSID` varchar(255) DEFAULT NULL,
832 `HOSTIP` varchar(45) DEFAULT NULL,
833 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
834 `HCRESPONSE` longtext,
835 `CREATEDON` datetime DEFAULT NULL,
836 `SDNOINSTANCE` varchar(45) NOT NULL,
837 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
838 `DMAAPSENT` varchar(1) NOT NULL DEFAULT 'N',
839 `NODETYPE` varchar(45) DEFAULT NULL,
840 `HCCODE` varchar(45) DEFAULT NULL,
841 `USERID` varchar(10) DEFAULT NULL,
842 `CLIENTNAME` varchar(45) DEFAULT NULL,
843 `HDSTARTTIME` datetime DEFAULT NULL,
844 `HDENDTIME` datetime DEFAULT NULL,
845 PRIMARY KEY (`HCRESPONSEID`),
846 KEY `hctransid_idx` (`HCTRANSID`),
847 KEY `sdnotransid_idx` (`SDNOTRANSID`),
848 KEY `clientname_idx` (`CLIENTNAME`),
849 KEY `nodetype_idx` (`NODETYPE`),
850 KEY `hccode_idx` (`HCCODE`),
851 KEY `hostip_idx` (`HOSTIP`),
852 KEY `createdon_idx` (`CREATEDON`)
853 ) ENGINE=InnoDB AUTO_INCREMENT=15380 DEFAULT CHARSET=utf8;
854 /*!40101 SET character_set_client = @saved_cs_client */;
855 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
856 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
857 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
858 /*!50003 SET character_set_client = latin1 */ ;
859 /*!50003 SET character_set_results = latin1 */ ;
860 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
861 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
862 /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
864 /*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `OPS_HEALTHCHECKRESPONSE_BEFORE_INSERT` BEFORE INSERT ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
866 declare reftransid varchar(128);
868 declare ahostip varchar(45);
869 declare ahdcode varchar(45);
870 declare ahdendtime datetime;
871 declare ahdstarttime datetime;
872 declare acacheexpiretime datetime;
873 declare hdexectime INT DEFAULT 5;
874 declare hdexpectedendtime datetime;
875 declare nowtime datetime;
876 declare acacheduration INT;
877 declare maxtimeintbl INT DEFAULT 1800;
879 SET nowtime:=utc_timestamp();
880 SET ahdcode:=NEW.HCCODE;
881 SET ahostip:=NEW.HOSTIP;
882 SET reftransid:=trim(NEW.REFHCTRANSID);
883 SET new.CREATEDON = nowtime;
884 SET new.HDSTARTTIME = nowtime;
886 delete from OPS_HCRESPCACHE where HDENDTIME is null AND time_to_sec(timediff(nowtime, HDSTARTTIME))>maxtimeintbl;
888 IF (reftransid is null) then
889 select CACHEDURATION, EXECTIME into acacheduration, hdexectime from OPS_HCTYPES where HCCODE=ahdcode;
890 select count(*) into ccount from OPS_HCRESPCACHE where HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0;
892 select HDSTARTTIME, HDENDTIME, CACHEEXPIRETIME into ahdstarttime, ahdendtime, acacheexpiretime from OPS_HCRESPCACHE where
893 HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0 order by HDENDTIME desc limit 1 ;
894 select time_to_sec(timediff(ahdendtime, ahdstarttime)) into hdexectime;
897 if (acacheduration > 0) then
898 set hdexpectedendtime = nowtime + INTERVAL hdexectime second;
899 insert into OPS_HCRESPCACHE(HCRESPONSEID,SDNOTRANSID,HOSTIP,HCRESPONSESTATUS,HCRESPONSE,CREATEDON,SDNOINSTANCE,SDNOINSTANCESERVER,DMAAPSENT,
900 NODETYPE,HCCODE,USERID,CLIENTNAME,HDSTARTTIME,HDENDTIME,CACHEEXPIRETIME,HDEXPECTEDENDTIME)
901 VALUES(NEW.HCRESPONSEID,NEW.SDNOTRANSID,NEW.HOSTIP,null,null,nowtime,NEW.SDNOINSTANCE,NEW.SDNOINSTANCESERVER,NEW.DMAAPSENT,
902 NEW.NODETYPE,NEW.HCCODE,NEW.USERID,NEW.CLIENTNAME,NEW.HDSTARTTIME,null,null,hdexpectedendtime);
908 /*!50003 SET sql_mode = @saved_sql_mode */ ;
909 /*!50003 SET character_set_client = @saved_cs_client */ ;
910 /*!50003 SET character_set_results = @saved_cs_results */ ;
911 /*!50003 SET collation_connection = @saved_col_connection */ ;
912 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
913 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
914 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
915 /*!50003 SET character_set_client = latin1 */ ;
916 /*!50003 SET character_set_results = latin1 */ ;
917 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
918 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
919 /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
921 /*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `sdnctl`.`OPS_HEALTHCHECKRESPONSE_BEFORE_UPDATE` BEFORE UPDATE ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
923 Declare aduration INT;
924 declare reftransid varchar(128);
925 DECLARE cachetime datetime;
926 declare ahostip varchar(45);
927 declare ahdcode varchar(45);
928 declare ahdendtime datetime;
930 SET ahdcode:=NEW.HCCODE;
931 SET ahostip:=NEW.HOSTIP;
932 SET ahdendtime:=NEW.HDENDTIME;
933 SET reftransid:=trim(NEW.REFHCTRANSID);
935 if (NEW.DMAAPSENT in ('U','Y')) then
936 update OPS_HCRESPCACHE
937 set DMAAPSENT=NEW.DMAAPSENT where OLD.SDNOTRANSID=NEW.SDNOTRANSID and OLD.CREATEDON=NEW.CREATEDON;
938 ELSEIF (reftransid is null and OLD.HCRESPONSESTATUS is null) then
939 select cacheduration into aduration from OPS_HCTYPES where HCCODE=ahdcode;
940 if (aduration > 0) then
941 select ahdendtime + INTERVAL aduration MINUTE into cachetime from OPS_HCTYPES where HCCODE=ahdcode;
942 update OPS_HCRESPCACHE
943 set HCRESPONSESTATUS=NEW.HCRESPONSESTATUS,HCRESPONSE=NEW.HCRESPONSE,HDENDTIME=NEW.HDENDTIME,CACHEEXPIRETIME=cachetime,HDEXPECTEDENDTIME=null
944 where SDNOTRANSID=NEW.SDNOTRANSID and CREATEDON=NEW.CREATEDON;
945 insert into OPS_HCRESPCOMPACT (HCRESPONSEID, HCTRANSID, HOSTIP, HCRESPONSESTATUS, SDNOINSTANCE, SDNOINSTANCESERVER, NODETYPE, HCCODE, USERID, CLIENTNAME, HDSTARTTIME, HDENDTIME)
946 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);
951 /*!50003 SET sql_mode = @saved_sql_mode */ ;
952 /*!50003 SET character_set_client = @saved_cs_client */ ;
953 /*!50003 SET character_set_results = @saved_cs_results */ ;
954 /*!50003 SET collation_connection = @saved_col_connection */ ;
957 -- Table structure for table `OPS_MAPNODETYPES`
960 DROP TABLE IF EXISTS `OPS_MAPNODETYPES`;
961 /*!40101 SET @saved_cs_client = @@character_set_client */;
962 /*!40101 SET character_set_client = utf8 */;
963 CREATE TABLE `OPS_MAPNODETYPES` (
964 `ID` int(11) NOT NULL AUTO_INCREMENT,
965 `INNODETYPE` varchar(45) DEFAULT NULL COMMENT 'nodetype value in incoming API',
966 `TBLNODETYPE` varchar(45) DEFAULT NULL COMMENT 'nodetype value as stored in db',
968 KEY `tablnodetype_idx` (`TBLNODETYPE`)
969 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
970 /*!40101 SET character_set_client = @saved_cs_client */;
973 -- Table structure for table `OPS_NODEINFO`
976 DROP TABLE IF EXISTS `OPS_NODEINFO`;
977 /*!40101 SET @saved_cs_client = @@character_set_client */;
978 /*!40101 SET character_set_client = utf8 */;
979 CREATE TABLE `OPS_NODEINFO` (
980 `NODEID` int(11) NOT NULL AUTO_INCREMENT,
981 `NODETYPE` varchar(255) DEFAULT NULL,
982 `HOSTIP` varchar(45) DEFAULT NULL,
983 `STACKLEVEL` varchar(15) DEFAULT 'VM',
984 `HOSTUSER` varchar(45) DEFAULT NULL,
985 `HOSTPASSWORD` varchar(45) DEFAULT NULL,
986 `PROMPTCMD` varchar(256) DEFAULT NULL,
987 `PREPROMPTSTRS` varchar(45) DEFAULT NULL COMMENT 'Strings to send before login prompt',
988 `LABNODETYPE` varchar(256) DEFAULT NULL,
989 `MULTIVERSIONS` varchar(2) DEFAULT 'N',
990 `JUMPSERVERIP` varchar(45) DEFAULT NULL,
991 `JUMPSERVERUSER` varchar(45) DEFAULT NULL,
992 `JUMPSERVERPASSWORD` varchar(45) DEFAULT NULL,
993 `VSERVERID` varchar(128) DEFAULT NULL,
994 `SELFSERVLINK` varchar(1024) DEFAULT NULL,
995 `TENANTID` varchar(128) DEFAULT NULL,
996 `IDENTITYURL` varchar(1024) DEFAULT NULL,
997 PRIMARY KEY (`NODEID`),
998 KEY `hostname_idx` (`NODETYPE`)
999 ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
1000 /*!40101 SET character_set_client = @saved_cs_client */;
1003 -- Table structure for table `OPS_NODETYPE2SDNO`
1006 DROP TABLE IF EXISTS `OPS_NODETYPE2SDNO`;
1007 /*!40101 SET @saved_cs_client = @@character_set_client */;
1008 /*!40101 SET character_set_client = utf8 */;
1009 CREATE TABLE `OPS_NODETYPE2SDNO` (
1010 `VNFTYPEID` int(11) NOT NULL AUTO_INCREMENT,
1011 `VNFTYPECODE` varchar(45) DEFAULT NULL,
1012 `VNFTYPENAME` varchar(256) DEFAULT NULL,
1013 `VNFCLLI` varchar(20) DEFAULT NULL,
1014 `DEFAULT_4_UNK_CLLI` varchar(2) DEFAULT NULL,
1015 `SDNOINSTANCE` varchar(45) NOT NULL,
1016 PRIMARY KEY (`VNFTYPEID`)
1017 ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
1018 /*!40101 SET character_set_client = @saved_cs_client */;
1021 -- Table structure for table `OPS_NODE_PROPERTIES`
1024 DROP TABLE IF EXISTS `OPS_NODE_PROPERTIES`;
1025 /*!40101 SET @saved_cs_client = @@character_set_client */;
1026 /*!40101 SET character_set_client = utf8 */;
1027 CREATE TABLE `OPS_NODE_PROPERTIES` (
1028 `NODETYPE` varchar(64) NOT NULL,
1029 `PROPERTY` varchar(64) NOT NULL,
1030 `VALUE` varchar(128) NOT NULL,
1031 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1032 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1033 PRIMARY KEY (`NODETYPE`,`PROPERTY`)
1034 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1035 /*!40101 SET character_set_client = @saved_cs_client */;
1038 -- Table structure for table `OPS_SDNOINFO`
1041 DROP TABLE IF EXISTS `OPS_SDNOINFO`;
1042 /*!40101 SET @saved_cs_client = @@character_set_client */;
1043 /*!40101 SET character_set_client = utf8 */;
1044 CREATE TABLE `OPS_SDNOINFO` (
1045 `SDNOID` int(11) NOT NULL AUTO_INCREMENT,
1046 `SDNOINSTANCE` varchar(45) DEFAULT NULL,
1047 `URI` varchar(1000) NOT NULL,
1048 PRIMARY KEY (`SDNOID`),
1049 UNIQUE KEY `SDNOINSTANCE_UNIQUE` (`SDNOINSTANCE`)
1050 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
1051 /*!40101 SET character_set_client = @saved_cs_client */;
1054 -- Table structure for table `OPS_SQLMGR`
1057 DROP TABLE IF EXISTS `OPS_SQLMGR`;
1058 /*!40101 SET @saved_cs_client = @@character_set_client */;
1059 /*!40101 SET character_set_client = utf8 */;
1060 CREATE TABLE `OPS_SQLMGR` (
1061 `SQLID` int(11) NOT NULL AUTO_INCREMENT,
1063 `SQLSTATUS` int(11) DEFAULT '0',
1064 `COMMENTS` varchar(255) DEFAULT NULL,
1065 `CREATEDBY` varchar(15) DEFAULT NULL,
1066 `CREATEDON` datetime DEFAULT NULL,
1067 PRIMARY KEY (`SQLID`)
1068 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1069 /*!40101 SET character_set_client = @saved_cs_client */;
1072 -- Table structure for table `OPS_TRUSTED_PARTNER`
1075 DROP TABLE IF EXISTS `OPS_TRUSTED_PARTNER`;
1076 /*!40101 SET @saved_cs_client = @@character_set_client */;
1077 /*!40101 SET character_set_client = utf8 */;
1078 CREATE TABLE `OPS_TRUSTED_PARTNER` (
1079 `PARTNERID` int(11) NOT NULL AUTO_INCREMENT,
1080 `PARTNER_NAME` varchar(256) NOT NULL,
1081 `PARTNER_PUBLIC_KEY` varchar(1024) DEFAULT NULL,
1082 PRIMARY KEY (`PARTNERID`)
1083 ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
1084 /*!40101 SET character_set_client = @saved_cs_client */;
1087 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
1090 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
1091 /*!40101 SET @saved_cs_client = @@character_set_client */;
1092 /*!40101 SET character_set_client = utf8 */;
1093 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
1094 `PREPARE_FILE_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
1095 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
1096 `REQUEST_ID` varchar(255) DEFAULT NULL,
1097 `CONFIG_FILE_ID` int(11) DEFAULT NULL,
1098 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
1099 PRIMARY KEY (`PREPARE_FILE_RELATIONSHIP_ID`),
1100 UNIQUE KEY `PREPARE_FILE_RELATIONSHIP_ID` (`PREPARE_FILE_RELATIONSHIP_ID`),
1101 KEY `ie_prepare_file_relationship` (`CONFIG_FILE_ID`),
1102 KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
1103 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
1104 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
1105 ) ENGINE=InnoDB AUTO_INCREMENT=338 DEFAULT CHARSET=latin1;
1106 /*!40101 SET character_set_client = @saved_cs_client */;
1109 -- Table structure for table `PROCESS_FLOW_REFERENCE`
1112 DROP TABLE IF EXISTS `PROCESS_FLOW_REFERENCE`;
1113 /*!40101 SET @saved_cs_client = @@character_set_client */;
1114 /*!40101 SET character_set_client = utf8 */;
1115 CREATE TABLE `PROCESS_FLOW_REFERENCE` (
1116 `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1117 `ACTION` varchar(50) NOT NULL,
1118 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
1119 `PROTOCOL` varchar(50) DEFAULT NULL,
1120 `EXECUTION_TYPE` varchar(100) NOT NULL,
1121 `EXECUTION_MODULE` varchar(100) NOT NULL,
1122 `EXECUTION_RPC` varchar(100) NOT NULL,
1123 `UPDATED_DATE` datetime DEFAULT NULL,
1124 `GET_RUNNING_CONFIG` varchar(50) DEFAULT NULL,
1125 PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),
1126 UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)
1127 ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
1128 /*!40101 SET character_set_client = @saved_cs_client */;
1131 -- Table structure for table `PROTOCOL_REFERENCE`
1134 DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
1135 /*!40101 SET @saved_cs_client = @@character_set_client */;
1136 /*!40101 SET character_set_client = utf8 */;
1137 CREATE TABLE `PROTOCOL_REFERENCE` (
1138 `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1139 `ACTION` varchar(50) NOT NULL,
1140 `VNF_TYPE` varchar(150) DEFAULT NULL,
1141 `PROTOCOL` varchar(50) DEFAULT NULL,
1142 `UPDATED_DATE` datetime DEFAULT NULL,
1143 `TEMPLATE` varchar(45) DEFAULT NULL,
1144 `ACTION_LEVEL` varchar(45) DEFAULT NULL,
1145 PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
1146 UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
1147 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
1148 /*!40101 SET character_set_client = @saved_cs_client */;
1151 -- Table structure for table `REQUEST_ARTIFACTS`
1154 DROP TABLE IF EXISTS `REQUEST_ARTIFACTS`;
1155 /*!40101 SET @saved_cs_client = @@character_set_client */;
1156 /*!40101 SET character_set_client = utf8 */;
1157 CREATE TABLE `REQUEST_ARTIFACTS` (
1158 `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
1159 `REQUEST_ID` varchar(50) NOT NULL,
1160 `ACTION` varchar(50) NOT NULL,
1161 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
1162 `VNF_TYPE` varchar(150) DEFAULT NULL,
1163 `CATEGORY` varchar(50) NOT NULL,
1164 `ARTIFACT_CONTENT` longtext,
1165 `UPDATED_DATE` datetime DEFAULT NULL,
1166 PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
1167 UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
1168 ) ENGINE=InnoDB AUTO_INCREMENT=1962 DEFAULT CHARSET=latin1;
1169 /*!40101 SET character_set_client = @saved_cs_client */;
1172 -- Table structure for table `SVC_LOGIC`
1175 DROP TABLE IF EXISTS `SVC_LOGIC`;
1176 /*!40101 SET @saved_cs_client = @@character_set_client */;
1177 /*!40101 SET character_set_client = utf8 */;
1178 CREATE TABLE `SVC_LOGIC` (
1179 `module` varchar(80) NOT NULL,
1180 `rpc` varchar(80) NOT NULL,
1181 `version` varchar(40) NOT NULL,
1182 `mode` varchar(5) NOT NULL,
1183 `active` varchar(1) NOT NULL,
1185 `md5sum` varchar(32) NOT NULL DEFAULT '',
1186 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
1187 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1188 /*!40101 SET character_set_client = @saved_cs_client */;
1191 -- Table structure for table `TRANSACTIONS`
1194 DROP TABLE IF EXISTS `TRANSACTIONS`;
1195 /*!40101 SET @saved_cs_client = @@character_set_client */;
1196 /*!40101 SET character_set_client = utf8 */;
1197 CREATE TABLE `TRANSACTIONS` (
1198 `TRANSACTION_ID` varchar(75) NOT NULL,
1199 `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
1200 `REQUEST_ID` varchar(256) NOT NULL,
1201 `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
1202 `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
1203 `START_TIME` datetime(3) NOT NULL,
1204 `END_TIME` datetime(3) DEFAULT NULL,
1205 `TARGET_ID` varchar(256) DEFAULT NULL,
1206 `TARGET_TYPE` varchar(256) DEFAULT NULL,
1207 `OPERATION` varchar(256) NOT NULL,
1208 `RESULT_CODE` int(11) DEFAULT NULL,
1210 `STATE` varchar(50) NOT NULL,
1211 `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
1212 `VNFC_NAME` varchar(256) DEFAULT NULL,
1213 `VSERVER_ID` varchar(256) DEFAULT NULL,
1214 `VF_MODULE_ID` varchar(256) DEFAULT NULL,
1215 `MODE` varchar(50) NOT NULL,
1216 PRIMARY KEY (`TRANSACTION_ID`)
1217 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1218 /*!40101 SET character_set_client = @saved_cs_client */;
1221 -- Table structure for table `UPLOAD_CONFIG`
1224 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
1225 /*!40101 SET @saved_cs_client = @@character_set_client */;
1226 /*!40101 SET character_set_client = utf8 */;
1227 CREATE TABLE `UPLOAD_CONFIG` (
1228 `UPLOAD_CONFIG_ID` int(11) NOT NULL AUTO_INCREMENT,
1229 `REQUEST_ID` varchar(50) DEFAULT NULL,
1230 `ORIGINATOR_ID` varchar(50) DEFAULT NULL,
1231 `SERVICE_DESCRIPTION` varchar(100) DEFAULT NULL,
1232 `ACTION` varchar(50) DEFAULT NULL,
1233 `UPLOAD_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1234 `VNF_ID` varchar(50) DEFAULT NULL,
1235 `VNF_NAME` varchar(50) DEFAULT NULL,
1236 `VM_NAME` varchar(50) DEFAULT NULL,
1237 `VNF_TYPE` varchar(150) DEFAULT NULL,
1238 `VNFC_TYPE` varchar(50) DEFAULT NULL,
1239 `HOST_IP_ADDRESS` varchar(50) DEFAULT NULL,
1240 `CONFIG_INDICATOR` varchar(25) DEFAULT NULL,
1241 `PENDING_DELETE` varchar(1) DEFAULT NULL,
1243 PRIMARY KEY (`UPLOAD_CONFIG_ID`),
1244 UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
1245 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1246 /*!40101 SET character_set_client = @saved_cs_client */;
1249 -- Table structure for table `VNFC_DG_MAPPING`
1252 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
1253 /*!40101 SET @saved_cs_client = @@character_set_client */;
1254 /*!40101 SET character_set_client = utf8 */;
1255 CREATE TABLE `VNFC_DG_MAPPING` (
1256 `VNFC_DG_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
1257 `ACTION` varchar(50) DEFAULT NULL,
1258 `API_VERSION` varchar(10) DEFAULT NULL,
1259 `VNF_TYPE` varchar(150) DEFAULT NULL,
1260 `VNFC_TYPE` varchar(50) DEFAULT NULL,
1261 `DG_NAME` varchar(50) NOT NULL,
1262 `DG_VERSION` varchar(50) DEFAULT NULL,
1263 `DG_MODULE` varchar(50) NOT NULL,
1264 PRIMARY KEY (`VNFC_DG_MAPPING_ID`)
1265 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
1266 /*!40101 SET character_set_client = @saved_cs_client */;
1269 -- Table structure for table `VNFC_REFERENCE`
1272 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
1273 /*!40101 SET @saved_cs_client = @@character_set_client */;
1274 /*!40101 SET character_set_client = utf8 */;
1275 CREATE TABLE `VNFC_REFERENCE` (
1276 `VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1277 `ACTION` varchar(50) NOT NULL,
1278 `VNF_TYPE` varchar(150) DEFAULT NULL,
1279 `VM_INSTANCE` int(11) NOT NULL,
1280 `VNFC_INSTANCE` int(11) NOT NULL,
1281 `VNFC_TYPE` varchar(50) NOT NULL,
1282 `VNFC_FUNCTION_CODE` varchar(50) NOT NULL,
1283 `IPADDRESS_V4_OAM_VIP` varchar(50) DEFAULT NULL,
1284 `GROUP_NOTATION_TYPE` varchar(50) DEFAULT NULL,
1285 `GROUP_NOTATION_VALUE` varchar(50) DEFAULT NULL,
1286 `TEMPLATE_ID` varchar(100) DEFAULT NULL,
1287 PRIMARY KEY (`VNFC_REFERENCE_ID`),
1288 UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
1289 ) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=latin1;
1290 /*!40101 SET character_set_client = @saved_cs_client */;
1293 -- Table structure for table `VNF_DG_MAPPING`
1296 DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
1297 /*!40101 SET @saved_cs_client = @@character_set_client */;
1298 /*!40101 SET character_set_client = utf8 */;
1299 CREATE TABLE `VNF_DG_MAPPING` (
1300 `VNF_DG_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
1301 `ACTION` varchar(50) NOT NULL,
1302 `API_VERSION` varchar(50) DEFAULT NULL,
1303 `VNF_TYPE` varchar(150) DEFAULT NULL,
1304 `VNF_VERSION` varchar(50) DEFAULT NULL,
1305 `DG_NAME` varchar(50) NOT NULL,
1306 `DG_VERSION` varchar(50) DEFAULT NULL,
1307 `DG_MODULE` varchar(50) NOT NULL,
1308 PRIMARY KEY (`VNF_DG_MAPPING_ID`)
1309 ) ENGINE=InnoDB AUTO_INCREMENT=576 DEFAULT CHARSET=latin1;
1310 /*!40101 SET character_set_client = @saved_cs_client */;
1313 -- Table structure for table `VNF_LOCK_MANAGEMENT`
1316 DROP TABLE IF EXISTS `VNF_LOCK_MANAGEMENT`;
1317 /*!40101 SET @saved_cs_client = @@character_set_client */;
1318 /*!40101 SET character_set_client = utf8 */;
1319 CREATE TABLE `VNF_LOCK_MANAGEMENT` (
1320 `RESOURCE_ID` varchar(50) NOT NULL,
1321 `OWNER_ID` varchar(255) DEFAULT NULL,
1322 `UPDATED` bigint(20) unsigned NOT NULL,
1323 `TIMEOUT` int(10) unsigned NOT NULL,
1324 `VER` int(10) unsigned NOT NULL DEFAULT '1',
1325 PRIMARY KEY (`RESOURCE_ID`)
1326 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1327 /*!40101 SET character_set_client = @saved_cs_client */;
1330 -- Table structure for table `VNF_STATE_MANAGEMENT`
1333 DROP TABLE IF EXISTS `VNF_STATE_MANAGEMENT`;
1334 /*!40101 SET @saved_cs_client = @@character_set_client */;
1335 /*!40101 SET character_set_client = utf8 */;
1336 CREATE TABLE `VNF_STATE_MANAGEMENT` (
1337 `VNF_ID` varchar(50) NOT NULL,
1338 `STATE` varchar(50) NOT NULL,
1339 `OWNER_ID` varchar(255) DEFAULT NULL,
1340 `UPDATED` bigint(20) unsigned NOT NULL,
1341 `VER` int(10) unsigned NOT NULL DEFAULT '1',
1342 PRIMARY KEY (`VNF_ID`)
1343 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1344 /*!40101 SET character_set_client = @saved_cs_client */;
1346 SET FOREIGN_KEY_CHECKS = 1;