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` int(4) 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 `aic_site_id` varchar(100) DEFAULT NULL,
115 `vendor_code` varchar(1) NOT NULL,
116 `virtual_device_type` varchar(2) DEFAULT NULL,
117 `device_sequence` varchar(3) NOT NULL,
118 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
119 PRIMARY KEY (`hostname`),
120 UNIQUE KEY `hostname` (`hostname`),
121 KEY `IN1_AIC_HOSTNAME` (`cust_id`),
122 CONSTRAINT `AC1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
123 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124 /*!40101 SET character_set_client = @saved_cs_client */;
127 -- Table structure for table `AIC_NETWORK`
130 DROP TABLE IF EXISTS `AIC_NETWORK`;
131 /*!40101 SET @saved_cs_client = @@character_set_client */;
132 /*!40101 SET character_set_client = utf8 */;
133 CREATE TABLE `AIC_NETWORK` (
134 `network_id` varchar(100) NOT NULL,
135 `network_name` varchar(100) DEFAULT NULL,
136 `status` varchar(20) DEFAULT NULL,
137 `tenant_id` varchar(100) DEFAULT NULL,
138 `switch_uuid` varchar(100) DEFAULT NULL,
139 `portgroup_name` varchar(100) DEFAULT NULL,
140 `portgroup_id` varchar(100) DEFAULT NULL,
141 PRIMARY KEY (`network_id`)
142 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
143 /*!40101 SET character_set_client = @saved_cs_client */;
146 -- Table structure for table `AIC_SITE`
149 DROP TABLE IF EXISTS `AIC_SITE`;
150 /*!40101 SET @saved_cs_client = @@character_set_client */;
151 /*!40101 SET character_set_client = utf8 */;
152 CREATE TABLE `AIC_SITE` (
153 `name` varchar(100) DEFAULT NULL,
154 `aic_site_id` varchar(100) NOT NULL,
155 `vcenter_url` varchar(200) DEFAULT NULL,
156 `vcenter_username` varchar(40) DEFAULT NULL,
157 `vcenter_passwd` varbinary(255) DEFAULT NULL,
158 `city` varchar(100) DEFAULT NULL,
159 `state` varchar(2) DEFAULT NULL,
160 `operational_status` varchar(20) DEFAULT NULL,
161 `oam_gateway_addr` varchar(20) DEFAULT '',
162 PRIMARY KEY (`aic_site_id`)
163 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
164 /*!40101 SET character_set_client = @saved_cs_client */;
167 -- Table structure for table `AIC_SWITCH`
170 DROP TABLE IF EXISTS `AIC_SWITCH`;
171 /*!40101 SET @saved_cs_client = @@character_set_client */;
172 /*!40101 SET character_set_client = utf8 */;
173 CREATE TABLE `AIC_SWITCH` (
174 `switch_name` varchar(100) DEFAULT NULL,
175 `physical_network_name` varchar(100) NOT NULL,
176 `aic_site_id` varchar(100) DEFAULT NULL,
177 `uuid` varchar(100) DEFAULT NULL,
178 `availability_zone` varchar(100) DEFAULT NULL,
179 PRIMARY KEY (`physical_network_name`)
180 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
181 /*!40101 SET character_set_client = @saved_cs_client */;
184 -- Table structure for table `AIC_ZONE_CLOUD_REGION_ID`
187 DROP TABLE IF EXISTS `AIC_ZONE_CLOUD_REGION_ID`;
188 /*!40101 SET @saved_cs_client = @@character_set_client */;
189 /*!40101 SET character_set_client = utf8 */;
190 CREATE TABLE `AIC_ZONE_CLOUD_REGION_ID` (
191 `zone_region_id` varchar(255) NOT NULL,
192 `cilli_code` varchar(255) NOT NULL,
193 `location_id` varchar(255) NOT NULL DEFAULT '',
194 `city_state_country` varchar(255) NOT NULL DEFAULT '',
195 PRIMARY KEY (`zone_region_id`,`cilli_code`,`location_id`,`city_state_country`)
196 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
197 /*!40101 SET character_set_client = @saved_cs_client */;
200 -- Table structure for table `ALLOCATION_ITEM`
203 DROP TABLE IF EXISTS `ALLOCATION_ITEM`;
204 /*!40101 SET @saved_cs_client = @@character_set_client */;
205 /*!40101 SET character_set_client = utf8 */;
206 CREATE TABLE `ALLOCATION_ITEM` (
207 `allocation_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
208 `resource_id` bigint(20) NOT NULL,
209 `application_id` varchar(50) NOT NULL,
210 `resource_set_id` varchar(200) NOT NULL,
211 `resource_union_id` varchar(200) NOT NULL,
212 `resource_share_group_list` varchar(200) DEFAULT NULL,
213 `lt_used` bigint(20) DEFAULT NULL,
214 `ll_label` varchar(50) DEFAULT NULL,
215 `rr_used` varchar(200) DEFAULT NULL,
216 `allocation_time` datetime NOT NULL,
217 PRIMARY KEY (`allocation_item_id`),
218 UNIQUE KEY `allocation_item_id` (`allocation_item_id`),
219 UNIQUE KEY `IX2_ALLOCATION_ITEM` (`resource_id`,`resource_set_id`),
220 KEY `IX1_ALLOCATION_ITEM` (`resource_id`)
221 ) ENGINE=InnoDB AUTO_INCREMENT=5764 DEFAULT CHARSET=latin1;
222 /*!40101 SET character_set_client = @saved_cs_client */;
225 -- Table structure for table `ALLOTTED_RESOURCE_MODEL`
228 DROP TABLE IF EXISTS `ALLOTTED_RESOURCE_MODEL`;
229 /*!40101 SET @saved_cs_client = @@character_set_client */;
230 /*!40101 SET character_set_client = utf8 */;
231 CREATE TABLE `ALLOTTED_RESOURCE_MODEL` (
232 `customization_uuid` varchar(255) NOT NULL,
233 `model_yaml` longblob,
234 `invariant_uuid` varchar(255) DEFAULT NULL,
235 `uuid` varchar(255) DEFAULT NULL,
236 `version` varchar(255) DEFAULT NULL,
237 `naming_policy` varchar(255) DEFAULT NULL,
238 `ecomp_generated_naming` char(1) DEFAULT NULL,
239 `depending_service` varchar(255) DEFAULT NULL,
240 `role` varchar(255) DEFAULT NULL,
241 `type` varchar(255) DEFAULT NULL,
242 `service_dependency` varchar(255) DEFAULT NULL,
243 `allotted_resource_type` varchar(255) DEFAULT NULL,
244 PRIMARY KEY (`customization_uuid`)
245 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
246 /*!40101 SET character_set_client = @saved_cs_client */;
249 -- Table structure for table `ALTS_CREDENTIALS`
252 DROP TABLE IF EXISTS `ALTS_CREDENTIALS`;
253 /*!40101 SET @saved_cs_client = @@character_set_client */;
254 /*!40101 SET character_set_client = utf8 */;
255 CREATE TABLE `ALTS_CREDENTIALS` (
256 `alts_username` varchar(255) NOT NULL,
257 `alts_password` varbinary(255) NOT NULL,
258 PRIMARY KEY (`alts_username`)
259 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
260 /*!40101 SET character_set_client = @saved_cs_client */;
263 -- Table structure for table `ASDC_ARTIFACTS`
266 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
267 /*!40101 SET @saved_cs_client = @@character_set_client */;
268 /*!40101 SET character_set_client = utf8 */;
269 CREATE TABLE `ASDC_ARTIFACTS` (
270 `asdc_artifacts_id` int(11) NOT NULL AUTO_INCREMENT,
271 `service_uuid` varchar(50) DEFAULT NULL,
272 `distribution_id` varchar(50) DEFAULT NULL,
273 `service_name` varchar(255) DEFAULT NULL,
274 `service_description` varchar(255) DEFAULT NULL,
275 `resource_uuid` varchar(255) DEFAULT NULL,
276 `resource_instance_name` varchar(255) DEFAULT NULL,
277 `resource_name` varchar(255) DEFAULT NULL,
278 `resource_version` varchar(50) DEFAULT NULL,
279 `resource_type` varchar(50) DEFAULT NULL,
280 `artifact_uuid` varchar(50) DEFAULT NULL,
281 `artifact_type` varchar(50) DEFAULT NULL,
282 `artifact_version` varchar(25) DEFAULT NULL,
283 `artifact_description` varchar(255) DEFAULT NULL,
284 `internal_version` int(11) DEFAULT NULL,
285 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
286 `artifact_name` varchar(255) DEFAULT NULL,
287 `artifact_content` longtext,
288 PRIMARY KEY (`asdc_artifacts_id`),
289 UNIQUE KEY `asdc_artifacts_id` (`asdc_artifacts_id`)
290 ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
291 /*!40101 SET character_set_client = @saved_cs_client */;
294 -- Table structure for table `ASDC_REFERENCE`
297 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
298 /*!40101 SET @saved_cs_client = @@character_set_client */;
299 /*!40101 SET character_set_client = utf8 */;
300 CREATE TABLE `ASDC_REFERENCE` (
301 `asdc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
302 `service_type` varchar(50) DEFAULT NULL,
303 `vnf_type` varchar(50) DEFAULT NULL,
304 `vnfc_type` varchar(50) DEFAULT NULL,
305 `file_category` varchar(50) DEFAULT NULL,
306 `action` varchar(50) DEFAULT NULL,
307 `artifact_type` varchar(50) DEFAULT NULL,
308 `artifact_name` varchar(255) NOT NULL,
309 PRIMARY KEY (`asdc_reference_id`),
310 UNIQUE KEY `asdc_reference_id` (`asdc_reference_id`)
311 ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
312 /*!40101 SET character_set_client = @saved_cs_client */;
316 -- Table structure for table `BLOB_TEST`
319 DROP TABLE IF EXISTS `BLOB_TEST`;
320 /*!40101 SET @saved_cs_client = @@character_set_client */;
321 /*!40101 SET character_set_client = utf8 */;
322 CREATE TABLE `BLOB_TEST` (
323 `seq` int(11) NOT NULL AUTO_INCREMENT,
324 `odl` varchar(20) DEFAULT NULL,
325 `communities` mediumblob,
326 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
327 `retry_count` int(11) DEFAULT '-1',
329 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
330 /*!40101 SET character_set_client = @saved_cs_client */;
333 -- Table structure for table `CAPABILITY`
336 DROP TABLE IF EXISTS `CAPABILITY`;
337 /*!40101 SET @saved_cs_client = @@character_set_client */;
338 /*!40101 SET character_set_client = utf8 */;
339 CREATE TABLE `CAPABILITY` (
340 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
341 `capability_name` varchar(50) NOT NULL,
342 `implementation_name` varchar(100) NOT NULL,
343 `operation_name` varchar(50) NOT NULL,
344 `operation_description` varchar(100) NOT NULL,
345 `input_definition` longtext,
346 `output_definition` longtext,
347 `dependency_definition` longtext,
348 `tags` varchar(100) DEFAULT NULL,
349 PRIMARY KEY (`capability_id`),
350 UNIQUE KEY `capability_id` (`capability_name`)
351 ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;
352 /*!40101 SET character_set_client = @saved_cs_client */;
355 -- Table structure for table `CITY_CODE`
358 DROP TABLE IF EXISTS `CITY_CODE`;
359 /*!40101 SET @saved_cs_client = @@character_set_client */;
360 /*!40101 SET character_set_client = utf8 */;
361 CREATE TABLE `CITY_CODE` (
362 `city_code_id` int(11) NOT NULL AUTO_INCREMENT,
363 `city_code` varchar(3) NOT NULL,
364 `city` varchar(150) NOT NULL,
365 `state` varchar(10) NOT NULL,
366 `country_code` varchar(10) NOT NULL,
367 PRIMARY KEY (`city_code_id`),
368 KEY `IN1_CITY_CODE` (`city`,`state`,`country_code`)
369 ) ENGINE=InnoDB AUTO_INCREMENT=37822 DEFAULT CHARSET=latin1;
370 /*!40101 SET character_set_client = @saved_cs_client */;
373 -- Table structure for table `CLI_UPDATES`
376 DROP TABLE IF EXISTS `CLI_UPDATES`;
377 /*!40101 SET @saved_cs_client = @@character_set_client */;
378 /*!40101 SET character_set_client = utf8 */;
379 CREATE TABLE `CLI_UPDATES` (
380 `seq` int(11) NOT NULL AUTO_INCREMENT,
381 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
382 `create_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
383 `last_processed_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
384 `target_address` varchar(128) DEFAULT NULL,
385 `cli_text` varchar(128) DEFAULT NULL,
387 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
388 /*!40101 SET character_set_client = @saved_cs_client */;
391 -- Table structure for table `CONFIGFILES`
394 DROP TABLE IF EXISTS `CONFIGFILES`;
395 /*!40101 SET @saved_cs_client = @@character_set_client */;
396 /*!40101 SET character_set_client = utf8 */;
397 CREATE TABLE `CONFIGFILES` (
398 `config_file_id` int(11) NOT NULL AUTO_INCREMENT,
399 `external_version` varchar(50) DEFAULT NULL,
400 `data_source` varchar(25) DEFAULT NULL,
401 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
402 `service_instance_id` varchar(50) DEFAULT NULL,
403 `vnf_type` varchar(50) DEFAULT NULL,
404 `vnfc_type` varchar(50) DEFAULT NULL,
405 `file_category` varchar(50) DEFAULT NULL,
406 `file_name` varchar(255) DEFAULT NULL,
407 `file_content` longtext,
408 `action` varchar(50) DEFAULT NULL,
409 `vnf_id` varchar(50) DEFAULT NULL,
410 `vm_name` varchar(50) DEFAULT NULL,
411 `vnf_name` varchar(50) DEFAULT NULL,
412 PRIMARY KEY (`config_file_id`),
413 UNIQUE KEY `config_file_id` (`config_file_id`)
414 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
415 /*!40101 SET character_set_client = @saved_cs_client */;
418 -- Table structure for table `CONFIGURE_ACTION_DG`
421 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
422 /*!40101 SET @saved_cs_client = @@character_set_client */;
423 /*!40101 SET character_set_client = utf8 */;
424 CREATE TABLE `CONFIGURE_ACTION_DG` (
425 `configure_action_dg_id` int(11) NOT NULL AUTO_INCREMENT,
426 `vnf_type` varchar(50) DEFAULT NULL,
427 `action` varchar(50) DEFAULT NULL,
428 `init_config_dg` varchar(50) DEFAULT NULL,
429 `generate_config_dg` varchar(50) DEFAULT NULL,
430 `download_config_dg` varchar(50) DEFAULT NULL,
431 PRIMARY KEY (`configure_action_dg_id`),
432 UNIQUE KEY `configure_action_dg_id` (`configure_action_dg_id`)
433 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
434 /*!40101 SET character_set_client = @saved_cs_client */;
437 -- Table structure for table `CONFIG_CONTENT`
440 DROP TABLE IF EXISTS `CONFIG_CONTENT`;
441 /*!40101 SET @saved_cs_client = @@character_set_client */;
442 /*!40101 SET character_set_client = utf8 */;
443 CREATE TABLE `CONFIG_CONTENT` (
444 `config_content_id` int(11) NOT NULL AUTO_INCREMENT,
445 `request_id` varchar(50) NOT NULL,
446 `content_type` varchar(50) NOT NULL,
447 `template_name` varchar(50) DEFAULT NULL,
448 `originator_id` varchar(50) DEFAULT NULL,
449 `service_description` varchar(100) DEFAULT NULL,
450 `action` varchar(50) DEFAULT NULL,
451 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
452 `service_type` varchar(50) DEFAULT NULL,
453 `service_instance_id` varchar(50) DEFAULT NULL,
454 `vnf_id` varchar(50) DEFAULT NULL,
455 `vnf_name` varchar(50) DEFAULT NULL,
456 `vm_name` varchar(50) DEFAULT NULL,
457 `vnf_type` varchar(50) DEFAULT NULL,
458 `vnfc_type` varchar(50) DEFAULT NULL,
459 `host_ip_address` varchar(50) DEFAULT NULL,
460 `config_indicator` varchar(25) DEFAULT NULL,
461 `pending_delete` varchar(1) DEFAULT NULL,
463 PRIMARY KEY (`config_content_id`),
464 UNIQUE KEY `config_content_id` (`creation_date`)
465 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
466 /*!40101 SET character_set_client = @saved_cs_client */;
469 -- Table structure for table `CONFIG_FILE_REFERENCE`
472 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
473 /*!40101 SET @saved_cs_client = @@character_set_client */;
474 /*!40101 SET character_set_client = utf8 */;
475 CREATE TABLE `CONFIG_FILE_REFERENCE` (
476 `config_file_reference_id` int(11) NOT NULL AUTO_INCREMENT,
477 `site_location` varchar(50) DEFAULT NULL,
478 `vnf_type` varchar(50) DEFAULT NULL,
479 `import_type` varchar(50) DEFAULT NULL,
480 `file_type` varchar(50) DEFAULT NULL,
481 `source_server_name` varchar(255) DEFAULT NULL,
482 `source_file_path` varchar(255) DEFAULT NULL,
483 `target_file_path` varchar(255) DEFAULT NULL,
484 `name` varchar(50) DEFAULT NULL,
485 `file_name` varchar(255) DEFAULT NULL,
486 PRIMARY KEY (`config_file_reference_id`),
487 UNIQUE KEY `config_file_reference_id` (`config_file_reference_id`)
488 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
489 /*!40101 SET character_set_client = @saved_cs_client */;
492 -- Table structure for table `CONFIG_TRANSACTION_LOG`
495 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
496 /*!40101 SET @saved_cs_client = @@character_set_client */;
497 /*!40101 SET character_set_client = utf8 */;
498 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
499 `config_transaction_log_id` int(11) NOT NULL AUTO_INCREMENT,
500 `request_id` varchar(50) DEFAULT NULL,
501 `message_type` varchar(50) DEFAULT NULL,
502 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
504 PRIMARY KEY (`config_transaction_log_id`),
505 UNIQUE KEY `config_transaction_log_id` (`config_transaction_log_id`)
506 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
507 /*!40101 SET character_set_client = @saved_cs_client */;
510 -- Table structure for table `COUNTRY_ASN_MAPPING`
513 DROP TABLE IF EXISTS `COUNTRY_ASN_MAPPING`;
514 /*!40101 SET @saved_cs_client = @@character_set_client */;
515 /*!40101 SET character_set_client = utf8 */;
516 CREATE TABLE `COUNTRY_ASN_MAPPING` (
517 `asn` int(5) NOT NULL,
518 `iso_2char` varchar(5) NOT NULL,
519 `iso_3char` varchar(5) NOT NULL
520 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
521 /*!40101 SET character_set_client = @saved_cs_client */;
524 -- Table structure for table `CUSTOMER`
527 DROP TABLE IF EXISTS `CUSTOMER`;
528 /*!40101 SET @saved_cs_client = @@character_set_client */;
529 /*!40101 SET character_set_client = utf8 */;
530 CREATE TABLE `CUSTOMER` (
531 `cust_id` int(11) NOT NULL AUTO_INCREMENT,
532 `customer_name` varchar(256) DEFAULT NULL,
533 `grua` varchar(4) NOT NULL,
534 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
535 PRIMARY KEY (`cust_id`),
536 UNIQUE KEY `IU1_CUSTOMER` (`customer_name`)
537 ) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=latin1;
538 /*!40101 SET character_set_client = @saved_cs_client */;
541 -- Table structure for table `CUSTOMER2CONNECTION_MAPPING`
544 DROP TABLE IF EXISTS `CUSTOMER2CONNECTION_MAPPING`;
545 /*!40101 SET @saved_cs_client = @@character_set_client */;
546 /*!40101 SET character_set_client = utf8 */;
547 CREATE TABLE `CUSTOMER2CONNECTION_MAPPING` (
548 `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT,
549 `service_instance_id` varchar(80) NOT NULL,
550 `instance_type` varchar(20) NOT NULL,
551 `originating_service_instance_id` varchar(80) DEFAULT NULL,
552 `originating_service_type` varchar(20) DEFAULT NULL,
553 `service_type` varchar(30) DEFAULT NULL,
554 `connection_id` varchar(100) NOT NULL,
555 `status` varchar(20) DEFAULT NULL,
556 PRIMARY KEY (`customer2connection_id`)
557 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
558 /*!40101 SET character_set_client = @saved_cs_client */;
561 -- Table structure for table `CUSTOMER2CONNECTION_MAPPING_NEW`
564 DROP TABLE IF EXISTS `CUSTOMER2CONNECTION_MAPPING_NEW`;
565 /*!40101 SET @saved_cs_client = @@character_set_client */;
566 /*!40101 SET character_set_client = utf8 */;
567 CREATE TABLE `CUSTOMER2CONNECTION_MAPPING_NEW` (
568 `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT,
569 `service_instance_id` varchar(80) NOT NULL,
570 `instance_type` varchar(20) NOT NULL,
571 `originating_service_instance_id` varchar(80) DEFAULT NULL,
572 `originating_service_type` varchar(20) DEFAULT NULL,
573 `service_type` varchar(30) DEFAULT NULL,
574 `connection_id` varchar(100) NOT NULL,
575 `status` varchar(100) DEFAULT NULL,
576 PRIMARY KEY (`customer2connection_id`)
577 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
578 /*!40101 SET character_set_client = @saved_cs_client */;
581 -- Table structure for table `DATA_OBJECT_MAPPING`
584 DROP TABLE IF EXISTS `DATA_OBJECT_MAPPING`;
585 /*!40101 SET @saved_cs_client = @@character_set_client */;
586 /*!40101 SET character_set_client = utf8 */;
587 CREATE TABLE `DATA_OBJECT_MAPPING` (
588 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
589 `data_object_key` varchar(100) NOT NULL,
590 `data_object_type` varchar(50) NOT NULL,
591 `service_type` varchar(50) NOT NULL,
592 `data_object_key2` varchar(100) NOT NULL,
593 `data_object_key2_type` varchar(50) NOT NULL,
594 `data_object_key3` varchar(100) DEFAULT NULL,
595 `data_object_key3_type` varchar(50) DEFAULT NULL,
596 `service` varchar(50) DEFAULT NULL,
597 PRIMARY KEY (`serial_key`),
598 KEY `IX1_DATA_OBJECT_MAPPING` (`data_object_key`,`data_object_type`,`service_type`),
599 KEY `IX2_DATA_OBJECT_MAPPING` (`service_type`,`data_object_key2`,`data_object_key2_type`)
600 ) ENGINE=InnoDB AUTO_INCREMENT=3211 DEFAULT CHARSET=latin1;
601 /*!40101 SET character_set_client = @saved_cs_client */;
604 -- Table structure for table `DEVICE2CONNECTION_MAPPING`
607 DROP TABLE IF EXISTS `DEVICE2CONNECTION_MAPPING`;
608 /*!40101 SET @saved_cs_client = @@character_set_client */;
609 /*!40101 SET character_set_client = utf8 */;
610 CREATE TABLE `DEVICE2CONNECTION_MAPPING` (
611 `vnf_host_name` varchar(100) NOT NULL,
612 `e2e_vpn_key` varchar(30) NOT NULL,
613 `service_type` varchar(30) NOT NULL,
614 `connection_id` varchar(100) NOT NULL,
615 PRIMARY KEY (`vnf_host_name`,`e2e_vpn_key`,`service_type`)
616 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
617 /*!40101 SET character_set_client = @saved_cs_client */;
620 -- Table structure for table `DEVICE2IPADDRESS_CONSUMPTION`
623 DROP TABLE IF EXISTS `DEVICE2IPADDRESS_CONSUMPTION`;
624 /*!40101 SET @saved_cs_client = @@character_set_client */;
625 /*!40101 SET character_set_client = utf8 */;
626 CREATE TABLE `DEVICE2IPADDRESS_CONSUMPTION` (
627 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
628 `device_id` varchar(100) NOT NULL,
629 `device_type` varchar(30) NOT NULL,
630 `ip_version` varchar(10) NOT NULL,
631 `consumption_key` varchar(100) NOT NULL,
632 `logical_interface_service_id` varchar(100) NOT NULL,
633 `address_type` varchar(30) NOT NULL,
634 `ip_consumed` varchar(50) NOT NULL,
635 `vnf_type` varchar(30) NOT NULL,
636 `secondary_key` varchar(100) DEFAULT NULL,
637 PRIMARY KEY (`serial_key`),
638 KEY `IX1_DEVICEIPADDRESS_CONSUMPTION` (`device_id`,`device_type`,`ip_version`)
639 ) ENGINE=InnoDB AUTO_INCREMENT=1357 DEFAULT CHARSET=latin1;
640 /*!40101 SET character_set_client = @saved_cs_client */;
643 -- Table structure for table `DEVICE2IPADDRESS_MAPPING`
646 DROP TABLE IF EXISTS `DEVICE2IPADDRESS_MAPPING`;
647 /*!40101 SET @saved_cs_client = @@character_set_client */;
648 /*!40101 SET character_set_client = utf8 */;
649 CREATE TABLE `DEVICE2IPADDRESS_MAPPING` (
650 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
651 `device_id` varchar(100) NOT NULL,
652 `device_type` varchar(30) NOT NULL,
653 `secondary_key` varchar(100) NOT NULL,
654 `secondary_key_type` varchar(30) NOT NULL,
655 `address` varchar(50) NOT NULL,
656 `address_type` varchar(30) NOT NULL,
657 `ip_version` varchar(10) NOT NULL,
658 `length` int(11) NOT NULL,
659 `status` varchar(30) NOT NULL,
660 PRIMARY KEY (`serial_key`),
661 KEY `IX1_DEVICE2IPADDRESS_MAPPING` (`device_id`,`device_type`,`secondary_key`,`secondary_key_type`,`address`,`address_type`)
662 ) ENGINE=InnoDB AUTO_INCREMENT=4734 DEFAULT CHARSET=latin1;
663 /*!40101 SET character_set_client = @saved_cs_client */;
666 -- Table structure for table `DEVICE_AUTHENTICATION`
669 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
670 /*!40101 SET @saved_cs_client = @@character_set_client */;
671 /*!40101 SET character_set_client = utf8 */;
672 CREATE TABLE `DEVICE_AUTHENTICATION` (
673 `device_authentication_id` int(11) NOT NULL AUTO_INCREMENT,
674 `vnf_type` varchar(50) DEFAULT NULL,
675 `user_name` varchar(50) DEFAULT NULL,
676 `password` varchar(100) DEFAULT NULL,
677 `protocol` varchar(100) DEFAULT NULL,
678 `port_number` int(11) DEFAULT NULL,
679 PRIMARY KEY (`device_authentication_id`),
680 UNIQUE KEY `device_authentication_id` (`device_authentication_id`)
681 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
682 /*!40101 SET character_set_client = @saved_cs_client */;
685 -- Table structure for table `DEVICE_INTERFACE_LOG`
688 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
689 /*!40101 SET @saved_cs_client = @@character_set_client */;
690 /*!40101 SET character_set_client = utf8 */;
691 CREATE TABLE `DEVICE_INTERFACE_LOG` (
692 `device_interface_log_id` int(11) NOT NULL AUTO_INCREMENT,
693 `service_instance_id` varchar(50) DEFAULT NULL,
694 `request_id` varchar(50) DEFAULT NULL,
695 `creation_date` datetime NOT NULL,
697 PRIMARY KEY (`device_interface_log_id`),
698 UNIQUE KEY `device_interface_log_id` (`device_interface_log_id`)
699 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
700 /*!40101 SET character_set_client = @saved_cs_client */;
703 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
706 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
707 /*!40101 SET @saved_cs_client = @@character_set_client */;
708 /*!40101 SET character_set_client = utf8 */;
709 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
710 `device_interface_protocol_id` int(11) NOT NULL AUTO_INCREMENT,
711 `vnf_type` varchar(50) DEFAULT NULL,
712 `protocol` varchar(50) DEFAULT NULL,
713 `module` varchar(50) DEFAULT NULL,
714 `dg_rpc` varchar(50) DEFAULT NULL,
715 PRIMARY KEY (`device_interface_protocol_id`),
716 UNIQUE KEY `device_interface_protocol_id` (`device_interface_protocol_id`),
717 UNIQUE KEY `vnf_type` (`vnf_type`)
718 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
719 /*!40101 SET character_set_client = @saved_cs_client */;
722 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
725 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
726 /*!40101 SET @saved_cs_client = @@character_set_client */;
727 /*!40101 SET character_set_client = utf8 */;
728 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
729 `download_config_template_id` int(11) NOT NULL AUTO_INCREMENT,
730 `vnf_type` varchar(50) NOT NULL,
731 `protocol` varchar(50) NOT NULL,
733 PRIMARY KEY (`download_config_template_id`),
734 UNIQUE KEY `download_config_template_id` (`download_config_template_id`)
735 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
736 /*!40101 SET character_set_client = @saved_cs_client */;
739 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
742 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
743 /*!40101 SET @saved_cs_client = @@character_set_client */;
744 /*!40101 SET character_set_client = utf8 */;
745 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
746 `download_dg_reference_id` int(11) NOT NULL AUTO_INCREMENT,
747 `protocol` varchar(50) NOT NULL,
748 `download_config_dg` varchar(50) NOT NULL,
749 PRIMARY KEY (`download_dg_reference_id`),
750 UNIQUE KEY `download_dg_reference_id` (`download_dg_reference_id`)
751 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
752 /*!40101 SET character_set_client = @saved_cs_client */;
755 -- Table structure for table `EIPAM_CLIENT_KEY_INDEX`
758 DROP TABLE IF EXISTS `EIPAM_CLIENT_KEY_INDEX`;
759 /*!40101 SET @saved_cs_client = @@character_set_client */;
760 /*!40101 SET character_set_client = utf8 */;
761 CREATE TABLE `EIPAM_CLIENT_KEY_INDEX` (
762 `vnf_name_prefix` varchar(100) NOT NULL,
763 `index_number` int(11) NOT NULL,
764 PRIMARY KEY (`vnf_name_prefix`)
765 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
766 /*!40101 SET character_set_client = @saved_cs_client */;
769 -- Table structure for table `EIPAM_IP_ASSIGNMENTS`
772 DROP TABLE IF EXISTS `EIPAM_IP_ASSIGNMENTS`;
773 /*!40101 SET @saved_cs_client = @@character_set_client */;
774 /*!40101 SET character_set_client = utf8 */;
775 CREATE TABLE `EIPAM_IP_ASSIGNMENTS` (
776 `plan_name` varchar(40) NOT NULL,
777 `client_key` varchar(100) NOT NULL,
778 `service_type` varchar(40) NOT NULL,
779 `ip_address` varchar(40) DEFAULT NULL,
780 `prefix_length` int(2) DEFAULT NULL,
781 `status` varchar(255) DEFAULT NULL,
782 `service_instance_id` varchar(80) DEFAULT NULL,
783 `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
784 `prev_status` varchar(20) DEFAULT NULL,
785 `info` varchar(255) DEFAULT NULL,
786 PRIMARY KEY (`plan_name`,`client_key`)
787 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
788 /*!40101 SET character_set_client = @saved_cs_client */;
791 -- Table structure for table `EIPAM_IP_POOLS`
794 DROP TABLE IF EXISTS `EIPAM_IP_POOLS`;
795 /*!40101 SET @saved_cs_client = @@character_set_client */;
796 /*!40101 SET character_set_client = utf8 */;
797 CREATE TABLE `EIPAM_IP_POOLS` (
798 `pool_id` int(11) NOT NULL AUTO_INCREMENT,
799 `key_name` varchar(50) NOT NULL,
800 `key_value` varchar(255) NOT NULL,
801 `level` int(2) NOT NULL,
802 `plan_name` varchar(50) NOT NULL,
803 `address_family` varchar(10) NOT NULL,
804 `parent_pool` varchar(255) NOT NULL,
805 `service_instance_id` varchar(255) DEFAULT NULL,
806 `network_id` varchar(255) DEFAULT NULL,
807 `created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
808 `delete_failure` varchar(20) DEFAULT NULL,
809 `delete_request_id` varchar(255) DEFAULT NULL,
810 PRIMARY KEY (`pool_id`)
811 ) 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.';
812 /*!40101 SET character_set_client = @saved_cs_client */;
815 -- Table structure for table `EIPAM_IP_SUBNETS`
818 DROP TABLE IF EXISTS `EIPAM_IP_SUBNETS`;
819 /*!40101 SET @saved_cs_client = @@character_set_client */;
820 /*!40101 SET character_set_client = utf8 */;
821 CREATE TABLE `EIPAM_IP_SUBNETS` (
822 `entity_id` int(6) NOT NULL,
823 `service_type` varchar(40) NOT NULL,
824 `plan_name` varchar(50) NOT NULL,
825 `address_family` varchar(10) NOT NULL,
826 `ip_address` varchar(40) NOT NULL,
827 `prefix_length` int(3) NOT NULL,
828 `status` varchar(20) NOT NULL,
829 `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
830 `network_id` varchar(255) DEFAULT NULL,
831 `pool_id` int(11) DEFAULT NULL,
832 `dealloc_failure` varchar(20) DEFAULT NULL,
833 `dealloc_request_id` varchar(255) DEFAULT NULL,
834 PRIMARY KEY (`entity_id`),
835 KEY `FK_EIPAM_IP_SUBNETS_EIPAM_IP_POOLS` (`pool_id`),
836 CONSTRAINT `EIPAM_IP_SUBNETS_ibfk_1` FOREIGN KEY (`pool_id`) REFERENCES `EIPAM_IP_POOLS` (`pool_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
837 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
838 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
839 /*!40101 SET character_set_client = @saved_cs_client */;
842 -- Table structure for table `EIPAM_IP_SUBNET_KEYS`
845 DROP TABLE IF EXISTS `EIPAM_IP_SUBNET_KEYS`;
846 /*!40101 SET @saved_cs_client = @@character_set_client */;
847 /*!40101 SET character_set_client = utf8 */;
848 CREATE TABLE `EIPAM_IP_SUBNET_KEYS` (
849 `entity_id` int(6) NOT NULL,
850 `key_name` varchar(50) NOT NULL,
851 `key_value` varchar(255) NOT NULL,
852 `level` int(2) NOT NULL,
853 PRIMARY KEY (`entity_id`,`key_name`,`key_value`,`level`)
854 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
855 /*!40101 SET character_set_client = @saved_cs_client */;
858 -- Table structure for table `EIPAM_REQUEST_KEY`
861 DROP TABLE IF EXISTS `EIPAM_REQUEST_KEY`;
862 /*!40101 SET @saved_cs_client = @@character_set_client */;
863 /*!40101 SET character_set_client = utf8 */;
864 CREATE TABLE `EIPAM_REQUEST_KEY` (
865 `key_name_1` varchar(50) NOT NULL,
866 `address_family` varchar(4) NOT NULL,
867 `serial_key` int(2) NOT NULL AUTO_INCREMENT,
868 `plan_name` varchar(50) NOT NULL,
869 `request_length` int(2) NOT NULL,
870 `pools_length` int(2) NOT NULL,
871 `plan_length` int(2) NOT NULL,
872 `key_name_0` varchar(50) NOT NULL,
873 `key_name_type_0` varchar(255) NOT NULL,
874 `key_name_type_1` varchar(255) NOT NULL,
875 `prefix_length` int(2) NOT NULL,
876 `group_flag` char(1) NOT NULL,
877 `address_type` varchar(20) DEFAULT NULL,
878 PRIMARY KEY (`key_name_1`,`address_family`),
879 UNIQUE KEY `IX1_EIPAM_REQUEST_KEY` (`serial_key`)
880 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
881 /*!40101 SET character_set_client = @saved_cs_client */;
884 -- Table structure for table `EXTERNAL_DATA`
887 DROP TABLE IF EXISTS `EXTERNAL_DATA`;
888 /*!40101 SET @saved_cs_client = @@character_set_client */;
889 /*!40101 SET character_set_client = utf8 */;
890 CREATE TABLE `EXTERNAL_DATA` (
891 `external_data_id` int(11) NOT NULL AUTO_INCREMENT,
892 `request_id` int(11) DEFAULT NULL,
893 `param_name` varchar(30) NOT NULL,
894 `param_value` varchar(50) NOT NULL,
895 PRIMARY KEY (`external_data_id`)
896 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
897 /*!40101 SET character_set_client = @saved_cs_client */;
900 -- Table structure for table `FLOW_UPDATES`
903 DROP TABLE IF EXISTS `FLOW_UPDATES`;
904 /*!40101 SET @saved_cs_client = @@character_set_client */;
905 /*!40101 SET character_set_client = utf8 */;
906 CREATE TABLE `FLOW_UPDATES` (
907 `seq` int(11) NOT NULL AUTO_INCREMENT,
908 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
909 `create_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
910 `last_processed_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
911 `odl` varchar(128) DEFAULT NULL,
912 `address_family` enum('IPV4','IPV6') DEFAULT NULL,
913 `destination_prefix` varchar(50) DEFAULT NULL,
914 `communities` varchar(6000) DEFAULT NULL,
915 `route_key` varchar(50) DEFAULT NULL,
917 ) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=latin1;
918 /*!40101 SET character_set_client = @saved_cs_client */;
921 -- Table structure for table `GENERIC_L3_NETWORK`
924 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK`;
925 /*!40101 SET @saved_cs_client = @@character_set_client */;
926 /*!40101 SET character_set_client = utf8 */;
927 CREATE TABLE `GENERIC_L3_NETWORK` (
928 `network_id` varchar(80) NOT NULL,
929 `network_name` varchar(80) DEFAULT NULL,
930 `network_type` varchar(80) DEFAULT NULL,
931 `network_role` varchar(80) DEFAULT NULL,
932 `network_technology` varchar(80) DEFAULT NULL,
933 `neutron_network_id` varchar(80) DEFAULT NULL,
934 `is_bound_to_vpn` tinyint(1) DEFAULT NULL,
935 `orchestration_status` varchar(20) DEFAULT NULL,
936 `heat_stack_id` varchar(80) DEFAULT NULL,
937 `mso_catalog_key` varchar(80) DEFAULT NULL,
938 `service_id` varchar(80) NOT NULL,
939 `tenant_id` varchar(80) NOT NULL,
940 `physical_location_id` varchar(20) DEFAULT NULL,
941 `network_role_instance` varchar(80) NOT NULL,
942 PRIMARY KEY (`network_id`)
943 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
944 /*!40101 SET character_set_client = @saved_cs_client */;
947 -- Table structure for table `GENERIC_L3_NETWORK_SUBNET`
950 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK_SUBNET`;
951 /*!40101 SET @saved_cs_client = @@character_set_client */;
952 /*!40101 SET character_set_client = utf8 */;
953 CREATE TABLE `GENERIC_L3_NETWORK_SUBNET` (
954 `network_id` varchar(80) NOT NULL,
955 `subnet_id` varchar(80) NOT NULL,
956 `neutron_subnet_id` varchar(80) DEFAULT NULL,
957 `gateway_address` varchar(45) NOT NULL,
958 `network_start_address` varchar(45) NOT NULL,
959 `cidr_mask` varchar(20) NOT NULL,
960 `ip_version` char(1) NOT NULL,
961 `orchestration_status` varchar(64) NOT NULL,
962 `dhcp_enabled` tinyint(1) NOT NULL,
963 `dhcp_start` varchar(45) DEFAULT NULL,
964 `dhcp_end` varchar(45) DEFAULT NULL,
965 PRIMARY KEY (`network_id`,`subnet_id`)
966 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
967 /*!40101 SET character_set_client = @saved_cs_client */;
970 -- Table structure for table `GENERIC_L3_NETWORK_VPN_BINDING`
973 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK_VPN_BINDING`;
974 /*!40101 SET @saved_cs_client = @@character_set_client */;
975 /*!40101 SET character_set_client = utf8 */;
976 CREATE TABLE `GENERIC_L3_NETWORK_VPN_BINDING` (
977 `network_id` varchar(80) NOT NULL,
978 `vpn_id` varchar(80) NOT NULL,
979 PRIMARY KEY (`network_id`,`vpn_id`)
980 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
981 /*!40101 SET character_set_client = @saved_cs_client */;
984 -- Table structure for table `GENERIC_RESOURCE_NAME`
987 DROP TABLE IF EXISTS `GENERIC_RESOURCE_NAME`;
988 /*!40101 SET @saved_cs_client = @@character_set_client */;
989 /*!40101 SET character_set_client = utf8 */;
990 CREATE TABLE `GENERIC_RESOURCE_NAME` (
991 `type` varchar(50) NOT NULL,
992 `name` varchar(255) NOT NULL,
993 PRIMARY KEY (`type`,`name`)
994 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
995 /*!40101 SET character_set_client = @saved_cs_client */;
998 -- Table structure for table `GENERIC_VNF`
1001 DROP TABLE IF EXISTS `GENERIC_VNF`;
1002 /*!40101 SET @saved_cs_client = @@character_set_client */;
1003 /*!40101 SET character_set_client = utf8 */;
1004 CREATE TABLE `GENERIC_VNF` (
1005 `vnf_id` varchar(80) NOT NULL,
1006 `vnf_name` varchar(80) NOT NULL,
1007 `vnf_type` varchar(200) NOT NULL,
1008 `vnf_name2` varchar(80) DEFAULT NULL,
1009 `service_id` varchar(80) NOT NULL,
1010 `equipment_role` varchar(80) NOT NULL,
1011 `orchestration_status` varchar(20) DEFAULT NULL,
1012 `prov_status` varchar(20) DEFAULT NULL,
1013 `heat_stack_id` varchar(80) DEFAULT NULL,
1014 `mso_catalog_key` varchar(80) DEFAULT NULL,
1015 `regional_resource_zone` varchar(80) DEFAULT NULL,
1016 `operational_state` varchar(80) DEFAULT NULL,
1017 `license_key` varchar(80) DEFAULT NULL,
1018 `ipv4_oam_address` varchar(20) DEFAULT NULL,
1019 `ipv4_loopback0_address` varchar(20) DEFAULT NULL,
1020 `nm_lan_v6_address` varchar(40) DEFAULT NULL,
1021 `management_v6_address` varchar(40) DEFAULT NULL,
1022 `management_option` varchar(45) DEFAULT NULL,
1023 `vcpu` varchar(45) DEFAULT NULL,
1024 `vmemory` varchar(45) DEFAULT NULL,
1025 `vdisk` varchar(45) DEFAULT NULL,
1026 `vcpu_units` varchar(45) DEFAULT NULL,
1027 `vmemory_units` varchar(45) DEFAULT NULL,
1028 `vdisk_units` varchar(45) DEFAULT NULL,
1029 PRIMARY KEY (`vnf_id`)
1030 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1031 /*!40101 SET character_set_client = @saved_cs_client */;
1034 -- Table structure for table `GENERIC_VNF_L3_NETWORK`
1037 DROP TABLE IF EXISTS `GENERIC_VNF_L3_NETWORK`;
1038 /*!40101 SET @saved_cs_client = @@character_set_client */;
1039 /*!40101 SET character_set_client = utf8 */;
1040 CREATE TABLE `GENERIC_VNF_L3_NETWORK` (
1041 `vnf_id` varchar(80) NOT NULL,
1042 `network_id` varchar(80) NOT NULL,
1043 PRIMARY KEY (`vnf_id`,`network_id`)
1044 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1045 /*!40101 SET character_set_client = @saved_cs_client */;
1048 -- Table structure for table `GENERIC_VNF_LICENSE_MANAGEMENT`
1051 DROP TABLE IF EXISTS `GENERIC_VNF_LICENSE_MANAGEMENT`;
1052 /*!40101 SET @saved_cs_client = @@character_set_client */;
1053 /*!40101 SET character_set_client = utf8 */;
1054 CREATE TABLE `GENERIC_VNF_LICENSE_MANAGEMENT` (
1055 `vnf_id` varchar(80) NOT NULL,
1056 `att_uuid` varchar(80) NOT NULL,
1057 PRIMARY KEY (`vnf_id`,`att_uuid`)
1058 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1059 /*!40101 SET character_set_client = @saved_cs_client */;
1062 -- Table structure for table `GENERIC_VNF_LINTERFACE`
1065 DROP TABLE IF EXISTS `GENERIC_VNF_LINTERFACE`;
1066 /*!40101 SET @saved_cs_client = @@character_set_client */;
1067 /*!40101 SET character_set_client = utf8 */;
1068 CREATE TABLE `GENERIC_VNF_LINTERFACE` (
1069 `vnf_id` varchar(80) NOT NULL,
1070 `interface_name` varchar(255) NOT NULL,
1071 `interface_role` varchar(45) DEFAULT NULL,
1072 `v6_wan_link_ip` varchar(45) DEFAULT NULL,
1073 `selflink` varchar(128) DEFAULT NULL,
1074 `interface_id` varchar(45) DEFAULT NULL,
1075 `macaddr` varchar(64) DEFAULT NULL,
1076 `network_name` varchar(255) DEFAULT NULL,
1077 PRIMARY KEY (`vnf_id`,`interface_name`),
1078 KEY `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF_IDX` (`vnf_id`),
1079 CONSTRAINT `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF` FOREIGN KEY (`vnf_id`) REFERENCES `GENERIC_VNF` (`vnf_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
1080 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1081 /*!40101 SET character_set_client = @saved_cs_client */;
1084 -- Table structure for table `GENERIC_VNF_PSERVER`
1087 DROP TABLE IF EXISTS `GENERIC_VNF_PSERVER`;
1088 /*!40101 SET @saved_cs_client = @@character_set_client */;
1089 /*!40101 SET character_set_client = utf8 */;
1090 CREATE TABLE `GENERIC_VNF_PSERVER` (
1091 `vnf_id` varchar(64) NOT NULL,
1092 `hostname` varchar(255) NOT NULL,
1093 PRIMARY KEY (`vnf_id`,`hostname`)
1094 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1095 /*!40101 SET character_set_client = @saved_cs_client */;
1098 -- Table structure for table `GENERIC_VNF_SERVICE_INSTANCE`
1101 DROP TABLE IF EXISTS `GENERIC_VNF_SERVICE_INSTANCE`;
1102 /*!40101 SET @saved_cs_client = @@character_set_client */;
1103 /*!40101 SET character_set_client = utf8 */;
1104 CREATE TABLE `GENERIC_VNF_SERVICE_INSTANCE` (
1105 `vnf_id` varchar(64) NOT NULL,
1106 `service_instance_id` varchar(255) NOT NULL,
1107 `relationship_key` varchar(64) NOT NULL,
1108 `relationship_value` varchar(64) DEFAULT NULL,
1109 `global_customer_id` varchar(255) DEFAULT NULL,
1110 `service_type` varchar(255) DEFAULT NULL,
1111 PRIMARY KEY (`vnf_id`,`service_instance_id`,`relationship_key`)
1112 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1113 /*!40101 SET character_set_client = @saved_cs_client */;
1116 -- Table structure for table `GENERIC_VNF_VNF_IMAGE`
1119 DROP TABLE IF EXISTS `GENERIC_VNF_VNF_IMAGE`;
1120 /*!40101 SET @saved_cs_client = @@character_set_client */;
1121 /*!40101 SET character_set_client = utf8 */;
1122 CREATE TABLE `GENERIC_VNF_VNF_IMAGE` (
1123 `vnf_id` varchar(64) NOT NULL,
1124 `att_uuid` varchar(255) NOT NULL,
1125 PRIMARY KEY (`vnf_id`,`att_uuid`)
1126 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1127 /*!40101 SET character_set_client = @saved_cs_client */;
1130 -- Table structure for table `GENERIC_VNF_VSERVER`
1133 DROP TABLE IF EXISTS `GENERIC_VNF_VSERVER`;
1134 /*!40101 SET @saved_cs_client = @@character_set_client */;
1135 /*!40101 SET character_set_client = utf8 */;
1136 CREATE TABLE `GENERIC_VNF_VSERVER` (
1137 `vnf_id` varchar(80) NOT NULL,
1138 `vserver_id` varchar(128) NOT NULL,
1139 `tenant_id` varchar(128) DEFAULT NULL,
1140 PRIMARY KEY (`vnf_id`,`vserver_id`)
1141 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1142 /*!40101 SET character_set_client = @saved_cs_client */;
1145 -- Table structure for table `GENERIC_VPN_BINDING`
1148 DROP TABLE IF EXISTS `GENERIC_VPN_BINDING`;
1149 /*!40101 SET @saved_cs_client = @@character_set_client */;
1150 /*!40101 SET character_set_client = utf8 */;
1151 CREATE TABLE `GENERIC_VPN_BINDING` (
1152 `vpn_id` varchar(80) NOT NULL,
1153 `vpn_name` varchar(80) NOT NULL,
1154 `global_route_target` varchar(80) NOT NULL,
1155 PRIMARY KEY (`vpn_id`)
1156 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1157 /*!40101 SET character_set_client = @saved_cs_client */;
1160 -- Table structure for table `GET_CONFIG_TEMPLATE`
1163 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
1164 /*!40101 SET @saved_cs_client = @@character_set_client */;
1165 /*!40101 SET character_set_client = utf8 */;
1166 CREATE TABLE `GET_CONFIG_TEMPLATE` (
1167 `get_config_template_id` int(11) NOT NULL AUTO_INCREMENT,
1168 `vnf_type` varchar(50) NOT NULL,
1169 `device_interface_protocol_id` int(11) NOT NULL,
1170 `xml_processing` varchar(1) DEFAULT NULL,
1171 `xml_protocol` varchar(30) DEFAULT NULL,
1172 `template` longtext,
1173 PRIMARY KEY (`get_config_template_id`),
1174 UNIQUE KEY `get_config_template_id` (`get_config_template_id`),
1175 KEY `get_config_template_ibfk_1` (`device_interface_protocol_id`),
1176 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
1177 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1178 /*!40101 SET character_set_client = @saved_cs_client */;
1181 -- Table structure for table `HOSTNAME`
1184 DROP TABLE IF EXISTS `HOSTNAME`;
1185 /*!40101 SET @saved_cs_client = @@character_set_client */;
1186 /*!40101 SET character_set_client = utf8 */;
1187 CREATE TABLE `HOSTNAME` (
1188 `hostname` varchar(21) NOT NULL,
1189 `parent_hostname` varchar(21) DEFAULT NULL,
1190 `cust_id` int(11) NOT NULL,
1191 `loc_id` int(11) NOT NULL,
1192 `site_sequence` varchar(2) NOT NULL,
1193 `server_sequence` varchar(2) NOT NULL,
1194 `activation_code` varchar(11) DEFAULT NULL,
1195 `vnf_sequence` varchar(2) DEFAULT NULL,
1196 `vendor_code` varchar(1) NOT NULL,
1197 `virtual_device_type` varchar(2) DEFAULT NULL,
1198 `device_sequence` varchar(3) DEFAULT NULL,
1199 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1200 PRIMARY KEY (`hostname`),
1201 KEY `IN1_HOSTNAME` (`cust_id`),
1202 KEY `IN2_HOSTNAME` (`loc_id`),
1203 KEY `IN3_HOSTNAME` (`vendor_code`),
1204 KEY `IN4_HOSTNAME` (`parent_hostname`),
1205 CONSTRAINT `FK1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1206 CONSTRAINT `FK2_HOSTNAME` FOREIGN KEY (`loc_id`) REFERENCES `LOCATION` (`loc_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1207 CONSTRAINT `FK4_HOSTNAME` FOREIGN KEY (`parent_hostname`) REFERENCES `HOSTNAME` (`hostname`) ON DELETE NO ACTION ON UPDATE NO ACTION
1208 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1209 /*!40101 SET character_set_client = @saved_cs_client */;
1212 -- Table structure for table `IPV4_ADDRESS_POOL`
1215 DROP TABLE IF EXISTS `IPV4_ADDRESS_POOL`;
1216 /*!40101 SET @saved_cs_client = @@character_set_client */;
1217 /*!40101 SET character_set_client = utf8 */;
1218 CREATE TABLE `IPV4_ADDRESS_POOL` (
1219 `aic_site_id` varchar(100) NOT NULL,
1220 `universe` varchar(40) NOT NULL,
1221 `status` varchar(40) NOT NULL,
1222 `ipv4_addr` varchar(20) NOT NULL,
1223 PRIMARY KEY (`ipv4_addr`,`universe`)
1224 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1225 /*!40101 SET character_set_client = @saved_cs_client */;
1228 -- Table structure for table `LINK_MASTER`
1231 DROP TABLE IF EXISTS `LINK_MASTER`;
1232 /*!40101 SET @saved_cs_client = @@character_set_client */;
1233 /*!40101 SET character_set_client = utf8 */;
1234 CREATE TABLE `LINK_MASTER` (
1235 `link_interface_ip` varchar(20) NOT NULL,
1236 `source_crs_name` varchar(20) NOT NULL,
1237 `destination_crs_name` varchar(20) NOT NULL,
1238 `max_reserved_bw` int(11) DEFAULT NULL,
1239 `default_cost` int(11) DEFAULT NULL,
1240 `bundle_name` varchar(20) DEFAULT NULL,
1241 PRIMARY KEY (`link_interface_ip`)
1242 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1243 /*!40101 SET character_set_client = @saved_cs_client */;
1246 -- Table structure for table `LINTERFACE_VLAN`
1249 DROP TABLE IF EXISTS `LINTERFACE_VLAN`;
1250 /*!40101 SET @saved_cs_client = @@character_set_client */;
1251 /*!40101 SET character_set_client = utf8 */;
1252 CREATE TABLE `LINTERFACE_VLAN` (
1253 `vnf_id` varchar(80) NOT NULL,
1254 `interface_name` varchar(255) NOT NULL,
1255 `vlan_interface` varchar(255) NOT NULL,
1256 `vlan_id_inner` varchar(64) DEFAULT NULL,
1257 `vlan_id_outer` varchar(64) DEFAULT NULL,
1258 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`),
1259 KEY `FK_LINTERFACE_VLAN_GENERIC_VNF_LINTERFACE_IDX` (`vnf_id`,`interface_name`),
1260 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
1261 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1262 /*!40101 SET character_set_client = @saved_cs_client */;
1265 -- Table structure for table `LOCATION`
1268 DROP TABLE IF EXISTS `LOCATION`;
1269 /*!40101 SET @saved_cs_client = @@character_set_client */;
1270 /*!40101 SET character_set_client = utf8 */;
1271 CREATE TABLE `LOCATION` (
1272 `loc_id` int(11) NOT NULL AUTO_INCREMENT,
1273 `address` varchar(150) NOT NULL,
1274 `city_code_id` int(11) NOT NULL,
1275 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1276 PRIMARY KEY (`loc_id`),
1277 KEY `IN1_LOCATION_IDX` (`city_code_id`),
1278 CONSTRAINT `FK1_LOCATION` FOREIGN KEY (`city_code_id`) REFERENCES `CITY_CODE` (`city_code_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
1279 ) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=latin1;
1280 /*!40101 SET character_set_client = @saved_cs_client */;
1283 -- Table structure for table `MAX_PORT_SPEED`
1286 DROP TABLE IF EXISTS `MAX_PORT_SPEED`;
1287 /*!40101 SET @saved_cs_client = @@character_set_client */;
1288 /*!40101 SET character_set_client = utf8 */;
1289 CREATE TABLE `MAX_PORT_SPEED` (
1290 `max_port_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1291 `image_file_name` varchar(50) NOT NULL,
1292 `end_point_position` varchar(50) NOT NULL,
1293 `interface_name` varchar(100) NOT NULL,
1294 `max_speed` bigint(20) NOT NULL,
1295 `unit` varchar(10) NOT NULL,
1296 PRIMARY KEY (`max_port_speed_id`),
1297 UNIQUE KEY `max_port_speed_id` (`max_port_speed_id`)
1298 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1299 /*!40101 SET character_set_client = @saved_cs_client */;
1302 -- Table structure for table `MAX_SERVER_SPEED`
1305 DROP TABLE IF EXISTS `MAX_SERVER_SPEED`;
1306 /*!40101 SET @saved_cs_client = @@character_set_client */;
1307 /*!40101 SET character_set_client = utf8 */;
1308 CREATE TABLE `MAX_SERVER_SPEED` (
1309 `max_server_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1310 `server_model` varchar(50) NOT NULL,
1311 `evc_count` smallint(6) NOT NULL,
1312 `max_speed` bigint(20) NOT NULL,
1313 `unit` varchar(10) NOT NULL,
1314 `description` varchar(500) DEFAULT NULL,
1315 PRIMARY KEY (`max_server_speed_id`),
1316 UNIQUE KEY `max_server_speed_id` (`max_server_speed_id`)
1317 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
1318 /*!40101 SET character_set_client = @saved_cs_client */;
1321 -- Table structure for table `NAMING_POLICY_VM_NAME_INDEX`
1324 DROP TABLE IF EXISTS `NAMING_POLICY_VM_NAME_INDEX`;
1325 /*!40101 SET @saved_cs_client = @@character_set_client */;
1326 /*!40101 SET character_set_client = utf8 */;
1327 CREATE TABLE `NAMING_POLICY_VM_NAME_INDEX` (
1328 `vm_name_prefix` varchar(255) NOT NULL,
1329 `index_number` int(11) NOT NULL,
1330 PRIMARY KEY (`vm_name_prefix`)
1331 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1332 /*!40101 SET character_set_client = @saved_cs_client */;
1335 -- Table structure for table `NAMING_POLICY_VNFC_NAME_INDEX`
1338 DROP TABLE IF EXISTS `NAMING_POLICY_VNFC_NAME_INDEX`;
1339 /*!40101 SET @saved_cs_client = @@character_set_client */;
1340 /*!40101 SET character_set_client = utf8 */;
1341 CREATE TABLE `NAMING_POLICY_VNFC_NAME_INDEX` (
1342 `vnfc_name_prefix` varchar(255) NOT NULL,
1343 `index_number` int(11) NOT NULL,
1344 PRIMARY KEY (`vnfc_name_prefix`)
1345 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1346 /*!40101 SET character_set_client = @saved_cs_client */;
1349 -- Table structure for table `NBNC_ASSIGN_VPN_OVERRIDE`
1352 DROP TABLE IF EXISTS `NBNC_ASSIGN_VPN_OVERRIDE`;
1353 /*!40101 SET @saved_cs_client = @@character_set_client */;
1354 /*!40101 SET character_set_client = utf8 */;
1355 CREATE TABLE `NBNC_ASSIGN_VPN_OVERRIDE` (
1356 `vpn_id` varchar(12) NOT NULL DEFAULT '',
1357 `vpn_rt` varchar(16) NOT NULL DEFAULT '',
1358 `service_type` varchar(16) NOT NULL DEFAULT '',
1359 `be_location` varchar(16) NOT NULL DEFAULT '',
1360 `be_type` varchar(32) NOT NULL DEFAULT '',
1361 `be_id` varchar(32) DEFAULT NULL,
1362 `description` varchar(128) DEFAULT NULL,
1363 PRIMARY KEY (`vpn_id`,`vpn_rt`,`service_type`,`be_location`,`be_type`)
1364 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1365 /*!40101 SET character_set_client = @saved_cs_client */;
1368 -- Table structure for table `NBNC_BORDER_ELEMENT`
1371 DROP TABLE IF EXISTS `NBNC_BORDER_ELEMENT`;
1372 /*!40101 SET @saved_cs_client = @@character_set_client */;
1373 /*!40101 SET character_set_client = utf8 */;
1374 CREATE TABLE `NBNC_BORDER_ELEMENT` (
1375 `be_id` varchar(32) NOT NULL,
1376 `be_type` varchar(16) NOT NULL,
1377 `be_name` varchar(32) DEFAULT NULL,
1378 `be_host_vnf_id` varchar(32) DEFAULT NULL,
1379 `service_type` varchar(16) DEFAULT NULL,
1380 `tangibility` varchar(16) DEFAULT NULL,
1381 `usage_order` smallint(6) DEFAULT NULL,
1382 `vlan_start` smallint(6) DEFAULT NULL,
1383 `vlan_end` smallint(6) DEFAULT NULL,
1384 `ipv4_subnet` varchar(18) DEFAULT NULL,
1385 `ipv6_subnet` varchar(68) DEFAULT NULL,
1386 `network_ip` varchar(48) DEFAULT NULL,
1387 `be_location` varchar(16) DEFAULT NULL,
1388 `description` varchar(128) DEFAULT NULL,
1389 `updated_timestamp` timestamp NULL DEFAULT NULL,
1390 `log_link_model_uuid` varchar(64) DEFAULT NULL,
1391 PRIMARY KEY (`be_id`,`be_type`)
1392 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1393 /*!40101 SET character_set_client = @saved_cs_client */;
1396 -- Table structure for table `NBNC_IPE`
1399 DROP TABLE IF EXISTS `NBNC_IPE`;
1400 /*!40101 SET @saved_cs_client = @@character_set_client */;
1401 /*!40101 SET character_set_client = utf8 */;
1402 CREATE TABLE `NBNC_IPE` (
1403 `ipe_name` varchar(32) NOT NULL,
1404 `ipe_location` varchar(16) DEFAULT NULL,
1405 `ipe_ip_address` varchar(16) DEFAULT NULL,
1406 `ipe_id` varchar(8) DEFAULT NULL,
1407 `service_type_array` varchar(512) DEFAULT NULL,
1408 `ipe_status` varchar(32) DEFAULT NULL,
1409 `updated_timestamp` timestamp NULL DEFAULT NULL,
1410 PRIMARY KEY (`ipe_name`)
1411 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1412 /*!40101 SET character_set_client = @saved_cs_client */;
1415 -- Table structure for table `NBNC_IPE_PORT`
1418 DROP TABLE IF EXISTS `NBNC_IPE_PORT`;
1419 /*!40101 SET @saved_cs_client = @@character_set_client */;
1420 /*!40101 SET character_set_client = utf8 */;
1421 CREATE TABLE `NBNC_IPE_PORT` (
1422 `port_id` varchar(16) NOT NULL,
1423 `ipe_name` varchar(32) NOT NULL,
1424 `be_id` varchar(32) NOT NULL,
1425 `be_type` varchar(16) NOT NULL,
1426 `port_type` varchar(16) DEFAULT NULL,
1427 `ae_name` varchar(16) DEFAULT NULL,
1428 `description` varchar(128) DEFAULT NULL,
1429 `updated_timestamp` timestamp NULL DEFAULT NULL,
1430 PRIMARY KEY (`port_id`,`ipe_name`,`be_id`,`be_type`)
1431 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1432 /*!40101 SET character_set_client = @saved_cs_client */;
1435 -- Table structure for table `NBNC_MAPPING_SBG_BGF`
1438 DROP TABLE IF EXISTS `NBNC_MAPPING_SBG_BGF`;
1439 /*!40101 SET @saved_cs_client = @@character_set_client */;
1440 /*!40101 SET character_set_client = utf8 */;
1441 CREATE TABLE `NBNC_MAPPING_SBG_BGF` (
1442 `asbg_vlan` smallint(6) NOT NULL,
1443 `bgf_vlan` smallint(6) NOT NULL,
1444 PRIMARY KEY (`asbg_vlan`)
1445 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1446 /*!40101 SET character_set_client = @saved_cs_client */;
1449 -- Table structure for table `NBNC_SERVICE`
1452 DROP TABLE IF EXISTS `NBNC_SERVICE`;
1453 /*!40101 SET @saved_cs_client = @@character_set_client */;
1454 /*!40101 SET character_set_client = utf8 */;
1455 CREATE TABLE `NBNC_SERVICE` (
1456 `service_type` varchar(16) NOT NULL,
1457 `service_model_uuid` varchar(64) NOT NULL,
1458 `description` varchar(128) DEFAULT NULL,
1459 `created_timestamp` timestamp NULL DEFAULT NULL,
1460 `updated_timestamp` timestamp NULL DEFAULT NULL,
1461 PRIMARY KEY (`service_type`)
1462 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1463 /*!40101 SET character_set_client = @saved_cs_client */;
1466 -- Table structure for table `NBNC_SERVICE_VLAN`
1469 DROP TABLE IF EXISTS `NBNC_SERVICE_VLAN`;
1470 /*!40101 SET @saved_cs_client = @@character_set_client */;
1471 /*!40101 SET character_set_client = utf8 */;
1472 CREATE TABLE `NBNC_SERVICE_VLAN` (
1473 `be_id` varchar(32) NOT NULL,
1474 `vlan` smallint(6) NOT NULL,
1475 `service_type` varchar(16) DEFAULT NULL,
1476 `be_type` varchar(16) DEFAULT NULL,
1477 `be_name` varchar(32) DEFAULT NULL,
1478 `be_host_vnf_id` varchar(32) DEFAULT NULL,
1479 `be_location` varchar(16) DEFAULT NULL,
1480 `be_usage_order` smallint(6) DEFAULT NULL,
1481 `vlan_usage_order` smallint(6) DEFAULT NULL,
1482 `status` varchar(16) DEFAULT 'AVAILABLE',
1483 `request_id` varchar(64) DEFAULT NULL,
1484 `service_instance_id` varchar(64) DEFAULT NULL,
1485 `vni_id` varchar(16) DEFAULT NULL,
1486 `customer_id` varchar(16) DEFAULT NULL,
1487 `ipe1_router_name` varchar(32) DEFAULT NULL,
1488 `ipe1_port_id` varchar(16) DEFAULT NULL,
1489 `ipe1_ae_name` varchar(16) DEFAULT NULL,
1490 `ipe2_router_name` varchar(32) DEFAULT NULL,
1491 `ipe2_port_id` varchar(16) DEFAULT NULL,
1492 `ipe2_ae_name` varchar(16) DEFAULT NULL,
1493 `available_timestamp` timestamp NULL DEFAULT NULL,
1494 `allocated_timestamp` timestamp NULL DEFAULT NULL,
1495 `disabled_timestamp` timestamp NULL DEFAULT NULL,
1496 `enabled_timestamp` timestamp NULL DEFAULT NULL,
1497 `vpn_id` varchar(12) DEFAULT NULL,
1498 `vpn_rt` varchar(16) DEFAULT NULL,
1499 PRIMARY KEY (`be_id`,`vlan`)
1500 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1501 /*!40101 SET character_set_client = @saved_cs_client */;
1504 -- Table structure for table `NCS_EXPECTED_ASYNC_REQUESTS`
1507 DROP TABLE IF EXISTS `NCS_EXPECTED_ASYNC_REQUESTS`;
1508 /*!40101 SET @saved_cs_client = @@character_set_client */;
1509 /*!40101 SET character_set_client = utf8 */;
1510 CREATE TABLE `NCS_EXPECTED_ASYNC_REQUESTS` (
1511 `ncs_request_id` varchar(255) NOT NULL,
1512 `mso_gp_request_id` varchar(255) NOT NULL,
1513 `service_instance_id` varchar(255) NOT NULL,
1514 `sdn_module_name` varchar(255) NOT NULL,
1515 `sdn_rpc_name` varchar(255) NOT NULL,
1516 `sdn_service_action` varchar(255) DEFAULT NULL,
1517 `ncs_rpc` varchar(255) NOT NULL,
1518 `ncs_sub_action` varchar(255) DEFAULT NULL,
1519 `status` varchar(255) NOT NULL DEFAULT 'inProgress',
1520 `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1521 PRIMARY KEY (`ncs_request_id`)
1522 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1523 /*!40101 SET character_set_client = @saved_cs_client */;
1526 -- Table structure for table `NETWORK_INSTANCE_NAME_INDEX`
1529 DROP TABLE IF EXISTS `NETWORK_INSTANCE_NAME_INDEX`;
1530 /*!40101 SET @saved_cs_client = @@character_set_client */;
1531 /*!40101 SET character_set_client = utf8 */;
1532 CREATE TABLE `NETWORK_INSTANCE_NAME_INDEX` (
1533 `network_instance_name_prefix` varchar(255) NOT NULL,
1534 `index_number` int(11) NOT NULL,
1535 PRIMARY KEY (`network_instance_name_prefix`)
1536 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1537 /*!40101 SET character_set_client = @saved_cs_client */;
1540 -- Table structure for table `NETWORK_MODEL`
1543 DROP TABLE IF EXISTS `NETWORK_MODEL`;
1544 /*!40101 SET @saved_cs_client = @@character_set_client */;
1545 /*!40101 SET character_set_client = utf8 */;
1546 CREATE TABLE `NETWORK_MODEL` (
1547 `customization_uuid` varchar(255) NOT NULL,
1548 `service_uuid` varchar(255) NOT NULL,
1549 `model_yaml` longblob,
1550 `invariant_uuid` varchar(255) DEFAULT NULL,
1551 `uuid` varchar(255) DEFAULT NULL,
1552 `network_type` varchar(255) DEFAULT NULL,
1553 `network_role` varchar(255) DEFAULT NULL,
1554 `network_technology` varchar(255) DEFAULT NULL,
1555 `network_scope` varchar(255) DEFAULT NULL,
1556 `naming_policy` varchar(255) DEFAULT NULL,
1557 `ecomp_generated_naming` char(1) DEFAULT NULL,
1558 `is_shared_network` char(1) DEFAULT NULL,
1559 `is_external_network` char(1) DEFAULT NULL,
1560 `is_provider_network` char(1) DEFAULT NULL,
1561 `physical_network_name` varchar(255) DEFAULT NULL,
1562 `is_bound_to_vpn` char(1) DEFAULT NULL,
1563 `vpn_binding` varchar(255) DEFAULT NULL,
1564 `use_ipv4` char(1) DEFAULT NULL,
1565 `ipv4_dhcp_enabled` char(1) DEFAULT NULL,
1566 `ipv4_ip_version` char(1) DEFAULT NULL,
1567 `ipv4_cidr_mask` varchar(255) DEFAULT NULL,
1568 `eipam_v4_address_plan` varchar(255) DEFAULT NULL,
1569 `use_ipv6` char(1) DEFAULT NULL,
1570 `ipv6_dhcp_enabled` char(1) DEFAULT NULL,
1571 `ipv6_ip_version` char(1) DEFAULT NULL,
1572 `ipv6_cidr_mask` varchar(255) DEFAULT NULL,
1573 `eipam_v6_address_plan` varchar(255) DEFAULT NULL,
1574 `version` varchar(255) DEFAULT NULL,
1575 PRIMARY KEY (`customization_uuid`),
1576 KEY `FK_NETWORK_MODEL` (`service_uuid`),
1577 CONSTRAINT `FK_NETWORK_MODEL` FOREIGN KEY (`service_uuid`) REFERENCES `SERVICE_MODEL` (`service_uuid`) ON DELETE NO ACTION ON UPDATE NO ACTION
1578 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1579 /*!40101 SET character_set_client = @saved_cs_client */;
1582 -- Table structure for table `NETWORK_PROFILE`
1585 DROP TABLE IF EXISTS `NETWORK_PROFILE`;
1586 /*!40101 SET @saved_cs_client = @@character_set_client */;
1587 /*!40101 SET character_set_client = utf8 */;
1588 CREATE TABLE `NETWORK_PROFILE` (
1589 `network_type` varchar(100) NOT NULL,
1590 `technology` varchar(100) NOT NULL,
1591 PRIMARY KEY (`network_type`)
1592 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1593 /*!40101 SET character_set_client = @saved_cs_client */;
1596 -- Table structure for table `NETWORK_ROLE_VPN_BINDING`
1599 DROP TABLE IF EXISTS `NETWORK_ROLE_VPN_BINDING`;
1600 /*!40101 SET @saved_cs_client = @@character_set_client */;
1601 /*!40101 SET character_set_client = utf8 */;
1602 CREATE TABLE `NETWORK_ROLE_VPN_BINDING` (
1603 `network_role` varchar(80) NOT NULL,
1604 `vpn_id` varchar(80) NOT NULL,
1605 PRIMARY KEY (`network_role`,`vpn_id`)
1606 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1607 /*!40101 SET character_set_client = @saved_cs_client */;
1610 -- Table structure for table `NODE_TYPES`
1613 DROP TABLE IF EXISTS `NODE_TYPES`;
1614 /*!40101 SET @saved_cs_client = @@character_set_client */;
1615 /*!40101 SET character_set_client = utf8 */;
1616 CREATE TABLE `NODE_TYPES` (
1617 `nodetype` varchar(80) NOT NULL,
1618 PRIMARY KEY (`nodetype`)
1619 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1620 /*!40101 SET character_set_client = @saved_cs_client */;
1623 -- Table structure for table `OBJECT_GROUPING`
1626 DROP TABLE IF EXISTS `OBJECT_GROUPING`;
1627 /*!40101 SET @saved_cs_client = @@character_set_client */;
1628 /*!40101 SET character_set_client = utf8 */;
1629 CREATE TABLE `OBJECT_GROUPING` (
1630 `group_id` varchar(128) NOT NULL,
1631 `group_type` varchar(128) NOT NULL,
1632 PRIMARY KEY (`group_id`)
1633 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1634 /*!40101 SET character_set_client = @saved_cs_client */;
1637 -- Table structure for table `OBJECT_GROUP_MEMBER_TRACKING`
1640 DROP TABLE IF EXISTS `OBJECT_GROUP_MEMBER_TRACKING`;
1641 /*!40101 SET @saved_cs_client = @@character_set_client */;
1642 /*!40101 SET character_set_client = utf8 */;
1643 CREATE TABLE `OBJECT_GROUP_MEMBER_TRACKING` (
1644 `group_id` varchar(128) NOT NULL,
1645 `key_id` varchar(128) NOT NULL,
1646 `key_type` varchar(128) NOT NULL,
1647 PRIMARY KEY (`group_id`,`key_id`,`key_type`)
1648 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1649 /*!40101 SET character_set_client = @saved_cs_client */;
1652 -- Table structure for table `PARAMETERS`
1655 DROP TABLE IF EXISTS `PARAMETERS`;
1656 /*!40101 SET @saved_cs_client = @@character_set_client */;
1657 /*!40101 SET character_set_client = utf8 */;
1658 CREATE TABLE `PARAMETERS` (
1659 `name` varchar(100) NOT NULL,
1660 `value` varchar(128) NOT NULL,
1661 `category` varchar(24) DEFAULT NULL,
1662 `memo` varchar(128) DEFAULT NULL,
1663 PRIMARY KEY (`name`)
1664 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1665 /*!40101 SET character_set_client = @saved_cs_client */;
1668 -- Table structure for table `PE_INV`
1671 DROP TABLE IF EXISTS `PE_INV`;
1672 /*!40101 SET @saved_cs_client = @@character_set_client */;
1673 /*!40101 SET character_set_client = utf8 */;
1674 CREATE TABLE `PE_INV` (
1675 `EQUIP_ID` int(11) DEFAULT NULL,
1676 `EQUIP_TYPE` varchar(20) DEFAULT NULL,
1677 `PTNII_EQUIP_NAME` varchar(20) DEFAULT NULL,
1678 `IP_ADDR` varchar(15) DEFAULT NULL,
1679 `ROUTER_PROV_STATUS` varchar(50) DEFAULT NULL,
1680 `REGION` varchar(16) DEFAULT NULL,
1681 `COUNTRY_ABBR` varchar(50) DEFAULT NULL,
1682 `EQUIP_NAME_CODE` varchar(50) DEFAULT NULL,
1683 `AS_NUMBER` varchar(5) DEFAULT NULL,
1684 `LOOPBACK1` varchar(15) DEFAULT NULL,
1685 `LOOPBACK2` varchar(15) DEFAULT NULL,
1686 `LOOPBACK3` varchar(15) DEFAULT NULL,
1687 `LOOPBACK40` varchar(15) DEFAULT NULL,
1688 `LOOPBACK65535` varchar(15) DEFAULT NULL,
1689 `INMS_LIST` varchar(20) DEFAULT NULL,
1690 `ENCRYPTED_ACCESS_FLAG` varchar(50) DEFAULT NULL,
1691 `SW_NAME` varchar(100) DEFAULT NULL,
1692 `NMIPADDR` varchar(15) DEFAULT NULL,
1693 `CREATE_DATE` datetime DEFAULT NULL,
1694 `MOD_DATE` datetime DEFAULT NULL,
1695 `FCN_CODE` varchar(50) DEFAULT NULL
1696 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1697 /*!40101 SET character_set_client = @saved_cs_client */;
1700 -- Table structure for table `PHYSICAL_LINK`
1703 DROP TABLE IF EXISTS `PHYSICAL_LINK`;
1704 /*!40101 SET @saved_cs_client = @@character_set_client */;
1705 /*!40101 SET character_set_client = utf8 */;
1706 CREATE TABLE `PHYSICAL_LINK` (
1707 `link_name` varchar(255) NOT NULL,
1708 `speed_value` varchar(64) DEFAULT NULL,
1709 `speed_units` varchar(64) DEFAULT NULL,
1710 `circuit_id` varchar(255) NOT NULL,
1711 `dual_mode` varchar(64) NOT NULL,
1712 PRIMARY KEY (`link_name`)
1713 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1714 /*!40101 SET character_set_client = @saved_cs_client */;
1717 -- Table structure for table `PHYSICAL_LINK_PINTERFACE`
1720 DROP TABLE IF EXISTS `PHYSICAL_LINK_PINTERFACE`;
1721 /*!40101 SET @saved_cs_client = @@character_set_client */;
1722 /*!40101 SET character_set_client = utf8 */;
1723 CREATE TABLE `PHYSICAL_LINK_PINTERFACE` (
1724 `link_name` varchar(255) NOT NULL,
1725 `hostname` varchar(255) NOT NULL,
1726 `port_name_ft` varchar(255) NOT NULL,
1727 PRIMARY KEY (`link_name`,`hostname`,`port_name_ft`)
1728 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1729 /*!40101 SET character_set_client = @saved_cs_client */;
1732 -- Table structure for table `PINTERFACE`
1735 DROP TABLE IF EXISTS `PINTERFACE`;
1736 /*!40101 SET @saved_cs_client = @@character_set_client */;
1737 /*!40101 SET character_set_client = utf8 */;
1738 CREATE TABLE `PINTERFACE` (
1739 `hostname` varchar(255) NOT NULL,
1740 `port_name_ft` varchar(255) NOT NULL,
1741 `interface_name` varchar(255) DEFAULT '',
1742 `physical_speed` varchar(255) DEFAULT '',
1743 `physical_units` varchar(255) DEFAULT '',
1744 `port_description` varchar(255) DEFAULT '',
1745 PRIMARY KEY (`hostname`,`port_name_ft`)
1746 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1747 /*!40101 SET character_set_client = @saved_cs_client */;
1750 -- Table structure for table `POLICY_UPDATE_NOTIFICATION`
1753 DROP TABLE IF EXISTS `POLICY_UPDATE_NOTIFICATION`;
1754 /*!40101 SET @saved_cs_client = @@character_set_client */;
1755 /*!40101 SET character_set_client = utf8 */;
1756 CREATE TABLE `POLICY_UPDATE_NOTIFICATION` (
1757 `policy_name` varchar(255) NOT NULL,
1758 `version_id` varchar(255) NOT NULL,
1759 `update_type` varchar(255) NOT NULL,
1760 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1761 PRIMARY KEY (`policy_name`,`version_id`)
1762 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1763 /*!40101 SET character_set_client = @saved_cs_client */;
1766 -- Table structure for table `PORTAL_USERS`
1769 DROP TABLE IF EXISTS `PORTAL_USERS`;
1770 /*!40101 SET @saved_cs_client = @@character_set_client */;
1771 /*!40101 SET character_set_client = utf8 */;
1772 CREATE TABLE `PORTAL_USERS` (
1773 `attuid` varchar(6) NOT NULL,
1774 `firstName` varchar(25) DEFAULT NULL,
1775 `lastName` varchar(25) DEFAULT NULL,
1776 `role` varchar(25) DEFAULT NULL,
1777 `privilege` char(1) NOT NULL,
1778 `last_login` timestamp NULL DEFAULT NULL,
1779 PRIMARY KEY (`attuid`)
1780 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1781 /*!40101 SET character_set_client = @saved_cs_client */;
1785 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
1788 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
1789 /*!40101 SET @saved_cs_client = @@character_set_client */;
1790 /*!40101 SET character_set_client = utf8 */;
1791 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
1792 `prepare_file_relationship_id` int(11) NOT NULL AUTO_INCREMENT,
1793 `service_instance_id` varchar(50) DEFAULT NULL,
1794 `request_id` varchar(255) DEFAULT NULL,
1795 `config_file_id` int(11) DEFAULT NULL,
1796 `asdc_artifacts_id` int(11) DEFAULT NULL,
1797 PRIMARY KEY (`prepare_file_relationship_id`),
1798 UNIQUE KEY `prepare_file_relationship_id` (`prepare_file_relationship_id`),
1799 KEY `ie_prepare_file_relationship` (`config_file_id`),
1800 KEY `ie2_prepare_file_relationship` (`asdc_artifacts_id`),
1801 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`asdc_artifacts_id`) REFERENCES `ASDC_ARTIFACTS` (`asdc_artifacts_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
1802 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`config_file_id`) REFERENCES `CONFIGFILES` (`config_file_id`) ON DELETE NO ACTION ON UPDATE CASCADE
1803 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1804 /*!40101 SET character_set_client = @saved_cs_client */;
1807 -- Table structure for table `PRE_LOAD_VNF_DATA`
1810 DROP TABLE IF EXISTS `PRE_LOAD_VNF_DATA`;
1811 /*!40101 SET @saved_cs_client = @@character_set_client */;
1812 /*!40101 SET character_set_client = utf8 */;
1813 CREATE TABLE `PRE_LOAD_VNF_DATA` (
1814 `id` int(11) NOT NULL AUTO_INCREMENT,
1815 `svc_request_id` varchar(100) DEFAULT '',
1816 `svc_action` varchar(40) DEFAULT '',
1817 `status` varchar(10) NOT NULL DEFAULT 'pending',
1818 `filename` varchar(100) NOT NULL,
1819 `attuid` varchar(8) NOT NULL,
1820 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1821 `preload_data` longblob,
1823 ) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=latin1;
1824 /*!40101 SET character_set_client = @saved_cs_client */;
1827 -- Table structure for table `PRE_LOAD_VNF_NETWORK_DATA`
1830 DROP TABLE IF EXISTS `PRE_LOAD_VNF_NETWORK_DATA`;
1831 /*!40101 SET @saved_cs_client = @@character_set_client */;
1832 /*!40101 SET character_set_client = utf8 */;
1833 CREATE TABLE `PRE_LOAD_VNF_NETWORK_DATA` (
1834 `id` int(11) NOT NULL AUTO_INCREMENT,
1835 `svc_request_id` varchar(100) DEFAULT '',
1836 `svc_action` varchar(40) DEFAULT '',
1837 `status` varchar(10) NOT NULL DEFAULT 'pending',
1838 `filename` varchar(100) NOT NULL,
1839 `attuid` varchar(8) NOT NULL,
1840 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1841 `preload_data` longblob,
1843 ) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1;
1844 /*!40101 SET character_set_client = @saved_cs_client */;
1847 -- Table structure for table `PSERVER`
1850 DROP TABLE IF EXISTS `PSERVER`;
1851 /*!40101 SET @saved_cs_client = @@character_set_client */;
1852 /*!40101 SET character_set_client = utf8 */;
1853 CREATE TABLE `PSERVER` (
1854 `hostname` varchar(255) NOT NULL,
1855 `ptnii_equip_name` varchar(255) DEFAULT '',
1856 `number_of_cpus` varchar(255) DEFAULT '',
1857 `disk_in_gigabytes` varchar(255) DEFAULT '',
1858 `ram_in_megabytes` varchar(255) DEFAULT '',
1859 `equip_type` varchar(255) DEFAULT '',
1860 `equip_vendor` varchar(255) DEFAULT '',
1861 `equip_model` varchar(255) DEFAULT '',
1862 `fqdn` varchar(255) DEFAULT '',
1863 `pserver_selflink` varchar(255) DEFAULT '',
1864 `ipv4_oam_address` varchar(15) DEFAULT '',
1865 `serial_number` varchar(255) DEFAULT '',
1866 `pserver_id` varchar(255) DEFAULT '',
1867 `internet_topology` varchar(40) DEFAULT '',
1868 `aic_site_id` varchar(100) DEFAULT '',
1869 `in_maint` varchar(5) DEFAULT '',
1870 `pserver_name2` varchar(255) DEFAULT '',
1871 `purpose` varchar(255) DEFAULT '',
1872 PRIMARY KEY (`hostname`)
1873 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1874 /*!40101 SET character_set_client = @saved_cs_client */;
1877 -- Table structure for table `RANGE_RULE`
1880 DROP TABLE IF EXISTS `RANGE_RULE`;
1881 /*!40101 SET @saved_cs_client = @@character_set_client */;
1882 /*!40101 SET character_set_client = utf8 */;
1883 CREATE TABLE `RANGE_RULE` (
1884 `range_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1885 `range_name` varchar(50) NOT NULL,
1886 `service_model` varchar(50) NOT NULL,
1887 `end_point_position` varchar(50) NOT NULL,
1888 `equipment_level` varchar(50) NOT NULL,
1889 `min_value` int(11) NOT NULL,
1890 `max_value` int(11) NOT NULL,
1891 PRIMARY KEY (`range_rule_id`)
1892 ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
1893 /*!40101 SET character_set_client = @saved_cs_client */;
1896 -- Table structure for table `REQUEST_PROGRESS`
1899 DROP TABLE IF EXISTS `REQUEST_PROGRESS`;
1900 /*!40101 SET @saved_cs_client = @@character_set_client */;
1901 /*!40101 SET character_set_client = utf8 */;
1902 CREATE TABLE `REQUEST_PROGRESS` (
1903 `request_id` int(11) NOT NULL AUTO_INCREMENT,
1904 `request_type` varchar(20) DEFAULT NULL,
1905 `service_instance_id` varchar(80) NOT NULL,
1906 `request_instance_type` varchar(20) NOT NULL,
1907 `originating_service_instance_id` varchar(80) DEFAULT NULL,
1908 `originating_service_type` varchar(20) DEFAULT NULL,
1909 `overall_status` varchar(20) DEFAULT NULL,
1910 `status_date` varchar(80) DEFAULT NULL,
1911 `message` varchar(255) DEFAULT NULL,
1912 PRIMARY KEY (`request_id`)
1913 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1914 /*!40101 SET character_set_client = @saved_cs_client */;
1917 -- Table structure for table `REQUEST_PROGRESS_STATE`
1920 DROP TABLE IF EXISTS `REQUEST_PROGRESS_STATE`;
1921 /*!40101 SET @saved_cs_client = @@character_set_client */;
1922 /*!40101 SET character_set_client = utf8 */;
1923 CREATE TABLE `REQUEST_PROGRESS_STATE` (
1924 `request_progress_state_id` int(11) NOT NULL AUTO_INCREMENT,
1925 `request_id` int(11) DEFAULT NULL,
1926 `service_instance_id` varchar(80) NOT NULL,
1927 `request_instance_type` varchar(20) NOT NULL,
1928 `progress_state` varchar(30) DEFAULT NULL,
1929 `transaction_status` varchar(20) DEFAULT NULL,
1930 `status_date` varchar(80) DEFAULT NULL,
1931 `response_code` varchar(20) DEFAULT NULL,
1932 `message` varchar(255) DEFAULT NULL,
1933 PRIMARY KEY (`request_progress_state_id`)
1934 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1935 /*!40101 SET character_set_client = @saved_cs_client */;
1938 -- Table structure for table `RESOURCE`
1941 DROP TABLE IF EXISTS `RESOURCE`;
1942 /*!40101 SET @saved_cs_client = @@character_set_client */;
1943 /*!40101 SET character_set_client = utf8 */;
1944 CREATE TABLE `RESOURCE` (
1945 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1946 `asset_id` varchar(100) NOT NULL,
1947 `resource_name` varchar(50) NOT NULL,
1948 `resource_type` enum('Limit','Label','Range') NOT NULL,
1949 `lt_used` bigint(20) DEFAULT NULL,
1950 `ll_label` varchar(50) DEFAULT NULL,
1951 `ll_reference_count` smallint(6) DEFAULT NULL,
1952 `rr_used` varchar(4000) DEFAULT NULL,
1953 PRIMARY KEY (`resource_id`),
1954 UNIQUE KEY `resource_id` (`resource_id`),
1955 UNIQUE KEY `IX1_RESOURCE` (`asset_id`,`resource_name`)
1956 ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;
1957 /*!40101 SET character_set_client = @saved_cs_client */;
1960 -- Table structure for table `RESOURCE_LOAD`
1963 DROP TABLE IF EXISTS `RESOURCE_LOAD`;
1964 /*!40101 SET @saved_cs_client = @@character_set_client */;
1965 /*!40101 SET character_set_client = utf8 */;
1966 CREATE TABLE `RESOURCE_LOAD` (
1967 `resource_load_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1968 `resource_id` bigint(20) NOT NULL,
1969 `application_id` varchar(20) NOT NULL,
1970 `resource_load_time` datetime NOT NULL,
1971 `resource_expiration_time` datetime DEFAULT NULL,
1972 PRIMARY KEY (`resource_load_id`),
1973 UNIQUE KEY `resource_load_id` (`resource_load_id`),
1974 UNIQUE KEY `IX2_RESOURCE_LOAD` (`resource_id`,`application_id`),
1975 KEY `IX1_RESOURCE_LOAD` (`resource_id`)
1976 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1977 /*!40101 SET character_set_client = @saved_cs_client */;
1980 -- Table structure for table `RESOURCE_LOCK`
1983 DROP TABLE IF EXISTS `RESOURCE_LOCK`;
1984 /*!40101 SET @saved_cs_client = @@character_set_client */;
1985 /*!40101 SET character_set_client = utf8 */;
1986 CREATE TABLE `RESOURCE_LOCK` (
1987 `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1988 `resource_name` varchar(256) DEFAULT NULL,
1989 `lock_holder` varchar(100) NOT NULL,
1990 `lock_count` smallint(6) NOT NULL,
1991 `lock_time` datetime NOT NULL,
1992 `expiration_time` datetime NOT NULL,
1993 PRIMARY KEY (`resource_lock_id`),
1994 UNIQUE KEY `resource_lock_id` (`resource_lock_id`),
1995 UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`)
1996 ) ENGINE=InnoDB AUTO_INCREMENT=29681 DEFAULT CHARSET=latin1;
1997 /*!40101 SET character_set_client = @saved_cs_client */;
2000 -- Table structure for table `RESOURCE_RULE`
2003 DROP TABLE IF EXISTS `RESOURCE_RULE`;
2004 /*!40101 SET @saved_cs_client = @@character_set_client */;
2005 /*!40101 SET character_set_client = utf8 */;
2006 CREATE TABLE `RESOURCE_RULE` (
2007 `resource_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2008 `resource_name` varchar(50) NOT NULL,
2009 `service_model` varchar(50) NOT NULL,
2010 `end_point_position` varchar(50) NOT NULL,
2011 `service_expression` varchar(2000) NOT NULL,
2012 `equipment_level` varchar(50) NOT NULL,
2013 `equipment_expression` varchar(2000) NOT NULL,
2014 `allocation_expression` varchar(2000) NOT NULL,
2015 `soft_limit_expression` varchar(2000) NOT NULL,
2016 `hard_limit_expression` varchar(2000) NOT NULL,
2017 PRIMARY KEY (`resource_rule_id`),
2018 UNIQUE KEY `resource_rule_id` (`resource_rule_id`)
2019 ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
2020 /*!40101 SET character_set_client = @saved_cs_client */;
2023 -- Table structure for table `RESOURCE_THRESHOLD`
2026 DROP TABLE IF EXISTS `RESOURCE_THRESHOLD`;
2027 /*!40101 SET @saved_cs_client = @@character_set_client */;
2028 /*!40101 SET character_set_client = utf8 */;
2029 CREATE TABLE `RESOURCE_THRESHOLD` (
2030 `resource_threshold_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2031 `resource_rule_id` bigint(20) NOT NULL,
2032 `threshold_expression` varchar(2000) NOT NULL,
2033 `threshold_message` varchar(2000) NOT NULL,
2034 PRIMARY KEY (`resource_threshold_id`)
2035 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2036 /*!40101 SET character_set_client = @saved_cs_client */;
2039 -- Table structure for table `ROUTER_MASTER`
2042 DROP TABLE IF EXISTS `ROUTER_MASTER`;
2043 /*!40101 SET @saved_cs_client = @@character_set_client */;
2044 /*!40101 SET character_set_client = utf8 */;
2045 CREATE TABLE `ROUTER_MASTER` (
2046 `crs_name` varchar(20) NOT NULL,
2047 `loopback_ip` varchar(20) NOT NULL,
2048 PRIMARY KEY (`crs_name`)
2049 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2050 /*!40101 SET character_set_client = @saved_cs_client */;
2053 -- Table structure for table `ROUTING_CHARACTERISTIC_MAPPING`
2056 DROP TABLE IF EXISTS `ROUTING_CHARACTERISTIC_MAPPING`;
2057 /*!40101 SET @saved_cs_client = @@character_set_client */;
2058 /*!40101 SET character_set_client = utf8 */;
2059 CREATE TABLE `ROUTING_CHARACTERISTIC_MAPPING` (
2060 `network_role` varchar(255) NOT NULL,
2061 `vrf_name` varchar(255) NOT NULL,
2062 `routing_characteristic` varchar(255) NOT NULL,
2063 PRIMARY KEY (`network_role`,`vrf_name`)
2064 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2065 /*!40101 SET character_set_client = @saved_cs_client */;
2068 -- Table structure for table `SERVICE_HOMING`
2071 DROP TABLE IF EXISTS `SERVICE_HOMING`;
2072 /*!40101 SET @saved_cs_client = @@character_set_client */;
2073 /*!40101 SET character_set_client = utf8 */;
2074 CREATE TABLE `SERVICE_HOMING` (
2075 `service_type` varchar(100) NOT NULL,
2076 `lata` int(3) NOT NULL,
2077 `hubbing_city_type` varchar(40) NOT NULL,
2078 `latitude` float DEFAULT NULL,
2079 `longitude` float DEFAULT NULL,
2080 `primary_aic_site_name` varchar(100) NOT NULL,
2081 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2082 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2083 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2084 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2085 /*!40101 SET character_set_client = @saved_cs_client */;
2088 -- Table structure for table `SERVICE_HOMING_BACKUP`
2091 DROP TABLE IF EXISTS `SERVICE_HOMING_BACKUP`;
2092 /*!40101 SET @saved_cs_client = @@character_set_client */;
2093 /*!40101 SET character_set_client = utf8 */;
2094 CREATE TABLE `SERVICE_HOMING_BACKUP` (
2095 `service_type` varchar(100) NOT NULL,
2096 `lata` int(3) NOT NULL,
2097 `hubbing_city_type` varchar(40) NOT NULL,
2098 `latitude` float DEFAULT NULL,
2099 `longitude` float DEFAULT NULL,
2100 `primary_aic_site_name` varchar(100) NOT NULL,
2101 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2102 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2103 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2104 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2105 /*!40101 SET character_set_client = @saved_cs_client */;
2108 -- Table structure for table `SERVICE_INSTANCE_NAME_INDEX`
2111 DROP TABLE IF EXISTS `SERVICE_INSTANCE_NAME_INDEX`;
2112 /*!40101 SET @saved_cs_client = @@character_set_client */;
2113 /*!40101 SET character_set_client = utf8 */;
2114 CREATE TABLE `SERVICE_INSTANCE_NAME_INDEX` (
2115 `service_instance_name_prefix` varchar(255) NOT NULL,
2116 `index_number` int(11) NOT NULL,
2117 PRIMARY KEY (`service_instance_name_prefix`)
2118 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2119 /*!40101 SET character_set_client = @saved_cs_client */;
2122 -- Table structure for table `SERVICE_MANAGER_CREDENTIALS`
2125 DROP TABLE IF EXISTS `SERVICE_MANAGER_CREDENTIALS`;
2126 /*!40101 SET @saved_cs_client = @@character_set_client */;
2127 /*!40101 SET character_set_client = utf8 */;
2128 CREATE TABLE `SERVICE_MANAGER_CREDENTIALS` (
2129 `service_manager_username` varchar(255) NOT NULL,
2130 `service_manager_password` varbinary(255) NOT NULL,
2131 PRIMARY KEY (`service_manager_username`)
2132 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2133 /*!40101 SET character_set_client = @saved_cs_client */;
2136 -- Table structure for table `SERVICE_MODEL`
2139 DROP TABLE IF EXISTS `SERVICE_MODEL`;
2140 /*!40101 SET @saved_cs_client = @@character_set_client */;
2141 /*!40101 SET character_set_client = utf8 */;
2142 CREATE TABLE `SERVICE_MODEL` (
2143 `service_uuid` varchar(255) NOT NULL,
2144 `model_yaml` longblob,
2145 `invariant_uuid` varchar(255) DEFAULT NULL,
2146 `version` varchar(255) DEFAULT NULL,
2147 `name` varchar(255) DEFAULT NULL,
2148 `description` varchar(1024) DEFAULT NULL,
2149 `type` varchar(255) DEFAULT NULL,
2150 `category` varchar(255) DEFAULT NULL,
2151 `ecomp_naming` char(1) DEFAULT NULL,
2152 `service_instance_name_prefix` varchar(255) DEFAULT NULL,
2153 `filename` varchar(100) DEFAULT NULL,
2154 `naming_policy` varchar(255) DEFAULT NULL,
2155 PRIMARY KEY (`service_uuid`)
2156 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2157 /*!40101 SET character_set_client = @saved_cs_client */;
2160 -- Table structure for table `SERVICE_PROXY`
2163 DROP TABLE IF EXISTS `SERVICE_PROXY`;
2164 /*!40101 SET @saved_cs_client = @@character_set_client */;
2165 /*!40101 SET character_set_client = utf8 */;
2166 CREATE TABLE `SERVICE_PROXY` (
2167 `port_mirror_service_uuid` varchar(255) NOT NULL,
2168 `service_proxy_name` varchar(255) NOT NULL,
2169 `source_service_uuid` varchar(255) NOT NULL,
2170 `resources_vendor` varchar(255) DEFAULT NULL,
2171 `resource_vendor_release` varchar(255) DEFAULT NULL,
2172 `description` varchar(255) DEFAULT NULL,
2173 `category` varchar(255) DEFAULT NULL,
2174 `subcategory` varchar(255) DEFAULT NULL,
2175 `version` varchar(255) DEFAULT NULL,
2176 `role` varchar(255) NOT NULL,
2177 `uuid` varchar(255) DEFAULT NULL,
2178 `customization_uuid` varchar(255) DEFAULT NULL,
2179 `invariant_uuid` varchar(255) DEFAULT NULL,
2180 PRIMARY KEY (`port_mirror_service_uuid`,`service_proxy_name`),
2181 KEY `FK_SERVICE_PROXY_SOURCE_TO_SERVICE_MODE` (`source_service_uuid`),
2182 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
2183 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2184 /*!40101 SET character_set_client = @saved_cs_client */;
2187 -- Table structure for table `SERVICE_RESOURCE`
2190 DROP TABLE IF EXISTS `SERVICE_RESOURCE`;
2191 /*!40101 SET @saved_cs_client = @@character_set_client */;
2192 /*!40101 SET character_set_client = utf8 */;
2193 CREATE TABLE `SERVICE_RESOURCE` (
2194 `service_resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2195 `service_instance_id` varchar(80) NOT NULL,
2196 `service_status` enum('Active','Pending') NOT NULL,
2197 `service_change_number` smallint(6) NOT NULL,
2198 `resource_set_id` varchar(100) NOT NULL,
2199 `resource_union_id` varchar(100) NOT NULL,
2200 PRIMARY KEY (`service_instance_id`,`service_change_number`),
2201 UNIQUE KEY `service_resource_id` (`service_resource_id`),
2202 KEY `IX1_SERVICE_RESOURCE` (`service_instance_id`)
2203 ) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=latin1;
2204 /*!40101 SET character_set_client = @saved_cs_client */;
2207 -- Table structure for table `SERVICE_TYPE_MAPPING`
2210 DROP TABLE IF EXISTS `SERVICE_TYPE_MAPPING`;
2211 /*!40101 SET @saved_cs_client = @@character_set_client */;
2212 /*!40101 SET character_set_client = utf8 */;
2213 CREATE TABLE `SERVICE_TYPE_MAPPING` (
2214 `sdnc_service_type` varchar(128) NOT NULL,
2215 `ncs_service_type` varchar(128) NOT NULL,
2216 PRIMARY KEY (`sdnc_service_type`,`ncs_service_type`)
2217 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2218 /*!40101 SET character_set_client = @saved_cs_client */;
2221 -- Table structure for table `SUBNETPOOL_MAPPING`
2224 DROP TABLE IF EXISTS `SUBNETPOOL_MAPPING`;
2225 /*!40101 SET @saved_cs_client = @@character_set_client */;
2226 /*!40101 SET character_set_client = utf8 */;
2227 CREATE TABLE `SUBNETPOOL_MAPPING` (
2228 `aic_cloud_region` varchar(16) NOT NULL,
2229 `ntc` varchar(32) NOT NULL,
2230 `lcp` varchar(32) NOT NULL,
2231 `aic_region_id` varchar(255) NOT NULL,
2232 PRIMARY KEY (`aic_cloud_region`)
2233 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2234 /*!40101 SET character_set_client = @saved_cs_client */;
2237 -- Table structure for table `SUPPORTED_SEQUENCE_NUMBER`
2240 DROP TABLE IF EXISTS `SUPPORTED_SEQUENCE_NUMBER`;
2241 /*!40101 SET @saved_cs_client = @@character_set_client */;
2242 /*!40101 SET character_set_client = utf8 */;
2243 CREATE TABLE `SUPPORTED_SEQUENCE_NUMBER` (
2244 `resource_sequence_number` varchar(10) NOT NULL,
2245 `resource_type` varchar(10) NOT NULL,
2246 PRIMARY KEY (`resource_sequence_number`,`resource_type`)
2247 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2248 /*!40101 SET character_set_client = @saved_cs_client */;
2251 -- Table structure for table `SVC_LOGIC`
2254 DROP TABLE IF EXISTS `SVC_LOGIC`;
2255 /*!40101 SET @saved_cs_client = @@character_set_client */;
2256 /*!40101 SET character_set_client = utf8 */;
2257 CREATE TABLE `SVC_LOGIC` (
2258 `module` varchar(80) NOT NULL,
2259 `rpc` varchar(80) NOT NULL,
2260 `version` varchar(40) NOT NULL,
2261 `mode` varchar(5) NOT NULL,
2262 `active` varchar(1) NOT NULL,
2264 `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2265 `md5sum` varchar(128) DEFAULT NULL,
2266 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
2267 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2268 /*!40101 SET character_set_client = @saved_cs_client */;
2271 -- Table structure for table `TABLE_CLEANUP_CONFIGURATION`
2274 DROP TABLE IF EXISTS `TABLE_CLEANUP_CONFIGURATION`;
2275 /*!40101 SET @saved_cs_client = @@character_set_client */;
2276 /*!40101 SET character_set_client = utf8 */;
2277 CREATE TABLE `TABLE_CLEANUP_CONFIGURATION` (
2278 `table_name` varchar(255) NOT NULL COMMENT 'The name of the table the cleanup will be performed on',
2279 `days_old` int(11) NOT NULL COMMENT 'Records older than the current date minus DAYS_OLD will be deleted',
2280 `date_column` varchar(255) NOT NULL COMMENT 'The name of the column containing the date to be checked',
2281 `commit_interval` int(11) NOT NULL DEFAULT '2500' COMMENT 'The maximum number of rows a commit may contain',
2282 `query_clause` varchar(1000) DEFAULT NULL COMMENT 'An optional additional query clause to further restrict deletion criteria',
2283 `child_table_name` varchar(255) DEFAULT NULL,
2284 `child_table_pk` varchar(255) DEFAULT NULL,
2285 PRIMARY KEY (`table_name`)
2286 ) 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.';
2287 /*!40101 SET character_set_client = @saved_cs_client */;
2290 -- Table structure for table `TASK_TEMPLATE`
2293 DROP TABLE IF EXISTS `TASK_TEMPLATE`;
2294 /*!40101 SET @saved_cs_client = @@character_set_client */;
2295 /*!40101 SET character_set_client = utf8 */;
2296 CREATE TABLE `TASK_TEMPLATE` (
2297 `task_template_id` int(11) NOT NULL AUTO_INCREMENT,
2298 `request_type` varchar(20) DEFAULT NULL,
2299 `task_name` varchar(30) NOT NULL,
2300 `task_category` varchar(50) NOT NULL,
2301 `ecomp_task` varchar(50) NOT NULL,
2302 `initial_load` varchar(1) NOT NULL,
2303 `service` varchar(20) DEFAULT NULL,
2304 PRIMARY KEY (`task_template_id`)
2305 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2306 /*!40101 SET character_set_client = @saved_cs_client */;
2309 -- Table structure for table `TENANT`
2312 DROP TABLE IF EXISTS `TENANT`;
2313 /*!40101 SET @saved_cs_client = @@character_set_client */;
2314 /*!40101 SET character_set_client = utf8 */;
2315 CREATE TABLE `TENANT` (
2316 `tenant_id` varchar(255) NOT NULL,
2317 `tenant_name` varchar(255) NOT NULL,
2318 `service_instance_id` varchar(255) NOT NULL,
2319 PRIMARY KEY (`tenant_id`,`tenant_name`)
2320 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2321 /*!40101 SET character_set_client = @saved_cs_client */;
2324 -- Table structure for table `TESTTBL`
2327 DROP TABLE IF EXISTS `TESTTBL`;
2328 /*!40101 SET @saved_cs_client = @@character_set_client */;
2329 /*!40101 SET character_set_client = utf8 */;
2330 CREATE TABLE `TESTTBL` (
2331 `pk` varchar(25) NOT NULL,
2332 `col1` varchar(25) DEFAULT NULL
2333 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2334 /*!40101 SET character_set_client = @saved_cs_client */;
2337 -- Table structure for table `THRESHOLD_NOTIFICATION`
2340 DROP TABLE IF EXISTS `THRESHOLD_NOTIFICATION`;
2341 /*!40101 SET @saved_cs_client = @@character_set_client */;
2342 /*!40101 SET character_set_client = utf8 */;
2343 CREATE TABLE `THRESHOLD_NOTIFICATION` (
2344 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2345 `threshold_expression` varchar(2000) DEFAULT NULL,
2346 `threshold_message` varchar(500) DEFAULT NULL,
2347 PRIMARY KEY (`resource_id`)
2348 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2349 /*!40101 SET character_set_client = @saved_cs_client */;
2352 -- Table structure for table `TMP_AIC_AVAIL_ZONE_POOL`
2355 DROP TABLE IF EXISTS `TMP_AIC_AVAIL_ZONE_POOL`;
2356 /*!40101 SET @saved_cs_client = @@character_set_client */;
2357 /*!40101 SET character_set_client = utf8 */;
2358 CREATE TABLE `TMP_AIC_AVAIL_ZONE_POOL` (
2359 `aic_site_id` varchar(100) NOT NULL,
2360 `status` varchar(40) NOT NULL,
2361 `availability_zone` varchar(100) NOT NULL,
2362 `token` int(4) NOT NULL,
2363 `vnf_id` varchar(80) DEFAULT NULL,
2364 `service_type` varchar(100) NOT NULL,
2365 `vnf_type` varchar(20) DEFAULT NULL,
2366 `hypervisor` varchar(10) DEFAULT NULL,
2367 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
2368 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2369 /*!40101 SET character_set_client = @saved_cs_client */;
2372 -- Table structure for table `TOPOLOGY_PARAMETER`
2375 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER`;
2376 /*!40101 SET @saved_cs_client = @@character_set_client */;
2377 /*!40101 SET character_set_client = utf8 */;
2378 CREATE TABLE `TOPOLOGY_PARAMETER` (
2379 `parameter_id` int(11) NOT NULL,
2380 `parameter_name` varchar(20) NOT NULL,
2381 `parameter_set` int(11) NOT NULL,
2382 `create_update_time` datetime NOT NULL,
2383 `create_update_user` varchar(40) NOT NULL,
2384 PRIMARY KEY (`parameter_id`)
2385 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2386 /*!40101 SET character_set_client = @saved_cs_client */;
2389 -- Table structure for table `TOPOLOGY_PARAMETER_ENTRIES`
2392 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_ENTRIES`;
2393 /*!40101 SET @saved_cs_client = @@character_set_client */;
2394 /*!40101 SET character_set_client = utf8 */;
2395 CREATE TABLE `TOPOLOGY_PARAMETER_ENTRIES` (
2396 `parameter_entry_id` int(11) NOT NULL,
2397 `parameter_name` varchar(255) NOT NULL,
2398 `parameter_value` varchar(64) NOT NULL,
2399 `create_update_time` datetime NOT NULL,
2400 `create_update_user` varchar(40) NOT NULL,
2401 PRIMARY KEY (`parameter_entry_id`)
2402 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2403 /*!40101 SET character_set_client = @saved_cs_client */;
2406 -- Table structure for table `TOPOLOGY_PARAMETER_TO_ENTRIES`
2409 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_TO_ENTRIES`;
2410 /*!40101 SET @saved_cs_client = @@character_set_client */;
2411 /*!40101 SET character_set_client = utf8 */;
2412 CREATE TABLE `TOPOLOGY_PARAMETER_TO_ENTRIES` (
2413 `parameter_id` int(11) DEFAULT NULL,
2414 `parameter_entry_id` int(11) DEFAULT NULL,
2415 `entry_order` int(11) DEFAULT NULL,
2416 `create_update_time` datetime DEFAULT NULL,
2417 `create_update_user` varchar(40) NOT NULL,
2418 KEY `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_id`),
2419 KEY `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_entry_id`),
2420 CONSTRAINT `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_id`) REFERENCES `TOPOLOGY_PARAMETER` (`parameter_id`),
2421 CONSTRAINT `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_entry_id`) REFERENCES `TOPOLOGY_PARAMETER_ENTRIES` (`parameter_entry_id`)
2422 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2423 /*!40101 SET character_set_client = @saved_cs_client */;
2426 -- Table structure for table `TRANSACTION_LOG`
2429 DROP TABLE IF EXISTS `TRANSACTION_LOG`;
2430 /*!40101 SET @saved_cs_client = @@character_set_client */;
2431 /*!40101 SET character_set_client = utf8 */;
2432 CREATE TABLE `TRANSACTION_LOG` (
2433 `serial_key` int(10) NOT NULL AUTO_INCREMENT,
2434 `log_time` varchar(40) NOT NULL,
2435 `request_id` varchar(80) DEFAULT NULL,
2436 `svc_request_id` varchar(80) DEFAULT NULL,
2437 `x_ecomp_request_id` varchar(80) DEFAULT NULL,
2438 `graph_name` varchar(255) DEFAULT NULL,
2439 PRIMARY KEY (`serial_key`)
2440 ) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;
2441 /*!40101 SET character_set_client = @saved_cs_client */;
2445 -- Table structure for table `UPLOAD_CONFIG`
2448 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
2449 /*!40101 SET @saved_cs_client = @@character_set_client */;
2450 /*!40101 SET character_set_client = utf8 */;
2451 CREATE TABLE `UPLOAD_CONFIG` (
2452 `upload_config_id` int(11) NOT NULL AUTO_INCREMENT,
2453 `request_id` varchar(50) DEFAULT NULL,
2454 `originator_id` varchar(50) DEFAULT NULL,
2455 `service_description` varchar(100) DEFAULT NULL,
2456 `action` varchar(50) DEFAULT NULL,
2457 `upload_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
2458 `vnf_id` varchar(50) DEFAULT NULL,
2459 `vnf_name` varchar(50) DEFAULT NULL,
2460 `vm_name` varchar(50) DEFAULT NULL,
2461 `vnf_type` varchar(50) DEFAULT NULL,
2462 `vnfc_type` varchar(50) DEFAULT NULL,
2463 `host_ip_address` varchar(50) DEFAULT NULL,
2464 `config_indicator` varchar(25) DEFAULT NULL,
2465 `pending_delete` varchar(1) DEFAULT NULL,
2467 PRIMARY KEY (`upload_config_id`),
2468 UNIQUE KEY `upload_config_id` (`upload_config_id`)
2469 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2470 /*!40101 SET character_set_client = @saved_cs_client */;
2473 -- Table structure for table `USED_SEQUENCE_NUMBER`
2476 DROP TABLE IF EXISTS `USED_SEQUENCE_NUMBER`;
2477 /*!40101 SET @saved_cs_client = @@character_set_client */;
2478 /*!40101 SET character_set_client = utf8 */;
2479 CREATE TABLE `USED_SEQUENCE_NUMBER` (
2480 `resource_sequence_number` varchar(10) NOT NULL,
2481 `resource_type` varchar(10) NOT NULL,
2482 `zone_region_id` varchar(50) NOT NULL,
2483 PRIMARY KEY (`resource_sequence_number`,`resource_type`,`zone_region_id`)
2484 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2485 /*!40101 SET character_set_client = @saved_cs_client */;
2488 -- Table structure for table `USER_TRACE`
2491 DROP TABLE IF EXISTS `USER_TRACE`;
2492 /*!40101 SET @saved_cs_client = @@character_set_client */;
2493 /*!40101 SET character_set_client = utf8 */;
2494 CREATE TABLE `USER_TRACE` (
2495 `user_trace_seq` int(11) NOT NULL AUTO_INCREMENT,
2496 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2497 `identity` varchar(12) DEFAULT NULL,
2498 `action` varchar(128) DEFAULT NULL,
2499 `description` varchar(256) DEFAULT NULL,
2500 PRIMARY KEY (`user_trace_seq`)
2501 ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=latin1;
2502 /*!40101 SET character_set_client = @saved_cs_client */;
2505 -- Table structure for table `VENDOR_CODE`
2508 DROP TABLE IF EXISTS `VENDOR_CODE`;
2509 /*!40101 SET @saved_cs_client = @@character_set_client */;
2510 /*!40101 SET character_set_client = utf8 */;
2511 CREATE TABLE `VENDOR_CODE` (
2512 `vendor_code` varchar(1) NOT NULL,
2513 `vendor` varchar(45) NOT NULL DEFAULT '',
2514 PRIMARY KEY (`vendor_code`,`vendor`)
2515 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2516 /*!40101 SET character_set_client = @saved_cs_client */;
2519 -- Table structure for table `VFC_MODEL`
2522 DROP TABLE IF EXISTS `VFC_MODEL`;
2523 /*!40101 SET @saved_cs_client = @@character_set_client */;
2524 /*!40101 SET character_set_client = utf8 */;
2525 CREATE TABLE `VFC_MODEL` (
2526 `customization_uuid` varchar(255) NOT NULL,
2527 `model_yaml` longblob,
2528 `invariant_uuid` varchar(255) DEFAULT NULL,
2529 `uuid` varchar(255) DEFAULT NULL,
2530 `version` varchar(255) DEFAULT NULL,
2531 `naming_policy` varchar(255) DEFAULT NULL,
2532 `ecomp_generated_naming` char(1) DEFAULT NULL,
2533 `nfc_function` varchar(255) DEFAULT NULL,
2534 `nfc_naming_code` varchar(255) DEFAULT NULL,
2535 `vm_type` varchar(255) DEFAULT NULL,
2536 `vm_type_tag` varchar(255) DEFAULT NULL,
2537 `vm_image_name` varchar(255) DEFAULT NULL,
2538 `vm_flavor_name` varchar(255) DEFAULT NULL,
2539 `high_availability` varchar(255) DEFAULT NULL,
2540 `nfc_naming` varchar(255) DEFAULT NULL,
2541 `min_instances` int(11) DEFAULT NULL,
2542 `max_instances` int(11) DEFAULT NULL,
2543 PRIMARY KEY (`customization_uuid`)
2544 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2545 /*!40101 SET character_set_client = @saved_cs_client */;
2548 -- Table structure for table `VFC_TO_NETWORK_ROLE_MAPPING`
2551 DROP TABLE IF EXISTS `VFC_TO_NETWORK_ROLE_MAPPING`;
2552 /*!40101 SET @saved_cs_client = @@character_set_client */;
2553 /*!40101 SET character_set_client = utf8 */;
2554 CREATE TABLE `VFC_TO_NETWORK_ROLE_MAPPING` (
2555 `seq` int(11) NOT NULL AUTO_INCREMENT,
2556 `vfc_customization_uuid` varchar(255) NOT NULL,
2557 `network_role` varchar(255) NOT NULL,
2558 `vm_type` varchar(255) DEFAULT NULL,
2559 `network_role_tag` varchar(255) DEFAULT NULL,
2560 `ipv4_count` int(11) NOT NULL,
2561 `ipv6_count` int(11) NOT NULL,
2562 `ipv4_use_dhcp` char(1) DEFAULT NULL,
2563 `ipv6_use_dhcp` char(1) DEFAULT NULL,
2564 `ipv4_ip_version` char(1) DEFAULT NULL,
2565 `ipv6_ip_version` char(1) DEFAULT NULL,
2566 `extcp_subnetpool_id` varchar(512) DEFAULT NULL,
2567 `ipv4_floating_count` int(11) DEFAULT NULL,
2568 `ipv6_floating_count` int(11) DEFAULT NULL,
2569 `ipv4_address_plan_name` varchar(512) DEFAULT NULL,
2570 `ipv6_address_plan_name` varchar(512) DEFAULT NULL,
2571 `ipv4_vrf_name` varchar(512) DEFAULT NULL,
2572 `ipv6_vrf_name` varchar(512) DEFAULT NULL,
2573 `subnet_role` varchar(255) DEFAULT NULL,
2574 PRIMARY KEY (`seq`),
2575 KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`)
2576 ) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1;
2577 /*!40101 SET character_set_client = @saved_cs_client */;
2580 -- Table structure for table `VF_MODEL`
2583 DROP TABLE IF EXISTS `VF_MODEL`;
2584 /*!40101 SET @saved_cs_client = @@character_set_client */;
2585 /*!40101 SET character_set_client = utf8 */;
2586 CREATE TABLE `VF_MODEL` (
2587 `customization_uuid` varchar(255) NOT NULL,
2588 `model_yaml` longblob,
2589 `invariant_uuid` varchar(255) DEFAULT NULL,
2590 `uuid` varchar(255) DEFAULT NULL,
2591 `version` varchar(255) DEFAULT NULL,
2592 `name` varchar(255) DEFAULT NULL,
2593 `naming_policy` varchar(255) DEFAULT NULL,
2594 `ecomp_generated_naming` char(1) DEFAULT NULL,
2595 `avail_zone_max_count` int(11) DEFAULT NULL,
2596 `nf_function` varchar(255) DEFAULT NULL,
2597 `nf_code` varchar(255) DEFAULT NULL,
2598 `nf_type` varchar(255) DEFAULT NULL,
2599 `nf_role` varchar(255) DEFAULT NULL,
2600 `vendor` varchar(255) DEFAULT NULL,
2601 `vendor_version` varchar(255) DEFAULT NULL,
2602 PRIMARY KEY (`customization_uuid`)
2603 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2604 /*!40101 SET character_set_client = @saved_cs_client */;
2607 -- Table structure for table `VF_MODULE_MODEL`
2610 DROP TABLE IF EXISTS `VF_MODULE_MODEL`;
2611 /*!40101 SET @saved_cs_client = @@character_set_client */;
2612 /*!40101 SET character_set_client = utf8 */;
2613 CREATE TABLE `VF_MODULE_MODEL` (
2614 `customization_uuid` varchar(255) NOT NULL,
2615 `model_yaml` longblob,
2616 `invariant_uuid` varchar(255) DEFAULT NULL,
2617 `uuid` varchar(255) DEFAULT NULL,
2618 `version` varchar(255) DEFAULT NULL,
2619 `vf_module_type` varchar(255) DEFAULT NULL,
2620 `availability_zone_count` int(11) DEFAULT NULL,
2621 `ecomp_generated_vm_assignments` char(1) DEFAULT NULL,
2622 PRIMARY KEY (`customization_uuid`)
2623 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2624 /*!40101 SET character_set_client = @saved_cs_client */;
2627 -- Table structure for table `VF_MODULE_TO_VFC_MAPPING`
2630 DROP TABLE IF EXISTS `VF_MODULE_TO_VFC_MAPPING`;
2631 /*!40101 SET @saved_cs_client = @@character_set_client */;
2632 /*!40101 SET character_set_client = utf8 */;
2633 CREATE TABLE `VF_MODULE_TO_VFC_MAPPING` (
2634 `seq` int(11) NOT NULL AUTO_INCREMENT,
2635 `vf_module_customization_uuid` varchar(255) NOT NULL,
2636 `vfc_customization_uuid` varchar(255) NOT NULL,
2637 `vm_type` varchar(255) NOT NULL,
2638 `vm_count` int(11) NOT NULL,
2639 PRIMARY KEY (`seq`),
2640 KEY `IX1_VF_MODULE_TO_VFC_MAPPING` (`vf_module_customization_uuid`)
2641 ) ENGINE=InnoDB AUTO_INCREMENT=1591 DEFAULT CHARSET=latin1;
2642 /*!40101 SET character_set_client = @saved_cs_client */;
2645 -- Table structure for table `VF_TO_NETWORK_ROLE_MAPPING`
2648 DROP TABLE IF EXISTS `VF_TO_NETWORK_ROLE_MAPPING`;
2649 /*!40101 SET @saved_cs_client = @@character_set_client */;
2650 /*!40101 SET character_set_client = utf8 */;
2651 CREATE TABLE `VF_TO_NETWORK_ROLE_MAPPING` (
2652 `seq` int(11) NOT NULL AUTO_INCREMENT,
2653 `vf_customization_uuid` varchar(255) NOT NULL,
2654 `network_role` varchar(255) NOT NULL,
2655 PRIMARY KEY (`seq`),
2656 KEY `IX1_VF_TO_NETWORK_ROLE_MAPPING` (`vf_customization_uuid`)
2657 ) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=latin1;
2658 /*!40101 SET character_set_client = @saved_cs_client */;
2661 -- Table structure for table `VIPR_CONFIGURATION`
2664 DROP TABLE IF EXISTS `VIPR_CONFIGURATION`;
2665 /*!40101 SET @saved_cs_client = @@character_set_client */;
2666 /*!40101 SET character_set_client = utf8 */;
2667 CREATE TABLE `VIPR_CONFIGURATION` (
2668 `seq` int(11) NOT NULL AUTO_INCREMENT,
2669 `serial_number` varchar(255) DEFAULT NULL,
2670 `vnf_id` varchar(255) DEFAULT NULL,
2671 `vnf_name` varchar(255) DEFAULT NULL,
2672 `ecomp_service_instance_id` varchar(255) DEFAULT NULL,
2673 `vm_name` varchar(255) DEFAULT NULL,
2674 `cloud_region_id` varchar(255) DEFAULT NULL,
2675 `cloud_owner` varchar(255) DEFAULT NULL,
2677 ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
2678 /*!40101 SET character_set_client = @saved_cs_client */;
2681 -- Table structure for table `VIPR_SZ_MANAGER_KEY`
2684 DROP TABLE IF EXISTS `VIPR_SZ_MANAGER_KEY`;
2685 /*!40101 SET @saved_cs_client = @@character_set_client */;
2686 /*!40101 SET character_set_client = utf8 */;
2687 CREATE TABLE `VIPR_SZ_MANAGER_KEY` (
2688 `vipr_sz_manager_ip_addr` varchar(40) NOT NULL,
2689 `vipr_sz_manager_state` varchar(10) DEFAULT NULL,
2690 `vipr_sz_manager_api_key` varchar(255) DEFAULT NULL,
2691 PRIMARY KEY (`vipr_sz_manager_ip_addr`)
2692 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2693 /*!40101 SET character_set_client = @saved_cs_client */;
2696 -- Table structure for table `VLAN_ID_POOL`
2699 DROP TABLE IF EXISTS `VLAN_ID_POOL`;
2700 /*!40101 SET @saved_cs_client = @@character_set_client */;
2701 /*!40101 SET character_set_client = utf8 */;
2702 CREATE TABLE `VLAN_ID_POOL` (
2703 `aic_site_id` varchar(100) NOT NULL,
2704 `purpose` varchar(40) NOT NULL,
2705 `status` varchar(40) NOT NULL,
2706 `vlan_id` int(4) NOT NULL,
2707 `svc_instance_id` varchar(80) DEFAULT NULL,
2708 `availability_zone` varchar(100) DEFAULT NULL,
2709 `vplspe_name` varchar(80) DEFAULT NULL,
2710 PRIMARY KEY (`vlan_id`,`aic_site_id`,`purpose`)
2711 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2712 /*!40101 SET character_set_client = @saved_cs_client */;
2715 -- Table structure for table `VLAN_L3INTERFACE_IPV4_ADDRESS`
2718 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV4_ADDRESS`;
2719 /*!40101 SET @saved_cs_client = @@character_set_client */;
2720 /*!40101 SET character_set_client = utf8 */;
2721 CREATE TABLE `VLAN_L3INTERFACE_IPV4_ADDRESS` (
2722 `vnf_id` varchar(80) NOT NULL,
2723 `interface_name` varchar(255) NOT NULL,
2724 `vlan_interface` varchar(255) NOT NULL,
2725 `l3_interface_ipv4_address` varchar(64) NOT NULL,
2726 `l3_interface_ipv4_prefix_length` varchar(45) DEFAULT NULL,
2727 `vlan_id_inner` varchar(45) DEFAULT NULL,
2728 `vlan_id_outer` varchar(45) DEFAULT NULL,
2729 `is_floating` varchar(1) DEFAULT NULL,
2730 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv4_address`),
2731 KEY `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`),
2732 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
2733 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2734 /*!40101 SET character_set_client = @saved_cs_client */;
2737 -- Table structure for table `VLAN_L3INTERFACE_IPV6_ADDRESS`
2740 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV6_ADDRESS`;
2741 /*!40101 SET @saved_cs_client = @@character_set_client */;
2742 /*!40101 SET character_set_client = utf8 */;
2743 CREATE TABLE `VLAN_L3INTERFACE_IPV6_ADDRESS` (
2744 `vnf_id` varchar(80) NOT NULL,
2745 `interface_name` varchar(255) NOT NULL,
2746 `vlan_interface` varchar(255) NOT NULL,
2747 `l3_interface_ipv6_address` varchar(64) NOT NULL,
2748 `l3_interface_ipv6_prefix_length` varchar(45) DEFAULT NULL,
2749 `vlan_id_inner` varchar(45) DEFAULT NULL,
2750 `vlan_id_outer` varchar(45) DEFAULT NULL,
2751 `is_floating` varchar(1) DEFAULT NULL,
2752 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv6_address`),
2753 KEY `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`,`vlan_interface`),
2754 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
2755 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2756 /*!40101 SET character_set_client = @saved_cs_client */;
2759 -- Table structure for table `VLAN_PLAN_ID`
2762 DROP TABLE IF EXISTS `VLAN_PLAN_ID`;
2763 /*!40101 SET @saved_cs_client = @@character_set_client */;
2764 /*!40101 SET character_set_client = utf8 */;
2765 CREATE TABLE `VLAN_PLAN_ID` (
2766 `plan_type` varchar(40) NOT NULL,
2767 `purpose` varchar(40) NOT NULL,
2768 `vlan_plan_id_count` int(4) NOT NULL,
2769 PRIMARY KEY (`vlan_plan_id_count`,`plan_type`,`purpose`)
2770 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2771 /*!40101 SET character_set_client = @saved_cs_client */;
2774 -- Table structure for table `VLAN_POOL`
2777 DROP TABLE IF EXISTS `VLAN_POOL`;
2778 /*!40101 SET @saved_cs_client = @@character_set_client */;
2779 /*!40101 SET character_set_client = utf8 */;
2780 CREATE TABLE `VLAN_POOL` (
2781 `aic_site_id` varchar(100) NOT NULL,
2782 `availability_zone` varchar(100) NOT NULL,
2783 `vlan_plan_id` varchar(100) NOT NULL,
2784 `plan_type` varchar(40) NOT NULL,
2785 `purpose` varchar(40) NOT NULL,
2786 `vlan_id` int(4) NOT NULL,
2787 `status` varchar(40) NOT NULL,
2788 `reserved_id` varchar(80) DEFAULT NULL,
2789 PRIMARY KEY (`aic_site_id`,`availability_zone`,`vlan_plan_id`,`plan_type`,`purpose`,`vlan_id`)
2790 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2791 /*!40101 SET character_set_client = @saved_cs_client */;
2794 -- Table structure for table `VLAN_RANGES`
2797 DROP TABLE IF EXISTS `VLAN_RANGES`;
2798 /*!40101 SET @saved_cs_client = @@character_set_client */;
2799 /*!40101 SET character_set_client = utf8 */;
2800 CREATE TABLE `VLAN_RANGES` (
2801 `vlan_plan_id` varchar(100) NOT NULL,
2802 `plan_type` varchar(40) NOT NULL,
2803 `purpose` varchar(40) NOT NULL,
2804 `range_start` int(4) NOT NULL,
2805 `range_end` int(4) NOT NULL,
2806 `generated` char(1) DEFAULT NULL,
2807 PRIMARY KEY (`vlan_plan_id`,`plan_type`,`purpose`,`range_start`,`range_end`)
2808 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2809 /*!40101 SET character_set_client = @saved_cs_client */;
2812 -- Table structure for table `VM_NAME_INDEX`
2815 DROP TABLE IF EXISTS `VM_NAME_INDEX`;
2816 /*!40101 SET @saved_cs_client = @@character_set_client */;
2817 /*!40101 SET character_set_client = utf8 */;
2818 CREATE TABLE `VM_NAME_INDEX` (
2819 `vm_name_prefix` varchar(255) NOT NULL,
2820 `index_number` int(11) NOT NULL,
2821 PRIMARY KEY (`vm_name_prefix`)
2822 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2823 /*!40101 SET character_set_client = @saved_cs_client */;
2826 -- Table structure for table `VM_NETWORKS`
2829 DROP TABLE IF EXISTS `VM_NETWORKS`;
2830 /*!40101 SET @saved_cs_client = @@character_set_client */;
2831 /*!40101 SET character_set_client = utf8 */;
2832 CREATE TABLE `VM_NETWORKS` (
2833 `vnf_type` varchar(200) NOT NULL,
2834 `vm_type` varchar(45) NOT NULL,
2835 `network_role` varchar(45) NOT NULL,
2836 `assign_ips` tinyint(1) NOT NULL,
2837 `assign_macs` tinyint(1) NOT NULL,
2838 `assign_floating_ip` tinyint(1) NOT NULL,
2839 `ip_count` int(11) DEFAULT NULL,
2840 PRIMARY KEY (`vnf_type`,`vm_type`,`network_role`)
2841 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2842 /*!40101 SET character_set_client = @saved_cs_client */;
2845 -- Table structure for table `VM_PROFILE`
2848 DROP TABLE IF EXISTS `VM_PROFILE`;
2849 /*!40101 SET @saved_cs_client = @@character_set_client */;
2850 /*!40101 SET character_set_client = utf8 */;
2851 CREATE TABLE `VM_PROFILE` (
2852 `vnf_type` varchar(200) NOT NULL,
2853 `vm_type` varchar(45) NOT NULL,
2854 `vm_count` int(11) NOT NULL,
2855 PRIMARY KEY (`vnf_type`,`vm_type`)
2856 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2857 /*!40101 SET character_set_client = @saved_cs_client */;
2860 -- Table structure for table `VNF`
2863 DROP TABLE IF EXISTS `VNF`;
2864 /*!40101 SET @saved_cs_client = @@character_set_client */;
2865 /*!40101 SET character_set_client = utf8 */;
2866 CREATE TABLE `VNF` (
2867 `vnf_id` varchar(80) NOT NULL,
2868 `vnf_name` varchar(80) NOT NULL,
2869 `vnf_type` varchar(10) NOT NULL,
2870 `orchestration_status` varchar(20) DEFAULT NULL,
2871 `heat_stack_id` varchar(80) DEFAULT NULL,
2872 `mso_catalog_key` varchar(80) DEFAULT NULL,
2873 `availability_zone` varchar(80) DEFAULT NULL,
2874 `aic_site_id` varchar(80) DEFAULT NULL,
2875 `oam_ipv4_address` varchar(20) DEFAULT NULL,
2876 `vnf_name2` varchar(80) DEFAULT NULL,
2877 `vpe_id` varchar(80) NOT NULL,
2878 `ipv4_loopback0_address` varchar(80) DEFAULT NULL,
2879 `license_key` varchar(256) DEFAULT NULL,
2880 `entitlement_resource_uuid` varchar(256) DEFAULT NULL,
2881 PRIMARY KEY (`vnf_id`)
2882 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2883 /*!40101 SET character_set_client = @saved_cs_client */;
2886 -- Table structure for table `VNFC_DG_MAPPING`
2889 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
2890 /*!40101 SET @saved_cs_client = @@character_set_client */;
2891 /*!40101 SET character_set_client = utf8 */;
2892 CREATE TABLE `VNFC_DG_MAPPING` (
2893 `vnfc_dg_mapping_id` int(11) NOT NULL AUTO_INCREMENT,
2894 `action` varchar(50) DEFAULT NULL,
2895 `api_version` varchar(10) DEFAULT NULL,
2896 `vnf_type` varchar(50) DEFAULT NULL,
2897 `vnfc_type` varchar(50) DEFAULT NULL,
2898 `dg_name` varchar(50) NOT NULL,
2899 `dg_version` varchar(50) DEFAULT NULL,
2900 `dg_module` varchar(50) NOT NULL,
2901 PRIMARY KEY (`vnfc_dg_mapping_id`),
2902 UNIQUE KEY `input_constraint` (`action`,`api_version`,`vnf_type`,`vnfc_type`)
2903 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2904 /*!40101 SET character_set_client = @saved_cs_client */;
2907 -- Table structure for table `VNFC_REFERENCE`
2910 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
2911 /*!40101 SET @saved_cs_client = @@character_set_client */;
2912 /*!40101 SET character_set_client = utf8 */;
2913 CREATE TABLE `VNFC_REFERENCE` (
2914 `vnfc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
2915 `action` varchar(50) NOT NULL,
2916 `vnf_type` varchar(50) NOT NULL,
2917 `vm_instance` int(11) NOT NULL,
2918 `vnfc_instance` int(11) NOT NULL,
2919 `vnfc_type` varchar(50) NOT NULL,
2920 `vnfc_function_code` varchar(50) NOT NULL,
2921 `ipaddress_v4_oam_vip` varchar(50) DEFAULT NULL,
2922 `group_notation_type` varchar(50) DEFAULT NULL,
2923 `group_notation_value` varchar(50) DEFAULT NULL,
2924 PRIMARY KEY (`vnfc_reference_id`),
2925 UNIQUE KEY `vnfc_reference_id` (`vnfc_reference_id`)
2926 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2927 /*!40101 SET character_set_client = @saved_cs_client */;
2930 -- Table structure for table `VNF_IMAGE`
2933 DROP TABLE IF EXISTS `VNF_IMAGE`;
2934 /*!40101 SET @saved_cs_client = @@character_set_client */;
2935 /*!40101 SET character_set_client = utf8 */;
2936 CREATE TABLE `VNF_IMAGE` (
2937 `application_vendor` varchar(255) NOT NULL,
2938 `application_version` varchar(255) NOT NULL,
2939 `att_uuid` varchar(255) NOT NULL,
2940 `application` varchar(255) DEFAULT NULL,
2941 `selflink` varchar(255) DEFAULT NULL,
2942 PRIMARY KEY (`application_vendor`,`application_version`,`att_uuid`)
2943 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2944 /*!40101 SET character_set_client = @saved_cs_client */;
2947 -- Table structure for table `VNF_MODEL_LICENSES`
2950 DROP TABLE IF EXISTS `VNF_MODEL_LICENSES`;
2951 /*!40101 SET @saved_cs_client = @@character_set_client */;
2952 /*!40101 SET character_set_client = utf8 */;
2953 CREATE TABLE `VNF_MODEL_LICENSES` (
2954 `att_part_number` varchar(255) NOT NULL,
2955 `license_assignment_group` varchar(255) NOT NULL,
2956 `license_required` tinyint(1) DEFAULT NULL,
2957 `entitlement_assignment_group` varchar(255) DEFAULT NULL,
2958 `entitlement_required` tinyint(1) DEFAULT '0',
2959 `feature_group_uuid` varchar(255) DEFAULT NULL,
2960 PRIMARY KEY (`att_part_number`,`license_assignment_group`)
2961 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2962 /*!40101 SET character_set_client = @saved_cs_client */;
2965 -- Table structure for table `VNF_MODEL_LICENSE_FEATURES`
2968 DROP TABLE IF EXISTS `VNF_MODEL_LICENSE_FEATURES`;
2969 /*!40101 SET @saved_cs_client = @@character_set_client */;
2970 /*!40101 SET character_set_client = utf8 */;
2971 CREATE TABLE `VNF_MODEL_LICENSE_FEATURES` (
2972 `att_part_number` varchar(255) NOT NULL,
2973 `license_assignment_group` varchar(255) NOT NULL,
2974 `feature` varchar(255) NOT NULL,
2975 PRIMARY KEY (`att_part_number`,`license_assignment_group`,`feature`)
2976 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2977 /*!40101 SET character_set_client = @saved_cs_client */;
2980 -- Table structure for table `VNF_NAME_INDEX`
2983 DROP TABLE IF EXISTS `VNF_NAME_INDEX`;
2984 /*!40101 SET @saved_cs_client = @@character_set_client */;
2985 /*!40101 SET character_set_client = utf8 */;
2986 CREATE TABLE `VNF_NAME_INDEX` (
2987 `vnf_name_prefix` varchar(255) NOT NULL,
2988 `index_number` int(11) NOT NULL,
2989 PRIMARY KEY (`vnf_name_prefix`)
2990 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2991 /*!40101 SET character_set_client = @saved_cs_client */;
2994 -- Table structure for table `VNF_NETWORKS`
2997 DROP TABLE IF EXISTS `VNF_NETWORKS`;
2998 /*!40101 SET @saved_cs_client = @@character_set_client */;
2999 /*!40101 SET character_set_client = utf8 */;
3000 CREATE TABLE `VNF_NETWORKS` (
3001 `vnf_type` varchar(200) NOT NULL,
3002 `network_role` varchar(45) NOT NULL,
3003 PRIMARY KEY (`vnf_type`,`network_role`)
3004 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3005 /*!40101 SET character_set_client = @saved_cs_client */;
3008 -- Table structure for table `VNF_NETWORK_CONNECTION`
3011 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION`;
3012 /*!40101 SET @saved_cs_client = @@character_set_client */;
3013 /*!40101 SET character_set_client = utf8 */;
3014 CREATE TABLE `VNF_NETWORK_CONNECTION` (
3015 `connection_uuid` varchar(80) NOT NULL,
3016 `vnf_id` varchar(80) NOT NULL,
3017 `connection_id` varchar(80) DEFAULT NULL,
3018 `connection_type` varchar(20) DEFAULT NULL,
3019 `neutron_network_id` varchar(80) DEFAULT NULL,
3020 `neutron_network_name` varchar(80) DEFAULT NULL,
3021 `orchestration_status` varchar(20) DEFAULT NULL,
3022 `switch_id` varchar(40) DEFAULT NULL,
3023 `heat_stack_id` varchar(80) DEFAULT NULL,
3024 `mso_catalog_key` varchar(80) DEFAULT NULL,
3025 `provider_network` varchar(80) DEFAULT NULL,
3026 `port_group_id` varchar(80) DEFAULT NULL,
3027 `port_group_name` varchar(80) DEFAULT NULL,
3028 PRIMARY KEY (`connection_uuid`)
3029 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3030 /*!40101 SET character_set_client = @saved_cs_client */;
3033 -- Table structure for table `VNF_NETWORK_CONNECTION_VLAN`
3036 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION_VLAN`;
3037 /*!40101 SET @saved_cs_client = @@character_set_client */;
3038 /*!40101 SET character_set_client = utf8 */;
3039 CREATE TABLE `VNF_NETWORK_CONNECTION_VLAN` (
3040 `vlan_uuid` varchar(80) NOT NULL,
3041 `vlan_id` int(4) NOT NULL,
3042 `vlan_type` varchar(5) NOT NULL,
3043 `connection_uuid` varchar(80) DEFAULT NULL,
3044 PRIMARY KEY (`vlan_uuid`)
3045 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3046 /*!40101 SET character_set_client = @saved_cs_client */;
3049 -- Table structure for table `VNF_PROFILE`
3052 DROP TABLE IF EXISTS `VNF_PROFILE`;
3053 /*!40101 SET @saved_cs_client = @@character_set_client */;
3054 /*!40101 SET character_set_client = utf8 */;
3055 CREATE TABLE `VNF_PROFILE` (
3056 `vnf_type` varchar(200) NOT NULL,
3057 `availability_zone_count` int(11) NOT NULL,
3058 `equipment_role` varchar(80) NOT NULL,
3059 PRIMARY KEY (`vnf_type`)
3060 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3061 /*!40101 SET character_set_client = @saved_cs_client */;
3064 -- Table structure for table `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`
3067 DROP TABLE IF EXISTS `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`;
3068 /*!40101 SET @saved_cs_client = @@character_set_client */;
3069 /*!40101 SET character_set_client = utf8 */;
3070 CREATE TABLE `VNF_SERVICE_TO_NETWORK_ROLE_FILTER` (
3071 `vnf_service_type` varchar(60) NOT NULL,
3072 `network_role_filter` varchar(60) NOT NULL,
3073 PRIMARY KEY (`vnf_service_type`,`network_role_filter`)
3074 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3075 /*!40101 SET character_set_client = @saved_cs_client */;
3078 -- Table structure for table `VPE_LOCK`
3081 DROP TABLE IF EXISTS `VPE_LOCK`;
3082 /*!40101 SET @saved_cs_client = @@character_set_client */;
3083 /*!40101 SET character_set_client = utf8 */;
3084 CREATE TABLE `VPE_LOCK` (
3085 `vpe_name` varchar(20) NOT NULL,
3086 `vpn_lock` varchar(20) NOT NULL,
3087 PRIMARY KEY (`vpe_name`)
3088 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3089 /*!40101 SET character_set_client = @saved_cs_client */;
3092 -- Table structure for table `VPE_MAC_ADDRESS_POOL`
3095 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_POOL`;
3096 /*!40101 SET @saved_cs_client = @@character_set_client */;
3097 /*!40101 SET character_set_client = utf8 */;
3098 CREATE TABLE `VPE_MAC_ADDRESS_POOL` (
3099 `id` int(11) NOT NULL,
3100 `mac_address` varchar(50) NOT NULL,
3101 `sw_name` varchar(30) NOT NULL,
3103 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3104 /*!40101 SET character_set_client = @saved_cs_client */;
3107 -- Table structure for table `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`
3110 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`;
3111 /*!40101 SET @saved_cs_client = @@character_set_client */;
3112 /*!40101 SET character_set_client = utf8 */;
3113 CREATE TABLE `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING` (
3114 `id` int(11) NOT NULL,
3115 `hostname` varchar(50) NOT NULL,
3116 `assigned_user` varchar(25) NOT NULL,
3117 `assigned_date` date DEFAULT NULL,
3119 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3120 /*!40101 SET character_set_client = @saved_cs_client */;
3123 -- Table structure for table `VPE_POOL`
3126 DROP TABLE IF EXISTS `VPE_POOL`;
3127 /*!40101 SET @saved_cs_client = @@character_set_client */;
3128 /*!40101 SET character_set_client = utf8 */;
3129 CREATE TABLE `VPE_POOL` (
3130 `vpe_name` varchar(20) NOT NULL,
3131 `ipv4_oam_address` varchar(20) NOT NULL,
3132 `loopback0_ipv4_address` varchar(20) NOT NULL,
3133 `provisioning_status` varchar(10) NOT NULL,
3134 `aic_site_id` varchar(100) NOT NULL,
3135 `availability_zone` varchar(100) NOT NULL,
3136 `vlan_id_outer` varchar(20) NOT NULL,
3137 `vendor` varchar(20) NOT NULL,
3138 `physical_intf_name` varchar(40) NOT NULL,
3139 `physical_intf_speed` varchar(20) NOT NULL,
3140 `physical_intf_units` varchar(20) NOT NULL,
3141 `vpe_uuid` varchar(80) DEFAULT NULL,
3142 `vpe_id` varchar(80) NOT NULL,
3143 `image_filename` varchar(100) DEFAULT NULL,
3144 `as_number` varchar(20) NOT NULL,
3145 `loopback5000` varchar(16) DEFAULT NULL,
3146 `loopback10` varchar(16) DEFAULT NULL,
3147 `aic_version` varchar(50) DEFAULT NULL,
3148 `vpe_capacity` int(11) NOT NULL,
3149 PRIMARY KEY (`aic_site_id`,`vpe_name`,`availability_zone`)
3150 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3151 /*!40101 SET character_set_client = @saved_cs_client */;
3154 -- Table structure for table `VPLSPE_POOL`
3157 DROP TABLE IF EXISTS `VPLSPE_POOL`;
3158 /*!40101 SET @saved_cs_client = @@character_set_client */;
3159 /*!40101 SET character_set_client = utf8 */;
3160 CREATE TABLE `VPLSPE_POOL` (
3161 `vplspe_name` varchar(20) NOT NULL,
3162 `aic_site_id` varchar(100) NOT NULL,
3163 `availability_zone` varchar(100) NOT NULL,
3164 `physical_intf_name` varchar(40) NOT NULL,
3165 `physical_intf_speed` varchar(20) NOT NULL,
3166 `physical_intf_units` varchar(20) NOT NULL,
3167 `loopback0_ipv4_address` varchar(20) NOT NULL,
3168 `vlan_id_outer` varchar(20) NOT NULL,
3169 `vplspe_uuid` varchar(80) DEFAULT NULL,
3170 `image_filename` varchar(100) DEFAULT NULL,
3171 `provisioning_status` varchar(10) DEFAULT NULL,
3172 `vendor` varchar(20) DEFAULT NULL,
3173 PRIMARY KEY (`vplspe_name`,`aic_site_id`,`availability_zone`,`physical_intf_name`)
3174 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3175 /*!40101 SET character_set_client = @saved_cs_client */;
3178 -- Table structure for table `VPN_BINDINGS`
3181 DROP TABLE IF EXISTS `VPN_BINDINGS`;
3182 /*!40101 SET @saved_cs_client = @@character_set_client */;
3183 /*!40101 SET character_set_client = utf8 */;
3184 CREATE TABLE `VPN_BINDINGS` (
3185 `network_customization_uuid` varchar(255) NOT NULL,
3186 `binding_uuid` varchar(255) NOT NULL,
3187 PRIMARY KEY (`network_customization_uuid`,`binding_uuid`)
3188 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3189 /*!40101 SET character_set_client = @saved_cs_client */;
3192 -- Table structure for table `VRR_FUNCTION_CODE_VMTYPE_MAPPING`
3195 DROP TABLE IF EXISTS `VRR_FUNCTION_CODE_VMTYPE_MAPPING`;
3196 /*!40101 SET @saved_cs_client = @@character_set_client */;
3197 /*!40101 SET character_set_client = utf8 */;
3198 CREATE TABLE `VRR_FUNCTION_CODE_VMTYPE_MAPPING` (
3199 `ptnii_function_code` varchar(128) NOT NULL,
3200 `vm_type` varchar(128) NOT NULL,
3201 PRIMARY KEY (`ptnii_function_code`,`vm_type`)
3202 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3203 /*!40101 SET character_set_client = @saved_cs_client */;
3206 -- Table structure for table `VSERVER`
3209 DROP TABLE IF EXISTS `VSERVER`;
3210 /*!40101 SET @saved_cs_client = @@character_set_client */;
3211 /*!40101 SET character_set_client = utf8 */;
3212 CREATE TABLE `VSERVER` (
3213 `tenant_id` varchar(40) NOT NULL,
3214 `vserver_id` varchar(40) NOT NULL,
3215 `aic_site_id` varchar(100) NOT NULL,
3216 `vendor` varchar(20) NOT NULL,
3217 `image_name` varchar(100) NOT NULL,
3218 `vnf_type` varchar(10) NOT NULL,
3219 `vnf_id` varchar(80) NOT NULL,
3220 PRIMARY KEY (`tenant_id`,`vserver_id`)
3221 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3222 /*!40101 SET character_set_client = @saved_cs_client */;
3225 -- Table structure for table `VSERVER2`
3228 DROP TABLE IF EXISTS `VSERVER2`;
3229 /*!40101 SET @saved_cs_client = @@character_set_client */;
3230 /*!40101 SET character_set_client = utf8 */;
3231 CREATE TABLE `VSERVER2` (
3232 `tenant_id` varchar(255) NOT NULL,
3233 `vserver_id` varchar(128) NOT NULL,
3234 `vserver_name` varchar(255) NOT NULL,
3235 `vserver_name2` varchar(255) DEFAULT NULL,
3236 `prov_status` varchar(20) DEFAULT NULL,
3237 `selflink` varchar(255) DEFAULT NULL,
3238 PRIMARY KEY (`tenant_id`,`vserver_id`)
3239 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3240 /*!40101 SET character_set_client = @saved_cs_client */;
3243 -- Table structure for table `VSERVER_PSERVER`
3246 DROP TABLE IF EXISTS `VSERVER_PSERVER`;
3247 /*!40101 SET @saved_cs_client = @@character_set_client */;
3248 /*!40101 SET character_set_client = utf8 */;
3249 CREATE TABLE `VSERVER_PSERVER` (
3250 `vserver_id` varchar(128) NOT NULL,
3251 `pserver_hostname` varchar(255) DEFAULT NULL,
3252 PRIMARY KEY (`vserver_id`)
3253 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3254 /*!40101 SET character_set_client = @saved_cs_client */;
3257 -- Table structure for table `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`
3260 DROP TABLE IF EXISTS `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`;
3261 /*!40101 SET @saved_cs_client = @@character_set_client */;
3262 /*!40101 SET character_set_client = utf8 */;
3263 CREATE TABLE `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING` (
3264 `key_id` varchar(128) NOT NULL,
3265 `cloud_region` varchar(128) NOT NULL,
3266 `key_type` varchar(128) NOT NULL,
3267 PRIMARY KEY (`key_id`,`cloud_region`,`key_type`)
3268 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3269 /*!40101 SET character_set_client = @saved_cs_client */;
3272 -- Table structure for table `WAN_COMBO_ALLOWABLE`
3275 DROP TABLE IF EXISTS `WAN_COMBO_ALLOWABLE`;
3276 /*!40101 SET @saved_cs_client = @@character_set_client */;
3277 /*!40101 SET character_set_client = utf8 */;
3278 CREATE TABLE `WAN_COMBO_ALLOWABLE` (
3279 `combo_sequence` int(11) NOT NULL AUTO_INCREMENT,
3280 `topology` varchar(16) DEFAULT 'unknown',
3281 `internet_topology` varchar(20) DEFAULT NULL,
3282 `wan1` varchar(40) DEFAULT NULL,
3283 `wan2` varchar(40) DEFAULT NULL,
3284 `new_start_release_flexware` varchar(16) DEFAULT 'unknown',
3285 `is_active_flexware` varchar(1) DEFAULT 'N',
3286 `new_start_release_dhv` varchar(16) DEFAULT 'unknown',
3287 `is_active_dhv` varchar(1) DEFAULT 'N',
3288 `ucpe_type` varchar(32) DEFAULT 'stand-alone',
3289 `description` varchar(128) NOT NULL,
3290 PRIMARY KEY (`combo_sequence`),
3291 UNIQUE KEY `IX1_WAN_COMBO_ALLOWABLE` (`internet_topology`,`wan1`,`wan2`)
3292 ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
3293 /*!40101 SET character_set_client = @saved_cs_client */;
3296 /*!40101 SET character_set_client = @saved_cs_client */;
3297 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3299 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3300 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3301 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3302 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3303 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3304 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3305 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3307 -- Dump completed on 2017-10-04 18:23:01