add login_type check

Emyrk · Emyrk · commit c79f10a1b4c8 · 2024-03-28T15:42:40.000-05:00
diff --git a/coderd/database/migrations/000205_unique_linked_id.up.sql b/coderd/database/migrations/000205_unique_linked_id.up.sql
@@ -11,8 +11,8 @@ SET
 			  -- When the count of linked_id is greater than 1, set the linked_id to empty
 			  SELECT  COUNT(*)
 			  FROM    user_links inn
-			  WHERE   out.linked_id = inn.linked_id
+			  WHERE   out.linked_id = inn.linked_id AND out.login_type = inn.login_type
 		  ) > 1 THEN '' ELSE out.linked_id END;
 
 -- Enforce unique linked_id constraint on non-empty linked_id
-CREATE UNIQUE INDEX idx_user_link_linked_id ON user_links USING btree (linked_id) WHERE (linked_id != '');
+CREATE UNIQUE INDEX idx_user_link_linked_id ON user_links USING btree (linked_id, login_type) WHERE (linked_id != '');
