User:RichMorin/mw jobs

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

Inter-table Relationships

NA

MySQL Table Description

mysql> desc mw_jobs;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| keyname | varchar(255) |      | PRI |         |       |
| value   | mediumblob   | YES  |     | NULL    |       |
| exptime | datetime     | YES  | MUL | NULL    |       |
+---------+--------------+------+-----+---------+-------+
5 rows in set

Annotated Table Creation Code

-- Jobs performed by parallel Apache threads
-- or a command-line daemon

CREATE TABLE /*$wgDBprefix*/job (

  job_id int(9) unsigned NOT NULL auto_increment,

  -- Command name, currently only refreshLinks is defined

  job_cmd             varchar(255)                NOT NULL  default '',

  -- Namespace and title to act on.
  -- Should be 0 and '' if the command does not operate on a title.

  job_namespace       int                         NOT NULL,
  job_title           varchar(255)   binary       NOT NULL,

  -- Any other parameters to the command
  -- Presently unused, format undefined
  
  job_params          blob                        NOT NULL  default '',

PRIMARY KEY           job_id (job_id),
KEY                   (job_cmd, job_namespace, job_title)

) ENGINE=InnoDB;