[MediaWiki-commits] [Gerrit] mediawiki...Comments[master]: sql: Fix SQLite compatibility

[Legoktm (Code Review)]

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
.

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 
Gerrit-Reviewer: Legoktm 
Gerrit-Reviewer: Springle 
Gerrit-Reviewer: UltrasonicNXT 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] mediawiki...Comments[master]: sql: Fix SQLite compatibility

[Legoktm (Code Review)]

Legoktm has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/305547

Change subject: sql: Fix SQLite compatibility
..

sql: Fix SQLite compatibility

Apparently it needs to be in this order. I just copied it from
.

Change-Id: I948a2fcd546076ad186e7cde933a70795f591a58
---
M sql/comments.sql
1 file changed, 3 insertions(+), 3 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Comments 
refs/changes/47/305547/1

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: newchange
Gerrit-Change-Id: I948a2fcd546076ad186e7cde933a70795f591a58
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Comments
Gerrit-Branch: master
Gerrit-Owner: Legoktm 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits