maintenance/archives/patch-job.sql

   1
   2 -- Jobs performed by parallel apache threads or a command-line daemon
   3 CREATE TABLE /*$wgDBprefix*/job (
   4   job_id int(9) unsigned NOT NULL auto_increment,
   5
   6   -- Command name, currently only refreshLinks is defined
   7   job_cmd varchar(255) NOT NULL default '',
   8
   9   -- Namespace and title to act on
  10   -- Should be 0 and '' if the command does not operate on a title
  11   job_namespace int NOT NULL,
  12   job_title varchar(255) binary NOT NULL,
  13
  14   -- Any other parameters to the command
  15   -- Presently unused, format undefined
  16   job_params blob NOT NULL default '',
  17
  18   PRIMARY KEY job_id (job_id),
  19   KEY (job_cmd, job_namespace, job_title)
  20 ) TYPE=InnoDB;