feat(coderd): add user_pinned_workspaces table

coder · johnstcn · Jan 16, 2024 · Jan 17, 2024 · Jan 17, 2024 · Jan 17, 2024
commit 46ca00df317e9400d785642ff781d21ac6deb37c
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000185_user_pinned_workspaces.down.sql b/coderd/database/migrations/000185_user_pinned_workspaces.down.sql
@@ -0,0 +1 @@
+DROP TABLE user_pinned_workspaces;
diff --git a/coderd/database/migrations/000185_user_pinned_workspaces.up.sql b/coderd/database/migrations/000185_user_pinned_workspaces.up.sql
@@ -0,0 +1,4 @@
+CREATE TABLE user_pinned_workspaces (
+	user_id uuid NOT NULL,
+	workspace_id uuid NOT NULL
+);
diff --git a/coderd/database/migrations/testdata/fixtures/000185_user_pinned_workspaces.up.sql b/coderd/database/migrations/testdata/fixtures/000185_user_pinned_workspaces.up.sql
@@ -0,0 +1,13 @@
+INSERT INTO user_pinned_workspaces
+	(user_id, workspace_id)
+VALUES (
+	'30095c71-380b-457a-8995-97b8ee6e5307',
+	'3a9a1feb-e89d-457c-9d53-ac751b198ebe'
+);
+
+INSERT INTO user_pinned_workspaces
+	(user_id, workspace_id)
+VALUES (
+	'0ed9befc-4911-4ccf-a8e2-559bf72daa94',
+	'b90547be-8870-4d68-8184-e8b2242b7c01'
+);
diff --git a/coderd/database/models.go b/coderd/database/models.go