rzaarat0

1CREATE TABLE IF NOT EXISTS `permissions_inheritance` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `child` varchar(50) NOT NULL,
4  `parent` varchar(50) NOT NULL,
5  `type` tinyint(1) NOT NULL,
6  `world` varchar(50) DEFAULT NULL,
7  PRIMARY KEY (`id`),
8  UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
9  KEY `child_2` (`child`,`type`),
10  KEY `parent` (`parent`,`type`)
11) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=481 ;
12
13CREATE TABLE IF NOT EXISTS `permissions_entity` (
14  `id` int(11) NOT NULL AUTO_INCREMENT,
15  `name` varchar(50) NOT NULL,
16  `type` tinyint(1) NOT NULL,
17  `prefix` varchar(255) NOT NULL,
18  `suffix` varchar(255) NOT NULL,
19  `default` tinyint(1) NOT NULL DEFAULT '0',
20  PRIMARY KEY (`id`),
21  UNIQUE KEY `name` (`name`),
22  KEY `default` (`default`)
23) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=428 ;
24
25CREATE TABLE IF NOT EXISTS `permissions` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `name` varchar(50) NOT NULL,
28  `type` tinyint(1) NOT NULL,
29  `permission` varchar(200) NOT NULL,
30  `world` varchar(50) NOT NULL,
31  `value` mediumtext NOT NULL,
32  PRIMARY KEY (`id`),
33  UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
34  KEY `user` (`name`,`type`),
35  KEY `world` (`world`,`name`,`type`)
36) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2794 ;