e3fewW3g

1
2CREATE TABLE IF NOT EXISTS `poll` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `question` varchar(150) DEFAULT NULL,
5  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
6  `date_start` datetime DEFAULT NULL,
7  `date_end` datetime DEFAULT NULL,
8  `status` tinyint(1) NOT NULL DEFAULT '0',
9  PRIMARY KEY (`id`),
10  KEY `question` (`question`)
11) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
12
13
14-- --------------------------------------------------------
15
16
17CREATE TABLE IF NOT EXISTS `poll_answer` (
18  `id` int(11) NOT NULL AUTO_INCREMENT,
19  `poll_id` int(11) NOT NULL,
20  `answer` varchar(150) DEFAULT NULL,
21  PRIMARY KEY (`id`),
22  KEY `poll_id` (`poll_id`)
23) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
24
25
26-- ------------------------------------------------------
27
28
29CREATE TABLE IF NOT EXISTS `poll_votes` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `answer_id` int(11) DEFAULT NULL,
32  `poll_id` int(11) DEFAULT NULL,
33  `account_id` int(11) NOT NULL,
34  PRIMARY KEY (`id`),
35  KEY `poll_id` (`poll_id`),
36  KEY `account_id` (`account_id`),
37  KEY `answer_id` (`answer_id`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;