Dave Hrycyszyn
f6a79ce7c3
* Renaming validator-api to nym-api * nym-api: simplified crate name * Added nym-api rename to changelog * Changed some output messages * Renamed validator-api-requests to nym-api requests * Removing more references to validator-api-requests * Additional lockfile name changes after full build * Removing mistakenly added merge files * ibid * ibid * Getting rid of ref to validator_api deep inside validator-client * Fixing file storage paths * Renaming struct function names referring to validator_api * Simplifying struct init * Fixed up all other instances of nym_api. * Renaming validatorApi to nymApi in TypeScript client for consistency v * Found a few more Rust instances * Changed examples in TypeScript SDK * Found one more instance of the use of validator instead of nym apis * Aliasing config key name for deserialization to preserve compatibility with old configs
91 lines
2.5 KiB
SQL
91 lines
2.5 KiB
SQL
CREATE TABLE mixnode_details
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
owner VARCHAR NOT NULL,
|
|
identity VARCHAR NOT NULL UNIQUE
|
|
);
|
|
|
|
CREATE TABLE gateway_details
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
owner VARCHAR NOT NULL,
|
|
identity VARCHAR NOT NULL UNIQUE
|
|
);
|
|
|
|
create TABLE mixnode_historical_uptime
|
|
(
|
|
mixnode_details_id INTEGER NOT NULL,
|
|
|
|
-- 'YYYY-MM-DD'
|
|
date VARCHAR NOT NULL,
|
|
|
|
-- 24h uptimes for that day
|
|
ipv4_uptime INTEGER NOT NULL,
|
|
ipv6_uptime INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (mixnode_details_id) REFERENCES mixnode_details (id)
|
|
);
|
|
|
|
create table mixnode_ipv4_status
|
|
(
|
|
mixnode_details_id INTEGER NOT NULL,
|
|
up BOOLEAN NOT NULL,
|
|
timestamp INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (mixnode_details_id) REFERENCES mixnode_details (id)
|
|
);
|
|
|
|
create table mixnode_ipv6_status
|
|
(
|
|
mixnode_details_id INTEGER NOT NULL,
|
|
up BOOLEAN NOT NULL,
|
|
timestamp INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (mixnode_details_id) REFERENCES mixnode_details (id)
|
|
);
|
|
|
|
create TABLE gateway_historical_uptime
|
|
(
|
|
gateway_details_id INTEGER NOT NULL,
|
|
|
|
-- 'YYYY-MM-DD'
|
|
date VARCHAR NOT NULL,
|
|
|
|
-- 24h uptimes for that day
|
|
ipv4_uptime INTEGER NOT NULL,
|
|
ipv6_uptime INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (gateway_details_id) REFERENCES gateway_details (id)
|
|
);
|
|
|
|
create table gateway_ipv4_status
|
|
(
|
|
gateway_details_id INTEGER NOT NULL,
|
|
up BOOLEAN NOT NULL,
|
|
timestamp INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (gateway_details_id) REFERENCES gateway_details (id)
|
|
);
|
|
|
|
create table gateway_ipv6_status
|
|
(
|
|
gateway_details_id INTEGER NOT NULL,
|
|
up BOOLEAN NOT NULL,
|
|
timestamp INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (gateway_details_id) REFERENCES gateway_details (id)
|
|
);
|
|
|
|
-- indices for faster lookups
|
|
CREATE
|
|
INDEX `mixnode_ipv4_status_index` ON `mixnode_ipv4_status` (`mixnode_details_id`, `timestamp` desc);
|
|
CREATE
|
|
INDEX `mixnode_ipv6_status_index` ON `mixnode_ipv6_status` (`mixnode_details_id`, `timestamp` desc);
|
|
|
|
CREATE
|
|
INDEX `gateway_ipv4_status_index` ON `gateway_ipv4_status` (`gateway_details_id`, `timestamp` desc);
|
|
CREATE
|
|
INDEX `gateway_ipv6_status_index` ON `gateway_ipv6_status` (`gateway_details_id`, `timestamp` desc);
|
|
|
|
CREATE INDEX `mixnode_identity_index` ON `mixnode_details` (`id`, `identity`);
|
|
CREATE INDEX `gateway_identity_index` ON `gateway_details` (`id`, `identity`); |