We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent549fee9 commit7b082efCopy full SHA for 7b082ef
coderd/database/migrations/testdata/fixtures/000189_duplicate_user_links.up.sql
@@ -12,3 +12,8 @@ INSERT INTO public.users(id, email, username, hashed_password, created_at, updat
12
INSERT INTOpublic.organization_membersVALUES ('fc1511ef-4fcf-4a3b-98a1-8df64160e35a','bb640d07-ca8a-4869-b6bc-ae61ebb2fda1','2022-11-02 13:05:21.447595+02','2022-11-02 13:05:21.447595+02','{}')ON CONFLICT DO NOTHING;
13
INSERT INTOpublic.user_links(user_id, login_type, linked_id, oauth_access_token)
14
VALUES('fc1511ef-4fcf-4a3b-98a1-8df64160e35a','github','100','');
15
+
16
+-- Additionally, there is no unique constraint on user_id. So also add another user_link for the same user.
17
+-- This has happened on a production database.
18
+INSERT INTOpublic.user_links(user_id, login_type, linked_id, oauth_access_token)
19
+VALUES('fc1511ef-4fcf-4a3b-98a1-8df64160e35a','oidc','foo','');