diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-09-25 08:46:58 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-09-25 08:46:58 +0200 |
| commit | 077aa1700fbcaf3f499c2178e0e58e89ae9dcaf8 (patch) | |
| tree | 020d0d8b34ab7b47cf551b50034c1e086a247af3 /db/schema.sql | |
| parent | 90614736f2a0c556f31eca5361b3c032f5f309f6 (diff) | |
Chart power vs time for official climb attempts
Snapshot average power per attempt in a nullable average_power_w column (backfilled from stored rides), plot each powered attempt on the climb page as duration vs average watts with ride hover and click-through, and show avg power in the attempts table.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 5 |
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'); |