-- migrate:up
CREATE TABLE ride_official_climb_attempts (
    ride_id integer not null references rides(id),
    climb_id integer not null references official_climbs(id),
    occurrence integer not null,
    distance_m real not null,
    elevation_gain_m real not null,
    slope_percent real not null,
    cotacol real not null,
    cotacol_algo_version text not null,
    started_at text not null,
    ended_at text not null,
    created_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    primary key (ride_id, climb_id, occurrence)
);

-- migrate:down
DROP TABLE ride_official_climb_attempts;