Simon Wicky
ab11508235
* add stats storage to gateways * config fix * add stats storage model and logic * adapt stats collection to new storage * stats cleanup on start * change to linux only code * tweaks * modified stats cleanup + change session started * change wrong table name * store crashed session as 0 duration * adapt for sqlx 0.7 * remove unused dependencies * revert changes from gateway config, as it is broken anyway * copyright and misc stuff --------- Co-authored-by: Simon Wicky <simon@linode2-2.net>
26 lines
689 B
SQL
26 lines
689 B
SQL
/*
|
|
* Copyright 2024 - Nym Technologies SA <contact@nymtech.net>
|
|
* SPDX-License-Identifier: GPL-3.0-only
|
|
*/
|
|
|
|
CREATE TABLE sessions_active
|
|
(
|
|
client_address TEXT NOT NULL PRIMARY KEY UNIQUE,
|
|
start_time TIMESTAMP WITHOUT TIME ZONE NOT NULL,
|
|
typ TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE sessions_finished
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
day DATE NOT NULL,
|
|
duration_ms INTEGER NOT NULL,
|
|
typ TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE sessions_unique_users
|
|
(
|
|
day DATE NOT NULL,
|
|
client_address TEXT NOT NULL,
|
|
PRIMARY KEY (day, client_address)
|
|
); |