April 2008 - Freeswitch-trunk - FreeSWITCH Mailing Lists

[commit] r8089 - in freeswitch/trunk/src/mod: applications/mod_fifo endpoints/mod_sofia
by Freeswitch SVN 11 Apr '08

11 Apr '08

Author: anthm Date: Fri Apr 11 15:41:24 2008 New Revision: 8089 Modified: freeswitch/trunk/src/mod/applications/mod_fifo/mod_fifo.c freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c Log: tweak parking bug Modified: freeswitch/trunk/src/mod/applications/mod_fifo/mod_fifo.c ============================================================================== --- freeswitch/trunk/src/mod/applications/mod_fifo/mod_fifo.c (original) +++ freeswitch/trunk/src/mod/applications/mod_fifo/mod_fifo.c Fri Apr 11 15:41:24 2008 @@ -329,9 +329,7 @@ node = create_node(node_name, 0); } - switch_mutex_lock(node->mutex); send_presence(node); - switch_mutex_unlock(node->mutex); switch_mutex_unlock(globals.mutex); @@ -498,8 +496,9 @@ switch_mutex_lock(node->mutex); node->caller_count++; - send_presence(node); + switch_core_hash_insert(node->caller_hash, uuid, session); + if ((pri = switch_channel_get_variable(channel, "fifo_priority"))) { p = atoi(pri); @@ -545,6 +544,8 @@ cd.next = switch_timestamp(NULL) + cd.freq; } + send_presence(node); + while(switch_channel_ready(channel)) { switch_input_args_t args = { 0 }; char buf[25] = ""; @@ -566,7 +567,9 @@ if ((serviced_uuid = switch_channel_get_variable(channel, "fifo_serviced_uuid"))) { break; } - + + switch_core_session_flush_private_events(session); + if (moh) { switch_ivr_play_file(session, NULL, moh, &args); } else { @@ -592,6 +595,7 @@ } } + switch_core_session_flush_private_events(session); if (switch_channel_ready(channel)) { if (announce) { @@ -621,9 +625,10 @@ switch_mutex_lock(node->mutex); node_remove_uuid(node, uuid); node->caller_count--; - send_presence(node); switch_core_hash_delete(node->caller_hash, uuid); switch_mutex_unlock(node->mutex); + send_presence(node); + } if (cd.do_orbit && cd.orbit_exten) { @@ -847,6 +852,7 @@ switch_channel_set_variable(other_channel, "fifo_serviced_by", my_id); switch_channel_set_variable(other_channel, "fifo_serviced_uuid", switch_core_session_get_uuid(session)); + switch_channel_set_flag(other_channel, CF_BREAK); while (switch_channel_ready(channel) && switch_channel_ready(other_channel) && switch_channel_test_flag(other_channel, CF_TAGGED)) { @@ -883,9 +889,9 @@ switch_channel_set_variable(other_channel, "fifo_status", "TALKING"); switch_channel_set_variable(other_channel, "fifo_timestamp", date); switch_channel_set_variable(other_channel, "fifo_target", switch_core_session_get_uuid(session)); - switch_mutex_lock(node->mutex); + send_presence(node); - switch_mutex_unlock(node->mutex); + if (record_template) { expanded = switch_channel_expand_variables(other_channel, record_template); @@ -912,10 +918,12 @@ switch_mutex_lock(node->mutex); node->caller_count--; - send_presence(node); switch_core_hash_delete(node->caller_hash, uuid); switch_mutex_unlock(node->mutex); + send_presence(node); switch_core_session_rwunlock(other_session); + + if (!do_wait) { done = 1; } Modified: freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c ============================================================================== --- freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c (original) +++ freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c Fri Apr 11 15:41:24 2008 @@ -46,6 +46,7 @@ sofia_profile_t *profile; switch_event_t *event; switch_stream_handle_t stream; + char last_uuid[512]; }; switch_status_t sofia_presence_chat_send(char *proto, char *from, char *to, char *subject, char *body, char *hint) @@ -472,6 +473,7 @@ if (!switch_strlen_zero((char *)helper.stream.data)) { char *this = (char *)helper.stream.data; char *next = NULL; + char *last = NULL; do { if ((next = strchr(this, ';'))) { @@ -481,8 +483,9 @@ } } - if (!switch_strlen_zero(this)) { + if (!switch_strlen_zero(this) && (!last || strcmp(last, this))) { sofia_glue_execute_sql(profile, &this, SWITCH_FALSE); + last = this; } this = next; } while (this); @@ -934,8 +937,10 @@ ct = "application/dialog-info+xml"; } - if (!switch_strlen_zero(astate) && !switch_strlen_zero(uuid) && helper && helper->stream.data) { - helper->stream.write_function(&helper->stream, "update sip_dialogs set state='%s' where uuid='%s';\n", astate, uuid); + if (!switch_strlen_zero(astate) && !switch_strlen_zero(uuid) && helper && helper->stream.data && strcmp(helper->last_uuid, uuid)) { + helper->stream.write_function(&helper->stream, "update sip_dialogs set state='%s' where uuid='%s';", astate, uuid); + + switch_copy_string(helper->last_uuid, uuid, sizeof(helper->last_uuid)); }

1 0

[commit] r8088 - freeswitch/trunk/src/mod/endpoints/mod_sofia
by Freeswitch SVN 11 Apr '08

11 Apr '08

Author: anthm Date: Fri Apr 11 13:07:06 2008 New Revision: 8088 Modified: freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c Log: fix ODBC issue Modified: freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c ============================================================================== --- freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c (original) +++ freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c Fri Apr 11 13:07:06 2008 @@ -469,12 +469,25 @@ sofia_presence_sub_callback, &helper); - if (switch_strlen_zero((char *)helper.stream.data)) { - switch_safe_free(helper.stream.data); - } else { - char *ssql = (char *)helper.stream.data; - sofia_glue_execute_sql(profile, &ssql, SWITCH_TRUE); + if (!switch_strlen_zero((char *)helper.stream.data)) { + char *this = (char *)helper.stream.data; + char *next = NULL; + + do { + if ((next = strchr(this, ';'))) { + *next++ = '\0'; + while(*next == '\n' || *next == ' ' || *next == '\r') { + *next++ = '\0'; + } + } + + if (!switch_strlen_zero(this)) { + sofia_glue_execute_sql(profile, &this, SWITCH_FALSE); + } + this = next; + } while (this); } + switch_safe_free(helper.stream.data); helper.stream.data = NULL; } }

1 0

[commit] r8087 - freeswitch/trunk/src
by Freeswitch SVN 11 Apr '08

11 Apr '08

Author: anthm Date: Fri Apr 11 11:53:25 2008 New Revision: 8087 Modified: freeswitch/trunk/src/switch_channel.c freeswitch/trunk/src/switch_event.c Log: small fix Modified: freeswitch/trunk/src/switch_channel.c ============================================================================== --- freeswitch/trunk/src/switch_channel.c (original) +++ freeswitch/trunk/src/switch_channel.c Fri Apr 11 11:53:25 2008 @@ -1581,11 +1581,6 @@ break; } - if (*(p-1) == '\\') { - q = p + 1; - continue; - } - if (*(p+1) != '{') { q = p + 1; continue; @@ -1599,6 +1594,7 @@ return (char *)in; } + nv = 0; olen = strlen(in) + 1; indup = strdup(in); Modified: freeswitch/trunk/src/switch_event.c ============================================================================== --- freeswitch/trunk/src/switch_event.c (original) +++ freeswitch/trunk/src/switch_event.c Fri Apr 11 11:53:25 2008 @@ -1044,11 +1044,6 @@ break; } - if (*(p-1) == '\\') { - q = p + 1; - continue; - } - if (*(p+1) != '{') { q = p + 1; continue;

1 0

[commit] r8086 - in freeswitch/trunk/scripts/socket: . FreeSWITCH
by Freeswitch SVN 10 Apr '08

10 Apr '08

Author: mikej Date: Thu Apr 10 16:42:15 2008 New Revision: 8086 Modified: freeswitch/trunk/scripts/socket/FreeSWITCH/Client.pm freeswitch/trunk/scripts/socket/sock.pl Log: revert unintentional commit Modified: freeswitch/trunk/scripts/socket/FreeSWITCH/Client.pm ============================================================================== --- freeswitch/trunk/scripts/socket/FreeSWITCH/Client.pm (original) +++ freeswitch/trunk/scripts/socket/FreeSWITCH/Client.pm Thu Apr 10 16:42:15 2008 @@ -10,7 +10,6 @@ my $proto = shift; my $args = shift; my $class = ref($proto) || $proto; - $self->{_host} = $args->{-host} || "localhost"; $self->{_port} = $args->{-port} || 8021; $self->{_password} = $args->{-password} || undef; @@ -18,14 +17,10 @@ $self->{events} = []; my $me = bless $self,$class; - - - if (!$self->{_password}) { return $me; } if ($me->connect()) { - print Dumper $me; return $me; } else { return undef; Modified: freeswitch/trunk/scripts/socket/sock.pl ============================================================================== --- freeswitch/trunk/scripts/socket/sock.pl (original) +++ freeswitch/trunk/scripts/socket/sock.pl Thu Apr 10 16:42:15 2008 @@ -36,15 +36,6 @@ if ($r->{has_event}) { print Dumper $r->{event}; } - if ($r->{event}->{'event-name'} !~ /dtmf/i) { - $o = $fs->call_command("park"); - - print "Got DTMF $r->{event}->{'dtmf-digit'}\n"; - push @digits, $r->{event}->{'dtmf-digit'}; - print "Dialed: " . join("", @digits) . "\n"; - next; - } - if ($r->{event}->{'event-name'} !~ /execute/i) { printf "uuid: $data->{'unique-id'}\n"; $o = $fs->call_command("break");

1 0

[commit] r8085 - freeswitch/trunk/conf/autoload_configs
by Freeswitch SVN 10 Apr '08

10 Apr '08

Author: brian Date: Thu Apr 10 16:35:10 2008 New Revision: 8085 Modified: freeswitch/trunk/conf/autoload_configs/enum.conf.xml Log: tweak config Modified: freeswitch/trunk/conf/autoload_configs/enum.conf.xml ============================================================================== --- freeswitch/trunk/conf/autoload_configs/enum.conf.xml (original) +++ freeswitch/trunk/conf/autoload_configs/enum.conf.xml Thu Apr 10 16:35:10 2008 @@ -3,6 +3,7 @@ <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>

1 0

[commit] r8084 - in freeswitch/trunk: scripts/socket scripts/socket/FreeSWITCH src/mod/applications/mod_enum
by Freeswitch SVN 10 Apr '08

10 Apr '08

Author: anthm Date: Thu Apr 10 16:26:15 2008 New Revision: 8084 Modified: freeswitch/trunk/scripts/socket/FreeSWITCH/Client.pm freeswitch/trunk/scripts/socket/sock.pl freeswitch/trunk/src/mod/applications/mod_enum/mod_enum.c Log: fix MODAPP-85 Modified: freeswitch/trunk/scripts/socket/FreeSWITCH/Client.pm ============================================================================== --- freeswitch/trunk/scripts/socket/FreeSWITCH/Client.pm (original) +++ freeswitch/trunk/scripts/socket/FreeSWITCH/Client.pm Thu Apr 10 16:26:15 2008 @@ -10,6 +10,7 @@ my $proto = shift; my $args = shift; my $class = ref($proto) || $proto; + $self->{_host} = $args->{-host} || "localhost"; $self->{_port} = $args->{-port} || 8021; $self->{_password} = $args->{-password} || undef; @@ -17,10 +18,14 @@ $self->{events} = []; my $me = bless $self,$class; + + + if (!$self->{_password}) { return $me; } if ($me->connect()) { + print Dumper $me; return $me; } else { return undef; Modified: freeswitch/trunk/scripts/socket/sock.pl ============================================================================== --- freeswitch/trunk/scripts/socket/sock.pl (original) +++ freeswitch/trunk/scripts/socket/sock.pl Thu Apr 10 16:26:15 2008 @@ -36,6 +36,15 @@ if ($r->{has_event}) { print Dumper $r->{event}; } + if ($r->{event}->{'event-name'} !~ /dtmf/i) { + $o = $fs->call_command("park"); + + print "Got DTMF $r->{event}->{'dtmf-digit'}\n"; + push @digits, $r->{event}->{'dtmf-digit'}; + print "Dialed: " . join("", @digits) . "\n"; + next; + } + if ($r->{event}->{'event-name'} !~ /execute/i) { printf "uuid: $data->{'unique-id'}\n"; $o = $fs->call_command("break"); Modified: freeswitch/trunk/src/mod/applications/mod_enum/mod_enum.c ============================================================================== --- freeswitch/trunk/src/mod/applications/mod_enum/mod_enum.c (original) +++ freeswitch/trunk/src/mod/applications/mod_enum/mod_enum.c Thu Apr 10 16:26:15 2008 @@ -40,11 +40,15 @@ SWITCH_MODULE_SHUTDOWN_FUNCTION(mod_enum_shutdown); SWITCH_MODULE_DEFINITION(mod_enum, mod_enum_load, mod_enum_shutdown, NULL); +static switch_mutex_t *MUTEX = NULL; + + struct enum_record { int order; int preference; char *service; char *route; + int supported; struct enum_record *next; }; typedef struct enum_record enum_record_t; @@ -72,9 +76,9 @@ static struct { char *root; char *isn_root; - switch_hash_t *routes; enum_route_t *route_order; switch_memory_pool_t *pool; + int auto_reload; int timeout; } globals; @@ -85,26 +89,21 @@ { enum_route_t *route, *rp; - if (!(route = malloc(sizeof(*route)))) { - return; - } + route = switch_core_alloc(globals.pool, sizeof(*route)); - memset(route, 0, sizeof(*route)); route->service = strdup(service); route->regex = strdup(regex); route->replace = strdup(replace); + switch_mutex_lock(MUTEX); if (!globals.route_order) { globals.route_order = route; } else { for (rp = globals.route_order; rp && rp->next; rp = rp->next); rp->next = route; } - - if (!(rp = switch_core_hash_find(globals.routes, service))) { - switch_core_hash_insert(globals.routes, route->service, route); - } + switch_mutex_unlock(MUTEX); } @@ -114,8 +113,6 @@ switch_xml_t cfg, xml = NULL, param, settings, route, routes; switch_status_t status = SWITCH_STATUS_SUCCESS; - switch_core_hash_init(&globals.routes, globals.pool); - if (!(xml = switch_xml_open_cfg(cf, &cfg, NULL))) { switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "open of %s failed\n", cf); status = SWITCH_STATUS_FALSE; @@ -128,6 +125,8 @@ char *val = (char *) switch_xml_attr_soft(param, "value"); if (!strcasecmp(var, "default-root")) { set_global_root(val); + } else if (!strcasecmp(var, "auto-reload")) { + globals.auto_reload = switch_true(val); } else if (!strcasecmp(var, "query-timeout")) { globals.timeout = atoi(val); } else if (!strcasecmp(var, "default-isn-root")) { @@ -210,20 +209,19 @@ } -static void add_result(enum_query_t * q, int order, int preference, char *service, char *route) +static void add_result(enum_query_t * q, int order, int preference, char *service, char *route, int supported) { enum_record_t *new_result, *rp, *prev = NULL; - if (!(new_result = malloc(sizeof(*new_result)))) { - return; - } - + new_result = malloc(sizeof(*new_result)); + switch_assert(new_result); memset(new_result, 0, sizeof(*new_result)); new_result->order = order; new_result->preference = preference; new_result->service = strdup(service); new_result->route = strdup(route); + new_result->supported = supported; if (!q->results) { q->results = new_result; @@ -347,7 +345,7 @@ char rbuf[1024] = ""; char *uri; enum_route_t *route; - + int supported = 0; switch_regex_safe_free(re); if ((proceed = switch_regex_perform(q->number, regex, &re, ovector, sizeof(ovector) / sizeof(ovector[0])))) { @@ -358,7 +356,11 @@ uri = replace; } - if ((route = (enum_route_t *) switch_core_hash_find(globals.routes, service))) { + switch_mutex_lock(MUTEX); + for(route = globals.route_order; route; route = route->next) { + if (strcasecmp(service, route->service)) { + continue; + } switch_regex_safe_free(re); if ((proceed = switch_regex_perform(uri, route->regex, &re, ovector, sizeof(ovector) / sizeof(ovector[0])))) { if (strchr(route->regex, '(')) { @@ -367,11 +369,17 @@ } else { uri = route->replace; } + supported++; + add_result(q, order, preference, service, uri, supported); } } - - add_result(q, order, preference, service, uri); - } + + if (!supported) { + add_result(q, order, preference, service, uri, 0); + } + } + switch_mutex_unlock(MUTEX); + switch_regex_safe_free(re); } @@ -563,7 +571,6 @@ switch_caller_extension_t *extension = NULL; enum_record_t *results, *rp; switch_channel_t *channel = switch_core_session_get_channel(session); - enum_route_t *rtp; char *dp = (char *) arg; if (!caller_profile) { @@ -580,13 +587,15 @@ } switch_channel_set_variable(channel, SWITCH_HANGUP_AFTER_BRIDGE_VARIABLE, "true"); - for (rtp = globals.route_order; rtp; rtp = rtp->next) { - for (rp = results; rp; rp = rp->next) { - if (!strcasecmp(rtp->service, rp->service)) { - switch_caller_extension_add_application(session, extension, "bridge", rp->route); - } + + for (rp = results; rp; rp = rp->next) { + if (!rp->supported) { + continue; } + + switch_caller_extension_add_application(session, extension, "bridge", rp->route); } + free_results(&results); } @@ -602,7 +611,6 @@ char *mydata = NULL; char *dest = NULL, *root = NULL; enum_record_t *results, *rp; - enum_route_t *rtp; char rbuf[1024] = ""; char vbuf[1024] = ""; char *rbp = rbuf; @@ -631,24 +639,24 @@ switch_channel_variable_last(channel); } - for (rtp = globals.route_order; rtp; rtp = rtp->next) { - for (rp = results; rp; rp = rp->next) { - if (!strcasecmp(rtp->service, rp->service)) { - switch_snprintf(vbuf, sizeof(vbuf), "enum_route_%d", cnt++); - switch_channel_set_variable(channel, vbuf, rp->route); - if (rp->preference == last_pref && rp->order == last_order) { - *last_delim = ','; - } - switch_snprintf(rbp, rbl, "%s|", rp->route); - last_delim = end_of_p(rbp); - last_order = rp->order; - last_pref = rp->preference; - l = strlen(rp->route) + 1; - rbp += l; - rbl -= l; - } + for (rp = results; rp; rp = rp->next) { + if (!rp->supported) { + continue; } + switch_snprintf(vbuf, sizeof(vbuf), "enum_route_%d", cnt++); + switch_channel_set_variable(channel, vbuf, rp->route); + if (rp->preference == last_pref && rp->order == last_order) { + *last_delim = ','; + } + switch_snprintf(rbp, rbl, "%s|", rp->route); + last_delim = end_of_p(rbp); + last_order = rp->order; + last_pref = rp->preference; + l = strlen(rp->route) + 1; + rbp += l; + rbl -= l; } + switch_snprintf(vbuf, sizeof(vbuf), "%d", cnt); switch_channel_set_variable(channel, "enum_route_count", vbuf); *(rbuf + strlen(rbuf) - 1) = '\0'; @@ -667,7 +675,6 @@ char *mydata = NULL; char *dest = NULL, *root = NULL; enum_record_t *results, *rp; - enum_route_t *rtp; char rbuf[1024] = ""; char *rbp = rbuf; switch_size_t l = 0, rbl = sizeof(rbuf); @@ -688,21 +695,21 @@ dest = argv[0]; root = argv[1]; if (enum_lookup(root, dest, &results) == SWITCH_STATUS_SUCCESS) { - for (rtp = globals.route_order; rtp; rtp = rtp->next) { - for (rp = results; rp; rp = rp->next) { - if (!strcasecmp(rtp->service, rp->service)) { - if (rp->preference == last_pref && rp->order == last_order) { - *last_delim = ','; - } - switch_snprintf(rbp, rbl, "%s|", rp->route); - last_delim = end_of_p(rbp); - last_order = rp->order; - last_pref = rp->preference; - l = strlen(rp->route) + 1; - rbp += l; - rbl -= l; - } + for (rp = results; rp; rp = rp->next) { + if (!rp->supported) { + continue; } + if (rp->preference == last_pref && rp->order == last_order) { + *last_delim = ','; + } + switch_snprintf(rbp, rbl, "%s|", rp->route); + last_delim = end_of_p(rbp); + last_order = rp->order; + last_pref = rp->preference; + l = strlen(rp->route) + 1; + rbp += l; + rbl -= l; + } *(rbuf + strlen(rbuf) - 1) = '\0'; stream->write_function(stream, "%s", rbuf); @@ -721,6 +728,24 @@ } +static void do_load(void) +{ + switch_mutex_lock(MUTEX); + if (globals.pool) { + switch_core_destroy_memory_pool(&globals.pool); + } + + memset(&globals, 0, sizeof(globals)); + switch_core_new_memory_pool(&globals.pool); + globals.timeout = 10; + load_config(); + switch_mutex_unlock(MUTEX); + switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_INFO, "ENUM Reloaded\n"); + +} + + + SWITCH_STANDARD_API(enum_function) { int argc = 0; @@ -728,7 +753,6 @@ enum_record_t *results, *rp; char *mydata = NULL; char *dest = NULL, *root = NULL; - enum_route_t *rtp; if (session) { switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "This function cannot be called from the dialplan.\n"); @@ -736,13 +760,20 @@ } if (!cmd || !(mydata = strdup(cmd))) { - stream->write_function(stream, "Usage: enum <number> [<root>]\n"); + stream->write_function(stream, "Usage: enum [reload | <number> [<root>] ]\n"); return SWITCH_STATUS_SUCCESS; } if ((argc = switch_separate_string(mydata, ' ', argv, (sizeof(argv) / sizeof(argv[0]))))) { dest = argv[0]; root = argv[1]; + + if (!strcasecmp(dest, "reload")) { + do_load(); + stream->write_function(stream, "+OK ENUM Reloaded.\n"); + return SWITCH_STATUS_SUCCESS; + + } if (!enum_lookup(root, dest, &results) == SWITCH_STATUS_SUCCESS) { stream->write_function(stream, "No Match!\n"); @@ -762,11 +793,10 @@ "\nSupported Routes:\n" "Order\tPref\tService \tRoute\n" "==============================================================================\n"); - for (rtp = globals.route_order; rtp; rtp = rtp->next) { - for (rp = results; rp; rp = rp->next) { - if (!strcasecmp(rtp->service, rp->service)) { - stream->write_function(stream, "%d\t%d\t%-10s\t%s\n", rp->order, rp->preference, rp->service, rp->route); - } + + for (rp = results; rp; rp = rp->next) { + if (rp->supported) { + stream->write_function(stream, "%d\t%d\t%-10s\t%s\n", rp->order, rp->preference, rp->service, rp->route); } } @@ -779,20 +809,34 @@ } +static void event_handler(switch_event_t *event) +{ + if (globals.auto_reload) { + do_load(); + } +} + SWITCH_MODULE_LOAD_FUNCTION(mod_enum_load) { switch_api_interface_t *api_interface; switch_application_interface_t *app_interface; switch_dialplan_interface_t *dp_interface; + + switch_mutex_init(&MUTEX, SWITCH_MUTEX_NESTED, pool); + if (dns_init(0) < 0) { return SWITCH_STATUS_FALSE; } memset(&globals, 0, sizeof(globals)); - globals.pool = pool; - globals.timeout = 10; - load_config(); + do_load(); + + + if (switch_event_bind(modname, SWITCH_EVENT_RELOADXML, NULL, event_handler, NULL) != SWITCH_STATUS_SUCCESS) { + switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "Couldn't bind!\n"); + return SWITCH_STATUS_TERM; + } /* connect my internal structure to the blank pointer passed to me */ *module_interface = switch_loadable_module_create_module_interface(pool, modname); @@ -801,13 +845,18 @@ SWITCH_ADD_APP(app_interface, "enum", "Perform an ENUM lookup", "Perform an ENUM lookup", enum_app_function, "<number> [<root>]", SAF_SUPPORT_NOMEDIA); SWITCH_ADD_DIALPLAN(dp_interface, "enum", enum_dialplan_hunt); + /* indicate that the module should continue to be loaded */ return SWITCH_STATUS_SUCCESS; } SWITCH_MODULE_SHUTDOWN_FUNCTION(mod_enum_shutdown) { - switch_core_hash_destroy(&globals.routes); + + if (globals.pool) { + switch_core_destroy_memory_pool(&globals.pool); + } + return SWITCH_STATUS_SUCCESS; }

1 0

[commit] r8083 - freeswitch/trunk/src/mod/applications/mod_enum
by Freeswitch SVN 10 Apr '08

10 Apr '08

Author: anthm Date: Thu Apr 10 11:42:13 2008 New Revision: 8083 Modified: freeswitch/trunk/src/mod/applications/mod_enum/mod_enum.c Log: fix seg in new function Modified: freeswitch/trunk/src/mod/applications/mod_enum/mod_enum.c ============================================================================== --- freeswitch/trunk/src/mod/applications/mod_enum/mod_enum.c (original) +++ freeswitch/trunk/src/mod/applications/mod_enum/mod_enum.c Thu Apr 10 11:42:13 2008 @@ -673,6 +673,12 @@ switch_size_t l = 0, rbl = sizeof(rbuf); int last_order = -1, last_pref = -2; char *last_delim = "|"; + int ok = 0; + + if (switch_strlen_zero(cmd)) { + stream->write_function(stream, "%s", "none"); + return SWITCH_STATUS_SUCCESS; + } if (!(mydata = strdup(cmd))) { abort(); @@ -701,11 +707,16 @@ *(rbuf + strlen(rbuf) - 1) = '\0'; stream->write_function(stream, "%s", rbuf); free_results(&results); + ok++; } } switch_safe_free(mydata); + if (!ok) { + stream->write_function(stream, "%s", "none"); + } + return SWITCH_STATUS_SUCCESS; }

1 0

[commit] r8082 - freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql
by Freeswitch SVN 10 Apr '08

10 Apr '08

Author: intralanman Date: Thu Apr 10 11:33:38 2008 New Revision: 8082 Added: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0-with-samples.sql Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0.sql freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0-with-samples.sql freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0.sql Log: Adding changes for the specialized dialplan thing i added last night. Added: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0-with-samples.sql ============================================================================== --- (empty file) +++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0-with-samples.sql Thu Apr 10 11:33:38 2008 @@ -0,0 +1,1079 @@ +-- MySQL dump 10.11 +-- +-- Host: localhost Database: freeswitch +-- ------------------------------------------------------ +-- Server version 5.0.32-Debian_7etch5-log + +/*!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 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `carrier_gateway` +-- + +DROP TABLE IF EXISTS `carrier_gateway`; +CREATE TABLE `carrier_gateway` ( + `id` int(11) NOT NULL auto_increment, + `carrier_id` int(11) default NULL, + `gateway` varchar(32) default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `gateway` (`gateway`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `carrier_gateway` +-- + +LOCK TABLES `carrier_gateway` WRITE; +/*!40000 ALTER TABLE `carrier_gateway` DISABLE KEYS */; +INSERT INTO `carrier_gateway` VALUES (1,1,'GX1783b'),(2,2,'L3285032k1'),(3,1,'GX2946h'),(4,2,'L3973865l2'); +/*!40000 ALTER TABLE `carrier_gateway` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `carriers` +-- + +DROP TABLE IF EXISTS `carriers`; +CREATE TABLE `carriers` ( + `id` int(11) NOT NULL auto_increment, + `Carrier_Name` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `carriers` +-- + +LOCK TABLES `carriers` WRITE; +/*!40000 ALTER TABLE `carriers` DISABLE KEYS */; +INSERT INTO `carriers` VALUES (1,'Global Crossing'),(2,'Level 3 Communications'); +/*!40000 ALTER TABLE `carriers` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `conference_advertise` +-- + +DROP TABLE IF EXISTS `conference_advertise`; +CREATE TABLE `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; + +-- +-- Dumping data for table `conference_advertise` +-- + +LOCK TABLES `conference_advertise` WRITE; +/*!40000 ALTER TABLE `conference_advertise` DISABLE KEYS */; +INSERT INTO `conference_advertise` VALUES (1,'3000@$${domain}','Freeswitch Conference'),(2,'3001@$${domain}','FreeSWITCH Conference 2'),(3,'3002@$${domain}','FreeSWITCH Conference 3'); +/*!40000 ALTER TABLE `conference_advertise` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `conference_controls` +-- + +DROP TABLE IF EXISTS `conference_controls`; +CREATE TABLE `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; + +-- +-- Dumping data for table `conference_controls` +-- + +LOCK TABLES `conference_controls` WRITE; +/*!40000 ALTER TABLE `conference_controls` DISABLE KEYS */; +INSERT INTO `conference_controls` VALUES (1,'default','mute','0'),(2,'default','deaf_mute','*'),(3,'default','energy up','9'),(4,'default','energy equ','8'),(5,'default','energy dn','7'),(6,'default','vol talk up','3'),(7,'default','vol talk dn','1'),(8,'default','vol talk zero','2'),(9,'default','vol listen up','6'),(10,'default','vol listen dn','4'),(11,'default','vol listen zero','5'),(12,'default','hangup','#'); +/*!40000 ALTER TABLE `conference_controls` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `conference_profiles` +-- + +DROP TABLE IF EXISTS `conference_profiles`; +CREATE TABLE `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; + +-- +-- Dumping data for table `conference_profiles` +-- + +LOCK TABLES `conference_profiles` WRITE; +/*!40000 ALTER TABLE `conference_profiles` DISABLE KEYS */; +INSERT INTO `conference_profiles` VALUES (1,'default','domain','$${domain}'),(2,'default','rate','8000'),(3,'default','interval','20'),(4,'default','energy-level','300'),(5,'default','moh-sound','$${moh_uri}'),(6,'default','caller-id-name','$${outbound_caller_name}'),(7,'default','caller-id-number','$${outbound_caller_number}'); +/*!40000 ALTER TABLE `conference_profiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `db_data` +-- + +DROP TABLE IF EXISTS `db_data`; +CREATE TABLE `db_data` ( + `hostname` varchar(255) default NULL, + `realm` varchar(255) default NULL, + `data_key` varchar(255) default NULL, + `data` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `db_data` +-- + +LOCK TABLES `db_data` WRITE; +/*!40000 ALTER TABLE `db_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `db_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dialplan` +-- + +DROP TABLE IF EXISTS `dialplan`; +CREATE TABLE `dialplan` ( + `id` int(11) NOT NULL auto_increment, + `context` varchar(64) NOT NULL, + `extension` varchar(64) NOT NULL, + `condition_field` varchar(64) NOT NULL, + `condition_expression` varchar(64) NOT NULL, + `application_name` varchar(64) NOT NULL, + `application_data` text, + `weight` int(11) NOT NULL, + `type` varchar(16) NOT NULL default 'action', + `ext_continue` smallint(1) NOT NULL default '0', + `global_weight` int(11) NOT NULL default '10000', + `cond_break` varchar(8) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `dialplan` +-- + +LOCK TABLES `dialplan` WRITE; +/*!40000 ALTER TABLE `dialplan` DISABLE KEYS */; +INSERT INTO `dialplan` VALUES (113,'public','public_extensions','destination_number','^(10[01][0-9])$','transfer','$1 XML default',1,'action',0,200,''),(114,'public','public_did','destination_number','^(5551212)$','transfer','$1 XML default',1,'action',0,300,''),(271,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','set','continue_on_fail=true',1,'action',0,200,''),(272,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','set','hangup_after_bridge=true',2,'action',0,200,''),(273,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','enum','1$1',3,'action',0,200,''),(274,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','bridge','${enum_auto_route}',4,'action',0,200,''),(275,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','bridge','sofia/gateway/${default_gateway}/011$1',5,'action',0,200,''),(276,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','set','continue_on_fail=true',1,'action',0,300,''),(277,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','set','hangup_after_bridge=true',2,'action',0,300,''),(278,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','enum','1$1',3,'action',0,300,''),(279,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','bridge','${enum_auto_route}',4,'action',0,300,''),(280,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','bridge','sofia/gateway/${default_gateway}/1$1',5,'action',0,300,''),(281,'US-Numbering-Plan','US_Local','${default_area_code}','\\d{3}','say','you must dial the area code to call this destination',1,'anti-action',0,400,'on-true'),(282,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','set','continue_on_fail=true',1,'action',0,400,''),(283,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','set','hangup_after_bridge=true',2,'action',0,400,''),(284,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','enum','1$1',3,'action',0,400,''),(285,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','bridge','${enum_auto_route}',4,'action',0,400,''),(286,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','bridge','sofia/gateway/${default_gateway}/1${default_area_code}$1',5,'action',0,400,''),(287,'US-Numbering-Plan','FCC_Services','^([4689]11)$','','bridge','sofia/gateway/${default_gateway}/$1',1,'action',0,500,''),(333,'default','intercept','destination_number','^886$','answer','',1,'action',0,200,''),(334,'default','intercept','destination_number','^886$','intercept','${db(select/last_dial/global)}',2,'action',0,200,''),(335,'default','intercept','destination_number','^886$','sleep','2000',3,'action',0,200,''),(336,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','answer','',1,'action',0,300,''),(337,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','intercept','${db(select/last_dial_ext/$1)}',2,'action',0,300,''),(338,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','sleep','2000',3,'action',0,300,''),(339,'default','redial','destination_number','^870$','transfer','${db(select/last_dial/${caller_id_number})}',1,'action',0,400,''),(340,'default','global','${network_addr}','','set','use_profile=${cond(${is_lan_addr($${local_ip_v4})} == yes ? nat : default)}',1,'action',1,500,''),(341,'default','global','${network_addr}','','set','use_profile=${cond(${is_lan_addr(${network_addr})} == yes ? nat : default)}',2,'anti-action',1,500,''),(342,'default','global','${numbering_plan}','','set_user','default@${domain}',1,'action',1,500,''),(343,'default','global','','','info','',1,'action',1,500,''),(344,'default','global','','','db','insert/spymap/${caller_id_number}/${uuid}',2,'action',1,500,''),(345,'default','global','','','db','insert/last_dial/${caller_id_number}/${destination_number}',3,'action',1,500,''),(346,'default','global','','','db','insert/last_dial/global/${uuid}',4,'action',1,500,''),(347,'default','eavesdrop','destination_number','^88(.*)$|^\\*0(.*)$','answer','',1,'action',0,600,''),(348,'default','eavesdrop','destination_number','^88(.*)$|^\\*0(.*)$','eavesdrop','${db(select/spymap/$1)}',2,'action',0,600,''),(349,'default','call_return','destination_number','^\\*69$|^869$','transfer','${db(select/call_return/${caller_id_number})}',1,'action',0,700,''),(350,'default','del-group','destination_number','^80(\\d{2})$','answer','',1,'action',0,800,''),(351,'default','del-group','destination_number','^80(\\d{2})$','group','delete:$1:${sofia_contact(${sip_from_user}@${domain})}',2,'action',0,800,''),(352,'default','del-group','destination_number','^80(\\d{2})$','gentones','%(1000, 0, 320)',3,'action',0,800,''),(353,'default','add-group','destination_number','^81(\\d{2})$','answer','',1,'action',0,900,''),(354,'default','add-group','destination_number','^81(\\d{2})$','group','insert:$1:${sofia_contact(${sip_from_user}@${domain})}',2,'action',0,900,''),(355,'default','add-group','destination_number','^81(\\d{2})$','gentones','%(1000, 0, 640)',3,'action',0,900,''),(356,'default','call-group-simo','destination_number','^82(\\d{2})$','bridge','${group(call:$1)}',1,'action',0,1000,''),(357,'default','call-group-order','destination_number','^83(\\d{2})$','set','call_timeout=10',1,'action',0,1100,''),(358,'default','call-group-order','destination_number','^83(\\d{2})$','bridge','${group(call:$1:order)}',2,'action',0,1100,''),(359,'default','Local_Extension','destination_number','^(10[01][0-9])$','set','dialed_ext=$1',1,'action',0,1200,'on-true'),(360,'default','Local_Extension','destination_number','^${caller_id_number}$','set','voicemail_authorized=${sip_authorized}',1,'action',0,1200,''),(361,'default','Local_Extension','destination_number','^${caller_id_number}$','answer','',2,'action',0,1200,''),(362,'default','Local_Extension','destination_number','^${caller_id_number}$','sleep','1000',3,'action',0,1200,''),(363,'default','Local_Extension','destination_number','^${caller_id_number}$','voicemail','check default $${domain} ${dialed_ext}',4,'action',0,1200,''),(364,'default','Local_Extension','destination_number','^${caller_id_number}$','ring_ready','',5,'anti-action',0,1200,''),(365,'default','Local_Extension','destination_number','^${caller_id_number}$','set','call_timeout=130',6,'anti-action',0,1200,''),(366,'default','Local_Extension','destination_number','^${caller_id_number}$','set','hangup_after_bridge=true',7,'anti-action',0,1200,''),(367,'default','Local_Extension','destination_number','^${caller_id_number}$','set','left_hanging_extension=5900',8,'anti-action',0,1200,''),(368,'default','Local_Extension','destination_number','^${caller_id_number}$','set','continue_on_fail=true',9,'anti-action',0,1200,''),(369,'default','Local_Extension','destination_number','^${caller_id_number}$','db','insert/call_return/${dialed_ext}/${caller_id_number}',10,'anti-action',0,1200,''),(370,'default','Local_Extension','destination_number','^${caller_id_number}$','db','insert/last_dial_ext/${dialed_ext}/${uuid}',11,'anti-action',0,1200,''),(371,'default','Local_Extension','destination_number','^${caller_id_number}$','bridge','{left_hanging_extension=5900,transfer_fallback_extension=${dialed_ext}}USER/${dialed_ext}@$${domain}',12,'anti-action',0,1200,''),(372,'default','Local_Extension','destination_number','^${caller_id_number}$','answer','',13,'anti-action',0,1200,''),(373,'default','Local_Extension','destination_number','^${caller_id_number}$','sleep','1000',14,'anti-action',0,1200,''),(374,'default','Local_Extension','destination_number','^${caller_id_number}$','voicemail','default $${domain} ${dialed_ext}',15,'anti-action',0,1200,''),(375,'default','sip_uri','destination_number','^sip:(.*)$','bridge','sofia/${use_profile}/$1',1,'action',0,1300,''),(376,'default','conferences','destination_number','^(3\\d{3})$','conference','$1@default',1,'action',0,1400,''),(377,'default','freeswitch_public_conf_via_sip','destination_number','^9(888|1616)$','bridge','sofia/${use_profile}/$1(a)conference.freeswitch.org',1,'action',0,1500,''),(378,'default','ivr_demo','destination_number','5000','ivr','demo',1,'action',0,1600,''),(379,'default','park','destination_number','^(590[0-9])$','fifo','$1@$${domain} in undef $${moh_uri}',1,'action',0,1700,''),(380,'default','unpark','destination_number','^\\*{0,2}park\\+(590[0-9])$','answer','',1,'action',0,1800,''),(381,'default','unpark','destination_number','^\\*{0,2}park\\+(590[0-9])$','fifo','$1@$${domain} out nowait',2,'action',0,1800,''),(382,'default','hold_music','destination_number','^9999$','answer','',1,'action',0,1900,''),(383,'default','hold_music','destination_number','^9999$','playback','$${moh_uri}',2,'action',0,1900,''),(384,'default','enum','destination_number','^(.*)$','transfer','$1 enum',1,'action',0,2000,''); +/*!40000 ALTER TABLE `dialplan` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dialplan_special` +-- + +DROP TABLE IF EXISTS `dialplan_special`; +CREATE TABLE `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; + +-- +-- Dumping data for table `dialplan_special` +-- + +LOCK TABLES `dialplan_special` WRITE; +/*!40000 ALTER TABLE `dialplan_special` DISABLE KEYS */; +INSERT INTO `dialplan_special` VALUES (1,'lcr','dialplans/lcr.php'),(2,'lcr2','some/php/file.php'); +/*!40000 ALTER TABLE `dialplan_special` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dingaling_profile_params` +-- + +DROP TABLE IF EXISTS `dingaling_profile_params`; +CREATE TABLE `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`), + CONSTRAINT `dingaling_profile` FOREIGN KEY (`dingaling_id`) REFERENCES `dingaling_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `dingaling_profile_params` +-- + +LOCK TABLES `dingaling_profile_params` WRITE; +/*!40000 ALTER TABLE `dingaling_profile_params` DISABLE KEYS */; +INSERT INTO `dingaling_profile_params` VALUES (1,1,'password','secret'),(2,1,'dialplan','XML,enum'),(3,1,'server','example.org'),(4,1,'name','fs.example.org'); +/*!40000 ALTER TABLE `dingaling_profile_params` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dingaling_profiles` +-- + +DROP TABLE IF EXISTS `dingaling_profiles`; +CREATE TABLE `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; + +-- +-- Dumping data for table `dingaling_profiles` +-- + +LOCK TABLES `dingaling_profiles` WRITE; +/*!40000 ALTER TABLE `dingaling_profiles` DISABLE KEYS */; +INSERT INTO `dingaling_profiles` VALUES (1,'fs.intralanman.servehttp.com','component'); +/*!40000 ALTER TABLE `dingaling_profiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dingaling_settings` +-- + +DROP TABLE IF EXISTS `dingaling_settings`; +CREATE TABLE `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; + +-- +-- Dumping data for table `dingaling_settings` +-- + +LOCK TABLES `dingaling_settings` WRITE; +/*!40000 ALTER TABLE `dingaling_settings` DISABLE KEYS */; +INSERT INTO `dingaling_settings` VALUES (1,'debug','0'),(2,'codec-prefs','$${global_codec_prefs}'); +/*!40000 ALTER TABLE `dingaling_settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory` +-- + +DROP TABLE IF EXISTS `directory`; +CREATE TABLE `directory` ( + `id` int(11) NOT NULL auto_increment, + `username` varchar(255) NOT NULL, + `mailbox` varchar(255) NOT NULL, + `domain` varchar(255) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `directory` +-- + +LOCK TABLES `directory` WRITE; +/*!40000 ALTER TABLE `directory` DISABLE KEYS */; +INSERT INTO `directory` VALUES (1,'1000','','example.com'),(2,'1001','','example.org'),(3,'1002','','example.net'),(5,'1003','','example.info'),(6,'1004','','example.com'),(7,'1005','','example.org'),(8,'1006','','example.net'),(9,'1007','','example.info'),(10,'1008','','$${domain}'),(11,'1009','','$${local_ip_v4}'),(12,'tester','1000','$${domain}'); +/*!40000 ALTER TABLE `directory` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_domains` +-- + +DROP TABLE IF EXISTS `directory_domains`; +CREATE TABLE `directory_domains` ( + `id` int(10) unsigned NOT NULL auto_increment, + `domain_name` varchar(128) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `directory_domains` +-- + +LOCK TABLES `directory_domains` WRITE; +/*!40000 ALTER TABLE `directory_domains` DISABLE KEYS */; +INSERT INTO `directory_domains` VALUES (1,'freeswitch.org'),(2,'sofaswitch.org'); +/*!40000 ALTER TABLE `directory_domains` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_gateway_params` +-- + +DROP TABLE IF EXISTS `directory_gateway_params`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_gateway_params` +-- + +LOCK TABLES `directory_gateway_params` WRITE; +/*!40000 ALTER TABLE `directory_gateway_params` DISABLE KEYS */; +/*!40000 ALTER TABLE `directory_gateway_params` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_gateways` +-- + +DROP TABLE IF EXISTS `directory_gateways`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_gateways` +-- + +LOCK TABLES `directory_gateways` WRITE; +/*!40000 ALTER TABLE `directory_gateways` DISABLE KEYS */; +/*!40000 ALTER TABLE `directory_gateways` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_global_params` +-- + +DROP TABLE IF EXISTS `directory_global_params`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_global_params` +-- + +LOCK TABLES `directory_global_params` WRITE; +/*!40000 ALTER TABLE `directory_global_params` DISABLE KEYS */; +INSERT INTO `directory_global_params` VALUES (1,'default_gateway','errors',1); +/*!40000 ALTER TABLE `directory_global_params` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_global_vars` +-- + +DROP TABLE IF EXISTS `directory_global_vars`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_global_vars` +-- + +LOCK TABLES `directory_global_vars` WRITE; +/*!40000 ALTER TABLE `directory_global_vars` DISABLE KEYS */; +/*!40000 ALTER TABLE `directory_global_vars` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_params` +-- + +DROP TABLE IF EXISTS `directory_params`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_params` +-- + +LOCK TABLES `directory_params` WRITE; +/*!40000 ALTER TABLE `directory_params` DISABLE KEYS */; +INSERT INTO `directory_params` VALUES (1,1,'password','1234'),(2,1,'vm-password','861000'),(3,2,'password','1234'),(4,2,'vm-password','861001'),(7,5,'password','1234'),(8,6,'password','1234'),(9,7,'password','1234'),(10,8,'password','1234'),(11,9,'password','1234'),(12,10,'password','1234'),(13,11,'password','1234'),(14,3,'vm-password','861002'),(15,3,'password','1234'),(16,11,'vm-password','861009'),(17,10,'vm-password','861008'),(18,9,'vm-password','861007'),(19,8,'vm-password','861006'),(20,7,'vm-password','861005'),(21,6,'vm-password','861004'),(22,5,'vm-password','861003'); +/*!40000 ALTER TABLE `directory_params` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_vars` +-- + +DROP TABLE IF EXISTS `directory_vars`; +CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `directory_vars` +-- + +LOCK TABLES `directory_vars` WRITE; +/*!40000 ALTER TABLE `directory_vars` DISABLE KEYS */; +INSERT INTO `directory_vars` VALUES (1,1,'numbering_plan','US'),(2,2,'numbering_plan','US'),(3,3,'numbering_plan','AU'),(4,5,'numbering_plan','US'),(5,5,'area_code','434'); +/*!40000 ALTER TABLE `directory_vars` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `group_data` +-- + +DROP TABLE IF EXISTS `group_data`; +CREATE TABLE `group_data` ( + `hostname` varchar(255) default NULL, + `groupname` varchar(255) default NULL, + `url` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `group_data` +-- + +LOCK TABLES `group_data` WRITE; +/*!40000 ALTER TABLE `group_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `group_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `iax_conf` +-- + +DROP TABLE IF EXISTS `iax_conf`; +CREATE TABLE `iax_conf` ( + `id` int(11) NOT NULL auto_increment, + `profile_name` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `iax_conf` +-- + +LOCK TABLES `iax_conf` WRITE; +/*!40000 ALTER TABLE `iax_conf` DISABLE KEYS */; +INSERT INTO `iax_conf` VALUES (3,'test_profile'); +/*!40000 ALTER TABLE `iax_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `iax_settings` +-- + +DROP TABLE IF EXISTS `iax_settings`; +CREATE TABLE `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; + +-- +-- Dumping data for table `iax_settings` +-- + +LOCK TABLES `iax_settings` WRITE; +/*!40000 ALTER TABLE `iax_settings` DISABLE KEYS */; +INSERT INTO `iax_settings` VALUES (35,3,'debug','1'),(36,3,'ip','$${local_ip_v4}'),(37,3,'port','4569'),(38,3,'context','public'),(39,3,'dialplan','enum,XML'),(40,3,'codec-prefs','$${global_codec_prefs}'),(41,3,'codec-master','us'),(42,3,'codec-rate','8'); +/*!40000 ALTER TABLE `iax_settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `ivr_conf` +-- + +DROP TABLE IF EXISTS `ivr_conf`; +CREATE TABLE `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; + +-- +-- Dumping data for table `ivr_conf` +-- + +LOCK TABLES `ivr_conf` WRITE; +/*!40000 ALTER TABLE `ivr_conf` DISABLE KEYS */; +INSERT INTO `ivr_conf` VALUES (1,'demo','soundfiles/ivr/demo/greet-long.wav','soundfiles/ivr/demo/greet-short.wav','soundfiles/ivr/invalid.wav','soundfiles/ivr/exit.wav',3,5,'cepstral','allison'),(2,'demo2','soundfiles/ivr/demo2/greet-long.wav','soundfiles/ivr/demo2/greet-short.wav','soundfiles/ivr/invalid.wav','soundfiles/ivr/exit.wav',3,5,NULL,NULL),(3,'menu8','soundfiles/ivr/menu8/greet-long.wav','soundfiles/ivr/menu8/greet-short.wav','soundfiles/ivr/menu8/invalid.wav','soundfiles/ivr/menu8/exit.wav',3,5,NULL,NULL); +/*!40000 ALTER TABLE `ivr_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `ivr_entries` +-- + +DROP TABLE IF EXISTS `ivr_entries`; +CREATE TABLE `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; + +-- +-- Dumping data for table `ivr_entries` +-- + +LOCK TABLES `ivr_entries` WRITE; +/*!40000 ALTER TABLE `ivr_entries` DISABLE KEYS */; +INSERT INTO `ivr_entries` VALUES (1,1,'menu-play-sound','1','soundfiles/features.wav'),(2,1,'menu-exit','*',NULL),(3,1,'menu-sub','2','demo2'),(4,1,'menu-exec-api','3','bridge sofia/$${domain}/888(a)conference.freeswtich.org'),(5,1,'menu-call-transfer','4','888'),(6,2,'menu-back','#',NULL),(7,2,'menu-top','*',NULL),(8,3,'menu-back','#',NULL),(9,3,'menu-top','*',NULL),(10,3,'menu-playsound','4','soundfiles/4.wav'); +/*!40000 ALTER TABLE `ivr_entries` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `jabber_subscriptions` +-- + +DROP TABLE IF EXISTS `jabber_subscriptions`; +CREATE TABLE `jabber_subscriptions` ( + `sub_from` varchar(255) default NULL, + `sub_to` varchar(255) default NULL, + `show_pres` varchar(255) default NULL, + `status` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `jabber_subscriptions` +-- + +LOCK TABLES `jabber_subscriptions` WRITE; +/*!40000 ALTER TABLE `jabber_subscriptions` DISABLE KEYS */; +/*!40000 ALTER TABLE `jabber_subscriptions` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `lcr` +-- + +DROP TABLE IF EXISTS `lcr`; +CREATE TABLE `lcr` ( + `id` int(11) NOT NULL auto_increment, + `digits` varchar(15) default NULL, + `rate` int(11) NOT NULL, + `carrier_id` int(11) NOT NULL, + `lead_strip` int(11) NOT NULL, + `trail_strip` int(11) NOT NULL, + `prefix` varchar(16) NOT NULL, + `suffix` varchar(16) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB; + +-- +-- Dumping data for table `lcr` +-- + +LOCK TABLES `lcr` WRITE; +/*!40000 ALTER TABLE `lcr` DISABLE KEYS */; +INSERT INTO `lcr` VALUES (1,'1407',23,2,0,0,'',''),(2,'1407',29,1,0,0,'',''),(3,'1407282',28,2,0,0,'',''),(4,'1434',29,1,0,0,'',''),(5,'1434315',21,1,0,0,'',''); +/*!40000 ALTER TABLE `lcr` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `limit_conf` +-- + +DROP TABLE IF EXISTS `limit_conf`; +CREATE TABLE `limit_conf` ( + `id` int(11) NOT NULL auto_increment, + `name` varchar(255) default NULL, + `value` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `limit_conf` +-- + +LOCK TABLES `limit_conf` WRITE; +/*!40000 ALTER TABLE `limit_conf` DISABLE KEYS */; +/*!40000 ALTER TABLE `limit_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `limit_data` +-- + +DROP TABLE IF EXISTS `limit_data`; +CREATE TABLE `limit_data` ( + `hostname` varchar(255) default NULL, + `realm` varchar(255) default NULL, + `id` varchar(255) default NULL, + `uuid` varchar(255) default NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `limit_data` +-- + +LOCK TABLES `limit_data` WRITE; +/*!40000 ALTER TABLE `limit_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `limit_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `local_stream_conf` +-- + +DROP TABLE IF EXISTS `local_stream_conf`; +CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `local_stream_conf` +-- + +LOCK TABLES `local_stream_conf` WRITE; +/*!40000 ALTER TABLE `local_stream_conf` DISABLE KEYS */; +/*!40000 ALTER TABLE `local_stream_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `post_load_modules_conf` +-- + +DROP TABLE IF EXISTS `post_load_modules_conf`; +CREATE TABLE `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; + +-- +-- Dumping data for table `post_load_modules_conf` +-- + +LOCK TABLES `post_load_modules_conf` WRITE; +/*!40000 ALTER TABLE `post_load_modules_conf` DISABLE KEYS */; +INSERT INTO `post_load_modules_conf` VALUES (1,'mod_sofia',1,2000),(2,'mod_iax',1,2000),(3,'mod_xml_rpc',1,100),(4,'mod_portaudio',1,1000),(5,'mod_enum',1,2000),(6,'mod_xml_cdr',1,1000),(7,'mod_spidermonkey',1,1000),(8,'mod_alsa',0,1000),(9,'mod_log_file',1,0),(10,'mod_commands',1,1000),(11,'mod_voicemail',1,1000),(12,'mod_dialplan_xml',1,150),(13,'mod_dialplan_asterisk',1,150),(14,'mod_openzap',0,1000),(15,'mod_woomera',0,1000),(17,'mod_speex',1,500),(18,'mod_ilbc',0,1000),(20,'mod_g723_1',1,500),(21,'mod_g729',1,500),(22,'mod_g722',1,500),(23,'mod_g726',1,500),(25,'mod_amr',1,500),(26,'mod_fifo',1,1000),(27,'mod_limit',1,1000),(28,'mod_syslog',1,0),(29,'mod_dingaling',1,2000),(30,'mod_cdr_csv',1,1000),(31,'mod_event_socket',1,100),(32,'mod_multicast',0,1000),(33,'mod_zeroconf',0,1000),(34,'mod_xmpp_event',0,1000),(35,'mod_sndfile',1,1000),(36,'mod_native_file',1,1000),(37,'mod_shout',1,1000),(38,'mod_local_stream',1,1000),(39,'mod_perl',0,1000),(40,'mod_python',0,1000),(41,'mod_java',0,1000),(42,'mod_cepstral',0,1000),(43,'mod_openmrcp',0,1000),(44,'mod_lumenvox',0,1000),(45,'mod_rss',0,1000),(46,'mod_say_de',1,1000),(47,'mod_say_fr',0,1000),(48,'mod_say_en',1,1000),(49,'mod_conference',1,1000),(50,'mod_ivr',0,1000),(51,'mod_console',1,0),(52,'mod_dptools',1,1500),(53,'mod_voipcodecs',1,500); +/*!40000 ALTER TABLE `post_load_modules_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `rss_conf` +-- + +DROP TABLE IF EXISTS `rss_conf`; +CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `rss_conf` +-- + +LOCK TABLES `rss_conf` WRITE; +/*!40000 ALTER TABLE `rss_conf` DISABLE KEYS */; +/*!40000 ALTER TABLE `rss_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sip_authentication` +-- + +DROP TABLE IF EXISTS `sip_authentication`; +CREATE TABLE `sip_authentication` ( + `nonce` varchar(255) default NULL, + `expires` int(8) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `sip_authentication` +-- + +LOCK TABLES `sip_authentication` WRITE; +/*!40000 ALTER TABLE `sip_authentication` DISABLE KEYS */; +/*!40000 ALTER TABLE `sip_authentication` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sip_dialogs` +-- + +DROP TABLE IF EXISTS `sip_dialogs`; +CREATE TABLE `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` +-- + +LOCK TABLES `sip_dialogs` WRITE; +/*!40000 ALTER TABLE `sip_dialogs` DISABLE KEYS */; +/*!40000 ALTER TABLE `sip_dialogs` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sip_registrations` +-- + +DROP TABLE IF EXISTS `sip_registrations`; +CREATE TABLE `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` +-- + +LOCK TABLES `sip_registrations` WRITE; +/*!40000 ALTER TABLE `sip_registrations` DISABLE KEYS */; +/*!40000 ALTER TABLE `sip_registrations` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sip_subscriptions` +-- + +DROP TABLE IF EXISTS `sip_subscriptions`; +CREATE TABLE `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` +-- + +LOCK TABLES `sip_subscriptions` WRITE; +/*!40000 ALTER TABLE `sip_subscriptions` DISABLE KEYS */; +/*!40000 ALTER TABLE `sip_subscriptions` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_aliases` +-- + +DROP TABLE IF EXISTS `sofia_aliases`; +CREATE TABLE `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; + +-- +-- Dumping data for table `sofia_aliases` +-- + +LOCK TABLES `sofia_aliases` WRITE; +/*!40000 ALTER TABLE `sofia_aliases` DISABLE KEYS */; +INSERT INTO `sofia_aliases` VALUES (1,1,'default'),(3,1,'sip.example.com'); +/*!40000 ALTER TABLE `sofia_aliases` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_conf` +-- + +DROP TABLE IF EXISTS `sofia_conf`; +CREATE TABLE `sofia_conf` ( + `id` int(11) NOT NULL auto_increment, + `profile_name` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `sofia_conf` +-- + +LOCK TABLES `sofia_conf` WRITE; +/*!40000 ALTER TABLE `sofia_conf` DISABLE KEYS */; +INSERT INTO `sofia_conf` VALUES (1,'$${domain}'); +/*!40000 ALTER TABLE `sofia_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_domains` +-- + +DROP TABLE IF EXISTS `sofia_domains`; +CREATE TABLE `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; + +-- +-- Dumping data for table `sofia_domains` +-- + +LOCK TABLES `sofia_domains` WRITE; +/*!40000 ALTER TABLE `sofia_domains` DISABLE KEYS */; +/*!40000 ALTER TABLE `sofia_domains` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_gateways` +-- + +DROP TABLE IF EXISTS `sofia_gateways`; +CREATE TABLE `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; + +-- +-- Dumping data for table `sofia_gateways` +-- + +LOCK TABLES `sofia_gateways` WRITE; +/*!40000 ALTER TABLE `sofia_gateways` DISABLE KEYS */; +INSERT INTO `sofia_gateways` VALUES (8,1,'default','proxy','asterlink.com'),(9,1,'default','realm','asterlink.com'),(10,1,'default','username','USERNAME_HERE'),(11,1,'default','register','false'),(12,1,'default','expire-seconds','60'),(13,1,'default','retry_seconds','2'),(14,1,'default','password','PASSWORD_HERE'); +/*!40000 ALTER TABLE `sofia_gateways` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_settings` +-- + +DROP TABLE IF EXISTS `sofia_settings`; +CREATE TABLE `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; + +-- +-- Dumping data for table `sofia_settings` +-- + +LOCK TABLES `sofia_settings` WRITE; +/*!40000 ALTER TABLE `sofia_settings` DISABLE KEYS */; +INSERT INTO `sofia_settings` VALUES (1,1,'user-agent-string','RayUA 2.0pre4'),(2,1,'auth-calls','true'),(5,1,'debug','1'),(6,1,'rfc2833-pt','101'),(7,1,'sip-port','5060'),(8,1,'dialplan','XML'),(9,1,'dtmf-duration','100'),(10,1,'codec-prefs','$${global_codec_prefs}'),(11,1,'rtp-timeout-sec','300'),(12,1,'rtp-ip','$${local_ip_v4}'),(13,1,'sip-ip','$${local_ip_v4}'),(14,1,'context','default'),(15,1,'manage-presence','true'),(16,1,'force-register-domain','intralanman.servehttp.com'),(17,1,'inbound-codec-negotiation','generous'),(18,1,'rtp-rewrite-timestampes','true'),(19,1,'nonce-ttl','60'),(20,1,'vad','out'),(36,1,'odbc-dsn','freeswitch-mysql:freeswitch:Fr33Sw1tch'); +/*!40000 ALTER TABLE `sofia_settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_conf` +-- + +DROP TABLE IF EXISTS `voicemail_conf`; +CREATE TABLE `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; + +-- +-- Dumping data for table `voicemail_conf` +-- + +LOCK TABLES `voicemail_conf` WRITE; +/*!40000 ALTER TABLE `voicemail_conf` DISABLE KEYS */; +INSERT INTO `voicemail_conf` VALUES (1,'default'); +/*!40000 ALTER TABLE `voicemail_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_data` +-- + +DROP TABLE IF EXISTS `voicemail_data`; +CREATE TABLE `voicemail_data` ( + `created_epoch` int(8) default NULL, + `read_epoch` int(8) default NULL, + `user` varchar(255) default NULL, + `domain` varchar(255) default NULL, + `uuid` varchar(255) default NULL, + `cid_name` varchar(255) default NULL, + `cid_number` varchar(255) default NULL, + `in_folder` varchar(255) default NULL, + `file_path` varchar(255) default NULL, + `flags` varchar(255) default NULL, + `read_flags` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `voicemail_data` +-- + +LOCK TABLES `voicemail_data` WRITE; +/*!40000 ALTER TABLE `voicemail_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `voicemail_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_email` +-- + +DROP TABLE IF EXISTS `voicemail_email`; +CREATE TABLE `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; + +-- +-- Dumping data for table `voicemail_email` +-- + +LOCK TABLES `voicemail_email` WRITE; +/*!40000 ALTER TABLE `voicemail_email` DISABLE KEYS */; +INSERT INTO `voicemail_email` VALUES (1,1,'template-file','voicemail.tpl'),(2,1,'date-fmt','%A, %B %d %Y, %I %M %p'),(3,1,'email-from','${voicemail_account}@${voicemail_domain}'); +/*!40000 ALTER TABLE `voicemail_email` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_prefs` +-- + +DROP TABLE IF EXISTS `voicemail_prefs`; +CREATE TABLE `voicemail_prefs` ( + `user` varchar(255) default NULL, + `domain` varchar(255) default NULL, + `name_path` varchar(255) default NULL, + `greeting_path` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `voicemail_prefs` +-- + +LOCK TABLES `voicemail_prefs` WRITE; +/*!40000 ALTER TABLE `voicemail_prefs` DISABLE KEYS */; +/*!40000 ALTER TABLE `voicemail_prefs` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_settings` +-- + +DROP TABLE IF EXISTS `voicemail_settings`; +CREATE TABLE `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; + +-- +-- Dumping data for table `voicemail_settings` +-- + +LOCK TABLES `voicemail_settings` WRITE; +/*!40000 ALTER TABLE `voicemail_settings` DISABLE KEYS */; +INSERT INTO `voicemail_settings` VALUES (1,1,'file-extension','wav'),(2,1,'terminator-key','#'),(3,1,'max-login-attempts','3'),(4,1,'digit-timeout','10000'),(5,1,'max-record-length','300'),(6,1,'tone-spec','%(1000, 0, 640)'),(7,1,'callback-dialplan','XML'),(8,1,'callback-context','default'),(9,1,'play-new-messages-key','1'),(10,1,'play-saved-messages-key','2'),(11,1,'main-menu-key','*'),(12,1,'config-menu-key','5'),(13,1,'record-greeting-key','1'),(14,1,'choose-greeting-key','2'),(15,1,'record-file-key','3'),(16,1,'listen-file-key','1'),(17,1,'record-name-key','3'),(18,1,'save-file-key','9'),(19,1,'delete-file-key','7'),(20,1,'undelete-file-key','8'),(21,1,'email-key','4'),(22,1,'pause-key','0'),(23,1,'restart-key','1'),(24,1,'ff-key','6'),(25,1,'rew-key','4'),(26,1,'record-silence-threshold','200'),(27,1,'record-silence-hits','2'),(28,1,'web-template-file','web-vm.tpl'),(29,1,'operator-extension','operator XML default'),(30,1,'operator-key','9'); +/*!40000 ALTER TABLE `voicemail_settings` ENABLE KEYS */; +UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2008-04-10 15:11:05 Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0.sql ============================================================================== --- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0.sql (original) +++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0.sql Thu Apr 10 11:33:38 2008 @@ -3,11 +3,16 @@ -- Host: localhost Database: freeswitch -- ------------------------------------------------------ -- Server version 5.0.32-Debian_7etch5-log + +/*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- @@ -21,7 +26,7 @@ `gateway` varchar(32) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `gateway` (`gateway`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `carriers` @@ -32,7 +37,7 @@ `id` int(11) NOT NULL auto_increment, `Carrier_Name` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `conference_advertise` @@ -45,7 +50,7 @@ `status` varchar(128) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_room` (`room`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `conference_controls` @@ -58,8 +63,8 @@ `action` varchar(64) NOT NULL, `digits` varchar(16) NOT NULL, PRIMARY KEY (`id`), - UNIQUE KEY `unique_group_action` (`conf_group`,`action`) -) TYPE=InnoDB; + UNIQUE KEY `unique_group_action` USING BTREE (`conf_group`,`action`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `conference_profiles` @@ -73,7 +78,7 @@ `param_value` varchar(64) NOT NULL, PRIMARY KEY (`id`), KEY `unique_profile_param` (`profile_name`,`param_name`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `db_data` @@ -85,7 +90,7 @@ `realm` varchar(255) default NULL, `data_key` varchar(255) default NULL, `data` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB; -- -- Table structure for table `dialplan` @@ -106,7 +111,20 @@ `global_weight` int(11) NOT NULL default '10000', `cond_break` varchar(8) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `dialplan_special` +-- + +DROP TABLE IF EXISTS `dialplan_special`; +CREATE TABLE `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; -- -- Table structure for table `dingaling_profile_params` @@ -121,7 +139,7 @@ PRIMARY KEY (`id`), UNIQUE KEY `unique_type_name` (`dingaling_id`,`param_name`), CONSTRAINT `dingaling_profile` FOREIGN KEY (`dingaling_id`) REFERENCES `dingaling_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `dingaling_profiles` @@ -134,7 +152,7 @@ `type` varchar(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_name` (`profile_name`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `dingaling_settings` @@ -147,7 +165,7 @@ `param_value` varchar(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_param` (`param_name`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `directory` @@ -160,7 +178,7 @@ `mailbox` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `directory_domains` @@ -171,7 +189,7 @@ `id` int(10) unsigned NOT NULL auto_increment, `domain_name` varchar(128) NOT NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `directory_gateway_params` @@ -185,7 +203,7 @@ `param_value` varchar(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_gw_param` (`d_gw_id`,`param_name`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `directory_gateways` @@ -197,7 +215,7 @@ `directory_id` int(10) unsigned NOT NULL, `gateway_name` varchar(128) NOT NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `directory_global_params` @@ -210,7 +228,7 @@ `param_value` varchar(128) NOT NULL, `domain_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `directory_global_vars` @@ -223,7 +241,7 @@ `var_value` varchar(128) NOT NULL, `domain_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `directory_params` @@ -236,7 +254,7 @@ `param_name` varchar(255) default NULL, `param_value` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `directory_vars` @@ -249,7 +267,7 @@ `var_name` varchar(255) default NULL, `var_value` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `group_data` @@ -260,7 +278,7 @@ `hostname` varchar(255) default NULL, `groupname` varchar(255) default NULL, `url` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB; -- -- Table structure for table `iax_conf` @@ -271,7 +289,7 @@ `id` int(11) NOT NULL auto_increment, `profile_name` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `iax_settings` @@ -284,7 +302,7 @@ `param_name` varchar(255) default NULL, `param_value` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `ivr_conf` @@ -304,7 +322,7 @@ `tts_voice` varchar(64) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_name` (`name`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `ivr_entries` @@ -318,8 +336,8 @@ `digits` varchar(16) NOT NULL, `params` varchar(255) default NULL, PRIMARY KEY (`id`), - UNIQUE KEY `unique_ivr_digits` (`ivr_id`,`digits`) -) TYPE=InnoDB; + UNIQUE KEY `unique_ivr_digits` USING BTREE (`ivr_id`,`digits`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `jabber_subscriptions` @@ -331,7 +349,7 @@ `sub_to` varchar(255) default NULL, `show_pres` varchar(255) default NULL, `status` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB; -- -- Table structure for table `lcr` @@ -348,7 +366,7 @@ `prefix` varchar(16) NOT NULL, `suffix` varchar(16) NOT NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB AUTO_INCREMENT=6; +) ENGINE=InnoDB; -- -- Table structure for table `limit_conf` @@ -360,7 +378,7 @@ `name` varchar(255) default NULL, `value` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `limit_data` @@ -372,7 +390,7 @@ `realm` varchar(255) default NULL, `id` varchar(255) default NULL, `uuid` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `local_stream_conf` @@ -386,7 +404,7 @@ `param_name` varchar(255) default NULL, `param_value` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `post_load_modules_conf` @@ -400,7 +418,7 @@ `priority` int(10) unsigned NOT NULL default '1000', PRIMARY KEY (`id`), UNIQUE KEY `unique_mod` (`module_name`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `rss_conf` @@ -415,7 +433,7 @@ `description` text, `priority` int(11) NOT NULL default '1000', PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `sip_authentication` @@ -425,7 +443,7 @@ CREATE TABLE `sip_authentication` ( `nonce` varchar(255) default NULL, `expires` int(8) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB; -- -- Table structure for table `sip_dialogs` @@ -444,7 +462,7 @@ `state` varchar(255) default NULL, `direction` varchar(255) default NULL, `user_agent` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `sip_registrations` @@ -460,7 +478,7 @@ `rpid` varchar(255) default NULL, `expires` int(11) default NULL, `user_agent` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `sip_subscriptions` @@ -481,7 +499,7 @@ `expires` int(11) default NULL, `user_agent` varchar(255) default NULL, `accept` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `sofia_aliases` @@ -493,7 +511,7 @@ `sofia_id` int(10) unsigned NOT NULL, `alias_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `sofia_conf` @@ -504,7 +522,7 @@ `id` int(11) NOT NULL auto_increment, `profile_name` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `sofia_domains` @@ -517,7 +535,7 @@ `domain_name` varchar(255) default NULL, `parse` tinyint(1) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `sofia_gateways` @@ -531,7 +549,7 @@ `gateway_param` varchar(255) default NULL, `gateway_value` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `sofia_settings` @@ -544,7 +562,7 @@ `param_name` varchar(255) default NULL, `param_value` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `voicemail_conf` @@ -556,7 +574,7 @@ `vm_profile` varchar(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_profile` (`vm_profile`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `voicemail_data` @@ -575,7 +593,7 @@ `file_path` varchar(255) default NULL, `flags` varchar(255) default NULL, `read_flags` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB; -- -- Table structure for table `voicemail_email` @@ -589,7 +607,7 @@ `param_value` varchar(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_profile_param` (`param_name`,`voicemail_id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `voicemail_prefs` @@ -601,7 +619,7 @@ `domain` varchar(255) default NULL, `name_path` varchar(255) default NULL, `greeting_path` varchar(255) default NULL -) TYPE=InnoDB; +) ENGINE=InnoDB; -- -- Table structure for table `voicemail_settings` @@ -614,12 +632,15 @@ `param_name` varchar(255) default NULL, `param_value` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2008-04-10 4:45:50 +-- Dump completed on 2008-04-10 15:11:05 Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0-with-samples.sql ============================================================================== --- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0-with-samples.sql (original) +++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0-with-samples.sql Thu Apr 10 11:33:38 2008 @@ -1,772 +1,1079 @@ --- MySQL dump 10.11 --- --- Host: localhost Database: freeswitch --- ------------------------------------------------------ --- Server version 5.0.45-community-nt - -/*!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 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - --- --- Table structure for table `conference_advertise` --- - -DROP TABLE IF EXISTS `conference_advertise`; -CREATE TABLE `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 AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `conference_advertise` --- - -LOCK TABLES `conference_advertise` WRITE; -/*!40000 ALTER TABLE `conference_advertise` DISABLE KEYS */; -INSERT INTO `conference_advertise` VALUES (1,'3000@$${domain}','Freeswitch Conference'),(2,'3001@$${domain}','FreeSWITCH Conference 2'),(3,'3002@$${domain}','FreeSWITCH Conference 3'); -/*!40000 ALTER TABLE `conference_advertise` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `conference_controls` --- - -DROP TABLE IF EXISTS `conference_controls`; -CREATE TABLE `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 AUTO_INCREMENT=25 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `conference_controls` --- - -LOCK TABLES `conference_controls` WRITE; -/*!40000 ALTER TABLE `conference_controls` DISABLE KEYS */; -INSERT INTO `conference_controls` VALUES (1,'default','mute','0'),(2,'default','deaf_mute','*'),(3,'default','energy up','9'),(4,'default','energy equ','8'),(5,'default','energy dn','7'),(6,'default','vol talk up','3'),(7,'default','vol talk dn','1'),(8,'default','vol talk zero','2'),(9,'default','vol listen up','6'),(10,'default','vol listen dn','4'),(11,'default','vol listen zero','5'),(12,'default','hangup','#'); -/*!40000 ALTER TABLE `conference_controls` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `conference_profiles` --- - -DROP TABLE IF EXISTS `conference_profiles`; -CREATE TABLE `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 AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `conference_profiles` --- - -LOCK TABLES `conference_profiles` WRITE; -/*!40000 ALTER TABLE `conference_profiles` DISABLE KEYS */; -INSERT INTO `conference_profiles` VALUES (1,'default','domain','$${domain}'),(2,'default','rate','8000'),(3,'default','interval','20'),(4,'default','energy-level','300'),(5,'default','moh-sound','$${moh_uri}'),(6,'default','caller-id-name','$${outbound_caller_name}'),(7,'default','caller-id-number','$${outbound_caller_number}'); -/*!40000 ALTER TABLE `conference_profiles` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `dialplan` --- - -DROP TABLE IF EXISTS `dialplan`; -CREATE TABLE `dialplan` ( - `id` int(11) NOT NULL auto_increment, - `context` varchar(64) NOT NULL, - `extension` varchar(64) NOT NULL, - `condition_field` varchar(64) NOT NULL, - `condition_expression` varchar(64) NOT NULL, - `application_name` varchar(64) NOT NULL, - `application_data` text, - `weight` int(11) NOT NULL, - `type` varchar(16) NOT NULL default 'action', - `ext_continue` smallint(1) NOT NULL default '0', - `global_weight` int(11) NOT NULL default '10000', - `cond_break` varchar(8) default NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=385 DEFAULT CHARSET=utf8; - --- --- Dumping data for table `dialplan` --- - -LOCK TABLES `dialplan` WRITE; -/*!40000 ALTER TABLE `dialplan` DISABLE KEYS */; -INSERT INTO `dialplan` VALUES (273,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','enum','1$1',3,'action',0,200,''),(272,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','set','hangup_after_bridge=true',2,'action',0,200,''),(271,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','set','continue_on_fail=true',1,'action',0,200,''),(383,'default','hold_music','destination_number','^9999$','playback','$${moh_uri}',2,'action',0,1900,''),(384,'default','enum','destination_number','^(.*)$','transfer','$1 enum',1,'action',0,2000,''),(382,'default','hold_music','destination_number','^9999$','answer','',1,'action',0,1900,''),(378,'default','ivr_demo','destination_number','5000','ivr','demo',1,'action',0,1600,''),(379,'default','park','destination_number','^(590[0-9])$','fifo','$1@$${domain} in undef $${moh_uri}',1,'action',0,1700,''),(380,'default','unpark','destination_number','^\\*{0,2}park\\+(590[0-9])$','answer','',1,'action',0,1800,''),(381,'default','unpark','destination_number','^\\*{0,2}park\\+(590[0-9])$','fifo','$1@$${domain} out nowait',2,'action',0,1800,''),(375,'default','sip_uri','destination_number','^sip:(.*)$','bridge','sofia/${use_profile}/$1',1,'action',0,1300,''),(376,'default','conferences','destination_number','^(3\\d{3})$','conference','$1@default',1,'action',0,1400,''),(377,'default','freeswitch_public_conf_via_sip','destination_number','^9(888|1616)$','bridge','sofia/${use_profile}/$1(a)conference.freeswitch.org',1,'action',0,1500,''),(372,'default','Local_Extension','destination_number','^${caller_id_number}$','answer','',13,'anti-action',0,1200,''),(373,'default','Local_Extension','destination_number','^${caller_id_number}$','sleep','1000',14,'anti-action',0,1200,''),(374,'default','Local_Extension','destination_number','^${caller_id_number}$','voicemail','default $${domain} ${dialed_ext}',15,'anti-action',0,1200,''),(371,'default','Local_Extension','destination_number','^${caller_id_number}$','bridge','{left_hanging_extension=5900,transfer_fallback_extension=${dialed_ext}}USER/${dialed_ext}@$${domain}',12,'anti-action',0,1200,''),(367,'default','Local_Extension','destination_number','^${caller_id_number}$','set','left_hanging_extension=5900',8,'anti-action',0,1200,''),(368,'default','Local_Extension','destination_number','^${caller_id_number}$','set','continue_on_fail=true',9,'anti-action',0,1200,''),(369,'default','Local_Extension','destination_number','^${caller_id_number}$','db','insert/call_return/${dialed_ext}/${caller_id_number}',10,'anti-action',0,1200,''),(370,'default','Local_Extension','destination_number','^${caller_id_number}$','db','insert/last_dial_ext/${dialed_ext}/${uuid}',11,'anti-action',0,1200,''),(364,'default','Local_Extension','destination_number','^${caller_id_number}$','ring_ready','',5,'anti-action',0,1200,''),(365,'default','Local_Extension','destination_number','^${caller_id_number}$','set','call_timeout=130',6,'anti-action',0,1200,''),(366,'default','Local_Extension','destination_number','^${caller_id_number}$','set','hangup_after_bridge=true',7,'anti-action',0,1200,''),(361,'default','Local_Extension','destination_number','^${caller_id_number}$','answer','',2,'action',0,1200,''),(362,'default','Local_Extension','destination_number','^${caller_id_number}$','sleep','1000',3,'action',0,1200,''),(363,'default','Local_Extension','destination_number','^${caller_id_number}$','voicemail','check default $${domain} ${dialed_ext}',4,'action',0,1200,''),(359,'default','Local_Extension','destination_number','^(10[01][0-9])$','set','dialed_ext=$1',1,'action',0,1200,'on-true'),(360,'default','Local_Extension','destination_number','^${caller_id_number}$','set','voicemail_authorized=${sip_authorized}',1,'action',0,1200,''),(357,'default','call-group-order','destination_number','^83(\\d{2})$','set','call_timeout=10',1,'action',0,1100,''),(358,'default','call-group-order','destination_number','^83(\\d{2})$','bridge','${group(call:$1:order)}',2,'action',0,1100,''),(356,'default','call-group-simo','destination_number','^82(\\d{2})$','bridge','${group(call:$1)}',1,'action',0,1000,''),(355,'default','add-group','destination_number','^81(\\d{2})$','gentones','%(1000, 0, 640)',3,'action',0,900,''),(354,'default','add-group','destination_number','^81(\\d{2})$','group','insert:$1:${sofia_contact(${sip_from_user}@${domain})}',2,'action',0,900,''),(350,'default','del-group','destination_number','^80(\\d{2})$','answer','',1,'action',0,800,''),(351,'default','del-group','destination_number','^80(\\d{2})$','group','delete:$1:${sofia_contact(${sip_from_user}@${domain})}',2,'action',0,800,''),(352,'default','del-group','destination_number','^80(\\d{2})$','gentones','%(1000, 0, 320)',3,'action',0,800,''),(353,'default','add-group','destination_number','^81(\\d{2})$','answer','',1,'action',0,900,''),(349,'default','call_return','destination_number','^\\*69$|^869$','transfer','${db(select/call_return/${caller_id_number})}',1,'action',0,700,''),(348,'default','eavesdrop','destination_number','^88(.*)$|^\\*0(.*)$','eavesdrop','${db(select/spymap/$1)}',2,'action',0,600,''),(347,'default','eavesdrop','destination_number','^88(.*)$|^\\*0(.*)$','answer','',1,'action',0,600,''),(344,'default','global','','','db','insert/spymap/${caller_id_number}/${uuid}',2,'action',1,500,''),(345,'default','global','','','db','insert/last_dial/${caller_id_number}/${destination_number}',3,'action',1,500,''),(346,'default','global','','','db','insert/last_dial/global/${uuid}',4,'action',1,500,''),(340,'default','global','${network_addr}','','set','use_profile=${cond(${is_lan_addr($${local_ip_v4})} == yes ? nat : default)}',1,'action',1,500,''),(342,'default','global','${numbering_plan}','','set_user','default@${domain}',1,'action',1,500,''),(343,'default','global','','','info','',1,'action',1,500,''),(341,'default','global','${network_addr}','','set','use_profile=${cond(${is_lan_addr(${network_addr})} == yes ? nat : default)}',2,'anti-action',1,500,''),(338,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','sleep','2000',3,'action',0,300,''),(339,'default','redial','destination_number','^870$','transfer','${db(select/last_dial/${caller_id_number})}',1,'action',0,400,''),(337,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','intercept','${db(select/last_dial_ext/$1)}',2,'action',0,300,''),(335,'default','intercept','destination_number','^886$','sleep','2000',3,'action',0,200,''),(336,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','answer','',1,'action',0,300,''),(333,'default','intercept','destination_number','^886$','answer','',1,'action',0,200,''),(334,'default','intercept','destination_number','^886$','intercept','${db(select/last_dial/global)}',2,'action',0,200,''),(113,'public','public_extensions','destination_number','^(10[01][0-9])$','transfer','$1 XML default',1,'action',0,200,''),(114,'public','public_did','destination_number','^(5551212)$','transfer','$1 XML default',1,'action',0,300,''),(274,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','bridge','${enum_auto_route}',4,'action',0,200,''),(275,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','bridge','sofia/gateway/${default_gateway}/011$1',5,'action',0,200,''),(276,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','set','continue_on_fail=true',1,'action',0,300,''),(277,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','set','hangup_after_bridge=true',2,'action',0,300,''),(278,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','enum','1$1',3,'action',0,300,''),(279,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','bridge','${enum_auto_route}',4,'action',0,300,''),(280,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','bridge','sofia/gateway/${default_gateway}/1$1',5,'action',0,300,''),(281,'US-Numbering-Plan','US_Local','${default_area_code}','\\d{3}','say','you must dial the area code to call this destination',1,'anti-action',0,400,'on-true'),(282,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','set','continue_on_fail=true',1,'action',0,400,''),(283,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','set','hangup_after_bridge=true',2,'action',0,400,''),(284,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','enum','1$1',3,'action',0,400,''),(285,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','bridge','${enum_auto_route}',4,'action',0,400,''),(286,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','bridge','sofia/gateway/${default_gateway}/1${default_area_code}$1',5,'action',0,400,''),(287,'US-Numbering-Plan','FCC_Services','^([4689]11)$','','bridge','sofia/gateway/${default_gateway}/$1',1,'action',0,500,''); -/*!40000 ALTER TABLE `dialplan` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `dingaling_profile_params` --- - -DROP TABLE IF EXISTS `dingaling_profile_params`; -CREATE TABLE `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`), - CONSTRAINT `dingaling_profile` FOREIGN KEY (`dingaling_id`) REFERENCES `dingaling_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `dingaling_profile_params` --- - -LOCK TABLES `dingaling_profile_params` WRITE; -/*!40000 ALTER TABLE `dingaling_profile_params` DISABLE KEYS */; -INSERT INTO `dingaling_profile_params` VALUES (1,1,'password','secret'),(2,1,'dialplan','XML,enum'),(3,1,'server','example.org'),(4,1,'name','fs.example.org'); -/*!40000 ALTER TABLE `dingaling_profile_params` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `dingaling_profiles` --- - -DROP TABLE IF EXISTS `dingaling_profiles`; -CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `dingaling_profiles` --- - -LOCK TABLES `dingaling_profiles` WRITE; -/*!40000 ALTER TABLE `dingaling_profiles` DISABLE KEYS */; -INSERT INTO `dingaling_profiles` VALUES (1,'fs.intralanman.servehttp.com','component'); -/*!40000 ALTER TABLE `dingaling_profiles` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `dingaling_settings` --- - -DROP TABLE IF EXISTS `dingaling_settings`; -CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `dingaling_settings` --- - -LOCK TABLES `dingaling_settings` WRITE; -/*!40000 ALTER TABLE `dingaling_settings` DISABLE KEYS */; -INSERT INTO `dingaling_settings` VALUES (1,'debug','0'),(2,'codec-prefs','$${global_codec_prefs}'); -/*!40000 ALTER TABLE `dingaling_settings` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `directory` --- - -DROP TABLE IF EXISTS `directory`; -CREATE TABLE `directory` ( - `id` int(11) NOT NULL auto_increment, - `username` varchar(255) NOT NULL, - `mailbox` varchar(255) NOT NULL, - `domain` varchar(255) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; - --- --- Dumping data for table `directory` --- - -LOCK TABLES `directory` WRITE; -/*!40000 ALTER TABLE `directory` DISABLE KEYS */; -INSERT INTO `directory` VALUES (1,'1000','','example.com'),(2,'1001','','example.org'),(3,'1002','','example.net'),(5,'1003','','example.info'),(6,'1004','','example.com'),(7,'1005','','example.org'),(8,'1006','','example.net'),(9,'1007','','example.info'),(10,'1008','','$${domain}'),(11,'1009','','$${local_ip_v4}'),(12,'tester','1000','$${domain}'); -/*!40000 ALTER TABLE `directory` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `directory_domains` --- - -DROP TABLE IF EXISTS `directory_domains`; -CREATE TABLE `directory_domains` ( - `id` int(10) unsigned NOT NULL auto_increment, - `domain_name` varchar(128) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `directory_domains` --- - -LOCK TABLES `directory_domains` WRITE; -/*!40000 ALTER TABLE `directory_domains` DISABLE KEYS */; -INSERT INTO `directory_domains` VALUES (1,'freeswitch.org'),(2,'sofaswitch.org'); -/*!40000 ALTER TABLE `directory_domains` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `directory_gateway_params` --- - -DROP TABLE IF EXISTS `directory_gateway_params`; -CREATE TABLE `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 AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `directory_gateway_params` --- - -LOCK TABLES `directory_gateway_params` WRITE; -/*!40000 ALTER TABLE `directory_gateway_params` DISABLE KEYS */; -/*!40000 ALTER TABLE `directory_gateway_params` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `directory_gateways` --- - -DROP TABLE IF EXISTS `directory_gateways`; -CREATE TABLE `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 AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `directory_gateways` --- - -LOCK TABLES `directory_gateways` WRITE; -/*!40000 ALTER TABLE `directory_gateways` DISABLE KEYS */; -/*!40000 ALTER TABLE `directory_gateways` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `directory_global_params` --- - -DROP TABLE IF EXISTS `directory_global_params`; -CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `directory_global_params` --- - -LOCK TABLES `directory_global_params` WRITE; -/*!40000 ALTER TABLE `directory_global_params` DISABLE KEYS */; -INSERT INTO `directory_global_params` VALUES (1,'default_gateway','errors',1); -/*!40000 ALTER TABLE `directory_global_params` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `directory_global_vars` --- - -DROP TABLE IF EXISTS `directory_global_vars`; -CREATE TABLE `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; - --- --- Dumping data for table `directory_global_vars` --- - -LOCK TABLES `directory_global_vars` WRITE; -/*!40000 ALTER TABLE `directory_global_vars` DISABLE KEYS */; -/*!40000 ALTER TABLE `directory_global_vars` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `directory_params` --- - -DROP TABLE IF EXISTS `directory_params`; -CREATE TABLE `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 AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; - --- --- Dumping data for table `directory_params` --- - -LOCK TABLES `directory_params` WRITE; -/*!40000 ALTER TABLE `directory_params` DISABLE KEYS */; -INSERT INTO `directory_params` VALUES (1,1,'password','1234'),(2,1,'vm-password','861000'),(3,2,'password','1234'),(4,2,'vm-password','861001'),(7,5,'password','1234'),(8,6,'password','1234'),(9,7,'password','1234'),(10,8,'password','1234'),(11,9,'password','1234'),(12,10,'password','1234'),(13,11,'password','1234'),(14,3,'vm-password','861002'),(15,3,'password','1234'),(16,11,'vm-password','861009'),(17,10,'vm-password','861008'),(18,9,'vm-password','861007'),(19,8,'vm-password','861006'),(20,7,'vm-password','861005'),(21,6,'vm-password','861004'),(22,5,'vm-password','861003'); -/*!40000 ALTER TABLE `directory_params` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `directory_vars` --- - -DROP TABLE IF EXISTS `directory_vars`; -CREATE TABLE `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=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; - --- --- Dumping data for table `directory_vars` --- - -LOCK TABLES `directory_vars` WRITE; -/*!40000 ALTER TABLE `directory_vars` DISABLE KEYS */; -INSERT INTO `directory_vars` VALUES (1,1,'numbering_plan','US'),(2,2,'numbering_plan','US'),(3,3,'numbering_plan','AU'),(4,5,'numbering_plan','US'),(5,5,'area_code','434'); -/*!40000 ALTER TABLE `directory_vars` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `iax_conf` --- - -DROP TABLE IF EXISTS `iax_conf`; -CREATE TABLE `iax_conf` ( - `id` int(11) NOT NULL auto_increment, - `profile_name` varchar(255) default NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `iax_conf` --- - -LOCK TABLES `iax_conf` WRITE; -/*!40000 ALTER TABLE `iax_conf` DISABLE KEYS */; -INSERT INTO `iax_conf` VALUES (3,'test_profile'); -/*!40000 ALTER TABLE `iax_conf` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `iax_settings` --- - -DROP TABLE IF EXISTS `iax_settings`; -CREATE TABLE `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 AUTO_INCREMENT=43 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `iax_settings` --- - -LOCK TABLES `iax_settings` WRITE; -/*!40000 ALTER TABLE `iax_settings` DISABLE KEYS */; -INSERT INTO `iax_settings` VALUES (35,3,'debug','1'),(36,3,'ip','$${local_ip_v4}'),(37,3,'port','4569'),(38,3,'context','public'),(39,3,'dialplan','enum,XML'),(40,3,'codec-prefs','$${global_codec_prefs}'),(41,3,'codec-master','us'),(42,3,'codec-rate','8'); -/*!40000 ALTER TABLE `iax_settings` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `ivr_conf` --- - -DROP TABLE IF EXISTS `ivr_conf`; -CREATE TABLE `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 AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `ivr_conf` --- - -LOCK TABLES `ivr_conf` WRITE; -/*!40000 ALTER TABLE `ivr_conf` DISABLE KEYS */; -INSERT INTO `ivr_conf` VALUES (1,'demo','soundfiles/ivr/demo/greet-long.wav','soundfiles/ivr/demo/greet-short.wav','soundfiles/ivr/invalid.wav','soundfiles/ivr/exit.wav',3,5,'cepstral','allison'),(2,'demo2','soundfiles/ivr/demo2/greet-long.wav','soundfiles/ivr/demo2/greet-short.wav','soundfiles/ivr/invalid.wav','soundfiles/ivr/exit.wav',3,5,NULL,NULL),(3,'menu8','soundfiles/ivr/menu8/greet-long.wav','soundfiles/ivr/menu8/greet-short.wav','soundfiles/ivr/menu8/invalid.wav','soundfiles/ivr/menu8/exit.wav',3,5,NULL,NULL); -/*!40000 ALTER TABLE `ivr_conf` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `ivr_entries` --- - -DROP TABLE IF EXISTS `ivr_entries`; -CREATE TABLE `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 AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `ivr_entries` --- - -LOCK TABLES `ivr_entries` WRITE; -/*!40000 ALTER TABLE `ivr_entries` DISABLE KEYS */; -INSERT INTO `ivr_entries` VALUES (1,1,'menu-play-sound','1','soundfiles/features.wav'),(2,1,'menu-exit','*',NULL),(3,1,'menu-sub','2','demo2'),(4,1,'menu-exec-api','3','bridge sofia/$${domain}/888(a)conference.freeswtich.org'),(5,1,'menu-call-transfer','4','888'),(6,2,'menu-back','#',NULL),(7,2,'menu-top','*',NULL),(8,3,'menu-back','#',NULL),(9,3,'menu-top','*',NULL),(10,3,'menu-playsound','4','soundfiles/4.wav'); -/*!40000 ALTER TABLE `ivr_entries` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `limit_conf` --- - -DROP TABLE IF EXISTS `limit_conf`; -CREATE TABLE `limit_conf` ( - `id` int(11) NOT NULL auto_increment, - `name` varchar(255) default NULL, - `value` varchar(255) default NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; - --- --- Dumping data for table `limit_conf` --- - -LOCK TABLES `limit_conf` WRITE; -/*!40000 ALTER TABLE `limit_conf` DISABLE KEYS */; -/*!40000 ALTER TABLE `limit_conf` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `limit_data` --- - -DROP TABLE IF EXISTS `limit_data`; -CREATE TABLE `limit_data` ( - `hostname` varchar(255) default NULL, - `realm` varchar(255) default NULL, - `id` varchar(255) default NULL, - `uuid` varchar(255) default NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `limit_data` --- - -LOCK TABLES `limit_data` WRITE; -/*!40000 ALTER TABLE `limit_data` DISABLE KEYS */; -/*!40000 ALTER TABLE `limit_data` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `local_stream_conf` --- - -DROP TABLE IF EXISTS `local_stream_conf`; -CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `local_stream_conf` --- - -LOCK TABLES `local_stream_conf` WRITE; -/*!40000 ALTER TABLE `local_stream_conf` DISABLE KEYS */; -/*!40000 ALTER TABLE `local_stream_conf` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `post_load_modules_conf` --- - -DROP TABLE IF EXISTS `post_load_modules_conf`; -CREATE TABLE `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 AUTO_INCREMENT=54 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `post_load_modules_conf` --- - -LOCK TABLES `post_load_modules_conf` WRITE; -/*!40000 ALTER TABLE `post_load_modules_conf` DISABLE KEYS */; -INSERT INTO `post_load_modules_conf` VALUES (1,'mod_sofia',1,2000),(2,'mod_iax',1,2000),(3,'mod_xml_rpc',1,100),(4,'mod_portaudio',1,1000),(5,'mod_enum',1,2000),(6,'mod_xml_cdr',1,1000),(7,'mod_spidermonkey',1,1000),(8,'mod_alsa',0,1000),(9,'mod_log_file',1,0),(10,'mod_commands',1,1000),(11,'mod_voicemail',1,1000),(12,'mod_dialplan_xml',1,150),(13,'mod_dialplan_asterisk',1,150),(14,'mod_openzap',0,1000),(15,'mod_woomera',0,1000),(17,'mod_speex',1,500),(18,'mod_ilbc',0,1000),(20,'mod_g723_1',1,500),(21,'mod_g729',1,500),(22,'mod_g722',1,500),(23,'mod_g726',1,500),(25,'mod_amr',1,500),(26,'mod_fifo',1,1000),(27,'mod_limit',1,1000),(28,'mod_syslog',1,0),(29,'mod_dingaling',1,2000),(30,'mod_cdr_csv',1,1000),(31,'mod_event_socket',1,100),(32,'mod_multicast',0,1000),(33,'mod_zeroconf',0,1000),(34,'mod_xmpp_event',0,1000),(35,'mod_sndfile',1,1000),(36,'mod_native_file',1,1000),(37,'mod_shout',1,1000),(38,'mod_local_stream',1,1000),(39,'mod_perl',0,1000),(40,'mod_python',0,1000),(41,'mod_java',0,1000),(42,'mod_cepstral',0,1000),(43,'mod_openmrcp',0,1000),(44,'mod_lumenvox',0,1000),(45,'mod_rss',0,1000),(46,'mod_say_de',1,1000),(47,'mod_say_fr',0,1000),(48,'mod_say_en',1,1000),(49,'mod_conference',1,1000),(50,'mod_ivr',0,1000),(51,'mod_console',1,0),(52,'mod_dptools',1,1500),(53,'mod_voipcodecs',1,500); -/*!40000 ALTER TABLE `post_load_modules_conf` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `rss_conf` --- - -DROP TABLE IF EXISTS `rss_conf`; -CREATE TABLE `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=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; - --- --- Dumping data for table `rss_conf` --- - -LOCK TABLES `rss_conf` WRITE; -/*!40000 ALTER TABLE `rss_conf` DISABLE KEYS */; -/*!40000 ALTER TABLE `rss_conf` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `sofia_aliases` --- - -DROP TABLE IF EXISTS `sofia_aliases`; -CREATE TABLE `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 AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sofia_aliases` --- - -LOCK TABLES `sofia_aliases` WRITE; -/*!40000 ALTER TABLE `sofia_aliases` DISABLE KEYS */; -INSERT INTO `sofia_aliases` VALUES (1,1,'default'),(3,1,'sip.example.com'); -/*!40000 ALTER TABLE `sofia_aliases` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `sofia_conf` --- - -DROP TABLE IF EXISTS `sofia_conf`; -CREATE TABLE `sofia_conf` ( - `id` int(11) NOT NULL auto_increment, - `profile_name` varchar(255) default NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sofia_conf` --- - -LOCK TABLES `sofia_conf` WRITE; -/*!40000 ALTER TABLE `sofia_conf` DISABLE KEYS */; -INSERT INTO `sofia_conf` VALUES (1,'$${domain}'); -/*!40000 ALTER TABLE `sofia_conf` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `sofia_domains` --- - -DROP TABLE IF EXISTS `sofia_domains`; -CREATE TABLE `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; - --- --- Dumping data for table `sofia_domains` --- - -LOCK TABLES `sofia_domains` WRITE; -/*!40000 ALTER TABLE `sofia_domains` DISABLE KEYS */; -/*!40000 ALTER TABLE `sofia_domains` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `sofia_gateways` --- - -DROP TABLE IF EXISTS `sofia_gateways`; -CREATE TABLE `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 AUTO_INCREMENT=15 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sofia_gateways` --- - -LOCK TABLES `sofia_gateways` WRITE; -/*!40000 ALTER TABLE `sofia_gateways` DISABLE KEYS */; -INSERT INTO `sofia_gateways` VALUES (8,1,'default','proxy','asterlink.com'),(9,1,'default','realm','asterlink.com'),(10,1,'default','username','USERNAME_HERE'),(11,1,'default','register','false'),(12,1,'default','expire-seconds','60'),(13,1,'default','retry_seconds','2'),(14,1,'default','password','PASSWORD_HERE'); -/*!40000 ALTER TABLE `sofia_gateways` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `sofia_settings` --- - -DROP TABLE IF EXISTS `sofia_settings`; -CREATE TABLE `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 AUTO_INCREMENT=37 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sofia_settings` --- - -LOCK TABLES `sofia_settings` WRITE; -/*!40000 ALTER TABLE `sofia_settings` DISABLE KEYS */; -INSERT INTO `sofia_settings` VALUES (1,1,'user-agent-string','RayUA 2.0pre4'),(2,1,'auth-calls','true'),(5,1,'debug','1'),(6,1,'rfc2833-pt','101'),(7,1,'sip-port','5060'),(8,1,'dialplan','XML'),(9,1,'dtmf-duration','100'),(10,1,'codec-prefs','$${global_codec_prefs}'),(11,1,'rtp-timeout-sec','300'),(12,1,'rtp-ip','$${local_ip_v4}'),(13,1,'sip-ip','$${local_ip_v4}'),(14,1,'context','default'),(15,1,'manage-presence','true'),(16,1,'force-register-domain','intralanman.servehttp.com'),(17,1,'inbound-codec-negotiation','generous'),(18,1,'rtp-rewrite-timestampes','true'),(19,1,'nonce-ttl','60'),(20,1,'vad','out'),(36,1,'odbc-dsn','freeswitch-mysql:freeswitch:Fr33Sw1tch'); -/*!40000 ALTER TABLE `sofia_settings` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `voicemail_conf` --- - -DROP TABLE IF EXISTS `voicemail_conf`; -CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `voicemail_conf` --- - -LOCK TABLES `voicemail_conf` WRITE; -/*!40000 ALTER TABLE `voicemail_conf` DISABLE KEYS */; -INSERT INTO `voicemail_conf` VALUES (1,'default'); -/*!40000 ALTER TABLE `voicemail_conf` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `voicemail_email` --- - -DROP TABLE IF EXISTS `voicemail_email`; -CREATE TABLE `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 AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `voicemail_email` --- - -LOCK TABLES `voicemail_email` WRITE; -/*!40000 ALTER TABLE `voicemail_email` DISABLE KEYS */; -INSERT INTO `voicemail_email` VALUES (1,1,'template-file','voicemail.tpl'),(2,1,'date-fmt','%A, %B %d %Y, %I %M %p'),(3,1,'email-from','${voicemail_account}@${voicemail_domain}'); -/*!40000 ALTER TABLE `voicemail_email` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `voicemail_settings` --- - -DROP TABLE IF EXISTS `voicemail_settings`; -CREATE TABLE `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 AUTO_INCREMENT=31 DEFAULT CHARSET=latin1; - --- --- Dumping data for table `voicemail_settings` --- - -LOCK TABLES `voicemail_settings` WRITE; -/*!40000 ALTER TABLE `voicemail_settings` DISABLE KEYS */; -INSERT INTO `voicemail_settings` VALUES (1,1,'file-extension','wav'),(2,1,'terminator-key','#'),(3,1,'max-login-attempts','3'),(4,1,'digit-timeout','10000'),(5,1,'max-record-length','300'),(6,1,'tone-spec','%(1000, 0, 640)'),(7,1,'callback-dialplan','XML'),(8,1,'callback-context','default'),(9,1,'play-new-messages-key','1'),(10,1,'play-saved-messages-key','2'),(11,1,'main-menu-key','*'),(12,1,'config-menu-key','5'),(13,1,'record-greeting-key','1'),(14,1,'choose-greeting-key','2'),(15,1,'record-file-key','3'),(16,1,'listen-file-key','1'),(17,1,'record-name-key','3'),(18,1,'save-file-key','9'),(19,1,'delete-file-key','7'),(20,1,'undelete-file-key','8'),(21,1,'email-key','4'),(22,1,'pause-key','0'),(23,1,'restart-key','1'),(24,1,'ff-key','6'),(25,1,'rew-key','4'),(26,1,'record-silence-threshold','200'),(27,1,'record-silence-hits','2'),(28,1,'web-template-file','web-vm.tpl'),(29,1,'operator-extension','operator XML default'),(30,1,'operator-key','9'); -/*!40000 ALTER TABLE `voicemail_settings` ENABLE KEYS */; -UNLOCK TABLES; -/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; - -/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; -/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; -/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; -/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; -/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; -/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; - --- Dump completed on 2008-03-25 4:57:01 +-- MySQL dump 10.11 +-- +-- Host: localhost Database: freeswitch +-- ------------------------------------------------------ +-- Server version 5.0.32-Debian_7etch5-log + +/*!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 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `carrier_gateway` +-- + +DROP TABLE IF EXISTS `carrier_gateway`; +CREATE TABLE `carrier_gateway` ( + `id` int(11) NOT NULL auto_increment, + `carrier_id` int(11) default NULL, + `gateway` varchar(32) default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `gateway` (`gateway`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `carrier_gateway` +-- + +LOCK TABLES `carrier_gateway` WRITE; +/*!40000 ALTER TABLE `carrier_gateway` DISABLE KEYS */; +INSERT INTO `carrier_gateway` VALUES (1,1,'GX1783b'),(2,2,'L3285032k1'),(3,1,'GX2946h'),(4,2,'L3973865l2'); +/*!40000 ALTER TABLE `carrier_gateway` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `carriers` +-- + +DROP TABLE IF EXISTS `carriers`; +CREATE TABLE `carriers` ( + `id` int(11) NOT NULL auto_increment, + `Carrier_Name` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `carriers` +-- + +LOCK TABLES `carriers` WRITE; +/*!40000 ALTER TABLE `carriers` DISABLE KEYS */; +INSERT INTO `carriers` VALUES (1,'Global Crossing'),(2,'Level 3 Communications'); +/*!40000 ALTER TABLE `carriers` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `conference_advertise` +-- + +DROP TABLE IF EXISTS `conference_advertise`; +CREATE TABLE `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; + +-- +-- Dumping data for table `conference_advertise` +-- + +LOCK TABLES `conference_advertise` WRITE; +/*!40000 ALTER TABLE `conference_advertise` DISABLE KEYS */; +INSERT INTO `conference_advertise` VALUES (1,'3000@$${domain}','Freeswitch Conference'),(2,'3001@$${domain}','FreeSWITCH Conference 2'),(3,'3002@$${domain}','FreeSWITCH Conference 3'); +/*!40000 ALTER TABLE `conference_advertise` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `conference_controls` +-- + +DROP TABLE IF EXISTS `conference_controls`; +CREATE TABLE `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; + +-- +-- Dumping data for table `conference_controls` +-- + +LOCK TABLES `conference_controls` WRITE; +/*!40000 ALTER TABLE `conference_controls` DISABLE KEYS */; +INSERT INTO `conference_controls` VALUES (1,'default','mute','0'),(2,'default','deaf_mute','*'),(3,'default','energy up','9'),(4,'default','energy equ','8'),(5,'default','energy dn','7'),(6,'default','vol talk up','3'),(7,'default','vol talk dn','1'),(8,'default','vol talk zero','2'),(9,'default','vol listen up','6'),(10,'default','vol listen dn','4'),(11,'default','vol listen zero','5'),(12,'default','hangup','#'); +/*!40000 ALTER TABLE `conference_controls` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `conference_profiles` +-- + +DROP TABLE IF EXISTS `conference_profiles`; +CREATE TABLE `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; + +-- +-- Dumping data for table `conference_profiles` +-- + +LOCK TABLES `conference_profiles` WRITE; +/*!40000 ALTER TABLE `conference_profiles` DISABLE KEYS */; +INSERT INTO `conference_profiles` VALUES (1,'default','domain','$${domain}'),(2,'default','rate','8000'),(3,'default','interval','20'),(4,'default','energy-level','300'),(5,'default','moh-sound','$${moh_uri}'),(6,'default','caller-id-name','$${outbound_caller_name}'),(7,'default','caller-id-number','$${outbound_caller_number}'); +/*!40000 ALTER TABLE `conference_profiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `db_data` +-- + +DROP TABLE IF EXISTS `db_data`; +CREATE TABLE `db_data` ( + `hostname` varchar(255) default NULL, + `realm` varchar(255) default NULL, + `data_key` varchar(255) default NULL, + `data` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `db_data` +-- + +LOCK TABLES `db_data` WRITE; +/*!40000 ALTER TABLE `db_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `db_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dialplan` +-- + +DROP TABLE IF EXISTS `dialplan`; +CREATE TABLE `dialplan` ( + `id` int(11) NOT NULL auto_increment, + `context` varchar(64) NOT NULL, + `extension` varchar(64) NOT NULL, + `condition_field` varchar(64) NOT NULL, + `condition_expression` varchar(64) NOT NULL, + `application_name` varchar(64) NOT NULL, + `application_data` text, + `weight` int(11) NOT NULL, + `type` varchar(16) NOT NULL default 'action', + `ext_continue` smallint(1) NOT NULL default '0', + `global_weight` int(11) NOT NULL default '10000', + `cond_break` varchar(8) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `dialplan` +-- + +LOCK TABLES `dialplan` WRITE; +/*!40000 ALTER TABLE `dialplan` DISABLE KEYS */; +INSERT INTO `dialplan` VALUES (113,'public','public_extensions','destination_number','^(10[01][0-9])$','transfer','$1 XML default',1,'action',0,200,''),(114,'public','public_did','destination_number','^(5551212)$','transfer','$1 XML default',1,'action',0,300,''),(271,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','set','continue_on_fail=true',1,'action',0,200,''),(272,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','set','hangup_after_bridge=true',2,'action',0,200,''),(273,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','enum','1$1',3,'action',0,200,''),(274,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','bridge','${enum_auto_route}',4,'action',0,200,''),(275,'US-Numbering-Plan','US_International','destination_number','^011(\\d+)$','bridge','sofia/gateway/${default_gateway}/011$1',5,'action',0,200,''),(276,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','set','continue_on_fail=true',1,'action',0,300,''),(277,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','set','hangup_after_bridge=true',2,'action',0,300,''),(278,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','enum','1$1',3,'action',0,300,''),(279,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','bridge','${enum_auto_route}',4,'action',0,300,''),(280,'US-Numbering-Plan','US_LD','destination_number','^1?([2-9]\\d{2}[2-9]\\d{6})$','bridge','sofia/gateway/${default_gateway}/1$1',5,'action',0,300,''),(281,'US-Numbering-Plan','US_Local','${default_area_code}','\\d{3}','say','you must dial the area code to call this destination',1,'anti-action',0,400,'on-true'),(282,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','set','continue_on_fail=true',1,'action',0,400,''),(283,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','set','hangup_after_bridge=true',2,'action',0,400,''),(284,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','enum','1$1',3,'action',0,400,''),(285,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','bridge','${enum_auto_route}',4,'action',0,400,''),(286,'US-Numbering-Plan','US_Local','destination_number','^([2-9]\\d{6})$','bridge','sofia/gateway/${default_gateway}/1${default_area_code}$1',5,'action',0,400,''),(287,'US-Numbering-Plan','FCC_Services','^([4689]11)$','','bridge','sofia/gateway/${default_gateway}/$1',1,'action',0,500,''),(333,'default','intercept','destination_number','^886$','answer','',1,'action',0,200,''),(334,'default','intercept','destination_number','^886$','intercept','${db(select/last_dial/global)}',2,'action',0,200,''),(335,'default','intercept','destination_number','^886$','sleep','2000',3,'action',0,200,''),(336,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','answer','',1,'action',0,300,''),(337,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','intercept','${db(select/last_dial_ext/$1)}',2,'action',0,300,''),(338,'default','intercept-ext','destination_number','^\\*\\*(\\d+)$','sleep','2000',3,'action',0,300,''),(339,'default','redial','destination_number','^870$','transfer','${db(select/last_dial/${caller_id_number})}',1,'action',0,400,''),(340,'default','global','${network_addr}','','set','use_profile=${cond(${is_lan_addr($${local_ip_v4})} == yes ? nat : default)}',1,'action',1,500,''),(341,'default','global','${network_addr}','','set','use_profile=${cond(${is_lan_addr(${network_addr})} == yes ? nat : default)}',2,'anti-action',1,500,''),(342,'default','global','${numbering_plan}','','set_user','default@${domain}',1,'action',1,500,''),(343,'default','global','','','info','',1,'action',1,500,''),(344,'default','global','','','db','insert/spymap/${caller_id_number}/${uuid}',2,'action',1,500,''),(345,'default','global','','','db','insert/last_dial/${caller_id_number}/${destination_number}',3,'action',1,500,''),(346,'default','global','','','db','insert/last_dial/global/${uuid}',4,'action',1,500,''),(347,'default','eavesdrop','destination_number','^88(.*)$|^\\*0(.*)$','answer','',1,'action',0,600,''),(348,'default','eavesdrop','destination_number','^88(.*)$|^\\*0(.*)$','eavesdrop','${db(select/spymap/$1)}',2,'action',0,600,''),(349,'default','call_return','destination_number','^\\*69$|^869$','transfer','${db(select/call_return/${caller_id_number})}',1,'action',0,700,''),(350,'default','del-group','destination_number','^80(\\d{2})$','answer','',1,'action',0,800,''),(351,'default','del-group','destination_number','^80(\\d{2})$','group','delete:$1:${sofia_contact(${sip_from_user}@${domain})}',2,'action',0,800,''),(352,'default','del-group','destination_number','^80(\\d{2})$','gentones','%(1000, 0, 320)',3,'action',0,800,''),(353,'default','add-group','destination_number','^81(\\d{2})$','answer','',1,'action',0,900,''),(354,'default','add-group','destination_number','^81(\\d{2})$','group','insert:$1:${sofia_contact(${sip_from_user}@${domain})}',2,'action',0,900,''),(355,'default','add-group','destination_number','^81(\\d{2})$','gentones','%(1000, 0, 640)',3,'action',0,900,''),(356,'default','call-group-simo','destination_number','^82(\\d{2})$','bridge','${group(call:$1)}',1,'action',0,1000,''),(357,'default','call-group-order','destination_number','^83(\\d{2})$','set','call_timeout=10',1,'action',0,1100,''),(358,'default','call-group-order','destination_number','^83(\\d{2})$','bridge','${group(call:$1:order)}',2,'action',0,1100,''),(359,'default','Local_Extension','destination_number','^(10[01][0-9])$','set','dialed_ext=$1',1,'action',0,1200,'on-true'),(360,'default','Local_Extension','destination_number','^${caller_id_number}$','set','voicemail_authorized=${sip_authorized}',1,'action',0,1200,''),(361,'default','Local_Extension','destination_number','^${caller_id_number}$','answer','',2,'action',0,1200,''),(362,'default','Local_Extension','destination_number','^${caller_id_number}$','sleep','1000',3,'action',0,1200,''),(363,'default','Local_Extension','destination_number','^${caller_id_number}$','voicemail','check default $${domain} ${dialed_ext}',4,'action',0,1200,''),(364,'default','Local_Extension','destination_number','^${caller_id_number}$','ring_ready','',5,'anti-action',0,1200,''),(365,'default','Local_Extension','destination_number','^${caller_id_number}$','set','call_timeout=130',6,'anti-action',0,1200,''),(366,'default','Local_Extension','destination_number','^${caller_id_number}$','set','hangup_after_bridge=true',7,'anti-action',0,1200,''),(367,'default','Local_Extension','destination_number','^${caller_id_number}$','set','left_hanging_extension=5900',8,'anti-action',0,1200,''),(368,'default','Local_Extension','destination_number','^${caller_id_number}$','set','continue_on_fail=true',9,'anti-action',0,1200,''),(369,'default','Local_Extension','destination_number','^${caller_id_number}$','db','insert/call_return/${dialed_ext}/${caller_id_number}',10,'anti-action',0,1200,''),(370,'default','Local_Extension','destination_number','^${caller_id_number}$','db','insert/last_dial_ext/${dialed_ext}/${uuid}',11,'anti-action',0,1200,''),(371,'default','Local_Extension','destination_number','^${caller_id_number}$','bridge','{left_hanging_extension=5900,transfer_fallback_extension=${dialed_ext}}USER/${dialed_ext}@$${domain}',12,'anti-action',0,1200,''),(372,'default','Local_Extension','destination_number','^${caller_id_number}$','answer','',13,'anti-action',0,1200,''),(373,'default','Local_Extension','destination_number','^${caller_id_number}$','sleep','1000',14,'anti-action',0,1200,''),(374,'default','Local_Extension','destination_number','^${caller_id_number}$','voicemail','default $${domain} ${dialed_ext}',15,'anti-action',0,1200,''),(375,'default','sip_uri','destination_number','^sip:(.*)$','bridge','sofia/${use_profile}/$1',1,'action',0,1300,''),(376,'default','conferences','destination_number','^(3\\d{3})$','conference','$1@default',1,'action',0,1400,''),(377,'default','freeswitch_public_conf_via_sip','destination_number','^9(888|1616)$','bridge','sofia/${use_profile}/$1(a)conference.freeswitch.org',1,'action',0,1500,''),(378,'default','ivr_demo','destination_number','5000','ivr','demo',1,'action',0,1600,''),(379,'default','park','destination_number','^(590[0-9])$','fifo','$1@$${domain} in undef $${moh_uri}',1,'action',0,1700,''),(380,'default','unpark','destination_number','^\\*{0,2}park\\+(590[0-9])$','answer','',1,'action',0,1800,''),(381,'default','unpark','destination_number','^\\*{0,2}park\\+(590[0-9])$','fifo','$1@$${domain} out nowait',2,'action',0,1800,''),(382,'default','hold_music','destination_number','^9999$','answer','',1,'action',0,1900,''),(383,'default','hold_music','destination_number','^9999$','playback','$${moh_uri}',2,'action',0,1900,''),(384,'default','enum','destination_number','^(.*)$','transfer','$1 enum',1,'action',0,2000,''); +/*!40000 ALTER TABLE `dialplan` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dialplan_special` +-- + +DROP TABLE IF EXISTS `dialplan_special`; +CREATE TABLE `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; + +-- +-- Dumping data for table `dialplan_special` +-- + +LOCK TABLES `dialplan_special` WRITE; +/*!40000 ALTER TABLE `dialplan_special` DISABLE KEYS */; +INSERT INTO `dialplan_special` VALUES (1,'lcr','dialplans/lcr.php'),(2,'lcr2','some/php/file.php'); +/*!40000 ALTER TABLE `dialplan_special` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dingaling_profile_params` +-- + +DROP TABLE IF EXISTS `dingaling_profile_params`; +CREATE TABLE `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`), + CONSTRAINT `dingaling_profile` FOREIGN KEY (`dingaling_id`) REFERENCES `dingaling_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `dingaling_profile_params` +-- + +LOCK TABLES `dingaling_profile_params` WRITE; +/*!40000 ALTER TABLE `dingaling_profile_params` DISABLE KEYS */; +INSERT INTO `dingaling_profile_params` VALUES (1,1,'password','secret'),(2,1,'dialplan','XML,enum'),(3,1,'server','example.org'),(4,1,'name','fs.example.org'); +/*!40000 ALTER TABLE `dingaling_profile_params` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dingaling_profiles` +-- + +DROP TABLE IF EXISTS `dingaling_profiles`; +CREATE TABLE `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; + +-- +-- Dumping data for table `dingaling_profiles` +-- + +LOCK TABLES `dingaling_profiles` WRITE; +/*!40000 ALTER TABLE `dingaling_profiles` DISABLE KEYS */; +INSERT INTO `dingaling_profiles` VALUES (1,'fs.intralanman.servehttp.com','component'); +/*!40000 ALTER TABLE `dingaling_profiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dingaling_settings` +-- + +DROP TABLE IF EXISTS `dingaling_settings`; +CREATE TABLE `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; + +-- +-- Dumping data for table `dingaling_settings` +-- + +LOCK TABLES `dingaling_settings` WRITE; +/*!40000 ALTER TABLE `dingaling_settings` DISABLE KEYS */; +INSERT INTO `dingaling_settings` VALUES (1,'debug','0'),(2,'codec-prefs','$${global_codec_prefs}'); +/*!40000 ALTER TABLE `dingaling_settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory` +-- + +DROP TABLE IF EXISTS `directory`; +CREATE TABLE `directory` ( + `id` int(11) NOT NULL auto_increment, + `username` varchar(255) NOT NULL, + `mailbox` varchar(255) NOT NULL, + `domain` varchar(255) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `directory` +-- + +LOCK TABLES `directory` WRITE; +/*!40000 ALTER TABLE `directory` DISABLE KEYS */; +INSERT INTO `directory` VALUES (1,'1000','','example.com'),(2,'1001','','example.org'),(3,'1002','','example.net'),(5,'1003','','example.info'),(6,'1004','','example.com'),(7,'1005','','example.org'),(8,'1006','','example.net'),(9,'1007','','example.info'),(10,'1008','','$${domain}'),(11,'1009','','$${local_ip_v4}'),(12,'tester','1000','$${domain}'); +/*!40000 ALTER TABLE `directory` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_domains` +-- + +DROP TABLE IF EXISTS `directory_domains`; +CREATE TABLE `directory_domains` ( + `id` int(10) unsigned NOT NULL auto_increment, + `domain_name` varchar(128) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `directory_domains` +-- + +LOCK TABLES `directory_domains` WRITE; +/*!40000 ALTER TABLE `directory_domains` DISABLE KEYS */; +INSERT INTO `directory_domains` VALUES (1,'freeswitch.org'),(2,'sofaswitch.org'); +/*!40000 ALTER TABLE `directory_domains` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_gateway_params` +-- + +DROP TABLE IF EXISTS `directory_gateway_params`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_gateway_params` +-- + +LOCK TABLES `directory_gateway_params` WRITE; +/*!40000 ALTER TABLE `directory_gateway_params` DISABLE KEYS */; +/*!40000 ALTER TABLE `directory_gateway_params` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_gateways` +-- + +DROP TABLE IF EXISTS `directory_gateways`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_gateways` +-- + +LOCK TABLES `directory_gateways` WRITE; +/*!40000 ALTER TABLE `directory_gateways` DISABLE KEYS */; +/*!40000 ALTER TABLE `directory_gateways` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_global_params` +-- + +DROP TABLE IF EXISTS `directory_global_params`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_global_params` +-- + +LOCK TABLES `directory_global_params` WRITE; +/*!40000 ALTER TABLE `directory_global_params` DISABLE KEYS */; +INSERT INTO `directory_global_params` VALUES (1,'default_gateway','errors',1); +/*!40000 ALTER TABLE `directory_global_params` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_global_vars` +-- + +DROP TABLE IF EXISTS `directory_global_vars`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_global_vars` +-- + +LOCK TABLES `directory_global_vars` WRITE; +/*!40000 ALTER TABLE `directory_global_vars` DISABLE KEYS */; +/*!40000 ALTER TABLE `directory_global_vars` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_params` +-- + +DROP TABLE IF EXISTS `directory_params`; +CREATE TABLE `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; + +-- +-- Dumping data for table `directory_params` +-- + +LOCK TABLES `directory_params` WRITE; +/*!40000 ALTER TABLE `directory_params` DISABLE KEYS */; +INSERT INTO `directory_params` VALUES (1,1,'password','1234'),(2,1,'vm-password','861000'),(3,2,'password','1234'),(4,2,'vm-password','861001'),(7,5,'password','1234'),(8,6,'password','1234'),(9,7,'password','1234'),(10,8,'password','1234'),(11,9,'password','1234'),(12,10,'password','1234'),(13,11,'password','1234'),(14,3,'vm-password','861002'),(15,3,'password','1234'),(16,11,'vm-password','861009'),(17,10,'vm-password','861008'),(18,9,'vm-password','861007'),(19,8,'vm-password','861006'),(20,7,'vm-password','861005'),(21,6,'vm-password','861004'),(22,5,'vm-password','861003'); +/*!40000 ALTER TABLE `directory_params` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `directory_vars` +-- + +DROP TABLE IF EXISTS `directory_vars`; +CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `directory_vars` +-- + +LOCK TABLES `directory_vars` WRITE; +/*!40000 ALTER TABLE `directory_vars` DISABLE KEYS */; +INSERT INTO `directory_vars` VALUES (1,1,'numbering_plan','US'),(2,2,'numbering_plan','US'),(3,3,'numbering_plan','AU'),(4,5,'numbering_plan','US'),(5,5,'area_code','434'); +/*!40000 ALTER TABLE `directory_vars` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `group_data` +-- + +DROP TABLE IF EXISTS `group_data`; +CREATE TABLE `group_data` ( + `hostname` varchar(255) default NULL, + `groupname` varchar(255) default NULL, + `url` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `group_data` +-- + +LOCK TABLES `group_data` WRITE; +/*!40000 ALTER TABLE `group_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `group_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `iax_conf` +-- + +DROP TABLE IF EXISTS `iax_conf`; +CREATE TABLE `iax_conf` ( + `id` int(11) NOT NULL auto_increment, + `profile_name` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `iax_conf` +-- + +LOCK TABLES `iax_conf` WRITE; +/*!40000 ALTER TABLE `iax_conf` DISABLE KEYS */; +INSERT INTO `iax_conf` VALUES (3,'test_profile'); +/*!40000 ALTER TABLE `iax_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `iax_settings` +-- + +DROP TABLE IF EXISTS `iax_settings`; +CREATE TABLE `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; + +-- +-- Dumping data for table `iax_settings` +-- + +LOCK TABLES `iax_settings` WRITE; +/*!40000 ALTER TABLE `iax_settings` DISABLE KEYS */; +INSERT INTO `iax_settings` VALUES (35,3,'debug','1'),(36,3,'ip','$${local_ip_v4}'),(37,3,'port','4569'),(38,3,'context','public'),(39,3,'dialplan','enum,XML'),(40,3,'codec-prefs','$${global_codec_prefs}'),(41,3,'codec-master','us'),(42,3,'codec-rate','8'); +/*!40000 ALTER TABLE `iax_settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `ivr_conf` +-- + +DROP TABLE IF EXISTS `ivr_conf`; +CREATE TABLE `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; + +-- +-- Dumping data for table `ivr_conf` +-- + +LOCK TABLES `ivr_conf` WRITE; +/*!40000 ALTER TABLE `ivr_conf` DISABLE KEYS */; +INSERT INTO `ivr_conf` VALUES (1,'demo','soundfiles/ivr/demo/greet-long.wav','soundfiles/ivr/demo/greet-short.wav','soundfiles/ivr/invalid.wav','soundfiles/ivr/exit.wav',3,5,'cepstral','allison'),(2,'demo2','soundfiles/ivr/demo2/greet-long.wav','soundfiles/ivr/demo2/greet-short.wav','soundfiles/ivr/invalid.wav','soundfiles/ivr/exit.wav',3,5,NULL,NULL),(3,'menu8','soundfiles/ivr/menu8/greet-long.wav','soundfiles/ivr/menu8/greet-short.wav','soundfiles/ivr/menu8/invalid.wav','soundfiles/ivr/menu8/exit.wav',3,5,NULL,NULL); +/*!40000 ALTER TABLE `ivr_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `ivr_entries` +-- + +DROP TABLE IF EXISTS `ivr_entries`; +CREATE TABLE `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; + +-- +-- Dumping data for table `ivr_entries` +-- + +LOCK TABLES `ivr_entries` WRITE; +/*!40000 ALTER TABLE `ivr_entries` DISABLE KEYS */; +INSERT INTO `ivr_entries` VALUES (1,1,'menu-play-sound','1','soundfiles/features.wav'),(2,1,'menu-exit','*',NULL),(3,1,'menu-sub','2','demo2'),(4,1,'menu-exec-api','3','bridge sofia/$${domain}/888(a)conference.freeswtich.org'),(5,1,'menu-call-transfer','4','888'),(6,2,'menu-back','#',NULL),(7,2,'menu-top','*',NULL),(8,3,'menu-back','#',NULL),(9,3,'menu-top','*',NULL),(10,3,'menu-playsound','4','soundfiles/4.wav'); +/*!40000 ALTER TABLE `ivr_entries` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `jabber_subscriptions` +-- + +DROP TABLE IF EXISTS `jabber_subscriptions`; +CREATE TABLE `jabber_subscriptions` ( + `sub_from` varchar(255) default NULL, + `sub_to` varchar(255) default NULL, + `show_pres` varchar(255) default NULL, + `status` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `jabber_subscriptions` +-- + +LOCK TABLES `jabber_subscriptions` WRITE; +/*!40000 ALTER TABLE `jabber_subscriptions` DISABLE KEYS */; +/*!40000 ALTER TABLE `jabber_subscriptions` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `lcr` +-- + +DROP TABLE IF EXISTS `lcr`; +CREATE TABLE `lcr` ( + `id` int(11) NOT NULL auto_increment, + `digits` varchar(15) default NULL, + `rate` int(11) NOT NULL, + `carrier_id` int(11) NOT NULL, + `lead_strip` int(11) NOT NULL, + `trail_strip` int(11) NOT NULL, + `prefix` varchar(16) NOT NULL, + `suffix` varchar(16) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB; + +-- +-- Dumping data for table `lcr` +-- + +LOCK TABLES `lcr` WRITE; +/*!40000 ALTER TABLE `lcr` DISABLE KEYS */; +INSERT INTO `lcr` VALUES (1,'1407',23,2,0,0,'',''),(2,'1407',29,1,0,0,'',''),(3,'1407282',28,2,0,0,'',''),(4,'1434',29,1,0,0,'',''),(5,'1434315',21,1,0,0,'',''); +/*!40000 ALTER TABLE `lcr` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `limit_conf` +-- + +DROP TABLE IF EXISTS `limit_conf`; +CREATE TABLE `limit_conf` ( + `id` int(11) NOT NULL auto_increment, + `name` varchar(255) default NULL, + `value` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `limit_conf` +-- + +LOCK TABLES `limit_conf` WRITE; +/*!40000 ALTER TABLE `limit_conf` DISABLE KEYS */; +/*!40000 ALTER TABLE `limit_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `limit_data` +-- + +DROP TABLE IF EXISTS `limit_data`; +CREATE TABLE `limit_data` ( + `hostname` varchar(255) default NULL, + `realm` varchar(255) default NULL, + `id` varchar(255) default NULL, + `uuid` varchar(255) default NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `limit_data` +-- + +LOCK TABLES `limit_data` WRITE; +/*!40000 ALTER TABLE `limit_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `limit_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `local_stream_conf` +-- + +DROP TABLE IF EXISTS `local_stream_conf`; +CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `local_stream_conf` +-- + +LOCK TABLES `local_stream_conf` WRITE; +/*!40000 ALTER TABLE `local_stream_conf` DISABLE KEYS */; +/*!40000 ALTER TABLE `local_stream_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `post_load_modules_conf` +-- + +DROP TABLE IF EXISTS `post_load_modules_conf`; +CREATE TABLE `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; + +-- +-- Dumping data for table `post_load_modules_conf` +-- + +LOCK TABLES `post_load_modules_conf` WRITE; +/*!40000 ALTER TABLE `post_load_modules_conf` DISABLE KEYS */; +INSERT INTO `post_load_modules_conf` VALUES (1,'mod_sofia',1,2000),(2,'mod_iax',1,2000),(3,'mod_xml_rpc',1,100),(4,'mod_portaudio',1,1000),(5,'mod_enum',1,2000),(6,'mod_xml_cdr',1,1000),(7,'mod_spidermonkey',1,1000),(8,'mod_alsa',0,1000),(9,'mod_log_file',1,0),(10,'mod_commands',1,1000),(11,'mod_voicemail',1,1000),(12,'mod_dialplan_xml',1,150),(13,'mod_dialplan_asterisk',1,150),(14,'mod_openzap',0,1000),(15,'mod_woomera',0,1000),(17,'mod_speex',1,500),(18,'mod_ilbc',0,1000),(20,'mod_g723_1',1,500),(21,'mod_g729',1,500),(22,'mod_g722',1,500),(23,'mod_g726',1,500),(25,'mod_amr',1,500),(26,'mod_fifo',1,1000),(27,'mod_limit',1,1000),(28,'mod_syslog',1,0),(29,'mod_dingaling',1,2000),(30,'mod_cdr_csv',1,1000),(31,'mod_event_socket',1,100),(32,'mod_multicast',0,1000),(33,'mod_zeroconf',0,1000),(34,'mod_xmpp_event',0,1000),(35,'mod_sndfile',1,1000),(36,'mod_native_file',1,1000),(37,'mod_shout',1,1000),(38,'mod_local_stream',1,1000),(39,'mod_perl',0,1000),(40,'mod_python',0,1000),(41,'mod_java',0,1000),(42,'mod_cepstral',0,1000),(43,'mod_openmrcp',0,1000),(44,'mod_lumenvox',0,1000),(45,'mod_rss',0,1000),(46,'mod_say_de',1,1000),(47,'mod_say_fr',0,1000),(48,'mod_say_en',1,1000),(49,'mod_conference',1,1000),(50,'mod_ivr',0,1000),(51,'mod_console',1,0),(52,'mod_dptools',1,1500),(53,'mod_voipcodecs',1,500); +/*!40000 ALTER TABLE `post_load_modules_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `rss_conf` +-- + +DROP TABLE IF EXISTS `rss_conf`; +CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `rss_conf` +-- + +LOCK TABLES `rss_conf` WRITE; +/*!40000 ALTER TABLE `rss_conf` DISABLE KEYS */; +/*!40000 ALTER TABLE `rss_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sip_authentication` +-- + +DROP TABLE IF EXISTS `sip_authentication`; +CREATE TABLE `sip_authentication` ( + `nonce` varchar(255) default NULL, + `expires` int(8) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `sip_authentication` +-- + +LOCK TABLES `sip_authentication` WRITE; +/*!40000 ALTER TABLE `sip_authentication` DISABLE KEYS */; +/*!40000 ALTER TABLE `sip_authentication` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sip_dialogs` +-- + +DROP TABLE IF EXISTS `sip_dialogs`; +CREATE TABLE `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` +-- + +LOCK TABLES `sip_dialogs` WRITE; +/*!40000 ALTER TABLE `sip_dialogs` DISABLE KEYS */; +/*!40000 ALTER TABLE `sip_dialogs` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sip_registrations` +-- + +DROP TABLE IF EXISTS `sip_registrations`; +CREATE TABLE `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` +-- + +LOCK TABLES `sip_registrations` WRITE; +/*!40000 ALTER TABLE `sip_registrations` DISABLE KEYS */; +/*!40000 ALTER TABLE `sip_registrations` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sip_subscriptions` +-- + +DROP TABLE IF EXISTS `sip_subscriptions`; +CREATE TABLE `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` +-- + +LOCK TABLES `sip_subscriptions` WRITE; +/*!40000 ALTER TABLE `sip_subscriptions` DISABLE KEYS */; +/*!40000 ALTER TABLE `sip_subscriptions` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_aliases` +-- + +DROP TABLE IF EXISTS `sofia_aliases`; +CREATE TABLE `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; + +-- +-- Dumping data for table `sofia_aliases` +-- + +LOCK TABLES `sofia_aliases` WRITE; +/*!40000 ALTER TABLE `sofia_aliases` DISABLE KEYS */; +INSERT INTO `sofia_aliases` VALUES (1,1,'default'),(3,1,'sip.example.com'); +/*!40000 ALTER TABLE `sofia_aliases` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_conf` +-- + +DROP TABLE IF EXISTS `sofia_conf`; +CREATE TABLE `sofia_conf` ( + `id` int(11) NOT NULL auto_increment, + `profile_name` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `sofia_conf` +-- + +LOCK TABLES `sofia_conf` WRITE; +/*!40000 ALTER TABLE `sofia_conf` DISABLE KEYS */; +INSERT INTO `sofia_conf` VALUES (1,'$${domain}'); +/*!40000 ALTER TABLE `sofia_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_domains` +-- + +DROP TABLE IF EXISTS `sofia_domains`; +CREATE TABLE `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; + +-- +-- Dumping data for table `sofia_domains` +-- + +LOCK TABLES `sofia_domains` WRITE; +/*!40000 ALTER TABLE `sofia_domains` DISABLE KEYS */; +/*!40000 ALTER TABLE `sofia_domains` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_gateways` +-- + +DROP TABLE IF EXISTS `sofia_gateways`; +CREATE TABLE `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; + +-- +-- Dumping data for table `sofia_gateways` +-- + +LOCK TABLES `sofia_gateways` WRITE; +/*!40000 ALTER TABLE `sofia_gateways` DISABLE KEYS */; +INSERT INTO `sofia_gateways` VALUES (8,1,'default','proxy','asterlink.com'),(9,1,'default','realm','asterlink.com'),(10,1,'default','username','USERNAME_HERE'),(11,1,'default','register','false'),(12,1,'default','expire-seconds','60'),(13,1,'default','retry_seconds','2'),(14,1,'default','password','PASSWORD_HERE'); +/*!40000 ALTER TABLE `sofia_gateways` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sofia_settings` +-- + +DROP TABLE IF EXISTS `sofia_settings`; +CREATE TABLE `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; + +-- +-- Dumping data for table `sofia_settings` +-- + +LOCK TABLES `sofia_settings` WRITE; +/*!40000 ALTER TABLE `sofia_settings` DISABLE KEYS */; +INSERT INTO `sofia_settings` VALUES (1,1,'user-agent-string','RayUA 2.0pre4'),(2,1,'auth-calls','true'),(5,1,'debug','1'),(6,1,'rfc2833-pt','101'),(7,1,'sip-port','5060'),(8,1,'dialplan','XML'),(9,1,'dtmf-duration','100'),(10,1,'codec-prefs','$${global_codec_prefs}'),(11,1,'rtp-timeout-sec','300'),(12,1,'rtp-ip','$${local_ip_v4}'),(13,1,'sip-ip','$${local_ip_v4}'),(14,1,'context','default'),(15,1,'manage-presence','true'),(16,1,'force-register-domain','intralanman.servehttp.com'),(17,1,'inbound-codec-negotiation','generous'),(18,1,'rtp-rewrite-timestampes','true'),(19,1,'nonce-ttl','60'),(20,1,'vad','out'),(36,1,'odbc-dsn','freeswitch-mysql:freeswitch:Fr33Sw1tch'); +/*!40000 ALTER TABLE `sofia_settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_conf` +-- + +DROP TABLE IF EXISTS `voicemail_conf`; +CREATE TABLE `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; + +-- +-- Dumping data for table `voicemail_conf` +-- + +LOCK TABLES `voicemail_conf` WRITE; +/*!40000 ALTER TABLE `voicemail_conf` DISABLE KEYS */; +INSERT INTO `voicemail_conf` VALUES (1,'default'); +/*!40000 ALTER TABLE `voicemail_conf` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_data` +-- + +DROP TABLE IF EXISTS `voicemail_data`; +CREATE TABLE `voicemail_data` ( + `created_epoch` int(8) default NULL, + `read_epoch` int(8) default NULL, + `user` varchar(255) default NULL, + `domain` varchar(255) default NULL, + `uuid` varchar(255) default NULL, + `cid_name` varchar(255) default NULL, + `cid_number` varchar(255) default NULL, + `in_folder` varchar(255) default NULL, + `file_path` varchar(255) default NULL, + `flags` varchar(255) default NULL, + `read_flags` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `voicemail_data` +-- + +LOCK TABLES `voicemail_data` WRITE; +/*!40000 ALTER TABLE `voicemail_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `voicemail_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_email` +-- + +DROP TABLE IF EXISTS `voicemail_email`; +CREATE TABLE `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; + +-- +-- Dumping data for table `voicemail_email` +-- + +LOCK TABLES `voicemail_email` WRITE; +/*!40000 ALTER TABLE `voicemail_email` DISABLE KEYS */; +INSERT INTO `voicemail_email` VALUES (1,1,'template-file','voicemail.tpl'),(2,1,'date-fmt','%A, %B %d %Y, %I %M %p'),(3,1,'email-from','${voicemail_account}@${voicemail_domain}'); +/*!40000 ALTER TABLE `voicemail_email` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_prefs` +-- + +DROP TABLE IF EXISTS `voicemail_prefs`; +CREATE TABLE `voicemail_prefs` ( + `user` varchar(255) default NULL, + `domain` varchar(255) default NULL, + `name_path` varchar(255) default NULL, + `greeting_path` varchar(255) default NULL +) ENGINE=InnoDB; + +-- +-- Dumping data for table `voicemail_prefs` +-- + +LOCK TABLES `voicemail_prefs` WRITE; +/*!40000 ALTER TABLE `voicemail_prefs` DISABLE KEYS */; +/*!40000 ALTER TABLE `voicemail_prefs` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `voicemail_settings` +-- + +DROP TABLE IF EXISTS `voicemail_settings`; +CREATE TABLE `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; + +-- +-- Dumping data for table `voicemail_settings` +-- + +LOCK TABLES `voicemail_settings` WRITE; +/*!40000 ALTER TABLE `voicemail_settings` DISABLE KEYS */; +INSERT INTO `voicemail_settings` VALUES (1,1,'file-extension','wav'),(2,1,'terminator-key','#'),(3,1,'max-login-attempts','3'),(4,1,'digit-timeout','10000'),(5,1,'max-record-length','300'),(6,1,'tone-spec','%(1000, 0, 640)'),(7,1,'callback-dialplan','XML'),(8,1,'callback-context','default'),(9,1,'play-new-messages-key','1'),(10,1,'play-saved-messages-key','2'),(11,1,'main-menu-key','*'),(12,1,'config-menu-key','5'),(13,1,'record-greeting-key','1'),(14,1,'choose-greeting-key','2'),(15,1,'record-file-key','3'),(16,1,'listen-file-key','1'),(17,1,'record-name-key','3'),(18,1,'save-file-key','9'),(19,1,'delete-file-key','7'),(20,1,'undelete-file-key','8'),(21,1,'email-key','4'),(22,1,'pause-key','0'),(23,1,'restart-key','1'),(24,1,'ff-key','6'),(25,1,'rew-key','4'),(26,1,'record-silence-threshold','200'),(27,1,'record-silence-hits','2'),(28,1,'web-template-file','web-vm.tpl'),(29,1,'operator-extension','operator XML default'),(30,1,'operator-key','9'); +/*!40000 ALTER TABLE `voicemail_settings` ENABLE KEYS */; +UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2008-04-10 15:11:05 Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0.sql ============================================================================== --- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0.sql (original) +++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0.sql Thu Apr 10 11:33:38 2008 @@ -16,6 +16,30 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- +-- Table structure for table `carrier_gateway` +-- + +DROP TABLE IF EXISTS `carrier_gateway`; +CREATE TABLE `carrier_gateway` ( + `id` int(11) NOT NULL auto_increment, + `carrier_id` int(11) default NULL, + `gateway` varchar(32) default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `gateway` (`gateway`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `carriers` +-- + +DROP TABLE IF EXISTS `carriers`; +CREATE TABLE `carriers` ( + `id` int(11) NOT NULL auto_increment, + `Carrier_Name` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -- Table structure for table `conference_advertise` -- @@ -66,7 +90,7 @@ `realm` varchar(255) default NULL, `data_key` varchar(255) default NULL, `data` varchar(255) default NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB; -- -- Table structure for table `dialplan` @@ -86,10 +110,21 @@ `ext_continue` smallint(1) NOT NULL default '0', `global_weight` int(11) NOT NULL default '10000', `cond_break` varchar(8) default NULL, - `app_cdata` tinyint(1) NOT NULL default '0', - `re_cdata` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=386 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `dialplan_special` +-- + +DROP TABLE IF EXISTS `dialplan_special`; +CREATE TABLE `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; -- -- Table structure for table `dingaling_profile_params` @@ -143,7 +178,18 @@ `mailbox` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `directory_domains` +-- + +DROP TABLE IF EXISTS `directory_domains`; +CREATE TABLE `directory_domains` ( + `id` int(10) unsigned NOT NULL auto_increment, + `domain_name` varchar(128) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `directory_gateway_params` @@ -172,6 +218,32 @@ ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- +-- Table structure for table `directory_global_params` +-- + +DROP TABLE IF EXISTS `directory_global_params`; +CREATE TABLE `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; + +-- +-- Table structure for table `directory_global_vars` +-- + +DROP TABLE IF EXISTS `directory_global_vars`; +CREATE TABLE `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; + +-- -- Table structure for table `directory_params` -- @@ -195,7 +267,7 @@ `var_name` varchar(255) default NULL, `var_value` varchar(255) default NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `group_data` @@ -206,7 +278,7 @@ `hostname` varchar(255) default NULL, `groupname` varchar(255) default NULL, `url` varchar(255) default NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB; -- -- Table structure for table `iax_conf` @@ -277,7 +349,24 @@ `sub_to` varchar(255) default NULL, `show_pres` varchar(255) default NULL, `status` varchar(255) default NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB; + +-- +-- Table structure for table `lcr` +-- + +DROP TABLE IF EXISTS `lcr`; +CREATE TABLE `lcr` ( + `id` int(11) NOT NULL auto_increment, + `digits` varchar(15) default NULL, + `rate` int(11) NOT NULL, + `carrier_id` int(11) NOT NULL, + `lead_strip` int(11) NOT NULL, + `trail_strip` int(11) NOT NULL, + `prefix` varchar(16) NOT NULL, + `suffix` varchar(16) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB; -- -- Table structure for table `limit_conf` @@ -289,7 +378,7 @@ `name` varchar(255) default NULL, `value` varchar(255) default NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `limit_data` @@ -344,7 +433,7 @@ `description` text, `priority` int(11) NOT NULL default '1000', PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `sip_authentication` @@ -354,7 +443,7 @@ CREATE TABLE `sip_authentication` ( `nonce` varchar(255) default NULL, `expires` int(8) default NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB; -- -- Table structure for table `sip_dialogs` @@ -504,7 +593,7 @@ `file_path` varchar(255) default NULL, `flags` varchar(255) default NULL, `read_flags` varchar(255) default NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB; -- -- Table structure for table `voicemail_email` @@ -530,7 +619,7 @@ `domain` varchar(255) default NULL, `name_path` varchar(255) default NULL, `greeting_path` varchar(255) default NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB; -- -- Table structure for table `voicemail_settings` @@ -554,4 +643,4 @@ /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2008-03-05 1:16:13 +-- Dump completed on 2008-04-10 15:11:05

1 0

[commit] r8081 - in freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl: . dialplans
by Freeswitch SVN 10 Apr '08

10 Apr '08

Author: intralanman Date: Thu Apr 10 03:53:56 2008 New Revision: 8081 Added: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/dialplans/ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/dialplans/lcr.php Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_dialplan.php freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_directory.php Log: fixed a small bug in the directory (thanks to jdjurici) added a bit of logic to allow implementors to use custom php scripts for certain contexts and added a quick n dirty lcr for a sample. will commit the schema changes later.... must sleep now. Added: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/dialplans/lcr.php ============================================================================== --- (empty file) +++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/dialplans/lcr.php Thu Apr 10 03:53:56 2008 @@ -0,0 +1,73 @@ +<?php + +class dialplan_lcr { + + function main(&$obj) { + $obj -> xmlw -> startElement('section'); + $obj -> xmlw -> writeAttribute('name', 'dialplan'); + $obj -> xmlw -> writeAttribute('description', 'FreeSWITCH Dialplan'); + $obj -> xmlw -> startElement('context'); + $obj -> xmlw -> writeAttribute('name', 'lcr'); + $obj -> xmlw -> startElement('extension'); + $obj -> xmlw -> startElement('condition'); + $applications = $this -> lcr_lookup($obj); + $app_count = count($applications); + + $sets = array( + 'hangup_after_bridge'=>'true', + 'continue_on_failure'=>'true' + ); + foreach ($sets as $var=>$val) { + $this -> xmlw -> startElement('action'); + $this -> xmlw -> writeAttribute('application', 'set'); + $this -> xmlw -> writeAttribute('data', "$var=$val"); + $this -> xmlw -> endElement(); + } + for ($i=0; $i<$app_count; $i++) { + $obj -> xmlw -> startElement($applications[$i]['type']); + $obj -> xmlw -> writeAttribute('application', 'bridge'); + $obj -> xmlw -> writeAttribute('data', $applications[$i]['data']); + $obj -> xmlw -> endElement(); + } + $obj -> xmlw -> endElement(); //</condition> + $obj -> xmlw -> endElement(); //</extension> + $obj -> xmlw -> endElement(); //</context> + $obj -> xmlw -> endElement(); //</section> + + } + + function lcr_lookup(&$obj) { + $obj -> comment_array($obj -> request); + $digitstr = $obj -> request['destination_number']; + $digitlen = strlen($digitstr); + $where_clause = ''; + for ($i=0; $i<$digitlen; $i++) { + $where_clause .= sprintf("%s digits='%s' " + , ($i==0?"WHERE":"OR") + , substr($digitstr, 0, $i+1) + ); + } + $query = sprintf("SELECT l.digits, c.Carrier_Name, l.rate, cg.id, cg.gateway, cg.id AS gwid, l.lead_strip, l.trail_strip, l.prefix, l.suffix FROM lcr l JOIN carriers c ON l.carrier_id=c.id JOIN carrier_gateway cg ON c.id=cg.carrier_id %s ORDER BY length(digits) DESC, rate;", $where_clause); + $res = $obj -> db -> query($query); + $obj -> comment($query); + if (MDB2::isError($res)) { + $obj -> comment($query); + $obj -> comment($res -> getMessage()); + $obj -> file_not_found(); + } + $carriers = array(); + while ($row = $res -> fetchRow()) { + $carrier_id = $row['gwid']; + if (array_key_exists($carrier_id, $carriers)) { + continue; + } + $carriers[$carrier_id] = true; + $datastr = sprintf('sofia/gateway/%s/%s', $row['gateway'], $digitstr); + $results[] = array('type'=>'action', 'data'=>$datastr); + } + return $results; + } +} + + +?> \ No newline at end of file Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_dialplan.php ============================================================================== --- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_dialplan.php (original) +++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_dialplan.php Thu Apr 10 03:53:56 2008 @@ -18,18 +18,63 @@ * Class for XML dialplan */ class fs_dialplan extends fs_curl { + private $special_class_file; + public function fs_dialplan() { $this -> fs_curl(); } + /** + * This is the method that determines the XML output. Customized dialplans can + * be easily created by adding a record to the dialplan_special table with the + * appropriate values. The php class MUST contain a "main()" method. The method + * should write directly to the xmlw obj that's pased or take care of writing + * out the xml itself and exiting as to not return. + * + */ public function main() { $this -> comment($this -> request); $context = $this -> request['Caller-Context']; - $dp_array = $this -> get_dialplan($context); - $this -> writeDialplan($dp_array); + if ($this -> is_specialized_dialplan($context)) { + if (!include_once($this -> special_class_file)) { + $this -> file_not_found(); + } + $class = sprintf('dialplan_%s', $context); + if (!class_exists($class)) { + $this -> comment("No Class of name $class"); + $this -> file_not_found(); + } + $obj = new $class; + /** + * recieving method should take incoming parameter as &$something + */ + $obj -> main($this); + } else { + $dp_array = $this -> get_dialplan($context); + $this -> writeDialplan($dp_array); + } $this -> output_xml(); } + public function is_specialized_dialplan($context) { + $query = sprintf( + "SELECT * FROM dialplan_special WHERE context='%s'", $context + ); + $res = $this -> db -> query($query); + if (MDB2::isError($res)) { + $this -> comment($query); + $this -> comment($res -> getMessage()); + $this -> file_not_found(); + } + if ($res -> numRows() == 1) { + $row = $res -> fetchRow(); + $this -> special_class_file = $row['class_file']; + return true; + } else { + return false; + } + } + /** * This method will pull dialplan from database * Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_directory.php ============================================================================== --- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_directory.php (original) +++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_directory.php Thu Apr 10 03:53:56 2008 @@ -196,7 +196,7 @@ if (MDB2::isError($res)) { $this -> comment($query); $error_msg = sprintf("Error while selecting global params - %s" - , $this -> db -> getMessage() + , $res -> getMessage() ); trigger_error($error_msg); } @@ -225,7 +225,7 @@ if (MDB2::isError($res)) { $this -> comment($query); $error_msg = sprintf("Error while selecting global vars - %s" - , $this -> db -> getMessage() + , $res -> getMessage() ); trigger_error($error_msg); }

1 0

[commit] r8080 - in freeswitch/trunk/src: . mod/asr_tts/mod_openmrcp
by Freeswitch SVN 10 Apr '08

10 Apr '08

Author: mikej Date: Thu Apr 10 03:37:42 2008 New Revision: 8080 Modified: freeswitch/trunk/src/mod/asr_tts/mod_openmrcp/mod_openmrcp.vcproj freeswitch/trunk/src/switch_ivr_play_say.c Log: msvc build fixes Modified: freeswitch/trunk/src/mod/asr_tts/mod_openmrcp/mod_openmrcp.vcproj ============================================================================== --- freeswitch/trunk/src/mod/asr_tts/mod_openmrcp/mod_openmrcp.vcproj (original) +++ freeswitch/trunk/src/mod/asr_tts/mod_openmrcp/mod_openmrcp.vcproj Thu Apr 10 03:37:42 2008 @@ -22,15 +22,63 @@ CharacterSet="2" > <Tool + Name="VCPreBuildEventTool" + /> + <Tool + Name="VCCustomBuildTool" + /> + <Tool + Name="VCXMLDataGeneratorTool" + /> + <Tool + Name="VCWebServiceProxyGeneratorTool" + /> + <Tool + Name="VCMIDLTool" + /> + <Tool Name="VCCLCompilerTool" - AdditionalIncludeDirectories=""$(InputDir)..\..\..\..\libs\openmrcp\platform\openmrcpclient\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\client\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\parser\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\media\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\resource\include";"$(InputDir)..\..\..\..\libs\openmrcp\mediaframe\include";"$(InputDir)..\..\..\..\libs\openmrcp\aprtoolkit\include";"$(InputDir)..\..\..\..\libs\apr\include"" + AdditionalIncludeDirectories=""$(InputDir)..\..\..\..\libs\openmrcp\platform\libopenmrcpclient\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\client\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\parser\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\media\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\resource\include";"$(InputDir)..\..\..\..\libs\openmrcp\mediaframe\include";"$(InputDir)..\..\..\..\libs\openmrcp\aprtoolkit\include";"$(InputDir)..\..\..\..\libs\apr\include"" UsePrecompiledHeader="0" /> <Tool + Name="VCManagedResourceCompilerTool" + /> + <Tool + Name="VCResourceCompilerTool" + /> + <Tool + Name="VCPreLinkEventTool" + /> + <Tool Name="VCLinkerTool" AdditionalDependencies="ws2_32.lib advapi32.lib iphlpapi.lib" AdditionalLibraryDirectories=""C:\Program Files\openmrcp\sdk\lib\winnt"" /> + <Tool + Name="VCALinkTool" + /> + <Tool + Name="VCManifestTool" + /> + <Tool + Name="VCXDCMakeTool" + /> + <Tool + Name="VCBscMakeTool" + /> + <Tool + Name="VCFxCopTool" + /> + <Tool + Name="VCAppVerifierTool" + /> + <Tool + Name="VCWebDeploymentTool" + /> + <Tool + Name="VCPostBuildEventTool" + /> </Configuration> <Configuration Name="Release|Win32" @@ -39,15 +87,63 @@ CharacterSet="2" > <Tool + Name="VCPreBuildEventTool" + /> + <Tool + Name="VCCustomBuildTool" + /> + <Tool + Name="VCXMLDataGeneratorTool" + /> + <Tool + Name="VCWebServiceProxyGeneratorTool" + /> + <Tool + Name="VCMIDLTool" + /> + <Tool Name="VCCLCompilerTool" - AdditionalIncludeDirectories=""$(InputDir)..\..\..\..\libs\openmrcp\platform\openmrcpclient\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\client\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\parser\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\media\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\resource\include";"$(InputDir)..\..\..\..\libs\openmrcp\mediaframe\include";"$(InputDir)..\..\..\..\libs\openmrcp\aprtoolkit\include";"$(InputDir)..\..\..\..\libs\apr\include"" + AdditionalIncludeDirectories=""$(InputDir)..\..\..\..\libs\openmrcp\platform\libopenmrcpclient\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\client\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\parser\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\media\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\resource\include";"$(InputDir)..\..\..\..\libs\openmrcp\mediaframe\include";"$(InputDir)..\..\..\..\libs\openmrcp\aprtoolkit\include";"$(InputDir)..\..\..\..\libs\apr\include"" UsePrecompiledHeader="0" /> <Tool + Name="VCManagedResourceCompilerTool" + /> + <Tool + Name="VCResourceCompilerTool" + /> + <Tool + Name="VCPreLinkEventTool" + /> + <Tool Name="VCLinkerTool" AdditionalDependencies="ws2_32.lib advapi32.lib iphlpapi.lib" AdditionalLibraryDirectories=""C:\Program Files\openmrcp\sdk\lib\winnt"" /> + <Tool + Name="VCALinkTool" + /> + <Tool + Name="VCManifestTool" + /> + <Tool + Name="VCXDCMakeTool" + /> + <Tool + Name="VCBscMakeTool" + /> + <Tool + Name="VCFxCopTool" + /> + <Tool + Name="VCAppVerifierTool" + /> + <Tool + Name="VCWebDeploymentTool" + /> + <Tool + Name="VCPostBuildEventTool" + /> </Configuration> <Configuration Name="Debug Static|Win32" @@ -56,15 +152,63 @@ CharacterSet="2" > <Tool + Name="VCPreBuildEventTool" + /> + <Tool + Name="VCCustomBuildTool" + /> + <Tool + Name="VCXMLDataGeneratorTool" + /> + <Tool + Name="VCWebServiceProxyGeneratorTool" + /> + <Tool + Name="VCMIDLTool" + /> + <Tool Name="VCCLCompilerTool" - AdditionalIncludeDirectories=""$(InputDir)..\..\..\..\libs\openmrcp\platform\openmrcpclient\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\client\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\parser\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\media\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\resource\include";"$(InputDir)..\..\..\..\libs\openmrcp\mediaframe\include";"$(InputDir)..\..\..\..\libs\openmrcp\aprtoolkit\include";"$(InputDir)..\..\..\..\libs\apr\include"" + AdditionalIncludeDirectories=""$(InputDir)..\..\..\..\libs\openmrcp\platform\libopenmrcpclient\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\client\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\parser\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\media\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\resource\include";"$(InputDir)..\..\..\..\libs\openmrcp\mediaframe\include";"$(InputDir)..\..\..\..\libs\openmrcp\aprtoolkit\include";"$(InputDir)..\..\..\..\libs\apr\include"" UsePrecompiledHeader="0" /> <Tool + Name="VCManagedResourceCompilerTool" + /> + <Tool + Name="VCResourceCompilerTool" + /> + <Tool + Name="VCPreLinkEventTool" + /> + <Tool Name="VCLinkerTool" AdditionalDependencies="ws2_32.lib advapi32.lib iphlpapi.lib" AdditionalLibraryDirectories=""C:\Program Files\openmrcp\sdk\lib\winnt"" /> + <Tool + Name="VCALinkTool" + /> + <Tool + Name="VCManifestTool" + /> + <Tool + Name="VCXDCMakeTool" + /> + <Tool + Name="VCBscMakeTool" + /> + <Tool + Name="VCFxCopTool" + /> + <Tool + Name="VCAppVerifierTool" + /> + <Tool + Name="VCWebDeploymentTool" + /> + <Tool + Name="VCPostBuildEventTool" + /> </Configuration> <Configuration Name="Release Static|Win32" @@ -73,15 +217,63 @@ CharacterSet="2" > <Tool + Name="VCPreBuildEventTool" + /> + <Tool + Name="VCCustomBuildTool" + /> + <Tool + Name="VCXMLDataGeneratorTool" + /> + <Tool + Name="VCWebServiceProxyGeneratorTool" + /> + <Tool + Name="VCMIDLTool" + /> + <Tool Name="VCCLCompilerTool" - AdditionalIncludeDirectories=""$(InputDir)..\..\..\..\libs\openmrcp\platform\openmrcpclient\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\client\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\parser\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\media\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\resource\include";"$(InputDir)..\..\..\..\libs\openmrcp\mediaframe\include";"$(InputDir)..\..\..\..\libs\openmrcp\aprtoolkit\include";"$(InputDir)..\..\..\..\libs\apr\include"" + AdditionalIncludeDirectories=""$(InputDir)..\..\..\..\libs\openmrcp\platform\libopenmrcpclient\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\client\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\parser\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\media\include";"$(InputDir)..\..\..\..\libs\openmrcp\mrcpcore\resource\include";"$(InputDir)..\..\..\..\libs\openmrcp\mediaframe\include";"$(InputDir)..\..\..\..\libs\openmrcp\aprtoolkit\include";"$(InputDir)..\..\..\..\libs\apr\include"" UsePrecompiledHeader="0" /> <Tool + Name="VCManagedResourceCompilerTool" + /> + <Tool + Name="VCResourceCompilerTool" + /> + <Tool + Name="VCPreLinkEventTool" + /> + <Tool Name="VCLinkerTool" AdditionalDependencies="ws2_32.lib advapi32.lib iphlpapi.lib" AdditionalLibraryDirectories=""C:\Program Files\openmrcp\sdk\lib\winnt"" /> + <Tool + Name="VCALinkTool" + /> + <Tool + Name="VCManifestTool" + /> + <Tool + Name="VCXDCMakeTool" + /> + <Tool + Name="VCBscMakeTool" + /> + <Tool + Name="VCFxCopTool" + /> + <Tool + Name="VCAppVerifierTool" + /> + <Tool + Name="VCWebDeploymentTool" + /> + <Tool + Name="VCPostBuildEventTool" + /> </Configuration> </Configurations> <References> Modified: freeswitch/trunk/src/switch_ivr_play_say.c ============================================================================== --- freeswitch/trunk/src/switch_ivr_play_say.c (original) +++ freeswitch/trunk/src/switch_ivr_play_say.c Thu Apr 10 03:37:42 2008 @@ -1776,7 +1776,7 @@ switch_input_args_t args = { 0 }; args.input_callback = hold_on_dtmf; args.buf = (void *) unhold_key; - args.buflen = strlen(unhold_key); + args.buflen = (uint32_t)strlen(unhold_key); switch_assert(session != NULL); channel = switch_core_session_get_channel(session);

1 0