Aktualisierung auf MediaWiki 1.9.0

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);