From a58285fd06c8113c45377c655dd43cef6337e815 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Thu, 11 Jan 2007 19:06:07 +0000
Subject: Aktualisierung auf MediaWiki 1.9.0

---
 maintenance/archives/patch-backlinkindexes.sql     | 19 +++++++++++++++
 maintenance/archives/patch-externallinks.sql       |  4 ++--
 maintenance/archives/patch-filearchive.sql         |  2 +-
 maintenance/archives/patch-ipb_anon_only.sql       |  8 +++----
 .../archives/patch-ipb_optional_autoblock.sql      |  3 +++
 maintenance/archives/patch-job.sql                 |  2 +-
 maintenance/archives/patch-log_params.sql          |  2 +-
 maintenance/archives/patch-logging.sql             |  2 +-
 maintenance/archives/patch-querycachetwo.sql       | 22 +++++++++++++++++
 maintenance/archives/patch-rc_len.sql              |  9 +++++++
 maintenance/archives/patch-rc_user_text-index.sql  |  7 ++++++
 maintenance/archives/patch-redirect.sql            | 28 ++++++++++++++++++++++
 .../patch-rename-user_groups-and_rights.sql        |  2 +-
 maintenance/archives/patch-restructure.sql         |  8 +++----
 maintenance/archives/patch-searchindex.sql         |  2 +-
 maintenance/archives/patch-user_editcount.sql      |  5 ++++
 maintenance/archives/patch-user_newpass_time.sql   |  4 ++++
 maintenance/archives/patch-user_rights.sql         |  2 +-
 18 files changed, 114 insertions(+), 17 deletions(-)
 create mode 100644 maintenance/archives/patch-backlinkindexes.sql
 create mode 100644 maintenance/archives/patch-ipb_optional_autoblock.sql
 create mode 100644 maintenance/archives/patch-querycachetwo.sql
 create mode 100644 maintenance/archives/patch-rc_len.sql
 create mode 100644 maintenance/archives/patch-rc_user_text-index.sql
 create mode 100644 maintenance/archives/patch-redirect.sql
 create mode 100644 maintenance/archives/patch-user_editcount.sql
 create mode 100644 maintenance/archives/patch-user_newpass_time.sql

(limited to 'maintenance/archives')

