This repository has been archived on 2024-07-22. You can view files and clone it, but cannot push or open issues or pull requests.
Zaimki/migrations/015-permissions.sql

10 lines
221 B
MySQL
Raw Permalink Normal View History

2020-12-30 15:03:30 -08:00
-- 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 = '';