Differences From:

File ideas.txt part of check-in [d8f27c5afd] - Notes on how to proceed with ticket integration added to ideas.txt. by drh on 2007-10-02 15:22:13. [view]

To:

File ideas.txt part of check-in [2e9d52f27f] - Begin adding the ticket configuration processing logic. by drh on 2007-10-02 18:58:44. [view]

@@ -42,9 +42,10 @@
 
 Tables:
 
    tktrid(rid, tkid, mtime);  index(tkid, mtime);
-   ticket(tkid, tkuuid, title, com, status, ...);
+   ticket(tkid, tkuuid UNIQUE, starttime, lastmod, ...);
+   tktfield(fieldname UNIQUE, type, width, other);
    tktxref(tkid, mid); index(tkid); index(mid);
 
 Tktformat in the config table.
 
@@ -70,10 +71,12 @@
    * Configuration file parser
        + tkt-new-template
        + tkt-view-template
        + tkt-edit-template
-
+       + Reconstruct the ticket table schema
+       + Repopulate tktfield
    * Ticket control file parser
+       +
    * Transfer tkt control info to ticket table
    * Setup pages for selecting and editing ticket configuration
    * Ticket display
    * New ticket creation display