RT 4.2.11, ticket#13852

[freeside.git] / rt / etc / upgrade / 4.1.7 / schema.mysql

UPDATE Transactions
SET TimeTaken
    = COALESCE(NewValue,0)
    - COALESCE(OldValue,0)
WHERE ObjectType = 'RT::Ticket' AND Type = 'Set' AND Field = 'TimeWorked';