Legoktm has submitted this change and it was merged. Change subject: sql: Fix SQLite compatibility ......................................................................
sql: Fix SQLite compatibility Apparently it needs to be in this order. I just copied it from <https://www.mediawiki.org/wiki/Manual:Database_access#SQLite_compatibility>. Change-Id: I948a2fcd546076ad186e7cde933a70795f591a58 --- M sql/comments.sql 1 file changed, 3 insertions(+), 3 deletions(-) Approvals: Legoktm: Verified; Looks good to me, approved diff --git a/sql/comments.sql b/sql/comments.sql index e9fbaef..543d6b3 100644 --- a/sql/comments.sql +++ b/sql/comments.sql @@ -1,6 +1,6 @@ -- MySQL/SQLite schema for the Comments extension CREATE TABLE /*_*/Comments ( - CommentID int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, + CommentID int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, Comment_Page_ID int(11) NOT NULL default 0, Comment_user_id int(11) NOT NULL default 0, Comment_Username varchar(200) NOT NULL default '', @@ -28,11 +28,11 @@ CREATE INDEX /*i*/Comment_Vote_user_id ON /*_*/Comments_Vote (Comment_Vote_user_id); CREATE TABLE /*_*/Comments_block ( - cb_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, + cb_id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, cb_user_id int(5) NOT NULL default 0, cb_user_name varchar(255) NOT NULL default '', cb_user_id_blocked int(5) default NULL, cb_user_name_blocked varchar(255) NOT NULL default '', cb_date datetime default NULL ) /*$wgDBTableOptions*/; -CREATE INDEX /*i*/cb_user_id ON /*_*/Comments_block (cb_user_id); \ No newline at end of file +CREATE INDEX /*i*/cb_user_id ON /*_*/Comments_block (cb_user_id); -- To view, visit https://gerrit.wikimedia.org/r/305547 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I948a2fcd546076ad186e7cde933a70795f591a58 Gerrit-PatchSet: 2 Gerrit-Project: mediawiki/extensions/Comments Gerrit-Branch: master Gerrit-Owner: Legoktm <legoktm.wikipe...@gmail.com> Gerrit-Reviewer: Legoktm <legoktm.wikipe...@gmail.com> Gerrit-Reviewer: Springle <sprin...@wikimedia.org> Gerrit-Reviewer: UltrasonicNXT <adamr_car...@btinternet.com> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits