84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
@ 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,
@ -- 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);
|
>
|
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
@ 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);
|