summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-archive-user-index.sql
blob: 62baa2ddc25341273f58180093d42ae2501d74f7 (plain)
1
2
3
4
-- Adds a user,timestamp index to the archive table
-- Used for browsing deleted contributions and renames
ALTER TABLE /*$wgDBprefix*/archive 
	ADD INDEX usertext_timestamp ( ar_user_text , ar_timestamp );