From cec9880cc5bb35360b656b5527d3c5feb3ec040b Mon Sep 17 00:00:00 2001 From: Tim Starling Date: Fri, 4 Dec 2009 03:01:42 +0000 Subject: [PATCH] Update patch-job.sql for r57610 and documentation updates. --- maintenance/archives/patch-job.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/maintenance/archives/patch-job.sql b/maintenance/archives/patch-job.sql index a1f9094f42..c9199efbca 100644 --- a/maintenance/archives/patch-job.sql +++ b/maintenance/archives/patch-job.sql @@ -1,9 +1,9 @@ - -- Jobs performed by parallel apache threads or a command-line daemon -CREATE TABLE /*$wgDBprefix*/job ( - job_id int unsigned NOT NULL auto_increment, +CREATE TABLE /*_*/job ( + job_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, - -- Command name, currently only refreshLinks is defined + -- Command name + -- Limited to 60 to prevent key length overflow job_cmd varbinary(60) NOT NULL default '', -- Namespace and title to act on @@ -12,9 +12,9 @@ CREATE TABLE /*$wgDBprefix*/job ( job_title varchar(255) binary NOT NULL, -- Any other parameters to the command - -- Presently unused, format undefined - job_params blob NOT NULL, - - PRIMARY KEY job_id (job_id), - KEY (job_cmd, job_namespace, job_title) + -- Stored as a PHP serialized array, or an empty string if there are no parameters + job_params blob NOT NULL ) /*$wgDBTableOptions*/; + +CREATE INDEX /*i*/job_cmd ON /*_*/job (job_cmd, job_namespace, job_title, job_params(128)); + -- 2.20.1