-- Weight Log Table for periodic weight tracking
CREATE TABLE IF NOT EXISTS weight_log (
  id TEXT PRIMARY KEY,
  user_email TEXT NOT NULL,
  weight_kg DECIMAL(5,2) NOT NULL,
  logged_date DATE NOT NULL,
  notes TEXT DEFAULT '',
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX IF NOT EXISTS idx_wl_user_date ON weight_log(user_email, logged_date);