From: Paladox <thomasmulhall410@yahoo.com>
Date: Sat, 8 Oct 2016 15:08:29 +0000 (+0100)
Subject: Drop index oi_name_archive_name on table oldimage
X-Git-Tag: 1.31.0-rc.0~3823^2
X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fwiklou.git;a=commitdiff_plain;h=5473e9e9eeea71b0a32b2b0e703529e196721407;hp=-c

Drop index oi_name_archive_name on table oldimage

Bug: T145635
Change-Id: I7d1c534ec69bfac7d63514993d3f8429a6121592
---

5473e9e9eeea71b0a32b2b0e703529e196721407
diff --git a/includes/installer/MssqlUpdater.php b/includes/installer/MssqlUpdater.php
index 968ee15dba..988ec41ace 100644
--- a/includes/installer/MssqlUpdater.php
+++ b/includes/installer/MssqlUpdater.php
@@ -97,6 +97,8 @@ class MssqlUpdater extends DatabaseUpdater {
 
 			// 1.29
 			[ 'addField', 'externallinks', 'el_index_60', 'patch-externallinks-el_index_60.sql' ],
+			[ 'dropIndex', 'oldimage', 'oi_name_archive_name',
+				'patch-alter-table-oldimage.sql' ],
 		];
 	}
 
diff --git a/maintenance/mssql/archives/patch-alter-table-oldimage.sql b/maintenance/mssql/archives/patch-alter-table-oldimage.sql
new file mode 100644
index 0000000000..fb31d6ae5f
--- /dev/null
+++ b/maintenance/mssql/archives/patch-alter-table-oldimage.sql
@@ -0,0 +1 @@
+DROP INDEX /*i*/oi_name_archive_name ON /*_*/oldimage;
diff --git a/maintenance/mssql/tables.sql b/maintenance/mssql/tables.sql
index ba1f752b72..ddc37baeee 100644
--- a/maintenance/mssql/tables.sql
+++ b/maintenance/mssql/tables.sql
@@ -659,7 +659,6 @@ CREATE TABLE /*_*/oldimage (
 
 CREATE INDEX /*i*/oi_usertext_timestamp ON /*_*/oldimage (oi_user_text,oi_timestamp);
 CREATE INDEX /*i*/oi_name_timestamp ON /*_*/oldimage (oi_name,oi_timestamp);
-CREATE INDEX /*i*/oi_name_archive_name ON /*_*/oldimage (oi_name,oi_archive_name);
 CREATE INDEX /*i*/oi_sha1 ON /*_*/oldimage (oi_sha1);