coder
diff --git a/‎coderd/database/dump.sql
+11-1 b/‎coderd/database/dump.sql
+11-1
diff --git a/‎coderd/database/migrations/000258_add_otp_reset_to_user.down.sql
+5 b/‎coderd/database/migrations/000258_add_otp_reset_to_user.down.sql
+5
diff --git a/‎coderd/database/migrations/000258_add_otp_reset_to_user.up.sql
+13 b/‎coderd/database/migrations/000258_add_otp_reset_to_user.up.sql
+13
diff --git a/‎coderd/database/modelqueries.go
+3 b/‎coderd/database/modelqueries.go
+3
diff --git a/‎coderd/database/models.go
+6 b/‎coderd/database/models.go
+6
diff --git a/‎coderd/database/queries.sql.go
+68-29 b/‎coderd/database/queries.sql.go
+68-29
@@ -0,0 +1,5 @@
+ALTER TABLE users DROP CONSTRAINT one_time_passcode_set;
+
+ALTER TABLE users DROP COLUMN hashed_one_time_passcode;
+ALTER TABLE users DROP COLUMN one_time_passcode_expires_at;
+ALTER TABLE users DROP COLUMN must_reset_password;
@@ -0,0 +1,13 @@
+ALTER TABLE users ADD COLUMN hashed_one_time_passcode bytea;
+COMMENT ON COLUMN users.hashed_one_time_passcode IS 'A hash of the one-time-passcode given to the user.';
+
+ALTER TABLE users ADD COLUMN one_time_passcode_expires_at timestamp with time zone;
+COMMENT ON COLUMN users.one_time_passcode_expires_at IS 'The time when the one-time-passcode expires.';
+
+ALTER TABLE users ADD CONSTRAINT one_time_passcode_set CHECK (
+    (hashed_one_time_passcode IS NULL AND one_time_passcode_expires_at IS NULL)
+    OR (hashed_one_time_passcode IS NOT NULL AND one_time_passcode_expires_at IS NOT NULL)
+);
+
+ALTER TABLE users ADD COLUMN must_reset_password bool NOT NULL DEFAULT false;
+COMMENT ON COLUMN users.must_reset_password IS 'Determines if the user should be forced to change their password.';
@@ -364,6 +364,9 @@ func (q *sqlQuerier) GetAuthorizedUsers(ctx context.Context, arg GetUsersParams,
 			&i.ThemePreference,
 			&i.Name,
 			&i.GithubComUserID,
+			&i.HashedOneTimePasscode,
+			&i.OneTimePasscodeExpiresAt,
+			&i.MustResetPassword,
 			&i.Count,
 		); err != nil {
 			return nil, err