CREATE TABLE `jos_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `callback_id` varchar(32) NOT NULL DEFAULT '',
  `unique_id` varchar(32) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL,
  `site_id` varchar(500) NOT NULL,
  `process_id` int(11) NOT NULL,
  `created_time` datetime NOT NULL,
  `start_time` datetime NOT NULL,
  `priority` int(2) NOT NULL DEFAULT 3,
  `running` int(2) NOT NULL,
  `info` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `hold` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `process_priority` (`process_id`,`callback_id`,`priority`),
  KEY `unique_id` (`unique_id`),
  KEY `user_id` (`user_id`,`running`),
  KEY `running` (`running`,`start_time`)
) ENGINE=InnoDB AUTO_INCREMENT=276553594 DEFAULT CHARSET=utf8;
