diff options
| author | June McEnroe <june@causal.agency> | 2020-07-08 20:09:10 -0400 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2020-07-08 20:09:10 -0400 |
| commit | 756e5c63dab8a29cab9e1b438c23e4bb029505d0 (patch) | |
| tree | 05d75c9f9595995ac902ff7e41d4a099ec36d058 | |
| parent | Add link to "IRC Suite" post in README (diff) | |
| download | litterbox-756e5c63dab8a29cab9e1b438c23e4bb029505d0.tar.gz litterbox-756e5c63dab8a29cab9e1b438c23e4bb029505d0.zip | |
Delay creating eventsTime index when migration from v2 1.4
| -rw-r--r-- | database.h | 5 |
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; ), }; |