-- Live scoreboard ticks + who is watching the bowl.

create table if not exists stadium_live_events (
  id bigserial primary key,
  kind text not null default 'play',
  payload jsonb not null default '{}'::jsonb,
  created_at timestamptz not null default now()
);

create index if not exists stadium_live_events_created_idx on stadium_live_events (created_at desc);

create table if not exists stadium_watchers (
  peer_id text primary key,
  arena_id text not null default 'football',
  last_seen timestamptz not null default now()
);

create table if not exists deal_room_access_log (
  id text primary key,
  project_id text not null,
  actor_email text not null,
  actor_role text not null,
  action text not null,
  doc_id text,
  created_at timestamptz not null default now()
);