| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -116,7 +116,8 @@ |
| 117 | 117 | rev_minor_edit SMALLINT NOT NULL DEFAULT 0, |
| 118 | 118 | rev_deleted SMALLINT NOT NULL DEFAULT 0, |
| 119 | 119 | rev_len INTEGER NULL, |
| 120 | | - rev_parent_id INTEGER NULL |
| | 120 | + rev_parent_id INTEGER NULL, |
| | 121 | + rev_sha1 TEXT NOT NULL DEFAULT '' |
| 121 | 122 | ); |
| 122 | 123 | CREATE UNIQUE INDEX revision_unique ON revision (rev_page, rev_id); |
| 123 | 124 | CREATE INDEX rev_text_id_idx ON revision (rev_text_id); |
| — | — | @@ -159,6 +160,7 @@ |
| 160 | 161 | ar_text TEXT, -- technically should be bytea, but not used anymore |
| 161 | 162 | ar_page_id INTEGER NULL, |
| 162 | 163 | ar_parent_id INTEGER NULL, |
| | 164 | + ar_sha1 TEXT NOT NULL DEFAULT '', |
| 163 | 165 | ar_comment TEXT, |
| 164 | 166 | ar_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, |
| 165 | 167 | ar_user_text TEXT NOT NULL, |