fixup! feat: add single tailnet support to pgcoord

coadler · coadler · commit 1cd56e6acc28 · 2023-08-25T23:19:13.000Z
diff --git a/coderd/database/migrations/000152_pg_coordinator_single_tailnet.down.sql b/coderd/database/migrations/000152_pg_coordinator_single_tailnet.down.sql
@@ -1,16 +1,21 @@
 BEGIN;
 
--- ALTER TABLE
--- 	tailnet_clients
--- ADD COLUMN
--- 	agent_id uuid;
+ALTER TABLE
+	tailnet_clients
+ADD COLUMN
+	agent_id uuid;
 
 UPDATE
 	tailnet_clients
 SET
 	-- grab just the first agent_id, or default to an empty UUID.
 	agent_id = COALESCE(agent_ids[0], '00000000-0000-0000-0000-000000000000'::uuid);
 
+ALTER TABLE
+	tailnet_clients
+ALTER COLUMN
+	agent_id SET NOT NULL;
+
 ALTER TABLE
 	tailnet_clients
 DROP COLUMN
