Simon Wicky
6eb8f29235
* vpn client report v2 * report v2 support in nym-stats API * version bump * CI fix while we're at it * more CI fix * needed the dind after all * PR comments
30 lines
941 B
SQL
30 lines
941 B
SQL
CREATE TABLE report_v2 (
|
|
-- some info about the report, inferred from when/from where we got it
|
|
received_at TIMESTAMP WITH TIME ZONE NOT NULL,
|
|
source_ip TEXT,
|
|
from_mixnet BOOLEAN,
|
|
country_code TEXT,
|
|
report_version TEXT,
|
|
|
|
-- some infos about the device sending the report
|
|
device_id TEXT NOT NULL,
|
|
os_type TEXT,
|
|
os_version TEXT,
|
|
architecture TEXT,
|
|
app_version TEXT,
|
|
user_agent TEXT,
|
|
|
|
-- session info
|
|
start_day_utc DATE,
|
|
connection_time_ms INTEGER,
|
|
tunnel_type TEXT,
|
|
retry_attempt INTEGER,
|
|
session_duration_min INTEGER,
|
|
disconnection_time_ms INTEGER,
|
|
exit_id TEXT,
|
|
follow_up_id TEXT,
|
|
error TEXT
|
|
);
|
|
|
|
CREATE INDEX idx_report_v2_received_at ON report_v2 (received_at);
|