From 7ecba24a3383d4e331c812b0dcd57bc7bf565713 Mon Sep 17 00:00:00 2001 From: Thomas Vanbesien Date: Wed, 18 Mar 2026 15:26:22 +0100 Subject: Add body weight logging with diff tracking --- db.py | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'db.py') diff --git a/db.py b/db.py index a5f3250..a7be976 100644 --- a/db.py +++ b/db.py @@ -59,6 +59,16 @@ CREATE INDEX IF NOT EXISTS idx_workout_sessions_date CREATE INDEX IF NOT EXISTS idx_workout_template_exercises_template ON workout_template_exercises(template_id); + +CREATE TABLE IF NOT EXISTS weight_logs ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + date_time TEXT NOT NULL, + weight REAL NOT NULL, + note TEXT +); + +CREATE INDEX IF NOT EXISTS idx_weight_logs_date + ON weight_logs(date_time); """ -- cgit v1.2.3