schema.sql

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE owner (
    address varchar(64) primary key,
    nonce varchar(32),
    balance integer,
    bad_attempts integer,
    delegate varchar(64));
CREATE TABLE kv (
    key varchar(64) primary key,
    value blob,
    owner varchar(64),
    testnet boolean,
    sale integer,    /* which sale/bucket is this stored under */
    foreign key(owner) references owner(address)
);
CREATE TABLE wallet (
    address varchar(64) primary key,
    contact varchar(256),
    owner varchar(64)
);
CREATE TABLE sale (
    id integer primary key,
    owner varchar(64),
    created text,
    amount integer,
    term integer,
    contact varchar(255),
    price integer,
    bytes_used integer,
    payment_address varchar(64),
    paid boolean,
    received varchar(32),
    foreign key(owner) references owner(address)
);
CREATE TABLE log (
    created text,
    ip varchar(45),  /* max length of ipv6 address */
    action varchar(10),
    bytes integer,
    owner varchar(64),
    message text,
    foreign key(owner) references owner(address)
);
COMMIT;