diff options
Diffstat (limited to 'db')
| -rwxr-xr-x | db/0-create.psql | 5 |
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 ); |