Advertisement
Guest User

Untitled

a guest
May 30th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.58 KB | None | 0 0
  1. mysql> show columns from sip_capture_call_20160527;
  2. +------------------+---------------------+------+-----+-------------------+----------------+
  3. | Field | Type | Null | Key | Default | Extra |
  4. +------------------+---------------------+------+-----+-------------------+----------------+
  5. | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
  6. | date | timestamp | NO | PRI | CURRENT_TIMESTAMP | |
  7. | micro_ts | bigint(18) | NO | | 0 | |
  8. | method | varchar(50) | NO | | | |
  9. | reply_reason | varchar(100) | NO | | | |
  10. | ruri | varchar(200) | NO | | | |
  11. | ruri_user | varchar(100) | NO | MUL | | |
  12. | ruri_domain | varchar(150) | NO | | | |
  13. | from_user | varchar(100) | NO | MUL | | |
  14. | from_domain | varchar(150) | NO | | | |
  15. | from_tag | varchar(64) | NO | | | |
  16. | to_user | varchar(100) | NO | MUL | | |
  17. | to_domain | varchar(150) | NO | | | |
  18. | to_tag | varchar(64) | NO | | | |
  19. | pid_user | varchar(100) | NO | MUL | | |
  20. | contact_user | varchar(120) | NO | | | |
  21. | auth_user | varchar(120) | NO | MUL | | |
  22. | callid | varchar(120) | NO | MUL | | |
  23. | callid_aleg | varchar(120) | NO | MUL | | |
  24. | via_1 | varchar(256) | NO | | | |
  25. | via_1_branch | varchar(80) | NO | | | |
  26. | cseq | varchar(25) | NO | | | |
  27. | diversion | varchar(256) | NO | | | |
  28. | reason | varchar(200) | NO | | | |
  29. | content_type | varchar(256) | NO | | | |
  30. | auth | varchar(256) | NO | | | |
  31. | user_agent | varchar(256) | NO | | | |
  32. | source_ip | varchar(60) | NO | | | |
  33. | source_port | int(10) | NO | | 0 | |
  34. | destination_ip | varchar(60) | NO | | | |
  35. | destination_port | int(10) | NO | | 0 | |
  36. | contact_ip | varchar(60) | NO | | | |
  37. | contact_port | int(10) | NO | | 0 | |
  38. | originator_ip | varchar(60) | NO | | | |
  39. | originator_port | int(10) | NO | | 0 | |
  40. | correlation_id | varchar(256) | NO | | | |
  41. | custom_field1 | varchar(120) | NO | | | |
  42. | custom_field2 | varchar(120) | NO | | | |
  43. | custom_field3 | varchar(120) | NO | | | |
  44. | proto | int(5) | NO | | 0 | |
  45. | family | int(1) | YES | | NULL | |
  46. | rtp_stat | varchar(256) | NO | | | |
  47. | type | int(2) | NO | | 0 | |
  48. | node | varchar(125) | NO | | | |
  49. | msg | varchar(1500) | NO | | | |
  50. +------------------+---------------------+------+-----+-------------------+----------------+
  51. 45 rows in set (0.03 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement