Diff
Not logged in

Differences From:

File src/schema.c part of check-in [e38fc922a5] - Remove unused hard-coded tags from the schema. Output a row count as a status indicator when doing a rebuild. by drh on 2007-10-11 01:17:20. [view]

To:

File src/schema.c part of check-in [62f37c9722] - Begin porting the CVSTrac ticket reporting code over to fossil. The new code is not yet connected into the system. The port is incomplete. by drh on 2007-11-26 01:33:50. Also file src/schema.c part of check-in [d0305b305a] - Merged mainline into my branch to get the newest application. by aku on 2007-12-05 08:07:46. [view]

@@ -123,9 +123,21 @@
 @ -- spam can be shunned in order to prevent them from contaminating
 @ -- the repository.
 @ --
 @ CREATE TABLE shun(uuid UNIQUE);
+@
+@ -- An entry in this table describes a database query that generates a
+@ -- table of tickets.
+@ --
+@ CREATE TABLE reportfmt(
+@    rn integer primary key,  -- Report number
+@    owner text,              -- Owner of this report format (not used)
+@    title text,              -- Title of this report
+@    cols text,               -- A color-key specification
+@    sqlcode text             -- An SQL SELECT statement for this report
+@ );
 ;
+
 const char zRepositorySchema2[] =
 @ -- Filenames
 @ --
 @ CREATE TABLE filename(