CREATE TABLE `jobs` ( `job_reference` TEXT, `job_title` TEXT, `job_status` TEXT, `reply_to` TEXT ); CREATE TABLE `job_history` ( `job_reference` TEXT, `field_name` TEXT, `old_value` TEXT, `new_value` TEXT, `changed_on` TEXT );