about summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-07-11 14:23:51 -0400
committerJune McEnroe <june@causal.agency>2020-07-11 14:23:51 -0400
commit6c82c1e785847986d9adda4fc4c3d637f94d37fe (patch)
treee69bc70a43911122fa7d40875d7d52a7fe7d38be
parentDelay creating eventsTime index when migration from v2 (diff)
downloadlitterbox-6c82c1e785847986d9adda4fc4c3d637f94d37fe.tar.gz
litterbox-6c82c1e785847986d9adda4fc4c3d637f94d37fe.zip
Replace time index with (context, time) index 1.4p1
This is what it should have been...
-rw-r--r--database.h16
1 files changed, 12 insertions, 4 deletions
diff --git a/database.h b/database.h
index e2d52ff..46679f5 100644
--- a/database.h
+++ b/database.h
@@ -42,7 +42,7 @@
 
 #define DATABASE_PATH "litterbox/litterbox.sqlite"
 
-enum { DatabaseVersion = 4 };
+enum { DatabaseVersion = 5 };
 
 #define ENUM_TYPE \
 	X(Privmsg, "privmsg") \
@@ -282,7 +282,7 @@ static const char *InitSQL = SQL(
 		target TEXT,
 		message TEXT
 	);
-	CREATE INDEX eventsTime ON events (time);
+	CREATE INDEX eventsContextTime ON events (context, time);
 
 	CREATE VIEW text (
 		event, network, channel, query, nick, user, target, message
@@ -323,7 +323,7 @@ static const char *InitSQL = SQL(
 		UNIQUE (host, port)
 	);
 
-	PRAGMA user_version = 4;
+	PRAGMA user_version = 5;
 
 	COMMIT TRANSACTION;
 );
@@ -370,9 +370,17 @@ 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);
+		// Don't bother creating the index that will be immediately dropped in
+		// version 5.
+		// CREATE INDEX IF NOT EXISTS eventsTime ON events (time);
 		PRAGMA user_version = 4;
 	),
+
+	SQL(
+		DROP INDEX IF EXISTS eventsTime;
+		CREATE INDEX eventsContextTime ON events (context, time);
+		PRAGMA user_version = 5;
+	),
 };
 
 static inline void dbMigrate(void) {