-- AUDIT-2 #17e (2026-05-24): drop SyntheticTest{,Run,StepResult} tables.
--
-- The feature was half-shipped — schema + UI shells were present but no
-- worker code path actually executed synthetic tests. Live DB had 0
-- rows in any of the three tables at removal time (verified via row
-- counts before this migration). Dropping is safe.
--
-- Drop order is leaves-first to avoid FK violations:
--   1. SyntheticTestStepResult depends on SyntheticTestRun
--   2. SyntheticTestRun depends on SyntheticTest
--   3. SyntheticTest is the root

DROP TABLE IF EXISTS `SyntheticTestStepResult`;
DROP TABLE IF EXISTS `SyntheticTestRun`;
DROP TABLE IF EXISTS `SyntheticTest`;