Přidat ropidgtfs view pro odjezdové tabule
Prosím v rámci úprav IE pro vlaky, upravit migrační skripty pro jiné issue.
UP
CREATE MATERIALIZED VIEW "v_ropidgtfs_trips_minmaxsequences" AS
SELECT ropidgtfs_stop_times.trip_id,
max(ropidgtfs_stop_times.stop_sequence) AS max_stop_sequence,
min(ropidgtfs_stop_times.stop_sequence) AS min_stop_sequence
FROM ropidgtfs_stop_times
GROUP BY ropidgtfs_stop_times.trip_id;
REFRESH MATERIALIZED VIEW "v_ropidgtfs_trips_minmaxsequences";
DOWN
DROP MATERIALIZED VIEW "v_ropidgtfs_trips_minmaxsequences";
Edited by Jan Vlasatý