1 -- This code has been copied from the auto-generated civicrm.mysql
2 -- It is required to facilitate queue-backed upgrades.
4 -- /*******************************************************
6 -- * civicrm_queue_item
8 -- * Stores a list of queue items
10 -- *******************************************************/
11 CREATE TABLE `civicrm_queue_item` (
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'
23 , INDEX `index_queueids`(
30 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;