23 lines
663 B
Plaintext
23 lines
663 B
Plaintext
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
|
|
);
|