diff options
Diffstat (limited to 'maintenance/sqlite/archives')
| -rw-r--r-- | maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql | 3 | ||||
| -rw-r--r-- | maintenance/sqlite/archives/patch-rename-iwl_prefix.sql | 2 |
2 files changed, 4 insertions, 1 deletions
diff --git a/maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql b/maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql new file mode 100644 index 00000000..0f3e9c7f --- /dev/null +++ b/maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql @@ -0,0 +1,3 @@ +-- Used for killing the wrong index added during SVN for 1.17 +-- Won't affect most people, but it doesn't need to exist +DROP INDEX IF EXISTS ar_page_revid;
\ No newline at end of file diff --git a/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql b/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql index 08c3ae5f..851a6b37 100644 --- a/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql +++ b/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql @@ -2,4 +2,4 @@ -- Recreates the iwl_prefix for the iwlinks table -- 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 +CREATE INDEX IF NOT EXISTS /*i*/iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from, iwl_title); |