From 7807e30a69ab39b3f2a7f20d2608ba6b46b456e8 Mon Sep 17 00:00:00 2001
From: Christian Hofmaier
Date: Tue, 28 Mar 2017 11:23:24 +0200
Subject: [permission-manager] first part of UI, database table, sql queries
 and db methods

---
 .../permissionmanager/install.inc.php              | 27 ++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 modules-available/permissionmanager/install.inc.php

(limited to 'modules-available/permissionmanager/install.inc.php')

diff --git a/modules-available/permissionmanager/install.inc.php b/modules-available/permissionmanager/install.inc.php
new file mode 100644
index 00000000..a873f2c0
--- /dev/null
+++ b/modules-available/permissionmanager/install.inc.php
@@ -0,0 +1,27 @@
+<?php
+
+$res = array();
+
+$res[] = tableCreate('role', "
+	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+	`name` varchar(200) NOT NULL,
+	PRIMARY KEY (`id`)
+");
+
+$res[] = tableCreate('userXrole', "
+	`userid` int(10) unsigned NOT NULL,
+	`roleid` int(10) unsigned NOT NULL,
+	PRIMARY KEY (`userid`, `roleid`)
+");
+
+$res[] = tableCreate('roleXlocation', "
+	`roleid` int(10) unsigned NOT NULL,
+	`locid` int(10) unsigned NOT NULL,
+	PRIMARY KEY (`roleid`, `locid`)
+");
+
+$res[] = tableCreate('roleXpermission', "
+	`roleid` int(10) unsigned NOT NULL,
+	`permissionid`int(10) unsigned NOT NULL,
+	PRIMARY KEY (`roleid`, `permissionid`)
+");
-- 
cgit v1.2.3-55-g7522