add user_permisions table

retore user informaction
for CDT GUI

Issue-ID: APPC-1833
Change-Id: Id54d9d1d25fe73066eaa6a964d819bb14e36a895
Signed-off-by: Taka Cho <takamune.cho@att.com>

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index 41e8ef8..77974f6 100644 (file)
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -430,6 +430,28 @@ 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 */;
+
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
 --
 -- Table structure for table `GET_CONFIG_TEMPLATE`
 --