summaryrefslogtreecommitdiff
path: root/db/0-create.psql
diff options
context:
space:
mode:
authorsostler <sbostler@gmail.com>2009-12-06 20:38:51 -0500
committersostler <sbostler@gmail.com>2009-12-06 20:38:51 -0500
commit631f492c328ee40414ee32f717215d3fdda6f55a (patch)
treead3c4e284b06c3ddc4fd2eb9ac6ea6280f7c07ac /db/0-create.psql
parent9dd2ee1b1eb63529f5694d2e400dd04cc1eb1663 (diff)
Profiles / templates
Diffstat (limited to 'db/0-create.psql')
-rwxr-xr-xdb/0-create.psql4
1 files changed, 3 insertions, 1 deletions
diff --git a/db/0-create.psql b/db/0-create.psql
index d34ccdd..35278c7 100755
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -3,7 +3,9 @@ CREATE TABLE users (
nick text UNIQUE NOT NULL,
hash text NOT NULL,
email text NOT NULL,
- created_on timestamp NOT NULL DEFAULT now()
+ created_on timestamp NOT NULL DEFAULT now(),
+ contact text,
+ bio text
);
CREATE TABLE rooms (