diff options
author | markster <markster@f38db490-d61c-443f-a65b-d21fe96a405b> | 2003-07-18 05:38:11 +0000 |
---|---|---|
committer | markster <markster@f38db490-d61c-443f-a65b-d21fe96a405b> | 2003-07-18 05:38:11 +0000 |
commit | 47386acd8ef9657a88284b2a5690b9f7bd717d96 (patch) | |
tree | e755b1a7e87bec285fe450d58da0eaf5354d7538 | |
parent | 12c9c895c5fbae01dcf8193e06aa733c9ecf4e81 (diff) |
optionally log uniqueid as well
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@1198 f38db490-d61c-443f-a65b-d21fe96a405b
-rwxr-xr-x | cdr/cdr_mysql.c | 5 | ||||
-rwxr-xr-x | doc/cdr_mysql.txt | 3 |
2 files changed, 6 insertions, 2 deletions
diff --git a/cdr/cdr_mysql.c b/cdr/cdr_mysql.c index 9d8ff3f43..ccdfc163c 100755 --- a/cdr/cdr_mysql.c +++ b/cdr/cdr_mysql.c @@ -56,8 +56,11 @@ static int mysql_log(struct ast_cdr *cdr) ast_log(LOG_DEBUG,"cdr_mysql: inserting a CDR record.\n"); +#ifdef MYSQL_LOGUNIQUEID + sprintf(sqlcmd,"INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid) VALUES ('%s','%s','%s','%s','%s', '%s','%s','%s','%s',%i,%i,%i,%i,'%s','%s')",timestr,cdr->clid,cdr->src, cdr->dst, cdr->dcontext,cdr->channel, cdr->dstchannel, cdr->lastapp, cdr->lastdata,cdr->duration,cdr->billsec,cdr->disposition,cdr->amaflags, cdr->accountcode, cdr->uniqueid); +#else sprintf(sqlcmd,"INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES ('%s','%s','%s','%s','%s', '%s','%s','%s','%s',%i,%i,%i,%i,'%s')",timestr,cdr->clid,cdr->src, cdr->dst, cdr->dcontext,cdr->channel, cdr->dstchannel, cdr->lastapp, cdr->lastdata,cdr->duration,cdr->billsec,cdr->disposition,cdr->amaflags, cdr->accountcode); - +#endif ast_log(LOG_DEBUG,"cdr_mysql: SQL command as follows: %s\n",sqlcmd); if (mysql_real_query(mysql,sqlcmd,strlen(sqlcmd))) diff --git a/doc/cdr_mysql.txt b/doc/cdr_mysql.txt index 9127c2f2b..45195030c 100755 --- a/doc/cdr_mysql.txt +++ b/doc/cdr_mysql.txt @@ -22,7 +22,8 @@ CREATE TABLE cdr ( billsec int(11) NOT NULL default '0', disposition int(11) NOT NULL default '0', amaflags int(11) NOT NULL default '0', - accountcode varchar(45) NOT NULL default '' + accountcode varchar(45) NOT NULL default '', + uniqueid varchar(45) NOT NULL default '' ); The calls will automatically be logged as long as the module is loaded. |