jenkins-bot has submitted this change and it was merged. Change subject: Fix SQLite compatibility ......................................................................
Fix SQLite compatibility bug 46433 Change-Id: Ic3c4e447330f78ad6681cf2a30ada8eefa3ce5e2 --- M sql/Survey.sql 1 file changed, 4 insertions(+), 4 deletions(-) Approvals: Hashar: Looks good to me, approved jenkins-bot: Verified diff --git a/sql/Survey.sql b/sql/Survey.sql index b047617..a281556 100644 --- a/sql/Survey.sql +++ b/sql/Survey.sql @@ -4,7 +4,7 @@ -- Surveys CREATE TABLE IF NOT EXISTS /*_*/surveys ( - survey_id SMALLINT unsigned NOT NULL auto_increment PRIMARY KEY, + survey_id SMALLINT unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, survey_name VARCHAR(255) NOT NULL, -- String indentifier for the survey survey_title VARCHAR(255) NOT NULL, -- Title of the survey survey_enabled TINYINT NOT NULL default '0', -- If the survey can be taken by users @@ -28,7 +28,7 @@ -- Questions CREATE TABLE IF NOT EXISTS /*_*/survey_questions ( - question_id INT(10) unsigned NOT NULL auto_increment PRIMARY KEY, + question_id INT(10) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, question_survey_id SMALLINT unsigned NOT NULL, -- Foreign key: surveys.survey_id question_text TEXT NOT NULL, question_type INT(2) unsigned NOT NULL, @@ -44,7 +44,7 @@ -- Submissions CREATE TABLE IF NOT EXISTS /*_*/survey_submissions ( - submission_id INT(10) unsigned NOT NULL auto_increment PRIMARY KEY, + submission_id INT(10) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, submission_survey_id SMALLINT unsigned NOT NULL, -- Foreign key: surveys.survey_id submission_user_name VARCHAR(255) NOT NULL, -- The person that made the submission (account name or ip) submission_page_id INT(10) unsigned NULL, -- The id of the page the submission was made on @@ -58,7 +58,7 @@ -- Answers CREATE TABLE IF NOT EXISTS /*_*/survey_answers ( - answer_id SMALLINT unsigned NOT NULL auto_increment PRIMARY KEY, + answer_id SMALLINT unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, answer_submission_id INT(10) unsigned NOT NULL, -- Foreign key: survey_submissions.submission_id answer_question_id INT(10) unsigned NOT NULL, -- Foreign key: survey_questions.question_id answer_text BLOB NOT NULL -- To view, visit https://gerrit.wikimedia.org/r/55452 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ic3c4e447330f78ad6681cf2a30ada8eefa3ce5e2 Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/Survey Gerrit-Branch: master Gerrit-Owner: Jeroen De Dauw <[email protected]> Gerrit-Reviewer: Demon <[email protected]> Gerrit-Reviewer: Hashar <[email protected]> Gerrit-Reviewer: jenkins-bot _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
