add migration to fix any custom roles out there

Emyrk · Emyrk · commit 6efc8d6d19e9 · 2024-06-03T16:13:37.000-05:00
diff --git a/coderd/database/migrations/000214_org_custom_role_array.down.sql b/coderd/database/migrations/000214_org_custom_role_array.down.sql
@@ -0,0 +1 @@
+UPDATE custom_roles SET org_permissions = '{}';
diff --git a/coderd/database/migrations/000214_org_custom_role_array.up.sql b/coderd/database/migrations/000214_org_custom_role_array.up.sql
@@ -0,0 +1,4 @@
+-- Previous custom roles are now invalid, as the json changed. Since this is an
+-- experimental feature, there is no point in trying to save the perms.
+-- This does not elevate any permissions, so it is not a security issue.
+UPDATE custom_roles SET org_permissions = '[]';

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+UPDATE custom_roles SET org_permissions = '{}';`