path: root/modules-available/permissionmanager/install.inc.php

<?php

$res = array();

$res[] = tableCreate('role', "
	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	`name` varchar(200) NOT NULL,
	`locType` varchar(200) NOT NULL DEFAULT 'include',
	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` varchar(200) NOT NULL,
	PRIMARY KEY (`roleid`, `permissionid`)
");