From 86858f7ba43740db2139a226a5e7729a8152d9be Mon Sep 17 00:00:00 2001 From: Jure Kajzer Date: Tue, 1 Mar 2011 07:40:53 +0000 Subject: [PATCH] * fixed INDEX change (i missed that one) --- maintenance/oracle/archives/patch_16_17_schema_changes.sql | 2 +- maintenance/oracle/tables.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/oracle/archives/patch_16_17_schema_changes.sql b/maintenance/oracle/archives/patch_16_17_schema_changes.sql index c3214b9693..64c284811b 100644 --- a/maintenance/oracle/archives/patch_16_17_schema_changes.sql +++ b/maintenance/oracle/archives/patch_16_17_schema_changes.sql @@ -2,7 +2,7 @@ define mw_prefix='{$wgDBprefix}'; ALTER TABLE &mw_prefix.archive MODIFY ar_user DEFAULT 0 NOT NULL; ALTER TABLE &mw_prefix.archive MODIFY ar_deleted CHAR(1); -CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_namespace, ar_title, ar_rev_id); +CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_rev_id); ALTER TABLE &mw_prefix.page MODIFY page_is_redirect default '0'; ALTER TABLE &mw_prefix.page MODIFY page_is_new default '0'; diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql index 6d57c7cddb..1f9db86615 100644 --- a/maintenance/oracle/tables.sql +++ b/maintenance/oracle/tables.sql @@ -131,7 +131,7 @@ CREATE TABLE &mw_prefix.archive ( ALTER TABLE &mw_prefix.archive ADD CONSTRAINT &mw_prefix.archive_fk1 FOREIGN KEY (ar_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; CREATE INDEX &mw_prefix.archive_i01 ON &mw_prefix.archive (ar_namespace,ar_title,ar_timestamp); CREATE INDEX &mw_prefix.archive_i02 ON &mw_prefix.archive (ar_user_text,ar_timestamp); -CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_namespace, ar_title, ar_rev_id); +CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_rev_id); CREATE TABLE &mw_prefix.pagelinks ( pl_from NUMBER NOT NULL, -- 2.20.1