remove system user index

SasSwart · SasSwart · commit 95d70a30762d · 2025-03-20T06:39:26.000Z
diff --git a/coderd/database/dbmem/dbmem.go b/coderd/database/dbmem/dbmem.go
@@ -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",
diff --git a/coderd/database/migrations/000302_system_user.down.sql b/coderd/database/migrations/000302_system_user.down.sql
@@ -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;
diff --git a/coderd/database/migrations/000302_system_user.up.sql b/coderd/database/migrations/000302_system_user.up.sql
@@ -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)

Original file line number	Diff line number	Diff line change
`@@ -155,6 +155,7 @@ func New() database.Store {`
`155`	`155`	`}`
`156`	`156`
`157`	`157`	`q.mutex.Lock()`
	`158`	`+ // We can't insert this user using the interface, because it's a system user.`
`158`	`159`	`q.data.users = append(q.data.users, database.User{`
`159`	`160`	`ID: prebuilds.SystemUserID,`
`160`	`161`	`Email: "prebuilds@coder.com",`