From 291fd5e319005b8908c9516923bd1384845e85f0 Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Wed, 2 Mar 2011 19:23:34 +0100 Subject: Database schema: Add more metadata to users. --- schema.sql | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/schema.sql b/schema.sql index 8c2287d..5e4c250 100644 --- a/schema.sql +++ b/schema.sql @@ -14,12 +14,14 @@ BEGIN TRANSACTION; CREATE TABLE users( - id SERIAL NOT NULL, - name VARCHAR, - status VARCHAR NOT NULL, + id SERIAL NOT NULL, + name VARCHAR, + status VARCHAR NOT NULL, + email VARCHAR, + website VARCHAR, PRIMARY KEY (id), CHECK (status IN ('pending', 'approved', 'trusted', 'deferred', 'disabled', - 'admin')) + 'admin', 'visitor')) ); CREATE TABLE passwords( -- cgit v1.2.3