288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
|
@ -- have values assigned to them. So we are not really dealing with
@ -- tags here. These are really properties. But we are going to
@ -- keep calling them tags because in many cases the value is ignored.
@ --
@ CREATE TABLE tagxref(
@ tagid INTEGER REFERENCES tag, -- The tag that added or removed
@ tagtype INTEGER, -- 0:cancel 1:single 2:branch
@ srcid INTEGER REFERENCES blob, -- Origin of the tag. 0 for propagated tags
@ value TEXT, -- Value of the tag. Might be NULL.
@ mtime TIMESTAMP, -- Time of addition or removal
@ 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
@ --
@ -- NB: when changing the schema of the TICKET table here, also make the
|
|
>
|
|
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
|
@ -- have values assigned to them. So we are not really dealing with
@ -- tags here. These are really properties. But we are going to
@ -- keep calling them tags because in many cases the value is ignored.
@ --
@ CREATE TABLE tagxref(
@ tagid INTEGER REFERENCES tag, -- The tag that added or removed
@ tagtype INTEGER, -- 0:cancel 1:single 2:branch
@ srcid INTEGER REFERENCES blob, -- Artifact of tag. 0 for propagated tags
@ origid INTEGER REFERENCES blob, -- check-in holding propagated tag
@ value TEXT, -- Value of the tag. Might be NULL.
@ mtime TIMESTAMP, -- Time of addition or removal
@ rid INTEGER REFERENCE blob, -- Artifact tag is applied to
@ UNIQUE(rid, tagid)
@ );
@ CREATE INDEX tagxref_i1 ON tagxref(tagid, mtime);
@
@ -- Template for the TICKET table
@ --
@ -- NB: when changing the schema of the TICKET table here, also make the
|