The Open
Championship

-- Run this in your Supabase SQL Editor
create table if not exists draft_state (
  id text primary key default 'main',
  players jsonb default '[]',
  draft_order jsonb default '[]',
  picks jsonb default '[]',
  current_pick int default 0,
  draft_started boolean default false,
  draft_complete boolean default false,
  pool_name text default '2026 The Open Championship Pool',
  drafter_names jsonb default '["Player 1","Player 2","Player 3"]',
  updated_at timestamptz default now()
);
insert into draft_state (id) values ('main') on conflict do nothing;

alter table draft_state enable row level security;
create policy "public_all" on draft_state for all using (true) with check (true);