-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `job_id` int(11) NOT NULL,
  `status` enum('applied','under_review','shortlisted','interview','offered','rejected') DEFAULT 'applied',
  `date_applied` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `applications`
--

INSERT INTO `applications` (`id`, `user_id`, `job_id`, `status`, `date_applied`, `updated_at`, `notes`) VALUES
(1, 1, 1, 'applied', '2026-01-15 05:26:00', NULL, NULL),
(2, 1, 3, 'under_review', '2026-01-15 05:26:00', NULL, NULL),
(3, 2, 5, 'applied', '2026-01-15 05:26:00', NULL, NULL),
(4, 2, 10, 'applied', '2026-01-15 05:26:00', NULL, NULL),
(5, 3, 2, 'interview', '2026-01-15 05:26:00', NULL, NULL),
(6, 3, 7, 'applied', '2026-01-15 05:26:00', NULL, NULL),
(7, 4, 15, 'interview', '2026-01-15 05:26:00', NULL, NULL),
(8, 4, 18, 'applied', '2026-01-15 05:26:00', NULL, NULL),
(9, 5, 20, 'offered', '2026-01-15 05:26:00', NULL, NULL),
(10, 5, 25, 'rejected', '2026-01-15 05:26:00', NULL, NULL),
(11, 39, 7, 'applied', '2026-01-19 09:26:25', NULL, NULL),
(12, 39, 1, 'under_review', '2026-01-19 09:59:46', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `job_openings`
--

CREATE TABLE `job_openings` (
  `id` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `field` varchar(100) DEFAULT NULL,
  `location` varchar(150) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` enum('open','closed','paused') DEFAULT 'open',
  `job_type` enum('fulltime','parttime','contract','internship') DEFAULT 'fulltime',
  `deadline` date DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `job_openings`
--

INSERT INTO `job_openings` (`id`, `title`, `field`, `location`, `description`, `status`, `job_type`, `deadline`, `created_at`) VALUES
(1, 'Frontend Developer', 'IT', 'Remote', '<div>\n                                            <b>Job Summary</b>\n                                            <p>We are looking for a Web Developer who is passionate about coding, problem-solving, and creating exceptional user experiences. The ideal candidate should have hands-on experience with front-end and back-end technologies, strong attention to detail, and the ability to work independently as well as in a collaborative environment.</p>\n                                        </div>\n                                        <br />\n\n                                        <div>\n                                            <b>Key Responsibilities</b>\n                                            <ul>\n                                                <li>Develop, test, and maintain responsive websites and web applications.</li>\n                                                <li>Collaborate with UI/UX designers to implement design concepts accurately.</li>\n                                                <li>Write clean, efficient, and maintainable code using languages such as HTML, CSS, JavaScript, PHP, or other relevant technologies.</li>\n                                                <li>Integrate back-end services, APIs, and databases for full-stack functionality.</li>\n                                                <li>Optimize website performance, speed, and scalability.</li>\n                                                <li>Troubleshoot, debug, and resolve technical issues.</li>\n                                                <li>Stay up-to-date with emerging web technologies and best practices.</li>\n                                                <li>Ensure web applications are secure, accessible, and cross-browser compatible.</li>\n                                            </ul>\n                                        </div>\n                                        <br />\n\n                                        <div>\n                                            <b>Required Skills and Qualifications</b>\n                                            <ul>\n                                                <li>Proven experience as a Web Developer or similar role.</li>\n                                                <li>Proficiency in front-end technologies: HTML5, CSS3, JavaScript, frameworks like React.js or Vue.js.</li>\n                                                <li>Proficiency in back-end technologies: PHP, Node.js, Laravel, or similar frameworks.</li>\n                                                <li>Experience with databases such as MySQL, PostgreSQL, or MongoDB.</li>\n                                                <li>Understanding of RESTful APIs and web services integration.</li>\n                                                <li>Familiarity with version control systems, preferably Git.</li>\n                                                <li>Strong problem-solving skills and attention to detail.</li>\n                                                <li>Excellent communication and teamwork skills.</li>\n                                            </ul>\n                                        </div>\n                                        <br />\n                                        <div>\n                                            <b>Preferred Qualifications</b>\n                                            <ul>\n                                                <li>Experience with cloud services (AWS, Azure, Google Cloud).</li>\n                                                <li>Knowledge of SEO best practices and web analytics.</li>\n                                                <li>Experience with web security best practices.</li>\n                                            </ul>\n                                        </div>\n                                        <br />\n                                        <div>\n                                            <b>What We Offer</b>\n                                            <ul>\n                                                <li>Competitive salary and benefits package.</li>\n                                                <li>Opportunities for professional growth and skill development.</li>\n                                                <li>Collaborative and inclusive work environment.</li>\n                                                <li>Chance to work on exciting projects using modern web technologies.</li>\n                                            </ul>\n                                        </div>', 'open', 'contract', '2026-03-01', '2026-01-15 05:25:44'),
(2, 'Backend Developer', 'IT', 'Lagos', '<div>\n                                            <b>Job Summary</b>\n                                            <p>We are looking for a Web Developer who is passionate about coding, problem-solving, and creating exceptional user experiences. The ideal candidate should have hands-on experience with front-end and back-end technologies, strong attention to detail, and the ability to work independently as well as in a collaborative environment.</p>\n                                        </div>\n                                        <hr />\n                                        <br />\n\n                                        <div>\n                                            <b>Key Responsibilities</b>\n                                            <ul>\n                                                <li>Develop, test, and maintain responsive websites and web applications.</li>\n                                                <li>Collaborate with UI/UX designers to implement design concepts accurately.</li>\n                                                <li>Write clean, efficient, and maintainable code using languages such as HTML, CSS, JavaScript, PHP, or other relevant technologies.</li>\n                                                <li>Integrate back-end services, APIs, and databases for full-stack functionality.</li>\n                                                <li>Optimize website performance, speed, and scalability.</li>\n                                                <li>Troubleshoot, debug, and resolve technical issues.</li>\n                                                <li>Stay up-to-date with emerging web technologies and best practices.</li>\n                                                <li>Ensure web applications are secure, accessible, and cross-browser compatible.</li>\n                                            </ul>\n                                        </div>\n                                        <hr />\n                                        <br />\n\n                                        <div>\n                                            <b>Required Skills and Qualifications</b>\n                                            <ul>\n                                                <li>Proven experience as a Web Developer or similar role.</li>\n                                                <li>Proficiency in front-end technologies: HTML5, CSS3, JavaScript, frameworks like React.js or Vue.js.</li>\n                                                <li>Proficiency in back-end technologies: PHP, Node.js, Laravel, or similar frameworks.</li>\n                                                <li>Experience with databases such as MySQL, PostgreSQL, or MongoDB.</li>\n                                                <li>Understanding of RESTful APIs and web services integration.</li>\n                                                <li>Familiarity with version control systems, preferably Git.</li>\n                                                <li>Strong problem-solving skills and attention to detail.</li>\n                                                <li>Excellent communication and teamwork skills.</li>\n                                            </ul>\n                                        </div>\n                                        <hr />\n                                        <br />\n\n                                        <div>\n                                            <b>Preferred Qualifications</b>\n                                            <ul>\n                                                <li>Experience with cloud services (AWS, Azure, Google Cloud).</li>\n                                                <li>Knowledge of SEO best practices and web analytics.</li>\n                                                <li>Experience with web security best practices.</li>\n                                            </ul>\n                                        </div>\n                                        <br />\n                                        <hr />\n\n                                        <div>\n                                            <b>What We Offer</b>\n                                            <ul>\n                                                <li>Competitive salary and benefits package.</li>\n                                                <li>Opportunities for professional growth and skill development.</li>\n                                                <li>Collaborative and inclusive work environment.</li>\n                                                <li>Chance to work on exciting projects using modern web technologies.</li>\n                                            </ul>\n                                        </div>', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(3, 'Full Stack Developer', 'IT', 'Abuja', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'fulltime', '2026-03-01', '2026-01-15 05:25:44'),
(5, 'Mobile App Developer', 'IT', 'Enugu', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'fulltime', '2026-03-01', '2026-01-15 05:25:44'),
(6, 'DevOps Engineer', 'IT', 'Remote', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'parttime', '2026-03-01', '2026-01-15 05:25:44'),
(7, 'Data Analyst', 'Data', 'Lagos', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'fulltime', '2026-03-01', '2026-01-15 05:25:44'),
(8, 'Cyber Security Officer', 'Security', 'Abuja', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'contract', '2026-03-01', '2026-01-15 05:25:44'),
(9, 'Network Administrator', 'IT', 'Onitsha', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'fulltime', '2026-03-01', '2026-01-15 05:25:44'),
(10, 'System Support Officer', 'IT', 'Owerri', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(11, 'HR Officer', 'Human Resource', 'Lagos', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'fulltime', '2026-03-01', '2026-01-15 05:25:44'),
(12, 'Recruitment Specialist', 'Human Resource', 'Abuja', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(13, 'Admin Officer', 'Administration', 'Enugu', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'fulltime', '2026-03-01', '2026-01-15 05:25:44'),
(14, 'Office Assistant', 'Administration', 'Awka', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'parttime', '2026-03-01', '2026-01-15 05:25:44'),
(15, 'Accountant', 'Finance', 'Lagos', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(16, 'Finance Analyst', 'Finance', 'Abuja', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'parttime', '2026-03-01', '2026-01-15 05:25:44'),
(17, 'Marketing Executive', 'Marketing', 'Lagos', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(18, 'Social Media Manager', 'Marketing', 'Remote', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(20, 'Graphic Designer', 'Design', 'Enugu', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(21, 'Project Manager', 'Management', 'Lagos', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'parttime', '2026-03-01', '2026-01-15 05:25:44'),
(22, 'Operations Manager', 'Management', 'Abuja', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'contract', '2026-03-01', '2026-01-15 05:25:44'),
(23, 'Business Development Officer', 'Business', 'Lagos', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(24, 'Customer Support Agent', 'Support', 'Remote', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(25, 'Sales Executive', 'Sales', 'Onitsha', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'closed', 'contract', '2026-03-01', '2026-01-15 05:25:44'),
(26, 'Quality Assurance Tester', 'IT', 'Remote', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'contract', '2026-03-01', '2026-01-15 05:25:44'),
(27, 'Product Manager', 'Product', 'Lagos', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'open', 'internship', '2026-03-01', '2026-01-15 05:25:44'),
(31, 'Product Engineer', 'IT', 'Remote', 'Job Title: Product Engineer\r\n\r\nLocation: [On-site / Remote / Hybrid]\r\nEmployment Type: Full-time\r\n\r\nJob Summary\r\n\r\nWe are looking for a skilled Product Engineer to design, build, and improve scalable products from concept to launch. The ideal candidate will work closely with product managers, designers, and other engineers to deliver high-quality, user-focused solutions.\r\n\r\nKey Responsibilities\r\n\r\nDesign, develop, test, and maintain product features and systems\r\n\r\nCollaborate with product and design teams to translate requirements into technical solutions\r\n\r\nParticipate in product planning, architecture decisions, and code reviews\r\n\r\nOptimize product performance, scalability, and reliability\r\n\r\nTroubleshoot, debug, and resolve production issues\r\n\r\nContinuously improve development processes and product quality\r\n\r\nDocument technical designs and implementation details\r\n\r\nRequirements\r\n\r\nBachelor’s degree in Engineering, Computer Science, or related field\r\n\r\nProven experience as a Product Engineer or Software Engineer\r\n\r\nStrong knowledge of programming languages and frameworks relevant to the product\r\n\r\nExperience working with APIs, databases, and version control systems\r\n\r\nSolid problem-solving and analytical skills\r\n\r\nAbility to work in a collaborative, cross-functional environment', 'open', 'internship', '2026-02-26', '2026-02-11 11:30:18'),
(32, 'Product Engineer', 'IT', 'Remote', 'Job Title: Product Engineer\r\n\r\nLocation: [On-site / Remote / Hybrid]\r\nEmployment Type: Full-time\r\n\r\nJob Summary\r\n\r\nWe are looking for a skilled Product Engineer to design, build, and improve scalable products from concept to launch. The ideal candidate will work closely with product managers, designers, and other engineers to deliver high-quality, user-focused solutions.\r\n\r\nKey Responsibilities\r\n\r\nDesign, develop, test, and maintain product features and systems\r\n\r\nCollaborate with product and design teams to translate requirements into technical solutions\r\n\r\nParticipate in product planning, architecture decisions, and code reviews\r\n\r\nOptimize product performance, scalability, and reliability\r\n\r\nTroubleshoot, debug, and resolve production issues\r\n\r\nContinuously improve development processes and product quality\r\n\r\nDocument technical designs and implementation details\r\n\r\nRequirements\r\n\r\nBachelor’s degree in Engineering, Computer Science, or related field\r\n\r\nProven experience as a Product Engineer or Software Engineer\r\n\r\nStrong knowledge of programming languages and frameworks relevant to the product\r\n\r\nExperience working with APIs, databases, and version control systems\r\n\r\nSolid problem-solving and analytical skills\r\n\r\nAbility to work in a collaborative, cross-functional environment', 'open', 'internship', '2026-02-26', '2026-02-11 11:31:09'),
(33, 'DevOps Engineer', 'IT', 'Remote', 'Job Title: DevOps Engineer\r\n\r\nLocation: [On-site / Remote / Hybrid]\r\nEmployment Type: Full-time\r\n\r\nJob Summary\r\n\r\nWe are seeking a skilled DevOps Engineer to build, deploy, and maintain reliable infrastructure and CI/CD pipelines. The ideal candidate will work closely with development teams to automate processes, improve system performance, and ensure high availability, security, and scalability of applications.\r\n\r\nKey Responsibilities\r\n\r\nDesign, implement, and manage CI/CD pipelines\r\n\r\nAutomate infrastructure provisioning and configuration\r\n\r\nMonitor system performance, availability, and security\r\n\r\nManage cloud infrastructure and on-premise servers\r\n\r\nCollaborate with developers to optimize deployment workflows\r\n\r\nImplement backup, disaster recovery, and security best practices\r\n\r\nTroubleshoot production and deployment issues\r\n\r\nMaintain documentation for infrastructure and processes\r\n\r\nRequirements\r\n\r\nBachelor’s degree in Computer Science, Engineering, or related field\r\n\r\nProven experience as a DevOps Engineer or similar role\r\n\r\nStrong knowledge of Linux systems and server administration\r\n\r\nExperience with CI/CD tools (GitHub Actions, GitLab CI, Jenkins, etc.)\r\n\r\nFamiliarity with cloud platforms (AWS, Azure, GCP)\r\n\r\nExperience with containerization and orchestration tools (Docker, Kubernetes)\r\n\r\nKnowledge of scripting languages (Bash, Python, etc.)\r\n\r\nPreferred Qualifications\r\n\r\nExperience with Infrastructure as Code (Terraform, Ansible, CloudFormation)\r\n\r\nUnderstanding of monitoring and logging tools (Prometheus, Grafana, ELK)\r\n\r\nKnowledge of security and compliance best practices\r\n\r\nExperience working in Agile/Scrum environments\r\n\r\nWhat We Offer\r\n\r\nCompetitive salary and benefits\r\n\r\nFlexible work options\r\n\r\nOpportunity to work on scalable, real-world systems\r\n\r\nLearning and career growth opportunities', 'open', 'contract', '2026-03-07', '2026-02-11 11:31:58'),
(34, 'Host Engineer', 'IT', 'Remote', 'Job Title: Host Engineer\r\n\r\nLocation: [On-site / Remote / Hybrid]\r\nEmployment Type: Full-time\r\n\r\nJob Summary\r\n\r\nWe are looking for a skilled Product Engineer to design, build, and improve scalable products from concept to launch. The ideal candidate will work closely with product managers, designers, and other engineers to deliver high-quality, user-focused solutions.\r\n\r\nKey Responsibilities\r\n\r\nDesign, develop, test, and maintain product features and systems\r\n\r\nCollaborate with product and design teams to translate requirements into technical solutions\r\n\r\nParticipate in product planning, architecture decisions, and code reviews\r\n\r\nOptimize product performance, scalability, and reliability\r\n\r\nTroubleshoot, debug, and resolve production issues\r\n\r\nContinuously improve development processes and product quality\r\n\r\nDocument technical designs and implementation details\r\n\r\nRequirements\r\n\r\nBachelor’s degree in Engineering, Computer Science, or related field\r\n\r\nProven experience as a Product Engineer or Software Engineer\r\n\r\nStrong knowledge of programming languages and frameworks relevant to the product\r\n\r\nExperience working with APIs, databases, and version control systems\r\n\r\nSolid problem-solving and analytical skills\r\n\r\nAbility to work in a collaborative, cross-functional environment', 'open', 'contract', '2026-02-26', '2026-02-11 11:32:49');

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `conversation_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `message_body` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `conversation_id`, `user_id`, `admin_id`, `message_body`, `created_at`) VALUES
(1, 27, 5, NULL, 'I am getting a timeout when calling the /v1/auth endpoint.', '2026-01-20 10:30:05'),
(2, 27, 0, 2, 'Are you sending the request from a production server or localhost?', '2026-01-20 10:35:05'),
(3, 27, 5, NULL, 'From a production server. IP is 192.168.1.50.', '2026-01-20 10:40:05'),
(4, 27, 0, 2, 'I see the logs. Your IP was temporarily throttled for too many attempts.', '2026-01-20 10:45:05'),
(5, 27, 5, NULL, 'Ah, my script had a retry loop error. Can you whitelist it?', '2026-01-20 10:50:05'),
(6, 27, 0, 2, 'I have cleared the throttle. Please limit requests to 10 per second.', '2026-01-20 10:55:05'),
(7, 28, 39, NULL, 'The CSV importer is skipping the last 5 rows of my file.', '2026-01-20 11:10:05'),
(8, 28, 0, 3, 'Make sure there is a trailing newline at the end of your file.', '2026-01-20 11:15:05'),
(9, 28, 39, NULL, 'I just checked, the last row ends abruptly. Let me fix that.', '2026-01-20 11:20:05'),
(10, 28, 0, 3, 'Let me know if that resolves the skipping issue.', '2026-01-20 11:25:05'),
(11, 28, 39, NULL, 'That worked! It was a formatting issue on my end.', '2026-01-20 11:30:05'),
(12, 29, 1, NULL, 'Do you plan on adding Spanish language support to the dashboard?', '2026-01-20 11:50:05'),
(13, 29, 0, 1, 'Yes! Spanish and French are scheduled for the Q3 update.', '2026-01-20 11:55:05'),
(14, 29, 1, NULL, 'That is great news. My team in Madrid will be happy.', '2026-01-20 12:00:05'),
(15, 29, 0, 1, 'Would you like to join the Beta group to test the translations?', '2026-01-20 12:05:05'),
(16, 29, 1, NULL, 'Yes, please add my email to the tester list.', '2026-01-20 12:10:05'),
(17, 30, 2, NULL, 'I lost my phone and cannot access my 2FA codes.', '2026-01-20 12:30:05'),
(18, 30, 0, 2, 'Do you have your 16-character backup recovery key?', '2026-01-20 12:35:05'),
(19, 30, 2, NULL, 'I have it written down in my safe. One second.', '2026-01-20 12:40:05'),
(20, 30, 2, NULL, 'Okay, I found the key. How do I use it?', '2026-01-20 12:45:05'),
(21, 30, 0, 2, 'Select \"Try another way\" on the login screen and enter the key.', '2026-01-20 12:50:05'),
(22, 30, 2, NULL, 'I am back in! Deactivating the old 2FA now.', '2026-01-20 12:55:05'),
(23, 31, 3, NULL, 'Why am I getting \"Storage Full\" when I only have 10 files?', '2026-01-20 13:10:05'),
(24, 31, 0, 3, 'The limit is based on file size (MB), not the number of files.', '2026-01-20 13:15:05'),
(25, 31, 3, NULL, 'Oh, I see. I uploaded some 4K videos. That explains it.', '2026-01-20 13:20:05'),
(26, 31, 0, 3, 'If you delete those, your space will free up instantly.', '2026-01-20 13:25:05'),
(27, 32, 4, NULL, 'Can I add my VAT number to the automated invoices?', '2026-01-20 13:40:05'),
(28, 32, 0, 1, 'Yes, you can add it under Billing > Invoice Settings.', '2026-01-20 13:45:05'),
(29, 32, 4, NULL, 'Will it apply to previous invoices or just new ones?', '2026-01-20 13:50:05'),
(30, 32, 0, 1, 'It will only apply to future invoices. I can regenerate the last one for you.', '2026-01-20 13:55:05'),
(31, 32, 4, NULL, 'Please regenerate invoice #INV-882. Thank you!', '2026-01-20 14:00:05'),
(32, 32, 0, 1, 'Done. You can download the updated PDF now.', '2026-01-20 14:05:05'),
(33, 33, 39, NULL, 'I am not getting desktop notifications on Chrome.', '2026-01-20 14:20:05'),
(34, 33, 0, 2, 'Please check if you have \"Quiet Mode\" enabled in Windows/macOS.', '2026-01-20 14:25:05'),
(35, 33, 39, NULL, 'Quiet mode is off. Browser permissions are also allowed.', '2026-01-20 14:30:05'),
(36, 33, 0, 2, 'Try refreshing the site and clicking the \"Test Notification\" button.', '2026-01-20 14:35:05'),
(37, 33, 39, NULL, 'The test worked. I think it was a stuck browser tab.', '2026-01-20 14:40:05'),
(38, 34, 5, NULL, 'Is there a way to force the site to follow my system theme?', '2026-01-20 15:00:05'),
(39, 34, 0, 3, 'Yes, in Appearance settings, select \"System Default\".', '2026-01-20 15:05:05'),
(40, 34, 5, NULL, 'It keeps switching back to Light mode at sunset.', '2026-01-20 15:10:05'),
(41, 34, 0, 3, 'Check your OS settings to see if you have a scheduled Night Shift.', '2026-01-20 15:15:05'),
(42, 34, 5, NULL, 'That was it. My OS was overriding the browser. Fixed!', '2026-01-20 15:20:05'),
(43, 35, 1, NULL, 'Does your platform support outgoing webhooks for event triggers?', '2026-01-19 18:51:33'),
(44, 35, 5, 3, 'Yes, we support webhooks for 12 different event types including new signups.', '2026-01-19 19:01:33'),
(45, 35, 1, NULL, 'Can I customize the JSON payload sent by the webhook?', '2026-01-19 19:11:33'),
(46, 35, 0, 3, 'Currently, payloads are fixed, but you can use our transformation tool in the middle.', '2026-01-19 19:21:33'),
(47, 35, 1, NULL, 'Got it. Is there a retry logic if my server is down?', '2026-01-19 19:31:33'),
(48, 35, 0, 3, 'We retry up to 5 times with exponential backoff.', '2026-01-19 19:41:33'),
(49, 36, 39, NULL, 'I need to invite 10 members at once. Is there a bulk invite?', '2026-01-19 21:11:33'),
(50, 36, 0, 2, 'You can upload a CSV file with emails in the \"Team\" section.', '2026-01-19 21:21:33'),
(51, 36, 39, NULL, 'Does this assign roles automatically too?', '2026-01-19 21:31:33'),
(52, 36, 0, 2, 'If you add a \"Role\" column to the CSV, it will assign them during import.', '2026-01-19 21:41:33'),
(53, 36, 39, NULL, 'What are the valid role strings? \"Admin\", \"Member\", \"Viewer\"?', '2026-01-19 21:51:33'),
(54, 36, 0, 2, 'Exactly. Use those exact strings (case-sensitive).', '2026-01-19 22:01:33'),
(55, 37, 4, NULL, 'Where can I download our SOC2 compliance report?', '2026-01-19 22:51:33'),
(56, 37, 0, 1, 'Compliance documents are available in the Trust Center.', '2026-01-19 23:01:33'),
(57, 37, 4, NULL, 'The link in the footer seems to be broken for me.', '2026-01-19 23:11:33'),
(58, 37, 0, 1, 'Apologies. I will send the PDF directly to your registered email.', '2026-01-19 23:21:33'),
(59, 37, 4, NULL, 'Received it. Thank you for the quick turnaround.', '2026-01-19 23:31:33'),
(60, 38, 2, NULL, 'I heard there is a new AI-powered analytics tool in beta?', '2026-01-20 00:31:33'),
(61, 38, 0, 2, 'That is correct. It is currently in a closed pilot.', '2026-01-20 00:41:33'),
(62, 38, 2, NULL, 'Can my organization (User ID 2) be whitelisted for it?', '2026-01-20 00:51:33'),
(63, 38, 0, 2, 'I have submitted your request to the product manager.', '2026-01-20 01:01:33'),
(64, 38, 2, NULL, 'How long does the approval usually take?', '2026-01-20 01:11:33'),
(65, 38, 0, 2, 'Usually 2-3 business days. You will see a new tab in your dashboard.', '2026-01-20 01:21:33'),
(66, 39, 5, NULL, 'My changes on the web app are not showing up on my phone.', '2026-01-20 03:51:33'),
(67, 39, 0, 3, 'Please try a \"Pull to Refresh\" on the mobile dashboard.', '2026-01-20 04:01:33'),
(68, 39, 5, NULL, 'I tried that, but the old data still persists.', '2026-01-20 04:11:33'),
(69, 39, 0, 3, 'Are you on Wi-Fi or Cellular? Sometimes cellular sync is disabled in settings.', '2026-01-20 04:21:33'),
(70, 39, 5, NULL, 'Oh! I had \"Data Saver\" mode on. Disabling it now.', '2026-01-20 04:31:33'),
(71, 39, 0, 3, 'That should do it. Let me know if it syncs now.', '2026-01-20 04:41:33'),
(72, 40, 3, NULL, 'If I cancel today, do I lose access immediately?', '2026-01-20 05:31:33'),
(73, 40, 0, 1, 'No, you will have access until the end of your current billing cycle.', '2026-01-20 05:41:33'),
(74, 40, 3, NULL, 'What happens to my data after the cycle ends?', '2026-01-20 05:51:33'),
(75, 40, 0, 1, 'We keep it for 90 days in case you decide to reactivate.', '2026-01-20 06:01:33'),
(76, 40, 3, NULL, 'Can I export it before it gets deleted?', '2026-01-20 06:11:33'),
(77, 40, 0, 1, 'Yes, we recommend doing a full data export before the cycle ends.', '2026-01-20 06:21:33'),
(78, 41, 1, NULL, 'Just wanted to say the new UI update is incredible.', '2026-01-20 08:51:33'),
(79, 41, 0, 2, 'That is so kind of you! I will share this with the design team.', '2026-01-20 09:01:33'),
(80, 41, 1, NULL, 'The speed improvement is also very noticeable.', '2026-01-20 09:11:33'),
(81, 41, 0, 2, 'We optimized our database queries recently. Glad it helped!', '2026-01-20 09:21:33'),
(82, 42, 0, 1, 'Hi User 39, I noticed you had some failed login attempts earlier. Is everything okay?', '2026-01-20 06:59:35'),
(83, 42, 39, NULL, 'Oh, thanks for checking! I just had caps lock on by accident.', '2026-01-20 07:04:35'),
(84, 42, 0, 1, 'Glad to hear! Just a reminder to never share your credentials with anyone.', '2026-01-20 07:09:35'),
(85, 43, 0, 2, 'Hello User 1, we are performing scheduled maintenance on your server node tonight.', '2026-01-20 07:39:35'),
(86, 43, 1, NULL, 'Will there be any downtime for my API integrations?', '2026-01-20 07:44:35'),
(87, 43, 0, 2, 'Expect about 5 minutes of latency, but no total downtime is expected.', '2026-01-20 07:49:35'),
(88, 43, 1, NULL, 'Understood. I will pause my automated cron jobs during that window.', '2026-01-20 07:54:35'),
(89, 44, 0, 3, 'Hi User 5, based on your usage, we thought you might like our new advanced reporting tools.', '2026-01-20 08:59:35'),
(90, 44, 5, NULL, 'I was actually just looking for something like that! Is it a paid add-on?', '2026-01-20 09:04:35'),
(91, 44, 0, 3, 'Since you are a long-time user, I can enable a 30-day free trial for you.', '2026-01-20 09:09:35'),
(92, 44, 5, NULL, 'That would be excellent. Please go ahead and enable it.', '2026-01-20 09:14:35'),
(93, 44, 0, 3, 'It is now active! You will see a \"Reports+\" icon in your sidebar.', '2026-01-20 09:19:35'),
(94, 45, 0, 1, 'Hello User 2, your payment method is expiring in 3 days. Please update it to avoid service gaps.', '2026-01-20 10:39:35'),
(95, 45, 2, NULL, 'Thanks for the heads up. Does the system support PayPal now?', '2026-01-20 10:44:35'),
(96, 45, 0, 1, 'Not yet, we currently only support Visa, Mastercard, and AMEX.', '2026-01-20 10:49:35'),
(97, 45, 2, NULL, 'Okay, I will put my new Mastercard in the system tonight.', '2026-01-20 10:54:35'),
(98, 46, 0, 2, 'Hi User 4, how are you finding the new dashboard layout we launched last week?', '2026-01-20 12:19:35'),
(99, 46, 4, NULL, 'It is much cleaner, but I miss the quick-access button for \"Drafts\".', '2026-01-20 12:24:35'),
(100, 46, 0, 2, 'We actually moved that under the \"Compose\" dropdown to save space.', '2026-01-20 12:29:35'),
(101, 46, 4, NULL, 'Ah, I see it now. It takes one extra click but looks better.', '2026-01-20 12:34:35'),
(102, 47, 0, 3, 'User 3, we detected an unusual amount of data being exported from your account.', '2026-01-20 13:59:35'),
(103, 47, 3, NULL, 'That was me! I am doing a year-end audit for my taxes.', '2026-01-20 14:04:35'),
(104, 47, 0, 3, 'Perfect, just making sure. We have a high-security alert for large exports.', '2026-01-20 14:09:35'),
(105, 47, 3, NULL, 'I appreciate the vigilance. Better safe than sorry.', '2026-01-20 14:14:35'),
(106, 48, 0, 1, 'Hi 39, we have updated our Privacy Policy regarding data retention.', '2026-01-20 15:39:35'),
(107, 48, 39, NULL, 'Does this change how long my deleted files are kept?', '2026-01-20 15:44:35'),
(108, 48, 0, 1, 'Yes, the retention period has been reduced from 60 days to 30 days.', '2026-01-20 15:49:35'),
(109, 48, 39, NULL, 'Good to know. I will make sure to export anything important immediately.', '2026-01-20 15:54:35'),
(110, 49, 0, 2, 'Welcome back, User 5! I noticed you haven’t logged in for a few months.', '2026-01-20 17:19:35'),
(111, 49, 5, NULL, 'Yeah, I was away on sabbatical. Excited to see what’s new.', '2026-01-20 17:24:35'),
(112, 49, 0, 2, 'A lot has changed! Check out the \"What’s New\" section in the help docs.', '2026-01-20 17:29:35'),
(113, 50, 0, 3, 'User 1, the bug you reported regarding the API keys has been hotfixed.', '2026-01-20 17:59:35'),
(114, 50, 1, NULL, 'That was fast! Let me test the endpoint.', '2026-01-20 18:04:35'),
(115, 50, 1, NULL, 'Confirmed, it is returning the correct JSON structure now.', '2026-01-20 18:09:35'),
(116, 50, 0, 3, 'Excellent. Sorry for the disruption to your workflow.', '2026-01-20 18:14:35'),
(117, 50, 1, NULL, 'No problem at all. Thanks for the fix!', '2026-01-20 18:19:35'),
(118, 39, 5, NULL, 'i will try it now', '2026-01-21 07:42:54'),
(119, 39, 5, NULL, 'can you re explain', '2026-01-21 07:44:54'),
(120, 35, 5, 3, 'can you re explain', '2026-01-21 08:04:08'),
(121, 49, 5, NULL, 'am waiting', '2026-01-21 08:06:02'),
(122, 34, 5, NULL, '1w', '2026-01-21 08:12:41'),
(123, 34, 5, NULL, '1ws', '2026-01-21 08:21:11'),
(124, 34, 5, 3, 'only', '2026-01-21 08:21:42'),
(125, 34, 5, 3, 'hweb\nhushks', '2026-01-21 08:24:33'),
(126, 34, 5, 3, 'work', '2026-01-21 08:25:24'),
(127, 34, 5, 3, 'whats', '2026-01-21 08:25:57'),
(128, 39, 5, NULL, 'whats', '2026-01-21 08:26:11'),
(129, 35, 5, 3, 'whats', '2026-01-21 08:26:17'),
(130, 35, 5, NULL, 'whats is what', '2026-01-21 08:27:00'),
(131, 44, 5, NULL, 'ok', '2026-01-21 08:30:00'),
(132, 44, 5, 3, 'whats the are you seetin', '2026-01-21 08:31:05'),
(133, 27, 5, NULL, 'whats', '2026-01-21 08:34:42'),
(134, 44, 5, 3, 'hello sir/ma', '2026-01-21 08:38:58'),
(135, 27, 5, 2, 'w', '2026-01-21 08:45:46'),
(136, 49, 1, NULL, 'sir', '2026-01-21 08:49:00'),
(137, 49, 5, 3, 'goos', '2026-01-21 08:52:10'),
(138, 34, 5, 1, 'we', '2026-01-21 08:54:46'),
(139, 34, 2, NULL, 'q1', '2026-01-21 08:55:12'),
(140, 34, 1, NULL, 'uw7', '2026-01-21 08:55:52'),
(141, 39, 5, NULL, 'is the issue', '2026-01-26 08:10:00'),
(142, 39, 0, NULL, 'ghuiok', '2026-02-11 10:16:12'),
(143, 39, 0, 1, 'whats is it', '2026-02-11 10:18:35'),
(144, 39, 0, 1, 'Kindly give response', '2026-02-11 10:19:31');

--
-- Indexes for table `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `job_id` (`job_id`);

--
-- Indexes for table `job_openings`
--
ALTER TABLE `job_openings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- AUTO_INCREMENT for table `applications`
--
ALTER TABLE `applications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `job_openings`
--
ALTER TABLE `job_openings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `applications`
--
ALTER TABLE `applications`
  ADD CONSTRAINT `applications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `applications_ibfk_2` FOREIGN KEY (`job_id`) REFERENCES `job_openings` (`id`) ON DELETE CASCADE;
COMMIT;

