X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=installation%2Fsdnc%2Fsrc%2Fmain%2Fresources%2Fsdnctl.dump;h=fd13d372b08a5cdf33486fc95416317662ca163d;hb=refs%2Fheads%2Fmaster;hp=04a9ad73bd5547268a2c40009b0e2574e150acf5;hpb=9b7d5181a5a95de88b683f036c0071c9b8f2c881;p=sdnc%2Foam.git diff --git a/installation/sdnc/src/main/resources/sdnctl.dump b/installation/sdnc/src/main/resources/sdnctl.dump index 04a9ad73..fd13d372 100644 --- a/installation/sdnc/src/main/resources/sdnctl.dump +++ b/installation/sdnc/src/main/resources/sdnctl.dump @@ -495,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`), @@ -991,7 +991,7 @@ CREATE TABLE `GENERIC_RESOURCE_NAME` ( `name` varchar(255) NOT NULL, `prefix` varchar(255) NULL, `name_index` int(11) NULL, - `content_id` varchar(255) NULL, + `context_id` varchar(255) NULL, PRIMARY KEY (`type`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1554,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, @@ -1889,6 +1890,28 @@ CREATE TABLE `RANGE_RULE` ( ) 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, + `pinterface_list` 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` -- @@ -2419,6 +2442,26 @@ CREATE TABLE `TOPOLOGY_PARAMETER_TO_ENTRIES` ( ) 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` -- @@ -2568,6 +2611,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; @@ -2596,6 +2640,9 @@ CREATE TABLE `VF_MODEL` ( `nf_role` varchar(255) DEFAULT NULL, `vendor` varchar(255) DEFAULT NULL, `vendor_version` varchar(255) DEFAULT NULL, + `sdnc_model_name` varchar(255) DEFAULT NULL, + `sdnc_model_version` varchar(255) DEFAULT NULL, + `sdnc_artifact_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`customization_uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2616,6 +2663,8 @@ CREATE TABLE `VF_MODULE_MODEL` ( `vf_module_type` varchar(255) DEFAULT NULL, `availability_zone_count` int(11) DEFAULT NULL, `ecomp_generated_vm_assignments` char(1) DEFAULT NULL, + `vf_customization_uuid` varchar(255) DEFAULT NULL, + `vf_module_label` varchar(255) DEFAULT NULL, PRIMARY KEY (`customization_uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3319,4 +3368,121 @@ CREATE TABLE `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING` ( /*!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