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
_______________________________________________ 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