Manual:job table

From MediaWiki.org
Jump to: navigation, search
Manual:Contents MediaWiki database layout job table


Contents


Jobs performed by parallel apache threads or a command-line daemon.

Fields [edit]

job_id [edit]

Primary key.

job_cmd [edit]

Command name, limited to 60 characters to prevent key length overflow.

job_namespace [edit]

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

job_title [edit]

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

job_timestamp [edit]

MediaWiki version: 1.19

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

job_params [edit]

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

Versions [edit]

MediaWiki versions: 1.19 – 1.20
mysql> describe job;
+---------------+------------------+------+-----+---------+----------------+
| 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    |                |
+---------------+------------------+------+-----+---------+----------------+


MediaWiki version: 1.18
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| job_id        | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| job_cmd       | varbinary(60)    | NO   | MUL | NULL    |                |
| job_namespace | int(11)          | NO   |     | NULL    |                |
| job_title     | varbinary(255)   | NO   |     | NULL    |                |
| job_params    | blob             | NO   |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+


MediaWiki version: 1.10
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| job_id        | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| job_cmd       | varbinary(60)    | NO   | MUL | NULL    |                |
| job_namespace | int(11)          | NO   |     | NULL    |                |
| job_title     | varchar(255)     | NO   |     | NULL    |                |
| job_params    | blob             | NO   |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+


MediaWiki version: 1.9
MediaWiki version: 1.8
MediaWiki version: 1.7
MediaWiki version: 1.6
+---------------+-----------------+------+-----+---------+----------------+
| 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)    | NO   |     | NULL    |                |
| job_params    | blob            | NO   |     | NULL    |                |
+---------------+-----------------+------+-----+---------+----------------+
Language: English  • 日本語