From c117b604e120a5ac3cde9130e427ec95ac1e180c Mon Sep 17 00:00:00 2001 From: Tim Starling Date: Mon, 2 Jul 2007 16:33:23 +0000 Subject: [PATCH] Bug 10435: oi_name_archive_name index length overflow --- maintenance/archives/patch-oi_metadata.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/maintenance/archives/patch-oi_metadata.sql b/maintenance/archives/patch-oi_metadata.sql index 6f22e87127..c8e25493d5 100644 --- a/maintenance/archives/patch-oi_metadata.sql +++ b/maintenance/archives/patch-oi_metadata.sql @@ -8,7 +8,7 @@ ALTER TABLE /*$wgDBprefix*/oldimage DROP INDEX oi_name, ADD INDEX oi_name_timestamp (oi_name,oi_timestamp), - ADD INDEX oi_name_archive_name (oi_name,oi_archive_name), + ADD INDEX oi_name_archive_name (oi_name,oi_archive_name(14)), ADD oi_metadata mediumblob NOT NULL, ADD oi_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, ADD oi_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") NOT NULL default "unknown", -- 2.20.1