X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fchatty;a=blobdiff_plain;f=db%2Fschema.sql;h=dfd06e3dafb911a794e4c48382ead1357ad657ba;hp=fee4063c1152baf247785b5a5c1884fc5f1ee53a;hb=e26179af9aaf7cae5a0aa68ad87a50e4b1e1aba5;hpb=d2a57728529b95fa1c2e3da677e64c848e7d065b

diff --git a/db/schema.sql b/db/schema.sql
index fee4063..dfd06e3 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -9,21 +9,9 @@ CREATE TABLE room (
 
 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 CURRENT_TIMESTAMP,
-	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');
-