From ca32f08966f1b51fcb19460f0996bb0c4048e6fe Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Sat, 3 Dec 2011 13:29:22 +0100
Subject: Update to MediaWiki 1.18.0

* also update ArchLinux skin to chagnes in MonoBook
* Use only css to hide our menu bar when printing
---
 .../patch-categorylinks-better-collation.sql        | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 maintenance/ibm_db2/patch-categorylinks-better-collation.sql

(limited to 'maintenance/ibm_db2/patch-categorylinks-better-collation.sql')

diff --git a/maintenance/ibm_db2/patch-categorylinks-better-collation.sql b/maintenance/ibm_db2/patch-categorylinks-better-collation.sql
new file mode 100644
index 00000000..312583ac
--- /dev/null
+++ b/maintenance/ibm_db2/patch-categorylinks-better-collation.sql
@@ -0,0 +1,21 @@
+--
+-- patch-categorylinks-better-collation.sql
+--
+--
+-- Track category inclusions *used inline*
+-- This tracks a single level of category membership
+-- (folksonomic tagging, really).
+--
+CREATE TABLE categorylinks (
+  cl_from       BIGINT      NOT NULL  DEFAULT 0,
+  -- REFERENCES page(page_id) ON DELETE CASCADE,
+  cl_to         VARCHAR(255)         NOT NULL,
+  -- cl_sortkey has to be at least 86 wide 
+  -- in order to be compatible with the old MySQL schema from MW 1.10
+  --cl_sortkey    VARCHAR(86),
+  cl_sortkey VARCHAR(230) FOR BIT DATA  NOT NULL ,
+  cl_sortkey_prefix VARCHAR(255) FOR BIT DATA  NOT NULL ,
+  cl_timestamp  TIMESTAMP(3)  NOT NULL,
+  cl_collation VARCHAR(32) FOR BIT DATA  NOT NULL ,
+  cl_type VARCHAR(6) FOR BIT DATA  NOT NULL
+);
-- 
cgit v1.2.3-54-g00ecf

