| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -92,7 +92,8 @@ |
| 93 | 93 | rev_user_text TEXT NOT NULL, |
| 94 | 94 | rev_timestamp TIMESTAMPTZ NOT NULL, |
| 95 | 95 | rev_minor_edit CHAR NOT NULL DEFAULT '0', |
| 96 | | - rev_deleted CHAR NOT NULL DEFAULT '0' |
| | 96 | + rev_deleted CHAR NOT NULL DEFAULT '0', |
| | 97 | + rev_len INTEGER NULL |
| 97 | 98 | ); |
| 98 | 99 | CREATE UNIQUE INDEX revision_unique ON revision (rev_page, rev_id); |
| 99 | 100 | CREATE INDEX rev_text_id_idx ON revision (rev_text_id); |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -270,6 +270,9 @@ |
| 271 | 271 | -- Not yet used; reserved for future changes to the deletion system. |
| 272 | 272 | rev_deleted tinyint(1) unsigned NOT NULL default '0', |
| 273 | 273 | |
| | 274 | + -- Length of this revision in bytes |
| | 275 | + rev_len int(8) unsigned, |
| | 276 | + |
| 274 | 277 | PRIMARY KEY rev_page_id (rev_page, rev_id), |
| 275 | 278 | UNIQUE INDEX rev_id (rev_id), |
| 276 | 279 | INDEX rev_timestamp (rev_timestamp), |