fix: Allow template names to be re-used after deletion

mafredri · mafredri · commit b1f6ec691861 · 2022-06-17T15:08:20.000+03:00
Fixes #2152
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
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
@@ -0,0 +1,4 @@
+DROP INDEX idx_templates_name_lower;
+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
@@ -0,0 +1,4 @@
+DROP INDEX idx_templates_name_lower;
+CREATE UNIQUE INDEX idx_templates_name_lower ON templates USING btree (lower(name)) WHERE deleted = false;
+
+ALTER TABLE ONLY templates DROP CONSTRAINT templates_organization_id_name_key;
