diff options
Diffstat (limited to 'src/exchangedb/exchange_do_history_request.sql')
| -rw-r--r-- | src/exchangedb/exchange_do_history_request.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/exchangedb/exchange_do_history_request.sql b/src/exchangedb/exchange_do_history_request.sql index 2f6041741..7eb368ef3 100644 --- a/src/exchangedb/exchange_do_history_request.sql +++ b/src/exchangedb/exchange_do_history_request.sql @@ -54,23 +54,23 @@ BEGIN -- Update reserve balance. UPDATE exchange.reserves SET - current_balance_frac=current_balance_frac-in_history_fee_frac + current_balance.frac=current_balance.frac-in_history_fee_frac + CASE - WHEN current_balance_frac < in_history_fee_frac + WHEN current_balance.frac < in_history_fee_frac THEN 100000000 ELSE 0 END, - current_balance_val=current_balance_val-in_history_fee_val + current_balance.val=current_balance.val-in_history_fee_val - CASE - WHEN current_balance_frac < in_history_fee_frac + WHEN current_balance.frac < in_history_fee_frac THEN 1 ELSE 0 END WHERE reserve_pub=in_reserve_pub - AND ( (current_balance_val > in_history_fee_val) OR - ( (current_balance_frac >= in_history_fee_frac) AND - (current_balance_val >= in_history_fee_val) ) ); + AND ( (current_balance.val > in_history_fee_val) OR + ( (current_balance.frac >= in_history_fee_frac) AND + (current_balance.val >= in_history_fee_val) ) ); IF NOT FOUND THEN |