Department of Economics & Finance

Tạo bảng Supabase `experience_day_sessions`

Mở Supabase Dashboard → SQL Editor → Dán đoạn mã này và bấm Run:

create table if not exists experience_day_sessions (
  id uuid default gen_random_uuid() primary key,
  participant_name text not null default 'Anonymous',
  arena_id int not null,
  arena_title text not null,
  score int not null default 0,
  pnl numeric not null default 0,
  correct_count int not null default 0,
  total_questions int not null default 5,
  accuracy numeric not null default 0,
  best_streak int not null default 0,
  time_left_sec int not null default 0,
  timed_out boolean not null default false,
  is_prize_winner boolean not null default false,
  missed_questions jsonb default '[]'::jsonb,
  device_type text,
  language text default 'vi',
  created_at timestamptz default now()
);

alter table experience_day_sessions enable row level security;
create policy "Allow public insert" on experience_day_sessions for insert with check (true);
create policy "Allow public select" on experience_day_sessions for select using (true);