create table if not exists public.site_content (
  id text primary key default 'main',
  payload jsonb not null,
  updated_at timestamptz default now()
);

create table if not exists public.guestbook_messages (
  id uuid primary key default gen_random_uuid(),
  sender_name text not null,
  sender_contact text,
  message text not null,
  status text default 'approved',
  created_at timestamptz default now()
);

alter table public.site_content enable row level security;
alter table public.guestbook_messages enable row level security;

create policy "Public can read site_content"
  on public.site_content for select using (true);

create policy "Manage site_content"
  on public.site_content for all using (true) with check (true);

create policy "Visitors can insert guestbook_messages"
  on public.guestbook_messages for insert with check (length(trim(sender_name)) > 0 and length(trim(message)) > 0);

create policy "Public can read guestbook_messages"
  on public.guestbook_messages for select using (status = 'approved' or status is null);