cvsdb: The "descs" table

Hello,

I'm writing a patch which adds PostgreSQL support to ViewVC. Unlike the
patch in Issue 133, I plan to keep MySQL support. I'm also implementing
schema support (only relevant for PostgreSQL, but doesn't break MySQL).

One thing which puzzles me is the "descs" table, especially in connection
with UPDATEs. It seems that a commit message may be shared by several
checkins. This is problem if a log message is changed for a specific
commit. And, by the way, svndbadmin doesn't update log messages as it is,
as far as I can see.

Another thing: The "descs" table has a "hash" column. Am I right in
assuming that it exists for some kind of performance optimization?

Why keep log messages (commit descriptions) in a separate table anyway? I
suggest that the commit messsages be part of the "checkins" table, in a
new column of type "text". I don't know if the hash column makes sense to
keep.

-- 
Greetings from Troels Arvin