y7te65Fa

1USE asterisk;
2GRANT ALL PRIVILEGES ON asterisk.* TO 'asterisk'@'localhost' IDENTIFIED BY 'change_me';
3FLUSH PRIVILEGES;
4CREATE TABLE IF NOT EXISTS cdr (
5        id BIGINT(20) NOT NULL AUTO_INCREMENT,
6        accountcode VARCHAR(30),
7        src VARCHAR(64),
8        dst VARCHAR(64),
9        dcontext VARCHAR(32),
10        clid VARCHAR(64),
11        channel VARCHAR(32),
12        dstchannel VARCHAR(32),
13        lastapp VARCHAR(32),
14        lastdata VARCHAR(256),
15        calldate TIMESTAMP NOT NULL,
16        answerdate TIMESTAMP NOT NULL,
17        hangupdate TIMESTAMP NOT NULL,
18        duration int(8) UNSIGNED DEFAULT NULL,
19        billsec int(8) UNSIGNED DEFAULT NULL,
20        disposition VARCHAR(32),
21        amaflags VARCHAR(128),
22        uniqueid VARCHAR(128),
23        userfield VARCHAR(128),
24        PRIMARY KEY(id),
25        KEY `calldate` (`calldate`)
26) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;