From 291fd5e319005b8908c9516923bd1384845e85f0 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
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(-)

(limited to 'schema.sql')

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

