From 704efb06cd424de7411f198bc4c6ce6b99a9dcbe Mon Sep 17 00:00:00 2001 From: sostler Date: Fri, 18 Dec 2009 21:56:51 -0500 Subject: Checkin before leaving --- db/0-create.psql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'db') diff --git a/db/0-create.psql b/db/0-create.psql index 35278c7..5bd8622 100755 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -4,6 +4,7 @@ CREATE TABLE users ( hash text NOT NULL, email text NOT NULL, created_on timestamp NOT NULL DEFAULT now(), + avatar text, contact text, bio text ); @@ -19,7 +20,8 @@ CREATE TABLE messages ( user_id integer NOT NULL REFERENCES users, room_id integer NOT NULL REFERENCES rooms, content text NOT NULL, - created_on timestamp NOT NULL DEFAULT now() + created_on timestamp NOT NULL DEFAULT now(), + is_image bool ); CREATE TABLE user_session ( -- cgit v1.2.3-70-g09d2