add comet support for real-time chatting

[chaz/chatty] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 536b1f372cf74467248dd1c573a2f289676146b8..dfd06e3dafb911a794e4c48382ead1357ad657ba 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -15,14 +15,3 @@ CREATE TABLE account (
        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');
-