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 t/?h=1.0'>summary refs log tree commit diff
path: root/spawn.8 (unfollow)
Commit message (Expand)Author
2020-08-14Implement serviceSignal, serviceStop, serviceRestartJune McEnroe
2020-08-14Reset restartInterval and restartDeadline on startJune McEnroe
2020-08-14Switch to timespec for timeoutsJune McEnroe
2020-08-14Implement serviceStartJune McEnroe
2020-08-14Flesh out Service structJune McEnroe
2020-08-14Build environment for servicesJune McEnroe
2020-08-14Implement spawntab parsingJune McEnroe
2020-08-14Open syslog, daemonize, write PIDJune McEnroe
2020-08-14Implement user and group lookupJune McEnroe
2020-08-14Add install targetJune McEnroe
2020-08-14Add spawnd skeletonJune McEnroe