From d840f82c1087cd7354022ef239168b0ab0b64cd8 Mon Sep 17 00:00:00 2001 From: Chad Horohoe Date: Thu, 26 Jun 2008 20:41:40 +0000 Subject: [PATCH] Undo previous commit. Schema changes are a no-no without permission first :-) --- maintenance/archives/patch-index-img_mime.sql | 6 ------ maintenance/tables.sql | 6 ++---- maintenance/updaters.inc | 1 - 3 files changed, 2 insertions(+), 11 deletions(-) delete mode 100644 maintenance/archives/patch-index-img_mime.sql diff --git a/maintenance/archives/patch-index-img_mime.sql b/maintenance/archives/patch-index-img_mime.sql deleted file mode 100644 index f808e1a518..0000000000 --- a/maintenance/archives/patch-index-img_mime.sql +++ /dev/null @@ -1,6 +0,0 @@ --- Indexing MIME types --- --- Allows MIME search to work on large databases like Wikimedia one - -ALTER TABLE /*$wgDBprefix*/image - ADD INDEX img_mime (img_major_mime, img_minor_mime); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index d717dcc48b..5b83983d99 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -745,11 +745,9 @@ CREATE TABLE /*$wgDBprefix*/image ( INDEX img_size (img_size), -- Used by Special:Newimages and Special:Imagelist INDEX img_timestamp (img_timestamp), - -- Used in API and duplicate search - INDEX img_sha1 (img_sha1), - -- Used in MIME search - INDEX img_mime (img_major_mime, img_minor_mime) + -- For future use + INDEX img_sha1 (img_sha1) ) /*$wgDBTableOptions*/; diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 8f5ffbbc88..c83893b2dc 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -143,7 +143,6 @@ $wgMysqlUpdates = array( array( 'maybe_do_profiling_memory_update' ), array( 'do_filearchive_indices_update' ), array( 'update_password_format' ), - array( 'add_index', 'image', 'img_mime', 'patch-index-img_mime.sql' ), ); -- 2.20.1