· 6 years ago · Mar 14, 2019, 07:10 AM
1CREATE TABLE IF NOT EXISTS `poll_answer` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `poll_id` int(11) NOT NULL,
4 `answer` varchar(150) DEFAULT NULL,
5 PRIMARY KEY (`id`),
6 KEY `poll_id` (`poll_id`)
7) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
8
9
10CREATE TABLE IF NOT EXISTS `poll_votes` (
11 `id` int(11) NOT NULL AUTO_INCREMENT,
12 `answer_id` int(11) DEFAULT NULL,
13 `poll_id` int(11) DEFAULT NULL,
14 `account_id` int(11) NOT NULL,
15 PRIMARY KEY (`id`),
16 KEY `answer_id` (`answer_id`),
17 KEY `poll_id` (`poll_id`),
18 KEY `account_id` (`account_id`)
19) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;