Rodrigo Lang

CREATE DATABASE asterisk;

GRANT INSERT
  ON asterisk.*
  TO root@localhost
  IDENTIFIED BY 'password' ;

USE asterisk;

CREATE TABLE `cdr` (
  `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 '',
  `fluxo` VARCHAR(80) NOT NULL,
  `dcontext` VARCHAR(80) NOT NULL DEFAULT '',
  `channel` VARCHAR(80) NOT NULL DEFAULT '',
  `dstchannel` VARCHAR(80) NOT NULL DEFAULT '',
  `lastapp` VARCHAR(80) NOT NULL DEFAULT '',
  `lastdata` VARCHAR(80) NOT NULL DEFAULT '',
  `duration` INT(11) NOT NULL DEFAULT '0',
  `billsec` INT(11) NOT NULL DEFAULT '0',
  `disposition` VARCHAR(45) NOT NULL DEFAULT '',
  `amaflags` INT(11) NOT NULL DEFAULT '0',
  `accountcode` VARCHAR(20) NOT NULL DEFAULT '',
  `userfield` VARCHAR(255) NOT NULL DEFAULT '',
  `uniqueid` VARCHAR(32) NOT NULL DEFAULT '',
  KEY `calldate` (`calldate`),
  KEY `dst` (`dst`),
  KEY `accountcode` (`accountcode`),
  KEY `cdr_uniqueid` (`uniqueid`)
) ENGINE=InnoDB;

CREATE TABLE `queue_log` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `time` INT(10) UNSIGNED DEFAULT NULL,
  `callid` VARCHAR(32) NOT NULL DEFAULT '',
  `queuename` VARCHAR(32) NOT NULL DEFAULT '',
  `agent` VARCHAR(32) NOT NULL DEFAULT '',
  `event` VARCHAR(32) NOT NULL DEFAULT '',
  `data` VARCHAR(255) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`),
  KEY `queue_log_event` (`event`),
  KEY `queue_log_callid` (`callid`),
  KEY `queue_log_agent` (`agent`),
  KEY `queue_log_time` (`time`)
) ENGINE=InnoDB;