Differences From:

File src/sample-config1.txt part of check-in [8c96ed62f5] - Continuing work on the infrastructure for tickets. by drh on 2007-11-17 17:48:46. [view]

To:

File src/sample-config1.txt part of check-in [d5e7891b07] - Add a more advanced commit-hook mechanism that allows us to specify multiple procedures in a particular order prior to commit. Continuing work toward getting tickets going. by drh on 2007-11-18 20:48:07. [view]

@@ -80,8 +80,26 @@
    contact
    title
    comment
 } /ticket_fields
+{
+   CREATE TABLE ticket(
+     -- Do not change any column that begins with tkt_
+     tkt_id INTEGER PRIMARY KEY,
+     tkt_uuid TEXT UNIQUE,
+     tkt_mtime DATE,
+     tkt_valid BOOLEAN,
+     -- Add as many field as required below this line
+     type TEXT,
+     status TEXT,
+     subsystem TEXT,
+     priority TEXT,
+     severity TEXT,
+     title TEXT,
+     comment TEXT
+   );
+   -- Add indices as desired
+} /ticket_sql set
 
 #############################################################################
 # You can define additional variables here.  These variables will be
 # accessible to the page templates when they run.