fix: Consolidate idx_templates_name_lower and templates_organization_id_name_idx

mafredri · mafredri · commit 1fa648909e55 · 2022-06-17T20:43:53.000+03:00
diff --git a/coderd/database/migrations/000025_allow_template_name_re_use.down.sql b/coderd/database/migrations/000025_allow_template_name_re_use.down.sql
@@ -1,4 +1,5 @@
-DROP INDEX idx_templates_name_lower;
+DROP INDEX templates_organization_id_name_idx;
+CREATE UNIQUE INDEX templates_organization_id_name_idx ON templates USING btree (organization_id, name) WHERE deleted = false;
 CREATE UNIQUE INDEX idx_templates_name_lower ON templates USING btree (lower(name));
 
 ALTER TABLE ONLY templates ADD CONSTRAINT templates_organization_id_name_key UNIQUE (organization_id, name);
diff --git a/coderd/database/migrations/000025_allow_template_name_re_use.up.sql b/coderd/database/migrations/000025_allow_template_name_re_use.up.sql
@@ -1,4 +1,5 @@
 DROP INDEX idx_templates_name_lower;
-CREATE UNIQUE INDEX idx_templates_name_lower ON templates USING btree (lower(name)) WHERE deleted = false;
+DROP INDEX templates_organization_id_name_idx;
+CREATE UNIQUE INDEX templates_organization_id_name_idx ON templates (organization_id, lower(name)) WHERE deleted = false;
 
 ALTER TABLE ONLY templates DROP CONSTRAINT templates_organization_id_name_key;
