summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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(