[Freeswitch-svn] [commit] r12661 - freeswitch/trunk/scripts/contrib/swk/php/esl_cdr
FreeSWITCH SVN
silik0n at freeswitch.org
Wed Mar 18 16:39:48 PDT 2009
Author: silik0n
Date: Wed Mar 18 18:39:48 2009
New Revision: 12661
Log:
mysql schema for this script
Added:
freeswitch/trunk/scripts/contrib/swk/php/esl_cdr/esl_cdr.mysql.sql
Added: freeswitch/trunk/scripts/contrib/swk/php/esl_cdr/esl_cdr.mysql.sql
==============================================================================
--- (empty file)
+++ freeswitch/trunk/scripts/contrib/swk/php/esl_cdr/esl_cdr.mysql.sql Wed Mar 18 18:39:48 2009
@@ -0,0 +1,33 @@
+CREATE TABLE IF NOT EXISTS `cdr` (
+ `uuid` varchar(100) NOT NULL,
+ `acctcode` varchar(100) NOT NULL,
+ `ani` varchar(100) NOT NULL,
+ `e164_ani` varchar(100) NOT NULL,
+ `dnis` varchar(100) NOT NULL,
+ `e164_dnis` varchar(100) NOT NULL,
+ `translated_dnis` varchar(100) NOT NULL,
+ `src_host` varchar(100) NOT NULL,
+ `read_codec` varchar(100) NOT NULL,
+ `write_codec` varchar(100) NOT NULL,
+ `clid_name` varchar(100) NOT NULL,
+ `clid_number` varchar(100) NOT NULL,
+ `src_sdp` varchar(100) NOT NULL,
+ `dest_sdp` varchar(100) NOT NULL,
+ `originate_disposition` varchar(100) NOT NULL,
+ `bridge_to_uuid` varchar(100) NOT NULL,
+ `endpoint_disposition` varchar(100) NOT NULL,
+ `sip_hangup_disposition` varchar(100) NOT NULL,
+ `term_cause` varchar(100) NOT NULL,
+ `hangup_cause` varchar(100) NOT NULL,
+ `start_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `answer_stamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `progress_media_stamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `end_stamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `duration` int(11) NOT NULL,
+ `billsec` int(11) NOT NULL,
+ `progress_mediasec` int(11) NOT NULL,
+ `billmin` varchar(100) NOT NULL,
+ `carrier_id` varchar(100) NOT NULL,
+ `cust_cost` varchar(100) NOT NULL,
+ `carrier_cost` varchar(100) NOT NULL
+)
More information about the Freeswitch-svn
mailing list