copper/migrations/20250914092514_rank.up.sql

3 lines
131 B
SQL

ALTER TABLE users
ADD COLUMN rank TEXT NOT NULL DEFAULT 'user',
ADD COLUMN "extra_permissions" JSON NOT NULL DEFAULT '[]';