· 8 years ago · Jun 11, 2018, 05:10 AM
1structure for table `tempvotes`
2--
3
4CREATE TABLE IF NOT EXISTS `tempvotes` (
5 `id` int(5) NOT NULL,
6 `time` int(9) NOT NULL,
7 `ipaddress` varchar(15) NOT NULL,
8 `voted` int(1) NOT NULL DEFAULT '0'
9) ENGINE=MyISAM DEFAULT CHARSET=latin1;
10
11-- --------------------------------------------------------
12
13--
14-- Table structure for table `votes`
15--
16
17CREATE TABLE IF NOT EXISTS `votes` (
18 `id` int(11) NOT NULL AUTO_INCREMENT,
19 `time` int(9) NOT NULL,
20 `ipaddress` varchar(15) NOT NULL,
21 `authcode` varchar(6) NOT NULL,
22 `used` int(1) NOT NULL DEFAULT '0',
23 `username` varchar(14) NOT NULL,
24 `guid` varchar(45) NOT NULL,
25 PRIMARY KEY (`id`)
26) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
27
28/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
29/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
30/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;