Thread: [Astpp-commit] SF.net SVN: astpp:[2224] trunk/freeswitch/contrib
Brought to you by:
darrenkw
Menu
▾
▴
astpp-commit
|
From: <dar...@us...> - 2009-01-31 18:53:54
|
Revision: 2224
http://astpp.svn.sourceforge.net/astpp/?rev=2224&view=rev
Author: darrenkw
Date: 2009-01-31 18:53:47 +0000 (Sat, 31 Jan 2009)
Log Message:
-----------
Add sample configuration from my testing machine.
Added Paths:
-----------
trunk/freeswitch/contrib/darren/
trunk/freeswitch/contrib/darren/conf/
trunk/freeswitch/contrib/darren/conf/autoload_configs/
trunk/freeswitch/contrib/darren/conf/autoload_configs/acl.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/alsa.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/cdr_csv.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/cdr_csv.conf.xml.backup
trunk/freeswitch/contrib/darren/conf/autoload_configs/conference.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/console.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/dialplan_directory.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/dingaling.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/enum.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/event_multicast.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/event_socket.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/fax.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/iax.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/ivr.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/java.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/limit.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/local_stream.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/logfile.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/lua.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/modules.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/openmrcp.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/perl.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/pocketsphinx.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/portaudio.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/post_load_modules.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/python.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/rss.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/sofia.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/spidermonkey.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/switch.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/syslog.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/timezones.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/voicemail.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/wanpipe.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/woomera.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/xml_cdr.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/xml_curl.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/xml_rpc.conf.xml
trunk/freeswitch/contrib/darren/conf/autoload_configs/zeroconf.conf.xml
trunk/freeswitch/contrib/darren/conf/dialplan/
trunk/freeswitch/contrib/darren/conf/dialplan/default.xml
trunk/freeswitch/contrib/darren/conf/dialplan/extensions/
trunk/freeswitch/contrib/darren/conf/dialplan/extensions/00_pizza_demo.xml
trunk/freeswitch/contrib/darren/conf/dialplan/extensions/99999_enum.xml
trunk/freeswitch/contrib/darren/conf/dialplan/features.xml
trunk/freeswitch/contrib/darren/conf/dialplan/public.xml
trunk/freeswitch/contrib/darren/conf/directory/
trunk/freeswitch/contrib/darren/conf/directory/default/
trunk/freeswitch/contrib/darren/conf/directory/default/1001.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1002.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1003.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1004.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1005.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1006.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1007.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1008.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1009.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1010.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1011.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1012.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1013.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1014.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1015.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1016.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1017.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1018.xml
trunk/freeswitch/contrib/darren/conf/directory/default/1019.xml
trunk/freeswitch/contrib/darren/conf/directory/default/brian.xml
trunk/freeswitch/contrib/darren/conf/directory/default/default.xml
trunk/freeswitch/contrib/darren/conf/directory/default.xml
trunk/freeswitch/contrib/darren/conf/extensions.conf
trunk/freeswitch/contrib/darren/conf/freeswitch.xml
trunk/freeswitch/contrib/darren/conf/fur_elise.ttml
trunk/freeswitch/contrib/darren/conf/jingle_profiles/
trunk/freeswitch/contrib/darren/conf/jingle_profiles/client.xml
trunk/freeswitch/contrib/darren/conf/jingle_profiles/server.xml
trunk/freeswitch/contrib/darren/conf/lang/
trunk/freeswitch/contrib/darren/conf/lang/de/
trunk/freeswitch/contrib/darren/conf/lang/de/de.xml
trunk/freeswitch/contrib/darren/conf/lang/de/demo/
trunk/freeswitch/contrib/darren/conf/lang/de/demo/demo.xml
trunk/freeswitch/contrib/darren/conf/lang/de/vm/
trunk/freeswitch/contrib/darren/conf/lang/de/vm/tts.xml
trunk/freeswitch/contrib/darren/conf/lang/en/
trunk/freeswitch/contrib/darren/conf/lang/en/demo/
trunk/freeswitch/contrib/darren/conf/lang/en/demo/demo-ivr.xml
trunk/freeswitch/contrib/darren/conf/lang/en/demo/demo.xml
trunk/freeswitch/contrib/darren/conf/lang/en/en.xml
trunk/freeswitch/contrib/darren/conf/lang/en/vm/
trunk/freeswitch/contrib/darren/conf/lang/en/vm/sounds.xml
trunk/freeswitch/contrib/darren/conf/lang/en/vm/tts.xml
trunk/freeswitch/contrib/darren/conf/lang/fr/
trunk/freeswitch/contrib/darren/conf/lang/fr/demo/
trunk/freeswitch/contrib/darren/conf/lang/fr/demo/demo.xml
trunk/freeswitch/contrib/darren/conf/lang/fr/fr.xml
trunk/freeswitch/contrib/darren/conf/lang/fr/vm/
trunk/freeswitch/contrib/darren/conf/lang/fr/vm/sounds.xml
trunk/freeswitch/contrib/darren/conf/mime.types
trunk/freeswitch/contrib/darren/conf/mrcp_profiles/
trunk/freeswitch/contrib/darren/conf/mrcp_profiles/openmrcp-v1.xml
trunk/freeswitch/contrib/darren/conf/mrcp_profiles/openmrcp-v2.xml
trunk/freeswitch/contrib/darren/conf/notify-voicemail.tpl
trunk/freeswitch/contrib/darren/conf/sip_profiles/
trunk/freeswitch/contrib/darren/conf/sip_profiles/external/
trunk/freeswitch/contrib/darren/conf/sip_profiles/external/example.xml
trunk/freeswitch/contrib/darren/conf/sip_profiles/external.xml
trunk/freeswitch/contrib/darren/conf/sip_profiles/internal/
trunk/freeswitch/contrib/darren/conf/sip_profiles/internal/example.xml
trunk/freeswitch/contrib/darren/conf/sip_profiles/internal-ipv6.xml
trunk/freeswitch/contrib/darren/conf/sip_profiles/internal.xml
trunk/freeswitch/contrib/darren/conf/tetris.ttml
trunk/freeswitch/contrib/darren/conf/vars.xml
trunk/freeswitch/contrib/darren/conf/voicemail.tpl
trunk/freeswitch/contrib/darren/conf/web-vm.tpl
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/acl.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/acl.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/acl.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,29 @@
+<configuration name="acl.conf" description="Network Lists">
+ <network-lists>
+ <list name="dl-candidates" default="allow">
+ <node type="deny" cidr="10.0.0.0/8"/>
+ <node type="deny" cidr="172.16.0.0/12"/>
+ <node type="deny" cidr="192.168.0.0/16"/>
+ </list>
+ <list name="rfc1918" default="deny">
+ <node type="allow" cidr="10.0.0.0/8"/>
+ <node type="allow" cidr="172.16.0.0/12"/>
+ <node type="allow" cidr="192.168.0.0/16"/>
+ </list>
+
+ <list name="lan" default="allow">
+ <node type="deny" cidr="192.168.42.0/24"/>
+ <node type="allow" cidr="192.168.42.42/32"/>
+ </list>
+
+ <list name="strict" default="deny">
+ <node type="allow" cidr="208.102.123.124/32"/>
+ </list>
+
+ <list name="domains" default="deny">
+ <node type="allow" domain="$${domain}"/>
+ </list>
+
+ </network-lists>
+</configuration>
+
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/alsa.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/alsa.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/alsa.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,12 @@
+<configuration name="alsa.conf" description="Soundcard Endpoint">
+ <settings>
+ <!--Default dialplan and caller-id info -->
+ <param name="dialplan" value="XML"/>
+ <param name="cid-name" value="N800 Alsa"/>
+ <param name="cid-num" value="5555551212"/>
+
+ <!--audio sample rate and interval -->
+ <param name="sample-rate" value="8000"/>
+ <param name="codec-ms" value="20"/>
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/cdr_csv.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/cdr_csv.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/cdr_csv.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,17 @@
+<configuration name="cdr_csv.conf" description="CDR CSV Format">
+ <settings>
+ <!-- 'cdr-csv' will always be appended to log-base -->
+ <!--<param name="log-base" value="/var/log"/>-->
+ <param name="default-template" value="astpp"/>
+ <!-- This is like the info app but after the call is hung up -->
+ <!--<param name="debug" value="true"/>-->
+ <param name="rotate-on-hup" value="true"/>
+ <!-- may be a b or ab -->
+ <param name="legs" value="a"/>
+ </settings>
+ <templates>
+ <template name="example">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}", "${accountcode}","${read_codec}","${write_codec}"</template>
+ <template name="astpp">"${accountcode}","${caller_id_number}","${destination_number}","${context}","${caller_id}","${channel_name}","${bridge_channel}","${last_app}","${last_arg}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${amaflags}","${uuid}","${userfield}","${read_codec}","${write_codec}","none","none"</template>
+ </templates>
+</configuration>
+
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/cdr_csv.conf.xml.backup
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/cdr_csv.conf.xml.backup (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/cdr_csv.conf.xml.backup 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,20 @@
+<configuration name="cdr_csv.conf" description="CDR CSV Format">
+ <settings>
+ <!-- 'cdr-csv' will always be appended to log-base -->
+ <!--<param name="log-base" value="/var/log"/>-->
+ <param name="default-template" value="example"/>
+ <!-- This is like the info app but after the call is hung up -->
+ <!--<param name="debug" value="true"/>-->
+ <param name="rotate-on-hup" value="true"/>
+ <!-- may be a b or ab -->
+ <param name="legs" value="a"/>
+ </settings>
+ <templates>
+ <template name="sql">INSERT INTO cdr VALUES ("${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}", "${accountcode}");</template>
+ <template name="example">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}", "${accountcode}","${read_codec}","${write_codec}"</template>
+ <template name="snom">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}", "${accountcode}","${read_codec}","${write_codec}","${sip_user_agent}","${call_clientcode}","${sip_rtp_rxstat}","${sip_rtp_txstat}","${sofia_record_file}"</template>
+ <template name="linksys">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${uuid}","${bleg_uuid}","${accountcode}","${read_codec}","${write_codec}","${sip_user_agent}","${sip_p_rtp_stat}"</template>
+ <template name="asterisk">"${accountcode}","${caller_id_number}","${destination_number}","${context}","${caller_id}","${channel_name}","${bridge_channel}","${last_app}","${last_arg}","${start_stamp}","${answer_stamp}","${end_stamp}","${duration}","${billsec}","${hangup_cause}","${amaflags}","${uuid}","${userfield}"</template>
+ </templates>
+</configuration>
+
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/conference.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/conference.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/conference.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,150 @@
+<!-- http://wiki.freeswitch.org/wiki/Mod_conference -->
+<!-- None of these paths are real if you want any of these options you need to really set them up -->
+<configuration name="conference.conf" description="Audio Conference">
+ <!-- Advertise certain presence on startup . -->
+ <advertise>
+ <room name="3001@$${domain}" status="FreeSWITCH"/>
+ </advertise>
+
+ <!-- These are the default keys that map when you do not specify a caller control group -->
+ <!-- Note: none and default are reserved names for group names -->
+ <caller-controls>
+ <group name="default">
+ <control action="mute" digits="0"/>
+ <control action="deaf mute" digits="*"/>
+ <control action="energy up" digits="9"/>
+ <control action="energy equ" digits="8"/>
+ <control action="energy dn" digits="7"/>
+ <control action="vol talk up" digits="3"/>
+ <control action="vol talk zero" digits="2"/>
+ <control action="vol talk dn" digits="1"/>
+ <control action="vol listen up" digits="6"/>
+ <control action="vol listen zero" digits="5"/>
+ <control action="vol listen dn" digits="4"/>
+ <control action="hangup" digits="#"/>
+ </group>
+ </caller-controls>
+
+ <!-- Profiles are collections of settings you can reference by name. -->
+ <profiles>
+ <!--If no profile is specified it will default to "default"-->
+ <profile name="default">
+ <!-- Domain (for presence) -->
+ <param name="domain" value="$${domain}"/>
+ <!-- Sample Rate-->
+ <param name="rate" value="8000"/>
+ <!-- Number of milliseconds per frame -->
+ <param name="interval" value="20"/>
+ <!-- Energy level required for audio to be sent to the other users -->
+ <param name="energy-level" value="300"/>
+
+ <!--Can be | delim of waste|mute|deaf waste will always transmit data to each channel
+ even during silence -->
+ <!--<param name="member-flags" value="waste"/>-->
+
+ <!-- Name of the caller control group to use for this profile -->
+ <!-- <param name="caller-controls" value="some name"/> -->
+ <!-- TTS Engine to use -->
+ <!--<param name="tts-engine" value="cepstral"/>-->
+ <!-- TTS Voice to use -->
+ <!--<param name="tts-voice" value="david"/>-->
+
+ <!-- If TTS is enabled all audio-file params beginning with -->
+ <!-- 'say:' will be considered text to say with TTS -->
+ <!-- Set a default path here so you can use relative paths in the other sound params-->
+ <param name="sound-prefix" value="$${base_dir}/sounds/en/us/callie"/>
+ <!-- File to play to acknowledge succees -->
+ <!--<param name="ack-sound" value="beep.wav"/>-->
+ <!-- File to play to acknowledge failure -->
+ <!--<param name="nack-sound" value="beeperr.wav"/>-->
+ <!-- File to play to acknowledge muted -->
+ <param name="muted-sound" value="conference/conf-muted.wav"/>
+ <!-- File to play to acknowledge unmuted -->
+ <param name="unmuted-sound" value="conference/conf-unmuted.wav"/>
+ <!-- File to play if you are alone in the conference -->
+ <param name="alone-sound" value="conference/conf-alone.wav"/>
+ <!-- File to play endlessly (nobody will ever be able to talk) -->
+ <!--<param name="perpetual-sound" value="perpetual.wav"/>-->
+ <!-- File to play when you're alone (music on hold)-->
+ <param name="moh-sound" value="$${hold_music}"/>
+ <!-- File to play when you join the conference -->
+ <param name="enter-sound" value="tone_stream://%(200,0,500,600,700)"/>
+ <!-- File to play when you leave the conference -->
+ <param name="exit-sound" value="tone_stream://%(500,0,300,200,100,50,25)"/>
+ <!-- File to play when you ae ejected from the conference -->
+ <param name="kicked-sound" value="conference/conf-kicked.wav"/>
+ <!-- File to play when the conference is locked -->
+ <param name="locked-sound" value="conference/conf-locked.wav"/>
+ <!-- File to play when the conference is locked during the call-->
+ <param name="is-locked-sound" value="conference/conf-is-locked.wav"/>
+ <!-- File to play when the conference is unlocked during the call-->
+ <param name="is-unlocked-sound" value="conference/conf-is-unlocked.wav"/>
+ <!-- File to play to prompt for a pin -->
+ <param name="pin-sound" value="conference/conf-pin.wav"/>
+ <!-- File to play to when the pin is invalid -->
+ <param name="bad-pin-sound" value="conference/conf-bad-pin.wav"/>
+ <param name="comfort-noise-level" value="1400"/>
+ <!-- Conference pin -->
+ <!--<param name="pin" value="12345"/>-->
+ <!-- Default Caller ID Name for outbound calls -->
+ <param name="caller-id-name" value="$${outbound_caller_name}"/>
+ <!-- Default Caller ID Number for outbound calls -->
+ <param name="caller-id-number" value="$${outbound_caller_id}"/>
+ <!-- Suppress start and stop talking events -->
+ <!-- <param name="suppress-events" value="start-talking,stop-talking"/> -->
+ <!-- enable comfort noise generation -->
+ <param name="comfort-noise" value="true"/>
+ <!-- Uncomment auto-record to toggle recording every conference call. -->
+ <!-- Another valid value is shout://user:pa...@se.../live.mp3 -->
+ <!--
+ <param name="auto-record" value="/usr/local/freeswitch/sounds/conference/${conference_name}_${strftime(%Y-%m-%d-%H-%M-%S)}.wav"/>
+ -->
+ </profile>
+
+ <profile name="wideband">
+ <param name="domain" value="$${domain}"/>
+ <param name="rate" value="16000"/>
+ <param name="interval" value="20"/>
+ <param name="energy-level" value="300"/>
+ <param name="sound-prefix" value="$${base_dir}/sounds/en/us/callie"/>
+ <param name="muted-sound" value="conference/conf-muted.wav"/>
+ <param name="unmuted-sound" value="conference/conf-unmuted.wav"/>
+ <param name="alone-sound" value="conference/conf-alone.wav"/>
+ <param name="moh-sound" value="$${hold_music}"/>
+ <param name="enter-sound" value="tone_stream://%(200,0,500,600,700)"/>
+ <param name="exit-sound" value="tone_stream://%(500,0,300,200,100,50,25)"/>
+ <param name="kicked-sound" value="conference/conf-kicked.wav"/>
+ <param name="locked-sound" value="conference/conf-locked.wav"/>
+ <param name="is-locked-sound" value="conference/conf-is-locked.wav"/>
+ <param name="is-unlocked-sound" value="conference/conf-is-unlocked.wav"/>
+ <param name="pin-sound" value="conference/conf-pin.wav"/>
+ <param name="bad-pin-sound" value="conference/conf-bad-pin.wav"/>
+ <param name="caller-id-name" value="$${outbound_caller_name}"/>
+ <param name="caller-id-number" value="$${outbound_caller_id}"/>
+ <param name="comfort-noise" value="true"/>
+ </profile>
+
+ <profile name="ultrawideband">
+ <param name="domain" value="$${domain}"/>
+ <param name="rate" value="32000"/>
+ <param name="interval" value="20"/>
+ <param name="energy-level" value="300"/>
+ <param name="sound-prefix" value="$${base_dir}/sounds/en/us/callie"/>
+ <param name="muted-sound" value="conference/conf-muted.wav"/>
+ <param name="unmuted-sound" value="conference/conf-unmuted.wav"/>
+ <param name="alone-sound" value="conference/conf-alone.wav"/>
+ <param name="moh-sound" value="$${hold_music}"/>
+ <param name="enter-sound" value="tone_stream://%(200,0,500,600,700)"/>
+ <param name="exit-sound" value="tone_stream://%(500,0,300,200,100,50,25)"/>
+ <param name="kicked-sound" value="conference/conf-kicked.wav"/>
+ <param name="locked-sound" value="conference/conf-locked.wav"/>
+ <param name="is-locked-sound" value="conference/conf-is-locked.wav"/>
+ <param name="is-unlocked-sound" value="conference/conf-is-unlocked.wav"/>
+ <param name="pin-sound" value="conference/conf-pin.wav"/>
+ <param name="bad-pin-sound" value="conference/conf-bad-pin.wav"/>
+ <param name="caller-id-name" value="$${outbound_caller_name}"/>
+ <param name="caller-id-number" value="$${outbound_caller_id}"/>
+ <param name="comfort-noise" value="true"/>
+ </profile>
+ </profiles>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/console.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/console.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/console.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,56 @@
+<configuration name="console.conf" description="Console Logger">
+ <!-- pick a file name, a function name or 'all' -->
+ <!-- map as many as you need for specific debugging -->
+ <mappings>
+ <!--
+ name can be a file name, function name or 'all'
+ value is one or more of debug,info,notice,warning,err,crit,alert,all
+ See examples below
+
+
+ The following map is the default, which is all debug levels enabled:
+ <map name="all" value="debug,info,notice,warning,err,crit,alert"/>
+
+
+ Example: the following turns on debugging for error and critical levels only
+ <map name="all" value="err,crit"/>
+
+ NOTE: using map name="all" will override any other settings! If you
+ want a more specific set of console messages then you will need
+ to specify which files and/or functions you want to have debug
+ messages. One option is to turn on just the more critical
+ messages with map name="all", then specify the other types of
+ console messages you want to see for various files and functions.
+
+ Example: turn on ERROR, CRIT, ALERT for all modules, then specify other
+ levels for various modules and functions
+
+ <map name="all" value="err,crit,alert"/>
+ <map name="switch_loadable_module_process" value="all"/>
+ <map name="mod_local_stream.c" value="warning,debug"/>
+ <map name="mod_sndfile.c" value="warning,info,debug"/>
+ -->
+ <map name="all" value="console,debug,info,notice,warning,err,crit,alert"/>
+
+ <!--
+ You can use or modify this sample set of mappings. It turns on higher
+ level messages for all modules and then specifies extra lower level
+ messages for OpenZAP, Sofia, and switch core messages.
+
+ <map name="all" value="warning,err,crit,alert"/>
+ <map name="zap_analog.c" value="all"/>
+ <map name="zap_io.c" value="all"/>
+ <map name="zap_isdn.c" value="all"/>
+ <map name="zap_zt.c" value="all"/>
+ <map name="mod_openzap" value="all"/>
+ <map name="sofia.c" value="notice"/>
+ <map name="switch_core_state_machine.c" value="all"/>
+
+ -->
+ </mappings>
+ <settings>
+ <!-- comment or set to false for no color logging -->
+ <param name="colorize" value="true"/>
+ <param name="loglevel" value="info"/>
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/dialplan_directory.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/dialplan_directory.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/dialplan_directory.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,9 @@
+<configuration name="dialplan_directory.conf" description="Dialplan Directory">
+ <settings>
+ <param name="directory-name" value="ldap"/>
+ <param name="host" value="ldap.freeswitch.org"/>
+ <param name="dn" value="cn=Manager,dc=freeswitch,dc=org"/>
+ <param name="pass" value="test"/>
+ <param name="base" value="dc=freeswitch,dc=org"/>
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/dingaling.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/dingaling.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/dingaling.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,9 @@
+<configuration name="dingaling.conf" description="XMPP Jingle Endpoint">
+ <settings>
+ <param name="debug" value="0"/>
+ <param name="codec-prefs" value="PCMU"/>
+ </settings>
+
+ <X-PRE-PROCESS cmd="include" data="../jingle_profiles/*.xml"/>
+
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/enum.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/enum.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/enum.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,14 @@
+<configuration name="enum.conf" description="ENUM Module">
+ <settings>
+ <param name="default-root" value="e164.org"/>
+ <param name="default-isn-root" value="freenum.org"/>
+ <param name="query-timeout" value="10"/>
+ <param name="auto-reload" value="true"/>
+ </settings>
+
+ <routes>
+ <route service="E2U+SIP" regex="sip:(.*)" replace="sofia/${use_profile}/$1"/>
+ <!--<route service="E2U+IAX2" regex="iax2:(.*)" replace="iax/$1"/>-->
+ <!--<route service="E2U+XMPP" regex="XMPP:(.*)" replace="dingaling/$${xmpp_server_profile}/$1"/>-->
+ </routes>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/event_multicast.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/event_multicast.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/event_multicast.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,8 @@
+<configuration name="event_multicast.conf" description="Multicast Event">
+ <settings>
+ <param name="address" value="225.1.1.1"/>
+ <param name="port" value="4242"/>
+ <param name="bindings" value="all"/>
+ </settings>
+</configuration>
+
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/event_socket.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/event_socket.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/event_socket.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,8 @@
+<configuration name="event_socket.conf" description="Socket Client">
+ <settings>
+ <param name="listen-ip" value="127.0.0.1"/>
+ <param name="listen-port" value="8021"/>
+ <param name="password" value="ClueCon"/>
+ <!--<param name="apply-inbound-acl" value="lan"/>-->
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/fax.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/fax.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/fax.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,12 @@
+<configuration name="fax.conf" description="FAX application configuration">
+ <settings>
+ <param name="use-ecm" value="true"/>
+ <param name="verbose" value="false"/>
+ <param name="disable-v17" value="false"/>
+ <param name="ident" value="SpanDSP Fax Ident"/>
+ <param name="header" value="SpanDSP Fax Header"/>
+
+ <param name="spool-dir" value="/tmp"/>
+ <param name="file-prefix" value="faxrx"/>
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/iax.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/iax.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/iax.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,12 @@
+<configuration name="iax.conf" description="IAX Configuration">
+ <settings>
+ <param name="debug" value="0"/>
+ <param name="ip" value="$${local_ip_v4}"/>
+ <param name="port" value="4569"/>
+ <param name="context" value="public"/>
+ <param name="dialplan" value="XML"/>
+ <param name="codec-prefs" value="PCMU@20i,PCMA,speex,L16"/>
+ <param name="codec-master" value="us"/>
+ <param name="codec-rates" value="8"/>
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/ivr.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/ivr.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/ivr.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,58 @@
+<configuration name="ivr.conf" description="IVR menus">
+ <menus>
+ <!-- demo IVR setup -->
+ <!-- demo IVR, Main Menu -->
+ <menu name="demo_ivr"
+ greet-long="phrase:demo_ivr_main_menu"
+ greet-short="phrase:demo_ivr_main_menu_short"
+ invalid-sound="ivr/ivr-that_was_an_invalid_entry.wav"
+ exit-sound="voicemail/vm-goodbye.wav"
+ timeout ="10000"
+ inter-digit-timeout="2000"
+ max-failures="3"
+ max-timeouts="3"
+ digit-len="4">
+ <entry action="menu-exec-app" digits="1" param="bridge sofia/$${domain}/88...@co..."/>
+ <entry action="menu-exec-app" digits="2" param="transfer 9996 XML default"/> <!-- FS echo -->
+ <entry action="menu-exec-app" digits="3" param="transfer 9999 XML default"/> <!-- MOH -->
+ <entry action="menu-sub" digits="4" param="demo_ivr_submenu"/> <!-- demo sub menu -->
+ <entry action="menu-exec-app" digits="5" param="transfer 1234*256 enum"/> <!-- Screaming monkeys -->
+ <entry action="menu-exec-app" digits="/^(10[01][0-9])$/" param="transfer $1 XML default"/>
+ <entry action="menu-top" digits="9"/> <!-- Repeat this menu -->
+ </menu>
+ <!-- Demo IVR, Sub Menu -->
+ <menu name="demo_ivr_submenu"
+ greet-long="phrase:demo_ivr_sub_menu"
+ greet-short="phrase:demo_ivr_sub_menu_short"
+ invalid-sound="ivr/ivr-that_was_an_invalid_entry.wav"
+ exit-sound="voicemail/vm-goodbye.wav"
+ timeout="15000"
+ max-failures="3"
+ max-timeouts="3">
+ <entry action="menu-top" digits="*"/>
+ </menu>
+
+ </menus>
+
+
+</configuration>
+
+
+<!-- TTS sample; non-functional but it demonstrates say: and TTS -->
+<!--
+ <menu name="demo3"
+ greet-long="say:Press 1 to join the conference, Press 2 to join the other conference"
+ greet-short="say:Press 1 to join the conference, Press 2 to join the other conference"
+ invalid-sound="say:invalid extension"
+ exit-sound="say:exit sound"
+ timeout ="15000"
+ max-failures="3">
+ <entry action="menu-exit" digits="*"/>
+ <entry action="menu-playback" digits="1" param="say:You pressed 1"/>
+ <entry action="menu-call-transfer" digits="2" param=
+
+
+"1000"/>
+ <entry action="menu-call-transfer" digits="3" param="1001"/>
+ </menu>
+-->
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/java.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/java.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/java.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,11 @@
+<configuration name="java.conf" description="Java Plug-Ins">
+ <!-- Path to the Java 1.6 virtual machine to use -->
+ <javavm path="/usr/java/jdk1.6.0/jre/lib/i386/client/libjvm.so"/>
+ <!-- Options to pass to Java -->
+ <options>
+ <!-- Your class path (make sure freeswitch.jar is on it) -->
+ <option value="-Djava.class.path=/usr/local/freeswitch/scripts/freeswitch.jar"/>
+ <!-- Enable remote debugging -->
+ <option value="-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=127.0.0.1:8000"/>
+ </options>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/limit.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/limit.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/limit.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,5 @@
+<configuration name="limit.conf" description="LIMIT Configuration">
+ <settings>
+ <!--<param name="odbc-dsn" value="dsn:user:pass"/>-->
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/local_stream.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/local_stream.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/local_stream.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,26 @@
+<configuration name="local_stream.conf" description="stream files from local dir">
+ <directory name="moh/8000" path="$${base_dir}/sounds/music/8000">
+ <param name="rate" value="8000"/>
+ <param name="shuffle" value="true"/>
+ <param name="channels" value="1"/>
+ <param name="interval" value="20"/>
+ <param name="timer_name" value="soft"/>
+ </directory>
+
+ <directory name="moh/16000" path="$${base_dir}/sounds/music/16000">
+ <param name="rate" value="16000"/>
+ <param name="shuffle" value="true"/>
+ <param name="channels" value="1"/>
+ <param name="interval" value="20"/>
+ <param name="timer_name" value="soft"/>
+ </directory>
+ <!--
+ <directory name="moh/32000" path="$${base_dir}/sounds/music/32000">
+ <param name="rate" value="32000"/>
+ <param name="shuffle" value="true"/>
+ <param name="channels" value="1"/>
+ <param name="interval" value="20"/>
+ <param name="timer_name" value="soft"/>
+ </directory>
+ -->
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/logfile.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/logfile.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/logfile.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,24 @@
+<configuration name="logfile.conf" description="File Logging">
+ <settings>
+ <!-- true to auto rotate on HUP, false to open/close -->
+ <param name="rotate-on-hup" value="true"/>
+ </settings>
+ <profiles>
+ <profile name="default">
+ <settings>
+ <!-- File to log to -->
+ <!--<param name="logfile" value="/var/log/freeswitch.log"/>-->
+ <!-- At this length in bytes rotate the log file (0 for never) -->
+ <!--<param name="rollover" value="10485760"/>-->
+ </settings>
+ <mappings>
+ <!--
+ name can be a file name, function name or 'all'
+ value is one or more of debug,info,notice,warning,err,crit,alert,all
+ Please see comments in console.conf.xml for more information
+ -->
+ <map name="all" value="debug,info,notice,warning,err,crit,alert"/>
+ </mappings>
+ </profile>
+ </profiles>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/lua.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/lua.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/lua.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,15 @@
+<configuration name="lua.conf" description="LUA Configuration">
+ <settings>
+ <!--<param name="xml-handler-script" value="/dp.lua"/>-->
+ <!--<param name="xml-handler-bindings" value="dialplan"/>-->
+
+ <!--
+ The following options identifies a lua script that is launched
+ at startup and may live forever in the background.
+ You can define multiple lines, one for each script you
+ need to run.
+ -->
+ <!--<param name="startup-script" value="startup_script_1.lua"/>-->
+ <!--<param name="startup-script" value="startup_script_2.lua"/>-->
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/modules.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/modules.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/modules.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,90 @@
+<configuration name="modules.conf" description="Modules">
+ <modules>
+
+ <!-- Loggers (I'd load these first) -->
+ <load module="mod_console"/>
+ <load module="mod_logfile"/>
+ <!-- <load module="mod_syslog"/> -->
+
+ <!-- Multi-Faceted -->
+ <!-- mod_enum is a dialplan interface, an application interface and an api command interface -->
+ <load module="mod_enum"/>
+
+ <!-- XML Interfaces -->
+ <!-- <load module="mod_xml_rpc"/> -->
+ <load module="mod_xml_curl"/>
+ <load module="mod_xml_cdr"/>
+
+ <!-- Event Handlers -->
+ <load module="mod_cdr_csv"/>
+ <!-- <load module="mod_event_multicast"/> -->
+ <load module="mod_event_socket"/>
+ <!-- <load module="mod_xmpp_event"/> -->
+ <!-- <load module="mod_zeroconf"/> -->
+
+ <!-- Directory Interfaces -->
+ <!-- <load module="mod_ldap"/> -->
+
+ <!-- Endpoints -->
+ <!-- <load module="mod_dingaling"/> -->
+ <!-- <load module="mod_iax"/> -->
+ <!-- <load module="mod_portaudio"/> -->
+ <!-- <load module="mod_alsa"/> -->
+ <load module="mod_sofia"/>
+ <!-- <load module="mod_wanpipe"/> -->
+ <!-- <load module="mod_woomera"/> -->
+ <!-- <load module="mod_openzap"/> -->
+
+ <!-- Applications -->
+ <load module="mod_commands"/>
+ <load module="mod_conference"/>
+ <load module="mod_dptools"/>
+ <load module="mod_expr"/>
+ <load module="mod_fifo"/>
+ <load module="mod_voicemail"/>
+ <load module="mod_limit"/>
+ <load module="mod_esf"/>
+ <load module="mod_fsv"/>
+
+ <!-- Dialplan Interfaces -->
+ <!-- <load module="mod_dialplan_directory"/> -->
+ <load module="mod_dialplan_xml"/>
+ <load module="mod_dialplan_asterisk"/>
+
+ <!-- Codec Interfaces -->
+ <load module="mod_voipcodecs"/>
+ <load module="mod_g723_1"/>
+ <load module="mod_g729"/>
+ <load module="mod_amr"/>
+ <load module="mod_ilbc"/>
+ <load module="mod_speex"/>
+ <load module="mod_h26x"/>
+
+ <!-- File Format Interfaces -->
+ <load module="mod_sndfile"/>
+ <load module="mod_native_file"/>
+ <!--For icecast/mp3 streams/files-->
+ <!--<load module="mod_shout"/>-->
+ <!--For local streams (play all the files in a directory)-->
+ <load module="mod_local_stream"/>
+ <load module="mod_tone_stream"/>
+
+ <!-- Timers -->
+
+ <!-- Languages -->
+ <load module="mod_spidermonkey"/>
+ <load module="mod_perl"/>
+ <!-- <load module="mod_python"/> -->
+ <!-- <load module="mod_java"/> -->
+ <load module="mod_lua"/>
+
+ <!-- ASR /TTS -->
+ <!-- <load module="mod_cepstral"/> -->
+ <!-- <load module="mod_openmrcp"/> -->
+ <!-- <load module="mod_rss"/> -->
+ <load module="mod_pocketsphinx"/>
+
+ <!-- Say -->
+ <load module="mod_say_en"/>
+ </modules>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/openmrcp.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/openmrcp.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/openmrcp.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,10 @@
+<!-- http://wiki.freeswitch.org/wiki/Mod_openmrcp#Configuration -->
+<configuration name="openmrcp.conf" description="mod_openmrcp configuration">
+ <settings>
+ <param name="asr_default_profile" value="openmrcp-v2"/>
+ <param name="tts_default_profile" value="openmrcp-v2"/>
+ </settings>
+ <profiles>
+ <X-PRE-PROCESS cmd="include" data="../mrcp_profiles/*.xml"/>
+ </profiles>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/perl.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/perl.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/perl.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,16 @@
+<configuration name="perl.conf" description="PERL Configuration">
+ <settings>
+ <!--<param name="xml-handler-script" value="/tmp/xml.pl"/>-->
+ <!--<param name="xml-handler-bindings" value="dialplan"/>-->
+
+ <!--
+ The following options identifies a perl script that is launched
+ at startup and may live forever in the background.
+ You can define multiple lines, one for each script you
+ need to run.
+ -->
+<!-- <param name="startup-script" value="/root/test_perl.pl"/> -->
+ <!--param name="startup-script" value="startup_script_2.pl"/-->
+
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/pocketsphinx.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/pocketsphinx.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/pocketsphinx.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,10 @@
+<configuration name="pocketsphinx.conf" description="PocketSphinx ASR Configuration">
+ <settings>
+ <param name="threshold" value="400"/>
+ <param name="silence-hits" value="25"/>
+ <param name="listen-hits" value="1"/>
+ <param name="auto-reload" value="true"/>
+ <!--<param name="narrowband-model" value="communicator"/>-->
+ <!--<param name="wideband-model" value="wsj1"/>-->
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/portaudio.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/portaudio.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/portaudio.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,33 @@
+<configuration name="portaudio.conf" description="Soundcard Endpoint">
+ <settings>
+ <!-- indev, outdev, ringdev:
+ partial case sensitive string match on something in the name
+ or the device number prefixed with # eg "#1" (or blank for default) -->
+
+ <!-- device to use for input -->
+ <param name="indev" value=""/>
+ <!-- device to use for output -->
+ <param name="outdev" value=""/>
+
+ <!--device to use for inbound ring -->
+ <!--<param name="ringdev" value=""/>-->
+ <!--File to play as the ring sound -->
+ <!--<param name="ring-file" value="/sounds/ring.wav"/>-->
+ <!--Number of seconds to pause between rings -->
+ <!--<param name="ring-interval" value="5"/>-->
+
+ <!--file to play when calls are on hold-->
+ <!--<param name="hold-file" value="/sounds/holdmusic.wav"/>-->
+ <!--Timer to use for hold music (i'd leave this one commented)-->
+ <!--<param name="timer-name" value="soft"/>-->
+
+ <!--Default dialplan and caller-id info -->
+ <param name="dialplan" value="XML"/>
+ <param name="cid-name" value="FreeSwitch"/>
+ <param name="cid-num" value="5555551212"/>
+
+ <!--audio sample rate and interval -->
+ <param name="sample-rate" value="8000"/>
+ <param name="codec-ms" value="20"/>
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/post_load_modules.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/post_load_modules.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/post_load_modules.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,4 @@
+<configuration name="post_load_modules.conf" description="Modules">
+ <modules>
+ </modules>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/python.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/python.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/python.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,16 @@
+<configuration name="python.conf" description="PYTHON Configuration">
+ <settings>
+ <!--<param name="xml-handler-script" value="dp"/>-->
+ <!--<param name="xml-handler-bindings" value="dialplan"/>-->
+
+ <!--
+ The following options identifies a py script that is launched
+ at startup and may live forever in the background.
+ You can define multiple lines, one for each script you
+ need to run.
+ -->
+ <!--<param name="startup-script" value="startup_script_1.py"/>-->
+ <!--<param name="startup-script" value="startup_script_2.py"/>-->
+
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/rss.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/rss.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/rss.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,7 @@
+<configuration name="rss.conf" description="RSS Parser">
+ <feeds>
+ <!-- Just download the files to wherever and refer to them here -->
+ <!-- <feed name="Slash Dot">/home/rss/rss.rss</feed> -->
+ <!-- <feed name="News Forge">/home/rss/newsforge.rss</feed> -->
+ </feeds>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/sofia.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/sofia.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/sofia.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,9 @@
+<configuration name="sofia.conf" description="sofia Endpoint">
+ <global_settings>
+ <param name="log-level" value="0"/>
+ </global_settings>
+
+ <profiles>
+ <X-PRE-PROCESS cmd="include" data="../sip_profiles/*.xml"/>
+ </profiles>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/spidermonkey.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/spidermonkey.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/spidermonkey.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,8 @@
+<configuration name="spidermonkey.conf" description="Spider Monkey JavaScript Plug-Ins">
+ <modules>
+ <load module="mod_spidermonkey_teletone"/>
+ <load module="mod_spidermonkey_core_db"/>
+ <load module="mod_spidermonkey_socket"/>
+ <!--<load module="mod_spidermonkey_odbc"/>-->
+ </modules>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/switch.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/switch.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/switch.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,66 @@
+<configuration name="switch.conf" description="Core Configuration">
+
+ <cli-keybindings>
+ <key name="1" value="help"/>
+ <key name="2" value="status"/>
+ <key name="3" value="show channels"/>
+ <key name="4" value="show calls"/>
+ <key name="5" value="sofia status"/>
+ <key name="6" value="reloadxml"/>
+ <key name="7" value="console loglevel 0"/>
+ <key name="8" value="console loglevel 7"/>
+ <key name="9" value="sofia status profile internal"/>
+ <key name="10" value="fsctl pause"/>
+ <key name="11" value="fsctl resume"/>
+ <key name="12" value="version"/>
+ </cli-keybindings>
+
+ <settings>
+ <!--Colorize the Console -->
+ <param name="colorize-console" value="true"/>
+ <!--Most channels to allow at once -->
+ <param name="max-sessions" value="1000"/>
+ <!--Most channels to create per second -->
+ <param name="sessions-per-second" value="30"/>
+ <!-- Default Global Log Level - value is one of debug,info,notice,warning,err,crit,alert -->
+ <param name="loglevel" value="debug"/>
+ <!--Try to catch any crashes that can be recoverable (in the context of a call)-->
+ <param name="crash-protection" value="false"/>
+ <!--<param name="max_dtmf_duration" value="192000"/>-->
+ <!--<param name="default_dtmf_duration" value="8000"/>-->
+ <!--
+ If you want to send out voicemail notifications via Windows you'll need to change the mailer-app
+ variable to the setting below:
+
+ <param name="mailer-app" value="msmtp"/>
+
+ Donot change mailer-app-args.
+ You will also need to download a sendmail clone for Windows (msmtp). This version works without issue:
+ http://msmtp.sourceforge.net/index.html. Download and copy the .exe to %winddir%\system32.
+ You'll need to create a small config file for smtp credentials (host name, authentication, tls, etc.) in
+ %USERPROFILE%\Application Data\ called "msmtprc.txt". Below is a sample copy of this file:
+
+ ###################################
+ # The SMTP server of the provider.
+ account provider
+ host smtp.myisp.com
+ from jo...@my...
+ auth login
+ user johndoe
+ password mypassword
+
+ # Set a default account
+ account default : provider
+ ###################################
+
+ -->
+ <param name="mailer-app" value="sendmail"/>
+ <param name="mailer-app-args" value="-t"/>
+ <param name="dump-cores" value="yes"/>
+ <!--RTP port range -->
+ <!--<param name="rtp-start-port" value="16384"/>-->
+ <!--<param name="rtp-end-port" value="32768"/>-->
+ </settings>
+
+</configuration>
+
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/syslog.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/syslog.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/syslog.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,15 @@
+<configuration name="syslog.conf" description="Syslog Logger">
+ <!-- SYSLOG -->
+ <!-- emerg - system is unusable -->
+ <!-- alert - action must be taken immediately -->
+ <!-- crit - critical conditions -->
+ <!-- err - error conditions -->
+ <!-- warning - warning conditions -->
+ <!-- notice - normal, but significant, condition -->
+ <!-- info - informational message -->
+ <!-- debug - debug-level message -->
+ <settings>
+ <param name="ident" value="freeswitch"/>
+ <param name="loglevel" value="warning"/>
+ </settings>
+</configuration>
Added: trunk/freeswitch/contrib/darren/conf/autoload_configs/timezones.conf.xml
===================================================================
--- trunk/freeswitch/contrib/darren/conf/autoload_configs/timezones.conf.xml (rev 0)
+++ trunk/freeswitch/contrib/darren/conf/autoload_configs/timezones.conf.xml 2009-01-31 18:53:47 UTC (rev 2224)
@@ -0,0 +1,551 @@
+<configuration name="timezones.conf" description="Timezones">
+ <timezones>
+ <zone name="Africa/Abidjan" value="GMT0" />
+ <zone name="Africa/Accra" value="GMT0" />
+ <zone name="Africa/Addis_Ababa" value="EAT-3" />
+ <zone name="Africa/Algiers" value="CET-1" />
+ <zone name="Africa/Asmara" value="EAT-3" />
+ <zone name="Africa/Asmera" value="EAT-3" />
+ <zone name="Africa/Bamako" value="GMT0" />
+ <zone name="Africa/Bangui" value="WAT-1" />
+ <zone name="Africa/Banjul" value="GMT0" />
+ <zone name="Africa/Bissau" value="GMT0" />
+ <zone name="Africa/Blantyre" value="CAT-2" />
+ <zone name="Africa/Brazzaville" value="WAT-1" />
+ <zone name="Africa/Bujumbura" value="CAT-2" />
+ <zone name="Africa/Cairo" value="EEST" />
+ <zone name="Africa/Casablanca" value="WET0" />
+ <zone name="Africa/Ceuta" value="CET-1CEST,M3.5.0,M10.5.0/3" />
+ <zone name="Africa/Conakry" value="GMT0" />
+ <zone name="Africa/Dakar" value="GMT0" />
+ <zone name="Africa/Dar_es_Salaam" value="EAT-3" />
+ <zone name="Africa/Djibouti" value="EAT-3" />
+ <zone name="Africa/Douala" value="WAT-1" />
+ <zone name="Africa/El_Aaiun" value="WET0" />
+ <zone name="Africa/Freetown" value="GMT0" />
+ <zone name="Africa/Gaborone" value="CAT-2" />
+ <zone name="Africa/Harare" value="CAT-2" />
+ <zone name="Africa/Johannesburg" value="SAST-2" />
+ <zone name="Africa/Kampala" value="EAT-3" />
+ <zone name="Africa/Khartoum" value="EAT-3" />
+ <zone name="Africa/Kigali" value="CAT-2" />
+ <zone name="Africa/Kinshasa" value="WAT-1" />
+ <zone name="Africa/Lagos" value="WAT-1" />
+ <zone name="Africa/Libreville" value="WAT-1" />
+ <zone name="Africa/Lome" value="GMT0" />
+ <zone name="Africa/Luanda" value="WAT-1" />
+ <zone name="Africa/Lubumbashi" value="CAT-2" />
+ <zone name="Africa/Lusaka" value="CAT-2" />
+ <zone name="Africa/Malabo" value="WAT-1" />
+ <zone name="Africa/Maputo" value="CAT-2" />
+ <zone name="Africa/Maseru" value="SAST-2" />
+ <zone name="Africa/Mbabane" value="SAST-2" />
+ <zone name="Africa/Mogadishu" value="EAT-3" />
+ <zone name="Africa/Monrovia" value="GMT0" />
+ <zone name="Africa/Nairobi" value="EAT-3" />
+ <zone name="Africa/Ndjamena" value="WAT-1" />
+ <zone name="Africa/Niamey" value="WAT-1" />
+ <zone name="Africa/Nouakchott" value="GMT0" />
+ <zone name="Africa/Ouagadougou" value="GMT0" />
+ <zone name="Africa/Porto-Novo" value="WAT-1" />
+ <zone name="Africa/Sao_Tome" value="GMT0" />
+ <zone name="Africa/Timbuktu" value="GMT0" />
+ <zone name="Africa/Tripoli" value="EET-2" />
+ <zone name="Africa/Tunis" value="CET-1CEST,M3.5.0,M10.5.0/3" />
+ <zone name="Africa/Windhoek" value="WAT-1WAST,M9.1.0,M4.1.0" />
+
+ <zone name="America/Adak" value="HAST10HADT,M3.2.0,M11.1.0" />
+ <zone name="America/Anchorage" value="AKST9AKDT,M3.2.0,M11.1.0" />
+ <zone name="America/Anguilla" value="AST4" />
+ <zone name="America/Antigua" value="AST4" />
+ <zone name="America/Araguaina" value="BRT3" />
+ <zone name="America/Argentina/Buenos_Aires" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/Catamarca" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/ComodRivadavia" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/Cordoba" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/Jujuy" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/La_Rioja" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/Mendoza" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/Rio_Gallegos" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/San_Juan" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/San_Luis" value="ART3" />
+ <zone name="America/Argentina/Tucuman" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Argentina/Ushuaia" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Aruba" value="AST4" />
+ <zone name="America/Asuncion" value="PYT4PYST,M10.3.0/0,M3.2.0/0" />
+ <zone name="America/Atikokan" value="EST5" />
+ <zone name="America/Atka" value="HAST10HADT,M3.2.0,M11.1.0" />
+ <zone name="America/Bahia" value="BRT3" />
+ <zone name="America/Barbados" value="AST4" />
+ <zone name="America/Belem" value="BRT3" />
+ <zone name="America/Belize" value="CST6" />
+ <zone name="America/Blanc-Sablon" value="AST4" />
+ <zone name="America/Boa_Vista" value="AMT4" />
+ <zone name="America/Bogota" value="COT5" />
+ <zone name="America/Boise" value="MST7MDT,M3.2.0,M11.1.0" />
+ <zone name="America/Buenos_Aires" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Cambridge_Bay" value="MST7MDT,M3.2.0,M11.1.0" />
+ <zone name="America/Campo_Grande" value="AMT4AMST,M10.2.0/0,M2.3.0/0" />
+ <zone name="America/Cancun" value="CST6CDT,M4.1.0,M10.5.0" />
+ <zone name="America/Caracas" value="VET4:30" />
+ <zone name="America/Catamarca" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Cayenne" value="GFT3" />
+ <zone name="America/Cayman" value="EST5" />
+ <zone name="America/Chicago" value="CST6CDT,M3.2.0,M11.1.0" />
+ <zone name="America/Chihuahua" value="MST7MDT,M4.1.0,M10.5.0" />
+ <zone name="America/Coral_Harbour" value="EST5" />
+ <zone name="America/Cordoba" value="ART3ARST,M10.1.0/0,M3.3.0/0" />
+ <zone name="America/Costa_Rica" value="CST6" />
+ <zone name="America/Cuiaba" value="AMT4AMST,M10.2.0/0,M2.3.0/0" />
+ <zone name="America/Curacao" value="AST4" />
+ <zone name="America/Danmarkshavn" value="GMT0" />
+ <zone name="America/Dawson" value="PST8PDT,M3.2.0,M11.1.0" />
+ <zone name="America/Dawson_Creek" value="MST7" />
+ <zone name="America/Denver" value="MST7MDT,M3.2.0,M11.1.0" />
+ <zone name="America/Detroit" value="EST5EDT,M3.2.0,M11.1.0" />
+ <zone name="America/Dominica" value="AST4" />
+ <zone name="America/Edmonton" value="MST7MDT,M3.2.0,M11.1.0" />
+ <zone name="America/Eirunepe" value="ACT5" />
+ <zone name="America/El_Salvador" value="CST6" />
+ <zone name="America/Ensenada" value="PST8PDT,M4.1.0,M10.5.0" />
+ <zone name="America/Fortaleza" value="B...
[truncated message content] |
|
From: <dar...@us...> - 2010-09-01 01:25:20
|
Revision: 2314
http://astpp.svn.sourceforge.net/astpp/?rev=2314&view=rev
Author: darrenkw
Date: 2010-09-01 01:25:12 +0000 (Wed, 01 Sep 2010)
Log Message:
-----------
added sql for Freeswitch support
Added Paths:
-----------
trunk/freeswitch/contrib/README
trunk/freeswitch/contrib/mysql-4.0.sql
trunk/freeswitch/contrib/mysql-5.0.sql
Added: trunk/freeswitch/contrib/README
===================================================================
--- trunk/freeswitch/contrib/README (rev 0)
+++ trunk/freeswitch/contrib/README 2010-09-01 01:25:12 UTC (rev 2314)
@@ -0,0 +1,2 @@
+The SQL files are copied out of the contrib directory in the freeswitch source code. They
+were contributed there by intralanman.
Added: trunk/freeswitch/contrib/mysql-4.0.sql
===================================================================
--- trunk/freeswitch/contrib/mysql-4.0.sql (rev 0)
+++ trunk/freeswitch/contrib/mysql-4.0.sql 2010-09-01 01:25:12 UTC (rev 2314)
@@ -0,0 +1,885 @@
+-- phpMyAdmin SQL Dump
+-- version 3.1.2deb1
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Feb 15, 2009 at 09:36 PM
+-- Server version: 5.0.75
+-- PHP Version: 5.2.6-3ubuntu2
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Database: `freeswitch`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `acl_lists`
+--
+
+CREATE TABLE IF NOT EXISTS `acl_lists` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `acl_name` varchar(128) NOT NULL,
+ `default_policy` varchar(45) NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `acl_lists`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `acl_nodes`
+--
+
+CREATE TABLE IF NOT EXISTS `acl_nodes` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `cidr` varchar(45) NOT NULL,
+ `type` varchar(16) NOT NULL,
+ `list_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `acl_nodes`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `conference_advertise`
+--
+
+CREATE TABLE IF NOT EXISTS `conference_advertise` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `room` varchar(64) NOT NULL,
+ `status` varchar(128) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_room` (`room`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `conference_advertise`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `conference_controls`
+--
+
+CREATE TABLE IF NOT EXISTS `conference_controls` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `conf_group` varchar(64) NOT NULL,
+ `action` varchar(64) NOT NULL,
+ `digits` varchar(16) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_group_action` (`conf_group`,`action`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `conference_controls`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `conference_profiles`
+--
+
+CREATE TABLE IF NOT EXISTS `conference_profiles` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `profile_name` varchar(64) NOT NULL,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `unique_profile_param` (`profile_name`,`param_name`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `conference_profiles`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan` (
+ `dialplan_id` int(11) NOT NULL auto_increment,
+ `domain` varchar(128) NOT NULL,
+ `ip_address` varchar(15) NOT NULL,
+ PRIMARY KEY (`dialplan_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_actions`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_actions` (
+ `action_id` int(11) NOT NULL auto_increment,
+ `condition_id` int(11) NOT NULL,
+ `application` varchar(256) NOT NULL,
+ `data` varchar(256) NOT NULL,
+ `type` varchar(32) NOT NULL,
+ `weight` int(11) NOT NULL,
+ PRIMARY KEY (`action_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_actions`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_condition`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_condition` (
+ `condition_id` int(11) NOT NULL auto_increment,
+ `extension_id` int(11) NOT NULL,
+ `field` varchar(1238) NOT NULL,
+ `expression` varchar(128) NOT NULL,
+ `weight` int(11) NOT NULL,
+ PRIMARY KEY (`condition_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_condition`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_context`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_context` (
+ `context_id` int(11) NOT NULL auto_increment,
+ `dialplan_id` int(11) NOT NULL,
+ `context` varchar(64) NOT NULL,
+ `weight` int(11) NOT NULL,
+ PRIMARY KEY (`context_id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_context`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_extension`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_extension` (
+ `extension_id` int(11) NOT NULL auto_increment,
+ `context_id` int(11) NOT NULL,
+ `name` varchar(128) NOT NULL,
+ `continue` varchar(32) NOT NULL,
+ `weight` int(11) NOT NULL,
+ PRIMARY KEY (`extension_id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_extension`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_special`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_special` (
+ `id` int(11) NOT NULL auto_increment,
+ `context` varchar(255) NOT NULL,
+ `class_file` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_context` (`context`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_special`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dingaling_profiles`
+--
+
+CREATE TABLE IF NOT EXISTS `dingaling_profiles` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `profile_name` varchar(64) NOT NULL,
+ `type` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_name` (`profile_name`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dingaling_profiles`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dingaling_profile_params`
+--
+
+CREATE TABLE IF NOT EXISTS `dingaling_profile_params` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `dingaling_id` int(10) unsigned NOT NULL,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_type_name` (`dingaling_id`,`param_name`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dingaling_profile_params`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dingaling_settings`
+--
+
+CREATE TABLE IF NOT EXISTS `dingaling_settings` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_param` (`param_name`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dingaling_settings`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory`
+--
+
+CREATE TABLE IF NOT EXISTS `directory` (
+ `id` int(11) NOT NULL auto_increment,
+ `username` varchar(255) NOT NULL,
+ `domain` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_domains`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_domains` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `domain_name` varchar(128) NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_domains`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_gateways`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_gateways` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `directory_id` int(10) unsigned NOT NULL,
+ `gateway_name` varchar(128) NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_gateways`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_gateway_params`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_gateway_params` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `d_gw_id` int(10) unsigned NOT NULL,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_gw_param` (`d_gw_id`,`param_name`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_gateway_params`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_global_params`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_global_params` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(128) NOT NULL,
+ `domain_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_global_params`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_global_vars`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_global_vars` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `var_name` varchar(64) NOT NULL,
+ `var_value` varchar(128) NOT NULL,
+ `domain_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_global_vars`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_params`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_params` (
+ `id` int(11) NOT NULL auto_increment,
+ `directory_id` int(11) default NULL,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_params`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_vars`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_vars` (
+ `id` int(11) NOT NULL auto_increment,
+ `directory_id` int(11) default NULL,
+ `var_name` varchar(255) default NULL,
+ `var_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_vars`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `iax_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `iax_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `profile_name` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `iax_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `iax_settings`
+--
+
+CREATE TABLE IF NOT EXISTS `iax_settings` (
+ `id` int(11) NOT NULL auto_increment,
+ `iax_id` int(11) default NULL,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `iax_settings`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ivr_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `ivr_conf` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `name` varchar(64) NOT NULL,
+ `greet_long` varchar(255) NOT NULL,
+ `greet_short` varchar(255) NOT NULL,
+ `invalid_sound` varchar(255) NOT NULL,
+ `exit_sound` varchar(255) NOT NULL,
+ `max_failures` int(10) unsigned NOT NULL default '3',
+ `timeout` int(11) NOT NULL default '5',
+ `tts_engine` varchar(64) default NULL,
+ `tts_voice` varchar(64) default NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_name` (`name`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `ivr_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ivr_entries`
+--
+
+CREATE TABLE IF NOT EXISTS `ivr_entries` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `ivr_id` int(10) unsigned NOT NULL,
+ `action` varchar(64) NOT NULL,
+ `digits` varchar(16) NOT NULL,
+ `params` varchar(255) default NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_ivr_digits` (`ivr_id`,`digits`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `ivr_entries`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `limit_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `limit_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `name` varchar(255) default NULL,
+ `value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `limit_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `limit_data`
+--
+
+CREATE TABLE IF NOT EXISTS `limit_data` (
+ `hostname` varchar(255) default NULL,
+ `realm` varchar(255) default NULL,
+ `id` varchar(255) default NULL,
+ `uuid` varchar(255) default NULL
+) TYPE=MyISAM;
+
+--
+-- Dumping data for table `limit_data`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `local_stream_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `local_stream_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `directory_name` varchar(255) default NULL,
+ `directory_path` text,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `local_stream_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `modless_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `modless_conf` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `conf_name` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `modless_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `post_load_modules_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `post_load_modules_conf` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `module_name` varchar(64) NOT NULL,
+ `load_module` tinyint(1) NOT NULL default '1',
+ `priority` int(10) unsigned NOT NULL default '1000',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_mod` (`module_name`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `post_load_modules_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `rss_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `rss_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `directory_id` int(11) NOT NULL,
+ `feed` text NOT NULL,
+ `local_file` text NOT NULL,
+ `description` text,
+ `priority` int(11) NOT NULL default '1000',
+ PRIMARY KEY (`id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `rss_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sip_authentication`
+--
+
+CREATE TABLE IF NOT EXISTS `sip_authentication` (
+ `nonce` varchar(255) default NULL,
+ `expires` int(11) default NULL
+) TYPE=InnoDB;
+
+--
+-- Dumping data for table `sip_authentication`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sip_dialogs`
+--
+
+CREATE TABLE IF NOT EXISTS `sip_dialogs` (
+ `call_id` varchar(255) default NULL,
+ `uuid` varchar(255) default NULL,
+ `sip_to_user` varchar(255) default NULL,
+ `sip_to_host` varchar(255) default NULL,
+ `sip_from_user` varchar(255) default NULL,
+ `sip_from_host` varchar(255) default NULL,
+ `contact_user` varchar(255) default NULL,
+ `contact_host` varchar(255) default NULL,
+ `state` varchar(255) default NULL,
+ `direction` varchar(255) default NULL,
+ `user_agent` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Dumping data for table `sip_dialogs`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sip_registrations`
+--
+
+CREATE TABLE IF NOT EXISTS `sip_registrations` (
+ `call_id` varchar(255) default NULL,
+ `sip_user` varchar(255) default NULL,
+ `sip_host` varchar(255) default NULL,
+ `contact` varchar(1024) default NULL,
+ `status` varchar(255) default NULL,
+ `rpid` varchar(255) default NULL,
+ `expires` int(11) default NULL,
+ `user_agent` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Dumping data for table `sip_registrations`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sip_subscriptions`
+--
+
+CREATE TABLE IF NOT EXISTS `sip_subscriptions` (
+ `proto` varchar(255) default NULL,
+ `sip_user` varchar(255) default NULL,
+ `sip_host` varchar(255) default NULL,
+ `sub_to_user` varchar(255) default NULL,
+ `sub_to_host` varchar(255) default NULL,
+ `event` varchar(255) default NULL,
+ `contact` varchar(1024) default NULL,
+ `call_id` varchar(255) default NULL,
+ `full_from` varchar(255) default NULL,
+ `full_via` varchar(255) default NULL,
+ `expires` int(11) default NULL,
+ `user_agent` varchar(255) default NULL,
+ `accept` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Dumping data for table `sip_subscriptions`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_aliases`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_aliases` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `sofia_id` int(10) unsigned NOT NULL,
+ `alias_name` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_aliases`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `profile_name` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_domains`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_domains` (
+ `id` int(11) NOT NULL auto_increment,
+ `sofia_id` int(11) default NULL,
+ `domain_name` varchar(255) default NULL,
+ `parse` tinyint(1) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_domains`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_gateways`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_gateways` (
+ `id` int(11) NOT NULL auto_increment,
+ `sofia_id` int(11) default NULL,
+ `gateway_name` varchar(255) default NULL,
+ `gateway_param` varchar(255) default NULL,
+ `gateway_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_gateways`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_settings`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_settings` (
+ `id` int(11) NOT NULL auto_increment,
+ `sofia_id` int(11) default NULL,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_settings`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `voicemail_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `voicemail_conf` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `vm_profile` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_profile` (`vm_profile`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `voicemail_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `voicemail_email`
+--
+
+CREATE TABLE IF NOT EXISTS `voicemail_email` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `voicemail_id` int(10) unsigned NOT NULL,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_profile_param` (`param_name`,`voicemail_id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `voicemail_email`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `voicemail_settings`
+--
+
+CREATE TABLE IF NOT EXISTS `voicemail_settings` (
+ `id` int(11) NOT NULL auto_increment,
+ `voicemail_id` int(11) default NULL,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `voicemail_settings`
+--
+
+
+--
+-- Constraints for dumped tables
+--
+
+--
+-- Constraints for table `dingaling_profile_params`
+--
+ALTER TABLE `dingaling_profile_params`
+ ADD CONSTRAINT `dingaling_profile` FOREIGN KEY (`dingaling_id`) REFERENCES `dingaling_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Added: trunk/freeswitch/contrib/mysql-5.0.sql
===================================================================
--- trunk/freeswitch/contrib/mysql-5.0.sql (rev 0)
+++ trunk/freeswitch/contrib/mysql-5.0.sql 2010-09-01 01:25:12 UTC (rev 2314)
@@ -0,0 +1,887 @@
+-- phpMyAdmin SQL Dump
+-- version 3.1.2deb1
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Feb 15, 2009 at 09:36 PM
+-- Server version: 5.0.75
+-- PHP Version: 5.2.6-3ubuntu2
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Database: `freeswitch`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `acl_lists`
+--
+
+CREATE TABLE IF NOT EXISTS `acl_lists` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `acl_name` varchar(128) NOT NULL,
+ `default_policy` varchar(45) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `acl_lists`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `acl_nodes`
+--
+
+CREATE TABLE IF NOT EXISTS `acl_nodes` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `cidr` varchar(45) NOT NULL,
+ `type` varchar(16) NOT NULL,
+ `list_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `acl_nodes`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `conference_advertise`
+--
+
+CREATE TABLE IF NOT EXISTS `conference_advertise` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `room` varchar(64) NOT NULL,
+ `status` varchar(128) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_room` (`room`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `conference_advertise`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `conference_controls`
+--
+
+CREATE TABLE IF NOT EXISTS `conference_controls` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `conf_group` varchar(64) NOT NULL,
+ `action` varchar(64) NOT NULL,
+ `digits` varchar(16) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_group_action` USING BTREE (`conf_group`,`action`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `conference_controls`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `conference_profiles`
+--
+
+CREATE TABLE IF NOT EXISTS `conference_profiles` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `profile_name` varchar(64) NOT NULL,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `unique_profile_param` (`profile_name`,`param_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `conference_profiles`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan` (
+ `dialplan_id` int(11) NOT NULL auto_increment,
+ `domain` varchar(128) NOT NULL,
+ `ip_address` varchar(15) NOT NULL,
+ PRIMARY KEY (`dialplan_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_actions`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_actions` (
+ `action_id` int(11) NOT NULL auto_increment,
+ `condition_id` int(11) NOT NULL,
+ `application` varchar(256) NOT NULL,
+ `data` varchar(256) NOT NULL,
+ `type` varchar(32) NOT NULL,
+ `weight` int(11) NOT NULL,
+ PRIMARY KEY (`action_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_actions`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_condition`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_condition` (
+ `condition_id` int(11) NOT NULL auto_increment,
+ `extension_id` int(11) NOT NULL,
+ `field` varchar(1238) NOT NULL,
+ `expression` varchar(128) NOT NULL,
+ `weight` int(11) NOT NULL,
+ PRIMARY KEY (`condition_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_condition`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_context`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_context` (
+ `context_id` int(11) NOT NULL auto_increment,
+ `dialplan_id` int(11) NOT NULL,
+ `context` varchar(64) NOT NULL,
+ `weight` int(11) NOT NULL,
+ PRIMARY KEY (`context_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_context`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_extension`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_extension` (
+ `extension_id` int(11) NOT NULL auto_increment,
+ `context_id` int(11) NOT NULL,
+ `name` varchar(128) NOT NULL,
+ `continue` varchar(32) NOT NULL,
+ `weight` int(11) NOT NULL,
+ PRIMARY KEY (`extension_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_extension`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dialplan_special`
+--
+
+CREATE TABLE IF NOT EXISTS `dialplan_special` (
+ `id` int(11) NOT NULL auto_increment,
+ `context` varchar(255) NOT NULL,
+ `class_file` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_context` (`context`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dialplan_special`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dingaling_profiles`
+--
+
+CREATE TABLE IF NOT EXISTS `dingaling_profiles` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `profile_name` varchar(64) NOT NULL,
+ `type` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_name` (`profile_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dingaling_profiles`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dingaling_profile_params`
+--
+
+CREATE TABLE IF NOT EXISTS `dingaling_profile_params` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `dingaling_id` int(10) unsigned NOT NULL,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_type_name` (`dingaling_id`,`param_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dingaling_profile_params`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dingaling_settings`
+--
+
+CREATE TABLE IF NOT EXISTS `dingaling_settings` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_param` (`param_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `dingaling_settings`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory`
+--
+
+CREATE TABLE IF NOT EXISTS `directory` (
+ `id` int(11) NOT NULL auto_increment,
+ `username` varchar(255) NOT NULL,
+ `domain` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_domains`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_domains` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `domain_name` varchar(128) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_domains`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_gateways`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_gateways` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `directory_id` int(10) unsigned NOT NULL,
+ `gateway_name` varchar(128) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_gateways`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_gateway_params`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_gateway_params` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `d_gw_id` int(10) unsigned NOT NULL,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_gw_param` (`d_gw_id`,`param_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_gateway_params`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_global_params`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_global_params` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(128) NOT NULL,
+ `domain_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_global_params`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_global_vars`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_global_vars` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `var_name` varchar(64) NOT NULL,
+ `var_value` varchar(128) NOT NULL,
+ `domain_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_global_vars`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_params`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_params` (
+ `id` int(11) NOT NULL auto_increment,
+ `directory_id` int(11) default NULL,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_params`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `directory_vars`
+--
+
+CREATE TABLE IF NOT EXISTS `directory_vars` (
+ `id` int(11) NOT NULL auto_increment,
+ `directory_id` int(11) default NULL,
+ `var_name` varchar(255) default NULL,
+ `var_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `directory_vars`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `iax_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `iax_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `profile_name` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `iax_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `iax_settings`
+--
+
+CREATE TABLE IF NOT EXISTS `iax_settings` (
+ `id` int(11) NOT NULL auto_increment,
+ `iax_id` int(11) default NULL,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `iax_settings`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ivr_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `ivr_conf` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `name` varchar(64) NOT NULL,
+ `greet_long` varchar(255) NOT NULL,
+ `greet_short` varchar(255) NOT NULL,
+ `invalid_sound` varchar(255) NOT NULL,
+ `exit_sound` varchar(255) NOT NULL,
+ `max_failures` int(10) unsigned NOT NULL default '3',
+ `timeout` int(11) NOT NULL default '5',
+ `tts_engine` varchar(64) default NULL,
+ `tts_voice` varchar(64) default NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_name` (`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `ivr_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ivr_entries`
+--
+
+CREATE TABLE IF NOT EXISTS `ivr_entries` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `ivr_id` int(10) unsigned NOT NULL,
+ `action` varchar(64) NOT NULL,
+ `digits` varchar(16) NOT NULL,
+ `params` varchar(255) default NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_ivr_digits` USING BTREE (`ivr_id`,`digits`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `ivr_entries`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `limit_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `limit_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `name` varchar(255) default NULL,
+ `value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `limit_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `limit_data`
+--
+
+CREATE TABLE IF NOT EXISTS `limit_data` (
+ `hostname` varchar(255) default NULL,
+ `realm` varchar(255) default NULL,
+ `id` varchar(255) default NULL,
+ `uuid` varchar(255) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `limit_data`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `local_stream_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `local_stream_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `directory_name` varchar(255) default NULL,
+ `directory_path` text,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `local_stream_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `modless_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `modless_conf` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `conf_name` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `modless_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `post_load_modules_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `post_load_modules_conf` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `module_name` varchar(64) NOT NULL,
+ `load_module` tinyint(1) NOT NULL default '1',
+ `priority` int(10) unsigned NOT NULL default '1000',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_mod` (`module_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `post_load_modules_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `rss_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `rss_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `directory_id` int(11) NOT NULL,
+ `feed` text NOT NULL,
+ `local_file` text NOT NULL,
+ `description` text,
+ `priority` int(11) NOT NULL default '1000',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `rss_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sip_authentication`
+--
+
+CREATE TABLE IF NOT EXISTS `sip_authentication` (
+ `nonce` varchar(255) default NULL,
+ `expires` int(11) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `sip_authentication`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sip_dialogs`
+--
+
+CREATE TABLE IF NOT EXISTS `sip_dialogs` (
+ `call_id` varchar(255) default NULL,
+ `uuid` varchar(255) default NULL,
+ `sip_to_user` varchar(255) default NULL,
+ `sip_to_host` varchar(255) default NULL,
+ `sip_from_user` varchar(255) default NULL,
+ `sip_from_host` varchar(255) default NULL,
+ `contact_user` varchar(255) default NULL,
+ `contact_host` varchar(255) default NULL,
+ `state` varchar(255) default NULL,
+ `direction` varchar(255) default NULL,
+ `user_agent` varchar(255) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `sip_dialogs`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sip_registrations`
+--
+
+CREATE TABLE IF NOT EXISTS `sip_registrations` (
+ `call_id` varchar(255) default NULL,
+ `sip_user` varchar(255) default NULL,
+ `sip_host` varchar(255) default NULL,
+ `contact` varchar(1024) default NULL,
+ `status` varchar(255) default NULL,
+ `rpid` varchar(255) default NULL,
+ `expires` int(11) default NULL,
+ `user_agent` varchar(255) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `sip_registrations`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sip_subscriptions`
+--
+
+CREATE TABLE IF NOT EXISTS `sip_subscriptions` (
+ `proto` varchar(255) default NULL,
+ `sip_user` varchar(255) default NULL,
+ `sip_host` varchar(255) default NULL,
+ `sub_to_user` varchar(255) default NULL,
+ `sub_to_host` varchar(255) default NULL,
+ `event` varchar(255) default NULL,
+ `contact` varchar(1024) default NULL,
+ `call_id` varchar(255) default NULL,
+ `full_from` varchar(255) default NULL,
+ `full_via` varchar(255) default NULL,
+ `expires` int(11) default NULL,
+ `user_agent` varchar(255) default NULL,
+ `accept` varchar(255) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `sip_subscriptions`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_aliases`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_aliases` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `sofia_id` int(10) unsigned NOT NULL,
+ `alias_name` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_aliases`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_conf` (
+ `id` int(11) NOT NULL auto_increment,
+ `profile_name` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_domains`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_domains` (
+ `id` int(11) NOT NULL auto_increment,
+ `sofia_id` int(11) default NULL,
+ `domain_name` varchar(255) default NULL,
+ `parse` tinyint(1) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_domains`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_gateways`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_gateways` (
+ `id` int(11) NOT NULL auto_increment,
+ `sofia_id` int(11) default NULL,
+ `gateway_name` varchar(255) default NULL,
+ `gateway_param` varchar(255) default NULL,
+ `gateway_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_gateways`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sofia_settings`
+--
+
+CREATE TABLE IF NOT EXISTS `sofia_settings` (
+ `id` int(11) NOT NULL auto_increment,
+ `sofia_id` int(11) default NULL,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `sofia_settings`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `voicemail_conf`
+--
+
+CREATE TABLE IF NOT EXISTS `voicemail_conf` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `vm_profile` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_profile` (`vm_profile`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `voicemail_conf`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `voicemail_email`
+--
+
+CREATE TABLE IF NOT EXISTS `voicemail_email` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `voicemail_id` int(10) unsigned NOT NULL,
+ `param_name` varchar(64) NOT NULL,
+ `param_value` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_profile_param` (`param_name`,`voicemail_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `voicemail_email`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `voicemail_settings`
+--
+
+CREATE TABLE IF NOT EXISTS `voicemail_settings` (
+ `id` int(11) NOT NULL auto_increment,
+ `voicemail_id` int(11) default NULL,
+ `param_name` varchar(255) default NULL,
+ `param_value` varchar(255) default NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `voicemail_settings`
+--
+
+
+--
+-- Constraints for dumped tables
+--
+
+--
+-- Constraints for table `dingaling_profile_params`
+--
+ALTER TABLE `dingaling_profile_params`
+ ADD CONSTRAINT `dingaling_profile` FOREIGN KEY (`dingaling_id`) REFERENCES `dingaling_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X