Files
coder/coderd/database/migrations/000007_user_status.up.sql

5 lines
156 B
SQL

CREATE TYPE user_status AS ENUM ('active', 'suspended');
ALTER TABLE ONLY users
ADD COLUMN IF NOT EXISTS status user_status NOT NULL DEFAULT 'active';