fedimovies/fedimovies-models/migrations/V0041__user_account__user_role.sql

2 lines
137 B
SQL

ALTER TABLE user_account ADD COLUMN user_role SMALLINT NOT NULL DEFAULT 1;
ALTER TABLE user_account ALTER COLUMN user_role DROP DEFAULT;