Settings

-- Create single-row settings store
create table if not exists public.admin_settings (
  id int primary key default 1,
  updated_at timestamptz not null default now(),
  settings jsonb not null default '{}'::jsonb
);

-- Ensure single-row behavior (optional)
create unique index if not exists admin_settings_singleton on public.admin_settings ((id));

-- Seed row
insert into public.admin_settings (id, settings)
values (1, '{}'::jsonb)
on conflict (id) do nothing;

-- RLS (adjust to your admin policy)
alter table public.admin_settings enable row level security;

-- Example permissive policy (NOT recommended for public sites)
-- create policy "read admin_settings" on public.admin_settings for select using (true);
-- create policy "write admin_settings" on public.admin_settings for insert with check (true);
-- create policy "update admin_settings" on public.admin_settings for update using (true);