diff options
Diffstat (limited to 'doc/cdr_mysql.txt')
-rwxr-xr-x | doc/cdr_mysql.txt | 28 |
1 files changed, 28 insertions, 0 deletions
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. |