@   UNIQUE(pid, cid)
@ );
@ CREATE INDEX plink_i2 ON plink(cid);
@
@ -- Events used to generate a timeline
@ --
@ CREATE TABLE event(
@   type TEXT,
@   mtime DATETIME,
@   objid INTEGER,
@   uid INTEGER REFERENCES user,
@   user TEXT,
@   comment TEXT
@   type TEXT,                      -- Type of event
@   mtime DATETIME,                 -- Date and time when the event occurs
@   objid INTEGER PRIMARY KEY,      -- Associated record ID
@   uid INTEGER REFERENCES user,    -- User who caused the event
@   user TEXT,                      -- Name of the user
@   comment TEXT                    -- Comment describing the event
@ );
@ CREATE INDEX event_i1 ON event(mtime);
@ CREATE INDEX event_i2 ON event(objid);
@
@ -- A record of phantoms.  A phantom is a record for which we know the
@ -- UUID but we do not (yet) know the file content.
@ --
@ CREATE TABLE phantom(
@   rid INTEGER PRIMARY KEY         -- Record ID of the phantom
@ );

@ -- used to reduce push operations to a single HTTP request in the
@ -- common case when one repository only talks to a single server.
@ --
@ CREATE TABLE unsent(
@   rid INTEGER PRIMARY KEY         -- Record ID of the phantom
@ );
@
@ -- Each baseline or manifest can have one or more tags.  A tag
@ -- Aggregated ticket information
@ --
@ -- is defined by a row in the next table.
@ -- 
@ CREATE TABLE tkt(
@   tktid INTEGER PRIMARY KEY,           -- Internal ticket ID
@   fnid INTEGER REFERENCES filename,    -- Name of the ticket file
@ -- Tags that begin with "br" automatically propagate to direct
@ -- children, but not to merge children.
@   rid INTEGER REFERENCES blob,         -- version of ticket file scanned
@   title TEXT,                          -- title of the ticket
@   remarks TEXT                         -- text of the ticket
@ );
@ CREATE TABLE tkttag(
@   tagid INTEGER PRIMARY KEY,           -- Numeric tag ID
@   name TEXT UNIQUE                     -- Human-readable name of tag
@ --
@ CREATE TABLE tag(
@   tagid INTEGER PRIMARY KEY,       -- Numeric tag ID
@   tagname TEXT UNIQUE              -- Tag name.  Prefixed by 'v' or 'b'
@ );
@
@ -- Assignments of tags to baselines
@ --
@ CREATE TABLE tktmap(
@   tktid INTEGER REFERENCES tkt,        -- This ticket
@   tagid INTEGER REFERENCES tkttag,     --    ....holds this tag
@   UNIQUE(tktid, tagid)
@ CREATE TABLE tagxref(
@   tagid INTEGER REFERENCES tag,   -- The tag that added or removed
@   addFlag BOOLEAN,                -- True to add the tag, False to remove
@   srcid INTEGER REFERENCES blob,  -- Origin of the tag. 0 for propagated tags
@   mtime TIMESTAMP,                -- Time of addition or removal
@   rid INTEGER REFERENCE blob,     -- Baseline that tag added/removed from
@   UNIQUE(rid, tagid)
@ );
@ CREATE INDEX tktmap_i2 ON tktmap(tagid);
;

/*
** The schema for the locate FOSSIL database file found at the root
** of very check-out.  This database contains the complete state of
** the checkout.
*/