supabase-schema.sql

create table if not exists public.command_history (
  id uuid primary key default gen_random_uuid(),
  user_id uuid not null,
  command text not null,
  current_dir text not null default '/',
  risk_score int not null check (risk_score >= 0 and risk_score <= 100),
  decision text not null,
  badge text not null,
  analysis jsonb not null,
  created_at timestamptz not null default now()
);

create index if not exists idx_command_history_user_created_at
  on public.command_history (user_id, created_at desc);

alter table public.command_history enable row level security;

create policy "Users can read own history"
on public.command_history
for select
using (auth.uid() = user_id);

create policy "Users can insert own history"
on public.command_history
for insert
with check (auth.uid() = user_id);