f73c0e792b 2007-09-22 drh: ba486fec5a 2007-09-03 drh: Possible ticket file format: ba486fec5a 2007-09-03 drh: bd35e98274 2007-09-27 drh: A uuid name description bd35e98274 2007-09-27 drh: D datetime bd35e98274 2007-09-27 drh: J field value bd35e98274 2007-09-27 drh: K uuid bd35e98274 2007-09-27 drh: U user bd35e98274 2007-09-27 drh: Z md5sum bd35e98274 2007-09-27 drh: bd35e98274 2007-09-27 drh: FIELDs: bd35e98274 2007-09-27 drh: bd35e98274 2007-09-27 drh: comment cumulative text bd35e98274 2007-09-27 drh: title text bd35e98274 2007-09-27 drh: assignedto text bd35e98274 2007-09-27 drh: status enum bd35e98274 2007-09-27 drh: resolution enum bd35e98274 2007-09-27 drh: subsystem enum bd35e98274 2007-09-27 drh: type enum bd35e98274 2007-09-27 drh: priority enum bd35e98274 2007-09-27 drh: severity enum bd35e98274 2007-09-27 drh: deferuntil datetime bd35e98274 2007-09-27 drh: duedate datetime bd35e98274 2007-09-27 drh: derivedfrom add or subtract uuid bd35e98274 2007-09-27 drh: relatedversions add or subtract associate with manifest bd35e98274 2007-09-27 drh: presentin add or subtract uuid bd35e98274 2007-09-27 drh: fixedin add or subtract uuid bd35e98274 2007-09-27 drh: bd35e98274 2007-09-27 drh: Other table columns: bd35e98274 2007-09-27 drh: origintime bd35e98274 2007-09-27 drh: lastchange bd35e98274 2007-09-27 drh: bd35e98274 2007-09-27 drh: 134e2aeccc 2007-09-28 drh: Field Types: 134e2aeccc 2007-09-28 drh: 134e2aeccc 2007-09-28 drh: text width height 134e2aeccc 2007-09-28 drh: enum width valuelist 134e2aeccc 2007-09-28 drh: datetime width 134e2aeccc 2007-09-28 drh: cumulative-text width height 134e2aeccc 2007-09-28 drh: set-of-uuid width 134e2aeccc 2007-09-28 drh: set-of-checkin width 134e2aeccc 2007-09-28 drh: bd35e98274 2007-09-27 drh: Tables: bd35e98274 2007-09-27 drh: bd35e98274 2007-09-27 drh: tktrid(rid, tkid, mtime); index(tkid, mtime); 2e9d52f27f 2007-10-02 drh: ticket(tkid, tkuuid UNIQUE, starttime, lastmod, ...); 2e9d52f27f 2007-10-02 drh: tktfield(fieldname UNIQUE, type, width, other); bd35e98274 2007-09-27 drh: tktxref(tkid, mid); index(tkid); index(mid); bd35e98274 2007-09-27 drh: bd35e98274 2007-09-27 drh: Tktformat in the config table. bd35e98274 2007-09-27 drh: bd35e98274 2007-09-27 drh: * Three pages: creation, display, and edit d8f27c5afd 2007-10-02 drh: * Separate global and local versions of each page. Local overwrites d8f27c5afd 2007-10-02 drh: global if it exists. bd35e98274 2007-09-27 drh: * HTML bd35e98274 2007-09-27 drh: * [[field]] to substitute the appropriate form or display element bd35e98274 2007-09-27 drh: d8f27c5afd 2007-10-02 drh: Ticket Configuraiton File: d8f27c5afd 2007-10-02 drh: d8f27c5afd 2007-10-02 drh: * Format: d8f27c5afd 2007-10-02 drh: ticket-configuration d8f27c5afd 2007-10-02 drh: field <fieldname> <type> <param> ... d8f27c5afd 2007-10-02 drh: template <type> <delimiter> d8f27c5afd 2007-10-02 drh: <text> d8f27c5afd 2007-10-02 drh: * Each repository selects a single ticket config for its own use. d8f27c5afd 2007-10-02 drh: * Rescan all tickets following any config change d8f27c5afd 2007-10-02 drh: * Use the ticket-configuration tag must be on the file d8f27c5afd 2007-10-02 drh: d8f27c5afd 2007-10-02 drh: Todo: d8f27c5afd 2007-10-02 drh: d8f27c5afd 2007-10-02 drh: * Configuration file parser d8f27c5afd 2007-10-02 drh: + tkt-new-template d8f27c5afd 2007-10-02 drh: + tkt-view-template d8f27c5afd 2007-10-02 drh: + tkt-edit-template 2e9d52f27f 2007-10-02 drh: + Reconstruct the ticket table schema 2e9d52f27f 2007-10-02 drh: + Repopulate tktfield d8f27c5afd 2007-10-02 drh: * Ticket control file parser 0edee97370 2007-10-03 drh: + Create ticket entry if necessary 0edee97370 2007-10-03 drh: + Update fields. Ignore unrecognized fields. d8f27c5afd 2007-10-02 drh: * Transfer tkt control info to ticket table d8f27c5afd 2007-10-02 drh: * Setup pages for selecting and editing ticket configuration d8f27c5afd 2007-10-02 drh: * Ticket display d8f27c5afd 2007-10-02 drh: * New ticket creation display d8f27c5afd 2007-10-02 drh: * Ticket change screen d8f27c5afd 2007-10-02 drh: * Ticket query screens d8f27c5afd 2007-10-02 drh: ab637af752 2007-09-28 drh: bd35e98274 2007-09-27 drh: ------------------------------------------------------------------------ ab637af752 2007-09-28 drh: Change to wiki: ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: A uuid filename description ab637af752 2007-09-28 drh: D datetime ab637af752 2007-09-28 drh: P uuid ... ab637af752 2007-09-28 drh: U user ab637af752 2007-09-28 drh: W wikipagename uuid ab637af752 2007-09-28 drh: Z md5sum ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: On page: ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: <title>....</title> ab637af752 2007-09-28 drh: <readonly/> ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: Hyperlinks: ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: [lowercasehex] /info/lowercasehex ab637af752 2007-09-28 drh: [attachment.gif] inline image ab637af752 2007-09-28 drh: [tagname] /info/tagname ab637af752 2007-09-28 drh: [wikipagename] /wiki/wikipagename ab637af752 2007-09-28 drh: [/internal/page] /internal/page ab637af752 2007-09-28 drh: [http:...] external link ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: Markup: ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: blank-line paragraph break ab637af752 2007-09-28 drh: _*__ bullet ab637af752 2007-09-28 drh: __ indentation ab637af752 2007-09-28 drh: _#.__ enumeration ab637af752 2007-09-28 drh: *text* bold ab637af752 2007-09-28 drh: _text_ italic ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: ab637af752 2007-09-28 drh: ------------------------------------------------------------------------ 634fd117b1 2007-08-25 drh: ba486fec5a 2007-09-03 drh: Random thoughts: 634fd117b1 2007-08-25 drh: 634fd117b1 2007-08-25 drh: * Plink.isprim changed to record: fd8b28ad87 2007-08-26 drh: + child is the principal descendent of parent. (1) fd8b28ad87 2007-08-26 drh: + child is a branch from parent (2) fd8b28ad87 2007-08-26 drh: + child uses parent as a merge (0) 634fd117b1 2007-08-25 drh: 634fd117b1 2007-08-25 drh: * website can toggle isprim between principal and branch. 634fd117b1 2007-08-25 drh: + How to preserve across rebuild. A new record type? 634fd117b1 2007-08-25 drh: + How to share with other repositories 634fd117b1 2007-08-25 drh: * isprim guessed using userid of parent and child. Change 634fd117b1 2007-08-25 drh: in id suggests a branch. Same id suggests principal. fd8b28ad87 2007-08-26 drh: For a tie, go with the earliest check-in as the principal' fd8b28ad87 2007-08-26 drh: fd8b28ad87 2007-08-26 drh: * Autosync mode 6847e9b22a 2007-09-25 jnc: * Notes: 6847e9b22a 2007-09-25 jnc: + Designed to avoid branching in highly collaborative 6847e9b22a 2007-09-25 jnc: environments. 6847e9b22a 2007-09-25 jnc: * Outstanding: 6847e9b22a 2007-09-25 jnc: + On commit, first pull. If commit baseline is not a tip 6847e9b22a 2007-09-25 jnc: prompt user to cancel or branch. Default is cancel. 6847e9b22a 2007-09-25 jnc: + Need an "undo" capability 6847e9b22a 2007-09-25 jnc: * Done: 6847e9b22a 2007-09-25 jnc: * Set a preferred remote repository to use as a server 6847e9b22a 2007-09-25 jnc: = Clone repository is the default 6847e9b22a 2007-09-25 jnc: * Push after commit 6847e9b22a 2007-09-25 jnc: * Automatically pull prior to update. fd8b28ad87 2007-08-26 drh: fd8b28ad87 2007-08-26 drh: * Archeological webpage improvements: fd8b28ad87 2007-08-26 drh: + Use a small amount of CSS+javascript on timelines so that fd8b28ad87 2007-08-26 drh: branching structure is displayed on mouseover. On mouseover fd8b28ad87 2007-08-26 drh: of a checkin, highlight other checkins that are direct (non-merge) fd8b28ad87 2007-08-26 drh: descendents and ancestors of the mouseover checkin. fd8b28ad87 2007-08-26 drh: + Timeline showing individual branches fd8b28ad87 2007-08-26 drh: + Timeline shows forks and merges fd8b28ad87 2007-08-26 drh: + Tags shown on timeline (maybe) and in vinfo (surely). fd8b28ad87 2007-08-26 drh: 251545cd43 2007-09-02 drh: Features needed: 251545cd43 2007-09-02 drh: * Means to suppress artifacts 251545cd43 2007-09-02 drh: * Means to cap a branch 251545cd43 2007-09-02 drh: * Ticketing 251545cd43 2007-09-02 drh: + Problem is/is-not expressed in baseline X. 251545cd43 2007-09-02 drh: + Append comment and zero or more attachments 251545cd43 2007-09-02 drh: * Modify comments on baselines 251545cd43 2007-09-02 drh: * Append comments to any artifact 251545cd43 2007-09-02 drh: * Wiki? 251545cd43 2007-09-02 drh: 251545cd43 2007-09-02 drh: 251545cd43 2007-09-02 drh: fd8b28ad87 2007-08-26 drh: Extended manifests. fd8b28ad87 2007-08-26 drh: * normal manifest has: fd8b28ad87 2007-08-26 drh: C comment fd8b28ad87 2007-08-26 drh: D date-time fd8b28ad87 2007-08-26 drh: F* filename uuid fd8b28ad87 2007-08-26 drh: P uuid ... -- omitted for first manifest fd8b28ad87 2007-08-26 drh: R repository-md5sum fd8b28ad87 2007-08-26 drh: U user-login fd8b28ad87 2007-08-26 drh: Z manifest-checksum 251545cd43 2007-09-02 drh: 251545cd43 2007-09-02 drh: * Accessory: 251545cd43 2007-09-02 drh: A uuid|* attachment-uuid description 251545cd43 2007-09-02 drh: D date-time 251545cd43 2007-09-02 drh: E uuid new-comment 251545cd43 2007-09-02 drh: G uuid appended-remark 251545cd43 2007-09-02 drh: S repositoryid serial-number 2bc0e2c565 2007-09-21 drh: T (+|-)tag uuid 2bc0e2c565 2007-09-21 drh: U userid 251545cd43 2007-09-02 drh: X uuid-to-surpress 251545cd43 2007-09-02 drh: Z this-file-checksum 251545cd43 2007-09-02 drh: fd8b28ad87 2007-08-26 drh: * Change the comment on a version: -- always a leaf except in cluster fd8b28ad87 2007-08-26 drh: D date-time fd8b28ad87 2007-08-26 drh: E new-comment fd8b28ad87 2007-08-26 drh: P uuid -- baseline whose comment is changed fd8b28ad87 2007-08-26 drh: U user-login fd8b28ad87 2007-08-26 drh: Z checksum fd8b28ad87 2007-08-26 drh: -- most recent wins fd8b28ad87 2007-08-26 drh: * Wiki edit fd8b28ad87 2007-08-26 drh: A* name uuid -- zero or more attachments fd8b28ad87 2007-08-26 drh: C? comment fd8b28ad87 2007-08-26 drh: D date-time fd8b28ad87 2007-08-26 drh: N name -- name of the wiki page fd8b28ad87 2007-08-26 drh: P uuid ... -- omit for new wiki fd8b28ad87 2007-08-26 drh: U user-login fd8b28ad87 2007-08-26 drh: W uuid -- The content file fd8b28ad87 2007-08-26 drh: Z manifest-cksum fd8b28ad87 2007-08-26 drh: * Ticket edit fd8b28ad87 2007-08-26 drh: A* name uuid -- zero or more attachments fd8b28ad87 2007-08-26 drh: D date-time fd8b28ad87 2007-08-26 drh: N name -- name of the ticket fd8b28ad87 2007-08-26 drh: P uuid -- omit for new ticket fd8b28ad87 2007-08-26 drh: T uuid -- content of the ticket fd8b28ad87 2007-08-26 drh: U user-login fd8b28ad87 2007-08-26 drh: Z manifest-cksum fd8b28ad87 2007-08-26 drh: * Set or erase a tag -- most recent date wins fd8b28ad87 2007-08-26 drh: B* (+|-)tag uuid fd8b28ad87 2007-08-26 drh: C? comment fd8b28ad87 2007-08-26 drh: D date-time fd8b28ad87 2007-08-26 drh: V* (+|-) tag uuid -- + to set, - to clear. fd8b28ad87 2007-08-26 drh: Z manifest-cksum fd8b28ad87 2007-08-26 drh: -- Must have at least one B or V. 2bc0e2c565 2007-09-21 drh: -- Branch tag "hidden" means do not sync 2bc0e2c565 2007-09-21 drh: -- Version tag "closed" means do not display as a leaf 8c828207a2 2007-08-27 drh: * A cluster 8c828207a2 2007-08-27 drh: M+ uuid 8c828207a2 2007-08-27 drh: Z manifest-cksum 2bc0e2c565 2007-09-21 drh: 2bc0e2c565 2007-09-21 drh: * Complete set of cards in a control file: fd8b28ad87 2007-08-26 drh: A filename uuid fd8b28ad87 2007-08-26 drh: B (+|-)branch-tag uuid fd8b28ad87 2007-08-26 drh: C comment fd8b28ad87 2007-08-26 drh: D date-time 2bc0e2c565 2007-09-21 drh: E uuid edited-comment fd8b28ad87 2007-08-26 drh: F filename uuid 2bc0e2c565 2007-09-21 drh: M uuid fd8b28ad87 2007-08-26 drh: N name fd8b28ad87 2007-08-26 drh: P uuid ... fd8b28ad87 2007-08-26 drh: R repository-md5sum fd8b28ad87 2007-08-26 drh: T uuid fd8b28ad87 2007-08-26 drh: U user-login fd8b28ad87 2007-08-26 drh: V (+|-)version-tag uuid fd8b28ad87 2007-08-26 drh: W uuid fd8b28ad87 2007-08-26 drh: Z manifest-checksum
File Annotation