-- action field, but only the type controls categorization.
log_type varbinary(10) NOT NULL default '',
log_action varbinary(10) NOT NULL default '',
-
+
-- Timestamp. Duh.
log_timestamp binary(14) NOT NULL default '19700101000000',
-
+
-- The user who performed this action; key to user_id
log_user int unsigned NOT NULL default 0,
-
+
-- Key to the page affected. Where a user is the target,
-- this will point to the user page.
log_namespace int NOT NULL default 0,
- log_title varbinary(255) NOT NULL default '',
-
+ log_title varchar(255) binary NOT NULL default '',
+
-- Freeform text. Interpreted as edit history comments.
- log_comment varbinary(255) NOT NULL default '',
-
+ log_comment varchar(255) NOT NULL default '',
+
-- LF separated list of miscellaneous parameters
log_params blob NOT NULL,