Something went wrong. Try again.
Live STIB-MIVB departures on the Pebble Time 2. It covers the bus, tram, and metro network of Brussels
Something went wrong. Try again.
762 B · 18 lines
SQL
at main
12345678910111213141516171819CREATE TABLE route_variant_stop_v4 ( variant_id INTEGER NOT NULL REFERENCES route_variant(id), ordinal INTEGER NOT NULL, external_id TEXT NOT NULL, place_id INTEGER REFERENCES place(id), PRIMARY KEY (variant_id, ordinal));INSERT INTO route_variant_stop_v4(variant_id, ordinal, external_id, place_id)SELECT variant_stop.variant_id, variant_stop.ordinal, place.external_id, variant_stop.place_idFROM route_variant_stop AS variant_stopJOIN place ON place.id = variant_stop.place_id;DROP TABLE route_variant_stop;ALTER TABLE route_variant_stop_v4 RENAME TO route_variant_stop;CREATE INDEX route_variant_by_placeON route_variant_stop(place_id, variant_id);UPDATE schema_metaSET version = 4, applied_at = unixepoch('subsec') * 1000;