-- Admin/manager company holidays — run once in Supabase SQL Editor

create table if not exists public.company_holidays (
  id uuid primary key default gen_random_uuid(),
  holiday_date date not null,
  note text not null,
  created_by uuid null references public.users (id) on delete set null,
  created_at timestamptz not null default now(),
  updated_at timestamptz not null default now(),
  constraint company_holidays_date_unique unique (holiday_date)
);

create index if not exists company_holidays_date_idx on public.company_holidays (holiday_date);