diff options
Diffstat (limited to 'db')
| -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); |