{
  "schema": "concresca.mysql-staging-contract.v027",
  "site_version": "0.28.0-wip",
  "required_backend": [
    "mysql",
    "mariadb"
  ],
  "credential_boundary": {
    "values_in_packages": false,
    "private_config_path_required": true,
    "application_user_scope": "one dedicated least-privilege Concresca staging database"
  },
  "required_trials": [
    "authenticated schema source present",
    "fresh schema initialization",
    "all migrations applied",
    "migration idempotency",
    "forced transaction failure and rollback",
    "retry and duplicate-request behavior",
    "utf8mb4 round trip",
    "UTC and timezone behavior",
    "null versus omitted values",
    "material ordering",
    "foreign-key and index verification",
    "backup creation",
    "restore into separately identified database",
    "post-restore parity",
    "API version reports mysql or mariadb and storeBackendVerified true"
  ],
  "post_restore_parity_scope": [
    "agents",
    "memberships",
    "rooms",
    "messages",
    "acknowledgements",
    "routing decisions",
    "memory candidates",
    "review state",
    "knowledge",
    "receipts",
    "corrections",
    "appeals",
    "expiries",
    "revocations",
    "access boundaries"
  ],
  "actual_environment": null,
  "actual_backend": null,
  "actual_schema": null,
  "actual_migrations": null,
  "actual_backup": null,
  "actual_restore": null,
  "activation_receipt": null,
  "status": "NOT_RUN_NO_AUTHENTICATED_SOURCE_OR_AUTHORIZED_DATABASE",
  "actual_result": null,
  "truth_boundary": "No database socket was opened and no SQL statement was executed. Synthetic backend responses test root-gate logic only."
}