Page MenuHomeWickedGov Phorge
Files F5979024

patch-rename-indexes.sql
No OneTemporary
Actions

Size
782 B
Referenced Files
None
Subscribers
None

patch-rename-indexes.sql
View Options

-- Rename indexes with explicit names (T251613)
ALTER TABLE /*_*/abuse_filter
DROP INDEX /*i*/af_group,
ADD INDEX /*i*/af_group_enabled(af_group,af_enabled,af_id);
ALTER TABLE /*_*/abuse_filter_log
DROP INDEX /*i*/filter_timestamp_full,
DROP INDEX /*i*/user_timestamp,
DROP INDEX /*i*/page_timestamp,
DROP INDEX /*i*/ip_timestamp;
CREATE INDEX /*i*/afl_filter_timestamp_full ON /*$wgDBprefix*/abuse_filter_log (afl_global,afl_filter_id,afl_timestamp);
CREATE INDEX /*i*/afl_user_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_user,afl_user_text,afl_timestamp);
CREATE INDEX /*i*/afl_page_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_namespace, afl_title, afl_timestamp);
CREATE INDEX /*i*/afl_ip_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_ip, afl_timestamp);

File Metadata

Mime Type
text/plain
Expires
Sat, Oct 3, 20:42 (4 d, 10 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
3d/cc/90a6b18208190facafc43f648c11
Default Alt Text
patch-rename-indexes.sql (782 B)

Event Timeline