15.02.07.sql 549 B

1234567891011121314
  1. /*
  2. Rank 0: guest - read-only access
  3. Rank 1: client - read-only access + comments
  4. Rank 2: user - current user permissions
  5. Rank 3: manager - delete issues/comments
  6. Rank 4: admin - current admin privileges, minus plugin config
  7. Rank 5: superadmin - able to change config file values from web interface
  8. */
  9. ALTER TABLE user ADD COLUMN rank tinyint(1) UNSIGNED DEFAULT 0 NOT NULL AFTER role;
  10. UPDATE user SET rank = '2' WHERE role = 'user';
  11. UPDATE user SET rank = '4' WHERE role = 'admin';
  12. UPDATE config SET value = '15.02.07' WHERE attribute = 'version';