ALTER TABLE user_weekly_plans ADD COLUMN IF NOT EXISTS coach_note TEXT;

ALTER TABLE profiles
  ADD COLUMN IF NOT EXISTS level        text,
  ADD COLUMN IF NOT EXISTS goal         text,
  ADD COLUMN IF NOT EXISTS height       numeric,
  ADD COLUMN IF NOT EXISTS body_photo_1 text,
  ADD COLUMN IF NOT EXISTS body_photo_2 text,
  ADD COLUMN IF NOT EXISTS body_photo_3 text;

CREATE TABLE IF NOT EXISTS user_nutrition_plans (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id uuid REFERENCES auth.users(id) ON DELETE CASCADE,
  content text NOT NULL,
  is_active boolean NOT NULL DEFAULT true,
  created_at timestamptz NOT NULL DEFAULT now()
);