 
 -- ---- create roles table:
 CREATE TABLE `roles` (
-	`roleId` int(11) unsigned NOT NULL AUTO_INCREMENT,
+	`roleId` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
 	`name` varchar(40) NOT NULL,
 	`parent` int(11) NOT NULL,
 	PRIMARY KEY (`roleId`),


-- ---- create privileges table:
CREATE TABLE `privileges` (
	`privilegeId` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`name` varchar(40) NOT NULL,
	PRIMARY KEY (`privilegeId`),
	UNIQUE KEY `name` (`name`)


-- ---- create resources table:
CREATE TABLE `resources` (
	`resourceId` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
	`name` varchar(40) NOT NULL,
	PRIMARY KEY (`resourceId`),
	UNIQUE KEY `name` (`name`)
