summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-img_sha1.sql
blob: 0a375c4ffc4f89c5d6ab96bc9febd7d9452b61d4 (plain)
1
2
3
4
5
6
7
8
-- Add img_sha1, oi_sha1 and related indexes
ALTER TABLE /*$wgDBprefix*/image
  ADD COLUMN img_sha1 varbinary(32) NOT NULL default '',
  ADD INDEX img_sha1 (img_sha1(10));

ALTER TABLE /*$wgDBprefix*/oldimage
  ADD COLUMN oi_sha1 varbinary(32) NOT NULL default '',
  ADD INDEX oi_sha1 (oi_sha1(10));