CREATE TABLE IF NOT EXISTS `permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`type` tinyint(1) NOT NULL,
`permission` varchar(200) NOT NULL,
`world` varchar(50) DEFAULT NULL,
`value` text,
PRIMARY KEY (`id`),
UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
KEY `user` (`name`,`type`),
KEY `world` (`world`,`name`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
CREATE TABLE IF NOT EXISTS `permissions_entity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`type` tinyint(1) NOT NULL,
`prefix` varchar(255) NOT NULL,
`suffix` varchar(255) NOT NULL,
`default` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `default` (`default`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
CREATE TABLE IF NOT EXISTS `permissions_inheritance` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`child` varchar(50) NOT NULL,
`parent` varchar(50) NOT NULL,
`type` tinyint(1) NOT NULL,
`world` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
KEY `child_2` (`child`,`type`),
KEY `parent` (`parent`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;