about summary refs log tree commit diff
path: root/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
diff options
context:
space:
mode:
authorGriffin Smith <grfn@gws.fyi>2021-12-19T04·37-0500
committerclbot <clbot@tvl.fyi>2021-12-19T04·43+0000
commit2bc742964163217982d43d74e4a06968de09d67b (patch)
tree20094a736d75e839c6689de8ae79cb50af3813c5 /users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
parent1205b42ee0436287fea654510db9323e8d59a395 (diff)
feat(grfn/bbbg): Allow Organizers to sign in via Discord r/3298
Allow users with the Organizers role to sign in via a Discord Oauth2
handshake, creating a user in the users table and adding the ID of that
user to the session.

Change-Id: I39d9e17433e71b07314b9eabb787fb9214289772
Reviewed-on: https://cl.tvl.fyi/c/depot/+/4409
Tested-by: BuildkiteCI
Reviewed-by: grfn <grfn@gws.fyi>
Autosubmit: grfn <grfn@gws.fyi>
Diffstat (limited to 'users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql')
-rw-r--r--users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql b/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
index 8c3276e1e61d..9718d84748ae 100644
--- a/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
+++ b/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
@@ -26,6 +26,7 @@ CREATE TABLE "event_attendee" (
 -- ;;
 CREATE TABLE "user" (
     "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
+    "username" TEXT NOT NULL,
     "discord_user_id" TEXT NOT NULL,
     "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
 );