Task Calendar

create table if not exists public.tasks (
  id          uuid primary key default gen_random_uuid(),
  name        text not null,
  assignee    text,
  date_given  date,
  deadline    date,
  freq_type   text default 'preset',
  freq_preset text,
  freq_number int,
  priority    text default 'medium',
  done        boolean default false,
  skip_sat    boolean default false,
  skip_sun    boolean default false,
  created_at  timestamptz default now()
);

alter table public.tasks enable row level security;

create policy "team read"   on public.tasks for select using (true);
create policy "team write"  on public.tasks for insert with check (true);
create policy "team update" on public.tasks for update using (true) with check (true);
create policy "team delete" on public.tasks for delete using (true);

create table if not exists public.holidays (
  id         uuid primary key default gen_random_uuid(),
  day        date not null unique,
  label      text,
  created_at timestamptz default now()
);
alter table public.holidays enable row level security;
create policy "h read"   on public.holidays for select using (true);
create policy "h write"  on public.holidays for insert with check (true);
create policy "h delete" on public.holidays for delete using (true);

create table if not exists public.completions (
  id         uuid primary key default gen_random_uuid(),
  task_id    uuid not null references public.tasks(id) on delete cascade,
  day        date not null,
  created_at timestamptz default now(),
  unique (task_id, day)
);
alter table public.completions enable row level security;
create policy "c read"   on public.completions for select using (true);
create policy "c write"  on public.completions for insert with check (true);
create policy "c delete" on public.completions for delete using (true);