#=============================================== # MySQL table : jobs #=============================================== # For recording the number of attempts to run each job, and the point # where the job should start reprocessing (ie everything after last_id, or # everything changed after time last_run) +----------+----------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------------------+------+-----+---------------------+-------+ | name | varchar(200) | | PRI | | | | last_id | bigint(20) unsigned | | | 0 | | | last_run | timestamp | YES | | 0000-00-00 00:00:00 | | | attempts | smallint(5) unsigned | | | 0 | | +----------+----------------------+------+-----+---------------------+-------+