maintenance/archives/patch-img_sha1.sql

   1 -- Add img_sha1, oi_sha1 and related indexes
   2 ALTER TABLE /*$wgDBprefix*/image
   3   ADD COLUMN img_sha1 varbinary(32) NOT NULL default '',
   4   ADD INDEX img_sha1 (img_sha1(10));
   5
   6 ALTER TABLE /*$wgDBprefix*/oldimage
   7   ADD COLUMN oi_sha1 varbinary(32) NOT NULL default '',
   8   ADD INDEX oi_sha1 (oi_sha1(10));