CREATE TABLE `banned_ips` ( `id` int(11) NOT NULL auto_increment, `g1` varchar(3) NOT NULL, `g2` varchar(3) NOT NULL, `g3` varchar(3) NOT NULL, `g4` varchar(3) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; CREATE TABLE `banned_referrers` ( `id` int(11) NOT NULL auto_increment, `host` varchar(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; CREATE TABLE tableone ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, ip VARCHAR(15) NOT NULL, vtime VARCHAR(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;