From 97efc5c6c3c7e5cae0c140ab646b8bcf517e4c95 Mon Sep 17 00:00:00 2001 From: Max Semenik Date: Sat, 25 Sep 2010 17:45:00 +0000 Subject: [PATCH] A few index-related fixes in SQLite DB patches, ping r66920. The need to drop index patch-rename-iwl_prefix.sql arose from development versions that had discrepancies between tables.sql and updater. Let's just DROP IF EXISTS it. --- maintenance/sqlite/archives/patch-kill-iwl_pft.sql | 2 +- maintenance/sqlite/archives/patch-kill-iwl_prefix.sql | 2 +- maintenance/sqlite/archives/patch-rename-iwl_prefix.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/maintenance/sqlite/archives/patch-kill-iwl_pft.sql b/maintenance/sqlite/archives/patch-kill-iwl_pft.sql index 96e1435693..b2eca40d73 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 ON /*_*/iwlinks; +DROP INDEX /*i*/iwl_prefix_from_title; diff --git a/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql b/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql index 1cd9b45416..c57b7e6505 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 ON /*_*/iwlinks; +DROP INDEX /*i*/iwl_prefix; diff --git a/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql b/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql index 0d68b0fb4b..08c3ae5f0c 100644 --- a/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql +++ b/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql @@ -1,5 +1,5 @@ -- -- Recreates the iwl_prefix for the iwlinks table -- -DROP INDEX /*i*/iwl_prefix; +DROP INDEX IF EXISTS /*i*/iwl_prefix; CREATE INDEX /*i*/iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from, iwl_title); \ No newline at end of file -- 2.20.1