Jędrzej Stuczyński
d3cdaf373b
* moved storage and deposits buffer to the common lib * move more of the state into the shared lib * extracted the rest of the features into the shared lib * fixed test imports * clippy
79 lines
3.0 KiB
SQL
79 lines
3.0 KiB
SQL
/*
|
|
* Copyright 2024 - Nym Technologies SA <contact@nymtech.net>
|
|
* SPDX-License-Identifier: GPL-3.0-only
|
|
*/
|
|
|
|
|
|
DROP TABLE blinded_shares;
|
|
CREATE TABLE blinded_shares
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY,
|
|
-- added request_uuid to tie it to deposit and actual share data
|
|
request_uuid TEXT NOT NULL REFERENCES ticketbook_deposit(request_uuid),
|
|
status TEXT NOT NULL,
|
|
device_id TEXT NOT NULL,
|
|
credential_id TEXT NOT NULL,
|
|
-- replaced the explicit data field in favour of separate table alongside
|
|
-- the information on the number of shares available (need min. threshold)
|
|
available_shares INTEGER NOT NULL DEFAULT 0,
|
|
error_message TEXT DEFAULT NULL,
|
|
created TIMESTAMP WITHOUT TIME ZONE NOT NULL,
|
|
updated TIMESTAMP WITHOUT TIME ZONE NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX blinded_shares_index ON blinded_shares (credential_id, device_id);
|
|
|
|
|
|
CREATE TABLE ticketbook_deposit (
|
|
deposit_id INTEGER PRIMARY KEY NOT NULL,
|
|
deposit_tx_hash TEXT NOT NULL,
|
|
requested_on TIMESTAMP WITHOUT TIME ZONE NOT NULL,
|
|
request_uuid TEXT UNIQUE NOT NULL,
|
|
deposit_amount TEXT NOT NULL,
|
|
client_pubkey BLOB NOT NULL,
|
|
ed25519_deposit_private_key BLOB NOT NULL
|
|
);
|
|
|
|
CREATE TABLE partial_blinded_wallet (
|
|
corresponding_deposit INTEGER NOT NULL REFERENCES ticketbook_deposit(deposit_id),
|
|
epoch_id INTEGER NOT NULL,
|
|
expiration_date DATE NOT NULL,
|
|
node_id INTEGER NOT NULL,
|
|
created TIMESTAMP WITHOUT TIME ZONE NOT NULL,
|
|
blinded_signature BLOB NOT NULL
|
|
);
|
|
|
|
CREATE TABLE partial_blinded_wallet_failure (
|
|
corresponding_deposit INTEGER NOT NULL REFERENCES ticketbook_deposit(deposit_id),
|
|
epoch_id INTEGER NOT NULL,
|
|
expiration_date DATE NOT NULL,
|
|
node_id INTEGER NOT NULL,
|
|
created TIMESTAMP WITHOUT TIME ZONE NOT NULL,
|
|
failure_message TEXT NOT NULL
|
|
);
|
|
|
|
-- copied (+rev) from nym-api
|
|
CREATE TABLE master_verification_key (
|
|
epoch_id INTEGER PRIMARY KEY NOT NULL,
|
|
serialization_revision INTEGER NOT NULL,
|
|
serialised_key BLOB NOT NULL
|
|
);
|
|
|
|
CREATE TABLE global_coin_index_signatures (
|
|
-- we can only have a single entry
|
|
epoch_id INTEGER PRIMARY KEY NOT NULL,
|
|
serialization_revision INTEGER NOT NULL,
|
|
|
|
-- combined signatures for all indices
|
|
serialised_signatures BLOB NOT NULL
|
|
);
|
|
|
|
CREATE TABLE global_expiration_date_signatures (
|
|
expiration_date DATE NOT NULL UNIQUE PRIMARY KEY,
|
|
epoch_id INTEGER NOT NULL,
|
|
serialization_revision INTEGER NOT NULL,
|
|
|
|
-- combined signatures for all tuples issued for given day
|
|
serialised_signatures BLOB NOT NULL
|
|
);
|