CREATE TABLE users (
id INTEGER DEFAULT NULL PRIMARY KEY AUTOINCREMENT,
name TEXT DEFAULT NULL,
created TEXT DEFAULT NULL,
permission TEXT DEFAULT NULL
);
CREATE TABLE accounts (
id INTEGER DEFAULT NULL PRIMARY KEY AUTOINCREMENT,
user_id INTEGER DEFAULT NULL REFERENCES users (id),
balance TEXT DEFAULT NULL,
name TEXT DEFAULT NULL,
opened TEXT DEFAULT NULL
);
CREATE TABLE transactions (
id INTEGER DEFAULT NULL PRIMARY KEY AUTOINCREMENT,
outgoing_id INTEGER DEFAULT NULL REFERENCES accounts (id),
incoming_id INTEGER DEFAULT NULL REFERENCES accounts (id),
type TEXT DEFAULT NULL,
amount TEXT DEFAULT NULL,
date TEXT DEFAULT NULL,
new field TEXT DEFAULT NULL
);