Fossil: Diff

Differences From:

File src/schema.c part of check-in [525cc35bf3] - Allow the check-in of files show names begin with ".". Add the "private" table to repository schema but do not yet do anything with it. by drh on 2008-05-17 08:53:34. [view]

To:

File src/schema.c part of check-in [243e02bfbd] - Improvements to cloning performance. by drh on 2008-05-18 15:51:05. [view]

@@ -74,10 +74,11 @@
 @ CREATE TABLE blob(
 @   rid INTEGER PRIMARY KEY,        -- Record ID
 @   rcvid INTEGER,                  -- Origin of this record
 @   size INTEGER,                   -- Size of content. -1 for a phantom.
-@   uuid TEXT UNIQUE,               -- SHA1 hash of the content
-@   content BLOB                    -- Compressed content of this record
+@   uuid TEXT UNIQUE NOT NULL,      -- SHA1 hash of the content
+@   content BLOB,                   -- Compressed content of this record
+@   CHECK( length(uuid)==40 AND rid>0 )
 @ );
 @ CREATE TABLE delta(
 @   rid INTEGER PRIMARY KEY,                 -- Record ID
 @   srcid INTEGER NOT NULL REFERENCES blob   -- Record holding source document