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
|
-- Every climb carries its segment sample, so the columns stop being optional; SQLite cannot alter nullability, hence the rebuild (it fails loudly on a missing sample).
-- migrate:up transaction:false
PRAGMA foreign_keys=OFF;
CREATE TABLE official_climbs_rebuild (
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')),
sample_distance_m real not null,
sample_elevation_gain_m real not null
);
INSERT INTO official_climbs_rebuild (id, name, start_latitude, start_longitude, end_latitude, end_longitude, created_at, updated_at, sample_distance_m, sample_elevation_gain_m)
SELECT id, name, start_latitude, start_longitude, end_latitude, end_longitude, created_at, updated_at, sample_distance_m, sample_elevation_gain_m FROM official_climbs;
DROP TABLE official_climbs;
ALTER TABLE official_climbs_rebuild RENAME TO official_climbs;
-- migrate:down transaction:false
PRAGMA foreign_keys=OFF;
CREATE TABLE official_climbs_rebuild (
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')),
sample_distance_m real,
sample_elevation_gain_m real
);
INSERT INTO official_climbs_rebuild (id, name, start_latitude, start_longitude, end_latitude, end_longitude, created_at, updated_at, sample_distance_m, sample_elevation_gain_m)
SELECT id, name, start_latitude, start_longitude, end_latitude, end_longitude, created_at, updated_at, sample_distance_m, sample_elevation_gain_m FROM official_climbs;
DROP TABLE official_climbs;
ALTER TABLE official_climbs_rebuild RENAME TO official_climbs;
|
