diff options
author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-07-13 14:49:46 +0000 |
---|---|---|
committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-07-13 14:49:46 +0000 |
commit | 7fd284c51580790f1a834a9c42401998986d9dbc (patch) | |
tree | 37ac377fb75d3644469a241ddda1032b5edea970 /contrib/realtime/mysql/iaxfriends.sql | |
parent | b9c441a77fd5e2c8c97d595c24bc95809241ec2e (diff) |
Merged revisions 275910 via svnmerge from
https://origsvn.digium.com/svn/asterisk/trunk
................
r275910 | tilghman | 2010-07-13 09:48:40 -0500 (Tue, 13 Jul 2010) | 9 lines
Merged revisions 275909 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.4
........
r275909 | tilghman | 2010-07-13 09:47:30 -0500 (Tue, 13 Jul 2010) | 2 lines
Move SQL scripts into their own database-specific directories.
........
................
git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.6.2@275911 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib/realtime/mysql/iaxfriends.sql')
-rw-r--r-- | contrib/realtime/mysql/iaxfriends.sql | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/contrib/realtime/mysql/iaxfriends.sql b/contrib/realtime/mysql/iaxfriends.sql new file mode 100644 index 000000000..a83d8ce46 --- /dev/null +++ b/contrib/realtime/mysql/iaxfriends.sql @@ -0,0 +1,57 @@ +# +# Table structure for table `iaxfriends` +# + +CREATE TABLE `iaxfriends` ( + `name` varchar(40) NOT NULL default '', + `type` varchar(10) NOT NULL default 'friend', -- friend/user/peer + `username` varchar(40) NULL, -- username to send as peer + `mailbox` varchar(40) NULL, -- mailbox@context + `secret` varchar(40) NULL, + `dbsecret` varchar(40) NULL, -- In AstDB, location to store/retrieve secret + `context` varchar(40) NULL, + `regcontext` varchar(40) NULL, + `host` varchar(40) NULL default 'dynamic', + `ipaddr` varchar(20) NULL, -- Must be updateable by Asterisk user + `port` int(5) NULL, -- Must be updateable by Asterisk user + `defaultip` varchar(20) NULL, + `sourceaddress` varchar(20) NULL, + `mask` varchar(20) NULL, + `regexten` varchar(40) NULL, + `regseconds` int(11) NULL, -- Must be updateable by Asterisk user + `accountcode` varchar(20) NULL, + `mohinterpret` varchar(20) NULL, + `mohsuggest` varchar(20) NULL, + `inkeys` varchar(40) NULL, + `outkey` varchar(40) NULL, + `language` varchar(10) NULL, + `callerid` varchar(100) NULL, -- The whole callerid string, or broken down in the next 3 fields + `cid_number` varchar(40) NULL, -- The number portion of the callerid + `sendani` varchar(10) NULL, -- yes/no + `fullname` varchar(40) NULL, -- The name portion of the callerid + `trunk` varchar(3) NULL, -- Yes/no + `auth` varchar(20) NULL, -- RSA/md5/plaintext + `maxauthreq` varchar(5) NULL, -- Maximum outstanding AUTHREQ calls {1-32767} + `requirecalltoken` varchar(4) NULL, -- yes/no/auto + `encryption` varchar(20) NULL, -- aes128/yes/no + `transfer` varchar(10) NULL, -- mediaonly/yes/no + `jitterbuffer` varchar(3) NULL, -- yes/no + `forcejitterbuffer` varchar(3) NULL, -- yes/no + `disallow` varchar(40) NULL, -- all/{list-of-codecs} + `allow` varchar(40) NULL, -- all/{list-of-codecs} + `codecpriority` varchar(40) NULL, + `qualify` varchar(10) NULL, -- yes/no/{number of milliseconds} + `qualifysmoothing` varchar(10) NULL, -- yes/no + `qualifyfreqok` varchar(10) NULL, -- {number of milliseconds}|60000 + `qualifyfreqnotok` varchar(10) NULL, -- {number of milliseconds}|10000 + `timezone` varchar(20) NULL, + `adsi` varchar(10) NULL, -- yes/no + `amaflags` varchar(20) NULL, + `setvar` varchar(200) NULL, + PRIMARY KEY (`name`), + INDEX name (name, host), + INDEX name2 (name, ipaddr, port), + INDEX ipaddr (ipaddr, port), + INDEX host (host, port) +); + |