`aic_site_id` varchar(100) NOT NULL,
`status` varchar(40) NOT NULL,
`availability_zone` varchar(100) NOT NULL,
- `token` int(4) 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,
CREATE TABLE `AIC_HOSTNAME` (
`hostname` varchar(20) NOT NULL,
`cust_id` int(11) NOT NULL,
- `aic_site_id` varchar(100) DEFAULT NULL,
`vendor_code` varchar(1) NOT NULL,
`virtual_device_type` varchar(2) DEFAULT NULL,
`device_sequence` varchar(3) NOT NULL,
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CONFIG_TRANSACTION_LOG` (
- `config_transaction_log_id` int(11) NOT NULL AUTO_INCREMENT,
+ `config_transaction_log_id` varchar(50) NOT NULL,
`request_id` varchar(50) DEFAULT NULL,
- `message_type` varchar(50) DEFAULT NULL,
+ `message_type` varchar(100) DEFAULT NULL,
`creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`message` longtext,
PRIMARY KEY (`config_transaction_log_id`),
CREATE TABLE `GENERIC_RESOURCE_NAME` (
`type` varchar(50) NOT NULL,
`name` varchar(255) NOT NULL,
+ `prefix` varchar(255) NULL,
+ `name_index` int(11) NULL,
+ `context_id` varchar(255) NULL,
PRIMARY KEY (`type`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
`network_type` varchar(255) DEFAULT NULL,
`network_role` varchar(255) DEFAULT NULL,
`network_technology` varchar(255) DEFAULT NULL,
+ `trunk_network_indicator` char(1) DEFAULT NULL,
`network_scope` varchar(255) DEFAULT NULL,
`naming_policy` varchar(255) DEFAULT NULL,
`ecomp_generated_naming` char(1) DEFAULT NULL,
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PORTAL_USERS` (
- `attuid` varchar(6) NOT NULL,
- `firstName` varchar(25) DEFAULT NULL,
- `lastName` varchar(25) DEFAULT NULL,
- `role` varchar(25) DEFAULT NULL,
+ `email` varchar(64) NOT NULL,
+ `password` varbinary(255) NOT NULL,
`privilege` char(1) NOT NULL,
- `last_login` timestamp NULL DEFAULT NULL,
- PRIMARY KEY (`attuid`)
+ PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
`svc_action` varchar(40) DEFAULT '',
`status` varchar(10) NOT NULL DEFAULT 'pending',
`filename` varchar(100) NOT NULL,
- `attuid` varchar(8) NOT NULL,
`ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`preload_data` longblob,
PRIMARY KEY (`id`)
`svc_action` varchar(40) DEFAULT '',
`status` varchar(10) NOT NULL DEFAULT 'pending',
`filename` varchar(100) NOT NULL,
- `attuid` varchar(8) NOT NULL,
`ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`preload_data` longblob,
PRIMARY KEY (`id`)
`equip_model` varchar(255) DEFAULT '',
`fqdn` varchar(255) DEFAULT '',
`pserver_selflink` varchar(255) DEFAULT '',
- `ipv4_oam_address` varchar(15) DEFAULT '',
+ `ipv4_oam_address` varchar(40) DEFAULT NULL,
`serial_number` varchar(255) DEFAULT '',
`pserver_id` varchar(255) DEFAULT '',
`internet_topology` varchar(40) DEFAULT '',
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
+--
+-- Table structure for table `REQUEST_DETAILS`
+--
+
+DROP TABLE IF EXISTS `REQUEST_DETAILS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `REQUEST_DETAILS` (
+ `request_id` varchar(255) NOT NULL,
+ `controller_id` varchar(255) DEFAULT NULL,
+ `status` varchar(255) DEFAULT NULL,
+ `service_rate` varchar(255) DEFAULT NULL,
+ `service_instance_id` varchar(255) DEFAULT NULL,
+ `service_type` varchar(255) DEFAULT NULL,
+ `global_customer_id` varchar(255) DEFAULT NULL,
+ `notification_url` varchar(255) DEFAULT NULL,
+ `domain_requests` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`request_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
--
-- Table structure for table `REQUEST_PROGRESS`
--
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
+--
+-- Table structure for table `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE`
+--
+
+DROP TABLE IF EXISTS `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE` (
+ `interface_name` varchar(255) NOT NULL,
+ `interface_id` varchar(255) NOT NULL,
+ `pnf_name` varchar(255) NOT NULL,
+ `pnf_id` varchar(255) NOT NULL,
+ `controller_id` varchar(255) DEFAULT NULL,
+ `rate` varchar(255) DEFAULT NULL,
+ `clli` varchar(255) DEFAULT NULL,
+ `connection_point` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`interface_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
--
-- Table structure for table `TRANSACTION_LOG`
--
`ipv4_vrf_name` varchar(512) DEFAULT NULL,
`ipv6_vrf_name` varchar(512) DEFAULT NULL,
`subnet_role` varchar(255) DEFAULT NULL,
+ `subinterface_indicator` char(1) DEFAULT NULL,
PRIMARY KEY (`seq`),
KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1;
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `DHCP_MAP`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DHCP_MAP` (
+ `mac_addr` varchar(128) NOT NULL,
+ `ip_addr` varchar(128) DEFAULT NULL,
+ PRIMARY KEY (`mac_addr`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING`;
+CREATE TABLE `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING` (
+ `group_uuid` varchar(255) NOT NULL,
+ `parent_uuid` varchar(255) NOT NULL,
+ `target_node_uuid` varchar(255) NOT NULL,
+ `target_type` varchar(255) NULL,
+ `table_name` varchar(255) NULL,
+ PRIMARY KEY (`group_uuid`, `parent_uuid`, `target_node_uuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+DROP TABLE IF EXISTS `ATTRIBUTE_VALUE_PAIR`;
+CREATE TABLE `ATTRIBUTE_VALUE_PAIR` (
+ `resource_uuid` varchar(255) NOT NULL,
+ `attribute_name` varchar(255) NOT NULL,
+ `resource_type` varchar(255) NOT NULL,
+ `attribute_value` varchar(255) DEFAULT NULL,
+ `resource_customization_uuid` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`resource_uuid`,`attribute_name`,`resource_type`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `COMPLEX_RESOURCE`;
+CREATE TABLE `COMPLEX_RESOURCE` (
+ `uuid` varchar(255) NOT NULL,
+ `model_yaml` longblob,
+ `invariant_uuid` varchar(255) NOT NULL,
+ `customization_uuid` varchar(255) NOT NULL,
+ `version` varchar(255) DEFAULT NULL,
+ `name` varchar(255) DEFAULT NULL,
+ `description` varchar(255) DEFAULT NULL,
+ `type` varchar(255) NOT NULL,
+ PRIMARY KEY (`uuid`,`customization_uuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `NODE_CAPABILITY`;
+CREATE TABLE `NODE_CAPABILITY` (
+ `capability_id` int(11) NOT NULL AUTO_INCREMENT,
+ `capability_provider_uuid` varchar(255) NOT NULL,
+ `capability_provider_customization_uuid` varchar(255) NOT NULL,
+ `capability_name` varchar(255) DEFAULT NULL,
+ `capability_type` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`capability_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `NODE_REQUIREMENT`;
+CREATE TABLE `NODE_REQUIREMENT` (
+ `requirement_id` int(11) NOT NULL AUTO_INCREMENT,
+ `capability_id` int(11) DEFAULT NULL,
+ `capability_provider_uuid` varchar(255) DEFAULT NULL,
+ `capability_provider_customization_uuid` varchar(255) DEFAULT NULL,
+ `capability_consumer_uuid` varchar(255) NOT NULL,
+ `capability_consumer_customization_uuid` varchar(255) NOT NULL,
+ `requirement_name` varchar(255) NOT NULL,
+ PRIMARY KEY (`requirement_id`),
+ KEY `NODE_REQUIREMENT_TO_NODE_CAPABILITY` (`capability_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `RELATED_NETWORK_ROLE`;
+CREATE TABLE `RELATED_NETWORK_ROLE` (
+ `network_model_customization_uuid` varchar(255) NOT NULL,
+ `related_network_role` varchar(255) NOT NULL,
+ PRIMARY KEY (`network_model_customization_uuid`,`related_network_role`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `RESOURCE_GROUP`;
+CREATE TABLE `RESOURCE_GROUP` (
+ `resource_uuid` varchar(255) NOT NULL,
+ `group_uuid` varchar(255) NOT NULL,
+ `group_customization_uuid` varchar(255) DEFAULT NULL,
+ `group_invariant_uuid` varchar(255) NOT NULL,
+ `group_name` varchar(255) DEFAULT NULL,
+ `version` varchar(255) DEFAULT NULL,
+ `group_type` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`resource_uuid`,`group_uuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `RESOURCE_POLICY`;
+CREATE TABLE `RESOURCE_POLICY` (
+ `resource_uuid` varchar(255) NOT NULL,
+ `policy_uuid` varchar(255) NOT NULL,
+ `policy_customization_uuid` varchar(255) DEFAULT NULL,
+ `policy_invariant_uuid` varchar(255) NOT NULL,
+ `policy_name` varchar(255) DEFAULT NULL,
+ `version` varchar(255) DEFAULT NULL,
+ `policy_type` varchar(255) DEFAULT NULL,
+ `property_type` varchar(255) DEFAULT NULL,
+ `property_source` varchar(255) DEFAULT NULL,
+ `property_name` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`resource_uuid`,`policy_uuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING`;
+CREATE TABLE `RESOURCE_POLICY_TO_TARGET_NODE_MAPPING` (
+ `policy_uuid` varchar(255) NOT NULL,
+ `parent_uuid` varchar(255) NOT NULL,
+ `target_node_uuid` varchar(255) NOT NULL,
+ `target_type` varchar(255) DEFAULT NULL,
+ `target_node_customization_uuid` varchar(255) DEFAULT NULL,
+ `policy_customization_uuid` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`policy_uuid`,`parent_uuid`,`target_node_uuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+
+DROP TABLE IF EXISTS `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING`;
+CREATE TABLE `SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING` (
+ `service_uuid` varchar(255) NOT NULL,
+ `complex_resource_uuid` varchar(255) NOT NULL,
+ `complex_resource_customization_uuid` varchar(255) NOT NULL,
+ PRIMARY KEY (`service_uuid`,`complex_resource_uuid`,`complex_resource_customization_uuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `VFC_RELATED_NETWORK_ROLE`;
+CREATE TABLE `VFC_RELATED_NETWORK_ROLE` (
+ `vfc_customization_uuid` varchar(255) NOT NULL,
+ `vm_type` varchar(255) NOT NULL,
+ `network_role` varchar(255) NOT NULL,
+ `related_network_role` varchar(255) NOT NULL,
+ PRIMARY KEY (`vfc_customization_uuid`,`vm_type`,`network_role`,`related_network_role`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `VNF_RELATED_NETWORK_ROLE`;
+CREATE TABLE `VNF_RELATED_NETWORK_ROLE` (
+ `vnf_customization_uuid` varchar(255) NOT NULL,
+ `network_role` varchar(255) NOT NULL,
+ `related_network_role` varchar(255) NOT NULL,
+ PRIMARY KEY (`vnf_customization_uuid`,`network_role`,`related_network_role`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
-- Dump completed on 2017-10-04 18:23:01