crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/sql/civicrm_queue_item.mysql

   1 -- This code has been copied from the auto-generated civicrm.mysql
   2 -- It is required to facilitate queue-backed upgrades.
   3
   4 -- /*******************************************************
   5 -- *
   6 -- * civicrm_queue_item
   7 -- *
   8 -- * Stores a list of queue items
   9 -- *
  10 -- *******************************************************/
  11 CREATE TABLE `civicrm_queue_item` (
  12
  13
  14      `id` int unsigned NOT NULL AUTO_INCREMENT  ,
  15      `queue_name` varchar(64) NOT NULL   COMMENT 'Name of the queue which includes this item',
  16      `weight` int NOT NULL   ,
  17      `submit_time` datetime NOT NULL   COMMENT 'date on which this item was submitted to the queue',
  18      `release_time` datetime    COMMENT 'date on which this job becomes available; null if ASAP',
  19      `data` text    COMMENT 'Serialized queue'
  20 ,
  21     PRIMARY KEY ( `id` )
  22
  23     ,     INDEX `index_queueids`(
  24         `queue_name`
  25       , `weight`
  26       , `id`
  27   )
  28
  29
  30 )  ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;