Td6WFNyf

1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3CREATE DATABASE `website` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
4
5USE `website`;
6
7CREATE TABLE IF NOT EXISTS `items` (
8 `id` int(11) NOT NULL AUTO_INCREMENT,
9 `username` varchar(12) NOT NULL,
10 `item_id` int(11) NOT NULL,
11 `item_amount` int(11) NOT NULL DEFAULT '1',
12 `claimed` int(11) NOT NULL DEFAULT '0',
13 PRIMARY KEY (`id`)
14) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
15
16CREATE TABLE IF NOT EXISTS `verifying_votes` (
17 `callbackid` varchar(10) NOT NULL,
18 KEY `callbackid` (`callbackid`)
19) ENGINE=MyISAM DEFAULT CHARSET=latin1;
20
21CREATE TABLE IF NOT EXISTS `votes` (
22 `id` int(8) NOT NULL AUTO_INCREMENT,
23 `ip` varchar(45) NOT NULL,
24 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
25 PRIMARY KEY (`id`)
26) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;