Differences From:

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

To:

File src/schema.c part of check-in [a48474bc75] - Improvements to the shunning algorithm. Add the shun page and an opportunity to shun or unshun artifacts in the artifact viewer. by drh on 2008-05-29 01:58:15. [view]

@@ -245,8 +245,10 @@
 @ INSERT INTO tag VALUES(1, 'bgcolor');         -- TAG_BGCOLOR
 @ INSERT INTO tag VALUES(2, 'comment');         -- TAG_COMMENT
 @ INSERT INTO tag VALUES(3, 'user');            -- TAG_USER
 @ INSERT INTO tag VALUES(4, 'hidden');          -- TAG_HIDDEN
+@ INSERT INTO tag VALUES(5, 'private');         -- TAG_PRIVATE
+@ INSERT INTO tag VALUES(6, 'cluster');         -- TAG_CLUSTER
 @
 @ -- Assignments of tags to baselines.  Note that we allow tags to
 @ -- have values assigned to them.  So we are not really dealing with
 @ -- tags here.  These are really properties.  But we are going to
@@ -261,18 +263,29 @@
 @   rid INTEGER REFERENCE blob,     -- Baseline that tag added/removed from
 @   UNIQUE(rid, tagid)
 @ );
 @ CREATE INDEX tagxref_i1 ON tagxref(tagid, mtime);
+@
+@ -- Template for the TICKET table
+@ --
+@ CREATE TABLE ticket(
+@   tkt_id INTEGER PRIMARY KEY,
+@   tkt_uuid TEXT,
+@   tkt_mtime REAL,
+@   UNIQUE(tkt_uuid, tkt_mtime)
+@ );
 ;
 
 /*
 ** Predefined tagid values
 */
 #if INTERFACE
-# define TAG_BGCOLOR    1
-# define TAG_COMMENT    2
-# define TAG_USER       3
-# define TAG_HIDDEN     4
+# define TAG_BGCOLOR    1     /* Set the background color for display */
+# define TAG_COMMENT    2     /* The check-in comment */
+# define TAG_USER       3     /* User who made a checking */
+# define TAG_HIDDEN     4     /* Do not display or sync */
+# define TAG_PRIVATE    5     /* Display but do not sync */
+# define TAG_CLUSTER    6     /* A cluster */
 #endif
 
 /*
 ** The schema for the locate FOSSIL database file found at the root