---
--- Table structure for table `AGNOSTIC_NOTIFICATION_URL`
---
-
-DROP TABLE IF EXISTS `AGNOSTIC_NOTIFICATION_URL`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AGNOSTIC_NOTIFICATION_URL` (
- `service_type` varchar(128) NOT NULL,
- `service_instance_id` varchar(128) NOT NULL,
- `request_id` varchar(128) NOT NULL,
- `svc_notification_url` varchar(256) NOT NULL,
- PRIMARY KEY (`service_type`,`service_instance_id`,`request_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AGNOSTIC_TO_SVC_SPCFC_API`
---
-
-DROP TABLE IF EXISTS `AGNOSTIC_TO_SVC_SPCFC_API`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AGNOSTIC_TO_SVC_SPCFC_API` (
- `operation` varchar(128) NOT NULL,
- `service` varchar(128) NOT NULL,
- `service_specific_api` varchar(128) NOT NULL,
- `async_process` varchar(15) DEFAULT NULL,
- PRIMARY KEY (`operation`,`service`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_AVAIL_ZONE_POOL`
---
-
-DROP TABLE IF EXISTS `AIC_AVAIL_ZONE_POOL`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_AVAIL_ZONE_POOL` (
- `aic_site_id` varchar(100) NOT NULL,
- `status` varchar(40) NOT NULL,
- `availability_zone` varchar(100) NOT NULL,
- `token` varchar(5) NOT NULL,
- `vnf_id` varchar(80) DEFAULT NULL,
- `service_type` varchar(100) NOT NULL,
- `vnf_type` varchar(20) DEFAULT NULL,
- `hypervisor` varchar(10) DEFAULT NULL,
- PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_HOSTNAME`
---
-
-DROP TABLE IF EXISTS `AIC_HOSTNAME`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_HOSTNAME` (
- `hostname` varchar(20) NOT NULL,
- `cust_id` int(11) NOT NULL,
- `vendor_code` varchar(1) NOT NULL,
- `virtual_device_type` varchar(2) DEFAULT NULL,
- `device_sequence` varchar(3) NOT NULL,
- `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`hostname`),
- UNIQUE KEY `hostname` (`hostname`),
- KEY `IN1_AIC_HOSTNAME` (`cust_id`),
- CONSTRAINT `AC1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_NETWORK`
---
-
-DROP TABLE IF EXISTS `AIC_NETWORK`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_NETWORK` (
- `network_id` varchar(100) NOT NULL,
- `network_name` varchar(100) DEFAULT NULL,
- `status` varchar(20) DEFAULT NULL,
- `tenant_id` varchar(100) DEFAULT NULL,
- `switch_uuid` varchar(100) DEFAULT NULL,
- `portgroup_name` varchar(100) DEFAULT NULL,
- `portgroup_id` varchar(100) DEFAULT NULL,
- PRIMARY KEY (`network_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_SITE`
---
-
-DROP TABLE IF EXISTS `AIC_SITE`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_SITE` (
- `name` varchar(100) DEFAULT NULL,
- `aic_site_id` varchar(100) NOT NULL,
- `vcenter_url` varchar(200) DEFAULT NULL,
- `vcenter_username` varchar(40) DEFAULT NULL,
- `vcenter_passwd` varbinary(255) DEFAULT NULL,
- `city` varchar(100) DEFAULT NULL,
- `state` varchar(2) DEFAULT NULL,
- `operational_status` varchar(20) DEFAULT NULL,
- `oam_gateway_addr` varchar(20) DEFAULT '',
- PRIMARY KEY (`aic_site_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_SWITCH`
---
-
-DROP TABLE IF EXISTS `AIC_SWITCH`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_SWITCH` (
- `switch_name` varchar(100) DEFAULT NULL,
- `physical_network_name` varchar(100) NOT NULL,
- `aic_site_id` varchar(100) DEFAULT NULL,
- `uuid` varchar(100) DEFAULT NULL,
- `availability_zone` varchar(100) DEFAULT NULL,
- PRIMARY KEY (`physical_network_name`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-