1 ALTER TABLE /*_*/job
ADD COLUMN job_random
integer unsigned
NOT NULL default 0;
2 ALTER TABLE /*_*/job
ADD COLUMN job_token
varbinary(32) NOT NULL default '';
3 ALTER TABLE /*_*/job
ADD COLUMN job_sha1
varbinary(32) NOT NULL default '';
4 ALTER TABLE /*_*/job
ADD COLUMN job_token_timestamp
varbinary(14) NULL default NULL;
6 CREATE INDEX /*i*/job_sha1
ON /*_*/job (job_sha1
);
7 CREATE INDEX /*i*/job_cmd_token
ON /*_*/job (job_cmd
,job_token
,job_random
);