p13CMeAh

1
2CREATE TABLE IF NOT EXISTS `Horoscope` (
3  `userid` bigint(20) unsigned NOT NULL,
4  `sign` varchar(12) NOT NULL,
5  `skin` varchar(12) NOT NULL,
6  `birthdate` date NOT NULL DEFAULT '0000-00-00',
7  `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
8  `name` varchar(25) NOT NULL DEFAULT '',
9  `phone` bigint(20) unsigned NOT NULL DEFAULT '0',
10  PRIMARY KEY (`userid`),
11  KEY `skin` (`skin`),
12  KEY `birthdate` (`birthdate`),
13  KEY `createddate` (`createddate`)
14) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15
16
17
18CREATE TABLE IF NOT EXISTS `HoroscopeVote` (
19  `userid` bigint(20) unsigned NOT NULL,
20  `sign` tinyint(3) unsigned NOT NULL,
21  `score` tinyint(4) NOT NULL,
22  `lastvotetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
23  PRIMARY KEY (`userid`,`sign`),
24  KEY `userid-lastvotetime` (`userid`,`lastvotetime`)
25) ENGINE=InnoDB DEFAULT CHARSET=latin1;