· 8 years ago · Jun 11, 2018, 08:46 AM
1CREATE TABLE IF NOT EXISTS `tempvotes` (
2 `id` int(5) NOT NULL,
3 `time` int(9) NOT NULL,
4 `ipaddress` varchar(15) NOT NULL,
5 `voted` int(1) NOT NULL DEFAULT '0'
6) ENGINE=MyISAM DEFAULT CHARSET=latin1;
7
8CREATE TABLE IF NOT EXISTS `votes` (
9 `id` int(11) NOT NULL AUTO_INCREMENT,
10 `time` int(9) NOT NULL,
11 `ipaddress` varchar(15) NOT NULL,
12 `authcode` varchar(6) NOT NULL,
13 `used` int(1) NOT NULL DEFAULT '0',
14 `username` varchar(14) NOT NULL,
15 `guid` varchar(45) NOT NULL,
16 PRIMARY KEY (`id`)
17) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2748 ;