{
  "python": "3.14.0",
  "sqlite": "3.50.4",
  "observed_defaults_not_assumed": [
    0,
    0
  ],
  "trace": [
    {
      "stage": "two_connections",
      "first": 1,
      "second": 0,
      "violations": 0
    },
    {
      "stage": "second_inserted_orphan",
      "first": 1,
      "second": 0,
      "violations": 1
    },
    {
      "stage": "enable_inside_transaction_ignored",
      "first": 1,
      "second": 0,
      "violations": 2
    },
    {
      "stage": "enabled_but_old_orphan_remains",
      "first": 1,
      "second": 1,
      "violations": 1
    },
    {
      "stage": "fixture_repaired_and_parent_delete_blocked",
      "first": 1,
      "second": 1,
      "violations": 0
    }
  ],
  "audit_columns": [
    "child_table",
    "child_rowid",
    "parent_table",
    "foreign_key_id"
  ],
  "old_violations_after_enabling": [
    [
      "child",
      20,
      "parent",
      0
    ]
  ],
  "final_child_rows": [
    [
      30,
      1
    ]
  ],
  "temporary_directory_removed": true,
  "scope": "two real connections used sequentially; no concurrent contention or production database"
}
PASS: per-connection flags, transaction no-op, historical audit, restricted delete and cleanup
