PronounsPage/migrations/015-permissions.sql
2020-12-31 00:03:30 +01:00

10 lines
221 B
SQL

-- Up
UPDATE users SET roles = '*' WHERE roles = 'admin';
UPDATE users SET roles = '' WHERE roles = 'user';
-- Down
UPDATE users SET roles = 'admin' WHERE roles = '*';
UPDATE users SET roles = 'user' WHERE roles = '';