From e92a909196bddb11d72f122bc0537585972cd90e Mon Sep 17 00:00:00 2001 From: markster Date: Fri, 28 Jun 2002 15:15:11 +0000 Subject: Version 0.1.12 from FTP git-svn-id: http://svn.digium.com/svn/asterisk/trunk@469 f38db490-d61c-443f-a65b-d21fe96a405b --- doc/cdr_mysql.txt | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100755 doc/cdr_mysql.txt (limited to 'doc/cdr_mysql.txt') diff --git a/doc/cdr_mysql.txt b/doc/cdr_mysql.txt new file mode 100755 index 000000000..9127c2f2b --- /dev/null +++ b/doc/cdr_mysql.txt @@ -0,0 +1,28 @@ +Call Detail Recording for MySQL +=============================== + +Usage: +====== + +Include the module in your modules.conf. Change the database hostname, database name, username, and password in cdr_mysql.conf. + +Create a table called cdr under the database name you will be using the following schema. + +CREATE TABLE cdr ( + calldate datetime NOT NULL default '0000-00-00 00:00:00', + clid varchar(45) NOT NULL default '', + src varchar(45) NOT NULL default '', + dst varchar(45) NOT NULL default '', + dcontext varchar(45) NOT NULL default '', + channel varchar(45) NOT NULL default '', + dstchannel varchar(45) NOT NULL default '', + lastapp varchar(45) NOT NULL default '', + lastdata varchar(45) NOT NULL default '', + duration int(11) NOT NULL default '0', + 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 '' +); + +The calls will automatically be logged as long as the module is loaded. -- cgit v1.2.3