MediaWiki 1.16.0

[autoinstallsdev/mediawiki.git] / 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 (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);
+