add comet support for real-time chatting

[chaz/chatty] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 0b8a7104b91534d25e9344df343a33fbd7f166c5..dfd06e3dafb911a794e4c48382ead1357ad657ba 100644 (file)
--- 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');
-