Edgewall Software

Changes between Version 1 and Version 2 of TracDev/DatabaseSchema/TicketSystem


Ignore:
Timestamp:
Jul 22, 2012, 12:30:22 PM (12 years ago)
Author:
Peter Suter
Comment:

Mention special ticket_change comment field and comment history handling

Legend:

Unmodified
Added
Removed
Modified

  • TracDev/DatabaseSchema/TicketSystem

    v1 v2  
    5656
    5757Stores ticket change history and comments.
     58
     59The ''field'' value `comment` is special: it associates a comment with a set of field changes. ''oldvalue'' may store the comment number in that case as an optimization.
     60
     61A comment's edit history is stored in ''field'' value `_comment0`, `_comment1` etc. In these cases the ''newvalue'' stores the edit time.
    5862
    5963Use the `trac.ticket.model.Ticket` model class to access this table.