summaryrefslogtreecommitdiff
path: root/contrib/realtime
diff options
context:
space:
mode:
authorMatthew Jordan <mjordan@digium.com>2011-11-17 18:09:13 +0000
committerMatthew Jordan <mjordan@digium.com>2011-11-17 18:09:13 +0000
commit279873e8eb2a9cb97878b72f221b22c10cdcc63c (patch)
tree70037a5d19ecc8068b8f95e9c6de87e166130650 /contrib/realtime
parent4a125f45a0e6bb2a6c71265521834ef3dd1972cd (diff)
Add admin toggle mute all and participant count menu options to app_confbridge
This patch adds two new menu features to app_confbridge, admin_toggle_menu_ participants and participant_count. The admin action will globally mute / unmute all non-admin participants on a converence, while the participant count simply exposes the existing participant count function to the conference bridge menu. This also adds configuration options to change the sound played when the conference is globally muted / unmuted, as well as the necessary config hooks to place these functions in the DTMF menus. (closes issue ASTERISK-18204) Reported by: Kevin Reeves Tested by: Matt Jordan Patches: app_confbridge.c.patch.txt, conf_config_parser.c.patch.txt, confbridge.h.patch.txt uploaded by Kevin Reeves (license 6281) Review: https://reviewboard.asterisk.org/r/1518/ git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@345560 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'contrib/realtime')
-rw-r--r--contrib/realtime/mysql/sipfriends.sql97
1 files changed, 97 insertions, 0 deletions
diff --git a/contrib/realtime/mysql/sipfriends.sql b/contrib/realtime/mysql/sipfriends.sql
new file mode 100644
index 000000000..07cd8788a
--- /dev/null
+++ b/contrib/realtime/mysql/sipfriends.sql
@@ -0,0 +1,97 @@
+#
+# 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;