Manual:Job table

The job table holds a list of pending. Used only when  uses the  class.

job_id
Primary key.

job_cmd
Command name, limited to 60 characters to prevent key length overflow. Command names correspond to keys from .

job_namespace
to act on. Should be 0 if the command does not operate on a title. Used in conjunction with  .

job_title
to act on. Should be empty if the command does not operate on a title. Used in conjunction with  .

job_timestamp
of when the job was inserted. NULL for jobs added before addition of the timestamp.

job_params
Any other parameters to the command. Stored as a PHP serialized array, or an empty string if there are no parameters.

job_random
Random, non-unique, number used for concurrent job acquisition.

job_attempts
The number of times this job has been locked.

job_token
Field that conveys process locks on rows via process UUIDs. Unlocked jobs have this field set to an empty string.

job_token_timestamp
Timestamp when the job was locked. Unlocked jobs have this field null.

job_sha1
Base 36 SHA1 of the job parameters relevant to detecting duplicates.

Schema summary
+-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field              | Type             | Null | Key | Default | Extra          |
 * job_id             | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * job_cmd            | varbinary(60)    | NO   | MUL |         |                |
 * job_namespace      | int(11)          | NO   |     | NULL    |                |
 * job_title          | varbinary(255)   | NO   |     | NULL    |                |
 * job_timestamp      | binary(14)       | YES  | MUL | NULL    |                |
 * job_params         | mediumblob       | NO   |     | NULL    |                |
 * job_random         | int(10) unsigned | NO   |     | 0       |                |
 * job_attempts       | int(10) unsigned | NO   |     | 0       |                |
 * job_token          | varbinary(32)    | NO   |     |         |                |
 * job_token_timestamp | binary(14)      | YES  |     | NULL    |                |
 * job_sha1           | varbinary(32)    | NO   | MUL |         |                |

+-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field              | Type             | Null | Key | Default | Extra          |
 * job_id             | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * job_cmd            | varbinary(60)    | NO   | MUL |         |                |
 * job_namespace      | int(11)          | NO   |     | NULL    |                |
 * job_title          | varbinary(255)   | NO   |     | NULL    |                |
 * job_timestamp      | varbinary(14)    | YES  | MUL | NULL    |                |
 * job_params         | mediumblob       | NO   |     | NULL    |                |
 * job_random         | int(10) unsigned | NO   |     | 0       |                |
 * job_attempts       | int(10) unsigned | NO   |     | 0       |                |
 * job_token          | varbinary(32)    | NO   |     |         |                |
 * job_token_timestamp | varbinary(14)   | YES  |     | NULL    |                |
 * job_sha1           | varbinary(32)    | NO   | MUL |         |                |

+-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field              | Type             | Null | Key | Default | Extra          |
 * job_id             | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * job_cmd            | varbinary(60)    | NO   | MUL |         |                |
 * job_namespace      | int(11)          | NO   |     | NULL    |                |
 * job_title          | varbinary(255)   | NO   |     | NULL    |                |
 * job_timestamp      | varbinary(14)    | YES  | MUL | NULL    |                |
 * job_params         | blob             | NO   |     | NULL    |                |
 * job_random         | int(10) unsigned | NO   |     | 0       |                |
 * job_attempts       | int(10) unsigned | NO   |     | 0       |                |
 * job_token          | varbinary(32)    | NO   |     |         |                |
 * job_token_timestamp | varbinary(14)   | YES  |     | NULL    |                |
 * job_sha1           | varbinary(32)    | NO   | MUL |         |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * job_id       | int(10) unsigned    | NO   | PRI | NULL    | AUTO_INCREMENT |
 * job_cmd      | varbinary(60)       | NO   | MUL | NULL    |                |
 * job_namespace | int(11)            | NO   |     | NULL    |                |
 * job_title    | varchar(255) binary | NO   |     | NULL    |                |
 * job_timestamp | varbinary(14)      | YES  | MUL | NULL    |                |
 * job_params   | blob                | NO   |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * job_id       | int(10) unsigned    | NO   | PRI | NULL    | AUTO_INCREMENT |
 * job_cmd      | varbinary(60)       | NO   | MUL | NULL    |                |
 * job_namespace | int(11)            | NO   |     | NULL    |                |
 * job_title    | varchar(255) binary | NO   |     | NULL    |                |
 * job_params   | blob                | NO   |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * job_id       | int(9) unsigned     | NO   | PRI | NULL    | AUTO_INCREMENT |
 * job_cmd      | varchar(255)        | NO   | MUL | NULL    |                |
 * job_namespace | int(11)            | NO   |     | NULL    |                |
 * job_title    | varchar(255) binary | NO   |     | NULL    |                |
 * job_params   | blob                | NO   |     | NULL    |                |