Something went wrong. Try again.
Sync your workout data from your "Strong" app to your own database
strong-app strongapp workout api clickhouse rust
Something went wrong. Try again.
611 B · 21 lines
SQL
at master
12345678910111213141516171819202122CREATE DATABASE IF NOT EXISTS workouts;USE workouts;
CREATE TABLE workout_sets( workout_id UUID, workout_name String, timezone String DEFAULT 'Europe/Berlin', start_date DateTime64(3) DEFAULT now(), end_date DateTime64(3) DEFAULT now(), exercise_id UUID, exercise_nr UInt32, exercise_name String, set_id UUID, set_nr UInt32, weight Float32 DEFAULT 0.0, reps UInt32, rpe Float32 DEFAULT 0.0) ENGINE = ReplacingMergeTree()ORDER BY (start_date, workout_id, exercise_nr, exercise_id, set_nr);