Modified: freeswitch/trunk/src/mod/applications/mod_commands/mod_commands.c (15841 => 15842)
--- freeswitch/trunk/src/mod/applications/mod_commands/mod_commands.c 2009-12-08 07:20:58 UTC (rev 15841)
+++ freeswitch/trunk/src/mod/applications/mod_commands/mod_commands.c 2009-12-08 16:37:48 UTC (rev 15842)
@@ -3012,24 +3012,24 @@
if (end_of(command) == 's') {
end_of(command) = '\0';
}
- sprintf(sql, "select type, name, key from interfaces where type = '%s' order by type,name", command);
+ sprintf(sql, "select type, name, ikey from interfaces where type = '%s' order by type,name", command);
} else if (!strncasecmp(command, "module", 6)) {
if (argv[1]) {
- sprintf(sql, "select distinct type, name, key, filename from interfaces where key = '%s' order by type,name", argv[1]);
+ sprintf(sql, "select distinct type, name, ikey, filename from interfaces where key = '%s' order by type,name", argv[1]);
} else {
- sprintf(sql, "select distinct type, name, key, filename from interfaces order by type,name");
+ sprintf(sql, "select distinct type, name, ikey, filename from interfaces order by type,name");
}
} else if (!strcasecmp(command, "interfaces")) {
- sprintf(sql, "select type, name, key from interfaces order by type,name");
+ sprintf(sql, "select type, name, ikey from interfaces order by type,name");
} else if (!strcasecmp(command, "interface_types")) {
sprintf(sql, "select type,count(type) as total from interfaces group by type order by type");
} else if (!strcasecmp(command, "tasks")) {
sprintf(sql, "select * from %s", command);
} else if (!strcasecmp(command, "application") || !strcasecmp(command, "api")) {
if (argv[1] && strcasecmp(argv[1], "as")) {
- sprintf(sql, "select name, description, syntax, key from interfaces where type = '%s' and description != '' and name = '%s' order by type,name", command, argv[1]);
+ sprintf(sql, "select name, description, syntax, ikey from interfaces where type = '%s' and description != '' and name = '%s' order by type,name", command, argv[1]);
} else {
- sprintf(sql, "select name, description, syntax, key from interfaces where type = '%s' and description != '' order by type,name", command);
+ sprintf(sql, "select name, description, syntax, ikey from interfaces where type = '%s' and description != '' order by type,name", command);
}
} else if (!strcasecmp(command, "calls")) {
sprintf(sql, "select * from calls order by call_created_epoch");
@@ -3087,10 +3087,10 @@
holder.print_title = 0;
if ((cmdname = strchr(command, ' ')) && strcasecmp(cmdname, "as")) {
*cmdname++ = '\0';
- switch_snprintf(sql, sizeof(sql) - 1, "select name, syntax, description, key from interfaces where type = 'api' and name = '%s' order by name",
+ switch_snprintf(sql, sizeof(sql) - 1, "select name, syntax, description, ikey from interfaces where type = 'api' and name = '%s' order by name",
cmdname);
} else {
- switch_snprintf(sql, sizeof(sql) - 1, "select name, syntax, description, key from interfaces where type = 'api' order by name");
+ switch_snprintf(sql, sizeof(sql) - 1, "select name, syntax, description, ikey from interfaces where type = 'api' order by name");
}
} else if (!strcasecmp(command, "nat_map")) {
switch_snprintf(sql, sizeof(sql) - 1,
Modified: freeswitch/trunk/src/switch_core_sqldb.c (15841 => 15842)
--- freeswitch/trunk/src/switch_core_sqldb.c 2009-12-08 07:20:58 UTC (rev 15841)
+++ freeswitch/trunk/src/switch_core_sqldb.c 2009-12-08 16:37:48 UTC (rev 15842)
@@ -1067,7 +1067,7 @@
const char *filename = switch_event_get_header_nil(event, "filename");
if (!zstr(type) && !zstr(name)) {
sql =
- switch_mprintf("insert into interfaces (type,name,description,syntax,key,filename,hostname) values('%q','%q','%q','%q','%q','%q','%q')",
+ switch_mprintf("insert into interfaces (type,name,description,syntax,ikey,filename,hostname) values('%q','%q','%q','%q','%q','%q','%q')",
type, name, switch_str_nil(description), switch_str_nil(syntax),
switch_str_nil(key), switch_str_nil(filename), switch_core_get_variable("hostname")
);
@@ -1211,7 +1211,7 @@
" type VARCHAR(4096),\n"
" name VARCHAR(4096),\n"
" description VARCHAR(4096),\n"
- " key VARCHAR(4096),\n"
+ " ikey VARCHAR(4096),\n"
" filename VARCHAR(4096),\n"
" syntax VARCHAR(4096),\n"
" hostname VARCHAR(4096)\n"
@@ -1307,7 +1307,7 @@
char *err;
switch_cache_db_test_reactive(dbh, "select hostname from channels", "DROP TABLE channels", create_channels_sql);
switch_cache_db_test_reactive(dbh, "select hostname from calls", "DROP TABLE calls", create_calls_sql);
- switch_cache_db_test_reactive(dbh, "select hostname from interfaces", "DROP TABLE interfaces", create_interfaces_sql);
+ switch_cache_db_test_reactive(dbh, "select ikey from interfaces", "DROP TABLE interfaces", create_interfaces_sql);
switch_cache_db_test_reactive(dbh, "select hostname from tasks", "DROP TABLE tasks", create_tasks_sql);
switch_cache_db_execute_sql(dbh, "begin;delete from channels where hostname='';delete from channels where hostname='';commit;", &err);