`question_id` smallint(3) unsigned NOT NULL,
`answer` text NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `vote` (`vote_id`,`question_id`)
+ KEY `vote` (`vote_id`,`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
`end` date NOT NULL default '0000-00-00',
`mode` tinyint(2) unsigned NOT NULL default '0',
`promos` varchar(255) NOT NULL,
- `valid` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
`survey_id` smallint(4) unsigned NOT NULL,
`user_id` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
+ KEY `voter` (`survey_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE `requests_answers` MODIFY `category` enum('alias','liste','usage','photo','evts','marketing','orange','homonyme','nl','paiements','medal','broken','surveys') NOT NULL default 'alias';
+
# vim: set syntax=mysql: