diff options
| author | Daniel Friesel <derf@finalrewind.org> | 2022-12-12 20:21:44 +0100 |
|---|---|---|
| committer | Daniel Friesel <derf@finalrewind.org> | 2022-12-12 20:21:44 +0100 |
| commit | 2f7669a5202acd65f0316b0a3d9f4731b0f062bd (patch) | |
| tree | c72e1f47a19991900a8f3b52fdc2ea95d356646f | |
| parent | 54c46ac9f0c8209f9b1e99c67619a3a82b82ff6a (diff) | |
database IRIS sync: update ds100, name, lat, lon from IRIS DB1.28.4
| -rw-r--r-- | lib/Travelynx/Command/database.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/Travelynx/Command/database.pm b/lib/Travelynx/Command/database.pm index 172d3c1..e9cffa8 100644 --- a/lib/Travelynx/Command/database.pm +++ b/lib/Travelynx/Command/database.pm @@ -1224,7 +1224,7 @@ sub sync_stations { }, { on_conflict => \ - '(eva) do update set archived = false, source = 0' +'(eva) do update set archived = false, source = 0, ds100 = EXCLUDED.ds100, name=EXCLUDED.name, lat=EXCLUDED.lat, lon=EXCLUDED.lon' } ); if ( $count++ % 1000 == 0 ) { |