From 94a7e74df5e0226d8f9fa3fc53dc0a35b09e8053 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Thu, 10 Nov 2011 21:03:23 +0000 Subject: [PATCH] Added some revision table comments --- maintenance/tables.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 3d4bee16b6..69937c1616 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -273,6 +273,7 @@ CREATE INDEX /*i*/page_len ON /*_*/page (page_len); -- to the text storage backend. -- CREATE TABLE /*_*/revision ( + -- Unique ID to identify each revision rev_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, -- Key to page_id. This should _never_ be invalid. @@ -296,14 +297,14 @@ CREATE TABLE /*_*/revision ( -- Text username or IP address of the editor. rev_user_text varchar(255) binary NOT NULL default '', - -- Timestamp + -- Timestamp of when revision was created rev_timestamp binary(14) NOT NULL default '', -- Records whether the user marked the 'minor edit' checkbox. -- Many automated edits are marked as minor. rev_minor_edit tinyint unsigned NOT NULL default 0, - -- Not yet used; reserved for future changes to the deletion system. + -- Restrictions on who can access this revision rev_deleted tinyint unsigned NOT NULL default 0, -- Length of this revision in bytes -- 2.20.1