diff options
| author | sostler <sbostler@gmail.com> | 2010-06-02 13:20:39 -0400 |
|---|---|---|
| committer | sostler <sbostler@gmail.com> | 2010-06-02 13:20:39 -0400 |
| commit | 494148401b8fce4895b1a57488d79a18bd6437a2 (patch) | |
| tree | 8dbc11081f4feec779a2f4e5b270124221ce9232 /db/0-create.psql | |
| parent | 213b7c38376df9e7645aec5ecb2c1e06e56fb4c6 (diff) | |
is_text msg classification
Diffstat (limited to 'db/0-create.psql')
| -rw-r--r-- | db/0-create.psql | 3 |
1 files changed, 2 insertions, 1 deletions
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); |