· 6 years ago · Mar 14, 2019, 07:00 AM
1CREATE TABLE IF NOT EXISTS `poll` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `question` varchar(150) DEFAULT NULL,
4 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
5 `date_start` datetime DEFAULT NULL,
6 `date_end` datetime DEFAULT NULL,
7 `status` tinyint(1) NOT NULL DEFAULT '0',
8 PRIMARY KEY (`id`),
9 KEY `question` (`question`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;