diff options
Diffstat (limited to 'util/updates/update_2.20.sql')
-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; + |