| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -136,7 +136,7 @@ |
| 137 | 137 | ar_flags TEXT, |
| 138 | 138 | ar_rev_id INTEGER, |
| 139 | 139 | ar_text_id INTEGER, |
| 140 | | - ar_deleted INTEGER NOT NULL DEFAULT '0', |
| | 140 | + ar_deleted INTEGER NOT NULL DEFAULT '0', |
| 141 | 141 | ); |
| 142 | 142 | CREATE INDEX archive_name_title_timestamp ON archive2 (ar_namespace,ar_title,ar_timestamp); |
| 143 | 143 | |
| — | — | @@ -144,7 +144,7 @@ |
| 145 | 145 | CREATE VIEW archive AS |
| 146 | 146 | SELECT |
| 147 | 147 | ar_namespace, ar_title, ar_text, ar_comment, ar_user, ar_user_text, |
| 148 | | - ar_minor_edit, ar_flags, ar_rev_id, ar_text_id, |
| | 148 | + ar_minor_edit, ar_flags, ar_rev_id, ar_text_id, ar_deleted, |
| 149 | 149 | TO_CHAR(ar_timestamp, 'YYYYMMDDHH24MISS') AS ar_timestamp |
| 150 | 150 | FROM archive2; |
| 151 | 151 | |