diff options
| -rw-r--r-- | database.h | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/database.h b/database.h index a701a9d..a0cba04 100644 --- a/database.h +++ b/database.h @@ -42,7 +42,7 @@ #define DATABASE_PATH "litterbox/litterbox.sqlite" -enum { DatabaseVersion = 2 }; +enum { DatabaseVersion = 3 }; #define ENUM_TYPE \ X(Privmsg, "privmsg") \ @@ -282,6 +282,7 @@ static const char *InitSQL = SQL( target TEXT, message TEXT ); + CREATE INDEX eventsTime ON events (time); CREATE VIEW text ( event, network, channel, query, nick, user, target, message @@ -322,7 +323,7 @@ static const char *InitSQL = SQL( UNIQUE (host, port) ); - PRAGMA user_version = 2; + PRAGMA user_version = 3; COMMIT TRANSACTION; ); @@ -357,6 +358,11 @@ static const char *MigrationSQL[] = { ); PRAGMA user_version = 2; ), + + SQL( + CREATE INDEX eventsTime ON events (time); + PRAGMA user_version = 3; + ), }; static inline void dbMigrate(void) { |