[asterisk-bugs] [JIRA] (ASTERISK-19572) Proposed change to CDR MySQL table structure

[Eugene (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-19572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eugene closed ASTERISK-19572.
-----------------------------

    Resolution: Won't Fix  (was: Suspended)

> Proposed change to CDR MySQL table structure
> --------------------------------------------
>
>                 Key: ASTERISK-19572
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-19572
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>            Reporter: Eugene
>            Severity: Minor
>
> I am administering relatively large CDR database in MySQL. To make table faster and smaller I've made number of changes to table structure. Here is my CREATE code for the table:
> {noformat}
> CREATE TABLE `cdr` (
> 	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
> 	`calldate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
> 	`clid` VARCHAR(80) NOT NULL DEFAULT '',
> 	`src` VARCHAR(80) NOT NULL DEFAULT '',
> 	`dst` VARCHAR(80) NOT NULL DEFAULT '',
> 	`dcontext` VARCHAR(80) NOT NULL DEFAULT '',
> 	`lastapp` VARCHAR(200) NOT NULL DEFAULT '',
> 	`lastdata` VARCHAR(200) NOT NULL DEFAULT '',
> 	`duration` FLOAT UNSIGNED NULL DEFAULT NULL,
> 	`billsec` FLOAT UNSIGNED NULL DEFAULT NULL,
> 	`disposition` ENUM('ANSWERED','BUSY','FAILED','NO ANSWER','CONGESTION') NULL DEFAULT NULL,
> 	`channel` VARCHAR(50) NULL DEFAULT NULL,
> 	`dstchannel` VARCHAR(50) NULL DEFAULT NULL,
> 	`amaflags` VARCHAR(50) NULL DEFAULT NULL,
>         `accountcode` VARCHAR(20) NULL DEFAULT NULL,
> 	`uniqueid` VARCHAR(32) NOT NULL DEFAULT '',
> 	`userfield` FLOAT UNSIGNED NULL DEFAULT NULL,
> 	`answer` DATETIME NOT NULL,
> 	`end` DATETIME NOT NULL,
> 	PRIMARY KEY (`id`),
> 	INDEX `calldate` (`calldate`),
> 	INDEX `dst` (`dst`),
> 	INDEX `uniqueid` (`uniqueid`),
> 	INDEX `src` (`src`),
> 	INDEX `dcontext` (`dcontext`),
> 	INDEX `clid` (`clid`),
> 	INDEX `userfield` (`userfield`),
> 	INDEX `disposition` (`disposition`)
> )
> COLLATE='utf8_bin'
> ENGINE=InnoDB;
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)