summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-04-30 18:04:50 +0200
committerYorhel <git@yorhel.nl>2011-04-30 18:04:50 +0200
commit4873e8583189ee9c611fadd27d491dc104c52b57 (patch)
tree8c3b4e8b6f1c011e85f1ead078b7308b0863345e /util/sql/schema.sql
parent57b464e826e5f24828dec9401b70baaa43410b6c (diff)
Replaced user ranks with a permission system
This is far more flexible.
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r--util/sql/schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 0a593cec..6cbd2b14 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -357,7 +357,7 @@ CREATE TABLE users (
id SERIAL NOT NULL PRIMARY KEY,
username varchar(20) NOT NULL UNIQUE,
mail varchar(100) NOT NULL,
- rank smallint NOT NULL DEFAULT 3,
+ perm smallint NOT NULL DEFAULT 1+4+16,
passwd bytea NOT NULL DEFAULT '',
registered timestamptz NOT NULL DEFAULT NOW(),
c_votes integer NOT NULL DEFAULT 0,