X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-img_sha1.sql;h=0a375c4ffc4f89c5d6ab96bc9febd7d9452b61d4;hb=9e331cd4c3c13bce12bbd6f5ab24ce8c0016e3bb;hp=36f93b3664c0974e677db505015728637ef62eaa;hpb=5d1bf41015dbd21453f50d6fb1357f68908165d0;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/archives/patch-img_sha1.sql b/maintenance/archives/patch-img_sha1.sql index 36f93b3664..0a375c4ffc 100644 --- a/maintenance/archives/patch-img_sha1.sql +++ b/maintenance/archives/patch-img_sha1.sql @@ -1,8 +1,8 @@ -- Add img_sha1, oi_sha1 and related indexes ALTER TABLE /*$wgDBprefix*/image - ADD COLUMN img_sha1 varbinary(31) NOT NULL default '', - ADD INDEX img_sha1 (img_sha1); + 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(31) NOT NULL default '', - ADD INDEX oi_sha1 (oi_sha1); + ADD COLUMN oi_sha1 varbinary(32) NOT NULL default '', + ADD INDEX oi_sha1 (oi_sha1(10));