{
  "version": "4.6.0",
  "php_files_checked": 104,
  "database_tables": 48,
  "foreign_keys": 83,
  "upgrade_add_columns_checked": 15,
  "checks": {
    "php_lint_all": true,
    "foreign_keys_valid": true,
    "table_order_valid": true,
    "all_upgrade_columns_in_fresh_db": true,
    "no_create_database": true,
    "no_use_database": true,
    "member_social_schema": true,
    "member_join_date_schema": true,
    "pre_member_social_schema": true,
    "pre_member_join_date_schema": true,
    "member_form_social": true,
    "member_form_join_date": true,
    "member_save_social": true,
    "member_search_social": true,
    "direct_import_social": true,
    "direct_import_join_date": true,
    "direct_import_blank_join_preserves_existing": true,
    "pre_import_social": true,
    "pre_import_join_date": true,
    "pre_approval_carries_social": true,
    "pre_approval_carries_join": true,
    "member_export_social_join": true,
    "template_member_exists": true,
    "template_pre_exists": true,
    "schema_helper": true,
    "upgrade_v460": true,
    "v450_preserved": true,
    "older_modules_preserved": true
  },
  "template_integrity": {
    "template_import_member.xlsx": null,
    "template_import_pra_member.xlsx": null
  },
  "foreign_key_errors": [],
  "table_order_issues": [],
  "missing_upgrade_columns": [],
  "php_lint_errors": [],
  "sql_shapes": [
    {
      "file": "members.php",
      "table": "members",
      "columns": 23,
      "placeholders": 23,
      "values_sql": "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?"
    },
    {
      "file": "import_members.php",
      "table": "members",
      "columns": 18,
      "placeholders": 18,
      "values_sql": "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?"
    },
    {
      "file": "pre_members.php",
      "table": "pre_members",
      "columns": 18,
      "placeholders": 17,
      "values_sql": "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'pending',?"
    },
    {
      "file": "pre_member_approvals.php",
      "table": "members",
      "columns": 21,
      "placeholders": 20,
      "values_sql": "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,1"
    }
  ]
}