Index: sip-friends.sql
===================================================================
RCS file: /usr/cvsroot/asterisk/contrib/scripts/sip-friends.sql,v
retrieving revision 1.2
diff -u -r1.2 sip-friends.sql
--- sip-friends.sql	20 Feb 2004 15:39:43 -0000	1.2
+++ sip-friends.sql	8 Mar 2004 06:10:25 -0000
@@ -4,11 +4,21 @@
 
 CREATE TABLE `sipfriends` (
   `name` varchar(40) NOT NULL default '',
+  `type` int(2) NOT NULL default '3',
   `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',
+  `nat` int(2) NOT NULL default '1',
+  `canreinvite` int(2) NOT NULL default '0',
+  `accountcode` varchar(20) NOT NULL default '',
+  `amaflags` int(2) NOT NULL default '0',
+  `dtmfmode` int(2) NOT NULL default '1',
+  `restrictcid` int(2) NOT NULL default '0',
+  `cidname` varchar(20) NOT NULL default '',
+  `cidnumber` varchar(20) NOT NULL default '',
+  `codecflags` int NOT NULL default '524302',
   PRIMARY KEY  (`name`)
 ) TYPE=MyISAM;