[Tickets #4895] Re: Number comments for easier reference

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=4895
-----------------------------------------------------------------------
 Ticket             | 4895
 Updated By         | php at ideacode.com
 Summary            | Number comments for easier reference
 Queue              | Whups
 Type               | Enhancement
 State              | Accepted
 Priority           | 1. Low
 Owners             | 
-----------------------------------------------------------------------


php at ideacode.com (2007-01-18 14:09) wrote:

> Probably useful for things like comment feeds and for making nicer 
> interfaces involving links to tickets.

Recommend cross-linking using URI fragments:

Examples for how to access comment #242:
1. Direct access via a URL:
http://example.com/horde/whups/ticket/?id=142&Horde=MD5HORDEID#242

2. Comment text like this: "Issue 431#242" gets turned into URL like
above.

> Wouldn't be hard to do if we 
> created a sequence for each ticket, but that'd be a _lot_ of 
> sequences. Probably easier to have a table of sequences with two 
> columns: ticket_id and comment_sequence.

Yep:

CREATE TABLE whups_comment_sequences {
     ticket_id INTEGER NOT NULL,
     next_comment_number INTEGER NOT NULL
}