Commit | Line | Data |
---|---|---|
6a488035 TO |
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', | |
c213dee5 | 19 | `data` text COMMENT 'Serialized queue' |
6a488035 TO |
20 | , |
21 | PRIMARY KEY ( `id` ) | |
c213dee5 | 22 | |
6a488035 TO |
23 | , INDEX `index_queueids`( |
24 | `queue_name` | |
25 | , `weight` | |
26 | , `id` | |
27 | ) | |
c213dee5 | 28 | |
29 | ||
6a488035 | 30 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; |