-- Key to the page affected. Where a user is the target,
-- this will point to the user page.
- log_namespace tinyint unsigned NOT NULL default 0,
- log_title varchar(255) NOT NULL default '',
+ log_namespace int NOT NULL default 0,
+ log_title varchar(255) binary NOT NULL default '',
-- Freeform text. Interpreted as edit history comments.
log_comment varchar(255) NOT NULL default '',
+ -- LF separated list of miscellaneous parameters
+ log_params blob NOT NULL default '',
+
KEY type_time (log_type, log_timestamp),
KEY user_time (log_user, log_timestamp),
KEY page_time (log_namespace, log_title, log_timestamp)
-);
+
+) TYPE=InnoDB;
+
-- Change from unsigned to signed so we can store special pages
ALTER TABLE recentchanges