15 lines
711 B
SQL
15 lines
711 B
SQL
-- Per-match ping telemetry reported by game clients.
|
|
create table if not exists public.ping_reports (
|
|
id bigint generated by default as identity not null,
|
|
created_at timestamp with time zone not null default now(),
|
|
user_id bigint not null references public.users(id),
|
|
match_id bigint not null references public.matches(id),
|
|
ip_address text null,
|
|
ping integer not null,
|
|
constraint ping_reports_pkey primary key (id)
|
|
);
|
|
|
|
create index if not exists ping_reports_user_id_idx on public.ping_reports(user_id);
|
|
create index if not exists ping_reports_match_id_idx on public.ping_reports(match_id);
|
|
create index if not exists ping_reports_created_at_idx on public.ping_reports(created_at);
|