Paladox has uploaded a new change for review.

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

Change subject: Update farmer.sql
......................................................................

Update farmer.sql

* Updates farmer.sql and adds support for sqlite.

Change-Id: Ifc7dd1b500aa0c3a118201fe2e33c8f1561a45cf
(cherry picked from commit 15cb10a863485127371b4f2bcda85dbd3233a8b6)
---
M Farmer.php
M farmer.sql
2 files changed, 9 insertions(+), 9 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Farmer 
refs/changes/76/185476/1

diff --git a/Farmer.php b/Farmer.php
index ce78aa6..8425f8d 100644
--- a/Farmer.php
+++ b/Farmer.php
@@ -17,7 +17,7 @@
        'author' => array( 'Gregory Szorc <[email protected]>', 'Alexandre 
Emsenhuber' ),
        'url' => 'https://www.mediawiki.org/wiki/Extension:Farmer',
        'descriptionmsg' => 'farmer-desc',
-       'version' => '0.1.1',
+       'version' => '0.1.2',
 );
 
 /**
diff --git a/farmer.sql b/farmer.sql
index 9f79f94..bc99281 100644
--- a/farmer.sql
+++ b/farmer.sql
@@ -3,8 +3,8 @@
 --
 
 -- Store each wiki in the wiki farm
-CREATE TABLE farmer_wiki (
-       fw_id INT NOT NULL auto_increment PRIMARY KEY,
+CREATE TABLE /*_*/farmer_wiki (
+       fw_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
        fw_name VARCHAR(32) UNIQUE,
        fw_title VARCHAR(255),
        fw_description BLOB,
@@ -14,20 +14,20 @@
 ) /*$wgDBTableOptions*/;
 
 -- Store information about each extension availabe in the farm
-CREATE TABLE farmer_extension (
-       fe_id INT NOT NULL auto_increment PRIMARY KEY,
+CREATE TABLE /*_*/farmer_extension (
+       fe_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
        fe_name VARCHAR(255) UNIQUE,
        fe_description BLOB,
        fe_path VARCHAR(255)
 ) /*$wgDBTableOptions*/;
 
 -- Store relation beetween wiki and extensions
-CREATE TABLE farmer_wiki_extension (
+CREATE TABLE /*_*/farmer_wiki_extension (
        fwe_wiki INT NOT NULL,
        fwe_extension INT NOT NULL
 ) /*$wgDBTableOptions*/;
 
-CREATE INDEX farmer_wiki_extension_wiki ON farmer_wiki_extension ( fwe_wiki );
-CREATE INDEX farmer_wiki_extension_extension ON farmer_wiki_extension ( 
fwe_extension );
-ALTER TABLE farmer_wiki_extension
+CREATE INDEX /*i*/farmer_wiki_extension_wiki ON /*_*/farmer_wiki_extension ( 
fwe_wiki );
+CREATE INDEX /*i*/farmer_wiki_extension_extension ON 
/*_*/farmer_wiki_extension ( fwe_extension );
+ALTER TABLE /*_*/farmer_wiki_extension
        ADD CONSTRAINT farmer_wiki_extension_wiki_extension PRIMARY KEY ( 
fwe_wiki, fwe_extension );

-- 
To view, visit https://gerrit.wikimedia.org/r/185476
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ifc7dd1b500aa0c3a118201fe2e33c8f1561a45cf
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Farmer
Gerrit-Branch: REL1_24
Gerrit-Owner: Paladox <[email protected]>

_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to