projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Moves skills edition to mentor edition page.
[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
6528dca
..
2e0927c
100644
(file)
--- a/
upgrade/0.9.14/07_survey.sql
+++ b/
upgrade/0.9.14/07_survey.sql
@@
-4,7
+4,7
@@
CREATE TABLE `survey_answers` (
`question_id` smallint(3) unsigned NOT NULL,
`answer` text NOT NULL,
PRIMARY KEY (`id`),
`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;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@
-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,
`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;
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@
-27,6
+26,10
@@
CREATE TABLE `survey_votes` (
`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`),
+ KEY `voter` (`survey_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) 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:
# vim: set syntax=mysql: