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
,
6 -- Limited to 60 to prevent key length overflow
7 job_cmd
varbinary(60) NOT NULL default '',
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,
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*/;
19 CREATE INDEX /*i*/job_cmd
ON /*_*/job (job_cmd
, job_namespace
, job_title
, job_params(128));