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
74 lines
2.4 KiB
SQL
74 lines
2.4 KiB
SQL
-- table to write information about any rewarding that has already begun
|
|
-- in case the process crashes during the procedure.
|
|
-- this would prevent people from somehow purposely crashing it and getting multiple rewards
|
|
-- per epoch
|
|
CREATE TABLE epoch_rewarding
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
epoch_timestamp INTEGER NOT NULL,
|
|
finished BOOLEAN NOT NULL
|
|
);
|
|
|
|
-- for each epoch there shall be a summary
|
|
CREATE TABLE rewarding_report
|
|
(
|
|
epoch_rewarding_id INTEGER NOT NULL,
|
|
|
|
eligible_mixnodes INTEGER NOT NULL,
|
|
eligible_gateways INTEGER NOT NULL,
|
|
|
|
possibly_unrewarded_mixnodes INTEGER NOT NULL,
|
|
possibly_unrewarded_gateways INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (epoch_rewarding_id) REFERENCES epoch_rewarding (id)
|
|
);
|
|
|
|
-- containing possibly many (ideally zero!) failed reward entries
|
|
-- (this refers to a reward chunk)
|
|
CREATE TABLE failed_mixnode_reward_chunk
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
error_message VARCHAR NOT NULL,
|
|
|
|
reward_summary_id INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (reward_summary_id) REFERENCES epoch_rewarding (id)
|
|
);
|
|
|
|
|
|
CREATE TABLE failed_gateway_reward_chunk
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
error_message VARCHAR NOT NULL,
|
|
|
|
reward_summary_id INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (reward_summary_id) REFERENCES epoch_rewarding (id)
|
|
);
|
|
|
|
|
|
-- and each such failed_mixnode_reward_chunk contain mixnodes that might have been unrewarded
|
|
-- (but we don't know for sure - at least in typescript we could have gotten a timeout yet the tx still was executed)
|
|
-- this table only exists because sqlite has no arrays
|
|
CREATE TABLE possibly_unrewarded_mixnode
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
identity VARCHAR NOT NULL,
|
|
uptime INTEGER NOT NULL,
|
|
|
|
failed_mixnode_reward_chunk_id INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (failed_mixnode_reward_chunk_id) REFERENCES failed_mixnode_reward_chunk (id)
|
|
);
|
|
|
|
|
|
CREATE TABLE possibly_unrewarded_gateway
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
identity VARCHAR NOT NULL,
|
|
uptime INTEGER NOT NULL,
|
|
|
|
failed_gateway_reward_chunk_id INTEGER NOT NULL,
|
|
|
|
FOREIGN KEY (failed_gateway_reward_chunk_id) REFERENCES failed_gateway_reward_chunk (id)
|
|
) |