· 8 years ago · Jul 03, 2018, 10:56 AM
1DROP TABLE IF EXISTS `voting`;
2CREATE TABLE `voting` (
3 `user_ip` varchar(30) NOT NULL,
4 `sites` int(10) unsigned NOT NULL default '0',
5 `time` int(10) unsigned NOT NULL default '0',
6 PRIMARY KEY (`user_ip`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8
9DROP TABLE IF EXISTS `voting_points`;
10CREATE TABLE `voting_points` (
11 `id` bigint(20) unsigned NOT NULL,
12 `points` smallint(5) unsigned NOT NULL default '0',
13 `date` varchar(8) NOT NULL default '20081214',
14 `date_points` tinyint(2) unsigned NOT NULL default '0',
15 PRIMARY KEY (`id`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8;