X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;ds=sidebyside;f=installation%2Fappc%2Fsrc%2Fmain%2Fresources%2Fsdnctl.dump;h=547859ca43ec1988faaa2c99c211dfba1f43f766;hb=refs%2Fheads%2Fmaster;hp=5a4a04448a3b3f0134210d984ad5c16a4e1282a7;hpb=1140632654bc928a2065ef76658b3ff74b9ec91a;p=appc%2Fdeployment.git

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index 5a4a044..547859c 100644
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -133,7 +133,7 @@ DROP TABLE IF EXISTS `CONFIGFILES`;
 CREATE TABLE `CONFIGFILES` (
   `CONFIG_FILE_ID` int(11) NOT NULL AUTO_INCREMENT,
   `EXTERNAL_VERSION` varchar(50) DEFAULT NULL,
-  `DATA_SOURCE` varchar(25) DEFAULT NULL,
+  `DATA_SOURCE` varchar(50) DEFAULT NULL,
   `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
   `VNF_TYPE` varchar(150) DEFAULT NULL,
@@ -224,7 +224,7 @@ CREATE TABLE `DEVICE_AUTHENTICATION` (
   `USER_NAME` varchar(255) DEFAULT NULL,
   `PASSWORD` varchar(255) DEFAULT NULL,
   `PORT_NUMBER` int(11) DEFAULT NULL,
-  `URL` varchar(1024) DEFAULT NULL,
+  `URL` varchar(256) DEFAULT NULL,
   PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
   UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`,`URL`),
   KEY `PROTOCOL` (`PROTOCOL`),
@@ -430,6 +430,25 @@ CREATE TABLE `DT_STATUS_RELATIONSHIP` (
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `DT_USER_PERMISSIONS`
+--
+
+DROP TABLE IF EXISTS `DT_USER_PERMISSIONS`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE sdnctl.`DT_USER_PERMISSIONS` (
+   `DT_USER_PERMISSION_ID` int(11) NOT NULL AUTO_INCREMENT,
+   `VNF_TYPE` varchar(255) NOT NULL,
+   `USER_ID` varchar(255) DEFAULT NULL,
+   `PERMISSION` varchar(255) DEFAULT NULL,
+   `DATE_MODIFIED` datetime(3) DEFAULT NULL,
+   `MODIFIER` varchar(255) DEFAULT NULL,
+    PRIMARY KEY (`DT_USER_PERMISSION_ID`),
+    UNIQUE KEY `VNF_USER_UNIQ` (`VNF_TYPE`,`USER_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
 --
 -- Table structure for table `GET_CONFIG_TEMPLATE`
 --
@@ -1258,7 +1277,8 @@ CREATE TABLE `UPLOAD_CONFIG` (
   `PENDING_DELETE` varchar(1) DEFAULT NULL,
   `CONTENT` longtext,
   PRIMARY KEY (`UPLOAD_CONFIG_ID`),
-  UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
+  UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`),
+  KEY `VNF_ID` (`VNF_ID`)
 ) ENGINE=InnoDB AUTO_INCREMENT=1656 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;