)]}'
{
  "commit": "a2759e3317891e82aee0ef8e39155cca2d032017",
  "tree": "d1f9ccb82cceec8d655dd6d9a46722542d11df41",
  "parents": [
    "47f10d3fcd52733bec0102e1d7ba0840d0a51e1b"
  ],
  "author": {
    "name": "Jonathan Amsterdam",
    "email": "jba@google.com",
    "time": "Wed May 20 12:58:58 2026 -0400"
  },
  "committer": {
    "name": "Jonathan Amsterdam",
    "email": "jba@google.com",
    "time": "Wed Jul 08 13:44:34 2026 -0700"
  },
  "message": "db-schema.sql: dump of the DB schema\n\nThis file includes the entire database schema, as an aid to LLMs and\npeople.\n\nCurrently, the existing schema is created by using a base schema\nand then applying the migrations in the \"migrations\" directory. From\nthat information alone, it is hard to see the full schema.\n\nIt also adds devtools/dump_schema.sh, which creates the file.\n\nIt also explains the file and provides a recipe for regenerating it.\n\nChange-Id: Iba0ecb162ab743965827779e9af31c0b7d8ca065\nReviewed-on: https://go-review.googlesource.com/c/pkgsite/+/780600\nReviewed-by: Ethan Lee \u003cethanalee@google.com\u003e\nLUCI-TryBot-Result: golang-scoped@luci-project-accounts.iam.gserviceaccount.com \u003cgolang-scoped@luci-project-accounts.iam.gserviceaccount.com\u003e\nkokoro-CI: kokoro \u003cnoreply+kokoro@google.com\u003e\n",
  "tree_diff": [
    {
      "type": "modify",
      "old_id": "78a26ed551c49704944c022cf21b7658f711141d",
      "old_mode": 33261,
      "old_path": "all.bash",
      "new_id": "56928a78d49b992e6fa142cd46b1b879a19ddd6f",
      "new_mode": 33261,
      "new_path": "all.bash"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "083e314733857be73e695b813025de9e23d0e9cf",
      "new_mode": 33188,
      "new_path": "db-schema.sql"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "a2e27ee8766e1c1422cc5c8f73f7f965c15665dd",
      "new_mode": 33261,
      "new_path": "devtools/dump_schema.sh"
    },
    {
      "type": "modify",
      "old_id": "3ec62216c2fd3023871818c5da8c4a84a9c678d5",
      "old_mode": 33188,
      "old_path": "doc/postgres.md",
      "new_id": "69ec34a90a7e06076491e7a3e21c16b87fad59d6",
      "new_mode": 33188,
      "new_path": "doc/postgres.md"
    },
    {
      "type": "modify",
      "old_id": "58326a558fdd1314d221a22687f1a84d1aeb6692",
      "old_mode": 33188,
      "old_path": "migrations/000001_initial_schema_from_pg_dump.up.sql",
      "new_id": "7dbc298b91675525d386c2859a1af2186567ef34",
      "new_mode": 33188,
      "new_path": "migrations/000001_initial_schema_from_pg_dump.up.sql"
    }
  ]
}