634fd117b1 2007-08-25       drh: Random thoughts:
634fd117b1 2007-08-25       drh: 
634fd117b1 2007-08-25       drh:   *  Changes to manifest to support:
634fd117b1 2007-08-25       drh: 
634fd117b1 2007-08-25       drh:      +  Trees of wiki pages and tickets
634fd117b1 2007-08-25       drh:      +  The ability to cap or close a branch
634fd117b1 2007-08-25       drh: 
634fd117b1 2007-08-25       drh:   *  Add the concept of "clusters" to speed the transfer of "tips"
634fd117b1 2007-08-25       drh:      on a sync.
634fd117b1 2007-08-25       drh: 
634fd117b1 2007-08-25       drh:   *  Auxiliary tables:
634fd117b1 2007-08-25       drh: 
634fd117b1 2007-08-25       drh:      +  tip
634fd117b1 2007-08-25       drh:      +  phantom
634fd117b1 2007-08-25       drh:      +  mlink
634fd117b1 2007-08-25       drh:      +  plink
634fd117b1 2007-08-25       drh:      +  branch
634fd117b1 2007-08-25       drh:      +  tree
634fd117b1 2007-08-25       drh: 
634fd117b1 2007-08-25       drh:   * Plink.isprim changed to record:
634fd117b1 2007-08-25       drh:      +  child is the principal descendent of parent.
634fd117b1 2007-08-25       drh:      +  child is a branch from parent
634fd117b1 2007-08-25       drh:      +  child uses parent as a merge
634fd117b1 2007-08-25       drh: 
634fd117b1 2007-08-25       drh:   * tree records
634fd117b1 2007-08-25       drh:      + type  (code, wiki, ticket)
634fd117b1 2007-08-25       drh:      + name  (for wiki and ticket only)
634fd117b1 2007-08-25       drh:      + treeid
634fd117b1 2007-08-25       drh: 
634fd117b1 2007-08-25       drh:   * branch records
634fd117b1 2007-08-25       drh:      + treeid
634fd117b1 2007-08-25       drh:      + origin_rid
634fd117b1 2007-08-25       drh:      + origin_time
634fd117b1 2007-08-25       drh:      + tip_rid
634fd117b1 2007-08-25       drh:      + tip_time
634fd117b1 2007-08-25       drh:      + color
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.
634fd117b1 2007-08-25       drh:     For a tie, go with the earliest check-in as the principal