X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=rt%2Fetc%2Fupgrade%2F4.1.7%2Fschema.Oracle;fp=rt%2Fetc%2Fupgrade%2F4.1.7%2Fschema.Oracle;h=b53dceb021e1cd08864b604c2109e678a2f2799c;hb=1c538bfabc2cd31f27067505f0c3d1a46cba6ef0;hp=0000000000000000000000000000000000000000;hpb=4f5619288413a185e9933088d9dd8c5afbc55dfa;p=freeside.git

diff --git a/rt/etc/upgrade/4.1.7/schema.Oracle b/rt/etc/upgrade/4.1.7/schema.Oracle
new file mode 100644
index 000000000..b53dceb02
--- /dev/null
+++ b/rt/etc/upgrade/4.1.7/schema.Oracle
@@ -0,0 +1,5 @@
+UPDATE Transactions
+SET TimeTaken
+    = COALESCE(TO_NUMBER(REGEXP_SUBSTR(NewValue, '^-?\d+$')), 0)
+    - COALESCE(TO_NUMBER(OldValue),0)
+WHERE ObjectType = 'RT::Ticket' AND Type = 'Set' AND Field = 'TimeWorked';
\ No newline at end of file