civicrm_queue_item.mysql 966 Bytes
Newer Older
totten's avatar
totten committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
-- This code has been copied from the auto-generated civicrm.mysql
-- It is required to facilitate queue-backed upgrades.

-- /*******************************************************
-- *
-- * civicrm_queue_item
-- *
-- * Stores a list of queue items
-- *
-- *******************************************************/
CREATE TABLE `civicrm_queue_item` (


     `id` int unsigned NOT NULL AUTO_INCREMENT  ,
     `queue_name` varchar(64) NOT NULL   COMMENT 'Name of the queue which includes this item',
     `weight` int NOT NULL   ,
     `submit_time` datetime NOT NULL   COMMENT 'date on which this item was submitted to the queue',
     `release_time` datetime    COMMENT 'date on which this job becomes available; null if ASAP',
19
     `data` text    COMMENT 'Serialized queue'
totten's avatar
totten committed
20 21
,
    PRIMARY KEY ( `id` )
22

totten's avatar
totten committed
23 24 25 26 27
    ,     INDEX `index_queueids`(
        `queue_name`
      , `weight`
      , `id`
  )
28 29


totten's avatar
totten committed
30
)  ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;