From 8be2d410ea3e33fcb7447414672eea8b578470d2 Mon Sep 17 00:00:00 2001 From: Daniel Friesel Date: Fri, 20 Mar 2015 20:52:30 +0100 Subject: sqlite-migration: create table with time zone (time zones are hard!) --- bin/sqlite-migration | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bin/sqlite-migration b/bin/sqlite-migration index 4ccceec..4f12b18 100755 --- a/bin/sqlite-migration +++ b/bin/sqlite-migration @@ -124,7 +124,7 @@ if ( not table_exists('departures') ) { create table departures ( train_id bigint not null, station integer not null references station_codes (id), - scheduled_time timestamp (0) not null, + scheduled_time timestamp (0) with time zone not null, delay smallint, is_canceled boolean, destination integer not null references stations (id), -- cgit v1.2.3