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',
    `published` tinyint(1) NOT NULL DEFAULT 1,
    `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
    `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `created_by` int(10) unsigned NOT NULL DEFAULT 0,
    `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`),
    KEY `idx_published` (`published`),
    KEY `idx_created_by` (`created_by`),
    KEY `idx_company` (`company`),
    KEY `idx_job_title` (`job_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;