x34csuVC

1CREATE TABLE IF NOT EXISTS `items` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(12) NOT NULL,
4 `item_id` int(11) NOT NULL,
5 `item_amount` int(11) NOT NULL DEFAULT '1',
6 `claimed` int(11) NOT NULL DEFAULT '0',
7 PRIMARY KEY (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
9
10CREATE TABLE IF NOT EXISTS `verifying_votes` (
11 `callbackid` varchar(10) NOT NULL,
12 KEY `callbackid` (`callbackid`)
13) ENGINE=MyISAM DEFAULT CHARSET=latin1;
14
15CREATE TABLE IF NOT EXISTS `votes` (
16 `id` int(8) NOT NULL AUTO_INCREMENT,
17 `ip` varchar(45) NOT NULL,
18 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
19 PRIMARY KEY (`id`)
20) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;