1af8f55d |
1 | CREATE TABLE `survey_answers` ( |
2 | `id` smallint(5) unsigned NOT NULL auto_increment, |
1af8f55d |
3 | `vote_id` smallint(5) unsigned NOT NULL, |
4 | `question_id` smallint(3) unsigned NOT NULL, |
5 | `answer` text NOT NULL, |
6 | PRIMARY KEY (`id`), |
9f01f40b |
7 | KEY `vote` (`vote_id`,`question_id`) |
1af8f55d |
8 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
9 | |
10 | |
9fb47284 |
11 | CREATE TABLE `survey_surveys` ( |
12 | `id` smallint(4) unsigned NOT NULL auto_increment, |
1af8f55d |
13 | `questions` mediumtext NOT NULL, |
14 | `title` varchar(255) NOT NULL, |
15 | `description` text NOT NULL, |
16 | `author_id` smallint(5) unsigned NOT NULL, |
17 | `end` date NOT NULL default '0000-00-00', |
9fb47284 |
18 | `mode` tinyint(2) unsigned NOT NULL default '0', |
1af8f55d |
19 | `promos` varchar(255) NOT NULL, |
9fb47284 |
20 | PRIMARY KEY (`id`) |
1af8f55d |
21 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
22 | |
23 | |
24 | CREATE TABLE `survey_votes` ( |
9fb47284 |
25 | `id` smallint(5) unsigned NOT NULL auto_increment, |
1af8f55d |
26 | `survey_id` smallint(4) unsigned NOT NULL, |
27 | `user_id` smallint(5) unsigned NOT NULL, |
28 | PRIMARY KEY (`id`), |
9f01f40b |
29 | KEY `voter` (`survey_id`,`user_id`) |
1af8f55d |
30 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
31 | |
797d27db |
32 | |
33 | ALTER TABLE `requests_answers` MODIFY `category` enum('alias','liste','usage','photo','evts','marketing','orange','homonyme','nl','paiements','medal','broken','surveys') NOT NULL default 'alias'; |
34 | |
1af8f55d |
35 | # vim: set syntax=mysql: |