From 6824eb6371ed1a5d245acf43d4a6c935fe5b010e Mon Sep 17 00:00:00 2001 From: Taka Cho Date: Tue, 11 Feb 2020 14:45:04 -0500 Subject: [PATCH] add user_permisions table retore user informaction for CDT GUI Issue-ID: APPC-1833 Change-Id: Id54d9d1d25fe73066eaa6a964d819bb14e36a895 Signed-off-by: Taka Cho --- installation/appc/src/main/resources/sdnctl.dump | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump index 41e8ef8..77974f6 100644 --- 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` -- -- 2.16.6