4 -- Table structure for table `ACCESS_LOG`
7 CREATE TABLE IF NOT EXISTS `ACCESS_LOG` (
8 `access_log_seq` int(11) NOT NULL AUTO_INCREMENT,
9 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
10 `method` varchar(12) DEFAULT NULL,
11 `version` varchar(12) DEFAULT NULL,
12 `status` varchar(12) DEFAULT NULL,
13 `url` varchar(256) DEFAULT NULL,
14 `remote_address` varchar(128) DEFAULT NULL,
15 PRIMARY KEY (`access_log_seq`)
16 ) ENGINE=InnoDB AUTO_INCREMENT=1034 DEFAULT CHARSET=latin1;
19 -- Table structure for table `CUSTOMER`
23 CREATE TABLE IF NOT EXISTS `CUSTOMER` (
24 `cust_id` int(11) NOT NULL AUTO_INCREMENT,
25 `customer_name` varchar(256) DEFAULT NULL,
26 `grua` varchar(4) NOT NULL,
27 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
28 PRIMARY KEY (`cust_id`),
29 UNIQUE KEY `IU1_CUSTOMER` (`customer_name`)
30 ) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=latin1;
34 -- Table structure for table `ADDRESS_PLAN_POLICIES`
37 CREATE TABLE IF NOT EXISTS `ADDRESS_PLAN_POLICIES` (
38 `key_name` varchar(255) NOT NULL,
39 `key_value_source_type` varchar(255) NOT NULL,
40 `key_value_source` varchar(255) NOT NULL,
41 PRIMARY KEY (`key_name`)
42 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45 -- Table structure for table `AGNOSTIC_NOTIFICATION_URL`
48 CREATE TABLE IF NOT EXISTS `AGNOSTIC_NOTIFICATION_URL` (
49 `service_type` varchar(128) NOT NULL,
50 `service_instance_id` varchar(128) NOT NULL,
51 `request_id` varchar(128) NOT NULL,
52 `svc_notification_url` varchar(256) NOT NULL,
53 PRIMARY KEY (`service_type`,`service_instance_id`,`request_id`)
54 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58 -- Table structure for table `AGNOSTIC_TO_SVC_SPCFC_API`
60 CREATE TABLE IF NOT EXISTS `AGNOSTIC_TO_SVC_SPCFC_API` (
61 `operation` varchar(128) NOT NULL,
62 `service` varchar(128) NOT NULL,
63 `service_specific_api` varchar(128) NOT NULL,
64 `async_process` varchar(15) DEFAULT NULL,
65 PRIMARY KEY (`operation`,`service`)
66 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69 -- Table structure for table `AIC_AVAIL_ZONE_POOL`
71 CREATE TABLE IF NOT EXISTS `AIC_AVAIL_ZONE_POOL` (
72 `aic_site_id` varchar(100) NOT NULL,
73 `status` varchar(40) NOT NULL,
74 `availability_zone` varchar(100) NOT NULL,
75 `token` varchar(5) NOT NULL,
76 `vnf_id` varchar(80) DEFAULT NULL,
77 `service_type` varchar(100) NOT NULL,
78 `vnf_type` varchar(20) DEFAULT NULL,
79 `hypervisor` varchar(10) DEFAULT NULL,
80 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
81 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
84 -- Table structure for table `AIC_HOSTNAME`
86 CREATE TABLE IF NOT EXISTS `AIC_HOSTNAME` (
87 `hostname` varchar(20) NOT NULL,
88 `cust_id` int(11) NOT NULL,
89 `vendor_code` varchar(1) NOT NULL,
90 `virtual_device_type` varchar(2) DEFAULT NULL,
91 `device_sequence` varchar(3) NOT NULL,
92 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
93 PRIMARY KEY (`hostname`),
94 UNIQUE KEY `hostname` (`hostname`),
95 KEY `IN1_AIC_HOSTNAME` (`cust_id`),
96 CONSTRAINT `AC1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
97 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
100 -- Table structure for table `AIC_NETWORK`
103 CREATE TABLE IF NOT EXISTS `AIC_NETWORK` (
104 `network_id` varchar(100) NOT NULL,
105 `network_name` varchar(100) DEFAULT NULL,
106 `status` varchar(20) DEFAULT NULL,
107 `tenant_id` varchar(100) DEFAULT NULL,
108 `switch_uuid` varchar(100) DEFAULT NULL,
109 `portgroup_name` varchar(100) DEFAULT NULL,
110 `portgroup_id` varchar(100) DEFAULT NULL,
111 PRIMARY KEY (`network_id`)
112 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
115 -- Table structure for table `AIC_SITE`
118 CREATE TABLE IF NOT EXISTS `AIC_SITE` (
119 `name` varchar(100) DEFAULT NULL,
120 `aic_site_id` varchar(100) NOT NULL,
121 `vcenter_url` varchar(200) DEFAULT NULL,
122 `vcenter_username` varchar(40) DEFAULT NULL,
123 `vcenter_passwd` varbinary(255) DEFAULT NULL,
124 `city` varchar(100) DEFAULT NULL,
125 `state` varchar(2) DEFAULT NULL,
126 `operational_status` varchar(20) DEFAULT NULL,
127 `oam_gateway_addr` varchar(20) DEFAULT '',
128 PRIMARY KEY (`aic_site_id`)
129 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
132 -- Table structure for table `AIC_SWITCH`
135 CREATE TABLE IF NOT EXISTS `AIC_SWITCH` (
136 `switch_name` varchar(100) DEFAULT NULL,
137 `physical_network_name` varchar(100) NOT NULL,
138 `aic_site_id` varchar(100) DEFAULT NULL,
139 `uuid` varchar(100) DEFAULT NULL,
140 `availability_zone` varchar(100) DEFAULT NULL,
141 PRIMARY KEY (`physical_network_name`)
142 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
145 -- Table structure for table `AIC_ZONE_CLOUD_REGION_ID`
148 CREATE TABLE IF NOT EXISTS `AIC_ZONE_CLOUD_REGION_ID` (
149 `zone_region_id` varchar(255) NOT NULL,
150 `cilli_code` varchar(255) NOT NULL,
151 `location_id` varchar(255) NOT NULL DEFAULT '',
152 `city_state_country` varchar(255) NOT NULL DEFAULT '',
153 PRIMARY KEY (`zone_region_id`,`cilli_code`,`location_id`,`city_state_country`)
154 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
157 -- Table structure for table `ALLOCATION_ITEM`
160 CREATE TABLE IF NOT EXISTS `ALLOCATION_ITEM` (
161 `allocation_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
162 `resource_id` bigint(20) NOT NULL,
163 `application_id` varchar(50) NOT NULL,
164 `resource_set_id` varchar(200) NOT NULL,
165 `resource_union_id` varchar(200) NOT NULL,
166 `resource_share_group_list` varchar(200) DEFAULT NULL,
167 `lt_used` bigint(20) DEFAULT NULL,
168 `ll_label` varchar(50) DEFAULT NULL,
169 `rr_used` varchar(200) DEFAULT NULL,
170 `allocation_time` datetime NOT NULL,
171 PRIMARY KEY (`allocation_item_id`),
172 UNIQUE KEY `allocation_item_id` (`allocation_item_id`),
173 UNIQUE KEY `IX2_ALLOCATION_ITEM` (`resource_id`,`resource_set_id`),
174 KEY `IX1_ALLOCATION_ITEM` (`resource_id`)
175 ) ENGINE=InnoDB AUTO_INCREMENT=5764 DEFAULT CHARSET=latin1;
178 -- Table structure for table `ALLOTTED_RESOURCE_MODEL`
181 CREATE TABLE IF NOT EXISTS `ALLOTTED_RESOURCE_MODEL` (
182 `customization_uuid` varchar(255) NOT NULL,
183 `model_yaml` longblob,
184 `invariant_uuid` varchar(255) DEFAULT NULL,
185 `uuid` varchar(255) DEFAULT NULL,
186 `version` varchar(255) DEFAULT NULL,
187 `naming_policy` varchar(255) DEFAULT NULL,
188 `ecomp_generated_naming` char(1) DEFAULT NULL,
189 `depending_service` varchar(255) DEFAULT NULL,
190 `role` varchar(255) DEFAULT NULL,
191 `type` varchar(255) DEFAULT NULL,
192 `service_dependency` varchar(255) DEFAULT NULL,
193 `allotted_resource_type` varchar(255) DEFAULT NULL,
194 PRIMARY KEY (`customization_uuid`)
195 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
198 -- Table structure for table `ALTS_CREDENTIALS`
201 CREATE TABLE IF NOT EXISTS `ALTS_CREDENTIALS` (
202 `alts_username` varchar(255) NOT NULL,
203 `alts_password` varbinary(255) NOT NULL,
204 PRIMARY KEY (`alts_username`)
205 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
208 -- Table structure for table `ASDC_ARTIFACTS`
211 CREATE TABLE IF NOT EXISTS `ASDC_ARTIFACTS` (
212 `asdc_artifacts_id` int(11) NOT NULL AUTO_INCREMENT,
213 `service_uuid` varchar(50) DEFAULT NULL,
214 `distribution_id` varchar(50) DEFAULT NULL,
215 `service_name` varchar(255) DEFAULT NULL,
216 `service_description` varchar(255) DEFAULT NULL,
217 `resource_uuid` varchar(255) DEFAULT NULL,
218 `resource_instance_name` varchar(255) DEFAULT NULL,
219 `resource_name` varchar(255) DEFAULT NULL,
220 `resource_version` varchar(50) DEFAULT NULL,
221 `resource_type` varchar(50) DEFAULT NULL,
222 `artifact_uuid` varchar(50) DEFAULT NULL,
223 `artifact_type` varchar(50) DEFAULT NULL,
224 `artifact_version` varchar(25) DEFAULT NULL,
225 `artifact_description` varchar(255) DEFAULT NULL,
226 `internal_version` int(11) DEFAULT NULL,
227 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
228 `artifact_name` varchar(255) DEFAULT NULL,
229 `artifact_content` longtext,
230 PRIMARY KEY (`asdc_artifacts_id`),
231 UNIQUE KEY `asdc_artifacts_id` (`asdc_artifacts_id`)
232 ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
235 -- Table structure for table `ASDC_REFERENCE`
238 CREATE TABLE IF NOT EXISTS `ASDC_REFERENCE` (
239 `asdc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
240 `service_type` varchar(50) DEFAULT NULL,
241 `vnf_type` varchar(50) DEFAULT NULL,
242 `vnfc_type` varchar(50) DEFAULT NULL,
243 `file_category` varchar(50) DEFAULT NULL,
244 `action` varchar(50) DEFAULT NULL,
245 `artifact_type` varchar(50) DEFAULT NULL,
246 `artifact_name` varchar(255) NOT NULL,
247 PRIMARY KEY (`asdc_reference_id`),
248 UNIQUE KEY `asdc_reference_id` (`asdc_reference_id`)
249 ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
253 -- Table structure for table `BLOB_TEST`
256 CREATE TABLE IF NOT EXISTS `BLOB_TEST` (
257 `seq` int(11) NOT NULL AUTO_INCREMENT,
258 `odl` varchar(20) DEFAULT NULL,
259 `communities` mediumblob,
260 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
261 `retry_count` int(11) DEFAULT '-1',
263 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
266 -- Table structure for table `CAPABILITY`
269 CREATE TABLE IF NOT EXISTS `CAPABILITY` (
270 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
271 `capability_name` varchar(50) NOT NULL,
272 `implementation_name` varchar(100) NOT NULL,
273 `operation_name` varchar(50) NOT NULL,
274 `operation_description` varchar(100) NOT NULL,
275 `input_definition` longtext,
276 `output_definition` longtext,
277 `dependency_definition` longtext,
278 `tags` varchar(100) DEFAULT NULL,
279 PRIMARY KEY (`capability_id`),
280 UNIQUE KEY `capability_id` (`capability_name`)
281 ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;
284 -- Table structure for table `CITY_CODE`
287 CREATE TABLE IF NOT EXISTS `CITY_CODE` (
288 `city_code_id` int(11) NOT NULL AUTO_INCREMENT,
289 `city_code` varchar(3) NOT NULL,
290 `city` varchar(150) NOT NULL,
291 `state` varchar(10) NOT NULL,
292 `country_code` varchar(10) NOT NULL,
293 PRIMARY KEY (`city_code_id`),
294 KEY `IN1_CITY_CODE` (`city`,`state`,`country_code`)
295 ) ENGINE=InnoDB AUTO_INCREMENT=37822 DEFAULT CHARSET=latin1;
298 -- Table structure for table `CLI_UPDATES`
301 CREATE TABLE IF NOT EXISTS `CLI_UPDATES` (
302 `seq` int(11) NOT NULL AUTO_INCREMENT,
303 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
304 `create_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
305 `last_processed_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
306 `target_address` varchar(128) DEFAULT NULL,
307 `cli_text` varchar(128) DEFAULT NULL,
309 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
312 -- Table structure for table `CONFIGFILES`
315 CREATE TABLE IF NOT EXISTS `CONFIGFILES` (
316 `config_file_id` int(11) NOT NULL AUTO_INCREMENT,
317 `external_version` varchar(50) DEFAULT NULL,
318 `data_source` varchar(25) DEFAULT NULL,
319 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
320 `service_instance_id` varchar(50) DEFAULT NULL,
321 `vnf_type` varchar(50) DEFAULT NULL,
322 `vnfc_type` varchar(50) DEFAULT NULL,
323 `file_category` varchar(50) DEFAULT NULL,
324 `file_name` varchar(255) DEFAULT NULL,
325 `file_content` longtext,
326 `action` varchar(50) DEFAULT NULL,
327 `vnf_id` varchar(50) DEFAULT NULL,
328 `vm_name` varchar(50) DEFAULT NULL,
329 `vnf_name` varchar(50) DEFAULT NULL,
330 PRIMARY KEY (`config_file_id`),
331 UNIQUE KEY `config_file_id` (`config_file_id`)
332 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
335 -- Table structure for table `CONFIGURE_ACTION_DG`
339 CREATE TABLE IF NOT EXISTS `CONFIGURE_ACTION_DG` (
340 `configure_action_dg_id` int(11) NOT NULL AUTO_INCREMENT,
341 `vnf_type` varchar(50) DEFAULT NULL,
342 `action` varchar(50) DEFAULT NULL,
343 `init_config_dg` varchar(50) DEFAULT NULL,
344 `generate_config_dg` varchar(50) DEFAULT NULL,
345 `download_config_dg` varchar(50) DEFAULT NULL,
346 PRIMARY KEY (`configure_action_dg_id`),
347 UNIQUE KEY `configure_action_dg_id` (`configure_action_dg_id`)
348 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
352 -- Table structure for table `CONFIG_CONTENT`
355 CREATE TABLE IF NOT EXISTS `CONFIG_CONTENT` (
356 `config_content_id` int(11) NOT NULL AUTO_INCREMENT,
357 `request_id` varchar(50) NOT NULL,
358 `content_type` varchar(50) NOT NULL,
359 `template_name` varchar(50) DEFAULT NULL,
360 `originator_id` varchar(50) DEFAULT NULL,
361 `service_description` varchar(100) DEFAULT NULL,
362 `action` varchar(50) DEFAULT NULL,
363 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
364 `service_type` varchar(50) DEFAULT NULL,
365 `service_instance_id` varchar(50) DEFAULT NULL,
366 `vnf_id` varchar(50) DEFAULT NULL,
367 `vnf_name` varchar(50) DEFAULT NULL,
368 `vm_name` varchar(50) DEFAULT NULL,
369 `vnf_type` varchar(50) DEFAULT NULL,
370 `vnfc_type` varchar(50) DEFAULT NULL,
371 `host_ip_address` varchar(50) DEFAULT NULL,
372 `config_indicator` varchar(25) DEFAULT NULL,
373 `pending_delete` varchar(1) DEFAULT NULL,
375 PRIMARY KEY (`config_content_id`),
376 UNIQUE KEY `config_content_id` (`creation_date`)
377 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
381 -- Table structure for table `CONFIG_FILE_REFERENCE`
384 CREATE TABLE IF NOT EXISTS `CONFIG_FILE_REFERENCE` (
385 `config_file_reference_id` int(11) NOT NULL AUTO_INCREMENT,
386 `site_location` varchar(50) DEFAULT NULL,
387 `vnf_type` varchar(50) DEFAULT NULL,
388 `import_type` varchar(50) DEFAULT NULL,
389 `file_type` varchar(50) DEFAULT NULL,
390 `source_server_name` varchar(255) DEFAULT NULL,
391 `source_file_path` varchar(255) DEFAULT NULL,
392 `target_file_path` varchar(255) DEFAULT NULL,
393 `name` varchar(50) DEFAULT NULL,
394 `file_name` varchar(255) DEFAULT NULL,
395 PRIMARY KEY (`config_file_reference_id`),
396 UNIQUE KEY `config_file_reference_id` (`config_file_reference_id`)
397 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
400 -- Table structure for table `CONFIG_TRANSACTION_LOG`
403 CREATE TABLE IF NOT EXISTS `CONFIG_TRANSACTION_LOG` (
404 `config_transaction_log_id` varchar(50) NOT NULL,
405 `request_id` varchar(50) DEFAULT NULL,
406 `message_type` varchar(100) DEFAULT NULL,
407 `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
409 PRIMARY KEY (`config_transaction_log_id`),
410 UNIQUE KEY `config_transaction_log_id` (`config_transaction_log_id`)
411 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
415 -- Table structure for table `COUNTRY_ASN_MAPPING`
418 CREATE TABLE IF NOT EXISTS `COUNTRY_ASN_MAPPING` (
419 `asn` int(5) NOT NULL,
420 `iso_2char` varchar(5) NOT NULL,
421 `iso_3char` varchar(5) NOT NULL
422 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
428 -- Table structure for table `CUSTOMER2CONNECTION_MAPPING`
431 CREATE TABLE `CUSTOMER2CONNECTION_MAPPING` (
432 `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT,
433 `service_instance_id` varchar(80) NOT NULL,
434 `instance_type` varchar(20) NOT NULL,
435 `originating_service_instance_id` varchar(80) DEFAULT NULL,
436 `originating_service_type` varchar(20) DEFAULT NULL,
437 `service_type` varchar(30) DEFAULT NULL,
438 `connection_id` varchar(100) NOT NULL,
439 `status` varchar(20) DEFAULT NULL,
440 PRIMARY KEY (`customer2connection_id`)
441 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
444 -- Table structure for table `CUSTOMER2CONNECTION_MAPPING_NEW`
447 CREATE TABLE IF NOT EXISTS `CUSTOMER2CONNECTION_MAPPING_NEW` (
448 `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT,
449 `service_instance_id` varchar(80) NOT NULL,
450 `instance_type` varchar(20) NOT NULL,
451 `originating_service_instance_id` varchar(80) DEFAULT NULL,
452 `originating_service_type` varchar(20) DEFAULT NULL,
453 `service_type` varchar(30) DEFAULT NULL,
454 `connection_id` varchar(100) NOT NULL,
455 `status` varchar(100) DEFAULT NULL,
456 PRIMARY KEY (`customer2connection_id`)
457 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
460 -- Table structure for table `DATA_OBJECT_MAPPING`
463 CREATE TABLE IF NOT EXISTS `DATA_OBJECT_MAPPING` (
464 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
465 `data_object_key` varchar(100) NOT NULL,
466 `data_object_type` varchar(50) NOT NULL,
467 `service_type` varchar(50) NOT NULL,
468 `data_object_key2` varchar(100) NOT NULL,
469 `data_object_key2_type` varchar(50) NOT NULL,
470 `data_object_key3` varchar(100) DEFAULT NULL,
471 `data_object_key3_type` varchar(50) DEFAULT NULL,
472 `service` varchar(50) DEFAULT NULL,
473 PRIMARY KEY (`serial_key`),
474 KEY `IX1_DATA_OBJECT_MAPPING` (`data_object_key`,`data_object_type`,`service_type`),
475 KEY `IX2_DATA_OBJECT_MAPPING` (`service_type`,`data_object_key2`,`data_object_key2_type`)
476 ) ENGINE=InnoDB AUTO_INCREMENT=3211 DEFAULT CHARSET=latin1;
479 -- Table structure for table `DEVICE2CONNECTION_MAPPING`
482 CREATE TABLE IF NOT EXISTS `DEVICE2CONNECTION_MAPPING` (
483 `vnf_host_name` varchar(100) NOT NULL,
484 `e2e_vpn_key` varchar(30) NOT NULL,
485 `service_type` varchar(30) NOT NULL,
486 `connection_id` varchar(100) NOT NULL,
487 PRIMARY KEY (`vnf_host_name`,`e2e_vpn_key`,`service_type`)
488 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
491 -- Table structure for table `DEVICE2IPADDRESS_CONSUMPTION`
494 CREATE TABLE IF NOT EXISTS `DEVICE2IPADDRESS_CONSUMPTION` (
495 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
496 `device_id` varchar(100) NOT NULL,
497 `device_type` varchar(30) NOT NULL,
498 `ip_version` varchar(10) NOT NULL,
499 `consumption_key` varchar(100) NOT NULL,
500 `logical_interface_service_id` varchar(100) NOT NULL,
501 `address_type` varchar(30) NOT NULL,
502 `ip_consumed` varchar(50) NOT NULL,
503 `vnf_type` varchar(30) NOT NULL,
504 `secondary_key` varchar(100) DEFAULT NULL,
505 PRIMARY KEY (`serial_key`),
506 KEY `IX1_DEVICEIPADDRESS_CONSUMPTION` (`device_id`,`device_type`,`ip_version`)
507 ) ENGINE=InnoDB AUTO_INCREMENT=1357 DEFAULT CHARSET=latin1;
510 -- Table structure for table `DEVICE2IPADDRESS_MAPPING`
513 CREATE TABLE IF NOT EXISTS `DEVICE2IPADDRESS_MAPPING` (
514 `serial_key` int(11) NOT NULL AUTO_INCREMENT,
515 `device_id` varchar(100) NOT NULL,
516 `device_type` varchar(30) NOT NULL,
517 `secondary_key` varchar(100) NOT NULL,
518 `secondary_key_type` varchar(30) NOT NULL,
519 `address` varchar(50) NOT NULL,
520 `address_type` varchar(30) NOT NULL,
521 `ip_version` varchar(10) NOT NULL,
522 `length` int(11) NOT NULL,
523 `status` varchar(30) NOT NULL,
524 PRIMARY KEY (`serial_key`),
525 KEY `IX1_DEVICE2IPADDRESS_MAPPING` (`device_id`,`device_type`,`secondary_key`,`secondary_key_type`,`address`,`address_type`)
526 ) ENGINE=InnoDB AUTO_INCREMENT=4734 DEFAULT CHARSET=latin1;
529 -- Table structure for table `DEVICE_AUTHENTICATION`
532 CREATE TABLE IF NOT EXISTS `DEVICE_AUTHENTICATION` (
533 `device_authentication_id` int(11) NOT NULL AUTO_INCREMENT,
534 `vnf_type` varchar(50) DEFAULT NULL,
535 `user_name` varchar(50) DEFAULT NULL,
536 `password` varchar(100) DEFAULT NULL,
537 `protocol` varchar(100) DEFAULT NULL,
538 `port_number` int(11) DEFAULT NULL,
539 PRIMARY KEY (`device_authentication_id`),
540 UNIQUE KEY `device_authentication_id` (`device_authentication_id`)
541 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
544 -- Table structure for table `DEVICE_INTERFACE_LOG`
547 CREATE TABLE IF NOT EXISTS `DEVICE_INTERFACE_LOG` (
548 `device_interface_log_id` int(11) NOT NULL AUTO_INCREMENT,
549 `service_instance_id` varchar(50) DEFAULT NULL,
550 `request_id` varchar(50) DEFAULT NULL,
551 `creation_date` datetime NOT NULL,
553 PRIMARY KEY (`device_interface_log_id`),
554 UNIQUE KEY `device_interface_log_id` (`device_interface_log_id`)
555 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
558 -- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
561 CREATE TABLE IF NOT EXISTS `DEVICE_INTERFACE_PROTOCOL` (
562 `device_interface_protocol_id` int(11) NOT NULL AUTO_INCREMENT,
563 `vnf_type` varchar(50) DEFAULT NULL,
564 `protocol` varchar(50) DEFAULT NULL,
565 `module` varchar(50) DEFAULT NULL,
566 `dg_rpc` varchar(50) DEFAULT NULL,
567 PRIMARY KEY (`device_interface_protocol_id`),
568 UNIQUE KEY `device_interface_protocol_id` (`device_interface_protocol_id`),
569 UNIQUE KEY `vnf_type` (`vnf_type`)
570 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
573 -- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
576 CREATE TABLE IF NOT EXISTS `DOWNLOAD_CONFIG_TEMPLATE` (
577 `download_config_template_id` int(11) NOT NULL AUTO_INCREMENT,
578 `vnf_type` varchar(50) NOT NULL,
579 `protocol` varchar(50) NOT NULL,
581 PRIMARY KEY (`download_config_template_id`),
582 UNIQUE KEY `download_config_template_id` (`download_config_template_id`)
583 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
586 -- Table structure for table `DOWNLOAD_DG_REFERENCE`
589 CREATE TABLE IF NOT EXISTS `DOWNLOAD_DG_REFERENCE` (
590 `download_dg_reference_id` int(11) NOT NULL AUTO_INCREMENT,
591 `protocol` varchar(50) NOT NULL,
592 `download_config_dg` varchar(50) NOT NULL,
593 PRIMARY KEY (`download_dg_reference_id`),
594 UNIQUE KEY `download_dg_reference_id` (`download_dg_reference_id`)
595 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
598 -- Table structure for table `EIPAM_CLIENT_KEY_INDEX`
601 CREATE TABLE IF NOT EXISTS `EIPAM_CLIENT_KEY_INDEX` (
602 `vnf_name_prefix` varchar(100) NOT NULL,
603 `index_number` int(11) NOT NULL,
604 PRIMARY KEY (`vnf_name_prefix`)
605 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
608 -- Table structure for table `EIPAM_IP_ASSIGNMENTS`
611 CREATE TABLE IF NOT EXISTS `EIPAM_IP_ASSIGNMENTS` (
612 `plan_name` varchar(40) NOT NULL,
613 `client_key` varchar(100) NOT NULL,
614 `service_type` varchar(40) NOT NULL,
615 `ip_address` varchar(40) DEFAULT NULL,
616 `prefix_length` int(2) DEFAULT NULL,
617 `status` varchar(255) DEFAULT NULL,
618 `service_instance_id` varchar(80) DEFAULT NULL,
619 `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
620 `prev_status` varchar(20) DEFAULT NULL,
621 `info` varchar(255) DEFAULT NULL,
622 PRIMARY KEY (`plan_name`,`client_key`)
623 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
626 -- Table structure for table `EIPAM_IP_POOLS`
629 CREATE TABLE IF NOT EXISTS `EIPAM_IP_POOLS` (
630 `pool_id` int(11) NOT NULL AUTO_INCREMENT,
631 `key_name` varchar(50) NOT NULL,
632 `key_value` varchar(255) NOT NULL,
633 `level` int(2) NOT NULL,
634 `plan_name` varchar(50) NOT NULL,
635 `address_family` varchar(10) NOT NULL,
636 `parent_pool` varchar(255) NOT NULL,
637 `service_instance_id` varchar(255) DEFAULT NULL,
638 `network_id` varchar(255) DEFAULT NULL,
639 `created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
640 `delete_failure` varchar(20) DEFAULT NULL,
641 `delete_request_id` varchar(255) DEFAULT NULL,
642 PRIMARY KEY (`pool_id`)
643 ) 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.';
646 -- Table structure for table `EIPAM_IP_SUBNETS`
649 CREATE TABLE IF NOT EXISTS `EIPAM_IP_SUBNETS` (
650 `entity_id` int(6) NOT NULL,
651 `service_type` varchar(40) NOT NULL,
652 `plan_name` varchar(50) NOT NULL,
653 `address_family` varchar(10) NOT NULL,
654 `ip_address` varchar(40) NOT NULL,
655 `prefix_length` int(3) NOT NULL,
656 `status` varchar(20) NOT NULL,
657 `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
658 `network_id` varchar(255) DEFAULT NULL,
659 `pool_id` int(11) DEFAULT NULL,
660 `dealloc_failure` varchar(20) DEFAULT NULL,
661 `dealloc_request_id` varchar(255) DEFAULT NULL,
662 PRIMARY KEY (`entity_id`),
663 KEY `FK_EIPAM_IP_SUBNETS_EIPAM_IP_POOLS` (`pool_id`),
664 CONSTRAINT `EIPAM_IP_SUBNETS_ibfk_1` FOREIGN KEY (`pool_id`) REFERENCES `EIPAM_IP_POOLS` (`pool_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
665 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
666 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
669 -- Table structure for table `EIPAM_IP_SUBNET_KEYS`
672 CREATE TABLE IF NOT EXISTS `EIPAM_IP_SUBNET_KEYS` (
673 `entity_id` int(6) NOT NULL,
674 `key_name` varchar(50) NOT NULL,
675 `key_value` varchar(255) NOT NULL,
676 `level` int(2) NOT NULL,
677 PRIMARY KEY (`entity_id`,`key_name`,`key_value`,`level`)
678 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
681 -- Table structure for table `EIPAM_REQUEST_KEY`
684 CREATE TABLE IF NOT EXISTS `EIPAM_REQUEST_KEY` (
685 `key_name_1` varchar(50) NOT NULL,
686 `address_family` varchar(4) NOT NULL,
687 `serial_key` int(2) NOT NULL AUTO_INCREMENT,
688 `plan_name` varchar(50) NOT NULL,
689 `request_length` int(2) NOT NULL,
690 `pools_length` int(2) NOT NULL,
691 `plan_length` int(2) NOT NULL,
692 `key_name_0` varchar(50) NOT NULL,
693 `key_name_type_0` varchar(255) NOT NULL,
694 `key_name_type_1` varchar(255) NOT NULL,
695 `prefix_length` int(2) NOT NULL,
696 `group_flag` char(1) NOT NULL,
697 `address_type` varchar(20) DEFAULT NULL,
698 PRIMARY KEY (`key_name_1`,`address_family`),
699 UNIQUE KEY `IX1_EIPAM_REQUEST_KEY` (`serial_key`)
700 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
703 -- Table structure for table `EXTERNAL_DATA`
706 CREATE TABLE IF NOT EXISTS `EXTERNAL_DATA` (
707 `external_data_id` int(11) NOT NULL AUTO_INCREMENT,
708 `request_id` int(11) DEFAULT NULL,
709 `param_name` varchar(30) NOT NULL,
710 `param_value` varchar(50) NOT NULL,
711 PRIMARY KEY (`external_data_id`)
712 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
715 -- Table structure for table `FLOW_UPDATES`
718 CREATE TABLE IF NOT EXISTS `FLOW_UPDATES` (
719 `seq` int(11) NOT NULL AUTO_INCREMENT,
720 `status` enum('NEW','COMPLETE','FAILED') NOT NULL DEFAULT 'NEW',
721 `create_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
722 `last_processed_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
723 `odl` varchar(128) DEFAULT NULL,
724 `address_family` enum('IPV4','IPV6') DEFAULT NULL,
725 `destination_prefix` varchar(50) DEFAULT NULL,
726 `communities` varchar(6000) DEFAULT NULL,
727 `route_key` varchar(50) DEFAULT NULL,
729 ) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=latin1;
732 -- Table structure for table `GENERIC_L3_NETWORK`
735 CREATE TABLE IF NOT EXISTS `GENERIC_L3_NETWORK` (
736 `network_id` varchar(80) NOT NULL,
737 `network_name` varchar(80) DEFAULT NULL,
738 `network_type` varchar(80) DEFAULT NULL,
739 `network_role` varchar(80) DEFAULT NULL,
740 `network_technology` varchar(80) DEFAULT NULL,
741 `neutron_network_id` varchar(80) DEFAULT NULL,
742 `is_bound_to_vpn` tinyint(1) DEFAULT NULL,
743 `orchestration_status` varchar(20) DEFAULT NULL,
744 `heat_stack_id` varchar(80) DEFAULT NULL,
745 `mso_catalog_key` varchar(80) DEFAULT NULL,
746 `service_id` varchar(80) NOT NULL,
747 `tenant_id` varchar(80) NOT NULL,
748 `physical_location_id` varchar(20) DEFAULT NULL,
749 `network_role_instance` varchar(80) NOT NULL,
750 PRIMARY KEY (`network_id`)
751 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
754 -- Table structure for table `GENERIC_L3_NETWORK_SUBNET`
757 CREATE TABLE IF NOT EXISTS `GENERIC_L3_NETWORK_SUBNET` (
758 `network_id` varchar(80) NOT NULL,
759 `subnet_id` varchar(80) NOT NULL,
760 `neutron_subnet_id` varchar(80) DEFAULT NULL,
761 `gateway_address` varchar(45) NOT NULL,
762 `network_start_address` varchar(45) NOT NULL,
763 `cidr_mask` varchar(20) NOT NULL,
764 `ip_version` char(1) NOT NULL,
765 `orchestration_status` varchar(64) NOT NULL,
766 `dhcp_enabled` tinyint(1) NOT NULL,
767 `dhcp_start` varchar(45) DEFAULT NULL,
768 `dhcp_end` varchar(45) DEFAULT NULL,
769 PRIMARY KEY (`network_id`,`subnet_id`)
770 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
773 -- Table structure for table `GENERIC_L3_NETWORK_VPN_BINDING`
776 CREATE TABLE IF NOT EXISTS `GENERIC_L3_NETWORK_VPN_BINDING` (
777 `network_id` varchar(80) NOT NULL,
778 `vpn_id` varchar(80) NOT NULL,
779 PRIMARY KEY (`network_id`,`vpn_id`)
780 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
783 -- Table structure for table `GENERIC_RESOURCE_NAME`
786 CREATE TABLE IF NOT EXISTS `GENERIC_RESOURCE_NAME` (
787 `type` varchar(50) NOT NULL,
788 `name` varchar(255) NOT NULL,
789 `prefix` varchar(255) NULL,
790 `name_index` int(11) NULL,
791 `context_id` varchar(255) NULL,
792 PRIMARY KEY (`type`,`name`)
793 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
796 -- Table structure for table `GENERIC_VNF`
799 CREATE TABLE IF NOT EXISTS `GENERIC_VNF` (
800 `vnf_id` varchar(80) NOT NULL,
801 `vnf_name` varchar(80) NOT NULL,
802 `vnf_type` varchar(200) NOT NULL,
803 `vnf_name2` varchar(80) DEFAULT NULL,
804 `service_id` varchar(80) NOT NULL,
805 `equipment_role` varchar(80) NOT NULL,
806 `orchestration_status` varchar(20) DEFAULT NULL,
807 `prov_status` varchar(20) DEFAULT NULL,
808 `heat_stack_id` varchar(80) DEFAULT NULL,
809 `mso_catalog_key` varchar(80) DEFAULT NULL,
810 `regional_resource_zone` varchar(80) DEFAULT NULL,
811 `operational_state` varchar(80) DEFAULT NULL,
812 `license_key` varchar(80) DEFAULT NULL,
813 `ipv4_oam_address` varchar(20) DEFAULT NULL,
814 `ipv4_loopback0_address` varchar(20) DEFAULT NULL,
815 `nm_lan_v6_address` varchar(40) DEFAULT NULL,
816 `management_v6_address` varchar(40) DEFAULT NULL,
817 `management_option` varchar(45) DEFAULT NULL,
818 `vcpu` varchar(45) DEFAULT NULL,
819 `vmemory` varchar(45) DEFAULT NULL,
820 `vdisk` varchar(45) DEFAULT NULL,
821 `vcpu_units` varchar(45) DEFAULT NULL,
822 `vmemory_units` varchar(45) DEFAULT NULL,
823 `vdisk_units` varchar(45) DEFAULT NULL,
824 PRIMARY KEY (`vnf_id`)
825 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
828 -- Table structure for table `GENERIC_VNF_L3_NETWORK`
831 CREATE TABLE IF NOT EXISTS `GENERIC_VNF_L3_NETWORK` (
832 `vnf_id` varchar(80) NOT NULL,
833 `network_id` varchar(80) NOT NULL,
834 PRIMARY KEY (`vnf_id`,`network_id`)
835 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
838 -- Table structure for table `GENERIC_VNF_LICENSE_MANAGEMENT`
841 CREATE TABLE IF NOT EXISTS `GENERIC_VNF_LICENSE_MANAGEMENT` (
842 `vnf_id` varchar(80) NOT NULL,
843 `att_uuid` varchar(80) NOT NULL,
844 PRIMARY KEY (`vnf_id`,`att_uuid`)
845 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
848 -- Table structure for table `GENERIC_VNF_LINTERFACE`
851 CREATE TABLE IF NOT EXISTS `GENERIC_VNF_LINTERFACE` (
852 `vnf_id` varchar(80) NOT NULL,
853 `interface_name` varchar(255) NOT NULL,
854 `interface_role` varchar(45) DEFAULT NULL,
855 `v6_wan_link_ip` varchar(45) DEFAULT NULL,
856 `selflink` varchar(128) DEFAULT NULL,
857 `interface_id` varchar(45) DEFAULT NULL,
858 `macaddr` varchar(64) DEFAULT NULL,
859 `network_name` varchar(255) DEFAULT NULL,
860 PRIMARY KEY (`vnf_id`,`interface_name`),
861 KEY `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF_IDX` (`vnf_id`),
862 CONSTRAINT `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF` FOREIGN KEY (`vnf_id`) REFERENCES `GENERIC_VNF` (`vnf_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
863 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
866 -- Table structure for table `GENERIC_VNF_PSERVER`
869 CREATE TABLE IF NOT EXISTS `GENERIC_VNF_PSERVER` (
870 `vnf_id` varchar(64) NOT NULL,
871 `hostname` varchar(255) NOT NULL,
872 PRIMARY KEY (`vnf_id`,`hostname`)
873 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
876 -- Table structure for table `GENERIC_VNF_SERVICE_INSTANCE`
879 CREATE TABLE IF NOT EXISTS `GENERIC_VNF_SERVICE_INSTANCE` (
880 `vnf_id` varchar(64) NOT NULL,
881 `service_instance_id` varchar(255) NOT NULL,
882 `relationship_key` varchar(64) NOT NULL,
883 `relationship_value` varchar(64) DEFAULT NULL,
884 `global_customer_id` varchar(255) DEFAULT NULL,
885 `service_type` varchar(255) DEFAULT NULL,
886 PRIMARY KEY (`vnf_id`,`service_instance_id`,`relationship_key`)
887 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
890 -- Table structure for table `GENERIC_VNF_VNF_IMAGE`
893 CREATE TABLE IF NOT EXISTS `GENERIC_VNF_VNF_IMAGE` (
894 `vnf_id` varchar(64) NOT NULL,
895 `att_uuid` varchar(255) NOT NULL,
896 PRIMARY KEY (`vnf_id`,`att_uuid`)
897 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
900 -- Table structure for table `GENERIC_VNF_VSERVER`
903 CREATE TABLE IF NOT EXISTS `GENERIC_VNF_VSERVER` (
904 `vnf_id` varchar(80) NOT NULL,
905 `vserver_id` varchar(128) NOT NULL,
906 `tenant_id` varchar(128) DEFAULT NULL,
907 PRIMARY KEY (`vnf_id`,`vserver_id`)
908 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
911 -- Table structure for table `GENERIC_VPN_BINDING`
914 CREATE TABLE IF NOT EXISTS `GENERIC_VPN_BINDING` (
915 `vpn_id` varchar(80) NOT NULL,
916 `vpn_name` varchar(80) NOT NULL,
917 `global_route_target` varchar(80) NOT NULL,
918 PRIMARY KEY (`vpn_id`)
919 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
922 -- Table structure for table `GET_CONFIG_TEMPLATE`
925 CREATE TABLE IF NOT EXISTS `GET_CONFIG_TEMPLATE` (
926 `get_config_template_id` int(11) NOT NULL AUTO_INCREMENT,
927 `vnf_type` varchar(50) NOT NULL,
928 `device_interface_protocol_id` int(11) NOT NULL,
929 `xml_processing` varchar(1) DEFAULT NULL,
930 `xml_protocol` varchar(30) DEFAULT NULL,
932 PRIMARY KEY (`get_config_template_id`),
933 UNIQUE KEY `get_config_template_id` (`get_config_template_id`),
934 KEY `get_config_template_ibfk_1` (`device_interface_protocol_id`),
935 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
936 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
939 -- Table structure for table `LOCATION`
942 CREATE TABLE IF NOT EXISTS `LOCATION` (
943 `loc_id` int(11) NOT NULL AUTO_INCREMENT,
944 `address` varchar(150) NOT NULL,
945 `city_code_id` int(11) NOT NULL,
946 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
947 PRIMARY KEY (`loc_id`),
948 KEY `IN1_LOCATION_IDX` (`city_code_id`),
949 CONSTRAINT `FK1_LOCATION` FOREIGN KEY (`city_code_id`) REFERENCES `CITY_CODE` (`city_code_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
950 ) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=latin1;
953 -- Table structure for table `HOSTNAME`
956 CREATE TABLE IF NOT EXISTS `HOSTNAME` (
957 `hostname` varchar(21) NOT NULL,
958 `parent_hostname` varchar(21) DEFAULT NULL,
959 `cust_id` int(11) NOT NULL,
960 `loc_id` int(11) NOT NULL,
961 `site_sequence` varchar(2) NOT NULL,
962 `server_sequence` varchar(2) NOT NULL,
963 `activation_code` varchar(11) DEFAULT NULL,
964 `vnf_sequence` varchar(2) DEFAULT NULL,
965 `vendor_code` varchar(1) NOT NULL,
966 `virtual_device_type` varchar(2) DEFAULT NULL,
967 `device_sequence` varchar(3) DEFAULT NULL,
968 `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
969 PRIMARY KEY (`hostname`),
970 KEY `IN1_HOSTNAME` (`cust_id`),
971 KEY `IN2_HOSTNAME` (`loc_id`),
972 KEY `IN3_HOSTNAME` (`vendor_code`),
973 KEY `IN4_HOSTNAME` (`parent_hostname`),
974 CONSTRAINT `FK1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
975 CONSTRAINT `FK2_HOSTNAME` FOREIGN KEY (`loc_id`) REFERENCES `LOCATION` (`loc_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
976 CONSTRAINT `FK4_HOSTNAME` FOREIGN KEY (`parent_hostname`) REFERENCES `HOSTNAME` (`hostname`) ON DELETE NO ACTION ON UPDATE NO ACTION
977 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
980 -- Table structure for table `IPV4_ADDRESS_POOL`
983 CREATE TABLE IF NOT EXISTS `IPV4_ADDRESS_POOL` (
984 `aic_site_id` varchar(100) NOT NULL,
985 `universe` varchar(40) NOT NULL,
986 `status` varchar(40) NOT NULL,
987 `ipv4_addr` varchar(20) NOT NULL,
988 PRIMARY KEY (`ipv4_addr`,`universe`)
989 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
992 -- Table structure for table `LINK_MASTER`
995 CREATE TABLE IF NOT EXISTS `LINK_MASTER` (
996 `link_interface_ip` varchar(20) NOT NULL,
997 `source_crs_name` varchar(20) NOT NULL,
998 `destination_crs_name` varchar(20) NOT NULL,
999 `max_reserved_bw` int(11) DEFAULT NULL,
1000 `default_cost` int(11) DEFAULT NULL,
1001 `bundle_name` varchar(20) DEFAULT NULL,
1002 PRIMARY KEY (`link_interface_ip`)
1003 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1006 -- Table structure for table `LINTERFACE_VLAN`
1009 CREATE TABLE IF NOT EXISTS `LINTERFACE_VLAN` (
1010 `vnf_id` varchar(80) NOT NULL,
1011 `interface_name` varchar(255) NOT NULL,
1012 `vlan_interface` varchar(255) NOT NULL,
1013 `vlan_id_inner` varchar(64) DEFAULT NULL,
1014 `vlan_id_outer` varchar(64) DEFAULT NULL,
1015 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`),
1016 KEY `FK_LINTERFACE_VLAN_GENERIC_VNF_LINTERFACE_IDX` (`vnf_id`,`interface_name`),
1017 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
1018 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1022 -- Table structure for table `MAX_PORT_SPEED`
1025 CREATE TABLE IF NOT EXISTS `MAX_PORT_SPEED` (
1026 `max_port_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1027 `image_file_name` varchar(50) NOT NULL,
1028 `end_point_position` varchar(50) NOT NULL,
1029 `interface_name` varchar(100) NOT NULL,
1030 `max_speed` bigint(20) NOT NULL,
1031 `unit` varchar(10) NOT NULL,
1032 PRIMARY KEY (`max_port_speed_id`),
1033 UNIQUE KEY `max_port_speed_id` (`max_port_speed_id`)
1034 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1037 -- Table structure for table `MAX_SERVER_SPEED`
1040 CREATE TABLE IF NOT EXISTS `MAX_SERVER_SPEED` (
1041 `max_server_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1042 `server_model` varchar(50) NOT NULL,
1043 `evc_count` smallint(6) NOT NULL,
1044 `max_speed` bigint(20) NOT NULL,
1045 `unit` varchar(10) NOT NULL,
1046 `description` varchar(500) DEFAULT NULL,
1047 PRIMARY KEY (`max_server_speed_id`),
1048 UNIQUE KEY `max_server_speed_id` (`max_server_speed_id`)
1049 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
1052 -- Table structure for table `NAMING_POLICY_VM_NAME_INDEX`
1055 CREATE TABLE IF NOT EXISTS `NAMING_POLICY_VM_NAME_INDEX` (
1056 `vm_name_prefix` varchar(255) NOT NULL,
1057 `index_number` int(11) NOT NULL,
1058 PRIMARY KEY (`vm_name_prefix`)
1059 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1062 -- Table structure for table `NAMING_POLICY_VNFC_NAME_INDEX`
1065 CREATE TABLE IF NOT EXISTS `NAMING_POLICY_VNFC_NAME_INDEX` (
1066 `vnfc_name_prefix` varchar(255) NOT NULL,
1067 `index_number` int(11) NOT NULL,
1068 PRIMARY KEY (`vnfc_name_prefix`)
1069 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1072 -- Table structure for table `NBNC_ASSIGN_VPN_OVERRIDE`
1075 CREATE TABLE IF NOT EXISTS `NBNC_ASSIGN_VPN_OVERRIDE` (
1076 `vpn_id` varchar(12) NOT NULL DEFAULT '',
1077 `vpn_rt` varchar(16) NOT NULL DEFAULT '',
1078 `service_type` varchar(16) NOT NULL DEFAULT '',
1079 `be_location` varchar(16) NOT NULL DEFAULT '',
1080 `be_type` varchar(32) NOT NULL DEFAULT '',
1081 `be_id` varchar(32) DEFAULT NULL,
1082 `description` varchar(128) DEFAULT NULL,
1083 PRIMARY KEY (`vpn_id`,`vpn_rt`,`service_type`,`be_location`,`be_type`)
1084 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1087 -- Table structure for table `NBNC_BORDER_ELEMENT`
1090 CREATE TABLE IF NOT EXISTS `NBNC_BORDER_ELEMENT` (
1091 `be_id` varchar(32) NOT NULL,
1092 `be_type` varchar(16) NOT NULL,
1093 `be_name` varchar(32) DEFAULT NULL,
1094 `be_host_vnf_id` varchar(32) DEFAULT NULL,
1095 `service_type` varchar(16) DEFAULT NULL,
1096 `tangibility` varchar(16) DEFAULT NULL,
1097 `usage_order` smallint(6) DEFAULT NULL,
1098 `vlan_start` smallint(6) DEFAULT NULL,
1099 `vlan_end` smallint(6) DEFAULT NULL,
1100 `ipv4_subnet` varchar(18) DEFAULT NULL,
1101 `ipv6_subnet` varchar(68) DEFAULT NULL,
1102 `network_ip` varchar(48) DEFAULT NULL,
1103 `be_location` varchar(16) DEFAULT NULL,
1104 `description` varchar(128) DEFAULT NULL,
1105 `updated_timestamp` timestamp NULL DEFAULT NULL,
1106 `log_link_model_uuid` varchar(64) DEFAULT NULL,
1107 PRIMARY KEY (`be_id`,`be_type`)
1108 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1111 -- Table structure for table `NBNC_IPE`
1114 CREATE TABLE IF NOT EXISTS `NBNC_IPE` (
1115 `ipe_name` varchar(32) NOT NULL,
1116 `ipe_location` varchar(16) DEFAULT NULL,
1117 `ipe_ip_address` varchar(16) DEFAULT NULL,
1118 `ipe_id` varchar(8) DEFAULT NULL,
1119 `service_type_array` varchar(512) DEFAULT NULL,
1120 `ipe_status` varchar(32) DEFAULT NULL,
1121 `updated_timestamp` timestamp NULL DEFAULT NULL,
1122 PRIMARY KEY (`ipe_name`)
1123 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1126 -- Table structure for table `NBNC_IPE_PORT`
1129 CREATE TABLE IF NOT EXISTS `NBNC_IPE_PORT` (
1130 `port_id` varchar(16) NOT NULL,
1131 `ipe_name` varchar(32) NOT NULL,
1132 `be_id` varchar(32) NOT NULL,
1133 `be_type` varchar(16) NOT NULL,
1134 `port_type` varchar(16) DEFAULT NULL,
1135 `ae_name` varchar(16) DEFAULT NULL,
1136 `description` varchar(128) DEFAULT NULL,
1137 `updated_timestamp` timestamp NULL DEFAULT NULL,
1138 PRIMARY KEY (`port_id`,`ipe_name`,`be_id`,`be_type`)
1139 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1142 -- Table structure for table `NBNC_MAPPING_SBG_BGF`
1145 CREATE TABLE IF NOT EXISTS `NBNC_MAPPING_SBG_BGF` (
1146 `asbg_vlan` smallint(6) NOT NULL,
1147 `bgf_vlan` smallint(6) NOT NULL,
1148 PRIMARY KEY (`asbg_vlan`)
1149 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1152 -- Table structure for table `NBNC_SERVICE`
1155 CREATE TABLE IF NOT EXISTS `NBNC_SERVICE` (
1156 `service_type` varchar(16) NOT NULL,
1157 `service_model_uuid` varchar(64) NOT NULL,
1158 `description` varchar(128) DEFAULT NULL,
1159 `created_timestamp` timestamp NULL DEFAULT NULL,
1160 `updated_timestamp` timestamp NULL DEFAULT NULL,
1161 PRIMARY KEY (`service_type`)
1162 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1165 -- Table structure for table `NBNC_SERVICE_VLAN`
1168 CREATE TABLE IF NOT EXISTS `NBNC_SERVICE_VLAN` (
1169 `be_id` varchar(32) NOT NULL,
1170 `vlan` smallint(6) NOT NULL,
1171 `service_type` varchar(16) DEFAULT NULL,
1172 `be_type` varchar(16) DEFAULT NULL,
1173 `be_name` varchar(32) DEFAULT NULL,
1174 `be_host_vnf_id` varchar(32) DEFAULT NULL,
1175 `be_location` varchar(16) DEFAULT NULL,
1176 `be_usage_order` smallint(6) DEFAULT NULL,
1177 `vlan_usage_order` smallint(6) DEFAULT NULL,
1178 `status` varchar(16) DEFAULT 'AVAILABLE',
1179 `request_id` varchar(64) DEFAULT NULL,
1180 `service_instance_id` varchar(64) DEFAULT NULL,
1181 `vni_id` varchar(16) DEFAULT NULL,
1182 `customer_id` varchar(16) DEFAULT NULL,
1183 `ipe1_router_name` varchar(32) DEFAULT NULL,
1184 `ipe1_port_id` varchar(16) DEFAULT NULL,
1185 `ipe1_ae_name` varchar(16) DEFAULT NULL,
1186 `ipe2_router_name` varchar(32) DEFAULT NULL,
1187 `ipe2_port_id` varchar(16) DEFAULT NULL,
1188 `ipe2_ae_name` varchar(16) DEFAULT NULL,
1189 `available_timestamp` timestamp NULL DEFAULT NULL,
1190 `allocated_timestamp` timestamp NULL DEFAULT NULL,
1191 `disabled_timestamp` timestamp NULL DEFAULT NULL,
1192 `enabled_timestamp` timestamp NULL DEFAULT NULL,
1193 `vpn_id` varchar(12) DEFAULT NULL,
1194 `vpn_rt` varchar(16) DEFAULT NULL,
1195 PRIMARY KEY (`be_id`,`vlan`)
1196 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1199 -- Table structure for table `NCS_EXPECTED_ASYNC_REQUESTS`
1202 CREATE TABLE IF NOT EXISTS `NCS_EXPECTED_ASYNC_REQUESTS` (
1203 `ncs_request_id` varchar(255) NOT NULL,
1204 `mso_gp_request_id` varchar(255) NOT NULL,
1205 `service_instance_id` varchar(255) NOT NULL,
1206 `sdn_module_name` varchar(255) NOT NULL,
1207 `sdn_rpc_name` varchar(255) NOT NULL,
1208 `sdn_service_action` varchar(255) DEFAULT NULL,
1209 `ncs_rpc` varchar(255) NOT NULL,
1210 `ncs_sub_action` varchar(255) DEFAULT NULL,
1211 `status` varchar(255) NOT NULL DEFAULT 'inProgress',
1212 `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1213 PRIMARY KEY (`ncs_request_id`)
1214 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1217 -- Table structure for table `NETWORK_INSTANCE_NAME_INDEX`
1220 CREATE TABLE IF NOT EXISTS `NETWORK_INSTANCE_NAME_INDEX` (
1221 `network_instance_name_prefix` varchar(255) NOT NULL,
1222 `index_number` int(11) NOT NULL,
1223 PRIMARY KEY (`network_instance_name_prefix`)
1224 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1228 -- Table structure for table `SERVICE_MODEL`
1231 CREATE TABLE IF NOT EXISTS `SERVICE_MODEL` (
1232 `service_uuid` varchar(255) NOT NULL,
1233 `model_yaml` longblob,
1234 `invariant_uuid` varchar(255) DEFAULT NULL,
1235 `version` varchar(255) DEFAULT NULL,
1236 `name` varchar(255) DEFAULT NULL,
1237 `description` varchar(1024) DEFAULT NULL,
1238 `type` varchar(255) DEFAULT NULL,
1239 `category` varchar(255) DEFAULT NULL,
1240 `ecomp_naming` char(1) DEFAULT NULL,
1241 `service_instance_name_prefix` varchar(255) DEFAULT NULL,
1242 `filename` varchar(100) DEFAULT NULL,
1243 `naming_policy` varchar(255) DEFAULT NULL,
1244 PRIMARY KEY (`service_uuid`)
1245 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1249 -- Table structure for table `NETWORK_MODEL`
1252 CREATE TABLE IF NOT EXISTS `NETWORK_MODEL` (
1253 `customization_uuid` varchar(255) NOT NULL,
1254 `service_uuid` varchar(255) NOT NULL,
1255 `model_yaml` longblob,
1256 `invariant_uuid` varchar(255) DEFAULT NULL,
1257 `uuid` varchar(255) DEFAULT NULL,
1258 `network_type` varchar(255) DEFAULT NULL,
1259 `network_role` varchar(255) DEFAULT NULL,
1260 `network_technology` varchar(255) DEFAULT NULL,
1261 `trunk_network_indicator` char(1) DEFAULT NULL,
1262 `network_scope` varchar(255) DEFAULT NULL,
1263 `naming_policy` varchar(255) DEFAULT NULL,
1264 `ecomp_generated_naming` char(1) DEFAULT NULL,
1265 `is_shared_network` char(1) DEFAULT NULL,
1266 `is_external_network` char(1) DEFAULT NULL,
1267 `is_provider_network` char(1) DEFAULT NULL,
1268 `physical_network_name` varchar(255) DEFAULT NULL,
1269 `is_bound_to_vpn` char(1) DEFAULT NULL,
1270 `vpn_binding` varchar(255) DEFAULT NULL,
1271 `use_ipv4` char(1) DEFAULT NULL,
1272 `ipv4_dhcp_enabled` char(1) DEFAULT NULL,
1273 `ipv4_ip_version` char(1) DEFAULT NULL,
1274 `ipv4_cidr_mask` varchar(255) DEFAULT NULL,
1275 `eipam_v4_address_plan` varchar(255) DEFAULT NULL,
1276 `use_ipv6` char(1) DEFAULT NULL,
1277 `ipv6_dhcp_enabled` char(1) DEFAULT NULL,
1278 `ipv6_ip_version` char(1) DEFAULT NULL,
1279 `ipv6_cidr_mask` varchar(255) DEFAULT NULL,
1280 `eipam_v6_address_plan` varchar(255) DEFAULT NULL,
1281 `version` varchar(255) DEFAULT NULL,
1282 PRIMARY KEY (`customization_uuid`),
1283 KEY `FK_NETWORK_MODEL` (`service_uuid`),
1284 CONSTRAINT `FK_NETWORK_MODEL` FOREIGN KEY (`service_uuid`) REFERENCES `SERVICE_MODEL` (`service_uuid`) ON DELETE NO ACTION ON UPDATE NO ACTION
1285 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1288 -- Table structure for table `NETWORK_PROFILE`
1291 CREATE TABLE IF NOT EXISTS `NETWORK_PROFILE` (
1292 `network_type` varchar(100) NOT NULL,
1293 `technology` varchar(100) NOT NULL,
1294 PRIMARY KEY (`network_type`)
1295 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1298 -- Table structure for table `NETWORK_ROLE_VPN_BINDING`
1301 CREATE TABLE IF NOT EXISTS `NETWORK_ROLE_VPN_BINDING` (
1302 `network_role` varchar(80) NOT NULL,
1303 `vpn_id` varchar(80) NOT NULL,
1304 PRIMARY KEY (`network_role`,`vpn_id`)
1305 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1308 -- Table structure for table `NODE_TYPES`
1311 CREATE TABLE IF NOT EXISTS `NODE_TYPES` (
1312 `nodetype` varchar(80) NOT NULL,
1313 PRIMARY KEY (`nodetype`)
1314 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1317 -- Table structure for table `OBJECT_GROUPING`
1320 CREATE TABLE IF NOT EXISTS `OBJECT_GROUPING` (
1321 `group_id` varchar(128) NOT NULL,
1322 `group_type` varchar(128) NOT NULL,
1323 PRIMARY KEY (`group_id`)
1324 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1327 -- Table structure for table `OBJECT_GROUP_MEMBER_TRACKING`
1330 CREATE TABLE IF NOT EXISTS `OBJECT_GROUP_MEMBER_TRACKING` (
1331 `group_id` varchar(128) NOT NULL,
1332 `key_id` varchar(128) NOT NULL,
1333 `key_type` varchar(128) NOT NULL,
1334 PRIMARY KEY (`group_id`,`key_id`,`key_type`)
1335 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1338 -- Table structure for table `PARAMETERS`
1341 CREATE TABLE IF NOT EXISTS `PARAMETERS` (
1342 `name` varchar(100) NOT NULL,
1343 `value` varchar(128) NOT NULL,
1344 `category` varchar(24) DEFAULT NULL,
1345 `memo` varchar(128) DEFAULT NULL,
1346 PRIMARY KEY (`name`)
1347 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1350 -- Table structure for table `PE_INV`
1353 CREATE TABLE IF NOT EXISTS `PE_INV` (
1354 `EQUIP_ID` int(11) DEFAULT NULL,
1355 `EQUIP_TYPE` varchar(20) DEFAULT NULL,
1356 `PTNII_EQUIP_NAME` varchar(20) DEFAULT NULL,
1357 `IP_ADDR` varchar(15) DEFAULT NULL,
1358 `ROUTER_PROV_STATUS` varchar(50) DEFAULT NULL,
1359 `REGION` varchar(16) DEFAULT NULL,
1360 `COUNTRY_ABBR` varchar(50) DEFAULT NULL,
1361 `EQUIP_NAME_CODE` varchar(50) DEFAULT NULL,
1362 `AS_NUMBER` varchar(5) DEFAULT NULL,
1363 `LOOPBACK1` varchar(15) DEFAULT NULL,
1364 `LOOPBACK2` varchar(15) DEFAULT NULL,
1365 `LOOPBACK3` varchar(15) DEFAULT NULL,
1366 `LOOPBACK40` varchar(15) DEFAULT NULL,
1367 `LOOPBACK65535` varchar(15) DEFAULT NULL,
1368 `INMS_LIST` varchar(20) DEFAULT NULL,
1369 `ENCRYPTED_ACCESS_FLAG` varchar(50) DEFAULT NULL,
1370 `SW_NAME` varchar(100) DEFAULT NULL,
1371 `NMIPADDR` varchar(15) DEFAULT NULL,
1372 `CREATE_DATE` datetime DEFAULT NULL,
1373 `MOD_DATE` datetime DEFAULT NULL,
1374 `FCN_CODE` varchar(50) DEFAULT NULL
1375 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1378 -- Table structure for table `PHYSICAL_LINK`
1381 CREATE TABLE IF NOT EXISTS `PHYSICAL_LINK` (
1382 `link_name` varchar(255) NOT NULL,
1383 `speed_value` varchar(64) DEFAULT NULL,
1384 `speed_units` varchar(64) DEFAULT NULL,
1385 `circuit_id` varchar(255) NOT NULL,
1386 `dual_mode` varchar(64) NOT NULL,
1387 PRIMARY KEY (`link_name`)
1388 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1391 -- Table structure for table `PHYSICAL_LINK_PINTERFACE`
1394 CREATE TABLE IF NOT EXISTS `PHYSICAL_LINK_PINTERFACE` (
1395 `link_name` varchar(255) NOT NULL,
1396 `hostname` varchar(255) NOT NULL,
1397 `port_name_ft` varchar(255) NOT NULL,
1398 PRIMARY KEY (`link_name`,`hostname`,`port_name_ft`)
1399 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1402 -- Table structure for table `PINTERFACE`
1405 CREATE TABLE IF NOT EXISTS `PINTERFACE` (
1406 `hostname` varchar(255) NOT NULL,
1407 `port_name_ft` varchar(255) NOT NULL,
1408 `interface_name` varchar(255) DEFAULT '',
1409 `physical_speed` varchar(255) DEFAULT '',
1410 `physical_units` varchar(255) DEFAULT '',
1411 `port_description` varchar(255) DEFAULT '',
1412 PRIMARY KEY (`hostname`,`port_name_ft`)
1413 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1416 -- Table structure for table `POLICY_UPDATE_NOTIFICATION`
1419 CREATE TABLE IF NOT EXISTS `POLICY_UPDATE_NOTIFICATION` (
1420 `policy_name` varchar(255) NOT NULL,
1421 `version_id` varchar(255) NOT NULL,
1422 `update_type` varchar(255) NOT NULL,
1423 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1424 PRIMARY KEY (`policy_name`,`version_id`)
1425 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1428 -- Table structure for table `PORTAL_USERS`
1431 CREATE TABLE IF NOT EXISTS `PORTAL_USERS` (
1432 `email` varchar(64) NOT NULL,
1433 `password` varbinary(255) NOT NULL,
1434 `privilege` char(1) NOT NULL,
1435 PRIMARY KEY (`email`)
1436 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1440 -- Table structure for table `PREPARE_FILE_RELATIONSHIP`
1443 CREATE TABLE IF NOT EXISTS `PREPARE_FILE_RELATIONSHIP` (
1444 `prepare_file_relationship_id` int(11) NOT NULL AUTO_INCREMENT,
1445 `service_instance_id` varchar(50) DEFAULT NULL,
1446 `request_id` varchar(255) DEFAULT NULL,
1447 `config_file_id` int(11) DEFAULT NULL,
1448 `asdc_artifacts_id` int(11) DEFAULT NULL,
1449 PRIMARY KEY (`prepare_file_relationship_id`),
1450 UNIQUE KEY `prepare_file_relationship_id` (`prepare_file_relationship_id`),
1451 KEY `ie_prepare_file_relationship` (`config_file_id`),
1452 KEY `ie2_prepare_file_relationship` (`asdc_artifacts_id`),
1453 CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`asdc_artifacts_id`) REFERENCES `ASDC_ARTIFACTS` (`asdc_artifacts_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
1454 CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`config_file_id`) REFERENCES `CONFIGFILES` (`config_file_id`) ON DELETE NO ACTION ON UPDATE CASCADE
1455 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1458 -- Table structure for table `PRE_LOAD_VNF_DATA`
1461 CREATE TABLE IF NOT EXISTS `PRE_LOAD_VNF_DATA` (
1462 `id` int(11) NOT NULL AUTO_INCREMENT,
1463 `svc_request_id` varchar(100) DEFAULT '',
1464 `svc_action` varchar(40) DEFAULT '',
1465 `status` varchar(10) NOT NULL DEFAULT 'pending',
1466 `filename` varchar(100) NOT NULL,
1467 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1468 `preload_data` longblob,
1470 ) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=latin1;
1473 -- Table structure for table `PRE_LOAD_VNF_NETWORK_DATA`
1476 CREATE TABLE IF NOT EXISTS `PRE_LOAD_VNF_NETWORK_DATA` (
1477 `id` int(11) NOT NULL AUTO_INCREMENT,
1478 `svc_request_id` varchar(100) DEFAULT '',
1479 `svc_action` varchar(40) DEFAULT '',
1480 `status` varchar(10) NOT NULL DEFAULT 'pending',
1481 `filename` varchar(100) NOT NULL,
1482 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1483 `preload_data` longblob,
1485 ) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1;
1488 -- Table structure for table `PSERVER`
1491 CREATE TABLE IF NOT EXISTS `PSERVER` (
1492 `hostname` varchar(255) NOT NULL,
1493 `ptnii_equip_name` varchar(255) DEFAULT '',
1494 `number_of_cpus` varchar(255) DEFAULT '',
1495 `disk_in_gigabytes` varchar(255) DEFAULT '',
1496 `ram_in_megabytes` varchar(255) DEFAULT '',
1497 `equip_type` varchar(255) DEFAULT '',
1498 `equip_vendor` varchar(255) DEFAULT '',
1499 `equip_model` varchar(255) DEFAULT '',
1500 `fqdn` varchar(255) DEFAULT '',
1501 `pserver_selflink` varchar(255) DEFAULT '',
1502 `ipv4_oam_address` varchar(40) DEFAULT NULL,
1503 `serial_number` varchar(255) DEFAULT '',
1504 `pserver_id` varchar(255) DEFAULT '',
1505 `internet_topology` varchar(40) DEFAULT '',
1506 `aic_site_id` varchar(100) DEFAULT '',
1507 `in_maint` varchar(5) DEFAULT '',
1508 `pserver_name2` varchar(255) DEFAULT '',
1509 `purpose` varchar(255) DEFAULT '',
1510 PRIMARY KEY (`hostname`)
1511 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1514 -- Table structure for table `RANGE_RULE`
1517 CREATE TABLE IF NOT EXISTS `RANGE_RULE` (
1518 `range_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1519 `range_name` varchar(50) NOT NULL,
1520 `service_model` varchar(50) NOT NULL,
1521 `end_point_position` varchar(50) NOT NULL,
1522 `equipment_level` varchar(50) NOT NULL,
1523 `min_value` int(11) NOT NULL,
1524 `max_value` int(11) NOT NULL,
1525 PRIMARY KEY (`range_rule_id`)
1526 ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
1529 -- Table structure for table `REQUEST_DETAILS`
1532 CREATE TABLE IF NOT EXISTS `REQUEST_DETAILS` (
1533 `request_id` varchar(255) NOT NULL,
1534 `controller_id` varchar(255) DEFAULT NULL,
1535 `status` varchar(255) DEFAULT NULL,
1536 `service_rate` varchar(255) DEFAULT NULL,
1537 `service_instance_id` varchar(255) DEFAULT NULL,
1538 `service_type` varchar(255) DEFAULT NULL,
1539 `global_customer_id` varchar(255) DEFAULT NULL,
1540 `notification_url` varchar(255) DEFAULT NULL,
1541 `domain_requests` varchar(255) DEFAULT NULL,
1542 PRIMARY KEY (`request_id`)
1543 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1546 -- Table structure for table `REQUEST_PROGRESS`
1549 CREATE TABLE IF NOT EXISTS `REQUEST_PROGRESS` (
1550 `request_id` int(11) NOT NULL AUTO_INCREMENT,
1551 `request_type` varchar(20) DEFAULT NULL,
1552 `service_instance_id` varchar(80) NOT NULL,
1553 `request_instance_type` varchar(20) NOT NULL,
1554 `originating_service_instance_id` varchar(80) DEFAULT NULL,
1555 `originating_service_type` varchar(20) DEFAULT NULL,
1556 `overall_status` varchar(20) DEFAULT NULL,
1557 `status_date` varchar(80) DEFAULT NULL,
1558 `message` varchar(255) DEFAULT NULL,
1559 PRIMARY KEY (`request_id`)
1560 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1563 -- Table structure for table `REQUEST_PROGRESS_STATE`
1566 CREATE TABLE IF NOT EXISTS `REQUEST_PROGRESS_STATE` (
1567 `request_progress_state_id` int(11) NOT NULL AUTO_INCREMENT,
1568 `request_id` int(11) DEFAULT NULL,
1569 `service_instance_id` varchar(80) NOT NULL,
1570 `request_instance_type` varchar(20) NOT NULL,
1571 `progress_state` varchar(30) DEFAULT NULL,
1572 `transaction_status` varchar(20) DEFAULT NULL,
1573 `status_date` varchar(80) DEFAULT NULL,
1574 `response_code` varchar(20) DEFAULT NULL,
1575 `message` varchar(255) DEFAULT NULL,
1576 PRIMARY KEY (`request_progress_state_id`)
1577 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1580 -- Table structure for table `RESOURCE`
1583 CREATE TABLE IF NOT EXISTS `RESOURCE` (
1584 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1585 `asset_id` varchar(100) NOT NULL,
1586 `resource_name` varchar(50) NOT NULL,
1587 `resource_type` enum('Limit','Label','Range') NOT NULL,
1588 `lt_used` bigint(20) DEFAULT NULL,
1589 `ll_label` varchar(50) DEFAULT NULL,
1590 `ll_reference_count` smallint(6) DEFAULT NULL,
1591 `rr_used` varchar(4000) DEFAULT NULL,
1592 PRIMARY KEY (`resource_id`),
1593 UNIQUE KEY `resource_id` (`resource_id`),
1594 UNIQUE KEY `IX1_RESOURCE` (`asset_id`,`resource_name`)
1595 ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;
1598 -- Table structure for table `RESOURCE_LOAD`
1601 CREATE TABLE IF NOT EXISTS `RESOURCE_LOAD` (
1602 `resource_load_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1603 `resource_id` bigint(20) NOT NULL,
1604 `application_id` varchar(20) NOT NULL,
1605 `resource_load_time` datetime NOT NULL,
1606 `resource_expiration_time` datetime DEFAULT NULL,
1607 PRIMARY KEY (`resource_load_id`),
1608 UNIQUE KEY `resource_load_id` (`resource_load_id`),
1609 UNIQUE KEY `IX2_RESOURCE_LOAD` (`resource_id`,`application_id`),
1610 KEY `IX1_RESOURCE_LOAD` (`resource_id`)
1611 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1614 -- Table structure for table `RESOURCE_LOCK`
1617 CREATE TABLE IF NOT EXISTS `RESOURCE_LOCK` (
1618 `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1619 `resource_name` varchar(256) DEFAULT NULL,
1620 `lock_holder` varchar(100) NOT NULL,
1621 `lock_count` smallint(6) NOT NULL,
1622 `lock_time` datetime NOT NULL,
1623 `expiration_time` datetime NOT NULL,
1624 PRIMARY KEY (`resource_lock_id`),
1625 UNIQUE KEY `resource_lock_id` (`resource_lock_id`),
1626 UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`)
1627 ) ENGINE=InnoDB AUTO_INCREMENT=29681 DEFAULT CHARSET=latin1;
1630 -- Table structure for table `RESOURCE_RULE`
1633 CREATE TABLE IF NOT EXISTS `RESOURCE_RULE` (
1634 `resource_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1635 `resource_name` varchar(50) NOT NULL,
1636 `service_model` varchar(50) NOT NULL,
1637 `end_point_position` varchar(50) NOT NULL,
1638 `service_expression` varchar(2000) NOT NULL,
1639 `equipment_level` varchar(50) NOT NULL,
1640 `equipment_expression` varchar(2000) NOT NULL,
1641 `allocation_expression` varchar(2000) NOT NULL,
1642 `soft_limit_expression` varchar(2000) NOT NULL,
1643 `hard_limit_expression` varchar(2000) NOT NULL,
1644 PRIMARY KEY (`resource_rule_id`),
1645 UNIQUE KEY `resource_rule_id` (`resource_rule_id`)
1646 ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
1649 -- Table structure for table `RESOURCE_THRESHOLD`
1652 CREATE TABLE IF NOT EXISTS `RESOURCE_THRESHOLD` (
1653 `resource_threshold_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1654 `resource_rule_id` bigint(20) NOT NULL,
1655 `threshold_expression` varchar(2000) NOT NULL,
1656 `threshold_message` varchar(2000) NOT NULL,
1657 PRIMARY KEY (`resource_threshold_id`)
1658 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1661 -- Table structure for table `ROUTER_MASTER`
1664 CREATE TABLE IF NOT EXISTS `ROUTER_MASTER` (
1665 `crs_name` varchar(20) NOT NULL,
1666 `loopback_ip` varchar(20) NOT NULL,
1667 PRIMARY KEY (`crs_name`)
1668 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1671 -- Table structure for table `ROUTING_CHARACTERISTIC_MAPPING`
1674 CREATE TABLE IF NOT EXISTS `ROUTING_CHARACTERISTIC_MAPPING` (
1675 `network_role` varchar(255) NOT NULL,
1676 `vrf_name` varchar(255) NOT NULL,
1677 `routing_characteristic` varchar(255) NOT NULL,
1678 PRIMARY KEY (`network_role`,`vrf_name`)
1679 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1682 -- Table structure for table `SERVICE_HOMING`
1685 CREATE TABLE IF NOT EXISTS `SERVICE_HOMING` (
1686 `service_type` varchar(100) NOT NULL,
1687 `lata` int(3) NOT NULL,
1688 `hubbing_city_type` varchar(40) NOT NULL,
1689 `latitude` float DEFAULT NULL,
1690 `longitude` float DEFAULT NULL,
1691 `primary_aic_site_name` varchar(100) NOT NULL,
1692 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
1693 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
1694 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
1695 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1698 -- Table structure for table `SERVICE_HOMING_BACKUP`
1701 CREATE TABLE IF NOT EXISTS `SERVICE_HOMING_BACKUP` (
1702 `service_type` varchar(100) NOT NULL,
1703 `lata` int(3) NOT NULL,
1704 `hubbing_city_type` varchar(40) NOT NULL,
1705 `latitude` float DEFAULT NULL,
1706 `longitude` float DEFAULT NULL,
1707 `primary_aic_site_name` varchar(100) NOT NULL,
1708 `secondary_aic_site_name` varchar(100) DEFAULT NULL,
1709 `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
1710 PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
1711 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1714 -- Table structure for table `SERVICE_INSTANCE_NAME_INDEX`
1717 CREATE TABLE IF NOT EXISTS `SERVICE_INSTANCE_NAME_INDEX` (
1718 `service_instance_name_prefix` varchar(255) NOT NULL,
1719 `index_number` int(11) NOT NULL,
1720 PRIMARY KEY (`service_instance_name_prefix`)
1721 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1724 -- Table structure for table `SERVICE_MANAGER_CREDENTIALS`
1727 CREATE TABLE IF NOT EXISTS `SERVICE_MANAGER_CREDENTIALS` (
1728 `service_manager_username` varchar(255) NOT NULL,
1729 `service_manager_password` varbinary(255) NOT NULL,
1730 PRIMARY KEY (`service_manager_username`)
1731 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1734 -- Table structure for table `SERVICE_PROXY`
1737 CREATE TABLE IF NOT EXISTS `SERVICE_PROXY` (
1738 `port_mirror_service_uuid` varchar(255) NOT NULL,
1739 `service_proxy_name` varchar(255) NOT NULL,
1740 `source_service_uuid` varchar(255) NOT NULL,
1741 `resources_vendor` varchar(255) DEFAULT NULL,
1742 `resource_vendor_release` varchar(255) DEFAULT NULL,
1743 `description` varchar(255) DEFAULT NULL,
1744 `category` varchar(255) DEFAULT NULL,
1745 `subcategory` varchar(255) DEFAULT NULL,
1746 `version` varchar(255) DEFAULT NULL,
1747 `role` varchar(255) NOT NULL,
1748 `uuid` varchar(255) DEFAULT NULL,
1749 `customization_uuid` varchar(255) DEFAULT NULL,
1750 `invariant_uuid` varchar(255) DEFAULT NULL,
1751 PRIMARY KEY (`port_mirror_service_uuid`,`service_proxy_name`),
1752 KEY `FK_SERVICE_PROXY_SOURCE_TO_SERVICE_MODE` (`source_service_uuid`),
1753 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
1754 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1757 -- Table structure for table `SERVICE_RESOURCE`
1760 CREATE TABLE IF NOT EXISTS `SERVICE_RESOURCE` (
1761 `service_resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1762 `service_instance_id` varchar(80) NOT NULL,
1763 `service_status` enum('Active','Pending') NOT NULL,
1764 `service_change_number` smallint(6) NOT NULL,
1765 `resource_set_id` varchar(100) NOT NULL,
1766 `resource_union_id` varchar(100) NOT NULL,
1767 PRIMARY KEY (`service_instance_id`,`service_change_number`),
1768 UNIQUE KEY `service_resource_id` (`service_resource_id`),
1769 KEY `IX1_SERVICE_RESOURCE` (`service_instance_id`)
1770 ) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=latin1;
1773 -- Table structure for table `SERVICE_TYPE_MAPPING`
1776 CREATE TABLE IF NOT EXISTS `SERVICE_TYPE_MAPPING` (
1777 `sdnc_service_type` varchar(128) NOT NULL,
1778 `ncs_service_type` varchar(128) NOT NULL,
1779 PRIMARY KEY (`sdnc_service_type`,`ncs_service_type`)
1780 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1783 -- Table structure for table `SUBNETPOOL_MAPPING`
1786 CREATE TABLE IF NOT EXISTS `SUBNETPOOL_MAPPING` (
1787 `aic_cloud_region` varchar(16) NOT NULL,
1788 `ntc` varchar(32) NOT NULL,
1789 `lcp` varchar(32) NOT NULL,
1790 `aic_region_id` varchar(255) NOT NULL,
1791 PRIMARY KEY (`aic_cloud_region`)
1792 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1795 -- Table structure for table `SUPPORTED_SEQUENCE_NUMBER`
1798 CREATE TABLE IF NOT EXISTS `SUPPORTED_SEQUENCE_NUMBER` (
1799 `resource_sequence_number` varchar(10) NOT NULL,
1800 `resource_type` varchar(10) NOT NULL,
1801 PRIMARY KEY (`resource_sequence_number`,`resource_type`)
1802 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1805 -- Table structure for table `SVC_LOGIC`
1808 CREATE TABLE IF NOT EXISTS `SVC_LOGIC` (
1809 `module` varchar(80) NOT NULL,
1810 `rpc` varchar(80) NOT NULL,
1811 `version` varchar(40) NOT NULL,
1812 `mode` varchar(5) NOT NULL,
1813 `active` varchar(1) NOT NULL,
1815 `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1816 `md5sum` varchar(128) DEFAULT NULL,
1817 PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
1818 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1821 -- Table structure for table `TABLE_CLEANUP_CONFIGURATION`
1824 CREATE TABLE IF NOT EXISTS `TABLE_CLEANUP_CONFIGURATION` (
1825 `table_name` varchar(255) NOT NULL COMMENT 'The name of the table the cleanup will be performed on',
1826 `days_old` int(11) NOT NULL COMMENT 'Records older than the current date minus DAYS_OLD will be deleted',
1827 `date_column` varchar(255) NOT NULL COMMENT 'The name of the column containing the date to be checked',
1828 `commit_interval` int(11) NOT NULL DEFAULT '2500' COMMENT 'The maximum number of rows a commit may contain',
1829 `query_clause` varchar(1000) DEFAULT NULL COMMENT 'An optional additional query clause to further restrict deletion criteria',
1830 `child_table_name` varchar(255) DEFAULT NULL,
1831 `child_table_pk` varchar(255) DEFAULT NULL,
1832 PRIMARY KEY (`table_name`)
1833 ) 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.';
1836 -- Table structure for table `TASK_TEMPLATE`
1839 CREATE TABLE IF NOT EXISTS `TASK_TEMPLATE` (
1840 `task_template_id` int(11) NOT NULL AUTO_INCREMENT,
1841 `request_type` varchar(20) DEFAULT NULL,
1842 `task_name` varchar(30) NOT NULL,
1843 `task_category` varchar(50) NOT NULL,
1844 `ecomp_task` varchar(50) NOT NULL,
1845 `initial_load` varchar(1) NOT NULL,
1846 `service` varchar(20) DEFAULT NULL,
1847 PRIMARY KEY (`task_template_id`)
1848 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
1851 -- Table structure for table `TENANT`
1854 CREATE TABLE IF NOT EXISTS `TENANT` (
1855 `tenant_id` varchar(255) NOT NULL,
1856 `tenant_name` varchar(255) NOT NULL,
1857 `service_instance_id` varchar(255) NOT NULL,
1858 PRIMARY KEY (`tenant_id`,`tenant_name`)
1859 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1862 -- Table structure for table `TESTTBL`
1865 CREATE TABLE IF NOT EXISTS `TESTTBL` (
1866 `pk` varchar(25) NOT NULL,
1867 `col1` varchar(25) DEFAULT NULL
1868 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1871 -- Table structure for table `THRESHOLD_NOTIFICATION`
1874 CREATE TABLE IF NOT EXISTS `THRESHOLD_NOTIFICATION` (
1875 `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1876 `threshold_expression` varchar(2000) DEFAULT NULL,
1877 `threshold_message` varchar(500) DEFAULT NULL,
1878 PRIMARY KEY (`resource_id`)
1879 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1882 -- Table structure for table `TMP_AIC_AVAIL_ZONE_POOL`
1885 CREATE TABLE IF NOT EXISTS `TMP_AIC_AVAIL_ZONE_POOL` (
1886 `aic_site_id` varchar(100) NOT NULL,
1887 `status` varchar(40) NOT NULL,
1888 `availability_zone` varchar(100) NOT NULL,
1889 `token` int(4) NOT NULL,
1890 `vnf_id` varchar(80) DEFAULT NULL,
1891 `service_type` varchar(100) NOT NULL,
1892 `vnf_type` varchar(20) DEFAULT NULL,
1893 `hypervisor` varchar(10) DEFAULT NULL,
1894 PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
1895 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1898 -- Table structure for table `TOPOLOGY_PARAMETER`
1901 CREATE TABLE IF NOT EXISTS `TOPOLOGY_PARAMETER` (
1902 `parameter_id` int(11) NOT NULL,
1903 `parameter_name` varchar(20) NOT NULL,
1904 `parameter_set` int(11) NOT NULL,
1905 `create_update_time` datetime NOT NULL,
1906 `create_update_user` varchar(40) NOT NULL,
1907 PRIMARY KEY (`parameter_id`)
1908 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1911 -- Table structure for table `TOPOLOGY_PARAMETER_ENTRIES`
1914 CREATE TABLE IF NOT EXISTS `TOPOLOGY_PARAMETER_ENTRIES` (
1915 `parameter_entry_id` int(11) NOT NULL,
1916 `parameter_name` varchar(255) NOT NULL,
1917 `parameter_value` varchar(64) NOT NULL,
1918 `create_update_time` datetime NOT NULL,
1919 `create_update_user` varchar(40) NOT NULL,
1920 PRIMARY KEY (`parameter_entry_id`)
1921 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1924 -- Table structure for table `TOPOLOGY_PARAMETER_TO_ENTRIES`
1927 CREATE TABLE IF NOT EXISTS `TOPOLOGY_PARAMETER_TO_ENTRIES` (
1928 `parameter_id` int(11) DEFAULT NULL,
1929 `parameter_entry_id` int(11) DEFAULT NULL,
1930 `entry_order` int(11) DEFAULT NULL,
1931 `create_update_time` datetime DEFAULT NULL,
1932 `create_update_user` varchar(40) NOT NULL,
1933 KEY `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_id`),
1934 KEY `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` (`parameter_entry_id`),
1935 CONSTRAINT `FK1_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_id`) REFERENCES `TOPOLOGY_PARAMETER` (`parameter_id`),
1936 CONSTRAINT `FK2_TOPOLOGY_PARAMETER_TO_ENTRIES` FOREIGN KEY (`parameter_entry_id`) REFERENCES `TOPOLOGY_PARAMETER_ENTRIES` (`parameter_entry_id`)
1937 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1940 -- Table structure for table `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE`
1943 CREATE TABLE IF NOT EXISTS `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE` (
1944 `interface_name` varchar(255) NOT NULL,
1945 `interface_id` varchar(255) NOT NULL,
1946 `pnf_name` varchar(255) NOT NULL,
1947 `pnf_id` varchar(255) NOT NULL,
1948 `controller_id` varchar(255) DEFAULT NULL,
1949 `rate` varchar(255) DEFAULT NULL,
1950 `clli` varchar(255) DEFAULT NULL,
1951 `connection_point` varchar(255) DEFAULT NULL,
1952 PRIMARY KEY (`interface_name`)
1953 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1956 -- Table structure for table `TRANSACTION_LOG`
1959 CREATE TABLE IF NOT EXISTS `TRANSACTION_LOG` (
1960 `serial_key` int(10) NOT NULL AUTO_INCREMENT,
1961 `log_time` varchar(40) NOT NULL,
1962 `request_id` varchar(80) DEFAULT NULL,
1963 `svc_request_id` varchar(80) DEFAULT NULL,
1964 `x_ecomp_request_id` varchar(80) DEFAULT NULL,
1965 `graph_name` varchar(255) DEFAULT NULL,
1966 PRIMARY KEY (`serial_key`)
1967 ) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;
1971 -- Table structure for table `UPLOAD_CONFIG`
1974 CREATE TABLE IF NOT EXISTS `UPLOAD_CONFIG` (
1975 `upload_config_id` int(11) NOT NULL AUTO_INCREMENT,
1976 `request_id` varchar(50) DEFAULT NULL,
1977 `originator_id` varchar(50) DEFAULT NULL,
1978 `service_description` varchar(100) DEFAULT NULL,
1979 `action` varchar(50) DEFAULT NULL,
1980 `upload_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1981 `vnf_id` varchar(50) DEFAULT NULL,
1982 `vnf_name` varchar(50) DEFAULT NULL,
1983 `vm_name` varchar(50) DEFAULT NULL,
1984 `vnf_type` varchar(50) DEFAULT NULL,
1985 `vnfc_type` varchar(50) DEFAULT NULL,
1986 `host_ip_address` varchar(50) DEFAULT NULL,
1987 `config_indicator` varchar(25) DEFAULT NULL,
1988 `pending_delete` varchar(1) DEFAULT NULL,
1990 PRIMARY KEY (`upload_config_id`),
1991 UNIQUE KEY `upload_config_id` (`upload_config_id`)
1992 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1995 -- Table structure for table `USED_SEQUENCE_NUMBER`
1998 CREATE TABLE IF NOT EXISTS `USED_SEQUENCE_NUMBER` (
1999 `resource_sequence_number` varchar(10) NOT NULL,
2000 `resource_type` varchar(10) NOT NULL,
2001 `zone_region_id` varchar(50) NOT NULL,
2002 PRIMARY KEY (`resource_sequence_number`,`resource_type`,`zone_region_id`)
2003 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2006 -- Table structure for table `USER_TRACE`
2009 CREATE TABLE IF NOT EXISTS `USER_TRACE` (
2010 `user_trace_seq` int(11) NOT NULL AUTO_INCREMENT,
2011 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2012 `identity` varchar(12) DEFAULT NULL,
2013 `action` varchar(128) DEFAULT NULL,
2014 `description` varchar(256) DEFAULT NULL,
2015 PRIMARY KEY (`user_trace_seq`)
2016 ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=latin1;
2019 -- Table structure for table `VENDOR_CODE`
2022 CREATE TABLE IF NOT EXISTS `VENDOR_CODE` (
2023 `vendor_code` varchar(1) NOT NULL,
2024 `vendor` varchar(45) NOT NULL DEFAULT '',
2025 PRIMARY KEY (`vendor_code`,`vendor`)
2026 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2029 -- Table structure for table `VFC_MODEL`
2032 CREATE TABLE IF NOT EXISTS `VFC_MODEL` (
2033 `customization_uuid` varchar(255) NOT NULL,
2034 `model_yaml` longblob,
2035 `invariant_uuid` varchar(255) DEFAULT NULL,
2036 `uuid` varchar(255) DEFAULT NULL,
2037 `version` varchar(255) DEFAULT NULL,
2038 `naming_policy` varchar(255) DEFAULT NULL,
2039 `ecomp_generated_naming` char(1) DEFAULT NULL,
2040 `nfc_function` varchar(255) DEFAULT NULL,
2041 `nfc_naming_code` varchar(255) DEFAULT NULL,
2042 `vm_type` varchar(255) DEFAULT NULL,
2043 `vm_type_tag` varchar(255) DEFAULT NULL,
2044 `vm_image_name` varchar(255) DEFAULT NULL,
2045 `vm_flavor_name` varchar(255) DEFAULT NULL,
2046 `high_availability` varchar(255) DEFAULT NULL,
2047 `nfc_naming` varchar(255) DEFAULT NULL,
2048 `min_instances` int(11) DEFAULT NULL,
2049 `max_instances` int(11) DEFAULT NULL,
2050 PRIMARY KEY (`customization_uuid`)
2051 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2054 -- Table structure for table `VFC_TO_NETWORK_ROLE_MAPPING`
2057 CREATE TABLE IF NOT EXISTS `VFC_TO_NETWORK_ROLE_MAPPING` (
2058 `seq` int(11) NOT NULL AUTO_INCREMENT,
2059 `vfc_customization_uuid` varchar(255) NOT NULL,
2060 `network_role` varchar(255) NOT NULL,
2061 `vm_type` varchar(255) DEFAULT NULL,
2062 `network_role_tag` varchar(255) DEFAULT NULL,
2063 `ipv4_count` int(11) NOT NULL,
2064 `ipv6_count` int(11) NOT NULL,
2065 `ipv4_use_dhcp` char(1) DEFAULT NULL,
2066 `ipv6_use_dhcp` char(1) DEFAULT NULL,
2067 `ipv4_ip_version` char(1) DEFAULT NULL,
2068 `ipv6_ip_version` char(1) DEFAULT NULL,
2069 `extcp_subnetpool_id` varchar(512) DEFAULT NULL,
2070 `ipv4_floating_count` int(11) DEFAULT NULL,
2071 `ipv6_floating_count` int(11) DEFAULT NULL,
2072 `ipv4_address_plan_name` varchar(512) DEFAULT NULL,
2073 `ipv6_address_plan_name` varchar(512) DEFAULT NULL,
2074 `ipv4_vrf_name` varchar(512) DEFAULT NULL,
2075 `ipv6_vrf_name` varchar(512) DEFAULT NULL,
2076 `subnet_role` varchar(255) DEFAULT NULL,
2077 `subinterface_indicator` char(1) DEFAULT NULL,
2078 PRIMARY KEY (`seq`),
2079 KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`)
2080 ) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1;
2083 -- Table structure for table `VF_MODEL`
2086 CREATE TABLE IF NOT EXISTS `VF_MODEL` (
2087 `customization_uuid` varchar(255) NOT NULL,
2088 `model_yaml` longblob,
2089 `invariant_uuid` varchar(255) DEFAULT NULL,
2090 `uuid` varchar(255) DEFAULT NULL,
2091 `version` varchar(255) DEFAULT NULL,
2092 `name` varchar(255) DEFAULT NULL,
2093 `naming_policy` varchar(255) DEFAULT NULL,
2094 `ecomp_generated_naming` char(1) DEFAULT NULL,
2095 `avail_zone_max_count` int(11) DEFAULT NULL,
2096 `nf_function` varchar(255) DEFAULT NULL,
2097 `nf_code` varchar(255) DEFAULT NULL,
2098 `nf_type` varchar(255) DEFAULT NULL,
2099 `nf_role` varchar(255) DEFAULT NULL,
2100 `vendor` varchar(255) DEFAULT NULL,
2101 `vendor_version` varchar(255) DEFAULT NULL,
2102 PRIMARY KEY (`customization_uuid`)
2103 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2106 -- Table structure for table `VF_MODULE_MODEL`
2109 CREATE TABLE IF NOT EXISTS `VF_MODULE_MODEL` (
2110 `customization_uuid` varchar(255) NOT NULL,
2111 `model_yaml` longblob,
2112 `invariant_uuid` varchar(255) DEFAULT NULL,
2113 `uuid` varchar(255) DEFAULT NULL,
2114 `version` varchar(255) DEFAULT NULL,
2115 `vf_module_type` varchar(255) DEFAULT NULL,
2116 `availability_zone_count` int(11) DEFAULT NULL,
2117 `ecomp_generated_vm_assignments` char(1) DEFAULT NULL,
2118 PRIMARY KEY (`customization_uuid`)
2119 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2122 -- Table structure for table `VF_MODULE_TO_VFC_MAPPING`
2125 CREATE TABLE IF NOT EXISTS `VF_MODULE_TO_VFC_MAPPING` (
2126 `seq` int(11) NOT NULL AUTO_INCREMENT,
2127 `vf_module_customization_uuid` varchar(255) NOT NULL,
2128 `vfc_customization_uuid` varchar(255) NOT NULL,
2129 `vm_type` varchar(255) NOT NULL,
2130 `vm_count` int(11) NOT NULL,
2131 PRIMARY KEY (`seq`),
2132 KEY `IX1_VF_MODULE_TO_VFC_MAPPING` (`vf_module_customization_uuid`)
2133 ) ENGINE=InnoDB AUTO_INCREMENT=1591 DEFAULT CHARSET=latin1;
2136 -- Table structure for table `VF_TO_NETWORK_ROLE_MAPPING`
2139 CREATE TABLE IF NOT EXISTS `VF_TO_NETWORK_ROLE_MAPPING` (
2140 `seq` int(11) NOT NULL AUTO_INCREMENT,
2141 `vf_customization_uuid` varchar(255) NOT NULL,
2142 `network_role` varchar(255) NOT NULL,
2143 PRIMARY KEY (`seq`),
2144 KEY `IX1_VF_TO_NETWORK_ROLE_MAPPING` (`vf_customization_uuid`)
2145 ) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=latin1;
2148 -- Table structure for table `VIPR_CONFIGURATION`
2151 CREATE TABLE IF NOT EXISTS `VIPR_CONFIGURATION` (
2152 `seq` int(11) NOT NULL AUTO_INCREMENT,
2153 `serial_number` varchar(255) DEFAULT NULL,
2154 `vnf_id` varchar(255) DEFAULT NULL,
2155 `vnf_name` varchar(255) DEFAULT NULL,
2156 `ecomp_service_instance_id` varchar(255) DEFAULT NULL,
2157 `vm_name` varchar(255) DEFAULT NULL,
2158 `cloud_region_id` varchar(255) DEFAULT NULL,
2159 `cloud_owner` varchar(255) DEFAULT NULL,
2161 ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
2164 -- Table structure for table `VIPR_SZ_MANAGER_KEY`
2167 CREATE TABLE IF NOT EXISTS `VIPR_SZ_MANAGER_KEY` (
2168 `vipr_sz_manager_ip_addr` varchar(40) NOT NULL,
2169 `vipr_sz_manager_state` varchar(10) DEFAULT NULL,
2170 `vipr_sz_manager_api_key` varchar(255) DEFAULT NULL,
2171 PRIMARY KEY (`vipr_sz_manager_ip_addr`)
2172 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2175 -- Table structure for table `VLAN_ID_POOL`
2178 CREATE TABLE IF NOT EXISTS `VLAN_ID_POOL` (
2179 `aic_site_id` varchar(100) NOT NULL,
2180 `purpose` varchar(40) NOT NULL,
2181 `status` varchar(40) NOT NULL,
2182 `vlan_id` int(4) NOT NULL,
2183 `svc_instance_id` varchar(80) DEFAULT NULL,
2184 `availability_zone` varchar(100) DEFAULT NULL,
2185 `vplspe_name` varchar(80) DEFAULT NULL,
2186 PRIMARY KEY (`vlan_id`,`aic_site_id`,`purpose`)
2187 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2190 -- Table structure for table `VLAN_L3INTERFACE_IPV4_ADDRESS`
2193 CREATE TABLE IF NOT EXISTS `VLAN_L3INTERFACE_IPV4_ADDRESS` (
2194 `vnf_id` varchar(80) NOT NULL,
2195 `interface_name` varchar(255) NOT NULL,
2196 `vlan_interface` varchar(255) NOT NULL,
2197 `l3_interface_ipv4_address` varchar(64) NOT NULL,
2198 `l3_interface_ipv4_prefix_length` varchar(45) DEFAULT NULL,
2199 `vlan_id_inner` varchar(45) DEFAULT NULL,
2200 `vlan_id_outer` varchar(45) DEFAULT NULL,
2201 `is_floating` varchar(1) DEFAULT NULL,
2202 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv4_address`),
2203 KEY `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`),
2204 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
2205 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2208 -- Table structure for table `VLAN_L3INTERFACE_IPV6_ADDRESS`
2211 CREATE TABLE IF NOT EXISTS `VLAN_L3INTERFACE_IPV6_ADDRESS` (
2212 `vnf_id` varchar(80) NOT NULL,
2213 `interface_name` varchar(255) NOT NULL,
2214 `vlan_interface` varchar(255) NOT NULL,
2215 `l3_interface_ipv6_address` varchar(64) NOT NULL,
2216 `l3_interface_ipv6_prefix_length` varchar(45) DEFAULT NULL,
2217 `vlan_id_inner` varchar(45) DEFAULT NULL,
2218 `vlan_id_outer` varchar(45) DEFAULT NULL,
2219 `is_floating` varchar(1) DEFAULT NULL,
2220 PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv6_address`),
2221 KEY `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`,`vlan_interface`),
2222 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
2223 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2226 -- Table structure for table `VLAN_PLAN_ID`
2229 CREATE TABLE IF NOT EXISTS `VLAN_PLAN_ID` (
2230 `plan_type` varchar(40) NOT NULL,
2231 `purpose` varchar(40) NOT NULL,
2232 `vlan_plan_id_count` int(4) NOT NULL,
2233 PRIMARY KEY (`vlan_plan_id_count`,`plan_type`,`purpose`)
2234 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2237 -- Table structure for table `VLAN_POOL`
2240 CREATE TABLE IF NOT EXISTS `VLAN_POOL` (
2241 `aic_site_id` varchar(100) NOT NULL,
2242 `availability_zone` varchar(100) NOT NULL,
2243 `vlan_plan_id` varchar(100) NOT NULL,
2244 `plan_type` varchar(40) NOT NULL,
2245 `purpose` varchar(40) NOT NULL,
2246 `vlan_id` int(4) NOT NULL,
2247 `status` varchar(40) NOT NULL,
2248 `reserved_id` varchar(80) DEFAULT NULL,
2249 PRIMARY KEY (`aic_site_id`,`availability_zone`,`vlan_plan_id`,`plan_type`,`purpose`,`vlan_id`)
2250 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2253 -- Table structure for table `VLAN_RANGES`
2256 CREATE TABLE IF NOT EXISTS `VLAN_RANGES` (
2257 `vlan_plan_id` varchar(100) NOT NULL,
2258 `plan_type` varchar(40) NOT NULL,
2259 `purpose` varchar(40) NOT NULL,
2260 `range_start` int(4) NOT NULL,
2261 `range_end` int(4) NOT NULL,
2262 `generated` char(1) DEFAULT NULL,
2263 PRIMARY KEY (`vlan_plan_id`,`plan_type`,`purpose`,`range_start`,`range_end`)
2264 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2267 -- Table structure for table `VM_NAME_INDEX`
2270 CREATE TABLE IF NOT EXISTS `VM_NAME_INDEX` (
2271 `vm_name_prefix` varchar(255) NOT NULL,
2272 `index_number` int(11) NOT NULL,
2273 PRIMARY KEY (`vm_name_prefix`)
2274 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2277 -- Table structure for table `VM_NETWORKS`
2280 CREATE TABLE IF NOT EXISTS `VM_NETWORKS` (
2281 `vnf_type` varchar(200) NOT NULL,
2282 `vm_type` varchar(45) NOT NULL,
2283 `network_role` varchar(45) NOT NULL,
2284 `assign_ips` tinyint(1) NOT NULL,
2285 `assign_macs` tinyint(1) NOT NULL,
2286 `assign_floating_ip` tinyint(1) NOT NULL,
2287 `ip_count` int(11) DEFAULT NULL,
2288 PRIMARY KEY (`vnf_type`,`vm_type`,`network_role`)
2289 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2292 -- Table structure for table `VM_PROFILE`
2295 CREATE TABLE IF NOT EXISTS `VM_PROFILE` (
2296 `vnf_type` varchar(200) NOT NULL,
2297 `vm_type` varchar(45) NOT NULL,
2298 `vm_count` int(11) NOT NULL,
2299 PRIMARY KEY (`vnf_type`,`vm_type`)
2300 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2303 -- Table structure for table `VNF`
2306 CREATE TABLE IF NOT EXISTS `VNF` (
2307 `vnf_id` varchar(80) NOT NULL,
2308 `vnf_name` varchar(80) NOT NULL,
2309 `vnf_type` varchar(10) NOT NULL,
2310 `orchestration_status` varchar(20) DEFAULT NULL,
2311 `heat_stack_id` varchar(80) DEFAULT NULL,
2312 `mso_catalog_key` varchar(80) DEFAULT NULL,
2313 `availability_zone` varchar(80) DEFAULT NULL,
2314 `aic_site_id` varchar(80) DEFAULT NULL,
2315 `oam_ipv4_address` varchar(20) DEFAULT NULL,
2316 `vnf_name2` varchar(80) DEFAULT NULL,
2317 `vpe_id` varchar(80) NOT NULL,
2318 `ipv4_loopback0_address` varchar(80) DEFAULT NULL,
2319 `license_key` varchar(256) DEFAULT NULL,
2320 `entitlement_resource_uuid` varchar(256) DEFAULT NULL,
2321 PRIMARY KEY (`vnf_id`)
2322 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2325 -- Table structure for table `VNFC_DG_MAPPING`
2328 CREATE TABLE IF NOT EXISTS `VNFC_DG_MAPPING` (
2329 `vnfc_dg_mapping_id` int(11) NOT NULL AUTO_INCREMENT,
2330 `action` varchar(50) DEFAULT NULL,
2331 `api_version` varchar(10) DEFAULT NULL,
2332 `vnf_type` varchar(50) DEFAULT NULL,
2333 `vnfc_type` varchar(50) DEFAULT NULL,
2334 `dg_name` varchar(50) NOT NULL,
2335 `dg_version` varchar(50) DEFAULT NULL,
2336 `dg_module` varchar(50) NOT NULL,
2337 PRIMARY KEY (`vnfc_dg_mapping_id`),
2338 UNIQUE KEY `input_constraint` (`action`,`api_version`,`vnf_type`,`vnfc_type`)
2339 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2342 -- Table structure for table `VNFC_REFERENCE`
2345 CREATE TABLE IF NOT EXISTS `VNFC_REFERENCE` (
2346 `vnfc_reference_id` int(11) NOT NULL AUTO_INCREMENT,
2347 `action` varchar(50) NOT NULL,
2348 `vnf_type` varchar(50) NOT NULL,
2349 `vm_instance` int(11) NOT NULL,
2350 `vnfc_instance` int(11) NOT NULL,
2351 `vnfc_type` varchar(50) NOT NULL,
2352 `vnfc_function_code` varchar(50) NOT NULL,
2353 `ipaddress_v4_oam_vip` varchar(50) DEFAULT NULL,
2354 `group_notation_type` varchar(50) DEFAULT NULL,
2355 `group_notation_value` varchar(50) DEFAULT NULL,
2356 PRIMARY KEY (`vnfc_reference_id`),
2357 UNIQUE KEY `vnfc_reference_id` (`vnfc_reference_id`)
2358 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2361 -- Table structure for table `VNF_IMAGE`
2364 CREATE TABLE IF NOT EXISTS `VNF_IMAGE` (
2365 `application_vendor` varchar(255) NOT NULL,
2366 `application_version` varchar(255) NOT NULL,
2367 `att_uuid` varchar(255) NOT NULL,
2368 `application` varchar(255) DEFAULT NULL,
2369 `selflink` varchar(255) DEFAULT NULL,
2370 PRIMARY KEY (`application_vendor`,`application_version`,`att_uuid`)
2371 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2374 -- Table structure for table `VNF_MODEL_LICENSES`
2377 CREATE TABLE IF NOT EXISTS `VNF_MODEL_LICENSES` (
2378 `att_part_number` varchar(255) NOT NULL,
2379 `license_assignment_group` varchar(255) NOT NULL,
2380 `license_required` tinyint(1) DEFAULT NULL,
2381 `entitlement_assignment_group` varchar(255) DEFAULT NULL,
2382 `entitlement_required` tinyint(1) DEFAULT '0',
2383 `feature_group_uuid` varchar(255) DEFAULT NULL,
2384 PRIMARY KEY (`att_part_number`,`license_assignment_group`)
2385 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2388 -- Table structure for table `VNF_MODEL_LICENSE_FEATURES`
2391 CREATE TABLE IF NOT EXISTS `VNF_MODEL_LICENSE_FEATURES` (
2392 `att_part_number` varchar(255) NOT NULL,
2393 `license_assignment_group` varchar(255) NOT NULL,
2394 `feature` varchar(255) NOT NULL,
2395 PRIMARY KEY (`att_part_number`,`license_assignment_group`,`feature`)
2396 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2399 -- Table structure for table `VNF_NAME_INDEX`
2402 CREATE TABLE IF NOT EXISTS `VNF_NAME_INDEX` (
2403 `vnf_name_prefix` varchar(255) NOT NULL,
2404 `index_number` int(11) NOT NULL,
2405 PRIMARY KEY (`vnf_name_prefix`)
2406 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2409 -- Table structure for table `VNF_NETWORKS`
2412 CREATE TABLE IF NOT EXISTS `VNF_NETWORKS` (
2413 `vnf_type` varchar(200) NOT NULL,
2414 `network_role` varchar(45) NOT NULL,
2415 PRIMARY KEY (`vnf_type`,`network_role`)
2416 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2419 -- Table structure for table `VNF_NETWORK_CONNECTION`
2422 CREATE TABLE IF NOT EXISTS `VNF_NETWORK_CONNECTION` (
2423 `connection_uuid` varchar(80) NOT NULL,
2424 `vnf_id` varchar(80) NOT NULL,
2425 `connection_id` varchar(80) DEFAULT NULL,
2426 `connection_type` varchar(20) DEFAULT NULL,
2427 `neutron_network_id` varchar(80) DEFAULT NULL,
2428 `neutron_network_name` varchar(80) DEFAULT NULL,
2429 `orchestration_status` varchar(20) DEFAULT NULL,
2430 `switch_id` varchar(40) DEFAULT NULL,
2431 `heat_stack_id` varchar(80) DEFAULT NULL,
2432 `mso_catalog_key` varchar(80) DEFAULT NULL,
2433 `provider_network` varchar(80) DEFAULT NULL,
2434 `port_group_id` varchar(80) DEFAULT NULL,
2435 `port_group_name` varchar(80) DEFAULT NULL,
2436 PRIMARY KEY (`connection_uuid`)
2437 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2440 -- Table structure for table `VNF_NETWORK_CONNECTION_VLAN`
2443 CREATE TABLE IF NOT EXISTS `VNF_NETWORK_CONNECTION_VLAN` (
2444 `vlan_uuid` varchar(80) NOT NULL,
2445 `vlan_id` int(4) NOT NULL,
2446 `vlan_type` varchar(5) NOT NULL,
2447 `connection_uuid` varchar(80) DEFAULT NULL,
2448 PRIMARY KEY (`vlan_uuid`)
2449 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2452 -- Table structure for table `VNF_PROFILE`
2455 CREATE TABLE IF NOT EXISTS `VNF_PROFILE` (
2456 `vnf_type` varchar(200) NOT NULL,
2457 `availability_zone_count` int(11) NOT NULL,
2458 `equipment_role` varchar(80) NOT NULL,
2459 PRIMARY KEY (`vnf_type`)
2460 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2463 -- Table structure for table `VNF_SERVICE_TO_NETWORK_ROLE_FILTER`
2466 CREATE TABLE IF NOT EXISTS `VNF_SERVICE_TO_NETWORK_ROLE_FILTER` (
2467 `vnf_service_type` varchar(60) NOT NULL,
2468 `network_role_filter` varchar(60) NOT NULL,
2469 PRIMARY KEY (`vnf_service_type`,`network_role_filter`)
2470 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2473 -- Table structure for table `VPE_LOCK`
2476 CREATE TABLE IF NOT EXISTS `VPE_LOCK` (
2477 `vpe_name` varchar(20) NOT NULL,
2478 `vpn_lock` varchar(20) NOT NULL,
2479 PRIMARY KEY (`vpe_name`)
2480 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2483 -- Table structure for table `VPE_MAC_ADDRESS_POOL`
2486 CREATE TABLE IF NOT EXISTS `VPE_MAC_ADDRESS_POOL` (
2487 `id` int(11) NOT NULL,
2488 `mac_address` varchar(50) NOT NULL,
2489 `sw_name` varchar(30) NOT NULL,
2491 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2494 -- Table structure for table `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING`
2497 CREATE TABLE IF NOT EXISTS `VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING` (
2498 `id` int(11) NOT NULL,
2499 `hostname` varchar(50) NOT NULL,
2500 `assigned_user` varchar(25) NOT NULL,
2501 `assigned_date` date DEFAULT NULL,
2503 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2506 -- Table structure for table `VPE_POOL`
2509 CREATE TABLE IF NOT EXISTS `VPE_POOL` (
2510 `vpe_name` varchar(20) NOT NULL,
2511 `ipv4_oam_address` varchar(20) NOT NULL,
2512 `loopback0_ipv4_address` varchar(20) NOT NULL,
2513 `provisioning_status` varchar(10) NOT NULL,
2514 `aic_site_id` varchar(100) NOT NULL,
2515 `availability_zone` varchar(100) NOT NULL,
2516 `vlan_id_outer` varchar(20) NOT NULL,
2517 `vendor` varchar(20) NOT NULL,
2518 `physical_intf_name` varchar(40) NOT NULL,
2519 `physical_intf_speed` varchar(20) NOT NULL,
2520 `physical_intf_units` varchar(20) NOT NULL,
2521 `vpe_uuid` varchar(80) DEFAULT NULL,
2522 `vpe_id` varchar(80) NOT NULL,
2523 `image_filename` varchar(100) DEFAULT NULL,
2524 `as_number` varchar(20) NOT NULL,
2525 `loopback5000` varchar(16) DEFAULT NULL,
2526 `loopback10` varchar(16) DEFAULT NULL,
2527 `aic_version` varchar(50) DEFAULT NULL,
2528 `vpe_capacity` int(11) NOT NULL,
2529 PRIMARY KEY (`aic_site_id`,`vpe_name`,`availability_zone`)
2530 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2533 -- Table structure for table `VPLSPE_POOL`
2536 CREATE TABLE IF NOT EXISTS `VPLSPE_POOL` (
2537 `vplspe_name` varchar(20) NOT NULL,
2538 `aic_site_id` varchar(100) NOT NULL,
2539 `availability_zone` varchar(100) NOT NULL,
2540 `physical_intf_name` varchar(40) NOT NULL,
2541 `physical_intf_speed` varchar(20) NOT NULL,
2542 `physical_intf_units` varchar(20) NOT NULL,
2543 `loopback0_ipv4_address` varchar(20) NOT NULL,
2544 `vlan_id_outer` varchar(20) NOT NULL,
2545 `vplspe_uuid` varchar(80) DEFAULT NULL,
2546 `image_filename` varchar(100) DEFAULT NULL,
2547 `provisioning_status` varchar(10) DEFAULT NULL,
2548 `vendor` varchar(20) DEFAULT NULL,
2549 PRIMARY KEY (`vplspe_name`,`aic_site_id`,`availability_zone`,`physical_intf_name`)
2550 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2553 -- Table structure for table `VPN_BINDINGS`
2556 CREATE TABLE IF NOT EXISTS `VPN_BINDINGS` (
2557 `network_customization_uuid` varchar(255) NOT NULL,
2558 `binding_uuid` varchar(255) NOT NULL,
2559 PRIMARY KEY (`network_customization_uuid`,`binding_uuid`)
2560 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2563 -- Table structure for table `VRR_FUNCTION_CODE_VMTYPE_MAPPING`
2566 CREATE TABLE IF NOT EXISTS `VRR_FUNCTION_CODE_VMTYPE_MAPPING` (
2567 `ptnii_function_code` varchar(128) NOT NULL,
2568 `vm_type` varchar(128) NOT NULL,
2569 PRIMARY KEY (`ptnii_function_code`,`vm_type`)
2570 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2573 -- Table structure for table `VSERVER`
2576 CREATE TABLE IF NOT EXISTS `VSERVER` (
2577 `tenant_id` varchar(40) NOT NULL,
2578 `vserver_id` varchar(40) NOT NULL,
2579 `aic_site_id` varchar(100) NOT NULL,
2580 `vendor` varchar(20) NOT NULL,
2581 `image_name` varchar(100) NOT NULL,
2582 `vnf_type` varchar(10) NOT NULL,
2583 `vnf_id` varchar(80) NOT NULL,
2584 PRIMARY KEY (`tenant_id`,`vserver_id`)
2585 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2588 -- Table structure for table `VSERVER2`
2591 CREATE TABLE IF NOT EXISTS `VSERVER2` (
2592 `tenant_id` varchar(255) NOT NULL,
2593 `vserver_id` varchar(128) NOT NULL,
2594 `vserver_name` varchar(255) NOT NULL,
2595 `vserver_name2` varchar(255) DEFAULT NULL,
2596 `prov_status` varchar(20) DEFAULT NULL,
2597 `selflink` varchar(255) DEFAULT NULL,
2598 PRIMARY KEY (`tenant_id`,`vserver_id`)
2599 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2602 -- Table structure for table `VSERVER_PSERVER`
2605 CREATE TABLE IF NOT EXISTS `VSERVER_PSERVER` (
2606 `vserver_id` varchar(128) NOT NULL,
2607 `pserver_hostname` varchar(255) DEFAULT NULL,
2608 PRIMARY KEY (`vserver_id`)
2609 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2612 -- Table structure for table `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING`
2615 CREATE TABLE IF NOT EXISTS `VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING` (
2616 `key_id` varchar(128) NOT NULL,
2617 `cloud_region` varchar(128) NOT NULL,
2618 `key_type` varchar(128) NOT NULL,
2619 PRIMARY KEY (`key_id`,`cloud_region`,`key_type`)
2620 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2623 -- Table structure for table `WAN_COMBO_ALLOWABLE`
2626 CREATE TABLE IF NOT EXISTS `WAN_COMBO_ALLOWABLE` (
2627 `combo_sequence` int(11) NOT NULL AUTO_INCREMENT,
2628 `topology` varchar(16) DEFAULT 'unknown',
2629 `internet_topology` varchar(20) DEFAULT NULL,
2630 `wan1` varchar(40) DEFAULT NULL,
2631 `wan2` varchar(40) DEFAULT NULL,
2632 `new_start_release_flexware` varchar(16) DEFAULT 'unknown',
2633 `is_active_flexware` varchar(1) DEFAULT 'N',
2634 `new_start_release_dhv` varchar(16) DEFAULT 'unknown',
2635 `is_active_dhv` varchar(1) DEFAULT 'N',
2636 `ucpe_type` varchar(32) DEFAULT 'stand-alone',
2637 `description` varchar(128) NOT NULL,
2638 PRIMARY KEY (`combo_sequence`),
2639 UNIQUE KEY `IX1_WAN_COMBO_ALLOWABLE` (`internet_topology`,`wan1`,`wan2`)
2640 ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
2642 CREATE TABLE IF NOT EXISTS `DHCP_MAP` (
2643 `mac_addr` varchar(128) NOT NULL,
2644 `ip_addr` varchar(128) DEFAULT NULL,
2645 PRIMARY KEY (`mac_addr`)
2646 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2648 CREATE TABLE IF NOT EXISTS `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING` (
2649 `group_uuid` varchar(255) NOT NULL,
2650 `parent_uuid` varchar(255) NOT NULL,
2651 `target_node_uuid` varchar(255) NOT NULL,
2652 `target_type` varchar(255) NULL,
2653 `table_name` varchar(255) NULL,
2654 PRIMARY KEY (`group_uuid`, `parent_uuid`, `target_node_uuid`)
2655 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2659 CREATE TABLE IF NOT EXISTS `ATTRIBUTE_VALUE_PAIR` (
2660 `resource_uuid` varchar(255) NOT NULL,
2661 `attribute_name` varchar(255) NOT NULL,
2662 `resource_type` varchar(255) NOT NULL,
2663 `attribute_value` varchar(255) DEFAULT NULL,
2664 `resource_customization_uuid` varchar(255) DEFAULT NULL,
2665 PRIMARY KEY (`resource_uuid`,`attribute_name`,`resource_type`)
2666 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2668 CREATE TABLE IF NOT EXISTS `COMPLEX_RESOURCE` (
2669 `uuid` varchar(255) NOT NULL,
2670 `model_yaml` longblob,
2671 `invariant_uuid` varchar(255) NOT NULL,
2672 `customization_uuid` varchar(255) NOT NULL,
2673 `version` varchar(255) DEFAULT NULL,
2674 `name` varchar(255) DEFAULT NULL,
2675 `description` varchar(255) DEFAULT NULL,
2676 `type` varchar(255) NOT NULL,
2677 PRIMARY KEY (`uuid`,`customization_uuid`)
2678 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2680 CREATE TABLE IF NOT EXISTS `NODE_CAPABILITY` (
2681 `capability_id` int(11) NOT NULL AUTO_INCREMENT,
2682 `capability_provider_uuid` varchar(255) NOT NULL,
2683 `capability_provider_customization_uuid` varchar(255) NOT NULL,
2684 `capability_name` varchar(255) DEFAULT NULL,
2685 `capability_type` varchar(255) DEFAULT NULL,
2686 PRIMARY KEY (`capability_id`)
2687 ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
2689 CREATE TABLE IF NOT EXISTS `NODE_REQUIREMENT` (
2690 `requirement_id` int(11) NOT NULL AUTO_INCREMENT,
2691 `capability_id` int(11) DEFAULT NULL,
2692 `capability_provider_uuid` varchar(255) DEFAULT NULL,
2693 `capability_provider_customization_uuid` varchar(255) DEFAULT NULL,
2694 `capability_consumer_uuid` varchar(255) NOT NULL,
2695 `capability_consumer_customization_uuid` varchar(255) NOT NULL,
2696 `requirement_name` varchar(255) NOT NULL,
2697 PRIMARY KEY (`requirement_id`),
2698 KEY `NODE_REQUIREMENT_TO_NODE_CAPABILITY` (`capability_id`)
2699 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2701 CREATE TABLE IF NOT EXISTS `RELATED_NETWORK_ROLE` (
2702 `network_model_customization_uuid` varchar(255) NOT NULL,
2703 `related_network_role` varchar(255) NOT NULL,
2704 PRIMARY KEY (`network_model_customization_uuid`,`related_network_role`)
2705 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2707 CREATE TABLE IF NOT EXISTS `RESOURCE_GROUP` (
2708 `resource_uuid` varchar(255) NOT NULL,
2709 `group_uuid` varchar(255) NOT NULL,
2710 `group_customization_uuid` varchar(255) DEFAULT NULL,
2711 `group_invariant_uuid` varchar(255) NOT NULL,
2712 `group_name` varchar(255) DEFAULT NULL,
2713 `version` varchar(255) DEFAULT NULL,
2714 `group_type` varchar(255) DEFAULT NULL,
2715 PRIMARY KEY (`resource_uuid`,`group_uuid`)
2716 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2718 CREATE TABLE IF NOT EXISTS `RESOURCE_POLICY` (
2719 `resource_uuid` varchar(255) NOT NULL,
2720 `policy_uuid` varchar(255) NOT NULL,
2721 `policy_customization_uuid` varchar(255) DEFAULT NULL,
2722 `policy_invariant_uuid` varchar(255) NOT NULL,
2723 `policy_name` varchar(255) DEFAULT NULL,
2724 `version` varchar(255) DEFAULT NULL,
2725 `policy_type` varchar(255) DEFAULT NULL,
2726 `property_type` varchar(255) DEFAULT NULL,
2727 `property_source` varchar(255) DEFAULT NULL,
2728 `property_name` varchar(255) DEFAULT NULL,
2729 PRIMARY KEY (`resource_uuid`,`policy_uuid`)
2730 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2732 CREATE TABLE IF NOT EXISTS `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING` (
2733 `policy_uuid` varchar(255) NOT NULL,
2734 `parent_uuid` varchar(255) NOT NULL,
2735 `target_node_uuid` varchar(255) NOT NULL,
2736 `target_type` varchar(255) DEFAULT NULL,
2737 `target_node_customization_uuid` varchar(255) DEFAULT NULL,
2738 `policy_customization_uuid` varchar(255) DEFAULT NULL,
2739 PRIMARY KEY (`policy_uuid`,`parent_uuid`,`target_node_uuid`)
2740 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2743 CREATE TABLE IF NOT EXISTS `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING` (
2744 `service_uuid` varchar(255) NOT NULL,
2745 `complex_resource_uuid` varchar(255) NOT NULL,
2746 `complex_resource_customization_uuid` varchar(255) NOT NULL,
2747 PRIMARY KEY (`service_uuid`,`complex_resource_uuid`,`complex_resource_customization_uuid`)
2748 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2750 CREATE TABLE IF NOT EXISTS `VFC_RELATED_NETWORK_ROLE` (
2751 `vfc_customization_uuid` varchar(255) NOT NULL,
2752 `vm_type` varchar(255) NOT NULL,
2753 `network_role` varchar(255) NOT NULL,
2754 `related_network_role` varchar(255) NOT NULL,
2755 PRIMARY KEY (`vfc_customization_uuid`,`vm_type`,`network_role`,`related_network_role`)
2756 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2758 CREATE TABLE IF NOT EXISTS `VNF_RELATED_NETWORK_ROLE` (
2759 `vnf_customization_uuid` varchar(255) NOT NULL,
2760 `network_role` varchar(255) NOT NULL,
2761 `related_network_role` varchar(255) NOT NULL,
2762 PRIMARY KEY (`vnf_customization_uuid`,`network_role`,`related_network_role`)
2763 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;