summaryrefslogtreecommitdiff
path: root/contrib/realtime
diff options
context:
space:
mode:
authorMatthew Jordan <mjordan@digium.com>2011-11-17 19:47:29 +0000
committerMatthew Jordan <mjordan@digium.com>2011-11-17 19:47:29 +0000
commitcd9680e241453d7e95c4385868ce79121fc49601 (patch)
tree3e026ffb4013292ad1e9a2e84a673145a83bd660 /contrib/realtime
parent279873e8eb2a9cb97878b72f221b22c10cdcc63c (diff)
Accidentally readded sipfriends.sql in r345560. This was removed
in r342871 git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@345601 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'contrib/realtime')
-rw-r--r--contrib/realtime/mysql/sipfriends.sql97
1 files changed, 0 insertions, 97 deletions
diff --git a/contrib/realtime/mysql/sipfriends.sql b/contrib/realtime/mysql/sipfriends.sql
deleted file mode 100644
index 07cd8788a..000000000
--- a/contrib/realtime/mysql/sipfriends.sql
+++ /dev/null
@@ -1,97 +0,0 @@
-#
-# Table structure for table `sipfriends`
-#
-
-CREATE TABLE IF NOT EXISTS `sipfriends` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(10) NOT NULL,
- `ipaddr` varchar(15) DEFAULT NULL,
- `port` int(5) DEFAULT NULL,
- `regseconds` int(11) DEFAULT NULL,
- `defaultuser` varchar(10) DEFAULT NULL,
- `fullcontact` varchar(35) DEFAULT NULL,
- `regserver` varchar(20) DEFAULT NULL,
- `useragent` varchar(20) DEFAULT NULL,
- `lastms` int(11) DEFAULT NULL,
- `host` varchar(40) DEFAULT NULL,
- `type` enum('friend','user','peer') DEFAULT NULL,
- `context` varchar(40) DEFAULT NULL,
- `permit` varchar(40) DEFAULT NULL,
- `deny` varchar(40) DEFAULT NULL,
- `secret` varchar(40) DEFAULT NULL,
- `md5secret` varchar(40) DEFAULT NULL,
- `remotesecret` varchar(40) DEFAULT NULL,
- `transport` enum('udp','tcp','udp,tcp','tcp,udp') DEFAULT NULL,
- `dtmfmode` enum('rfc2833','info','shortinfo','inband','auto') DEFAULT NULL,
- `directmedia` enum('yes','no','nonat','update') DEFAULT NULL,
- `nat` enum('yes','no','never','route') DEFAULT NULL,
- `callgroup` varchar(40) DEFAULT NULL,
- `pickupgroup` varchar(40) DEFAULT NULL,
- `language` varchar(40) DEFAULT NULL,
- `allow` varchar(200) DEFAULT NULL,
- `insecure` varchar(40) DEFAULT NULL,
- `trustrpid` enum('yes','no') DEFAULT NULL,
- `progressinband` enum('yes','no','never') DEFAULT NULL,
- `promiscredir` enum('yes','no') DEFAULT NULL,
- `useclientcode` enum('yes','no') DEFAULT NULL,
- `accountcode` varchar(40) DEFAULT NULL,
- `setvar` varchar(40) DEFAULT NULL,
- `callerid` varchar(40) DEFAULT NULL,
- `amaflags` varchar(40) DEFAULT NULL,
- `callcounter` enum('yes','no') DEFAULT NULL,
- `busylevel` int(11) DEFAULT NULL,
- `allowoverlap` enum('yes','no') DEFAULT NULL,
- `allowsubscribe` enum('yes','no') DEFAULT NULL,
- `videosupport` enum('yes','no') DEFAULT NULL,
- `maxcallbitrate` int(11) DEFAULT NULL,
- `rfc2833compensate` enum('yes','no') DEFAULT NULL,
- `mailbox` varchar(40) DEFAULT NULL,
- `session-timers` enum('accept','refuse','originate') DEFAULT NULL,
- `session-expires` int(11) DEFAULT NULL,
- `session-minse` int(11) DEFAULT NULL,
- `session-refresher` enum('uac','uas') DEFAULT NULL,
- `t38pt_usertpsource` varchar(40) DEFAULT NULL,
- `regexten` varchar(40) DEFAULT NULL,
- `fromdomain` varchar(40) DEFAULT NULL,
- `fromuser` varchar(40) DEFAULT NULL,
- `qualify` varchar(40) DEFAULT NULL,
- `defaultip` varchar(40) DEFAULT NULL,
- `rtptimeout` int(11) DEFAULT NULL,
- `rtpholdtimeout` int(11) DEFAULT NULL,
- `sendrpid` enum('yes','no') DEFAULT NULL,
- `outboundproxy` varchar(40) DEFAULT NULL,
- `callbackextension` varchar(40) DEFAULT NULL,
- `registertrying` enum('yes','no') DEFAULT NULL,
- `timert1` int(11) DEFAULT NULL,
- `timerb` int(11) DEFAULT NULL,
- `qualifyfreq` int(11) DEFAULT NULL,
- `constantssrc` enum('yes','no') DEFAULT NULL,
- `contactpermit` varchar(40) DEFAULT NULL,
- `contactdeny` varchar(40) DEFAULT NULL,
- `usereqphone` enum('yes','no') DEFAULT NULL,
- `textsupport` enum('yes','no') DEFAULT NULL,
- `faxdetect` enum('yes','no') DEFAULT NULL,
- `buggymwi` enum('yes','no') DEFAULT NULL,
- `auth` varchar(40) DEFAULT NULL,
- `fullname` varchar(40) DEFAULT NULL,
- `trunkname` varchar(40) DEFAULT NULL,
- `cid_number` varchar(40) DEFAULT NULL,
- `callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') DEFAULT NULL,
- `mohinterpret` varchar(40) DEFAULT NULL,
- `mohsuggest` varchar(40) DEFAULT NULL,
- `parkinglot` varchar(40) DEFAULT NULL,
- `hasvoicemail` enum('yes','no') DEFAULT NULL,
- `subscribemwi` enum('yes','no') DEFAULT NULL,
- `vmexten` varchar(40) DEFAULT NULL,
- `autoframing` enum('yes','no') DEFAULT NULL,
- `rtpkeepalive` int(11) DEFAULT NULL,
- `call-limit` int(11) DEFAULT NULL,
- `g726nonstandard` enum('yes','no') DEFAULT NULL,
- `ignoresdpversion` enum('yes','no') DEFAULT NULL,
- `allowtransfer` enum('yes','no') DEFAULT NULL,
- `dynamic` enum('yes','no') DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- KEY `ipaddr` (`ipaddr`,`port`),
- KEY `host` (`host`,`port`)
-) ENGINE=MyISAM;