fix: update testdata fixtures again

DanielleMaywood · DanielleMaywood · commit 61c26eab00c1 · 2024-09-20T08:40:05.000Z
diff --git a/coderd/database/migrations/testdata/fixtures/000157_workspace_agent_script.up.sql b/coderd/database/migrations/testdata/fixtures/000157_workspace_agent_script.up.sql
@@ -15,7 +15,6 @@ INSERT INTO workspace_agent_log_sources (
 ) ON CONFLICT DO NOTHING;
 
 INSERT INTO workspace_agent_scripts (
-    id,
 	workspace_agent_id,
 	created_at,
 	log_source_id,
@@ -27,7 +26,6 @@ INSERT INTO workspace_agent_scripts (
 	run_on_stop,
 	timeout_seconds
 ) VALUES (
-	'a810e1ba-0b28-4db2-a5b6-1857ea72bf93',
 	'45e89705-e09d-4850-bcec-f9a937f5d78d',
 	'2022-11-02 13:03:45.046432+02',
 	'0ff953c0-92a6-4fe6-a415-eb0139a36ad1',
diff --git a/coderd/database/migrations/testdata/fixtures/000255_workspace_agent_script_timings.up.sql b/coderd/database/migrations/testdata/fixtures/000255_workspace_agent_script_timings.up.sql
@@ -1,3 +1,3 @@
 INSERT INTO workspace_agent_script_timings (script_id, display_name, started_at, ended_at, exit_code, ran_on_start, blocked_login)
 VALUES
-    ('a810e1ba-0b28-4db2-a5b6-1857ea72bf93', 'Startup Script', NOW() - INTERVAL '1 hour 55 minutes', NOW() - INTERVAL '1 hour 50 minutes', 0, true, false);
+    ((SELECT id FROM workspace_agent_scripts LIMIT 1), 'Startup Script', NOW() - INTERVAL '1 hour 55 minutes', NOW() - INTERVAL '1 hour 50 minutes', 0, true, false);
