jobs

CREATE TABLE `jobs` (
	`id` VARCHAR(36) NOT NULL,
	`job_number` VARCHAR(50) NOT NULL,
	`customer_reference` VARCHAR(50) NOT NULL,
	`quantity` INT(10) UNSIGNED NOT NULL,
	`mf_job_id` VARCHAR(36) NOT NULL,
	`act_actual_id` VARCHAR(36) NOT NULL,
	`status_id` INT(11) NOT NULL,
	`due_date` DATETIME NOT NULL,
	`requested_ship_date` DATETIME NULL DEFAULT NULL,
	`deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	`unc_path` VARCHAR(255) NULL DEFAULT NULL,
	`customer_name` VARCHAR(255) NULL DEFAULT NULL,
	`priority` INT(11) NOT NULL DEFAULT '0',
	`date_added` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`),
	INDEX `status_id` (`status_id`)
)
ENGINE=InnoDB
ROW_FORMAT=DEFAULT