crystal-gauntlet/db/migrations/19_user_ranks.sql

7 lines
226 B
SQL

-- +migrate up
ALTER TABLE accounts DROP COLUMN is_admin;
ALTER TABLE accounts ADD COLUMN rank TEXT;
-- +migrate down
ALTER TABLE accounts DROP COLUMN rank;
ALTER TABLE accounts ADD COLUMN is_admin INTEGER NOT NULL DEFAULT 0;