add user_permisions table

[appc/deployment.git] / installation / appc / src / main / resources / sdnctl.dump

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index 1a36a07..77974f6 100644 (file)
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -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,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`
 --
@@ -487,43 +509,43 @@ CREATE TABLE `NODE_TYPES` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Table structure for table `OPS_AIC_HOSTS`
+-- Table structure for table `OPS_AIC_REGIONS`
 --
 
-DROP TABLE IF EXISTS `OPS_AIC_HOSTS`;
+DROP TABLE IF EXISTS `OPS_AIC_REGIONS`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `OPS_AIC_HOSTS` (
+CREATE TABLE `OPS_AIC_REGIONS` (
   `REGION_ID` varchar(16) NOT NULL,
-  `HOST` varchar(64) NOT NULL,
-  `HOST_IP` varchar(64) DEFAULT NULL,
-  `EQUIPMENT_VENDOR` varchar(32) DEFAULT NULL,
-  `EQUIPMENT_PRODUCT` varchar(32) DEFAULT NULL,
-  `EQUIPMENT_MODEL` varchar(32) DEFAULT NULL,
-  `EQUIPMENT_VERSION` varchar(32) DEFAULT NULL,
+  `IDENTITY_URL` varchar(256) NOT NULL,
+  `HOST_DISCOVERY` varchar(3) NOT NULL DEFAULT 'NO',
+  `ADMIN_TENANT_ID` varchar(64) DEFAULT NULL,
+  `ADMIN_TENANT_NAME` varchar(64) DEFAULT 'admin',
   `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
-  PRIMARY KEY (`REGION_ID`,`HOST`),
-  CONSTRAINT `fk_aic_hosts` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
+  PRIMARY KEY (`REGION_ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Table structure for table `OPS_AIC_REGIONS`
+-- Table structure for table `OPS_AIC_HOSTS`
 --
 
-DROP TABLE IF EXISTS `OPS_AIC_REGIONS`;
+DROP TABLE IF EXISTS `OPS_AIC_HOSTS`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `OPS_AIC_REGIONS` (
+CREATE TABLE `OPS_AIC_HOSTS` (
   `REGION_ID` varchar(16) NOT NULL,
-  `IDENTITY_URL` varchar(256) NOT NULL,
-  `HOST_DISCOVERY` varchar(3) NOT NULL DEFAULT 'NO',
-  `ADMIN_TENANT_ID` varchar(64) DEFAULT NULL,
-  `ADMIN_TENANT_NAME` varchar(64) DEFAULT 'admin',
+  `HOST` varchar(64) NOT NULL,
+  `HOST_IP` varchar(64) DEFAULT NULL,
+  `EQUIPMENT_VENDOR` varchar(32) DEFAULT NULL,
+  `EQUIPMENT_PRODUCT` varchar(32) DEFAULT NULL,
+  `EQUIPMENT_MODEL` varchar(32) DEFAULT NULL,
+  `EQUIPMENT_VERSION` varchar(32) DEFAULT NULL,
   `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
-  PRIMARY KEY (`REGION_ID`)
+  PRIMARY KEY (`REGION_ID`,`HOST`),
+  CONSTRAINT `fk_aic_hosts` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -1258,7 +1280,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 */;
 
@@ -1420,14 +1443,5 @@ USE `sdnctl`;
 /*!50001 SET character_set_client      = @saved_cs_client */;
 /*!50001 SET character_set_results     = @saved_cs_results */;
 /*!50001 SET collation_connection      = @saved_col_connection */;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;