From 08c988064ad51b560bdd9c1f571e3992bda2ff7b Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 7 Feb 2007 18:13:00 +0000 Subject: [PATCH] Rules to allow deletion from archive[2] --- maintenance/postgres/tables.sql | 6 ++++++ maintenance/updaters.inc | 10 +++++++++- 2 files changed, 15 insertions(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 0bea5f86ff..4dca3b1b7a 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -150,6 +150,12 @@ DO INSTEAD INSERT INTO archive2 VALUES ( NEW.ar_minor_edit, NEW.ar_flags, NEW.ar_rev_id, NEW.ar_text_id ); +CREATE RULE archive_delete AS ON DELETE TO archive +DO INSTEAD DELETE FROM archive2 a2 WHERE + a2.ar_title = OLD.ar_title AND + a2.ar_namespace = OLD.ar_namespace AND + a2.ar_rev_id = OLD.ar_rev_id; + CREATE TABLE redirect ( rd_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE, diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 54ae702736..454f082b02 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1207,7 +1207,7 @@ ALTER TABLE page_restrictions ADD CONSTRAINT page_restrictions_pk PRIMARY KEY (p -- Add a new index to help with full-text searches CREATE INDEX rev_text_id_idx ON revision (rev_text_id); --- Fix the archive rule +-- Fix the archive rule ar_timestamp field CREATE OR REPLACE RULE archive_insert AS ON INSERT TO archive DO INSTEAD INSERT INTO archive2 VALUES ( NEW.ar_namespace, NEW.ar_title, NEW.ar_text, NEW.ar_comment, NEW.ar_user, NEW.ar_user_text, @@ -1215,6 +1215,14 @@ DO INSTEAD INSERT INTO archive2 VALUES ( NEW.ar_minor_edit, NEW.ar_flags, NEW.ar_rev_id, NEW.ar_text_id ); +-- Allow deletion of archive rows +CREATE RULE archive_delete AS ON DELETE TO archive +DO INSTEAD DELETE FROM archive2 a2 WHERE + a2.ar_title = OLD.ar_title AND + a2.ar_namespace = OLD.ar_namespace AND + a2.ar_rev_id = OLD.ar_rev_id; + + -- Note this upgrade INSERT INTO mediawiki_version (type,mw_version,notes) VALUES ('Upgrade','MWVERSION','Upgrade from older pre 1.10 version THISVERSION aka SVERSION'); -- 2.20.1