summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-07-08 20:09:10 -0400
committerJune McEnroe <june@causal.agency>2020-07-08 20:09:10 -0400
commit756e5c63dab8a29cab9e1b438c23e4bb029505d0 (patch)
tree05d75c9f9595995ac902ff7e41d4a099ec36d058
parentAdd link to "IRC Suite" post in README (diff)
downloadlitterbox-756e5c63dab8a29cab9e1b438c23e4bb029505d0.tar.gz
litterbox-756e5c63dab8a29cab9e1b438c23e4bb029505d0.zip
Delay creating eventsTime index when migration from v2 1.4
-rw-r--r--database.h5
1 files changed, 4 insertions, 1 deletions
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;
 	),
 };