commit 62abf675b44c0508a225bcd243e72231f6ba8695 parent 98c1f18bd96da593e9a543d114d5a5ab6a87f8ee Author: Silas Brack <silasbrack@gmail.com> Date: Sun, 7 Jun 2026 23:07:39 +0200 fix: use IF NOT EXISTS in index migration Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com> Diffstat:
| M | traildepot/migrations/main/U104__story_indices.sql | | | 4 | ++-- |
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/traildepot/migrations/main/U104__story_indices.sql b/traildepot/migrations/main/U104__story_indices.sql @@ -1,2 +1,2 @@ -CREATE INDEX idx_story_published ON story (published DESC); -CREATE INDEX idx_story_score ON story (score DESC, published DESC); +CREATE INDEX IF NOT EXISTS idx_story_published ON story (published DESC); +CREATE INDEX IF NOT EXISTS idx_story_score ON story (score DESC, published DESC);