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 '' +); + + +