CREATE TABLE /*$wgDBprefix*/job (
job_id int(9) unsigned NOT NULL auto_increment,
-- Command name, currently only refreshLinks is defined
job_cmd varchar(255) NOT NULL default '',
-- Namespace and title to act on
-- Should be 0 and '' if the command does not operate on a title
job_namespace int NOT NULL default '0',
job_title varchar(255) binary NOT NULL default '',
-- Any other parameters to the command
-- Presently unused, format undefined
job_params blob NOT NULL default '',
PRIMARY KEY job_id (job_id),
KEY (job_cmd, job_namespace, job_title)
) TYPE=InnoDB, DEFAULT CHARACTER SET latin1 collate utf8_general_ci;
|