From 784fd31562f927647f3509fcb3fd9b463a4adc63 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Micha=C5=82=20Socho=C5=84?= Date: Thu, 14 Jan 2021 20:53:54 +0100 Subject: [PATCH] Update upgrade_000_create_buffer_idx.sql Create index if it does not exist already, some people have it applied prior doing upgrades. --- .../SQL/SQLite/version/26/upgrade_000_create_buffer_idx.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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) -- 2.20.1