From a58285fd06c8113c45377c655dd43cef6337e815 Mon Sep 17 00:00:00 2001 From: Pierre Schmitz Date: Thu, 11 Jan 2007 19:06:07 +0000 Subject: Aktualisierung auf MediaWiki 1.9.0 --- maintenance/oracle/tables.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'maintenance/oracle') 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); -- cgit v1.2.3-54-g00ecf