-- ------------------------------------------------
-- UM Report Queue
-- Created 20111027
-- ------------------------------------------------

CREATE  TABLE `queue_report` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `system` VARCHAR(8) NOT NULL ,
  `client` VARCHAR(3) NOT NULL ,
  `user` VARCHAR(12) NOT NULL ,
  `params` LONGTEXT NOT NULL ,
  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
  `start` TIMESTAMP NULL ,
  `end` TIMESTAMP NULL ,
  `status` TINYINT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `user` (`system` ASC, `client` ASC, `user` ASC) ,
  INDEX `created` (`created` ASC) ,
  INDEX `start` (`start` ASC) ,
  INDEX `end` (`end` ASC) , 
  INDEX `status` (`status` ASC) );
  
