summary refs log tree commit diff
diff options
context:
space:
mode:
Diffstat (limited to '')
-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;
 	),
 };
commit/Makefile?id=6952f164c10689e3c112dbef85e461a6246654be&follow=1'>makefile: bump versionJason A. Donenfeld 2014-01-17mailmap: source before lighttpdJason A. Donenfeld 2014-01-17ui-shared: do not allow negative minutesJason A. Donenfeld 2014-01-17auth: document tweakables in lua scriptJason A. Donenfeld 2014-01-17repolist: make owner clickable to searchJason A. Donenfeld 2014-01-17ui-shared: move about tab all the way to the leftJason A. Donenfeld 2014-01-17filter: don't forget to reap the auth filterJason A. Donenfeld 2014-01-17cgit.c: free tmp variableJason A. Donenfeld 2014-01-17Switch to exclusively using global ctxLukas Fleischer 2014-01-16auth: have cgit calculate login addressJason A. Donenfeld 2014-01-16auth: lua string comparisons are time invariantJason A. Donenfeld 2014-01-16authentication: use hidden form instead of refererJason A. Donenfeld 2014-01-16auth: add basic authentication filter frameworkJason A. Donenfeld 2014-01-16t0111: Additions and fixesLukas Fleischer 2014-01-16parsing.c: Remove leading space from committerLukas Fleischer