Index: branches/extensionless-files/maintenance/archives/patch-img_file_ext.sql |
— | — | @@ -0,0 +1,20 @@ |
| 2 | +-- media type columns, added for 1.16 |
| 3 | +-- this alters the scheme for 1.16, img_type is no longer used. |
| 4 | + |
| 5 | +ALTER TABLE /*$wgDBprefix*/image ADD ( |
| 6 | + -- File extension, appended to the on-disk file in cases where the |
| 7 | + -- extension derived from img_name doesn't match the media type of |
| 8 | + -- the file. See bug #4421. |
| 9 | + img_file_ext varchar(32) binary NOT NULL default '' |
| 10 | +); |
| 11 | + |
| 12 | +ALTER TABLE /*$wgDBprefix*/oldimage ADD ( |
| 13 | + -- oldimage table counterpart of img_file_ext |
| 14 | + oi_file_ext varchar(32) binary NOT NULL default '' |
| 15 | +); |
| 16 | + |
| 17 | +ALTER TABLE /*$wgDBprefix*/filearchive ADD ( |
| 18 | + -- filearchive table counterpart of img_file_ext |
| 19 | + fa_file_ext varchar(32) binary NOT NULL default '' |
| 20 | +); |
| 21 | + |