mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
* chore: remove UpsertCustomRole in favor of Insert + Update --------- Co-authored-by: Jaayden Halko <jaayden.halko@gmail.com>
7 lines
200 B
SQL
7 lines
200 B
SQL
ALTER TABLE custom_roles
|
|
DROP CONSTRAINT custom_roles_pkey;
|
|
|
|
-- Roles are unique to the organization.
|
|
ALTER TABLE custom_roles
|
|
ADD CONSTRAINT custom_roles_unique_key UNIQUE (name, organization_id);
|