From 180e2ce0177f7955a14cbfca827c04b9fa44325f Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sat, 11 Apr 2009 23:46:12 +0000 Subject: [PATCH] log_target_id -> log_page. Indexed to allow better log tracking wrt page moves. --- maintenance/archives/patch-log_user_text.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/maintenance/archives/patch-log_user_text.sql b/maintenance/archives/patch-log_user_text.sql index dffbe8be77..6fbe31ed1c 100644 --- a/maintenance/archives/patch-log_user_text.sql +++ b/maintenance/archives/patch-log_user_text.sql @@ -1,7 +1,8 @@ ALTER TABLE /*$wgDBprefix*/logging ADD log_user_text varchar(255) binary NOT NULL default '', - ADD log_target_id int unsigned NULL, + ADD log_page int unsigned NULL, CHANGE log_type log_type varbinary(32) NOT NULL, CHANGE log_action log_action varbinary(32) NOT NULL; CREATE INDEX /*i*/user_type_time ON /*_*/logging (log_user, log_type, log_timestamp); +CREATE INDEX /*i*/page_type ON /*_*/logging (log_page,log_timestamp); -- 2.20.1