Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> show columns from sip_capture_call_20160527;
- +------------------+---------------------+------+-----+-------------------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +------------------+---------------------+------+-----+-------------------+----------------+
- | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
- | date | timestamp | NO | PRI | CURRENT_TIMESTAMP | |
- | micro_ts | bigint(18) | NO | | 0 | |
- | method | varchar(50) | NO | | | |
- | reply_reason | varchar(100) | NO | | | |
- | ruri | varchar(200) | NO | | | |
- | ruri_user | varchar(100) | NO | MUL | | |
- | ruri_domain | varchar(150) | NO | | | |
- | from_user | varchar(100) | NO | MUL | | |
- | from_domain | varchar(150) | NO | | | |
- | from_tag | varchar(64) | NO | | | |
- | to_user | varchar(100) | NO | MUL | | |
- | to_domain | varchar(150) | NO | | | |
- | to_tag | varchar(64) | NO | | | |
- | pid_user | varchar(100) | NO | MUL | | |
- | contact_user | varchar(120) | NO | | | |
- | auth_user | varchar(120) | NO | MUL | | |
- | callid | varchar(120) | NO | MUL | | |
- | callid_aleg | varchar(120) | NO | MUL | | |
- | via_1 | varchar(256) | NO | | | |
- | via_1_branch | varchar(80) | NO | | | |
- | cseq | varchar(25) | NO | | | |
- | diversion | varchar(256) | NO | | | |
- | reason | varchar(200) | NO | | | |
- | content_type | varchar(256) | NO | | | |
- | auth | varchar(256) | NO | | | |
- | user_agent | varchar(256) | NO | | | |
- | source_ip | varchar(60) | NO | | | |
- | source_port | int(10) | NO | | 0 | |
- | destination_ip | varchar(60) | NO | | | |
- | destination_port | int(10) | NO | | 0 | |
- | contact_ip | varchar(60) | NO | | | |
- | contact_port | int(10) | NO | | 0 | |
- | originator_ip | varchar(60) | NO | | | |
- | originator_port | int(10) | NO | | 0 | |
- | correlation_id | varchar(256) | NO | | | |
- | custom_field1 | varchar(120) | NO | | | |
- | custom_field2 | varchar(120) | NO | | | |
- | custom_field3 | varchar(120) | NO | | | |
- | proto | int(5) | NO | | 0 | |
- | family | int(1) | YES | | NULL | |
- | rtp_stat | varchar(256) | NO | | | |
- | type | int(2) | NO | | 0 | |
- | node | varchar(125) | NO | | | |
- | msg | varchar(1500) | NO | | | |
- +------------------+---------------------+------+-----+-------------------+----------------+
- 45 rows in set (0.03 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement