1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
/* Binary form of file ./sql/ticket-reports.sql */
/** @page page_schema_ticket_reports_cstr Schema: ticket-reports.sql
@code
INSERT INTO reportfmt(title,mtime,cols,sqlcode)
VALUES('All Tickets',julianday('1970-01-01'),'#ffffff Key:
#f2dcdc Active
#e8e8e8 Review
#cfe8bd Fixed
#bde5d6 Tested
#cacae5 Deferred
#c8c8c8 Closed','SELECT
CASE WHEN status IN (''Open'',''Verified'') THEN ''#f2dcdc''
WHEN status=''Review'' THEN ''#e8e8e8''
WHEN status=''Fixed'' THEN ''#cfe8bd''
WHEN status=''Tested'' THEN ''#bde5d6''
WHEN status=''Deferred'' THEN ''#cacae5''
ELSE ''#c8c8c8'' END AS ''bgcolor'',
substr(tkt_uuid,1,10) AS ''#'',
datetime(tkt_mtime) AS ''mtime'',
type,
status,
subsystem,
title
FROM ticket');
@endcode
@see schema_ticket_reports()
|
<
|
|
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
|
|
<
|
1
2
3
4
5
6
7
8
9
10
11
|
/** @page page_schema_ticket_reports_cstr ticket-reports.sql
Binary form of file ./sql/ticket-reports.sql.
*/
/* auto-generated code - edit at your own risk! (Good luck with that!) */
static char const fsl_schema_ticket_reports_cstr_a[] = {
73, 78, 83, 69, 82, 84, 32, 73, 78, 84, 79, 32, 114, 101, 112, 111, 114, 116, 102, 109,
116, 40, 116, 105, 116, 108, 101, 44, 109, 116, 105, 109, 101, 44, 99, 111, 108, 115, 44, 115,
113, 108, 99, 111, 100, 101, 41, 32, 10, 86, 65, 76, 85, 69, 83, 40, 39, 65, 108, 108,
32, 84, 105, 99, 107, 101, 116, 115, 39, 44, 106, 117, 108, 105, 97, 110, 100, 97, 121, 40,
|