Added additional rooms

1 files changed, 4 insertions, 1 deletions

diff --git a/db/0-create.psql b/db/0-create.psql
index be404be..af5ace6 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(),
+    is_admin boolean NOT NULL DEFAULT false,
     avatar text NOT NULL DEFAULT '',
     contact text NOT NULL DEFAULT '',
     bio text NOT NULL DEFAULT ''
@@ -11,7 +12,9 @@ CREATE TABLE users (
 
 CREATE TABLE rooms (
     room_id SERIAL PRIMARY KEY,
-    name text UNIQUE NOT NULL,
+    key text UNIQUE NOT NULL,
+    name text NOT NULL,
+    description text NOT NULL,
     created_on timestamp NOT NULL DEFAULT now(),
     admin_only bool NOT NULL DEFAULT false
 );