| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -273,6 +273,7 @@ |
| 274 | 274 | -- to the text storage backend. |
| 275 | 275 | -- |
| 276 | 276 | CREATE TABLE /*_*/revision ( |
| | 277 | + -- Unique ID to identify each revision |
| 277 | 278 | rev_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, |
| 278 | 279 | |
| 279 | 280 | -- Key to page_id. This should _never_ be invalid. |
| — | — | @@ -296,14 +297,14 @@ |
| 297 | 298 | -- Text username or IP address of the editor. |
| 298 | 299 | rev_user_text varchar(255) binary NOT NULL default '', |
| 299 | 300 | |
| 300 | | - -- Timestamp |
| | 301 | + -- Timestamp of when revision was created |
| 301 | 302 | rev_timestamp binary(14) NOT NULL default '', |
| 302 | 303 | |
| 303 | 304 | -- Records whether the user marked the 'minor edit' checkbox. |
| 304 | 305 | -- Many automated edits are marked as minor. |
| 305 | 306 | rev_minor_edit tinyint unsigned NOT NULL default 0, |
| 306 | 307 | |
| 307 | | - -- Not yet used; reserved for future changes to the deletion system. |
| | 308 | + -- Restrictions on who can access this revision |
| 308 | 309 | rev_deleted tinyint unsigned NOT NULL default 0, |
| 309 | 310 | |
| 310 | 311 | -- Length of this revision in bytes |