[Summary view] [Print] [Text view]

   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));