From f0d3466268ad5f25221ef9cc3538a47159e8d66f Mon Sep 17 00:00:00 2001 From: Tim Starling Date: Sun, 16 Aug 2009 04:41:00 +0000 Subject: [PATCH] Fix for CR comments on r51627: fix the log_search table if it was created between r50567 and r51465, with an incorrect index name. There's no significant performance penalty in checking for this in release versions. --- maintenance/archives/patch-log_search-rename-index.sql | 7 +++++++ maintenance/updaters.inc | 1 + 2 files changed, 8 insertions(+) create mode 100644 maintenance/archives/patch-log_search-rename-index.sql diff --git a/maintenance/archives/patch-log_search-rename-index.sql b/maintenance/archives/patch-log_search-rename-index.sql new file mode 100644 index 0000000000..41e051d865 --- /dev/null +++ b/maintenance/archives/patch-log_search-rename-index.sql @@ -0,0 +1,7 @@ +-- Rename the primary unique index from PRIMARY to ls_field_val +-- This is for MySQL only and is necessary only for databases which were updated +-- between MW 1.16 development revisions r50567 and r51465. +ALTER TABLE /*_*/log_search + DROP PRIMARY KEY, + ADD UNIQUE INDEX ls_field_val (ls_field,ls_value,ls_log_id); + diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index ab0a0cec5e..ab8436106e 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -162,6 +162,7 @@ $wgUpdates = array( array( 'add_field', 'logging', 'log_user_text', 'patch-log_user_text.sql' ), array( 'add_table', 'l10n_cache', 'patch-l10n_cache.sql' ), array( 'add_table', 'external_user', 'patch-external_user.sql' ), + array( 'add_index', 'log_search', 'ls_field_val', 'patch-log_search-rename-index.sql' ), ), 'sqlite' => array( -- 2.20.1