Differences From Artifact [65b308cd4d]:

• File src/schema.c — part of check-in [d681e1dc1d] at 2022-05-01 21:00:31 on branch tkt-ucard — Add support for optional <var>tkt_ucard</var> column of the <var>TICKETCHNG</var> table. If this column is present then its value is populated from the [/doc/tkt-ucard/www/fileformat.wiki#tktchng|U-card] of the corresponding artifact. (user: george size: 25551)

To Artifact [e616ccdd46]:

• File src/schema.c — part of check-in [6d95ae4f88] at 2022-05-08 20:40:55 on branch tkt-ucard — Rename proposed column to <var>tkt_user</var> which seems more natural. Amend default schema to create this column (and also drop a nearby comment). Add a tiny optimization to <code>getAllTicketFields()</code>. (user: george size: 25518) [more...]

456
457
458
459
460
461
462
463
464
465
466
467
468
469
470

@   comment TEXT
@ );
@ CREATE TABLE ticketchng(
@   -- Do not change any column that begins with tkt_
@   tkt_id INTEGER REFERENCES ticket,
@   tkt_rid INTEGER REFERENCES blob,
@   tkt_mtime DATE,
@   -- tkt_ucard TEXT, -- optional predefined field
@   -- Add as many fields as required below this line
@   login TEXT,
@   username TEXT,
@   mimetype TEXT,
@   icomment TEXT
@ );
@ CREATE INDEX ticketchng_idx1 ON ticketchng(tkt_id, tkt_mtime);

|

456
457
458
459
460
461
462
463
464
465
466
467
468
469
470

@   comment TEXT
@ );
@ CREATE TABLE ticketchng(
@   -- Do not change any column that begins with tkt_
@   tkt_id INTEGER REFERENCES ticket,
@   tkt_rid INTEGER REFERENCES blob,
@   tkt_mtime DATE,
@   tkt_user TEXT,
@   -- Add as many fields as required below this line
@   login TEXT,
@   username TEXT,
@   mimetype TEXT,
@   icomment TEXT
@ );
@ CREATE INDEX ticketchng_idx1 ON ticketchng(tkt_id, tkt_mtime);