diff options
Diffstat (limited to 'maintenance/postgres/archives')
6 files changed, 2 insertions, 28 deletions
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 08bc1e37..00000000 --- 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 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 -); - diff --git a/maintenance/postgres/archives/patch-archive_delete.sql b/maintenance/postgres/archives/patch-archive_delete.sql deleted file mode 100644 index 4a864c3b..00000000 --- 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 ca13d2a2..00000000 --- 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 -); diff --git a/maintenance/postgres/archives/patch-ipb_address_unique.sql b/maintenance/postgres/archives/patch-ipb_address_unique.sql new file mode 100644 index 00000000..9cfc6318 --- /dev/null +++ b/maintenance/postgres/archives/patch-ipb_address_unique.sql @@ -0,0 +1,2 @@ +DROP INDEX IF EXISTS ipb_address; +CREATE UNIQUE INDEX ipb_address_unique ON ipblocks (ipb_address,ipb_user,ipb_auto,ipb_anon_only); diff --git a/maintenance/postgres/archives/patch-rev_text_id_idx.sql b/maintenance/postgres/archives/patch-rev_text_id_idx.sql deleted file mode 100644 index 036c0be3..00000000 --- a/maintenance/postgres/archives/patch-rev_text_id_idx.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX rev_text_id_idx ON revision (rev_text_id); |