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_PROGRESS`
1897 DROP TABLE IF EXISTS `REQUEST_PROGRESS`;
1898 /*!40101 SET @saved_cs_client = @@character_set_client */;
1899 /*!40101 SET character_set_client = utf8 */;
1900 CREATE TABLE `REQUEST_PROGRESS` (
1901 `request_id` int(11) NOT NULL AUTO_INCREMENT,
1902 `request_type` varchar(20) DEFAULT NULL,
1903 `service_instance_id` varchar(80) NOT NULL,
1904 `request_instance_type` varchar(20) NOT NULL,
1905 `originating_service_instance_id` varchar(80) DEFAULT NULL,
1906 `originating_service_type` varchar(20) DEFAULT NULL,
1907 `overall_status` varchar(20) DEFAULT NULL,
1908 `status_date` varchar(80) DEFAULT NULL,
1909 `message` varchar(255) DEFAULT NULL,
1910 PRIMARY KEY (`request_id`)
1911 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1912 /*!40101 SET character_set_client = @saved_cs_client */;
1915 -- Table structure for table `REQUEST_PROGRESS_STATE`
1918 DROP TABLE IF EXISTS `REQUEST_PROGRESS_STATE`;
1919 /*!40101 SET @saved_cs_client = @@character_set_client */;
1920 /*!40101 SET character_set_client = utf8 */;
1921 CREATE TABLE `REQUEST_PROGRESS_STATE` (
1922 `request_progress_state_id` int(11) NOT NULL AUTO_INCREMENT,
1923 `request_id` int(11) DEFAULT NULL,
1924 `service_instance_id` varchar(80) NOT NULL,
1925 `request_instance_type` varchar(20) NOT NULL,
1926 `progress_state` varchar(30) DEFAULT NULL,
1927 `transaction_status` varchar(20) DEFAULT NULL,
1928 `status_date` varchar(80) DEFAULT NULL,
1929 `response_code` varchar(20) DEFAULT NULL,
1930 `message` varchar(255) DEFAULT NULL,
1931 PRIMARY KEY (`request_progress_state_id`)
1932 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1933 /*!40101 SET character_set_client = @saved_cs_client */;
1936 -- Table structure for table `RESOURCE`
1939 DROP TABLE IF EXISTS `RESOURCE`;
1940 /*!40101 SET @saved_cs_client = @@character_set_client */;
1941 /*!40101 SET character_set_client = utf8 */;
1942 CREATE TABLE `RESOURCE` (
1943 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1944 `asset_id` varchar(100) NOT NULL,
1945 `resource_name` varchar(50) NOT NULL,
1946 `resource_type` enum('Limit','Label','Range') NOT NULL,
1947 `lt_used` bigint(20) DEFAULT NULL,
1948 `ll_label` varchar(50) DEFAULT NULL,
1949 `ll_reference_count` smallint(6) DEFAULT NULL,
1950 `rr_used` varchar(4000) DEFAULT NULL,
1951 PRIMARY KEY (`resource_id`),
1952 UNIQUE KEY `resource_id` (`resource_id`),
1953 UNIQUE KEY `IX1_RESOURCE` (`asset_id`,`resource_name`)
1954 ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;
1955 /*!40101 SET character_set_client = @saved_cs_client */;
1958 -- Table structure for table `RESOURCE_LOAD`
1961 DROP TABLE IF EXISTS `RESOURCE_LOAD`;
1962 /*!40101 SET @saved_cs_client = @@character_set_client */;
1963 /*!40101 SET character_set_client = utf8 */;
1964 CREATE TABLE `RESOURCE_LOAD` (
1965 `resource_load_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1966 `resource_id` bigint(20) NOT NULL,
1967 `application_id` varchar(20) NOT NULL,
1968 `resource_load_time` datetime NOT NULL,
1969 `resource_expiration_time` datetime DEFAULT NULL,
1970 PRIMARY KEY (`resource_load_id`),
1971 UNIQUE KEY `resource_load_id` (`resource_load_id`),
1972 UNIQUE KEY `IX2_RESOURCE_LOAD` (`resource_id`,`application_id`),
1973 KEY `IX1_RESOURCE_LOAD` (`resource_id`)
1974 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1975 /*!40101 SET character_set_client = @saved_cs_client */;
1978 -- Table structure for table `RESOURCE_LOCK`
1981 DROP TABLE IF EXISTS `RESOURCE_LOCK`;
1982 /*!40101 SET @saved_cs_client = @@character_set_client */;
1983 /*!40101 SET character_set_client = utf8 */;
1984 CREATE TABLE `RESOURCE_LOCK` (
1985 `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1986 `resource_name` varchar(256) DEFAULT NULL,
1987 `lock_holder` varchar(100) NOT NULL,
1988 `lock_count` smallint(6) NOT NULL,
1989 `lock_time` datetime NOT NULL,
1990 `expiration_time` datetime NOT NULL,
1991 PRIMARY KEY (`resource_lock_id`),
1992 UNIQUE KEY `resource_lock_id` (`resource_lock_id`),
1993 UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`)
1994 ) ENGINE=InnoDB AUTO_INCREMENT=29681 DEFAULT CHARSET=latin1;
1995 /*!40101 SET character_set_client = @saved_cs_client */;
1998 -- Table structure for table `RESOURCE_RULE`
2001 DROP TABLE IF EXISTS `RESOURCE_RULE`;
2002 /*!40101 SET @saved_cs_client = @@character_set_client */;
2003 /*!40101 SET character_set_client = utf8 */;
2004 CREATE TABLE `RESOURCE_RULE` (
2005 `resource_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2006 `resource_name` varchar(50) NOT NULL,
2007 `service_model` varchar(50) NOT NULL,
2008 `end_point_position` varchar(50) NOT NULL,
2009 `service_expression` varchar(2000) NOT NULL,
2010 `equipment_level` varchar(50) NOT NULL,
2011 `equipment_expression` varchar(2000) NOT NULL,
2012 `allocation_expression` varchar(2000) NOT NULL,
2013 `soft_limit_expression` varchar(2000) NOT NULL,
2014 `hard_limit_expression` varchar(2000) NOT NULL,
2015 PRIMARY KEY (`resource_rule_id`),
2016 UNIQUE KEY `resource_rule_id` (`resource_rule_id`)
2017 ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
2018 /*!40101 SET character_set_client = @saved_cs_client */;
2021 -- Table structure for table `RESOURCE_THRESHOLD`
2024 DROP TABLE IF EXISTS `RESOURCE_THRESHOLD`;
2025 /*!40101 SET @saved_cs_client = @@character_set_client */;
2026 /*!40101 SET character_set_client = utf8 */;
2027 CREATE TABLE `RESOURCE_THRESHOLD` (
2028 `resource_threshold_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2029 `resource_rule_id` bigint(20) NOT NULL,
2030 `threshold_expression` varchar(2000) NOT NULL,
2031 `threshold_message` varchar(2000) NOT NULL,
2032 PRIMARY KEY (`resource_threshold_id`)
2033 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2034 /*!40101 SET character_set_client = @saved_cs_client */;
2037 -- Table structure for table `ROUTER_MASTER`
2040 DROP TABLE IF EXISTS `ROUTER_MASTER`;
2041 /*!40101 SET @saved_cs_client = @@character_set_client */;
2042 /*!40101 SET character_set_client = utf8 */;
2043 CREATE TABLE `ROUTER_MASTER` (
2044 `crs_name` varchar(20) NOT NULL,
2045 `loopback_ip` varchar(20) NOT NULL,
2046 PRIMARY KEY (`crs_name`)
2047 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2048 /*!40101 SET character_set_client = @saved_cs_client */;
2051 -- Table structure for table `ROUTING_CHARACTERISTIC_MAPPING`
2054 DROP TABLE IF EXISTS `ROUTING_CHARACTERISTIC_MAPPING`;
2055 /*!40101 SET @saved_cs_client = @@character_set_client */;
2056 /*!40101 SET character_set_client = utf8 */;
2057 CREATE TABLE `ROUTING_CHARACTERISTIC_MAPPING` (
2058 `network_role` varchar(255) NOT NULL,
2059 `vrf_name` varchar(255) NOT NULL,
2060 `routing_characteristic` varchar(255) NOT NULL,
2061 PRIMARY KEY (`network_role`,`vrf_name`)
2062 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2063 /*!40101 SET character_set_client = @saved_cs_client */;
2066 -- Table structure for table `SERVICE_HOMING`
2069 DROP TABLE IF EXISTS `SERVICE_HOMING`;
2070 /*!40101 SET @saved_cs_client = @@character_set_client */;
2071 /*!40101 SET character_set_client = utf8 */;
2072 CREATE TABLE `SERVICE_HOMING` (
2073 `service_type` varchar(100) NOT NULL,
2074 `lata` int(3) NOT NULL,
2075 `hubbing_city_type` varchar(40) NOT NULL,
2076 `latitude` float DEFAULT NULL,
2077 `longitude` float DEFAULT NULL,
2078 `primary_aic_site_name` varchar(100) NOT NULL,
2079 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2080 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2081 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2082 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2083 /*!40101 SET character_set_client = @saved_cs_client */;
2086 -- Table structure for table `SERVICE_HOMING_BACKUP`
2089 DROP TABLE IF EXISTS `SERVICE_HOMING_BACKUP`;
2090 /*!40101 SET @saved_cs_client = @@character_set_client */;
2091 /*!40101 SET character_set_client = utf8 */;
2092 CREATE TABLE `SERVICE_HOMING_BACKUP` (
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_INSTANCE_NAME_INDEX`
2109 DROP TABLE IF EXISTS `SERVICE_INSTANCE_NAME_INDEX`;
2110 /*!40101 SET @saved_cs_client = @@character_set_client */;
2111 /*!40101 SET character_set_client = utf8 */;
2112 CREATE TABLE `SERVICE_INSTANCE_NAME_INDEX` (
2113 `service_instance_name_prefix` varchar(255) NOT NULL,
2114 `index_number` int(11) NOT NULL,
2115 PRIMARY KEY (`service_instance_name_prefix`)
2116 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2117 /*!40101 SET character_set_client = @saved_cs_client */;
2120 -- Table structure for table `SERVICE_MANAGER_CREDENTIALS`
2123 DROP TABLE IF EXISTS `SERVICE_MANAGER_CREDENTIALS`;
2124 /*!40101 SET @saved_cs_client = @@character_set_client */;
2125 /*!40101 SET character_set_client = utf8 */;
2126 CREATE TABLE `SERVICE_MANAGER_CREDENTIALS` (
2127 `service_manager_username` varchar(255) NOT NULL,
2128 `service_manager_password` varbinary(255) NOT NULL,
2129 PRIMARY KEY (`service_manager_username`)
2130 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2131 /*!40101 SET character_set_client = @saved_cs_client */;
2134 -- Table structure for table `SERVICE_MODEL`
2137 DROP TABLE IF EXISTS `SERVICE_MODEL`;
2138 /*!40101 SET @saved_cs_client = @@character_set_client */;
2139 /*!40101 SET character_set_client = utf8 */;
2140 CREATE TABLE `SERVICE_MODEL` (
2141 `service_uuid` varchar(255) NOT NULL,
2142 `model_yaml` longblob,
2143 `invariant_uuid` varchar(255) DEFAULT NULL,
2144 `version` varchar(255) DEFAULT NULL,
2145 `name` varchar(255) DEFAULT NULL,
2146 `description` varchar(1024) DEFAULT NULL,
2147 `type` varchar(255) DEFAULT NULL,
2148 `category` varchar(255) DEFAULT NULL,
2149 `ecomp_naming` char(1) DEFAULT NULL,
2150 `service_instance_name_prefix` varchar(255) DEFAULT NULL,
2151 `filename` varchar(100) DEFAULT NULL,
2152 `naming_policy` varchar(255) DEFAULT NULL,
2153 PRIMARY KEY (`service_uuid`)
2154 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2155 /*!40101 SET character_set_client = @saved_cs_client */;
2158 -- Table structure for table `SERVICE_PROXY`
2161 DROP TABLE IF EXISTS `SERVICE_PROXY`;
2162 /*!40101 SET @saved_cs_client = @@character_set_client */;
2163 /*!40101 SET character_set_client = utf8 */;
2164 CREATE TABLE `SERVICE_PROXY` (
2165 `port_mirror_service_uuid` varchar(255) NOT NULL,
2166 `service_proxy_name` varchar(255) NOT NULL,
2167 `source_service_uuid` varchar(255) NOT NULL,
2168 `resources_vendor` varchar(255) DEFAULT NULL,
2169 `resource_vendor_release` varchar(255) DEFAULT NULL,
2170 `description` varchar(255) DEFAULT NULL,
2171 `category` varchar(255) DEFAULT NULL,
2172 `subcategory` varchar(255) DEFAULT NULL,
2173 `version` varchar(255) DEFAULT NULL,
2174 `role` varchar(255) NOT NULL,
2175 `uuid` varchar(255) DEFAULT NULL,
2176 `customization_uuid` varchar(255) DEFAULT NULL,
2177 `invariant_uuid` varchar(255) DEFAULT NULL,
2178 PRIMARY KEY (`port_mirror_service_uuid`,`service_proxy_name`),
2179 KEY `FK_SERVICE_PROXY_SOURCE_TO_SERVICE_MODE` (`source_service_uuid`),
2180 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
2181 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2182 /*!40101 SET character_set_client = @saved_cs_client */;
2185 -- Table structure for table `SERVICE_RESOURCE`
2188 DROP TABLE IF EXISTS `SERVICE_RESOURCE`;
2189 /*!40101 SET @saved_cs_client = @@character_set_client */;
2190 /*!40101 SET character_set_client = utf8 */;
2191 CREATE TABLE `SERVICE_RESOURCE` (
2192 `service_resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2193 `service_instance_id` varchar(80) NOT NULL,
2194 `service_status` enum('Active','Pending') NOT NULL,
2195 `service_change_number` smallint(6) NOT NULL,
2196 `resource_set_id` varchar(100) NOT NULL,
2197 `resource_union_id` varchar(100) NOT NULL,
2198 PRIMARY KEY (`service_instance_id`,`service_change_number`),
2199 UNIQUE KEY `service_resource_id` (`service_resource_id`),
2200 KEY `IX1_SERVICE_RESOURCE` (`service_instance_id`)
2201 ) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=latin1;
2202 /*!40101 SET character_set_client = @saved_cs_client */;
2205 -- Table structure for table `SERVICE_TYPE_MAPPING`
2208 DROP TABLE IF EXISTS `SERVICE_TYPE_MAPPING`;
2209 /*!40101 SET @saved_cs_client = @@character_set_client */;
2210 /*!40101 SET character_set_client = utf8 */;
2211 CREATE TABLE `SERVICE_TYPE_MAPPING` (
2212 `sdnc_service_type` varchar(128) NOT NULL,
2213 `ncs_service_type` varchar(128) NOT NULL,
2214 PRIMARY KEY (`sdnc_service_type`,`ncs_service_type`)
2215 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2216 /*!40101 SET character_set_client = @saved_cs_client */;
2219 -- Table structure for table `SUBNETPOOL_MAPPING`
2222 DROP TABLE IF EXISTS `SUBNETPOOL_MAPPING`;
2223 /*!40101 SET @saved_cs_client = @@character_set_client */;
2224 /*!40101 SET character_set_client = utf8 */;
2225 CREATE TABLE `SUBNETPOOL_MAPPING` (
2226 `aic_cloud_region` varchar(16) NOT NULL,
2227 `ntc` varchar(32) NOT NULL,
2228 `lcp` varchar(32) NOT NULL,
2229 `aic_region_id` varchar(255) NOT NULL,
2230 PRIMARY KEY (`aic_cloud_region`)
2231 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2232 /*!40101 SET character_set_client = @saved_cs_client */;
2235 -- Table structure for table `SUPPORTED_SEQUENCE_NUMBER`
2238 DROP TABLE IF EXISTS `SUPPORTED_SEQUENCE_NUMBER`;
2239 /*!40101 SET @saved_cs_client = @@character_set_client */;
2240 /*!40101 SET character_set_client = utf8 */;
2241 CREATE TABLE `SUPPORTED_SEQUENCE_NUMBER` (
2242 `resource_sequence_number` varchar(10) NOT NULL,
2243 `resource_type` varchar(10) NOT NULL,
2244 PRIMARY KEY (`resource_sequence_number`,`resource_type`)
2245 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2246 /*!40101 SET character_set_client = @saved_cs_client */;
2249 -- Table structure for table `SVC_LOGIC`
2252 DROP TABLE IF EXISTS `SVC_LOGIC`;
2253 /*!40101 SET @saved_cs_client = @@character_set_client */;
2254 /*!40101 SET character_set_client = utf8 */;
2255 CREATE TABLE `SVC_LOGIC` (
2256 `module` varchar(80) NOT NULL,
2257 `rpc` varchar(80) NOT NULL,
2258 `version` varchar(40) NOT NULL,
2259 `mode` varchar(5) NOT NULL,
2260 `active` varchar(1) NOT NULL,
2262 `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2263 `md5sum` varchar(128) DEFAULT NULL,
2264 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
2265 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2266 /*!40101 SET character_set_client = @saved_cs_client */;
2269 -- Table structure for table `TABLE_CLEANUP_CONFIGURATION`
2272 DROP TABLE IF EXISTS `TABLE_CLEANUP_CONFIGURATION`;
2273 /*!40101 SET @saved_cs_client = @@character_set_client */;
2274 /*!40101 SET character_set_client = utf8 */;
2275 CREATE TABLE `TABLE_CLEANUP_CONFIGURATION` (
2276 `table_name` varchar(255) NOT NULL COMMENT 'The name of the table the cleanup will be performed on',
2277 `days_old` int(11) NOT NULL COMMENT 'Records older than the current date minus DAYS_OLD will be deleted',
2278 `date_column` varchar(255) NOT NULL COMMENT 'The name of the column containing the date to be checked',
2279 `commit_interval` int(11) NOT NULL DEFAULT '2500' COMMENT 'The maximum number of rows a commit may contain',
2280 `query_clause` varchar(1000) DEFAULT NULL COMMENT 'An optional additional query clause to further restrict deletion criteria',
2281 `child_table_name` varchar(255) DEFAULT NULL,
2282 `child_table_pk` varchar(255) DEFAULT NULL,
2283 PRIMARY KEY (`table_name`)
2284 ) 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.';
2285 /*!40101 SET character_set_client = @saved_cs_client */;
2288 -- Table structure for table `TASK_TEMPLATE`
2291 DROP TABLE IF EXISTS `TASK_TEMPLATE`;
2292 /*!40101 SET @saved_cs_client = @@character_set_client */;
2293 /*!40101 SET character_set_client = utf8 */;
2294 CREATE TABLE `TASK_TEMPLATE` (
2295 `task_template_id` int(11) NOT NULL AUTO_INCREMENT,
2296 `request_type` varchar(20) DEFAULT NULL,
2297 `task_name` varchar(30) NOT NULL,
2298 `task_category` varchar(50) NOT NULL,
2299 `ecomp_task` varchar(50) NOT NULL,
2300 `initial_load` varchar(1) NOT NULL,
2301 `service` varchar(20) DEFAULT NULL,
2302 PRIMARY KEY (`task_template_id`)
2303 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2304 /*!40101 SET character_set_client = @saved_cs_client */;
2307 -- Table structure for table `TENANT`
2310 DROP TABLE IF EXISTS `TENANT`;
2311 /*!40101 SET @saved_cs_client = @@character_set_client */;
2312 /*!40101 SET character_set_client = utf8 */;
2313 CREATE TABLE `TENANT` (
2314 `tenant_id` varchar(255) NOT NULL,
2315 `tenant_name` varchar(255) NOT NULL,
2316 `service_instance_id` varchar(255) NOT NULL,
2317 PRIMARY KEY (`tenant_id`,`tenant_name`)
2318 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2319 /*!40101 SET character_set_client = @saved_cs_client */;
2322 -- Table structure for table `TESTTBL`
2325 DROP TABLE IF EXISTS `TESTTBL`;
2326 /*!40101 SET @saved_cs_client = @@character_set_client */;
2327 /*!40101 SET character_set_client = utf8 */;
2328 CREATE TABLE `TESTTBL` (
2329 `pk` varchar(25) NOT NULL,
2330 `col1` varchar(25) DEFAULT NULL
2331 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2332 /*!40101 SET character_set_client = @saved_cs_client */;
2335 -- Table structure for table `THRESHOLD_NOTIFICATION`
2338 DROP TABLE IF EXISTS `THRESHOLD_NOTIFICATION`;
2339 /*!40101 SET @saved_cs_client = @@character_set_client */;
2340 /*!40101 SET character_set_client = utf8 */;
2341 CREATE TABLE `THRESHOLD_NOTIFICATION` (
2342 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2343 `threshold_expression` varchar(2000) DEFAULT NULL,
2344 `threshold_message` varchar(500) DEFAULT NULL,
2345 PRIMARY KEY (`resource_id`)
2346 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2347 /*!40101 SET character_set_client = @saved_cs_client */;
2350 -- Table structure for table `TMP_AIC_AVAIL_ZONE_POOL`
2353 DROP TABLE IF EXISTS `TMP_AIC_AVAIL_ZONE_POOL`;
2354 /*!40101 SET @saved_cs_client = @@character_set_client */;
2355 /*!40101 SET character_set_client = utf8 */;
2356 CREATE TABLE `TMP_AIC_AVAIL_ZONE_POOL` (
2357 `aic_site_id` varchar(100) NOT NULL,
2358 `status` varchar(40) NOT NULL,
2359 `availability_zone` varchar(100) NOT NULL,
2360 `token` int(4) NOT NULL,
2361 `vnf_id` varchar(80) DEFAULT NULL,
2362 `service_type` varchar(100) NOT NULL,
2363 `vnf_type` varchar(20) DEFAULT NULL,
2364 `hypervisor` varchar(10) DEFAULT NULL,
2365 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
2366 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2367 /*!40101 SET character_set_client = @saved_cs_client */;
2370 -- Table structure for table `TOPOLOGY_PARAMETER`
2373 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER`;
2374 /*!40101 SET @saved_cs_client = @@character_set_client */;
2375 /*!40101 SET character_set_client = utf8 */;
2376 CREATE TABLE `TOPOLOGY_PARAMETER` (
2377 `parameter_id` int(11) NOT NULL,
2378 `parameter_name` varchar(20) NOT NULL,
2379 `parameter_set` int(11) NOT NULL,
2380 `create_update_time` datetime NOT NULL,
2381 `create_update_user` varchar(40) NOT NULL,
2382 PRIMARY KEY (`parameter_id`)
2383 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2384 /*!40101 SET character_set_client = @saved_cs_client */;
2387 -- Table structure for table `TOPOLOGY_PARAMETER_ENTRIES`
2390 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_ENTRIES`;
2391 /*!40101 SET @saved_cs_client = @@character_set_client */;
2392 /*!40101 SET character_set_client = utf8 */;
2393 CREATE TABLE `TOPOLOGY_PARAMETER_ENTRIES` (
2394 `parameter_entry_id` int(11) NOT NULL,
2395 `parameter_name` varchar(255) NOT NULL,
2396 `parameter_value` varchar(64) NOT NULL,
2397 `create_update_time` datetime NOT NULL,
2398 `create_update_user` varchar(40) NOT NULL,
2399 PRIMARY KEY (`parameter_entry_id`)
2400 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2401 /*!40101 SET character_set_client = @saved_cs_client */;
2404 -- Table structure for table `TOPOLOGY_PARAMETER_TO_ENTRIES`
2407 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_TO_ENTRIES`;
2408 /*!40101 SET @saved_cs_client = @@character_set_client */;
2409 /*!40101 SET character_set_client = utf8 */;
2410 CREATE TABLE `TOPOLOGY_PARAMETER_TO_ENTRIES` (
2411 `parameter_id` int(11) DEFAULT NULL,
2412 `parameter_entry_id` int(11) DEFAULT NULL,
2413 `entry_order` int(11) DEFAULT NULL,
2414 `create_update_time` datetime DEFAULT NULL,
2415 `create_update_user` varchar(40) NOT NULL,
2416 KEY `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_id`),
2417 KEY `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_entry_id`),
2418 CONSTRAINT `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_id`) REFERENCES `TOPOLOGY_PARAMETER` (`parameter_id`),
2419 CONSTRAINT `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_entry_id`) REFERENCES `TOPOLOGY_PARAMETER_ENTRIES` (`parameter_entry_id`)
2420 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2421 /*!40101 SET character_set_client = @saved_cs_client */;
2424 -- Table structure for table `TRANSACTION_LOG`
2427 DROP TABLE IF EXISTS `TRANSACTION_LOG`;
2428 /*!40101 SET @saved_cs_client = @@character_set_client */;
2429 /*!40101 SET character_set_client = utf8 */;
2430 CREATE TABLE `TRANSACTION_LOG` (
2431 `serial_key` int(10) NOT NULL AUTO_INCREMENT,
2432 `log_time` varchar(40) NOT NULL,
2433 `request_id` varchar(80) DEFAULT NULL,
2434 `svc_request_id` varchar(80) DEFAULT NULL,
2435 `x_ecomp_request_id` varchar(80) DEFAULT NULL,
2436 `graph_name` varchar(255) DEFAULT NULL,
2437 PRIMARY KEY (`serial_key`)
2438 ) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;
2439 /*!40101 SET character_set_client = @saved_cs_client */;
2443 -- Table structure for table `UPLOAD_CONFIG`
2446 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
2447 /*!40101 SET @saved_cs_client = @@character_set_client */;
2448 /*!40101 SET character_set_client = utf8 */;
2449 CREATE TABLE `UPLOAD_CONFIG` (
2450 `upload_config_id` int(11) NOT NULL AUTO_INCREMENT,
2451 `request_id` varchar(50) DEFAULT NULL,
2452 `originator_id` varchar(50) DEFAULT NULL,
2453 `service_description` varchar(100) DEFAULT NULL,
2454 `action` varchar(50) DEFAULT NULL,
2455 `upload_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
2456 `vnf_id` varchar(50) DEFAULT NULL,
2457 `vnf_name` varchar(50) DEFAULT NULL,
2458 `vm_name` varchar(50) DEFAULT NULL,
2459 `vnf_type` varchar(50) DEFAULT NULL,
2460 `vnfc_type` varchar(50) DEFAULT NULL,
2461 `host_ip_address` varchar(50) DEFAULT NULL,
2462 `config_indicator` varchar(25) DEFAULT NULL,
2463 `pending_delete` varchar(1) DEFAULT NULL,
2465 PRIMARY KEY (`upload_config_id`),
2466 UNIQUE KEY `upload_config_id` (`upload_config_id`)
2467 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2468 /*!40101 SET character_set_client = @saved_cs_client */;
2471 -- Table structure for table `USED_SEQUENCE_NUMBER`
2474 DROP TABLE IF EXISTS `USED_SEQUENCE_NUMBER`;
2475 /*!40101 SET @saved_cs_client = @@character_set_client */;
2476 /*!40101 SET character_set_client = utf8 */;
2477 CREATE TABLE `USED_SEQUENCE_NUMBER` (
2478 `resource_sequence_number` varchar(10) NOT NULL,
2479 `resource_type` varchar(10) NOT NULL,
2480 `zone_region_id` varchar(50) NOT NULL,
2481 PRIMARY KEY (`resource_sequence_number`,`resource_type`,`zone_region_id`)
2482 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2483 /*!40101 SET character_set_client = @saved_cs_client */;
2486 -- Table structure for table `USER_TRACE`
2489 DROP TABLE IF EXISTS `USER_TRACE`;
2490 /*!40101 SET @saved_cs_client = @@character_set_client */;
2491 /*!40101 SET character_set_client = utf8 */;
2492 CREATE TABLE `USER_TRACE` (
2493 `user_trace_seq` int(11) NOT NULL AUTO_INCREMENT,
2494 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2495 `identity` varchar(12) DEFAULT NULL,
2496 `action` varchar(128) DEFAULT NULL,
2497 `description` varchar(256) DEFAULT NULL,
2498 PRIMARY KEY (`user_trace_seq`)
2499 ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=latin1;
2500 /*!40101 SET character_set_client = @saved_cs_client */;
2503 -- Table structure for table `VENDOR_CODE`
2506 DROP TABLE IF EXISTS `VENDOR_CODE`;
2507 /*!40101 SET @saved_cs_client = @@character_set_client */;
2508 /*!40101 SET character_set_client = utf8 */;
2509 CREATE TABLE `VENDOR_CODE` (
2510 `vendor_code` varchar(1) NOT NULL,
2511 `vendor` varchar(45) NOT NULL DEFAULT '',
2512 PRIMARY KEY (`vendor_code`,`vendor`)
2513 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2514 /*!40101 SET character_set_client = @saved_cs_client */;
2517 -- Table structure for table `VFC_MODEL`
2520 DROP TABLE IF EXISTS `VFC_MODEL`;
2521 /*!40101 SET @saved_cs_client = @@character_set_client */;
2522 /*!40101 SET character_set_client = utf8 */;
2523 CREATE TABLE `VFC_MODEL` (
2524 `customization_uuid` varchar(255) NOT NULL,
2525 `model_yaml` longblob,
2526 `invariant_uuid` varchar(255) DEFAULT NULL,
2527 `uuid` varchar(255) DEFAULT NULL,
2528 `version` varchar(255) DEFAULT NULL,
2529 `naming_policy` varchar(255) DEFAULT NULL,
2530 `ecomp_generated_naming` char(1) DEFAULT NULL,
2531 `nfc_function` varchar(255) DEFAULT NULL,
2532 `nfc_naming_code` varchar(255) DEFAULT NULL,
2533 `vm_type` varchar(255) DEFAULT NULL,
2534 `vm_type_tag` varchar(255) DEFAULT NULL,
2535 `vm_image_name` varchar(255) DEFAULT NULL,
2536 `vm_flavor_name` varchar(255) DEFAULT NULL,
2537 `high_availability` varchar(255) DEFAULT NULL,
2538 `nfc_naming` varchar(255) DEFAULT NULL,
2539 `min_instances` int(11) DEFAULT NULL,
2540 `max_instances` int(11) DEFAULT NULL,
2541 PRIMARY KEY (`customization_uuid`)
2542 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2543 /*!40101 SET character_set_client = @saved_cs_client */;
2546 -- Table structure for table `VFC_TO_NETWORK_ROLE_MAPPING`
2549 DROP TABLE IF EXISTS `VFC_TO_NETWORK_ROLE_MAPPING`;
2550 /*!40101 SET @saved_cs_client = @@character_set_client */;
2551 /*!40101 SET character_set_client = utf8 */;
2552 CREATE TABLE `VFC_TO_NETWORK_ROLE_MAPPING` (
2553 `seq` int(11) NOT NULL AUTO_INCREMENT,
2554 `vfc_customization_uuid` varchar(255) NOT NULL,
2555 `network_role` varchar(255) NOT NULL,
2556 `vm_type` varchar(255) DEFAULT NULL,
2557 `network_role_tag` varchar(255) DEFAULT NULL,
2558 `ipv4_count` int(11) NOT NULL,
2559 `ipv6_count` int(11) NOT NULL,
2560 `ipv4_use_dhcp` char(1) DEFAULT NULL,
2561 `ipv6_use_dhcp` char(1) DEFAULT NULL,
2562 `ipv4_ip_version` char(1) DEFAULT NULL,
2563 `ipv6_ip_version` char(1) DEFAULT NULL,
2564 `extcp_subnetpool_id` varchar(512) DEFAULT NULL,
2565 `ipv4_floating_count` int(11) DEFAULT NULL,
2566 `ipv6_floating_count` int(11) DEFAULT NULL,
2567 `ipv4_address_plan_name` varchar(512) DEFAULT NULL,
2568 `ipv6_address_plan_name` varchar(512) DEFAULT NULL,
2569 `ipv4_vrf_name` varchar(512) DEFAULT NULL,
2570 `ipv6_vrf_name` varchar(512) DEFAULT NULL,
2571 `subnet_role` varchar(255) DEFAULT NULL,
2572 `subinterface_indicator` char(1) DEFAULT NULL,
2573 PRIMARY KEY (`seq`),
2574 KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`)
2575 ) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1;
2576 /*!40101 SET character_set_client = @saved_cs_client */;
2579 -- Table structure for table `VF_MODEL`
2582 DROP TABLE IF EXISTS `VF_MODEL`;
2583 /*!40101 SET @saved_cs_client = @@character_set_client */;
2584 /*!40101 SET character_set_client = utf8 */;
2585 CREATE TABLE `VF_MODEL` (
2586 `customization_uuid` varchar(255) NOT NULL,
2587 `model_yaml` longblob,
2588 `invariant_uuid` varchar(255) DEFAULT NULL,
2589 `uuid` varchar(255) DEFAULT NULL,
2590 `version` varchar(255) DEFAULT NULL,
2591 `name` varchar(255) DEFAULT NULL,
2592 `naming_policy` varchar(255) DEFAULT NULL,
2593 `ecomp_generated_naming` char(1) DEFAULT NULL,
2594 `avail_zone_max_count` int(11) DEFAULT NULL,
2595 `nf_function` varchar(255) DEFAULT NULL,
2596 `nf_code` varchar(255) DEFAULT NULL,
2597 `nf_type` varchar(255) DEFAULT NULL,
2598 `nf_role` varchar(255) DEFAULT NULL,
2599 `vendor` varchar(255) DEFAULT NULL,
2600 `vendor_version` varchar(255) DEFAULT NULL,
2601 PRIMARY KEY (`customization_uuid`)
2602 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2603 /*!40101 SET character_set_client = @saved_cs_client */;
2606 -- Table structure for table `VF_MODULE_MODEL`
2609 DROP TABLE IF EXISTS `VF_MODULE_MODEL`;
2610 /*!40101 SET @saved_cs_client = @@character_set_client */;
2611 /*!40101 SET character_set_client = utf8 */;
2612 CREATE TABLE `VF_MODULE_MODEL` (
2613 `customization_uuid` varchar(255) NOT NULL,
2614 `model_yaml` longblob,
2615 `invariant_uuid` varchar(255) DEFAULT NULL,
2616 `uuid` varchar(255) DEFAULT NULL,
2617 `version` varchar(255) DEFAULT NULL,
2618 `vf_module_type` varchar(255) DEFAULT NULL,
2619 `availability_zone_count` int(11) DEFAULT NULL,
2620 `ecomp_generated_vm_assignments` char(1) DEFAULT NULL,
2621 PRIMARY KEY (`customization_uuid`)
2622 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2623 /*!40101 SET character_set_client = @saved_cs_client */;
2626 -- Table structure for table `VF_MODULE_TO_VFC_MAPPING`
2629 DROP TABLE IF EXISTS `VF_MODULE_TO_VFC_MAPPING`;
2630 /*!40101 SET @saved_cs_client = @@character_set_client */;
2631 /*!40101 SET character_set_client = utf8 */;
2632 CREATE TABLE `VF_MODULE_TO_VFC_MAPPING` (
2633 `seq` int(11) NOT NULL AUTO_INCREMENT,
2634 `vf_module_customization_uuid` varchar(255) NOT NULL,
2635 `vfc_customization_uuid` varchar(255) NOT NULL,
2636 `vm_type` varchar(255) NOT NULL,
2637 `vm_count` int(11) NOT NULL,
2638 PRIMARY KEY (`seq`),
2639 KEY `IX1_VF_MODULE_TO_VFC_MAPPING` (`vf_module_customization_uuid`)
2640 ) ENGINE=InnoDB AUTO_INCREMENT=1591 DEFAULT CHARSET=latin1;
2641 /*!40101 SET character_set_client = @saved_cs_client */;
2644 -- Table structure for table `VF_TO_NETWORK_ROLE_MAPPING`
2647 DROP TABLE IF EXISTS `VF_TO_NETWORK_ROLE_MAPPING`;
2648 /*!40101 SET @saved_cs_client = @@character_set_client */;
2649 /*!40101 SET character_set_client = utf8 */;
2650 CREATE TABLE `VF_TO_NETWORK_ROLE_MAPPING` (
2651 `seq` int(11) NOT NULL AUTO_INCREMENT,
2652 `vf_customization_uuid` varchar(255) NOT NULL,
2653 `network_role` varchar(255) NOT NULL,
2654 PRIMARY KEY (`seq`),
2655 KEY `IX1_VF_TO_NETWORK_ROLE_MAPPING` (`vf_customization_uuid`)
2656 ) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=latin1;
2657 /*!40101 SET character_set_client = @saved_cs_client */;
2660 -- Table structure for table `VIPR_CONFIGURATION`
2663 DROP TABLE IF EXISTS `VIPR_CONFIGURATION`;
2664 /*!40101 SET @saved_cs_client = @@character_set_client */;
2665 /*!40101 SET character_set_client = utf8 */;
2666 CREATE TABLE `VIPR_CONFIGURATION` (
2667 `seq` int(11) NOT NULL AUTO_INCREMENT,
2668 `serial_number` varchar(255) DEFAULT NULL,
2669 `vnf_id` varchar(255) DEFAULT NULL,
2670 `vnf_name` varchar(255) DEFAULT NULL,
2671 `ecomp_service_instance_id` varchar(255) DEFAULT NULL,
2672 `vm_name` varchar(255) DEFAULT NULL,
2673 `cloud_region_id` varchar(255) DEFAULT NULL,
2674 `cloud_owner` varchar(255) DEFAULT NULL,
2676 ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
2677 /*!40101 SET character_set_client = @saved_cs_client */;
2680 -- Table structure for table `VIPR_SZ_MANAGER_KEY`
2683 DROP TABLE IF EXISTS `VIPR_SZ_MANAGER_KEY`;
2684 /*!40101 SET @saved_cs_client = @@character_set_client */;
2685 /*!40101 SET character_set_client = utf8 */;
2686 CREATE TABLE `VIPR_SZ_MANAGER_KEY` (
2687 `vipr_sz_manager_ip_addr` varchar(40) NOT NULL,
2688 `vipr_sz_manager_state` varchar(10) DEFAULT NULL,
2689 `vipr_sz_manager_api_key` varchar(255) DEFAULT NULL,
2690 PRIMARY KEY (`vipr_sz_manager_ip_addr`)
2691 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2692 /*!40101 SET character_set_client = @saved_cs_client */;
2695 -- Table structure for table `VLAN_ID_POOL`
2698 DROP TABLE IF EXISTS `VLAN_ID_POOL`;
2699 /*!40101 SET @saved_cs_client = @@character_set_client */;
2700 /*!40101 SET character_set_client = utf8 */;
2701 CREATE TABLE `VLAN_ID_POOL` (
2702 `aic_site_id` varchar(100) NOT NULL,
2703 `purpose` varchar(40) NOT NULL,
2704 `status` varchar(40) NOT NULL,
2705 `vlan_id` int(4) NOT NULL,
2706 `svc_instance_id` varchar(80) DEFAULT NULL,
2707 `availability_zone` varchar(100) DEFAULT NULL,
2708 `vplspe_name` varchar(80) DEFAULT NULL,
2709 PRIMARY KEY (`vlan_id`,`aic_site_id`,`purpose`)
2710 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2711 /*!40101 SET character_set_client = @saved_cs_client */;
2714 -- Table structure for table `VLAN_L3INTERFACE_IPV4_ADDRESS`
2717 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV4_ADDRESS`;
2718 /*!40101 SET @saved_cs_client = @@character_set_client */;
2719 /*!40101 SET character_set_client = utf8 */;
2720 CREATE TABLE `VLAN_L3INTERFACE_IPV4_ADDRESS` (
2721 `vnf_id` varchar(80) NOT NULL,
2722 `interface_name` varchar(255) NOT NULL,
2723 `vlan_interface` varchar(255) NOT NULL,
2724 `l3_interface_ipv4_address` varchar(64) NOT NULL,
2725 `l3_interface_ipv4_prefix_length` varchar(45) DEFAULT NULL,
2726 `vlan_id_inner` varchar(45) DEFAULT NULL,
2727 `vlan_id_outer` varchar(45) DEFAULT NULL,
2728 `is_floating` varchar(1) DEFAULT NULL,
2729 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv4_address`),
2730 KEY `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`),
2731 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
2732 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2733 /*!40101 SET character_set_client = @saved_cs_client */;
2736 -- Table structure for table `VLAN_L3INTERFACE_IPV6_ADDRESS`
2739 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV6_ADDRESS`;
2740 /*!40101 SET @saved_cs_client = @@character_set_client */;
2741 /*!40101 SET character_set_client = utf8 */;
2742 CREATE TABLE `VLAN_L3INTERFACE_IPV6_ADDRESS` (
2743 `vnf_id` varchar(80) NOT NULL,
2744 `interface_name` varchar(255) NOT NULL,
2745 `vlan_interface` varchar(255) NOT NULL,
2746 `l3_interface_ipv6_address` varchar(64) NOT NULL,
2747 `l3_interface_ipv6_prefix_length` varchar(45) DEFAULT NULL,
2748 `vlan_id_inner` varchar(45) DEFAULT NULL,
2749 `vlan_id_outer` varchar(45) DEFAULT NULL,
2750 `is_floating` varchar(1) DEFAULT NULL,
2751 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv6_address`),
2752 KEY `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`,`vlan_interface`),
2753 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
2754 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2755 /*!40101 SET character_set_client = @saved_cs_client */;
2758 -- Table structure for table `VLAN_PLAN_ID`
2761 DROP TABLE IF EXISTS `VLAN_PLAN_ID`;
2762 /*!40101 SET @saved_cs_client = @@character_set_client */;
2763 /*!40101 SET character_set_client = utf8 */;
2764 CREATE TABLE `VLAN_PLAN_ID` (
2765 `plan_type` varchar(40) NOT NULL,
2766 `purpose` varchar(40) NOT NULL,
2767 `vlan_plan_id_count` int(4) NOT NULL,
2768 PRIMARY KEY (`vlan_plan_id_count`,`plan_type`,`purpose`)
2769 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2770 /*!40101 SET character_set_client = @saved_cs_client */;
2773 -- Table structure for table `VLAN_POOL`
2776 DROP TABLE IF EXISTS `VLAN_POOL`;
2777 /*!40101 SET @saved_cs_client = @@character_set_client */;
2778 /*!40101 SET character_set_client = utf8 */;
2779 CREATE TABLE `VLAN_POOL` (
2780 `aic_site_id` varchar(100) NOT NULL,
2781 `availability_zone` varchar(100) NOT NULL,
2782 `vlan_plan_id` varchar(100) NOT NULL,
2783 `plan_type` varchar(40) NOT NULL,
2784 `purpose` varchar(40) NOT NULL,
2785 `vlan_id` int(4) NOT NULL,
2786 `status` varchar(40) NOT NULL,
2787 `reserved_id` varchar(80) DEFAULT NULL,
2788 PRIMARY KEY (`aic_site_id`,`availability_zone`,`vlan_plan_id`,`plan_type`,`purpose`,`vlan_id`)
2789 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2790 /*!40101 SET character_set_client = @saved_cs_client */;
2793 -- Table structure for table `VLAN_RANGES`
2796 DROP TABLE IF EXISTS `VLAN_RANGES`;
2797 /*!40101 SET @saved_cs_client = @@character_set_client */;
2798 /*!40101 SET character_set_client = utf8 */;
2799 CREATE TABLE `VLAN_RANGES` (
2800 `vlan_plan_id` varchar(100) NOT NULL,
2801 `plan_type` varchar(40) NOT NULL,
2802 `purpose` varchar(40) NOT NULL,
2803 `range_start` int(4) NOT NULL,
2804 `range_end` int(4) NOT NULL,
2805 `generated` char(1) DEFAULT NULL,
2806 PRIMARY KEY (`vlan_plan_id`,`plan_type`,`purpose`,`range_start`,`range_end`)
2807 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2808 /*!40101 SET character_set_client = @saved_cs_client */;
2811 -- Table structure for table `VM_NAME_INDEX`
2814 DROP TABLE IF EXISTS `VM_NAME_INDEX`;
2815 /*!40101 SET @saved_cs_client = @@character_set_client */;
2816 /*!40101 SET character_set_client = utf8 */;
2817 CREATE TABLE `VM_NAME_INDEX` (
2818 `vm_name_prefix` varchar(255) NOT NULL,
2819 `index_number` int(11) NOT NULL,
2820 PRIMARY KEY (`vm_name_prefix`)
2821 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2822 /*!40101 SET character_set_client = @saved_cs_client */;
2825 -- Table structure for table `VM_NETWORKS`
2828 DROP TABLE IF EXISTS `VM_NETWORKS`;
2829 /*!40101 SET @saved_cs_client = @@character_set_client */;
2830 /*!40101 SET character_set_client = utf8 */;
2831 CREATE TABLE `VM_NETWORKS` (
2832 `vnf_type` varchar(200) NOT NULL,
2833 `vm_type` varchar(45) NOT NULL,
2834 `network_role` varchar(45) NOT NULL,
2835 `assign_ips` tinyint(1) NOT NULL,
2836 `assign_macs` tinyint(1) NOT NULL,
2837 `assign_floating_ip` tinyint(1) NOT NULL,
2838 `ip_count` int(11) DEFAULT NULL,
2839 PRIMARY KEY (`vnf_type`,`vm_type`,`network_role`)
2840 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2841 /*!40101 SET character_set_client = @saved_cs_client */;
2844 -- Table structure for table `VM_PROFILE`
2847 DROP TABLE IF EXISTS `VM_PROFILE`;
2848 /*!40101 SET @saved_cs_client = @@character_set_client */;
2849 /*!40101 SET character_set_client = utf8 */;
2850 CREATE TABLE `VM_PROFILE` (
2851 `vnf_type` varchar(200) NOT NULL,
2852 `vm_type` varchar(45) NOT NULL,
2853 `vm_count` int(11) NOT NULL,
2854 PRIMARY KEY (`vnf_type`,`vm_type`)
2855 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2856 /*!40101 SET character_set_client = @saved_cs_client */;
2859 -- Table structure for table `VNF`
2862 DROP TABLE IF EXISTS `VNF`;
2863 /*!40101 SET @saved_cs_client = @@character_set_client */;
2864 /*!40101 SET character_set_client = utf8 */;
2865 CREATE TABLE `VNF` (
2866 `vnf_id` varchar(80) NOT NULL,
2867 `vnf_name` varchar(80) NOT NULL,
2868 `vnf_type` varchar(10) NOT NULL,
2869 `orchestration_status` varchar(20) DEFAULT NULL,
2870 `heat_stack_id` varchar(80) DEFAULT NULL,
2871 `mso_catalog_key` varchar(80) DEFAULT NULL,
2872 `availability_zone` varchar(80) DEFAULT NULL,
2873 `aic_site_id` varchar(80) DEFAULT NULL,
2874 `oam_ipv4_address` varchar(20) DEFAULT NULL,
2875 `vnf_name2` varchar(80) DEFAULT NULL,
2876 `vpe_id` varchar(80) NOT NULL,
2877 `ipv4_loopback0_address` varchar(80) DEFAULT NULL,
2878 `license_key` varchar(256) DEFAULT NULL,
2879 `entitlement_resource_uuid` varchar(256) DEFAULT NULL,
2880 PRIMARY KEY (`vnf_id`)
2881 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2882 /*!40101 SET character_set_client = @saved_cs_client */;
2885 -- Table structure for table `VNFC_DG_MAPPING`
2888 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
2889 /*!40101 SET @saved_cs_client = @@character_set_client */;
2890 /*!40101 SET character_set_client = utf8 */;
2891 CREATE TABLE `VNFC_DG_MAPPING` (
2892 `vnfc_dg_mapping_id` int(11) NOT NULL AUTO_INCREMENT,
2893 `action` varchar(50) DEFAULT NULL,
2894 `api_version` varchar(10) DEFAULT NULL,
2895 `vnf_type` varchar(50) DEFAULT NULL,
2896 `vnfc_type` varchar(50) DEFAULT NULL,
2897 `dg_name` varchar(50) NOT NULL,
2898 `dg_version` varchar(50) DEFAULT NULL,
2899 `dg_module` varchar(50) NOT NULL,
2900 PRIMARY KEY (`vnfc_dg_mapping_id`),
2901 UNIQUE KEY `input_constraint` (`action`,`api_version`,`vnf_type`,`vnfc_type`)
2902 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2903 /*!40101 SET character_set_client = @saved_cs_client */;
2906 -- Table structure for table `VNFC_REFERENCE`
2909 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
2910 /*!40101 SET @saved_cs_client = @@character_set_client */;
2911 /*!40101 SET character_set_client = utf8 */;
2912 CREATE TABLE `VNFC_REFERENCE` (
2913 `vnfc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
2914 `action` varchar(50) NOT NULL,
2915 `vnf_type` varchar(50) NOT NULL,
2916 `vm_instance` int(11) NOT NULL,
2917 `vnfc_instance` int(11) NOT NULL,
2918 `vnfc_type` varchar(50) NOT NULL,
2919 `vnfc_function_code` varchar(50) NOT NULL,
2920 `ipaddress_v4_oam_vip` varchar(50) DEFAULT NULL,
2921 `group_notation_type` varchar(50) DEFAULT NULL,
2922 `group_notation_value` varchar(50) DEFAULT NULL,
2923 PRIMARY KEY (`vnfc_reference_id`),
2924 UNIQUE KEY `vnfc_reference_id` (`vnfc_reference_id`)
2925 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2926 /*!40101 SET character_set_client = @saved_cs_client */;
2929 -- Table structure for table `VNF_IMAGE`
2932 DROP TABLE IF EXISTS `VNF_IMAGE`;
2933 /*!40101 SET @saved_cs_client = @@character_set_client */;
2934 /*!40101 SET character_set_client = utf8 */;
2935 CREATE TABLE `VNF_IMAGE` (
2936 `application_vendor` varchar(255) NOT NULL,
2937 `application_version` varchar(255) NOT NULL,
2938 `att_uuid` varchar(255) NOT NULL,
2939 `application` varchar(255) DEFAULT NULL,
2940 `selflink` varchar(255) DEFAULT NULL,
2941 PRIMARY KEY (`application_vendor`,`application_version`,`att_uuid`)
2942 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2943 /*!40101 SET character_set_client = @saved_cs_client */;
2946 -- Table structure for table `VNF_MODEL_LICENSES`
2949 DROP TABLE IF EXISTS `VNF_MODEL_LICENSES`;
2950 /*!40101 SET @saved_cs_client = @@character_set_client */;
2951 /*!40101 SET character_set_client = utf8 */;
2952 CREATE TABLE `VNF_MODEL_LICENSES` (
2953 `att_part_number` varchar(255) NOT NULL,
2954 `license_assignment_group` varchar(255) NOT NULL,
2955 `license_required` tinyint(1) DEFAULT NULL,
2956 `entitlement_assignment_group` varchar(255) DEFAULT NULL,
2957 `entitlement_required` tinyint(1) DEFAULT '0',
2958 `feature_group_uuid` varchar(255) DEFAULT NULL,
2959 PRIMARY KEY (`att_part_number`,`license_assignment_group`)
2960 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2961 /*!40101 SET character_set_client = @saved_cs_client */;
2964 -- Table structure for table `VNF_MODEL_LICENSE_FEATURES`
2967 DROP TABLE IF EXISTS `VNF_MODEL_LICENSE_FEATURES`;
2968 /*!40101 SET @saved_cs_client = @@character_set_client */;
2969 /*!40101 SET character_set_client = utf8 */;
2970 CREATE TABLE `VNF_MODEL_LICENSE_FEATURES` (
2971 `att_part_number` varchar(255) NOT NULL,
2972 `license_assignment_group` varchar(255) NOT NULL,
2973 `feature` varchar(255) NOT NULL,
2974 PRIMARY KEY (`att_part_number`,`license_assignment_group`,`feature`)
2975 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2976 /*!40101 SET character_set_client = @saved_cs_client */;
2979 -- Table structure for table `VNF_NAME_INDEX`
2982 DROP TABLE IF EXISTS `VNF_NAME_INDEX`;
2983 /*!40101 SET @saved_cs_client = @@character_set_client */;
2984 /*!40101 SET character_set_client = utf8 */;
2985 CREATE TABLE `VNF_NAME_INDEX` (
2986 `vnf_name_prefix` varchar(255) NOT NULL,
2987 `index_number` int(11) NOT NULL,
2988 PRIMARY KEY (`vnf_name_prefix`)
2989 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2990 /*!40101 SET character_set_client = @saved_cs_client */;
2993 -- Table structure for table `VNF_NETWORKS`
2996 DROP TABLE IF EXISTS `VNF_NETWORKS`;
2997 /*!40101 SET @saved_cs_client = @@character_set_client */;
2998 /*!40101 SET character_set_client = utf8 */;
2999 CREATE TABLE `VNF_NETWORKS` (
3000 `vnf_type` varchar(200) NOT NULL,
3001 `network_role` varchar(45) NOT NULL,
3002 PRIMARY KEY (`vnf_type`,`network_role`)
3003 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3004 /*!40101 SET character_set_client = @saved_cs_client */;
3007 -- Table structure for table `VNF_NETWORK_CONNECTION`
3010 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION`;
3011 /*!40101 SET @saved_cs_client = @@character_set_client */;
3012 /*!40101 SET character_set_client = utf8 */;
3013 CREATE TABLE `VNF_NETWORK_CONNECTION` (
3014 `connection_uuid` varchar(80) NOT NULL,
3015 `vnf_id` varchar(80) NOT NULL,
3016 `connection_id` varchar(80) DEFAULT NULL,
3017 `connection_type` varchar(20) DEFAULT NULL,
3018 `neutron_network_id` varchar(80) DEFAULT NULL,
3019 `neutron_network_name` varchar(80) DEFAULT NULL,
3020 `orchestration_status` varchar(20) DEFAULT NULL,
3021 `switch_id` varchar(40) DEFAULT NULL,
3022 `heat_stack_id` varchar(80) DEFAULT NULL,
3023 `mso_catalog_key` varchar(80) DEFAULT NULL,
3024 `provider_network` varchar(80) DEFAULT NULL,
3025 `port_group_id` varchar(80) DEFAULT NULL,
3026 `port_group_name` varchar(80) DEFAULT NULL,
3027 PRIMARY KEY (`connection_uuid`)
3028 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3029 /*!40101 SET character_set_client = @saved_cs_client */;
3032 -- Table structure for table `VNF_NETWORK_CONNECTION_VLAN`
3035 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION_VLAN`;
3036 /*!40101 SET @saved_cs_client = @@character_set_client */;
3037 /*!40101 SET character_set_client = utf8 */;
3038 CREATE TABLE `VNF_NETWORK_CONNECTION_VLAN` (
3039 `vlan_uuid` varchar(80) NOT NULL,
3040 `vlan_id` int(4) NOT NULL,
3041 `vlan_type` varchar(5) NOT NULL,
3042 `connection_uuid` varchar(80) DEFAULT NULL,
3043 PRIMARY KEY (`vlan_uuid`)
3044 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3045 /*!40101 SET character_set_client = @saved_cs_client */;
3048 -- Table structure for table `VNF_PROFILE`
3051 DROP TABLE IF EXISTS `VNF_PROFILE`;
3052 /*!40101 SET @saved_cs_client = @@character_set_client */;
3053 /*!40101 SET character_set_client = utf8 */;
3054 CREATE TABLE `VNF_PROFILE` (
3055 `vnf_type` varchar(200) NOT NULL,
3056 `availability_zone_count` int(11) NOT NULL,
3057 `equipment_role` varchar(80) NOT NULL,
3058 PRIMARY KEY (`vnf_type`)
3059 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3060 /*!40101 SET character_set_client = @saved_cs_client */;
3063 -- Table structure for table `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`
3066 DROP TABLE IF EXISTS `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`;
3067 /*!40101 SET @saved_cs_client = @@character_set_client */;
3068 /*!40101 SET character_set_client = utf8 */;
3069 CREATE TABLE `VNF_SERVICE_TO_NETWORK_ROLE_FILTER` (
3070 `vnf_service_type` varchar(60) NOT NULL,
3071 `network_role_filter` varchar(60) NOT NULL,
3072 PRIMARY KEY (`vnf_service_type`,`network_role_filter`)
3073 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3074 /*!40101 SET character_set_client = @saved_cs_client */;
3077 -- Table structure for table `VPE_LOCK`
3080 DROP TABLE IF EXISTS `VPE_LOCK`;
3081 /*!40101 SET @saved_cs_client = @@character_set_client */;
3082 /*!40101 SET character_set_client = utf8 */;
3083 CREATE TABLE `VPE_LOCK` (
3084 `vpe_name` varchar(20) NOT NULL,
3085 `vpn_lock` varchar(20) NOT NULL,
3086 PRIMARY KEY (`vpe_name`)
3087 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3088 /*!40101 SET character_set_client = @saved_cs_client */;
3091 -- Table structure for table `VPE_MAC_ADDRESS_POOL`
3094 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_POOL`;
3095 /*!40101 SET @saved_cs_client = @@character_set_client */;
3096 /*!40101 SET character_set_client = utf8 */;
3097 CREATE TABLE `VPE_MAC_ADDRESS_POOL` (
3098 `id` int(11) NOT NULL,
3099 `mac_address` varchar(50) NOT NULL,
3100 `sw_name` varchar(30) NOT NULL,
3102 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3103 /*!40101 SET character_set_client = @saved_cs_client */;
3106 -- Table structure for table `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`
3109 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`;
3110 /*!40101 SET @saved_cs_client = @@character_set_client */;
3111 /*!40101 SET character_set_client = utf8 */;
3112 CREATE TABLE `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING` (
3113 `id` int(11) NOT NULL,
3114 `hostname` varchar(50) NOT NULL,
3115 `assigned_user` varchar(25) NOT NULL,
3116 `assigned_date` date DEFAULT NULL,
3118 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3119 /*!40101 SET character_set_client = @saved_cs_client */;
3122 -- Table structure for table `VPE_POOL`
3125 DROP TABLE IF EXISTS `VPE_POOL`;
3126 /*!40101 SET @saved_cs_client = @@character_set_client */;
3127 /*!40101 SET character_set_client = utf8 */;
3128 CREATE TABLE `VPE_POOL` (
3129 `vpe_name` varchar(20) NOT NULL,
3130 `ipv4_oam_address` varchar(20) NOT NULL,
3131 `loopback0_ipv4_address` varchar(20) NOT NULL,
3132 `provisioning_status` varchar(10) NOT NULL,
3133 `aic_site_id` varchar(100) NOT NULL,
3134 `availability_zone` varchar(100) NOT NULL,
3135 `vlan_id_outer` varchar(20) NOT NULL,
3136 `vendor` varchar(20) NOT NULL,
3137 `physical_intf_name` varchar(40) NOT NULL,
3138 `physical_intf_speed` varchar(20) NOT NULL,
3139 `physical_intf_units` varchar(20) NOT NULL,
3140 `vpe_uuid` varchar(80) DEFAULT NULL,
3141 `vpe_id` varchar(80) NOT NULL,
3142 `image_filename` varchar(100) DEFAULT NULL,
3143 `as_number` varchar(20) NOT NULL,
3144 `loopback5000` varchar(16) DEFAULT NULL,
3145 `loopback10` varchar(16) DEFAULT NULL,
3146 `aic_version` varchar(50) DEFAULT NULL,
3147 `vpe_capacity` int(11) NOT NULL,
3148 PRIMARY KEY (`aic_site_id`,`vpe_name`,`availability_zone`)
3149 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3150 /*!40101 SET character_set_client = @saved_cs_client */;
3153 -- Table structure for table `VPLSPE_POOL`
3156 DROP TABLE IF EXISTS `VPLSPE_POOL`;
3157 /*!40101 SET @saved_cs_client = @@character_set_client */;
3158 /*!40101 SET character_set_client = utf8 */;
3159 CREATE TABLE `VPLSPE_POOL` (
3160 `vplspe_name` varchar(20) NOT NULL,
3161 `aic_site_id` varchar(100) NOT NULL,
3162 `availability_zone` varchar(100) NOT NULL,
3163 `physical_intf_name` varchar(40) NOT NULL,
3164 `physical_intf_speed` varchar(20) NOT NULL,
3165 `physical_intf_units` varchar(20) NOT NULL,
3166 `loopback0_ipv4_address` varchar(20) NOT NULL,
3167 `vlan_id_outer` varchar(20) NOT NULL,
3168 `vplspe_uuid` varchar(80) DEFAULT NULL,
3169 `image_filename` varchar(100) DEFAULT NULL,
3170 `provisioning_status` varchar(10) DEFAULT NULL,
3171 `vendor` varchar(20) DEFAULT NULL,
3172 PRIMARY KEY (`vplspe_name`,`aic_site_id`,`availability_zone`,`physical_intf_name`)
3173 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3174 /*!40101 SET character_set_client = @saved_cs_client */;
3177 -- Table structure for table `VPN_BINDINGS`
3180 DROP TABLE IF EXISTS `VPN_BINDINGS`;
3181 /*!40101 SET @saved_cs_client = @@character_set_client */;
3182 /*!40101 SET character_set_client = utf8 */;
3183 CREATE TABLE `VPN_BINDINGS` (
3184 `network_customization_uuid` varchar(255) NOT NULL,
3185 `binding_uuid` varchar(255) NOT NULL,
3186 PRIMARY KEY (`network_customization_uuid`,`binding_uuid`)
3187 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3188 /*!40101 SET character_set_client = @saved_cs_client */;
3191 -- Table structure for table `VRR_FUNCTION_CODE_VMTYPE_MAPPING`
3194 DROP TABLE IF EXISTS `VRR_FUNCTION_CODE_VMTYPE_MAPPING`;
3195 /*!40101 SET @saved_cs_client = @@character_set_client */;
3196 /*!40101 SET character_set_client = utf8 */;
3197 CREATE TABLE `VRR_FUNCTION_CODE_VMTYPE_MAPPING` (
3198 `ptnii_function_code` varchar(128) NOT NULL,
3199 `vm_type` varchar(128) NOT NULL,
3200 PRIMARY KEY (`ptnii_function_code`,`vm_type`)
3201 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3202 /*!40101 SET character_set_client = @saved_cs_client */;
3205 -- Table structure for table `VSERVER`
3208 DROP TABLE IF EXISTS `VSERVER`;
3209 /*!40101 SET @saved_cs_client = @@character_set_client */;
3210 /*!40101 SET character_set_client = utf8 */;
3211 CREATE TABLE `VSERVER` (
3212 `tenant_id` varchar(40) NOT NULL,
3213 `vserver_id` varchar(40) NOT NULL,
3214 `aic_site_id` varchar(100) NOT NULL,
3215 `vendor` varchar(20) NOT NULL,
3216 `image_name` varchar(100) NOT NULL,
3217 `vnf_type` varchar(10) NOT NULL,
3218 `vnf_id` varchar(80) NOT NULL,
3219 PRIMARY KEY (`tenant_id`,`vserver_id`)
3220 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3221 /*!40101 SET character_set_client = @saved_cs_client */;
3224 -- Table structure for table `VSERVER2`
3227 DROP TABLE IF EXISTS `VSERVER2`;
3228 /*!40101 SET @saved_cs_client = @@character_set_client */;
3229 /*!40101 SET character_set_client = utf8 */;
3230 CREATE TABLE `VSERVER2` (
3231 `tenant_id` varchar(255) NOT NULL,
3232 `vserver_id` varchar(128) NOT NULL,
3233 `vserver_name` varchar(255) NOT NULL,
3234 `vserver_name2` varchar(255) DEFAULT NULL,
3235 `prov_status` varchar(20) DEFAULT NULL,
3236 `selflink` varchar(255) DEFAULT NULL,
3237 PRIMARY KEY (`tenant_id`,`vserver_id`)
3238 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3239 /*!40101 SET character_set_client = @saved_cs_client */;
3242 -- Table structure for table `VSERVER_PSERVER`
3245 DROP TABLE IF EXISTS `VSERVER_PSERVER`;
3246 /*!40101 SET @saved_cs_client = @@character_set_client */;
3247 /*!40101 SET character_set_client = utf8 */;
3248 CREATE TABLE `VSERVER_PSERVER` (
3249 `vserver_id` varchar(128) NOT NULL,
3250 `pserver_hostname` varchar(255) DEFAULT NULL,
3251 PRIMARY KEY (`vserver_id`)
3252 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3253 /*!40101 SET character_set_client = @saved_cs_client */;
3256 -- Table structure for table `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`
3259 DROP TABLE IF EXISTS `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`;
3260 /*!40101 SET @saved_cs_client = @@character_set_client */;
3261 /*!40101 SET character_set_client = utf8 */;
3262 CREATE TABLE `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING` (
3263 `key_id` varchar(128) NOT NULL,
3264 `cloud_region` varchar(128) NOT NULL,
3265 `key_type` varchar(128) NOT NULL,
3266 PRIMARY KEY (`key_id`,`cloud_region`,`key_type`)
3267 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3268 /*!40101 SET character_set_client = @saved_cs_client */;
3271 -- Table structure for table `WAN_COMBO_ALLOWABLE`
3274 DROP TABLE IF EXISTS `WAN_COMBO_ALLOWABLE`;
3275 /*!40101 SET @saved_cs_client = @@character_set_client */;
3276 /*!40101 SET character_set_client = utf8 */;
3277 CREATE TABLE `WAN_COMBO_ALLOWABLE` (
3278 `combo_sequence` int(11) NOT NULL AUTO_INCREMENT,
3279 `topology` varchar(16) DEFAULT 'unknown',
3280 `internet_topology` varchar(20) DEFAULT NULL,
3281 `wan1` varchar(40) DEFAULT NULL,
3282 `wan2` varchar(40) DEFAULT NULL,
3283 `new_start_release_flexware` varchar(16) DEFAULT 'unknown',
3284 `is_active_flexware` varchar(1) DEFAULT 'N',
3285 `new_start_release_dhv` varchar(16) DEFAULT 'unknown',
3286 `is_active_dhv` varchar(1) DEFAULT 'N',
3287 `ucpe_type` varchar(32) DEFAULT 'stand-alone',
3288 `description` varchar(128) NOT NULL,
3289 PRIMARY KEY (`combo_sequence`),
3290 UNIQUE KEY `IX1_WAN_COMBO_ALLOWABLE` (`internet_topology`,`wan1`,`wan2`)
3291 ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
3292 /*!40101 SET character_set_client = @saved_cs_client */;
3294 DROP TABLE IF EXISTS `DHCP_MAP`;
3295 /*!40101 SET @saved_cs_client = @@character_set_client */;
3296 /*!40101 SET character_set_client = utf8 */;
3297 CREATE TABLE `DHCP_MAP` (
3298 `mac_addr` varchar(128) NOT NULL,
3299 `ip_addr` varchar(128) DEFAULT NULL,
3300 PRIMARY KEY (`mac_addr`)
3301 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3303 DROP TABLE IF EXISTS `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING`;
3304 CREATE TABLE `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING` (
3305 `group_uuid` varchar(255) NOT NULL,
3306 `parent_uuid` varchar(255) NOT NULL,
3307 `target_node_uuid` varchar(255) NOT NULL,
3308 `target_type` varchar(255) NULL,
3309 `table_name` varchar(255) NULL,
3310 PRIMARY KEY (`group_uuid`, `parent_uuid`, `target_node_uuid`)
3311 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3313 /*!40101 SET character_set_client = @saved_cs_client */;
3314 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3316 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3317 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3318 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3319 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3320 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3321 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3322 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3324 DROP TABLE IF EXISTS `ATTRIBUTE_VALUE_PAIR`;
3325 CREATE TABLE `ATTRIBUTE_VALUE_PAIR` (
3326 `resource_uuid` varchar(255) NOT NULL,
3327 `attribute_name` varchar(255) NOT NULL,
3328 `resource_type` varchar(255) NOT NULL,
3329 `attribute_value` varchar(255) DEFAULT NULL,
3330 `resource_customization_uuid` varchar(255) DEFAULT NULL,
3331 PRIMARY KEY (`resource_uuid`,`attribute_name`,`resource_type`)
3332 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3334 DROP TABLE IF EXISTS `COMPLEX_RESOURCE`;
3335 CREATE TABLE `COMPLEX_RESOURCE` (
3336 `uuid` varchar(255) NOT NULL,
3337 `model_yaml` longblob,
3338 `invariant_uuid` varchar(255) NOT NULL,
3339 `customization_uuid` varchar(255) NOT NULL,
3340 `version` varchar(255) DEFAULT NULL,
3341 `name` varchar(255) DEFAULT NULL,
3342 `description` varchar(255) DEFAULT NULL,
3343 `type` varchar(255) NOT NULL,
3344 PRIMARY KEY (`uuid`,`customization_uuid`)
3345 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3347 DROP TABLE IF EXISTS `NODE_CAPABILITY`;
3348 CREATE TABLE `NODE_CAPABILITY` (
3349 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
3350 `capability_provider_uuid` varchar(255) NOT NULL,
3351 `capability_provider_customization_uuid` varchar(255) NOT NULL,
3352 `capability_name` varchar(255) DEFAULT NULL,
3353 `capability_type` varchar(255) DEFAULT NULL,
3354 PRIMARY KEY (`capability_id`)
3355 ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
3357 DROP TABLE IF EXISTS `NODE_REQUIREMENT`;
3358 CREATE TABLE `NODE_REQUIREMENT` (
3359 `requirement_id` int(11) NOT NULL AUTO_INCREMENT,
3360 `capability_id` int(11) DEFAULT NULL,
3361 `capability_provider_uuid` varchar(255) DEFAULT NULL,
3362 `capability_provider_customization_uuid` varchar(255) DEFAULT NULL,
3363 `capability_consumer_uuid` varchar(255) NOT NULL,
3364 `capability_consumer_customization_uuid` varchar(255) NOT NULL,
3365 `requirement_name` varchar(255) NOT NULL,
3366 PRIMARY KEY (`requirement_id`),
3367 KEY `NODE_REQUIREMENT_TO_NODE_CAPABILITY` (`capability_id`)
3368 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
3370 DROP TABLE IF EXISTS `RELATED_NETWORK_ROLE`;
3371 CREATE TABLE `RELATED_NETWORK_ROLE` (
3372 `network_model_customization_uuid` varchar(255) NOT NULL,
3373 `related_network_role` varchar(255) NOT NULL,
3374 PRIMARY KEY (`network_model_customization_uuid`,`related_network_role`)
3375 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3377 DROP TABLE IF EXISTS `RESOURCE_GROUP`;
3378 CREATE TABLE `RESOURCE_GROUP` (
3379 `resource_uuid` varchar(255) NOT NULL,
3380 `group_uuid` varchar(255) NOT NULL,
3381 `group_customization_uuid` varchar(255) DEFAULT NULL,
3382 `group_invariant_uuid` varchar(255) NOT NULL,
3383 `group_name` varchar(255) DEFAULT NULL,
3384 `version` varchar(255) DEFAULT NULL,
3385 `group_type` varchar(255) DEFAULT NULL,
3386 PRIMARY KEY (`resource_uuid`,`group_uuid`)
3387 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3389 DROP TABLE IF EXISTS `RESOURCE_POLICY`;
3390 CREATE TABLE `RESOURCE_POLICY` (
3391 `resource_uuid` varchar(255) NOT NULL,
3392 `policy_uuid` varchar(255) NOT NULL,
3393 `policy_customization_uuid` varchar(255) DEFAULT NULL,
3394 `policy_invariant_uuid` varchar(255) NOT NULL,
3395 `policy_name` varchar(255) DEFAULT NULL,
3396 `version` varchar(255) DEFAULT NULL,
3397 `policy_type` varchar(255) DEFAULT NULL,
3398 `property_type` varchar(255) DEFAULT NULL,
3399 `property_source` varchar(255) DEFAULT NULL,
3400 `property_name` varchar(255) DEFAULT NULL,
3401 PRIMARY KEY (`resource_uuid`,`policy_uuid`)
3402 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3404 DROP TABLE IF EXISTS `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING`;
3405 CREATE TABLE `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING` (
3406 `policy_uuid` varchar(255) NOT NULL,
3407 `parent_uuid` varchar(255) NOT NULL,
3408 `target_node_uuid` varchar(255) NOT NULL,
3409 `target_type` varchar(255) DEFAULT NULL,
3410 `target_node_customization_uuid` varchar(255) DEFAULT NULL,
3411 `policy_customization_uuid` varchar(255) DEFAULT NULL,
3412 PRIMARY KEY (`policy_uuid`,`parent_uuid`,`target_node_uuid`)
3413 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3416 DROP TABLE IF EXISTS `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING`;
3417 CREATE TABLE `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING` (
3418 `service_uuid` varchar(255) NOT NULL,
3419 `complex_resource_uuid` varchar(255) NOT NULL,
3420 `complex_resource_customization_uuid` varchar(255) NOT NULL,
3421 PRIMARY KEY (`service_uuid`,`complex_resource_uuid`,`complex_resource_customization_uuid`)
3422 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3424 DROP TABLE IF EXISTS `VFC_RELATED_NETWORK_ROLE`;
3425 CREATE TABLE `VFC_RELATED_NETWORK_ROLE` (
3426 `vfc_customization_uuid` varchar(255) NOT NULL,
3427 `vm_type` varchar(255) NOT NULL,
3428 `network_role` varchar(255) NOT NULL,
3429 `related_network_role` varchar(255) NOT NULL,
3430 PRIMARY KEY (`vfc_customization_uuid`,`vm_type`,`network_role`,`related_network_role`)
3431 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3433 DROP TABLE IF EXISTS `VNF_RELATED_NETWORK_ROLE`;
3434 CREATE TABLE `VNF_RELATED_NETWORK_ROLE` (
3435 `vnf_customization_uuid` varchar(255) NOT NULL,
3436 `network_role` varchar(255) NOT NULL,
3437 `related_network_role` varchar(255) NOT NULL,
3438 PRIMARY KEY (`vnf_customization_uuid`,`network_role`,`related_network_role`)
3439 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3441 -- Dump completed on 2017-10-04 18:23:01