150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
|
@ 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
@ );
@ CREATE INDEX event_i1 ON event(mtime);
@ CREATE INDEX event_i2 ON event(objid);
|
|
|
|
|
|
|
<
|
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
|
@ UNIQUE(pid, cid)
@ );
@ CREATE INDEX plink_i2 ON plink(cid);
@
@ -- Events used to generate a timeline
@ --
@ CREATE TABLE event(
@ 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);
@
@ -- 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
@ );
|
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
|
@ -- 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
@ );
@
@ -- Aggregated ticket information
@ --
@ CREATE TABLE tkt(
@ tktid INTEGER PRIMARY KEY, -- Internal ticket ID
@ fnid INTEGER REFERENCES filename, -- Name of the ticket file
@ 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 tktmap(
@ tktid INTEGER REFERENCES tkt, -- This ticket
@ tagid INTEGER REFERENCES tkttag, -- ....holds this tag
@ UNIQUE(tktid, tagid)
@ );
@ CREATE INDEX tktmap_i2 ON tktmap(tagid);
|
>
|
|
<
|
|
<
<
<
|
|
|
|
>
>
>
|
|
>
|
>
>
|
<
|
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
|
@ -- 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
@ -- is defined by a row in the next table.
@ --
@ -- Tags that begin with "br" automatically propagate to direct
@ -- children, but not to merge children.
@ --
@ 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 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)
@ );
;
/*
** 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.
*/
|