[Asterisk-Users] What is sip-friends.sql??????

[Greg - Cirelle Enterprises]

maybe a dumb question but what do we have here???

sip-friends.sql
#
# Table structure for table `sipfriends`
#

CREATE TABLE `sipfriends` (
   `name` varchar(40) NOT NULL default '',
   `secret` varchar(40) NOT NULL default '',
   `context` varchar(40) NOT NULL default '',
   `username` varchar(40) default '',
   `ipaddr` varchar(20) NOT NULL default '',
   `port` int(6) NOT NULL default '0',
   `regseconds` int(11) NOT NULL default '0',
   PRIMARY KEY  (`name`)
) TYPE=MyISAM;


Realtime SIP
#
# Table structure for table `sip_buddies`
#

CREATE TABLE `sip_buddies` (
  `uniqueid` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `accountcode` varchar(30) default NULL,
  `amaflags` char(1) default NULL,
  `callgroup` varchar(30) default NULL,
  `callerid` varchar(50) default NULL,
  `canreinvite` char(1) default NULL,
  `context` varchar(30) default NULL,
  `defaultip` varchar(15) default NULL,
  `dtmfmode` varchar(7) default NULL,
  `fromuser` varchar(50) default NULL,
  `fromdomain` varchar(31) default NULL,
  `host` varchar(31) NOT NULL default '',
  `incominglimit` char(2) default NULL,
  `outgoinglimit` char(2) default NULL,
  `insecure` char(1) default NULL,
  `language` char(2) default NULL,
  `mailbox` varchar(50) default NULL,
  `md5secret` varchar(32) default NULL,
  `nat` varchar(5) default NULL,
  `permit` varchar(95) default NULL,
  `deny` varchar(95) default NULL,
  `pickupgroup` varchar(10) default NULL,
  `port` varchar(5) NOT NULL default '',
  `qualify` varchar(4) default NULL,
  `restrictcid` char(1) default NULL,
  `rtptimeout` char(3) default NULL,
  `rtpholdtimeout` char(3) default NULL,
  `secret` varchar(30) default NULL,
  `type` varchar(6) NOT NULL default '',
  `username` varchar(30) NOT NULL default '',
  `allow` varchar(100) default NULL,
  `disallow` varchar(100) default NULL,
  `regseconds` int(11) NOT NULL default '0',
  `ipaddr` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`uniqueid`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) TYPE=MyISAM;

Regards
Greg Cirino