1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
CREATE TABLE IF NOT EXISTS "schema_migrations" (version varchar(255) primary key);
CREATE TABLE mountain_passes (
id integer primary key,
external_id text unique not null,
name text not null,
country_code text not null,
department_code text not null,
elevation integer not null
, latitude real, longitude real);
CREATE TABLE osm_passes (
id integer primary key,
osm_id integer unique not null,
name text,
elevation integer,
latitude real not null,
longitude real not null
);
CREATE TABLE rides (
id integer primary key,
external_id text unique not null,
gpx_path text not null,
name text not null,
type text not null,
start_date text not null,
distance_m real not null,
moving_time_s integer not null,
elapsed_time_s integer not null,
total_elevation_gain_m real not null,
average_speed_mps real not null,
created_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
updated_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now'))
, cotacol_score real, cotacol_algo_version text);
CREATE TABLE official_climbs (
id integer primary key,
name text not null,
start_latitude real not null,
start_longitude real not null,
end_latitude real not null,
end_longitude real not null,
created_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
updated_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now'))
);
-- Dbmate schema migrations
INSERT INTO "schema_migrations" (version) VALUES
('20250802140659'),
('20260802090000'),
('20260804000000'),
('20260807000000'),
('20260813000000');
|