CREATE TABLE outputs (
    spending_key BLOB PRIMARY KEY NOT NULL,
    value INTEGER NOT NULL,
    flags INTEGER NOT NULL,
    maturity INTEGER NOT NULL,
    status INTEGER NOT NULL,
    tx_id INTEGER NULL
);

CREATE TABLE pending_transaction_outputs (
    tx_id INTEGER PRIMARY KEY NOT NULL,
    short_term INTEGER NOT NULL,
    timestamp DATETIME NOT NULL
);

CREATE TABLE key_manager_states (
    id INTEGER PRIMARY KEY,
    master_seed BLOB NOT NULL,
    branch_seed TEXT NOT NULL,
    primary_key_index INTEGER NOT NULL,
    timestamp DATETIME NOT NULL
);