Merge "objectcache: add expiration check callback to WANObjectCache::getWithSetCallback"

[lhc/web/wiklou.git] / maintenance / archives / patch-log_user_text.sql

diff --git a/maintenance/archives/patch-log_user_text.sql b/maintenance/archives/patch-log_user_text.sql
index f89a35f..12ca75e 100644 (file)
--- a/maintenance/archives/patch-log_user_text.sql
+++ b/maintenance/archives/patch-log_user_text.sql
@@ -1,5 +1,8 @@
-ALTER TABLE /*$wgDBprefix*/logging 
+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;
+       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*/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);