1 -- MySQL dump 10.13 Distrib 5.6.22, for Linux (x86_64)
3 -- Host: sdnctldb01 Database: sdnctl
4 -- ------------------------------------------------------
5 -- Server version 5.6.27-enterprise-commercial-advanced-log
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19 -- Table structure for table `ACCESS_LOG`
22 DROP TABLE IF EXISTS `ACCESS_LOG`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `ACCESS_LOG` (
26 `access_log_seq` int(11) NOT NULL AUTO_INCREMENT,
27 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
28 `method` varchar(12) DEFAULT NULL,
29 `version` varchar(12) DEFAULT NULL,
30 `status` varchar(12) DEFAULT NULL,
31 `url` varchar(256) DEFAULT NULL,
32 `remote_address` varchar(128) DEFAULT NULL,
33 PRIMARY KEY (`access_log_seq`)
34 ) ENGINE=InnoDB AUTO_INCREMENT=1034 DEFAULT CHARSET=latin1;
35 /*!40101 SET character_set_client = @saved_cs_client */;
38 -- Table structure for table `ADDRESS_PLAN_POLICIES`
41 DROP TABLE IF EXISTS `ADDRESS_PLAN_POLICIES`;
42 /*!40101 SET @saved_cs_client = @@character_set_client */;
43 /*!40101 SET character_set_client = utf8 */;
44 CREATE TABLE `ADDRESS_PLAN_POLICIES` (
45 `key_name` varchar(255) NOT NULL,
46 `key_value_source_type` varchar(255) NOT NULL,
47 `key_value_source` varchar(255) NOT NULL,
48 PRIMARY KEY (`key_name`)
49 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50 /*!40101 SET character_set_client = @saved_cs_client */;
53 -- Table structure for table `AGNOSTIC_NOTIFICATION_URL`
56 DROP TABLE IF EXISTS `AGNOSTIC_NOTIFICATION_URL`;
57 /*!40101 SET @saved_cs_client = @@character_set_client */;
58 /*!40101 SET character_set_client = utf8 */;
59 CREATE TABLE `AGNOSTIC_NOTIFICATION_URL` (
60 `service_type` varchar(128) NOT NULL,
61 `service_instance_id` varchar(128) NOT NULL,
62 `request_id` varchar(128) NOT NULL,
63 `svc_notification_url` varchar(256) NOT NULL,
64 PRIMARY KEY (`service_type`,`service_instance_id`,`request_id`)
65 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66 /*!40101 SET character_set_client = @saved_cs_client */;
69 -- Table structure for table `AGNOSTIC_TO_SVC_SPCFC_API`
72 DROP TABLE IF EXISTS `AGNOSTIC_TO_SVC_SPCFC_API`;
73 /*!40101 SET @saved_cs_client = @@character_set_client */;
74 /*!40101 SET character_set_client = utf8 */;
75 CREATE TABLE `AGNOSTIC_TO_SVC_SPCFC_API` (
76 `operation` varchar(128) NOT NULL,
77 `service` varchar(128) NOT NULL,
78 `service_specific_api` varchar(128) NOT NULL,
79 `async_process` varchar(15) DEFAULT NULL,
80 PRIMARY KEY (`operation`,`service`)
81 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82 /*!40101 SET character_set_client = @saved_cs_client */;
85 -- Table structure for table `AIC_AVAIL_ZONE_POOL`
88 DROP TABLE IF EXISTS `AIC_AVAIL_ZONE_POOL`;
89 /*!40101 SET @saved_cs_client = @@character_set_client */;
90 /*!40101 SET character_set_client = utf8 */;
91 CREATE TABLE `AIC_AVAIL_ZONE_POOL` (
92 `aic_site_id` varchar(100) NOT NULL,
93 `status` varchar(40) NOT NULL,
94 `availability_zone` varchar(100) NOT NULL,
95 `token` varchar(5) NOT NULL,
96 `vnf_id` varchar(80) DEFAULT NULL,
97 `service_type` varchar(100) NOT NULL,
98 `vnf_type` varchar(20) DEFAULT NULL,
99 `hypervisor` varchar(10) DEFAULT NULL,
100 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
101 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
102 /*!40101 SET character_set_client = @saved_cs_client */;
105 -- Table structure for table `AIC_HOSTNAME`
108 DROP TABLE IF EXISTS `AIC_HOSTNAME`;
109 /*!40101 SET @saved_cs_client = @@character_set_client */;
110 /*!40101 SET character_set_client = utf8 */;
111 CREATE TABLE `AIC_HOSTNAME` (
112 `hostname` varchar(20) NOT NULL,
113 `cust_id` int(11) NOT NULL,
114 `vendor_code` varchar(1) NOT NULL,
115 `virtual_device_type` varchar(2) DEFAULT NULL,
116 `device_sequence` varchar(3) NOT NULL,
117 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
118 PRIMARY KEY (`hostname`),
119 UNIQUE KEY `hostname` (`hostname`),
120 KEY `IN1_AIC_HOSTNAME` (`cust_id`),
121 CONSTRAINT `AC1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
122 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
123 /*!40101 SET character_set_client = @saved_cs_client */;
126 -- Table structure for table `AIC_NETWORK`
129 DROP TABLE IF EXISTS `AIC_NETWORK`;
130 /*!40101 SET @saved_cs_client = @@character_set_client */;
131 /*!40101 SET character_set_client = utf8 */;
132 CREATE TABLE `AIC_NETWORK` (
133 `network_id` varchar(100) NOT NULL,
134 `network_name` varchar(100) DEFAULT NULL,
135 `status` varchar(20) DEFAULT NULL,
136 `tenant_id` varchar(100) DEFAULT NULL,
137 `switch_uuid` varchar(100) DEFAULT NULL,
138 `portgroup_name` varchar(100) DEFAULT NULL,
139 `portgroup_id` varchar(100) DEFAULT NULL,
140 PRIMARY KEY (`network_id`)
141 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142 /*!40101 SET character_set_client = @saved_cs_client */;
145 -- Table structure for table `AIC_SITE`
148 DROP TABLE IF EXISTS `AIC_SITE`;
149 /*!40101 SET @saved_cs_client = @@character_set_client */;
150 /*!40101 SET character_set_client = utf8 */;
151 CREATE TABLE `AIC_SITE` (
152 `name` varchar(100) DEFAULT NULL,
153 `aic_site_id` varchar(100) NOT NULL,
154 `vcenter_url` varchar(200) DEFAULT NULL,
155 `vcenter_username` varchar(40) DEFAULT NULL,
156 `vcenter_passwd` varbinary(255) DEFAULT NULL,
157 `city` varchar(100) DEFAULT NULL,
158 `state` varchar(2) DEFAULT NULL,
159 `operational_status` varchar(20) DEFAULT NULL,
160 `oam_gateway_addr` varchar(20) DEFAULT '',
161 PRIMARY KEY (`aic_site_id`)
162 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
163 /*!40101 SET character_set_client = @saved_cs_client */;
166 -- Table structure for table `AIC_SWITCH`
169 DROP TABLE IF EXISTS `AIC_SWITCH`;
170 /*!40101 SET @saved_cs_client = @@character_set_client */;
171 /*!40101 SET character_set_client = utf8 */;
172 CREATE TABLE `AIC_SWITCH` (
173 `switch_name` varchar(100) DEFAULT NULL,
174 `physical_network_name` varchar(100) NOT NULL,
175 `aic_site_id` varchar(100) DEFAULT NULL,
176 `uuid` varchar(100) DEFAULT NULL,
177 `availability_zone` varchar(100) DEFAULT NULL,
178 PRIMARY KEY (`physical_network_name`)
179 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
180 /*!40101 SET character_set_client = @saved_cs_client */;
183 -- Table structure for table `AIC_ZONE_CLOUD_REGION_ID`
186 DROP TABLE IF EXISTS `AIC_ZONE_CLOUD_REGION_ID`;
187 /*!40101 SET @saved_cs_client = @@character_set_client */;
188 /*!40101 SET character_set_client = utf8 */;
189 CREATE TABLE `AIC_ZONE_CLOUD_REGION_ID` (
190 `zone_region_id` varchar(255) NOT NULL,
191 `cilli_code` varchar(255) NOT NULL,
192 `location_id` varchar(255) NOT NULL DEFAULT '',
193 `city_state_country` varchar(255) NOT NULL DEFAULT '',
194 PRIMARY KEY (`zone_region_id`,`cilli_code`,`location_id`,`city_state_country`)
195 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196 /*!40101 SET character_set_client = @saved_cs_client */;
199 -- Table structure for table `ALLOCATION_ITEM`
202 DROP TABLE IF EXISTS `ALLOCATION_ITEM`;
203 /*!40101 SET @saved_cs_client = @@character_set_client */;
204 /*!40101 SET character_set_client = utf8 */;
205 CREATE TABLE `ALLOCATION_ITEM` (
206 `allocation_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
207 `resource_id` bigint(20) NOT NULL,
208 `application_id` varchar(50) NOT NULL,
209 `resource_set_id` varchar(200) NOT NULL,
210 `resource_union_id` varchar(200) NOT NULL,
211 `resource_share_group_list` varchar(200) DEFAULT NULL,
212 `lt_used` bigint(20) DEFAULT NULL,
213 `ll_label` varchar(50) DEFAULT NULL,
214 `rr_used` varchar(200) DEFAULT NULL,
215 `allocation_time` datetime NOT NULL,
216 PRIMARY KEY (`allocation_item_id`),
217 UNIQUE KEY `allocation_item_id` (`allocation_item_id`),
218 UNIQUE KEY `IX2_ALLOCATION_ITEM` (`resource_id`,`resource_set_id`),
219 KEY `IX1_ALLOCATION_ITEM` (`resource_id`)
220 ) ENGINE=InnoDB AUTO_INCREMENT=5764 DEFAULT CHARSET=latin1;
221 /*!40101 SET character_set_client = @saved_cs_client */;
224 -- Table structure for table `ALLOTTED_RESOURCE_MODEL`
227 DROP TABLE IF EXISTS `ALLOTTED_RESOURCE_MODEL`;
228 /*!40101 SET @saved_cs_client = @@character_set_client */;
229 /*!40101 SET character_set_client = utf8 */;
230 CREATE TABLE `ALLOTTED_RESOURCE_MODEL` (
231 `customization_uuid` varchar(255) NOT NULL,
232 `model_yaml` longblob,
233 `invariant_uuid` varchar(255) DEFAULT NULL,
234 `uuid` varchar(255) DEFAULT NULL,
235 `version` varchar(255) DEFAULT NULL,
236 `naming_policy` varchar(255) DEFAULT NULL,
237 `ecomp_generated_naming` char(1) DEFAULT NULL,
238 `depending_service` varchar(255) DEFAULT NULL,
239 `role` varchar(255) DEFAULT NULL,
240 `type` varchar(255) DEFAULT NULL,
241 `service_dependency` varchar(255) DEFAULT NULL,
242 `allotted_resource_type` varchar(255) DEFAULT NULL,
243 PRIMARY KEY (`customization_uuid`)
244 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
245 /*!40101 SET character_set_client = @saved_cs_client */;
248 -- Table structure for table `ALTS_CREDENTIALS`
251 DROP TABLE IF EXISTS `ALTS_CREDENTIALS`;
252 /*!40101 SET @saved_cs_client = @@character_set_client */;
253 /*!40101 SET character_set_client = utf8 */;
254 CREATE TABLE `ALTS_CREDENTIALS` (
255 `alts_username` varchar(255) NOT NULL,
256 `alts_password` varbinary(255) NOT NULL,
257 PRIMARY KEY (`alts_username`)
258 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
259 /*!40101 SET character_set_client = @saved_cs_client */;
262 -- Table structure for table `ASDC_ARTIFACTS`
265 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
266 /*!40101 SET @saved_cs_client = @@character_set_client */;
267 /*!40101 SET character_set_client = utf8 */;
268 CREATE TABLE `ASDC_ARTIFACTS` (
269 `asdc_artifacts_id` int(11) NOT NULL AUTO_INCREMENT,
270 `service_uuid` varchar(50) DEFAULT NULL,
271 `distribution_id` varchar(50) DEFAULT NULL,
272 `service_name` varchar(255) DEFAULT NULL,
273 `service_description` varchar(255) DEFAULT NULL,
274 `resource_uuid` varchar(255) DEFAULT NULL,
275 `resource_instance_name` varchar(255) DEFAULT NULL,
276 `resource_name` varchar(255) DEFAULT NULL,
277 `resource_version` varchar(50) DEFAULT NULL,
278 `resource_type` varchar(50) DEFAULT NULL,
279 `artifact_uuid` varchar(50) DEFAULT NULL,
280 `artifact_type` varchar(50) DEFAULT NULL,
281 `artifact_version` varchar(25) DEFAULT NULL,
282 `artifact_description` varchar(255) DEFAULT NULL,
283 `internal_version` int(11) DEFAULT NULL,
284 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
285 `artifact_name` varchar(255) DEFAULT NULL,
286 `artifact_content` longtext,
287 PRIMARY KEY (`asdc_artifacts_id`),
288 UNIQUE KEY `asdc_artifacts_id` (`asdc_artifacts_id`)
289 ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
290 /*!40101 SET character_set_client = @saved_cs_client */;
293 -- Table structure for table `ASDC_REFERENCE`
296 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
297 /*!40101 SET @saved_cs_client = @@character_set_client */;
298 /*!40101 SET character_set_client = utf8 */;
299 CREATE TABLE `ASDC_REFERENCE` (
300 `asdc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
301 `service_type` varchar(50) DEFAULT NULL,
302 `vnf_type` varchar(50) DEFAULT NULL,
303 `vnfc_type` varchar(50) DEFAULT NULL,
304 `file_category` varchar(50) DEFAULT NULL,
305 `action` varchar(50) DEFAULT NULL,
306 `artifact_type` varchar(50) DEFAULT NULL,
307 `artifact_name` varchar(255) NOT NULL,
308 PRIMARY KEY (`asdc_reference_id`),
309 UNIQUE KEY `asdc_reference_id` (`asdc_reference_id`)
310 ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
311 /*!40101 SET character_set_client = @saved_cs_client */;
315 -- Table structure for table `BLOB_TEST`
318 DROP TABLE IF EXISTS `BLOB_TEST`;
319 /*!40101 SET @saved_cs_client = @@character_set_client */;
320 /*!40101 SET character_set_client = utf8 */;
321 CREATE TABLE `BLOB_TEST` (
322 `seq` int(11) NOT NULL AUTO_INCREMENT,
323 `odl` varchar(20) DEFAULT NULL,
324 `communities` mediumblob,
325 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
326 `retry_count` int(11) DEFAULT '-1',
328 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
329 /*!40101 SET character_set_client = @saved_cs_client */;
332 -- Table structure for table `CAPABILITY`
335 DROP TABLE IF EXISTS `CAPABILITY`;
336 /*!40101 SET @saved_cs_client = @@character_set_client */;
337 /*!40101 SET character_set_client = utf8 */;
338 CREATE TABLE `CAPABILITY` (
339 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
340 `capability_name` varchar(50) NOT NULL,
341 `implementation_name` varchar(100) NOT NULL,
342 `operation_name` varchar(50) NOT NULL,
343 `operation_description` varchar(100) NOT NULL,
344 `input_definition` longtext,
345 `output_definition` longtext,
346 `dependency_definition` longtext,
347 `tags` varchar(100) DEFAULT NULL,
348 PRIMARY KEY (`capability_id`),
349 UNIQUE KEY `capability_id` (`capability_name`)
350 ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;
351 /*!40101 SET character_set_client = @saved_cs_client */;
354 -- Table structure for table `CITY_CODE`
357 DROP TABLE IF EXISTS `CITY_CODE`;
358 /*!40101 SET @saved_cs_client = @@character_set_client */;
359 /*!40101 SET character_set_client = utf8 */;
360 CREATE TABLE `CITY_CODE` (
361 `city_code_id` int(11) NOT NULL AUTO_INCREMENT,
362 `city_code` varchar(3) NOT NULL,
363 `city` varchar(150) NOT NULL,
364 `state` varchar(10) NOT NULL,
365 `country_code` varchar(10) NOT NULL,
366 PRIMARY KEY (`city_code_id`),
367 KEY `IN1_CITY_CODE` (`city`,`state`,`country_code`)
368 ) ENGINE=InnoDB AUTO_INCREMENT=37822 DEFAULT CHARSET=latin1;
369 /*!40101 SET character_set_client = @saved_cs_client */;
372 -- Table structure for table `CLI_UPDATES`
375 DROP TABLE IF EXISTS `CLI_UPDATES`;
376 /*!40101 SET @saved_cs_client = @@character_set_client */;
377 /*!40101 SET character_set_client = utf8 */;
378 CREATE TABLE `CLI_UPDATES` (
379 `seq` int(11) NOT NULL AUTO_INCREMENT,
380 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
381 `create_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
382 `last_processed_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
383 `target_address` varchar(128) DEFAULT NULL,
384 `cli_text` varchar(128) DEFAULT NULL,
386 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
387 /*!40101 SET character_set_client = @saved_cs_client */;
390 -- Table structure for table `CONFIGFILES`
393 DROP TABLE IF EXISTS `CONFIGFILES`;
394 /*!40101 SET @saved_cs_client = @@character_set_client */;
395 /*!40101 SET character_set_client = utf8 */;
396 CREATE TABLE `CONFIGFILES` (
397 `config_file_id` int(11) NOT NULL AUTO_INCREMENT,
398 `external_version` varchar(50) DEFAULT NULL,
399 `data_source` varchar(25) DEFAULT NULL,
400 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
401 `service_instance_id` varchar(50) DEFAULT NULL,
402 `vnf_type` varchar(50) DEFAULT NULL,
403 `vnfc_type` varchar(50) DEFAULT NULL,
404 `file_category` varchar(50) DEFAULT NULL,
405 `file_name` varchar(255) DEFAULT NULL,
406 `file_content` longtext,
407 `action` varchar(50) DEFAULT NULL,
408 `vnf_id` varchar(50) DEFAULT NULL,
409 `vm_name` varchar(50) DEFAULT NULL,
410 `vnf_name` varchar(50) DEFAULT NULL,
411 PRIMARY KEY (`config_file_id`),
412 UNIQUE KEY `config_file_id` (`config_file_id`)
413 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
414 /*!40101 SET character_set_client = @saved_cs_client */;
417 -- Table structure for table `CONFIGURE_ACTION_DG`
420 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
421 /*!40101 SET @saved_cs_client = @@character_set_client */;
422 /*!40101 SET character_set_client = utf8 */;
423 CREATE TABLE `CONFIGURE_ACTION_DG` (
424 `configure_action_dg_id` int(11) NOT NULL AUTO_INCREMENT,
425 `vnf_type` varchar(50) DEFAULT NULL,
426 `action` varchar(50) DEFAULT NULL,
427 `init_config_dg` varchar(50) DEFAULT NULL,
428 `generate_config_dg` varchar(50) DEFAULT NULL,
429 `download_config_dg` varchar(50) DEFAULT NULL,
430 PRIMARY KEY (`configure_action_dg_id`),
431 UNIQUE KEY `configure_action_dg_id` (`configure_action_dg_id`)
432 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
433 /*!40101 SET character_set_client = @saved_cs_client */;
436 -- Table structure for table `CONFIG_CONTENT`
439 DROP TABLE IF EXISTS `CONFIG_CONTENT`;
440 /*!40101 SET @saved_cs_client = @@character_set_client */;
441 /*!40101 SET character_set_client = utf8 */;
442 CREATE TABLE `CONFIG_CONTENT` (
443 `config_content_id` int(11) NOT NULL AUTO_INCREMENT,
444 `request_id` varchar(50) NOT NULL,
445 `content_type` varchar(50) NOT NULL,
446 `template_name` varchar(50) DEFAULT NULL,
447 `originator_id` varchar(50) DEFAULT NULL,
448 `service_description` varchar(100) DEFAULT NULL,
449 `action` varchar(50) DEFAULT NULL,
450 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
451 `service_type` varchar(50) DEFAULT NULL,
452 `service_instance_id` varchar(50) DEFAULT NULL,
453 `vnf_id` varchar(50) DEFAULT NULL,
454 `vnf_name` varchar(50) DEFAULT NULL,
455 `vm_name` varchar(50) DEFAULT NULL,
456 `vnf_type` varchar(50) DEFAULT NULL,
457 `vnfc_type` varchar(50) DEFAULT NULL,
458 `host_ip_address` varchar(50) DEFAULT NULL,
459 `config_indicator` varchar(25) DEFAULT NULL,
460 `pending_delete` varchar(1) DEFAULT NULL,
462 PRIMARY KEY (`config_content_id`),
463 UNIQUE KEY `config_content_id` (`creation_date`)
464 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
465 /*!40101 SET character_set_client = @saved_cs_client */;
468 -- Table structure for table `CONFIG_FILE_REFERENCE`
471 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
472 /*!40101 SET @saved_cs_client = @@character_set_client */;
473 /*!40101 SET character_set_client = utf8 */;
474 CREATE TABLE `CONFIG_FILE_REFERENCE` (
475 `config_file_reference_id` int(11) NOT NULL AUTO_INCREMENT,
476 `site_location` varchar(50) DEFAULT NULL,
477 `vnf_type` varchar(50) DEFAULT NULL,
478 `import_type` varchar(50) DEFAULT NULL,
479 `file_type` varchar(50) DEFAULT NULL,
480 `source_server_name` varchar(255) DEFAULT NULL,
481 `source_file_path` varchar(255) DEFAULT NULL,
482 `target_file_path` varchar(255) DEFAULT NULL,
483 `name` varchar(50) DEFAULT NULL,
484 `file_name` varchar(255) DEFAULT NULL,
485 PRIMARY KEY (`config_file_reference_id`),
486 UNIQUE KEY `config_file_reference_id` (`config_file_reference_id`)
487 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
488 /*!40101 SET character_set_client = @saved_cs_client */;
491 -- Table structure for table `CONFIG_TRANSACTION_LOG`
494 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
495 /*!40101 SET @saved_cs_client = @@character_set_client */;
496 /*!40101 SET character_set_client = utf8 */;
497 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
498 `config_transaction_log_id` int(11) NOT NULL AUTO_INCREMENT,
499 `request_id` varchar(50) DEFAULT NULL,
500 `message_type` varchar(50) DEFAULT NULL,
501 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
503 PRIMARY KEY (`config_transaction_log_id`),
504 UNIQUE KEY `config_transaction_log_id` (`config_transaction_log_id`)
505 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
506 /*!40101 SET character_set_client = @saved_cs_client */;
509 -- Table structure for table `COUNTRY_ASN_MAPPING`
512 DROP TABLE IF EXISTS `COUNTRY_ASN_MAPPING`;
513 /*!40101 SET @saved_cs_client = @@character_set_client */;
514 /*!40101 SET character_set_client = utf8 */;
515 CREATE TABLE `COUNTRY_ASN_MAPPING` (
516 `asn` int(5) NOT NULL,
517 `iso_2char` varchar(5) NOT NULL,
518 `iso_3char` varchar(5) NOT NULL
519 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
520 /*!40101 SET character_set_client = @saved_cs_client */;
523 -- Table structure for table `CUSTOMER`
526 DROP TABLE IF EXISTS `CUSTOMER`;
527 /*!40101 SET @saved_cs_client = @@character_set_client */;
528 /*!40101 SET character_set_client = utf8 */;
529 CREATE TABLE `CUSTOMER` (
530 `cust_id` int(11) NOT NULL AUTO_INCREMENT,
531 `customer_name` varchar(256) DEFAULT NULL,
532 `grua` varchar(4) NOT NULL,
533 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
534 PRIMARY KEY (`cust_id`),
535 UNIQUE KEY `IU1_CUSTOMER` (`customer_name`)
536 ) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=latin1;
537 /*!40101 SET character_set_client = @saved_cs_client */;
540 -- Table structure for table `CUSTOMER2CONNECTION_MAPPING`
543 DROP TABLE IF EXISTS `CUSTOMER2CONNECTION_MAPPING`;
544 /*!40101 SET @saved_cs_client = @@character_set_client */;
545 /*!40101 SET character_set_client = utf8 */;
546 CREATE TABLE `CUSTOMER2CONNECTION_MAPPING` (
547 `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT,
548 `service_instance_id` varchar(80) NOT NULL,
549 `instance_type` varchar(20) NOT NULL,
550 `originating_service_instance_id` varchar(80) DEFAULT NULL,
551 `originating_service_type` varchar(20) DEFAULT NULL,
552 `service_type` varchar(30) DEFAULT NULL,
553 `connection_id` varchar(100) NOT NULL,
554 `status` varchar(20) DEFAULT NULL,
555 PRIMARY KEY (`customer2connection_id`)
556 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
557 /*!40101 SET character_set_client = @saved_cs_client */;
560 -- Table structure for table `CUSTOMER2CONNECTION_MAPPING_NEW`
563 DROP TABLE IF EXISTS `CUSTOMER2CONNECTION_MAPPING_NEW`;
564 /*!40101 SET @saved_cs_client = @@character_set_client */;
565 /*!40101 SET character_set_client = utf8 */;
566 CREATE TABLE `CUSTOMER2CONNECTION_MAPPING_NEW` (
567 `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT,
568 `service_instance_id` varchar(80) NOT NULL,
569 `instance_type` varchar(20) NOT NULL,
570 `originating_service_instance_id` varchar(80) DEFAULT NULL,
571 `originating_service_type` varchar(20) DEFAULT NULL,
572 `service_type` varchar(30) DEFAULT NULL,
573 `connection_id` varchar(100) NOT NULL,
574 `status` varchar(100) DEFAULT NULL,
575 PRIMARY KEY (`customer2connection_id`)
576 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
577 /*!40101 SET character_set_client = @saved_cs_client */;
580 -- Table structure for table `DATA_OBJECT_MAPPING`
583 DROP TABLE IF EXISTS `DATA_OBJECT_MAPPING`;
584 /*!40101 SET @saved_cs_client = @@character_set_client */;
585 /*!40101 SET character_set_client = utf8 */;
586 CREATE TABLE `DATA_OBJECT_MAPPING` (
587 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
588 `data_object_key` varchar(100) NOT NULL,
589 `data_object_type` varchar(50) NOT NULL,
590 `service_type` varchar(50) NOT NULL,
591 `data_object_key2` varchar(100) NOT NULL,
592 `data_object_key2_type` varchar(50) NOT NULL,
593 `data_object_key3` varchar(100) DEFAULT NULL,
594 `data_object_key3_type` varchar(50) DEFAULT NULL,
595 `service` varchar(50) DEFAULT NULL,
596 PRIMARY KEY (`serial_key`),
597 KEY `IX1_DATA_OBJECT_MAPPING` (`data_object_key`,`data_object_type`,`service_type`),
598 KEY `IX2_DATA_OBJECT_MAPPING` (`service_type`,`data_object_key2`,`data_object_key2_type`)
599 ) ENGINE=InnoDB AUTO_INCREMENT=3211 DEFAULT CHARSET=latin1;
600 /*!40101 SET character_set_client = @saved_cs_client */;
603 -- Table structure for table `DEVICE2CONNECTION_MAPPING`
606 DROP TABLE IF EXISTS `DEVICE2CONNECTION_MAPPING`;
607 /*!40101 SET @saved_cs_client = @@character_set_client */;
608 /*!40101 SET character_set_client = utf8 */;
609 CREATE TABLE `DEVICE2CONNECTION_MAPPING` (
610 `vnf_host_name` varchar(100) NOT NULL,
611 `e2e_vpn_key` varchar(30) NOT NULL,
612 `service_type` varchar(30) NOT NULL,
613 `connection_id` varchar(100) NOT NULL,
614 PRIMARY KEY (`vnf_host_name`,`e2e_vpn_key`,`service_type`)
615 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
616 /*!40101 SET character_set_client = @saved_cs_client */;
619 -- Table structure for table `DEVICE2IPADDRESS_CONSUMPTION`
622 DROP TABLE IF EXISTS `DEVICE2IPADDRESS_CONSUMPTION`;
623 /*!40101 SET @saved_cs_client = @@character_set_client */;
624 /*!40101 SET character_set_client = utf8 */;
625 CREATE TABLE `DEVICE2IPADDRESS_CONSUMPTION` (
626 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
627 `device_id` varchar(100) NOT NULL,
628 `device_type` varchar(30) NOT NULL,
629 `ip_version` varchar(10) NOT NULL,
630 `consumption_key` varchar(100) NOT NULL,
631 `logical_interface_service_id` varchar(100) NOT NULL,
632 `address_type` varchar(30) NOT NULL,
633 `ip_consumed` varchar(50) NOT NULL,
634 `vnf_type` varchar(30) NOT NULL,
635 `secondary_key` varchar(100) DEFAULT NULL,
636 PRIMARY KEY (`serial_key`),
637 KEY `IX1_DEVICEIPADDRESS_CONSUMPTION` (`device_id`,`device_type`,`ip_version`)
638 ) ENGINE=InnoDB AUTO_INCREMENT=1357 DEFAULT CHARSET=latin1;
639 /*!40101 SET character_set_client = @saved_cs_client */;
642 -- Table structure for table `DEVICE2IPADDRESS_MAPPING`
645 DROP TABLE IF EXISTS `DEVICE2IPADDRESS_MAPPING`;
646 /*!40101 SET @saved_cs_client = @@character_set_client */;
647 /*!40101 SET character_set_client = utf8 */;
648 CREATE TABLE `DEVICE2IPADDRESS_MAPPING` (
649 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
650 `device_id` varchar(100) NOT NULL,
651 `device_type` varchar(30) NOT NULL,
652 `secondary_key` varchar(100) NOT NULL,
653 `secondary_key_type` varchar(30) NOT NULL,
654 `address` varchar(50) NOT NULL,
655 `address_type` varchar(30) NOT NULL,
656 `ip_version` varchar(10) NOT NULL,
657 `length` int(11) NOT NULL,
658 `status` varchar(30) NOT NULL,
659 PRIMARY KEY (`serial_key`),
660 KEY `IX1_DEVICE2IPADDRESS_MAPPING` (`device_id`,`device_type`,`secondary_key`,`secondary_key_type`,`address`,`address_type`)
661 ) ENGINE=InnoDB AUTO_INCREMENT=4734 DEFAULT CHARSET=latin1;
662 /*!40101 SET character_set_client = @saved_cs_client */;
665 -- Table structure for table `DEVICE_AUTHENTICATION`
668 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
669 /*!40101 SET @saved_cs_client = @@character_set_client */;
670 /*!40101 SET character_set_client = utf8 */;
671 CREATE TABLE `DEVICE_AUTHENTICATION` (
672 `device_authentication_id` int(11) NOT NULL AUTO_INCREMENT,
673 `vnf_type` varchar(50) DEFAULT NULL,
674 `user_name` varchar(50) DEFAULT NULL,
675 `password` varchar(100) DEFAULT NULL,
676 `protocol` varchar(100) DEFAULT NULL,
677 `port_number` int(11) DEFAULT NULL,
678 PRIMARY KEY (`device_authentication_id`),
679 UNIQUE KEY `device_authentication_id` (`device_authentication_id`)
680 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
681 /*!40101 SET character_set_client = @saved_cs_client */;
684 -- Table structure for table `DEVICE_INTERFACE_LOG`
687 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
688 /*!40101 SET @saved_cs_client = @@character_set_client */;
689 /*!40101 SET character_set_client = utf8 */;
690 CREATE TABLE `DEVICE_INTERFACE_LOG` (
691 `device_interface_log_id` int(11) NOT NULL AUTO_INCREMENT,
692 `service_instance_id` varchar(50) DEFAULT NULL,
693 `request_id` varchar(50) DEFAULT NULL,
694 `creation_date` datetime NOT NULL,
696 PRIMARY KEY (`device_interface_log_id`),
697 UNIQUE KEY `device_interface_log_id` (`device_interface_log_id`)
698 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
699 /*!40101 SET character_set_client = @saved_cs_client */;
702 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
705 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
706 /*!40101 SET @saved_cs_client = @@character_set_client */;
707 /*!40101 SET character_set_client = utf8 */;
708 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
709 `device_interface_protocol_id` int(11) NOT NULL AUTO_INCREMENT,
710 `vnf_type` varchar(50) DEFAULT NULL,
711 `protocol` varchar(50) DEFAULT NULL,
712 `module` varchar(50) DEFAULT NULL,
713 `dg_rpc` varchar(50) DEFAULT NULL,
714 PRIMARY KEY (`device_interface_protocol_id`),
715 UNIQUE KEY `device_interface_protocol_id` (`device_interface_protocol_id`),
716 UNIQUE KEY `vnf_type` (`vnf_type`)
717 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
718 /*!40101 SET character_set_client = @saved_cs_client */;
721 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
724 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
725 /*!40101 SET @saved_cs_client = @@character_set_client */;
726 /*!40101 SET character_set_client = utf8 */;
727 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
728 `download_config_template_id` int(11) NOT NULL AUTO_INCREMENT,
729 `vnf_type` varchar(50) NOT NULL,
730 `protocol` varchar(50) NOT NULL,
732 PRIMARY KEY (`download_config_template_id`),
733 UNIQUE KEY `download_config_template_id` (`download_config_template_id`)
734 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
735 /*!40101 SET character_set_client = @saved_cs_client */;
738 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
741 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
742 /*!40101 SET @saved_cs_client = @@character_set_client */;
743 /*!40101 SET character_set_client = utf8 */;
744 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
745 `download_dg_reference_id` int(11) NOT NULL AUTO_INCREMENT,
746 `protocol` varchar(50) NOT NULL,
747 `download_config_dg` varchar(50) NOT NULL,
748 PRIMARY KEY (`download_dg_reference_id`),
749 UNIQUE KEY `download_dg_reference_id` (`download_dg_reference_id`)
750 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
751 /*!40101 SET character_set_client = @saved_cs_client */;
754 -- Table structure for table `EIPAM_CLIENT_KEY_INDEX`
757 DROP TABLE IF EXISTS `EIPAM_CLIENT_KEY_INDEX`;
758 /*!40101 SET @saved_cs_client = @@character_set_client */;
759 /*!40101 SET character_set_client = utf8 */;
760 CREATE TABLE `EIPAM_CLIENT_KEY_INDEX` (
761 `vnf_name_prefix` varchar(100) NOT NULL,
762 `index_number` int(11) NOT NULL,
763 PRIMARY KEY (`vnf_name_prefix`)
764 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
765 /*!40101 SET character_set_client = @saved_cs_client */;
768 -- Table structure for table `EIPAM_IP_ASSIGNMENTS`
771 DROP TABLE IF EXISTS `EIPAM_IP_ASSIGNMENTS`;
772 /*!40101 SET @saved_cs_client = @@character_set_client */;
773 /*!40101 SET character_set_client = utf8 */;
774 CREATE TABLE `EIPAM_IP_ASSIGNMENTS` (
775 `plan_name` varchar(40) NOT NULL,
776 `client_key` varchar(100) NOT NULL,
777 `service_type` varchar(40) NOT NULL,
778 `ip_address` varchar(40) DEFAULT NULL,
779 `prefix_length` int(2) DEFAULT NULL,
780 `status` varchar(255) DEFAULT NULL,
781 `service_instance_id` varchar(80) DEFAULT NULL,
782 `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
783 `prev_status` varchar(20) DEFAULT NULL,
784 `info` varchar(255) DEFAULT NULL,
785 PRIMARY KEY (`plan_name`,`client_key`)
786 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
787 /*!40101 SET character_set_client = @saved_cs_client */;
790 -- Table structure for table `EIPAM_IP_POOLS`
793 DROP TABLE IF EXISTS `EIPAM_IP_POOLS`;
794 /*!40101 SET @saved_cs_client = @@character_set_client */;
795 /*!40101 SET character_set_client = utf8 */;
796 CREATE TABLE `EIPAM_IP_POOLS` (
797 `pool_id` int(11) NOT NULL AUTO_INCREMENT,
798 `key_name` varchar(50) NOT NULL,
799 `key_value` varchar(255) NOT NULL,
800 `level` int(2) NOT NULL,
801 `plan_name` varchar(50) NOT NULL,
802 `address_family` varchar(10) NOT NULL,
803 `parent_pool` varchar(255) NOT NULL,
804 `service_instance_id` varchar(255) DEFAULT NULL,
805 `network_id` varchar(255) DEFAULT NULL,
806 `created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
807 `delete_failure` varchar(20) DEFAULT NULL,
808 `delete_request_id` varchar(255) DEFAULT NULL,
809 PRIMARY KEY (`pool_id`)
810 ) ENGINE=InnoDB AUTO_INCREMENT=339 DEFAULT CHARSET=latin1 COMMENT='This table will capture the pools being created by SDN-C in EIPAM_IP_POOLS. There is no data migration for existing vPE pool data.';
811 /*!40101 SET character_set_client = @saved_cs_client */;
814 -- Table structure for table `EIPAM_IP_SUBNETS`
817 DROP TABLE IF EXISTS `EIPAM_IP_SUBNETS`;
818 /*!40101 SET @saved_cs_client = @@character_set_client */;
819 /*!40101 SET character_set_client = utf8 */;
820 CREATE TABLE `EIPAM_IP_SUBNETS` (
821 `entity_id` int(6) NOT NULL,
822 `service_type` varchar(40) NOT NULL,
823 `plan_name` varchar(50) NOT NULL,
824 `address_family` varchar(10) NOT NULL,
825 `ip_address` varchar(40) NOT NULL,
826 `prefix_length` int(3) NOT NULL,
827 `status` varchar(20) NOT NULL,
828 `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
829 `network_id` varchar(255) DEFAULT NULL,
830 `pool_id` int(11) DEFAULT NULL,
831 `dealloc_failure` varchar(20) DEFAULT NULL,
832 `dealloc_request_id` varchar(255) DEFAULT NULL,
833 PRIMARY KEY (`entity_id`),
834 KEY `FK_EIPAM_IP_SUBNETS_EIPAM_IP_POOLS` (`pool_id`),
835 CONSTRAINT `EIPAM_IP_SUBNETS_ibfk_1` FOREIGN KEY (`pool_id`) REFERENCES `EIPAM_IP_POOLS` (`pool_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
836 CONSTRAINT `FK_EIPAM_IP_SUBNETS_EIPAM_IP_POOLS` FOREIGN KEY (`pool_id`) REFERENCES `EIPAM_IP_POOLS` (`pool_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
837 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
838 /*!40101 SET character_set_client = @saved_cs_client */;
841 -- Table structure for table `EIPAM_IP_SUBNET_KEYS`
844 DROP TABLE IF EXISTS `EIPAM_IP_SUBNET_KEYS`;
845 /*!40101 SET @saved_cs_client = @@character_set_client */;
846 /*!40101 SET character_set_client = utf8 */;
847 CREATE TABLE `EIPAM_IP_SUBNET_KEYS` (
848 `entity_id` int(6) NOT NULL,
849 `key_name` varchar(50) NOT NULL,
850 `key_value` varchar(255) NOT NULL,
851 `level` int(2) NOT NULL,
852 PRIMARY KEY (`entity_id`,`key_name`,`key_value`,`level`)
853 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
854 /*!40101 SET character_set_client = @saved_cs_client */;
857 -- Table structure for table `EIPAM_REQUEST_KEY`
860 DROP TABLE IF EXISTS `EIPAM_REQUEST_KEY`;
861 /*!40101 SET @saved_cs_client = @@character_set_client */;
862 /*!40101 SET character_set_client = utf8 */;
863 CREATE TABLE `EIPAM_REQUEST_KEY` (
864 `key_name_1` varchar(50) NOT NULL,
865 `address_family` varchar(4) NOT NULL,
866 `serial_key` int(2) NOT NULL AUTO_INCREMENT,
867 `plan_name` varchar(50) NOT NULL,
868 `request_length` int(2) NOT NULL,
869 `pools_length` int(2) NOT NULL,
870 `plan_length` int(2) NOT NULL,
871 `key_name_0` varchar(50) NOT NULL,
872 `key_name_type_0` varchar(255) NOT NULL,
873 `key_name_type_1` varchar(255) NOT NULL,
874 `prefix_length` int(2) NOT NULL,
875 `group_flag` char(1) NOT NULL,
876 `address_type` varchar(20) DEFAULT NULL,
877 PRIMARY KEY (`key_name_1`,`address_family`),
878 UNIQUE KEY `IX1_EIPAM_REQUEST_KEY` (`serial_key`)
879 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
880 /*!40101 SET character_set_client = @saved_cs_client */;
883 -- Table structure for table `EXTERNAL_DATA`
886 DROP TABLE IF EXISTS `EXTERNAL_DATA`;
887 /*!40101 SET @saved_cs_client = @@character_set_client */;
888 /*!40101 SET character_set_client = utf8 */;
889 CREATE TABLE `EXTERNAL_DATA` (
890 `external_data_id` int(11) NOT NULL AUTO_INCREMENT,
891 `request_id` int(11) DEFAULT NULL,
892 `param_name` varchar(30) NOT NULL,
893 `param_value` varchar(50) NOT NULL,
894 PRIMARY KEY (`external_data_id`)
895 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
896 /*!40101 SET character_set_client = @saved_cs_client */;
899 -- Table structure for table `FLOW_UPDATES`
902 DROP TABLE IF EXISTS `FLOW_UPDATES`;
903 /*!40101 SET @saved_cs_client = @@character_set_client */;
904 /*!40101 SET character_set_client = utf8 */;
905 CREATE TABLE `FLOW_UPDATES` (
906 `seq` int(11) NOT NULL AUTO_INCREMENT,
907 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
908 `create_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
909 `last_processed_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
910 `odl` varchar(128) DEFAULT NULL,
911 `address_family` enum('IPV4','IPV6') DEFAULT NULL,
912 `destination_prefix` varchar(50) DEFAULT NULL,
913 `communities` varchar(6000) DEFAULT NULL,
914 `route_key` varchar(50) DEFAULT NULL,
916 ) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=latin1;
917 /*!40101 SET character_set_client = @saved_cs_client */;
920 -- Table structure for table `GENERIC_L3_NETWORK`
923 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK`;
924 /*!40101 SET @saved_cs_client = @@character_set_client */;
925 /*!40101 SET character_set_client = utf8 */;
926 CREATE TABLE `GENERIC_L3_NETWORK` (
927 `network_id` varchar(80) NOT NULL,
928 `network_name` varchar(80) DEFAULT NULL,
929 `network_type` varchar(80) DEFAULT NULL,
930 `network_role` varchar(80) DEFAULT NULL,
931 `network_technology` varchar(80) DEFAULT NULL,
932 `neutron_network_id` varchar(80) DEFAULT NULL,
933 `is_bound_to_vpn` tinyint(1) DEFAULT NULL,
934 `orchestration_status` varchar(20) DEFAULT NULL,
935 `heat_stack_id` varchar(80) DEFAULT NULL,
936 `mso_catalog_key` varchar(80) DEFAULT NULL,
937 `service_id` varchar(80) NOT NULL,
938 `tenant_id` varchar(80) NOT NULL,
939 `physical_location_id` varchar(20) DEFAULT NULL,
940 `network_role_instance` varchar(80) NOT NULL,
941 PRIMARY KEY (`network_id`)
942 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
943 /*!40101 SET character_set_client = @saved_cs_client */;
946 -- Table structure for table `GENERIC_L3_NETWORK_SUBNET`
949 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK_SUBNET`;
950 /*!40101 SET @saved_cs_client = @@character_set_client */;
951 /*!40101 SET character_set_client = utf8 */;
952 CREATE TABLE `GENERIC_L3_NETWORK_SUBNET` (
953 `network_id` varchar(80) NOT NULL,
954 `subnet_id` varchar(80) NOT NULL,
955 `neutron_subnet_id` varchar(80) DEFAULT NULL,
956 `gateway_address` varchar(45) NOT NULL,
957 `network_start_address` varchar(45) NOT NULL,
958 `cidr_mask` varchar(20) NOT NULL,
959 `ip_version` char(1) NOT NULL,
960 `orchestration_status` varchar(64) NOT NULL,
961 `dhcp_enabled` tinyint(1) NOT NULL,
962 `dhcp_start` varchar(45) DEFAULT NULL,
963 `dhcp_end` varchar(45) DEFAULT NULL,
964 PRIMARY KEY (`network_id`,`subnet_id`)
965 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
966 /*!40101 SET character_set_client = @saved_cs_client */;
969 -- Table structure for table `GENERIC_L3_NETWORK_VPN_BINDING`
972 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK_VPN_BINDING`;
973 /*!40101 SET @saved_cs_client = @@character_set_client */;
974 /*!40101 SET character_set_client = utf8 */;
975 CREATE TABLE `GENERIC_L3_NETWORK_VPN_BINDING` (
976 `network_id` varchar(80) NOT NULL,
977 `vpn_id` varchar(80) NOT NULL,
978 PRIMARY KEY (`network_id`,`vpn_id`)
979 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
980 /*!40101 SET character_set_client = @saved_cs_client */;
983 -- Table structure for table `GENERIC_RESOURCE_NAME`
986 DROP TABLE IF EXISTS `GENERIC_RESOURCE_NAME`;
987 /*!40101 SET @saved_cs_client = @@character_set_client */;
988 /*!40101 SET character_set_client = utf8 */;
989 CREATE TABLE `GENERIC_RESOURCE_NAME` (
990 `type` varchar(50) NOT NULL,
991 `name` varchar(255) NOT NULL,
992 PRIMARY KEY (`type`,`name`)
993 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
994 /*!40101 SET character_set_client = @saved_cs_client */;
997 -- Table structure for table `GENERIC_VNF`
1000 DROP TABLE IF EXISTS `GENERIC_VNF`;
1001 /*!40101 SET @saved_cs_client = @@character_set_client */;
1002 /*!40101 SET character_set_client = utf8 */;
1003 CREATE TABLE `GENERIC_VNF` (
1004 `vnf_id` varchar(80) NOT NULL,
1005 `vnf_name` varchar(80) NOT NULL,
1006 `vnf_type` varchar(200) NOT NULL,
1007 `vnf_name2` varchar(80) DEFAULT NULL,
1008 `service_id` varchar(80) NOT NULL,
1009 `equipment_role` varchar(80) NOT NULL,
1010 `orchestration_status` varchar(20) DEFAULT NULL,
1011 `prov_status` varchar(20) DEFAULT NULL,
1012 `heat_stack_id` varchar(80) DEFAULT NULL,
1013 `mso_catalog_key` varchar(80) DEFAULT NULL,
1014 `regional_resource_zone` varchar(80) DEFAULT NULL,
1015 `operational_state` varchar(80) DEFAULT NULL,
1016 `license_key` varchar(80) DEFAULT NULL,
1017 `ipv4_oam_address` varchar(20) DEFAULT NULL,
1018 `ipv4_loopback0_address` varchar(20) DEFAULT NULL,
1019 `nm_lan_v6_address` varchar(40) DEFAULT NULL,
1020 `management_v6_address` varchar(40) DEFAULT NULL,
1021 `management_option` varchar(45) DEFAULT NULL,
1022 `vcpu` varchar(45) DEFAULT NULL,
1023 `vmemory` varchar(45) DEFAULT NULL,
1024 `vdisk` varchar(45) DEFAULT NULL,
1025 `vcpu_units` varchar(45) DEFAULT NULL,
1026 `vmemory_units` varchar(45) DEFAULT NULL,
1027 `vdisk_units` varchar(45) DEFAULT NULL,
1028 PRIMARY KEY (`vnf_id`)
1029 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1030 /*!40101 SET character_set_client = @saved_cs_client */;
1033 -- Table structure for table `GENERIC_VNF_L3_NETWORK`
1036 DROP TABLE IF EXISTS `GENERIC_VNF_L3_NETWORK`;
1037 /*!40101 SET @saved_cs_client = @@character_set_client */;
1038 /*!40101 SET character_set_client = utf8 */;
1039 CREATE TABLE `GENERIC_VNF_L3_NETWORK` (
1040 `vnf_id` varchar(80) NOT NULL,
1041 `network_id` varchar(80) NOT NULL,
1042 PRIMARY KEY (`vnf_id`,`network_id`)
1043 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1044 /*!40101 SET character_set_client = @saved_cs_client */;
1047 -- Table structure for table `GENERIC_VNF_LICENSE_MANAGEMENT`
1050 DROP TABLE IF EXISTS `GENERIC_VNF_LICENSE_MANAGEMENT`;
1051 /*!40101 SET @saved_cs_client = @@character_set_client */;
1052 /*!40101 SET character_set_client = utf8 */;
1053 CREATE TABLE `GENERIC_VNF_LICENSE_MANAGEMENT` (
1054 `vnf_id` varchar(80) NOT NULL,
1055 `att_uuid` varchar(80) NOT NULL,
1056 PRIMARY KEY (`vnf_id`,`att_uuid`)
1057 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1058 /*!40101 SET character_set_client = @saved_cs_client */;
1061 -- Table structure for table `GENERIC_VNF_LINTERFACE`
1064 DROP TABLE IF EXISTS `GENERIC_VNF_LINTERFACE`;
1065 /*!40101 SET @saved_cs_client = @@character_set_client */;
1066 /*!40101 SET character_set_client = utf8 */;
1067 CREATE TABLE `GENERIC_VNF_LINTERFACE` (
1068 `vnf_id` varchar(80) NOT NULL,
1069 `interface_name` varchar(255) NOT NULL,
1070 `interface_role` varchar(45) DEFAULT NULL,
1071 `v6_wan_link_ip` varchar(45) DEFAULT NULL,
1072 `selflink` varchar(128) DEFAULT NULL,
1073 `interface_id` varchar(45) DEFAULT NULL,
1074 `macaddr` varchar(64) DEFAULT NULL,
1075 `network_name` varchar(255) DEFAULT NULL,
1076 PRIMARY KEY (`vnf_id`,`interface_name`),
1077 KEY `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF_IDX` (`vnf_id`),
1078 CONSTRAINT `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF` FOREIGN KEY (`vnf_id`) REFERENCES `GENERIC_VNF` (`vnf_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
1079 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1080 /*!40101 SET character_set_client = @saved_cs_client */;
1083 -- Table structure for table `GENERIC_VNF_PSERVER`
1086 DROP TABLE IF EXISTS `GENERIC_VNF_PSERVER`;
1087 /*!40101 SET @saved_cs_client = @@character_set_client */;
1088 /*!40101 SET character_set_client = utf8 */;
1089 CREATE TABLE `GENERIC_VNF_PSERVER` (
1090 `vnf_id` varchar(64) NOT NULL,
1091 `hostname` varchar(255) NOT NULL,
1092 PRIMARY KEY (`vnf_id`,`hostname`)
1093 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1094 /*!40101 SET character_set_client = @saved_cs_client */;
1097 -- Table structure for table `GENERIC_VNF_SERVICE_INSTANCE`
1100 DROP TABLE IF EXISTS `GENERIC_VNF_SERVICE_INSTANCE`;
1101 /*!40101 SET @saved_cs_client = @@character_set_client */;
1102 /*!40101 SET character_set_client = utf8 */;
1103 CREATE TABLE `GENERIC_VNF_SERVICE_INSTANCE` (
1104 `vnf_id` varchar(64) NOT NULL,
1105 `service_instance_id` varchar(255) NOT NULL,
1106 `relationship_key` varchar(64) NOT NULL,
1107 `relationship_value` varchar(64) DEFAULT NULL,
1108 `global_customer_id` varchar(255) DEFAULT NULL,
1109 `service_type` varchar(255) DEFAULT NULL,
1110 PRIMARY KEY (`vnf_id`,`service_instance_id`,`relationship_key`)
1111 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1112 /*!40101 SET character_set_client = @saved_cs_client */;
1115 -- Table structure for table `GENERIC_VNF_VNF_IMAGE`
1118 DROP TABLE IF EXISTS `GENERIC_VNF_VNF_IMAGE`;
1119 /*!40101 SET @saved_cs_client = @@character_set_client */;
1120 /*!40101 SET character_set_client = utf8 */;
1121 CREATE TABLE `GENERIC_VNF_VNF_IMAGE` (
1122 `vnf_id` varchar(64) NOT NULL,
1123 `att_uuid` varchar(255) NOT NULL,
1124 PRIMARY KEY (`vnf_id`,`att_uuid`)
1125 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1126 /*!40101 SET character_set_client = @saved_cs_client */;
1129 -- Table structure for table `GENERIC_VNF_VSERVER`
1132 DROP TABLE IF EXISTS `GENERIC_VNF_VSERVER`;
1133 /*!40101 SET @saved_cs_client = @@character_set_client */;
1134 /*!40101 SET character_set_client = utf8 */;
1135 CREATE TABLE `GENERIC_VNF_VSERVER` (
1136 `vnf_id` varchar(80) NOT NULL,
1137 `vserver_id` varchar(128) NOT NULL,
1138 `tenant_id` varchar(128) DEFAULT NULL,
1139 PRIMARY KEY (`vnf_id`,`vserver_id`)
1140 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1141 /*!40101 SET character_set_client = @saved_cs_client */;
1144 -- Table structure for table `GENERIC_VPN_BINDING`
1147 DROP TABLE IF EXISTS `GENERIC_VPN_BINDING`;
1148 /*!40101 SET @saved_cs_client = @@character_set_client */;
1149 /*!40101 SET character_set_client = utf8 */;
1150 CREATE TABLE `GENERIC_VPN_BINDING` (
1151 `vpn_id` varchar(80) NOT NULL,
1152 `vpn_name` varchar(80) NOT NULL,
1153 `global_route_target` varchar(80) NOT NULL,
1154 PRIMARY KEY (`vpn_id`)
1155 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1156 /*!40101 SET character_set_client = @saved_cs_client */;
1159 -- Table structure for table `GET_CONFIG_TEMPLATE`
1162 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
1163 /*!40101 SET @saved_cs_client = @@character_set_client */;
1164 /*!40101 SET character_set_client = utf8 */;
1165 CREATE TABLE `GET_CONFIG_TEMPLATE` (
1166 `get_config_template_id` int(11) NOT NULL AUTO_INCREMENT,
1167 `vnf_type` varchar(50) NOT NULL,
1168 `device_interface_protocol_id` int(11) NOT NULL,
1169 `xml_processing` varchar(1) DEFAULT NULL,
1170 `xml_protocol` varchar(30) DEFAULT NULL,
1171 `template` longtext,
1172 PRIMARY KEY (`get_config_template_id`),
1173 UNIQUE KEY `get_config_template_id` (`get_config_template_id`),
1174 KEY `get_config_template_ibfk_1` (`device_interface_protocol_id`),
1175 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
1176 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1177 /*!40101 SET character_set_client = @saved_cs_client */;
1180 -- Table structure for table `HOSTNAME`
1183 DROP TABLE IF EXISTS `HOSTNAME`;
1184 /*!40101 SET @saved_cs_client = @@character_set_client */;
1185 /*!40101 SET character_set_client = utf8 */;
1186 CREATE TABLE `HOSTNAME` (
1187 `hostname` varchar(21) NOT NULL,
1188 `parent_hostname` varchar(21) DEFAULT NULL,
1189 `cust_id` int(11) NOT NULL,
1190 `loc_id` int(11) NOT NULL,
1191 `site_sequence` varchar(2) NOT NULL,
1192 `server_sequence` varchar(2) NOT NULL,
1193 `activation_code` varchar(11) DEFAULT NULL,
1194 `vnf_sequence` varchar(2) DEFAULT NULL,
1195 `vendor_code` varchar(1) NOT NULL,
1196 `virtual_device_type` varchar(2) DEFAULT NULL,
1197 `device_sequence` varchar(3) DEFAULT NULL,
1198 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1199 PRIMARY KEY (`hostname`),
1200 KEY `IN1_HOSTNAME` (`cust_id`),
1201 KEY `IN2_HOSTNAME` (`loc_id`),
1202 KEY `IN3_HOSTNAME` (`vendor_code`),
1203 KEY `IN4_HOSTNAME` (`parent_hostname`),
1204 CONSTRAINT `FK1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1205 CONSTRAINT `FK2_HOSTNAME` FOREIGN KEY (`loc_id`) REFERENCES `LOCATION` (`loc_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1206 CONSTRAINT `FK4_HOSTNAME` FOREIGN KEY (`parent_hostname`) REFERENCES `HOSTNAME` (`hostname`) ON DELETE NO ACTION ON UPDATE NO ACTION
1207 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1208 /*!40101 SET character_set_client = @saved_cs_client */;
1211 -- Table structure for table `IPV4_ADDRESS_POOL`
1214 DROP TABLE IF EXISTS `IPV4_ADDRESS_POOL`;
1215 /*!40101 SET @saved_cs_client = @@character_set_client */;
1216 /*!40101 SET character_set_client = utf8 */;
1217 CREATE TABLE `IPV4_ADDRESS_POOL` (
1218 `aic_site_id` varchar(100) NOT NULL,
1219 `universe` varchar(40) NOT NULL,
1220 `status` varchar(40) NOT NULL,
1221 `ipv4_addr` varchar(20) NOT NULL,
1222 PRIMARY KEY (`ipv4_addr`,`universe`)
1223 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1224 /*!40101 SET character_set_client = @saved_cs_client */;
1227 -- Table structure for table `LINK_MASTER`
1230 DROP TABLE IF EXISTS `LINK_MASTER`;
1231 /*!40101 SET @saved_cs_client = @@character_set_client */;
1232 /*!40101 SET character_set_client = utf8 */;
1233 CREATE TABLE `LINK_MASTER` (
1234 `link_interface_ip` varchar(20) NOT NULL,
1235 `source_crs_name` varchar(20) NOT NULL,
1236 `destination_crs_name` varchar(20) NOT NULL,
1237 `max_reserved_bw` int(11) DEFAULT NULL,
1238 `default_cost` int(11) DEFAULT NULL,
1239 `bundle_name` varchar(20) DEFAULT NULL,
1240 PRIMARY KEY (`link_interface_ip`)
1241 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1242 /*!40101 SET character_set_client = @saved_cs_client */;
1245 -- Table structure for table `LINTERFACE_VLAN`
1248 DROP TABLE IF EXISTS `LINTERFACE_VLAN`;
1249 /*!40101 SET @saved_cs_client = @@character_set_client */;
1250 /*!40101 SET character_set_client = utf8 */;
1251 CREATE TABLE `LINTERFACE_VLAN` (
1252 `vnf_id` varchar(80) NOT NULL,
1253 `interface_name` varchar(255) NOT NULL,
1254 `vlan_interface` varchar(255) NOT NULL,
1255 `vlan_id_inner` varchar(64) DEFAULT NULL,
1256 `vlan_id_outer` varchar(64) DEFAULT NULL,
1257 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`),
1258 KEY `FK_LINTERFACE_VLAN_GENERIC_VNF_LINTERFACE_IDX` (`vnf_id`,`interface_name`),
1259 CONSTRAINT `FK_LINTERFACE_VLAN_GENERIC_VNF_LINTERFACE` FOREIGN KEY (`vnf_id`, `interface_name`) REFERENCES `GENERIC_VNF_LINTERFACE` (`vnf_id`, `interface_name`) ON DELETE NO ACTION ON UPDATE NO ACTION
1260 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1261 /*!40101 SET character_set_client = @saved_cs_client */;
1264 -- Table structure for table `LOCATION`
1267 DROP TABLE IF EXISTS `LOCATION`;
1268 /*!40101 SET @saved_cs_client = @@character_set_client */;
1269 /*!40101 SET character_set_client = utf8 */;
1270 CREATE TABLE `LOCATION` (
1271 `loc_id` int(11) NOT NULL AUTO_INCREMENT,
1272 `address` varchar(150) NOT NULL,
1273 `city_code_id` int(11) NOT NULL,
1274 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1275 PRIMARY KEY (`loc_id`),
1276 KEY `IN1_LOCATION_IDX` (`city_code_id`),
1277 CONSTRAINT `FK1_LOCATION` FOREIGN KEY (`city_code_id`) REFERENCES `CITY_CODE` (`city_code_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
1278 ) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=latin1;
1279 /*!40101 SET character_set_client = @saved_cs_client */;
1282 -- Table structure for table `MAX_PORT_SPEED`
1285 DROP TABLE IF EXISTS `MAX_PORT_SPEED`;
1286 /*!40101 SET @saved_cs_client = @@character_set_client */;
1287 /*!40101 SET character_set_client = utf8 */;
1288 CREATE TABLE `MAX_PORT_SPEED` (
1289 `max_port_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1290 `image_file_name` varchar(50) NOT NULL,
1291 `end_point_position` varchar(50) NOT NULL,
1292 `interface_name` varchar(100) NOT NULL,
1293 `max_speed` bigint(20) NOT NULL,
1294 `unit` varchar(10) NOT NULL,
1295 PRIMARY KEY (`max_port_speed_id`),
1296 UNIQUE KEY `max_port_speed_id` (`max_port_speed_id`)
1297 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1298 /*!40101 SET character_set_client = @saved_cs_client */;
1301 -- Table structure for table `MAX_SERVER_SPEED`
1304 DROP TABLE IF EXISTS `MAX_SERVER_SPEED`;
1305 /*!40101 SET @saved_cs_client = @@character_set_client */;
1306 /*!40101 SET character_set_client = utf8 */;
1307 CREATE TABLE `MAX_SERVER_SPEED` (
1308 `max_server_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1309 `server_model` varchar(50) NOT NULL,
1310 `evc_count` smallint(6) NOT NULL,
1311 `max_speed` bigint(20) NOT NULL,
1312 `unit` varchar(10) NOT NULL,
1313 `description` varchar(500) DEFAULT NULL,
1314 PRIMARY KEY (`max_server_speed_id`),
1315 UNIQUE KEY `max_server_speed_id` (`max_server_speed_id`)
1316 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
1317 /*!40101 SET character_set_client = @saved_cs_client */;
1320 -- Table structure for table `NAMING_POLICY_VM_NAME_INDEX`
1323 DROP TABLE IF EXISTS `NAMING_POLICY_VM_NAME_INDEX`;
1324 /*!40101 SET @saved_cs_client = @@character_set_client */;
1325 /*!40101 SET character_set_client = utf8 */;
1326 CREATE TABLE `NAMING_POLICY_VM_NAME_INDEX` (
1327 `vm_name_prefix` varchar(255) NOT NULL,
1328 `index_number` int(11) NOT NULL,
1329 PRIMARY KEY (`vm_name_prefix`)
1330 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1331 /*!40101 SET character_set_client = @saved_cs_client */;
1334 -- Table structure for table `NAMING_POLICY_VNFC_NAME_INDEX`
1337 DROP TABLE IF EXISTS `NAMING_POLICY_VNFC_NAME_INDEX`;
1338 /*!40101 SET @saved_cs_client = @@character_set_client */;
1339 /*!40101 SET character_set_client = utf8 */;
1340 CREATE TABLE `NAMING_POLICY_VNFC_NAME_INDEX` (
1341 `vnfc_name_prefix` varchar(255) NOT NULL,
1342 `index_number` int(11) NOT NULL,
1343 PRIMARY KEY (`vnfc_name_prefix`)
1344 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1345 /*!40101 SET character_set_client = @saved_cs_client */;
1348 -- Table structure for table `NBNC_ASSIGN_VPN_OVERRIDE`
1351 DROP TABLE IF EXISTS `NBNC_ASSIGN_VPN_OVERRIDE`;
1352 /*!40101 SET @saved_cs_client = @@character_set_client */;
1353 /*!40101 SET character_set_client = utf8 */;
1354 CREATE TABLE `NBNC_ASSIGN_VPN_OVERRIDE` (
1355 `vpn_id` varchar(12) NOT NULL DEFAULT '',
1356 `vpn_rt` varchar(16) NOT NULL DEFAULT '',
1357 `service_type` varchar(16) NOT NULL DEFAULT '',
1358 `be_location` varchar(16) NOT NULL DEFAULT '',
1359 `be_type` varchar(32) NOT NULL DEFAULT '',
1360 `be_id` varchar(32) DEFAULT NULL,
1361 `description` varchar(128) DEFAULT NULL,
1362 PRIMARY KEY (`vpn_id`,`vpn_rt`,`service_type`,`be_location`,`be_type`)
1363 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1364 /*!40101 SET character_set_client = @saved_cs_client */;
1367 -- Table structure for table `NBNC_BORDER_ELEMENT`
1370 DROP TABLE IF EXISTS `NBNC_BORDER_ELEMENT`;
1371 /*!40101 SET @saved_cs_client = @@character_set_client */;
1372 /*!40101 SET character_set_client = utf8 */;
1373 CREATE TABLE `NBNC_BORDER_ELEMENT` (
1374 `be_id` varchar(32) NOT NULL,
1375 `be_type` varchar(16) NOT NULL,
1376 `be_name` varchar(32) DEFAULT NULL,
1377 `be_host_vnf_id` varchar(32) DEFAULT NULL,
1378 `service_type` varchar(16) DEFAULT NULL,
1379 `tangibility` varchar(16) DEFAULT NULL,
1380 `usage_order` smallint(6) DEFAULT NULL,
1381 `vlan_start` smallint(6) DEFAULT NULL,
1382 `vlan_end` smallint(6) DEFAULT NULL,
1383 `ipv4_subnet` varchar(18) DEFAULT NULL,
1384 `ipv6_subnet` varchar(68) DEFAULT NULL,
1385 `network_ip` varchar(48) DEFAULT NULL,
1386 `be_location` varchar(16) DEFAULT NULL,
1387 `description` varchar(128) DEFAULT NULL,
1388 `updated_timestamp` timestamp NULL DEFAULT NULL,
1389 `log_link_model_uuid` varchar(64) DEFAULT NULL,
1390 PRIMARY KEY (`be_id`,`be_type`)
1391 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1392 /*!40101 SET character_set_client = @saved_cs_client */;
1395 -- Table structure for table `NBNC_IPE`
1398 DROP TABLE IF EXISTS `NBNC_IPE`;
1399 /*!40101 SET @saved_cs_client = @@character_set_client */;
1400 /*!40101 SET character_set_client = utf8 */;
1401 CREATE TABLE `NBNC_IPE` (
1402 `ipe_name` varchar(32) NOT NULL,
1403 `ipe_location` varchar(16) DEFAULT NULL,
1404 `ipe_ip_address` varchar(16) DEFAULT NULL,
1405 `ipe_id` varchar(8) DEFAULT NULL,
1406 `service_type_array` varchar(512) DEFAULT NULL,
1407 `ipe_status` varchar(32) DEFAULT NULL,
1408 `updated_timestamp` timestamp NULL DEFAULT NULL,
1409 PRIMARY KEY (`ipe_name`)
1410 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1411 /*!40101 SET character_set_client = @saved_cs_client */;
1414 -- Table structure for table `NBNC_IPE_PORT`
1417 DROP TABLE IF EXISTS `NBNC_IPE_PORT`;
1418 /*!40101 SET @saved_cs_client = @@character_set_client */;
1419 /*!40101 SET character_set_client = utf8 */;
1420 CREATE TABLE `NBNC_IPE_PORT` (
1421 `port_id` varchar(16) NOT NULL,
1422 `ipe_name` varchar(32) NOT NULL,
1423 `be_id` varchar(32) NOT NULL,
1424 `be_type` varchar(16) NOT NULL,
1425 `port_type` varchar(16) DEFAULT NULL,
1426 `ae_name` varchar(16) DEFAULT NULL,
1427 `description` varchar(128) DEFAULT NULL,
1428 `updated_timestamp` timestamp NULL DEFAULT NULL,
1429 PRIMARY KEY (`port_id`,`ipe_name`,`be_id`,`be_type`)
1430 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1431 /*!40101 SET character_set_client = @saved_cs_client */;
1434 -- Table structure for table `NBNC_MAPPING_SBG_BGF`
1437 DROP TABLE IF EXISTS `NBNC_MAPPING_SBG_BGF`;
1438 /*!40101 SET @saved_cs_client = @@character_set_client */;
1439 /*!40101 SET character_set_client = utf8 */;
1440 CREATE TABLE `NBNC_MAPPING_SBG_BGF` (
1441 `asbg_vlan` smallint(6) NOT NULL,
1442 `bgf_vlan` smallint(6) NOT NULL,
1443 PRIMARY KEY (`asbg_vlan`)
1444 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1445 /*!40101 SET character_set_client = @saved_cs_client */;
1448 -- Table structure for table `NBNC_SERVICE`
1451 DROP TABLE IF EXISTS `NBNC_SERVICE`;
1452 /*!40101 SET @saved_cs_client = @@character_set_client */;
1453 /*!40101 SET character_set_client = utf8 */;
1454 CREATE TABLE `NBNC_SERVICE` (
1455 `service_type` varchar(16) NOT NULL,
1456 `service_model_uuid` varchar(64) NOT NULL,
1457 `description` varchar(128) DEFAULT NULL,
1458 `created_timestamp` timestamp NULL DEFAULT NULL,
1459 `updated_timestamp` timestamp NULL DEFAULT NULL,
1460 PRIMARY KEY (`service_type`)
1461 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1462 /*!40101 SET character_set_client = @saved_cs_client */;
1465 -- Table structure for table `NBNC_SERVICE_VLAN`
1468 DROP TABLE IF EXISTS `NBNC_SERVICE_VLAN`;
1469 /*!40101 SET @saved_cs_client = @@character_set_client */;
1470 /*!40101 SET character_set_client = utf8 */;
1471 CREATE TABLE `NBNC_SERVICE_VLAN` (
1472 `be_id` varchar(32) NOT NULL,
1473 `vlan` smallint(6) NOT NULL,
1474 `service_type` varchar(16) DEFAULT NULL,
1475 `be_type` varchar(16) DEFAULT NULL,
1476 `be_name` varchar(32) DEFAULT NULL,
1477 `be_host_vnf_id` varchar(32) DEFAULT NULL,
1478 `be_location` varchar(16) DEFAULT NULL,
1479 `be_usage_order` smallint(6) DEFAULT NULL,
1480 `vlan_usage_order` smallint(6) DEFAULT NULL,
1481 `status` varchar(16) DEFAULT 'AVAILABLE',
1482 `request_id` varchar(64) DEFAULT NULL,
1483 `service_instance_id` varchar(64) DEFAULT NULL,
1484 `vni_id` varchar(16) DEFAULT NULL,
1485 `customer_id` varchar(16) DEFAULT NULL,
1486 `ipe1_router_name` varchar(32) DEFAULT NULL,
1487 `ipe1_port_id` varchar(16) DEFAULT NULL,
1488 `ipe1_ae_name` varchar(16) DEFAULT NULL,
1489 `ipe2_router_name` varchar(32) DEFAULT NULL,
1490 `ipe2_port_id` varchar(16) DEFAULT NULL,
1491 `ipe2_ae_name` varchar(16) DEFAULT NULL,
1492 `available_timestamp` timestamp NULL DEFAULT NULL,
1493 `allocated_timestamp` timestamp NULL DEFAULT NULL,
1494 `disabled_timestamp` timestamp NULL DEFAULT NULL,
1495 `enabled_timestamp` timestamp NULL DEFAULT NULL,
1496 `vpn_id` varchar(12) DEFAULT NULL,
1497 `vpn_rt` varchar(16) DEFAULT NULL,
1498 PRIMARY KEY (`be_id`,`vlan`)
1499 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1500 /*!40101 SET character_set_client = @saved_cs_client */;
1503 -- Table structure for table `NCS_EXPECTED_ASYNC_REQUESTS`
1506 DROP TABLE IF EXISTS `NCS_EXPECTED_ASYNC_REQUESTS`;
1507 /*!40101 SET @saved_cs_client = @@character_set_client */;
1508 /*!40101 SET character_set_client = utf8 */;
1509 CREATE TABLE `NCS_EXPECTED_ASYNC_REQUESTS` (
1510 `ncs_request_id` varchar(255) NOT NULL,
1511 `mso_gp_request_id` varchar(255) NOT NULL,
1512 `service_instance_id` varchar(255) NOT NULL,
1513 `sdn_module_name` varchar(255) NOT NULL,
1514 `sdn_rpc_name` varchar(255) NOT NULL,
1515 `sdn_service_action` varchar(255) DEFAULT NULL,
1516 `ncs_rpc` varchar(255) NOT NULL,
1517 `ncs_sub_action` varchar(255) DEFAULT NULL,
1518 `status` varchar(255) NOT NULL DEFAULT 'inProgress',
1519 `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1520 PRIMARY KEY (`ncs_request_id`)
1521 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1522 /*!40101 SET character_set_client = @saved_cs_client */;
1525 -- Table structure for table `NETWORK_INSTANCE_NAME_INDEX`
1528 DROP TABLE IF EXISTS `NETWORK_INSTANCE_NAME_INDEX`;
1529 /*!40101 SET @saved_cs_client = @@character_set_client */;
1530 /*!40101 SET character_set_client = utf8 */;
1531 CREATE TABLE `NETWORK_INSTANCE_NAME_INDEX` (
1532 `network_instance_name_prefix` varchar(255) NOT NULL,
1533 `index_number` int(11) NOT NULL,
1534 PRIMARY KEY (`network_instance_name_prefix`)
1535 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1536 /*!40101 SET character_set_client = @saved_cs_client */;
1539 -- Table structure for table `NETWORK_MODEL`
1542 DROP TABLE IF EXISTS `NETWORK_MODEL`;
1543 /*!40101 SET @saved_cs_client = @@character_set_client */;
1544 /*!40101 SET character_set_client = utf8 */;
1545 CREATE TABLE `NETWORK_MODEL` (
1546 `customization_uuid` varchar(255) NOT NULL,
1547 `service_uuid` varchar(255) NOT NULL,
1548 `model_yaml` longblob,
1549 `invariant_uuid` varchar(255) DEFAULT NULL,
1550 `uuid` varchar(255) DEFAULT NULL,
1551 `network_type` varchar(255) DEFAULT NULL,
1552 `network_role` varchar(255) DEFAULT NULL,
1553 `network_technology` varchar(255) DEFAULT NULL,
1554 `network_scope` varchar(255) DEFAULT NULL,
1555 `naming_policy` varchar(255) DEFAULT NULL,
1556 `ecomp_generated_naming` char(1) DEFAULT NULL,
1557 `is_shared_network` char(1) DEFAULT NULL,
1558 `is_external_network` char(1) DEFAULT NULL,
1559 `is_provider_network` char(1) DEFAULT NULL,
1560 `physical_network_name` varchar(255) DEFAULT NULL,
1561 `is_bound_to_vpn` char(1) DEFAULT NULL,
1562 `vpn_binding` varchar(255) DEFAULT NULL,
1563 `use_ipv4` char(1) DEFAULT NULL,
1564 `ipv4_dhcp_enabled` char(1) DEFAULT NULL,
1565 `ipv4_ip_version` char(1) DEFAULT NULL,
1566 `ipv4_cidr_mask` varchar(255) DEFAULT NULL,
1567 `eipam_v4_address_plan` varchar(255) DEFAULT NULL,
1568 `use_ipv6` char(1) DEFAULT NULL,
1569 `ipv6_dhcp_enabled` char(1) DEFAULT NULL,
1570 `ipv6_ip_version` char(1) DEFAULT NULL,
1571 `ipv6_cidr_mask` varchar(255) DEFAULT NULL,
1572 `eipam_v6_address_plan` varchar(255) DEFAULT NULL,
1573 `version` varchar(255) DEFAULT NULL,
1574 PRIMARY KEY (`customization_uuid`),
1575 KEY `FK_NETWORK_MODEL` (`service_uuid`),
1576 CONSTRAINT `FK_NETWORK_MODEL` FOREIGN KEY (`service_uuid`) REFERENCES `SERVICE_MODEL` (`service_uuid`) ON DELETE NO ACTION ON UPDATE NO ACTION
1577 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1578 /*!40101 SET character_set_client = @saved_cs_client */;
1581 -- Table structure for table `NETWORK_PROFILE`
1584 DROP TABLE IF EXISTS `NETWORK_PROFILE`;
1585 /*!40101 SET @saved_cs_client = @@character_set_client */;
1586 /*!40101 SET character_set_client = utf8 */;
1587 CREATE TABLE `NETWORK_PROFILE` (
1588 `network_type` varchar(100) NOT NULL,
1589 `technology` varchar(100) NOT NULL,
1590 PRIMARY KEY (`network_type`)
1591 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1592 /*!40101 SET character_set_client = @saved_cs_client */;
1595 -- Table structure for table `NETWORK_ROLE_VPN_BINDING`
1598 DROP TABLE IF EXISTS `NETWORK_ROLE_VPN_BINDING`;
1599 /*!40101 SET @saved_cs_client = @@character_set_client */;
1600 /*!40101 SET character_set_client = utf8 */;
1601 CREATE TABLE `NETWORK_ROLE_VPN_BINDING` (
1602 `network_role` varchar(80) NOT NULL,
1603 `vpn_id` varchar(80) NOT NULL,
1604 PRIMARY KEY (`network_role`,`vpn_id`)
1605 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1606 /*!40101 SET character_set_client = @saved_cs_client */;
1609 -- Table structure for table `NODE_TYPES`
1612 DROP TABLE IF EXISTS `NODE_TYPES`;
1613 /*!40101 SET @saved_cs_client = @@character_set_client */;
1614 /*!40101 SET character_set_client = utf8 */;
1615 CREATE TABLE `NODE_TYPES` (
1616 `nodetype` varchar(80) NOT NULL,
1617 PRIMARY KEY (`nodetype`)
1618 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1619 /*!40101 SET character_set_client = @saved_cs_client */;
1622 -- Table structure for table `OBJECT_GROUPING`
1625 DROP TABLE IF EXISTS `OBJECT_GROUPING`;
1626 /*!40101 SET @saved_cs_client = @@character_set_client */;
1627 /*!40101 SET character_set_client = utf8 */;
1628 CREATE TABLE `OBJECT_GROUPING` (
1629 `group_id` varchar(128) NOT NULL,
1630 `group_type` varchar(128) NOT NULL,
1631 PRIMARY KEY (`group_id`)
1632 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1633 /*!40101 SET character_set_client = @saved_cs_client */;
1636 -- Table structure for table `OBJECT_GROUP_MEMBER_TRACKING`
1639 DROP TABLE IF EXISTS `OBJECT_GROUP_MEMBER_TRACKING`;
1640 /*!40101 SET @saved_cs_client = @@character_set_client */;
1641 /*!40101 SET character_set_client = utf8 */;
1642 CREATE TABLE `OBJECT_GROUP_MEMBER_TRACKING` (
1643 `group_id` varchar(128) NOT NULL,
1644 `key_id` varchar(128) NOT NULL,
1645 `key_type` varchar(128) NOT NULL,
1646 PRIMARY KEY (`group_id`,`key_id`,`key_type`)
1647 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1648 /*!40101 SET character_set_client = @saved_cs_client */;
1651 -- Table structure for table `PARAMETERS`
1654 DROP TABLE IF EXISTS `PARAMETERS`;
1655 /*!40101 SET @saved_cs_client = @@character_set_client */;
1656 /*!40101 SET character_set_client = utf8 */;
1657 CREATE TABLE `PARAMETERS` (
1658 `name` varchar(100) NOT NULL,
1659 `value` varchar(128) NOT NULL,
1660 `category` varchar(24) DEFAULT NULL,
1661 `memo` varchar(128) DEFAULT NULL,
1662 PRIMARY KEY (`name`)
1663 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1664 /*!40101 SET character_set_client = @saved_cs_client */;
1667 -- Table structure for table `PE_INV`
1670 DROP TABLE IF EXISTS `PE_INV`;
1671 /*!40101 SET @saved_cs_client = @@character_set_client */;
1672 /*!40101 SET character_set_client = utf8 */;
1673 CREATE TABLE `PE_INV` (
1674 `EQUIP_ID` int(11) DEFAULT NULL,
1675 `EQUIP_TYPE` varchar(20) DEFAULT NULL,
1676 `PTNII_EQUIP_NAME` varchar(20) DEFAULT NULL,
1677 `IP_ADDR` varchar(15) DEFAULT NULL,
1678 `ROUTER_PROV_STATUS` varchar(50) DEFAULT NULL,
1679 `REGION` varchar(16) DEFAULT NULL,
1680 `COUNTRY_ABBR` varchar(50) DEFAULT NULL,
1681 `EQUIP_NAME_CODE` varchar(50) DEFAULT NULL,
1682 `AS_NUMBER` varchar(5) DEFAULT NULL,
1683 `LOOPBACK1` varchar(15) DEFAULT NULL,
1684 `LOOPBACK2` varchar(15) DEFAULT NULL,
1685 `LOOPBACK3` varchar(15) DEFAULT NULL,
1686 `LOOPBACK40` varchar(15) DEFAULT NULL,
1687 `LOOPBACK65535` varchar(15) DEFAULT NULL,
1688 `INMS_LIST` varchar(20) DEFAULT NULL,
1689 `ENCRYPTED_ACCESS_FLAG` varchar(50) DEFAULT NULL,
1690 `SW_NAME` varchar(100) DEFAULT NULL,
1691 `NMIPADDR` varchar(15) DEFAULT NULL,
1692 `CREATE_DATE` datetime DEFAULT NULL,
1693 `MOD_DATE` datetime DEFAULT NULL,
1694 `FCN_CODE` varchar(50) DEFAULT NULL
1695 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1696 /*!40101 SET character_set_client = @saved_cs_client */;
1699 -- Table structure for table `PHYSICAL_LINK`
1702 DROP TABLE IF EXISTS `PHYSICAL_LINK`;
1703 /*!40101 SET @saved_cs_client = @@character_set_client */;
1704 /*!40101 SET character_set_client = utf8 */;
1705 CREATE TABLE `PHYSICAL_LINK` (
1706 `link_name` varchar(255) NOT NULL,
1707 `speed_value` varchar(64) DEFAULT NULL,
1708 `speed_units` varchar(64) DEFAULT NULL,
1709 `circuit_id` varchar(255) NOT NULL,
1710 `dual_mode` varchar(64) NOT NULL,
1711 PRIMARY KEY (`link_name`)
1712 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1713 /*!40101 SET character_set_client = @saved_cs_client */;
1716 -- Table structure for table `PHYSICAL_LINK_PINTERFACE`
1719 DROP TABLE IF EXISTS `PHYSICAL_LINK_PINTERFACE`;
1720 /*!40101 SET @saved_cs_client = @@character_set_client */;
1721 /*!40101 SET character_set_client = utf8 */;
1722 CREATE TABLE `PHYSICAL_LINK_PINTERFACE` (
1723 `link_name` varchar(255) NOT NULL,
1724 `hostname` varchar(255) NOT NULL,
1725 `port_name_ft` varchar(255) NOT NULL,
1726 PRIMARY KEY (`link_name`,`hostname`,`port_name_ft`)
1727 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1728 /*!40101 SET character_set_client = @saved_cs_client */;
1731 -- Table structure for table `PINTERFACE`
1734 DROP TABLE IF EXISTS `PINTERFACE`;
1735 /*!40101 SET @saved_cs_client = @@character_set_client */;
1736 /*!40101 SET character_set_client = utf8 */;
1737 CREATE TABLE `PINTERFACE` (
1738 `hostname` varchar(255) NOT NULL,
1739 `port_name_ft` varchar(255) NOT NULL,
1740 `interface_name` varchar(255) DEFAULT '',
1741 `physical_speed` varchar(255) DEFAULT '',
1742 `physical_units` varchar(255) DEFAULT '',
1743 `port_description` varchar(255) DEFAULT '',
1744 PRIMARY KEY (`hostname`,`port_name_ft`)
1745 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1746 /*!40101 SET character_set_client = @saved_cs_client */;
1749 -- Table structure for table `POLICY_UPDATE_NOTIFICATION`
1752 DROP TABLE IF EXISTS `POLICY_UPDATE_NOTIFICATION`;
1753 /*!40101 SET @saved_cs_client = @@character_set_client */;
1754 /*!40101 SET character_set_client = utf8 */;
1755 CREATE TABLE `POLICY_UPDATE_NOTIFICATION` (
1756 `policy_name` varchar(255) NOT NULL,
1757 `version_id` varchar(255) NOT NULL,
1758 `update_type` varchar(255) NOT NULL,
1759 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1760 PRIMARY KEY (`policy_name`,`version_id`)
1761 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1762 /*!40101 SET character_set_client = @saved_cs_client */;
1765 -- Table structure for table `PORTAL_USERS`
1768 DROP TABLE IF EXISTS `PORTAL_USERS`;
1769 /*!40101 SET @saved_cs_client = @@character_set_client */;
1770 /*!40101 SET character_set_client = utf8 */;
1771 CREATE TABLE `PORTAL_USERS` (
1772 `email` varchar(64) NOT NULL,
1773 `password` varbinary(255) NOT NULL,
1774 `privilege` char(1) NOT NULL,
1775 PRIMARY KEY (`email`)
1776 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1777 /*!40101 SET character_set_client = @saved_cs_client */;
1781 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
1784 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
1785 /*!40101 SET @saved_cs_client = @@character_set_client */;
1786 /*!40101 SET character_set_client = utf8 */;
1787 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
1788 `prepare_file_relationship_id` int(11) NOT NULL AUTO_INCREMENT,
1789 `service_instance_id` varchar(50) DEFAULT NULL,
1790 `request_id` varchar(255) DEFAULT NULL,
1791 `config_file_id` int(11) DEFAULT NULL,
1792 `asdc_artifacts_id` int(11) DEFAULT NULL,
1793 PRIMARY KEY (`prepare_file_relationship_id`),
1794 UNIQUE KEY `prepare_file_relationship_id` (`prepare_file_relationship_id`),
1795 KEY `ie_prepare_file_relationship` (`config_file_id`),
1796 KEY `ie2_prepare_file_relationship` (`asdc_artifacts_id`),
1797 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`asdc_artifacts_id`) REFERENCES `ASDC_ARTIFACTS` (`asdc_artifacts_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
1798 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`config_file_id`) REFERENCES `CONFIGFILES` (`config_file_id`) ON DELETE NO ACTION ON UPDATE CASCADE
1799 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1800 /*!40101 SET character_set_client = @saved_cs_client */;
1803 -- Table structure for table `PRE_LOAD_VNF_DATA`
1806 DROP TABLE IF EXISTS `PRE_LOAD_VNF_DATA`;
1807 /*!40101 SET @saved_cs_client = @@character_set_client */;
1808 /*!40101 SET character_set_client = utf8 */;
1809 CREATE TABLE `PRE_LOAD_VNF_DATA` (
1810 `id` int(11) NOT NULL AUTO_INCREMENT,
1811 `svc_request_id` varchar(100) DEFAULT '',
1812 `svc_action` varchar(40) DEFAULT '',
1813 `status` varchar(10) NOT NULL DEFAULT 'pending',
1814 `filename` varchar(100) NOT NULL,
1815 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1816 `preload_data` longblob,
1818 ) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=latin1;
1819 /*!40101 SET character_set_client = @saved_cs_client */;
1822 -- Table structure for table `PRE_LOAD_VNF_NETWORK_DATA`
1825 DROP TABLE IF EXISTS `PRE_LOAD_VNF_NETWORK_DATA`;
1826 /*!40101 SET @saved_cs_client = @@character_set_client */;
1827 /*!40101 SET character_set_client = utf8 */;
1828 CREATE TABLE `PRE_LOAD_VNF_NETWORK_DATA` (
1829 `id` int(11) NOT NULL AUTO_INCREMENT,
1830 `svc_request_id` varchar(100) DEFAULT '',
1831 `svc_action` varchar(40) DEFAULT '',
1832 `status` varchar(10) NOT NULL DEFAULT 'pending',
1833 `filename` varchar(100) NOT NULL,
1834 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1835 `preload_data` longblob,
1837 ) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1;
1838 /*!40101 SET character_set_client = @saved_cs_client */;
1841 -- Table structure for table `PSERVER`
1844 DROP TABLE IF EXISTS `PSERVER`;
1845 /*!40101 SET @saved_cs_client = @@character_set_client */;
1846 /*!40101 SET character_set_client = utf8 */;
1847 CREATE TABLE `PSERVER` (
1848 `hostname` varchar(255) NOT NULL,
1849 `ptnii_equip_name` varchar(255) DEFAULT '',
1850 `number_of_cpus` varchar(255) DEFAULT '',
1851 `disk_in_gigabytes` varchar(255) DEFAULT '',
1852 `ram_in_megabytes` varchar(255) DEFAULT '',
1853 `equip_type` varchar(255) DEFAULT '',
1854 `equip_vendor` varchar(255) DEFAULT '',
1855 `equip_model` varchar(255) DEFAULT '',
1856 `fqdn` varchar(255) DEFAULT '',
1857 `pserver_selflink` varchar(255) DEFAULT '',
1858 `ipv4_oam_address` varchar(40) DEFAULT NULL,
1859 `serial_number` varchar(255) DEFAULT '',
1860 `pserver_id` varchar(255) DEFAULT '',
1861 `internet_topology` varchar(40) DEFAULT '',
1862 `aic_site_id` varchar(100) DEFAULT '',
1863 `in_maint` varchar(5) DEFAULT '',
1864 `pserver_name2` varchar(255) DEFAULT '',
1865 `purpose` varchar(255) DEFAULT '',
1866 PRIMARY KEY (`hostname`)
1867 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1868 /*!40101 SET character_set_client = @saved_cs_client */;
1871 -- Table structure for table `RANGE_RULE`
1874 DROP TABLE IF EXISTS `RANGE_RULE`;
1875 /*!40101 SET @saved_cs_client = @@character_set_client */;
1876 /*!40101 SET character_set_client = utf8 */;
1877 CREATE TABLE `RANGE_RULE` (
1878 `range_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1879 `range_name` varchar(50) NOT NULL,
1880 `service_model` varchar(50) NOT NULL,
1881 `end_point_position` varchar(50) NOT NULL,
1882 `equipment_level` varchar(50) NOT NULL,
1883 `min_value` int(11) NOT NULL,
1884 `max_value` int(11) NOT NULL,
1885 PRIMARY KEY (`range_rule_id`)
1886 ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
1887 /*!40101 SET character_set_client = @saved_cs_client */;
1890 -- Table structure for table `REQUEST_PROGRESS`
1893 DROP TABLE IF EXISTS `REQUEST_PROGRESS`;
1894 /*!40101 SET @saved_cs_client = @@character_set_client */;
1895 /*!40101 SET character_set_client = utf8 */;
1896 CREATE TABLE `REQUEST_PROGRESS` (
1897 `request_id` int(11) NOT NULL AUTO_INCREMENT,
1898 `request_type` varchar(20) DEFAULT NULL,
1899 `service_instance_id` varchar(80) NOT NULL,
1900 `request_instance_type` varchar(20) NOT NULL,
1901 `originating_service_instance_id` varchar(80) DEFAULT NULL,
1902 `originating_service_type` varchar(20) DEFAULT NULL,
1903 `overall_status` varchar(20) DEFAULT NULL,
1904 `status_date` varchar(80) DEFAULT NULL,
1905 `message` varchar(255) DEFAULT NULL,
1906 PRIMARY KEY (`request_id`)
1907 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1908 /*!40101 SET character_set_client = @saved_cs_client */;
1911 -- Table structure for table `REQUEST_PROGRESS_STATE`
1914 DROP TABLE IF EXISTS `REQUEST_PROGRESS_STATE`;
1915 /*!40101 SET @saved_cs_client = @@character_set_client */;
1916 /*!40101 SET character_set_client = utf8 */;
1917 CREATE TABLE `REQUEST_PROGRESS_STATE` (
1918 `request_progress_state_id` int(11) NOT NULL AUTO_INCREMENT,
1919 `request_id` int(11) DEFAULT NULL,
1920 `service_instance_id` varchar(80) NOT NULL,
1921 `request_instance_type` varchar(20) NOT NULL,
1922 `progress_state` varchar(30) DEFAULT NULL,
1923 `transaction_status` varchar(20) DEFAULT NULL,
1924 `status_date` varchar(80) DEFAULT NULL,
1925 `response_code` varchar(20) DEFAULT NULL,
1926 `message` varchar(255) DEFAULT NULL,
1927 PRIMARY KEY (`request_progress_state_id`)
1928 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1929 /*!40101 SET character_set_client = @saved_cs_client */;
1932 -- Table structure for table `RESOURCE`
1935 DROP TABLE IF EXISTS `RESOURCE`;
1936 /*!40101 SET @saved_cs_client = @@character_set_client */;
1937 /*!40101 SET character_set_client = utf8 */;
1938 CREATE TABLE `RESOURCE` (
1939 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1940 `asset_id` varchar(100) NOT NULL,
1941 `resource_name` varchar(50) NOT NULL,
1942 `resource_type` enum('Limit','Label','Range') NOT NULL,
1943 `lt_used` bigint(20) DEFAULT NULL,
1944 `ll_label` varchar(50) DEFAULT NULL,
1945 `ll_reference_count` smallint(6) DEFAULT NULL,
1946 `rr_used` varchar(4000) DEFAULT NULL,
1947 PRIMARY KEY (`resource_id`),
1948 UNIQUE KEY `resource_id` (`resource_id`),
1949 UNIQUE KEY `IX1_RESOURCE` (`asset_id`,`resource_name`)
1950 ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;
1951 /*!40101 SET character_set_client = @saved_cs_client */;
1954 -- Table structure for table `RESOURCE_LOAD`
1957 DROP TABLE IF EXISTS `RESOURCE_LOAD`;
1958 /*!40101 SET @saved_cs_client = @@character_set_client */;
1959 /*!40101 SET character_set_client = utf8 */;
1960 CREATE TABLE `RESOURCE_LOAD` (
1961 `resource_load_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1962 `resource_id` bigint(20) NOT NULL,
1963 `application_id` varchar(20) NOT NULL,
1964 `resource_load_time` datetime NOT NULL,
1965 `resource_expiration_time` datetime DEFAULT NULL,
1966 PRIMARY KEY (`resource_load_id`),
1967 UNIQUE KEY `resource_load_id` (`resource_load_id`),
1968 UNIQUE KEY `IX2_RESOURCE_LOAD` (`resource_id`,`application_id`),
1969 KEY `IX1_RESOURCE_LOAD` (`resource_id`)
1970 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1971 /*!40101 SET character_set_client = @saved_cs_client */;
1974 -- Table structure for table `RESOURCE_LOCK`
1977 DROP TABLE IF EXISTS `RESOURCE_LOCK`;
1978 /*!40101 SET @saved_cs_client = @@character_set_client */;
1979 /*!40101 SET character_set_client = utf8 */;
1980 CREATE TABLE `RESOURCE_LOCK` (
1981 `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1982 `resource_name` varchar(256) DEFAULT NULL,
1983 `lock_holder` varchar(100) NOT NULL,
1984 `lock_count` smallint(6) NOT NULL,
1985 `lock_time` datetime NOT NULL,
1986 `expiration_time` datetime NOT NULL,
1987 PRIMARY KEY (`resource_lock_id`),
1988 UNIQUE KEY `resource_lock_id` (`resource_lock_id`),
1989 UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`)
1990 ) ENGINE=InnoDB AUTO_INCREMENT=29681 DEFAULT CHARSET=latin1;
1991 /*!40101 SET character_set_client = @saved_cs_client */;
1994 -- Table structure for table `RESOURCE_RULE`
1997 DROP TABLE IF EXISTS `RESOURCE_RULE`;
1998 /*!40101 SET @saved_cs_client = @@character_set_client */;
1999 /*!40101 SET character_set_client = utf8 */;
2000 CREATE TABLE `RESOURCE_RULE` (
2001 `resource_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2002 `resource_name` varchar(50) NOT NULL,
2003 `service_model` varchar(50) NOT NULL,
2004 `end_point_position` varchar(50) NOT NULL,
2005 `service_expression` varchar(2000) NOT NULL,
2006 `equipment_level` varchar(50) NOT NULL,
2007 `equipment_expression` varchar(2000) NOT NULL,
2008 `allocation_expression` varchar(2000) NOT NULL,
2009 `soft_limit_expression` varchar(2000) NOT NULL,
2010 `hard_limit_expression` varchar(2000) NOT NULL,
2011 PRIMARY KEY (`resource_rule_id`),
2012 UNIQUE KEY `resource_rule_id` (`resource_rule_id`)
2013 ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
2014 /*!40101 SET character_set_client = @saved_cs_client */;
2017 -- Table structure for table `RESOURCE_THRESHOLD`
2020 DROP TABLE IF EXISTS `RESOURCE_THRESHOLD`;
2021 /*!40101 SET @saved_cs_client = @@character_set_client */;
2022 /*!40101 SET character_set_client = utf8 */;
2023 CREATE TABLE `RESOURCE_THRESHOLD` (
2024 `resource_threshold_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2025 `resource_rule_id` bigint(20) NOT NULL,
2026 `threshold_expression` varchar(2000) NOT NULL,
2027 `threshold_message` varchar(2000) NOT NULL,
2028 PRIMARY KEY (`resource_threshold_id`)
2029 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2030 /*!40101 SET character_set_client = @saved_cs_client */;
2033 -- Table structure for table `ROUTER_MASTER`
2036 DROP TABLE IF EXISTS `ROUTER_MASTER`;
2037 /*!40101 SET @saved_cs_client = @@character_set_client */;
2038 /*!40101 SET character_set_client = utf8 */;
2039 CREATE TABLE `ROUTER_MASTER` (
2040 `crs_name` varchar(20) NOT NULL,
2041 `loopback_ip` varchar(20) NOT NULL,
2042 PRIMARY KEY (`crs_name`)
2043 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2044 /*!40101 SET character_set_client = @saved_cs_client */;
2047 -- Table structure for table `ROUTING_CHARACTERISTIC_MAPPING`
2050 DROP TABLE IF EXISTS `ROUTING_CHARACTERISTIC_MAPPING`;
2051 /*!40101 SET @saved_cs_client = @@character_set_client */;
2052 /*!40101 SET character_set_client = utf8 */;
2053 CREATE TABLE `ROUTING_CHARACTERISTIC_MAPPING` (
2054 `network_role` varchar(255) NOT NULL,
2055 `vrf_name` varchar(255) NOT NULL,
2056 `routing_characteristic` varchar(255) NOT NULL,
2057 PRIMARY KEY (`network_role`,`vrf_name`)
2058 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2059 /*!40101 SET character_set_client = @saved_cs_client */;
2062 -- Table structure for table `SERVICE_HOMING`
2065 DROP TABLE IF EXISTS `SERVICE_HOMING`;
2066 /*!40101 SET @saved_cs_client = @@character_set_client */;
2067 /*!40101 SET character_set_client = utf8 */;
2068 CREATE TABLE `SERVICE_HOMING` (
2069 `service_type` varchar(100) NOT NULL,
2070 `lata` int(3) NOT NULL,
2071 `hubbing_city_type` varchar(40) NOT NULL,
2072 `latitude` float DEFAULT NULL,
2073 `longitude` float DEFAULT NULL,
2074 `primary_aic_site_name` varchar(100) NOT NULL,
2075 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2076 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2077 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2078 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2079 /*!40101 SET character_set_client = @saved_cs_client */;
2082 -- Table structure for table `SERVICE_HOMING_BACKUP`
2085 DROP TABLE IF EXISTS `SERVICE_HOMING_BACKUP`;
2086 /*!40101 SET @saved_cs_client = @@character_set_client */;
2087 /*!40101 SET character_set_client = utf8 */;
2088 CREATE TABLE `SERVICE_HOMING_BACKUP` (
2089 `service_type` varchar(100) NOT NULL,
2090 `lata` int(3) NOT NULL,
2091 `hubbing_city_type` varchar(40) NOT NULL,
2092 `latitude` float DEFAULT NULL,
2093 `longitude` float DEFAULT NULL,
2094 `primary_aic_site_name` varchar(100) NOT NULL,
2095 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2096 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2097 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2098 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2099 /*!40101 SET character_set_client = @saved_cs_client */;
2102 -- Table structure for table `SERVICE_INSTANCE_NAME_INDEX`
2105 DROP TABLE IF EXISTS `SERVICE_INSTANCE_NAME_INDEX`;
2106 /*!40101 SET @saved_cs_client = @@character_set_client */;
2107 /*!40101 SET character_set_client = utf8 */;
2108 CREATE TABLE `SERVICE_INSTANCE_NAME_INDEX` (
2109 `service_instance_name_prefix` varchar(255) NOT NULL,
2110 `index_number` int(11) NOT NULL,
2111 PRIMARY KEY (`service_instance_name_prefix`)
2112 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2113 /*!40101 SET character_set_client = @saved_cs_client */;
2116 -- Table structure for table `SERVICE_MANAGER_CREDENTIALS`
2119 DROP TABLE IF EXISTS `SERVICE_MANAGER_CREDENTIALS`;
2120 /*!40101 SET @saved_cs_client = @@character_set_client */;
2121 /*!40101 SET character_set_client = utf8 */;
2122 CREATE TABLE `SERVICE_MANAGER_CREDENTIALS` (
2123 `service_manager_username` varchar(255) NOT NULL,
2124 `service_manager_password` varbinary(255) NOT NULL,
2125 PRIMARY KEY (`service_manager_username`)
2126 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2127 /*!40101 SET character_set_client = @saved_cs_client */;
2130 -- Table structure for table `SERVICE_MODEL`
2133 DROP TABLE IF EXISTS `SERVICE_MODEL`;
2134 /*!40101 SET @saved_cs_client = @@character_set_client */;
2135 /*!40101 SET character_set_client = utf8 */;
2136 CREATE TABLE `SERVICE_MODEL` (
2137 `service_uuid` varchar(255) NOT NULL,
2138 `model_yaml` longblob,
2139 `invariant_uuid` varchar(255) DEFAULT NULL,
2140 `version` varchar(255) DEFAULT NULL,
2141 `name` varchar(255) DEFAULT NULL,
2142 `description` varchar(1024) DEFAULT NULL,
2143 `type` varchar(255) DEFAULT NULL,
2144 `category` varchar(255) DEFAULT NULL,
2145 `ecomp_naming` char(1) DEFAULT NULL,
2146 `service_instance_name_prefix` varchar(255) DEFAULT NULL,
2147 `filename` varchar(100) DEFAULT NULL,
2148 `naming_policy` varchar(255) DEFAULT NULL,
2149 PRIMARY KEY (`service_uuid`)
2150 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2151 /*!40101 SET character_set_client = @saved_cs_client */;
2154 -- Table structure for table `SERVICE_PROXY`
2157 DROP TABLE IF EXISTS `SERVICE_PROXY`;
2158 /*!40101 SET @saved_cs_client = @@character_set_client */;
2159 /*!40101 SET character_set_client = utf8 */;
2160 CREATE TABLE `SERVICE_PROXY` (
2161 `port_mirror_service_uuid` varchar(255) NOT NULL,
2162 `service_proxy_name` varchar(255) NOT NULL,
2163 `source_service_uuid` varchar(255) NOT NULL,
2164 `resources_vendor` varchar(255) DEFAULT NULL,
2165 `resource_vendor_release` varchar(255) DEFAULT NULL,
2166 `description` varchar(255) DEFAULT NULL,
2167 `category` varchar(255) DEFAULT NULL,
2168 `subcategory` varchar(255) DEFAULT NULL,
2169 `version` varchar(255) DEFAULT NULL,
2170 `role` varchar(255) NOT NULL,
2171 `uuid` varchar(255) DEFAULT NULL,
2172 `customization_uuid` varchar(255) DEFAULT NULL,
2173 `invariant_uuid` varchar(255) DEFAULT NULL,
2174 PRIMARY KEY (`port_mirror_service_uuid`,`service_proxy_name`),
2175 KEY `FK_SERVICE_PROXY_SOURCE_TO_SERVICE_MODE` (`source_service_uuid`),
2176 CONSTRAINT `FK_SERVICE_PROXY_MIRROR_TO_SERVICE_MODE` FOREIGN KEY (`port_mirror_service_uuid`) REFERENCES `SERVICE_MODEL` (`service_uuid`) ON DELETE CASCADE ON UPDATE NO ACTION
2177 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2178 /*!40101 SET character_set_client = @saved_cs_client */;
2181 -- Table structure for table `SERVICE_RESOURCE`
2184 DROP TABLE IF EXISTS `SERVICE_RESOURCE`;
2185 /*!40101 SET @saved_cs_client = @@character_set_client */;
2186 /*!40101 SET character_set_client = utf8 */;
2187 CREATE TABLE `SERVICE_RESOURCE` (
2188 `service_resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2189 `service_instance_id` varchar(80) NOT NULL,
2190 `service_status` enum('Active','Pending') NOT NULL,
2191 `service_change_number` smallint(6) NOT NULL,
2192 `resource_set_id` varchar(100) NOT NULL,
2193 `resource_union_id` varchar(100) NOT NULL,
2194 PRIMARY KEY (`service_instance_id`,`service_change_number`),
2195 UNIQUE KEY `service_resource_id` (`service_resource_id`),
2196 KEY `IX1_SERVICE_RESOURCE` (`service_instance_id`)
2197 ) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=latin1;
2198 /*!40101 SET character_set_client = @saved_cs_client */;
2201 -- Table structure for table `SERVICE_TYPE_MAPPING`
2204 DROP TABLE IF EXISTS `SERVICE_TYPE_MAPPING`;
2205 /*!40101 SET @saved_cs_client = @@character_set_client */;
2206 /*!40101 SET character_set_client = utf8 */;
2207 CREATE TABLE `SERVICE_TYPE_MAPPING` (
2208 `sdnc_service_type` varchar(128) NOT NULL,
2209 `ncs_service_type` varchar(128) NOT NULL,
2210 PRIMARY KEY (`sdnc_service_type`,`ncs_service_type`)
2211 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2212 /*!40101 SET character_set_client = @saved_cs_client */;
2215 -- Table structure for table `SUBNETPOOL_MAPPING`
2218 DROP TABLE IF EXISTS `SUBNETPOOL_MAPPING`;
2219 /*!40101 SET @saved_cs_client = @@character_set_client */;
2220 /*!40101 SET character_set_client = utf8 */;
2221 CREATE TABLE `SUBNETPOOL_MAPPING` (
2222 `aic_cloud_region` varchar(16) NOT NULL,
2223 `ntc` varchar(32) NOT NULL,
2224 `lcp` varchar(32) NOT NULL,
2225 `aic_region_id` varchar(255) NOT NULL,
2226 PRIMARY KEY (`aic_cloud_region`)
2227 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2228 /*!40101 SET character_set_client = @saved_cs_client */;
2231 -- Table structure for table `SUPPORTED_SEQUENCE_NUMBER`
2234 DROP TABLE IF EXISTS `SUPPORTED_SEQUENCE_NUMBER`;
2235 /*!40101 SET @saved_cs_client = @@character_set_client */;
2236 /*!40101 SET character_set_client = utf8 */;
2237 CREATE TABLE `SUPPORTED_SEQUENCE_NUMBER` (
2238 `resource_sequence_number` varchar(10) NOT NULL,
2239 `resource_type` varchar(10) NOT NULL,
2240 PRIMARY KEY (`resource_sequence_number`,`resource_type`)
2241 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2242 /*!40101 SET character_set_client = @saved_cs_client */;
2245 -- Table structure for table `SVC_LOGIC`
2248 DROP TABLE IF EXISTS `SVC_LOGIC`;
2249 /*!40101 SET @saved_cs_client = @@character_set_client */;
2250 /*!40101 SET character_set_client = utf8 */;
2251 CREATE TABLE `SVC_LOGIC` (
2252 `module` varchar(80) NOT NULL,
2253 `rpc` varchar(80) NOT NULL,
2254 `version` varchar(40) NOT NULL,
2255 `mode` varchar(5) NOT NULL,
2256 `active` varchar(1) NOT NULL,
2258 `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2259 `md5sum` varchar(128) DEFAULT NULL,
2260 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
2261 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2262 /*!40101 SET character_set_client = @saved_cs_client */;
2265 -- Table structure for table `TABLE_CLEANUP_CONFIGURATION`
2268 DROP TABLE IF EXISTS `TABLE_CLEANUP_CONFIGURATION`;
2269 /*!40101 SET @saved_cs_client = @@character_set_client */;
2270 /*!40101 SET character_set_client = utf8 */;
2271 CREATE TABLE `TABLE_CLEANUP_CONFIGURATION` (
2272 `table_name` varchar(255) NOT NULL COMMENT 'The name of the table the cleanup will be performed on',
2273 `days_old` int(11) NOT NULL COMMENT 'Records older than the current date minus DAYS_OLD will be deleted',
2274 `date_column` varchar(255) NOT NULL COMMENT 'The name of the column containing the date to be checked',
2275 `commit_interval` int(11) NOT NULL DEFAULT '2500' COMMENT 'The maximum number of rows a commit may contain',
2276 `query_clause` varchar(1000) DEFAULT NULL COMMENT 'An optional additional query clause to further restrict deletion criteria',
2277 `child_table_name` varchar(255) DEFAULT NULL,
2278 `child_table_pk` varchar(255) DEFAULT NULL,
2279 PRIMARY KEY (`table_name`)
2280 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table will be used by the table clean-up script, tableCleanup.sh, to drive what tables should be purged and what the purge criteria are.';
2281 /*!40101 SET character_set_client = @saved_cs_client */;
2284 -- Table structure for table `TASK_TEMPLATE`
2287 DROP TABLE IF EXISTS `TASK_TEMPLATE`;
2288 /*!40101 SET @saved_cs_client = @@character_set_client */;
2289 /*!40101 SET character_set_client = utf8 */;
2290 CREATE TABLE `TASK_TEMPLATE` (
2291 `task_template_id` int(11) NOT NULL AUTO_INCREMENT,
2292 `request_type` varchar(20) DEFAULT NULL,
2293 `task_name` varchar(30) NOT NULL,
2294 `task_category` varchar(50) NOT NULL,
2295 `ecomp_task` varchar(50) NOT NULL,
2296 `initial_load` varchar(1) NOT NULL,
2297 `service` varchar(20) DEFAULT NULL,
2298 PRIMARY KEY (`task_template_id`)
2299 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2300 /*!40101 SET character_set_client = @saved_cs_client */;
2303 -- Table structure for table `TENANT`
2306 DROP TABLE IF EXISTS `TENANT`;
2307 /*!40101 SET @saved_cs_client = @@character_set_client */;
2308 /*!40101 SET character_set_client = utf8 */;
2309 CREATE TABLE `TENANT` (
2310 `tenant_id` varchar(255) NOT NULL,
2311 `tenant_name` varchar(255) NOT NULL,
2312 `service_instance_id` varchar(255) NOT NULL,
2313 PRIMARY KEY (`tenant_id`,`tenant_name`)
2314 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2315 /*!40101 SET character_set_client = @saved_cs_client */;
2318 -- Table structure for table `TESTTBL`
2321 DROP TABLE IF EXISTS `TESTTBL`;
2322 /*!40101 SET @saved_cs_client = @@character_set_client */;
2323 /*!40101 SET character_set_client = utf8 */;
2324 CREATE TABLE `TESTTBL` (
2325 `pk` varchar(25) NOT NULL,
2326 `col1` varchar(25) DEFAULT NULL
2327 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2328 /*!40101 SET character_set_client = @saved_cs_client */;
2331 -- Table structure for table `THRESHOLD_NOTIFICATION`
2334 DROP TABLE IF EXISTS `THRESHOLD_NOTIFICATION`;
2335 /*!40101 SET @saved_cs_client = @@character_set_client */;
2336 /*!40101 SET character_set_client = utf8 */;
2337 CREATE TABLE `THRESHOLD_NOTIFICATION` (
2338 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2339 `threshold_expression` varchar(2000) DEFAULT NULL,
2340 `threshold_message` varchar(500) DEFAULT NULL,
2341 PRIMARY KEY (`resource_id`)
2342 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2343 /*!40101 SET character_set_client = @saved_cs_client */;
2346 -- Table structure for table `TMP_AIC_AVAIL_ZONE_POOL`
2349 DROP TABLE IF EXISTS `TMP_AIC_AVAIL_ZONE_POOL`;
2350 /*!40101 SET @saved_cs_client = @@character_set_client */;
2351 /*!40101 SET character_set_client = utf8 */;
2352 CREATE TABLE `TMP_AIC_AVAIL_ZONE_POOL` (
2353 `aic_site_id` varchar(100) NOT NULL,
2354 `status` varchar(40) NOT NULL,
2355 `availability_zone` varchar(100) NOT NULL,
2356 `token` int(4) NOT NULL,
2357 `vnf_id` varchar(80) DEFAULT NULL,
2358 `service_type` varchar(100) NOT NULL,
2359 `vnf_type` varchar(20) DEFAULT NULL,
2360 `hypervisor` varchar(10) DEFAULT NULL,
2361 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
2362 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2363 /*!40101 SET character_set_client = @saved_cs_client */;
2366 -- Table structure for table `TOPOLOGY_PARAMETER`
2369 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER`;
2370 /*!40101 SET @saved_cs_client = @@character_set_client */;
2371 /*!40101 SET character_set_client = utf8 */;
2372 CREATE TABLE `TOPOLOGY_PARAMETER` (
2373 `parameter_id` int(11) NOT NULL,
2374 `parameter_name` varchar(20) NOT NULL,
2375 `parameter_set` int(11) NOT NULL,
2376 `create_update_time` datetime NOT NULL,
2377 `create_update_user` varchar(40) NOT NULL,
2378 PRIMARY KEY (`parameter_id`)
2379 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2380 /*!40101 SET character_set_client = @saved_cs_client */;
2383 -- Table structure for table `TOPOLOGY_PARAMETER_ENTRIES`
2386 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_ENTRIES`;
2387 /*!40101 SET @saved_cs_client = @@character_set_client */;
2388 /*!40101 SET character_set_client = utf8 */;
2389 CREATE TABLE `TOPOLOGY_PARAMETER_ENTRIES` (
2390 `parameter_entry_id` int(11) NOT NULL,
2391 `parameter_name` varchar(255) NOT NULL,
2392 `parameter_value` varchar(64) NOT NULL,
2393 `create_update_time` datetime NOT NULL,
2394 `create_update_user` varchar(40) NOT NULL,
2395 PRIMARY KEY (`parameter_entry_id`)
2396 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2397 /*!40101 SET character_set_client = @saved_cs_client */;
2400 -- Table structure for table `TOPOLOGY_PARAMETER_TO_ENTRIES`
2403 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_TO_ENTRIES`;
2404 /*!40101 SET @saved_cs_client = @@character_set_client */;
2405 /*!40101 SET character_set_client = utf8 */;
2406 CREATE TABLE `TOPOLOGY_PARAMETER_TO_ENTRIES` (
2407 `parameter_id` int(11) DEFAULT NULL,
2408 `parameter_entry_id` int(11) DEFAULT NULL,
2409 `entry_order` int(11) DEFAULT NULL,
2410 `create_update_time` datetime DEFAULT NULL,
2411 `create_update_user` varchar(40) NOT NULL,
2412 KEY `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_id`),
2413 KEY `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_entry_id`),
2414 CONSTRAINT `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_id`) REFERENCES `TOPOLOGY_PARAMETER` (`parameter_id`),
2415 CONSTRAINT `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_entry_id`) REFERENCES `TOPOLOGY_PARAMETER_ENTRIES` (`parameter_entry_id`)
2416 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2417 /*!40101 SET character_set_client = @saved_cs_client */;
2420 -- Table structure for table `TRANSACTION_LOG`
2423 DROP TABLE IF EXISTS `TRANSACTION_LOG`;
2424 /*!40101 SET @saved_cs_client = @@character_set_client */;
2425 /*!40101 SET character_set_client = utf8 */;
2426 CREATE TABLE `TRANSACTION_LOG` (
2427 `serial_key` int(10) NOT NULL AUTO_INCREMENT,
2428 `log_time` varchar(40) NOT NULL,
2429 `request_id` varchar(80) DEFAULT NULL,
2430 `svc_request_id` varchar(80) DEFAULT NULL,
2431 `x_ecomp_request_id` varchar(80) DEFAULT NULL,
2432 `graph_name` varchar(255) DEFAULT NULL,
2433 PRIMARY KEY (`serial_key`)
2434 ) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;
2435 /*!40101 SET character_set_client = @saved_cs_client */;
2439 -- Table structure for table `UPLOAD_CONFIG`
2442 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
2443 /*!40101 SET @saved_cs_client = @@character_set_client */;
2444 /*!40101 SET character_set_client = utf8 */;
2445 CREATE TABLE `UPLOAD_CONFIG` (
2446 `upload_config_id` int(11) NOT NULL AUTO_INCREMENT,
2447 `request_id` varchar(50) DEFAULT NULL,
2448 `originator_id` varchar(50) DEFAULT NULL,
2449 `service_description` varchar(100) DEFAULT NULL,
2450 `action` varchar(50) DEFAULT NULL,
2451 `upload_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
2452 `vnf_id` varchar(50) DEFAULT NULL,
2453 `vnf_name` varchar(50) DEFAULT NULL,
2454 `vm_name` varchar(50) DEFAULT NULL,
2455 `vnf_type` varchar(50) DEFAULT NULL,
2456 `vnfc_type` varchar(50) DEFAULT NULL,
2457 `host_ip_address` varchar(50) DEFAULT NULL,
2458 `config_indicator` varchar(25) DEFAULT NULL,
2459 `pending_delete` varchar(1) DEFAULT NULL,
2461 PRIMARY KEY (`upload_config_id`),
2462 UNIQUE KEY `upload_config_id` (`upload_config_id`)
2463 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2464 /*!40101 SET character_set_client = @saved_cs_client */;
2467 -- Table structure for table `USED_SEQUENCE_NUMBER`
2470 DROP TABLE IF EXISTS `USED_SEQUENCE_NUMBER`;
2471 /*!40101 SET @saved_cs_client = @@character_set_client */;
2472 /*!40101 SET character_set_client = utf8 */;
2473 CREATE TABLE `USED_SEQUENCE_NUMBER` (
2474 `resource_sequence_number` varchar(10) NOT NULL,
2475 `resource_type` varchar(10) NOT NULL,
2476 `zone_region_id` varchar(50) NOT NULL,
2477 PRIMARY KEY (`resource_sequence_number`,`resource_type`,`zone_region_id`)
2478 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2479 /*!40101 SET character_set_client = @saved_cs_client */;
2482 -- Table structure for table `USER_TRACE`
2485 DROP TABLE IF EXISTS `USER_TRACE`;
2486 /*!40101 SET @saved_cs_client = @@character_set_client */;
2487 /*!40101 SET character_set_client = utf8 */;
2488 CREATE TABLE `USER_TRACE` (
2489 `user_trace_seq` int(11) NOT NULL AUTO_INCREMENT,
2490 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2491 `identity` varchar(12) DEFAULT NULL,
2492 `action` varchar(128) DEFAULT NULL,
2493 `description` varchar(256) DEFAULT NULL,
2494 PRIMARY KEY (`user_trace_seq`)
2495 ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=latin1;
2496 /*!40101 SET character_set_client = @saved_cs_client */;
2499 -- Table structure for table `VENDOR_CODE`
2502 DROP TABLE IF EXISTS `VENDOR_CODE`;
2503 /*!40101 SET @saved_cs_client = @@character_set_client */;
2504 /*!40101 SET character_set_client = utf8 */;
2505 CREATE TABLE `VENDOR_CODE` (
2506 `vendor_code` varchar(1) NOT NULL,
2507 `vendor` varchar(45) NOT NULL DEFAULT '',
2508 PRIMARY KEY (`vendor_code`,`vendor`)
2509 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2510 /*!40101 SET character_set_client = @saved_cs_client */;
2513 -- Table structure for table `VFC_MODEL`
2516 DROP TABLE IF EXISTS `VFC_MODEL`;
2517 /*!40101 SET @saved_cs_client = @@character_set_client */;
2518 /*!40101 SET character_set_client = utf8 */;
2519 CREATE TABLE `VFC_MODEL` (
2520 `customization_uuid` varchar(255) NOT NULL,
2521 `model_yaml` longblob,
2522 `invariant_uuid` varchar(255) DEFAULT NULL,
2523 `uuid` varchar(255) DEFAULT NULL,
2524 `version` varchar(255) DEFAULT NULL,
2525 `naming_policy` varchar(255) DEFAULT NULL,
2526 `ecomp_generated_naming` char(1) DEFAULT NULL,
2527 `nfc_function` varchar(255) DEFAULT NULL,
2528 `nfc_naming_code` varchar(255) DEFAULT NULL,
2529 `vm_type` varchar(255) DEFAULT NULL,
2530 `vm_type_tag` varchar(255) DEFAULT NULL,
2531 `vm_image_name` varchar(255) DEFAULT NULL,
2532 `vm_flavor_name` varchar(255) DEFAULT NULL,
2533 `high_availability` varchar(255) DEFAULT NULL,
2534 `nfc_naming` varchar(255) DEFAULT NULL,
2535 `min_instances` int(11) DEFAULT NULL,
2536 `max_instances` int(11) DEFAULT NULL,
2537 PRIMARY KEY (`customization_uuid`)
2538 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2539 /*!40101 SET character_set_client = @saved_cs_client */;
2542 -- Table structure for table `VFC_TO_NETWORK_ROLE_MAPPING`
2545 DROP TABLE IF EXISTS `VFC_TO_NETWORK_ROLE_MAPPING`;
2546 /*!40101 SET @saved_cs_client = @@character_set_client */;
2547 /*!40101 SET character_set_client = utf8 */;
2548 CREATE TABLE `VFC_TO_NETWORK_ROLE_MAPPING` (
2549 `seq` int(11) NOT NULL AUTO_INCREMENT,
2550 `vfc_customization_uuid` varchar(255) NOT NULL,
2551 `network_role` varchar(255) NOT NULL,
2552 `vm_type` varchar(255) DEFAULT NULL,
2553 `network_role_tag` varchar(255) DEFAULT NULL,
2554 `ipv4_count` int(11) NOT NULL,
2555 `ipv6_count` int(11) NOT NULL,
2556 `ipv4_use_dhcp` char(1) DEFAULT NULL,
2557 `ipv6_use_dhcp` char(1) DEFAULT NULL,
2558 `ipv4_ip_version` char(1) DEFAULT NULL,
2559 `ipv6_ip_version` char(1) DEFAULT NULL,
2560 `extcp_subnetpool_id` varchar(512) DEFAULT NULL,
2561 `ipv4_floating_count` int(11) DEFAULT NULL,
2562 `ipv6_floating_count` int(11) DEFAULT NULL,
2563 `ipv4_address_plan_name` varchar(512) DEFAULT NULL,
2564 `ipv6_address_plan_name` varchar(512) DEFAULT NULL,
2565 `ipv4_vrf_name` varchar(512) DEFAULT NULL,
2566 `ipv6_vrf_name` varchar(512) DEFAULT NULL,
2567 `subnet_role` varchar(255) DEFAULT NULL,
2568 PRIMARY KEY (`seq`),
2569 KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`)
2570 ) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1;
2571 /*!40101 SET character_set_client = @saved_cs_client */;
2574 -- Table structure for table `VF_MODEL`
2577 DROP TABLE IF EXISTS `VF_MODEL`;
2578 /*!40101 SET @saved_cs_client = @@character_set_client */;
2579 /*!40101 SET character_set_client = utf8 */;
2580 CREATE TABLE `VF_MODEL` (
2581 `customization_uuid` varchar(255) NOT NULL,
2582 `model_yaml` longblob,
2583 `invariant_uuid` varchar(255) DEFAULT NULL,
2584 `uuid` varchar(255) DEFAULT NULL,
2585 `version` varchar(255) DEFAULT NULL,
2586 `name` varchar(255) DEFAULT NULL,
2587 `naming_policy` varchar(255) DEFAULT NULL,
2588 `ecomp_generated_naming` char(1) DEFAULT NULL,
2589 `avail_zone_max_count` int(11) DEFAULT NULL,
2590 `nf_function` varchar(255) DEFAULT NULL,
2591 `nf_code` varchar(255) DEFAULT NULL,
2592 `nf_type` varchar(255) DEFAULT NULL,
2593 `nf_role` varchar(255) DEFAULT NULL,
2594 `vendor` varchar(255) DEFAULT NULL,
2595 `vendor_version` varchar(255) DEFAULT NULL,
2596 PRIMARY KEY (`customization_uuid`)
2597 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2598 /*!40101 SET character_set_client = @saved_cs_client */;
2601 -- Table structure for table `VF_MODULE_MODEL`
2604 DROP TABLE IF EXISTS `VF_MODULE_MODEL`;
2605 /*!40101 SET @saved_cs_client = @@character_set_client */;
2606 /*!40101 SET character_set_client = utf8 */;
2607 CREATE TABLE `VF_MODULE_MODEL` (
2608 `customization_uuid` varchar(255) NOT NULL,
2609 `model_yaml` longblob,
2610 `invariant_uuid` varchar(255) DEFAULT NULL,
2611 `uuid` varchar(255) DEFAULT NULL,
2612 `version` varchar(255) DEFAULT NULL,
2613 `vf_module_type` varchar(255) DEFAULT NULL,
2614 `availability_zone_count` int(11) DEFAULT NULL,
2615 `ecomp_generated_vm_assignments` char(1) DEFAULT NULL,
2616 PRIMARY KEY (`customization_uuid`)
2617 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2618 /*!40101 SET character_set_client = @saved_cs_client */;
2621 -- Table structure for table `VF_MODULE_TO_VFC_MAPPING`
2624 DROP TABLE IF EXISTS `VF_MODULE_TO_VFC_MAPPING`;
2625 /*!40101 SET @saved_cs_client = @@character_set_client */;
2626 /*!40101 SET character_set_client = utf8 */;
2627 CREATE TABLE `VF_MODULE_TO_VFC_MAPPING` (
2628 `seq` int(11) NOT NULL AUTO_INCREMENT,
2629 `vf_module_customization_uuid` varchar(255) NOT NULL,
2630 `vfc_customization_uuid` varchar(255) NOT NULL,
2631 `vm_type` varchar(255) NOT NULL,
2632 `vm_count` int(11) NOT NULL,
2633 PRIMARY KEY (`seq`),
2634 KEY `IX1_VF_MODULE_TO_VFC_MAPPING` (`vf_module_customization_uuid`)
2635 ) ENGINE=InnoDB AUTO_INCREMENT=1591 DEFAULT CHARSET=latin1;
2636 /*!40101 SET character_set_client = @saved_cs_client */;
2639 -- Table structure for table `VF_TO_NETWORK_ROLE_MAPPING`
2642 DROP TABLE IF EXISTS `VF_TO_NETWORK_ROLE_MAPPING`;
2643 /*!40101 SET @saved_cs_client = @@character_set_client */;
2644 /*!40101 SET character_set_client = utf8 */;
2645 CREATE TABLE `VF_TO_NETWORK_ROLE_MAPPING` (
2646 `seq` int(11) NOT NULL AUTO_INCREMENT,
2647 `vf_customization_uuid` varchar(255) NOT NULL,
2648 `network_role` varchar(255) NOT NULL,
2649 PRIMARY KEY (`seq`),
2650 KEY `IX1_VF_TO_NETWORK_ROLE_MAPPING` (`vf_customization_uuid`)
2651 ) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=latin1;
2652 /*!40101 SET character_set_client = @saved_cs_client */;
2655 -- Table structure for table `VIPR_CONFIGURATION`
2658 DROP TABLE IF EXISTS `VIPR_CONFIGURATION`;
2659 /*!40101 SET @saved_cs_client = @@character_set_client */;
2660 /*!40101 SET character_set_client = utf8 */;
2661 CREATE TABLE `VIPR_CONFIGURATION` (
2662 `seq` int(11) NOT NULL AUTO_INCREMENT,
2663 `serial_number` varchar(255) DEFAULT NULL,
2664 `vnf_id` varchar(255) DEFAULT NULL,
2665 `vnf_name` varchar(255) DEFAULT NULL,
2666 `ecomp_service_instance_id` varchar(255) DEFAULT NULL,
2667 `vm_name` varchar(255) DEFAULT NULL,
2668 `cloud_region_id` varchar(255) DEFAULT NULL,
2669 `cloud_owner` varchar(255) DEFAULT NULL,
2671 ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
2672 /*!40101 SET character_set_client = @saved_cs_client */;
2675 -- Table structure for table `VIPR_SZ_MANAGER_KEY`
2678 DROP TABLE IF EXISTS `VIPR_SZ_MANAGER_KEY`;
2679 /*!40101 SET @saved_cs_client = @@character_set_client */;
2680 /*!40101 SET character_set_client = utf8 */;
2681 CREATE TABLE `VIPR_SZ_MANAGER_KEY` (
2682 `vipr_sz_manager_ip_addr` varchar(40) NOT NULL,
2683 `vipr_sz_manager_state` varchar(10) DEFAULT NULL,
2684 `vipr_sz_manager_api_key` varchar(255) DEFAULT NULL,
2685 PRIMARY KEY (`vipr_sz_manager_ip_addr`)
2686 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2687 /*!40101 SET character_set_client = @saved_cs_client */;
2690 -- Table structure for table `VLAN_ID_POOL`
2693 DROP TABLE IF EXISTS `VLAN_ID_POOL`;
2694 /*!40101 SET @saved_cs_client = @@character_set_client */;
2695 /*!40101 SET character_set_client = utf8 */;
2696 CREATE TABLE `VLAN_ID_POOL` (
2697 `aic_site_id` varchar(100) NOT NULL,
2698 `purpose` varchar(40) NOT NULL,
2699 `status` varchar(40) NOT NULL,
2700 `vlan_id` int(4) NOT NULL,
2701 `svc_instance_id` varchar(80) DEFAULT NULL,
2702 `availability_zone` varchar(100) DEFAULT NULL,
2703 `vplspe_name` varchar(80) DEFAULT NULL,
2704 PRIMARY KEY (`vlan_id`,`aic_site_id`,`purpose`)
2705 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2706 /*!40101 SET character_set_client = @saved_cs_client */;
2709 -- Table structure for table `VLAN_L3INTERFACE_IPV4_ADDRESS`
2712 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV4_ADDRESS`;
2713 /*!40101 SET @saved_cs_client = @@character_set_client */;
2714 /*!40101 SET character_set_client = utf8 */;
2715 CREATE TABLE `VLAN_L3INTERFACE_IPV4_ADDRESS` (
2716 `vnf_id` varchar(80) NOT NULL,
2717 `interface_name` varchar(255) NOT NULL,
2718 `vlan_interface` varchar(255) NOT NULL,
2719 `l3_interface_ipv4_address` varchar(64) NOT NULL,
2720 `l3_interface_ipv4_prefix_length` varchar(45) DEFAULT NULL,
2721 `vlan_id_inner` varchar(45) DEFAULT NULL,
2722 `vlan_id_outer` varchar(45) DEFAULT NULL,
2723 `is_floating` varchar(1) DEFAULT NULL,
2724 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv4_address`),
2725 KEY `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`),
2726 CONSTRAINT `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN` FOREIGN KEY (`vnf_id`, `interface_name`, `vlan_interface`) REFERENCES `LINTERFACE_VLAN` (`vnf_id`, `interface_name`, `vlan_interface`) ON DELETE NO ACTION ON UPDATE NO ACTION
2727 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2728 /*!40101 SET character_set_client = @saved_cs_client */;
2731 -- Table structure for table `VLAN_L3INTERFACE_IPV6_ADDRESS`
2734 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV6_ADDRESS`;
2735 /*!40101 SET @saved_cs_client = @@character_set_client */;
2736 /*!40101 SET character_set_client = utf8 */;
2737 CREATE TABLE `VLAN_L3INTERFACE_IPV6_ADDRESS` (
2738 `vnf_id` varchar(80) NOT NULL,
2739 `interface_name` varchar(255) NOT NULL,
2740 `vlan_interface` varchar(255) NOT NULL,
2741 `l3_interface_ipv6_address` varchar(64) NOT NULL,
2742 `l3_interface_ipv6_prefix_length` varchar(45) DEFAULT NULL,
2743 `vlan_id_inner` varchar(45) DEFAULT NULL,
2744 `vlan_id_outer` varchar(45) DEFAULT NULL,
2745 `is_floating` varchar(1) DEFAULT NULL,
2746 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv6_address`),
2747 KEY `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`,`vlan_interface`),
2748 CONSTRAINT `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN` FOREIGN KEY (`vnf_id`, `interface_name`, `vlan_interface`) REFERENCES `LINTERFACE_VLAN` (`vnf_id`, `interface_name`, `vlan_interface`) ON DELETE NO ACTION ON UPDATE NO ACTION
2749 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2750 /*!40101 SET character_set_client = @saved_cs_client */;
2753 -- Table structure for table `VLAN_PLAN_ID`
2756 DROP TABLE IF EXISTS `VLAN_PLAN_ID`;
2757 /*!40101 SET @saved_cs_client = @@character_set_client */;
2758 /*!40101 SET character_set_client = utf8 */;
2759 CREATE TABLE `VLAN_PLAN_ID` (
2760 `plan_type` varchar(40) NOT NULL,
2761 `purpose` varchar(40) NOT NULL,
2762 `vlan_plan_id_count` int(4) NOT NULL,
2763 PRIMARY KEY (`vlan_plan_id_count`,`plan_type`,`purpose`)
2764 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2765 /*!40101 SET character_set_client = @saved_cs_client */;
2768 -- Table structure for table `VLAN_POOL`
2771 DROP TABLE IF EXISTS `VLAN_POOL`;
2772 /*!40101 SET @saved_cs_client = @@character_set_client */;
2773 /*!40101 SET character_set_client = utf8 */;
2774 CREATE TABLE `VLAN_POOL` (
2775 `aic_site_id` varchar(100) NOT NULL,
2776 `availability_zone` varchar(100) NOT NULL,
2777 `vlan_plan_id` varchar(100) NOT NULL,
2778 `plan_type` varchar(40) NOT NULL,
2779 `purpose` varchar(40) NOT NULL,
2780 `vlan_id` int(4) NOT NULL,
2781 `status` varchar(40) NOT NULL,
2782 `reserved_id` varchar(80) DEFAULT NULL,
2783 PRIMARY KEY (`aic_site_id`,`availability_zone`,`vlan_plan_id`,`plan_type`,`purpose`,`vlan_id`)
2784 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2785 /*!40101 SET character_set_client = @saved_cs_client */;
2788 -- Table structure for table `VLAN_RANGES`
2791 DROP TABLE IF EXISTS `VLAN_RANGES`;
2792 /*!40101 SET @saved_cs_client = @@character_set_client */;
2793 /*!40101 SET character_set_client = utf8 */;
2794 CREATE TABLE `VLAN_RANGES` (
2795 `vlan_plan_id` varchar(100) NOT NULL,
2796 `plan_type` varchar(40) NOT NULL,
2797 `purpose` varchar(40) NOT NULL,
2798 `range_start` int(4) NOT NULL,
2799 `range_end` int(4) NOT NULL,
2800 `generated` char(1) DEFAULT NULL,
2801 PRIMARY KEY (`vlan_plan_id`,`plan_type`,`purpose`,`range_start`,`range_end`)
2802 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2803 /*!40101 SET character_set_client = @saved_cs_client */;
2806 -- Table structure for table `VM_NAME_INDEX`
2809 DROP TABLE IF EXISTS `VM_NAME_INDEX`;
2810 /*!40101 SET @saved_cs_client = @@character_set_client */;
2811 /*!40101 SET character_set_client = utf8 */;
2812 CREATE TABLE `VM_NAME_INDEX` (
2813 `vm_name_prefix` varchar(255) NOT NULL,
2814 `index_number` int(11) NOT NULL,
2815 PRIMARY KEY (`vm_name_prefix`)
2816 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2817 /*!40101 SET character_set_client = @saved_cs_client */;
2820 -- Table structure for table `VM_NETWORKS`
2823 DROP TABLE IF EXISTS `VM_NETWORKS`;
2824 /*!40101 SET @saved_cs_client = @@character_set_client */;
2825 /*!40101 SET character_set_client = utf8 */;
2826 CREATE TABLE `VM_NETWORKS` (
2827 `vnf_type` varchar(200) NOT NULL,
2828 `vm_type` varchar(45) NOT NULL,
2829 `network_role` varchar(45) NOT NULL,
2830 `assign_ips` tinyint(1) NOT NULL,
2831 `assign_macs` tinyint(1) NOT NULL,
2832 `assign_floating_ip` tinyint(1) NOT NULL,
2833 `ip_count` int(11) DEFAULT NULL,
2834 PRIMARY KEY (`vnf_type`,`vm_type`,`network_role`)
2835 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2836 /*!40101 SET character_set_client = @saved_cs_client */;
2839 -- Table structure for table `VM_PROFILE`
2842 DROP TABLE IF EXISTS `VM_PROFILE`;
2843 /*!40101 SET @saved_cs_client = @@character_set_client */;
2844 /*!40101 SET character_set_client = utf8 */;
2845 CREATE TABLE `VM_PROFILE` (
2846 `vnf_type` varchar(200) NOT NULL,
2847 `vm_type` varchar(45) NOT NULL,
2848 `vm_count` int(11) NOT NULL,
2849 PRIMARY KEY (`vnf_type`,`vm_type`)
2850 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2851 /*!40101 SET character_set_client = @saved_cs_client */;
2854 -- Table structure for table `VNF`
2857 DROP TABLE IF EXISTS `VNF`;
2858 /*!40101 SET @saved_cs_client = @@character_set_client */;
2859 /*!40101 SET character_set_client = utf8 */;
2860 CREATE TABLE `VNF` (
2861 `vnf_id` varchar(80) NOT NULL,
2862 `vnf_name` varchar(80) NOT NULL,
2863 `vnf_type` varchar(10) NOT NULL,
2864 `orchestration_status` varchar(20) DEFAULT NULL,
2865 `heat_stack_id` varchar(80) DEFAULT NULL,
2866 `mso_catalog_key` varchar(80) DEFAULT NULL,
2867 `availability_zone` varchar(80) DEFAULT NULL,
2868 `aic_site_id` varchar(80) DEFAULT NULL,
2869 `oam_ipv4_address` varchar(20) DEFAULT NULL,
2870 `vnf_name2` varchar(80) DEFAULT NULL,
2871 `vpe_id` varchar(80) NOT NULL,
2872 `ipv4_loopback0_address` varchar(80) DEFAULT NULL,
2873 `license_key` varchar(256) DEFAULT NULL,
2874 `entitlement_resource_uuid` varchar(256) DEFAULT NULL,
2875 PRIMARY KEY (`vnf_id`)
2876 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2877 /*!40101 SET character_set_client = @saved_cs_client */;
2880 -- Table structure for table `VNFC_DG_MAPPING`
2883 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
2884 /*!40101 SET @saved_cs_client = @@character_set_client */;
2885 /*!40101 SET character_set_client = utf8 */;
2886 CREATE TABLE `VNFC_DG_MAPPING` (
2887 `vnfc_dg_mapping_id` int(11) NOT NULL AUTO_INCREMENT,
2888 `action` varchar(50) DEFAULT NULL,
2889 `api_version` varchar(10) DEFAULT NULL,
2890 `vnf_type` varchar(50) DEFAULT NULL,
2891 `vnfc_type` varchar(50) DEFAULT NULL,
2892 `dg_name` varchar(50) NOT NULL,
2893 `dg_version` varchar(50) DEFAULT NULL,
2894 `dg_module` varchar(50) NOT NULL,
2895 PRIMARY KEY (`vnfc_dg_mapping_id`),
2896 UNIQUE KEY `input_constraint` (`action`,`api_version`,`vnf_type`,`vnfc_type`)
2897 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2898 /*!40101 SET character_set_client = @saved_cs_client */;
2901 -- Table structure for table `VNFC_REFERENCE`
2904 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
2905 /*!40101 SET @saved_cs_client = @@character_set_client */;
2906 /*!40101 SET character_set_client = utf8 */;
2907 CREATE TABLE `VNFC_REFERENCE` (
2908 `vnfc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
2909 `action` varchar(50) NOT NULL,
2910 `vnf_type` varchar(50) NOT NULL,
2911 `vm_instance` int(11) NOT NULL,
2912 `vnfc_instance` int(11) NOT NULL,
2913 `vnfc_type` varchar(50) NOT NULL,
2914 `vnfc_function_code` varchar(50) NOT NULL,
2915 `ipaddress_v4_oam_vip` varchar(50) DEFAULT NULL,
2916 `group_notation_type` varchar(50) DEFAULT NULL,
2917 `group_notation_value` varchar(50) DEFAULT NULL,
2918 PRIMARY KEY (`vnfc_reference_id`),
2919 UNIQUE KEY `vnfc_reference_id` (`vnfc_reference_id`)
2920 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2921 /*!40101 SET character_set_client = @saved_cs_client */;
2924 -- Table structure for table `VNF_IMAGE`
2927 DROP TABLE IF EXISTS `VNF_IMAGE`;
2928 /*!40101 SET @saved_cs_client = @@character_set_client */;
2929 /*!40101 SET character_set_client = utf8 */;
2930 CREATE TABLE `VNF_IMAGE` (
2931 `application_vendor` varchar(255) NOT NULL,
2932 `application_version` varchar(255) NOT NULL,
2933 `att_uuid` varchar(255) NOT NULL,
2934 `application` varchar(255) DEFAULT NULL,
2935 `selflink` varchar(255) DEFAULT NULL,
2936 PRIMARY KEY (`application_vendor`,`application_version`,`att_uuid`)
2937 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2938 /*!40101 SET character_set_client = @saved_cs_client */;
2941 -- Table structure for table `VNF_MODEL_LICENSES`
2944 DROP TABLE IF EXISTS `VNF_MODEL_LICENSES`;
2945 /*!40101 SET @saved_cs_client = @@character_set_client */;
2946 /*!40101 SET character_set_client = utf8 */;
2947 CREATE TABLE `VNF_MODEL_LICENSES` (
2948 `att_part_number` varchar(255) NOT NULL,
2949 `license_assignment_group` varchar(255) NOT NULL,
2950 `license_required` tinyint(1) DEFAULT NULL,
2951 `entitlement_assignment_group` varchar(255) DEFAULT NULL,
2952 `entitlement_required` tinyint(1) DEFAULT '0',
2953 `feature_group_uuid` varchar(255) DEFAULT NULL,
2954 PRIMARY KEY (`att_part_number`,`license_assignment_group`)
2955 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2956 /*!40101 SET character_set_client = @saved_cs_client */;
2959 -- Table structure for table `VNF_MODEL_LICENSE_FEATURES`
2962 DROP TABLE IF EXISTS `VNF_MODEL_LICENSE_FEATURES`;
2963 /*!40101 SET @saved_cs_client = @@character_set_client */;
2964 /*!40101 SET character_set_client = utf8 */;
2965 CREATE TABLE `VNF_MODEL_LICENSE_FEATURES` (
2966 `att_part_number` varchar(255) NOT NULL,
2967 `license_assignment_group` varchar(255) NOT NULL,
2968 `feature` varchar(255) NOT NULL,
2969 PRIMARY KEY (`att_part_number`,`license_assignment_group`,`feature`)
2970 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2971 /*!40101 SET character_set_client = @saved_cs_client */;
2974 -- Table structure for table `VNF_NAME_INDEX`
2977 DROP TABLE IF EXISTS `VNF_NAME_INDEX`;
2978 /*!40101 SET @saved_cs_client = @@character_set_client */;
2979 /*!40101 SET character_set_client = utf8 */;
2980 CREATE TABLE `VNF_NAME_INDEX` (
2981 `vnf_name_prefix` varchar(255) NOT NULL,
2982 `index_number` int(11) NOT NULL,
2983 PRIMARY KEY (`vnf_name_prefix`)
2984 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2985 /*!40101 SET character_set_client = @saved_cs_client */;
2988 -- Table structure for table `VNF_NETWORKS`
2991 DROP TABLE IF EXISTS `VNF_NETWORKS`;
2992 /*!40101 SET @saved_cs_client = @@character_set_client */;
2993 /*!40101 SET character_set_client = utf8 */;
2994 CREATE TABLE `VNF_NETWORKS` (
2995 `vnf_type` varchar(200) NOT NULL,
2996 `network_role` varchar(45) NOT NULL,
2997 PRIMARY KEY (`vnf_type`,`network_role`)
2998 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2999 /*!40101 SET character_set_client = @saved_cs_client */;
3002 -- Table structure for table `VNF_NETWORK_CONNECTION`
3005 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION`;
3006 /*!40101 SET @saved_cs_client = @@character_set_client */;
3007 /*!40101 SET character_set_client = utf8 */;
3008 CREATE TABLE `VNF_NETWORK_CONNECTION` (
3009 `connection_uuid` varchar(80) NOT NULL,
3010 `vnf_id` varchar(80) NOT NULL,
3011 `connection_id` varchar(80) DEFAULT NULL,
3012 `connection_type` varchar(20) DEFAULT NULL,
3013 `neutron_network_id` varchar(80) DEFAULT NULL,
3014 `neutron_network_name` varchar(80) DEFAULT NULL,
3015 `orchestration_status` varchar(20) DEFAULT NULL,
3016 `switch_id` varchar(40) DEFAULT NULL,
3017 `heat_stack_id` varchar(80) DEFAULT NULL,
3018 `mso_catalog_key` varchar(80) DEFAULT NULL,
3019 `provider_network` varchar(80) DEFAULT NULL,
3020 `port_group_id` varchar(80) DEFAULT NULL,
3021 `port_group_name` varchar(80) DEFAULT NULL,
3022 PRIMARY KEY (`connection_uuid`)
3023 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3024 /*!40101 SET character_set_client = @saved_cs_client */;
3027 -- Table structure for table `VNF_NETWORK_CONNECTION_VLAN`
3030 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION_VLAN`;
3031 /*!40101 SET @saved_cs_client = @@character_set_client */;
3032 /*!40101 SET character_set_client = utf8 */;
3033 CREATE TABLE `VNF_NETWORK_CONNECTION_VLAN` (
3034 `vlan_uuid` varchar(80) NOT NULL,
3035 `vlan_id` int(4) NOT NULL,
3036 `vlan_type` varchar(5) NOT NULL,
3037 `connection_uuid` varchar(80) DEFAULT NULL,
3038 PRIMARY KEY (`vlan_uuid`)
3039 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3040 /*!40101 SET character_set_client = @saved_cs_client */;
3043 -- Table structure for table `VNF_PROFILE`
3046 DROP TABLE IF EXISTS `VNF_PROFILE`;
3047 /*!40101 SET @saved_cs_client = @@character_set_client */;
3048 /*!40101 SET character_set_client = utf8 */;
3049 CREATE TABLE `VNF_PROFILE` (
3050 `vnf_type` varchar(200) NOT NULL,
3051 `availability_zone_count` int(11) NOT NULL,
3052 `equipment_role` varchar(80) NOT NULL,
3053 PRIMARY KEY (`vnf_type`)
3054 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3055 /*!40101 SET character_set_client = @saved_cs_client */;
3058 -- Table structure for table `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`
3061 DROP TABLE IF EXISTS `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`;
3062 /*!40101 SET @saved_cs_client = @@character_set_client */;
3063 /*!40101 SET character_set_client = utf8 */;
3064 CREATE TABLE `VNF_SERVICE_TO_NETWORK_ROLE_FILTER` (
3065 `vnf_service_type` varchar(60) NOT NULL,
3066 `network_role_filter` varchar(60) NOT NULL,
3067 PRIMARY KEY (`vnf_service_type`,`network_role_filter`)
3068 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3069 /*!40101 SET character_set_client = @saved_cs_client */;
3072 -- Table structure for table `VPE_LOCK`
3075 DROP TABLE IF EXISTS `VPE_LOCK`;
3076 /*!40101 SET @saved_cs_client = @@character_set_client */;
3077 /*!40101 SET character_set_client = utf8 */;
3078 CREATE TABLE `VPE_LOCK` (
3079 `vpe_name` varchar(20) NOT NULL,
3080 `vpn_lock` varchar(20) NOT NULL,
3081 PRIMARY KEY (`vpe_name`)
3082 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3083 /*!40101 SET character_set_client = @saved_cs_client */;
3086 -- Table structure for table `VPE_MAC_ADDRESS_POOL`
3089 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_POOL`;
3090 /*!40101 SET @saved_cs_client = @@character_set_client */;
3091 /*!40101 SET character_set_client = utf8 */;
3092 CREATE TABLE `VPE_MAC_ADDRESS_POOL` (
3093 `id` int(11) NOT NULL,
3094 `mac_address` varchar(50) NOT NULL,
3095 `sw_name` varchar(30) NOT NULL,
3097 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3098 /*!40101 SET character_set_client = @saved_cs_client */;
3101 -- Table structure for table `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`
3104 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`;
3105 /*!40101 SET @saved_cs_client = @@character_set_client */;
3106 /*!40101 SET character_set_client = utf8 */;
3107 CREATE TABLE `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING` (
3108 `id` int(11) NOT NULL,
3109 `hostname` varchar(50) NOT NULL,
3110 `assigned_user` varchar(25) NOT NULL,
3111 `assigned_date` date DEFAULT NULL,
3113 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3114 /*!40101 SET character_set_client = @saved_cs_client */;
3117 -- Table structure for table `VPE_POOL`
3120 DROP TABLE IF EXISTS `VPE_POOL`;
3121 /*!40101 SET @saved_cs_client = @@character_set_client */;
3122 /*!40101 SET character_set_client = utf8 */;
3123 CREATE TABLE `VPE_POOL` (
3124 `vpe_name` varchar(20) NOT NULL,
3125 `ipv4_oam_address` varchar(20) NOT NULL,
3126 `loopback0_ipv4_address` varchar(20) NOT NULL,
3127 `provisioning_status` varchar(10) NOT NULL,
3128 `aic_site_id` varchar(100) NOT NULL,
3129 `availability_zone` varchar(100) NOT NULL,
3130 `vlan_id_outer` varchar(20) NOT NULL,
3131 `vendor` varchar(20) NOT NULL,
3132 `physical_intf_name` varchar(40) NOT NULL,
3133 `physical_intf_speed` varchar(20) NOT NULL,
3134 `physical_intf_units` varchar(20) NOT NULL,
3135 `vpe_uuid` varchar(80) DEFAULT NULL,
3136 `vpe_id` varchar(80) NOT NULL,
3137 `image_filename` varchar(100) DEFAULT NULL,
3138 `as_number` varchar(20) NOT NULL,
3139 `loopback5000` varchar(16) DEFAULT NULL,
3140 `loopback10` varchar(16) DEFAULT NULL,
3141 `aic_version` varchar(50) DEFAULT NULL,
3142 `vpe_capacity` int(11) NOT NULL,
3143 PRIMARY KEY (`aic_site_id`,`vpe_name`,`availability_zone`)
3144 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3145 /*!40101 SET character_set_client = @saved_cs_client */;
3148 -- Table structure for table `VPLSPE_POOL`
3151 DROP TABLE IF EXISTS `VPLSPE_POOL`;
3152 /*!40101 SET @saved_cs_client = @@character_set_client */;
3153 /*!40101 SET character_set_client = utf8 */;
3154 CREATE TABLE `VPLSPE_POOL` (
3155 `vplspe_name` varchar(20) NOT NULL,
3156 `aic_site_id` varchar(100) NOT NULL,
3157 `availability_zone` varchar(100) NOT NULL,
3158 `physical_intf_name` varchar(40) NOT NULL,
3159 `physical_intf_speed` varchar(20) NOT NULL,
3160 `physical_intf_units` varchar(20) NOT NULL,
3161 `loopback0_ipv4_address` varchar(20) NOT NULL,
3162 `vlan_id_outer` varchar(20) NOT NULL,
3163 `vplspe_uuid` varchar(80) DEFAULT NULL,
3164 `image_filename` varchar(100) DEFAULT NULL,
3165 `provisioning_status` varchar(10) DEFAULT NULL,
3166 `vendor` varchar(20) DEFAULT NULL,
3167 PRIMARY KEY (`vplspe_name`,`aic_site_id`,`availability_zone`,`physical_intf_name`)
3168 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3169 /*!40101 SET character_set_client = @saved_cs_client */;
3172 -- Table structure for table `VPN_BINDINGS`
3175 DROP TABLE IF EXISTS `VPN_BINDINGS`;
3176 /*!40101 SET @saved_cs_client = @@character_set_client */;
3177 /*!40101 SET character_set_client = utf8 */;
3178 CREATE TABLE `VPN_BINDINGS` (
3179 `network_customization_uuid` varchar(255) NOT NULL,
3180 `binding_uuid` varchar(255) NOT NULL,
3181 PRIMARY KEY (`network_customization_uuid`,`binding_uuid`)
3182 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3183 /*!40101 SET character_set_client = @saved_cs_client */;
3186 -- Table structure for table `VRR_FUNCTION_CODE_VMTYPE_MAPPING`
3189 DROP TABLE IF EXISTS `VRR_FUNCTION_CODE_VMTYPE_MAPPING`;
3190 /*!40101 SET @saved_cs_client = @@character_set_client */;
3191 /*!40101 SET character_set_client = utf8 */;
3192 CREATE TABLE `VRR_FUNCTION_CODE_VMTYPE_MAPPING` (
3193 `ptnii_function_code` varchar(128) NOT NULL,
3194 `vm_type` varchar(128) NOT NULL,
3195 PRIMARY KEY (`ptnii_function_code`,`vm_type`)
3196 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3197 /*!40101 SET character_set_client = @saved_cs_client */;
3200 -- Table structure for table `VSERVER`
3203 DROP TABLE IF EXISTS `VSERVER`;
3204 /*!40101 SET @saved_cs_client = @@character_set_client */;
3205 /*!40101 SET character_set_client = utf8 */;
3206 CREATE TABLE `VSERVER` (
3207 `tenant_id` varchar(40) NOT NULL,
3208 `vserver_id` varchar(40) NOT NULL,
3209 `aic_site_id` varchar(100) NOT NULL,
3210 `vendor` varchar(20) NOT NULL,
3211 `image_name` varchar(100) NOT NULL,
3212 `vnf_type` varchar(10) NOT NULL,
3213 `vnf_id` varchar(80) NOT NULL,
3214 PRIMARY KEY (`tenant_id`,`vserver_id`)
3215 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3216 /*!40101 SET character_set_client = @saved_cs_client */;
3219 -- Table structure for table `VSERVER2`
3222 DROP TABLE IF EXISTS `VSERVER2`;
3223 /*!40101 SET @saved_cs_client = @@character_set_client */;
3224 /*!40101 SET character_set_client = utf8 */;
3225 CREATE TABLE `VSERVER2` (
3226 `tenant_id` varchar(255) NOT NULL,
3227 `vserver_id` varchar(128) NOT NULL,
3228 `vserver_name` varchar(255) NOT NULL,
3229 `vserver_name2` varchar(255) DEFAULT NULL,
3230 `prov_status` varchar(20) DEFAULT NULL,
3231 `selflink` varchar(255) DEFAULT NULL,
3232 PRIMARY KEY (`tenant_id`,`vserver_id`)
3233 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3234 /*!40101 SET character_set_client = @saved_cs_client */;
3237 -- Table structure for table `VSERVER_PSERVER`
3240 DROP TABLE IF EXISTS `VSERVER_PSERVER`;
3241 /*!40101 SET @saved_cs_client = @@character_set_client */;
3242 /*!40101 SET character_set_client = utf8 */;
3243 CREATE TABLE `VSERVER_PSERVER` (
3244 `vserver_id` varchar(128) NOT NULL,
3245 `pserver_hostname` varchar(255) DEFAULT NULL,
3246 PRIMARY KEY (`vserver_id`)
3247 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3248 /*!40101 SET character_set_client = @saved_cs_client */;
3251 -- Table structure for table `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`
3254 DROP TABLE IF EXISTS `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`;
3255 /*!40101 SET @saved_cs_client = @@character_set_client */;
3256 /*!40101 SET character_set_client = utf8 */;
3257 CREATE TABLE `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING` (
3258 `key_id` varchar(128) NOT NULL,
3259 `cloud_region` varchar(128) NOT NULL,
3260 `key_type` varchar(128) NOT NULL,
3261 PRIMARY KEY (`key_id`,`cloud_region`,`key_type`)
3262 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3263 /*!40101 SET character_set_client = @saved_cs_client */;
3266 -- Table structure for table `WAN_COMBO_ALLOWABLE`
3269 DROP TABLE IF EXISTS `WAN_COMBO_ALLOWABLE`;
3270 /*!40101 SET @saved_cs_client = @@character_set_client */;
3271 /*!40101 SET character_set_client = utf8 */;
3272 CREATE TABLE `WAN_COMBO_ALLOWABLE` (
3273 `combo_sequence` int(11) NOT NULL AUTO_INCREMENT,
3274 `topology` varchar(16) DEFAULT 'unknown',
3275 `internet_topology` varchar(20) DEFAULT NULL,
3276 `wan1` varchar(40) DEFAULT NULL,
3277 `wan2` varchar(40) DEFAULT NULL,
3278 `new_start_release_flexware` varchar(16) DEFAULT 'unknown',
3279 `is_active_flexware` varchar(1) DEFAULT 'N',
3280 `new_start_release_dhv` varchar(16) DEFAULT 'unknown',
3281 `is_active_dhv` varchar(1) DEFAULT 'N',
3282 `ucpe_type` varchar(32) DEFAULT 'stand-alone',
3283 `description` varchar(128) NOT NULL,
3284 PRIMARY KEY (`combo_sequence`),
3285 UNIQUE KEY `IX1_WAN_COMBO_ALLOWABLE` (`internet_topology`,`wan1`,`wan2`)
3286 ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
3287 /*!40101 SET character_set_client = @saved_cs_client */;
3289 DROP TABLE IF EXISTS `DHCP_MAP`;
3290 /*!40101 SET @saved_cs_client = @@character_set_client */;
3291 /*!40101 SET character_set_client = utf8 */;
3292 CREATE TABLE `DHCP_MAP` (
3293 `mac_addr` varchar(128) NOT NULL,
3294 `ip_addr` varchar(128) DEFAULT NULL,
3295 PRIMARY KEY (`mac_addr`)
3296 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3298 /*!40101 SET character_set_client = @saved_cs_client */;
3299 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3301 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3302 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3303 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3304 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3305 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3306 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3307 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3309 -- Dump completed on 2017-10-04 18:23:01