Undervisning i at bygge ai·campus.

-- 001_initial_schema.sql

create table public.profiles (
  id uuid references auth.users primary key,
  email text unique not null,
  plan text default 'intro' check (plan in ('intro','pro')),
  created_at timestamptz default now()
);

create table public.progress (
  user_id uuid references profiles(id) on delete cascade,
  lesson_id text not null,
  completed_at timestamptz,
  primary key (user_id, lesson_id)
);

-- RLS: brugere ser kun eget progress
alter table progress enable row level security;
create policy "own_progress" on progress
  for all using (auth.uid() = user_id);