asterisk users - Dec 2004 - What is sip-friends.sql??????

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

Its a way of storing ur sip stuff in a database rather than using the
flat files. Sip friends - extensions.conf stuff. Sip_buddies -
sip.conf stuff

At 09:44 AM 12/22/04, you wrote:
>Its a way of storing ur sip stuff in a database rather than using the
>flat files. Sip friends - extensions.conf stuff. Sip_buddies -
>sip.conf stuff
>_______________________________________________
this is the database to flat file storage I take it.


Regards
Greg Cirino

You are not quite correct.

sip-friends is the STABLE 1.0 method of storing sip.conf info on
peers/users.

sip_buddies is the CVS (RealTime) method of storing sip.conf info on
peers/users.

-Matthew

----- Original Message ----- 
From: "Giovanni Powell" <giovanni.powell@gmail.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
Sent: Wednesday, December 22, 2004 8:44 AM
Subject: Re: [Asterisk-Users] What is sip-friends.sql??????

> Its a way of storing ur sip stuff in a database rather than using the
> flat files. Sip friends - extensions.conf stuff. Sip_buddies -
> sip.conf stuff
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users