summaryrefslogtreecommitdiff
path: root/db/0-create.psql
diff options
context:
space:
mode:
authorScott Ostler <sostler@deathmachine.local>2010-01-02 20:53:30 -0500
committerScott Ostler <sostler@deathmachine.local>2010-01-02 20:53:30 -0500
commit7fd7757c4db84ec6cf8578ec1f9a778977710bcc (patch)
treee924b98dc8852fb80d06195b47d4dca450a58319 /db/0-create.psql
parentfe1b5678c330f0c3ec0e05a2295144338cadd5a6 (diff)
xmas work
Diffstat (limited to 'db/0-create.psql')
-rwxr-xr-xdb/0-create.psql6
1 files changed, 3 insertions, 3 deletions
diff --git a/db/0-create.psql b/db/0-create.psql
index 5bd8622..7bcffe6 100755
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -4,9 +4,9 @@ CREATE TABLE users (
hash text NOT NULL,
email text NOT NULL,
created_on timestamp NOT NULL DEFAULT now(),
- avatar text,
- contact text,
- bio text
+ avatar text NOT NULL DEFAULT '',
+ contact text NOT NULL DEFAULT '',
+ bio text NOT NULL DEFAULT ''
);
CREATE TABLE rooms (