aboutsummaryrefslogtreecommitdiffstats
path: root/sql/mysql/patch-archive-rename-name_title_timestamp-index.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/mysql/patch-archive-rename-name_title_timestamp-index.sql')
-rw-r--r--sql/mysql/patch-archive-rename-name_title_timestamp-index.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/mysql/patch-archive-rename-name_title_timestamp-index.sql b/sql/mysql/patch-archive-rename-name_title_timestamp-index.sql
new file mode 100644
index 000000000000..21d5a7fa7843
--- /dev/null
+++ b/sql/mysql/patch-archive-rename-name_title_timestamp-index.sql
@@ -0,0 +1,2 @@
+DROP INDEX name_title_timestamp ON /*_*/archive;
+CREATE INDEX ar_name_title_timestamp ON /*_*/archive (ar_namespace,ar_title,ar_timestamp);