CREATE TABLE IF NOT EXISTS `bans` (
`id` int(10) unsigned NOT NULL auto_increment,
`type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
`value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
`param` int(10) unsigned NOT NULL default '4294967295' COMMENT 'used only for ip banishment mask (integer)',
`active` tinyint(1) NOT NULL default '1',
`expires` int(11) NOT NULL,
`added` int(10) unsigned NOT NULL,
`admin_id` int(10) unsigned NOT NULL default '0',
`comment` text NOT NULL,
`reason` int(10) unsigned NOT NULL default '0',
`action` int(10) unsigned NOT NULL default '0',
`statement` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `type` (`type`,`value`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;