[asterisk-users] usage of each field

[Rilawich Ango]

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;