models.txt

# models
CREATE TABLE 'portfolio' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'user' FOREIGN KEY (user) references users(id), 'ticker' TEXT NOT NULL, 'amount' INTEGER NOT NULL, 'price' INTEGER NOT NULL, 'timestamp' DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL )

CREATE TABLE 'users' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'username' TEXT NOT NULL, 'hash' TEXT NOT NULL, 'cash' NUMERIC NOT NULL DEFAULT 10000.00 )