summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-img_media_mime-index.sql
blob: bfaf84f9a6afc18d5c22934963b41445313ff0a0 (plain)
1
2
3
4
-- New index on image table to allow searches for types i.e. video webm
-- Added 2013-01-08

CREATE INDEX /*i*/img_media_mime ON /*_*/image (img_media_type,img_major_mime,img_minor_mime);