Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Asterisk queue-realtime database schema
CREATE DATABASE IF NOT EXISTS `asteriskrealtime`;
USE `asteriskrealtime`;
/*Table structure for table `queue_log` */
DROP TABLE IF EXISTS `queue_log`;
CREATE TABLE `queue_log` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`time` CHAR(26) 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 '',
`data1` VARCHAR(100) NOT NULL DEFAULT '',
`data2` VARCHAR(100) NOT NULL DEFAULT '',
`data3` VARCHAR(100) NOT NULL DEFAULT '',
`data4` VARCHAR(100) NOT NULL DEFAULT '',
`data5` VARCHAR(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment