Installatør-anmeldelser

Opsætning af anmeldelser (Supabase)

For at aktivere anmeldelser skal du oprette en Supabase-database med denne tabel:

create table installer_reviews (
  id uuid default gen_random_uuid() primary key,
  installer_name text not null,
  region text not null,
  category text not null default 'Varmepumper',
  rating int not null check (rating >= 1 and rating <= 5),
  title text not null,
  body text not null,
  author_name text not null,
  created_at timestamptz default now(),
  verified boolean default false
);

-- Enable Row Level Security
alter table installer_reviews enable row level security;

-- Allow anyone to read verified reviews
create policy "Public can read verified reviews"
  on installer_reviews for select
  using (verified = true);

-- Allow anyone to insert (moderation via verified flag)
create policy "Anyone can submit reviews"
  on installer_reviews for insert
  with check (true);

Tilføj derefter dine Supabase-nøgler til .env.local: NEXT_PUBLIC_SUPABASE_URL og NEXT_PUBLIC_SUPABASE_ANON_KEY