Hi all,
From the web, I can find a table scheme of sipusers for ARA using.
However, I can't find any meaning of each field, especially for the
field regserver which is new in the table. Can any tell me more
detail about the usage of each field?
CREATE TABLE `sip_buddies` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '',
`host` varchar(31) NOT NULL default '',
`nat` varchar(5) NOT NULL default 'no',
`type` enum('user','peer','friend') NOT NULL default
'friend',
`accountcode` varchar(20) default NULL,
`amaflags` varchar(13) default NULL,
`callgroup` varchar(10) default NULL,
`callerid` varchar(80) default NULL,
`cancallforward` char(3) default 'yes',
`canreinvite` char(3) default 'yes',
`context` varchar(80) default NULL,
`defaultip` varchar(15) default NULL,
`dtmfmode` varchar(7) default NULL,
`fromuser` varchar(80) default NULL,
`fromdomain` varchar(80) default NULL,
`insecure` varchar(4) default NULL,
`language` char(2) default NULL,
`mailbox` varchar(50) default NULL,
`md5secret` varchar(80) default NULL,
`deny` varchar(95) default NULL,
`permit` varchar(95) default NULL,
`mask` varchar(95) default NULL,
`musiconhold` varchar(100) default NULL,
`pickupgroup` varchar(10) default NULL,
`qualify` char(3) default NULL,
`regexten` varchar(80) default NULL,
`restrictcid` char(3) default NULL,
`rtptimeout` char(3) default NULL,
`rtpholdtimeout` char(3) default NULL,
`secret` varchar(80) default NULL,
`setvar` varchar(100) default NULL,
`disallow` varchar(100) default 'all',
`allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw',
`fullcontact` varchar(80) NOT NULL default '',
`ipaddr` varchar(15) NOT NULL default '',
`port` smallint(5) unsigned NOT NULL default '0',
`regserver` varchar(100) default NULL,
`regseconds` int(11) NOT NULL default '0',
`username` varchar(80) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
Rilawich Ango wrote:> Hi all, > > From the web, I can find a table scheme of sipusers for ARA using. > However, I can't find any meaning of each field, especially for the > field regserver which is new in the table. Can any tell me more > detail about the usage of each field? > > CREATE TABLE `sip_buddies` ( > `id` int(11) NOT NULL auto_increment, > `name` varchar(80) NOT NULL default '', > `host` varchar(31) NOT NULL default '', > `nat` varchar(5) NOT NULL default 'no', > `type` enum('user','peer','friend') NOT NULL default 'friend', > `accountcode` varchar(20) default NULL, > `amaflags` varchar(13) default NULL, > `callgroup` varchar(10) default NULL, > `callerid` varchar(80) default NULL, > `cancallforward` char(3) default 'yes', > `canreinvite` char(3) default 'yes', > `context` varchar(80) default NULL, > `defaultip` varchar(15) default NULL, > `dtmfmode` varchar(7) default NULL, > `fromuser` varchar(80) default NULL, > `fromdomain` varchar(80) default NULL, > `insecure` varchar(4) default NULL, > `language` char(2) default NULL, > `mailbox` varchar(50) default NULL, > `md5secret` varchar(80) default NULL, > `deny` varchar(95) default NULL, > `permit` varchar(95) default NULL, > `mask` varchar(95) default NULL, > `musiconhold` varchar(100) default NULL, > `pickupgroup` varchar(10) default NULL, > `qualify` char(3) default NULL, > `regexten` varchar(80) default NULL, > `restrictcid` char(3) default NULL, > `rtptimeout` char(3) default NULL, > `rtpholdtimeout` char(3) default NULL, > `secret` varchar(80) default NULL, > `setvar` varchar(100) default NULL, > `disallow` varchar(100) default 'all', > `allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw', > `fullcontact` varchar(80) NOT NULL default '', > `ipaddr` varchar(15) NOT NULL default '', > `port` smallint(5) unsigned NOT NULL default '0', > `regserver` varchar(100) default NULL, > `regseconds` int(11) NOT NULL default '0', > `username` varchar(80) NOT NULL default '', > PRIMARY KEY (`id`), > UNIQUE KEY `name` (`name`), > KEY `name_2` (`name`) > ) TYPE=MyISAM ROW_FORMAT=DYNAMIC; > > _______________________________________________ > --Bandwidth and Colocation Provided by http://www.api-digital.com-- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >Here you go! http://www.voip-info.org/wiki-Asterisk+config+sip.conf