Add body weight logging with diff tracking

1 files changed, 10 insertions, 0 deletions

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);
 """