diff --git a/maintenance/archives/patch-backlinkindexes.sql b/maintenance/archives/patch-backlinkindexes.sql
new file mode 100644
index 00000000..5facd9ea
--- /dev/null
+++ b/maintenance/archives/patch-backlinkindexes.sql
@@ -0,0 +1,19 @@
+-- 
+-- patch-backlinkindexes.sql
+-- 
+-- Per bug 6440 / http://bugzilla.wikimedia.org/show_bug.cgi?id=6440
+--
+-- Improve performance of the "what links here"-type queries
+-- 
+
+ALTER TABLE /*$wgDBprefix*/pagelinks
+   DROP INDEX pl_namespace,
+   ADD INDEX pl_namespace(pl_namespace, pl_title, pl_from);
+
+ALTER TABLE /*$wgDBprefix*/templatelinks
+   DROP INDEX tl_namespace,
+   ADD INDEX tl_namespace(tl_namespace, tl_title, tl_from);
+   
+ALTER TABLE /*$wgDBprefix*/imagelinks
+   DROP INDEX il_to,
+   ADD INDEX il_to(il_to, il_from);
diff --git a/maintenance/archives/patch-externallinks.sql b/maintenance/archives/patch-externallinks.sql
index d1aa5764..52fb5bae 100644
--- a/maintenance/archives/patch-externallinks.sql
+++ b/maintenance/archives/patch-externallinks.sql
@@ -3,8 +3,8 @@
 --
 CREATE TABLE /*$wgDBprefix*/externallinks (
   el_from int(8) unsigned NOT NULL default '0',
-  el_to blob NOT NULL default '',
-  el_index blob NOT NULL default '',
+  el_to blob NOT NULL,
+  el_index blob NOT NULL,
   
   KEY (el_from, el_to(40)),
   KEY (el_to(60), el_from),
diff --git a/maintenance/archives/patch-filearchive.sql b/maintenance/archives/patch-filearchive.sql
index 4bf09366..cc50f2ae 100644
--- a/maintenance/archives/patch-filearchive.sql
+++ b/maintenance/archives/patch-filearchive.sql
@@ -37,7 +37,7 @@ CREATE TABLE /*$wgDBprefix*/filearchive (
   fa_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL,
   fa_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") default "unknown",
   fa_minor_mime varchar(32) default "unknown",
-  fa_description tinyblob default '',
+  fa_description tinyblob,
   fa_user int(5) unsigned default '0',
   fa_user_text varchar(255) binary default '',
   fa_timestamp char(14) binary default '',
diff --git a/maintenance/archives/patch-ipb_anon_only.sql b/maintenance/archives/patch-ipb_anon_only.sql
index 709308a2..b3738168 100644
--- a/maintenance/archives/patch-ipb_anon_only.sql
+++ b/maintenance/archives/patch-ipb_anon_only.sql
@@ -11,17 +11,17 @@ DROP TABLE IF EXISTS /*$wgDBprefix*/ipblocks_newunique;
 
 CREATE TABLE /*$wgDBprefix*/ipblocks_newunique (
   ipb_id int(8) NOT NULL auto_increment,
-  ipb_address tinyblob NOT NULL default '',
+  ipb_address tinyblob NOT NULL,
   ipb_user int(8) unsigned NOT NULL default '0',
   ipb_by int(8) unsigned NOT NULL default '0',
-  ipb_reason tinyblob NOT NULL default '',
+  ipb_reason tinyblob NOT NULL,
   ipb_timestamp char(14) binary NOT NULL default '',
   ipb_auto bool NOT NULL default 0,
   ipb_anon_only bool NOT NULL default 0,
   ipb_create_account bool NOT NULL default 1,
   ipb_expiry char(14) binary NOT NULL default '',
-  ipb_range_start tinyblob NOT NULL default '',
-  ipb_range_end tinyblob NOT NULL default '',
+  ipb_range_start tinyblob NOT NULL,
+  ipb_range_end tinyblob NOT NULL,
   
   PRIMARY KEY ipb_id (ipb_id),
   UNIQUE INDEX ipb_address_unique (ipb_address(255), ipb_user, ipb_auto),
diff --git a/maintenance/archives/patch-ipb_optional_autoblock.sql b/maintenance/archives/patch-ipb_optional_autoblock.sql
new file mode 100644
index 00000000..f31b8359
--- /dev/null
+++ b/maintenance/archives/patch-ipb_optional_autoblock.sql
@@ -0,0 +1,3 @@
+-- Add an extra option field "ipb_enable_autoblock" into the ipblocks table. This allows a block to be placed that does not trigger any autoblocks.
+
+ALTER TABLE /*$wgDBprefix*/ipblocks ADD COLUMN ipb_enable_autoblock bool NOT NULL default '1';
diff --git a/maintenance/archives/patch-job.sql b/maintenance/archives/patch-job.sql
index 89918456..d904fbeb 100644
--- a/maintenance/archives/patch-job.sql
+++ b/maintenance/archives/patch-job.sql
@@ -13,7 +13,7 @@ CREATE TABLE /*$wgDBprefix*/job (
 
   -- Any other parameters to the command
   -- Presently unused, format undefined
-  job_params blob NOT NULL default '',
+  job_params blob NOT NULL,
 
   PRIMARY KEY job_id (job_id),
   KEY (job_cmd, job_namespace, job_title)
diff --git a/maintenance/archives/patch-log_params.sql b/maintenance/archives/patch-log_params.sql
index aa00a673..ff6527ec 100644
--- a/maintenance/archives/patch-log_params.sql
+++ b/maintenance/archives/patch-log_params.sql
@@ -1 +1 @@
-ALTER TABLE /*$wgDBprefix*/logging ADD log_params blob NOT NULL default '';
+ALTER TABLE /*$wgDBprefix*/logging ADD log_params blob NOT NULL;
diff --git a/maintenance/archives/patch-logging.sql b/maintenance/archives/patch-logging.sql
index 79bb53b5..54146fb7 100644
--- a/maintenance/archives/patch-logging.sql
+++ b/maintenance/archives/patch-logging.sql
@@ -23,7 +23,7 @@ CREATE TABLE /*$wgDBprefix*/logging (
   log_comment varchar(255) NOT NULL default '',
   
   -- LF separated list of miscellaneous parameters
-  log_params blob NOT NULL default '',
+  log_params blob NOT NULL,
 
   KEY type_time (log_type, log_timestamp),
   KEY user_time (log_user, log_timestamp),
diff --git a/maintenance/archives/patch-querycachetwo.sql b/maintenance/archives/patch-querycachetwo.sql
new file mode 100644
index 00000000..cda5b90d
--- /dev/null
+++ b/maintenance/archives/patch-querycachetwo.sql
@@ -0,0 +1,22 @@
+-- Used for caching expensive grouped queries that need two links (for example double-redirects)
+
+CREATE TABLE /*$wgDBprefix*/querycachetwo (
+  -- A key name, generally the base name of of the special page.
+  qcc_type char(32) NOT NULL,
+  
+  -- Some sort of stored value. Sizes, counts...
+  qcc_value int(5) unsigned NOT NULL default '0',
+  
+  -- Target namespace+title
+  qcc_namespace int NOT NULL default '0',
+  qcc_title char(255) binary NOT NULL default '',
+  
+  -- Target namespace+title2
+  qcc_namespacetwo int NOT NULL default '0',
+  qcc_titletwo char(255) binary NOT NULL default '',
+
+  KEY qcc_type (qcc_type,qcc_value),
+  KEY qcc_title (qcc_type,qcc_namespace,qcc_title),
+  KEY qcc_titletwo (qcc_type,qcc_namespacetwo,qcc_titletwo)
+
+) TYPE=InnoDB;
diff --git a/maintenance/archives/patch-rc_len.sql b/maintenance/archives/patch-rc_len.sql
new file mode 100644
index 00000000..920f755b
--- /dev/null
+++ b/maintenance/archives/patch-rc_len.sql
@@ -0,0 +1,9 @@
+--
+-- patch-rc_len.sql
+-- Adds two rows to recentchanges to hold the text size befor and after the edit
+-- 2006-12-03
+--
+
+ALTER TABLE /*$wgDBprefix*/recentchanges
+	ADD COLUMN rc_old_len int(10), ADD COLUMN rc_new_len int(10);
+
diff --git a/maintenance/archives/patch-rc_user_text-index.sql b/maintenance/archives/patch-rc_user_text-index.sql
new file mode 100644
index 00000000..f6acc992
--- /dev/null
+++ b/maintenance/archives/patch-rc_user_text-index.sql
@@ -0,0 +1,7 @@
+-- Add an index to recentchanges on rc_user_text
+--
+-- Added 2006-11-08
+--
+
+     ALTER TABLE /*$wgDBprefix*/recentchanges
+ADD INDEX rc_user_text(rc_user_text, rc_timestamp);
\ No newline at end of file
diff --git a/maintenance/archives/patch-redirect.sql b/maintenance/archives/patch-redirect.sql
new file mode 100644
index 00000000..d377f1b1
--- /dev/null
+++ b/maintenance/archives/patch-redirect.sql
@@ -0,0 +1,28 @@
+--
+-- Create the new redirect table.
+-- For each redirect, this table contains exactly one row defining its target
+-- 
+CREATE TABLE /*$wgDBprefix*/redirect (
+  -- Key to the page_id of the redirect page
+  rd_from int(8) unsigned NOT NULL default '0',
+
+  -- Key to page_namespace/page_title of the target page.
+  -- The target page may or may not exist, and due to renames
+  -- and deletions may refer to different page records as time
+  -- goes by.
+  rd_namespace int NOT NULL default '0',
+  rd_title varchar(255) binary NOT NULL default '',
+
+  PRIMARY KEY rd_from (rd_from),
+  KEY rd_ns_title (rd_namespace,rd_title,rd_from)
+) TYPE=InnoDB;
+
+-- Import existing redirects
+-- Using ignore because some of the redirect pages contain more than one link
+INSERT IGNORE
+  INTO /*$wgDBprefix*/redirect (rd_from,rd_namespace,rd_title)
+  SELECT pl_from,pl_namespace,pl_title
+    FROM /*$wgDBprefix*/pagelinks, /*$wgDBprefix*/page
+    WHERE pl_from=page_id AND page_is_redirect=1;
+
+
diff --git a/maintenance/archives/patch-rename-user_groups-and_rights.sql b/maintenance/archives/patch-rename-user_groups-and_rights.sql
index abd59319..650f2604 100644
--- a/maintenance/archives/patch-rename-user_groups-and_rights.sql
+++ b/maintenance/archives/patch-rename-user_groups-and_rights.sql
@@ -5,5 +5,5 @@ ALTER TABLE /*$wgDBprefix*/user_groups
 
 ALTER TABLE /*$wgDBprefix*/user_rights
 	CHANGE user_id ur_user INT(5) UNSIGNED NOT NULL,
-	CHANGE user_rights ur_rights TINYBLOB NOT NULL DEFAULT '';
+	CHANGE user_rights ur_rights TINYBLOB NOT NULL;
 
diff --git a/maintenance/archives/patch-restructure.sql b/maintenance/archives/patch-restructure.sql
index 53f1836b..acf306c2 100644
--- a/maintenance/archives/patch-restructure.sql
+++ b/maintenance/archives/patch-restructure.sql
@@ -13,7 +13,7 @@ CREATE TABLE /*$wgDBprefix*/page (
   page_id int(8) unsigned NOT NULL auto_increment,
   page_namespace tinyint NOT NULL,
   page_title varchar(255) binary NOT NULL,
-  page_restrictions tinyblob NOT NULL default '',
+  page_restrictions tinyblob NOT NULL,
   page_counter bigint(20) unsigned NOT NULL default '0',
   page_is_redirect tinyint(1) unsigned NOT NULL default '0',
   page_is_new tinyint(1) unsigned NOT NULL default '0',
@@ -31,7 +31,7 @@ CREATE TABLE /*$wgDBprefix*/page (
 CREATE TABLE /*$wgDBprefix*/revision (
   rev_id int(8) unsigned NOT NULL auto_increment,
   rev_page int(8) unsigned NOT NULL,
-  rev_comment tinyblob NOT NULL default '',
+  rev_comment tinyblob NOT NULL,
   rev_user int(5) unsigned NOT NULL default '0',
   rev_user_text varchar(255) binary NOT NULL default '',
   rev_timestamp char(14) binary NOT NULL default '',
@@ -51,8 +51,8 @@ CREATE TABLE /*$wgDBprefix*/revision (
 --
 -- CREATE TABLE /*$wgDBprefix*/text (
 --   old_id int(8) unsigned NOT NULL auto_increment,
---   old_text mediumtext NOT NULL default '',
---   old_flags tinyblob NOT NULL default '',
+--   old_text mediumtext NOT NULL,
+--   old_flags tinyblob NOT NULL,
 --   
 --   PRIMARY KEY old_id (old_id)
 -- );
diff --git a/maintenance/archives/patch-searchindex.sql b/maintenance/archives/patch-searchindex.sql
index fb54dbbe..2b9b6702 100644
--- a/maintenance/archives/patch-searchindex.sql
+++ b/maintenance/archives/patch-searchindex.sql
@@ -15,7 +15,7 @@ CREATE TABLE /*$wgDBprefix*/searchindex (
   si_title varchar(255) NOT NULL default '',
   
   -- Munged version of body text
-  si_text mediumtext NOT NULL default '',
+  si_text mediumtext NOT NULL,
   
   UNIQUE KEY (si_page)
 
diff --git a/maintenance/archives/patch-user_editcount.sql b/maintenance/archives/patch-user_editcount.sql
new file mode 100644
index 00000000..cdde36dc
--- /dev/null
+++ b/maintenance/archives/patch-user_editcount.sql
@@ -0,0 +1,5 @@
+ALTER TABLE /*$wgDBprefix*/user
+  ADD COLUMN user_editcount int;
+
+-- Don't initialize values immediately... or should we?
+-- They will be lazy-evaluated, or batch-filled via maintenance/initEditCount.php
diff --git a/maintenance/archives/patch-user_newpass_time.sql b/maintenance/archives/patch-user_newpass_time.sql
new file mode 100644
index 00000000..47b332ba
--- /dev/null
+++ b/maintenance/archives/patch-user_newpass_time.sql
@@ -0,0 +1,4 @@
+-- Timestamp of the last time when a new password was
+-- sent, for throttling purposes
+ALTER TABLE /*$wgDBprefix*/user ADD user_newpass_time char(14) binary;
+
diff --git a/maintenance/archives/patch-user_rights.sql b/maintenance/archives/patch-user_rights.sql
index 36f0102a..a32ef457 100644
--- a/maintenance/archives/patch-user_rights.sql
+++ b/maintenance/archives/patch-user_rights.sql
@@ -10,7 +10,7 @@ CREATE TABLE /*$wgDBprefix*/user_rights (
   ur_user int(5) unsigned NOT NULL,
   
   -- Comma-separated list of permission keys
-  ur_rights tinyblob NOT NULL default '',
+  ur_rights tinyblob NOT NULL,
   
   UNIQUE KEY ur_user (ur_user)
 
-- 
cgit v1.2.2