aboutsummaryrefslogtreecommitdiff
path: root/db/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql5
1 files changed, 3 insertions, 2 deletions
diff --git a/db/schema.sql b/db/schema.sql
index 48bd02f..8995098 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -40,7 +40,7 @@ CREATE TABLE ride_official_climb_attempts (
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')),
+ created_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')), average_power_w real,
primary key (ride_id, climb_id, occurrence)
);
CREATE TABLE IF NOT EXISTS "official_climbs" (
@@ -71,4 +71,5 @@ INSERT INTO "schema_migrations" (version) VALUES
('20260831000000'),
('20260913000000'),
('20260924000000'),
- ('20260925000000');
+ ('20260925000000'),
+ ('20260925061236');