maintenance/archives/patch-job.sql

   1 -- Jobs performed by parallel apache threads or a command-line daemon
   2 CREATE TABLE /*_*/job (
   3   job_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
   4
   5   -- Command name
   6   -- Limited to 60 to prevent key length overflow
   7   job_cmd varbinary(60) 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   -- Stored as a PHP serialized array, or an empty string if there are no parameters
  16   job_params blob NOT NULL
  17 ) /*$wgDBTableOptions*/;
  18
  19 CREATE INDEX /*i*/job_cmd ON /*_*/job (job_cmd, job_namespace, job_title, job_params(128));
  20