Add role migrations

Emyrk · Emyrk · commit 691d9a5ce0ac · 2022-04-26T21:30:42.000-05:00
diff --git a/coderd/database/migrations/000007_rbac_user_roles.down.sql b/coderd/database/migrations/000007_rbac_user_roles.down.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY workspaces
+	DROP COLUMN IF EXISTS rbac_roles;
diff --git a/coderd/database/migrations/000007_rbac_user_roles.up.sql b/coderd/database/migrations/000007_rbac_user_roles.up.sql
@@ -0,0 +1,18 @@
+ALTER TABLE ONLY users
+	ADD COLUMN IF NOT EXISTS rbac_roles text[] DEFAULT '{}' NOT NULL;
+
+-- All users are site members. So give them the standard role.
+-- Also give them membership to the first org we retrieve. We should only have
+-- 1 organization at this point in the product.
+UPDATE
+    users
+SET
+    rbac_roles = ARRAY ['member', 'organization-member:' || (SELECT id FROM organizations LIMIT 1)];
+
+-- Give the first user created the admin role
+UPDATE
+	users
+SET
+	rbac_roles = rbac_roles || ARRAY ['admin']
+WHERE
+	id = (SELECT id FROM users ORDER BY created_at ASC LIMIT 1)

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+ALTER TABLE ONLY workspaces`
	`2`	`+ DROP COLUMN IF EXISTS rbac_roles;`