Setup SQL

Supabase Studio の SQL Editor で一度実行してください。

drop table if exists public.opennext_todos;

create table public.opennext_todos (
  id uuid primary key default gen_random_uuid(),
  user_id uuid not null default auth.uid(),
  title text not null,
  done boolean not null default false,
  created_at timestamptz not null default now()
);

alter table public.opennext_todos enable row level security;

drop policy if exists opennext_todos_select on public.opennext_todos;
drop policy if exists opennext_todos_insert on public.opennext_todos;
drop policy if exists opennext_todos_update on public.opennext_todos;
drop policy if exists opennext_todos_delete on public.opennext_todos;

create policy opennext_todos_select on public.opennext_todos
  for select to authenticated using (auth.uid() = user_id);
create policy opennext_todos_insert on public.opennext_todos
  for insert to authenticated with check (auth.uid() = user_id);
create policy opennext_todos_update on public.opennext_todos
  for update to authenticated using (auth.uid() = user_id) with check (auth.uid() = user_id);
create policy opennext_todos_delete on public.opennext_todos
  for delete to authenticated using (auth.uid() = user_id);

grant select, insert, update, delete on public.opennext_todos to authenticated;

notify pgrst, 'reload schema';