Simon Wicky
17 lines
528 B
SQL
17 lines
528 B
SQL
|
|
CREATE TABLE report_v1 (
|
|
received_at TIMESTAMP WITH TIME ZONE NOT NULL,
|
|
source_ip TEXT,
|
|
device_id TEXT NOT NULL,
|
|
from_mixnet BOOLEAN,
|
|
os_type TEXT,
|
|
os_version TEXT,
|
|
architecture TEXT,
|
|
app_version TEXT,
|
|
user_agent TEXT,
|
|
connection_time_ms INTEGER,
|
|
two_hop BOOLEAN,
|
|
country_code TEXT
|
|
);
|
|
|
|
CREATE INDEX idx_report_v1_received_at ON report_v1 (received_at); |