s62J6AzT

1CREATE TABLE IF NOT EXISTS `comments` (
2    `id` int(11) NOT NULL AUTO_INCREMENT,
3    `timestamp` varchar(255) NOT NULL,
4    `factId` int(11) NOT NULL,
5    `comment` text NOT NULL,
6    `name` text NOT NULL,
7    `ip` varchar(255) NOT NULL,
8    `rating` int(11) NOT NULL,
9    PRIMARY KEY (`id`),
10    KEY `id` (`id`)
11) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
12
13CREATE TABLE IF NOT EXISTS `facts` (
14    `id` int(11) NOT NULL AUTO_INCREMENT,
15    `name` text NOT NULL,
16    `timestamp` int(11) NOT NULL,
17    `ip` varchar(255) NOT NULL,
18    `fact` text NOT NULL,
19    `active` tinyint(1) NOT NULL,
20    `popularity` int(11) NOT NULL,
21    `plus` int(11) NOT NULL,
22    `minus` int(11) NOT NULL,
23    `tags` varchar(255) NOT NULL,
24    PRIMARY KEY (`id`)
25) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
26
27CREATE TABLE IF NOT EXISTS `votes` (
28    `id` int(11) NOT NULL AUTO_INCREMENT,
29    `fact_id` int(11) NOT NULL,
30    `ip` varchar(255) NOT NULL,
31    `type` tinyint(4) NOT NULL,
32    PRIMARY KEY (`id`)
33) ENGINE=InnoDB  DEFAULT CHARSET=latin1;