[permission-manager] first part of UI, database table, sql queries and db methods

1 files changed, 27 insertions, 0 deletions

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`)
+");