From 494148401b8fce4895b1a57488d79a18bd6437a2 Mon Sep 17 00:00:00 2001 From: sostler Date: Wed, 2 Jun 2010 13:20:39 -0400 Subject: is_text msg classification --- db/0-create.psql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'db') diff --git a/db/0-create.psql b/db/0-create.psql index 112e774..d06fde4 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -31,7 +31,8 @@ CREATE TABLE messages ( room_id integer NOT NULL REFERENCES rooms, content text NOT NULL, created_on timestamp NOT NULL DEFAULT now(), - is_image bool NOT NULL + is_image bool NOT NULL, + is_text bool NOT NULL DEFAULT false ); CREATE INDEX messages_user_id_idx ON messages (user_id); CREATE INDEX messages_room_id_idx ON messages (room_id); -- cgit v1.2.3-70-g09d2