Drazen Urch
1ac262ec90
* Initial commit * Cherry pick from develop * Keep track of fragments * A bunch of data formats, graphs * Use mix_id for display * Proper API routes * Add openapi + swagger ui * Update locustfile * Add node stats endpoint * Add Swagger and locust to readme * All node stats endpoint * Update dependencies to use workspace * Bunch of pedantic fixes * More version updates, fmt * More lints * Add new_from_env for NymTopology * Nym API endpoint to submit monitoring results (#4616) * Nym API endpoint to submit monitoring results * Add gateway monitoring results * Cleanup, ergonomics * Weaponize * Finalize results submissions * Monitor message signing and verification * Update README * Axum graceful shutdown * More grtacefulness * Restructure result submission * Less fragile routes * Remove gateway unique index on node_id
32 lines
679 B
SQL
32 lines
679 B
SQL
CREATE TABLE mixnode_details_v2
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
mix_id INTEGER NOT NULL UNIQUE,
|
|
owner VARCHAR NOT NULL,
|
|
identity_key VARCHAR NOT NULL
|
|
);
|
|
|
|
CREATE TABLE mixnode_status_v2
|
|
(
|
|
mixnode_details_id INTEGER NOT NULL,
|
|
reliability INTEGER NOT NULL,
|
|
timestamp INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE TABLE gateway_details_v2
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
owner VARCHAR NOT NULL,
|
|
identity VARCHAR NOT NULL UNIQUE
|
|
);
|
|
|
|
CREATE TABLE gateway_status_v2
|
|
(
|
|
gateway_details_id INTEGER NOT NULL,
|
|
reliability INTEGER NOT NULL,
|
|
timestamp INTEGER NOT NULL
|
|
);
|
|
|
|
|
|
|