From 54adced6ecc1e55bfb6bb44c9750c4d0a8b8dfcd Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sat, 11 Apr 2009 23:48:24 +0000 Subject: [PATCH] Index name fix, tweaked field name --- maintenance/archives/patch-log_user_text.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/archives/patch-log_user_text.sql b/maintenance/archives/patch-log_user_text.sql index 6fbe31ed1c..0ece6f1242 100644 --- a/maintenance/archives/patch-log_user_text.sql +++ b/maintenance/archives/patch-log_user_text.sql @@ -1,8 +1,8 @@ ALTER TABLE /*$wgDBprefix*/logging ADD log_user_text varchar(255) binary NOT NULL default '', - ADD log_page int unsigned NULL, + ADD log_page_id 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); +CREATE INDEX /*i*/page_id_time ON /*_*/logging (log_page,log_timestamp); -- 2.20.1