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 */;
28 -- Table structure for table `ACTION_LEVEL_REFERENCE`
31 DROP TABLE IF EXISTS `ACTION_LEVEL_REFERENCE`;
32 /*!40101 SET @saved_cs_client = @@character_set_client */;
33 /*!40101 SET character_set_client = utf8 */;
34 CREATE TABLE `ACTION_LEVEL_REFERENCE` (
35 `ACTION_LEVEL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
36 `ACTION_IDENTIFIER` varchar(50) NOT NULL,
37 `ACTION_LEVEL` varchar(50) NOT NULL,
38 UNIQUE KEY `ACTION_LEVEL_REFERENCE_ID` (`ACTION_LEVEL_REFERENCE_ID`)
39 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
40 /*!40101 SET character_set_client = @saved_cs_client */;
43 -- Table structure for table `APPC_HEALTH`
46 DROP TABLE IF EXISTS `APPC_HEALTH`;
47 /*!40101 SET @saved_cs_client = @@character_set_client */;
48 /*!40101 SET character_set_client = utf8 */;
49 CREATE TABLE `APPC_HEALTH` (
50 `APPC_HEALTH_ID` int(11) NOT NULL AUTO_INCREMENT,
51 `HEALTHY` varchar(30) NOT NULL,
52 PRIMARY KEY (`APPC_HEALTH_ID`)
53 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
54 /*!40101 SET character_set_client = @saved_cs_client */;
57 -- Table structure for table `ASDC_ARTIFACTS`
60 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
61 /*!40101 SET @saved_cs_client = @@character_set_client */;
62 /*!40101 SET character_set_client = utf8 */;
63 CREATE TABLE `ASDC_ARTIFACTS` (
64 `ASDC_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
65 `SERVICE_UUID` varchar(50) DEFAULT NULL,
66 `DISTRIBUTION_ID` varchar(50) DEFAULT NULL,
67 `SERVICE_NAME` varchar(255) DEFAULT NULL,
68 `SERVICE_DESCRIPTION` varchar(255) DEFAULT NULL,
69 `RESOURCE_UUID` varchar(255) DEFAULT NULL,
70 `RESOURCE_INSTANCE_NAME` varchar(255) DEFAULT NULL,
71 `RESOURCE_NAME` varchar(255) DEFAULT NULL,
72 `RESOURCE_VERSION` varchar(50) DEFAULT NULL,
73 `RESOURCE_TYPE` varchar(50) DEFAULT NULL,
74 `ARTIFACT_UUID` varchar(50) DEFAULT NULL,
75 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
76 `ARTIFACT_VERSION` varchar(25) DEFAULT NULL,
77 `ARTIFACT_DESCRIPTION` varchar(255) DEFAULT NULL,
78 `INTERNAL_VERSION` int(11) DEFAULT NULL,
79 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
80 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
81 `ARTIFACT_CONTENT` longtext,
82 PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
83 UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
84 ) ENGINE=InnoDB AUTO_INCREMENT=1219 DEFAULT CHARSET=latin1;
85 /*!40101 SET character_set_client = @saved_cs_client */;
88 -- Table structure for table `ASDC_REFERENCE`
91 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
92 /*!40101 SET @saved_cs_client = @@character_set_client */;
93 /*!40101 SET character_set_client = utf8 */;
94 CREATE TABLE `ASDC_REFERENCE` (
95 `ASDC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
96 `VNF_TYPE` varchar(150) DEFAULT NULL,
97 `VNFC_TYPE` varchar(50) DEFAULT NULL,
98 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
99 `ACTION` varchar(50) DEFAULT NULL,
100 `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
101 `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
102 PRIMARY KEY (`ASDC_REFERENCE_ID`),
103 UNIQUE KEY `ASDC_REFERENCE_ID` (`ASDC_REFERENCE_ID`)
104 ) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=latin1;
105 /*!40101 SET character_set_client = @saved_cs_client */;
108 -- Table structure for table `CONFIGFILES`
111 DROP TABLE IF EXISTS `CONFIGFILES`;
112 /*!40101 SET @saved_cs_client = @@character_set_client */;
113 /*!40101 SET character_set_client = utf8 */;
114 CREATE TABLE `CONFIGFILES` (
115 `CONFIG_FILE_ID` int(11) NOT NULL AUTO_INCREMENT,
116 `EXTERNAL_VERSION` varchar(50) DEFAULT NULL,
117 `DATA_SOURCE` varchar(25) DEFAULT NULL,
118 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
119 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
120 `VNF_TYPE` varchar(150) DEFAULT NULL,
121 `VNFC_TYPE` varchar(50) DEFAULT NULL,
122 `FILE_CATEGORY` varchar(50) DEFAULT NULL,
123 `FILE_NAME` varchar(255) DEFAULT NULL,
124 `FILE_CONTENT` longtext,
125 `ACTION` varchar(50) DEFAULT NULL,
126 `VNF_ID` varchar(50) DEFAULT NULL,
127 `VM_NAME` varchar(50) DEFAULT NULL,
128 `VNF_NAME` varchar(50) DEFAULT NULL,
129 PRIMARY KEY (`CONFIG_FILE_ID`),
130 UNIQUE KEY `CONFIG_FILE_ID` (`CONFIG_FILE_ID`)
131 ) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=latin1;
132 /*!40101 SET character_set_client = @saved_cs_client */;
135 -- Table structure for table `CONFIGURE_ACTION_DG`
138 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
139 /*!40101 SET @saved_cs_client = @@character_set_client */;
140 /*!40101 SET character_set_client = utf8 */;
141 CREATE TABLE `CONFIGURE_ACTION_DG` (
142 `CONFIGURE_ACTION_DG_ID` int(11) NOT NULL AUTO_INCREMENT,
143 `VNF_TYPE` varchar(150) DEFAULT NULL,
144 `ACTION` varchar(50) DEFAULT NULL,
145 `GENERATE_CONFIG_DG` varchar(50) DEFAULT NULL,
146 `DOWNLOAD_CONFIG_DG` varchar(50) DEFAULT NULL,
147 PRIMARY KEY (`CONFIGURE_ACTION_DG_ID`),
148 UNIQUE KEY ` CONFIGURE_ACTION_DG_ID` (`CONFIGURE_ACTION_DG_ID`)
149 ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
150 /*!40101 SET character_set_client = @saved_cs_client */;
153 -- Table structure for table `CONFIG_FILE_REFERENCE`
156 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
157 /*!40101 SET @saved_cs_client = @@character_set_client */;
158 /*!40101 SET character_set_client = utf8 */;
159 CREATE TABLE `CONFIG_FILE_REFERENCE` (
160 `CONFIG_FILE_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
161 `SITE_LOCATION` varchar(50) DEFAULT NULL,
162 `VNF_TYPE` varchar(150) DEFAULT NULL,
163 `IMPORT_TYPE` varchar(50) DEFAULT NULL,
164 `FILE_TYPE` varchar(50) DEFAULT NULL,
165 `SOURCE_SERVER_NAME` varchar(255) DEFAULT NULL,
166 `SOURCE_FILE_PATH` varchar(255) DEFAULT NULL,
167 `TARGET_FILE_PATH` varchar(255) DEFAULT NULL,
168 `NAME` varchar(50) DEFAULT NULL,
169 `FILE_NAME` varchar(255) DEFAULT NULL,
170 PRIMARY KEY (`CONFIG_FILE_REFERENCE_ID`),
171 UNIQUE KEY `CONFIG_FILE_REFERENCE_ID` (`CONFIG_FILE_REFERENCE_ID`)
172 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
173 /*!40101 SET character_set_client = @saved_cs_client */;
176 -- Table structure for table `CONFIG_TRANSACTION_LOG`
179 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
180 /*!40101 SET @saved_cs_client = @@character_set_client */;
181 /*!40101 SET character_set_client = utf8 */;
182 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
183 `CONFIG_TRANSACTION_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
184 `REQUEST_ID` varchar(50) DEFAULT NULL,
185 `MESSAGE_TYPE` varchar(50) DEFAULT NULL,
186 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
188 PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
189 UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
190 ) ENGINE=InnoDB AUTO_INCREMENT=6470 DEFAULT CHARSET=latin1;
191 /*!40101 SET character_set_client = @saved_cs_client */;
194 -- Table structure for table `DEVICE_AUTHENTICATION`
197 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
198 /*!40101 SET @saved_cs_client = @@character_set_client */;
199 /*!40101 SET character_set_client = utf8 */;
200 CREATE TABLE `DEVICE_AUTHENTICATION` (
201 `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
202 `VNF_TYPE` varchar(255) NOT NULL,
203 `PROTOCOL` varchar(255) NOT NULL,
204 `ACTION` varchar(255) NOT NULL,
205 `USER_NAME` varchar(255) DEFAULT NULL,
206 `PASSWORD` varchar(255) DEFAULT NULL,
207 `PORT_NUMBER` int(11) DEFAULT NULL,
208 `URL` varchar(1024) DEFAULT NULL,
209 PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
210 UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`),
211 KEY `PROTOCOL` (`PROTOCOL`),
212 KEY `ACTION` (`ACTION`)
213 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
214 /*!40101 SET character_set_client = @saved_cs_client */;
217 -- Temporary table structure for view `DEVICE_CONFIGURATION`
220 DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
221 /*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
222 SET @saved_cs_client = @@character_set_client;
223 SET character_set_client = utf8;
224 /*!50001 CREATE VIEW `DEVICE_CONFIGURATION` AS SELECT
225 1 AS `UPLOAD_CONFIG_ID`,
227 1 AS `ORIGINATOR_ID`,
228 1 AS `SERVICE_DESCRIPTION`,
236 1 AS `HOST_IP_ADDRESS`,
237 1 AS `CONFIG_INDICATOR`,
238 1 AS `PENDING_DELETE`,
240 SET character_set_client = @saved_cs_client;
243 -- Table structure for table `DEVICE_INTERFACE_LOG`
246 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
247 /*!40101 SET @saved_cs_client = @@character_set_client */;
248 /*!40101 SET character_set_client = utf8 */;
249 CREATE TABLE `DEVICE_INTERFACE_LOG` (
250 `DEVICE_INTERFACE_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
251 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
252 `REQUEST_ID` varchar(50) DEFAULT NULL,
253 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
255 PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
256 UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
257 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
258 /*!40101 SET character_set_client = @saved_cs_client */;
261 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
264 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
265 /*!40101 SET @saved_cs_client = @@character_set_client */;
266 /*!40101 SET character_set_client = utf8 */;
267 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
268 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
269 `VNF_TYPE` varchar(150) DEFAULT NULL,
270 `PROTOCOL` varchar(50) DEFAULT NULL,
271 `MODULE` varchar(50) DEFAULT NULL,
272 `DG_RPC` varchar(50) DEFAULT NULL,
273 PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
274 UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`)
275 ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
276 /*!40101 SET character_set_client = @saved_cs_client */;
279 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
282 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
283 /*!40101 SET @saved_cs_client = @@character_set_client */;
284 /*!40101 SET character_set_client = utf8 */;
285 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
286 `DOWNLOAD_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
287 `VNF_TYPE` varchar(150) DEFAULT NULL,
288 `PROTOCOL` varchar(50) NOT NULL,
290 PRIMARY KEY (`DOWNLOAD_CONFIG_TEMPLATE_ID`),
291 UNIQUE KEY `DOWNLOAD_CONFIG_TEMPLATE_ID` (`DOWNLOAD_CONFIG_TEMPLATE_ID`)
292 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
293 /*!40101 SET character_set_client = @saved_cs_client */;
296 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
299 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
300 /*!40101 SET @saved_cs_client = @@character_set_client */;
301 /*!40101 SET character_set_client = utf8 */;
302 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
303 `DOWNLOAD_DG_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
304 `PROTOCOL` varchar(50) NOT NULL,
305 `DOWNLOAD_CONFIG_DG` varchar(50) NOT NULL,
306 PRIMARY KEY (`DOWNLOAD_DG_REFERENCE_ID`),
307 UNIQUE KEY ` DOWNLOAD_DG_REFERENCE_ID` (`DOWNLOAD_DG_REFERENCE_ID`)
308 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
309 /*!40101 SET character_set_client = @saved_cs_client */;
312 -- Table structure for table `DT_ACTION_STATUS`
315 DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
316 /*!40101 SET @saved_cs_client = @@character_set_client */;
317 /*!40101 SET character_set_client = utf8 */;
318 CREATE TABLE `DT_ACTION_STATUS` (
319 `DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
320 `ACTION` varchar(50) NOT NULL,
321 `VNF_TYPE` varchar(150) DEFAULT NULL,
322 `VNFC_TYPE` varchar(50) DEFAULT NULL,
323 `USER` varchar(50) NOT NULL,
324 `TECHNOLOGY` varchar(50) DEFAULT NULL,
325 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
326 `STATUS` varchar(50) NOT NULL,
327 PRIMARY KEY (`DT_ACTION_STATUS_ID`),
328 UNIQUE KEY `DT_ACTION_STATUS_ID` (`DT_ACTION_STATUS_ID`)
329 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
330 /*!40101 SET character_set_client = @saved_cs_client */;
333 -- Table structure for table `DT_ARTIFACT_REFERENCE`
336 DROP TABLE IF EXISTS `DT_ARTIFACT_REFERENCE`;
337 /*!40101 SET @saved_cs_client = @@character_set_client */;
338 /*!40101 SET character_set_client = utf8 */;
339 CREATE TABLE `DT_ARTIFACT_REFERENCE` (
340 `DT_ARTIFACT_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
341 `PROTOCOL` varchar(50) DEFAULT NULL,
342 `ACTION` varchar(50) DEFAULT NULL,
343 `ARTIFACT_TYPE` varchar(50) NOT NULL,
344 `ARTIFACT_PRIORITY` int(11) NOT NULL,
345 PRIMARY KEY (`DT_ARTIFACT_REFERENCE_ID`),
346 UNIQUE KEY `DT_ARTIFACT_REFERENCE_ID` (`DT_ARTIFACT_REFERENCE_ID`)
347 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
348 /*!40101 SET character_set_client = @saved_cs_client */;
351 -- Table structure for table `DT_ARTIFACT_TRACKING`
354 DROP TABLE IF EXISTS `DT_ARTIFACT_TRACKING`;
355 /*!40101 SET @saved_cs_client = @@character_set_client */;
356 /*!40101 SET character_set_client = utf8 */;
357 CREATE TABLE `DT_ARTIFACT_TRACKING` (
358 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL AUTO_INCREMENT,
359 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
360 `ASDC_REFERENCE_ID` int(11) DEFAULT NULL,
361 `USER` varchar(50) NOT NULL,
362 `TECHNOLOGY` varchar(50) DEFAULT NULL,
363 `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
364 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
365 `ARTIFACT_STATUS` varchar(50) NOT NULL,
366 `IN_CART` varchar(50) DEFAULT NULL,
367 `PROTOCOL` varchar(50) DEFAULT NULL,
368 PRIMARY KEY (`DT_ARTIFACT_TRACKING_ID`),
369 UNIQUE KEY `DT_ARTIFACT_TRACKING_ID` (`DT_ARTIFACT_TRACKING_ID`)
370 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
371 /*!40101 SET character_set_client = @saved_cs_client */;
374 -- Table structure for table `DT_GUI_REFERENCE`
377 DROP TABLE IF EXISTS `DT_GUI_REFERENCE`;
378 /*!40101 SET @saved_cs_client = @@character_set_client */;
379 /*!40101 SET character_set_client = utf8 */;
380 CREATE TABLE `DT_GUI_REFERENCE` (
381 `DT_GUI_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
382 `GUI_NAME` varchar(50) NOT NULL,
383 `FIELD_NAME` varchar(50) NOT NULL,
384 `VALUE` varchar(50) NOT NULL,
385 `USER` varchar(50) NOT NULL,
386 `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
387 `PROTOCOL` varchar(50) DEFAULT NULL,
388 `ACTION` varchar(50) DEFAULT NULL,
389 PRIMARY KEY (`DT_GUI_REFERENCE_ID`),
390 UNIQUE KEY `DT_GUI_REFERENCE_ID` (`DT_GUI_REFERENCE_ID`)
391 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
392 /*!40101 SET character_set_client = @saved_cs_client */;
395 -- Table structure for table `DT_STATUS_RELATIONSHIP`
398 DROP TABLE IF EXISTS `DT_STATUS_RELATIONSHIP`;
399 /*!40101 SET @saved_cs_client = @@character_set_client */;
400 /*!40101 SET character_set_client = utf8 */;
401 CREATE TABLE `DT_STATUS_RELATIONSHIP` (
402 `DT_STATUS_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
403 `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL,
404 `DT_ACTION_STATUS_ID` int(11) NOT NULL,
405 PRIMARY KEY (`DT_STATUS_RELATIONSHIP_ID`),
406 UNIQUE KEY `DT_STATUS_RELATIONSHIP_ID` (`DT_STATUS_RELATIONSHIP_ID`),
407 KEY `IE_DT_STATUS_RELATIONSHIP` (`DT_ARTIFACT_TRACKING_ID`),
408 KEY `IE2_DT_STATUS_RELATIONSHIP` (`DT_ACTION_STATUS_ID`),
409 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,
410 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
411 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
412 /*!40101 SET character_set_client = @saved_cs_client */;
415 -- Table structure for table `GET_CONFIG_TEMPLATE`
418 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
419 /*!40101 SET @saved_cs_client = @@character_set_client */;
420 /*!40101 SET character_set_client = utf8 */;
421 CREATE TABLE `GET_CONFIG_TEMPLATE` (
422 `GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
423 `VNF_TYPE` varchar(150) DEFAULT NULL,
424 `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL,
425 `XML_PROCESSING` varchar(1) DEFAULT NULL,
426 `XML_PROTOCOL` varchar(30) DEFAULT NULL,
428 PRIMARY KEY (`GET_CONFIG_TEMPLATE_ID`),
429 UNIQUE KEY `GET_CONFIG_TEMPLATE_ID` (`GET_CONFIG_TEMPLATE_ID`),
430 KEY `get_config_template_ibfk_1` (`DEVICE_INTERFACE_PROTOCOL_ID`),
431 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
432 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
433 /*!40101 SET character_set_client = @saved_cs_client */;
436 -- Table structure for table `MULTISTEP_FLOW_REFERENCE`
439 DROP TABLE IF EXISTS `MULTISTEP_FLOW_REFERENCE`;
440 /*!40101 SET @saved_cs_client = @@character_set_client */;
441 /*!40101 SET character_set_client = utf8 */;
442 CREATE TABLE `MULTISTEP_FLOW_REFERENCE` (
443 `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
444 `ACTION` varchar(50) NOT NULL,
445 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
446 `VNF_TYPE` varchar(150) DEFAULT NULL,
447 `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
448 `CATEGORY` varchar(50) DEFAULT NULL,
449 `GENERATION_NODE` varchar(50) DEFAULT NULL,
450 `EXECUTION_NODE` varchar(50) DEFAULT NULL,
451 `CREATOR` varchar(50) DEFAULT NULL,
452 `UPDATED_DATE` datetime DEFAULT NULL,
453 UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)
454 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
455 /*!40101 SET character_set_client = @saved_cs_client */;
458 -- Table structure for table `NODE_TYPES`
461 DROP TABLE IF EXISTS `NODE_TYPES`;
462 /*!40101 SET @saved_cs_client = @@character_set_client */;
463 /*!40101 SET character_set_client = utf8 */;
464 CREATE TABLE `NODE_TYPES` (
465 `nodetype` varchar(80) NOT NULL,
466 PRIMARY KEY (`nodetype`)
467 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
468 /*!40101 SET character_set_client = @saved_cs_client */;
471 -- Table structure for table `OPS_AIC_HOSTS`
474 DROP TABLE IF EXISTS `OPS_AIC_HOSTS`;
475 /*!40101 SET @saved_cs_client = @@character_set_client */;
476 /*!40101 SET character_set_client = utf8 */;
477 CREATE TABLE `OPS_AIC_HOSTS` (
478 `REGION_ID` varchar(16) NOT NULL,
479 `HOST` varchar(64) NOT NULL,
480 `HOST_IP` varchar(64) DEFAULT NULL,
481 `EQUIPMENT_VENDOR` varchar(32) DEFAULT NULL,
482 `EQUIPMENT_PRODUCT` varchar(32) DEFAULT NULL,
483 `EQUIPMENT_MODEL` varchar(32) DEFAULT NULL,
484 `EQUIPMENT_VERSION` varchar(32) DEFAULT NULL,
485 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
486 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
487 PRIMARY KEY (`REGION_ID`,`HOST`),
488 CONSTRAINT `fk_aic_hosts` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
489 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
490 /*!40101 SET character_set_client = @saved_cs_client */;
493 -- Table structure for table `OPS_AIC_REGIONS`
496 DROP TABLE IF EXISTS `OPS_AIC_REGIONS`;
497 /*!40101 SET @saved_cs_client = @@character_set_client */;
498 /*!40101 SET character_set_client = utf8 */;
499 CREATE TABLE `OPS_AIC_REGIONS` (
500 `REGION_ID` varchar(16) NOT NULL,
501 `IDENTITY_URL` varchar(256) NOT NULL,
502 `HOST_DISCOVERY` varchar(3) NOT NULL DEFAULT 'NO',
503 `ADMIN_TENANT_ID` varchar(64) DEFAULT NULL,
504 `ADMIN_TENANT_NAME` varchar(64) DEFAULT 'admin',
505 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
506 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
507 PRIMARY KEY (`REGION_ID`)
508 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
509 /*!40101 SET character_set_client = @saved_cs_client */;
512 -- Table structure for table `OPS_AIC_SCHEDULER_EVENTS`
515 DROP TABLE IF EXISTS `OPS_AIC_SCHEDULER_EVENTS`;
516 /*!40101 SET @saved_cs_client = @@character_set_client */;
517 /*!40101 SET character_set_client = utf8 */;
518 CREATE TABLE `OPS_AIC_SCHEDULER_EVENTS` (
519 `REGION_ID` varchar(16) NOT NULL,
520 `HOST` varchar(64) NOT NULL DEFAULT '',
521 `STATE` enum('COMPLETE','PROGRESS') DEFAULT NULL,
522 `STATUS` enum('SUCCESS','FAILED','PARTIAL') DEFAULT NULL,
523 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
524 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
525 `RUNTIME` varchar(8) NOT NULL DEFAULT '',
526 `RETRIES` int(11) NOT NULL DEFAULT '0',
527 `ERROR` varchar(256) DEFAULT NULL,
528 PRIMARY KEY (`REGION_ID`,`HOST`),
529 CONSTRAINT `fk_aic_sch_events` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
530 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
531 /*!40101 SET character_set_client = @saved_cs_client */;
534 -- Table structure for table `OPS_EXPORT_SCRIPT`
537 DROP TABLE IF EXISTS `OPS_EXPORT_SCRIPT`;
538 /*!40101 SET @saved_cs_client = @@character_set_client */;
539 /*!40101 SET character_set_client = utf8 */;
540 CREATE TABLE `OPS_EXPORT_SCRIPT` (
541 `ID` varchar(15) NOT NULL,
542 `SCRIPT` text NOT NULL,
543 `CREATEDON` datetime NOT NULL,
544 `CREATEDBY` varchar(10) NOT NULL,
546 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
547 /*!40101 SET character_set_client = @saved_cs_client */;
550 -- Table structure for table `OPS_HCAGGMETRICS`
553 DROP TABLE IF EXISTS `OPS_HCAGGMETRICS`;
554 /*!40101 SET @saved_cs_client = @@character_set_client */;
555 /*!40101 SET character_set_client = utf8 */;
556 CREATE TABLE `OPS_HCAGGMETRICS` (
557 `ID` int(11) NOT NULL AUTO_INCREMENT,
558 `AGG_TIME` datetime DEFAULT NULL,
559 `CNT` int(11) DEFAULT NULL,
560 `HCCODE` varchar(45) DEFAULT NULL,
561 `SUCCESS` varchar(20) DEFAULT NULL,
562 `MIN_DUR` float DEFAULT NULL,
563 `AVG_DUR` float DEFAULT NULL,
564 `MAX_DUR` float DEFAULT NULL,
565 `STDDEV_DUR` float DEFAULT NULL,
566 `SDNOINSTANCE` varchar(45) DEFAULT NULL,
567 `HCNODETYPE` varchar(45) DEFAULT NULL,
568 `CLIENTNAME` varchar(45) DEFAULT NULL,
570 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
571 /*!40101 SET character_set_client = @saved_cs_client */;
574 -- Table structure for table `OPS_HCGROUPS`
577 DROP TABLE IF EXISTS `OPS_HCGROUPS`;
578 /*!40101 SET @saved_cs_client = @@character_set_client */;
579 /*!40101 SET character_set_client = utf8 */;
580 CREATE TABLE `OPS_HCGROUPS` (
581 `HCGROUPID` int(11) NOT NULL AUTO_INCREMENT,
582 `HCCODE` varchar(45) NOT NULL,
583 `CHCCODE` varchar(45) NOT NULL,
584 `EXECPRIORITY` int(11) DEFAULT NULL,
585 `CREATEDBY` varchar(45) DEFAULT NULL,
586 `CREATEDON` datetime DEFAULT NULL,
587 `UPDATEDON` datetime DEFAULT NULL,
588 `UPDATEDBY` varchar(45) DEFAULT NULL,
589 PRIMARY KEY (`HCGROUPID`)
590 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
591 /*!40101 SET character_set_client = @saved_cs_client */;
594 -- Table structure for table `OPS_HCRESPARCHIVE`
597 DROP TABLE IF EXISTS `OPS_HCRESPARCHIVE`;
598 /*!40101 SET @saved_cs_client = @@character_set_client */;
599 /*!40101 SET character_set_client = utf8 */;
600 CREATE TABLE `OPS_HCRESPARCHIVE` (
601 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
602 `HCTRANSID` varchar(128) DEFAULT NULL,
603 `REFHCTRANSID` varchar(128) DEFAULT NULL,
604 `SDNOTRANSID` varchar(255) DEFAULT NULL,
605 `HOSTIP` varchar(45) DEFAULT NULL,
606 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
607 `HCRESPONSE` longtext,
608 `CREATEDON` datetime DEFAULT NULL,
609 `SDNOINSTANCE` varchar(45) NOT NULL,
610 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
611 `DMAAPSENT` varchar(1) NOT NULL DEFAULT 'N',
612 `NODETYPE` varchar(45) DEFAULT NULL,
613 `HCCODE` varchar(45) DEFAULT NULL,
614 `USERID` varchar(10) DEFAULT NULL,
615 `CLIENTNAME` varchar(45) DEFAULT NULL,
616 `HDSTARTTIME` datetime DEFAULT NULL,
617 `HDENDTIME` datetime DEFAULT NULL,
618 PRIMARY KEY (`HCRESPONSEID`),
619 KEY `hctransid_idx` (`HCTRANSID`),
620 KEY `sdnotransid_idx` (`SDNOTRANSID`),
621 KEY `clientname_idx` (`CLIENTNAME`),
622 KEY `nodetype_idx` (`NODETYPE`),
623 KEY `hccode_idx` (`HCCODE`),
624 KEY `hostip_idx` (`HOSTIP`),
625 KEY `createdon_idx` (`CREATEDON`)
626 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
627 /*!40101 SET character_set_client = @saved_cs_client */;
630 -- Table structure for table `OPS_HCRESPCACHE`
633 DROP TABLE IF EXISTS `OPS_HCRESPCACHE`;
634 /*!40101 SET @saved_cs_client = @@character_set_client */;
635 /*!40101 SET character_set_client = utf8 */;
636 CREATE TABLE `OPS_HCRESPCACHE` (
637 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
638 `SDNOTRANSID` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
639 `HOSTIP` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
640 `HCRESPONSESTATUS` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
641 `HCRESPONSE` longtext CHARACTER SET utf8,
642 `CREATEDON` datetime DEFAULT NULL,
643 `SDNOINSTANCE` varchar(45) CHARACTER SET utf8 NOT NULL,
644 `SDNOINSTANCESERVER` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
645 `DMAAPSENT` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
646 `NODETYPE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
647 `HCCODE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
648 `USERID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
649 `CLIENTNAME` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
650 `HDSTARTTIME` datetime DEFAULT NULL,
651 `HDENDTIME` datetime DEFAULT NULL,
652 `CACHEEXPIRETIME` datetime DEFAULT NULL,
653 `HDEXPECTEDENDTIME` datetime DEFAULT NULL,
654 PRIMARY KEY (`HCRESPONSEID`),
655 KEY `cacheexpiretime_idx` (`CACHEEXPIRETIME`),
656 KEY `hdexpectedendtime_idx` (`HDEXPECTEDENDTIME`),
657 KEY `hdendtime_idx` (`HDENDTIME`),
658 KEY `hdstarttime_idx` (`HDSTARTTIME`)
659 ) ENGINE=InnoDB AUTO_INCREMENT=383 DEFAULT CHARSET=latin1;
660 /*!40101 SET character_set_client = @saved_cs_client */;
663 -- Temporary table structure for view `OPS_HCRESPCACHEVIEW`
666 DROP TABLE IF EXISTS `OPS_HCRESPCACHEVIEW`;
667 /*!50001 DROP VIEW IF EXISTS `OPS_HCRESPCACHEVIEW`*/;
668 SET @saved_cs_client = @@character_set_client;
669 SET character_set_client = utf8;
670 /*!50001 CREATE VIEW `OPS_HCRESPCACHEVIEW` AS SELECT
675 1 AS `HCRESPONSESTATUS`,
679 1 AS `SDNOINSTANCESERVER`,
687 1 AS `CACHEEXPIRETIME`,
688 1 AS `HDEXPECTEDENDTIME`*/;
689 SET character_set_client = @saved_cs_client;
692 -- Table structure for table `OPS_HCRESPCOMPACT`
695 DROP TABLE IF EXISTS `OPS_HCRESPCOMPACT`;
696 /*!40101 SET @saved_cs_client = @@character_set_client */;
697 /*!40101 SET character_set_client = utf8 */;
698 CREATE TABLE `OPS_HCRESPCOMPACT` (
699 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
700 `HCTRANSID` varchar(128) DEFAULT NULL,
701 `HOSTIP` varchar(45) DEFAULT NULL,
702 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
703 `SDNOINSTANCE` varchar(45) NOT NULL,
704 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
705 `NODETYPE` varchar(45) DEFAULT NULL,
706 `HCCODE` varchar(45) DEFAULT NULL,
707 `USERID` varchar(10) DEFAULT NULL,
708 `CLIENTNAME` varchar(45) DEFAULT NULL,
709 `HDSTARTTIME` datetime DEFAULT NULL,
710 `HDENDTIME` datetime DEFAULT NULL,
711 PRIMARY KEY (`HCRESPONSEID`),
712 KEY `clientname_idx` (`CLIENTNAME`),
713 KEY `nodetype_idx` (`NODETYPE`),
714 KEY `hccode_idx` (`HCCODE`),
715 KEY `hcresponsestatus_idx` (`HCRESPONSESTATUS`),
716 KEY `hdstarttime_idx` (`HDSTARTTIME`),
717 KEY `hdendtime_idx` (`HDENDTIME`)
718 ) ENGINE=InnoDB AUTO_INCREMENT=15378 DEFAULT CHARSET=utf8;
719 /*!40101 SET character_set_client = @saved_cs_client */;
722 -- Table structure for table `OPS_HCTYPES`
725 DROP TABLE IF EXISTS `OPS_HCTYPES`;
726 /*!40101 SET @saved_cs_client = @@character_set_client */;
727 /*!40101 SET character_set_client = utf8 */;
728 CREATE TABLE `OPS_HCTYPES` (
729 `HCTYPEID` int(11) NOT NULL AUTO_INCREMENT,
730 `HCCODE` varchar(45) DEFAULT NULL,
731 `HCDESCR` varchar(45) DEFAULT NULL,
732 `HCNODETYPE` varchar(45) DEFAULT NULL,
733 `NODETYPEVERSION` varchar(15) DEFAULT NULL,
734 `STACKLEVEL` varchar(15) DEFAULT 'VM',
735 `ACTIVE` varchar(5) DEFAULT NULL,
736 `EXECPRIORITY` int(11) DEFAULT NULL,
737 `SBINTERFACE` varchar(45) DEFAULT 'ssh',
738 `SELECTABLE` varchar(2) DEFAULT 'Y',
739 `EXECTIME` int(11) DEFAULT '10' COMMENT 'expected execution time in secs',
740 `DEFAULT4NODETYPE` varchar(2) DEFAULT 'N' COMMENT 'default HD for this nodetype',
741 `CACHEDURATION` int(5) DEFAULT '2' COMMENT 'cache default is in minutes',
742 `LOGCMDRESP2DB` varchar(2) DEFAULT 'Y',
743 `VERSIONCHKHD` varchar(45) DEFAULT NULL,
744 `SBIALTSRVR` varchar(255) DEFAULT NULL,
745 `CREATEDON` datetime DEFAULT NULL,
746 `CREATEDBY` varchar(15) DEFAULT NULL,
747 `UPDATEDON` datetime DEFAULT NULL,
748 `UPDATEDBY` varchar(15) DEFAULT NULL,
749 PRIMARY KEY (`HCTYPEID`),
750 KEY `hcnodetype_idx` (`HCNODETYPE`),
751 KEY `hccode_idx` (`HCCODE`),
752 KEY `active_idx` (`ACTIVE`),
753 KEY `default4nodetype_idx` (`DEFAULT4NODETYPE`)
754 ) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;
755 /*!40101 SET character_set_client = @saved_cs_client */;
758 -- Temporary table structure for view `OPS_HCVIEW`
761 DROP TABLE IF EXISTS `OPS_HCVIEW`;
762 /*!50001 DROP VIEW IF EXISTS `OPS_HCVIEW`*/;
763 SET @saved_cs_client = @@character_set_client;
764 SET character_set_client = utf8;
765 /*!50001 CREATE VIEW `OPS_HCVIEW` AS SELECT
784 SET character_set_client = @saved_cs_client;
787 -- Table structure for table `OPS_HEALTHCHECK`
790 DROP TABLE IF EXISTS `OPS_HEALTHCHECK`;
791 /*!40101 SET @saved_cs_client = @@character_set_client */;
792 /*!40101 SET character_set_client = utf8 */;
793 CREATE TABLE `OPS_HEALTHCHECK` (
794 `HCID` int(11) NOT NULL AUTO_INCREMENT,
795 `HCCODE` varchar(45) DEFAULT NULL,
796 `COMMAND` varchar(512) DEFAULT NULL,
797 `ACTIVE` varchar(1) DEFAULT 'N',
798 `PROMPTCHECK` varchar(32) DEFAULT NULL,
799 `EXECPRIORITY` int(11) DEFAULT NULL,
800 `TIMEOUT` int(11) DEFAULT NULL,
801 `PATTERNMATCH` varchar(512) DEFAULT NULL,
802 `FLIPRXRSLT` varchar(45) NOT NULL DEFAULT 'N',
803 `EXITONFAIL` varchar(6) DEFAULT 'N',
804 `SENDCMDRESP` varchar(5) DEFAULT 'Y',
805 `MANUALEFFORT` int(11) DEFAULT '2' COMMENT 'manual execution estimate in mins',
806 `COMMANDDESC` varchar(100) DEFAULT NULL,
807 `VERSION` varchar(45) DEFAULT 'none',
808 `CREATEDON` datetime DEFAULT NULL,
809 `CREATEDBY` varchar(15) DEFAULT NULL,
810 `UPDATEDON` datetime DEFAULT NULL,
811 `UPDATEDBY` varchar(15) DEFAULT NULL,
812 PRIMARY KEY (`HCID`),
813 KEY `hccode_idx` (`HCCODE`),
814 KEY `active_idx` (`ACTIVE`)
815 ) ENGINE=InnoDB AUTO_INCREMENT=445 DEFAULT CHARSET=latin1;
816 /*!40101 SET character_set_client = @saved_cs_client */;
819 -- Table structure for table `OPS_HEALTHCHECKRESPONSE`
822 DROP TABLE IF EXISTS `OPS_HEALTHCHECKRESPONSE`;
823 /*!40101 SET @saved_cs_client = @@character_set_client */;
824 /*!40101 SET character_set_client = utf8 */;
825 CREATE TABLE `OPS_HEALTHCHECKRESPONSE` (
826 `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
827 `HCTRANSID` varchar(128) DEFAULT NULL,
828 `REFHCTRANSID` varchar(128) DEFAULT NULL,
829 `SDNOTRANSID` varchar(255) DEFAULT NULL,
830 `HOSTIP` varchar(45) DEFAULT NULL,
831 `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
832 `HCRESPONSE` longtext,
833 `CREATEDON` datetime DEFAULT NULL,
834 `SDNOINSTANCE` varchar(45) NOT NULL,
835 `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
836 `DMAAPSENT` varchar(1) NOT NULL DEFAULT 'N',
837 `NODETYPE` varchar(45) DEFAULT NULL,
838 `HCCODE` varchar(45) DEFAULT NULL,
839 `USERID` varchar(10) DEFAULT NULL,
840 `CLIENTNAME` varchar(45) DEFAULT NULL,
841 `HDSTARTTIME` datetime DEFAULT NULL,
842 `HDENDTIME` datetime DEFAULT NULL,
843 PRIMARY KEY (`HCRESPONSEID`),
844 KEY `hctransid_idx` (`HCTRANSID`),
845 KEY `sdnotransid_idx` (`SDNOTRANSID`),
846 KEY `clientname_idx` (`CLIENTNAME`),
847 KEY `nodetype_idx` (`NODETYPE`),
848 KEY `hccode_idx` (`HCCODE`),
849 KEY `hostip_idx` (`HOSTIP`),
850 KEY `createdon_idx` (`CREATEDON`)
851 ) ENGINE=InnoDB AUTO_INCREMENT=15380 DEFAULT CHARSET=utf8;
852 /*!40101 SET character_set_client = @saved_cs_client */;
853 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
854 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
855 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
856 /*!50003 SET character_set_client = latin1 */ ;
857 /*!50003 SET character_set_results = latin1 */ ;
858 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
859 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
860 /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
862 /*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `OPS_HEALTHCHECKRESPONSE_BEFORE_INSERT` BEFORE INSERT ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
864 declare reftransid varchar(128);
866 declare ahostip varchar(45);
867 declare ahdcode varchar(45);
868 declare ahdendtime datetime;
869 declare ahdstarttime datetime;
870 declare acacheexpiretime datetime;
871 declare hdexectime INT DEFAULT 5;
872 declare hdexpectedendtime datetime;
873 declare nowtime datetime;
874 declare acacheduration INT;
875 declare maxtimeintbl INT DEFAULT 1800;
877 SET nowtime:=utc_timestamp();
878 SET ahdcode:=NEW.HCCODE;
879 SET ahostip:=NEW.HOSTIP;
880 SET reftransid:=trim(NEW.REFHCTRANSID);
881 SET new.CREATEDON = nowtime;
882 SET new.HDSTARTTIME = nowtime;
884 delete from OPS_HCRESPCACHE where HDENDTIME is null AND time_to_sec(timediff(nowtime, HDSTARTTIME))>maxtimeintbl;
886 IF (reftransid is null) then
887 select CACHEDURATION, EXECTIME into acacheduration, hdexectime from OPS_HCTYPES where HCCODE=ahdcode;
888 select count(*) into ccount from OPS_HCRESPCACHE where HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0;
890 select HDSTARTTIME, HDENDTIME, CACHEEXPIRETIME into ahdstarttime, ahdendtime, acacheexpiretime from OPS_HCRESPCACHE where
891 HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0 order by HDENDTIME desc limit 1 ;
892 select time_to_sec(timediff(ahdendtime, ahdstarttime)) into hdexectime;
895 if (acacheduration > 0) then
896 set hdexpectedendtime = nowtime + INTERVAL hdexectime second;
897 insert into OPS_HCRESPCACHE(HCRESPONSEID,SDNOTRANSID,HOSTIP,HCRESPONSESTATUS,HCRESPONSE,CREATEDON,SDNOINSTANCE,SDNOINSTANCESERVER,DMAAPSENT,
898 NODETYPE,HCCODE,USERID,CLIENTNAME,HDSTARTTIME,HDENDTIME,CACHEEXPIRETIME,HDEXPECTEDENDTIME)
899 VALUES(NEW.HCRESPONSEID,NEW.SDNOTRANSID,NEW.HOSTIP,null,null,nowtime,NEW.SDNOINSTANCE,NEW.SDNOINSTANCESERVER,NEW.DMAAPSENT,
900 NEW.NODETYPE,NEW.HCCODE,NEW.USERID,NEW.CLIENTNAME,NEW.HDSTARTTIME,null,null,hdexpectedendtime);
906 /*!50003 SET sql_mode = @saved_sql_mode */ ;
907 /*!50003 SET character_set_client = @saved_cs_client */ ;
908 /*!50003 SET character_set_results = @saved_cs_results */ ;
909 /*!50003 SET collation_connection = @saved_col_connection */ ;
910 /*!50003 SET @saved_cs_client = @@character_set_client */ ;
911 /*!50003 SET @saved_cs_results = @@character_set_results */ ;
912 /*!50003 SET @saved_col_connection = @@collation_connection */ ;
913 /*!50003 SET character_set_client = latin1 */ ;
914 /*!50003 SET character_set_results = latin1 */ ;
915 /*!50003 SET collation_connection = latin1_swedish_ci */ ;
916 /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
917 /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
919 /*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `sdnctl`.`OPS_HEALTHCHECKRESPONSE_BEFORE_UPDATE` BEFORE UPDATE ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
921 Declare aduration INT;
922 declare reftransid varchar(128);
923 DECLARE cachetime datetime;
924 declare ahostip varchar(45);
925 declare ahdcode varchar(45);
926 declare ahdendtime datetime;
928 SET ahdcode:=NEW.HCCODE;
929 SET ahostip:=NEW.HOSTIP;
930 SET ahdendtime:=NEW.HDENDTIME;
931 SET reftransid:=trim(NEW.REFHCTRANSID);
933 if (NEW.DMAAPSENT in ('U','Y')) then
934 update OPS_HCRESPCACHE
935 set DMAAPSENT=NEW.DMAAPSENT where OLD.SDNOTRANSID=NEW.SDNOTRANSID and OLD.CREATEDON=NEW.CREATEDON;
936 ELSEIF (reftransid is null and OLD.HCRESPONSESTATUS is null) then
937 select cacheduration into aduration from OPS_HCTYPES where HCCODE=ahdcode;
938 if (aduration > 0) then
939 select ahdendtime + INTERVAL aduration MINUTE into cachetime from OPS_HCTYPES where HCCODE=ahdcode;
940 update OPS_HCRESPCACHE
941 set HCRESPONSESTATUS=NEW.HCRESPONSESTATUS,HCRESPONSE=NEW.HCRESPONSE,HDENDTIME=NEW.HDENDTIME,CACHEEXPIRETIME=cachetime,HDEXPECTEDENDTIME=null
942 where SDNOTRANSID=NEW.SDNOTRANSID and CREATEDON=NEW.CREATEDON;
943 insert into OPS_HCRESPCOMPACT (HCRESPONSEID, HCTRANSID, HOSTIP, HCRESPONSESTATUS, SDNOINSTANCE, SDNOINSTANCESERVER, NODETYPE, HCCODE, USERID, CLIENTNAME, HDSTARTTIME, HDENDTIME)
944 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);
949 /*!50003 SET sql_mode = @saved_sql_mode */ ;
950 /*!50003 SET character_set_client = @saved_cs_client */ ;
951 /*!50003 SET character_set_results = @saved_cs_results */ ;
952 /*!50003 SET collation_connection = @saved_col_connection */ ;
955 -- Table structure for table `OPS_MAPNODETYPES`
958 DROP TABLE IF EXISTS `OPS_MAPNODETYPES`;
959 /*!40101 SET @saved_cs_client = @@character_set_client */;
960 /*!40101 SET character_set_client = utf8 */;
961 CREATE TABLE `OPS_MAPNODETYPES` (
962 `ID` int(11) NOT NULL AUTO_INCREMENT,
963 `INNODETYPE` varchar(45) DEFAULT NULL COMMENT 'nodetype value in incoming API',
964 `TBLNODETYPE` varchar(45) DEFAULT NULL COMMENT 'nodetype value as stored in db',
966 KEY `tablnodetype_idx` (`TBLNODETYPE`)
967 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
968 /*!40101 SET character_set_client = @saved_cs_client */;
971 -- Table structure for table `OPS_NODEINFO`
974 DROP TABLE IF EXISTS `OPS_NODEINFO`;
975 /*!40101 SET @saved_cs_client = @@character_set_client */;
976 /*!40101 SET character_set_client = utf8 */;
977 CREATE TABLE `OPS_NODEINFO` (
978 `NODEID` int(11) NOT NULL AUTO_INCREMENT,
979 `NODETYPE` varchar(255) DEFAULT NULL,
980 `HOSTIP` varchar(45) DEFAULT NULL,
981 `STACKLEVEL` varchar(15) DEFAULT 'VM',
982 `HOSTUSER` varchar(45) DEFAULT NULL,
983 `HOSTPASSWORD` varchar(45) DEFAULT NULL,
984 `PROMPTCMD` varchar(256) DEFAULT NULL,
985 `PREPROMPTSTRS` varchar(45) DEFAULT NULL COMMENT 'Strings to send before login prompt',
986 `LABNODETYPE` varchar(256) DEFAULT NULL,
987 `MULTIVERSIONS` varchar(2) DEFAULT 'N',
988 `JUMPSERVERIP` varchar(45) DEFAULT NULL,
989 `JUMPSERVERUSER` varchar(45) DEFAULT NULL,
990 `JUMPSERVERPASSWORD` varchar(45) DEFAULT NULL,
991 `VSERVERID` varchar(128) DEFAULT NULL,
992 `SELFSERVLINK` varchar(1024) DEFAULT NULL,
993 `TENANTID` varchar(128) DEFAULT NULL,
994 `IDENTITYURL` varchar(1024) DEFAULT NULL,
995 PRIMARY KEY (`NODEID`),
996 KEY `hostname_idx` (`NODETYPE`)
997 ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
998 /*!40101 SET character_set_client = @saved_cs_client */;
1001 -- Table structure for table `OPS_NODETYPE2SDNO`
1004 DROP TABLE IF EXISTS `OPS_NODETYPE2SDNO`;
1005 /*!40101 SET @saved_cs_client = @@character_set_client */;
1006 /*!40101 SET character_set_client = utf8 */;
1007 CREATE TABLE `OPS_NODETYPE2SDNO` (
1008 `VNFTYPEID` int(11) NOT NULL AUTO_INCREMENT,
1009 `VNFTYPECODE` varchar(45) DEFAULT NULL,
1010 `VNFTYPENAME` varchar(256) DEFAULT NULL,
1011 `VNFCLLI` varchar(20) DEFAULT NULL,
1012 `DEFAULT_4_UNK_CLLI` varchar(2) DEFAULT NULL,
1013 `SDNOINSTANCE` varchar(45) NOT NULL,
1014 PRIMARY KEY (`VNFTYPEID`)
1015 ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
1016 /*!40101 SET character_set_client = @saved_cs_client */;
1019 -- Table structure for table `OPS_NODE_PROPERTIES`
1022 DROP TABLE IF EXISTS `OPS_NODE_PROPERTIES`;
1023 /*!40101 SET @saved_cs_client = @@character_set_client */;
1024 /*!40101 SET character_set_client = utf8 */;
1025 CREATE TABLE `OPS_NODE_PROPERTIES` (
1026 `NODETYPE` varchar(64) NOT NULL,
1027 `PROPERTY` varchar(64) NOT NULL,
1028 `VALUE` varchar(128) NOT NULL,
1029 `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1030 `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
1031 PRIMARY KEY (`NODETYPE`,`PROPERTY`)
1032 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1033 /*!40101 SET character_set_client = @saved_cs_client */;
1036 -- Table structure for table `OPS_SDNOINFO`
1039 DROP TABLE IF EXISTS `OPS_SDNOINFO`;
1040 /*!40101 SET @saved_cs_client = @@character_set_client */;
1041 /*!40101 SET character_set_client = utf8 */;
1042 CREATE TABLE `OPS_SDNOINFO` (
1043 `SDNOID` int(11) NOT NULL AUTO_INCREMENT,
1044 `SDNOINSTANCE` varchar(45) DEFAULT NULL,
1045 `URI` varchar(1000) NOT NULL,
1046 PRIMARY KEY (`SDNOID`),
1047 UNIQUE KEY `SDNOINSTANCE_UNIQUE` (`SDNOINSTANCE`)
1048 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
1049 /*!40101 SET character_set_client = @saved_cs_client */;
1052 -- Table structure for table `OPS_SQLMGR`
1055 DROP TABLE IF EXISTS `OPS_SQLMGR`;
1056 /*!40101 SET @saved_cs_client = @@character_set_client */;
1057 /*!40101 SET character_set_client = utf8 */;
1058 CREATE TABLE `OPS_SQLMGR` (
1059 `SQLID` int(11) NOT NULL AUTO_INCREMENT,
1061 `SQLSTATUS` int(11) DEFAULT '0',
1062 `COMMENTS` varchar(255) DEFAULT NULL,
1063 `CREATEDBY` varchar(15) DEFAULT NULL,
1064 `CREATEDON` datetime DEFAULT NULL,
1065 PRIMARY KEY (`SQLID`)
1066 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1067 /*!40101 SET character_set_client = @saved_cs_client */;
1070 -- Table structure for table `OPS_TRUSTED_PARTNER`
1073 DROP TABLE IF EXISTS `OPS_TRUSTED_PARTNER`;
1074 /*!40101 SET @saved_cs_client = @@character_set_client */;
1075 /*!40101 SET character_set_client = utf8 */;
1076 CREATE TABLE `OPS_TRUSTED_PARTNER` (
1077 `PARTNERID` int(11) NOT NULL AUTO_INCREMENT,
1078 `PARTNER_NAME` varchar(256) NOT NULL,
1079 `PARTNER_PUBLIC_KEY` varchar(1024) DEFAULT NULL,
1080 PRIMARY KEY (`PARTNERID`)
1081 ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
1082 /*!40101 SET character_set_client = @saved_cs_client */;
1085 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
1088 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
1089 /*!40101 SET @saved_cs_client = @@character_set_client */;
1090 /*!40101 SET character_set_client = utf8 */;
1091 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
1092 `PREPARE_FILE_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
1093 `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
1094 `REQUEST_ID` varchar(255) DEFAULT NULL,
1095 `CONFIG_FILE_ID` int(11) DEFAULT NULL,
1096 `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
1097 PRIMARY KEY (`PREPARE_FILE_RELATIONSHIP_ID`),
1098 UNIQUE KEY `PREPARE_FILE_RELATIONSHIP_ID` (`PREPARE_FILE_RELATIONSHIP_ID`),
1099 KEY `ie_prepare_file_relationship` (`CONFIG_FILE_ID`),
1100 KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
1101 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
1102 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
1103 ) ENGINE=InnoDB AUTO_INCREMENT=338 DEFAULT CHARSET=latin1;
1104 /*!40101 SET character_set_client = @saved_cs_client */;
1107 -- Table structure for table `PROCESS_FLOW_REFERENCE`
1110 DROP TABLE IF EXISTS `PROCESS_FLOW_REFERENCE`;
1111 /*!40101 SET @saved_cs_client = @@character_set_client */;
1112 /*!40101 SET character_set_client = utf8 */;
1113 CREATE TABLE `PROCESS_FLOW_REFERENCE` (
1114 `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1115 `ACTION` varchar(50) NOT NULL,
1116 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
1117 `PROTOCOL` varchar(50) DEFAULT NULL,
1118 `EXECUTION_TYPE` varchar(100) NOT NULL,
1119 `EXECUTION_MODULE` varchar(100) NOT NULL,
1120 `EXECUTION_RPC` varchar(100) NOT NULL,
1121 `UPDATED_DATE` datetime DEFAULT NULL,
1122 `GET_RUNNING_CONFIG` varchar(50) DEFAULT NULL,
1123 PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),
1124 UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)
1125 ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
1126 /*!40101 SET character_set_client = @saved_cs_client */;
1129 -- Table structure for table `PROTOCOL_REFERENCE`
1132 DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
1133 /*!40101 SET @saved_cs_client = @@character_set_client */;
1134 /*!40101 SET character_set_client = utf8 */;
1135 CREATE TABLE `PROTOCOL_REFERENCE` (
1136 `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1137 `ACTION` varchar(50) NOT NULL,
1138 `VNF_TYPE` varchar(150) DEFAULT NULL,
1139 `PROTOCOL` varchar(50) DEFAULT NULL,
1140 `UPDATED_DATE` datetime DEFAULT NULL,
1141 `TEMPLATE` varchar(45) DEFAULT NULL,
1142 `ACTION_LEVEL` varchar(45) DEFAULT NULL,
1143 PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
1144 UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
1145 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
1146 /*!40101 SET character_set_client = @saved_cs_client */;
1149 -- Table structure for table `REQUEST_ARTIFACTS`
1152 DROP TABLE IF EXISTS `REQUEST_ARTIFACTS`;
1153 /*!40101 SET @saved_cs_client = @@character_set_client */;
1154 /*!40101 SET character_set_client = utf8 */;
1155 CREATE TABLE `REQUEST_ARTIFACTS` (
1156 `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
1157 `REQUEST_ID` varchar(50) NOT NULL,
1158 `ACTION` varchar(50) NOT NULL,
1159 `ACTION_LEVEL` varchar(50) DEFAULT NULL,
1160 `VNF_TYPE` varchar(150) DEFAULT NULL,
1161 `CATEGORY` varchar(50) NOT NULL,
1162 `ARTIFACT_CONTENT` longtext,
1163 `UPDATED_DATE` datetime DEFAULT NULL,
1164 PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
1165 UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
1166 ) ENGINE=InnoDB AUTO_INCREMENT=1962 DEFAULT CHARSET=latin1;
1167 /*!40101 SET character_set_client = @saved_cs_client */;
1170 -- Table structure for table `SVC_LOGIC`
1173 DROP TABLE IF EXISTS `SVC_LOGIC`;
1174 /*!40101 SET @saved_cs_client = @@character_set_client */;
1175 /*!40101 SET character_set_client = utf8 */;
1176 CREATE TABLE `SVC_LOGIC` (
1177 `module` varchar(80) NOT NULL,
1178 `rpc` varchar(80) NOT NULL,
1179 `version` varchar(40) NOT NULL,
1180 `mode` varchar(5) NOT NULL,
1181 `active` varchar(1) NOT NULL,
1183 `md5sum` varchar(32) NOT NULL DEFAULT '',
1184 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
1185 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1186 /*!40101 SET character_set_client = @saved_cs_client */;
1189 -- Table structure for table `TRANSACTIONS`
1192 DROP TABLE IF EXISTS `TRANSACTIONS`;
1193 /*!40101 SET @saved_cs_client = @@character_set_client */;
1194 /*!40101 SET character_set_client = utf8 */;
1195 CREATE TABLE `TRANSACTIONS` (
1196 `TRANSACTION_ID` varchar(75) NOT NULL,
1197 `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
1198 `REQUEST_ID` varchar(256) NOT NULL,
1199 `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
1200 `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
1201 `START_TIME` datetime(3) NOT NULL,
1202 `END_TIME` datetime(3) DEFAULT NULL,
1203 `TARGET_ID` varchar(256) DEFAULT NULL,
1204 `TARGET_TYPE` varchar(256) DEFAULT NULL,
1205 `OPERATION` varchar(256) NOT NULL,
1206 `RESULT_CODE` int(11) DEFAULT NULL,
1208 `STATE` varchar(50) NOT NULL,
1209 `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
1210 `VNFC_NAME` varchar(256) DEFAULT NULL,
1211 `VSERVER_ID` varchar(256) DEFAULT NULL,
1212 `VF_MODULE_ID` varchar(256) DEFAULT NULL,
1213 `MODE` varchar(50) NOT NULL,
1214 PRIMARY KEY (`TRANSACTION_ID`)
1215 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1216 /*!40101 SET character_set_client = @saved_cs_client */;
1219 -- Table structure for table `UPLOAD_CONFIG`
1222 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
1223 /*!40101 SET @saved_cs_client = @@character_set_client */;
1224 /*!40101 SET character_set_client = utf8 */;
1225 CREATE TABLE `UPLOAD_CONFIG` (
1226 `UPLOAD_CONFIG_ID` int(11) NOT NULL AUTO_INCREMENT,
1227 `REQUEST_ID` varchar(50) DEFAULT NULL,
1228 `ORIGINATOR_ID` varchar(50) DEFAULT NULL,
1229 `SERVICE_DESCRIPTION` varchar(100) DEFAULT NULL,
1230 `ACTION` varchar(50) DEFAULT NULL,
1231 `UPLOAD_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1232 `VNF_ID` varchar(50) DEFAULT NULL,
1233 `VNF_NAME` varchar(50) DEFAULT NULL,
1234 `VM_NAME` varchar(50) DEFAULT NULL,
1235 `VNF_TYPE` varchar(150) DEFAULT NULL,
1236 `VNFC_TYPE` varchar(50) DEFAULT NULL,
1237 `HOST_IP_ADDRESS` varchar(50) DEFAULT NULL,
1238 `CONFIG_INDICATOR` varchar(25) DEFAULT NULL,
1239 `PENDING_DELETE` varchar(1) DEFAULT NULL,
1241 PRIMARY KEY (`UPLOAD_CONFIG_ID`),
1242 UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
1243 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1244 /*!40101 SET character_set_client = @saved_cs_client */;
1247 -- Table structure for table `VNFC_DG_MAPPING`
1250 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
1251 /*!40101 SET @saved_cs_client = @@character_set_client */;
1252 /*!40101 SET character_set_client = utf8 */;
1253 CREATE TABLE `VNFC_DG_MAPPING` (
1254 `VNFC_DG_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
1255 `ACTION` varchar(50) DEFAULT NULL,
1256 `API_VERSION` varchar(10) DEFAULT NULL,
1257 `VNF_TYPE` varchar(150) DEFAULT NULL,
1258 `VNFC_TYPE` varchar(50) DEFAULT NULL,
1259 `DG_NAME` varchar(50) NOT NULL,
1260 `DG_VERSION` varchar(50) DEFAULT NULL,
1261 `DG_MODULE` varchar(50) NOT NULL,
1262 PRIMARY KEY (`VNFC_DG_MAPPING_ID`)
1263 ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
1264 /*!40101 SET character_set_client = @saved_cs_client */;
1267 -- Table structure for table `VNFC_REFERENCE`
1270 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
1271 /*!40101 SET @saved_cs_client = @@character_set_client */;
1272 /*!40101 SET character_set_client = utf8 */;
1273 CREATE TABLE `VNFC_REFERENCE` (
1274 `VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
1275 `ACTION` varchar(50) NOT NULL,
1276 `VNF_TYPE` varchar(150) DEFAULT NULL,
1277 `VM_INSTANCE` int(11) NOT NULL,
1278 `VNFC_INSTANCE` int(11) NOT NULL,
1279 `VNFC_TYPE` varchar(50) NOT NULL,
1280 `VNFC_FUNCTION_CODE` varchar(50) NOT NULL,
1281 `IPADDRESS_V4_OAM_VIP` varchar(50) DEFAULT NULL,
1282 `GROUP_NOTATION_TYPE` varchar(50) DEFAULT NULL,
1283 `GROUP_NOTATION_VALUE` varchar(50) DEFAULT NULL,
1284 `TEMPLATE_ID` varchar(100) DEFAULT NULL,
1285 PRIMARY KEY (`VNFC_REFERENCE_ID`),
1286 UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
1287 ) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=latin1;
1288 /*!40101 SET character_set_client = @saved_cs_client */;
1291 -- Table structure for table `VNF_DG_MAPPING`
1294 DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
1295 /*!40101 SET @saved_cs_client = @@character_set_client */;
1296 /*!40101 SET character_set_client = utf8 */;
1297 CREATE TABLE `VNF_DG_MAPPING` (
1298 `VNF_DG_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
1299 `ACTION` varchar(50) NOT NULL,
1300 `API_VERSION` varchar(50) DEFAULT NULL,
1301 `VNF_TYPE` varchar(150) DEFAULT NULL,
1302 `VNF_VERSION` varchar(50) DEFAULT NULL,
1303 `DG_NAME` varchar(50) NOT NULL,
1304 `DG_VERSION` varchar(50) DEFAULT NULL,
1305 `DG_MODULE` varchar(50) NOT NULL,
1306 PRIMARY KEY (`VNF_DG_MAPPING_ID`)
1307 ) ENGINE=InnoDB AUTO_INCREMENT=576 DEFAULT CHARSET=latin1;
1308 /*!40101 SET character_set_client = @saved_cs_client */;
1311 -- Table structure for table `VNF_LOCK_MANAGEMENT`
1314 DROP TABLE IF EXISTS `VNF_LOCK_MANAGEMENT`;
1315 /*!40101 SET @saved_cs_client = @@character_set_client */;
1316 /*!40101 SET character_set_client = utf8 */;
1317 CREATE TABLE `VNF_LOCK_MANAGEMENT` (
1318 `RESOURCE_ID` varchar(50) NOT NULL,
1319 `OWNER_ID` varchar(255) DEFAULT NULL,
1320 `UPDATED` bigint(20) unsigned NOT NULL,
1321 `TIMEOUT` int(10) unsigned NOT NULL,
1322 `VER` int(10) unsigned NOT NULL DEFAULT '1',
1323 PRIMARY KEY (`RESOURCE_ID`)
1324 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1325 /*!40101 SET character_set_client = @saved_cs_client */;
1328 -- Table structure for table `VNF_STATE_MANAGEMENT`
1331 DROP TABLE IF EXISTS `VNF_STATE_MANAGEMENT`;
1332 /*!40101 SET @saved_cs_client = @@character_set_client */;
1333 /*!40101 SET character_set_client = utf8 */;
1334 CREATE TABLE `VNF_STATE_MANAGEMENT` (
1335 `VNF_ID` varchar(50) NOT NULL,
1336 `STATE` varchar(50) NOT NULL,
1337 `OWNER_ID` varchar(255) DEFAULT NULL,
1338 `UPDATED` bigint(20) unsigned NOT NULL,
1339 `VER` int(10) unsigned NOT NULL DEFAULT '1',
1340 PRIMARY KEY (`VNF_ID`)
1341 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1342 /*!40101 SET character_set_client = @saved_cs_client */;