1 -- MySQL dump 10.13 Distrib 5.6.22, for Linux (x86_64)
3 -- Host: sdnctldb01 Database: sdnctl
4 -- ------------------------------------------------------
5 -- Server version 5.6.27-enterprise-commercial-advanced-log
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19 -- Table structure for table `ACCESS_LOG`
22 DROP TABLE IF EXISTS `ACCESS_LOG`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `ACCESS_LOG` (
26 `access_log_seq` int(11) NOT NULL AUTO_INCREMENT,
27 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
28 `method` varchar(12) DEFAULT NULL,
29 `version` varchar(12) DEFAULT NULL,
30 `status` varchar(12) DEFAULT NULL,
31 `url` varchar(256) DEFAULT NULL,
32 `remote_address` varchar(128) DEFAULT NULL,
33 PRIMARY KEY (`access_log_seq`)
34 ) ENGINE=InnoDB AUTO_INCREMENT=1034 DEFAULT CHARSET=latin1;
35 /*!40101 SET character_set_client = @saved_cs_client */;
38 -- Table structure for table `ADDRESS_PLAN_POLICIES`
41 DROP TABLE IF EXISTS `ADDRESS_PLAN_POLICIES`;
42 /*!40101 SET @saved_cs_client = @@character_set_client */;
43 /*!40101 SET character_set_client = utf8 */;
44 CREATE TABLE `ADDRESS_PLAN_POLICIES` (
45 `key_name` varchar(255) NOT NULL,
46 `key_value_source_type` varchar(255) NOT NULL,
47 `key_value_source` varchar(255) NOT NULL,
48 PRIMARY KEY (`key_name`)
49 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50 /*!40101 SET character_set_client = @saved_cs_client */;
53 -- Table structure for table `AGNOSTIC_NOTIFICATION_URL`
56 DROP TABLE IF EXISTS `AGNOSTIC_NOTIFICATION_URL`;
57 /*!40101 SET @saved_cs_client = @@character_set_client */;
58 /*!40101 SET character_set_client = utf8 */;
59 CREATE TABLE `AGNOSTIC_NOTIFICATION_URL` (
60 `service_type` varchar(128) NOT NULL,
61 `service_instance_id` varchar(128) NOT NULL,
62 `request_id` varchar(128) NOT NULL,
63 `svc_notification_url` varchar(256) NOT NULL,
64 PRIMARY KEY (`service_type`,`service_instance_id`,`request_id`)
65 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66 /*!40101 SET character_set_client = @saved_cs_client */;
69 -- Table structure for table `AGNOSTIC_TO_SVC_SPCFC_API`
72 DROP TABLE IF EXISTS `AGNOSTIC_TO_SVC_SPCFC_API`;
73 /*!40101 SET @saved_cs_client = @@character_set_client */;
74 /*!40101 SET character_set_client = utf8 */;
75 CREATE TABLE `AGNOSTIC_TO_SVC_SPCFC_API` (
76 `operation` varchar(128) NOT NULL,
77 `service` varchar(128) NOT NULL,
78 `service_specific_api` varchar(128) NOT NULL,
79 `async_process` varchar(15) DEFAULT NULL,
80 PRIMARY KEY (`operation`,`service`)
81 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82 /*!40101 SET character_set_client = @saved_cs_client */;
85 -- Table structure for table `AIC_AVAIL_ZONE_POOL`
88 DROP TABLE IF EXISTS `AIC_AVAIL_ZONE_POOL`;
89 /*!40101 SET @saved_cs_client = @@character_set_client */;
90 /*!40101 SET character_set_client = utf8 */;
91 CREATE TABLE `AIC_AVAIL_ZONE_POOL` (
92 `aic_site_id` varchar(100) NOT NULL,
93 `status` varchar(40) NOT NULL,
94 `availability_zone` varchar(100) NOT NULL,
95 `token` varchar(5) NOT NULL,
96 `vnf_id` varchar(80) DEFAULT NULL,
97 `service_type` varchar(100) NOT NULL,
98 `vnf_type` varchar(20) DEFAULT NULL,
99 `hypervisor` varchar(10) DEFAULT NULL,
100 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
101 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
102 /*!40101 SET character_set_client = @saved_cs_client */;
105 -- Table structure for table `AIC_HOSTNAME`
108 DROP TABLE IF EXISTS `AIC_HOSTNAME`;
109 /*!40101 SET @saved_cs_client = @@character_set_client */;
110 /*!40101 SET character_set_client = utf8 */;
111 CREATE TABLE `AIC_HOSTNAME` (
112 `hostname` varchar(20) NOT NULL,
113 `cust_id` int(11) NOT NULL,
114 `vendor_code` varchar(1) NOT NULL,
115 `virtual_device_type` varchar(2) DEFAULT NULL,
116 `device_sequence` varchar(3) NOT NULL,
117 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
118 PRIMARY KEY (`hostname`),
119 UNIQUE KEY `hostname` (`hostname`),
120 KEY `IN1_AIC_HOSTNAME` (`cust_id`),
121 CONSTRAINT `AC1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
122 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
123 /*!40101 SET character_set_client = @saved_cs_client */;
126 -- Table structure for table `AIC_NETWORK`
129 DROP TABLE IF EXISTS `AIC_NETWORK`;
130 /*!40101 SET @saved_cs_client = @@character_set_client */;
131 /*!40101 SET character_set_client = utf8 */;
132 CREATE TABLE `AIC_NETWORK` (
133 `network_id` varchar(100) NOT NULL,
134 `network_name` varchar(100) DEFAULT NULL,
135 `status` varchar(20) DEFAULT NULL,
136 `tenant_id` varchar(100) DEFAULT NULL,
137 `switch_uuid` varchar(100) DEFAULT NULL,
138 `portgroup_name` varchar(100) DEFAULT NULL,
139 `portgroup_id` varchar(100) DEFAULT NULL,
140 PRIMARY KEY (`network_id`)
141 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142 /*!40101 SET character_set_client = @saved_cs_client */;
145 -- Table structure for table `AIC_SITE`
148 DROP TABLE IF EXISTS `AIC_SITE`;
149 /*!40101 SET @saved_cs_client = @@character_set_client */;
150 /*!40101 SET character_set_client = utf8 */;
151 CREATE TABLE `AIC_SITE` (
152 `name` varchar(100) DEFAULT NULL,
153 `aic_site_id` varchar(100) NOT NULL,
154 `vcenter_url` varchar(200) DEFAULT NULL,
155 `vcenter_username` varchar(40) DEFAULT NULL,
156 `vcenter_passwd` varbinary(255) DEFAULT NULL,
157 `city` varchar(100) DEFAULT NULL,
158 `state` varchar(2) DEFAULT NULL,
159 `operational_status` varchar(20) DEFAULT NULL,
160 `oam_gateway_addr` varchar(20) DEFAULT '',
161 PRIMARY KEY (`aic_site_id`)
162 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
163 /*!40101 SET character_set_client = @saved_cs_client */;
166 -- Table structure for table `AIC_SWITCH`
169 DROP TABLE IF EXISTS `AIC_SWITCH`;
170 /*!40101 SET @saved_cs_client = @@character_set_client */;
171 /*!40101 SET character_set_client = utf8 */;
172 CREATE TABLE `AIC_SWITCH` (
173 `switch_name` varchar(100) DEFAULT NULL,
174 `physical_network_name` varchar(100) NOT NULL,
175 `aic_site_id` varchar(100) DEFAULT NULL,
176 `uuid` varchar(100) DEFAULT NULL,
177 `availability_zone` varchar(100) DEFAULT NULL,
178 PRIMARY KEY (`physical_network_name`)
179 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
180 /*!40101 SET character_set_client = @saved_cs_client */;
183 -- Table structure for table `AIC_ZONE_CLOUD_REGION_ID`
186 DROP TABLE IF EXISTS `AIC_ZONE_CLOUD_REGION_ID`;
187 /*!40101 SET @saved_cs_client = @@character_set_client */;
188 /*!40101 SET character_set_client = utf8 */;
189 CREATE TABLE `AIC_ZONE_CLOUD_REGION_ID` (
190 `zone_region_id` varchar(255) NOT NULL,
191 `cilli_code` varchar(255) NOT NULL,
192 `location_id` varchar(255) NOT NULL DEFAULT '',
193 `city_state_country` varchar(255) NOT NULL DEFAULT '',
194 PRIMARY KEY (`zone_region_id`,`cilli_code`,`location_id`,`city_state_country`)
195 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196 /*!40101 SET character_set_client = @saved_cs_client */;
199 -- Table structure for table `ALLOCATION_ITEM`
202 DROP TABLE IF EXISTS `ALLOCATION_ITEM`;
203 /*!40101 SET @saved_cs_client = @@character_set_client */;
204 /*!40101 SET character_set_client = utf8 */;
205 CREATE TABLE `ALLOCATION_ITEM` (
206 `allocation_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
207 `resource_id` bigint(20) NOT NULL,
208 `application_id` varchar(50) NOT NULL,
209 `resource_set_id` varchar(200) NOT NULL,
210 `resource_union_id` varchar(200) NOT NULL,
211 `resource_share_group_list` varchar(200) DEFAULT NULL,
212 `lt_used` bigint(20) DEFAULT NULL,
213 `ll_label` varchar(50) DEFAULT NULL,
214 `rr_used` varchar(200) DEFAULT NULL,
215 `allocation_time` datetime NOT NULL,
216 PRIMARY KEY (`allocation_item_id`),
217 UNIQUE KEY `allocation_item_id` (`allocation_item_id`),
218 UNIQUE KEY `IX2_ALLOCATION_ITEM` (`resource_id`,`resource_set_id`),
219 KEY `IX1_ALLOCATION_ITEM` (`resource_id`)
220 ) ENGINE=InnoDB AUTO_INCREMENT=5764 DEFAULT CHARSET=latin1;
221 /*!40101 SET character_set_client = @saved_cs_client */;
224 -- Table structure for table `ALLOTTED_RESOURCE_MODEL`
227 DROP TABLE IF EXISTS `ALLOTTED_RESOURCE_MODEL`;
228 /*!40101 SET @saved_cs_client = @@character_set_client */;
229 /*!40101 SET character_set_client = utf8 */;
230 CREATE TABLE `ALLOTTED_RESOURCE_MODEL` (
231 `customization_uuid` varchar(255) NOT NULL,
232 `model_yaml` longblob,
233 `invariant_uuid` varchar(255) DEFAULT NULL,
234 `uuid` varchar(255) DEFAULT NULL,
235 `version` varchar(255) DEFAULT NULL,
236 `naming_policy` varchar(255) DEFAULT NULL,
237 `ecomp_generated_naming` char(1) DEFAULT NULL,
238 `depending_service` varchar(255) DEFAULT NULL,
239 `role` varchar(255) DEFAULT NULL,
240 `type` varchar(255) DEFAULT NULL,
241 `service_dependency` varchar(255) DEFAULT NULL,
242 `allotted_resource_type` varchar(255) DEFAULT NULL,
243 PRIMARY KEY (`customization_uuid`)
244 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
245 /*!40101 SET character_set_client = @saved_cs_client */;
248 -- Table structure for table `ALTS_CREDENTIALS`
251 DROP TABLE IF EXISTS `ALTS_CREDENTIALS`;
252 /*!40101 SET @saved_cs_client = @@character_set_client */;
253 /*!40101 SET character_set_client = utf8 */;
254 CREATE TABLE `ALTS_CREDENTIALS` (
255 `alts_username` varchar(255) NOT NULL,
256 `alts_password` varbinary(255) NOT NULL,
257 PRIMARY KEY (`alts_username`)
258 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
259 /*!40101 SET character_set_client = @saved_cs_client */;
262 -- Table structure for table `ASDC_ARTIFACTS`
265 DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
266 /*!40101 SET @saved_cs_client = @@character_set_client */;
267 /*!40101 SET character_set_client = utf8 */;
268 CREATE TABLE `ASDC_ARTIFACTS` (
269 `asdc_artifacts_id` int(11) NOT NULL AUTO_INCREMENT,
270 `service_uuid` varchar(50) DEFAULT NULL,
271 `distribution_id` varchar(50) DEFAULT NULL,
272 `service_name` varchar(255) DEFAULT NULL,
273 `service_description` varchar(255) DEFAULT NULL,
274 `resource_uuid` varchar(255) DEFAULT NULL,
275 `resource_instance_name` varchar(255) DEFAULT NULL,
276 `resource_name` varchar(255) DEFAULT NULL,
277 `resource_version` varchar(50) DEFAULT NULL,
278 `resource_type` varchar(50) DEFAULT NULL,
279 `artifact_uuid` varchar(50) DEFAULT NULL,
280 `artifact_type` varchar(50) DEFAULT NULL,
281 `artifact_version` varchar(25) DEFAULT NULL,
282 `artifact_description` varchar(255) DEFAULT NULL,
283 `internal_version` int(11) DEFAULT NULL,
284 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
285 `artifact_name` varchar(255) DEFAULT NULL,
286 `artifact_content` longtext,
287 PRIMARY KEY (`asdc_artifacts_id`),
288 UNIQUE KEY `asdc_artifacts_id` (`asdc_artifacts_id`)
289 ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
290 /*!40101 SET character_set_client = @saved_cs_client */;
293 -- Table structure for table `ASDC_REFERENCE`
296 DROP TABLE IF EXISTS `ASDC_REFERENCE`;
297 /*!40101 SET @saved_cs_client = @@character_set_client */;
298 /*!40101 SET character_set_client = utf8 */;
299 CREATE TABLE `ASDC_REFERENCE` (
300 `asdc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
301 `service_type` varchar(50) DEFAULT NULL,
302 `vnf_type` varchar(50) DEFAULT NULL,
303 `vnfc_type` varchar(50) DEFAULT NULL,
304 `file_category` varchar(50) DEFAULT NULL,
305 `action` varchar(50) DEFAULT NULL,
306 `artifact_type` varchar(50) DEFAULT NULL,
307 `artifact_name` varchar(255) NOT NULL,
308 PRIMARY KEY (`asdc_reference_id`),
309 UNIQUE KEY `asdc_reference_id` (`asdc_reference_id`)
310 ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
311 /*!40101 SET character_set_client = @saved_cs_client */;
315 -- Table structure for table `BLOB_TEST`
318 DROP TABLE IF EXISTS `BLOB_TEST`;
319 /*!40101 SET @saved_cs_client = @@character_set_client */;
320 /*!40101 SET character_set_client = utf8 */;
321 CREATE TABLE `BLOB_TEST` (
322 `seq` int(11) NOT NULL AUTO_INCREMENT,
323 `odl` varchar(20) DEFAULT NULL,
324 `communities` mediumblob,
325 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
326 `retry_count` int(11) DEFAULT '-1',
328 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
329 /*!40101 SET character_set_client = @saved_cs_client */;
332 -- Table structure for table `CAPABILITY`
335 DROP TABLE IF EXISTS `CAPABILITY`;
336 /*!40101 SET @saved_cs_client = @@character_set_client */;
337 /*!40101 SET character_set_client = utf8 */;
338 CREATE TABLE `CAPABILITY` (
339 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
340 `capability_name` varchar(50) NOT NULL,
341 `implementation_name` varchar(100) NOT NULL,
342 `operation_name` varchar(50) NOT NULL,
343 `operation_description` varchar(100) NOT NULL,
344 `input_definition` longtext,
345 `output_definition` longtext,
346 `dependency_definition` longtext,
347 `tags` varchar(100) DEFAULT NULL,
348 PRIMARY KEY (`capability_id`),
349 UNIQUE KEY `capability_id` (`capability_name`)
350 ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;
351 /*!40101 SET character_set_client = @saved_cs_client */;
354 -- Table structure for table `CITY_CODE`
357 DROP TABLE IF EXISTS `CITY_CODE`;
358 /*!40101 SET @saved_cs_client = @@character_set_client */;
359 /*!40101 SET character_set_client = utf8 */;
360 CREATE TABLE `CITY_CODE` (
361 `city_code_id` int(11) NOT NULL AUTO_INCREMENT,
362 `city_code` varchar(3) NOT NULL,
363 `city` varchar(150) NOT NULL,
364 `state` varchar(10) NOT NULL,
365 `country_code` varchar(10) NOT NULL,
366 PRIMARY KEY (`city_code_id`),
367 KEY `IN1_CITY_CODE` (`city`,`state`,`country_code`)
368 ) ENGINE=InnoDB AUTO_INCREMENT=37822 DEFAULT CHARSET=latin1;
369 /*!40101 SET character_set_client = @saved_cs_client */;
372 -- Table structure for table `CLI_UPDATES`
375 DROP TABLE IF EXISTS `CLI_UPDATES`;
376 /*!40101 SET @saved_cs_client = @@character_set_client */;
377 /*!40101 SET character_set_client = utf8 */;
378 CREATE TABLE `CLI_UPDATES` (
379 `seq` int(11) NOT NULL AUTO_INCREMENT,
380 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
381 `create_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
382 `last_processed_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
383 `target_address` varchar(128) DEFAULT NULL,
384 `cli_text` varchar(128) DEFAULT NULL,
386 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
387 /*!40101 SET character_set_client = @saved_cs_client */;
390 -- Table structure for table `CONFIGFILES`
393 DROP TABLE IF EXISTS `CONFIGFILES`;
394 /*!40101 SET @saved_cs_client = @@character_set_client */;
395 /*!40101 SET character_set_client = utf8 */;
396 CREATE TABLE `CONFIGFILES` (
397 `config_file_id` int(11) NOT NULL AUTO_INCREMENT,
398 `external_version` varchar(50) DEFAULT NULL,
399 `data_source` varchar(25) DEFAULT NULL,
400 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
401 `service_instance_id` varchar(50) DEFAULT NULL,
402 `vnf_type` varchar(50) DEFAULT NULL,
403 `vnfc_type` varchar(50) DEFAULT NULL,
404 `file_category` varchar(50) DEFAULT NULL,
405 `file_name` varchar(255) DEFAULT NULL,
406 `file_content` longtext,
407 `action` varchar(50) DEFAULT NULL,
408 `vnf_id` varchar(50) DEFAULT NULL,
409 `vm_name` varchar(50) DEFAULT NULL,
410 `vnf_name` varchar(50) DEFAULT NULL,
411 PRIMARY KEY (`config_file_id`),
412 UNIQUE KEY `config_file_id` (`config_file_id`)
413 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
414 /*!40101 SET character_set_client = @saved_cs_client */;
417 -- Table structure for table `CONFIGURE_ACTION_DG`
420 DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
421 /*!40101 SET @saved_cs_client = @@character_set_client */;
422 /*!40101 SET character_set_client = utf8 */;
423 CREATE TABLE `CONFIGURE_ACTION_DG` (
424 `configure_action_dg_id` int(11) NOT NULL AUTO_INCREMENT,
425 `vnf_type` varchar(50) DEFAULT NULL,
426 `action` varchar(50) DEFAULT NULL,
427 `init_config_dg` varchar(50) DEFAULT NULL,
428 `generate_config_dg` varchar(50) DEFAULT NULL,
429 `download_config_dg` varchar(50) DEFAULT NULL,
430 PRIMARY KEY (`configure_action_dg_id`),
431 UNIQUE KEY `configure_action_dg_id` (`configure_action_dg_id`)
432 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
433 /*!40101 SET character_set_client = @saved_cs_client */;
436 -- Table structure for table `CONFIG_CONTENT`
439 DROP TABLE IF EXISTS `CONFIG_CONTENT`;
440 /*!40101 SET @saved_cs_client = @@character_set_client */;
441 /*!40101 SET character_set_client = utf8 */;
442 CREATE TABLE `CONFIG_CONTENT` (
443 `config_content_id` int(11) NOT NULL AUTO_INCREMENT,
444 `request_id` varchar(50) NOT NULL,
445 `content_type` varchar(50) NOT NULL,
446 `template_name` varchar(50) DEFAULT NULL,
447 `originator_id` varchar(50) DEFAULT NULL,
448 `service_description` varchar(100) DEFAULT NULL,
449 `action` varchar(50) DEFAULT NULL,
450 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
451 `service_type` varchar(50) DEFAULT NULL,
452 `service_instance_id` varchar(50) DEFAULT NULL,
453 `vnf_id` varchar(50) DEFAULT NULL,
454 `vnf_name` varchar(50) DEFAULT NULL,
455 `vm_name` varchar(50) DEFAULT NULL,
456 `vnf_type` varchar(50) DEFAULT NULL,
457 `vnfc_type` varchar(50) DEFAULT NULL,
458 `host_ip_address` varchar(50) DEFAULT NULL,
459 `config_indicator` varchar(25) DEFAULT NULL,
460 `pending_delete` varchar(1) DEFAULT NULL,
462 PRIMARY KEY (`config_content_id`),
463 UNIQUE KEY `config_content_id` (`creation_date`)
464 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
465 /*!40101 SET character_set_client = @saved_cs_client */;
468 -- Table structure for table `CONFIG_FILE_REFERENCE`
471 DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
472 /*!40101 SET @saved_cs_client = @@character_set_client */;
473 /*!40101 SET character_set_client = utf8 */;
474 CREATE TABLE `CONFIG_FILE_REFERENCE` (
475 `config_file_reference_id` int(11) NOT NULL AUTO_INCREMENT,
476 `site_location` varchar(50) DEFAULT NULL,
477 `vnf_type` varchar(50) DEFAULT NULL,
478 `import_type` varchar(50) DEFAULT NULL,
479 `file_type` varchar(50) DEFAULT NULL,
480 `source_server_name` varchar(255) DEFAULT NULL,
481 `source_file_path` varchar(255) DEFAULT NULL,
482 `target_file_path` varchar(255) DEFAULT NULL,
483 `name` varchar(50) DEFAULT NULL,
484 `file_name` varchar(255) DEFAULT NULL,
485 PRIMARY KEY (`config_file_reference_id`),
486 UNIQUE KEY `config_file_reference_id` (`config_file_reference_id`)
487 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
488 /*!40101 SET character_set_client = @saved_cs_client */;
491 -- Table structure for table `CONFIG_TRANSACTION_LOG`
494 DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
495 /*!40101 SET @saved_cs_client = @@character_set_client */;
496 /*!40101 SET character_set_client = utf8 */;
497 CREATE TABLE `CONFIG_TRANSACTION_LOG` (
498 `config_transaction_log_id` varchar(50) NOT NULL,
499 `request_id` varchar(50) DEFAULT NULL,
500 `message_type` varchar(100) DEFAULT NULL,
501 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
503 PRIMARY KEY (`config_transaction_log_id`),
504 UNIQUE KEY `config_transaction_log_id` (`config_transaction_log_id`)
505 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
506 /*!40101 SET character_set_client = @saved_cs_client */;
509 -- Table structure for table `COUNTRY_ASN_MAPPING`
512 DROP TABLE IF EXISTS `COUNTRY_ASN_MAPPING`;
513 /*!40101 SET @saved_cs_client = @@character_set_client */;
514 /*!40101 SET character_set_client = utf8 */;
515 CREATE TABLE `COUNTRY_ASN_MAPPING` (
516 `asn` int(5) NOT NULL,
517 `iso_2char` varchar(5) NOT NULL,
518 `iso_3char` varchar(5) NOT NULL
519 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
520 /*!40101 SET character_set_client = @saved_cs_client */;
523 -- Table structure for table `CUSTOMER`
526 DROP TABLE IF EXISTS `CUSTOMER`;
527 /*!40101 SET @saved_cs_client = @@character_set_client */;
528 /*!40101 SET character_set_client = utf8 */;
529 CREATE TABLE `CUSTOMER` (
530 `cust_id` int(11) NOT NULL AUTO_INCREMENT,
531 `customer_name` varchar(256) DEFAULT NULL,
532 `grua` varchar(4) NOT NULL,
533 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
534 PRIMARY KEY (`cust_id`),
535 UNIQUE KEY `IU1_CUSTOMER` (`customer_name`)
536 ) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=latin1;
537 /*!40101 SET character_set_client = @saved_cs_client */;
540 -- Table structure for table `CUSTOMER2CONNECTION_MAPPING`
543 DROP TABLE IF EXISTS `CUSTOMER2CONNECTION_MAPPING`;
544 /*!40101 SET @saved_cs_client = @@character_set_client */;
545 /*!40101 SET character_set_client = utf8 */;
546 CREATE TABLE `CUSTOMER2CONNECTION_MAPPING` (
547 `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT,
548 `service_instance_id` varchar(80) NOT NULL,
549 `instance_type` varchar(20) NOT NULL,
550 `originating_service_instance_id` varchar(80) DEFAULT NULL,
551 `originating_service_type` varchar(20) DEFAULT NULL,
552 `service_type` varchar(30) DEFAULT NULL,
553 `connection_id` varchar(100) NOT NULL,
554 `status` varchar(20) DEFAULT NULL,
555 PRIMARY KEY (`customer2connection_id`)
556 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
557 /*!40101 SET character_set_client = @saved_cs_client */;
560 -- Table structure for table `CUSTOMER2CONNECTION_MAPPING_NEW`
563 DROP TABLE IF EXISTS `CUSTOMER2CONNECTION_MAPPING_NEW`;
564 /*!40101 SET @saved_cs_client = @@character_set_client */;
565 /*!40101 SET character_set_client = utf8 */;
566 CREATE TABLE `CUSTOMER2CONNECTION_MAPPING_NEW` (
567 `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT,
568 `service_instance_id` varchar(80) NOT NULL,
569 `instance_type` varchar(20) NOT NULL,
570 `originating_service_instance_id` varchar(80) DEFAULT NULL,
571 `originating_service_type` varchar(20) DEFAULT NULL,
572 `service_type` varchar(30) DEFAULT NULL,
573 `connection_id` varchar(100) NOT NULL,
574 `status` varchar(100) DEFAULT NULL,
575 PRIMARY KEY (`customer2connection_id`)
576 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
577 /*!40101 SET character_set_client = @saved_cs_client */;
580 -- Table structure for table `DATA_OBJECT_MAPPING`
583 DROP TABLE IF EXISTS `DATA_OBJECT_MAPPING`;
584 /*!40101 SET @saved_cs_client = @@character_set_client */;
585 /*!40101 SET character_set_client = utf8 */;
586 CREATE TABLE `DATA_OBJECT_MAPPING` (
587 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
588 `data_object_key` varchar(100) NOT NULL,
589 `data_object_type` varchar(50) NOT NULL,
590 `service_type` varchar(50) NOT NULL,
591 `data_object_key2` varchar(100) NOT NULL,
592 `data_object_key2_type` varchar(50) NOT NULL,
593 `data_object_key3` varchar(100) DEFAULT NULL,
594 `data_object_key3_type` varchar(50) DEFAULT NULL,
595 `service` varchar(50) DEFAULT NULL,
596 PRIMARY KEY (`serial_key`),
597 KEY `IX1_DATA_OBJECT_MAPPING` (`data_object_key`,`data_object_type`,`service_type`),
598 KEY `IX2_DATA_OBJECT_MAPPING` (`service_type`,`data_object_key2`,`data_object_key2_type`)
599 ) ENGINE=InnoDB AUTO_INCREMENT=3211 DEFAULT CHARSET=latin1;
600 /*!40101 SET character_set_client = @saved_cs_client */;
603 -- Table structure for table `DEVICE2CONNECTION_MAPPING`
606 DROP TABLE IF EXISTS `DEVICE2CONNECTION_MAPPING`;
607 /*!40101 SET @saved_cs_client = @@character_set_client */;
608 /*!40101 SET character_set_client = utf8 */;
609 CREATE TABLE `DEVICE2CONNECTION_MAPPING` (
610 `vnf_host_name` varchar(100) NOT NULL,
611 `e2e_vpn_key` varchar(30) NOT NULL,
612 `service_type` varchar(30) NOT NULL,
613 `connection_id` varchar(100) NOT NULL,
614 PRIMARY KEY (`vnf_host_name`,`e2e_vpn_key`,`service_type`)
615 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
616 /*!40101 SET character_set_client = @saved_cs_client */;
619 -- Table structure for table `DEVICE2IPADDRESS_CONSUMPTION`
622 DROP TABLE IF EXISTS `DEVICE2IPADDRESS_CONSUMPTION`;
623 /*!40101 SET @saved_cs_client = @@character_set_client */;
624 /*!40101 SET character_set_client = utf8 */;
625 CREATE TABLE `DEVICE2IPADDRESS_CONSUMPTION` (
626 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
627 `device_id` varchar(100) NOT NULL,
628 `device_type` varchar(30) NOT NULL,
629 `ip_version` varchar(10) NOT NULL,
630 `consumption_key` varchar(100) NOT NULL,
631 `logical_interface_service_id` varchar(100) NOT NULL,
632 `address_type` varchar(30) NOT NULL,
633 `ip_consumed` varchar(50) NOT NULL,
634 `vnf_type` varchar(30) NOT NULL,
635 `secondary_key` varchar(100) DEFAULT NULL,
636 PRIMARY KEY (`serial_key`),
637 KEY `IX1_DEVICEIPADDRESS_CONSUMPTION` (`device_id`,`device_type`,`ip_version`)
638 ) ENGINE=InnoDB AUTO_INCREMENT=1357 DEFAULT CHARSET=latin1;
639 /*!40101 SET character_set_client = @saved_cs_client */;
642 -- Table structure for table `DEVICE2IPADDRESS_MAPPING`
645 DROP TABLE IF EXISTS `DEVICE2IPADDRESS_MAPPING`;
646 /*!40101 SET @saved_cs_client = @@character_set_client */;
647 /*!40101 SET character_set_client = utf8 */;
648 CREATE TABLE `DEVICE2IPADDRESS_MAPPING` (
649 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
650 `device_id` varchar(100) NOT NULL,
651 `device_type` varchar(30) NOT NULL,
652 `secondary_key` varchar(100) NOT NULL,
653 `secondary_key_type` varchar(30) NOT NULL,
654 `address` varchar(50) NOT NULL,
655 `address_type` varchar(30) NOT NULL,
656 `ip_version` varchar(10) NOT NULL,
657 `length` int(11) NOT NULL,
658 `status` varchar(30) NOT NULL,
659 PRIMARY KEY (`serial_key`),
660 KEY `IX1_DEVICE2IPADDRESS_MAPPING` (`device_id`,`device_type`,`secondary_key`,`secondary_key_type`,`address`,`address_type`)
661 ) ENGINE=InnoDB AUTO_INCREMENT=4734 DEFAULT CHARSET=latin1;
662 /*!40101 SET character_set_client = @saved_cs_client */;
665 -- Table structure for table `DEVICE_AUTHENTICATION`
668 DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
669 /*!40101 SET @saved_cs_client = @@character_set_client */;
670 /*!40101 SET character_set_client = utf8 */;
671 CREATE TABLE `DEVICE_AUTHENTICATION` (
672 `device_authentication_id` int(11) NOT NULL AUTO_INCREMENT,
673 `vnf_type` varchar(50) DEFAULT NULL,
674 `user_name` varchar(50) DEFAULT NULL,
675 `password` varchar(100) DEFAULT NULL,
676 `protocol` varchar(100) DEFAULT NULL,
677 `port_number` int(11) DEFAULT NULL,
678 PRIMARY KEY (`device_authentication_id`),
679 UNIQUE KEY `device_authentication_id` (`device_authentication_id`)
680 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
681 /*!40101 SET character_set_client = @saved_cs_client */;
684 -- Table structure for table `DEVICE_INTERFACE_LOG`
687 DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
688 /*!40101 SET @saved_cs_client = @@character_set_client */;
689 /*!40101 SET character_set_client = utf8 */;
690 CREATE TABLE `DEVICE_INTERFACE_LOG` (
691 `device_interface_log_id` int(11) NOT NULL AUTO_INCREMENT,
692 `service_instance_id` varchar(50) DEFAULT NULL,
693 `request_id` varchar(50) DEFAULT NULL,
694 `creation_date` datetime NOT NULL,
696 PRIMARY KEY (`device_interface_log_id`),
697 UNIQUE KEY `device_interface_log_id` (`device_interface_log_id`)
698 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
699 /*!40101 SET character_set_client = @saved_cs_client */;
702 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
705 DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
706 /*!40101 SET @saved_cs_client = @@character_set_client */;
707 /*!40101 SET character_set_client = utf8 */;
708 CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
709 `device_interface_protocol_id` int(11) NOT NULL AUTO_INCREMENT,
710 `vnf_type` varchar(50) DEFAULT NULL,
711 `protocol` varchar(50) DEFAULT NULL,
712 `module` varchar(50) DEFAULT NULL,
713 `dg_rpc` varchar(50) DEFAULT NULL,
714 PRIMARY KEY (`device_interface_protocol_id`),
715 UNIQUE KEY `device_interface_protocol_id` (`device_interface_protocol_id`),
716 UNIQUE KEY `vnf_type` (`vnf_type`)
717 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
718 /*!40101 SET character_set_client = @saved_cs_client */;
721 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
724 DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
725 /*!40101 SET @saved_cs_client = @@character_set_client */;
726 /*!40101 SET character_set_client = utf8 */;
727 CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
728 `download_config_template_id` int(11) NOT NULL AUTO_INCREMENT,
729 `vnf_type` varchar(50) NOT NULL,
730 `protocol` varchar(50) NOT NULL,
732 PRIMARY KEY (`download_config_template_id`),
733 UNIQUE KEY `download_config_template_id` (`download_config_template_id`)
734 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
735 /*!40101 SET character_set_client = @saved_cs_client */;
738 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
741 DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
742 /*!40101 SET @saved_cs_client = @@character_set_client */;
743 /*!40101 SET character_set_client = utf8 */;
744 CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
745 `download_dg_reference_id` int(11) NOT NULL AUTO_INCREMENT,
746 `protocol` varchar(50) NOT NULL,
747 `download_config_dg` varchar(50) NOT NULL,
748 PRIMARY KEY (`download_dg_reference_id`),
749 UNIQUE KEY `download_dg_reference_id` (`download_dg_reference_id`)
750 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
751 /*!40101 SET character_set_client = @saved_cs_client */;
754 -- Table structure for table `EIPAM_CLIENT_KEY_INDEX`
757 DROP TABLE IF EXISTS `EIPAM_CLIENT_KEY_INDEX`;
758 /*!40101 SET @saved_cs_client = @@character_set_client */;
759 /*!40101 SET character_set_client = utf8 */;
760 CREATE TABLE `EIPAM_CLIENT_KEY_INDEX` (
761 `vnf_name_prefix` varchar(100) NOT NULL,
762 `index_number` int(11) NOT NULL,
763 PRIMARY KEY (`vnf_name_prefix`)
764 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
765 /*!40101 SET character_set_client = @saved_cs_client */;
768 -- Table structure for table `EIPAM_IP_ASSIGNMENTS`
771 DROP TABLE IF EXISTS `EIPAM_IP_ASSIGNMENTS`;
772 /*!40101 SET @saved_cs_client = @@character_set_client */;
773 /*!40101 SET character_set_client = utf8 */;
774 CREATE TABLE `EIPAM_IP_ASSIGNMENTS` (
775 `plan_name` varchar(40) NOT NULL,
776 `client_key` varchar(100) NOT NULL,
777 `service_type` varchar(40) NOT NULL,
778 `ip_address` varchar(40) DEFAULT NULL,
779 `prefix_length` int(2) DEFAULT NULL,
780 `status` varchar(255) DEFAULT NULL,
781 `service_instance_id` varchar(80) DEFAULT NULL,
782 `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
783 `prev_status` varchar(20) DEFAULT NULL,
784 `info` varchar(255) DEFAULT NULL,
785 PRIMARY KEY (`plan_name`,`client_key`)
786 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
787 /*!40101 SET character_set_client = @saved_cs_client */;
790 -- Table structure for table `EIPAM_IP_POOLS`
793 DROP TABLE IF EXISTS `EIPAM_IP_POOLS`;
794 /*!40101 SET @saved_cs_client = @@character_set_client */;
795 /*!40101 SET character_set_client = utf8 */;
796 CREATE TABLE `EIPAM_IP_POOLS` (
797 `pool_id` int(11) NOT NULL AUTO_INCREMENT,
798 `key_name` varchar(50) NOT NULL,
799 `key_value` varchar(255) NOT NULL,
800 `level` int(2) NOT NULL,
801 `plan_name` varchar(50) NOT NULL,
802 `address_family` varchar(10) NOT NULL,
803 `parent_pool` varchar(255) NOT NULL,
804 `service_instance_id` varchar(255) DEFAULT NULL,
805 `network_id` varchar(255) DEFAULT NULL,
806 `created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
807 `delete_failure` varchar(20) DEFAULT NULL,
808 `delete_request_id` varchar(255) DEFAULT NULL,
809 PRIMARY KEY (`pool_id`)
810 ) ENGINE=InnoDB AUTO_INCREMENT=339 DEFAULT CHARSET=latin1 COMMENT='This table will capture the pools being created by SDN-C in EIPAM_IP_POOLS. There is no data migration for existing vPE pool data.';
811 /*!40101 SET character_set_client = @saved_cs_client */;
814 -- Table structure for table `EIPAM_IP_SUBNETS`
817 DROP TABLE IF EXISTS `EIPAM_IP_SUBNETS`;
818 /*!40101 SET @saved_cs_client = @@character_set_client */;
819 /*!40101 SET character_set_client = utf8 */;
820 CREATE TABLE `EIPAM_IP_SUBNETS` (
821 `entity_id` int(6) NOT NULL,
822 `service_type` varchar(40) NOT NULL,
823 `plan_name` varchar(50) NOT NULL,
824 `address_family` varchar(10) NOT NULL,
825 `ip_address` varchar(40) NOT NULL,
826 `prefix_length` int(3) NOT NULL,
827 `status` varchar(20) NOT NULL,
828 `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
829 `network_id` varchar(255) DEFAULT NULL,
830 `pool_id` int(11) DEFAULT NULL,
831 `dealloc_failure` varchar(20) DEFAULT NULL,
832 `dealloc_request_id` varchar(255) DEFAULT NULL,
833 PRIMARY KEY (`entity_id`),
834 KEY `FK_EIPAM_IP_SUBNETS_EIPAM_IP_POOLS` (`pool_id`),
835 CONSTRAINT `EIPAM_IP_SUBNETS_ibfk_1` FOREIGN KEY (`pool_id`) REFERENCES `EIPAM_IP_POOLS` (`pool_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
836 CONSTRAINT `FK_EIPAM_IP_SUBNETS_EIPAM_IP_POOLS` FOREIGN KEY (`pool_id`) REFERENCES `EIPAM_IP_POOLS` (`pool_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
837 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
838 /*!40101 SET character_set_client = @saved_cs_client */;
841 -- Table structure for table `EIPAM_IP_SUBNET_KEYS`
844 DROP TABLE IF EXISTS `EIPAM_IP_SUBNET_KEYS`;
845 /*!40101 SET @saved_cs_client = @@character_set_client */;
846 /*!40101 SET character_set_client = utf8 */;
847 CREATE TABLE `EIPAM_IP_SUBNET_KEYS` (
848 `entity_id` int(6) NOT NULL,
849 `key_name` varchar(50) NOT NULL,
850 `key_value` varchar(255) NOT NULL,
851 `level` int(2) NOT NULL,
852 PRIMARY KEY (`entity_id`,`key_name`,`key_value`,`level`)
853 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
854 /*!40101 SET character_set_client = @saved_cs_client */;
857 -- Table structure for table `EIPAM_REQUEST_KEY`
860 DROP TABLE IF EXISTS `EIPAM_REQUEST_KEY`;
861 /*!40101 SET @saved_cs_client = @@character_set_client */;
862 /*!40101 SET character_set_client = utf8 */;
863 CREATE TABLE `EIPAM_REQUEST_KEY` (
864 `key_name_1` varchar(50) NOT NULL,
865 `address_family` varchar(4) NOT NULL,
866 `serial_key` int(2) NOT NULL AUTO_INCREMENT,
867 `plan_name` varchar(50) NOT NULL,
868 `request_length` int(2) NOT NULL,
869 `pools_length` int(2) NOT NULL,
870 `plan_length` int(2) NOT NULL,
871 `key_name_0` varchar(50) NOT NULL,
872 `key_name_type_0` varchar(255) NOT NULL,
873 `key_name_type_1` varchar(255) NOT NULL,
874 `prefix_length` int(2) NOT NULL,
875 `group_flag` char(1) NOT NULL,
876 `address_type` varchar(20) DEFAULT NULL,
877 PRIMARY KEY (`key_name_1`,`address_family`),
878 UNIQUE KEY `IX1_EIPAM_REQUEST_KEY` (`serial_key`)
879 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
880 /*!40101 SET character_set_client = @saved_cs_client */;
883 -- Table structure for table `EXTERNAL_DATA`
886 DROP TABLE IF EXISTS `EXTERNAL_DATA`;
887 /*!40101 SET @saved_cs_client = @@character_set_client */;
888 /*!40101 SET character_set_client = utf8 */;
889 CREATE TABLE `EXTERNAL_DATA` (
890 `external_data_id` int(11) NOT NULL AUTO_INCREMENT,
891 `request_id` int(11) DEFAULT NULL,
892 `param_name` varchar(30) NOT NULL,
893 `param_value` varchar(50) NOT NULL,
894 PRIMARY KEY (`external_data_id`)
895 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
896 /*!40101 SET character_set_client = @saved_cs_client */;
899 -- Table structure for table `FLOW_UPDATES`
902 DROP TABLE IF EXISTS `FLOW_UPDATES`;
903 /*!40101 SET @saved_cs_client = @@character_set_client */;
904 /*!40101 SET character_set_client = utf8 */;
905 CREATE TABLE `FLOW_UPDATES` (
906 `seq` int(11) NOT NULL AUTO_INCREMENT,
907 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
908 `create_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
909 `last_processed_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
910 `odl` varchar(128) DEFAULT NULL,
911 `address_family` enum('IPV4','IPV6') DEFAULT NULL,
912 `destination_prefix` varchar(50) DEFAULT NULL,
913 `communities` varchar(6000) DEFAULT NULL,
914 `route_key` varchar(50) DEFAULT NULL,
916 ) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=latin1;
917 /*!40101 SET character_set_client = @saved_cs_client */;
920 -- Table structure for table `GENERIC_L3_NETWORK`
923 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK`;
924 /*!40101 SET @saved_cs_client = @@character_set_client */;
925 /*!40101 SET character_set_client = utf8 */;
926 CREATE TABLE `GENERIC_L3_NETWORK` (
927 `network_id` varchar(80) NOT NULL,
928 `network_name` varchar(80) DEFAULT NULL,
929 `network_type` varchar(80) DEFAULT NULL,
930 `network_role` varchar(80) DEFAULT NULL,
931 `network_technology` varchar(80) DEFAULT NULL,
932 `neutron_network_id` varchar(80) DEFAULT NULL,
933 `is_bound_to_vpn` tinyint(1) DEFAULT NULL,
934 `orchestration_status` varchar(20) DEFAULT NULL,
935 `heat_stack_id` varchar(80) DEFAULT NULL,
936 `mso_catalog_key` varchar(80) DEFAULT NULL,
937 `service_id` varchar(80) NOT NULL,
938 `tenant_id` varchar(80) NOT NULL,
939 `physical_location_id` varchar(20) DEFAULT NULL,
940 `network_role_instance` varchar(80) NOT NULL,
941 PRIMARY KEY (`network_id`)
942 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
943 /*!40101 SET character_set_client = @saved_cs_client */;
946 -- Table structure for table `GENERIC_L3_NETWORK_SUBNET`
949 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK_SUBNET`;
950 /*!40101 SET @saved_cs_client = @@character_set_client */;
951 /*!40101 SET character_set_client = utf8 */;
952 CREATE TABLE `GENERIC_L3_NETWORK_SUBNET` (
953 `network_id` varchar(80) NOT NULL,
954 `subnet_id` varchar(80) NOT NULL,
955 `neutron_subnet_id` varchar(80) DEFAULT NULL,
956 `gateway_address` varchar(45) NOT NULL,
957 `network_start_address` varchar(45) NOT NULL,
958 `cidr_mask` varchar(20) NOT NULL,
959 `ip_version` char(1) NOT NULL,
960 `orchestration_status` varchar(64) NOT NULL,
961 `dhcp_enabled` tinyint(1) NOT NULL,
962 `dhcp_start` varchar(45) DEFAULT NULL,
963 `dhcp_end` varchar(45) DEFAULT NULL,
964 PRIMARY KEY (`network_id`,`subnet_id`)
965 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
966 /*!40101 SET character_set_client = @saved_cs_client */;
969 -- Table structure for table `GENERIC_L3_NETWORK_VPN_BINDING`
972 DROP TABLE IF EXISTS `GENERIC_L3_NETWORK_VPN_BINDING`;
973 /*!40101 SET @saved_cs_client = @@character_set_client */;
974 /*!40101 SET character_set_client = utf8 */;
975 CREATE TABLE `GENERIC_L3_NETWORK_VPN_BINDING` (
976 `network_id` varchar(80) NOT NULL,
977 `vpn_id` varchar(80) NOT NULL,
978 PRIMARY KEY (`network_id`,`vpn_id`)
979 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
980 /*!40101 SET character_set_client = @saved_cs_client */;
983 -- Table structure for table `GENERIC_RESOURCE_NAME`
986 DROP TABLE IF EXISTS `GENERIC_RESOURCE_NAME`;
987 /*!40101 SET @saved_cs_client = @@character_set_client */;
988 /*!40101 SET character_set_client = utf8 */;
989 CREATE TABLE `GENERIC_RESOURCE_NAME` (
990 `type` varchar(50) NOT NULL,
991 `name` varchar(255) NOT NULL,
992 `prefix` varchar(255) NULL,
993 `name_index` int(11) NULL,
994 `context_id` varchar(255) NULL,
995 PRIMARY KEY (`type`,`name`)
996 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
997 /*!40101 SET character_set_client = @saved_cs_client */;
1000 -- Table structure for table `GENERIC_VNF`
1003 DROP TABLE IF EXISTS `GENERIC_VNF`;
1004 /*!40101 SET @saved_cs_client = @@character_set_client */;
1005 /*!40101 SET character_set_client = utf8 */;
1006 CREATE TABLE `GENERIC_VNF` (
1007 `vnf_id` varchar(80) NOT NULL,
1008 `vnf_name` varchar(80) NOT NULL,
1009 `vnf_type` varchar(200) NOT NULL,
1010 `vnf_name2` varchar(80) DEFAULT NULL,
1011 `service_id` varchar(80) NOT NULL,
1012 `equipment_role` varchar(80) NOT NULL,
1013 `orchestration_status` varchar(20) DEFAULT NULL,
1014 `prov_status` varchar(20) DEFAULT NULL,
1015 `heat_stack_id` varchar(80) DEFAULT NULL,
1016 `mso_catalog_key` varchar(80) DEFAULT NULL,
1017 `regional_resource_zone` varchar(80) DEFAULT NULL,
1018 `operational_state` varchar(80) DEFAULT NULL,
1019 `license_key` varchar(80) DEFAULT NULL,
1020 `ipv4_oam_address` varchar(20) DEFAULT NULL,
1021 `ipv4_loopback0_address` varchar(20) DEFAULT NULL,
1022 `nm_lan_v6_address` varchar(40) DEFAULT NULL,
1023 `management_v6_address` varchar(40) DEFAULT NULL,
1024 `management_option` varchar(45) DEFAULT NULL,
1025 `vcpu` varchar(45) DEFAULT NULL,
1026 `vmemory` varchar(45) DEFAULT NULL,
1027 `vdisk` varchar(45) DEFAULT NULL,
1028 `vcpu_units` varchar(45) DEFAULT NULL,
1029 `vmemory_units` varchar(45) DEFAULT NULL,
1030 `vdisk_units` varchar(45) DEFAULT NULL,
1031 PRIMARY KEY (`vnf_id`)
1032 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1033 /*!40101 SET character_set_client = @saved_cs_client */;
1036 -- Table structure for table `GENERIC_VNF_L3_NETWORK`
1039 DROP TABLE IF EXISTS `GENERIC_VNF_L3_NETWORK`;
1040 /*!40101 SET @saved_cs_client = @@character_set_client */;
1041 /*!40101 SET character_set_client = utf8 */;
1042 CREATE TABLE `GENERIC_VNF_L3_NETWORK` (
1043 `vnf_id` varchar(80) NOT NULL,
1044 `network_id` varchar(80) NOT NULL,
1045 PRIMARY KEY (`vnf_id`,`network_id`)
1046 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1047 /*!40101 SET character_set_client = @saved_cs_client */;
1050 -- Table structure for table `GENERIC_VNF_LICENSE_MANAGEMENT`
1053 DROP TABLE IF EXISTS `GENERIC_VNF_LICENSE_MANAGEMENT`;
1054 /*!40101 SET @saved_cs_client = @@character_set_client */;
1055 /*!40101 SET character_set_client = utf8 */;
1056 CREATE TABLE `GENERIC_VNF_LICENSE_MANAGEMENT` (
1057 `vnf_id` varchar(80) NOT NULL,
1058 `att_uuid` varchar(80) NOT NULL,
1059 PRIMARY KEY (`vnf_id`,`att_uuid`)
1060 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1061 /*!40101 SET character_set_client = @saved_cs_client */;
1064 -- Table structure for table `GENERIC_VNF_LINTERFACE`
1067 DROP TABLE IF EXISTS `GENERIC_VNF_LINTERFACE`;
1068 /*!40101 SET @saved_cs_client = @@character_set_client */;
1069 /*!40101 SET character_set_client = utf8 */;
1070 CREATE TABLE `GENERIC_VNF_LINTERFACE` (
1071 `vnf_id` varchar(80) NOT NULL,
1072 `interface_name` varchar(255) NOT NULL,
1073 `interface_role` varchar(45) DEFAULT NULL,
1074 `v6_wan_link_ip` varchar(45) DEFAULT NULL,
1075 `selflink` varchar(128) DEFAULT NULL,
1076 `interface_id` varchar(45) DEFAULT NULL,
1077 `macaddr` varchar(64) DEFAULT NULL,
1078 `network_name` varchar(255) DEFAULT NULL,
1079 PRIMARY KEY (`vnf_id`,`interface_name`),
1080 KEY `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF_IDX` (`vnf_id`),
1081 CONSTRAINT `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF` FOREIGN KEY (`vnf_id`) REFERENCES `GENERIC_VNF` (`vnf_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
1082 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1083 /*!40101 SET character_set_client = @saved_cs_client */;
1086 -- Table structure for table `GENERIC_VNF_PSERVER`
1089 DROP TABLE IF EXISTS `GENERIC_VNF_PSERVER`;
1090 /*!40101 SET @saved_cs_client = @@character_set_client */;
1091 /*!40101 SET character_set_client = utf8 */;
1092 CREATE TABLE `GENERIC_VNF_PSERVER` (
1093 `vnf_id` varchar(64) NOT NULL,
1094 `hostname` varchar(255) NOT NULL,
1095 PRIMARY KEY (`vnf_id`,`hostname`)
1096 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1097 /*!40101 SET character_set_client = @saved_cs_client */;
1100 -- Table structure for table `GENERIC_VNF_SERVICE_INSTANCE`
1103 DROP TABLE IF EXISTS `GENERIC_VNF_SERVICE_INSTANCE`;
1104 /*!40101 SET @saved_cs_client = @@character_set_client */;
1105 /*!40101 SET character_set_client = utf8 */;
1106 CREATE TABLE `GENERIC_VNF_SERVICE_INSTANCE` (
1107 `vnf_id` varchar(64) NOT NULL,
1108 `service_instance_id` varchar(255) NOT NULL,
1109 `relationship_key` varchar(64) NOT NULL,
1110 `relationship_value` varchar(64) DEFAULT NULL,
1111 `global_customer_id` varchar(255) DEFAULT NULL,
1112 `service_type` varchar(255) DEFAULT NULL,
1113 PRIMARY KEY (`vnf_id`,`service_instance_id`,`relationship_key`)
1114 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1115 /*!40101 SET character_set_client = @saved_cs_client */;
1118 -- Table structure for table `GENERIC_VNF_VNF_IMAGE`
1121 DROP TABLE IF EXISTS `GENERIC_VNF_VNF_IMAGE`;
1122 /*!40101 SET @saved_cs_client = @@character_set_client */;
1123 /*!40101 SET character_set_client = utf8 */;
1124 CREATE TABLE `GENERIC_VNF_VNF_IMAGE` (
1125 `vnf_id` varchar(64) NOT NULL,
1126 `att_uuid` varchar(255) NOT NULL,
1127 PRIMARY KEY (`vnf_id`,`att_uuid`)
1128 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1129 /*!40101 SET character_set_client = @saved_cs_client */;
1132 -- Table structure for table `GENERIC_VNF_VSERVER`
1135 DROP TABLE IF EXISTS `GENERIC_VNF_VSERVER`;
1136 /*!40101 SET @saved_cs_client = @@character_set_client */;
1137 /*!40101 SET character_set_client = utf8 */;
1138 CREATE TABLE `GENERIC_VNF_VSERVER` (
1139 `vnf_id` varchar(80) NOT NULL,
1140 `vserver_id` varchar(128) NOT NULL,
1141 `tenant_id` varchar(128) DEFAULT NULL,
1142 PRIMARY KEY (`vnf_id`,`vserver_id`)
1143 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1144 /*!40101 SET character_set_client = @saved_cs_client */;
1147 -- Table structure for table `GENERIC_VPN_BINDING`
1150 DROP TABLE IF EXISTS `GENERIC_VPN_BINDING`;
1151 /*!40101 SET @saved_cs_client = @@character_set_client */;
1152 /*!40101 SET character_set_client = utf8 */;
1153 CREATE TABLE `GENERIC_VPN_BINDING` (
1154 `vpn_id` varchar(80) NOT NULL,
1155 `vpn_name` varchar(80) NOT NULL,
1156 `global_route_target` varchar(80) NOT NULL,
1157 PRIMARY KEY (`vpn_id`)
1158 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1159 /*!40101 SET character_set_client = @saved_cs_client */;
1162 -- Table structure for table `GET_CONFIG_TEMPLATE`
1165 DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
1166 /*!40101 SET @saved_cs_client = @@character_set_client */;
1167 /*!40101 SET character_set_client = utf8 */;
1168 CREATE TABLE `GET_CONFIG_TEMPLATE` (
1169 `get_config_template_id` int(11) NOT NULL AUTO_INCREMENT,
1170 `vnf_type` varchar(50) NOT NULL,
1171 `device_interface_protocol_id` int(11) NOT NULL,
1172 `xml_processing` varchar(1) DEFAULT NULL,
1173 `xml_protocol` varchar(30) DEFAULT NULL,
1174 `template` longtext,
1175 PRIMARY KEY (`get_config_template_id`),
1176 UNIQUE KEY `get_config_template_id` (`get_config_template_id`),
1177 KEY `get_config_template_ibfk_1` (`device_interface_protocol_id`),
1178 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
1179 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1180 /*!40101 SET character_set_client = @saved_cs_client */;
1183 -- Table structure for table `HOSTNAME`
1186 DROP TABLE IF EXISTS `HOSTNAME`;
1187 /*!40101 SET @saved_cs_client = @@character_set_client */;
1188 /*!40101 SET character_set_client = utf8 */;
1189 CREATE TABLE `HOSTNAME` (
1190 `hostname` varchar(21) NOT NULL,
1191 `parent_hostname` varchar(21) DEFAULT NULL,
1192 `cust_id` int(11) NOT NULL,
1193 `loc_id` int(11) NOT NULL,
1194 `site_sequence` varchar(2) NOT NULL,
1195 `server_sequence` varchar(2) NOT NULL,
1196 `activation_code` varchar(11) DEFAULT NULL,
1197 `vnf_sequence` varchar(2) DEFAULT NULL,
1198 `vendor_code` varchar(1) NOT NULL,
1199 `virtual_device_type` varchar(2) DEFAULT NULL,
1200 `device_sequence` varchar(3) DEFAULT NULL,
1201 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1202 PRIMARY KEY (`hostname`),
1203 KEY `IN1_HOSTNAME` (`cust_id`),
1204 KEY `IN2_HOSTNAME` (`loc_id`),
1205 KEY `IN3_HOSTNAME` (`vendor_code`),
1206 KEY `IN4_HOSTNAME` (`parent_hostname`),
1207 CONSTRAINT `FK1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1208 CONSTRAINT `FK2_HOSTNAME` FOREIGN KEY (`loc_id`) REFERENCES `LOCATION` (`loc_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1209 CONSTRAINT `FK4_HOSTNAME` FOREIGN KEY (`parent_hostname`) REFERENCES `HOSTNAME` (`hostname`) ON DELETE NO ACTION ON UPDATE NO ACTION
1210 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1211 /*!40101 SET character_set_client = @saved_cs_client */;
1214 -- Table structure for table `IPV4_ADDRESS_POOL`
1217 DROP TABLE IF EXISTS `IPV4_ADDRESS_POOL`;
1218 /*!40101 SET @saved_cs_client = @@character_set_client */;
1219 /*!40101 SET character_set_client = utf8 */;
1220 CREATE TABLE `IPV4_ADDRESS_POOL` (
1221 `aic_site_id` varchar(100) NOT NULL,
1222 `universe` varchar(40) NOT NULL,
1223 `status` varchar(40) NOT NULL,
1224 `ipv4_addr` varchar(20) NOT NULL,
1225 PRIMARY KEY (`ipv4_addr`,`universe`)
1226 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1227 /*!40101 SET character_set_client = @saved_cs_client */;
1230 -- Table structure for table `LINK_MASTER`
1233 DROP TABLE IF EXISTS `LINK_MASTER`;
1234 /*!40101 SET @saved_cs_client = @@character_set_client */;
1235 /*!40101 SET character_set_client = utf8 */;
1236 CREATE TABLE `LINK_MASTER` (
1237 `link_interface_ip` varchar(20) NOT NULL,
1238 `source_crs_name` varchar(20) NOT NULL,
1239 `destination_crs_name` varchar(20) NOT NULL,
1240 `max_reserved_bw` int(11) DEFAULT NULL,
1241 `default_cost` int(11) DEFAULT NULL,
1242 `bundle_name` varchar(20) DEFAULT NULL,
1243 PRIMARY KEY (`link_interface_ip`)
1244 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1245 /*!40101 SET character_set_client = @saved_cs_client */;
1248 -- Table structure for table `LINTERFACE_VLAN`
1251 DROP TABLE IF EXISTS `LINTERFACE_VLAN`;
1252 /*!40101 SET @saved_cs_client = @@character_set_client */;
1253 /*!40101 SET character_set_client = utf8 */;
1254 CREATE TABLE `LINTERFACE_VLAN` (
1255 `vnf_id` varchar(80) NOT NULL,
1256 `interface_name` varchar(255) NOT NULL,
1257 `vlan_interface` varchar(255) NOT NULL,
1258 `vlan_id_inner` varchar(64) DEFAULT NULL,
1259 `vlan_id_outer` varchar(64) DEFAULT NULL,
1260 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`),
1261 KEY `FK_LINTERFACE_VLAN_GENERIC_VNF_LINTERFACE_IDX` (`vnf_id`,`interface_name`),
1262 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
1263 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1264 /*!40101 SET character_set_client = @saved_cs_client */;
1267 -- Table structure for table `LOCATION`
1270 DROP TABLE IF EXISTS `LOCATION`;
1271 /*!40101 SET @saved_cs_client = @@character_set_client */;
1272 /*!40101 SET character_set_client = utf8 */;
1273 CREATE TABLE `LOCATION` (
1274 `loc_id` int(11) NOT NULL AUTO_INCREMENT,
1275 `address` varchar(150) NOT NULL,
1276 `city_code_id` int(11) NOT NULL,
1277 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1278 PRIMARY KEY (`loc_id`),
1279 KEY `IN1_LOCATION_IDX` (`city_code_id`),
1280 CONSTRAINT `FK1_LOCATION` FOREIGN KEY (`city_code_id`) REFERENCES `CITY_CODE` (`city_code_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
1281 ) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=latin1;
1282 /*!40101 SET character_set_client = @saved_cs_client */;
1285 -- Table structure for table `MAX_PORT_SPEED`
1288 DROP TABLE IF EXISTS `MAX_PORT_SPEED`;
1289 /*!40101 SET @saved_cs_client = @@character_set_client */;
1290 /*!40101 SET character_set_client = utf8 */;
1291 CREATE TABLE `MAX_PORT_SPEED` (
1292 `max_port_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1293 `image_file_name` varchar(50) NOT NULL,
1294 `end_point_position` varchar(50) NOT NULL,
1295 `interface_name` varchar(100) NOT NULL,
1296 `max_speed` bigint(20) NOT NULL,
1297 `unit` varchar(10) NOT NULL,
1298 PRIMARY KEY (`max_port_speed_id`),
1299 UNIQUE KEY `max_port_speed_id` (`max_port_speed_id`)
1300 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1301 /*!40101 SET character_set_client = @saved_cs_client */;
1304 -- Table structure for table `MAX_SERVER_SPEED`
1307 DROP TABLE IF EXISTS `MAX_SERVER_SPEED`;
1308 /*!40101 SET @saved_cs_client = @@character_set_client */;
1309 /*!40101 SET character_set_client = utf8 */;
1310 CREATE TABLE `MAX_SERVER_SPEED` (
1311 `max_server_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1312 `server_model` varchar(50) NOT NULL,
1313 `evc_count` smallint(6) NOT NULL,
1314 `max_speed` bigint(20) NOT NULL,
1315 `unit` varchar(10) NOT NULL,
1316 `description` varchar(500) DEFAULT NULL,
1317 PRIMARY KEY (`max_server_speed_id`),
1318 UNIQUE KEY `max_server_speed_id` (`max_server_speed_id`)
1319 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
1320 /*!40101 SET character_set_client = @saved_cs_client */;
1323 -- Table structure for table `NAMING_POLICY_VM_NAME_INDEX`
1326 DROP TABLE IF EXISTS `NAMING_POLICY_VM_NAME_INDEX`;
1327 /*!40101 SET @saved_cs_client = @@character_set_client */;
1328 /*!40101 SET character_set_client = utf8 */;
1329 CREATE TABLE `NAMING_POLICY_VM_NAME_INDEX` (
1330 `vm_name_prefix` varchar(255) NOT NULL,
1331 `index_number` int(11) NOT NULL,
1332 PRIMARY KEY (`vm_name_prefix`)
1333 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1334 /*!40101 SET character_set_client = @saved_cs_client */;
1337 -- Table structure for table `NAMING_POLICY_VNFC_NAME_INDEX`
1340 DROP TABLE IF EXISTS `NAMING_POLICY_VNFC_NAME_INDEX`;
1341 /*!40101 SET @saved_cs_client = @@character_set_client */;
1342 /*!40101 SET character_set_client = utf8 */;
1343 CREATE TABLE `NAMING_POLICY_VNFC_NAME_INDEX` (
1344 `vnfc_name_prefix` varchar(255) NOT NULL,
1345 `index_number` int(11) NOT NULL,
1346 PRIMARY KEY (`vnfc_name_prefix`)
1347 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1348 /*!40101 SET character_set_client = @saved_cs_client */;
1351 -- Table structure for table `NBNC_ASSIGN_VPN_OVERRIDE`
1354 DROP TABLE IF EXISTS `NBNC_ASSIGN_VPN_OVERRIDE`;
1355 /*!40101 SET @saved_cs_client = @@character_set_client */;
1356 /*!40101 SET character_set_client = utf8 */;
1357 CREATE TABLE `NBNC_ASSIGN_VPN_OVERRIDE` (
1358 `vpn_id` varchar(12) NOT NULL DEFAULT '',
1359 `vpn_rt` varchar(16) NOT NULL DEFAULT '',
1360 `service_type` varchar(16) NOT NULL DEFAULT '',
1361 `be_location` varchar(16) NOT NULL DEFAULT '',
1362 `be_type` varchar(32) NOT NULL DEFAULT '',
1363 `be_id` varchar(32) DEFAULT NULL,
1364 `description` varchar(128) DEFAULT NULL,
1365 PRIMARY KEY (`vpn_id`,`vpn_rt`,`service_type`,`be_location`,`be_type`)
1366 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1367 /*!40101 SET character_set_client = @saved_cs_client */;
1370 -- Table structure for table `NBNC_BORDER_ELEMENT`
1373 DROP TABLE IF EXISTS `NBNC_BORDER_ELEMENT`;
1374 /*!40101 SET @saved_cs_client = @@character_set_client */;
1375 /*!40101 SET character_set_client = utf8 */;
1376 CREATE TABLE `NBNC_BORDER_ELEMENT` (
1377 `be_id` varchar(32) NOT NULL,
1378 `be_type` varchar(16) NOT NULL,
1379 `be_name` varchar(32) DEFAULT NULL,
1380 `be_host_vnf_id` varchar(32) DEFAULT NULL,
1381 `service_type` varchar(16) DEFAULT NULL,
1382 `tangibility` varchar(16) DEFAULT NULL,
1383 `usage_order` smallint(6) DEFAULT NULL,
1384 `vlan_start` smallint(6) DEFAULT NULL,
1385 `vlan_end` smallint(6) DEFAULT NULL,
1386 `ipv4_subnet` varchar(18) DEFAULT NULL,
1387 `ipv6_subnet` varchar(68) DEFAULT NULL,
1388 `network_ip` varchar(48) DEFAULT NULL,
1389 `be_location` varchar(16) DEFAULT NULL,
1390 `description` varchar(128) DEFAULT NULL,
1391 `updated_timestamp` timestamp NULL DEFAULT NULL,
1392 `log_link_model_uuid` varchar(64) DEFAULT NULL,
1393 PRIMARY KEY (`be_id`,`be_type`)
1394 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1395 /*!40101 SET character_set_client = @saved_cs_client */;
1398 -- Table structure for table `NBNC_IPE`
1401 DROP TABLE IF EXISTS `NBNC_IPE`;
1402 /*!40101 SET @saved_cs_client = @@character_set_client */;
1403 /*!40101 SET character_set_client = utf8 */;
1404 CREATE TABLE `NBNC_IPE` (
1405 `ipe_name` varchar(32) NOT NULL,
1406 `ipe_location` varchar(16) DEFAULT NULL,
1407 `ipe_ip_address` varchar(16) DEFAULT NULL,
1408 `ipe_id` varchar(8) DEFAULT NULL,
1409 `service_type_array` varchar(512) DEFAULT NULL,
1410 `ipe_status` varchar(32) DEFAULT NULL,
1411 `updated_timestamp` timestamp NULL DEFAULT NULL,
1412 PRIMARY KEY (`ipe_name`)
1413 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1414 /*!40101 SET character_set_client = @saved_cs_client */;
1417 -- Table structure for table `NBNC_IPE_PORT`
1420 DROP TABLE IF EXISTS `NBNC_IPE_PORT`;
1421 /*!40101 SET @saved_cs_client = @@character_set_client */;
1422 /*!40101 SET character_set_client = utf8 */;
1423 CREATE TABLE `NBNC_IPE_PORT` (
1424 `port_id` varchar(16) NOT NULL,
1425 `ipe_name` varchar(32) NOT NULL,
1426 `be_id` varchar(32) NOT NULL,
1427 `be_type` varchar(16) NOT NULL,
1428 `port_type` varchar(16) DEFAULT NULL,
1429 `ae_name` varchar(16) DEFAULT NULL,
1430 `description` varchar(128) DEFAULT NULL,
1431 `updated_timestamp` timestamp NULL DEFAULT NULL,
1432 PRIMARY KEY (`port_id`,`ipe_name`,`be_id`,`be_type`)
1433 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1434 /*!40101 SET character_set_client = @saved_cs_client */;
1437 -- Table structure for table `NBNC_MAPPING_SBG_BGF`
1440 DROP TABLE IF EXISTS `NBNC_MAPPING_SBG_BGF`;
1441 /*!40101 SET @saved_cs_client = @@character_set_client */;
1442 /*!40101 SET character_set_client = utf8 */;
1443 CREATE TABLE `NBNC_MAPPING_SBG_BGF` (
1444 `asbg_vlan` smallint(6) NOT NULL,
1445 `bgf_vlan` smallint(6) NOT NULL,
1446 PRIMARY KEY (`asbg_vlan`)
1447 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1448 /*!40101 SET character_set_client = @saved_cs_client */;
1451 -- Table structure for table `NBNC_SERVICE`
1454 DROP TABLE IF EXISTS `NBNC_SERVICE`;
1455 /*!40101 SET @saved_cs_client = @@character_set_client */;
1456 /*!40101 SET character_set_client = utf8 */;
1457 CREATE TABLE `NBNC_SERVICE` (
1458 `service_type` varchar(16) NOT NULL,
1459 `service_model_uuid` varchar(64) NOT NULL,
1460 `description` varchar(128) DEFAULT NULL,
1461 `created_timestamp` timestamp NULL DEFAULT NULL,
1462 `updated_timestamp` timestamp NULL DEFAULT NULL,
1463 PRIMARY KEY (`service_type`)
1464 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1465 /*!40101 SET character_set_client = @saved_cs_client */;
1468 -- Table structure for table `NBNC_SERVICE_VLAN`
1471 DROP TABLE IF EXISTS `NBNC_SERVICE_VLAN`;
1472 /*!40101 SET @saved_cs_client = @@character_set_client */;
1473 /*!40101 SET character_set_client = utf8 */;
1474 CREATE TABLE `NBNC_SERVICE_VLAN` (
1475 `be_id` varchar(32) NOT NULL,
1476 `vlan` smallint(6) NOT NULL,
1477 `service_type` varchar(16) DEFAULT NULL,
1478 `be_type` varchar(16) DEFAULT NULL,
1479 `be_name` varchar(32) DEFAULT NULL,
1480 `be_host_vnf_id` varchar(32) DEFAULT NULL,
1481 `be_location` varchar(16) DEFAULT NULL,
1482 `be_usage_order` smallint(6) DEFAULT NULL,
1483 `vlan_usage_order` smallint(6) DEFAULT NULL,
1484 `status` varchar(16) DEFAULT 'AVAILABLE',
1485 `request_id` varchar(64) DEFAULT NULL,
1486 `service_instance_id` varchar(64) DEFAULT NULL,
1487 `vni_id` varchar(16) DEFAULT NULL,
1488 `customer_id` varchar(16) DEFAULT NULL,
1489 `ipe1_router_name` varchar(32) DEFAULT NULL,
1490 `ipe1_port_id` varchar(16) DEFAULT NULL,
1491 `ipe1_ae_name` varchar(16) DEFAULT NULL,
1492 `ipe2_router_name` varchar(32) DEFAULT NULL,
1493 `ipe2_port_id` varchar(16) DEFAULT NULL,
1494 `ipe2_ae_name` varchar(16) DEFAULT NULL,
1495 `available_timestamp` timestamp NULL DEFAULT NULL,
1496 `allocated_timestamp` timestamp NULL DEFAULT NULL,
1497 `disabled_timestamp` timestamp NULL DEFAULT NULL,
1498 `enabled_timestamp` timestamp NULL DEFAULT NULL,
1499 `vpn_id` varchar(12) DEFAULT NULL,
1500 `vpn_rt` varchar(16) DEFAULT NULL,
1501 PRIMARY KEY (`be_id`,`vlan`)
1502 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1503 /*!40101 SET character_set_client = @saved_cs_client */;
1506 -- Table structure for table `NCS_EXPECTED_ASYNC_REQUESTS`
1509 DROP TABLE IF EXISTS `NCS_EXPECTED_ASYNC_REQUESTS`;
1510 /*!40101 SET @saved_cs_client = @@character_set_client */;
1511 /*!40101 SET character_set_client = utf8 */;
1512 CREATE TABLE `NCS_EXPECTED_ASYNC_REQUESTS` (
1513 `ncs_request_id` varchar(255) NOT NULL,
1514 `mso_gp_request_id` varchar(255) NOT NULL,
1515 `service_instance_id` varchar(255) NOT NULL,
1516 `sdn_module_name` varchar(255) NOT NULL,
1517 `sdn_rpc_name` varchar(255) NOT NULL,
1518 `sdn_service_action` varchar(255) DEFAULT NULL,
1519 `ncs_rpc` varchar(255) NOT NULL,
1520 `ncs_sub_action` varchar(255) DEFAULT NULL,
1521 `status` varchar(255) NOT NULL DEFAULT 'inProgress',
1522 `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1523 PRIMARY KEY (`ncs_request_id`)
1524 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1525 /*!40101 SET character_set_client = @saved_cs_client */;
1528 -- Table structure for table `NETWORK_INSTANCE_NAME_INDEX`
1531 DROP TABLE IF EXISTS `NETWORK_INSTANCE_NAME_INDEX`;
1532 /*!40101 SET @saved_cs_client = @@character_set_client */;
1533 /*!40101 SET character_set_client = utf8 */;
1534 CREATE TABLE `NETWORK_INSTANCE_NAME_INDEX` (
1535 `network_instance_name_prefix` varchar(255) NOT NULL,
1536 `index_number` int(11) NOT NULL,
1537 PRIMARY KEY (`network_instance_name_prefix`)
1538 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1539 /*!40101 SET character_set_client = @saved_cs_client */;
1542 -- Table structure for table `NETWORK_MODEL`
1545 DROP TABLE IF EXISTS `NETWORK_MODEL`;
1546 /*!40101 SET @saved_cs_client = @@character_set_client */;
1547 /*!40101 SET character_set_client = utf8 */;
1548 CREATE TABLE `NETWORK_MODEL` (
1549 `customization_uuid` varchar(255) NOT NULL,
1550 `service_uuid` varchar(255) NOT NULL,
1551 `model_yaml` longblob,
1552 `invariant_uuid` varchar(255) DEFAULT NULL,
1553 `uuid` varchar(255) DEFAULT NULL,
1554 `network_type` varchar(255) DEFAULT NULL,
1555 `network_role` varchar(255) DEFAULT NULL,
1556 `network_technology` varchar(255) DEFAULT NULL,
1557 `trunk_network_indicator` char(1) DEFAULT NULL,
1558 `network_scope` varchar(255) DEFAULT NULL,
1559 `naming_policy` varchar(255) DEFAULT NULL,
1560 `ecomp_generated_naming` char(1) DEFAULT NULL,
1561 `is_shared_network` char(1) DEFAULT NULL,
1562 `is_external_network` char(1) DEFAULT NULL,
1563 `is_provider_network` char(1) DEFAULT NULL,
1564 `physical_network_name` varchar(255) DEFAULT NULL,
1565 `is_bound_to_vpn` char(1) DEFAULT NULL,
1566 `vpn_binding` varchar(255) DEFAULT NULL,
1567 `use_ipv4` char(1) DEFAULT NULL,
1568 `ipv4_dhcp_enabled` char(1) DEFAULT NULL,
1569 `ipv4_ip_version` char(1) DEFAULT NULL,
1570 `ipv4_cidr_mask` varchar(255) DEFAULT NULL,
1571 `eipam_v4_address_plan` varchar(255) DEFAULT NULL,
1572 `use_ipv6` char(1) DEFAULT NULL,
1573 `ipv6_dhcp_enabled` char(1) DEFAULT NULL,
1574 `ipv6_ip_version` char(1) DEFAULT NULL,
1575 `ipv6_cidr_mask` varchar(255) DEFAULT NULL,
1576 `eipam_v6_address_plan` varchar(255) DEFAULT NULL,
1577 `version` varchar(255) DEFAULT NULL,
1578 PRIMARY KEY (`customization_uuid`),
1579 KEY `FK_NETWORK_MODEL` (`service_uuid`),
1580 CONSTRAINT `FK_NETWORK_MODEL` FOREIGN KEY (`service_uuid`) REFERENCES `SERVICE_MODEL` (`service_uuid`) ON DELETE NO ACTION ON UPDATE NO ACTION
1581 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1582 /*!40101 SET character_set_client = @saved_cs_client */;
1585 -- Table structure for table `NETWORK_PROFILE`
1588 DROP TABLE IF EXISTS `NETWORK_PROFILE`;
1589 /*!40101 SET @saved_cs_client = @@character_set_client */;
1590 /*!40101 SET character_set_client = utf8 */;
1591 CREATE TABLE `NETWORK_PROFILE` (
1592 `network_type` varchar(100) NOT NULL,
1593 `technology` varchar(100) NOT NULL,
1594 PRIMARY KEY (`network_type`)
1595 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1596 /*!40101 SET character_set_client = @saved_cs_client */;
1599 -- Table structure for table `NETWORK_ROLE_VPN_BINDING`
1602 DROP TABLE IF EXISTS `NETWORK_ROLE_VPN_BINDING`;
1603 /*!40101 SET @saved_cs_client = @@character_set_client */;
1604 /*!40101 SET character_set_client = utf8 */;
1605 CREATE TABLE `NETWORK_ROLE_VPN_BINDING` (
1606 `network_role` varchar(80) NOT NULL,
1607 `vpn_id` varchar(80) NOT NULL,
1608 PRIMARY KEY (`network_role`,`vpn_id`)
1609 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1610 /*!40101 SET character_set_client = @saved_cs_client */;
1613 -- Table structure for table `NODE_TYPES`
1616 DROP TABLE IF EXISTS `NODE_TYPES`;
1617 /*!40101 SET @saved_cs_client = @@character_set_client */;
1618 /*!40101 SET character_set_client = utf8 */;
1619 CREATE TABLE `NODE_TYPES` (
1620 `nodetype` varchar(80) NOT NULL,
1621 PRIMARY KEY (`nodetype`)
1622 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1623 /*!40101 SET character_set_client = @saved_cs_client */;
1626 -- Table structure for table `OBJECT_GROUPING`
1629 DROP TABLE IF EXISTS `OBJECT_GROUPING`;
1630 /*!40101 SET @saved_cs_client = @@character_set_client */;
1631 /*!40101 SET character_set_client = utf8 */;
1632 CREATE TABLE `OBJECT_GROUPING` (
1633 `group_id` varchar(128) NOT NULL,
1634 `group_type` varchar(128) NOT NULL,
1635 PRIMARY KEY (`group_id`)
1636 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1637 /*!40101 SET character_set_client = @saved_cs_client */;
1640 -- Table structure for table `OBJECT_GROUP_MEMBER_TRACKING`
1643 DROP TABLE IF EXISTS `OBJECT_GROUP_MEMBER_TRACKING`;
1644 /*!40101 SET @saved_cs_client = @@character_set_client */;
1645 /*!40101 SET character_set_client = utf8 */;
1646 CREATE TABLE `OBJECT_GROUP_MEMBER_TRACKING` (
1647 `group_id` varchar(128) NOT NULL,
1648 `key_id` varchar(128) NOT NULL,
1649 `key_type` varchar(128) NOT NULL,
1650 PRIMARY KEY (`group_id`,`key_id`,`key_type`)
1651 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1652 /*!40101 SET character_set_client = @saved_cs_client */;
1655 -- Table structure for table `PARAMETERS`
1658 DROP TABLE IF EXISTS `PARAMETERS`;
1659 /*!40101 SET @saved_cs_client = @@character_set_client */;
1660 /*!40101 SET character_set_client = utf8 */;
1661 CREATE TABLE `PARAMETERS` (
1662 `name` varchar(100) NOT NULL,
1663 `value` varchar(128) NOT NULL,
1664 `category` varchar(24) DEFAULT NULL,
1665 `memo` varchar(128) DEFAULT NULL,
1666 PRIMARY KEY (`name`)
1667 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1668 /*!40101 SET character_set_client = @saved_cs_client */;
1671 -- Table structure for table `PE_INV`
1674 DROP TABLE IF EXISTS `PE_INV`;
1675 /*!40101 SET @saved_cs_client = @@character_set_client */;
1676 /*!40101 SET character_set_client = utf8 */;
1677 CREATE TABLE `PE_INV` (
1678 `EQUIP_ID` int(11) DEFAULT NULL,
1679 `EQUIP_TYPE` varchar(20) DEFAULT NULL,
1680 `PTNII_EQUIP_NAME` varchar(20) DEFAULT NULL,
1681 `IP_ADDR` varchar(15) DEFAULT NULL,
1682 `ROUTER_PROV_STATUS` varchar(50) DEFAULT NULL,
1683 `REGION` varchar(16) DEFAULT NULL,
1684 `COUNTRY_ABBR` varchar(50) DEFAULT NULL,
1685 `EQUIP_NAME_CODE` varchar(50) DEFAULT NULL,
1686 `AS_NUMBER` varchar(5) DEFAULT NULL,
1687 `LOOPBACK1` varchar(15) DEFAULT NULL,
1688 `LOOPBACK2` varchar(15) DEFAULT NULL,
1689 `LOOPBACK3` varchar(15) DEFAULT NULL,
1690 `LOOPBACK40` varchar(15) DEFAULT NULL,
1691 `LOOPBACK65535` varchar(15) DEFAULT NULL,
1692 `INMS_LIST` varchar(20) DEFAULT NULL,
1693 `ENCRYPTED_ACCESS_FLAG` varchar(50) DEFAULT NULL,
1694 `SW_NAME` varchar(100) DEFAULT NULL,
1695 `NMIPADDR` varchar(15) DEFAULT NULL,
1696 `CREATE_DATE` datetime DEFAULT NULL,
1697 `MOD_DATE` datetime DEFAULT NULL,
1698 `FCN_CODE` varchar(50) DEFAULT NULL
1699 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1700 /*!40101 SET character_set_client = @saved_cs_client */;
1703 -- Table structure for table `PHYSICAL_LINK`
1706 DROP TABLE IF EXISTS `PHYSICAL_LINK`;
1707 /*!40101 SET @saved_cs_client = @@character_set_client */;
1708 /*!40101 SET character_set_client = utf8 */;
1709 CREATE TABLE `PHYSICAL_LINK` (
1710 `link_name` varchar(255) NOT NULL,
1711 `speed_value` varchar(64) DEFAULT NULL,
1712 `speed_units` varchar(64) DEFAULT NULL,
1713 `circuit_id` varchar(255) NOT NULL,
1714 `dual_mode` varchar(64) NOT NULL,
1715 PRIMARY KEY (`link_name`)
1716 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1717 /*!40101 SET character_set_client = @saved_cs_client */;
1720 -- Table structure for table `PHYSICAL_LINK_PINTERFACE`
1723 DROP TABLE IF EXISTS `PHYSICAL_LINK_PINTERFACE`;
1724 /*!40101 SET @saved_cs_client = @@character_set_client */;
1725 /*!40101 SET character_set_client = utf8 */;
1726 CREATE TABLE `PHYSICAL_LINK_PINTERFACE` (
1727 `link_name` varchar(255) NOT NULL,
1728 `hostname` varchar(255) NOT NULL,
1729 `port_name_ft` varchar(255) NOT NULL,
1730 PRIMARY KEY (`link_name`,`hostname`,`port_name_ft`)
1731 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1732 /*!40101 SET character_set_client = @saved_cs_client */;
1735 -- Table structure for table `PINTERFACE`
1738 DROP TABLE IF EXISTS `PINTERFACE`;
1739 /*!40101 SET @saved_cs_client = @@character_set_client */;
1740 /*!40101 SET character_set_client = utf8 */;
1741 CREATE TABLE `PINTERFACE` (
1742 `hostname` varchar(255) NOT NULL,
1743 `port_name_ft` varchar(255) NOT NULL,
1744 `interface_name` varchar(255) DEFAULT '',
1745 `physical_speed` varchar(255) DEFAULT '',
1746 `physical_units` varchar(255) DEFAULT '',
1747 `port_description` varchar(255) DEFAULT '',
1748 PRIMARY KEY (`hostname`,`port_name_ft`)
1749 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1750 /*!40101 SET character_set_client = @saved_cs_client */;
1753 -- Table structure for table `POLICY_UPDATE_NOTIFICATION`
1756 DROP TABLE IF EXISTS `POLICY_UPDATE_NOTIFICATION`;
1757 /*!40101 SET @saved_cs_client = @@character_set_client */;
1758 /*!40101 SET character_set_client = utf8 */;
1759 CREATE TABLE `POLICY_UPDATE_NOTIFICATION` (
1760 `policy_name` varchar(255) NOT NULL,
1761 `version_id` varchar(255) NOT NULL,
1762 `update_type` varchar(255) NOT NULL,
1763 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1764 PRIMARY KEY (`policy_name`,`version_id`)
1765 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1766 /*!40101 SET character_set_client = @saved_cs_client */;
1769 -- Table structure for table `PORTAL_USERS`
1772 DROP TABLE IF EXISTS `PORTAL_USERS`;
1773 /*!40101 SET @saved_cs_client = @@character_set_client */;
1774 /*!40101 SET character_set_client = utf8 */;
1775 CREATE TABLE `PORTAL_USERS` (
1776 `email` varchar(64) NOT NULL,
1777 `password` varbinary(255) NOT NULL,
1778 `privilege` char(1) NOT NULL,
1779 PRIMARY KEY (`email`)
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 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1820 `preload_data` longblob,
1822 ) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=latin1;
1823 /*!40101 SET character_set_client = @saved_cs_client */;
1826 -- Table structure for table `PRE_LOAD_VNF_NETWORK_DATA`
1829 DROP TABLE IF EXISTS `PRE_LOAD_VNF_NETWORK_DATA`;
1830 /*!40101 SET @saved_cs_client = @@character_set_client */;
1831 /*!40101 SET character_set_client = utf8 */;
1832 CREATE TABLE `PRE_LOAD_VNF_NETWORK_DATA` (
1833 `id` int(11) NOT NULL AUTO_INCREMENT,
1834 `svc_request_id` varchar(100) DEFAULT '',
1835 `svc_action` varchar(40) DEFAULT '',
1836 `status` varchar(10) NOT NULL DEFAULT 'pending',
1837 `filename` varchar(100) NOT NULL,
1838 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1839 `preload_data` longblob,
1841 ) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1;
1842 /*!40101 SET character_set_client = @saved_cs_client */;
1845 -- Table structure for table `PSERVER`
1848 DROP TABLE IF EXISTS `PSERVER`;
1849 /*!40101 SET @saved_cs_client = @@character_set_client */;
1850 /*!40101 SET character_set_client = utf8 */;
1851 CREATE TABLE `PSERVER` (
1852 `hostname` varchar(255) NOT NULL,
1853 `ptnii_equip_name` varchar(255) DEFAULT '',
1854 `number_of_cpus` varchar(255) DEFAULT '',
1855 `disk_in_gigabytes` varchar(255) DEFAULT '',
1856 `ram_in_megabytes` varchar(255) DEFAULT '',
1857 `equip_type` varchar(255) DEFAULT '',
1858 `equip_vendor` varchar(255) DEFAULT '',
1859 `equip_model` varchar(255) DEFAULT '',
1860 `fqdn` varchar(255) DEFAULT '',
1861 `pserver_selflink` varchar(255) DEFAULT '',
1862 `ipv4_oam_address` varchar(40) DEFAULT NULL,
1863 `serial_number` varchar(255) DEFAULT '',
1864 `pserver_id` varchar(255) DEFAULT '',
1865 `internet_topology` varchar(40) DEFAULT '',
1866 `aic_site_id` varchar(100) DEFAULT '',
1867 `in_maint` varchar(5) DEFAULT '',
1868 `pserver_name2` varchar(255) DEFAULT '',
1869 `purpose` varchar(255) DEFAULT '',
1870 PRIMARY KEY (`hostname`)
1871 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1872 /*!40101 SET character_set_client = @saved_cs_client */;
1875 -- Table structure for table `RANGE_RULE`
1878 DROP TABLE IF EXISTS `RANGE_RULE`;
1879 /*!40101 SET @saved_cs_client = @@character_set_client */;
1880 /*!40101 SET character_set_client = utf8 */;
1881 CREATE TABLE `RANGE_RULE` (
1882 `range_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1883 `range_name` varchar(50) NOT NULL,
1884 `service_model` varchar(50) NOT NULL,
1885 `end_point_position` varchar(50) NOT NULL,
1886 `equipment_level` varchar(50) NOT NULL,
1887 `min_value` int(11) NOT NULL,
1888 `max_value` int(11) NOT NULL,
1889 PRIMARY KEY (`range_rule_id`)
1890 ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
1891 /*!40101 SET character_set_client = @saved_cs_client */;
1894 -- Table structure for table `REQUEST_DETAILS`
1897 DROP TABLE IF EXISTS `REQUEST_DETAILS`;
1898 /*!40101 SET @saved_cs_client = @@character_set_client */;
1899 /*!40101 SET character_set_client = utf8 */;
1900 CREATE TABLE `REQUEST_DETAILS` (
1901 `request_id` varchar(255) NOT NULL,
1902 `controller_id` varchar(255) DEFAULT NULL,
1903 `status` varchar(255) DEFAULT NULL,
1904 `service_rate` varchar(255) DEFAULT NULL,
1905 `service_instance_id` varchar(255) DEFAULT NULL,
1906 `service_type` varchar(255) DEFAULT NULL,
1907 `global_customer_id` varchar(255) DEFAULT NULL,
1908 `notification_url` varchar(255) DEFAULT NULL,
1909 `domain_requests` varchar(255) DEFAULT NULL,
1910 PRIMARY KEY (`request_id`)
1911 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1912 /*!40101 SET character_set_client = @saved_cs_client */;
1915 -- Table structure for table `REQUEST_PROGRESS`
1918 DROP TABLE IF EXISTS `REQUEST_PROGRESS`;
1919 /*!40101 SET @saved_cs_client = @@character_set_client */;
1920 /*!40101 SET character_set_client = utf8 */;
1921 CREATE TABLE `REQUEST_PROGRESS` (
1922 `request_id` int(11) NOT NULL AUTO_INCREMENT,
1923 `request_type` varchar(20) DEFAULT NULL,
1924 `service_instance_id` varchar(80) NOT NULL,
1925 `request_instance_type` varchar(20) NOT NULL,
1926 `originating_service_instance_id` varchar(80) DEFAULT NULL,
1927 `originating_service_type` varchar(20) DEFAULT NULL,
1928 `overall_status` varchar(20) DEFAULT NULL,
1929 `status_date` varchar(80) DEFAULT NULL,
1930 `message` varchar(255) DEFAULT NULL,
1931 PRIMARY KEY (`request_id`)
1932 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1933 /*!40101 SET character_set_client = @saved_cs_client */;
1936 -- Table structure for table `REQUEST_PROGRESS_STATE`
1939 DROP TABLE IF EXISTS `REQUEST_PROGRESS_STATE`;
1940 /*!40101 SET @saved_cs_client = @@character_set_client */;
1941 /*!40101 SET character_set_client = utf8 */;
1942 CREATE TABLE `REQUEST_PROGRESS_STATE` (
1943 `request_progress_state_id` int(11) NOT NULL AUTO_INCREMENT,
1944 `request_id` int(11) DEFAULT NULL,
1945 `service_instance_id` varchar(80) NOT NULL,
1946 `request_instance_type` varchar(20) NOT NULL,
1947 `progress_state` varchar(30) DEFAULT NULL,
1948 `transaction_status` varchar(20) DEFAULT NULL,
1949 `status_date` varchar(80) DEFAULT NULL,
1950 `response_code` varchar(20) DEFAULT NULL,
1951 `message` varchar(255) DEFAULT NULL,
1952 PRIMARY KEY (`request_progress_state_id`)
1953 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1954 /*!40101 SET character_set_client = @saved_cs_client */;
1957 -- Table structure for table `RESOURCE`
1960 DROP TABLE IF EXISTS `RESOURCE`;
1961 /*!40101 SET @saved_cs_client = @@character_set_client */;
1962 /*!40101 SET character_set_client = utf8 */;
1963 CREATE TABLE `RESOURCE` (
1964 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1965 `asset_id` varchar(100) NOT NULL,
1966 `resource_name` varchar(50) NOT NULL,
1967 `resource_type` enum('Limit','Label','Range') NOT NULL,
1968 `lt_used` bigint(20) DEFAULT NULL,
1969 `ll_label` varchar(50) DEFAULT NULL,
1970 `ll_reference_count` smallint(6) DEFAULT NULL,
1971 `rr_used` varchar(4000) DEFAULT NULL,
1972 PRIMARY KEY (`resource_id`),
1973 UNIQUE KEY `resource_id` (`resource_id`),
1974 UNIQUE KEY `IX1_RESOURCE` (`asset_id`,`resource_name`)
1975 ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;
1976 /*!40101 SET character_set_client = @saved_cs_client */;
1979 -- Table structure for table `RESOURCE_LOAD`
1982 DROP TABLE IF EXISTS `RESOURCE_LOAD`;
1983 /*!40101 SET @saved_cs_client = @@character_set_client */;
1984 /*!40101 SET character_set_client = utf8 */;
1985 CREATE TABLE `RESOURCE_LOAD` (
1986 `resource_load_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1987 `resource_id` bigint(20) NOT NULL,
1988 `application_id` varchar(20) NOT NULL,
1989 `resource_load_time` datetime NOT NULL,
1990 `resource_expiration_time` datetime DEFAULT NULL,
1991 PRIMARY KEY (`resource_load_id`),
1992 UNIQUE KEY `resource_load_id` (`resource_load_id`),
1993 UNIQUE KEY `IX2_RESOURCE_LOAD` (`resource_id`,`application_id`),
1994 KEY `IX1_RESOURCE_LOAD` (`resource_id`)
1995 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1996 /*!40101 SET character_set_client = @saved_cs_client */;
1999 -- Table structure for table `RESOURCE_LOCK`
2002 DROP TABLE IF EXISTS `RESOURCE_LOCK`;
2003 /*!40101 SET @saved_cs_client = @@character_set_client */;
2004 /*!40101 SET character_set_client = utf8 */;
2005 CREATE TABLE `RESOURCE_LOCK` (
2006 `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2007 `resource_name` varchar(256) DEFAULT NULL,
2008 `lock_holder` varchar(100) NOT NULL,
2009 `lock_count` smallint(6) NOT NULL,
2010 `lock_time` datetime NOT NULL,
2011 `expiration_time` datetime NOT NULL,
2012 PRIMARY KEY (`resource_lock_id`),
2013 UNIQUE KEY `resource_lock_id` (`resource_lock_id`),
2014 UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`)
2015 ) ENGINE=InnoDB AUTO_INCREMENT=29681 DEFAULT CHARSET=latin1;
2016 /*!40101 SET character_set_client = @saved_cs_client */;
2019 -- Table structure for table `RESOURCE_RULE`
2022 DROP TABLE IF EXISTS `RESOURCE_RULE`;
2023 /*!40101 SET @saved_cs_client = @@character_set_client */;
2024 /*!40101 SET character_set_client = utf8 */;
2025 CREATE TABLE `RESOURCE_RULE` (
2026 `resource_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2027 `resource_name` varchar(50) NOT NULL,
2028 `service_model` varchar(50) NOT NULL,
2029 `end_point_position` varchar(50) NOT NULL,
2030 `service_expression` varchar(2000) NOT NULL,
2031 `equipment_level` varchar(50) NOT NULL,
2032 `equipment_expression` varchar(2000) NOT NULL,
2033 `allocation_expression` varchar(2000) NOT NULL,
2034 `soft_limit_expression` varchar(2000) NOT NULL,
2035 `hard_limit_expression` varchar(2000) NOT NULL,
2036 PRIMARY KEY (`resource_rule_id`),
2037 UNIQUE KEY `resource_rule_id` (`resource_rule_id`)
2038 ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
2039 /*!40101 SET character_set_client = @saved_cs_client */;
2042 -- Table structure for table `RESOURCE_THRESHOLD`
2045 DROP TABLE IF EXISTS `RESOURCE_THRESHOLD`;
2046 /*!40101 SET @saved_cs_client = @@character_set_client */;
2047 /*!40101 SET character_set_client = utf8 */;
2048 CREATE TABLE `RESOURCE_THRESHOLD` (
2049 `resource_threshold_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2050 `resource_rule_id` bigint(20) NOT NULL,
2051 `threshold_expression` varchar(2000) NOT NULL,
2052 `threshold_message` varchar(2000) NOT NULL,
2053 PRIMARY KEY (`resource_threshold_id`)
2054 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2055 /*!40101 SET character_set_client = @saved_cs_client */;
2058 -- Table structure for table `ROUTER_MASTER`
2061 DROP TABLE IF EXISTS `ROUTER_MASTER`;
2062 /*!40101 SET @saved_cs_client = @@character_set_client */;
2063 /*!40101 SET character_set_client = utf8 */;
2064 CREATE TABLE `ROUTER_MASTER` (
2065 `crs_name` varchar(20) NOT NULL,
2066 `loopback_ip` varchar(20) NOT NULL,
2067 PRIMARY KEY (`crs_name`)
2068 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2069 /*!40101 SET character_set_client = @saved_cs_client */;
2072 -- Table structure for table `ROUTING_CHARACTERISTIC_MAPPING`
2075 DROP TABLE IF EXISTS `ROUTING_CHARACTERISTIC_MAPPING`;
2076 /*!40101 SET @saved_cs_client = @@character_set_client */;
2077 /*!40101 SET character_set_client = utf8 */;
2078 CREATE TABLE `ROUTING_CHARACTERISTIC_MAPPING` (
2079 `network_role` varchar(255) NOT NULL,
2080 `vrf_name` varchar(255) NOT NULL,
2081 `routing_characteristic` varchar(255) NOT NULL,
2082 PRIMARY KEY (`network_role`,`vrf_name`)
2083 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2084 /*!40101 SET character_set_client = @saved_cs_client */;
2087 -- Table structure for table `SERVICE_HOMING`
2090 DROP TABLE IF EXISTS `SERVICE_HOMING`;
2091 /*!40101 SET @saved_cs_client = @@character_set_client */;
2092 /*!40101 SET character_set_client = utf8 */;
2093 CREATE TABLE `SERVICE_HOMING` (
2094 `service_type` varchar(100) NOT NULL,
2095 `lata` int(3) NOT NULL,
2096 `hubbing_city_type` varchar(40) NOT NULL,
2097 `latitude` float DEFAULT NULL,
2098 `longitude` float DEFAULT NULL,
2099 `primary_aic_site_name` varchar(100) NOT NULL,
2100 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2101 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2102 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2103 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2104 /*!40101 SET character_set_client = @saved_cs_client */;
2107 -- Table structure for table `SERVICE_HOMING_BACKUP`
2110 DROP TABLE IF EXISTS `SERVICE_HOMING_BACKUP`;
2111 /*!40101 SET @saved_cs_client = @@character_set_client */;
2112 /*!40101 SET character_set_client = utf8 */;
2113 CREATE TABLE `SERVICE_HOMING_BACKUP` (
2114 `service_type` varchar(100) NOT NULL,
2115 `lata` int(3) NOT NULL,
2116 `hubbing_city_type` varchar(40) NOT NULL,
2117 `latitude` float DEFAULT NULL,
2118 `longitude` float DEFAULT NULL,
2119 `primary_aic_site_name` varchar(100) NOT NULL,
2120 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2121 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2122 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2123 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2124 /*!40101 SET character_set_client = @saved_cs_client */;
2127 -- Table structure for table `SERVICE_INSTANCE_NAME_INDEX`
2130 DROP TABLE IF EXISTS `SERVICE_INSTANCE_NAME_INDEX`;
2131 /*!40101 SET @saved_cs_client = @@character_set_client */;
2132 /*!40101 SET character_set_client = utf8 */;
2133 CREATE TABLE `SERVICE_INSTANCE_NAME_INDEX` (
2134 `service_instance_name_prefix` varchar(255) NOT NULL,
2135 `index_number` int(11) NOT NULL,
2136 PRIMARY KEY (`service_instance_name_prefix`)
2137 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2138 /*!40101 SET character_set_client = @saved_cs_client */;
2141 -- Table structure for table `SERVICE_MANAGER_CREDENTIALS`
2144 DROP TABLE IF EXISTS `SERVICE_MANAGER_CREDENTIALS`;
2145 /*!40101 SET @saved_cs_client = @@character_set_client */;
2146 /*!40101 SET character_set_client = utf8 */;
2147 CREATE TABLE `SERVICE_MANAGER_CREDENTIALS` (
2148 `service_manager_username` varchar(255) NOT NULL,
2149 `service_manager_password` varbinary(255) NOT NULL,
2150 PRIMARY KEY (`service_manager_username`)
2151 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2152 /*!40101 SET character_set_client = @saved_cs_client */;
2155 -- Table structure for table `SERVICE_MODEL`
2158 DROP TABLE IF EXISTS `SERVICE_MODEL`;
2159 /*!40101 SET @saved_cs_client = @@character_set_client */;
2160 /*!40101 SET character_set_client = utf8 */;
2161 CREATE TABLE `SERVICE_MODEL` (
2162 `service_uuid` varchar(255) NOT NULL,
2163 `model_yaml` longblob,
2164 `invariant_uuid` varchar(255) DEFAULT NULL,
2165 `version` varchar(255) DEFAULT NULL,
2166 `name` varchar(255) DEFAULT NULL,
2167 `description` varchar(1024) DEFAULT NULL,
2168 `type` varchar(255) DEFAULT NULL,
2169 `category` varchar(255) DEFAULT NULL,
2170 `ecomp_naming` char(1) DEFAULT NULL,
2171 `service_instance_name_prefix` varchar(255) DEFAULT NULL,
2172 `filename` varchar(100) DEFAULT NULL,
2173 `naming_policy` varchar(255) DEFAULT NULL,
2174 PRIMARY KEY (`service_uuid`)
2175 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2176 /*!40101 SET character_set_client = @saved_cs_client */;
2179 -- Table structure for table `SERVICE_PROXY`
2182 DROP TABLE IF EXISTS `SERVICE_PROXY`;
2183 /*!40101 SET @saved_cs_client = @@character_set_client */;
2184 /*!40101 SET character_set_client = utf8 */;
2185 CREATE TABLE `SERVICE_PROXY` (
2186 `port_mirror_service_uuid` varchar(255) NOT NULL,
2187 `service_proxy_name` varchar(255) NOT NULL,
2188 `source_service_uuid` varchar(255) NOT NULL,
2189 `resources_vendor` varchar(255) DEFAULT NULL,
2190 `resource_vendor_release` varchar(255) DEFAULT NULL,
2191 `description` varchar(255) DEFAULT NULL,
2192 `category` varchar(255) DEFAULT NULL,
2193 `subcategory` varchar(255) DEFAULT NULL,
2194 `version` varchar(255) DEFAULT NULL,
2195 `role` varchar(255) NOT NULL,
2196 `uuid` varchar(255) DEFAULT NULL,
2197 `customization_uuid` varchar(255) DEFAULT NULL,
2198 `invariant_uuid` varchar(255) DEFAULT NULL,
2199 PRIMARY KEY (`port_mirror_service_uuid`,`service_proxy_name`),
2200 KEY `FK_SERVICE_PROXY_SOURCE_TO_SERVICE_MODE` (`source_service_uuid`),
2201 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
2202 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2203 /*!40101 SET character_set_client = @saved_cs_client */;
2206 -- Table structure for table `SERVICE_RESOURCE`
2209 DROP TABLE IF EXISTS `SERVICE_RESOURCE`;
2210 /*!40101 SET @saved_cs_client = @@character_set_client */;
2211 /*!40101 SET character_set_client = utf8 */;
2212 CREATE TABLE `SERVICE_RESOURCE` (
2213 `service_resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2214 `service_instance_id` varchar(80) NOT NULL,
2215 `service_status` enum('Active','Pending') NOT NULL,
2216 `service_change_number` smallint(6) NOT NULL,
2217 `resource_set_id` varchar(100) NOT NULL,
2218 `resource_union_id` varchar(100) NOT NULL,
2219 PRIMARY KEY (`service_instance_id`,`service_change_number`),
2220 UNIQUE KEY `service_resource_id` (`service_resource_id`),
2221 KEY `IX1_SERVICE_RESOURCE` (`service_instance_id`)
2222 ) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=latin1;
2223 /*!40101 SET character_set_client = @saved_cs_client */;
2226 -- Table structure for table `SERVICE_TYPE_MAPPING`
2229 DROP TABLE IF EXISTS `SERVICE_TYPE_MAPPING`;
2230 /*!40101 SET @saved_cs_client = @@character_set_client */;
2231 /*!40101 SET character_set_client = utf8 */;
2232 CREATE TABLE `SERVICE_TYPE_MAPPING` (
2233 `sdnc_service_type` varchar(128) NOT NULL,
2234 `ncs_service_type` varchar(128) NOT NULL,
2235 PRIMARY KEY (`sdnc_service_type`,`ncs_service_type`)
2236 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2237 /*!40101 SET character_set_client = @saved_cs_client */;
2240 -- Table structure for table `SUBNETPOOL_MAPPING`
2243 DROP TABLE IF EXISTS `SUBNETPOOL_MAPPING`;
2244 /*!40101 SET @saved_cs_client = @@character_set_client */;
2245 /*!40101 SET character_set_client = utf8 */;
2246 CREATE TABLE `SUBNETPOOL_MAPPING` (
2247 `aic_cloud_region` varchar(16) NOT NULL,
2248 `ntc` varchar(32) NOT NULL,
2249 `lcp` varchar(32) NOT NULL,
2250 `aic_region_id` varchar(255) NOT NULL,
2251 PRIMARY KEY (`aic_cloud_region`)
2252 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2253 /*!40101 SET character_set_client = @saved_cs_client */;
2256 -- Table structure for table `SUPPORTED_SEQUENCE_NUMBER`
2259 DROP TABLE IF EXISTS `SUPPORTED_SEQUENCE_NUMBER`;
2260 /*!40101 SET @saved_cs_client = @@character_set_client */;
2261 /*!40101 SET character_set_client = utf8 */;
2262 CREATE TABLE `SUPPORTED_SEQUENCE_NUMBER` (
2263 `resource_sequence_number` varchar(10) NOT NULL,
2264 `resource_type` varchar(10) NOT NULL,
2265 PRIMARY KEY (`resource_sequence_number`,`resource_type`)
2266 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2267 /*!40101 SET character_set_client = @saved_cs_client */;
2270 -- Table structure for table `SVC_LOGIC`
2273 DROP TABLE IF EXISTS `SVC_LOGIC`;
2274 /*!40101 SET @saved_cs_client = @@character_set_client */;
2275 /*!40101 SET character_set_client = utf8 */;
2276 CREATE TABLE `SVC_LOGIC` (
2277 `module` varchar(80) NOT NULL,
2278 `rpc` varchar(80) NOT NULL,
2279 `version` varchar(40) NOT NULL,
2280 `mode` varchar(5) NOT NULL,
2281 `active` varchar(1) NOT NULL,
2283 `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2284 `md5sum` varchar(128) DEFAULT NULL,
2285 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
2286 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2287 /*!40101 SET character_set_client = @saved_cs_client */;
2290 -- Table structure for table `TABLE_CLEANUP_CONFIGURATION`
2293 DROP TABLE IF EXISTS `TABLE_CLEANUP_CONFIGURATION`;
2294 /*!40101 SET @saved_cs_client = @@character_set_client */;
2295 /*!40101 SET character_set_client = utf8 */;
2296 CREATE TABLE `TABLE_CLEANUP_CONFIGURATION` (
2297 `table_name` varchar(255) NOT NULL COMMENT 'The name of the table the cleanup will be performed on',
2298 `days_old` int(11) NOT NULL COMMENT 'Records older than the current date minus DAYS_OLD will be deleted',
2299 `date_column` varchar(255) NOT NULL COMMENT 'The name of the column containing the date to be checked',
2300 `commit_interval` int(11) NOT NULL DEFAULT '2500' COMMENT 'The maximum number of rows a commit may contain',
2301 `query_clause` varchar(1000) DEFAULT NULL COMMENT 'An optional additional query clause to further restrict deletion criteria',
2302 `child_table_name` varchar(255) DEFAULT NULL,
2303 `child_table_pk` varchar(255) DEFAULT NULL,
2304 PRIMARY KEY (`table_name`)
2305 ) 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.';
2306 /*!40101 SET character_set_client = @saved_cs_client */;
2309 -- Table structure for table `TASK_TEMPLATE`
2312 DROP TABLE IF EXISTS `TASK_TEMPLATE`;
2313 /*!40101 SET @saved_cs_client = @@character_set_client */;
2314 /*!40101 SET character_set_client = utf8 */;
2315 CREATE TABLE `TASK_TEMPLATE` (
2316 `task_template_id` int(11) NOT NULL AUTO_INCREMENT,
2317 `request_type` varchar(20) DEFAULT NULL,
2318 `task_name` varchar(30) NOT NULL,
2319 `task_category` varchar(50) NOT NULL,
2320 `ecomp_task` varchar(50) NOT NULL,
2321 `initial_load` varchar(1) NOT NULL,
2322 `service` varchar(20) DEFAULT NULL,
2323 PRIMARY KEY (`task_template_id`)
2324 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2325 /*!40101 SET character_set_client = @saved_cs_client */;
2328 -- Table structure for table `TENANT`
2331 DROP TABLE IF EXISTS `TENANT`;
2332 /*!40101 SET @saved_cs_client = @@character_set_client */;
2333 /*!40101 SET character_set_client = utf8 */;
2334 CREATE TABLE `TENANT` (
2335 `tenant_id` varchar(255) NOT NULL,
2336 `tenant_name` varchar(255) NOT NULL,
2337 `service_instance_id` varchar(255) NOT NULL,
2338 PRIMARY KEY (`tenant_id`,`tenant_name`)
2339 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2340 /*!40101 SET character_set_client = @saved_cs_client */;
2343 -- Table structure for table `TESTTBL`
2346 DROP TABLE IF EXISTS `TESTTBL`;
2347 /*!40101 SET @saved_cs_client = @@character_set_client */;
2348 /*!40101 SET character_set_client = utf8 */;
2349 CREATE TABLE `TESTTBL` (
2350 `pk` varchar(25) NOT NULL,
2351 `col1` varchar(25) DEFAULT NULL
2352 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2353 /*!40101 SET character_set_client = @saved_cs_client */;
2356 -- Table structure for table `THRESHOLD_NOTIFICATION`
2359 DROP TABLE IF EXISTS `THRESHOLD_NOTIFICATION`;
2360 /*!40101 SET @saved_cs_client = @@character_set_client */;
2361 /*!40101 SET character_set_client = utf8 */;
2362 CREATE TABLE `THRESHOLD_NOTIFICATION` (
2363 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2364 `threshold_expression` varchar(2000) DEFAULT NULL,
2365 `threshold_message` varchar(500) DEFAULT NULL,
2366 PRIMARY KEY (`resource_id`)
2367 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2368 /*!40101 SET character_set_client = @saved_cs_client */;
2371 -- Table structure for table `TMP_AIC_AVAIL_ZONE_POOL`
2374 DROP TABLE IF EXISTS `TMP_AIC_AVAIL_ZONE_POOL`;
2375 /*!40101 SET @saved_cs_client = @@character_set_client */;
2376 /*!40101 SET character_set_client = utf8 */;
2377 CREATE TABLE `TMP_AIC_AVAIL_ZONE_POOL` (
2378 `aic_site_id` varchar(100) NOT NULL,
2379 `status` varchar(40) NOT NULL,
2380 `availability_zone` varchar(100) NOT NULL,
2381 `token` int(4) NOT NULL,
2382 `vnf_id` varchar(80) DEFAULT NULL,
2383 `service_type` varchar(100) NOT NULL,
2384 `vnf_type` varchar(20) DEFAULT NULL,
2385 `hypervisor` varchar(10) DEFAULT NULL,
2386 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
2387 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2388 /*!40101 SET character_set_client = @saved_cs_client */;
2391 -- Table structure for table `TOPOLOGY_PARAMETER`
2394 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER`;
2395 /*!40101 SET @saved_cs_client = @@character_set_client */;
2396 /*!40101 SET character_set_client = utf8 */;
2397 CREATE TABLE `TOPOLOGY_PARAMETER` (
2398 `parameter_id` int(11) NOT NULL,
2399 `parameter_name` varchar(20) NOT NULL,
2400 `parameter_set` int(11) NOT NULL,
2401 `create_update_time` datetime NOT NULL,
2402 `create_update_user` varchar(40) NOT NULL,
2403 PRIMARY KEY (`parameter_id`)
2404 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2405 /*!40101 SET character_set_client = @saved_cs_client */;
2408 -- Table structure for table `TOPOLOGY_PARAMETER_ENTRIES`
2411 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_ENTRIES`;
2412 /*!40101 SET @saved_cs_client = @@character_set_client */;
2413 /*!40101 SET character_set_client = utf8 */;
2414 CREATE TABLE `TOPOLOGY_PARAMETER_ENTRIES` (
2415 `parameter_entry_id` int(11) NOT NULL,
2416 `parameter_name` varchar(255) NOT NULL,
2417 `parameter_value` varchar(64) NOT NULL,
2418 `create_update_time` datetime NOT NULL,
2419 `create_update_user` varchar(40) NOT NULL,
2420 PRIMARY KEY (`parameter_entry_id`)
2421 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2422 /*!40101 SET character_set_client = @saved_cs_client */;
2425 -- Table structure for table `TOPOLOGY_PARAMETER_TO_ENTRIES`
2428 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_TO_ENTRIES`;
2429 /*!40101 SET @saved_cs_client = @@character_set_client */;
2430 /*!40101 SET character_set_client = utf8 */;
2431 CREATE TABLE `TOPOLOGY_PARAMETER_TO_ENTRIES` (
2432 `parameter_id` int(11) DEFAULT NULL,
2433 `parameter_entry_id` int(11) DEFAULT NULL,
2434 `entry_order` int(11) DEFAULT NULL,
2435 `create_update_time` datetime DEFAULT NULL,
2436 `create_update_user` varchar(40) NOT NULL,
2437 KEY `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_id`),
2438 KEY `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_entry_id`),
2439 CONSTRAINT `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_id`) REFERENCES `TOPOLOGY_PARAMETER` (`parameter_id`),
2440 CONSTRAINT `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_entry_id`) REFERENCES `TOPOLOGY_PARAMETER_ENTRIES` (`parameter_entry_id`)
2441 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2442 /*!40101 SET character_set_client = @saved_cs_client */;
2445 -- Table structure for table `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE`
2448 DROP TABLE IF EXISTS `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE`;
2449 /*!40101 SET @saved_cs_client = @@character_set_client */;
2450 /*!40101 SET character_set_client = utf8 */;
2451 CREATE TABLE `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE` (
2452 `interface_name` varchar(255) NOT NULL,
2453 `interface_id` varchar(255) NOT NULL,
2454 `pnf_name` varchar(255) NOT NULL,
2455 `pnf_id` varchar(255) NOT NULL,
2456 `controller_id` varchar(255) DEFAULT NULL,
2457 `rate` varchar(255) DEFAULT NULL,
2458 `clli` varchar(255) DEFAULT NULL,
2459 `connection_point` varchar(255) DEFAULT NULL,
2460 PRIMARY KEY (`interface_name`)
2461 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2462 /*!40101 SET character_set_client = @saved_cs_client */;
2465 -- Table structure for table `TRANSACTION_LOG`
2468 DROP TABLE IF EXISTS `TRANSACTION_LOG`;
2469 /*!40101 SET @saved_cs_client = @@character_set_client */;
2470 /*!40101 SET character_set_client = utf8 */;
2471 CREATE TABLE `TRANSACTION_LOG` (
2472 `serial_key` int(10) NOT NULL AUTO_INCREMENT,
2473 `log_time` varchar(40) NOT NULL,
2474 `request_id` varchar(80) DEFAULT NULL,
2475 `svc_request_id` varchar(80) DEFAULT NULL,
2476 `x_ecomp_request_id` varchar(80) DEFAULT NULL,
2477 `graph_name` varchar(255) DEFAULT NULL,
2478 PRIMARY KEY (`serial_key`)
2479 ) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;
2480 /*!40101 SET character_set_client = @saved_cs_client */;
2484 -- Table structure for table `UPLOAD_CONFIG`
2487 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
2488 /*!40101 SET @saved_cs_client = @@character_set_client */;
2489 /*!40101 SET character_set_client = utf8 */;
2490 CREATE TABLE `UPLOAD_CONFIG` (
2491 `upload_config_id` int(11) NOT NULL AUTO_INCREMENT,
2492 `request_id` varchar(50) DEFAULT NULL,
2493 `originator_id` varchar(50) DEFAULT NULL,
2494 `service_description` varchar(100) DEFAULT NULL,
2495 `action` varchar(50) DEFAULT NULL,
2496 `upload_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
2497 `vnf_id` varchar(50) DEFAULT NULL,
2498 `vnf_name` varchar(50) DEFAULT NULL,
2499 `vm_name` varchar(50) DEFAULT NULL,
2500 `vnf_type` varchar(50) DEFAULT NULL,
2501 `vnfc_type` varchar(50) DEFAULT NULL,
2502 `host_ip_address` varchar(50) DEFAULT NULL,
2503 `config_indicator` varchar(25) DEFAULT NULL,
2504 `pending_delete` varchar(1) DEFAULT NULL,
2506 PRIMARY KEY (`upload_config_id`),
2507 UNIQUE KEY `upload_config_id` (`upload_config_id`)
2508 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2509 /*!40101 SET character_set_client = @saved_cs_client */;
2512 -- Table structure for table `USED_SEQUENCE_NUMBER`
2515 DROP TABLE IF EXISTS `USED_SEQUENCE_NUMBER`;
2516 /*!40101 SET @saved_cs_client = @@character_set_client */;
2517 /*!40101 SET character_set_client = utf8 */;
2518 CREATE TABLE `USED_SEQUENCE_NUMBER` (
2519 `resource_sequence_number` varchar(10) NOT NULL,
2520 `resource_type` varchar(10) NOT NULL,
2521 `zone_region_id` varchar(50) NOT NULL,
2522 PRIMARY KEY (`resource_sequence_number`,`resource_type`,`zone_region_id`)
2523 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2524 /*!40101 SET character_set_client = @saved_cs_client */;
2527 -- Table structure for table `USER_TRACE`
2530 DROP TABLE IF EXISTS `USER_TRACE`;
2531 /*!40101 SET @saved_cs_client = @@character_set_client */;
2532 /*!40101 SET character_set_client = utf8 */;
2533 CREATE TABLE `USER_TRACE` (
2534 `user_trace_seq` int(11) NOT NULL AUTO_INCREMENT,
2535 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2536 `identity` varchar(12) DEFAULT NULL,
2537 `action` varchar(128) DEFAULT NULL,
2538 `description` varchar(256) DEFAULT NULL,
2539 PRIMARY KEY (`user_trace_seq`)
2540 ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=latin1;
2541 /*!40101 SET character_set_client = @saved_cs_client */;
2544 -- Table structure for table `VENDOR_CODE`
2547 DROP TABLE IF EXISTS `VENDOR_CODE`;
2548 /*!40101 SET @saved_cs_client = @@character_set_client */;
2549 /*!40101 SET character_set_client = utf8 */;
2550 CREATE TABLE `VENDOR_CODE` (
2551 `vendor_code` varchar(1) NOT NULL,
2552 `vendor` varchar(45) NOT NULL DEFAULT '',
2553 PRIMARY KEY (`vendor_code`,`vendor`)
2554 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2555 /*!40101 SET character_set_client = @saved_cs_client */;
2558 -- Table structure for table `VFC_MODEL`
2561 DROP TABLE IF EXISTS `VFC_MODEL`;
2562 /*!40101 SET @saved_cs_client = @@character_set_client */;
2563 /*!40101 SET character_set_client = utf8 */;
2564 CREATE TABLE `VFC_MODEL` (
2565 `customization_uuid` varchar(255) NOT NULL,
2566 `model_yaml` longblob,
2567 `invariant_uuid` varchar(255) DEFAULT NULL,
2568 `uuid` varchar(255) DEFAULT NULL,
2569 `version` varchar(255) DEFAULT NULL,
2570 `naming_policy` varchar(255) DEFAULT NULL,
2571 `ecomp_generated_naming` char(1) DEFAULT NULL,
2572 `nfc_function` varchar(255) DEFAULT NULL,
2573 `nfc_naming_code` varchar(255) DEFAULT NULL,
2574 `vm_type` varchar(255) DEFAULT NULL,
2575 `vm_type_tag` varchar(255) DEFAULT NULL,
2576 `vm_image_name` varchar(255) DEFAULT NULL,
2577 `vm_flavor_name` varchar(255) DEFAULT NULL,
2578 `high_availability` varchar(255) DEFAULT NULL,
2579 `nfc_naming` varchar(255) DEFAULT NULL,
2580 `min_instances` int(11) DEFAULT NULL,
2581 `max_instances` int(11) DEFAULT NULL,
2582 PRIMARY KEY (`customization_uuid`)
2583 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2584 /*!40101 SET character_set_client = @saved_cs_client */;
2587 -- Table structure for table `VFC_TO_NETWORK_ROLE_MAPPING`
2590 DROP TABLE IF EXISTS `VFC_TO_NETWORK_ROLE_MAPPING`;
2591 /*!40101 SET @saved_cs_client = @@character_set_client */;
2592 /*!40101 SET character_set_client = utf8 */;
2593 CREATE TABLE `VFC_TO_NETWORK_ROLE_MAPPING` (
2594 `seq` int(11) NOT NULL AUTO_INCREMENT,
2595 `vfc_customization_uuid` varchar(255) NOT NULL,
2596 `network_role` varchar(255) NOT NULL,
2597 `vm_type` varchar(255) DEFAULT NULL,
2598 `network_role_tag` varchar(255) DEFAULT NULL,
2599 `ipv4_count` int(11) NOT NULL,
2600 `ipv6_count` int(11) NOT NULL,
2601 `ipv4_use_dhcp` char(1) DEFAULT NULL,
2602 `ipv6_use_dhcp` char(1) DEFAULT NULL,
2603 `ipv4_ip_version` char(1) DEFAULT NULL,
2604 `ipv6_ip_version` char(1) DEFAULT NULL,
2605 `extcp_subnetpool_id` varchar(512) DEFAULT NULL,
2606 `ipv4_floating_count` int(11) DEFAULT NULL,
2607 `ipv6_floating_count` int(11) DEFAULT NULL,
2608 `ipv4_address_plan_name` varchar(512) DEFAULT NULL,
2609 `ipv6_address_plan_name` varchar(512) DEFAULT NULL,
2610 `ipv4_vrf_name` varchar(512) DEFAULT NULL,
2611 `ipv6_vrf_name` varchar(512) DEFAULT NULL,
2612 `subnet_role` varchar(255) DEFAULT NULL,
2613 `subinterface_indicator` char(1) DEFAULT NULL,
2614 PRIMARY KEY (`seq`),
2615 KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`)
2616 ) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1;
2617 /*!40101 SET character_set_client = @saved_cs_client */;
2620 -- Table structure for table `VF_MODEL`
2623 DROP TABLE IF EXISTS `VF_MODEL`;
2624 /*!40101 SET @saved_cs_client = @@character_set_client */;
2625 /*!40101 SET character_set_client = utf8 */;
2626 CREATE TABLE `VF_MODEL` (
2627 `customization_uuid` varchar(255) NOT NULL,
2628 `model_yaml` longblob,
2629 `invariant_uuid` varchar(255) DEFAULT NULL,
2630 `uuid` varchar(255) DEFAULT NULL,
2631 `version` varchar(255) DEFAULT NULL,
2632 `name` varchar(255) DEFAULT NULL,
2633 `naming_policy` varchar(255) DEFAULT NULL,
2634 `ecomp_generated_naming` char(1) DEFAULT NULL,
2635 `avail_zone_max_count` int(11) DEFAULT NULL,
2636 `nf_function` varchar(255) DEFAULT NULL,
2637 `nf_code` varchar(255) DEFAULT NULL,
2638 `nf_type` varchar(255) DEFAULT NULL,
2639 `nf_role` varchar(255) DEFAULT NULL,
2640 `vendor` varchar(255) DEFAULT NULL,
2641 `vendor_version` varchar(255) DEFAULT NULL,
2642 PRIMARY KEY (`customization_uuid`)
2643 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2644 /*!40101 SET character_set_client = @saved_cs_client */;
2647 -- Table structure for table `VF_MODULE_MODEL`
2650 DROP TABLE IF EXISTS `VF_MODULE_MODEL`;
2651 /*!40101 SET @saved_cs_client = @@character_set_client */;
2652 /*!40101 SET character_set_client = utf8 */;
2653 CREATE TABLE `VF_MODULE_MODEL` (
2654 `customization_uuid` varchar(255) NOT NULL,
2655 `model_yaml` longblob,
2656 `invariant_uuid` varchar(255) DEFAULT NULL,
2657 `uuid` varchar(255) DEFAULT NULL,
2658 `version` varchar(255) DEFAULT NULL,
2659 `vf_module_type` varchar(255) DEFAULT NULL,
2660 `availability_zone_count` int(11) DEFAULT NULL,
2661 `ecomp_generated_vm_assignments` char(1) DEFAULT NULL,
2662 PRIMARY KEY (`customization_uuid`)
2663 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2664 /*!40101 SET character_set_client = @saved_cs_client */;
2667 -- Table structure for table `VF_MODULE_TO_VFC_MAPPING`
2670 DROP TABLE IF EXISTS `VF_MODULE_TO_VFC_MAPPING`;
2671 /*!40101 SET @saved_cs_client = @@character_set_client */;
2672 /*!40101 SET character_set_client = utf8 */;
2673 CREATE TABLE `VF_MODULE_TO_VFC_MAPPING` (
2674 `seq` int(11) NOT NULL AUTO_INCREMENT,
2675 `vf_module_customization_uuid` varchar(255) NOT NULL,
2676 `vfc_customization_uuid` varchar(255) NOT NULL,
2677 `vm_type` varchar(255) NOT NULL,
2678 `vm_count` int(11) NOT NULL,
2679 PRIMARY KEY (`seq`),
2680 KEY `IX1_VF_MODULE_TO_VFC_MAPPING` (`vf_module_customization_uuid`)
2681 ) ENGINE=InnoDB AUTO_INCREMENT=1591 DEFAULT CHARSET=latin1;
2682 /*!40101 SET character_set_client = @saved_cs_client */;
2685 -- Table structure for table `VF_TO_NETWORK_ROLE_MAPPING`
2688 DROP TABLE IF EXISTS `VF_TO_NETWORK_ROLE_MAPPING`;
2689 /*!40101 SET @saved_cs_client = @@character_set_client */;
2690 /*!40101 SET character_set_client = utf8 */;
2691 CREATE TABLE `VF_TO_NETWORK_ROLE_MAPPING` (
2692 `seq` int(11) NOT NULL AUTO_INCREMENT,
2693 `vf_customization_uuid` varchar(255) NOT NULL,
2694 `network_role` varchar(255) NOT NULL,
2695 PRIMARY KEY (`seq`),
2696 KEY `IX1_VF_TO_NETWORK_ROLE_MAPPING` (`vf_customization_uuid`)
2697 ) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=latin1;
2698 /*!40101 SET character_set_client = @saved_cs_client */;
2701 -- Table structure for table `VIPR_CONFIGURATION`
2704 DROP TABLE IF EXISTS `VIPR_CONFIGURATION`;
2705 /*!40101 SET @saved_cs_client = @@character_set_client */;
2706 /*!40101 SET character_set_client = utf8 */;
2707 CREATE TABLE `VIPR_CONFIGURATION` (
2708 `seq` int(11) NOT NULL AUTO_INCREMENT,
2709 `serial_number` varchar(255) DEFAULT NULL,
2710 `vnf_id` varchar(255) DEFAULT NULL,
2711 `vnf_name` varchar(255) DEFAULT NULL,
2712 `ecomp_service_instance_id` varchar(255) DEFAULT NULL,
2713 `vm_name` varchar(255) DEFAULT NULL,
2714 `cloud_region_id` varchar(255) DEFAULT NULL,
2715 `cloud_owner` varchar(255) DEFAULT NULL,
2717 ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
2718 /*!40101 SET character_set_client = @saved_cs_client */;
2721 -- Table structure for table `VIPR_SZ_MANAGER_KEY`
2724 DROP TABLE IF EXISTS `VIPR_SZ_MANAGER_KEY`;
2725 /*!40101 SET @saved_cs_client = @@character_set_client */;
2726 /*!40101 SET character_set_client = utf8 */;
2727 CREATE TABLE `VIPR_SZ_MANAGER_KEY` (
2728 `vipr_sz_manager_ip_addr` varchar(40) NOT NULL,
2729 `vipr_sz_manager_state` varchar(10) DEFAULT NULL,
2730 `vipr_sz_manager_api_key` varchar(255) DEFAULT NULL,
2731 PRIMARY KEY (`vipr_sz_manager_ip_addr`)
2732 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2733 /*!40101 SET character_set_client = @saved_cs_client */;
2736 -- Table structure for table `VLAN_ID_POOL`
2739 DROP TABLE IF EXISTS `VLAN_ID_POOL`;
2740 /*!40101 SET @saved_cs_client = @@character_set_client */;
2741 /*!40101 SET character_set_client = utf8 */;
2742 CREATE TABLE `VLAN_ID_POOL` (
2743 `aic_site_id` varchar(100) NOT NULL,
2744 `purpose` varchar(40) NOT NULL,
2745 `status` varchar(40) NOT NULL,
2746 `vlan_id` int(4) NOT NULL,
2747 `svc_instance_id` varchar(80) DEFAULT NULL,
2748 `availability_zone` varchar(100) DEFAULT NULL,
2749 `vplspe_name` varchar(80) DEFAULT NULL,
2750 PRIMARY KEY (`vlan_id`,`aic_site_id`,`purpose`)
2751 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2752 /*!40101 SET character_set_client = @saved_cs_client */;
2755 -- Table structure for table `VLAN_L3INTERFACE_IPV4_ADDRESS`
2758 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV4_ADDRESS`;
2759 /*!40101 SET @saved_cs_client = @@character_set_client */;
2760 /*!40101 SET character_set_client = utf8 */;
2761 CREATE TABLE `VLAN_L3INTERFACE_IPV4_ADDRESS` (
2762 `vnf_id` varchar(80) NOT NULL,
2763 `interface_name` varchar(255) NOT NULL,
2764 `vlan_interface` varchar(255) NOT NULL,
2765 `l3_interface_ipv4_address` varchar(64) NOT NULL,
2766 `l3_interface_ipv4_prefix_length` varchar(45) DEFAULT NULL,
2767 `vlan_id_inner` varchar(45) DEFAULT NULL,
2768 `vlan_id_outer` varchar(45) DEFAULT NULL,
2769 `is_floating` varchar(1) DEFAULT NULL,
2770 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv4_address`),
2771 KEY `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`),
2772 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
2773 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2774 /*!40101 SET character_set_client = @saved_cs_client */;
2777 -- Table structure for table `VLAN_L3INTERFACE_IPV6_ADDRESS`
2780 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV6_ADDRESS`;
2781 /*!40101 SET @saved_cs_client = @@character_set_client */;
2782 /*!40101 SET character_set_client = utf8 */;
2783 CREATE TABLE `VLAN_L3INTERFACE_IPV6_ADDRESS` (
2784 `vnf_id` varchar(80) NOT NULL,
2785 `interface_name` varchar(255) NOT NULL,
2786 `vlan_interface` varchar(255) NOT NULL,
2787 `l3_interface_ipv6_address` varchar(64) NOT NULL,
2788 `l3_interface_ipv6_prefix_length` varchar(45) DEFAULT NULL,
2789 `vlan_id_inner` varchar(45) DEFAULT NULL,
2790 `vlan_id_outer` varchar(45) DEFAULT NULL,
2791 `is_floating` varchar(1) DEFAULT NULL,
2792 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv6_address`),
2793 KEY `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`,`vlan_interface`),
2794 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
2795 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2796 /*!40101 SET character_set_client = @saved_cs_client */;
2799 -- Table structure for table `VLAN_PLAN_ID`
2802 DROP TABLE IF EXISTS `VLAN_PLAN_ID`;
2803 /*!40101 SET @saved_cs_client = @@character_set_client */;
2804 /*!40101 SET character_set_client = utf8 */;
2805 CREATE TABLE `VLAN_PLAN_ID` (
2806 `plan_type` varchar(40) NOT NULL,
2807 `purpose` varchar(40) NOT NULL,
2808 `vlan_plan_id_count` int(4) NOT NULL,
2809 PRIMARY KEY (`vlan_plan_id_count`,`plan_type`,`purpose`)
2810 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2811 /*!40101 SET character_set_client = @saved_cs_client */;
2814 -- Table structure for table `VLAN_POOL`
2817 DROP TABLE IF EXISTS `VLAN_POOL`;
2818 /*!40101 SET @saved_cs_client = @@character_set_client */;
2819 /*!40101 SET character_set_client = utf8 */;
2820 CREATE TABLE `VLAN_POOL` (
2821 `aic_site_id` varchar(100) NOT NULL,
2822 `availability_zone` varchar(100) NOT NULL,
2823 `vlan_plan_id` varchar(100) NOT NULL,
2824 `plan_type` varchar(40) NOT NULL,
2825 `purpose` varchar(40) NOT NULL,
2826 `vlan_id` int(4) NOT NULL,
2827 `status` varchar(40) NOT NULL,
2828 `reserved_id` varchar(80) DEFAULT NULL,
2829 PRIMARY KEY (`aic_site_id`,`availability_zone`,`vlan_plan_id`,`plan_type`,`purpose`,`vlan_id`)
2830 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2831 /*!40101 SET character_set_client = @saved_cs_client */;
2834 -- Table structure for table `VLAN_RANGES`
2837 DROP TABLE IF EXISTS `VLAN_RANGES`;
2838 /*!40101 SET @saved_cs_client = @@character_set_client */;
2839 /*!40101 SET character_set_client = utf8 */;
2840 CREATE TABLE `VLAN_RANGES` (
2841 `vlan_plan_id` varchar(100) NOT NULL,
2842 `plan_type` varchar(40) NOT NULL,
2843 `purpose` varchar(40) NOT NULL,
2844 `range_start` int(4) NOT NULL,
2845 `range_end` int(4) NOT NULL,
2846 `generated` char(1) DEFAULT NULL,
2847 PRIMARY KEY (`vlan_plan_id`,`plan_type`,`purpose`,`range_start`,`range_end`)
2848 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2849 /*!40101 SET character_set_client = @saved_cs_client */;
2852 -- Table structure for table `VM_NAME_INDEX`
2855 DROP TABLE IF EXISTS `VM_NAME_INDEX`;
2856 /*!40101 SET @saved_cs_client = @@character_set_client */;
2857 /*!40101 SET character_set_client = utf8 */;
2858 CREATE TABLE `VM_NAME_INDEX` (
2859 `vm_name_prefix` varchar(255) NOT NULL,
2860 `index_number` int(11) NOT NULL,
2861 PRIMARY KEY (`vm_name_prefix`)
2862 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2863 /*!40101 SET character_set_client = @saved_cs_client */;
2866 -- Table structure for table `VM_NETWORKS`
2869 DROP TABLE IF EXISTS `VM_NETWORKS`;
2870 /*!40101 SET @saved_cs_client = @@character_set_client */;
2871 /*!40101 SET character_set_client = utf8 */;
2872 CREATE TABLE `VM_NETWORKS` (
2873 `vnf_type` varchar(200) NOT NULL,
2874 `vm_type` varchar(45) NOT NULL,
2875 `network_role` varchar(45) NOT NULL,
2876 `assign_ips` tinyint(1) NOT NULL,
2877 `assign_macs` tinyint(1) NOT NULL,
2878 `assign_floating_ip` tinyint(1) NOT NULL,
2879 `ip_count` int(11) DEFAULT NULL,
2880 PRIMARY KEY (`vnf_type`,`vm_type`,`network_role`)
2881 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2882 /*!40101 SET character_set_client = @saved_cs_client */;
2885 -- Table structure for table `VM_PROFILE`
2888 DROP TABLE IF EXISTS `VM_PROFILE`;
2889 /*!40101 SET @saved_cs_client = @@character_set_client */;
2890 /*!40101 SET character_set_client = utf8 */;
2891 CREATE TABLE `VM_PROFILE` (
2892 `vnf_type` varchar(200) NOT NULL,
2893 `vm_type` varchar(45) NOT NULL,
2894 `vm_count` int(11) NOT NULL,
2895 PRIMARY KEY (`vnf_type`,`vm_type`)
2896 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2897 /*!40101 SET character_set_client = @saved_cs_client */;
2900 -- Table structure for table `VNF`
2903 DROP TABLE IF EXISTS `VNF`;
2904 /*!40101 SET @saved_cs_client = @@character_set_client */;
2905 /*!40101 SET character_set_client = utf8 */;
2906 CREATE TABLE `VNF` (
2907 `vnf_id` varchar(80) NOT NULL,
2908 `vnf_name` varchar(80) NOT NULL,
2909 `vnf_type` varchar(10) NOT NULL,
2910 `orchestration_status` varchar(20) DEFAULT NULL,
2911 `heat_stack_id` varchar(80) DEFAULT NULL,
2912 `mso_catalog_key` varchar(80) DEFAULT NULL,
2913 `availability_zone` varchar(80) DEFAULT NULL,
2914 `aic_site_id` varchar(80) DEFAULT NULL,
2915 `oam_ipv4_address` varchar(20) DEFAULT NULL,
2916 `vnf_name2` varchar(80) DEFAULT NULL,
2917 `vpe_id` varchar(80) NOT NULL,
2918 `ipv4_loopback0_address` varchar(80) DEFAULT NULL,
2919 `license_key` varchar(256) DEFAULT NULL,
2920 `entitlement_resource_uuid` varchar(256) DEFAULT NULL,
2921 PRIMARY KEY (`vnf_id`)
2922 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2923 /*!40101 SET character_set_client = @saved_cs_client */;
2926 -- Table structure for table `VNFC_DG_MAPPING`
2929 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
2930 /*!40101 SET @saved_cs_client = @@character_set_client */;
2931 /*!40101 SET character_set_client = utf8 */;
2932 CREATE TABLE `VNFC_DG_MAPPING` (
2933 `vnfc_dg_mapping_id` int(11) NOT NULL AUTO_INCREMENT,
2934 `action` varchar(50) DEFAULT NULL,
2935 `api_version` varchar(10) DEFAULT NULL,
2936 `vnf_type` varchar(50) DEFAULT NULL,
2937 `vnfc_type` varchar(50) DEFAULT NULL,
2938 `dg_name` varchar(50) NOT NULL,
2939 `dg_version` varchar(50) DEFAULT NULL,
2940 `dg_module` varchar(50) NOT NULL,
2941 PRIMARY KEY (`vnfc_dg_mapping_id`),
2942 UNIQUE KEY `input_constraint` (`action`,`api_version`,`vnf_type`,`vnfc_type`)
2943 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2944 /*!40101 SET character_set_client = @saved_cs_client */;
2947 -- Table structure for table `VNFC_REFERENCE`
2950 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
2951 /*!40101 SET @saved_cs_client = @@character_set_client */;
2952 /*!40101 SET character_set_client = utf8 */;
2953 CREATE TABLE `VNFC_REFERENCE` (
2954 `vnfc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
2955 `action` varchar(50) NOT NULL,
2956 `vnf_type` varchar(50) NOT NULL,
2957 `vm_instance` int(11) NOT NULL,
2958 `vnfc_instance` int(11) NOT NULL,
2959 `vnfc_type` varchar(50) NOT NULL,
2960 `vnfc_function_code` varchar(50) NOT NULL,
2961 `ipaddress_v4_oam_vip` varchar(50) DEFAULT NULL,
2962 `group_notation_type` varchar(50) DEFAULT NULL,
2963 `group_notation_value` varchar(50) DEFAULT NULL,
2964 PRIMARY KEY (`vnfc_reference_id`),
2965 UNIQUE KEY `vnfc_reference_id` (`vnfc_reference_id`)
2966 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2967 /*!40101 SET character_set_client = @saved_cs_client */;
2970 -- Table structure for table `VNF_IMAGE`
2973 DROP TABLE IF EXISTS `VNF_IMAGE`;
2974 /*!40101 SET @saved_cs_client = @@character_set_client */;
2975 /*!40101 SET character_set_client = utf8 */;
2976 CREATE TABLE `VNF_IMAGE` (
2977 `application_vendor` varchar(255) NOT NULL,
2978 `application_version` varchar(255) NOT NULL,
2979 `att_uuid` varchar(255) NOT NULL,
2980 `application` varchar(255) DEFAULT NULL,
2981 `selflink` varchar(255) DEFAULT NULL,
2982 PRIMARY KEY (`application_vendor`,`application_version`,`att_uuid`)
2983 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2984 /*!40101 SET character_set_client = @saved_cs_client */;
2987 -- Table structure for table `VNF_MODEL_LICENSES`
2990 DROP TABLE IF EXISTS `VNF_MODEL_LICENSES`;
2991 /*!40101 SET @saved_cs_client = @@character_set_client */;
2992 /*!40101 SET character_set_client = utf8 */;
2993 CREATE TABLE `VNF_MODEL_LICENSES` (
2994 `att_part_number` varchar(255) NOT NULL,
2995 `license_assignment_group` varchar(255) NOT NULL,
2996 `license_required` tinyint(1) DEFAULT NULL,
2997 `entitlement_assignment_group` varchar(255) DEFAULT NULL,
2998 `entitlement_required` tinyint(1) DEFAULT '0',
2999 `feature_group_uuid` varchar(255) DEFAULT NULL,
3000 PRIMARY KEY (`att_part_number`,`license_assignment_group`)
3001 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3002 /*!40101 SET character_set_client = @saved_cs_client */;
3005 -- Table structure for table `VNF_MODEL_LICENSE_FEATURES`
3008 DROP TABLE IF EXISTS `VNF_MODEL_LICENSE_FEATURES`;
3009 /*!40101 SET @saved_cs_client = @@character_set_client */;
3010 /*!40101 SET character_set_client = utf8 */;
3011 CREATE TABLE `VNF_MODEL_LICENSE_FEATURES` (
3012 `att_part_number` varchar(255) NOT NULL,
3013 `license_assignment_group` varchar(255) NOT NULL,
3014 `feature` varchar(255) NOT NULL,
3015 PRIMARY KEY (`att_part_number`,`license_assignment_group`,`feature`)
3016 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3017 /*!40101 SET character_set_client = @saved_cs_client */;
3020 -- Table structure for table `VNF_NAME_INDEX`
3023 DROP TABLE IF EXISTS `VNF_NAME_INDEX`;
3024 /*!40101 SET @saved_cs_client = @@character_set_client */;
3025 /*!40101 SET character_set_client = utf8 */;
3026 CREATE TABLE `VNF_NAME_INDEX` (
3027 `vnf_name_prefix` varchar(255) NOT NULL,
3028 `index_number` int(11) NOT NULL,
3029 PRIMARY KEY (`vnf_name_prefix`)
3030 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3031 /*!40101 SET character_set_client = @saved_cs_client */;
3034 -- Table structure for table `VNF_NETWORKS`
3037 DROP TABLE IF EXISTS `VNF_NETWORKS`;
3038 /*!40101 SET @saved_cs_client = @@character_set_client */;
3039 /*!40101 SET character_set_client = utf8 */;
3040 CREATE TABLE `VNF_NETWORKS` (
3041 `vnf_type` varchar(200) NOT NULL,
3042 `network_role` varchar(45) NOT NULL,
3043 PRIMARY KEY (`vnf_type`,`network_role`)
3044 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3045 /*!40101 SET character_set_client = @saved_cs_client */;
3048 -- Table structure for table `VNF_NETWORK_CONNECTION`
3051 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION`;
3052 /*!40101 SET @saved_cs_client = @@character_set_client */;
3053 /*!40101 SET character_set_client = utf8 */;
3054 CREATE TABLE `VNF_NETWORK_CONNECTION` (
3055 `connection_uuid` varchar(80) NOT NULL,
3056 `vnf_id` varchar(80) NOT NULL,
3057 `connection_id` varchar(80) DEFAULT NULL,
3058 `connection_type` varchar(20) DEFAULT NULL,
3059 `neutron_network_id` varchar(80) DEFAULT NULL,
3060 `neutron_network_name` varchar(80) DEFAULT NULL,
3061 `orchestration_status` varchar(20) DEFAULT NULL,
3062 `switch_id` varchar(40) DEFAULT NULL,
3063 `heat_stack_id` varchar(80) DEFAULT NULL,
3064 `mso_catalog_key` varchar(80) DEFAULT NULL,
3065 `provider_network` varchar(80) DEFAULT NULL,
3066 `port_group_id` varchar(80) DEFAULT NULL,
3067 `port_group_name` varchar(80) DEFAULT NULL,
3068 PRIMARY KEY (`connection_uuid`)
3069 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3070 /*!40101 SET character_set_client = @saved_cs_client */;
3073 -- Table structure for table `VNF_NETWORK_CONNECTION_VLAN`
3076 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION_VLAN`;
3077 /*!40101 SET @saved_cs_client = @@character_set_client */;
3078 /*!40101 SET character_set_client = utf8 */;
3079 CREATE TABLE `VNF_NETWORK_CONNECTION_VLAN` (
3080 `vlan_uuid` varchar(80) NOT NULL,
3081 `vlan_id` int(4) NOT NULL,
3082 `vlan_type` varchar(5) NOT NULL,
3083 `connection_uuid` varchar(80) DEFAULT NULL,
3084 PRIMARY KEY (`vlan_uuid`)
3085 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3086 /*!40101 SET character_set_client = @saved_cs_client */;
3089 -- Table structure for table `VNF_PROFILE`
3092 DROP TABLE IF EXISTS `VNF_PROFILE`;
3093 /*!40101 SET @saved_cs_client = @@character_set_client */;
3094 /*!40101 SET character_set_client = utf8 */;
3095 CREATE TABLE `VNF_PROFILE` (
3096 `vnf_type` varchar(200) NOT NULL,
3097 `availability_zone_count` int(11) NOT NULL,
3098 `equipment_role` varchar(80) NOT NULL,
3099 PRIMARY KEY (`vnf_type`)
3100 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3101 /*!40101 SET character_set_client = @saved_cs_client */;
3104 -- Table structure for table `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`
3107 DROP TABLE IF EXISTS `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`;
3108 /*!40101 SET @saved_cs_client = @@character_set_client */;
3109 /*!40101 SET character_set_client = utf8 */;
3110 CREATE TABLE `VNF_SERVICE_TO_NETWORK_ROLE_FILTER` (
3111 `vnf_service_type` varchar(60) NOT NULL,
3112 `network_role_filter` varchar(60) NOT NULL,
3113 PRIMARY KEY (`vnf_service_type`,`network_role_filter`)
3114 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3115 /*!40101 SET character_set_client = @saved_cs_client */;
3118 -- Table structure for table `VPE_LOCK`
3121 DROP TABLE IF EXISTS `VPE_LOCK`;
3122 /*!40101 SET @saved_cs_client = @@character_set_client */;
3123 /*!40101 SET character_set_client = utf8 */;
3124 CREATE TABLE `VPE_LOCK` (
3125 `vpe_name` varchar(20) NOT NULL,
3126 `vpn_lock` varchar(20) NOT NULL,
3127 PRIMARY KEY (`vpe_name`)
3128 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3129 /*!40101 SET character_set_client = @saved_cs_client */;
3132 -- Table structure for table `VPE_MAC_ADDRESS_POOL`
3135 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_POOL`;
3136 /*!40101 SET @saved_cs_client = @@character_set_client */;
3137 /*!40101 SET character_set_client = utf8 */;
3138 CREATE TABLE `VPE_MAC_ADDRESS_POOL` (
3139 `id` int(11) NOT NULL,
3140 `mac_address` varchar(50) NOT NULL,
3141 `sw_name` varchar(30) NOT NULL,
3143 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3144 /*!40101 SET character_set_client = @saved_cs_client */;
3147 -- Table structure for table `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`
3150 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`;
3151 /*!40101 SET @saved_cs_client = @@character_set_client */;
3152 /*!40101 SET character_set_client = utf8 */;
3153 CREATE TABLE `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING` (
3154 `id` int(11) NOT NULL,
3155 `hostname` varchar(50) NOT NULL,
3156 `assigned_user` varchar(25) NOT NULL,
3157 `assigned_date` date DEFAULT NULL,
3159 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3160 /*!40101 SET character_set_client = @saved_cs_client */;
3163 -- Table structure for table `VPE_POOL`
3166 DROP TABLE IF EXISTS `VPE_POOL`;
3167 /*!40101 SET @saved_cs_client = @@character_set_client */;
3168 /*!40101 SET character_set_client = utf8 */;
3169 CREATE TABLE `VPE_POOL` (
3170 `vpe_name` varchar(20) NOT NULL,
3171 `ipv4_oam_address` varchar(20) NOT NULL,
3172 `loopback0_ipv4_address` varchar(20) NOT NULL,
3173 `provisioning_status` varchar(10) NOT NULL,
3174 `aic_site_id` varchar(100) NOT NULL,
3175 `availability_zone` varchar(100) NOT NULL,
3176 `vlan_id_outer` varchar(20) NOT NULL,
3177 `vendor` varchar(20) NOT NULL,
3178 `physical_intf_name` varchar(40) NOT NULL,
3179 `physical_intf_speed` varchar(20) NOT NULL,
3180 `physical_intf_units` varchar(20) NOT NULL,
3181 `vpe_uuid` varchar(80) DEFAULT NULL,
3182 `vpe_id` varchar(80) NOT NULL,
3183 `image_filename` varchar(100) DEFAULT NULL,
3184 `as_number` varchar(20) NOT NULL,
3185 `loopback5000` varchar(16) DEFAULT NULL,
3186 `loopback10` varchar(16) DEFAULT NULL,
3187 `aic_version` varchar(50) DEFAULT NULL,
3188 `vpe_capacity` int(11) NOT NULL,
3189 PRIMARY KEY (`aic_site_id`,`vpe_name`,`availability_zone`)
3190 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3191 /*!40101 SET character_set_client = @saved_cs_client */;
3194 -- Table structure for table `VPLSPE_POOL`
3197 DROP TABLE IF EXISTS `VPLSPE_POOL`;
3198 /*!40101 SET @saved_cs_client = @@character_set_client */;
3199 /*!40101 SET character_set_client = utf8 */;
3200 CREATE TABLE `VPLSPE_POOL` (
3201 `vplspe_name` varchar(20) NOT NULL,
3202 `aic_site_id` varchar(100) NOT NULL,
3203 `availability_zone` varchar(100) NOT NULL,
3204 `physical_intf_name` varchar(40) NOT NULL,
3205 `physical_intf_speed` varchar(20) NOT NULL,
3206 `physical_intf_units` varchar(20) NOT NULL,
3207 `loopback0_ipv4_address` varchar(20) NOT NULL,
3208 `vlan_id_outer` varchar(20) NOT NULL,
3209 `vplspe_uuid` varchar(80) DEFAULT NULL,
3210 `image_filename` varchar(100) DEFAULT NULL,
3211 `provisioning_status` varchar(10) DEFAULT NULL,
3212 `vendor` varchar(20) DEFAULT NULL,
3213 PRIMARY KEY (`vplspe_name`,`aic_site_id`,`availability_zone`,`physical_intf_name`)
3214 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3215 /*!40101 SET character_set_client = @saved_cs_client */;
3218 -- Table structure for table `VPN_BINDINGS`
3221 DROP TABLE IF EXISTS `VPN_BINDINGS`;
3222 /*!40101 SET @saved_cs_client = @@character_set_client */;
3223 /*!40101 SET character_set_client = utf8 */;
3224 CREATE TABLE `VPN_BINDINGS` (
3225 `network_customization_uuid` varchar(255) NOT NULL,
3226 `binding_uuid` varchar(255) NOT NULL,
3227 PRIMARY KEY (`network_customization_uuid`,`binding_uuid`)
3228 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3229 /*!40101 SET character_set_client = @saved_cs_client */;
3232 -- Table structure for table `VRR_FUNCTION_CODE_VMTYPE_MAPPING`
3235 DROP TABLE IF EXISTS `VRR_FUNCTION_CODE_VMTYPE_MAPPING`;
3236 /*!40101 SET @saved_cs_client = @@character_set_client */;
3237 /*!40101 SET character_set_client = utf8 */;
3238 CREATE TABLE `VRR_FUNCTION_CODE_VMTYPE_MAPPING` (
3239 `ptnii_function_code` varchar(128) NOT NULL,
3240 `vm_type` varchar(128) NOT NULL,
3241 PRIMARY KEY (`ptnii_function_code`,`vm_type`)
3242 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3243 /*!40101 SET character_set_client = @saved_cs_client */;
3246 -- Table structure for table `VSERVER`
3249 DROP TABLE IF EXISTS `VSERVER`;
3250 /*!40101 SET @saved_cs_client = @@character_set_client */;
3251 /*!40101 SET character_set_client = utf8 */;
3252 CREATE TABLE `VSERVER` (
3253 `tenant_id` varchar(40) NOT NULL,
3254 `vserver_id` varchar(40) NOT NULL,
3255 `aic_site_id` varchar(100) NOT NULL,
3256 `vendor` varchar(20) NOT NULL,
3257 `image_name` varchar(100) NOT NULL,
3258 `vnf_type` varchar(10) NOT NULL,
3259 `vnf_id` varchar(80) NOT NULL,
3260 PRIMARY KEY (`tenant_id`,`vserver_id`)
3261 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3262 /*!40101 SET character_set_client = @saved_cs_client */;
3265 -- Table structure for table `VSERVER2`
3268 DROP TABLE IF EXISTS `VSERVER2`;
3269 /*!40101 SET @saved_cs_client = @@character_set_client */;
3270 /*!40101 SET character_set_client = utf8 */;
3271 CREATE TABLE `VSERVER2` (
3272 `tenant_id` varchar(255) NOT NULL,
3273 `vserver_id` varchar(128) NOT NULL,
3274 `vserver_name` varchar(255) NOT NULL,
3275 `vserver_name2` varchar(255) DEFAULT NULL,
3276 `prov_status` varchar(20) DEFAULT NULL,
3277 `selflink` varchar(255) DEFAULT NULL,
3278 PRIMARY KEY (`tenant_id`,`vserver_id`)
3279 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3280 /*!40101 SET character_set_client = @saved_cs_client */;
3283 -- Table structure for table `VSERVER_PSERVER`
3286 DROP TABLE IF EXISTS `VSERVER_PSERVER`;
3287 /*!40101 SET @saved_cs_client = @@character_set_client */;
3288 /*!40101 SET character_set_client = utf8 */;
3289 CREATE TABLE `VSERVER_PSERVER` (
3290 `vserver_id` varchar(128) NOT NULL,
3291 `pserver_hostname` varchar(255) DEFAULT NULL,
3292 PRIMARY KEY (`vserver_id`)
3293 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3294 /*!40101 SET character_set_client = @saved_cs_client */;
3297 -- Table structure for table `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`
3300 DROP TABLE IF EXISTS `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`;
3301 /*!40101 SET @saved_cs_client = @@character_set_client */;
3302 /*!40101 SET character_set_client = utf8 */;
3303 CREATE TABLE `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING` (
3304 `key_id` varchar(128) NOT NULL,
3305 `cloud_region` varchar(128) NOT NULL,
3306 `key_type` varchar(128) NOT NULL,
3307 PRIMARY KEY (`key_id`,`cloud_region`,`key_type`)
3308 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3309 /*!40101 SET character_set_client = @saved_cs_client */;
3312 -- Table structure for table `WAN_COMBO_ALLOWABLE`
3315 DROP TABLE IF EXISTS `WAN_COMBO_ALLOWABLE`;
3316 /*!40101 SET @saved_cs_client = @@character_set_client */;
3317 /*!40101 SET character_set_client = utf8 */;
3318 CREATE TABLE `WAN_COMBO_ALLOWABLE` (
3319 `combo_sequence` int(11) NOT NULL AUTO_INCREMENT,
3320 `topology` varchar(16) DEFAULT 'unknown',
3321 `internet_topology` varchar(20) DEFAULT NULL,
3322 `wan1` varchar(40) DEFAULT NULL,
3323 `wan2` varchar(40) DEFAULT NULL,
3324 `new_start_release_flexware` varchar(16) DEFAULT 'unknown',
3325 `is_active_flexware` varchar(1) DEFAULT 'N',
3326 `new_start_release_dhv` varchar(16) DEFAULT 'unknown',
3327 `is_active_dhv` varchar(1) DEFAULT 'N',
3328 `ucpe_type` varchar(32) DEFAULT 'stand-alone',
3329 `description` varchar(128) NOT NULL,
3330 PRIMARY KEY (`combo_sequence`),
3331 UNIQUE KEY `IX1_WAN_COMBO_ALLOWABLE` (`internet_topology`,`wan1`,`wan2`)
3332 ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
3333 /*!40101 SET character_set_client = @saved_cs_client */;
3335 DROP TABLE IF EXISTS `DHCP_MAP`;
3336 /*!40101 SET @saved_cs_client = @@character_set_client */;
3337 /*!40101 SET character_set_client = utf8 */;
3338 CREATE TABLE `DHCP_MAP` (
3339 `mac_addr` varchar(128) NOT NULL,
3340 `ip_addr` varchar(128) DEFAULT NULL,
3341 PRIMARY KEY (`mac_addr`)
3342 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3344 DROP TABLE IF EXISTS `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING`;
3345 CREATE TABLE `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING` (
3346 `group_uuid` varchar(255) NOT NULL,
3347 `parent_uuid` varchar(255) NOT NULL,
3348 `target_node_uuid` varchar(255) NOT NULL,
3349 `target_type` varchar(255) NULL,
3350 `table_name` varchar(255) NULL,
3351 PRIMARY KEY (`group_uuid`, `parent_uuid`, `target_node_uuid`)
3352 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3354 /*!40101 SET character_set_client = @saved_cs_client */;
3355 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3357 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3358 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3359 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3360 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3361 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3362 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3363 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3365 DROP TABLE IF EXISTS `ATTRIBUTE_VALUE_PAIR`;
3366 CREATE TABLE `ATTRIBUTE_VALUE_PAIR` (
3367 `resource_uuid` varchar(255) NOT NULL,
3368 `attribute_name` varchar(255) NOT NULL,
3369 `resource_type` varchar(255) NOT NULL,
3370 `attribute_value` varchar(255) DEFAULT NULL,
3371 `resource_customization_uuid` varchar(255) DEFAULT NULL,
3372 PRIMARY KEY (`resource_uuid`,`attribute_name`,`resource_type`)
3373 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3375 DROP TABLE IF EXISTS `COMPLEX_RESOURCE`;
3376 CREATE TABLE `COMPLEX_RESOURCE` (
3377 `uuid` varchar(255) NOT NULL,
3378 `model_yaml` longblob,
3379 `invariant_uuid` varchar(255) NOT NULL,
3380 `customization_uuid` varchar(255) NOT NULL,
3381 `version` varchar(255) DEFAULT NULL,
3382 `name` varchar(255) DEFAULT NULL,
3383 `description` varchar(255) DEFAULT NULL,
3384 `type` varchar(255) NOT NULL,
3385 PRIMARY KEY (`uuid`,`customization_uuid`)
3386 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3388 DROP TABLE IF EXISTS `NODE_CAPABILITY`;
3389 CREATE TABLE `NODE_CAPABILITY` (
3390 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
3391 `capability_provider_uuid` varchar(255) NOT NULL,
3392 `capability_provider_customization_uuid` varchar(255) NOT NULL,
3393 `capability_name` varchar(255) DEFAULT NULL,
3394 `capability_type` varchar(255) DEFAULT NULL,
3395 PRIMARY KEY (`capability_id`)
3396 ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
3398 DROP TABLE IF EXISTS `NODE_REQUIREMENT`;
3399 CREATE TABLE `NODE_REQUIREMENT` (
3400 `requirement_id` int(11) NOT NULL AUTO_INCREMENT,
3401 `capability_id` int(11) DEFAULT NULL,
3402 `capability_provider_uuid` varchar(255) DEFAULT NULL,
3403 `capability_provider_customization_uuid` varchar(255) DEFAULT NULL,
3404 `capability_consumer_uuid` varchar(255) NOT NULL,
3405 `capability_consumer_customization_uuid` varchar(255) NOT NULL,
3406 `requirement_name` varchar(255) NOT NULL,
3407 PRIMARY KEY (`requirement_id`),
3408 KEY `NODE_REQUIREMENT_TO_NODE_CAPABILITY` (`capability_id`)
3409 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
3411 DROP TABLE IF EXISTS `RELATED_NETWORK_ROLE`;
3412 CREATE TABLE `RELATED_NETWORK_ROLE` (
3413 `network_model_customization_uuid` varchar(255) NOT NULL,
3414 `related_network_role` varchar(255) NOT NULL,
3415 PRIMARY KEY (`network_model_customization_uuid`,`related_network_role`)
3416 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3418 DROP TABLE IF EXISTS `RESOURCE_GROUP`;
3419 CREATE TABLE `RESOURCE_GROUP` (
3420 `resource_uuid` varchar(255) NOT NULL,
3421 `group_uuid` varchar(255) NOT NULL,
3422 `group_customization_uuid` varchar(255) DEFAULT NULL,
3423 `group_invariant_uuid` varchar(255) NOT NULL,
3424 `group_name` varchar(255) DEFAULT NULL,
3425 `version` varchar(255) DEFAULT NULL,
3426 `group_type` varchar(255) DEFAULT NULL,
3427 PRIMARY KEY (`resource_uuid`,`group_uuid`)
3428 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3430 DROP TABLE IF EXISTS `RESOURCE_POLICY`;
3431 CREATE TABLE `RESOURCE_POLICY` (
3432 `resource_uuid` varchar(255) NOT NULL,
3433 `policy_uuid` varchar(255) NOT NULL,
3434 `policy_customization_uuid` varchar(255) DEFAULT NULL,
3435 `policy_invariant_uuid` varchar(255) NOT NULL,
3436 `policy_name` varchar(255) DEFAULT NULL,
3437 `version` varchar(255) DEFAULT NULL,
3438 `policy_type` varchar(255) DEFAULT NULL,
3439 `property_type` varchar(255) DEFAULT NULL,
3440 `property_source` varchar(255) DEFAULT NULL,
3441 `property_name` varchar(255) DEFAULT NULL,
3442 PRIMARY KEY (`resource_uuid`,`policy_uuid`)
3443 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3445 DROP TABLE IF EXISTS `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING`;
3446 CREATE TABLE `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING` (
3447 `policy_uuid` varchar(255) NOT NULL,
3448 `parent_uuid` varchar(255) NOT NULL,
3449 `target_node_uuid` varchar(255) NOT NULL,
3450 `target_type` varchar(255) DEFAULT NULL,
3451 `target_node_customization_uuid` varchar(255) DEFAULT NULL,
3452 `policy_customization_uuid` varchar(255) DEFAULT NULL,
3453 PRIMARY KEY (`policy_uuid`,`parent_uuid`,`target_node_uuid`)
3454 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3457 DROP TABLE IF EXISTS `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING`;
3458 CREATE TABLE `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING` (
3459 `service_uuid` varchar(255) NOT NULL,
3460 `complex_resource_uuid` varchar(255) NOT NULL,
3461 `complex_resource_customization_uuid` varchar(255) NOT NULL,
3462 PRIMARY KEY (`service_uuid`,`complex_resource_uuid`,`complex_resource_customization_uuid`)
3463 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3465 DROP TABLE IF EXISTS `VFC_RELATED_NETWORK_ROLE`;
3466 CREATE TABLE `VFC_RELATED_NETWORK_ROLE` (
3467 `vfc_customization_uuid` varchar(255) NOT NULL,
3468 `vm_type` varchar(255) NOT NULL,
3469 `network_role` varchar(255) NOT NULL,
3470 `related_network_role` varchar(255) NOT NULL,
3471 PRIMARY KEY (`vfc_customization_uuid`,`vm_type`,`network_role`,`related_network_role`)
3472 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3474 DROP TABLE IF EXISTS `VNF_RELATED_NETWORK_ROLE`;
3475 CREATE TABLE `VNF_RELATED_NETWORK_ROLE` (
3476 `vnf_customization_uuid` varchar(255) NOT NULL,
3477 `network_role` varchar(255) NOT NULL,
3478 `related_network_role` varchar(255) NOT NULL,
3479 PRIMARY KEY (`vnf_customization_uuid`,`network_role`,`related_network_role`)
3480 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3482 -- Dump completed on 2017-10-04 18:23:01