1 files changed, 3 insertions, 1 deletions
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 (