diff options
| author | Pierre Schmitz <pierre@archlinux.de> | 2008-12-15 18:02:47 +0100 |
|---|---|---|
| committer | Pierre Schmitz <pierre@archlinux.de> | 2008-12-15 18:02:47 +0100 |
| commit | 396b28f3d881f5debd888ba9bb9b47c2d478a76f (patch) | |
| tree | 10d6e1a721ee4ef69def34a57f02d7eb3fc9e31e /maintenance/postgres/archives/patch-archive2.sql | |
| parent | 0be4d3ccf6c4fe98a72704f9463ecdea2ee5e615 (diff) | |
update to Mediawiki 1.13.3; some cleanups
Diffstat (limited to 'maintenance/postgres/archives/patch-archive2.sql')
| -rw-r--r-- | maintenance/postgres/archives/patch-archive2.sql | 15 |
1 files changed, 0 insertions, 15 deletions
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 -); - |