From 2f7669a5202acd65f0316b0a3d9f4731b0f062bd Mon Sep 17 00:00:00 2001 From: Daniel Friesel Date: Mon, 12 Dec 2022 20:21:44 +0100 Subject: database IRIS sync: update ds100, name, lat, lon from IRIS DB --- lib/Travelynx/Command/database.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 ) { -- cgit v1.2.3