MediaWiki 1.30.2

[autoinstallsdev/mediawiki.git] / maintenance / archives / patch-revision-page-rev-index-nonunique.sql

diff --git a/maintenance/archives/patch-revision-page-rev-index-nonunique.sql b/maintenance/archives/patch-revision-page-rev-index-nonunique.sql
new file mode 100644 (file)
index 0000000..dbb0325
--- /dev/null
+++ b/maintenance/archives/patch-revision-page-rev-index-nonunique.sql
@@ -0,0 +1,5 @@
+-- Makes rev_page_id index non-unique
+ALTER TABLE /*_*/revision
+DROP INDEX /*i*/rev_page_id;
+
+CREATE INDEX /*i*/rev_page_id ON /*_*/revision (rev_page, rev_id);