8 lines
383 B
SQL
8 lines
383 B
SQL
-- Restore the old flag for anyone who still has a role, so a rollback keeps
|
|
-- them in the panel.
|
|
UPDATE users SET role = 'admin' WHERE admin_role_id IS NOT NULL AND admin_blocked_at IS NULL;
|
|
DROP INDEX IF EXISTS users_admin_role_idx;
|
|
ALTER TABLE users DROP COLUMN IF EXISTS admin_blocked_at;
|
|
ALTER TABLE users DROP COLUMN IF EXISTS admin_role_id;
|
|
DROP TABLE IF EXISTS admin_roles;
|