Skip to content

Commit f15b165

Browse files
DanielleMaywoodDanielleMaywood
committed
feat: add one time passcode columns to users table
1 parent ae522c5 commit f15b165

File tree

8 files changed

+118
-47
lines changed

8 files changed

+118
-47
lines changed

‎coderd/database/dump.sql

Lines changed: 10 additions & 1 deletion
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/migrations/000258_add_otp_reset_to_user.down.sql

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
ALTER TABLE users DROP COLUMN hashed_one_time_passcode;
2+
ALTER TABLE users DROP COLUMN one_time_passcode_expires_at;
3+
ALTER TABLE users DROP COLUMN must_reset_password;

‎coderd/database/migrations/000258_add_otp_reset_to_user.up.sql

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,8 @@
1+
ALTER TABLE users ADD COLUMN hashed_one_time_passcode bytea;
2+
COMMENT ON COLUMN users.hashed_one_time_passcode IS 'A hash of the one-time-passcode given to the user.';
3+
4+
ALTER TABLE users ADD COLUMN one_time_passcode_expires_at timestamp with time zone;
5+
COMMENT ON COLUMN users.one_time_passcode_expires_at IS 'The time when the one-time-passcode expires.';
6+
7+
ALTER TABLE users ADD COLUMN must_reset_password bool NOT NULL DEFAULT false;
8+
COMMENT ON COLUMN users.must_reset_password IS 'Determines if the user should be forced to change their password.';

‎coderd/database/modelqueries.go

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -364,6 +364,9 @@ func (q *sqlQuerier) GetAuthorizedUsers(ctx context.Context, arg GetUsersParams,
364364
&i.ThemePreference,
365365
&i.Name,
366366
&i.GithubComUserID,
367+
&i.HashedOneTimePasscode,
368+
&i.OneTimePasscodeExpiresAt,
369+
&i.MustResetPassword,
367370
&i.Count,
368371
); err != nil {
369372
return nil, err

‎coderd/database/models.go

Lines changed: 6 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries.sql.go

Lines changed: 68 additions & 29 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

0 commit comments

Comments
 (0)