Split down patch-actor-table.sql
[lhc/web/wiklou.git] / maintenance / archives / patch-logging-log_actor.sql
1 ALTER TABLE /*_*/logging
2 ADD COLUMN log_actor bigint unsigned NOT NULL DEFAULT 0 AFTER log_user_text;
3 CREATE INDEX /*i*/actor_time ON /*_*/logging (log_actor, log_timestamp);
4 CREATE INDEX /*i*/log_actor_type_time ON /*_*/logging (log_actor, log_type, log_timestamp);