| Index: trunk/phase3/maintenance/archives/patch-job.sql |
| — | — | @@ -1,9 +1,9 @@ |
| 2 | | - |
| 3 | 2 | -- Jobs performed by parallel apache threads or a command-line daemon |
| 4 | | -CREATE TABLE /*$wgDBprefix*/job ( |
| 5 | | - job_id int unsigned NOT NULL auto_increment, |
| | 3 | +CREATE TABLE /*_*/job ( |
| | 4 | + job_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, |
| 6 | 5 | |
| 7 | | - -- Command name, currently only refreshLinks is defined |
| | 6 | + -- Command name |
| | 7 | + -- Limited to 60 to prevent key length overflow |
| 8 | 8 | job_cmd varbinary(60) NOT NULL default '', |
| 9 | 9 | |
| 10 | 10 | -- Namespace and title to act on |
| — | — | @@ -12,9 +12,9 @@ |
| 13 | 13 | job_title varchar(255) binary NOT NULL, |
| 14 | 14 | |
| 15 | 15 | -- Any other parameters to the command |
| 16 | | - -- Presently unused, format undefined |
| 17 | | - job_params blob NOT NULL, |
| | 16 | + -- Stored as a PHP serialized array, or an empty string if there are no parameters |
| | 17 | + job_params blob NOT NULL |
| | 18 | +) /*$wgDBTableOptions*/; |
| 18 | 19 | |
| 19 | | - PRIMARY KEY job_id (job_id), |
| 20 | | - KEY (job_cmd, job_namespace, job_title) |
| 21 | | -) /*$wgDBTableOptions*/; |
| | 20 | +CREATE INDEX /*i*/job_cmd ON /*_*/job (job_cmd, job_namespace, job_title, job_params(128)); |
| | 21 | + |