add partial fixture for CI

SasSwart · SasSwart · commit 3e86522c4ba7 · 2025-01-09T10:33:35.000Z
diff --git a/coderd/database/migrations/testdata/fixtures/000281_user_status_changes.up.sql b/coderd/database/migrations/testdata/fixtures/000281_user_status_changes.up.sql
@@ -0,0 +1,44 @@
+INSERT INTO
+	users (
+		id,
+		email,
+		username,
+		hashed_password,
+		created_at,
+		updated_at,
+		status,
+		rbac_roles,
+		login_type,
+		avatar_url,
+		deleted,
+		last_seen_at,
+		quiet_hours_schedule,
+		theme_preference,
+		name,
+		github_com_user_id,
+		hashed_one_time_passcode,
+		one_time_passcode_expires_at
+	)
+	VALUES (
+		'5755e622-fadd-44ca-98da-5df070491844', -- uuid
+		'test@example.com',
+		'testuser',
+		'hashed_password',
+		'2024-01-01 00:00:00',
+		'2024-01-01 00:00:00',
+		'active',
+		'{}',
+		'password',
+		'',
+		false,
+		'2024-01-01 00:00:00',
+		'',
+		'',
+		'',
+		123,
+		NULL,
+		NULL
+	);
+
+UPDATE users SET status = 'dormant', updated_at = '2024-01-01 01:00:00' WHERE id = '5755e622-fadd-44ca-98da-5df070491844';
+UPDATE users SET deleted = true, updated_at = '2024-01-01 02:00:00' WHERE id = '5755e622-fadd-44ca-98da-5df070491844';
