CREATE TABLE  `mcpermstest`.`GroupInheritance` (
  `parent` int(11) NOT NULL,
  `child` int(11) NOT NULL,
  PRIMARY KEY (`parent`,`child`),
  KEY `parent` (`parent`),
  KEY `child` (`child`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `mcpermstest`.`GroupMembership` (
  `groupid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`groupid`,`userid`),
  KEY `groupid` (`groupid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `mcpermstest`.`GroupPermissions` (
  `groupid` int(11) NOT NULL,
  `world` varchar(64) NOT NULL,
  `permission` varchar(64) NOT NULL,
  `value` tinyint(1) NOT NULL,
  PRIMARY KEY (`groupid`,`world`,`permission`),
  KEY `groupid` (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `mcpermstest`.`Groups` (
  `groupid` int(11) NOT NULL AUTO_INCREMENT,
  `groupname` varchar(64) NOT NULL,
  `is_default` tinyint(1) NOT NULL,
  PRIMARY KEY (`groupid`),
  KEY `groupname` (`groupname`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1

CREATE TABLE  `mcpermstest`.`UserPermissions` (
  `userid` int(11) NOT NULL,
  `world` varchar(64) NOT NULL,
  `permission` varchar(64) NOT NULL,
  `value` tinyint(1) NOT NULL,
  PRIMARY KEY (`userid`,`world`,`permission`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `mcpermstest`.`Users` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL,
  PRIMARY KEY (`userid`),
  KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=883 DEFAULT CHARSET=latin1