DROP TABLE IF EXISTS cdr;
CREATE TABLE cdr (
        cdrid UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
        calldate datetime,
        clid varchar(80),
        src varchar(80),
        dst varchar(80),
        dcontext varchar(80),
        channel varchar(80),
        dstchannel varchar(80),
        lastapp varchar(80),
        lastdata varchar (80),
        duration int UNSIGNED,
        billsec int UNSIGNED,
        disposition varchar(45),
        amaflags int UNSIGNED,
        accountcode varchar(20),
        uniqueid varchar(32),
        userfield varchar(255)
        );