On Fri, Feb 19, 2010 at 08:13, <julianf...@apache.org> wrote: >... > +++ subversion/trunk/subversion/libsvn_wc/wc-metadata.sql Fri Feb 19 13:13:09 > 2010 > @@ -172,7 +172,9 @@ > and ACTUAL_NODE tables. > */ > CREATE TABLE PRISTINE ( > - /* ### the hash algorithm (MD5 or SHA-1) is encoded in this value */ > + /* The SHA-1 checksum of the pristine text. This is a unique key. The > + SHA-1 checksum of a pristine text is assumed to be unique among all > + pristine texts referenced from this database. */ > checksum TEXT NOT NULL PRIMARY KEY,
That comment is now redundant with the PRIMARY KEY attached to that column. > /* ### enumerated values specifying type of compression. NULL implies > @@ -189,7 +191,8 @@ > refcount INTEGER NOT NULL, > > /* Alternative MD5 checksum used for communicating with older > - repositories. */ > + repositories. Not guaranteed to be unique among table rows. pfft. riiiiiight. > + NULL if not (yet) calculated. */ > md5_checksum TEXT > ); > > > >
