CREATE TABLE IF NOT EXISTS `#__jobpostingsamuel` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `company` VARCHAR(255) NOT NULL DEFAULT '',
  `job_title` VARCHAR(255) NOT NULL DEFAULT '',
  `occupational_categories` VARCHAR(255) NOT NULL DEFAULT '',
  `our_categories` VARCHAR(255) NOT NULL DEFAULT '',
  `duty_station` VARCHAR(255) NOT NULL DEFAULT '',
  `street_address` VARCHAR(255) NOT NULL DEFAULT '',
  `industry` VARCHAR(255) NOT NULL DEFAULT '',
  `deadline` DATE DEFAULT NULL,
  `town` VARCHAR(255) NOT NULL DEFAULT '',
  `job_description` TEXT NOT NULL,
  `responsibilities` TEXT NOT NULL,
  `skills` TEXT NOT NULL,
  `qualifications` TEXT NOT NULL,
  `education_level` VARCHAR(50) NOT NULL DEFAULT '',
  `experience` INT(11) NOT NULL DEFAULT 0,
  `email` VARCHAR(255) NOT NULL DEFAULT '',
  `application_procedure` TEXT NOT NULL,
  `salary_amount` INT(11) DEFAULT NULL,
  `currency` VARCHAR(10) NOT NULL DEFAULT '',
  `payment_period` VARCHAR(10) NOT NULL DEFAULT '',
  `location_type` VARCHAR(50) NOT NULL DEFAULT '',
  `applicant_location_requirements` VARCHAR(255) NOT NULL DEFAULT '',
  `work_hours` INT(11) NOT NULL DEFAULT 0,
  `base_salary` VARCHAR(255) NOT NULL DEFAULT '',
  `employment_type` VARCHAR(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;