Jack Phoenix has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/335738 )
Change subject: FU SQLite ...................................................................... FU SQLite Change-Id: I33ef40e540a0c88944b9cf45e3d9874d951573c5 --- M quizgame.sql 1 file changed, 4 insertions(+), 4 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/QuizGame refs/changes/38/335738/1 diff --git a/quizgame.sql b/quizgame.sql index 393991b..cb0d308 100644 --- a/quizgame.sql +++ b/quizgame.sql @@ -1,6 +1,6 @@ -- Tables for QuizGame extension CREATE TABLE /*_*/quizgame_questions ( - `q_id` int(11) unsigned NOT NULL auto_increment PRIMARY KEY, + `q_id` int(11) unsigned NOT NULL PRIMARY KEY auto_increment, `q_user_id` int(11) unsigned NOT NULL default '0', `q_user_name` varchar(255) NOT NULL default '', -- One of the QuizGameHome::$FLAG_* static variables @@ -23,7 +23,7 @@ CREATE INDEX /*i*/q_random ON /*_*/quizgame_questions (q_random); CREATE TABLE /*_*/quizgame_answers ( - `a_id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY, + `a_id` int(10) unsigned NOT NULL PRIMARY KEY auto_increment, `a_q_id` int(10) unsigned NOT NULL default '0', `a_choice_id` int(11) unsigned NOT NULL default '0', `a_user_id` int(11) unsigned NOT NULL default '0', @@ -38,7 +38,7 @@ CREATE INDEX /*i*/a_user_name ON /*_*/quizgame_answers (a_user_name); CREATE TABLE /*_*/quizgame_choice ( - `choice_id` int(11) NOT NULL auto_increment PRIMARY KEY, + `choice_id` int(11) NOT NULL PRIMARY KEY auto_increment, `choice_q_id` int(11) NOT NULL default '0', `choice_order` int(5) default '0', `choice_text` text NOT NULL, @@ -49,7 +49,7 @@ CREATE INDEX /*i*/choice_q_id ON /*_*/quizgame_choice (choice_q_id); CREATE TABLE /*_*/quizgame_user_view ( - `uv_id` int(11) unsigned NOT NULL auto_increment PRIMARY KEY, + `uv_id` int(11) unsigned NOT NULL PRIMARY KEY auto_increment, `uv_q_id` int(11) unsigned NOT NULL default '0', `uv_user_id` int(11) unsigned NOT NULL default '0', `uv_user_name` varchar(255) NOT NULL default '', -- To view, visit https://gerrit.wikimedia.org/r/335738 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I33ef40e540a0c88944b9cf45e3d9874d951573c5 Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/QuizGame Gerrit-Branch: master Gerrit-Owner: Jack Phoenix <j...@countervandalism.net> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
