[Summary view] [Print] [Text view]

   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