讀書計畫表 V0.8

在 Supabase SQL Editor 執行以下內容。資料在瀏覽器加密後才上傳。

create table if not exists public.study_planner_sync (
  room_id text primary key,
  payload jsonb not null,
  updated_at timestamptz not null default now()
);
alter table public.study_planner_sync enable row level security;
grant select, insert, update on public.study_planner_sync to anon;
drop policy if exists "planner read" on public.study_planner_sync;
drop policy if exists "planner insert" on public.study_planner_sync;
drop policy if exists "planner update" on public.study_planner_sync;
create policy "planner read" on public.study_planner_sync for select to anon using (true);
create policy "planner insert" on public.study_planner_sync for insert to anon with check (true);
create policy "planner update" on public.study_planner_sync for update to anon using (true) with check (true);