Remove double "account/types" link from admin index

[platal.git] / upgrade / 0.9.14 / 07_survey.sql

diff --git a/upgrade/0.9.14/07_survey.sql b/upgrade/0.9.14/07_survey.sql
index b118916..2e0927c 100644 (file)
--- a/upgrade/0.9.14/07_survey.sql
+++ b/upgrade/0.9.14/07_survey.sql
@@ -17,7 +17,6 @@ CREATE TABLE `survey_surveys` (
   `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;
 
@@ -30,4 +29,7 @@ CREATE TABLE `survey_votes` (
   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: