create table users (
  id uuid primary key default gen_random_uuid(),
  name text not null, password text not null,
  role text not null default 'athlete',
  photo text, birth date, club text, kelas text,
  created_at timestamptz default now()
);
create table records (
  id uuid primary key default gen_random_uuid(),
  user_id uuid references users(id) on delete cascade,
  cat text, time bigint, date date, note text,
  created_at timestamptz default now()
);
create table achievements (
  id uuid primary key default gen_random_uuid(),
  user_id uuid references users(id) on delete cascade,
  event_name text, rank text, year text,
  cat text, kelas text, pdf_data text,
  created_at timestamptz default now()
);
alter table users enable row level security;
alter table records enable row level security;
alter table achievements enable row level security;
create policy "allow_all" on users for all using (true) with check (true);
create policy "allow_all" on records for all using (true) with check (true);
create policy "allow_all" on achievements for all using (true) with check (true);