[Freeswitch-trunk] [commit] r6753 - freeswitch/trunk/scripts

[Freeswitch SVN]

Author: brian
Date: Thu Dec 13 12:15:31 2007
New Revision: 6753

Added:
   freeswitch/trunk/scripts/cdr.sql

Log:
adding sql schema

Added: freeswitch/trunk/scripts/cdr.sql
==============================================================================
--- (empty file)
+++ freeswitch/trunk/scripts/cdr.sql	Thu Dec 13 12:15:31 2007
@@ -0,0 +1,18 @@
+CREATE TABLE `cdr` ( 
+`caller_id_name` varchar(80) NOT NULL default '', 
+`caller_id_number` varchar(80) NOT NULL default '', 
+`destination_number` varchar(80) NOT NULL default '', 
+`context` varchar(80) NOT NULL default '', 
+`start_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',  
+`answer_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', 
+`end_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', 
+`duration` int(11) NOT NULL default '0', 
+`billsec` int(11) NOT NULL default '0', 
+`hangup_cause` varchar(45) NOT NULL default '',  
+`uuid` varchar(36) NOT NULL default '',
+`bleg_uuid` varchar(36) NOT NULL default '',
+`accountcode` varchar(20) NOT NULL default ''
+); 
+
+
+