From 396b28f3d881f5debd888ba9bb9b47c2d478a76f Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Mon, 15 Dec 2008 18:02:47 +0100
Subject: update to Mediawiki 1.13.3; some cleanups

---
 maintenance/postgres/archives/patch-archive2.sql | 15 ---------------
 1 file changed, 15 deletions(-)
 delete mode 100644 maintenance/postgres/archives/patch-archive2.sql

(limited to 'maintenance/postgres/archives/patch-archive2.sql')

diff --git a/maintenance/postgres/archives/patch-archive2.sql b/maintenance/postgres/archives/patch-archive2.sql
deleted file mode 100644
index fa900cbf..00000000
--- 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
-);
-
-- 
cgit v1.2.3-54-g00ecf

