1  CREATE TYPE AUTHORITY_LEVEL AS ENUM ('user', 'admin');
2  ALTER TABLE account
3  ADD COLUMN authority AUTHORITY_LEVEL NOT NULL DEFAULT 'user';