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
---
 maintenance/ibm_db2/tables.sql | 78 +++++++++++++++++++++++++++++++++++-------
 1 file changed, 65 insertions(+), 13 deletions(-)

(limited to 'maintenance/ibm_db2/tables.sql')

diff --git a/maintenance/ibm_db2/tables.sql b/maintenance/ibm_db2/tables.sql
index 546c871d..261a3a2b 100644
--- a/maintenance/ibm_db2/tables.sql
+++ b/maintenance/ibm_db2/tables.sql
@@ -9,7 +9,7 @@
 
 CREATE TABLE user (
   -- Needs to start with 0
-  user_id					BIGINT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 0),
+  user_id			BIGINT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 0),
   user_name                 VARCHAR(255)     NOT NULL  UNIQUE,
   user_real_name            VARCHAR(255),
   user_password             VARCHAR(1024),
@@ -220,8 +220,12 @@ CREATE TABLE categorylinks (
   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_timestamp  TIMESTAMP(3)  NOT NULL
+  --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
 );
 CREATE UNIQUE INDEX cl_from ON categorylinks (cl_from, cl_to);
 CREATE INDEX cl_sortkey     ON categorylinks (cl_to, cl_sortkey, cl_from);
@@ -441,18 +445,11 @@ CREATE TABLE watchlist (
 CREATE UNIQUE INDEX wl_user_namespace_title ON watchlist (wl_namespace, wl_title, wl_user);
 
 
-CREATE TABLE math (
-  math_inputhash              VARCHAR(16) FOR BIT DATA     NOT NULL  UNIQUE,
-  math_outputhash             VARCHAR(16) FOR BIT DATA     NOT NULL,
-  math_html_conservativeness  SMALLINT  NOT NULL,
-  math_html                   CLOB(64K) INLINE LENGTH 4096,
-  math_mathml                 CLOB(64K) INLINE LENGTH 4096
-);
-
-
 CREATE TABLE interwiki (
   iw_prefix  VARCHAR(32)      NOT NULL  UNIQUE,
   iw_url     CLOB(64K) INLINE LENGTH 4096      NOT NULL,
+  iw_api     CLOB(64K) INLINE LENGTH 4096      NOT NULL,
+  iw_wikiid  varchar(64) NOT NULL,
   iw_local   SMALLINT  NOT NULL,
   iw_trans   SMALLINT  NOT NULL  DEFAULT 0
 );
@@ -489,7 +486,7 @@ CREATE INDEX querycachetwo_titletwo   ON querycachetwo (qcc_type,qcc_namespacetw
 CREATE TABLE objectcache (
   keyname   VARCHAR(255)           NOT NULL        UNIQUE, -- was nullable
   value     CLOB(16M) INLINE LENGTH 4096                   NOT NULL  DEFAULT '',
-  exptime  TIMESTAMP(3)               NOT NULL
+  exptime  TIMESTAMP(3)		NOT NULL
 );
 CREATE INDEX objectcacache_exptime ON objectcache (exptime);
 
@@ -686,3 +683,58 @@ CREATE TABLE l10n_cache (
 );
 CREATE INDEX lc_lang_key ON l10n_cache (lc_lang, lc_key);
 
+
+CREATE  TABLE "MSG_RESOURCE_LINKS"
+(
+"MRL_RESOURCE" VARCHAR(255) FOR BIT DATA  NOT NULL ,
+"MRL_MESSAGE" VARCHAR(255) FOR BIT DATA  NOT NULL
+)
+;
+
+CREATE UNIQUE INDEX "UQ61_MSG_RESOURCE_LINKS" ON "MSG_RESOURCE_LINKS"
+(
+"MRL_MESSAGE",
+"MRL_RESOURCE"
+)
+ALLOW REVERSE SCANS
+;
+
+CREATE  TABLE "MSG_RESOURCE"
+(
+"MR_RESOURCE" VARCHAR(255) FOR BIT DATA  NOT NULL ,
+"MR_LANG" VARCHAR(32) FOR BIT DATA  NOT NULL ,
+"MR_BLOB" BLOB NOT NULL ,
+"MR_TIMESTAMP" TIMESTAMP(3)  NOT NULL
+)
+;
+
+CREATE UNIQUE INDEX "UQ81_MSG_RESOURCE" ON "MSG_RESOURCE"
+(
+"MR_RESOURCE"
+,"MR_LANG"
+)
+ALLOW REVERSE SCANS
+;
+
+CREATE  TABLE "MODULE_DEPS" (
+"MD_MODULE" VARCHAR(255) FOR BIT DATA  NOT NULL ,
+"MD_SKIN" VARCHAR(32) FOR BIT DATA  NOT NULL ,
+"MD_DEPS" CLOB(16M) INLINE LENGTH 4096 NOT NULL
+)
+;
+
+CREATE UNIQUE INDEX "UQ96_MODULE_DEPS" ON "MODULE_DEPS"
+(
+"MD_MODULE"
+,"MD_SKIN"
+)
+ALLOW REVERSE SCANS
+;
+
+CREATE  TABLE "IWLINKS"
+(
+"IWL_FROM" INT  NOT NULL ,
+"IWL_PREFIX" VARCHAR(20) FOR BIT DATA  NOT NULL ,
+"IWL_TITLE" VARCHAR(255) FOR BIT DATA  NOT NULL
+)
+;
-- 
cgit v1.2.3-54-g00ecf

