Skip to content

Here is the table structure used by MySQL for Realtime SIP friends

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
#
# Table structure for table `sipfriends`
#

CREATE TABLE IF NOT EXISTS `sipfriends` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(10) NOT NULL,
 `ipaddr` varchar(15) DEFAULT NULL,
 `port` int(5) DEFAULT NULL,
 `regseconds` int(11) DEFAULT NULL,
 `defaultuser` varchar(10) DEFAULT NULL,
 `fullcontact` varchar(35) DEFAULT NULL,
 `regserver` varchar(20) DEFAULT NULL,
 `useragent` varchar(20) DEFAULT NULL,
 `lastms` int(11) DEFAULT NULL,
 `host` varchar(40) DEFAULT NULL,
 `type` enum('friend','user','peer') DEFAULT NULL,
 `context` varchar(40) DEFAULT NULL,
 `permit` varchar(40) DEFAULT NULL,
 `deny` varchar(40) DEFAULT NULL,
 `secret` varchar(40) DEFAULT NULL,
 `md5secret` varchar(40) DEFAULT NULL,
 `remotesecret` varchar(40) DEFAULT NULL,
 `transport` enum('udp','tcp','udp,tcp','tcp,udp') DEFAULT NULL,
 `dtmfmode` enum('rfc2833','info','shortinfo','inband','auto') DEFAULT NULL,
 `directmedia` enum('yes','no','nonat','update') DEFAULT NULL,
 `nat` enum('yes','no','never','route') DEFAULT NULL,
 `callgroup` varchar(40) DEFAULT NULL,
 `pickupgroup` varchar(40) DEFAULT NULL,
 `language` varchar(40) DEFAULT NULL,
 `allow` varchar(40) DEFAULT NULL,
 `disallow` varchar(40) DEFAULT NULL,
 `insecure` varchar(40) DEFAULT NULL,
 `trustrpid` enum('yes','no') DEFAULT NULL,
 `progressinband` enum('yes','no','never') DEFAULT NULL,
 `promiscredir` enum('yes','no') DEFAULT NULL,
 `useclientcode` enum('yes','no') DEFAULT NULL,
 `accountcode` varchar(40) DEFAULT NULL,
 `setvar` varchar(40) DEFAULT NULL,
 `callerid` varchar(40) DEFAULT NULL,
 `amaflags` varchar(40) DEFAULT NULL,
 `callcounter` enum('yes','no') DEFAULT NULL,
 `busylevel` int(11) DEFAULT NULL,
 `allowoverlap` enum('yes','no') DEFAULT NULL,
 `allowsubscribe` enum('yes','no') DEFAULT NULL,
 `videosupport` enum('yes','no') DEFAULT NULL,
 `maxcallbitrate` int(11) DEFAULT NULL,
 `rfc2833compensate` enum('yes','no') DEFAULT NULL,
 `mailbox` varchar(40) DEFAULT NULL,
 `session-timers` enum('accept','refuse','originate') DEFAULT NULL,
 `session-expires` int(11) DEFAULT NULL,
 `session-minse` int(11) DEFAULT NULL,
 `session-refresher` enum('uac','uas') DEFAULT NULL,
 `t38pt_usertpsource` varchar(40) DEFAULT NULL,
 `regexten` varchar(40) DEFAULT NULL,
 `fromdomain` varchar(40) DEFAULT NULL,
 `fromuser` varchar(40) DEFAULT NULL,
 `qualify` varchar(40) DEFAULT NULL,
 `defaultip` varchar(40) DEFAULT NULL,
 `rtptimeout` int(11) DEFAULT NULL,
 `rtpholdtimeout` int(11) DEFAULT NULL,
 `sendrpid` enum('yes','no') DEFAULT NULL,
 `outboundproxy` varchar(40) DEFAULT NULL,
 `callbackextension` varchar(40) DEFAULT NULL,
 `registertrying` enum('yes','no') DEFAULT NULL,
 `timert1` int(11) DEFAULT NULL,
 `timerb` int(11) DEFAULT NULL,
 `qualifyfreq` int(11) DEFAULT NULL,
 `constantssrc` enum('yes','no') DEFAULT NULL,
 `contactpermit` varchar(40) DEFAULT NULL,
 `contactdeny` varchar(40) DEFAULT NULL,
 `usereqphone` enum('yes','no') DEFAULT NULL,
 `textsupport` enum('yes','no') DEFAULT NULL,
 `faxdetect` enum('yes','no') DEFAULT NULL,
 `buggymwi` enum('yes','no') DEFAULT NULL,
 `auth` varchar(40) DEFAULT NULL,
 `fullname` varchar(40) DEFAULT NULL,
 `trunkname` varchar(40) DEFAULT NULL,
 `cid_number` varchar(40) DEFAULT NULL,
 `callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') DEFAULT NULL,
 `mohinterpret` varchar(40) DEFAULT NULL,
 `mohsuggest` varchar(40) DEFAULT NULL,
 `parkinglot` varchar(40) DEFAULT NULL,
 `hasvoicemail` enum('yes','no') DEFAULT NULL,
 `subscribemwi` enum('yes','no') DEFAULT NULL,
 `vmexten` varchar(40) DEFAULT NULL,
 `autoframing` enum('yes','no') DEFAULT NULL,
 `rtpkeepalive` int(11) DEFAULT NULL,
 `call-limit` int(11) DEFAULT NULL,
 `g726nonstandard` enum('yes','no') DEFAULT NULL,
 `ignoresdpversion` enum('yes','no') DEFAULT NULL,
 `allowtransfer` enum('yes','no') DEFAULT NULL,
 `dynamic` enum('yes','no') DEFAULT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`),
 KEY `ipaddr` (`ipaddr`,`port`),
 KEY `host` (`host`,`port`)
) ENGINE=MyISAM;