cranberry

1
CREATE TABLE IF NOT EXISTS BLOCK_HEADERS (
2
    HASH TEXT PRIMARY KEY,
3
    PREV_HASH TEXT,
4
    HEIGHT INTEGER,
5
    MERKLE_ROOT TEXT
6
);
7
CREATE TABLE IF NOT EXISTS BLOCK_HEADER_SIGNATURES (
8
    BLOCK_HEADER_HASH TEXT,
9
    VALIDATOR_ID TEXT,
10
    SIGNATURE_R BYTEA,
11
    SIGNATURE_S BYTEA,
12
    PRIMARY KEY (BLOCK_HEADER_HASH, VALIDATOR_ID)
13
);
14
CREATE TABLE IF NOT EXISTS TXS (
15
    HASH TEXT PRIMARY KEY,
16
    BLOCK_HEIGHT INTEGER,
17
    ORDER_IN_BLOCK INTEGER,
18
    FROM_ACC TEXT,
19
    TO_ACC TEXT,
20
    AMOUNT INTEGER,
21
    SIGNATURE_R BYTEA,
22
    SIGNATURE_S BYTEA
23
);
24
CREATE TABLE IF NOT EXISTS PARAMS (
25
    NAME TEXT PRIMARY KEY,
26
    VALUE TEXT
27
);
28
CREATE TABLE IF NOT EXISTS PEERS (
29
    NAME TEXT PRIMARY KEY,
30
    ADDR TEXT,
31
    PORT INTEGER
32
);
33
CREATE TABLE IF NOT EXISTS ACCOUNTS (
34
    ADDR TEXT PRIMARY KEY,
35
    PUB_KEY BYTEA,
36
    BALANCE INTEGER
37
);
38
CREATE TABLE IF NOT EXISTS VALIDATORS (
39
    ADDR TEXT PRIMARY KEY,
40
    PUB_KEY BYTEA
41
);
42
CREATE TABLE IF NOT EXISTS ROUND_ROBIN_STATE (
43
    CURRENT_ROUND INTEGER PRIMARY KEY
44
);