From 756e5c63dab8a29cab9e1b438c23e4bb029505d0 Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Wed, 8 Jul 2020 20:09:10 -0400 Subject: Delay creating eventsTime index when migration from v2 --- database.h | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/database.h b/database.h index fb59140..e2d52ff 100644 --- a/database.h +++ b/database.h @@ -360,7 +360,9 @@ static const char *MigrationSQL[] = { ), SQL( - CREATE INDEX eventsTime ON events (time); + // When migrating from version 2, wait to create index until after + // times are converted in version 4. + // CREATE INDEX eventsTime ON events (time); PRAGMA user_version = 3; ), @@ -368,6 +370,7 @@ static const char *MigrationSQL[] = { UPDATE motds SET time = strftime('%s', time); UPDATE topics SET time = strftime('%s', time); UPDATE events SET time = strftime('%s', time); + CREATE INDEX IF NOT EXISTS eventsTime ON events (time); PRAGMA user_version = 4; ), }; -- cgit 1.4.1