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
82 lines
3.1 KiB
SQL
82 lines
3.1 KiB
SQL
/*
|
|
* Copyright 2025 - Nym Technologies SA <contact@nymtech.net>
|
|
* SPDX-License-Identifier: GPL-3.0-only
|
|
*/
|
|
|
|
CREATE TABLE ecash_deposit
|
|
(
|
|
-- id assigned [by the contract] to the deposit
|
|
deposit_id INTEGER PRIMARY KEY NOT NULL,
|
|
|
|
-- associated tx hash
|
|
deposit_tx_hash TEXT NOT NULL,
|
|
|
|
-- indication of when the deposit request has been created
|
|
-- (so that based on block timestamp we could potentially determine latency)
|
|
requested_on TIMESTAMP WITHOUT TIME ZONE NOT NULL,
|
|
|
|
-- the amount put in the deposit (informative, as we expect this to change in the future)
|
|
deposit_amount TEXT NOT NULL,
|
|
|
|
-- the private key generated for the purposes of the deposit (the public component has been put in the transaction)
|
|
ed25519_deposit_private_key BLOB NOT NULL
|
|
);
|
|
|
|
|
|
INSERT INTO ecash_deposit(deposit_id, deposit_tx_hash, requested_on, deposit_amount, ed25519_deposit_private_key)
|
|
SELECT deposit_id, deposit_tx_hash, requested_on, deposit_amount, ed25519_deposit_private_key
|
|
FROM ticketbook_deposit;
|
|
|
|
|
|
CREATE TABLE ecash_deposit_usage
|
|
(
|
|
deposit_id INTEGER PRIMARY KEY REFERENCES ecash_deposit (deposit_id),
|
|
ticketbooks_requested_on TIMESTAMP WITHOUT TIME ZONE NOT NULL,
|
|
client_pubkey BLOB NOT NULL,
|
|
request_uuid TEXT UNIQUE NOT NULL,
|
|
|
|
-- this has to be improved later on to resume issuance or something, but for now it's fine
|
|
ticketbook_request_error TEXT
|
|
);
|
|
|
|
INSERT INTO ecash_deposit_usage(deposit_id, ticketbooks_requested_on, client_pubkey, request_uuid)
|
|
SELECT deposit_id, 0, client_pubkey, request_uuid
|
|
FROM ticketbook_deposit;
|
|
|
|
|
|
CREATE TABLE partial_blinded_wallet_new
|
|
(
|
|
corresponding_deposit INTEGER NOT NULL REFERENCES ecash_deposit_usage (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_new
|
|
(
|
|
corresponding_deposit INTEGER NOT NULL REFERENCES ecash_deposit_usage (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
|
|
);
|
|
|
|
INSERT INTO partial_blinded_wallet_new
|
|
SELECT *
|
|
FROM partial_blinded_wallet;
|
|
INSERT INTO partial_blinded_wallet_failure_new
|
|
SELECT *
|
|
FROM partial_blinded_wallet_failure;
|
|
|
|
DROP TABLE partial_blinded_wallet;
|
|
DROP TABLE partial_blinded_wallet_failure;
|
|
DROP TABLE ticketbook_deposit;
|
|
|
|
ALTER TABLE partial_blinded_wallet_new
|
|
RENAME TO partial_blinded_wallet;
|
|
ALTER TABLE partial_blinded_wallet_failure_new
|
|
RENAME TO partial_blinded_wallet_failure;
|