PRAGMA foreign_keys = ON;

CREATE TABLE account (
	id				INTEGER PRIMARY KEY,
	username	TEXT,
	password	TEXT,
	status		TEXT DEFAULT 'active'
);

CREATE TABLE message (
	id				INTEGER PRIMARY KEY,
	posted		TIMESTAMP,
	author		INTEGER REFERENCES account(id),
	content		TEXT
);

INSERT INTO account (username, password) VALUES ('chaz', 'mypass');
INSERT INTO account (username, password) VALUES ('jdoe', 'foobar');