projects
/
freeside.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
71513: Card tokenization in v4+
[freeside.git]
/
rt
/
etc
/
upgrade
/
4.1.7
/
schema.Pg
1
UPDATE Transactions
2
SET TimeTaken
3
= (CASE WHEN NewValue~E'^-?\\d+$' THEN NewValue::integer ELSE 0 END)
4
- COALESCE(OldValue::integer, 0)
5
WHERE ObjectType = 'RT::Ticket' AND Type = 'Set' AND Field = 'TimeWorked';