summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMatthias Andreas Benkard <code@mail.matthias.benkard.de>2011-03-02 19:23:34 +0100
committerMatthias Andreas Benkard <code@mail.matthias.benkard.de>2011-03-02 19:23:34 +0100
commit291fd5e319005b8908c9516923bd1384845e85f0 (patch)
tree2dbd54c8cdad3bd888c2e68258fd12353c0ba73f
parentfd87dbade6aee9c8c69a3a3ae65758fb71e87118 (diff)
Database schema: Add more metadata to users.
-rw-r--r--schema.sql10
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(