Commit95d70a3

committed

remove system user index

1 parent0d4813a commit95d70a3Copy full SHA for 95d70a3

File tree

-5

lines changed

-5

lines changed

Lines changed: 1 addition & 0 deletions

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",`

Lines changed: 0 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -46,8 +46,5 @@ WHERE user_id = 'c42fdf75-3097-471c-8c33-fb52454d81c0';`
`46`	`46`	`DELETEFROM users`
`47`	`47`	`WHERE id='c42fdf75-3097-471c-8c33-fb52454d81c0';`
`48`	`48`
`49`		`--- Drop index`
`50`		`-DROPINDEX IF EXISTS user_is_system_idx;`
`51`		`-`
`52`	`49`	`-- Drop column`
`53`	`50`	`ALTERTABLE users DROP COLUMN IF EXISTS is_system;`

Lines changed: 0 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,8 +1,6 @@`
`1`	`1`	`ALTERTABLE users`
`2`	`2`	`ADD COLUMN is_system bool DEFAULT falseNOT NULL;`
`3`	`3`
`4`		`-CREATEINDEXuser_is_system_idxON users USING btree (is_system);`
`5`		`-`
`6`	`4`	`COMMENT ON COLUMN users.is_system IS'Determines if a user is a system user, and therefore cannot login or perform normal actions';`
`7`	`5`
`8`	`6`	`INSERT INTO users (id, email, username, name, created_at, updated_at, status, rbac_roles, hashed_password, is_system, login_type)`

Comments

(0)