X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=installation%2Fsdnc%2Fsrc%2Fmain%2Fresources%2Fsdnctl.dump;h=47766661e80608cf80f5f699ec4a242f58f87680;hb=f2e8a35e6f02e29941b1d6acb40b9772a66cda9d;hp=4f9dc4131a75cd5eab409c7f038a0fd59a3a7d5c;hpb=19b73ba71467fa7ec2d8436d33cfe7ddf32fcd8b;p=sdnc%2Foam.git diff --git a/installation/sdnc/src/main/resources/sdnctl.dump b/installation/sdnc/src/main/resources/sdnctl.dump index 4f9dc413..47766661 100644 --- a/installation/sdnc/src/main/resources/sdnctl.dump +++ b/installation/sdnc/src/main/resources/sdnctl.dump @@ -92,7 +92,7 @@ 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` 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, @@ -111,7 +111,6 @@ DROP TABLE IF EXISTS `AIC_HOSTNAME`; 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, @@ -496,9 +495,9 @@ DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`; /*!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`), @@ -990,6 +989,9 @@ DROP TABLE IF EXISTS `GENERIC_RESOURCE_NAME`; 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 */; @@ -1552,6 +1554,7 @@ CREATE TABLE `NETWORK_MODEL` ( `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, @@ -1770,13 +1773,10 @@ DROP TABLE IF EXISTS `PORTAL_USERS`; /*!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 */; @@ -1816,7 +1816,6 @@ CREATE TABLE `PRE_LOAD_VNF_DATA` ( `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`) @@ -1836,7 +1835,6 @@ CREATE TABLE `PRE_LOAD_VNF_NETWORK_DATA` ( `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`) @@ -1861,7 +1859,7 @@ CREATE TABLE `PSERVER` ( `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 '', @@ -2571,6 +2569,7 @@ CREATE TABLE `VFC_TO_NETWORK_ROLE_MAPPING` ( `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; @@ -3292,6 +3291,24 @@ CREATE TABLE `WAN_COMBO_ALLOWABLE` ( ) 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 */; @@ -3304,4 +3321,121 @@ CREATE TABLE `WAN_COMBO_ALLOWABLE` ( /*!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