#
#
# patch "NEWS"
#  from [ccebca5f660b9bdaeb5115cf72ad0c24dc76a6fe]
#    to [1498d5c14a0f782bb07967b8184c9febac392820]
# 
# patch "schema_migration.cc"
#  from [8ea29024b6a2dc1796e0fd81fe9640a151da571e]
#    to [134c3f6b56172722a4679709ebcd2de8a7b33947]
#
============================================================
--- NEWS	ccebca5f660b9bdaeb5115cf72ad0c24dc76a6fe
+++ NEWS	1498d5c14a0f782bb07967b8184c9febac392820
@@ -45,6 +45,16 @@
           directories. The typical case of listing files that need attention
           now runs at least four times faster.
 
+        Internal
+
+        - switched to storing binary sha1 hashes, instead of an ASCII
+          compliant hexadecimal encoding of the hash.
+          The newly added sqlite function unhex(), the built-in quote()
+          function as well as the built-in hex notation (i.e. x'deadbeef')
+          help with handling these binary hashes.
+
+        - merged the two indexes on revision_certs into a single one.
+
 Wed Dec 12 21:21:15 UTC 2007
 
         0.38 release.
============================================================
--- schema_migration.cc	8ea29024b6a2dc1796e0fd81fe9640a151da571e
+++ schema_migration.cc	134c3f6b56172722a4679709ebcd2de8a7b33947
@@ -647,7 +647,7 @@ char const migrate_to_binary_hashes[] =
   "UPDATE roster_deltas     SET id=unhex(id), base=unhex(base);"
   "UPDATE public_keys       SET hash=unhex(hash);"
 
-  // revision_certs also gets a new indices, so we recreate the
+  // revision_certs also gets a new index, so we recreate the
   // table completely.
   "ALTER TABLE revision_certs RENAME TO tmp;\n"
   "CREATE TABLE revision_certs"