8c96ed62f5 2007-11-17 drh: # This is a sample "ticket configuration" file for fossil. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # There is considerable flexibility in how tickets are defined 8c96ed62f5 2007-11-17 drh: # in fossil. Each repository can define its own ticket setup 8c96ed62f5 2007-11-17 drh: # differently. Each repository has an instance of a file, like 8c96ed62f5 2007-11-17 drh: # this one that defines how that repository deals with tickets. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # This file is in the form of a script in an exceedingly 8c96ed62f5 2007-11-17 drh: # minimalist scripting language called "subscript". Here are 8c96ed62f5 2007-11-17 drh: # the rules: 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # SYNTAX 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * The script consists of a sequence of whitespace 8c96ed62f5 2007-11-17 drh: # separated tokens. Whitespace is ignored, except 8c96ed62f5 2007-11-17 drh: # as its role as a token separator. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * Lines that begin with '#' are considered to be whitespace. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * Text within matching {...} is consider to be a single "string" 8c96ed62f5 2007-11-17 drh: # token, even if the text spans multiple lines and includes 8c96ed62f5 2007-11-17 drh: # embedded whitespace. The outermost {...} are not part of 8c96ed62f5 2007-11-17 drh: # the text of the token. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * A token that begins with "/" is a string token. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * A token that looks like a number is a string token. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * Tokens that do not fall under the previous three rules 8c96ed62f5 2007-11-17 drh: # are "verb" tokens. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # PROCESSING: 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * When a script is processed, the engine reads tokens 8c96ed62f5 2007-11-17 drh: # one by one. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * String tokens are pushed onto the stack. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * Verb tokens which correspond to the names of variables 8c96ed62f5 2007-11-17 drh: # cause the corresponding variable to be pushed onto the 8c96ed62f5 2007-11-17 drh: # stack. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # * Verb tokens which correspond to procedures cause the 8c96ed62f5 2007-11-17 drh: # procedures to run. The procedures might push or pull 8c96ed62f5 2007-11-17 drh: # values from the stack. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # There are just a handful of verbs. For the purposes of this 8c96ed62f5 2007-11-17 drh: # configuration script, there is only a single verb: "set". The 8c96ed62f5 2007-11-17 drh: # "set" verb pops two arguments from the stack. The topmost is 8c96ed62f5 2007-11-17 drh: # the name of a variable. The second element is the value. The 8c96ed62f5 2007-11-17 drh: # "set" verb sets the value of the named variable. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # VALUE NAME set 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # This configuration file just sets the values of various variables. 8c96ed62f5 2007-11-17 drh: # Some of the variables have special meanings. The content of some 8c96ed62f5 2007-11-17 drh: # of the variables are additional subscript scripts. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: ############################################################################ 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: # Every ticket configuration file should have a title. When you 8c96ed62f5 2007-11-17 drh: # come up with a new ticket configuration, please change the title 8c96ed62f5 2007-11-17 drh: # to something descriptive. 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: {Default Ticket Configuration} /ticket_config_title set 8c96ed62f5 2007-11-17 drh: 8c96ed62f5 2007-11-17 drh: ############################################################################ 8c96ed62f5 2007-11-17 drh: # Every ticket configuration *must* define a set of columns for the 8c96ed62f5 2007-11-17 drh: # "ticket" table of the database. These column names will also be 8c96ed62f5 2007-11-17 drh: # used as CGI parameter names, so to avoid problems it is best that 8c96ed62f5 2007-11-17 drh: # the names be all lower-case alphabetic characters. The names must 8c96ed62f5 2007-11-17 drh: # be unique and must not begin with "tkt_". 8c96ed62f5 2007-11-17 drh: # 8c96ed62f5 2007-11-17 drh: { 8c96ed62f5 2007-11-17 drh: type 8c96ed62f5 2007-11-17 drh: status 8c96ed62f5 2007-11-17 drh: subsystem 8c96ed62f5 2007-11-17 drh: priority 8c96ed62f5 2007-11-17 drh: severity 8c96ed62f5 2007-11-17 drh: contact 8c96ed62f5 2007-11-17 drh: title 8c96ed62f5 2007-11-17 drh: comment 8c96ed62f5 2007-11-17 drh: } /ticket_fields d5e7891b07 2007-11-18 drh: { d5e7891b07 2007-11-18 drh: CREATE TABLE ticket( d5e7891b07 2007-11-18 drh: -- Do not change any column that begins with tkt_ d5e7891b07 2007-11-18 drh: tkt_id INTEGER PRIMARY KEY, d5e7891b07 2007-11-18 drh: tkt_uuid TEXT UNIQUE, d5e7891b07 2007-11-18 drh: tkt_mtime DATE, d5e7891b07 2007-11-18 drh: tkt_valid BOOLEAN, d5e7891b07 2007-11-18 drh: -- Add as many field as required below this line d5e7891b07 2007-11-18 drh: type TEXT, d5e7891b07 2007-11-18 drh: status TEXT, d5e7891b07 2007-11-18 drh: subsystem TEXT, d5e7891b07 2007-11-18 drh: priority TEXT, d5e7891b07 2007-11-18 drh: severity TEXT, d5e7891b07 2007-11-18 drh: title TEXT, d5e7891b07 2007-11-18 drh: comment TEXT d5e7891b07 2007-11-18 drh: ); d5e7891b07 2007-11-18 drh: -- Add indices as desired d5e7891b07 2007-11-18 drh: } /ticket_sql set 8c96ed62f5 2007-11-17 drh: 8c96ed62f5 2007-11-17 drh: ############################################################################# 8c96ed62f5 2007-11-17 drh: # You can define additional variables here. These variables will be 8c96ed62f5 2007-11-17 drh: # accessible to the page templates when they run. 8c96ed62f5 2007-11-17 drh: # d29dd11f2e 2007-10-14 drh: {Code Build_Problem Documentation Feature_Request Incident} /type_choices set d29dd11f2e 2007-10-14 drh: {High Medium Low} /priority_choices set d29dd11f2e 2007-10-14 drh: {Critical Severe Important Minor Cosmetic} /severity_choices set d29dd11f2e 2007-10-14 drh: { d29dd11f2e 2007-10-14 drh: Open d29dd11f2e 2007-10-14 drh: Fixed d29dd11f2e 2007-10-14 drh: Rejected d29dd11f2e 2007-10-14 drh: Unable_To_Reproduce d29dd11f2e 2007-10-14 drh: Works_As_Designed d29dd11f2e 2007-10-14 drh: External_Bug d29dd11f2e 2007-10-14 drh: Not_A_Bug d29dd11f2e 2007-10-14 drh: Duplicate d29dd11f2e 2007-10-14 drh: Overcome_By_Events d29dd11f2e 2007-10-14 drh: Drive_By_Patch d29dd11f2e 2007-10-14 drh: } /resolution_choices set d29dd11f2e 2007-10-14 drh: { d29dd11f2e 2007-10-14 drh: Open d29dd11f2e 2007-10-14 drh: Verified d29dd11f2e 2007-10-14 drh: In_Process d29dd11f2e 2007-10-14 drh: Deferred d29dd11f2e 2007-10-14 drh: Fixed d29dd11f2e 2007-10-14 drh: Tested d29dd11f2e 2007-10-14 drh: Closed d29dd11f2e 2007-10-14 drh: } /status_choices set 8c96ed62f5 2007-11-17 drh: 8c96ed62f5 2007-11-17 drh: ############################################################################ 8c96ed62f5 2007-11-17 drh: # The "tktnew_template" variable is set to text which is a template for 8c96ed62f5 2007-11-17 drh: # the HTML of the "New Ticket" page. Within this template, text contained 8c96ed62f5 2007-11-17 drh: # within [...] is subscript. That subscript runs when the page is 8c96ed62f5 2007-11-17 drh: # rendered. 8c96ed62f5 2007-11-17 drh: # d29dd11f2e 2007-10-14 drh: { 8c96ed62f5 2007-11-17 drh: <!-- load database field names not found in CGI with an empty string --> 8c96ed62f5 2007-11-17 drh: <!-- start a form --> 8c96ed62f5 2007-11-17 drh: [{Open} /status set /submit submit_new_ticket] d29dd11f2e 2007-10-14 drh: <table cellpadding="5"> d29dd11f2e 2007-10-14 drh: <tr> d29dd11f2e 2007-10-14 drh: <td cellpadding="2"> d29dd11f2e 2007-10-14 drh: Enter a one-line summary of the problem:<br> 8c96ed62f5 2007-11-17 drh: <input type="text" name="title" size="60" value="[title html]"> d29dd11f2e 2007-10-14 drh: </td> d29dd11f2e 2007-10-14 drh: </tr> d29dd11f2e 2007-10-14 drh: d29dd11f2e 2007-10-14 drh: <tr> d29dd11f2e 2007-10-14 drh: <td align="right">Type: d29dd11f2e 2007-10-14 drh: [/type typechoices 20 combobox] d29dd11f2e 2007-10-14 drh: </td> d29dd11f2e 2007-10-14 drh: <td>What type of ticket is this?</td> d29dd11f2e 2007-10-14 drh: </tr> d29dd11f2e 2007-10-14 drh: d29dd11f2e 2007-10-14 drh: <tr> d29dd11f2e 2007-10-14 drh: <td align="right">Version: 8c96ed62f5 2007-11-17 drh: <input type="text" name="foundin" size="20" value="[foundin html]"> d29dd11f2e 2007-10-14 drh: </td> d29dd11f2e 2007-10-14 drh: <td>In what version or build number do you observer the problem?</td> d29dd11f2e 2007-10-14 drh: </tr> d29dd11f2e 2007-10-14 drh: d29dd11f2e 2007-10-14 drh: <tr> d29dd11f2e 2007-10-14 drh: <td align="right">Severity: d29dd11f2e 2007-10-14 drh: [/severity {High Medium Low} 8 combobox] d29dd11f2e 2007-10-14 drh: </td> d29dd11f2e 2007-10-14 drh: <td>How debilitating is the problem? How badly does the problem d29dd11f2e 2007-10-14 drh: effect the operation of the product?</td> d29dd11f2e 2007-10-14 drh: </tr> d29dd11f2e 2007-10-14 drh: d29dd11f2e 2007-10-14 drh: <tr> d29dd11f2e 2007-10-14 drh: <td colspan="2"> d29dd11f2e 2007-10-14 drh: Enter a detailed description of the problem. d29dd11f2e 2007-10-14 drh: For code defects, be sure to provide details on exactly how d29dd11f2e 2007-10-14 drh: the problem can be reproduced. Provide as much detail as d29dd11f2e 2007-10-14 drh: possible. d29dd11f2e 2007-10-14 drh: <br> 8c96ed62f5 2007-11-17 drh: <textarea name="comment" cols="80" rows="[comment linecount 50 max 10 min]" 8c96ed62f5 2007-11-17 drh: wrap="virtual" class="wikiedit">[comment html]</textarea><br> d29dd11f2e 2007-10-14 drh: <br> 8c96ed62f5 2007-11-17 drh: <input type="submit" name="preview" value="Preview"> d29dd11f2e 2007-10-14 drh: </tr> 8c96ed62f5 2007-11-17 drh: 8c96ed62f5 2007-11-17 drh: [0 /preview get enable_output] 8c96ed62f5 2007-11-17 drh: <tr><td colspan="2"> 8c96ed62f5 2007-11-17 drh: Description Preview:<br><hr> 8c96ed62f5 2007-11-17 drh: [/comment html] 8c96ed62f5 2007-11-17 drh: <hr> 8c96ed62f5 2007-11-17 drh: </td></tr> 8c96ed62f5 2007-11-17 drh: [1 enable_output] d29dd11f2e 2007-10-14 drh: d29dd11f2e 2007-10-14 drh: <tr> d29dd11f2e 2007-10-14 drh: <td align="right"> 8c96ed62f5 2007-11-17 drh: <input type="submit" name="submit" value="Submit"> d29dd11f2e 2007-10-14 drh: </td> d29dd11f2e 2007-10-14 drh: <td>After filling in the information above, press this button to create d29dd11f2e 2007-10-14 drh: the new ticket</td> d29dd11f2e 2007-10-14 drh: </tr> d29dd11f2e 2007-10-14 drh: </table> 8c96ed62f5 2007-11-17 drh: <!-- end of form --> 8c96ed62f5 2007-11-17 drh: } /tktnew_template set 929d28e358 2007-11-05 drh: d29dd11f2e 2007-10-14 drh: ###################################################################### 8c96ed62f5 2007-11-17 drh: # The template for the "edit ticket" page d29dd11f2e 2007-10-14 drh: { 8c96ed62f5 2007-11-17 drh: <!-- database field names not found as CGI parameters are loaded 8c96ed62f5 2007-11-17 drh: from the database automatically --> 8c96ed62f5 2007-11-17 drh: <!-- start a form --> 8c96ed62f5 2007-11-17 drh: [{<hr><i>%USER% added on %DATE%:</i><br>} 8c96ed62f5 2007-11-17 drh: /cmappnd /comment append_remark] 8c96ed62f5 2007-11-17 drh: [/submit submit_ticket_change] d29dd11f2e 2007-10-14 drh: <table cellpadding="5"> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Title:</td><td> 8c96ed62f5 2007-11-17 drh: <input type="text" name="title" value="[title html] size=60"> d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Status:</td><td> d29dd11f2e 2007-10-14 drh: [/status status_choices 20 combobox] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Type:</td><td> d29dd11f2e 2007-10-14 drh: [/type type_choices 20 combobox] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Severity:</td><td> d29dd11f2e 2007-10-14 drh: [/severity {High Medium Low} 10 combobox] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Priority:</td><td> d29dd11f2e 2007-10-14 drh: [/priority {High Medium Low} 10 combobox] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Resolution:</td><td> d29dd11f2e 2007-10-14 drh: [/resolution resolution_choices 20 combobox] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Subsystem:</td><td> d29dd11f2e 2007-10-14 drh: [/subsystem subsystem_choices 30 combobox] d29dd11f2e 2007-10-14 drh: </td></tr> 8c96ed62f5 2007-11-17 drh: [/e hascap enable_output] d29dd11f2e 2007-10-14 drh: <tr><td align="right">Contact:</td><td> 8c96ed62f5 2007-11-17 drh: <input type="text" name="contact" size="40" value="[contact html]"> d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: [1 enable_output] d29dd11f2e 2007-10-14 drh: <tr><td align="right">Version Found In:</td><td> 8c96ed62f5 2007-11-17 drh: <input type="text" name="foundin" size="50" value="[foundin html]"> d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td colspan="2"> 8c96ed62f5 2007-11-17 drh: [0 /eall 0 get /eall set] 8c96ed62f5 2007-11-17 drh: [/aonlybtn exists not /eall set] 8c96ed62f5 2007-11-17 drh: [/eallbtn exists /eall set] 8c96ed62f5 2007-11-17 drh: [/w hascap eall and /eall set] d29dd11f2e 2007-10-14 drh: [eall enable_output] d29dd11f2e 2007-10-14 drh: Description And Comments:<br> 929d28e358 2007-11-05 drh: <textarea name="comment" cols="80" rows="[comment linecount 15 max 10 min]" 8c96ed62f5 2007-11-17 drh: wrap="virtual" class="wikiedit">[comment html]</textarea><br> 8c96ed62f5 2007-11-17 drh: <input type="hidden" name="eall" value="1"> 8c96ed62f5 2007-11-17 drh: <input type="submit" name="aonlybtn" value="Append Remark"> d29dd11f2e 2007-10-14 drh: [eall not enable_output] d29dd11f2e 2007-10-14 drh: Append Remark:<br> 8c96ed62f5 2007-11-17 drh: <textarea name="cmappnd" cols="80" rows="15" 8c96ed62f5 2007-11-17 drh: wrap="virtual" class="wikiedit">[cmappnd html]</textarea><br> 8c96ed62f5 2007-11-17 drh: [ok_wrtkt enable_output] 8c96ed62f5 2007-11-17 drh: <input type="submit" name="eallbtn" value="Edit All"> d29dd11f2e 2007-10-14 drh: [1 enable_output] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right"></td><td> 8c96ed62f5 2007-11-17 drh: <input type="submit" name="submit" value="Submit Changes"> d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: </table> 8c96ed62f5 2007-11-17 drh: <!-- end-form inserted automatically --> 8c96ed62f5 2007-11-17 drh: } /tktedit_template set 8c96ed62f5 2007-11-17 drh: d29dd11f2e 2007-10-14 drh: ###################################################################### 8c96ed62f5 2007-11-17 drh: # The template for the "view ticket" page d29dd11f2e 2007-10-14 drh: { 8c96ed62f5 2007-11-17 drh: <!-- load database fields automatically loaded into variables --> d29dd11f2e 2007-10-14 drh: <table cellpadding="5"> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Title:</td><td> 8c96ed62f5 2007-11-17 drh: [/title html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Status:</td><td> 8c96ed62f5 2007-11-17 drh: [/status html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Type:</td><td> 8c96ed62f5 2007-11-17 drh: [/type html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Severity:</td><td> 8c96ed62f5 2007-11-17 drh: [/severity html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Priority:</td><td> 8c96ed62f5 2007-11-17 drh: [/priority html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Resolution:</td><td> 8c96ed62f5 2007-11-17 drh: [/priority html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td align="right">Subsystem:</td><td> 8c96ed62f5 2007-11-17 drh: [/subsystem html] d29dd11f2e 2007-10-14 drh: </td></tr> 929d28e358 2007-11-05 drh: [{e} hascap enable_output] d29dd11f2e 2007-10-14 drh: <tr><td align="right">Contact:</td><td> 8c96ed62f5 2007-11-17 drh: [/contact html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: [1 enable_output] d29dd11f2e 2007-10-14 drh: <tr><td align="right">Version Found In:</td><td> 8c96ed62f5 2007-11-17 drh: [/foundin html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: <tr><td colspan="2"> d29dd11f2e 2007-10-14 drh: Description And Comments:<br> 8c96ed62f5 2007-11-17 drh: [/comment html] d29dd11f2e 2007-10-14 drh: </td></tr> d29dd11f2e 2007-10-14 drh: </table> 8c96ed62f5 2007-11-17 drh: } /tktview_template set
File Annotation