Database schema: Add more metadata to users.

1 files 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(