From 3709b5957569c871a133ae3f18cc749be96a4328 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Tue, 19 Feb 2008 01:13:33 +0000 Subject: [PATCH] Remove no longer used patch files. --- .../archives/patch-archive-ar_deleted.sql | 1 - maintenance/postgres/archives/patch-archive2.sql | 15 --------------- .../postgres/archives/patch-archive_delete.sql | 5 ----- .../postgres/archives/patch-archive_insert.sql | 6 ------ 4 files changed, 27 deletions(-) delete mode 100644 maintenance/postgres/archives/patch-archive-ar_deleted.sql delete mode 100644 maintenance/postgres/archives/patch-archive2.sql delete mode 100644 maintenance/postgres/archives/patch-archive_delete.sql delete mode 100644 maintenance/postgres/archives/patch-archive_insert.sql diff --git a/maintenance/postgres/archives/patch-archive-ar_deleted.sql b/maintenance/postgres/archives/patch-archive-ar_deleted.sql deleted file mode 100644 index 08bc1e3712..0000000000 --- a/maintenance/postgres/archives/patch-archive-ar_deleted.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE archive ADD ar_deleted INTEGER NOT NULL DEFAULT '0'; diff --git a/maintenance/postgres/archives/patch-archive2.sql b/maintenance/postgres/archives/patch-archive2.sql deleted file mode 100644 index fa900cbfd2..0000000000 --- a/maintenance/postgres/archives/patch-archive2.sql +++ /dev/null @@ -1,15 +0,0 @@ -ALTER TABLE archive RENAME to archive2; -CREATE VIEW archive AS -SELECT - ar_namespace, ar_title, ar_text, ar_comment, ar_user, ar_user_text, - ar_minor_edit, ar_flags, ar_rev_id, ar_text_id, - TO_CHAR(ar_timestamp, 'YYYYMMDDHH24MISS') AS ar_timestamp -FROM archive2; - -CREATE 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, - TO_DATE(NEW.ar_timestamp, 'YYYYMMDDHH24MISS'), - NEW.ar_minor_edit, NEW.ar_flags, NEW.ar_rev_id, NEW.ar_text_id -); - diff --git a/maintenance/postgres/archives/patch-archive_delete.sql b/maintenance/postgres/archives/patch-archive_delete.sql deleted file mode 100644 index 4a864c3b81..0000000000 --- a/maintenance/postgres/archives/patch-archive_delete.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE RULE archive_delete AS ON DELETE TO archive -DO INSTEAD DELETE FROM archive2 WHERE - archive2.ar_title = OLD.ar_title AND - archive2.ar_namespace = OLD.ar_namespace AND - archive2.ar_rev_id = OLD.ar_rev_id; diff --git a/maintenance/postgres/archives/patch-archive_insert.sql b/maintenance/postgres/archives/patch-archive_insert.sql deleted file mode 100644 index ca13d2a2cc..0000000000 --- a/maintenance/postgres/archives/patch-archive_insert.sql +++ /dev/null @@ -1,6 +0,0 @@ -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, - TO_TIMESTAMP(NEW.ar_timestamp, 'YYYYMMDDHH24MISS'), - NEW.ar_minor_edit, NEW.ar_flags, NEW.ar_rev_id, NEW.ar_text_id -); -- 2.20.1