)]}'
{
  "commit": "7b88add315ec8db264ab379f7a83e96a17385e67",
  "tree": "6f712e89ffad13528038a7fedfac40a4132c835b",
  "parents": [
    "910d957c86c24bdc20a7375b3da86f028dc52be7"
  ],
  "author": {
    "name": "Shawn O. Pearce",
    "email": "sop@google.com",
    "time": "Wed Sep 28 23:36:48 2011 -0700"
  },
  "committer": {
    "name": "Shawn O. Pearce",
    "email": "sop@google.com",
    "time": "Wed Sep 28 23:36:48 2011 -0700"
  },
  "message": "MySQL: Declare VARCHAR columns as BINARY\n\nIn MySQL a VARCHAR column that is a member of a table\u0027s primary\nkey will be treated as case-insensitive, that is \"BOB\" and \"bob\"\nare identical and cannot both appear in the table.  This does not\nmatch with the other implementations that gwtorm supports, in both\nH2 and PostgreSQL these are distinct rows, and Gerrit Code Review\nrelies on this to support projects like the Linux kernel where\nfiles may appear in the same directory and differ only by case.\n\nDeclare all MySQL varchar columns as binary to ensure the server\nuses case-sensitive sorting and compare rules.\n\nChange-Id: Idebf6994f71c3a054d003b8061abaff48c113ed5\nSigned-off-by: Shawn O. Pearce \u003csop@google.com\u003e\n",
  "tree_diff": [
    {
      "type": "modify",
      "old_id": "f19f4e6d92f3d96f9d9bb6f65a7370defa93e3dd",
      "old_mode": 33188,
      "old_path": "pom.xml",
      "new_id": "6eae2e448ce8cedfc42e3144fa01093fbbc1b14f",
      "new_mode": 33188,
      "new_path": "pom.xml"
    },
    {
      "type": "modify",
      "old_id": "f81ad334b84ee7b4d8ccf936810d4a66ebd2f6fa",
      "old_mode": 33188,
      "old_path": "src/main/java/com/google/gwtorm/schema/sql/DialectMySQL.java",
      "new_id": "fed1c61f7a37b567ad88e1b40caaba1ab0daf41c",
      "new_mode": 33188,
      "new_path": "src/main/java/com/google/gwtorm/schema/sql/DialectMySQL.java"
    }
  ]
}