ALTER TABLE `jobs`
ADD COLUMN `reference` VARCHAR(255) NULL AFTER `invoice_amount`,
ADD COLUMN `location` VARCHAR(255) NULL AFTER `reference`,
ADD COLUMN `logo` VARCHAR(255) NULL AFTER `location`,
ADD COLUMN `type` VARCHAR(255) NULL AFTER `logo`,
ADD COLUMN `postal_code` VARCHAR(255) NULL AFTER `type`,
ADD COLUMN `job_advertiser` VARCHAR(255) NULL AFTER `postal_code`,
ADD COLUMN `application_url` VARCHAR(255) NULL AFTER `job_advertiser`,
ADD COLUMN `json_object` LONGTEXT NULL AFTER `application_url`,
ADD COLUMN `external_job` ENUM('yes', 'no') NOT NULL DEFAULT 'no' AFTER `json_object`,
ADD COLUMN `job_link` VARCHAR(255) NULL AFTER `external_job`,
ADD COLUMN `auto_approval_company` TINYINT(1) NOT NULL DEFAULT 0 AFTER `job_link`,
ADD COLUMN `auto_approval_job` TINYINT(1) NOT NULL DEFAULT 0 AFTER `auto_approval_company`,
ADD COLUMN `benefits` TEXT NULL AFTER `auto_approval_job`,
ADD COLUMN `company_name` VARCHAR(255) NULL AFTER `benefits`,
ADD COLUMN `search_index` TEXT NULL AFTER `company_name`;
