-CREATE TABLE message (
- id INTEGER PRIMARY KEY,
- posted TIMESTAMP,
- author INTEGER REFERENCES account(id),
- content TEXT
+CREATE TABLE account (
+ id INTEGER PRIMARY KEY,
+ username TEXT UNIQUE,
+ password TEXT NOT NULL,
+ status TEXT DEFAULT 'active',
+ current_room INTEGER REFERENCES room(id)