alter table cdr add column san_calldate DATETIME NULL default NULL after calldate;
alter table cdr add column answer_time DATETIME NULL default NULL after san_calldate ;
alter table cdr add column end_time DATETIME NULL default NULL after answer_time;

alter table cdr add column realsrc VARCHAR(16) NULL default NULL after src;

alter table cdr add column realdst VARCHAR(16) NULL default NULL after realsrc;


alter table cdr add column san_trunk VARCHAR(80) NOT NULL default '' after dstchannel;

alter table cdr add column call_type VARCHAR(20) NOT NULL default '' after recordingfile;

alter table cdr add column client_id INT(11) NULL default NULL after sanacd;

alter table cdr modify column san_calluniqueid VARCHAR(150) NULL default NULL;

alter table cdr modify column uniqueid VARCHAR(150) NULL default NULL;

ALTER TABLE `cdr` CHANGE COLUMN `end_time` `end_time` DATETIME NULL DEFAULT CURRENT_TIMESTAMP() AFTER `answer_time;