From a7b32ae5ae59e2f7e5734559c3945b33b400396c Mon Sep 17 00:00:00 2001 From: Roan Kattouw Date: Fri, 17 Jul 2009 17:45:53 +0000 Subject: [PATCH] (bug 19570) Add log_user_text and log_page to tables.sql; fixes r51997 --- maintenance/tables.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 4297b716da..b2fcd86f49 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1103,10 +1103,14 @@ CREATE TABLE /*_*/logging ( -- The user who performed this action; key to user_id log_user int unsigned NOT NULL default 0, + -- Name of the user who performed this action + log_user_text varchar(255) binary NOT NULL default '', + -- 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 varchar(255) binary NOT NULL default '', + log_page int unsigned NULL, -- Freeform text. Interpreted as edit history comments. log_comment varchar(255) NOT NULL default '', @@ -1122,6 +1126,8 @@ CREATE INDEX /*i*/type_time ON /*_*/logging (log_type, log_timestamp); CREATE INDEX /*i*/user_time ON /*_*/logging (log_user, log_timestamp); CREATE INDEX /*i*/page_time ON /*_*/logging (log_namespace, log_title, log_timestamp); CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp); +CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp); +CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp); CREATE TABLE /*_*/log_search ( -- 2.20.1