[Astpp-commit] SF.net SVN: astpp:[2282] trunk

Revision: 2282
          http://astpp.svn.sourceforge.net/astpp/?rev=2282&view=rev
Author:   darrenkw
Date:     2009-10-06 03:56:05 +0000 (Tue, 06 Oct 2009)

Log Message:
-----------
Start adding support to be able to link the A and B legs of calls in Freeswitch.

Modified Paths:
--------------
    trunk/freeswitch/astpp-fs-xml.pl

Added Paths:
-----------
    trunk/sql/cdrdb-2009-10-05.sql

Modified: trunk/freeswitch/astpp-fs-xml.pl
===================================================================
--- trunk/freeswitch/astpp-fs-xml.pl	2009-10-06 03:54:35 UTC (rev 2281)
+++ trunk/freeswitch/astpp-fs-xml.pl	2009-10-06 03:56:05 UTC (rev 2282)
@@ -322,7 +322,7 @@
 
 
 my $tmp = "INSERT INTO " . $config->{freeswitch_cdr_table} . "(accountcode,src,dst,dcontext,clid,channel,dstchannel,lastapp,"
-	. "lastdata,calldate,answerdate,enddate,duration,billsec,disposition,amaflags,uniqueid,userfield,read_codec,"
+	. "lastdata,calldate,answerdate,enddate,duration,billsec,disposition,amaflags,uniqueid,originator,userfield,read_codec,"
 	. "write_codec,cost,vendor,provider,trunk,outbound_route,progressmsec,answermsec,progress_mediamsec) VALUES ("
 	. "'"
 	. $data->{variables}->{accountcode}
@@ -388,6 +388,10 @@
 	. $data->{callflow}->{caller_profile}->{uuid}
 	. "'"
 	. ","
+	. "'"
+	. $data->{variables}->{originator}
+	. "'"
+	. ","
 	. "''"
 	. ","
 	. "'" . $data->{variables}->{read_code} . "'"

Added: trunk/sql/cdrdb-2009-10-05.sql
===================================================================
--- trunk/sql/cdrdb-2009-10-05.sql	                        (rev 0)
+++ trunk/sql/cdrdb-2009-10-05.sql	2009-10-06 03:56:05 UTC (rev 2282)
@@ -0,0 +1,70 @@
+--
+-- Table structure for table `cdr`
+--
+
+DROP TABLE IF EXISTS `cdr`;
+CREATE TABLE `cdr` (
+  `calldate` datetime NOT NULL default '0000-00-00 00:00:00',
+  `clid` varchar(80) NOT NULL default '',
+  `src` varchar(80) NOT NULL default '',
+  `dst` varchar(80) NOT NULL default '',
+  `dcontext` varchar(80) NOT NULL default '',
+  `channel` varchar(80) NOT NULL default '',
+  `dstchannel` varchar(80) NOT NULL default '',
+  `lastapp` varchar(80) NOT NULL default '',
+  `lastdata` varchar(80) NOT NULL default '',
+  `duration` int(11) NOT NULL default '0',
+  `billsec` int(11) NOT NULL default '0',
+  `disposition` varchar(45) NOT NULL default '',
+  `amaflags` int(11) NOT NULL default '0',
+  `accountcode` varchar(20) NOT NULL default '',
+  `uniqueid` varchar(32) NOT NULL default '',
+  `userfield` varchar(255) NOT NULL default '',
+  `cost` varchar(20) NOT NULL default 'none',
+  `vendor` varchar(20) NOT NULL default 'none',
+  KEY `calldate` (`calldate`),
+  KEY `dst` (`dst`),
+  KEY `accountcode` (`accountcode`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+
+--
+-- Table structure for table `fscdr`
+--
+
+DROP TABLE IF EXISTS `fscdr`;
+CREATE TABLE IF NOT EXISTS `fscdr` (
+  `accountcode` varchar(20) NOT NULL default '',
+  `src` varchar(80) NOT NULL default '',
+  `dst` varchar(80) NOT NULL default '',
+  `dcontext` varchar(80) NOT NULL default '',
+  `clid` varchar(80) NOT NULL default '',
+  `channel` varchar(80) NOT NULL default '',
+  `dstchannel` varchar(80) NOT NULL default '',
+  `lastapp` varchar(80) NOT NULL default '',
+  `lastdata` varchar(80) NOT NULL default '',
+  `calldate` datetime NOT NULL default '0000-00-00 00:00:00',
+  `answerdate` datetime NOT NULL default '0000-00-00 00:00:00',
+  `enddate` datetime NOT NULL default '0000-00-00 00:00:00',
+  `duration` int(11) NOT NULL default '0',
+  `billsec` int(11) NOT NULL default '0',
+  `disposition` varchar(45) NOT NULL default '',
+  `amaflags` int(11) NOT NULL default '0',
+  `uniqueid` varchar(60) NOT NULL,
+  `originator` varchar(60),
+  `userfield` varchar(255) NOT NULL default '',
+  `read_codec` varchar(60) NOT NULL default '',
+  `write_codec` varchar(60) NOT NULL default '',
+  `cost` varchar(20) NOT NULL default 'none',
+  `vendor` varchar(20) NOT NULL default 'none',
+  `provider` varchar(60) NOT NULL,
+  `trunk` varchar(60) NOT NULL,
+  `outbound_route` varchar(60) NOT NULL,
+  `progressmsec` varchar(20) NOT NULL,
+  `answermsec` varchar(20) NOT NULL,
+  `progress_mediamsec` varchar(20) NOT NULL,
+  KEY `calldate` (`calldate`),
+  KEY `dst` (`dst`),
+  KEY `accountcode` (`accountcode`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.