CREATE TABLE `survey_answers` (
`id` smallint(5) unsigned NOT NULL auto_increment,
CREATE TABLE `survey_answers` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`vote_id` smallint(5) unsigned NOT NULL,
`question_id` smallint(3) unsigned NOT NULL,
`answer` text NOT NULL,
PRIMARY KEY (`id`),
`vote_id` smallint(5) unsigned NOT NULL,
`question_id` smallint(3) unsigned NOT NULL,
`answer` text NOT NULL,
PRIMARY KEY (`id`),
-CREATE TABLE `survey_questions` (
- `survey_id` smallint(4) unsigned NOT NULL auto_increment,
+CREATE TABLE `survey_surveys` (
+ `id` smallint(4) unsigned NOT NULL auto_increment,
`questions` mediumtext NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`author_id` smallint(5) unsigned NOT NULL,
`end` date NOT NULL default '0000-00-00',
`questions` mediumtext NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`author_id` smallint(5) unsigned NOT NULL,
`end` date NOT NULL default '0000-00-00',
`survey_id` smallint(4) unsigned NOT NULL,
`user_id` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
`survey_id` smallint(4) unsigned NOT NULL,
`user_id` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
+
+ALTER TABLE `requests_answers` MODIFY `category` enum('alias','liste','usage','photo','evts','marketing','orange','homonyme','nl','paiements','medal','broken','surveys') NOT NULL default 'alias';
+