mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
6 lines
358 B
SQL
6 lines
358 B
SQL
CREATE UNIQUE INDEX idx_provisioner_daemons_org_name_owner_key ON provisioner_daemons USING btree (organization_id, name, lower(COALESCE((tags ->> 'owner'::text), ''::text)));
|
|
|
|
COMMENT ON INDEX idx_provisioner_daemons_org_name_owner_key IS 'Allow unique provisioner daemon names by organization and user';
|
|
|
|
DROP INDEX idx_provisioner_daemons_name_owner_key;
|