2 thoughts on “Asterisk Full RealTime Database example

  • September 10, 2013 at 6:15 am
    Permalink

    CREATE TABLE `queue_log` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `time` char(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`)
    );

  • September 10, 2013 at 6:19 am
    Permalink

    CREATE TABLE IF NOT EXISTS `queue_log` (
    `recid` int(10) unsigned NOT NULL auto_increment,
    `origid` int(10) unsigned NOT NULL,
    `callid` varchar(32) NOT NULL default ”,
    `queuename` varchar(32) NOT NULL default ”,
    `agentdev` varchar(32) NOT NULL,
    `event` varchar(32) NOT NULL default ”,
    `data` varchar(128) NOT NULL,
    `data1` varchar(128) NOT NULL,
    `data2` varchar(128) NOT NULL,
    `data3` varchar(128) NOT NULL,
    `data4` varchar(128) NOT NULL,
    `data5` varchar(128) NOT NULL,
    `time` datetime NOT NULL default ‘0000-00-00 00:00:00’,
    PRIMARY KEY (`recid`),
    KEY `data1` (`data1`),
    KEY `data2` (`data2`),
    KEY `data3` (`data3`),
    KEY `event` (`event`),
    KEY `queuename` (`queuename`),
    KEY `callid` (`callid`),
    KEY `time` (`time`),
    KEY `agentdev` (`agentdev`),
    KEY `origid` (`origid`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

Leave a Reply