X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=installation%2Fsdnc%2Fsrc%2Fmain%2Fresources%2Fsdnctl.dump;h=72fdc857d7d9b4d995ff534a6a253d1b952664b6;hb=d11a3e9608178a9b2ccc8249a3263c571783f69d;hp=b5ea0229739d319e298c82bc05ef012659020582;hpb=b48b1b4f54676da8d80b76270023ca1fd3112cae;p=sdnc%2Foam.git

diff --git a/installation/sdnc/src/main/resources/sdnctl.dump b/installation/sdnc/src/main/resources/sdnctl.dump
index b5ea0229..72fdc857 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;