diff options
| author | Yorhel <git@yorhel.nl> | 2011-04-30 18:04:50 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2011-04-30 18:04:50 +0200 |
| commit | 4873e8583189ee9c611fadd27d491dc104c52b57 (patch) | |
| tree | 8c3b4e8b6f1c011e85f1ead078b7308b0863345e /util/updates | |
| parent | 57b464e826e5f24828dec9401b70baaa43410b6c (diff) | |
Replaced user ranks with a permission system
This is far more flexible.
Diffstat (limited to 'util/updates')
| -rw-r--r-- | util/updates/update_2.20.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/util/updates/update_2.20.sql b/util/updates/update_2.20.sql index c4cdb880..390e9a41 100644 --- a/util/updates/update_2.20.sql +++ b/util/updates/update_2.20.sql @@ -39,3 +39,16 @@ CREATE TABLE affiliate_links ( CREATE INDEX affiliate_links_rid ON affiliate_links (rid) WHERE NOT hidden; + + +-- rank -> permissions + +ALTER TABLE users RENAME rank TO perm; +ALTER TABLE users ALTER COLUMN perm SET DEFAULT 1+4+16; +UPDATE users SET perm = CASE + WHEN perm = 2 THEN 1 + WHEN perm = 3 THEN 1+4+16 + WHEN perm = 4 THEN 1+2+4+8+16+32+64 + WHEN perm = 5 THEN 1+2+4+8+16+32+64+128+256 + ELSE 0 END; + |