[rt-users] Change text in tickts using database

[Tim Cutts]

On 18 Oct 2012, at 15:58, Juanjo <juanjillo at gmail.com> wrote:

> Hi, 
> 
> I have to change some test inside the tickets directly on database.
> 
> I don´t find where are the comments, or the emails body that we send to rt or create trought web.
> 
> Could you tell me what table and what comun have this data??

The Attachments table contains most of it.

Each ticket in the Tickets table has one or more transactions in the Transactions table, and each transaction can have zero or more attachments in the Attachments table, depending on the kind of transaction.

Tim

-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.