C9umBErs

1CREATE TABLE IF NOT EXISTS `permissions` (
2  `name` varchar(255) NOT NULL,
3  `type` tinyint(1) NOT NULL,
4  `permission` varchar(255) NOT NULL,
5  `world` varchar(255) NOT NULL,
6  `value` varchar(255) NOT NULL,
7  UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
8  KEY `user` (`name`,`type`),
9  KEY `world` (`world`,`name`,`type`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1;
11
12CREATE TABLE IF NOT EXISTS `permissions_entity` (
13  `name` varchar(255) NOT NULL,
14  `type` tinyint(1) NOT NULL,
15  `prefix` varchar(255) NOT NULL,
16  `suffix` varchar(255) NOT NULL,
17  `default` tinyint(1) NOT NULL,
18  PRIMARY KEY (`name`),
19  KEY `default` (`default`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1;
21
22INSERT INTO `permissions_entity` (`name`, `type`, `prefix`, `suffix`, `default`) VALUES
23('default', 0, '', '', 1);
24
25CREATE TABLE IF NOT EXISTS `permissions_inheritance` (
26  `child` varchar(255) NOT NULL,
27  `parent` varchar(255) NOT NULL,
28  `type` tinyint(1) NOT NULL COMMENT '0 for group-group, 1 for user-group',
29  UNIQUE KEY `child` (`child`,`parent`,`type`),
30  KEY `child_2` (`child`,`type`),
31  KEY `parent` (`parent`,`type`)
32) ENGINE=MyISAM DEFAULT CHARSET=latin1;