[asterisk-users] usage of each field

[Anthony Francis]

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