coder
diff --git a/‎coderd/database/dbmem/dbmem.go
Lines changed: 0 additions & 6 deletions b/‎coderd/database/dbmem/dbmem.go
Lines changed: 0 additions & 6 deletions
diff --git a/‎coderd/database/dump.sql
Lines changed: 0 additions & 3 deletions b/‎coderd/database/dump.sql
Lines changed: 0 additions & 3 deletions
diff --git a/‎coderd/database/migrations/000346_remove_oauth2_app_name_unique_constraint.down.sql
Lines changed: 3 additions & 0 deletions b/‎coderd/database/migrations/000346_remove_oauth2_app_name_unique_constraint.down.sql
Lines changed: 3 additions & 0 deletions
diff --git a/‎coderd/database/migrations/000346_remove_oauth2_app_name_unique_constraint.up.sql
Lines changed: 3 additions & 0 deletions b/‎coderd/database/migrations/000346_remove_oauth2_app_name_unique_constraint.up.sql
Lines changed: 3 additions & 0 deletions
diff --git a/‎coderd/database/unique_constraint.go
Lines changed: 0 additions & 1 deletion b/‎coderd/database/unique_constraint.go
Lines changed: 0 additions & 1 deletion
@@ -8971,12 +8971,6 @@ func (q *FakeQuerier) InsertOAuth2ProviderApp(_ context.Context, arg database.In
 	q.mutex.Lock()
 	defer q.mutex.Unlock()
 
-	for _, app := range q.oauth2ProviderApps {
-		if app.Name == arg.Name {
-			return database.OAuth2ProviderApp{}, errUniqueConstraint
-		}
-	}
-
 	//nolint:gosimple // Go wants database.OAuth2ProviderApp(arg), but we cannot be sure the structs will remain identical.
 	app := database.OAuth2ProviderApp{
 		ID:                      arg.ID,
 
@@ -0,0 +1,3 @@
+-- Restore unique constraint on oauth2_provider_apps.name for rollback
+-- Note: This rollback may fail if duplicate names exist in the database
+ALTER TABLE oauth2_provider_apps ADD CONSTRAINT oauth2_provider_apps_name_key UNIQUE (name);
@@ -0,0 +1,3 @@
+-- Remove unique constraint on oauth2_provider_apps.name to comply with RFC 7591
+-- RFC 7591 does not require unique client names, only unique client IDs
+ALTER TABLE oauth2_provider_apps DROP CONSTRAINT oauth2_provider_apps_name_key;
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+-- Restore unique constraint on oauth2_provider_apps.name for rollback`
	`2`	`+-- Note: This rollback may fail if duplicate names exist in the database`
	`3`	`+ALTER TABLE oauth2_provider_apps ADD CONSTRAINT oauth2_provider_apps_name_key UNIQUE (name);`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+-- Remove unique constraint on oauth2_provider_apps.name to comply with RFC 7591`
	`2`	`+-- RFC 7591 does not require unique client names, only unique client IDs`
	`3`	`+ALTER TABLE oauth2_provider_apps DROP CONSTRAINT oauth2_provider_apps_name_key;`