setup_registrations.sql

-- Create registration table
create table if not exists public.event_registrations (
  id uuid default gen_random_uuid() primary key,
  user_id uuid references auth.users(id) on delete cascade not null,
  event_id uuid references public.events(id) on delete cascade not null,
  created_at timestamptz default now(),
  unique(user_id, event_id)
);

-- Enable RLS
alter table public.event_registrations enable row level security;

-- Policies

-- 1. Users can register themselves
create policy "Users can register themselves"
  on public.event_registrations for insert
  with check (auth.uid() = user_id);

-- 2. Users can view their own registrations
create policy "Users can view their own registrations"
  on public.event_registrations for select
  using (auth.uid() = user_id);

-- 3. Admins can view all registrations (optional, good for dashboard)
create policy "Admins can view all registrations"
  on public.event_registrations for select
  using (exists (select 1 from public.roles where user_id = auth.uid() and role = 'admin'));