Tickets :: Comment on [#4895] Number comments for easier reference

* Your Email Address
* Spam protection	Enter the letters below: .___.__ .___.___. . [__ [ __[__ [__ \|\ \| \| [_./\| \| \| \\|
Comment	>> 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 > > }
Attachment
Watch this ticket