Callback mysql schema

From BGNV Wiki

Create a database and grant a user full access. For this example we are using a database named 'acd' with a username / password of 'acd' / 'acd'. We pre-load the table of blacklisted callback numbers and a list of queue names that match the queue name called by Queue() in the dialplan.

CREATE TABLE `blacklist` (
 `uniqueid` int(11) NOT NULL auto_increment,
 `callbacknum` varchar(15) NOT NULL default ,
 PRIMARY KEY  (`uniqueid`),
 KEY `callbacknum` (`callbacknum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Collection of numbers not allowed for customer callback' AUTO_INCREMENT=8 ;

INSERT INTO `blacklist` (`uniqueid`, `callbacknum`) VALUES (1, '311'), (2, '911');

CREATE TABLE `callers` (
 `uniqueid` varchar(15) NOT NULL default ,
 `callback` int(3) NOT NULL default '0',
 `callbacknum` varchar(15) NOT NULL default ,
 `queueid` smallint(6) NOT NULL default '8',
 `queuename` varchar(20) default NULL,
 PRIMARY KEY  (`uniqueid`),
 KEY `callback` (`callback`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `queuename` (
 `id` int(11) NOT NULL auto_increment,
 `queuename` varchar(20) NOT NULL default ,
 UNIQUE KEY `id` (`id`),
 KEY `queuename` (`queuename`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13;

INSERT INTO `queuename` (`id`, `callbacknum`) VALUES (1, 'tech');