miholeus

на 2700

May 22nd, 2013
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.57 KB | None | 0 0
  1. INSERT INTO payment_transactions
  2. SET bind_id = 2299123,
  3. bind_to = 'orders',
  4. statia = 2,
  5. man_id = 0,
  6. type = 'income',
  7. status = 'done',
  8. agent = 'kupivkredit',
  9. payment_method_id = 15,
  10. currency = 'RUB',
  11. amount = '2700.00',
  12. corr_id = '000000169',
  13. `comment` = 'Доплата по заявке КупиВКредит №21773',
  14. pko = 2,
  15. date_created = now(),
  16. currency_rate = '1.0000'
  17.  
  18. INSERT INTO payment_to_bank_x_operation
  19. SET pay_id = 45645,
  20. transaction_id = <из предыдущего запроса>
  21.  
  22. update payment_to_bank
  23. set status = 1
  24. where id = 45645
Advertisement
Add Comment
Please, Sign In to add comment