Files
coder/coderd/database/migrations/000299_system_user.up.sql
2025-03-04 10:08:54 +00:00

7 lines
260 B
SQL

ALTER TABLE users
ADD COLUMN is_system bool DEFAULT false;
CREATE INDEX user_is_system_idx ON users USING btree (is_system);
COMMENT ON COLUMN users.is_system IS 'Determines if a user is a system user, and therefore cannot login or perform normal actions';