diff options
| author | Daniel Friesel <derf@finalrewind.org> | 2015-03-20 20:52:30 +0100 |
|---|---|---|
| committer | Daniel Friesel <derf@finalrewind.org> | 2015-03-20 20:52:30 +0100 |
| commit | 8be2d410ea3e33fcb7447414672eea8b578470d2 (patch) | |
| tree | c9a216fea0fd08fd9b883ce4db44acec6bf7776a | |
| parent | 9793758e78db391e82139641f7f41a661332e4fc (diff) | |
sqlite-migration: create table with time zone (time zones are hard!)
| -rwxr-xr-x | bin/sqlite-migration | 2 |
1 files changed, 1 insertions, 1 deletions
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), |