From 2635ee9a323b1bded5ed8d1430079158fa1133dd Mon Sep 17 00:00:00 2001 From: Chad Horohoe Date: Wed, 3 Nov 2010 12:41:46 +0000 Subject: [PATCH] Fix r69721: SQLite yells at you if you try to drop an index that doesn't exist; which might be the case considering how many times these indexes were renamed and dropped. Per r73758, put IF EXISTS on them--it certainly can't hurt. --- maintenance/sqlite/archives/patch-kill-iwl_pft.sql | 2 +- maintenance/sqlite/archives/patch-kill-iwl_prefix.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/sqlite/archives/patch-kill-iwl_pft.sql b/maintenance/sqlite/archives/patch-kill-iwl_pft.sql index b2eca40d73..8fc4b5cd67 100644 --- a/maintenance/sqlite/archives/patch-kill-iwl_pft.sql +++ b/maintenance/sqlite/archives/patch-kill-iwl_pft.sql @@ -3,5 +3,5 @@ -- installs if they ran update.php between it being added and being renamed -- -DROP INDEX /*i*/iwl_prefix_from_title; +DROP INDEX IF EXISTS /*i*/iwl_prefix; diff --git a/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql b/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql index c57b7e6505..78ed385eb2 100644 --- a/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql +++ b/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql @@ -3,5 +3,5 @@ -- installs if they ran update.php between it being added and being renamed -- -DROP INDEX /*i*/iwl_prefix; +DROP INDEX IF EXISTS /*i*/iwl_prefix; -- 2.20.1