diff options
| author |   Taka Cho <takamune.cho@att.com> | 2020-02-11 14:45:04 -0500 |
|---|---|---|
| committer | Taka Cho <takamune.cho@att.com> | 2020-02-11 14:45:46 -0500 |
| commit | 6824eb6371ed1a5d245acf43d4a6c935fe5b010e (patch) | |
| tree | f675d19d1ef5fb22bb59a153e30316bda9905b90 | |
| parent | 9d72f25a464d5be9fa4ecc072dbad85edfeb5895 (diff) | |
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>
| -rw-r--r-- | installation/appc/src/main/resources/sdnctl.dump | 22 |
1 files changed, 22 insertions, 0 deletions
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 @@ -431,6 +431,28 @@ CREATE TABLE `DT_STATUS_RELATIONSHIP` ( /*!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` -- |