-- Run in Supabase SQL editor:
create table athletes (
  id uuid primary key default gen_random_uuid(),
  name text not null,
  current_week integer default 1,
  program_template text default 'level4',
  pin text default null,
  created_at timestamptz default now()
);
create table workout_logs (
  id uuid primary key default gen_random_uuid(),
  athlete_id uuid references athletes(id) on delete cascade,
  week integer not null,
  day integer not null,
  exercise_index integer not null,
  completed boolean default false,
  weights jsonb default '[]',
  notes text default '',
  updated_at timestamptz default now()
);
create table program_overrides (
  id uuid primary key default gen_random_uuid(),
  week integer not null,
  day integer not null,
  exercises jsonb not null,
  updated_at timestamptz default now(),
  unique(week, day)
);
create table athlete_overrides (
  id uuid primary key default gen_random_uuid(),
  athlete_id uuid references athletes(id) on delete cascade,
  template text not null default 'level4',
  week integer not null,
  day integer not null,
  scope text default 'week',
  exercises jsonb not null,
  updated_at timestamptz default now(),
  unique(athlete_id, template, week, day, scope)
);

-- Disable RLS on all tables (required for anon key access)
alter table athletes disable row level security;
alter table workout_logs disable row level security;
alter table program_overrides disable row level security;
alter table athlete_overrides disable row level security;