| Index: trunk/phase3/maintenance/archives/patch-oi_metadata.sql |
| — | — | @@ -8,7 +8,7 @@ |
| 9 | 9 | ALTER TABLE /*$wgDBprefix*/oldimage |
| 10 | 10 | DROP INDEX oi_name, |
| 11 | 11 | ADD INDEX oi_name_timestamp (oi_name,oi_timestamp), |
| 12 | | - ADD INDEX oi_name_archive_name (oi_name,oi_archive_name), |
| | 12 | + ADD INDEX oi_name_archive_name (oi_name,oi_archive_name(14)), |
| 13 | 13 | ADD oi_metadata mediumblob NOT NULL, |
| 14 | 14 | ADD oi_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, |
| 15 | 15 | ADD oi_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") NOT NULL default "unknown", |