CREATE 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_id
FROM route_variant_stop AS variant_stop
JOIN 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_place
ON route_variant_stop(place_id, variant_id);
UPDATE schema_meta
SET version = 4,
    applied_at = unixepoch('subsec') * 1000;