CREATE TABLE IF NOT EXISTS `#__JobPostingSamuel` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `Company` VARCHAR(255) NOT NULL,
    `Job_Title` VARCHAR(255) NOT NULL,
    `Occupational_Categories` TEXT,
    `Our_Categories` VARCHAR(255),
    `Duty_Station` VARCHAR(255),
    `Street_Address` VARCHAR(255),
    `Deadline` VARCHAR(10),
    `Town` VARCHAR(255),
    `Job_Description` TEXT,
    `Responsibilities` TEXT,
    `Skills` TEXT,
    `Qualifications` TEXT,
    `Education_Level` VARCHAR(50),
    `Experience` INT DEFAULT 12,
    `Email` VARCHAR(255),
    `Application_Procedure` TEXT,
    `Salary_Amount` INT,
    `Currency` VARCHAR(10),
    `Payment_Period` VARCHAR(10) DEFAULT 'MONTH',
    `Location_Type` VARCHAR(50),
    `Applicant_Location_Requirements` VARCHAR(50),
    `Work_Hours` INT DEFAULT 8,
    `Base_Salary` VARCHAR(255) DEFAULT 'Not Disclosed',
    `Employment_Type` VARCHAR(50) DEFAULT 'FULL_TIME'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;