CodedLeprecon

Store Dump #1

Aug 29th, 2012
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.58 KB | None | 0 0
  1. Table: paypal_payment_info
  2. [32 columns]
  3. +----------------+----------------------------+
  4. | Column | Type |
  5. +----------------+----------------------------+
  6. | buyer_email | varchar(100) |
  7. | city | varchar(50) |
  8. | country | varchar(20) |
  9. | custom | varchar(255) |
  10. | datecreation | date |
  11. | firstname | varchar(100) |
  12. | ghnote | varchar(255) |
  13. | itemname | varchar(255) |
  14. | itemnumber | varchar(50) |
  15. | lastname | varchar(100) |
  16. | mc_currency | varchar(5) |
  17. | mc_fee | varchar(5) |
  18. | mc_gross | varchar(6) |
  19. | memo | varchar(255) |
  20. | on0 | varchar(50) |
  21. | on1 | varchar(50) |
  22. | os0 | varchar(20) |
  23. | os1 | varchar(20) |
  24. | paymentdate | varchar(50) |
  25. | paymentstatus | varchar(15) |
  26. | paymenttype | varchar(10) |
  27. | pendingreason | varchar(10) |
  28. | ppipn | enum('VERIFIED','INVALID') |
  29. | quantity | char(3) |
  30. | reasoncode | varchar(20) |
  31. | receiver_email | varchar(256) |
  32. | state | char(3) |
  33. | street | varchar(100) |
  34. | tax | varchar(10) |
  35. | txnid | varchar(30) |
  36. | txntype | varchar(10) |
  37. | zipcode | varchar(11) |
  38. +----------------+----------------------------+
  39. +----------+-----------+
  40. | lastname | firstname |
  41. +----------+-----------+
  42. | <blank> | <blank> |
  43. | Scott | Myriam |
  44. | Scott | Myriam |
  45. +----------+-----------+
  46. +----------------------------+
  47. | buyer_email |
  48. +----------------------------+
  49. +----------------------------+
  50. +-----------------+
  51. | paymentstatus |
  52. +-----------------+
  53. | Canceled_Revers |
  54. | Reversed |
  55. |
  56. +-----------------+
  57. +----------+
  58. | ppipn |
  59. +----------+
  60. | VERIFIED |
  61. | VERIFIED |
  62. | VERIFIED |
  63. +----------+
  64. +-------------------------+
  65. | receiver_email |
  66. +-------------------------+
  67. +-------------------------
Add Comment
Please, Sign In to add comment