Mar 25, 2025 · Mar 12, 2025 · Mar 13, 2025 · Mar 13, 2025 · Mar 13, 2025 · Mar 13, 2025
diff --git a/coderd/database/dbmem/dbmem.go b/coderd/database/dbmem/dbmem.go
 }

 q.mutex.Lock()
 // We can't insert this user using the interface, because it's a system user.
 q.data.users = append(q.data.users, database.User{
 ID:             prebuilds.SystemUserID,
 Email:          "prebuilds@coder.com",
diff --git a/coderd/database/migrations/000302_system_user.down.sql b/coderd/database/migrations/000302_system_user.down.sql
 DELETE FROM users
 WHERE id = 'c42fdf75-3097-471c-8c33-fb52454d81c0';

 -- Drop index
 DROP INDEX IF EXISTS user_is_system_idx;

 -- Drop column
 ALTER TABLE users DROP COLUMN IF EXISTS is_system;
diff --git a/coderd/database/migrations/000302_system_user.up.sql b/coderd/database/migrations/000302_system_user.up.sql
 ALTER TABLE users
 ADD COLUMN is_system bool DEFAULT false NOT NULL;

 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';

 INSERT INTO users (id, email, username, name, created_at, updated_at, status, rbac_roles, hashed_password, is_system, login_type)
Original file line number	Diff line number	Diff line change
Expand Up		@@ -155,6 +155,7 @@ func New() database.Store {
		}

		q.mutex.Lock()
		// We can't insert this user using the interface, because it's a system user.
		q.data.users = append(q.data.users, database.User{
		ID: prebuilds.SystemUserID,
		Email: "prebuilds@coder.com",
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -46,8 +46,5 @@ WHERE user_id = 'c42fdf75-3097-471c-8c33-fb52454d81c0';
		DELETE FROM users
		WHERE id = 'c42fdf75-3097-471c-8c33-fb52454d81c0';

		-- Drop index
		DROP INDEX IF EXISTS user_is_system_idx;

		-- Drop column
		ALTER TABLE users DROP COLUMN IF EXISTS is_system;
Original file line number	Diff line number	Diff line change
		@@ -1,8 +1,6 @@
		ALTER TABLE users
		ADD COLUMN is_system bool DEFAULT false NOT NULL;

		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';

		INSERT INTO users (id, email, username, name, created_at, updated_at, status, rbac_roles, hashed_password, is_system, login_type)
Expand Down