PRAGMA foreign_keys = ON; CREATE TABLE room ( id INTEGER PRIMARY KEY, name TEXT, created TIMESTAMP DEFAULT NOW ); CREATE TABLE account ( id INTEGER PRIMARY KEY, email TEXT, username TEXT UNIQUE, password TEXT NOT NULL, status TEXT DEFAULT 'active', current_room INTEGER REFERENCES room(id) ); CREATE TABLE message ( id INTEGER PRIMARY KEY, posted TIMESTAMP DEFAULT NOW, author INTEGER REFERENCES account(id), room INTEGER REFERENCES room(id), content TEXT ); INSERT INTO account (username, password) VALUES ('chaz', 'mypass'); INSERT INTO account (username, password) VALUES ('jdoe', 'foobar');