summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-log_user_text.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/archives/patch-log_user_text.sql')
-rw-r--r--maintenance/archives/patch-log_user_text.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/maintenance/archives/patch-log_user_text.sql b/maintenance/archives/patch-log_user_text.sql
index f89a35f6..dffbe8be 100644
--- a/maintenance/archives/patch-log_user_text.sql
+++ b/maintenance/archives/patch-log_user_text.sql
@@ -1,5 +1,7 @@
ALTER TABLE /*$wgDBprefix*/logging
ADD log_user_text varchar(255) binary NOT NULL default '',
ADD log_target_id int unsigned NULL,
- CHANGE `log_type` `log_type` VARBINARY( 15 ) NOT NULL,
- CHANGE `log_action` `log_action` VARBINARY( 15 ) NOT 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);