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 `network_scope` varchar(255) DEFAULT NULL,
1558 `naming_policy` varchar(255) DEFAULT NULL,
1559 `ecomp_generated_naming` char(1) DEFAULT NULL,
1560 `is_shared_network` char(1) DEFAULT NULL,
1561 `is_external_network` char(1) DEFAULT NULL,
1562 `is_provider_network` char(1) DEFAULT NULL,
1563 `physical_network_name` varchar(255) DEFAULT NULL,
1564 `is_bound_to_vpn` char(1) DEFAULT NULL,
1565 `vpn_binding` varchar(255) DEFAULT NULL,
1566 `use_ipv4` char(1) DEFAULT NULL,
1567 `ipv4_dhcp_enabled` char(1) DEFAULT NULL,
1568 `ipv4_ip_version` char(1) DEFAULT NULL,
1569 `ipv4_cidr_mask` varchar(255) DEFAULT NULL,
1570 `eipam_v4_address_plan` varchar(255) DEFAULT NULL,
1571 `use_ipv6` char(1) DEFAULT NULL,
1572 `ipv6_dhcp_enabled` char(1) DEFAULT NULL,
1573 `ipv6_ip_version` char(1) DEFAULT NULL,
1574 `ipv6_cidr_mask` varchar(255) DEFAULT NULL,
1575 `eipam_v6_address_plan` varchar(255) DEFAULT NULL,
1576 `version` varchar(255) DEFAULT NULL,
1577 PRIMARY KEY (`customization_uuid`),
1578 KEY `FK_NETWORK_MODEL` (`service_uuid`),
1579 CONSTRAINT `FK_NETWORK_MODEL` FOREIGN KEY (`service_uuid`) REFERENCES `SERVICE_MODEL` (`service_uuid`) ON DELETE NO ACTION ON UPDATE NO ACTION
1580 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1581 /*!40101 SET character_set_client = @saved_cs_client */;
1584 -- Table structure for table `NETWORK_PROFILE`
1587 DROP TABLE IF EXISTS `NETWORK_PROFILE`;
1588 /*!40101 SET @saved_cs_client = @@character_set_client */;
1589 /*!40101 SET character_set_client = utf8 */;
1590 CREATE TABLE `NETWORK_PROFILE` (
1591 `network_type` varchar(100) NOT NULL,
1592 `technology` varchar(100) NOT NULL,
1593 PRIMARY KEY (`network_type`)
1594 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1595 /*!40101 SET character_set_client = @saved_cs_client */;
1598 -- Table structure for table `NETWORK_ROLE_VPN_BINDING`
1601 DROP TABLE IF EXISTS `NETWORK_ROLE_VPN_BINDING`;
1602 /*!40101 SET @saved_cs_client = @@character_set_client */;
1603 /*!40101 SET character_set_client = utf8 */;
1604 CREATE TABLE `NETWORK_ROLE_VPN_BINDING` (
1605 `network_role` varchar(80) NOT NULL,
1606 `vpn_id` varchar(80) NOT NULL,
1607 PRIMARY KEY (`network_role`,`vpn_id`)
1608 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1609 /*!40101 SET character_set_client = @saved_cs_client */;
1612 -- Table structure for table `NODE_TYPES`
1615 DROP TABLE IF EXISTS `NODE_TYPES`;
1616 /*!40101 SET @saved_cs_client = @@character_set_client */;
1617 /*!40101 SET character_set_client = utf8 */;
1618 CREATE TABLE `NODE_TYPES` (
1619 `nodetype` varchar(80) NOT NULL,
1620 PRIMARY KEY (`nodetype`)
1621 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1622 /*!40101 SET character_set_client = @saved_cs_client */;
1625 -- Table structure for table `OBJECT_GROUPING`
1628 DROP TABLE IF EXISTS `OBJECT_GROUPING`;
1629 /*!40101 SET @saved_cs_client = @@character_set_client */;
1630 /*!40101 SET character_set_client = utf8 */;
1631 CREATE TABLE `OBJECT_GROUPING` (
1632 `group_id` varchar(128) NOT NULL,
1633 `group_type` varchar(128) NOT NULL,
1634 PRIMARY KEY (`group_id`)
1635 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1636 /*!40101 SET character_set_client = @saved_cs_client */;
1639 -- Table structure for table `OBJECT_GROUP_MEMBER_TRACKING`
1642 DROP TABLE IF EXISTS `OBJECT_GROUP_MEMBER_TRACKING`;
1643 /*!40101 SET @saved_cs_client = @@character_set_client */;
1644 /*!40101 SET character_set_client = utf8 */;
1645 CREATE TABLE `OBJECT_GROUP_MEMBER_TRACKING` (
1646 `group_id` varchar(128) NOT NULL,
1647 `key_id` varchar(128) NOT NULL,
1648 `key_type` varchar(128) NOT NULL,
1649 PRIMARY KEY (`group_id`,`key_id`,`key_type`)
1650 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1651 /*!40101 SET character_set_client = @saved_cs_client */;
1654 -- Table structure for table `PARAMETERS`
1657 DROP TABLE IF EXISTS `PARAMETERS`;
1658 /*!40101 SET @saved_cs_client = @@character_set_client */;
1659 /*!40101 SET character_set_client = utf8 */;
1660 CREATE TABLE `PARAMETERS` (
1661 `name` varchar(100) NOT NULL,
1662 `value` varchar(128) NOT NULL,
1663 `category` varchar(24) DEFAULT NULL,
1664 `memo` varchar(128) DEFAULT NULL,
1665 PRIMARY KEY (`name`)
1666 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1667 /*!40101 SET character_set_client = @saved_cs_client */;
1670 -- Table structure for table `PE_INV`
1673 DROP TABLE IF EXISTS `PE_INV`;
1674 /*!40101 SET @saved_cs_client = @@character_set_client */;
1675 /*!40101 SET character_set_client = utf8 */;
1676 CREATE TABLE `PE_INV` (
1677 `EQUIP_ID` int(11) DEFAULT NULL,
1678 `EQUIP_TYPE` varchar(20) DEFAULT NULL,
1679 `PTNII_EQUIP_NAME` varchar(20) DEFAULT NULL,
1680 `IP_ADDR` varchar(15) DEFAULT NULL,
1681 `ROUTER_PROV_STATUS` varchar(50) DEFAULT NULL,
1682 `REGION` varchar(16) DEFAULT NULL,
1683 `COUNTRY_ABBR` varchar(50) DEFAULT NULL,
1684 `EQUIP_NAME_CODE` varchar(50) DEFAULT NULL,
1685 `AS_NUMBER` varchar(5) DEFAULT NULL,
1686 `LOOPBACK1` varchar(15) DEFAULT NULL,
1687 `LOOPBACK2` varchar(15) DEFAULT NULL,
1688 `LOOPBACK3` varchar(15) DEFAULT NULL,
1689 `LOOPBACK40` varchar(15) DEFAULT NULL,
1690 `LOOPBACK65535` varchar(15) DEFAULT NULL,
1691 `INMS_LIST` varchar(20) DEFAULT NULL,
1692 `ENCRYPTED_ACCESS_FLAG` varchar(50) DEFAULT NULL,
1693 `SW_NAME` varchar(100) DEFAULT NULL,
1694 `NMIPADDR` varchar(15) DEFAULT NULL,
1695 `CREATE_DATE` datetime DEFAULT NULL,
1696 `MOD_DATE` datetime DEFAULT NULL,
1697 `FCN_CODE` varchar(50) DEFAULT NULL
1698 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1699 /*!40101 SET character_set_client = @saved_cs_client */;
1702 -- Table structure for table `PHYSICAL_LINK`
1705 DROP TABLE IF EXISTS `PHYSICAL_LINK`;
1706 /*!40101 SET @saved_cs_client = @@character_set_client */;
1707 /*!40101 SET character_set_client = utf8 */;
1708 CREATE TABLE `PHYSICAL_LINK` (
1709 `link_name` varchar(255) NOT NULL,
1710 `speed_value` varchar(64) DEFAULT NULL,
1711 `speed_units` varchar(64) DEFAULT NULL,
1712 `circuit_id` varchar(255) NOT NULL,
1713 `dual_mode` varchar(64) NOT NULL,
1714 PRIMARY KEY (`link_name`)
1715 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1716 /*!40101 SET character_set_client = @saved_cs_client */;
1719 -- Table structure for table `PHYSICAL_LINK_PINTERFACE`
1722 DROP TABLE IF EXISTS `PHYSICAL_LINK_PINTERFACE`;
1723 /*!40101 SET @saved_cs_client = @@character_set_client */;
1724 /*!40101 SET character_set_client = utf8 */;
1725 CREATE TABLE `PHYSICAL_LINK_PINTERFACE` (
1726 `link_name` varchar(255) NOT NULL,
1727 `hostname` varchar(255) NOT NULL,
1728 `port_name_ft` varchar(255) NOT NULL,
1729 PRIMARY KEY (`link_name`,`hostname`,`port_name_ft`)
1730 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1731 /*!40101 SET character_set_client = @saved_cs_client */;
1734 -- Table structure for table `PINTERFACE`
1737 DROP TABLE IF EXISTS `PINTERFACE`;
1738 /*!40101 SET @saved_cs_client = @@character_set_client */;
1739 /*!40101 SET character_set_client = utf8 */;
1740 CREATE TABLE `PINTERFACE` (
1741 `hostname` varchar(255) NOT NULL,
1742 `port_name_ft` varchar(255) NOT NULL,
1743 `interface_name` varchar(255) DEFAULT '',
1744 `physical_speed` varchar(255) DEFAULT '',
1745 `physical_units` varchar(255) DEFAULT '',
1746 `port_description` varchar(255) DEFAULT '',
1747 PRIMARY KEY (`hostname`,`port_name_ft`)
1748 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1749 /*!40101 SET character_set_client = @saved_cs_client */;
1752 -- Table structure for table `POLICY_UPDATE_NOTIFICATION`
1755 DROP TABLE IF EXISTS `POLICY_UPDATE_NOTIFICATION`;
1756 /*!40101 SET @saved_cs_client = @@character_set_client */;
1757 /*!40101 SET character_set_client = utf8 */;
1758 CREATE TABLE `POLICY_UPDATE_NOTIFICATION` (
1759 `policy_name` varchar(255) NOT NULL,
1760 `version_id` varchar(255) NOT NULL,
1761 `update_type` varchar(255) NOT NULL,
1762 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1763 PRIMARY KEY (`policy_name`,`version_id`)
1764 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1765 /*!40101 SET character_set_client = @saved_cs_client */;
1768 -- Table structure for table `PORTAL_USERS`
1771 DROP TABLE IF EXISTS `PORTAL_USERS`;
1772 /*!40101 SET @saved_cs_client = @@character_set_client */;
1773 /*!40101 SET character_set_client = utf8 */;
1774 CREATE TABLE `PORTAL_USERS` (
1775 `email` varchar(64) NOT NULL,
1776 `password` varbinary(255) NOT NULL,
1777 `privilege` char(1) NOT NULL,
1778 PRIMARY KEY (`email`)
1779 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1780 /*!40101 SET character_set_client = @saved_cs_client */;
1784 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
1787 DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
1788 /*!40101 SET @saved_cs_client = @@character_set_client */;
1789 /*!40101 SET character_set_client = utf8 */;
1790 CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
1791 `prepare_file_relationship_id` int(11) NOT NULL AUTO_INCREMENT,
1792 `service_instance_id` varchar(50) DEFAULT NULL,
1793 `request_id` varchar(255) DEFAULT NULL,
1794 `config_file_id` int(11) DEFAULT NULL,
1795 `asdc_artifacts_id` int(11) DEFAULT NULL,
1796 PRIMARY KEY (`prepare_file_relationship_id`),
1797 UNIQUE KEY `prepare_file_relationship_id` (`prepare_file_relationship_id`),
1798 KEY `ie_prepare_file_relationship` (`config_file_id`),
1799 KEY `ie2_prepare_file_relationship` (`asdc_artifacts_id`),
1800 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`asdc_artifacts_id`) REFERENCES `ASDC_ARTIFACTS` (`asdc_artifacts_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
1801 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`config_file_id`) REFERENCES `CONFIGFILES` (`config_file_id`) ON DELETE NO ACTION ON UPDATE CASCADE
1802 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1803 /*!40101 SET character_set_client = @saved_cs_client */;
1806 -- Table structure for table `PRE_LOAD_VNF_DATA`
1809 DROP TABLE IF EXISTS `PRE_LOAD_VNF_DATA`;
1810 /*!40101 SET @saved_cs_client = @@character_set_client */;
1811 /*!40101 SET character_set_client = utf8 */;
1812 CREATE TABLE `PRE_LOAD_VNF_DATA` (
1813 `id` int(11) NOT NULL AUTO_INCREMENT,
1814 `svc_request_id` varchar(100) DEFAULT '',
1815 `svc_action` varchar(40) DEFAULT '',
1816 `status` varchar(10) NOT NULL DEFAULT 'pending',
1817 `filename` varchar(100) NOT NULL,
1818 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1819 `preload_data` longblob,
1821 ) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=latin1;
1822 /*!40101 SET character_set_client = @saved_cs_client */;
1825 -- Table structure for table `PRE_LOAD_VNF_NETWORK_DATA`
1828 DROP TABLE IF EXISTS `PRE_LOAD_VNF_NETWORK_DATA`;
1829 /*!40101 SET @saved_cs_client = @@character_set_client */;
1830 /*!40101 SET character_set_client = utf8 */;
1831 CREATE TABLE `PRE_LOAD_VNF_NETWORK_DATA` (
1832 `id` int(11) NOT NULL AUTO_INCREMENT,
1833 `svc_request_id` varchar(100) DEFAULT '',
1834 `svc_action` varchar(40) DEFAULT '',
1835 `status` varchar(10) NOT NULL DEFAULT 'pending',
1836 `filename` varchar(100) NOT NULL,
1837 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1838 `preload_data` longblob,
1840 ) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1;
1841 /*!40101 SET character_set_client = @saved_cs_client */;
1844 -- Table structure for table `PSERVER`
1847 DROP TABLE IF EXISTS `PSERVER`;
1848 /*!40101 SET @saved_cs_client = @@character_set_client */;
1849 /*!40101 SET character_set_client = utf8 */;
1850 CREATE TABLE `PSERVER` (
1851 `hostname` varchar(255) NOT NULL,
1852 `ptnii_equip_name` varchar(255) DEFAULT '',
1853 `number_of_cpus` varchar(255) DEFAULT '',
1854 `disk_in_gigabytes` varchar(255) DEFAULT '',
1855 `ram_in_megabytes` varchar(255) DEFAULT '',
1856 `equip_type` varchar(255) DEFAULT '',
1857 `equip_vendor` varchar(255) DEFAULT '',
1858 `equip_model` varchar(255) DEFAULT '',
1859 `fqdn` varchar(255) DEFAULT '',
1860 `pserver_selflink` varchar(255) DEFAULT '',
1861 `ipv4_oam_address` varchar(40) DEFAULT NULL,
1862 `serial_number` varchar(255) DEFAULT '',
1863 `pserver_id` varchar(255) DEFAULT '',
1864 `internet_topology` varchar(40) DEFAULT '',
1865 `aic_site_id` varchar(100) DEFAULT '',
1866 `in_maint` varchar(5) DEFAULT '',
1867 `pserver_name2` varchar(255) DEFAULT '',
1868 `purpose` varchar(255) DEFAULT '',
1869 PRIMARY KEY (`hostname`)
1870 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1871 /*!40101 SET character_set_client = @saved_cs_client */;
1874 -- Table structure for table `RANGE_RULE`
1877 DROP TABLE IF EXISTS `RANGE_RULE`;
1878 /*!40101 SET @saved_cs_client = @@character_set_client */;
1879 /*!40101 SET character_set_client = utf8 */;
1880 CREATE TABLE `RANGE_RULE` (
1881 `range_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1882 `range_name` varchar(50) NOT NULL,
1883 `service_model` varchar(50) NOT NULL,
1884 `end_point_position` varchar(50) NOT NULL,
1885 `equipment_level` varchar(50) NOT NULL,
1886 `min_value` int(11) NOT NULL,
1887 `max_value` int(11) NOT NULL,
1888 PRIMARY KEY (`range_rule_id`)
1889 ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
1890 /*!40101 SET character_set_client = @saved_cs_client */;
1893 -- Table structure for table `REQUEST_PROGRESS`
1896 DROP TABLE IF EXISTS `REQUEST_PROGRESS`;
1897 /*!40101 SET @saved_cs_client = @@character_set_client */;
1898 /*!40101 SET character_set_client = utf8 */;
1899 CREATE TABLE `REQUEST_PROGRESS` (
1900 `request_id` int(11) NOT NULL AUTO_INCREMENT,
1901 `request_type` varchar(20) DEFAULT NULL,
1902 `service_instance_id` varchar(80) NOT NULL,
1903 `request_instance_type` varchar(20) NOT NULL,
1904 `originating_service_instance_id` varchar(80) DEFAULT NULL,
1905 `originating_service_type` varchar(20) DEFAULT NULL,
1906 `overall_status` varchar(20) DEFAULT NULL,
1907 `status_date` varchar(80) DEFAULT NULL,
1908 `message` varchar(255) DEFAULT NULL,
1909 PRIMARY KEY (`request_id`)
1910 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1911 /*!40101 SET character_set_client = @saved_cs_client */;
1914 -- Table structure for table `REQUEST_PROGRESS_STATE`
1917 DROP TABLE IF EXISTS `REQUEST_PROGRESS_STATE`;
1918 /*!40101 SET @saved_cs_client = @@character_set_client */;
1919 /*!40101 SET character_set_client = utf8 */;
1920 CREATE TABLE `REQUEST_PROGRESS_STATE` (
1921 `request_progress_state_id` int(11) NOT NULL AUTO_INCREMENT,
1922 `request_id` int(11) DEFAULT NULL,
1923 `service_instance_id` varchar(80) NOT NULL,
1924 `request_instance_type` varchar(20) NOT NULL,
1925 `progress_state` varchar(30) DEFAULT NULL,
1926 `transaction_status` varchar(20) DEFAULT NULL,
1927 `status_date` varchar(80) DEFAULT NULL,
1928 `response_code` varchar(20) DEFAULT NULL,
1929 `message` varchar(255) DEFAULT NULL,
1930 PRIMARY KEY (`request_progress_state_id`)
1931 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1932 /*!40101 SET character_set_client = @saved_cs_client */;
1935 -- Table structure for table `RESOURCE`
1938 DROP TABLE IF EXISTS `RESOURCE`;
1939 /*!40101 SET @saved_cs_client = @@character_set_client */;
1940 /*!40101 SET character_set_client = utf8 */;
1941 CREATE TABLE `RESOURCE` (
1942 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1943 `asset_id` varchar(100) NOT NULL,
1944 `resource_name` varchar(50) NOT NULL,
1945 `resource_type` enum('Limit','Label','Range') NOT NULL,
1946 `lt_used` bigint(20) DEFAULT NULL,
1947 `ll_label` varchar(50) DEFAULT NULL,
1948 `ll_reference_count` smallint(6) DEFAULT NULL,
1949 `rr_used` varchar(4000) DEFAULT NULL,
1950 PRIMARY KEY (`resource_id`),
1951 UNIQUE KEY `resource_id` (`resource_id`),
1952 UNIQUE KEY `IX1_RESOURCE` (`asset_id`,`resource_name`)
1953 ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;
1954 /*!40101 SET character_set_client = @saved_cs_client */;
1957 -- Table structure for table `RESOURCE_LOAD`
1960 DROP TABLE IF EXISTS `RESOURCE_LOAD`;
1961 /*!40101 SET @saved_cs_client = @@character_set_client */;
1962 /*!40101 SET character_set_client = utf8 */;
1963 CREATE TABLE `RESOURCE_LOAD` (
1964 `resource_load_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1965 `resource_id` bigint(20) NOT NULL,
1966 `application_id` varchar(20) NOT NULL,
1967 `resource_load_time` datetime NOT NULL,
1968 `resource_expiration_time` datetime DEFAULT NULL,
1969 PRIMARY KEY (`resource_load_id`),
1970 UNIQUE KEY `resource_load_id` (`resource_load_id`),
1971 UNIQUE KEY `IX2_RESOURCE_LOAD` (`resource_id`,`application_id`),
1972 KEY `IX1_RESOURCE_LOAD` (`resource_id`)
1973 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1974 /*!40101 SET character_set_client = @saved_cs_client */;
1977 -- Table structure for table `RESOURCE_LOCK`
1980 DROP TABLE IF EXISTS `RESOURCE_LOCK`;
1981 /*!40101 SET @saved_cs_client = @@character_set_client */;
1982 /*!40101 SET character_set_client = utf8 */;
1983 CREATE TABLE `RESOURCE_LOCK` (
1984 `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1985 `resource_name` varchar(256) DEFAULT NULL,
1986 `lock_holder` varchar(100) NOT NULL,
1987 `lock_count` smallint(6) NOT NULL,
1988 `lock_time` datetime NOT NULL,
1989 `expiration_time` datetime NOT NULL,
1990 PRIMARY KEY (`resource_lock_id`),
1991 UNIQUE KEY `resource_lock_id` (`resource_lock_id`),
1992 UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`)
1993 ) ENGINE=InnoDB AUTO_INCREMENT=29681 DEFAULT CHARSET=latin1;
1994 /*!40101 SET character_set_client = @saved_cs_client */;
1997 -- Table structure for table `RESOURCE_RULE`
2000 DROP TABLE IF EXISTS `RESOURCE_RULE`;
2001 /*!40101 SET @saved_cs_client = @@character_set_client */;
2002 /*!40101 SET character_set_client = utf8 */;
2003 CREATE TABLE `RESOURCE_RULE` (
2004 `resource_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2005 `resource_name` varchar(50) NOT NULL,
2006 `service_model` varchar(50) NOT NULL,
2007 `end_point_position` varchar(50) NOT NULL,
2008 `service_expression` varchar(2000) NOT NULL,
2009 `equipment_level` varchar(50) NOT NULL,
2010 `equipment_expression` varchar(2000) NOT NULL,
2011 `allocation_expression` varchar(2000) NOT NULL,
2012 `soft_limit_expression` varchar(2000) NOT NULL,
2013 `hard_limit_expression` varchar(2000) NOT NULL,
2014 PRIMARY KEY (`resource_rule_id`),
2015 UNIQUE KEY `resource_rule_id` (`resource_rule_id`)
2016 ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
2017 /*!40101 SET character_set_client = @saved_cs_client */;
2020 -- Table structure for table `RESOURCE_THRESHOLD`
2023 DROP TABLE IF EXISTS `RESOURCE_THRESHOLD`;
2024 /*!40101 SET @saved_cs_client = @@character_set_client */;
2025 /*!40101 SET character_set_client = utf8 */;
2026 CREATE TABLE `RESOURCE_THRESHOLD` (
2027 `resource_threshold_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2028 `resource_rule_id` bigint(20) NOT NULL,
2029 `threshold_expression` varchar(2000) NOT NULL,
2030 `threshold_message` varchar(2000) NOT NULL,
2031 PRIMARY KEY (`resource_threshold_id`)
2032 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2033 /*!40101 SET character_set_client = @saved_cs_client */;
2036 -- Table structure for table `ROUTER_MASTER`
2039 DROP TABLE IF EXISTS `ROUTER_MASTER`;
2040 /*!40101 SET @saved_cs_client = @@character_set_client */;
2041 /*!40101 SET character_set_client = utf8 */;
2042 CREATE TABLE `ROUTER_MASTER` (
2043 `crs_name` varchar(20) NOT NULL,
2044 `loopback_ip` varchar(20) NOT NULL,
2045 PRIMARY KEY (`crs_name`)
2046 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2047 /*!40101 SET character_set_client = @saved_cs_client */;
2050 -- Table structure for table `ROUTING_CHARACTERISTIC_MAPPING`
2053 DROP TABLE IF EXISTS `ROUTING_CHARACTERISTIC_MAPPING`;
2054 /*!40101 SET @saved_cs_client = @@character_set_client */;
2055 /*!40101 SET character_set_client = utf8 */;
2056 CREATE TABLE `ROUTING_CHARACTERISTIC_MAPPING` (
2057 `network_role` varchar(255) NOT NULL,
2058 `vrf_name` varchar(255) NOT NULL,
2059 `routing_characteristic` varchar(255) NOT NULL,
2060 PRIMARY KEY (`network_role`,`vrf_name`)
2061 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2062 /*!40101 SET character_set_client = @saved_cs_client */;
2065 -- Table structure for table `SERVICE_HOMING`
2068 DROP TABLE IF EXISTS `SERVICE_HOMING`;
2069 /*!40101 SET @saved_cs_client = @@character_set_client */;
2070 /*!40101 SET character_set_client = utf8 */;
2071 CREATE TABLE `SERVICE_HOMING` (
2072 `service_type` varchar(100) NOT NULL,
2073 `lata` int(3) NOT NULL,
2074 `hubbing_city_type` varchar(40) NOT NULL,
2075 `latitude` float DEFAULT NULL,
2076 `longitude` float DEFAULT NULL,
2077 `primary_aic_site_name` varchar(100) NOT NULL,
2078 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2079 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2080 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2081 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2082 /*!40101 SET character_set_client = @saved_cs_client */;
2085 -- Table structure for table `SERVICE_HOMING_BACKUP`
2088 DROP TABLE IF EXISTS `SERVICE_HOMING_BACKUP`;
2089 /*!40101 SET @saved_cs_client = @@character_set_client */;
2090 /*!40101 SET character_set_client = utf8 */;
2091 CREATE TABLE `SERVICE_HOMING_BACKUP` (
2092 `service_type` varchar(100) NOT NULL,
2093 `lata` int(3) NOT NULL,
2094 `hubbing_city_type` varchar(40) NOT NULL,
2095 `latitude` float DEFAULT NULL,
2096 `longitude` float DEFAULT NULL,
2097 `primary_aic_site_name` varchar(100) NOT NULL,
2098 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
2099 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
2100 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
2101 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2102 /*!40101 SET character_set_client = @saved_cs_client */;
2105 -- Table structure for table `SERVICE_INSTANCE_NAME_INDEX`
2108 DROP TABLE IF EXISTS `SERVICE_INSTANCE_NAME_INDEX`;
2109 /*!40101 SET @saved_cs_client = @@character_set_client */;
2110 /*!40101 SET character_set_client = utf8 */;
2111 CREATE TABLE `SERVICE_INSTANCE_NAME_INDEX` (
2112 `service_instance_name_prefix` varchar(255) NOT NULL,
2113 `index_number` int(11) NOT NULL,
2114 PRIMARY KEY (`service_instance_name_prefix`)
2115 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2116 /*!40101 SET character_set_client = @saved_cs_client */;
2119 -- Table structure for table `SERVICE_MANAGER_CREDENTIALS`
2122 DROP TABLE IF EXISTS `SERVICE_MANAGER_CREDENTIALS`;
2123 /*!40101 SET @saved_cs_client = @@character_set_client */;
2124 /*!40101 SET character_set_client = utf8 */;
2125 CREATE TABLE `SERVICE_MANAGER_CREDENTIALS` (
2126 `service_manager_username` varchar(255) NOT NULL,
2127 `service_manager_password` varbinary(255) NOT NULL,
2128 PRIMARY KEY (`service_manager_username`)
2129 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2130 /*!40101 SET character_set_client = @saved_cs_client */;
2133 -- Table structure for table `SERVICE_MODEL`
2136 DROP TABLE IF EXISTS `SERVICE_MODEL`;
2137 /*!40101 SET @saved_cs_client = @@character_set_client */;
2138 /*!40101 SET character_set_client = utf8 */;
2139 CREATE TABLE `SERVICE_MODEL` (
2140 `service_uuid` varchar(255) NOT NULL,
2141 `model_yaml` longblob,
2142 `invariant_uuid` varchar(255) DEFAULT NULL,
2143 `version` varchar(255) DEFAULT NULL,
2144 `name` varchar(255) DEFAULT NULL,
2145 `description` varchar(1024) DEFAULT NULL,
2146 `type` varchar(255) DEFAULT NULL,
2147 `category` varchar(255) DEFAULT NULL,
2148 `ecomp_naming` char(1) DEFAULT NULL,
2149 `service_instance_name_prefix` varchar(255) DEFAULT NULL,
2150 `filename` varchar(100) DEFAULT NULL,
2151 `naming_policy` varchar(255) DEFAULT NULL,
2152 PRIMARY KEY (`service_uuid`)
2153 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2154 /*!40101 SET character_set_client = @saved_cs_client */;
2157 -- Table structure for table `SERVICE_PROXY`
2160 DROP TABLE IF EXISTS `SERVICE_PROXY`;
2161 /*!40101 SET @saved_cs_client = @@character_set_client */;
2162 /*!40101 SET character_set_client = utf8 */;
2163 CREATE TABLE `SERVICE_PROXY` (
2164 `port_mirror_service_uuid` varchar(255) NOT NULL,
2165 `service_proxy_name` varchar(255) NOT NULL,
2166 `source_service_uuid` varchar(255) NOT NULL,
2167 `resources_vendor` varchar(255) DEFAULT NULL,
2168 `resource_vendor_release` varchar(255) DEFAULT NULL,
2169 `description` varchar(255) DEFAULT NULL,
2170 `category` varchar(255) DEFAULT NULL,
2171 `subcategory` varchar(255) DEFAULT NULL,
2172 `version` varchar(255) DEFAULT NULL,
2173 `role` varchar(255) NOT NULL,
2174 `uuid` varchar(255) DEFAULT NULL,
2175 `customization_uuid` varchar(255) DEFAULT NULL,
2176 `invariant_uuid` varchar(255) DEFAULT NULL,
2177 PRIMARY KEY (`port_mirror_service_uuid`,`service_proxy_name`),
2178 KEY `FK_SERVICE_PROXY_SOURCE_TO_SERVICE_MODE` (`source_service_uuid`),
2179 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
2180 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2181 /*!40101 SET character_set_client = @saved_cs_client */;
2184 -- Table structure for table `SERVICE_RESOURCE`
2187 DROP TABLE IF EXISTS `SERVICE_RESOURCE`;
2188 /*!40101 SET @saved_cs_client = @@character_set_client */;
2189 /*!40101 SET character_set_client = utf8 */;
2190 CREATE TABLE `SERVICE_RESOURCE` (
2191 `service_resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2192 `service_instance_id` varchar(80) NOT NULL,
2193 `service_status` enum('Active','Pending') NOT NULL,
2194 `service_change_number` smallint(6) NOT NULL,
2195 `resource_set_id` varchar(100) NOT NULL,
2196 `resource_union_id` varchar(100) NOT NULL,
2197 PRIMARY KEY (`service_instance_id`,`service_change_number`),
2198 UNIQUE KEY `service_resource_id` (`service_resource_id`),
2199 KEY `IX1_SERVICE_RESOURCE` (`service_instance_id`)
2200 ) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=latin1;
2201 /*!40101 SET character_set_client = @saved_cs_client */;
2204 -- Table structure for table `SERVICE_TYPE_MAPPING`
2207 DROP TABLE IF EXISTS `SERVICE_TYPE_MAPPING`;
2208 /*!40101 SET @saved_cs_client = @@character_set_client */;
2209 /*!40101 SET character_set_client = utf8 */;
2210 CREATE TABLE `SERVICE_TYPE_MAPPING` (
2211 `sdnc_service_type` varchar(128) NOT NULL,
2212 `ncs_service_type` varchar(128) NOT NULL,
2213 PRIMARY KEY (`sdnc_service_type`,`ncs_service_type`)
2214 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2215 /*!40101 SET character_set_client = @saved_cs_client */;
2218 -- Table structure for table `SUBNETPOOL_MAPPING`
2221 DROP TABLE IF EXISTS `SUBNETPOOL_MAPPING`;
2222 /*!40101 SET @saved_cs_client = @@character_set_client */;
2223 /*!40101 SET character_set_client = utf8 */;
2224 CREATE TABLE `SUBNETPOOL_MAPPING` (
2225 `aic_cloud_region` varchar(16) NOT NULL,
2226 `ntc` varchar(32) NOT NULL,
2227 `lcp` varchar(32) NOT NULL,
2228 `aic_region_id` varchar(255) NOT NULL,
2229 PRIMARY KEY (`aic_cloud_region`)
2230 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2231 /*!40101 SET character_set_client = @saved_cs_client */;
2234 -- Table structure for table `SUPPORTED_SEQUENCE_NUMBER`
2237 DROP TABLE IF EXISTS `SUPPORTED_SEQUENCE_NUMBER`;
2238 /*!40101 SET @saved_cs_client = @@character_set_client */;
2239 /*!40101 SET character_set_client = utf8 */;
2240 CREATE TABLE `SUPPORTED_SEQUENCE_NUMBER` (
2241 `resource_sequence_number` varchar(10) NOT NULL,
2242 `resource_type` varchar(10) NOT NULL,
2243 PRIMARY KEY (`resource_sequence_number`,`resource_type`)
2244 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2245 /*!40101 SET character_set_client = @saved_cs_client */;
2248 -- Table structure for table `SVC_LOGIC`
2251 DROP TABLE IF EXISTS `SVC_LOGIC`;
2252 /*!40101 SET @saved_cs_client = @@character_set_client */;
2253 /*!40101 SET character_set_client = utf8 */;
2254 CREATE TABLE `SVC_LOGIC` (
2255 `module` varchar(80) NOT NULL,
2256 `rpc` varchar(80) NOT NULL,
2257 `version` varchar(40) NOT NULL,
2258 `mode` varchar(5) NOT NULL,
2259 `active` varchar(1) NOT NULL,
2261 `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2262 `md5sum` varchar(128) DEFAULT NULL,
2263 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
2264 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2265 /*!40101 SET character_set_client = @saved_cs_client */;
2268 -- Table structure for table `TABLE_CLEANUP_CONFIGURATION`
2271 DROP TABLE IF EXISTS `TABLE_CLEANUP_CONFIGURATION`;
2272 /*!40101 SET @saved_cs_client = @@character_set_client */;
2273 /*!40101 SET character_set_client = utf8 */;
2274 CREATE TABLE `TABLE_CLEANUP_CONFIGURATION` (
2275 `table_name` varchar(255) NOT NULL COMMENT 'The name of the table the cleanup will be performed on',
2276 `days_old` int(11) NOT NULL COMMENT 'Records older than the current date minus DAYS_OLD will be deleted',
2277 `date_column` varchar(255) NOT NULL COMMENT 'The name of the column containing the date to be checked',
2278 `commit_interval` int(11) NOT NULL DEFAULT '2500' COMMENT 'The maximum number of rows a commit may contain',
2279 `query_clause` varchar(1000) DEFAULT NULL COMMENT 'An optional additional query clause to further restrict deletion criteria',
2280 `child_table_name` varchar(255) DEFAULT NULL,
2281 `child_table_pk` varchar(255) DEFAULT NULL,
2282 PRIMARY KEY (`table_name`)
2283 ) 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.';
2284 /*!40101 SET character_set_client = @saved_cs_client */;
2287 -- Table structure for table `TASK_TEMPLATE`
2290 DROP TABLE IF EXISTS `TASK_TEMPLATE`;
2291 /*!40101 SET @saved_cs_client = @@character_set_client */;
2292 /*!40101 SET character_set_client = utf8 */;
2293 CREATE TABLE `TASK_TEMPLATE` (
2294 `task_template_id` int(11) NOT NULL AUTO_INCREMENT,
2295 `request_type` varchar(20) DEFAULT NULL,
2296 `task_name` varchar(30) NOT NULL,
2297 `task_category` varchar(50) NOT NULL,
2298 `ecomp_task` varchar(50) NOT NULL,
2299 `initial_load` varchar(1) NOT NULL,
2300 `service` varchar(20) DEFAULT NULL,
2301 PRIMARY KEY (`task_template_id`)
2302 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2303 /*!40101 SET character_set_client = @saved_cs_client */;
2306 -- Table structure for table `TENANT`
2309 DROP TABLE IF EXISTS `TENANT`;
2310 /*!40101 SET @saved_cs_client = @@character_set_client */;
2311 /*!40101 SET character_set_client = utf8 */;
2312 CREATE TABLE `TENANT` (
2313 `tenant_id` varchar(255) NOT NULL,
2314 `tenant_name` varchar(255) NOT NULL,
2315 `service_instance_id` varchar(255) NOT NULL,
2316 PRIMARY KEY (`tenant_id`,`tenant_name`)
2317 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2318 /*!40101 SET character_set_client = @saved_cs_client */;
2321 -- Table structure for table `TESTTBL`
2324 DROP TABLE IF EXISTS `TESTTBL`;
2325 /*!40101 SET @saved_cs_client = @@character_set_client */;
2326 /*!40101 SET character_set_client = utf8 */;
2327 CREATE TABLE `TESTTBL` (
2328 `pk` varchar(25) NOT NULL,
2329 `col1` varchar(25) DEFAULT NULL
2330 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2331 /*!40101 SET character_set_client = @saved_cs_client */;
2334 -- Table structure for table `THRESHOLD_NOTIFICATION`
2337 DROP TABLE IF EXISTS `THRESHOLD_NOTIFICATION`;
2338 /*!40101 SET @saved_cs_client = @@character_set_client */;
2339 /*!40101 SET character_set_client = utf8 */;
2340 CREATE TABLE `THRESHOLD_NOTIFICATION` (
2341 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2342 `threshold_expression` varchar(2000) DEFAULT NULL,
2343 `threshold_message` varchar(500) DEFAULT NULL,
2344 PRIMARY KEY (`resource_id`)
2345 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2346 /*!40101 SET character_set_client = @saved_cs_client */;
2349 -- Table structure for table `TMP_AIC_AVAIL_ZONE_POOL`
2352 DROP TABLE IF EXISTS `TMP_AIC_AVAIL_ZONE_POOL`;
2353 /*!40101 SET @saved_cs_client = @@character_set_client */;
2354 /*!40101 SET character_set_client = utf8 */;
2355 CREATE TABLE `TMP_AIC_AVAIL_ZONE_POOL` (
2356 `aic_site_id` varchar(100) NOT NULL,
2357 `status` varchar(40) NOT NULL,
2358 `availability_zone` varchar(100) NOT NULL,
2359 `token` int(4) NOT NULL,
2360 `vnf_id` varchar(80) DEFAULT NULL,
2361 `service_type` varchar(100) NOT NULL,
2362 `vnf_type` varchar(20) DEFAULT NULL,
2363 `hypervisor` varchar(10) DEFAULT NULL,
2364 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
2365 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2366 /*!40101 SET character_set_client = @saved_cs_client */;
2369 -- Table structure for table `TOPOLOGY_PARAMETER`
2372 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER`;
2373 /*!40101 SET @saved_cs_client = @@character_set_client */;
2374 /*!40101 SET character_set_client = utf8 */;
2375 CREATE TABLE `TOPOLOGY_PARAMETER` (
2376 `parameter_id` int(11) NOT NULL,
2377 `parameter_name` varchar(20) NOT NULL,
2378 `parameter_set` int(11) NOT NULL,
2379 `create_update_time` datetime NOT NULL,
2380 `create_update_user` varchar(40) NOT NULL,
2381 PRIMARY KEY (`parameter_id`)
2382 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2383 /*!40101 SET character_set_client = @saved_cs_client */;
2386 -- Table structure for table `TOPOLOGY_PARAMETER_ENTRIES`
2389 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_ENTRIES`;
2390 /*!40101 SET @saved_cs_client = @@character_set_client */;
2391 /*!40101 SET character_set_client = utf8 */;
2392 CREATE TABLE `TOPOLOGY_PARAMETER_ENTRIES` (
2393 `parameter_entry_id` int(11) NOT NULL,
2394 `parameter_name` varchar(255) NOT NULL,
2395 `parameter_value` varchar(64) NOT NULL,
2396 `create_update_time` datetime NOT NULL,
2397 `create_update_user` varchar(40) NOT NULL,
2398 PRIMARY KEY (`parameter_entry_id`)
2399 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2400 /*!40101 SET character_set_client = @saved_cs_client */;
2403 -- Table structure for table `TOPOLOGY_PARAMETER_TO_ENTRIES`
2406 DROP TABLE IF EXISTS `TOPOLOGY_PARAMETER_TO_ENTRIES`;
2407 /*!40101 SET @saved_cs_client = @@character_set_client */;
2408 /*!40101 SET character_set_client = utf8 */;
2409 CREATE TABLE `TOPOLOGY_PARAMETER_TO_ENTRIES` (
2410 `parameter_id` int(11) DEFAULT NULL,
2411 `parameter_entry_id` int(11) DEFAULT NULL,
2412 `entry_order` int(11) DEFAULT NULL,
2413 `create_update_time` datetime DEFAULT NULL,
2414 `create_update_user` varchar(40) NOT NULL,
2415 KEY `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_id`),
2416 KEY `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_entry_id`),
2417 CONSTRAINT `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_id`) REFERENCES `TOPOLOGY_PARAMETER` (`parameter_id`),
2418 CONSTRAINT `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_entry_id`) REFERENCES `TOPOLOGY_PARAMETER_ENTRIES` (`parameter_entry_id`)
2419 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2420 /*!40101 SET character_set_client = @saved_cs_client */;
2423 -- Table structure for table `TRANSACTION_LOG`
2426 DROP TABLE IF EXISTS `TRANSACTION_LOG`;
2427 /*!40101 SET @saved_cs_client = @@character_set_client */;
2428 /*!40101 SET character_set_client = utf8 */;
2429 CREATE TABLE `TRANSACTION_LOG` (
2430 `serial_key` int(10) NOT NULL AUTO_INCREMENT,
2431 `log_time` varchar(40) NOT NULL,
2432 `request_id` varchar(80) DEFAULT NULL,
2433 `svc_request_id` varchar(80) DEFAULT NULL,
2434 `x_ecomp_request_id` varchar(80) DEFAULT NULL,
2435 `graph_name` varchar(255) DEFAULT NULL,
2436 PRIMARY KEY (`serial_key`)
2437 ) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;
2438 /*!40101 SET character_set_client = @saved_cs_client */;
2442 -- Table structure for table `UPLOAD_CONFIG`
2445 DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
2446 /*!40101 SET @saved_cs_client = @@character_set_client */;
2447 /*!40101 SET character_set_client = utf8 */;
2448 CREATE TABLE `UPLOAD_CONFIG` (
2449 `upload_config_id` int(11) NOT NULL AUTO_INCREMENT,
2450 `request_id` varchar(50) DEFAULT NULL,
2451 `originator_id` varchar(50) DEFAULT NULL,
2452 `service_description` varchar(100) DEFAULT NULL,
2453 `action` varchar(50) DEFAULT NULL,
2454 `upload_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
2455 `vnf_id` varchar(50) DEFAULT NULL,
2456 `vnf_name` varchar(50) DEFAULT NULL,
2457 `vm_name` varchar(50) DEFAULT NULL,
2458 `vnf_type` varchar(50) DEFAULT NULL,
2459 `vnfc_type` varchar(50) DEFAULT NULL,
2460 `host_ip_address` varchar(50) DEFAULT NULL,
2461 `config_indicator` varchar(25) DEFAULT NULL,
2462 `pending_delete` varchar(1) DEFAULT NULL,
2464 PRIMARY KEY (`upload_config_id`),
2465 UNIQUE KEY `upload_config_id` (`upload_config_id`)
2466 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2467 /*!40101 SET character_set_client = @saved_cs_client */;
2470 -- Table structure for table `USED_SEQUENCE_NUMBER`
2473 DROP TABLE IF EXISTS `USED_SEQUENCE_NUMBER`;
2474 /*!40101 SET @saved_cs_client = @@character_set_client */;
2475 /*!40101 SET character_set_client = utf8 */;
2476 CREATE TABLE `USED_SEQUENCE_NUMBER` (
2477 `resource_sequence_number` varchar(10) NOT NULL,
2478 `resource_type` varchar(10) NOT NULL,
2479 `zone_region_id` varchar(50) NOT NULL,
2480 PRIMARY KEY (`resource_sequence_number`,`resource_type`,`zone_region_id`)
2481 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2482 /*!40101 SET character_set_client = @saved_cs_client */;
2485 -- Table structure for table `USER_TRACE`
2488 DROP TABLE IF EXISTS `USER_TRACE`;
2489 /*!40101 SET @saved_cs_client = @@character_set_client */;
2490 /*!40101 SET character_set_client = utf8 */;
2491 CREATE TABLE `USER_TRACE` (
2492 `user_trace_seq` int(11) NOT NULL AUTO_INCREMENT,
2493 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2494 `identity` varchar(12) DEFAULT NULL,
2495 `action` varchar(128) DEFAULT NULL,
2496 `description` varchar(256) DEFAULT NULL,
2497 PRIMARY KEY (`user_trace_seq`)
2498 ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=latin1;
2499 /*!40101 SET character_set_client = @saved_cs_client */;
2502 -- Table structure for table `VENDOR_CODE`
2505 DROP TABLE IF EXISTS `VENDOR_CODE`;
2506 /*!40101 SET @saved_cs_client = @@character_set_client */;
2507 /*!40101 SET character_set_client = utf8 */;
2508 CREATE TABLE `VENDOR_CODE` (
2509 `vendor_code` varchar(1) NOT NULL,
2510 `vendor` varchar(45) NOT NULL DEFAULT '',
2511 PRIMARY KEY (`vendor_code`,`vendor`)
2512 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2513 /*!40101 SET character_set_client = @saved_cs_client */;
2516 -- Table structure for table `VFC_MODEL`
2519 DROP TABLE IF EXISTS `VFC_MODEL`;
2520 /*!40101 SET @saved_cs_client = @@character_set_client */;
2521 /*!40101 SET character_set_client = utf8 */;
2522 CREATE TABLE `VFC_MODEL` (
2523 `customization_uuid` varchar(255) NOT NULL,
2524 `model_yaml` longblob,
2525 `invariant_uuid` varchar(255) DEFAULT NULL,
2526 `uuid` varchar(255) DEFAULT NULL,
2527 `version` varchar(255) DEFAULT NULL,
2528 `naming_policy` varchar(255) DEFAULT NULL,
2529 `ecomp_generated_naming` char(1) DEFAULT NULL,
2530 `nfc_function` varchar(255) DEFAULT NULL,
2531 `nfc_naming_code` varchar(255) DEFAULT NULL,
2532 `vm_type` varchar(255) DEFAULT NULL,
2533 `vm_type_tag` varchar(255) DEFAULT NULL,
2534 `vm_image_name` varchar(255) DEFAULT NULL,
2535 `vm_flavor_name` varchar(255) DEFAULT NULL,
2536 `high_availability` varchar(255) DEFAULT NULL,
2537 `nfc_naming` varchar(255) DEFAULT NULL,
2538 `min_instances` int(11) DEFAULT NULL,
2539 `max_instances` int(11) DEFAULT NULL,
2540 PRIMARY KEY (`customization_uuid`)
2541 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2542 /*!40101 SET character_set_client = @saved_cs_client */;
2545 -- Table structure for table `VFC_TO_NETWORK_ROLE_MAPPING`
2548 DROP TABLE IF EXISTS `VFC_TO_NETWORK_ROLE_MAPPING`;
2549 /*!40101 SET @saved_cs_client = @@character_set_client */;
2550 /*!40101 SET character_set_client = utf8 */;
2551 CREATE TABLE `VFC_TO_NETWORK_ROLE_MAPPING` (
2552 `seq` int(11) NOT NULL AUTO_INCREMENT,
2553 `vfc_customization_uuid` varchar(255) NOT NULL,
2554 `network_role` varchar(255) NOT NULL,
2555 `vm_type` varchar(255) DEFAULT NULL,
2556 `network_role_tag` varchar(255) DEFAULT NULL,
2557 `ipv4_count` int(11) NOT NULL,
2558 `ipv6_count` int(11) NOT NULL,
2559 `ipv4_use_dhcp` char(1) DEFAULT NULL,
2560 `ipv6_use_dhcp` char(1) DEFAULT NULL,
2561 `ipv4_ip_version` char(1) DEFAULT NULL,
2562 `ipv6_ip_version` char(1) DEFAULT NULL,
2563 `extcp_subnetpool_id` varchar(512) DEFAULT NULL,
2564 `ipv4_floating_count` int(11) DEFAULT NULL,
2565 `ipv6_floating_count` int(11) DEFAULT NULL,
2566 `ipv4_address_plan_name` varchar(512) DEFAULT NULL,
2567 `ipv6_address_plan_name` varchar(512) DEFAULT NULL,
2568 `ipv4_vrf_name` varchar(512) DEFAULT NULL,
2569 `ipv6_vrf_name` varchar(512) DEFAULT NULL,
2570 `subnet_role` varchar(255) DEFAULT NULL,
2571 PRIMARY KEY (`seq`),
2572 KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`)
2573 ) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1;
2574 /*!40101 SET character_set_client = @saved_cs_client */;
2577 -- Table structure for table `VF_MODEL`
2580 DROP TABLE IF EXISTS `VF_MODEL`;
2581 /*!40101 SET @saved_cs_client = @@character_set_client */;
2582 /*!40101 SET character_set_client = utf8 */;
2583 CREATE TABLE `VF_MODEL` (
2584 `customization_uuid` varchar(255) NOT NULL,
2585 `model_yaml` longblob,
2586 `invariant_uuid` varchar(255) DEFAULT NULL,
2587 `uuid` varchar(255) DEFAULT NULL,
2588 `version` varchar(255) DEFAULT NULL,
2589 `name` varchar(255) DEFAULT NULL,
2590 `naming_policy` varchar(255) DEFAULT NULL,
2591 `ecomp_generated_naming` char(1) DEFAULT NULL,
2592 `avail_zone_max_count` int(11) DEFAULT NULL,
2593 `nf_function` varchar(255) DEFAULT NULL,
2594 `nf_code` varchar(255) DEFAULT NULL,
2595 `nf_type` varchar(255) DEFAULT NULL,
2596 `nf_role` varchar(255) DEFAULT NULL,
2597 `vendor` varchar(255) DEFAULT NULL,
2598 `vendor_version` varchar(255) DEFAULT NULL,
2599 PRIMARY KEY (`customization_uuid`)
2600 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2601 /*!40101 SET character_set_client = @saved_cs_client */;
2604 -- Table structure for table `VF_MODULE_MODEL`
2607 DROP TABLE IF EXISTS `VF_MODULE_MODEL`;
2608 /*!40101 SET @saved_cs_client = @@character_set_client */;
2609 /*!40101 SET character_set_client = utf8 */;
2610 CREATE TABLE `VF_MODULE_MODEL` (
2611 `customization_uuid` varchar(255) NOT NULL,
2612 `model_yaml` longblob,
2613 `invariant_uuid` varchar(255) DEFAULT NULL,
2614 `uuid` varchar(255) DEFAULT NULL,
2615 `version` varchar(255) DEFAULT NULL,
2616 `vf_module_type` varchar(255) DEFAULT NULL,
2617 `availability_zone_count` int(11) DEFAULT NULL,
2618 `ecomp_generated_vm_assignments` char(1) DEFAULT NULL,
2619 PRIMARY KEY (`customization_uuid`)
2620 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2621 /*!40101 SET character_set_client = @saved_cs_client */;
2624 -- Table structure for table `VF_MODULE_TO_VFC_MAPPING`
2627 DROP TABLE IF EXISTS `VF_MODULE_TO_VFC_MAPPING`;
2628 /*!40101 SET @saved_cs_client = @@character_set_client */;
2629 /*!40101 SET character_set_client = utf8 */;
2630 CREATE TABLE `VF_MODULE_TO_VFC_MAPPING` (
2631 `seq` int(11) NOT NULL AUTO_INCREMENT,
2632 `vf_module_customization_uuid` varchar(255) NOT NULL,
2633 `vfc_customization_uuid` varchar(255) NOT NULL,
2634 `vm_type` varchar(255) NOT NULL,
2635 `vm_count` int(11) NOT NULL,
2636 PRIMARY KEY (`seq`),
2637 KEY `IX1_VF_MODULE_TO_VFC_MAPPING` (`vf_module_customization_uuid`)
2638 ) ENGINE=InnoDB AUTO_INCREMENT=1591 DEFAULT CHARSET=latin1;
2639 /*!40101 SET character_set_client = @saved_cs_client */;
2642 -- Table structure for table `VF_TO_NETWORK_ROLE_MAPPING`
2645 DROP TABLE IF EXISTS `VF_TO_NETWORK_ROLE_MAPPING`;
2646 /*!40101 SET @saved_cs_client = @@character_set_client */;
2647 /*!40101 SET character_set_client = utf8 */;
2648 CREATE TABLE `VF_TO_NETWORK_ROLE_MAPPING` (
2649 `seq` int(11) NOT NULL AUTO_INCREMENT,
2650 `vf_customization_uuid` varchar(255) NOT NULL,
2651 `network_role` varchar(255) NOT NULL,
2652 PRIMARY KEY (`seq`),
2653 KEY `IX1_VF_TO_NETWORK_ROLE_MAPPING` (`vf_customization_uuid`)
2654 ) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=latin1;
2655 /*!40101 SET character_set_client = @saved_cs_client */;
2658 -- Table structure for table `VIPR_CONFIGURATION`
2661 DROP TABLE IF EXISTS `VIPR_CONFIGURATION`;
2662 /*!40101 SET @saved_cs_client = @@character_set_client */;
2663 /*!40101 SET character_set_client = utf8 */;
2664 CREATE TABLE `VIPR_CONFIGURATION` (
2665 `seq` int(11) NOT NULL AUTO_INCREMENT,
2666 `serial_number` varchar(255) DEFAULT NULL,
2667 `vnf_id` varchar(255) DEFAULT NULL,
2668 `vnf_name` varchar(255) DEFAULT NULL,
2669 `ecomp_service_instance_id` varchar(255) DEFAULT NULL,
2670 `vm_name` varchar(255) DEFAULT NULL,
2671 `cloud_region_id` varchar(255) DEFAULT NULL,
2672 `cloud_owner` varchar(255) DEFAULT NULL,
2674 ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
2675 /*!40101 SET character_set_client = @saved_cs_client */;
2678 -- Table structure for table `VIPR_SZ_MANAGER_KEY`
2681 DROP TABLE IF EXISTS `VIPR_SZ_MANAGER_KEY`;
2682 /*!40101 SET @saved_cs_client = @@character_set_client */;
2683 /*!40101 SET character_set_client = utf8 */;
2684 CREATE TABLE `VIPR_SZ_MANAGER_KEY` (
2685 `vipr_sz_manager_ip_addr` varchar(40) NOT NULL,
2686 `vipr_sz_manager_state` varchar(10) DEFAULT NULL,
2687 `vipr_sz_manager_api_key` varchar(255) DEFAULT NULL,
2688 PRIMARY KEY (`vipr_sz_manager_ip_addr`)
2689 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2690 /*!40101 SET character_set_client = @saved_cs_client */;
2693 -- Table structure for table `VLAN_ID_POOL`
2696 DROP TABLE IF EXISTS `VLAN_ID_POOL`;
2697 /*!40101 SET @saved_cs_client = @@character_set_client */;
2698 /*!40101 SET character_set_client = utf8 */;
2699 CREATE TABLE `VLAN_ID_POOL` (
2700 `aic_site_id` varchar(100) NOT NULL,
2701 `purpose` varchar(40) NOT NULL,
2702 `status` varchar(40) NOT NULL,
2703 `vlan_id` int(4) NOT NULL,
2704 `svc_instance_id` varchar(80) DEFAULT NULL,
2705 `availability_zone` varchar(100) DEFAULT NULL,
2706 `vplspe_name` varchar(80) DEFAULT NULL,
2707 PRIMARY KEY (`vlan_id`,`aic_site_id`,`purpose`)
2708 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2709 /*!40101 SET character_set_client = @saved_cs_client */;
2712 -- Table structure for table `VLAN_L3INTERFACE_IPV4_ADDRESS`
2715 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV4_ADDRESS`;
2716 /*!40101 SET @saved_cs_client = @@character_set_client */;
2717 /*!40101 SET character_set_client = utf8 */;
2718 CREATE TABLE `VLAN_L3INTERFACE_IPV4_ADDRESS` (
2719 `vnf_id` varchar(80) NOT NULL,
2720 `interface_name` varchar(255) NOT NULL,
2721 `vlan_interface` varchar(255) NOT NULL,
2722 `l3_interface_ipv4_address` varchar(64) NOT NULL,
2723 `l3_interface_ipv4_prefix_length` varchar(45) DEFAULT NULL,
2724 `vlan_id_inner` varchar(45) DEFAULT NULL,
2725 `vlan_id_outer` varchar(45) DEFAULT NULL,
2726 `is_floating` varchar(1) DEFAULT NULL,
2727 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv4_address`),
2728 KEY `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`),
2729 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
2730 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2731 /*!40101 SET character_set_client = @saved_cs_client */;
2734 -- Table structure for table `VLAN_L3INTERFACE_IPV6_ADDRESS`
2737 DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV6_ADDRESS`;
2738 /*!40101 SET @saved_cs_client = @@character_set_client */;
2739 /*!40101 SET character_set_client = utf8 */;
2740 CREATE TABLE `VLAN_L3INTERFACE_IPV6_ADDRESS` (
2741 `vnf_id` varchar(80) NOT NULL,
2742 `interface_name` varchar(255) NOT NULL,
2743 `vlan_interface` varchar(255) NOT NULL,
2744 `l3_interface_ipv6_address` varchar(64) NOT NULL,
2745 `l3_interface_ipv6_prefix_length` varchar(45) DEFAULT NULL,
2746 `vlan_id_inner` varchar(45) DEFAULT NULL,
2747 `vlan_id_outer` varchar(45) DEFAULT NULL,
2748 `is_floating` varchar(1) DEFAULT NULL,
2749 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv6_address`),
2750 KEY `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`,`vlan_interface`),
2751 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
2752 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2753 /*!40101 SET character_set_client = @saved_cs_client */;
2756 -- Table structure for table `VLAN_PLAN_ID`
2759 DROP TABLE IF EXISTS `VLAN_PLAN_ID`;
2760 /*!40101 SET @saved_cs_client = @@character_set_client */;
2761 /*!40101 SET character_set_client = utf8 */;
2762 CREATE TABLE `VLAN_PLAN_ID` (
2763 `plan_type` varchar(40) NOT NULL,
2764 `purpose` varchar(40) NOT NULL,
2765 `vlan_plan_id_count` int(4) NOT NULL,
2766 PRIMARY KEY (`vlan_plan_id_count`,`plan_type`,`purpose`)
2767 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2768 /*!40101 SET character_set_client = @saved_cs_client */;
2771 -- Table structure for table `VLAN_POOL`
2774 DROP TABLE IF EXISTS `VLAN_POOL`;
2775 /*!40101 SET @saved_cs_client = @@character_set_client */;
2776 /*!40101 SET character_set_client = utf8 */;
2777 CREATE TABLE `VLAN_POOL` (
2778 `aic_site_id` varchar(100) NOT NULL,
2779 `availability_zone` varchar(100) NOT NULL,
2780 `vlan_plan_id` varchar(100) NOT NULL,
2781 `plan_type` varchar(40) NOT NULL,
2782 `purpose` varchar(40) NOT NULL,
2783 `vlan_id` int(4) NOT NULL,
2784 `status` varchar(40) NOT NULL,
2785 `reserved_id` varchar(80) DEFAULT NULL,
2786 PRIMARY KEY (`aic_site_id`,`availability_zone`,`vlan_plan_id`,`plan_type`,`purpose`,`vlan_id`)
2787 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2788 /*!40101 SET character_set_client = @saved_cs_client */;
2791 -- Table structure for table `VLAN_RANGES`
2794 DROP TABLE IF EXISTS `VLAN_RANGES`;
2795 /*!40101 SET @saved_cs_client = @@character_set_client */;
2796 /*!40101 SET character_set_client = utf8 */;
2797 CREATE TABLE `VLAN_RANGES` (
2798 `vlan_plan_id` varchar(100) NOT NULL,
2799 `plan_type` varchar(40) NOT NULL,
2800 `purpose` varchar(40) NOT NULL,
2801 `range_start` int(4) NOT NULL,
2802 `range_end` int(4) NOT NULL,
2803 `generated` char(1) DEFAULT NULL,
2804 PRIMARY KEY (`vlan_plan_id`,`plan_type`,`purpose`,`range_start`,`range_end`)
2805 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2806 /*!40101 SET character_set_client = @saved_cs_client */;
2809 -- Table structure for table `VM_NAME_INDEX`
2812 DROP TABLE IF EXISTS `VM_NAME_INDEX`;
2813 /*!40101 SET @saved_cs_client = @@character_set_client */;
2814 /*!40101 SET character_set_client = utf8 */;
2815 CREATE TABLE `VM_NAME_INDEX` (
2816 `vm_name_prefix` varchar(255) NOT NULL,
2817 `index_number` int(11) NOT NULL,
2818 PRIMARY KEY (`vm_name_prefix`)
2819 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2820 /*!40101 SET character_set_client = @saved_cs_client */;
2823 -- Table structure for table `VM_NETWORKS`
2826 DROP TABLE IF EXISTS `VM_NETWORKS`;
2827 /*!40101 SET @saved_cs_client = @@character_set_client */;
2828 /*!40101 SET character_set_client = utf8 */;
2829 CREATE TABLE `VM_NETWORKS` (
2830 `vnf_type` varchar(200) NOT NULL,
2831 `vm_type` varchar(45) NOT NULL,
2832 `network_role` varchar(45) NOT NULL,
2833 `assign_ips` tinyint(1) NOT NULL,
2834 `assign_macs` tinyint(1) NOT NULL,
2835 `assign_floating_ip` tinyint(1) NOT NULL,
2836 `ip_count` int(11) DEFAULT NULL,
2837 PRIMARY KEY (`vnf_type`,`vm_type`,`network_role`)
2838 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2839 /*!40101 SET character_set_client = @saved_cs_client */;
2842 -- Table structure for table `VM_PROFILE`
2845 DROP TABLE IF EXISTS `VM_PROFILE`;
2846 /*!40101 SET @saved_cs_client = @@character_set_client */;
2847 /*!40101 SET character_set_client = utf8 */;
2848 CREATE TABLE `VM_PROFILE` (
2849 `vnf_type` varchar(200) NOT NULL,
2850 `vm_type` varchar(45) NOT NULL,
2851 `vm_count` int(11) NOT NULL,
2852 PRIMARY KEY (`vnf_type`,`vm_type`)
2853 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2854 /*!40101 SET character_set_client = @saved_cs_client */;
2857 -- Table structure for table `VNF`
2860 DROP TABLE IF EXISTS `VNF`;
2861 /*!40101 SET @saved_cs_client = @@character_set_client */;
2862 /*!40101 SET character_set_client = utf8 */;
2863 CREATE TABLE `VNF` (
2864 `vnf_id` varchar(80) NOT NULL,
2865 `vnf_name` varchar(80) NOT NULL,
2866 `vnf_type` varchar(10) NOT NULL,
2867 `orchestration_status` varchar(20) DEFAULT NULL,
2868 `heat_stack_id` varchar(80) DEFAULT NULL,
2869 `mso_catalog_key` varchar(80) DEFAULT NULL,
2870 `availability_zone` varchar(80) DEFAULT NULL,
2871 `aic_site_id` varchar(80) DEFAULT NULL,
2872 `oam_ipv4_address` varchar(20) DEFAULT NULL,
2873 `vnf_name2` varchar(80) DEFAULT NULL,
2874 `vpe_id` varchar(80) NOT NULL,
2875 `ipv4_loopback0_address` varchar(80) DEFAULT NULL,
2876 `license_key` varchar(256) DEFAULT NULL,
2877 `entitlement_resource_uuid` varchar(256) DEFAULT NULL,
2878 PRIMARY KEY (`vnf_id`)
2879 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2880 /*!40101 SET character_set_client = @saved_cs_client */;
2883 -- Table structure for table `VNFC_DG_MAPPING`
2886 DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
2887 /*!40101 SET @saved_cs_client = @@character_set_client */;
2888 /*!40101 SET character_set_client = utf8 */;
2889 CREATE TABLE `VNFC_DG_MAPPING` (
2890 `vnfc_dg_mapping_id` int(11) NOT NULL AUTO_INCREMENT,
2891 `action` varchar(50) DEFAULT NULL,
2892 `api_version` varchar(10) DEFAULT NULL,
2893 `vnf_type` varchar(50) DEFAULT NULL,
2894 `vnfc_type` varchar(50) DEFAULT NULL,
2895 `dg_name` varchar(50) NOT NULL,
2896 `dg_version` varchar(50) DEFAULT NULL,
2897 `dg_module` varchar(50) NOT NULL,
2898 PRIMARY KEY (`vnfc_dg_mapping_id`),
2899 UNIQUE KEY `input_constraint` (`action`,`api_version`,`vnf_type`,`vnfc_type`)
2900 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2901 /*!40101 SET character_set_client = @saved_cs_client */;
2904 -- Table structure for table `VNFC_REFERENCE`
2907 DROP TABLE IF EXISTS `VNFC_REFERENCE`;
2908 /*!40101 SET @saved_cs_client = @@character_set_client */;
2909 /*!40101 SET character_set_client = utf8 */;
2910 CREATE TABLE `VNFC_REFERENCE` (
2911 `vnfc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
2912 `action` varchar(50) NOT NULL,
2913 `vnf_type` varchar(50) NOT NULL,
2914 `vm_instance` int(11) NOT NULL,
2915 `vnfc_instance` int(11) NOT NULL,
2916 `vnfc_type` varchar(50) NOT NULL,
2917 `vnfc_function_code` varchar(50) NOT NULL,
2918 `ipaddress_v4_oam_vip` varchar(50) DEFAULT NULL,
2919 `group_notation_type` varchar(50) DEFAULT NULL,
2920 `group_notation_value` varchar(50) DEFAULT NULL,
2921 PRIMARY KEY (`vnfc_reference_id`),
2922 UNIQUE KEY `vnfc_reference_id` (`vnfc_reference_id`)
2923 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2924 /*!40101 SET character_set_client = @saved_cs_client */;
2927 -- Table structure for table `VNF_IMAGE`
2930 DROP TABLE IF EXISTS `VNF_IMAGE`;
2931 /*!40101 SET @saved_cs_client = @@character_set_client */;
2932 /*!40101 SET character_set_client = utf8 */;
2933 CREATE TABLE `VNF_IMAGE` (
2934 `application_vendor` varchar(255) NOT NULL,
2935 `application_version` varchar(255) NOT NULL,
2936 `att_uuid` varchar(255) NOT NULL,
2937 `application` varchar(255) DEFAULT NULL,
2938 `selflink` varchar(255) DEFAULT NULL,
2939 PRIMARY KEY (`application_vendor`,`application_version`,`att_uuid`)
2940 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2941 /*!40101 SET character_set_client = @saved_cs_client */;
2944 -- Table structure for table `VNF_MODEL_LICENSES`
2947 DROP TABLE IF EXISTS `VNF_MODEL_LICENSES`;
2948 /*!40101 SET @saved_cs_client = @@character_set_client */;
2949 /*!40101 SET character_set_client = utf8 */;
2950 CREATE TABLE `VNF_MODEL_LICENSES` (
2951 `att_part_number` varchar(255) NOT NULL,
2952 `license_assignment_group` varchar(255) NOT NULL,
2953 `license_required` tinyint(1) DEFAULT NULL,
2954 `entitlement_assignment_group` varchar(255) DEFAULT NULL,
2955 `entitlement_required` tinyint(1) DEFAULT '0',
2956 `feature_group_uuid` varchar(255) DEFAULT NULL,
2957 PRIMARY KEY (`att_part_number`,`license_assignment_group`)
2958 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2959 /*!40101 SET character_set_client = @saved_cs_client */;
2962 -- Table structure for table `VNF_MODEL_LICENSE_FEATURES`
2965 DROP TABLE IF EXISTS `VNF_MODEL_LICENSE_FEATURES`;
2966 /*!40101 SET @saved_cs_client = @@character_set_client */;
2967 /*!40101 SET character_set_client = utf8 */;
2968 CREATE TABLE `VNF_MODEL_LICENSE_FEATURES` (
2969 `att_part_number` varchar(255) NOT NULL,
2970 `license_assignment_group` varchar(255) NOT NULL,
2971 `feature` varchar(255) NOT NULL,
2972 PRIMARY KEY (`att_part_number`,`license_assignment_group`,`feature`)
2973 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2974 /*!40101 SET character_set_client = @saved_cs_client */;
2977 -- Table structure for table `VNF_NAME_INDEX`
2980 DROP TABLE IF EXISTS `VNF_NAME_INDEX`;
2981 /*!40101 SET @saved_cs_client = @@character_set_client */;
2982 /*!40101 SET character_set_client = utf8 */;
2983 CREATE TABLE `VNF_NAME_INDEX` (
2984 `vnf_name_prefix` varchar(255) NOT NULL,
2985 `index_number` int(11) NOT NULL,
2986 PRIMARY KEY (`vnf_name_prefix`)
2987 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2988 /*!40101 SET character_set_client = @saved_cs_client */;
2991 -- Table structure for table `VNF_NETWORKS`
2994 DROP TABLE IF EXISTS `VNF_NETWORKS`;
2995 /*!40101 SET @saved_cs_client = @@character_set_client */;
2996 /*!40101 SET character_set_client = utf8 */;
2997 CREATE TABLE `VNF_NETWORKS` (
2998 `vnf_type` varchar(200) NOT NULL,
2999 `network_role` varchar(45) NOT NULL,
3000 PRIMARY KEY (`vnf_type`,`network_role`)
3001 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3002 /*!40101 SET character_set_client = @saved_cs_client */;
3005 -- Table structure for table `VNF_NETWORK_CONNECTION`
3008 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION`;
3009 /*!40101 SET @saved_cs_client = @@character_set_client */;
3010 /*!40101 SET character_set_client = utf8 */;
3011 CREATE TABLE `VNF_NETWORK_CONNECTION` (
3012 `connection_uuid` varchar(80) NOT NULL,
3013 `vnf_id` varchar(80) NOT NULL,
3014 `connection_id` varchar(80) DEFAULT NULL,
3015 `connection_type` varchar(20) DEFAULT NULL,
3016 `neutron_network_id` varchar(80) DEFAULT NULL,
3017 `neutron_network_name` varchar(80) DEFAULT NULL,
3018 `orchestration_status` varchar(20) DEFAULT NULL,
3019 `switch_id` varchar(40) DEFAULT NULL,
3020 `heat_stack_id` varchar(80) DEFAULT NULL,
3021 `mso_catalog_key` varchar(80) DEFAULT NULL,
3022 `provider_network` varchar(80) DEFAULT NULL,
3023 `port_group_id` varchar(80) DEFAULT NULL,
3024 `port_group_name` varchar(80) DEFAULT NULL,
3025 PRIMARY KEY (`connection_uuid`)
3026 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3027 /*!40101 SET character_set_client = @saved_cs_client */;
3030 -- Table structure for table `VNF_NETWORK_CONNECTION_VLAN`
3033 DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION_VLAN`;
3034 /*!40101 SET @saved_cs_client = @@character_set_client */;
3035 /*!40101 SET character_set_client = utf8 */;
3036 CREATE TABLE `VNF_NETWORK_CONNECTION_VLAN` (
3037 `vlan_uuid` varchar(80) NOT NULL,
3038 `vlan_id` int(4) NOT NULL,
3039 `vlan_type` varchar(5) NOT NULL,
3040 `connection_uuid` varchar(80) DEFAULT NULL,
3041 PRIMARY KEY (`vlan_uuid`)
3042 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3043 /*!40101 SET character_set_client = @saved_cs_client */;
3046 -- Table structure for table `VNF_PROFILE`
3049 DROP TABLE IF EXISTS `VNF_PROFILE`;
3050 /*!40101 SET @saved_cs_client = @@character_set_client */;
3051 /*!40101 SET character_set_client = utf8 */;
3052 CREATE TABLE `VNF_PROFILE` (
3053 `vnf_type` varchar(200) NOT NULL,
3054 `availability_zone_count` int(11) NOT NULL,
3055 `equipment_role` varchar(80) NOT NULL,
3056 PRIMARY KEY (`vnf_type`)
3057 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3058 /*!40101 SET character_set_client = @saved_cs_client */;
3061 -- Table structure for table `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`
3064 DROP TABLE IF EXISTS `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`;
3065 /*!40101 SET @saved_cs_client = @@character_set_client */;
3066 /*!40101 SET character_set_client = utf8 */;
3067 CREATE TABLE `VNF_SERVICE_TO_NETWORK_ROLE_FILTER` (
3068 `vnf_service_type` varchar(60) NOT NULL,
3069 `network_role_filter` varchar(60) NOT NULL,
3070 PRIMARY KEY (`vnf_service_type`,`network_role_filter`)
3071 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3072 /*!40101 SET character_set_client = @saved_cs_client */;
3075 -- Table structure for table `VPE_LOCK`
3078 DROP TABLE IF EXISTS `VPE_LOCK`;
3079 /*!40101 SET @saved_cs_client = @@character_set_client */;
3080 /*!40101 SET character_set_client = utf8 */;
3081 CREATE TABLE `VPE_LOCK` (
3082 `vpe_name` varchar(20) NOT NULL,
3083 `vpn_lock` varchar(20) NOT NULL,
3084 PRIMARY KEY (`vpe_name`)
3085 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3086 /*!40101 SET character_set_client = @saved_cs_client */;
3089 -- Table structure for table `VPE_MAC_ADDRESS_POOL`
3092 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_POOL`;
3093 /*!40101 SET @saved_cs_client = @@character_set_client */;
3094 /*!40101 SET character_set_client = utf8 */;
3095 CREATE TABLE `VPE_MAC_ADDRESS_POOL` (
3096 `id` int(11) NOT NULL,
3097 `mac_address` varchar(50) NOT NULL,
3098 `sw_name` varchar(30) NOT NULL,
3100 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3101 /*!40101 SET character_set_client = @saved_cs_client */;
3104 -- Table structure for table `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`
3107 DROP TABLE IF EXISTS `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`;
3108 /*!40101 SET @saved_cs_client = @@character_set_client */;
3109 /*!40101 SET character_set_client = utf8 */;
3110 CREATE TABLE `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING` (
3111 `id` int(11) NOT NULL,
3112 `hostname` varchar(50) NOT NULL,
3113 `assigned_user` varchar(25) NOT NULL,
3114 `assigned_date` date DEFAULT NULL,
3116 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3117 /*!40101 SET character_set_client = @saved_cs_client */;
3120 -- Table structure for table `VPE_POOL`
3123 DROP TABLE IF EXISTS `VPE_POOL`;
3124 /*!40101 SET @saved_cs_client = @@character_set_client */;
3125 /*!40101 SET character_set_client = utf8 */;
3126 CREATE TABLE `VPE_POOL` (
3127 `vpe_name` varchar(20) NOT NULL,
3128 `ipv4_oam_address` varchar(20) NOT NULL,
3129 `loopback0_ipv4_address` varchar(20) NOT NULL,
3130 `provisioning_status` varchar(10) NOT NULL,
3131 `aic_site_id` varchar(100) NOT NULL,
3132 `availability_zone` varchar(100) NOT NULL,
3133 `vlan_id_outer` varchar(20) NOT NULL,
3134 `vendor` varchar(20) NOT NULL,
3135 `physical_intf_name` varchar(40) NOT NULL,
3136 `physical_intf_speed` varchar(20) NOT NULL,
3137 `physical_intf_units` varchar(20) NOT NULL,
3138 `vpe_uuid` varchar(80) DEFAULT NULL,
3139 `vpe_id` varchar(80) NOT NULL,
3140 `image_filename` varchar(100) DEFAULT NULL,
3141 `as_number` varchar(20) NOT NULL,
3142 `loopback5000` varchar(16) DEFAULT NULL,
3143 `loopback10` varchar(16) DEFAULT NULL,
3144 `aic_version` varchar(50) DEFAULT NULL,
3145 `vpe_capacity` int(11) NOT NULL,
3146 PRIMARY KEY (`aic_site_id`,`vpe_name`,`availability_zone`)
3147 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3148 /*!40101 SET character_set_client = @saved_cs_client */;
3151 -- Table structure for table `VPLSPE_POOL`
3154 DROP TABLE IF EXISTS `VPLSPE_POOL`;
3155 /*!40101 SET @saved_cs_client = @@character_set_client */;
3156 /*!40101 SET character_set_client = utf8 */;
3157 CREATE TABLE `VPLSPE_POOL` (
3158 `vplspe_name` varchar(20) NOT NULL,
3159 `aic_site_id` varchar(100) NOT NULL,
3160 `availability_zone` varchar(100) NOT NULL,
3161 `physical_intf_name` varchar(40) NOT NULL,
3162 `physical_intf_speed` varchar(20) NOT NULL,
3163 `physical_intf_units` varchar(20) NOT NULL,
3164 `loopback0_ipv4_address` varchar(20) NOT NULL,
3165 `vlan_id_outer` varchar(20) NOT NULL,
3166 `vplspe_uuid` varchar(80) DEFAULT NULL,
3167 `image_filename` varchar(100) DEFAULT NULL,
3168 `provisioning_status` varchar(10) DEFAULT NULL,
3169 `vendor` varchar(20) DEFAULT NULL,
3170 PRIMARY KEY (`vplspe_name`,`aic_site_id`,`availability_zone`,`physical_intf_name`)
3171 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3172 /*!40101 SET character_set_client = @saved_cs_client */;
3175 -- Table structure for table `VPN_BINDINGS`
3178 DROP TABLE IF EXISTS `VPN_BINDINGS`;
3179 /*!40101 SET @saved_cs_client = @@character_set_client */;
3180 /*!40101 SET character_set_client = utf8 */;
3181 CREATE TABLE `VPN_BINDINGS` (
3182 `network_customization_uuid` varchar(255) NOT NULL,
3183 `binding_uuid` varchar(255) NOT NULL,
3184 PRIMARY KEY (`network_customization_uuid`,`binding_uuid`)
3185 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3186 /*!40101 SET character_set_client = @saved_cs_client */;
3189 -- Table structure for table `VRR_FUNCTION_CODE_VMTYPE_MAPPING`
3192 DROP TABLE IF EXISTS `VRR_FUNCTION_CODE_VMTYPE_MAPPING`;
3193 /*!40101 SET @saved_cs_client = @@character_set_client */;
3194 /*!40101 SET character_set_client = utf8 */;
3195 CREATE TABLE `VRR_FUNCTION_CODE_VMTYPE_MAPPING` (
3196 `ptnii_function_code` varchar(128) NOT NULL,
3197 `vm_type` varchar(128) NOT NULL,
3198 PRIMARY KEY (`ptnii_function_code`,`vm_type`)
3199 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3200 /*!40101 SET character_set_client = @saved_cs_client */;
3203 -- Table structure for table `VSERVER`
3206 DROP TABLE IF EXISTS `VSERVER`;
3207 /*!40101 SET @saved_cs_client = @@character_set_client */;
3208 /*!40101 SET character_set_client = utf8 */;
3209 CREATE TABLE `VSERVER` (
3210 `tenant_id` varchar(40) NOT NULL,
3211 `vserver_id` varchar(40) NOT NULL,
3212 `aic_site_id` varchar(100) NOT NULL,
3213 `vendor` varchar(20) NOT NULL,
3214 `image_name` varchar(100) NOT NULL,
3215 `vnf_type` varchar(10) NOT NULL,
3216 `vnf_id` varchar(80) NOT NULL,
3217 PRIMARY KEY (`tenant_id`,`vserver_id`)
3218 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3219 /*!40101 SET character_set_client = @saved_cs_client */;
3222 -- Table structure for table `VSERVER2`
3225 DROP TABLE IF EXISTS `VSERVER2`;
3226 /*!40101 SET @saved_cs_client = @@character_set_client */;
3227 /*!40101 SET character_set_client = utf8 */;
3228 CREATE TABLE `VSERVER2` (
3229 `tenant_id` varchar(255) NOT NULL,
3230 `vserver_id` varchar(128) NOT NULL,
3231 `vserver_name` varchar(255) NOT NULL,
3232 `vserver_name2` varchar(255) DEFAULT NULL,
3233 `prov_status` varchar(20) DEFAULT NULL,
3234 `selflink` varchar(255) DEFAULT NULL,
3235 PRIMARY KEY (`tenant_id`,`vserver_id`)
3236 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3237 /*!40101 SET character_set_client = @saved_cs_client */;
3240 -- Table structure for table `VSERVER_PSERVER`
3243 DROP TABLE IF EXISTS `VSERVER_PSERVER`;
3244 /*!40101 SET @saved_cs_client = @@character_set_client */;
3245 /*!40101 SET character_set_client = utf8 */;
3246 CREATE TABLE `VSERVER_PSERVER` (
3247 `vserver_id` varchar(128) NOT NULL,
3248 `pserver_hostname` varchar(255) DEFAULT NULL,
3249 PRIMARY KEY (`vserver_id`)
3250 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3251 /*!40101 SET character_set_client = @saved_cs_client */;
3254 -- Table structure for table `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`
3257 DROP TABLE IF EXISTS `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`;
3258 /*!40101 SET @saved_cs_client = @@character_set_client */;
3259 /*!40101 SET character_set_client = utf8 */;
3260 CREATE TABLE `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING` (
3261 `key_id` varchar(128) NOT NULL,
3262 `cloud_region` varchar(128) NOT NULL,
3263 `key_type` varchar(128) NOT NULL,
3264 PRIMARY KEY (`key_id`,`cloud_region`,`key_type`)
3265 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3266 /*!40101 SET character_set_client = @saved_cs_client */;
3269 -- Table structure for table `WAN_COMBO_ALLOWABLE`
3272 DROP TABLE IF EXISTS `WAN_COMBO_ALLOWABLE`;
3273 /*!40101 SET @saved_cs_client = @@character_set_client */;
3274 /*!40101 SET character_set_client = utf8 */;
3275 CREATE TABLE `WAN_COMBO_ALLOWABLE` (
3276 `combo_sequence` int(11) NOT NULL AUTO_INCREMENT,
3277 `topology` varchar(16) DEFAULT 'unknown',
3278 `internet_topology` varchar(20) DEFAULT NULL,
3279 `wan1` varchar(40) DEFAULT NULL,
3280 `wan2` varchar(40) DEFAULT NULL,
3281 `new_start_release_flexware` varchar(16) DEFAULT 'unknown',
3282 `is_active_flexware` varchar(1) DEFAULT 'N',
3283 `new_start_release_dhv` varchar(16) DEFAULT 'unknown',
3284 `is_active_dhv` varchar(1) DEFAULT 'N',
3285 `ucpe_type` varchar(32) DEFAULT 'stand-alone',
3286 `description` varchar(128) NOT NULL,
3287 PRIMARY KEY (`combo_sequence`),
3288 UNIQUE KEY `IX1_WAN_COMBO_ALLOWABLE` (`internet_topology`,`wan1`,`wan2`)
3289 ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
3290 /*!40101 SET character_set_client = @saved_cs_client */;
3292 DROP TABLE IF EXISTS `DHCP_MAP`;
3293 /*!40101 SET @saved_cs_client = @@character_set_client */;
3294 /*!40101 SET character_set_client = utf8 */;
3295 CREATE TABLE `DHCP_MAP` (
3296 `mac_addr` varchar(128) NOT NULL,
3297 `ip_addr` varchar(128) DEFAULT NULL,
3298 PRIMARY KEY (`mac_addr`)
3299 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3301 DROP TABLE IF EXISTS `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING`;
3302 CREATE TABLE `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING` (
3303 `group_uuid` varchar(255) NOT NULL,
3304 `parent_uuid` varchar(255) NOT NULL,
3305 `target_node_uuid` varchar(255) NOT NULL,
3306 `target_type` varchar(255) NULL,
3307 `table_name` varchar(255) NULL,
3308 PRIMARY KEY (`group_uuid`, `parent_uuid`, `target_node_uuid`)
3309 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3311 /*!40101 SET character_set_client = @saved_cs_client */;
3312 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3314 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3315 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3316 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3317 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3318 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3319 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3320 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3322 DROP TABLE IF EXISTS `ATTRIBUTE_VALUE_PAIR`;
3323 CREATE TABLE `ATTRIBUTE_VALUE_PAIR` (
3324 `resource_uuid` varchar(255) NOT NULL,
3325 `attribute_name` varchar(255) NOT NULL,
3326 `resource_type` varchar(255) NOT NULL,
3327 `attribute_value` varchar(255) DEFAULT NULL,
3328 `resource_customization_uuid` varchar(255) DEFAULT NULL,
3329 PRIMARY KEY (`resource_uuid`,`attribute_name`,`resource_type`)
3330 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3332 DROP TABLE IF EXISTS `COMPLEX_RESOURCE`;
3333 CREATE TABLE `COMPLEX_RESOURCE` (
3334 `uuid` varchar(255) NOT NULL,
3335 `model_yaml` longblob,
3336 `invariant_uuid` varchar(255) NOT NULL,
3337 `customization_uuid` varchar(255) NOT NULL,
3338 `version` varchar(255) DEFAULT NULL,
3339 `name` varchar(255) DEFAULT NULL,
3340 `description` varchar(255) DEFAULT NULL,
3341 `type` varchar(255) NOT NULL,
3342 PRIMARY KEY (`uuid`,`customization_uuid`)
3343 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3345 DROP TABLE IF EXISTS `NODE_CAPABILITY`;
3346 CREATE TABLE `NODE_CAPABILITY` (
3347 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
3348 `capability_provider_uuid` varchar(255) NOT NULL,
3349 `capability_provider_customization_uuid` varchar(255) NOT NULL,
3350 `capability_name` varchar(255) DEFAULT NULL,
3351 `capability_type` varchar(255) DEFAULT NULL,
3352 PRIMARY KEY (`capability_id`)
3353 ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
3355 DROP TABLE IF EXISTS `NODE_REQUIREMENT`;
3356 CREATE TABLE `NODE_REQUIREMENT` (
3357 `requirement_id` int(11) NOT NULL AUTO_INCREMENT,
3358 `capability_id` int(11) DEFAULT NULL,
3359 `capability_provider_uuid` varchar(255) DEFAULT NULL,
3360 `capability_provider_customization_uuid` varchar(255) DEFAULT NULL,
3361 `capability_consumer_uuid` varchar(255) NOT NULL,
3362 `capability_consumer_customization_uuid` varchar(255) NOT NULL,
3363 `requirement_name` varchar(255) NOT NULL,
3364 PRIMARY KEY (`requirement_id`),
3365 KEY `NODE_REQUIREMENT_TO_NODE_CAPABILITY` (`capability_id`)
3366 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
3368 DROP TABLE IF EXISTS `RELATED_NETWORK_ROLE`;
3369 CREATE TABLE `RELATED_NETWORK_ROLE` (
3370 `network_model_customization_uuid` varchar(255) NOT NULL,
3371 `related_network_role` varchar(255) NOT NULL,
3372 PRIMARY KEY (`network_model_customization_uuid`,`related_network_role`)
3373 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3375 DROP TABLE IF EXISTS `RESOURCE_GROUP`;
3376 CREATE TABLE `RESOURCE_GROUP` (
3377 `resource_uuid` varchar(255) NOT NULL,
3378 `group_uuid` varchar(255) NOT NULL,
3379 `group_customization_uuid` varchar(255) DEFAULT NULL,
3380 `group_invariant_uuid` varchar(255) NOT NULL,
3381 `group_name` varchar(255) DEFAULT NULL,
3382 `version` varchar(255) DEFAULT NULL,
3383 `group_type` varchar(255) DEFAULT NULL,
3384 PRIMARY KEY (`resource_uuid`,`group_uuid`)
3385 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3387 DROP TABLE IF EXISTS `RESOURCE_POLICY`;
3388 CREATE TABLE `RESOURCE_POLICY` (
3389 `resource_uuid` varchar(255) NOT NULL,
3390 `policy_uuid` varchar(255) NOT NULL,
3391 `policy_customization_uuid` varchar(255) DEFAULT NULL,
3392 `policy_invariant_uuid` varchar(255) NOT NULL,
3393 `policy_name` varchar(255) DEFAULT NULL,
3394 `version` varchar(255) DEFAULT NULL,
3395 `policy_type` varchar(255) DEFAULT NULL,
3396 `property_type` varchar(255) DEFAULT NULL,
3397 `property_source` varchar(255) DEFAULT NULL,
3398 `property_name` varchar(255) DEFAULT NULL,
3399 PRIMARY KEY (`resource_uuid`,`policy_uuid`)
3400 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3402 DROP TABLE IF EXISTS `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING`;
3403 CREATE TABLE `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING` (
3404 `policy_uuid` varchar(255) NOT NULL,
3405 `parent_uuid` varchar(255) NOT NULL,
3406 `target_node_uuid` varchar(255) NOT NULL,
3407 `target_type` varchar(255) DEFAULT NULL,
3408 `target_node_customization_uuid` varchar(255) DEFAULT NULL,
3409 `policy_customization_uuid` varchar(255) DEFAULT NULL,
3410 PRIMARY KEY (`policy_uuid`,`parent_uuid`,`target_node_uuid`)
3411 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3414 DROP TABLE IF EXISTS `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING`;
3415 CREATE TABLE `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING` (
3416 `service_uuid` varchar(255) NOT NULL,
3417 `complex_resource_uuid` varchar(255) NOT NULL,
3418 `complex_resource_customization_uuid` varchar(255) NOT NULL,
3419 PRIMARY KEY (`service_uuid`,`complex_resource_uuid`,`complex_resource_customization_uuid`)
3420 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3422 DROP TABLE IF EXISTS `VFC_RELATED_NETWORK_ROLE`;
3423 CREATE TABLE `VFC_RELATED_NETWORK_ROLE` (
3424 `vfc_customization_uuid` varchar(255) NOT NULL,
3425 `vm_type` varchar(255) NOT NULL,
3426 `network_role` varchar(255) NOT NULL,
3427 `related_network_role` varchar(255) NOT NULL,
3428 PRIMARY KEY (`vfc_customization_uuid`,`vm_type`,`network_role`,`related_network_role`)
3429 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3431 DROP TABLE IF EXISTS `VNF_RELATED_NETWORK_ROLE`;
3432 CREATE TABLE `VNF_RELATED_NETWORK_ROLE` (
3433 `vnf_customization_uuid` varchar(255) NOT NULL,
3434 `network_role` varchar(255) NOT NULL,
3435 `related_network_role` varchar(255) NOT NULL,
3436 PRIMARY KEY (`vnf_customization_uuid`,`network_role`,`related_network_role`)
3437 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3439 -- Dump completed on 2017-10-04 18:23:01