CREATE TABLE IF NOT EXISTS `#__jobpostingsamuel` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `company` varchar(255) NOT NULL DEFAULT '',
    `job_title` varchar(255) NOT NULL DEFAULT '',
    `occupational_categories` text,
    `our_categories` varchar(255) DEFAULT NULL,
    `duty_station` varchar(255) DEFAULT NULL,
    `street_address` varchar(255) DEFAULT NULL,
    `deadline` varchar(10) DEFAULT NULL,
    `town` varchar(255) DEFAULT NULL,
    `job_description` text,
    `responsibilities` text,
    `skills` text,
    `qualifications` text,
    `education_level` varchar(50) DEFAULT NULL,
    `experience` int(11) DEFAULT 12,
    `email` varchar(255) DEFAULT NULL,
    `application_procedure` text,
    `salary_amount` int(11) DEFAULT NULL,
    `currency` varchar(10) DEFAULT NULL,
    `payment_period` varchar(10) DEFAULT 'MONTH',
    `location_type` varchar(50) DEFAULT NULL,
    `applicant_location_requirements` varchar(50) DEFAULT NULL,
    `work_hours` int(11) DEFAULT 8,
    `base_salary` varchar(255) DEFAULT 'Not Disclosed',
    `employment_type` varchar(50) DEFAULT 'FULL_TIME',
    `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` int(10) unsigned NOT NULL DEFAULT 0,
    `published` tinyint(1) NOT NULL DEFAULT 1,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;