X-Git-Url: https://git.dogcows.com/gitweb?a=blobdiff_plain;f=db%2Fschema.sql;h=536b1f372cf74467248dd1c573a2f289676146b8;hb=afee0e0191a4808f3c9fcc13de5db87a83fc0cb4;hp=7fd9824cf3e213289c8d5858dcc24ca041ae5e73;hpb=9a7bfdb65af033380ae3c9242b2b3815bdc2bdc5;p=chaz%2Fchatty

diff --git a/db/schema.sql b/db/schema.sql
index 7fd9824..536b1f3 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -1,18 +1,25 @@
 
 PRAGMA foreign_keys = ON;
 
+CREATE TABLE room (
+	id		INTEGER PRIMARY KEY,
+	name		TEXT UNIQUE,
+	created		TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+);
+
 CREATE TABLE account (
 	id		INTEGER PRIMARY KEY,
-	email		TEXT,
 	username	TEXT UNIQUE,
 	password	TEXT NOT NULL,
-	status		TEXT DEFAULT 'active'
+	status		TEXT DEFAULT 'active',
+	current_room	INTEGER REFERENCES room(id)
 );
 
 CREATE TABLE message (
 	id		INTEGER PRIMARY KEY,
-	posted		TIMESTAMP,
+	posted		TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 	author		INTEGER REFERENCES account(id),
+	room		INTEGER REFERENCES room(id),
 	content		TEXT
 );