aboutsummaryrefslogtreecommitdiffstats
path: root/doc
diff options
context:
space:
mode:
authormarkster <markster@f38db490-d61c-443f-a65b-d21fe96a405b>2002-06-28 15:15:11 +0000
committermarkster <markster@f38db490-d61c-443f-a65b-d21fe96a405b>2002-06-28 15:15:11 +0000
commite92a909196bddb11d72f122bc0537585972cd90e (patch)
tree24815e270c97ccf4292b2e9716311cf353d963c0 /doc
parentf2a9ecd09326d891bf547b8ce0354dd47de356e2 (diff)
Version 0.1.12 from FTP
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@469 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'doc')
-rwxr-xr-xdoc/cdr_mysql.txt28
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.