From: Michał Sochoń <kaszpir@gmail.com>
Date: Thu, 14 Jan 2021 19:53:54 +0000 (+0100)
Subject: Update upgrade_000_create_buffer_idx.sql
X-Git-Tag: 0.14-rc2~31
X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=commitdiff_plain;h=784fd31562f927647f3509fcb3fd9b463a4adc63

Update upgrade_000_create_buffer_idx.sql

Create index if it does not exist already, some people have it applied prior doing upgrades.
---

diff --git a/src/core/SQL/SQLite/version/26/upgrade_000_create_buffer_idx.sql b/src/core/SQL/SQLite/version/26/upgrade_000_create_buffer_idx.sql
index 35146b19..3b693888 100644
--- a/src/core/SQL/SQLite/version/26/upgrade_000_create_buffer_idx.sql
+++ b/src/core/SQL/SQLite/version/26/upgrade_000_create_buffer_idx.sql
@@ -1 +1 @@
-CREATE INDEX backlog_buffer_msg_idx ON backlog (bufferid, messageid)
+CREATE INDEX IF NOT EXISTS backlog_buffer_msg_idx ON backlog (bufferid, messageid)