darkfi/src/contract/money/wallet.sql

-- Wallet definitions for this contract.
-- We store data that is needed to be able to receive and send tokens.
-- TODO: The tables should be prefixed with ContractId to prevent collision

-- Arbitrary info that is potentially useful
CREATE TABLE IF NOT EXISTS money_info (
	last_scanned_slot INTEGER NOT NULL
);

-- The Merkle tree containing coins
CREATE TABLE IF NOT EXISTS money_tree (
	tree BLOB NOT NULL
);

-- The keypairs in our wallet
CREATE TABLE IF NOT EXISTS money_keys (
	key_id INTEGER PRIMARY KEY NOT NULL,
	is_default INTEGER NOT NULL,
	public BLOB NOT NULL,
	secret BLOB NOT NULL
);

-- The coins we have the information to and can spend
CREATE TABLE IF NOT EXISTS money_coins (
	coin BLOB PRIMARY KEY NOT NULL,
	is_spent INTEGER NOT NULL,
	serial BLOB NOT NULL,
	value BLOB NOT NULL,
	token_id BLOB NOT NULL,
	spend_hook BLOB NOT NULL,
	user_data BLOB NOT NULL,
	coin_blind BLOB NOT NULL,
	value_blind BLOB NOT NULL,
	token_blind BLOB NOT NULL,
	secret BLOB NOT NULL,
	nullifier BLOB NOT NULL,
	leaf_position BLOB NOT NULL,
	memo BLOB
);