From: Taka Cho Date: Tue, 11 Feb 2020 19:45:04 +0000 (-0500) Subject: add user_permisions table X-Git-Tag: 1.7.1~9 X-Git-Url: https://gerrit.onap.org/r/gitweb?p=appc%2Fdeployment.git;a=commitdiff_plain;h=6824eb6371ed1a5d245acf43d4a6c935fe5b010e add user_permisions table retore user informaction for CDT GUI Issue-ID: APPC-1833 Change-Id: Id54d9d1d25fe73066eaa6a964d819bb14e36a895 Signed-off-by: Taka Cho --- 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` --