Code:
CREATE TABLE IF NOT EXISTS `infractionban` (
`infractionbanid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` int(11) NOT NULL DEFAULT '0',
`banusergroupid` int(10) unsigned NOT NULL DEFAULT '0',
`amount` int(10) unsigned NOT NULL DEFAULT '0',
`period` char(5) NOT NULL DEFAULT '',
`method` enum('points','infractions') NOT NULL DEFAULT 'infractions',
PRIMARY KEY (`infractionbanid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `userban` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`usertitle` varchar(250) NOT NULL DEFAULT '',
`customtitle` smallint(6) NOT NULL DEFAULT '0',
`adminid` int(10) unsigned NOT NULL DEFAULT '0',
`bandate` int(10) unsigned NOT NULL DEFAULT '0',
`liftdate` int(10) unsigned NOT NULL DEFAULT '0',
`reason` varchar(250) NOT NULL DEFAULT '',
PRIMARY KEY (`userid`),
KEY `liftdate` (`liftdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;