diff options
author | Tilghman Lesher <tilghman@meg.abyt.es> | 2008-03-12 01:54:00 +0000 |
---|---|---|
committer | Tilghman Lesher <tilghman@meg.abyt.es> | 2008-03-12 01:54:00 +0000 |
commit | f0096c713e7d7ec2933cb98e929bd92ea3a94aae (patch) | |
tree | 6328d8509b5cc20ed236b96430b1f66e26c0ef13 /contrib/scripts/iax-friends.sql | |
parent | ce66adb98173e26dab393cb0d6c609c4512a3702 (diff) |
Merged revisions 107877 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.4
........
r107877 | tilghman | 2008-03-11 20:52:40 -0500 (Tue, 11 Mar 2008) | 2 lines
Document all of the possible realtime fields
........
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@107878 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'contrib/scripts/iax-friends.sql')
-rw-r--r-- | contrib/scripts/iax-friends.sql | 41 |
1 files changed, 40 insertions, 1 deletions
diff --git a/contrib/scripts/iax-friends.sql b/contrib/scripts/iax-friends.sql index 717a27d07..9f8cd5ccd 100644 --- a/contrib/scripts/iax-friends.sql +++ b/contrib/scripts/iax-friends.sql @@ -4,12 +4,51 @@ CREATE TABLE `iaxfriends` ( `name` varchar(40) NOT NULL default '', + `username` varchar(40) NOT NULL default '', `secret` varchar(40) NOT NULL default '', + `dbsecret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', + `regcontext` varchar(40) NOT NULL default '', + `host` varchar(40) NOT NULL default 'dynamic', `ipaddr` varchar(20) NOT NULL default '', `port` int(6) NOT NULL default '0', + `defaultip` varchar(20) NOT NULL default '', + `sourceaddress` varchar(20) NOT NULL default '', + `mask` varchar(20) NOT NULL default '', + `regexten` varchar(40) NOT NULL default '', `regseconds` int(11) NOT NULL default '0', `accountcode` varchar(20) NOT NULL default '', - PRIMARY KEY (`name`) + `mohinterpret` varchar(20) NOT NULL default '', + `mohsuggest` varchar(20) NOT NULL default '', + `inkeys` varchar(40) NOT NULL default '', + `outkey` varchar(40) NOT NULL default '', + `language` varchar(10) NOT NULL default '', + `callerid` varchar(40) NOT NULL default '', + `cid_number` varchar(40) NOT NULL default '', + `sendani` varchar(10) NOT NULL default '', + `fullname` varchar(40) NOT NULL default '', + `trunk` varchar(10) NOT NULL default '', + `auth` varchar(20) NOT NULL default '', + `maxauthreq` varchar(15) NOT NULL default '', + `encryption` varchar(20) NOT NULL default '', + `transfer` varchar(10) NOT NULL default '', + `jitterbuffer` varchar(10) NOT NULL default '', + `forcejitterbuffer` varchar(10) NOT NULL default '', + `disallow` varchar(40) NOT NULL default 'all', + `allow` varchar(40) NOT NULL default '', + `codecpriority` varchar(40) NOT NULL default '', + `qualify` varchar(10) NOT NULL default '', + `qualifysmoothing` varchar(10) NOT NULL default '', + `qualifyfreqok` varchar(10) NOT NULL default '', + `qualifyfreqnotok` varchar(10) NOT NULL default '', + `timezone` varchar(20) NOT NULL default '', + `adsi` varchar(10) NOT NULL default '', + `amaflags` varchar(20) NOT NULL default '', + `setvar` varchar(200) NOT NULL default '', + PRIMARY KEY (`name`), + INDEX name (name, host), + INDEX name2 (name, ipaddr, port), + INDEX ipaddr (ipaddr, port), + INDEX host (host, port), ) TYPE=MyISAM; |