| 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 ; |