----------------------------------------------------------------------------
Request Tracker - Flag Updated Tickets
----------------------------------------------------------------------------

NB: Only tested on RT 3.6.6

These files make any tickets that are unread or have been updated get
flagged in ticket listings.

Unread tickets are marked with a "*" at the start of the subject line, and
tickets with new comments since the last time they were read are marked with
"UPDATED" at the start of the subject line.

Create the following table in your RT database:

  CREATE TABLE CommentsSeen (
    `UserId` int(11) NOT NULL,
    `TicketId` int(11) NOT NULL,
    `Comments` int(11) NOT NULL,
    PRIMARY KEY (`UserId`,`TicketId`)
  ) ENGINE=InnoDB;

Extract the files so that they end up in your local RT updates area, e.g.
/usr/local/rt3/html.

For example, Callbacks/FlagUpdated/Elements/RT__Ticket/ColumnMap/ColumnMap
would end up under /usr/local/rt3/html/Callbacks/FlagUpdated/... .

----------------------------------------------------------------------------
Home page:
http://www.ivarch.com/programs/rt-flagupdated.shtml
----------------------------------------------------------------------------
