ALTER TABLE `cdr` ADD `cdr_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE `cdr` ADD `dest_name` VARCHAR( 100 ) NULL ;
ALTER TABLE `cdr` ADD `cost` FLOAT NOT NULL DEFAULT -1;

ALTER TABLE `zone` ADD INDEX `CodeIndex` ( `zn_ndcode` , `zn_lacode` );
ALTER TABLE `cdr` ADD INDEX `DSTIndex` ( `dst` ) ;
ALTER TABLE `cdr` ADD INDEX `SRCIndex` ( `src` );
ALTER TABLE `cdr` ADD INDEX `NameIndex` ( `dest_name` );
ALTER TABLE `cdr` ADD INDEX `BillCallsIndex` ( `userfield`, `cost`, `disposition` );
ALTER TABLE `cdr` ADD INDEX `BillCallsIndex2` ( `accountcode`, `cost`, `disposition` );