summaryrefslogtreecommitdiff
path: root/maintenance/oracle
diff options
context:
space:
mode:
authorPierre Schmitz <pierre@archlinux.de>2007-01-11 19:06:07 +0000
committerPierre Schmitz <pierre@archlinux.de>2007-01-11 19:06:07 +0000
commita58285fd06c8113c45377c655dd43cef6337e815 (patch)
treedfe31d3d12652352fe44890b4811eda0728faefb /maintenance/oracle
parent20194986f6638233732ba1fc3e838f117d3cc9ea (diff)
Aktualisierung auf MediaWiki 1.9.0
Diffstat (limited to 'maintenance/oracle')
-rw-r--r--maintenance/oracle/tables.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql
index 6733f950..030f427f 100644
--- a/maintenance/oracle/tables.sql
+++ b/maintenance/oracle/tables.sql
@@ -109,14 +109,14 @@ CREATE TABLE pagelinks (
pl_title VARCHAR2(255) NOT NULL
);
CREATE UNIQUE INDEX pl_from ON pagelinks(pl_from, pl_namespace, pl_title);
-CREATE INDEX pl_namespace ON pagelinks(pl_namespace, pl_title);
+CREATE INDEX pl_namespace ON pagelinks(pl_namespace, pl_title, pl_from);
CREATE TABLE imagelinks (
il_from NUMBER(8) NOT NULL REFERENCES page(page_id) ON DELETE CASCADE,
il_to VARCHAR2(255) NOT NULL
);
CREATE UNIQUE INDEX il_from ON imagelinks(il_from, il_to);
-CREATE INDEX il_to ON imagelinks(il_to);
+CREATE INDEX il_to ON imagelinks(il_to, il_from);
CREATE TABLE categorylinks (
cl_from NUMBER(8) NOT NULL REFERENCES page(page_id) ON DELETE CASCADE,
@@ -229,6 +229,8 @@ CREATE TABLE recentchanges (
rc_moved_to_title VARCHAR2(255),
rc_patrolled NUMBER(3) DEFAULT 0 NOT NULL,
rc_ip VARCHAR2(40),
+ rc_old_len NUMBER(10) DEFAULT 0,
+ rc_new_len NUMBER(10) DEFAULT 0,
CONSTRAINT rc_pk PRIMARY KEY (rc_id)
);
CREATE INDEX rc_timestamp ON recentchanges (rc_timestamp);