diff options
author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-03-12 01:54:00 +0000 |
---|---|---|
committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-03-12 01:54:00 +0000 |
commit | 7076f48ef54648362e43b9601a8a0459a82ecdfb (patch) | |
tree | 6328d8509b5cc20ed236b96430b1f66e26c0ef13 /contrib/scripts/sip-friends.sql | |
parent | e1e65e86e8ad4e6c6364acc4c077f012d3be6f4c (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: http://svn.digium.com/svn/asterisk/trunk@107878 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib/scripts/sip-friends.sql')
-rw-r--r-- | contrib/scripts/sip-friends.sql | 46 |
1 files changed, 43 insertions, 3 deletions
diff --git a/contrib/scripts/sip-friends.sql b/contrib/scripts/sip-friends.sql index 15d7cb393..d76db7f93 100644 --- a/contrib/scripts/sip-friends.sql +++ b/contrib/scripts/sip-friends.sql @@ -4,11 +4,51 @@ CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', - `secret` varchar(40) NOT NULL default '', + `type` varchar(10) NOT NULL default '', + `username` varchar(40), + `fromuser` varchar(40), + `fromdomain` varchar(40), + `secret` varchar(40), + `md5secret` varchar(40), + `auth` varchar(10), + `mailbox` varchar(20), + `subscribemwi` varchar(10), -- yes/no + `vmexten` varchar(20), + `callerid` varchar(40), + `cid_number` varchar(40), + `callingpres` varchar(20), + `usereqphone` varchar(10), + `language` varchar(10), + `incominglimit` varchar(10), `context` varchar(40) NOT NULL default '', - `username` varchar(40) default '', + `subscribecontext` varchar(40), + `amaflags` varchar(20), + `accountcode` varchar(20), + `musicclass` varchar(20), + `mohsuggest` varchar(20), + `allowtransfer` varchar(20), + `callgroup` varchar(20), + `pickupgroup` varchar(20), + `autoframing` varchar(10), -- yes/no + `disallow` varchar(20) default 'all', + `allow` varchar(20), + `maxcallbitrate` varchar(15), + `host` varchar(40) default 'dynamic', + `outboundproxy` varchar(40), `ipaddr` varchar(20) NOT NULL default '', + `defaultip` varchar(20), `port` int(6) NOT NULL default '0', + `fullcontact` varchar(40), + `insecure` varchar(20), + `qualify` varchar(15), `regseconds` int(11) NOT NULL default '0', - PRIMARY KEY (`name`) + `regexten` varchar(20), + `regserver` varchar(20), + `rtptimeout` varchar(15), + `rtpholdtimeout` varchar(15), + `rtpkeepalive` varchar(15), + `setvar` varchar(200), + PRIMARY KEY (`name`), + INDEX host (host, port), + INDEX ipaddr (ipaddr, port), ) TYPE=MyISAM; |