From 5baa9afd14575187f02e1a2e0a6e6e1dccd2bb81 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sat, 10 Mar 2007 18:41:51 +0000 Subject: [PATCH] * Add ar_deleted to CREATE VIEW --- maintenance/postgres/tables.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 9cafcb3324..8777aa6198 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -136,7 +136,7 @@ CREATE TABLE archive2 ( ar_flags TEXT, ar_rev_id INTEGER, ar_text_id INTEGER, - ar_deleted INTEGER NOT NULL DEFAULT '0', + ar_deleted INTEGER NOT NULL DEFAULT '0', ); CREATE INDEX archive_name_title_timestamp ON archive2 (ar_namespace,ar_title,ar_timestamp); @@ -144,7 +144,7 @@ CREATE INDEX archive_name_title_timestamp ON archive2 (ar_namespace,ar_title,ar_ 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, + ar_minor_edit, ar_flags, ar_rev_id, ar_text_id, ar_deleted, TO_CHAR(ar_timestamp, 'YYYYMMDDHH24MISS') AS ar_timestamp FROM archive2; -- 2.20.1