Advertisement
Guest User

SQLpatchPARTone

a guest
Oct 25th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. ALTER TABLE orderHistory MODIFY column sellCommission DECIMAL(16,8);
  2. ALTER TABLE orderHistory MODIFY column buyCommission DECIMAL(16,8);
  3. ALTER TABLE orderHistory MODIFY column profitAfterCommission DECIMAL(16,8);
  4. ALTER TABLE orderHistory MODIFY column profitBeforeCommission DECIMAL(16,8);
  5. ALTER TABLE orderHistory MODIFY column totalSellPrice DECIMAL(16,8);
  6. ALTER TABLE orderHistory MODIFY column totalBuyPrice DECIMAL(16,8);
  7. ALTER TABLE orderHistory MODIFY column remaining DECIMAL(16,8);
  8. ALTER TABLE orderHistory MODIFY column amount DECIMAL(16,8);
  9. ALTER TABLE orderHistory MODIFY column perUnitSellPrice DECIMAL(16,8);
  10. ALTER TABLE orderHistory MODIFY column perUnitBuyPrice DECIMAL(16,8);
  11. ALTER TABLE autoTrades MODIFY column buyCommission DECIMAL(16,8);
  12. ALTER TABLE autoTrades MODIFY column sellCommission DECIMAL(16,8);
  13. ALTER TABLE altCoinPriceHistory MODIFY column price DECIMAL(16,8);
  14. ALTER TABLE altCoinPriceHistory MODIFY column bid DECIMAL(16,8);
  15. ALTER TABLE altCoinPriceHistory MODIFY column ask DECIMAL(16,8);
  16. ALTER TABLE btcPriceHistory MODIFY column price DECIMAL(16,8);
  17. ALTER TABLE currencies MODIFY column balance DECIMAL(16,8);
  18. ALTER TABLE currencies MODIFY column pending DECIMAL(16,8);
  19. ALTER TABLE currencies MODIFY column reserve DECIMAL(16,8);
  20. ALTER TABLE currencies MODIFY column available DECIMAL(16,8);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement