Matthias Mullie has uploaded a new change for review.
https://gerrit.wikimedia.org/r/277990
Change subject: Fix SQLite update issues because of duplicate indexes
......................................................................
Fix SQLite update issues because of duplicate indexes
Bug: T126587
Change-Id: I585ef8321e658bd338807f049d25ad54d728a717
---
M db_patches/patch-ref_id-phase2.sqlite.sql
1 file changed, 8 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Flow
refs/changes/90/277990/1
diff --git a/db_patches/patch-ref_id-phase2.sqlite.sql
b/db_patches/patch-ref_id-phase2.sqlite.sql
index cbfebc6..de87b46 100644
--- a/db_patches/patch-ref_id-phase2.sqlite.sql
+++ b/db_patches/patch-ref_id-phase2.sqlite.sql
@@ -4,6 +4,14 @@
ALTER TABLE /*_*/flow_wiki_ref RENAME TO /*_*/temp_flow_wiki_ref;
ALTER TABLE /*_*/flow_ext_ref RENAME TO /*_*/temp_flow_ext_ref;
+-- SQLite also doesn't allow multiple indexes with the same name (even if
+-- they're on separate tables.
+-- Since we're going to recreate these same tables with the same indexes, we
+-- first need to drop them from the other table.
+DROP INDEX /*i*/flow_wiki_ref_idx_v2;
+DROP INDEX /*i*/flow_wiki_ref_revision_v2;
+DROP INDEX /*i*/flow_ext_ref_idx_v2;
+DROP INDEX /*i*/flow_ext_ref_revision_v2;
CREATE TABLE /*_*/flow_wiki_ref (
ref_id binary(11) not null,
--
To view, visit https://gerrit.wikimedia.org/r/277990
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I585ef8321e658bd338807f049d25ad54d728a717
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Flow
Gerrit-Branch: master
Gerrit-Owner: Matthias Mullie <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
