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 PRIMARY KEY (`request_id`)
1910 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1911 /*!40101 SET character_set_client = @saved_cs_client */;
1914 -- Table structure for table `REQUEST_PROGRESS`
1917 DROP TABLE IF EXISTS `REQUEST_PROGRESS`;
1918 /*!40101 SET @saved_cs_client = @@character_set_client */;
1919 /*!40101 SET character_set_client = utf8 */;
1920 CREATE TABLE `REQUEST_PROGRESS` (
1921 `request_id` int(11) NOT NULL AUTO_INCREMENT,
1922 `request_type` varchar(20) DEFAULT NULL,
1923 `service_instance_id` varchar(80) NOT NULL,
1924 `request_instance_type` varchar(20) NOT NULL,
1925 `originating_service_instance_id` varchar(80) DEFAULT NULL,
1926 `originating_service_type` varchar(20) DEFAULT NULL,
1927 `overall_status` varchar(20) DEFAULT NULL,
1928 `status_date` varchar(80) DEFAULT NULL,
1929 `message` varchar(255) DEFAULT NULL,
1930 PRIMARY KEY (`request_id`)
1931 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1932 /*!40101 SET character_set_client = @saved_cs_client */;
1935 -- Table structure for table `REQUEST_PROGRESS_STATE`
1938 DROP TABLE IF EXISTS `REQUEST_PROGRESS_STATE`;
1939 /*!40101 SET @saved_cs_client = @@character_set_client */;
1940 /*!40101 SET character_set_client = utf8 */;
1941 CREATE TABLE `REQUEST_PROGRESS_STATE` (
1942 `request_progress_state_id` int(11) NOT NULL AUTO_INCREMENT,
1943 `request_id` int(11) DEFAULT NULL,
1944 `service_instance_id` varchar(80) NOT NULL,
1945 `request_instance_type` varchar(20) NOT NULL,
1946 `progress_state` varchar(30) DEFAULT NULL,
1947 `transaction_status` varchar(20) DEFAULT NULL,
1948 `status_date` varchar(80) DEFAULT NULL,
1949 `response_code` varchar(20) DEFAULT NULL,
1950 `message` varchar(255) DEFAULT NULL,
1951 PRIMARY KEY (`request_progress_state_id`)
1952 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1953 /*!40101 SET character_set_client = @saved_cs_client */;
1956 -- Table structure for table `RESOURCE`
1959 DROP TABLE IF EXISTS `RESOURCE`;
1960 /*!40101 SET @saved_cs_client = @@character_set_client */;
1961 /*!40101 SET character_set_client = utf8 */;
1962 CREATE TABLE `RESOURCE` (
1963 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1964 `asset_id` varchar(100) NOT NULL,
1965 `resource_name` varchar(50) NOT NULL,
1966 `resource_type` enum('Limit','Label','Range') NOT NULL,
1967 `lt_used` bigint(20) DEFAULT NULL,
1968 `ll_label` varchar(50) DEFAULT NULL,
1969 `ll_reference_count` smallint(6) DEFAULT NULL,
1970 `rr_used` varchar(4000) DEFAULT NULL,
1971 PRIMARY KEY (`resource_id`),
1972 UNIQUE KEY `resource_id` (`resource_id`),
1973 UNIQUE KEY `IX1_RESOURCE` (`asset_id`,`resource_name`)
1974 ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;
1975 /*!40101 SET character_set_client = @saved_cs_client */;
1978 -- Table structure for table `RESOURCE_LOAD`
1981 DROP TABLE IF EXISTS `RESOURCE_LOAD`;
1982 /*!40101 SET @saved_cs_client = @@character_set_client */;
1983 /*!40101 SET character_set_client = utf8 */;
1984 CREATE TABLE `RESOURCE_LOAD` (
1985 `resource_load_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1986 `resource_id` bigint(20) NOT NULL,
1987 `application_id` varchar(20) NOT NULL,
1988 `resource_load_time` datetime NOT NULL,
1989 `resource_expiration_time` datetime DEFAULT NULL,
1990 PRIMARY KEY (`resource_load_id`),
1991 UNIQUE KEY `resource_load_id` (`resource_load_id`),
1992 UNIQUE KEY `IX2_RESOURCE_LOAD` (`resource_id`,`application_id`),
1993 KEY `IX1_RESOURCE_LOAD` (`resource_id`)
1994 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1995 /*!40101 SET character_set_client = @saved_cs_client */;
1998 -- Table structure for table `RESOURCE_LOCK`
2001 DROP TABLE IF EXISTS `RESOURCE_LOCK`;
2002 /*!40101 SET @saved_cs_client = @@character_set_client */;
2003 /*!40101 SET character_set_client = utf8 */;
2004 CREATE TABLE `RESOURCE_LOCK` (
2005 `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2006 `resource_name` varchar(256) DEFAULT NULL,
2007 `lock_holder` varchar(100) NOT NULL,
2008 `lock_count` smallint(6) NOT NULL,
2009 `lock_time` datetime NOT NULL,
2010 `expiration_time` datetime NOT NULL,
2011 PRIMARY KEY (`resource_lock_id`),
2012 UNIQUE KEY `resource_lock_id` (`resource_lock_id`),
2013 UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`)
2014 ) ENGINE=InnoDB AUTO_INCREMENT=29681 DEFAULT CHARSET=latin1;
2015 /*!40101 SET character_set_client = @saved_cs_client */;
2018 -- Table structure for table `RESOURCE_RULE`
2021 DROP TABLE IF EXISTS `RESOURCE_RULE`;
2022 /*!40101 SET @saved_cs_client = @@character_set_client */;
2023 /*!40101 SET character_set_client = utf8 */;
2024 CREATE TABLE `RESOURCE_RULE` (
2025 `resource_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2026 `resource_name` varchar(50) NOT NULL,
2027 `service_model` varchar(50) NOT NULL,
2028 `end_point_position` varchar(50) NOT NULL,
2029 `service_expression` varchar(2000) NOT NULL,
2030 `equipment_level` varchar(50) NOT NULL,
2031 `equipment_expression` varchar(2000) NOT NULL,
2032 `allocation_expression` varchar(2000) NOT NULL,
2033 `soft_limit_expression` varchar(2000) NOT NULL,
2034 `hard_limit_expression` varchar(2000) NOT NULL,
2035 PRIMARY KEY (`resource_rule_id`),
2036 UNIQUE KEY `resource_rule_id` (`resource_rule_id`)
2037 ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
2038 /*!40101 SET character_set_client = @saved_cs_client */;
2041 -- Table structure for table `RESOURCE_THRESHOLD`
2044 DROP TABLE IF EXISTS `RESOURCE_THRESHOLD`;
2045 /*!40101 SET @saved_cs_client = @@character_set_client */;
2046 /*!40101 SET character_set_client = utf8 */;
2047 CREATE TABLE `RESOURCE_THRESHOLD` (
2048 `resource_threshold_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2049 `resource_rule_id` bigint(20) NOT NULL,
2050 `threshold_expression` varchar(2000) NOT NULL,
2051 `threshold_message` varchar(2000) NOT NULL,
2052 PRIMARY KEY (`resource_threshold_id`)
2053 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2054 /*!40101 SET character_set_client = @saved_cs_client */;
2057 -- Table structure for table `ROUTER_MASTER`
2060 DROP TABLE IF EXISTS `ROUTER_MASTER`;
2061 /*!40101 SET @saved_cs_client = @@character_set_client */;
2062 /*!40101 SET character_set_client = utf8 */;
2063 CREATE TABLE `ROUTER_MASTER` (
2064 `crs_name` varchar(20) NOT NULL,
2065 `loopback_ip` varchar(20) NOT NULL,
2066 PRIMARY KEY (`crs_name`)
2067 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2068 /*!40101 SET character_set_client = @saved_cs_client */;
2071 -- Table structure for table `ROUTING_CHARACTERISTIC_MAPPING`
2074 DROP TABLE IF EXISTS `ROUTING_CHARACTERISTIC_MAPPING`;
2075 /*!40101 SET @saved_cs_client = @@character_set_client */;
2076 /*!40101 SET character_set_client = utf8 */;
2077 CREATE TABLE `ROUTING_CHARACTERISTIC_MAPPING` (
2078 `network_role` varchar(255) NOT NULL,
2079 `vrf_name` varchar(255) NOT NULL,
2080 `routing_characteristic` varchar(255) NOT NULL,
2081 PRIMARY KEY (`network_role`,`vrf_name`)
2082 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2083 /*!40101 SET character_set_client = @saved_cs_client */;
2086 -- Table structure for table `SERVICE_HOMING`
2089 DROP TABLE IF EXISTS `SERVICE_HOMING`;
2090 /*!40101 SET @saved_cs_client = @@character_set_client */;
2091 /*!40101 SET character_set_client = utf8 */;
2092 CREATE TABLE `SERVICE_HOMING` (
2093 `service_type` varchar(100) NOT NULL,
2094 `lata` int(3) NOT NULL,
2095 `hubbing_city_type` varchar(40) NOT NULL,
2096 `latitude` float DEFAULT NULL,
2097 `longitude` float DEFAULT NULL,
2098 `primary_aic_site_name` varchar(100) NOT NULL,
2099 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2100 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2101 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2102 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2103 /*!40101 SET character_set_client = @saved_cs_client */;
2106 -- Table structure for table `SERVICE_HOMING_BACKUP`
2109 DROP TABLE IF EXISTS `SERVICE_HOMING_BACKUP`;
2110 /*!40101 SET @saved_cs_client = @@character_set_client */;
2111 /*!40101 SET character_set_client = utf8 */;
2112 CREATE TABLE `SERVICE_HOMING_BACKUP` (
2113 `service_type` varchar(100) NOT NULL,
2114 `lata` int(3) NOT NULL,
2115 `hubbing_city_type` varchar(40) NOT NULL,
2116 `latitude` float DEFAULT NULL,
2117 `longitude` float DEFAULT NULL,
2118 `primary_aic_site_name` varchar(100) NOT NULL,
2119 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2120 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2121 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2122 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2123 /*!40101 SET character_set_client = @saved_cs_client */;
2126 -- Table structure for table `SERVICE_INSTANCE_NAME_INDEX`
2129 DROP TABLE IF EXISTS `SERVICE_INSTANCE_NAME_INDEX`;
2130 /*!40101 SET @saved_cs_client = @@character_set_client */;
2131 /*!40101 SET character_set_client = utf8 */;
2132 CREATE TABLE `SERVICE_INSTANCE_NAME_INDEX` (
2133 `service_instance_name_prefix` varchar(255) NOT NULL,
2134 `index_number` int(11) NOT NULL,
2135 PRIMARY KEY (`service_instance_name_prefix`)
2136 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2137 /*!40101 SET character_set_client = @saved_cs_client */;
2140 -- Table structure for table `SERVICE_MANAGER_CREDENTIALS`
2143 DROP TABLE IF EXISTS `SERVICE_MANAGER_CREDENTIALS`;
2144 /*!40101 SET @saved_cs_client = @@character_set_client */;
2145 /*!40101 SET character_set_client = utf8 */;
2146 CREATE TABLE `SERVICE_MANAGER_CREDENTIALS` (
2147 `service_manager_username` varchar(255) NOT NULL,
2148 `service_manager_password` varbinary(255) NOT NULL,
2149 PRIMARY KEY (`service_manager_username`)
2150 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2151 /*!40101 SET character_set_client = @saved_cs_client */;
2154 -- Table structure for table `SERVICE_MODEL`
2157 DROP TABLE IF EXISTS `SERVICE_MODEL`;
2158 /*!40101 SET @saved_cs_client = @@character_set_client */;
2159 /*!40101 SET character_set_client = utf8 */;
2160 CREATE TABLE `SERVICE_MODEL` (
2161 `service_uuid` varchar(255) NOT NULL,
2162 `model_yaml` longblob,
2163 `invariant_uuid` varchar(255) DEFAULT NULL,
2164 `version` varchar(255) DEFAULT NULL,
2165 `name` varchar(255) DEFAULT NULL,
2166 `description` varchar(1024) DEFAULT NULL,
2167 `type` varchar(255) DEFAULT NULL,
2168 `category` varchar(255) DEFAULT NULL,
2169 `ecomp_naming` char(1) DEFAULT NULL,
2170 `service_instance_name_prefix` varchar(255) DEFAULT NULL,
2171 `filename` varchar(100) DEFAULT NULL,
2172 `naming_policy` varchar(255) DEFAULT NULL,
2173 PRIMARY KEY (`service_uuid`)
2174 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2175 /*!40101 SET character_set_client = @saved_cs_client */;
2178 -- Table structure for table `SERVICE_PROXY`
2181 DROP TABLE IF EXISTS `SERVICE_PROXY`;
2182 /*!40101 SET @saved_cs_client = @@character_set_client */;
2183 /*!40101 SET character_set_client = utf8 */;
2184 CREATE TABLE `SERVICE_PROXY` (
2185 `port_mirror_service_uuid` varchar(255) NOT NULL,
2186 `service_proxy_name` varchar(255) NOT NULL,
2187 `source_service_uuid` varchar(255) NOT NULL,
2188 `resources_vendor` varchar(255) DEFAULT NULL,
2189 `resource_vendor_release` varchar(255) DEFAULT NULL,
2190 `description` varchar(255) DEFAULT NULL,
2191 `category` varchar(255) DEFAULT NULL,
2192 `subcategory` varchar(255) DEFAULT NULL,
2193 `version` varchar(255) DEFAULT NULL,
2194 `role` varchar(255) NOT NULL,
2195 `uuid` varchar(255) DEFAULT NULL,
2196 `customization_uuid` varchar(255) DEFAULT NULL,
2197 `invariant_uuid` varchar(255) DEFAULT NULL,
2198 PRIMARY KEY (`port_mirror_service_uuid`,`service_proxy_name`),
2199 KEY `FK_SERVICE_PROXY_SOURCE_TO_SERVICE_MODE` (`source_service_uuid`),
2200 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
2201 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2202 /*!40101 SET character_set_client = @saved_cs_client */;
2205 -- Table structure for table `SERVICE_RESOURCE`
2208 DROP TABLE IF EXISTS `SERVICE_RESOURCE`;
2209 /*!40101 SET @saved_cs_client = @@character_set_client */;
2210 /*!40101 SET character_set_client = utf8 */;
2211 CREATE TABLE `SERVICE_RESOURCE` (
2212 `service_resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2213 `service_instance_id` varchar(80) NOT NULL,
2214 `service_status` enum('Active','Pending') NOT NULL,
2215 `service_change_number` smallint(6) NOT NULL,
2216 `resource_set_id` varchar(100) NOT NULL,
2217 `resource_union_id` varchar(100) NOT NULL,
2218 PRIMARY KEY (`service_instance_id`,`service_change_number`),
2219 UNIQUE KEY `service_resource_id` (`service_resource_id`),
2220 KEY `IX1_SERVICE_RESOURCE` (`service_instance_id`)
2221 ) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=latin1;
2222 /*!40101 SET character_set_client = @saved_cs_client */;
2225 -- Table structure for table `SERVICE_TYPE_MAPPING`
2228 DROP TABLE IF EXISTS `SERVICE_TYPE_MAPPING`;
2229 /*!40101 SET @saved_cs_client = @@character_set_client */;
2230 /*!40101 SET character_set_client = utf8 */;
2231 CREATE TABLE `SERVICE_TYPE_MAPPING` (
2232 `sdnc_service_type` varchar(128) NOT NULL,
2233 `ncs_service_type` varchar(128) NOT NULL,
2234 PRIMARY KEY (`sdnc_service_type`,`ncs_service_type`)
2235 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2236 /*!40101 SET character_set_client = @saved_cs_client */;
2239 -- Table structure for table `SUBNETPOOL_MAPPING`
2242 DROP TABLE IF EXISTS `SUBNETPOOL_MAPPING`;
2243 /*!40101 SET @saved_cs_client = @@character_set_client */;
2244 /*!40101 SET character_set_client = utf8 */;
2245 CREATE TABLE `SUBNETPOOL_MAPPING` (
2246 `aic_cloud_region` varchar(16) NOT NULL,
2247 `ntc` varchar(32) NOT NULL,
2248 `lcp` varchar(32) NOT NULL,
2249 `aic_region_id` varchar(255) NOT NULL,
2250 PRIMARY KEY (`aic_cloud_region`)
2251 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2252 /*!40101 SET character_set_client = @saved_cs_client */;
2255 -- Table structure for table `SUPPORTED_SEQUENCE_NUMBER`
2258 DROP TABLE IF EXISTS `SUPPORTED_SEQUENCE_NUMBER`;
2259 /*!40101 SET @saved_cs_client = @@character_set_client */;
2260 /*!40101 SET character_set_client = utf8 */;
2261 CREATE TABLE `SUPPORTED_SEQUENCE_NUMBER` (
2262 `resource_sequence_number` varchar(10) NOT NULL,
2263 `resource_type` varchar(10) NOT NULL,
2264 PRIMARY KEY (`resource_sequence_number`,`resource_type`)
2265 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2266 /*!40101 SET character_set_client = @saved_cs_client */;
2269 -- Table structure for table `SVC_LOGIC`
2272 DROP TABLE IF EXISTS `SVC_LOGIC`;
2273 /*!40101 SET @saved_cs_client = @@character_set_client */;
2274 /*!40101 SET character_set_client = utf8 */;
2275 CREATE TABLE `SVC_LOGIC` (
2276 `module` varchar(80) NOT NULL,
2277 `rpc` varchar(80) NOT NULL,
2278 `version` varchar(40) NOT NULL,
2279 `mode` varchar(5) NOT NULL,
2280 `active` varchar(1) NOT NULL,
2282 `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2283 `md5sum` varchar(128) DEFAULT NULL,
2284 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
2285 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2286 /*!40101 SET character_set_client = @saved_cs_client */;
2289 -- Table structure for table `TABLE_CLEANUP_CONFIGURATION`
2292 DROP TABLE IF EXISTS `TABLE_CLEANUP_CONFIGURATION`;
2293 /*!40101 SET @saved_cs_client = @@character_set_client */;
2294 /*!40101 SET character_set_client = utf8 */;
2295 CREATE TABLE `TABLE_CLEANUP_CONFIGURATION` (
2296 `table_name` varchar(255) NOT NULL COMMENT 'The name of the table the cleanup will be performed on',
2297 `days_old` int(11) NOT NULL COMMENT 'Records older than the current date minus DAYS_OLD will be deleted',
2298 `date_column` varchar(255) NOT NULL COMMENT 'The name of the column containing the date to be checked',
2299 `commit_interval` int(11) NOT NULL DEFAULT '2500' COMMENT 'The maximum number of rows a commit may contain',
2300 `query_clause` varchar(1000) DEFAULT NULL COMMENT 'An optional additional query clause to further restrict deletion criteria',
2301 `child_table_name` varchar(255) DEFAULT NULL,
2302 `child_table_pk` varchar(255) DEFAULT NULL,
2303 PRIMARY KEY (`table_name`)
2304 ) 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.';
2305 /*!40101 SET character_set_client = @saved_cs_client */;
2308 -- Table structure for table `TASK_TEMPLATE`
2311 DROP TABLE IF EXISTS `TASK_TEMPLATE`;
2312 /*!40101 SET @saved_cs_client = @@character_set_client */;
2313 /*!40101 SET character_set_client = utf8 */;
2314 CREATE TABLE `TASK_TEMPLATE` (
2315 `task_template_id` int(11) NOT NULL AUTO_INCREMENT,
2316 `request_type` varchar(20) DEFAULT NULL,
2317 `task_name` varchar(30) NOT NULL,
2318 `task_category` varchar(50) NOT NULL,
2319 `ecomp_task` varchar(50) NOT NULL,
2320 `initial_load` varchar(1) NOT NULL,
2321 `service` varchar(20) DEFAULT NULL,
2322 PRIMARY KEY (`task_template_id`)
2323 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2324 /*!40101 SET character_set_client = @saved_cs_client */;
2327 -- Table structure for table `TENANT`
2330 DROP TABLE IF EXISTS `TENANT`;
2331 /*!40101 SET @saved_cs_client = @@character_set_client */;
2332 /*!40101 SET character_set_client = utf8 */;
2333 CREATE TABLE `TENANT` (
2334 `tenant_id` varchar(255) NOT NULL,
2335 `tenant_name` varchar(255) NOT NULL,
2336 `service_instance_id` varchar(255) NOT NULL,
2337 PRIMARY KEY (`tenant_id`,`tenant_name`)
2338 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2339 /*!40101 SET character_set_client = @saved_cs_client */;
2342 -- Table structure for table `TESTTBL`
2345 DROP TABLE IF EXISTS `TESTTBL`;
2346 /*!40101 SET @saved_cs_client = @@character_set_client */;
2347 /*!40101 SET character_set_client = utf8 */;
2348 CREATE TABLE `TESTTBL` (
2349 `pk` varchar(25) NOT NULL,
2350 `col1` varchar(25) DEFAULT NULL
2351 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2352 /*!40101 SET character_set_client = @saved_cs_client */;
2355 -- Table structure for table `THRESHOLD_NOTIFICATION`
2358 DROP TABLE IF EXISTS `THRESHOLD_NOTIFICATION`;
2359 /*!40101 SET @saved_cs_client = @@character_set_client */;
2360 /*!40101 SET character_set_client = utf8 */;
2361 CREATE TABLE `THRESHOLD_NOTIFICATION` (
2362 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2363 `threshold_expression` varchar(2000) DEFAULT NULL,
2364 `threshold_message` varchar(500) DEFAULT NULL,
2365 PRIMARY KEY (`resource_id`)
2366 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2367 /*!40101 SET character_set_client = @saved_cs_client */;
2370 -- Table structure for table `TMP_AIC_AVAIL_ZONE_POOL`
2373 DROP TABLE IF EXISTS `TMP_AIC_AVAIL_ZONE_POOL`;
2374 /*!40101 SET @saved_cs_client = @@character_set_client */;
2375 /*!40101 SET character_set_client = utf8 */;
2376 CREATE TABLE `TMP_AIC_AVAIL_ZONE_POOL` (
2377 `aic_site_id` varchar(100) NOT NULL,
2378 `status` varchar(40) NOT NULL,
2379 `availability_zone` varchar(100) NOT NULL,
2380 `token` int(4) NOT NULL,
2381 `vnf_id` varchar(80) DEFAULT NULL,
2382 `service_type` varchar(100) NOT NULL,
2383 `vnf_type` varchar(20) DEFAULT NULL,
2384 `hypervisor` varchar(10) DEFAULT NULL,
2385 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
2386 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2387 /*!40101 SET character_set_client = @saved_cs_client */;
2390 -- Table structure for table `TOPOLOGY_PARAMETER`
2393 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER`;
2394 /*!40101 SET @saved_cs_client = @@character_set_client */;
2395 /*!40101 SET character_set_client = utf8 */;
2396 CREATE TABLE `TOPOLOGY_PARAMETER` (
2397 `parameter_id` int(11) NOT NULL,
2398 `parameter_name` varchar(20) NOT NULL,
2399 `parameter_set` int(11) NOT NULL,
2400 `create_update_time` datetime NOT NULL,
2401 `create_update_user` varchar(40) NOT NULL,
2402 PRIMARY KEY (`parameter_id`)
2403 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2404 /*!40101 SET character_set_client = @saved_cs_client */;
2407 -- Table structure for table `TOPOLOGY_PARAMETER_ENTRIES`
2410 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_ENTRIES`;
2411 /*!40101 SET @saved_cs_client = @@character_set_client */;
2412 /*!40101 SET character_set_client = utf8 */;
2413 CREATE TABLE `TOPOLOGY_PARAMETER_ENTRIES` (
2414 `parameter_entry_id` int(11) NOT NULL,
2415 `parameter_name` varchar(255) NOT NULL,
2416 `parameter_value` varchar(64) NOT NULL,
2417 `create_update_time` datetime NOT NULL,
2418 `create_update_user` varchar(40) NOT NULL,
2419 PRIMARY KEY (`parameter_entry_id`)
2420 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2421 /*!40101 SET character_set_client = @saved_cs_client */;
2424 -- Table structure for table `TOPOLOGY_PARAMETER_TO_ENTRIES`
2427 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_TO_ENTRIES`;
2428 /*!40101 SET @saved_cs_client = @@character_set_client */;
2429 /*!40101 SET character_set_client = utf8 */;
2430 CREATE TABLE `TOPOLOGY_PARAMETER_TO_ENTRIES` (
2431 `parameter_id` int(11) DEFAULT NULL,
2432 `parameter_entry_id` int(11) DEFAULT NULL,
2433 `entry_order` int(11) DEFAULT NULL,
2434 `create_update_time` datetime DEFAULT NULL,
2435 `create_update_user` varchar(40) NOT NULL,
2436 KEY `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_id`),
2437 KEY `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_entry_id`),
2438 CONSTRAINT `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_id`) REFERENCES `TOPOLOGY_PARAMETER` (`parameter_id`),
2439 CONSTRAINT `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_entry_id`) REFERENCES `TOPOLOGY_PARAMETER_ENTRIES` (`parameter_entry_id`)
2440 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2441 /*!40101 SET character_set_client = @saved_cs_client */;
2444 -- Table structure for table `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE`
2447 DROP TABLE IF EXISTS `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE`;
2448 /*!40101 SET @saved_cs_client = @@character_set_client */;
2449 /*!40101 SET character_set_client = utf8 */;
2450 CREATE TABLE `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE` (
2451 `interface_name` varchar(255) NOT NULL,
2452 `interface_id` varchar(255) NOT NULL,
2453 `pnf_name` varchar(255) NOT NULL,
2454 `pnf_id` varchar(255) NOT NULL,
2455 `controller_id` varchar(255) DEFAULT NULL,
2456 `rate` varchar(255) DEFAULT NULL,
2457 `clli` varchar(255) DEFAULT NULL,
2458 `connection_point` varchar(255) DEFAULT NULL,
2459 PRIMARY KEY (`interface_name`)
2460 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2461 /*!40101 SET character_set_client = @saved_cs_client */;
2464 -- Table structure for table `TRANSACTION_LOG`
2467 DROP TABLE IF EXISTS `TRANSACTION_LOG`;
2468 /*!40101 SET @saved_cs_client = @@character_set_client */;
2469 /*!40101 SET character_set_client = utf8 */;
2470 CREATE TABLE `TRANSACTION_LOG` (
2471 `serial_key` int(10) NOT NULL AUTO_INCREMENT,
2472 `log_time` varchar(40) NOT NULL,
2473 `request_id` varchar(80) DEFAULT NULL,
2474 `svc_request_id` varchar(80) DEFAULT NULL,
2475 `x_ecomp_request_id` varchar(80) DEFAULT NULL,
2476 `graph_name` varchar(255) DEFAULT NULL,
2477 PRIMARY KEY (`serial_key`)
2478 ) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;
2479 /*!40101 SET character_set_client = @saved_cs_client */;
2483 -- Table structure for table `UPLOAD_CONFIG`
2486 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
2487 /*!40101 SET @saved_cs_client = @@character_set_client */;
2488 /*!40101 SET character_set_client = utf8 */;
2489 CREATE TABLE `UPLOAD_CONFIG` (
2490 `upload_config_id` int(11) NOT NULL AUTO_INCREMENT,
2491 `request_id` varchar(50) DEFAULT NULL,
2492 `originator_id` varchar(50) DEFAULT NULL,
2493 `service_description` varchar(100) DEFAULT NULL,
2494 `action` varchar(50) DEFAULT NULL,
2495 `upload_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
2496 `vnf_id` varchar(50) DEFAULT NULL,
2497 `vnf_name` varchar(50) DEFAULT NULL,
2498 `vm_name` varchar(50) DEFAULT NULL,
2499 `vnf_type` varchar(50) DEFAULT NULL,
2500 `vnfc_type` varchar(50) DEFAULT NULL,
2501 `host_ip_address` varchar(50) DEFAULT NULL,
2502 `config_indicator` varchar(25) DEFAULT NULL,
2503 `pending_delete` varchar(1) DEFAULT NULL,
2505 PRIMARY KEY (`upload_config_id`),
2506 UNIQUE KEY `upload_config_id` (`upload_config_id`)
2507 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2508 /*!40101 SET character_set_client = @saved_cs_client */;
2511 -- Table structure for table `USED_SEQUENCE_NUMBER`
2514 DROP TABLE IF EXISTS `USED_SEQUENCE_NUMBER`;
2515 /*!40101 SET @saved_cs_client = @@character_set_client */;
2516 /*!40101 SET character_set_client = utf8 */;
2517 CREATE TABLE `USED_SEQUENCE_NUMBER` (
2518 `resource_sequence_number` varchar(10) NOT NULL,
2519 `resource_type` varchar(10) NOT NULL,
2520 `zone_region_id` varchar(50) NOT NULL,
2521 PRIMARY KEY (`resource_sequence_number`,`resource_type`,`zone_region_id`)
2522 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2523 /*!40101 SET character_set_client = @saved_cs_client */;
2526 -- Table structure for table `USER_TRACE`
2529 DROP TABLE IF EXISTS `USER_TRACE`;
2530 /*!40101 SET @saved_cs_client = @@character_set_client */;
2531 /*!40101 SET character_set_client = utf8 */;
2532 CREATE TABLE `USER_TRACE` (
2533 `user_trace_seq` int(11) NOT NULL AUTO_INCREMENT,
2534 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2535 `identity` varchar(12) DEFAULT NULL,
2536 `action` varchar(128) DEFAULT NULL,
2537 `description` varchar(256) DEFAULT NULL,
2538 PRIMARY KEY (`user_trace_seq`)
2539 ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=latin1;
2540 /*!40101 SET character_set_client = @saved_cs_client */;
2543 -- Table structure for table `VENDOR_CODE`
2546 DROP TABLE IF EXISTS `VENDOR_CODE`;
2547 /*!40101 SET @saved_cs_client = @@character_set_client */;
2548 /*!40101 SET character_set_client = utf8 */;
2549 CREATE TABLE `VENDOR_CODE` (
2550 `vendor_code` varchar(1) NOT NULL,
2551 `vendor` varchar(45) NOT NULL DEFAULT '',
2552 PRIMARY KEY (`vendor_code`,`vendor`)
2553 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2554 /*!40101 SET character_set_client = @saved_cs_client */;
2557 -- Table structure for table `VFC_MODEL`
2560 DROP TABLE IF EXISTS `VFC_MODEL`;
2561 /*!40101 SET @saved_cs_client = @@character_set_client */;
2562 /*!40101 SET character_set_client = utf8 */;
2563 CREATE TABLE `VFC_MODEL` (
2564 `customization_uuid` varchar(255) NOT NULL,
2565 `model_yaml` longblob,
2566 `invariant_uuid` varchar(255) DEFAULT NULL,
2567 `uuid` varchar(255) DEFAULT NULL,
2568 `version` varchar(255) DEFAULT NULL,
2569 `naming_policy` varchar(255) DEFAULT NULL,
2570 `ecomp_generated_naming` char(1) DEFAULT NULL,
2571 `nfc_function` varchar(255) DEFAULT NULL,
2572 `nfc_naming_code` varchar(255) DEFAULT NULL,
2573 `vm_type` varchar(255) DEFAULT NULL,
2574 `vm_type_tag` varchar(255) DEFAULT NULL,
2575 `vm_image_name` varchar(255) DEFAULT NULL,
2576 `vm_flavor_name` varchar(255) DEFAULT NULL,
2577 `high_availability` varchar(255) DEFAULT NULL,
2578 `nfc_naming` varchar(255) DEFAULT NULL,
2579 `min_instances` int(11) DEFAULT NULL,
2580 `max_instances` int(11) DEFAULT NULL,
2581 PRIMARY KEY (`customization_uuid`)
2582 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2583 /*!40101 SET character_set_client = @saved_cs_client */;
2586 -- Table structure for table `VFC_TO_NETWORK_ROLE_MAPPING`
2589 DROP TABLE IF EXISTS `VFC_TO_NETWORK_ROLE_MAPPING`;
2590 /*!40101 SET @saved_cs_client = @@character_set_client */;
2591 /*!40101 SET character_set_client = utf8 */;
2592 CREATE TABLE `VFC_TO_NETWORK_ROLE_MAPPING` (
2593 `seq` int(11) NOT NULL AUTO_INCREMENT,
2594 `vfc_customization_uuid` varchar(255) NOT NULL,
2595 `network_role` varchar(255) NOT NULL,
2596 `vm_type` varchar(255) DEFAULT NULL,
2597 `network_role_tag` varchar(255) DEFAULT NULL,
2598 `ipv4_count` int(11) NOT NULL,
2599 `ipv6_count` int(11) NOT NULL,
2600 `ipv4_use_dhcp` char(1) DEFAULT NULL,
2601 `ipv6_use_dhcp` char(1) DEFAULT NULL,
2602 `ipv4_ip_version` char(1) DEFAULT NULL,
2603 `ipv6_ip_version` char(1) DEFAULT NULL,
2604 `extcp_subnetpool_id` varchar(512) DEFAULT NULL,
2605 `ipv4_floating_count` int(11) DEFAULT NULL,
2606 `ipv6_floating_count` int(11) DEFAULT NULL,
2607 `ipv4_address_plan_name` varchar(512) DEFAULT NULL,
2608 `ipv6_address_plan_name` varchar(512) DEFAULT NULL,
2609 `ipv4_vrf_name` varchar(512) DEFAULT NULL,
2610 `ipv6_vrf_name` varchar(512) DEFAULT NULL,
2611 `subnet_role` varchar(255) DEFAULT NULL,
2612 `subinterface_indicator` char(1) DEFAULT NULL,
2613 PRIMARY KEY (`seq`),
2614 KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`)
2615 ) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1;
2616 /*!40101 SET character_set_client = @saved_cs_client */;
2619 -- Table structure for table `VF_MODEL`
2622 DROP TABLE IF EXISTS `VF_MODEL`;
2623 /*!40101 SET @saved_cs_client = @@character_set_client */;
2624 /*!40101 SET character_set_client = utf8 */;
2625 CREATE TABLE `VF_MODEL` (
2626 `customization_uuid` varchar(255) NOT NULL,
2627 `model_yaml` longblob,
2628 `invariant_uuid` varchar(255) DEFAULT NULL,
2629 `uuid` varchar(255) DEFAULT NULL,
2630 `version` varchar(255) DEFAULT NULL,
2631 `name` varchar(255) DEFAULT NULL,
2632 `naming_policy` varchar(255) DEFAULT NULL,
2633 `ecomp_generated_naming` char(1) DEFAULT NULL,
2634 `avail_zone_max_count` int(11) DEFAULT NULL,
2635 `nf_function` varchar(255) DEFAULT NULL,
2636 `nf_code` varchar(255) DEFAULT NULL,
2637 `nf_type` varchar(255) DEFAULT NULL,
2638 `nf_role` varchar(255) DEFAULT NULL,
2639 `vendor` varchar(255) DEFAULT NULL,
2640 `vendor_version` varchar(255) DEFAULT NULL,
2641 PRIMARY KEY (`customization_uuid`)
2642 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2643 /*!40101 SET character_set_client = @saved_cs_client */;
2646 -- Table structure for table `VF_MODULE_MODEL`
2649 DROP TABLE IF EXISTS `VF_MODULE_MODEL`;
2650 /*!40101 SET @saved_cs_client = @@character_set_client */;
2651 /*!40101 SET character_set_client = utf8 */;
2652 CREATE TABLE `VF_MODULE_MODEL` (
2653 `customization_uuid` varchar(255) NOT NULL,
2654 `model_yaml` longblob,
2655 `invariant_uuid` varchar(255) DEFAULT NULL,
2656 `uuid` varchar(255) DEFAULT NULL,
2657 `version` varchar(255) DEFAULT NULL,
2658 `vf_module_type` varchar(255) DEFAULT NULL,
2659 `availability_zone_count` int(11) DEFAULT NULL,
2660 `ecomp_generated_vm_assignments` char(1) DEFAULT NULL,
2661 PRIMARY KEY (`customization_uuid`)
2662 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2663 /*!40101 SET character_set_client = @saved_cs_client */;
2666 -- Table structure for table `VF_MODULE_TO_VFC_MAPPING`
2669 DROP TABLE IF EXISTS `VF_MODULE_TO_VFC_MAPPING`;
2670 /*!40101 SET @saved_cs_client = @@character_set_client */;
2671 /*!40101 SET character_set_client = utf8 */;
2672 CREATE TABLE `VF_MODULE_TO_VFC_MAPPING` (
2673 `seq` int(11) NOT NULL AUTO_INCREMENT,
2674 `vf_module_customization_uuid` varchar(255) NOT NULL,
2675 `vfc_customization_uuid` varchar(255) NOT NULL,
2676 `vm_type` varchar(255) NOT NULL,
2677 `vm_count` int(11) NOT NULL,
2678 PRIMARY KEY (`seq`),
2679 KEY `IX1_VF_MODULE_TO_VFC_MAPPING` (`vf_module_customization_uuid`)
2680 ) ENGINE=InnoDB AUTO_INCREMENT=1591 DEFAULT CHARSET=latin1;
2681 /*!40101 SET character_set_client = @saved_cs_client */;
2684 -- Table structure for table `VF_TO_NETWORK_ROLE_MAPPING`
2687 DROP TABLE IF EXISTS `VF_TO_NETWORK_ROLE_MAPPING`;
2688 /*!40101 SET @saved_cs_client = @@character_set_client */;
2689 /*!40101 SET character_set_client = utf8 */;
2690 CREATE TABLE `VF_TO_NETWORK_ROLE_MAPPING` (
2691 `seq` int(11) NOT NULL AUTO_INCREMENT,
2692 `vf_customization_uuid` varchar(255) NOT NULL,
2693 `network_role` varchar(255) NOT NULL,
2694 PRIMARY KEY (`seq`),
2695 KEY `IX1_VF_TO_NETWORK_ROLE_MAPPING` (`vf_customization_uuid`)
2696 ) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=latin1;
2697 /*!40101 SET character_set_client = @saved_cs_client */;
2700 -- Table structure for table `VIPR_CONFIGURATION`
2703 DROP TABLE IF EXISTS `VIPR_CONFIGURATION`;
2704 /*!40101 SET @saved_cs_client = @@character_set_client */;
2705 /*!40101 SET character_set_client = utf8 */;
2706 CREATE TABLE `VIPR_CONFIGURATION` (
2707 `seq` int(11) NOT NULL AUTO_INCREMENT,
2708 `serial_number` varchar(255) DEFAULT NULL,
2709 `vnf_id` varchar(255) DEFAULT NULL,
2710 `vnf_name` varchar(255) DEFAULT NULL,
2711 `ecomp_service_instance_id` varchar(255) DEFAULT NULL,
2712 `vm_name` varchar(255) DEFAULT NULL,
2713 `cloud_region_id` varchar(255) DEFAULT NULL,
2714 `cloud_owner` varchar(255) DEFAULT NULL,
2716 ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
2717 /*!40101 SET character_set_client = @saved_cs_client */;
2720 -- Table structure for table `VIPR_SZ_MANAGER_KEY`
2723 DROP TABLE IF EXISTS `VIPR_SZ_MANAGER_KEY`;
2724 /*!40101 SET @saved_cs_client = @@character_set_client */;
2725 /*!40101 SET character_set_client = utf8 */;
2726 CREATE TABLE `VIPR_SZ_MANAGER_KEY` (
2727 `vipr_sz_manager_ip_addr` varchar(40) NOT NULL,
2728 `vipr_sz_manager_state` varchar(10) DEFAULT NULL,
2729 `vipr_sz_manager_api_key` varchar(255) DEFAULT NULL,
2730 PRIMARY KEY (`vipr_sz_manager_ip_addr`)
2731 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2732 /*!40101 SET character_set_client = @saved_cs_client */;
2735 -- Table structure for table `VLAN_ID_POOL`
2738 DROP TABLE IF EXISTS `VLAN_ID_POOL`;
2739 /*!40101 SET @saved_cs_client = @@character_set_client */;
2740 /*!40101 SET character_set_client = utf8 */;
2741 CREATE TABLE `VLAN_ID_POOL` (
2742 `aic_site_id` varchar(100) NOT NULL,
2743 `purpose` varchar(40) NOT NULL,
2744 `status` varchar(40) NOT NULL,
2745 `vlan_id` int(4) NOT NULL,
2746 `svc_instance_id` varchar(80) DEFAULT NULL,
2747 `availability_zone` varchar(100) DEFAULT NULL,
2748 `vplspe_name` varchar(80) DEFAULT NULL,
2749 PRIMARY KEY (`vlan_id`,`aic_site_id`,`purpose`)
2750 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2751 /*!40101 SET character_set_client = @saved_cs_client */;
2754 -- Table structure for table `VLAN_L3INTERFACE_IPV4_ADDRESS`
2757 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV4_ADDRESS`;
2758 /*!40101 SET @saved_cs_client = @@character_set_client */;
2759 /*!40101 SET character_set_client = utf8 */;
2760 CREATE TABLE `VLAN_L3INTERFACE_IPV4_ADDRESS` (
2761 `vnf_id` varchar(80) NOT NULL,
2762 `interface_name` varchar(255) NOT NULL,
2763 `vlan_interface` varchar(255) NOT NULL,
2764 `l3_interface_ipv4_address` varchar(64) NOT NULL,
2765 `l3_interface_ipv4_prefix_length` varchar(45) DEFAULT NULL,
2766 `vlan_id_inner` varchar(45) DEFAULT NULL,
2767 `vlan_id_outer` varchar(45) DEFAULT NULL,
2768 `is_floating` varchar(1) DEFAULT NULL,
2769 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv4_address`),
2770 KEY `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`),
2771 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
2772 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2773 /*!40101 SET character_set_client = @saved_cs_client */;
2776 -- Table structure for table `VLAN_L3INTERFACE_IPV6_ADDRESS`
2779 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV6_ADDRESS`;
2780 /*!40101 SET @saved_cs_client = @@character_set_client */;
2781 /*!40101 SET character_set_client = utf8 */;
2782 CREATE TABLE `VLAN_L3INTERFACE_IPV6_ADDRESS` (
2783 `vnf_id` varchar(80) NOT NULL,
2784 `interface_name` varchar(255) NOT NULL,
2785 `vlan_interface` varchar(255) NOT NULL,
2786 `l3_interface_ipv6_address` varchar(64) NOT NULL,
2787 `l3_interface_ipv6_prefix_length` varchar(45) DEFAULT NULL,
2788 `vlan_id_inner` varchar(45) DEFAULT NULL,
2789 `vlan_id_outer` varchar(45) DEFAULT NULL,
2790 `is_floating` varchar(1) DEFAULT NULL,
2791 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv6_address`),
2792 KEY `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`,`vlan_interface`),
2793 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
2794 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2795 /*!40101 SET character_set_client = @saved_cs_client */;
2798 -- Table structure for table `VLAN_PLAN_ID`
2801 DROP TABLE IF EXISTS `VLAN_PLAN_ID`;
2802 /*!40101 SET @saved_cs_client = @@character_set_client */;
2803 /*!40101 SET character_set_client = utf8 */;
2804 CREATE TABLE `VLAN_PLAN_ID` (
2805 `plan_type` varchar(40) NOT NULL,
2806 `purpose` varchar(40) NOT NULL,
2807 `vlan_plan_id_count` int(4) NOT NULL,
2808 PRIMARY KEY (`vlan_plan_id_count`,`plan_type`,`purpose`)
2809 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2810 /*!40101 SET character_set_client = @saved_cs_client */;
2813 -- Table structure for table `VLAN_POOL`
2816 DROP TABLE IF EXISTS `VLAN_POOL`;
2817 /*!40101 SET @saved_cs_client = @@character_set_client */;
2818 /*!40101 SET character_set_client = utf8 */;
2819 CREATE TABLE `VLAN_POOL` (
2820 `aic_site_id` varchar(100) NOT NULL,
2821 `availability_zone` varchar(100) NOT NULL,
2822 `vlan_plan_id` varchar(100) NOT NULL,
2823 `plan_type` varchar(40) NOT NULL,
2824 `purpose` varchar(40) NOT NULL,
2825 `vlan_id` int(4) NOT NULL,
2826 `status` varchar(40) NOT NULL,
2827 `reserved_id` varchar(80) DEFAULT NULL,
2828 PRIMARY KEY (`aic_site_id`,`availability_zone`,`vlan_plan_id`,`plan_type`,`purpose`,`vlan_id`)
2829 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2830 /*!40101 SET character_set_client = @saved_cs_client */;
2833 -- Table structure for table `VLAN_RANGES`
2836 DROP TABLE IF EXISTS `VLAN_RANGES`;
2837 /*!40101 SET @saved_cs_client = @@character_set_client */;
2838 /*!40101 SET character_set_client = utf8 */;
2839 CREATE TABLE `VLAN_RANGES` (
2840 `vlan_plan_id` varchar(100) NOT NULL,
2841 `plan_type` varchar(40) NOT NULL,
2842 `purpose` varchar(40) NOT NULL,
2843 `range_start` int(4) NOT NULL,
2844 `range_end` int(4) NOT NULL,
2845 `generated` char(1) DEFAULT NULL,
2846 PRIMARY KEY (`vlan_plan_id`,`plan_type`,`purpose`,`range_start`,`range_end`)
2847 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2848 /*!40101 SET character_set_client = @saved_cs_client */;
2851 -- Table structure for table `VM_NAME_INDEX`
2854 DROP TABLE IF EXISTS `VM_NAME_INDEX`;
2855 /*!40101 SET @saved_cs_client = @@character_set_client */;
2856 /*!40101 SET character_set_client = utf8 */;
2857 CREATE TABLE `VM_NAME_INDEX` (
2858 `vm_name_prefix` varchar(255) NOT NULL,
2859 `index_number` int(11) NOT NULL,
2860 PRIMARY KEY (`vm_name_prefix`)
2861 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2862 /*!40101 SET character_set_client = @saved_cs_client */;
2865 -- Table structure for table `VM_NETWORKS`
2868 DROP TABLE IF EXISTS `VM_NETWORKS`;
2869 /*!40101 SET @saved_cs_client = @@character_set_client */;
2870 /*!40101 SET character_set_client = utf8 */;
2871 CREATE TABLE `VM_NETWORKS` (
2872 `vnf_type` varchar(200) NOT NULL,
2873 `vm_type` varchar(45) NOT NULL,
2874 `network_role` varchar(45) NOT NULL,
2875 `assign_ips` tinyint(1) NOT NULL,
2876 `assign_macs` tinyint(1) NOT NULL,
2877 `assign_floating_ip` tinyint(1) NOT NULL,
2878 `ip_count` int(11) DEFAULT NULL,
2879 PRIMARY KEY (`vnf_type`,`vm_type`,`network_role`)
2880 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2881 /*!40101 SET character_set_client = @saved_cs_client */;
2884 -- Table structure for table `VM_PROFILE`
2887 DROP TABLE IF EXISTS `VM_PROFILE`;
2888 /*!40101 SET @saved_cs_client = @@character_set_client */;
2889 /*!40101 SET character_set_client = utf8 */;
2890 CREATE TABLE `VM_PROFILE` (
2891 `vnf_type` varchar(200) NOT NULL,
2892 `vm_type` varchar(45) NOT NULL,
2893 `vm_count` int(11) NOT NULL,
2894 PRIMARY KEY (`vnf_type`,`vm_type`)
2895 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2896 /*!40101 SET character_set_client = @saved_cs_client */;
2899 -- Table structure for table `VNF`
2902 DROP TABLE IF EXISTS `VNF`;
2903 /*!40101 SET @saved_cs_client = @@character_set_client */;
2904 /*!40101 SET character_set_client = utf8 */;
2905 CREATE TABLE `VNF` (
2906 `vnf_id` varchar(80) NOT NULL,
2907 `vnf_name` varchar(80) NOT NULL,
2908 `vnf_type` varchar(10) NOT NULL,
2909 `orchestration_status` varchar(20) DEFAULT NULL,
2910 `heat_stack_id` varchar(80) DEFAULT NULL,
2911 `mso_catalog_key` varchar(80) DEFAULT NULL,
2912 `availability_zone` varchar(80) DEFAULT NULL,
2913 `aic_site_id` varchar(80) DEFAULT NULL,
2914 `oam_ipv4_address` varchar(20) DEFAULT NULL,
2915 `vnf_name2` varchar(80) DEFAULT NULL,
2916 `vpe_id` varchar(80) NOT NULL,
2917 `ipv4_loopback0_address` varchar(80) DEFAULT NULL,
2918 `license_key` varchar(256) DEFAULT NULL,
2919 `entitlement_resource_uuid` varchar(256) DEFAULT NULL,
2920 PRIMARY KEY (`vnf_id`)
2921 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2922 /*!40101 SET character_set_client = @saved_cs_client */;
2925 -- Table structure for table `VNFC_DG_MAPPING`
2928 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
2929 /*!40101 SET @saved_cs_client = @@character_set_client */;
2930 /*!40101 SET character_set_client = utf8 */;
2931 CREATE TABLE `VNFC_DG_MAPPING` (
2932 `vnfc_dg_mapping_id` int(11) NOT NULL AUTO_INCREMENT,
2933 `action` varchar(50) DEFAULT NULL,
2934 `api_version` varchar(10) DEFAULT NULL,
2935 `vnf_type` varchar(50) DEFAULT NULL,
2936 `vnfc_type` varchar(50) DEFAULT NULL,
2937 `dg_name` varchar(50) NOT NULL,
2938 `dg_version` varchar(50) DEFAULT NULL,
2939 `dg_module` varchar(50) NOT NULL,
2940 PRIMARY KEY (`vnfc_dg_mapping_id`),
2941 UNIQUE KEY `input_constraint` (`action`,`api_version`,`vnf_type`,`vnfc_type`)
2942 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2943 /*!40101 SET character_set_client = @saved_cs_client */;
2946 -- Table structure for table `VNFC_REFERENCE`
2949 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
2950 /*!40101 SET @saved_cs_client = @@character_set_client */;
2951 /*!40101 SET character_set_client = utf8 */;
2952 CREATE TABLE `VNFC_REFERENCE` (
2953 `vnfc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
2954 `action` varchar(50) NOT NULL,
2955 `vnf_type` varchar(50) NOT NULL,
2956 `vm_instance` int(11) NOT NULL,
2957 `vnfc_instance` int(11) NOT NULL,
2958 `vnfc_type` varchar(50) NOT NULL,
2959 `vnfc_function_code` varchar(50) NOT NULL,
2960 `ipaddress_v4_oam_vip` varchar(50) DEFAULT NULL,
2961 `group_notation_type` varchar(50) DEFAULT NULL,
2962 `group_notation_value` varchar(50) DEFAULT NULL,
2963 PRIMARY KEY (`vnfc_reference_id`),
2964 UNIQUE KEY `vnfc_reference_id` (`vnfc_reference_id`)
2965 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2966 /*!40101 SET character_set_client = @saved_cs_client */;
2969 -- Table structure for table `VNF_IMAGE`
2972 DROP TABLE IF EXISTS `VNF_IMAGE`;
2973 /*!40101 SET @saved_cs_client = @@character_set_client */;
2974 /*!40101 SET character_set_client = utf8 */;
2975 CREATE TABLE `VNF_IMAGE` (
2976 `application_vendor` varchar(255) NOT NULL,
2977 `application_version` varchar(255) NOT NULL,
2978 `att_uuid` varchar(255) NOT NULL,
2979 `application` varchar(255) DEFAULT NULL,
2980 `selflink` varchar(255) DEFAULT NULL,
2981 PRIMARY KEY (`application_vendor`,`application_version`,`att_uuid`)
2982 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2983 /*!40101 SET character_set_client = @saved_cs_client */;
2986 -- Table structure for table `VNF_MODEL_LICENSES`
2989 DROP TABLE IF EXISTS `VNF_MODEL_LICENSES`;
2990 /*!40101 SET @saved_cs_client = @@character_set_client */;
2991 /*!40101 SET character_set_client = utf8 */;
2992 CREATE TABLE `VNF_MODEL_LICENSES` (
2993 `att_part_number` varchar(255) NOT NULL,
2994 `license_assignment_group` varchar(255) NOT NULL,
2995 `license_required` tinyint(1) DEFAULT NULL,
2996 `entitlement_assignment_group` varchar(255) DEFAULT NULL,
2997 `entitlement_required` tinyint(1) DEFAULT '0',
2998 `feature_group_uuid` varchar(255) DEFAULT NULL,
2999 PRIMARY KEY (`att_part_number`,`license_assignment_group`)
3000 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3001 /*!40101 SET character_set_client = @saved_cs_client */;
3004 -- Table structure for table `VNF_MODEL_LICENSE_FEATURES`
3007 DROP TABLE IF EXISTS `VNF_MODEL_LICENSE_FEATURES`;
3008 /*!40101 SET @saved_cs_client = @@character_set_client */;
3009 /*!40101 SET character_set_client = utf8 */;
3010 CREATE TABLE `VNF_MODEL_LICENSE_FEATURES` (
3011 `att_part_number` varchar(255) NOT NULL,
3012 `license_assignment_group` varchar(255) NOT NULL,
3013 `feature` varchar(255) NOT NULL,
3014 PRIMARY KEY (`att_part_number`,`license_assignment_group`,`feature`)
3015 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3016 /*!40101 SET character_set_client = @saved_cs_client */;
3019 -- Table structure for table `VNF_NAME_INDEX`
3022 DROP TABLE IF EXISTS `VNF_NAME_INDEX`;
3023 /*!40101 SET @saved_cs_client = @@character_set_client */;
3024 /*!40101 SET character_set_client = utf8 */;
3025 CREATE TABLE `VNF_NAME_INDEX` (
3026 `vnf_name_prefix` varchar(255) NOT NULL,
3027 `index_number` int(11) NOT NULL,
3028 PRIMARY KEY (`vnf_name_prefix`)
3029 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3030 /*!40101 SET character_set_client = @saved_cs_client */;
3033 -- Table structure for table `VNF_NETWORKS`
3036 DROP TABLE IF EXISTS `VNF_NETWORKS`;
3037 /*!40101 SET @saved_cs_client = @@character_set_client */;
3038 /*!40101 SET character_set_client = utf8 */;
3039 CREATE TABLE `VNF_NETWORKS` (
3040 `vnf_type` varchar(200) NOT NULL,
3041 `network_role` varchar(45) NOT NULL,
3042 PRIMARY KEY (`vnf_type`,`network_role`)
3043 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3044 /*!40101 SET character_set_client = @saved_cs_client */;
3047 -- Table structure for table `VNF_NETWORK_CONNECTION`
3050 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION`;
3051 /*!40101 SET @saved_cs_client = @@character_set_client */;
3052 /*!40101 SET character_set_client = utf8 */;
3053 CREATE TABLE `VNF_NETWORK_CONNECTION` (
3054 `connection_uuid` varchar(80) NOT NULL,
3055 `vnf_id` varchar(80) NOT NULL,
3056 `connection_id` varchar(80) DEFAULT NULL,
3057 `connection_type` varchar(20) DEFAULT NULL,
3058 `neutron_network_id` varchar(80) DEFAULT NULL,
3059 `neutron_network_name` varchar(80) DEFAULT NULL,
3060 `orchestration_status` varchar(20) DEFAULT NULL,
3061 `switch_id` varchar(40) DEFAULT NULL,
3062 `heat_stack_id` varchar(80) DEFAULT NULL,
3063 `mso_catalog_key` varchar(80) DEFAULT NULL,
3064 `provider_network` varchar(80) DEFAULT NULL,
3065 `port_group_id` varchar(80) DEFAULT NULL,
3066 `port_group_name` varchar(80) DEFAULT NULL,
3067 PRIMARY KEY (`connection_uuid`)
3068 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3069 /*!40101 SET character_set_client = @saved_cs_client */;
3072 -- Table structure for table `VNF_NETWORK_CONNECTION_VLAN`
3075 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION_VLAN`;
3076 /*!40101 SET @saved_cs_client = @@character_set_client */;
3077 /*!40101 SET character_set_client = utf8 */;
3078 CREATE TABLE `VNF_NETWORK_CONNECTION_VLAN` (
3079 `vlan_uuid` varchar(80) NOT NULL,
3080 `vlan_id` int(4) NOT NULL,
3081 `vlan_type` varchar(5) NOT NULL,
3082 `connection_uuid` varchar(80) DEFAULT NULL,
3083 PRIMARY KEY (`vlan_uuid`)
3084 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3085 /*!40101 SET character_set_client = @saved_cs_client */;
3088 -- Table structure for table `VNF_PROFILE`
3091 DROP TABLE IF EXISTS `VNF_PROFILE`;
3092 /*!40101 SET @saved_cs_client = @@character_set_client */;
3093 /*!40101 SET character_set_client = utf8 */;
3094 CREATE TABLE `VNF_PROFILE` (
3095 `vnf_type` varchar(200) NOT NULL,
3096 `availability_zone_count` int(11) NOT NULL,
3097 `equipment_role` varchar(80) NOT NULL,
3098 PRIMARY KEY (`vnf_type`)
3099 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3100 /*!40101 SET character_set_client = @saved_cs_client */;
3103 -- Table structure for table `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`
3106 DROP TABLE IF EXISTS `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`;
3107 /*!40101 SET @saved_cs_client = @@character_set_client */;
3108 /*!40101 SET character_set_client = utf8 */;
3109 CREATE TABLE `VNF_SERVICE_TO_NETWORK_ROLE_FILTER` (
3110 `vnf_service_type` varchar(60) NOT NULL,
3111 `network_role_filter` varchar(60) NOT NULL,
3112 PRIMARY KEY (`vnf_service_type`,`network_role_filter`)
3113 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3114 /*!40101 SET character_set_client = @saved_cs_client */;
3117 -- Table structure for table `VPE_LOCK`
3120 DROP TABLE IF EXISTS `VPE_LOCK`;
3121 /*!40101 SET @saved_cs_client = @@character_set_client */;
3122 /*!40101 SET character_set_client = utf8 */;
3123 CREATE TABLE `VPE_LOCK` (
3124 `vpe_name` varchar(20) NOT NULL,
3125 `vpn_lock` varchar(20) NOT NULL,
3126 PRIMARY KEY (`vpe_name`)
3127 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3128 /*!40101 SET character_set_client = @saved_cs_client */;
3131 -- Table structure for table `VPE_MAC_ADDRESS_POOL`
3134 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_POOL`;
3135 /*!40101 SET @saved_cs_client = @@character_set_client */;
3136 /*!40101 SET character_set_client = utf8 */;
3137 CREATE TABLE `VPE_MAC_ADDRESS_POOL` (
3138 `id` int(11) NOT NULL,
3139 `mac_address` varchar(50) NOT NULL,
3140 `sw_name` varchar(30) NOT NULL,
3142 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3143 /*!40101 SET character_set_client = @saved_cs_client */;
3146 -- Table structure for table `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`
3149 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`;
3150 /*!40101 SET @saved_cs_client = @@character_set_client */;
3151 /*!40101 SET character_set_client = utf8 */;
3152 CREATE TABLE `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING` (
3153 `id` int(11) NOT NULL,
3154 `hostname` varchar(50) NOT NULL,
3155 `assigned_user` varchar(25) NOT NULL,
3156 `assigned_date` date DEFAULT NULL,
3158 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3159 /*!40101 SET character_set_client = @saved_cs_client */;
3162 -- Table structure for table `VPE_POOL`
3165 DROP TABLE IF EXISTS `VPE_POOL`;
3166 /*!40101 SET @saved_cs_client = @@character_set_client */;
3167 /*!40101 SET character_set_client = utf8 */;
3168 CREATE TABLE `VPE_POOL` (
3169 `vpe_name` varchar(20) NOT NULL,
3170 `ipv4_oam_address` varchar(20) NOT NULL,
3171 `loopback0_ipv4_address` varchar(20) NOT NULL,
3172 `provisioning_status` varchar(10) NOT NULL,
3173 `aic_site_id` varchar(100) NOT NULL,
3174 `availability_zone` varchar(100) NOT NULL,
3175 `vlan_id_outer` varchar(20) NOT NULL,
3176 `vendor` varchar(20) NOT NULL,
3177 `physical_intf_name` varchar(40) NOT NULL,
3178 `physical_intf_speed` varchar(20) NOT NULL,
3179 `physical_intf_units` varchar(20) NOT NULL,
3180 `vpe_uuid` varchar(80) DEFAULT NULL,
3181 `vpe_id` varchar(80) NOT NULL,
3182 `image_filename` varchar(100) DEFAULT NULL,
3183 `as_number` varchar(20) NOT NULL,
3184 `loopback5000` varchar(16) DEFAULT NULL,
3185 `loopback10` varchar(16) DEFAULT NULL,
3186 `aic_version` varchar(50) DEFAULT NULL,
3187 `vpe_capacity` int(11) NOT NULL,
3188 PRIMARY KEY (`aic_site_id`,`vpe_name`,`availability_zone`)
3189 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3190 /*!40101 SET character_set_client = @saved_cs_client */;
3193 -- Table structure for table `VPLSPE_POOL`
3196 DROP TABLE IF EXISTS `VPLSPE_POOL`;
3197 /*!40101 SET @saved_cs_client = @@character_set_client */;
3198 /*!40101 SET character_set_client = utf8 */;
3199 CREATE TABLE `VPLSPE_POOL` (
3200 `vplspe_name` varchar(20) NOT NULL,
3201 `aic_site_id` varchar(100) NOT NULL,
3202 `availability_zone` varchar(100) NOT NULL,
3203 `physical_intf_name` varchar(40) NOT NULL,
3204 `physical_intf_speed` varchar(20) NOT NULL,
3205 `physical_intf_units` varchar(20) NOT NULL,
3206 `loopback0_ipv4_address` varchar(20) NOT NULL,
3207 `vlan_id_outer` varchar(20) NOT NULL,
3208 `vplspe_uuid` varchar(80) DEFAULT NULL,
3209 `image_filename` varchar(100) DEFAULT NULL,
3210 `provisioning_status` varchar(10) DEFAULT NULL,
3211 `vendor` varchar(20) DEFAULT NULL,
3212 PRIMARY KEY (`vplspe_name`,`aic_site_id`,`availability_zone`,`physical_intf_name`)
3213 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3214 /*!40101 SET character_set_client = @saved_cs_client */;
3217 -- Table structure for table `VPN_BINDINGS`
3220 DROP TABLE IF EXISTS `VPN_BINDINGS`;
3221 /*!40101 SET @saved_cs_client = @@character_set_client */;
3222 /*!40101 SET character_set_client = utf8 */;
3223 CREATE TABLE `VPN_BINDINGS` (
3224 `network_customization_uuid` varchar(255) NOT NULL,
3225 `binding_uuid` varchar(255) NOT NULL,
3226 PRIMARY KEY (`network_customization_uuid`,`binding_uuid`)
3227 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3228 /*!40101 SET character_set_client = @saved_cs_client */;
3231 -- Table structure for table `VRR_FUNCTION_CODE_VMTYPE_MAPPING`
3234 DROP TABLE IF EXISTS `VRR_FUNCTION_CODE_VMTYPE_MAPPING`;
3235 /*!40101 SET @saved_cs_client = @@character_set_client */;
3236 /*!40101 SET character_set_client = utf8 */;
3237 CREATE TABLE `VRR_FUNCTION_CODE_VMTYPE_MAPPING` (
3238 `ptnii_function_code` varchar(128) NOT NULL,
3239 `vm_type` varchar(128) NOT NULL,
3240 PRIMARY KEY (`ptnii_function_code`,`vm_type`)
3241 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3242 /*!40101 SET character_set_client = @saved_cs_client */;
3245 -- Table structure for table `VSERVER`
3248 DROP TABLE IF EXISTS `VSERVER`;
3249 /*!40101 SET @saved_cs_client = @@character_set_client */;
3250 /*!40101 SET character_set_client = utf8 */;
3251 CREATE TABLE `VSERVER` (
3252 `tenant_id` varchar(40) NOT NULL,
3253 `vserver_id` varchar(40) NOT NULL,
3254 `aic_site_id` varchar(100) NOT NULL,
3255 `vendor` varchar(20) NOT NULL,
3256 `image_name` varchar(100) NOT NULL,
3257 `vnf_type` varchar(10) NOT NULL,
3258 `vnf_id` varchar(80) NOT NULL,
3259 PRIMARY KEY (`tenant_id`,`vserver_id`)
3260 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3261 /*!40101 SET character_set_client = @saved_cs_client */;
3264 -- Table structure for table `VSERVER2`
3267 DROP TABLE IF EXISTS `VSERVER2`;
3268 /*!40101 SET @saved_cs_client = @@character_set_client */;
3269 /*!40101 SET character_set_client = utf8 */;
3270 CREATE TABLE `VSERVER2` (
3271 `tenant_id` varchar(255) NOT NULL,
3272 `vserver_id` varchar(128) NOT NULL,
3273 `vserver_name` varchar(255) NOT NULL,
3274 `vserver_name2` varchar(255) DEFAULT NULL,
3275 `prov_status` varchar(20) DEFAULT NULL,
3276 `selflink` varchar(255) DEFAULT NULL,
3277 PRIMARY KEY (`tenant_id`,`vserver_id`)
3278 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3279 /*!40101 SET character_set_client = @saved_cs_client */;
3282 -- Table structure for table `VSERVER_PSERVER`
3285 DROP TABLE IF EXISTS `VSERVER_PSERVER`;
3286 /*!40101 SET @saved_cs_client = @@character_set_client */;
3287 /*!40101 SET character_set_client = utf8 */;
3288 CREATE TABLE `VSERVER_PSERVER` (
3289 `vserver_id` varchar(128) NOT NULL,
3290 `pserver_hostname` varchar(255) DEFAULT NULL,
3291 PRIMARY KEY (`vserver_id`)
3292 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3293 /*!40101 SET character_set_client = @saved_cs_client */;
3296 -- Table structure for table `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`
3299 DROP TABLE IF EXISTS `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`;
3300 /*!40101 SET @saved_cs_client = @@character_set_client */;
3301 /*!40101 SET character_set_client = utf8 */;
3302 CREATE TABLE `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING` (
3303 `key_id` varchar(128) NOT NULL,
3304 `cloud_region` varchar(128) NOT NULL,
3305 `key_type` varchar(128) NOT NULL,
3306 PRIMARY KEY (`key_id`,`cloud_region`,`key_type`)
3307 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3308 /*!40101 SET character_set_client = @saved_cs_client */;
3311 -- Table structure for table `WAN_COMBO_ALLOWABLE`
3314 DROP TABLE IF EXISTS `WAN_COMBO_ALLOWABLE`;
3315 /*!40101 SET @saved_cs_client = @@character_set_client */;
3316 /*!40101 SET character_set_client = utf8 */;
3317 CREATE TABLE `WAN_COMBO_ALLOWABLE` (
3318 `combo_sequence` int(11) NOT NULL AUTO_INCREMENT,
3319 `topology` varchar(16) DEFAULT 'unknown',
3320 `internet_topology` varchar(20) DEFAULT NULL,
3321 `wan1` varchar(40) DEFAULT NULL,
3322 `wan2` varchar(40) DEFAULT NULL,
3323 `new_start_release_flexware` varchar(16) DEFAULT 'unknown',
3324 `is_active_flexware` varchar(1) DEFAULT 'N',
3325 `new_start_release_dhv` varchar(16) DEFAULT 'unknown',
3326 `is_active_dhv` varchar(1) DEFAULT 'N',
3327 `ucpe_type` varchar(32) DEFAULT 'stand-alone',
3328 `description` varchar(128) NOT NULL,
3329 PRIMARY KEY (`combo_sequence`),
3330 UNIQUE KEY `IX1_WAN_COMBO_ALLOWABLE` (`internet_topology`,`wan1`,`wan2`)
3331 ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
3332 /*!40101 SET character_set_client = @saved_cs_client */;
3334 DROP TABLE IF EXISTS `DHCP_MAP`;
3335 /*!40101 SET @saved_cs_client = @@character_set_client */;
3336 /*!40101 SET character_set_client = utf8 */;
3337 CREATE TABLE `DHCP_MAP` (
3338 `mac_addr` varchar(128) NOT NULL,
3339 `ip_addr` varchar(128) DEFAULT NULL,
3340 PRIMARY KEY (`mac_addr`)
3341 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3343 DROP TABLE IF EXISTS `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING`;
3344 CREATE TABLE `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING` (
3345 `group_uuid` varchar(255) NOT NULL,
3346 `parent_uuid` varchar(255) NOT NULL,
3347 `target_node_uuid` varchar(255) NOT NULL,
3348 `target_type` varchar(255) NULL,
3349 `table_name` varchar(255) NULL,
3350 PRIMARY KEY (`group_uuid`, `parent_uuid`, `target_node_uuid`)
3351 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3353 /*!40101 SET character_set_client = @saved_cs_client */;
3354 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3356 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3357 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3358 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3359 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3360 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3361 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3362 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3364 DROP TABLE IF EXISTS `ATTRIBUTE_VALUE_PAIR`;
3365 CREATE TABLE `ATTRIBUTE_VALUE_PAIR` (
3366 `resource_uuid` varchar(255) NOT NULL,
3367 `attribute_name` varchar(255) NOT NULL,
3368 `resource_type` varchar(255) NOT NULL,
3369 `attribute_value` varchar(255) DEFAULT NULL,
3370 `resource_customization_uuid` varchar(255) DEFAULT NULL,
3371 PRIMARY KEY (`resource_uuid`,`attribute_name`,`resource_type`)
3372 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3374 DROP TABLE IF EXISTS `COMPLEX_RESOURCE`;
3375 CREATE TABLE `COMPLEX_RESOURCE` (
3376 `uuid` varchar(255) NOT NULL,
3377 `model_yaml` longblob,
3378 `invariant_uuid` varchar(255) NOT NULL,
3379 `customization_uuid` varchar(255) NOT NULL,
3380 `version` varchar(255) DEFAULT NULL,
3381 `name` varchar(255) DEFAULT NULL,
3382 `description` varchar(255) DEFAULT NULL,
3383 `type` varchar(255) NOT NULL,
3384 PRIMARY KEY (`uuid`,`customization_uuid`)
3385 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3387 DROP TABLE IF EXISTS `NODE_CAPABILITY`;
3388 CREATE TABLE `NODE_CAPABILITY` (
3389 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
3390 `capability_provider_uuid` varchar(255) NOT NULL,
3391 `capability_provider_customization_uuid` varchar(255) NOT NULL,
3392 `capability_name` varchar(255) DEFAULT NULL,
3393 `capability_type` varchar(255) DEFAULT NULL,
3394 PRIMARY KEY (`capability_id`)
3395 ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
3397 DROP TABLE IF EXISTS `NODE_REQUIREMENT`;
3398 CREATE TABLE `NODE_REQUIREMENT` (
3399 `requirement_id` int(11) NOT NULL AUTO_INCREMENT,
3400 `capability_id` int(11) DEFAULT NULL,
3401 `capability_provider_uuid` varchar(255) DEFAULT NULL,
3402 `capability_provider_customization_uuid` varchar(255) DEFAULT NULL,
3403 `capability_consumer_uuid` varchar(255) NOT NULL,
3404 `capability_consumer_customization_uuid` varchar(255) NOT NULL,
3405 `requirement_name` varchar(255) NOT NULL,
3406 PRIMARY KEY (`requirement_id`),
3407 KEY `NODE_REQUIREMENT_TO_NODE_CAPABILITY` (`capability_id`)
3408 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
3410 DROP TABLE IF EXISTS `RELATED_NETWORK_ROLE`;
3411 CREATE TABLE `RELATED_NETWORK_ROLE` (
3412 `network_model_customization_uuid` varchar(255) NOT NULL,
3413 `related_network_role` varchar(255) NOT NULL,
3414 PRIMARY KEY (`network_model_customization_uuid`,`related_network_role`)
3415 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3417 DROP TABLE IF EXISTS `RESOURCE_GROUP`;
3418 CREATE TABLE `RESOURCE_GROUP` (
3419 `resource_uuid` varchar(255) NOT NULL,
3420 `group_uuid` varchar(255) NOT NULL,
3421 `group_customization_uuid` varchar(255) DEFAULT NULL,
3422 `group_invariant_uuid` varchar(255) NOT NULL,
3423 `group_name` varchar(255) DEFAULT NULL,
3424 `version` varchar(255) DEFAULT NULL,
3425 `group_type` varchar(255) DEFAULT NULL,
3426 PRIMARY KEY (`resource_uuid`,`group_uuid`)
3427 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3429 DROP TABLE IF EXISTS `RESOURCE_POLICY`;
3430 CREATE TABLE `RESOURCE_POLICY` (
3431 `resource_uuid` varchar(255) NOT NULL,
3432 `policy_uuid` varchar(255) NOT NULL,
3433 `policy_customization_uuid` varchar(255) DEFAULT NULL,
3434 `policy_invariant_uuid` varchar(255) NOT NULL,
3435 `policy_name` varchar(255) DEFAULT NULL,
3436 `version` varchar(255) DEFAULT NULL,
3437 `policy_type` varchar(255) DEFAULT NULL,
3438 `property_type` varchar(255) DEFAULT NULL,
3439 `property_source` varchar(255) DEFAULT NULL,
3440 `property_name` varchar(255) DEFAULT NULL,
3441 PRIMARY KEY (`resource_uuid`,`policy_uuid`)
3442 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3444 DROP TABLE IF EXISTS `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING`;
3445 CREATE TABLE `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING` (
3446 `policy_uuid` varchar(255) NOT NULL,
3447 `parent_uuid` varchar(255) NOT NULL,
3448 `target_node_uuid` varchar(255) NOT NULL,
3449 `target_type` varchar(255) DEFAULT NULL,
3450 `target_node_customization_uuid` varchar(255) DEFAULT NULL,
3451 `policy_customization_uuid` varchar(255) DEFAULT NULL,
3452 PRIMARY KEY (`policy_uuid`,`parent_uuid`,`target_node_uuid`)
3453 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3456 DROP TABLE IF EXISTS `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING`;
3457 CREATE TABLE `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING` (
3458 `service_uuid` varchar(255) NOT NULL,
3459 `complex_resource_uuid` varchar(255) NOT NULL,
3460 `complex_resource_customization_uuid` varchar(255) NOT NULL,
3461 PRIMARY KEY (`service_uuid`,`complex_resource_uuid`,`complex_resource_customization_uuid`)
3462 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3464 DROP TABLE IF EXISTS `VFC_RELATED_NETWORK_ROLE`;
3465 CREATE TABLE `VFC_RELATED_NETWORK_ROLE` (
3466 `vfc_customization_uuid` varchar(255) NOT NULL,
3467 `vm_type` varchar(255) NOT NULL,
3468 `network_role` varchar(255) NOT NULL,
3469 `related_network_role` varchar(255) NOT NULL,
3470 PRIMARY KEY (`vfc_customization_uuid`,`vm_type`,`network_role`,`related_network_role`)
3471 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3473 DROP TABLE IF EXISTS `VNF_RELATED_NETWORK_ROLE`;
3474 CREATE TABLE `VNF_RELATED_NETWORK_ROLE` (
3475 `vnf_customization_uuid` varchar(255) NOT NULL,
3476 `network_role` varchar(255) NOT NULL,
3477 `related_network_role` varchar(255) NOT NULL,
3478 PRIMARY KEY (`vnf_customization_uuid`,`network_role`,`related_network_role`)
3479 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3481 -- Dump completed on 2017-10-04 18:23:01