k0kFW4zr

1CREATE TABLE IF NOT EXISTS `asterisk`.`cdr` (
2  `id` INT ZEROFILL NOT NULL AUTO_INCREMENT,
3  `calldate` DATETIME NOT NULL DEFAULT '2011-01-01 00:00:00',
4  `org_unique_id` VARCHAR(255) NULL,
5  `uniqueid` VARCHAR(32) NOT NULL DEFAULT '',
6  `clid` VARCHAR(80) NOT NULL DEFAULT '',
7  `src` VARCHAR(80) NOT NULL DEFAULT '',
8  `dst` VARCHAR(80) NOT NULL DEFAULT '',
9  `dcontext` VARCHAR(80) NOT NULL DEFAULT '',
10  `channel` VARCHAR(80) NOT NULL DEFAULT '',
11  `dstchannel` VARCHAR(80) NOT NULL DEFAULT '',
12  `lastapp` VARCHAR(80) NOT NULL DEFAULT '',
13  `lastdata` VARCHAR(80) NOT NULL DEFAULT '',
14  `duration` INT(11) NOT NULL DEFAULT '0',
15  `billsec` INT(11) NOT NULL DEFAULT '0',
16  `disposition` VARCHAR(45) NULL DEFAULT '',
17  `amaflags` INT(11) NULL DEFAULT '0',
18  `accountcode` VARCHAR(20) NULL DEFAULT '',
19  `userfield` VARCHAR(255) NULL DEFAULT '',
20  `id_huesped` INT NULL,
21  `id_troncal` INT NULL,
22  `endcall` DATETIME NULL,
23  `id_ruta_saliente` INT NULL,
24  `id_ruta_entrante` INT NULL,
25  `linkedid` VARCHAR(40) NULL,
26  `sentido` TINYINT(5) NULL,
27  `robot` TINYINT(1) NULL DEFAULT 0,
28  `procesada` TINYINT(1) NULL DEFAULT 0,
29  `grabacion` VARCHAR(255) NULL,
30  `desborde` INT NULL COMMENT '1 - Buzonn2 - Numero internon3 - Numero externo.',
31  INDEX `calldate` (`calldate` ASC),
32  INDEX `dst` (`dst` ASC),
33  INDEX `accountcode` (`accountcode` ASC),
34  INDEX `uniqueid` (`uniqueid` ASC),
35  PRIMARY KEY (`id`),
36  INDEX `ix_lastapp` (`lastapp` ASC),
37  INDEX `ix_orguid` (`org_unique_id` ASC),
38  INDEX `ix_grabacion` (`userfield` ASC))
39ENGINE = MyISAM
40DEFAULT CHARACTER SET = latin1