Fix for CR comments on r51627: fix the log_search table if it was created between...

diff --git a/maintenance/archives/patch-log_search-rename-index.sql b/maintenance/archives/patch-log_search-rename-index.sql
new file mode 100644 (file)
index 0000000..41e051d
--- /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 ab0a0ce..ab84361 100644 (file)
--- 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(