Jędrzej Stuczyński
bac0f24cf7
* split up coconut module a bit * internal tool for watching dkg state and updating group contract * debug dkg state * display past dealer data * improved EpochState Display impl * display contract errors + advance epoch state * check admin * panic handler * simplify app.rs * split action enum * added new tab with logger information * new dealing display * sort by index * [fixedup] wip: updating epoch issued credentials - OG 92ade10384a6d7b6c6c222d2e29d69d3b3446a4c * storing and signing partial blinded credentials * starting cleanup * fixed coconut tests + clippy * fixed nym-api tests * removed dkg-manager tool it was moved to a different branch * implemented remaining endpoints * unit tests + bug fixes * clippy * added persistent identity keys to nym-api theyre not yet announced - this will be in another PR * cargo fmt * clippy * fixed loading of old configs without storage paths set * added additional logs for blind-sign endpoint * fixed up licenses * lowercasing error variants * changed 'issued_credentials' to a post * added minimal client support * fixed the unit test
28 lines
987 B
SQL
28 lines
987 B
SQL
/*
|
|
* Copyright 2023 - Nym Technologies SA <contact@nymtech.net>
|
|
* SPDX-License-Identifier: GPL-3.0-only
|
|
*/
|
|
|
|
|
|
DROP TABLE signed_deposit;
|
|
|
|
-- represents information about credentials issued in that epoch so that the other parties could make their appropriate queries
|
|
-- note: before this information can be returned to a client (of the API), it needs to be signed first
|
|
CREATE TABLE epoch_credentials
|
|
(
|
|
epoch_id INTEGER NOT NULL PRIMARY KEY UNIQUE,
|
|
start_id INTEGER NOT NULL,
|
|
total_issued INTEGER NOT NULL
|
|
);
|
|
|
|
-- particular credential issued in this epoch
|
|
CREATE TABLE issued_credential
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
epoch_id INTEGER NOT NULL,
|
|
tx_hash VARCHAR NOT NULL UNIQUE,
|
|
bs58_partial_credential VARCHAR NOT NULL,
|
|
bs58_signature VARCHAR NOT NULL,
|
|
joined_private_commitments VARCHAR NOT NULL,
|
|
joined_public_attributes VARCHAR NOT NULL
|
|
); |