From 450f4d7978578e9c263af522587cbf611c38a5b6 Mon Sep 17 00:00:00 2001 From: sostler Date: Mon, 4 Jan 2010 04:08:37 -0500 Subject: Added additional rooms --- db/0-create.psql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'db') 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 ); -- cgit v1.2.3-70-g09d2