X-Git-Url: https://git.dogcows.com/gitweb?a=blobdiff_plain;f=db%2Fschema.sql;h=dfd06e3dafb911a794e4c48382ead1357ad657ba;hb=05b5135c2b3d5b658704029010909b651c767a3f;hp=0b8a7104b91534d25e9344df343a33fbd7f166c5;hpb=d4c693d621d476e20ea670aad267c60960963826;p=chaz%2Fchatty

diff --git a/db/schema.sql b/db/schema.sql
index 0b8a710..dfd06e3 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -1,20 +1,17 @@
 
 PRAGMA foreign_keys = ON;
 
-CREATE TABLE account (
-	id				INTEGER PRIMARY KEY,
-	username	TEXT,
-	password	TEXT,
-	status		TEXT DEFAULT 'active'
+CREATE TABLE room (
+	id		INTEGER PRIMARY KEY,
+	name		TEXT UNIQUE,
+	created		TIMESTAMP DEFAULT CURRENT_TIMESTAMP
 );
 
-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)
 );
 
-INSERT INTO account (username, password) VALUES ('chaz', 'mypass');
-INSERT INTO account (username, password) VALUES ('jdoe', 'foobar');
-