-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Apr 17, 2026 at 07:29 AM
-- Server version: 8.3.0
-- PHP Version: 8.2.18

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mbs_website_portal`
--

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

--
-- Table structure for table `consumer_complaints`
--

DROP TABLE IF EXISTS `consumer_complaints`;
CREATE TABLE IF NOT EXISTS `consumer_complaints` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `complainant_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `department` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supporting_docs` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `consumer_complaints`
--

INSERT INTO `consumer_complaints` (`id`, `complainant_name`, `email`, `phone`, `organisation`, `location`, `message`, `city`, `country`, `subject`, `description`, `status`, `department`, `supporting_docs`, `created_at`, `updated_at`) VALUES
(1, 'Sarah Msosa', 'sarahmsosa@mbsmw.org', '0886097333', 'Malawi Bureau of Standards', 'HQ', NULL, 'Blantyre', 'Malawi', 'Library membership', 'Library membership', 'pending', 'fInance', 'supporting_docs/ZAo6QjO5XcbYtRL5KCZeJNPePX3S7UUWsi0bRnrH.pdf', '2025-08-28 06:11:03', '2025-08-28 06:11:03'),
(2, 'Sarah Msosa', 'sarahmsosa@mbsmw.org', '0886097333', 'Malawi Bureau of Standards', 'HQ', 'hello', 'Blantyre', 'Malawi', 'Library membership application', 'Library membership application', 'Resolved', 'HRA', NULL, '2025-08-28 10:34:40', '2025-09-03 09:10:15'),
(9, 'Blessings Mlundira', 'blessingsmlundira@gmail.com', '0882211752', 'Fresh Food Farms', 'Central Region, Area 12', 'officer, review the submitted documents', 'Lilongwe', 'Malawi', 'Waiting for certification', 'i applied for certification, but i still havent received any feedback, what is going on', 'Resolved', NULL, NULL, '2025-09-09 05:32:10', '2025-09-09 07:53:46'),
(10, 'john banda', 'johnmanda@gmail.com', '0882211752', 'fast foods org', 'Lilongwe', 'added this message', 'Lilongwe', 'Malawi', 'certification', 'still waiting for our certificate', 'Resolved', 'TSD', 'supporting_docs/8vPfya8n8Myd3B25bIBXKZVxjkHFj1VOt1W95siH.png', '2025-09-11 06:01:06', '2025-09-11 07:48:45');

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

--
-- Table structure for table `email_template`
--

DROP TABLE IF EXISTS `email_template`;
CREATE TABLE IF NOT EXISTS `email_template` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_template`
--

INSERT INTO `email_template` (`id`, `created_at`, `updated_at`, `content`, `name`, `subject`) VALUES
(1, NULL, NULL, '<!DOCTYPE html>\n                <html lang=\"en\">\n                <head>\n                    <meta charset=\"utf-8\">\n                    <meta name=\"viewport\" content=\"width=device-width\">\n                    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\"> \n                    <meta name=\"x-apple-disable-message-reformatting\">\n                    <title>Example</title>\n                    <style>\n                        body {\n                            background-color:#fff;\n                            color:#222222;\n                            margin: 0px auto;\n                            padding: 0px;\n                            height: 100%;\n                            width: 100%;\n                            font-weight: 400;\n                            font-size: 15px;\n                            line-height: 1.8;\n                        }\n                        .continer{\n                            width:400px;\n                            margin-left:auto;\n                            margin-right:auto;\n                            background-color:#efefef;\n                            padding:30px;\n                        }\n                        .btn{\n                            padding: 5px 15px;\n                            display: inline-block;\n                        }\n                        .btn-primary{\n                            border-radius: 3px;\n                            background: #0b3c7c;\n                            color: #fff;\n                            text-decoration: none;\n                        }\n                        .btn-primary:hover{\n                            border-radius: 3px;\n                            background: #4673ad;\n                            color: #fff;\n                            text-decoration: none;\n                        }\n                    </style>\n                </head>\n                <body>\n                    <div class=\"continer\">\n                        <h1>Lorem ipsum dolor</h1>\n                        <h4>Ipsum dolor cet emit amet</h4>\n                        <p>\n                            Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea <strong>commodo consequat</strong>. \n                            Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. \n                            Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\n                        </p>\n                        <h4>Ipsum dolor cet emit amet</h4>\n                        <p>\n                            Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod <a href=\"#\">tempor incididunt ut labore</a> et dolore magna aliqua.\n                            Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. \n                        </p>\n                        <h4>Ipsum dolor cet emit amet</h4>\n                        <p>\n                            Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\n                            Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. \n                        </p>\n                        <a href=\"#\" class=\"btn btn-primary\">Lorem ipsum dolor</a>\n                        <h4>Ipsum dolor cet emit amet</h4>\n                        <p>\n                            Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\n                            Ut enim ad minim veniam, quis nostrud exercitation <a href=\"#\">ullamco</a> laboris nisi ut aliquip ex ea commodo consequat. \n                            Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. \n                            Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\n                        </p>\n                    </div>\n                </body>\n                </html>', 'Example E-mail', 'Example E-mail');

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

--
-- Table structure for table `example`
--

DROP TABLE IF EXISTS `example`;
CREATE TABLE IF NOT EXISTS `example` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_id` int UNSIGNED NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `example`
--

INSERT INTO `example` (`id`, `created_at`, `updated_at`, `name`, `description`, `status_id`) VALUES
(1, NULL, NULL, 'Occaecati maxime suscipit ducimus labore voluptas.', 'Nulla itaque non impedit id quis. Reiciendis perspiciatis officia nihil non.', 1),
(2, NULL, NULL, 'Voluptas voluptatibus sit excepturi ut.', 'Nesciunt aspernatur culpa itaque commodi temporibus veritatis.', 2),
(3, NULL, NULL, 'Rerum dolores est tempore illum.', 'Nemo eum consequatur alias adipisci blanditiis in.', 3),
(4, NULL, NULL, 'Animi autem unde modi perferendis.', 'Nemo aliquam accusantium voluptate adipisci dignissimos doloremque rerum exercitationem. Architecto aut velit repudiandae et.', 3),
(5, NULL, NULL, 'Natus animi consectetur ipsum facere.', 'Dolore blanditiis praesentium ut aperiam. Et assumenda quo quae quidem illum dolorem corporis.', 4),
(6, NULL, NULL, 'Nostrum ut commodi magnam.', 'Quia ducimus doloremque quam.', 4),
(7, NULL, NULL, 'Perspiciatis voluptas non quis id magni.', 'Voluptate quia rerum iusto commodi. Excepturi dolores vel ducimus laborum.', 1),
(8, NULL, NULL, 'Repudiandae quia quod in.', 'Eius quaerat neque cupiditate velit voluptatem numquam. Sequi omnis quia magni ad.', 2),
(9, NULL, NULL, 'Delectus molestiae ut atque.', 'Illo laboriosam labore dolore necessitatibus.', 2),
(10, NULL, NULL, 'Beatae molestiae officiis.', 'Voluptatem animi adipisci sit reiciendis magnam. Ab optio et ut et quas voluptatem ullam.', 4),
(11, NULL, NULL, 'Quae adipisci dolores enim dolorum praesentium.', 'Cum ullam enim quis saepe sint eveniet consequatur deleniti.', 1),
(12, NULL, NULL, 'Mollitia sed mollitia aspernatur soluta.', 'Minus veritatis repellat voluptatem veritatis quo qui. Assumenda quos est quia voluptatem.', 1),
(13, NULL, NULL, 'Alias dolor dolorum omnis non iusto.', 'Enim omnis commodi temporibus velit non quas quaerat dolor.', 1),
(14, NULL, NULL, 'Asperiores atque tenetur dolor sit ipsa.', 'Commodi est vel ut quia. Provident magni qui et tempora.', 3),
(15, NULL, NULL, 'Reiciendis eos nemo aliquid et reprehenderit.', 'Repellendus ut repellendus perspiciatis nobis ducimus natus praesentium. Nemo voluptatem sed molestias cum ex.', 1),
(16, NULL, NULL, 'Optio mollitia ipsa.', 'Harum temporibus incidunt eaque omnis sequi facilis soluta. Et est deserunt ut laudantium molestiae blanditiis at.', 3),
(17, NULL, NULL, 'Nobis esse perferendis.', 'Blanditiis et porro placeat eum suscipit vero. Incidunt aperiam laudantium officiis et est a.', 4),
(18, NULL, NULL, 'Dolor repellendus id est.', 'Inventore cumque ea accusamus voluptatem. Accusamus ex magni pariatur ipsum sed reprehenderit.', 1),
(19, NULL, NULL, 'Asperiores suscipit est incidunt.', 'Perferendis dolore repellendus numquam. Dicta eos aut molestias consectetur.', 4),
(20, NULL, NULL, 'Porro dolorem in velit.', 'Quia qui eos similique assumenda similique id. Error consequatur tempora quibusdam eligendi quos consectetur.', 4),
(21, NULL, NULL, 'Et rerum nesciunt voluptatum ut.', 'Nihil enim natus omnis.', 3),
(22, NULL, NULL, 'Voluptas consectetur natus minus beatae.', 'Quo et modi id facere dolor eum saepe. Pariatur sequi et fugiat ab sapiente maxime et eum.', 4),
(23, NULL, NULL, 'Dolore voluptatem aut ut.', 'Facilis facere provident qui praesentium optio.', 3),
(24, NULL, NULL, 'Voluptas accusamus vitae harum qui.', 'Praesentium minus quia accusantium perferendis. Nesciunt neque recusandae reprehenderit est neque fugiat.', 4),
(25, NULL, NULL, 'Et perspiciatis architecto asperiores.', 'Est assumenda sit et voluptates voluptatem adipisci veniam. Atque nostrum laborum in.', 4);

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

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `folder`
--

DROP TABLE IF EXISTS `folder`;
CREATE TABLE IF NOT EXISTS `folder` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `folder_id` int UNSIGNED DEFAULT NULL,
  `resource` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `folder`
--

INSERT INTO `folder` (`id`, `created_at`, `updated_at`, `name`, `folder_id`, `resource`) VALUES
(1, NULL, NULL, 'root', NULL, NULL),
(2, NULL, NULL, 'resource', 1, 1),
(3, NULL, NULL, 'documents', 1, NULL),
(4, NULL, NULL, 'graphics', 1, NULL),
(5, NULL, NULL, 'other', 1, NULL);

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

--
-- Table structure for table `form`
--

DROP TABLE IF EXISTS `form`;
CREATE TABLE IF NOT EXISTS `form` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `read` tinyint(1) NOT NULL,
  `edit` tinyint(1) NOT NULL,
  `add` tinyint(1) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  `pagination` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `form`
--

INSERT INTO `form` (`id`, `created_at`, `updated_at`, `name`, `table_name`, `read`, `edit`, `add`, `delete`, `pagination`) VALUES
(1, NULL, NULL, 'Example', 'example', 1, 1, 1, 1, 5);

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

--
-- Table structure for table `form_field`
--

DROP TABLE IF EXISTS `form_field`;
CREATE TABLE IF NOT EXISTS `form_field` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `browse` tinyint(1) NOT NULL,
  `read` tinyint(1) NOT NULL,
  `edit` tinyint(1) NOT NULL,
  `add` tinyint(1) NOT NULL,
  `relation_table` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relation_column` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_id` int UNSIGNED NOT NULL,
  `column_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `form_field`
--

INSERT INTO `form_field` (`id`, `created_at`, `updated_at`, `name`, `type`, `browse`, `read`, `edit`, `add`, `relation_table`, `relation_column`, `form_id`, `column_name`) VALUES
(1, NULL, NULL, 'Title', 'text', 1, 1, 1, 1, NULL, NULL, 1, 'name'),
(2, NULL, NULL, 'Description', 'text_area', 1, 1, 1, 1, NULL, NULL, 1, 'description'),
(3, NULL, NULL, 'Status', 'relation_select', 1, 1, 1, 1, 'status', 'name', 1, 'status_id');

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

--
-- Table structure for table `home_sections`
--

DROP TABLE IF EXISTS `home_sections`;
CREATE TABLE IF NOT EXISTS `home_sections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `section` varchar(50) NOT NULL,
  `heading` varchar(255) NOT NULL,
  `url_link` varchar(2000) DEFAULT NULL,
  `content` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `order` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `home_sections`
--

INSERT INTO `home_sections` (`id`, `section`, `heading`, `url_link`, `content`, `image`, `order`, `created_at`, `updated_at`) VALUES
(11, 'carousel', 'GET YOUR PRODUCT TESTED', 'TestingLaboratories', 'Testing Services For Product Certification', 'public/home_sections/1760357445_DSC09576.JPG', 7, '2025-10-13 10:10:45', '2026-04-09 08:55:26'),
(10, 'carousel', 'MBS Hosts Malawi Defence Force Students on Staff and Command Course', 'mediaPublications/story1', 'MBS hosted Malawi Defence Force students on 21st October 2025 to highlight how standards promote safety, innovation, and national development.', 'public/home_sections/1761738369_Picture1.jpg', 6, '2025-10-13 10:08:24', '2026-04-09 08:55:36'),
(12, 'carousel', 'MBS AND WFP SIGNS MOU TO INCREASE COMMERCIALIZATION OF AGRICULTURE PRODUCTS.', 'mediaPublications/story2', 'MBS and WFP have signed an MoU to enhance food quality and increase market access for Malawi’s agricultural products. The collaboration will strengthen MBS’s certification capacity and support farmers in reaching international markets.', 'public/home_sections/1761743974_44.jpg', 8, '2025-10-13 10:12:18', '2026-04-09 08:54:12'),
(15, 'projects', 'Implementation of Management Information System (MIS)', NULL, 'The Malawi Bureau of Standards (MBS) is implementing a Management Information System (MIS) with the aim of automating its processes and workflows. Currently, the core activities for MBS are almost exclusively paper-based with a lack of modern electronic systems, especially for import and export certification and laboratory management, which is a factor that has hampered efficiency in cross boarder clearance services rendered to the trading community.', 'public/home_sections/1763976628_mis-acronym-management-information-system-260nw-2413343361.webp', 4, '2025-10-13 11:57:45', '2025-11-24 09:30:28'),
(33, 'projects', 'Automated System for Customs Data (ASYCUDA) Project', NULL, 'The Malawi Bureau of Standards implements the Imports Quality Monitoring Scheme (IQMS) to monitor compliance of imported products and ensure that substandard products, which may endanger the health and safety of consumers in Malawi, do not find their way into the market.', 'public/home_sections/1764080119_ascyuda.png', 5, '2025-11-25 12:15:19', '2025-12-10 08:50:16'),
(22, 'what_we_do', 'Testing Services', NULL, 'MBS evaluates the quality, safety, and performance of products, materials, or processes to ensure they meet specific standards and regulatory requirements.', NULL, 9, '2025-10-14 10:01:32', '2025-11-14 09:05:39'),
(21, 'what_we_do', 'Develop and review Malawi standards', NULL, 'Create, update, and refine national standards for various products, services, processes, and systems in Malawi.', NULL, 8, '2025-10-14 10:00:20', '2025-11-14 09:05:39'),
(23, 'what_we_do', 'Product certification and Inspectorate services', NULL, 'Integral components of the national regulatory framework designed to ensure that products meet established standards for quality, safety, and performance.', NULL, 10, '2025-10-14 10:02:12', '2025-10-14 14:17:40'),
(24, 'what_we_do', 'Consumer complaints handling', NULL, 'Safeguarding consumer rights, promoting product safety, and ensuring that businesses adhere to established standards.', NULL, 11, '2025-10-14 10:03:32', '2025-10-14 14:17:40'),
(25, 'what_we_do', 'Verification and calibration services', NULL, 'Ensuring the accuracy and reliability of measurement instruments, equipment, and systems used in various industries.', NULL, 12, '2025-10-14 10:04:12', '2025-10-14 14:17:40'),
(30, 'certification-marks', 'Pre-certified Mark', NULL, 'Certification issued to products or services that meet preliminary conformity assessment criteria as set in the Malawi Standards.', 'public/home_sections/1760449148_pre-certified.jpg', 15, '2025-10-14 11:39:08', '2025-11-14 10:43:27'),
(28, 'what_we_do', 'WTO/SPS inquiry point', NULL, 'Designated body or contact point established under the World Trade Organization (WTO) framework to provide information and handle inquiries related to Sanitary and Phytosanitary (SPS) Measures in international trade.', NULL, 13, '2025-10-14 10:07:31', '2025-11-24 06:42:05'),
(31, 'certification-marks', 'Certified Mark', NULL, 'Formal symbol of assurance that a product, service, or process fully complies with the relevant Malawi standards.', 'public/home_sections/1763562202_certification-mark.jpg', 14, '2025-10-14 11:40:14', '2025-11-19 14:23:22'),
(35, 'carousel', 'MBS RECOGNISED FOR STRENGTHENING GOVERNANCE AT NATIONAL INVESTMENT FORUM', 'mediaPublications/story35', 'This award is a testament to the essential role that the MBS plays in advancing the Malawi 2063 pillars, including Industrialization, Urbanization and Agricultural Productivity & Commercialization, by upholding quality standards and strengthening accountability across industries.', 'public/home_sections/1765784876_cdf307f9d1fa43e0862a4e5f5417c51b.jpg', 3, '2025-12-15 05:47:56', '2026-04-09 08:56:00'),
(34, 'carousel', 'MBS Sponsors Mzuzu University Open Innovation Day', 'mediaPublications/story34', 'The Malawi Bureau of Standards (MBS) reaffirmed its commitment to promoting innovation and quality-driven development by sponsoring the Mzuzu University (MZUNI) Open Innovation Day with a contribution of K3 million under the Silver Sponsorship category.', 'public/home_sections/1764227374_IMG-20251126-WA0405.jpg', 5, '2025-11-26 06:50:50', '2026-04-09 08:55:37'),
(36, 'carousel', 'MBS Launches ISO CASCO National Mirror Committee and Conducts Stakeholders Training', 'mediaPublications/story36', 'An ISO mirror committee is a national committee established by a country’s national standards body (NSB) in this case, the MBS, to mirror the work of an international ISO Technical Committee (TC)', 'public/home_sections/1765786274_ISO-CASCO-GROPU-PHOTO.jpg', 4, '2025-12-15 06:05:53', '2026-04-09 08:55:49'),
(37, 'carousel', 'APPOINTMENT OF DIRECTOR GENERAL', NULL, 'The Malawi Bureau of Standards Board is pleased to announce the appointment of                    Mr. Symon O. Mandala as its new Director General.\r\nMr. Mandala returns to the Malawi Bureau of Standards (MBS) having previously served the institution as Director General from 21st February 2019 to 20th February 2022. His appointment brings back to the MBS a seasoned scientist and accomplished leader with over 20 years of experience in science, technology, environmental management and public sector administration.', 'public/home_sections/1774013920_DIRECTOR GENERAL.jpeg', 2, '2026-03-20 11:38:40', '2026-04-09 08:56:07');

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

--
-- Table structure for table `media`
--

DROP TABLE IF EXISTS `media`;
CREATE TABLE IF NOT EXISTS `media` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  `collection_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` bigint UNSIGNED NOT NULL,
  `uuid` bigint UNSIGNED NOT NULL,
  `manipulations` json NOT NULL,
  `custom_properties` json NOT NULL,
  `responsive_images` json NOT NULL,
  `order_column` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `memos`
--

DROP TABLE IF EXISTS `memos`;
CREATE TABLE IF NOT EXISTS `memos` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `menulist`
--

DROP TABLE IF EXISTS `menulist`;
CREATE TABLE IF NOT EXISTS `menulist` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menulist`
--

INSERT INTO `menulist` (`id`, `name`) VALUES
(1, 'sidebar menu'),
(2, 'top menu');

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

--
-- Table structure for table `menus`
--

DROP TABLE IF EXISTS `menus`;
CREATE TABLE IF NOT EXISTS `menus` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `href` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int UNSIGNED DEFAULT NULL,
  `menu_id` int UNSIGNED NOT NULL,
  `sequence` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `href`, `icon`, `slug`, `parent_id`, `menu_id`, `sequence`) VALUES
(2, 'Main Site', '/', 'cil-home', 'link', NULL, 1, 1),
(7, 'Assistant Query Management', '/query_management', 'cil-user-follow', 'link', NULL, 1, 7),
(5, 'Department Queries', '/department_rep', 'cil-balance-scale', 'link', NULL, 1, 5),
(4, 'Home Page', '/home_page', 'cil-pencil', 'link', NULL, 1, 4),
(68, 'Who we are', '', 'cil-people', 'dropdown', NULL, 1, 4),
(69, 'About us', '', 'cil-pencil', 'link', 68, 1, 1),
(70, 'MBS Management', '', 'cil-pencil', 'link', 68, 1, 2),
(71, 'MBS Strategic Plan ', '', 'cil-pencil', 'link', 68, 1, 3),
(72, 'Corporate Social Responsibility (CSR)', '', 'cil-pencil', 'link', 68, 1, 4);

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

--
-- Table structure for table `menu_role`
--

DROP TABLE IF EXISTS `menu_role`;
CREATE TABLE IF NOT EXISTS `menu_role` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `menus_id` int UNSIGNED NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_role`
--

INSERT INTO `menu_role` (`id`, `role_name`, `menus_id`) VALUES
(1, 'guest', 1),
(2, 'user', 1),
(3, 'admin', 1),
(4, 'user', 4),
(5, 'admin', 3),
(6, 'admin', 44),
(7, 'admin', 5),
(8, 'mbsDPT', 5),
(9, 'mbsAA', 7),
(10, 'admin', 8),
(11, 'admin', 9),
(12, 'admin', 10),
(13, 'guest', 11),
(14, 'guest', 12),
(15, 'user', 13),
(16, 'admin', 13),
(17, 'user', 14),
(18, 'admin', 14),
(19, 'user', 15),
(20, 'admin', 15),
(21, 'user', 16),
(22, 'admin', 16),
(23, 'user', 17),
(24, 'admin', 17),
(25, 'user', 18),
(26, 'admin', 18),
(27, 'user', 19),
(28, 'admin', 19),
(29, 'user', 20),
(30, 'admin', 20),
(31, 'user', 21),
(32, 'admin', 21),
(33, 'user', 22),
(34, 'admin', 22),
(35, 'user', 23),
(36, 'admin', 23),
(37, 'user', 24),
(38, 'admin', 24),
(39, 'user', 25),
(40, 'admin', 25),
(41, 'user', 26),
(42, 'admin', 26),
(43, 'user', 27),
(44, 'admin', 27),
(45, 'user', 28),
(46, 'admin', 28),
(47, 'user', 29),
(48, 'admin', 29),
(49, 'user', 30),
(50, 'admin', 30),
(51, 'user', 31),
(52, 'admin', 31),
(53, 'user', 32),
(54, 'admin', 32),
(55, 'user', 33),
(56, 'admin', 33),
(57, 'user', 34),
(58, 'admin', 34),
(59, 'user', 35),
(60, 'admin', 35),
(61, 'user', 36),
(62, 'admin', 36),
(63, 'user', 37),
(64, 'admin', 37),
(65, 'user', 38),
(66, 'admin', 38),
(67, 'user', 39),
(68, 'admin', 39),
(69, 'user', 40),
(70, 'admin', 40),
(71, 'user', 41),
(72, 'admin', 41),
(73, 'user', 42),
(74, 'admin', 42),
(75, 'user', 43),
(76, 'admin', 43),
(77, 'user', 44),
(78, 'admin', 44),
(79, 'user', 45),
(80, 'admin', 45),
(81, 'user', 46),
(82, 'admin', 46),
(83, 'user', 47),
(84, 'admin', 47),
(85, 'user', 48),
(86, 'admin', 48),
(87, 'user', 49),
(88, 'admin', 49),
(89, 'user', 50),
(90, 'admin', 50),
(91, 'user', 51),
(92, 'admin', 51),
(93, 'user', 52),
(94, 'admin', 52),
(95, 'user', 53),
(96, 'admin', 53),
(97, 'guest', 54),
(98, 'user', 54),
(99, 'admin', 54),
(100, 'guest', 55),
(101, 'user', 55),
(102, 'admin', 55),
(103, 'guest', 56),
(104, 'user', 56),
(105, 'admin', 56),
(106, 'guest', 57),
(107, 'user', 57),
(108, 'admin', 57),
(109, 'user', 58),
(110, 'admin', 58),
(111, 'admin', 59),
(112, 'admin', 60),
(113, 'admin', 61),
(114, 'admin', 62),
(115, 'admin', 63),
(116, 'admin', 64),
(117, 'admin', 65),
(118, 'admin', 66),
(119, 'user', 68),
(120, 'user', 69),
(121, 'user', 70),
(122, 'user', 71),
(123, 'user', 72);

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

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

DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `complaint_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `messages_user_id_foreign` (`user_id`),
  KEY `messages_complaint_id_user_id_index` (`complaint_id`,`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `messages` (`id`, `complaint_id`, `user_id`, `message`, `created_at`, `updated_at`) VALUES
(1, 10, 15, 'This has been received', '2025-09-11 07:17:53', '2025-09-11 07:17:53');

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

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_10_11_085455_create_notes_table', 1),
(5, '2019_10_12_115248_create_status_table', 1),
(6, '2019_11_08_102827_create_menus_table', 1),
(7, '2019_11_13_092213_create_menurole_table', 1),
(8, '2019_12_10_092113_create_permission_tables', 1),
(9, '2019_12_11_091036_create_menulist_table', 1),
(10, '2019_12_18_092518_create_role_hierarchy_table', 1),
(11, '2020_01_07_093259_create_folder_table', 1),
(12, '2020_01_08_184500_create_media_table', 1),
(13, '2020_01_21_161241_create_form_field_table', 1),
(14, '2020_01_21_161242_create_form_table', 1),
(15, '2020_01_21_161243_create_example_table', 1),
(16, '2020_03_12_111400_create_email_template_table', 1),
(17, '2024_09_24_074958_create_scans_table', 2),
(18, '2024_09_26_063135_create_memos_table', 2),
(19, '2025_02_06_082206_create_product_certifications_table', 2),
(20, '2025_02_10_130034_create_testing_calibration_requests_table', 3),
(21, '2025_09_04_080336_create_messages_table', 4);

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

--
-- Table structure for table `model_has_permissions`
--

DROP TABLE IF EXISTS `model_has_permissions`;
CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

DROP TABLE IF EXISTS `model_has_roles`;
CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 2),
(2, 'App\\Models\\User', 3),
(2, 'App\\Models\\User', 4),
(2, 'App\\Models\\User', 5),
(2, 'App\\Models\\User', 6),
(2, 'App\\Models\\User', 7),
(2, 'App\\Models\\User', 8),
(2, 'App\\Models\\User', 9),
(2, 'App\\Models\\User', 10),
(2, 'App\\Models\\User', 11),
(2, 'App\\Models\\User', 12),
(2, 'App\\Models\\User', 13),
(2, 'App\\Models\\User', 17),
(2, 'App\\Models\\User', 18),
(2, 'App\\Models\\User', 19),
(4, 'App\\Models\\User', 15),
(6, 'App\\Models\\User', 16);

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

--
-- Table structure for table `notes`
--

DROP TABLE IF EXISTS `notes`;
CREATE TABLE IF NOT EXISTS `notes` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `note_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `applies_to_date` date NOT NULL,
  `users_id` int UNSIGNED NOT NULL,
  `status_id` int UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notes`
--

INSERT INTO `notes` (`id`, `title`, `content`, `note_type`, `applies_to_date`, `users_id`, `status_id`, `created_at`, `updated_at`) VALUES
(1, 'Facilis odio est maxime minima aut.', 'Quo fugit doloremque quidem eveniet eos repudiandae ullam qui. In ut quos est dolorem. Ipsam sit ut corrupti laboriosam impedit.', 'ut', '1996-11-07', 2, 4, NULL, NULL),
(2, 'Reiciendis pariatur officiis.', 'Quia laudantium quo quae. Iusto earum aut consequatur nihil provident qui dolor voluptatum. Modi hic iusto tempora cumque.', 'hic', '1993-04-15', 6, 1, NULL, NULL),
(3, 'Vero dolorem vel sit eos odio.', 'Voluptatibus assumenda quis minima aliquid neque. Inventore ut ut iure animi quia. Ex sunt sint odio impedit. Voluptatem debitis amet nemo magni sed debitis quo accusantium.', 'quibusdam', '1999-04-18', 4, 2, NULL, NULL),
(4, 'Omnis aut autem unde.', 'Accusantium nisi qui sunt qui rem et qui. Assumenda consectetur accusamus culpa explicabo nesciunt tempora. Delectus tenetur a aut. Modi neque quia necessitatibus sit aut.', 'quis', '1995-04-26', 10, 2, NULL, NULL),
(5, 'Officiis iure omnis.', 'Maiores ipsa sunt neque odio est tempora. Numquam quod nemo veniam sequi et. Quis voluptatem minus quibusdam ea quae autem non. Totam aliquid autem possimus. Et voluptatibus voluptatem rem repellat.', 'harum magni', '1993-01-28', 4, 2, NULL, NULL),
(6, 'Odit temporibus eius.', 'Facere eos reprehenderit et ut magnam sint qui vel. Sed molestiae deserunt quia occaecati explicabo quo voluptatem molestiae. Sed architecto aut vel vel voluptas facere.', 'aut', '1979-07-02', 6, 3, NULL, NULL),
(7, 'Perspiciatis nesciunt est non.', 'Molestias repellat labore et. Rerum sapiente consequatur veniam aliquid recusandae. Esse omnis suscipit reiciendis minima porro.', 'quia', '2006-02-22', 2, 3, NULL, NULL),
(8, 'Adipisci modi quidem rem et.', 'Et et et consequatur maxime id perspiciatis ad. Vel illum illo cupiditate dolorem nisi veritatis. Hic ut in est maxime soluta. Pariatur ea quae omnis delectus commodi nostrum atque veniam.', 'eligendi', '2003-08-18', 10, 2, NULL, NULL),
(9, 'Exercitationem aliquam accusantium iusto dolorem excepturi.', 'Incidunt aliquam enim sed iure explicabo ut. Assumenda sunt enim et perspiciatis fugiat est excepturi. Ducimus voluptates asperiores est et. Aut voluptatem et ut eos enim.', 'voluptas exercitationem', '1995-11-17', 8, 1, NULL, NULL),
(10, 'Maxime quae earum aspernatur quas.', 'Assumenda quae illo ut minus. Quia consequatur quasi quam voluptatem doloribus. Perspiciatis nesciunt unde voluptatem possimus harum. Ducimus voluptatem necessitatibus placeat delectus quae.', 'sed illum', '1979-07-26', 10, 4, NULL, NULL),
(11, 'Ab dolore veritatis fugiat quis.', 'Ratione dignissimos qui omnis et cumque. Excepturi hic nesciunt ut modi dolore perferendis. Sit nobis tempora voluptas tempore magni suscipit. Consectetur repudiandae aut iusto sint voluptatibus vel sequi rerum.', 'aut', '2020-05-01', 4, 1, NULL, NULL),
(12, 'Hic distinctio et ea fugiat aliquam.', 'Dolore aut sunt nulla voluptatem tempora aperiam consequatur. Nisi eos quisquam vitae voluptatem. Blanditiis error earum est minima nam. Natus ipsa est et vel.', 'cum', '2010-04-28', 10, 4, NULL, NULL),
(13, 'Vitae nemo omnis sed est.', 'Soluta impedit aut reprehenderit ratione neque ut. Similique quod quasi excepturi.', 'ad', '2000-08-22', 11, 2, NULL, NULL),
(14, 'Quibusdam quae temporibus.', 'Maxime et blanditiis corporis ab reprehenderit eaque. Id et molestias et possimus est. Et voluptas animi et placeat voluptatem non nihil cupiditate.', 'ut quibusdam', '1977-04-21', 4, 4, NULL, NULL),
(15, 'Mollitia in expedita.', 'Autem reiciendis laboriosam vel rerum quia autem hic. Iusto quaerat nam aliquam aliquid. Quam aliquid et qui deserunt. Aspernatur eligendi omnis dicta reprehenderit est.', 'ducimus', '2009-01-29', 2, 2, NULL, NULL),
(16, 'Quia doloremque aut voluptatem animi.', 'Beatae culpa exercitationem quo magni. Aspernatur totam aut quia et. Sapiente nostrum omnis et eveniet. Illo quam iure veniam reprehenderit.', 'sit', '1970-09-20', 7, 2, NULL, NULL),
(17, 'Accusamus animi occaecati enim cumque tempora.', 'Repellendus eum natus facilis rerum reprehenderit laborum. Labore exercitationem molestiae voluptas placeat. Architecto magnam similique aperiam laborum. Est vel est consequatur nobis nam enim aspernatur.', 'provident', '1982-10-13', 9, 2, NULL, NULL),
(18, 'Assumenda ut sed magnam ipsa placeat.', 'Maiores quis cupiditate amet laudantium facilis ullam. Suscipit occaecati voluptatem voluptates temporibus aut facere. Est pariatur et est sit.', 'eveniet', '1992-06-29', 3, 1, NULL, NULL),
(19, 'Animi nisi rerum ipsum velit sint.', 'Possimus iure ratione suscipit. Eveniet soluta dolor impedit est exercitationem. Voluptates ex ad deleniti et maiores et temporibus.', 'sed', '2004-06-30', 11, 1, NULL, NULL),
(20, 'Minima cum sapiente ea commodi.', 'Nesciunt consequatur deleniti ullam numquam amet. Eum placeat et placeat porro voluptates quia sed. Quis velit possimus in est. Pariatur eum ad enim rerum corporis ea.', 'maxime', '2004-06-21', 6, 1, NULL, NULL),
(21, 'Asperiores consequatur corporis facilis cumque.', 'Et magnam voluptatem accusantium rem sequi ipsam omnis rem. Autem qui occaecati est cumque quos et officia quo. Excepturi aliquid perferendis numquam vitae. Velit ut esse tempore quaerat omnis tempora consequuntur. Dolores id doloremque qui aut.', 'aut', '1992-12-06', 5, 3, NULL, NULL),
(22, 'Maiores unde et doloribus dignissimos.', 'Voluptate non ullam asperiores quos nihil. Et et voluptatibus placeat assumenda aut sequi mollitia. Necessitatibus beatae impedit error nam.', 'quia', '2016-12-14', 5, 4, NULL, NULL),
(23, 'Suscipit dicta dolorem veniam deleniti.', 'Nihil fugiat quisquam omnis ipsum minima dolor similique. Ullam tempora assumenda laudantium commodi. Alias consequuntur nam placeat eius qui rerum ut. Quas eos qui quibusdam autem dolores et autem.', 'assumenda quis', '2000-02-09', 7, 3, NULL, NULL),
(24, 'Et soluta dolorum distinctio.', 'Dolorem non architecto consequuntur voluptatem hic. Adipisci vel odit beatae fuga error et. Dolores labore quidem quia dolores. Nihil sunt ut occaecati quia.', 'harum', '1993-03-21', 4, 3, NULL, NULL),
(25, 'Aut cumque sit laborum.', 'Eum voluptatem quibusdam rerum et quo enim officiis. Sed vero accusamus alias dicta similique iure at. Animi est dolorum iure fugiat officiis.', 'qui', '2011-05-15', 10, 4, NULL, NULL),
(26, 'Cumque rem facere.', 'Dolores quia autem rem deleniti aperiam. Aliquid quia omnis veniam harum officiis. Consequatur non enim quidem est architecto odit.', 'placeat dolores', '2016-06-20', 8, 3, NULL, NULL),
(27, 'Esse repellendus sed molestiae.', 'Rem dolorem excepturi accusantium repudiandae nemo. Sit omnis reiciendis et cumque soluta.', 'expedita', '1994-04-29', 11, 3, NULL, NULL),
(28, 'Provident officia exercitationem voluptatem itaque.', 'Et id aspernatur omnis. Possimus at alias doloremque nisi labore et aliquam. Necessitatibus earum totam aliquam numquam fugit dolorum reprehenderit nesciunt.', 'atque', '2002-12-17', 7, 2, NULL, NULL),
(29, 'Explicabo possimus officiis id qui.', 'Quae ex qui ullam est aut earum voluptas. Perspiciatis assumenda accusantium veritatis doloribus consequatur sed. Velit nobis saepe qui in et.', 'aspernatur', '1972-05-05', 6, 4, NULL, NULL),
(30, 'Hic similique esse dicta amet molestias.', 'Ut quas magnam nemo beatae alias consectetur beatae ad. Laudantium reprehenderit architecto quae sint.', 'tenetur debitis', '2025-08-22', 3, 3, NULL, NULL),
(31, 'Itaque sit quia.', 'Cum rerum minus beatae amet cumque reiciendis unde. Dolorum sit repudiandae at officiis. Veritatis distinctio perferendis totam quas quibusdam suscipit sunt. Aut ullam sit deleniti qui minima.', 'mollitia', '2022-09-12', 8, 4, NULL, NULL),
(32, 'Nostrum qui possimus.', 'Tenetur repudiandae occaecati omnis minima fugit animi voluptas. Voluptatibus debitis ad sed labore. Repellendus expedita ut dolor maiores laudantium dignissimos. Et dolorem quia maiores id.', 'sunt ea', '2012-01-31', 7, 2, NULL, NULL),
(33, 'Enim et velit.', 'Nisi quia ut debitis cum sint dolorem aut. In pariatur labore alias ut natus accusamus. Non nesciunt dolorem enim nostrum aspernatur quisquam. Voluptas vel et ut vitae.', 'aut delectus', '1975-11-17', 3, 1, NULL, NULL),
(34, 'Non aspernatur rem nihil.', 'Sunt voluptate ea velit sed eum quam molestiae. Facilis et provident maiores rerum dolor ut inventore. Ea nesciunt velit beatae ratione totam facere occaecati. Tenetur ut reiciendis pariatur sint.', 'quia', '2018-07-26', 2, 2, NULL, NULL),
(35, 'Omnis architecto quidem quos id.', 'Ut error qui alias. Qui quo quas debitis ullam sunt et. Saepe sunt error aliquid illo officiis error.', 'enim sed', '1976-09-04', 3, 4, NULL, NULL),
(36, 'Sed provident optio.', 'Et ut id ut sunt assumenda adipisci et quo. Dolores et et nemo culpa. Quisquam qui autem rerum dolores culpa ipsam cum quo.', 'nobis at', '2004-12-01', 4, 3, NULL, NULL),
(37, 'Quia repellat harum qui.', 'Vel error hic dolores accusamus. Ea quam neque dolorem rerum. Maxime in consequatur aperiam quo eum aliquid nemo dolorum. Pariatur accusantium ea repudiandae eius est. Non ea est non ullam.', 'est', '1990-03-31', 6, 4, NULL, NULL),
(38, 'Doloribus et dolor.', 'Totam a facere nostrum harum inventore voluptate et. Quidem doloribus repellendus dolores ipsum. Reiciendis ut pariatur rerum nihil harum odit.', 'quos neque', '2011-11-13', 10, 2, NULL, NULL),
(39, 'Velit consectetur asperiores ea.', 'Ea officia vel eum eaque. Voluptas blanditiis reprehenderit omnis. Incidunt corporis aut libero sed. Dolorum doloribus maiores corporis sint mollitia animi provident.', 'sit', '1989-04-30', 11, 3, NULL, NULL),
(40, 'Ab cumque quia.', 'Facere hic labore dolorem voluptas. Nihil incidunt quisquam dolor nostrum asperiores. Laboriosam sunt non ut.', 'sit eaque', '1980-11-12', 3, 2, NULL, NULL),
(41, 'Hic cum est laudantium quam.', 'Aperiam sunt culpa at et omnis. A omnis qui ex quia ducimus et. Ut provident ducimus temporibus minus at cupiditate. Saepe enim libero sed quos et accusamus expedita.', 'consequatur', '1983-10-05', 2, 4, NULL, NULL),
(42, 'Ex veniam nostrum esse nemo fuga.', 'Praesentium porro quas rerum voluptate incidunt consectetur non. Quia quo voluptatem aliquid quo. Voluptatum sint delectus quo doloribus dolor sunt.', 'iure', '1972-11-06', 2, 2, NULL, NULL),
(43, 'Quam nostrum saepe rem non.', 'Reiciendis et est non assumenda quia. Quia sed est magnam labore omnis. Esse eaque eveniet recusandae aut ex. A quaerat eos dicta nostrum voluptas non qui. Repellat ut quam quod atque ratione.', 'dicta iusto', '1977-10-24', 4, 1, NULL, NULL),
(44, 'Tempora excepturi quae.', 'Quam consequatur non enim quas mollitia. Voluptatum et aliquam adipisci officia aliquam. Necessitatibus rerum autem minima distinctio nihil eius aut. Deleniti iste dolorum ut quam et sed.', 'voluptatem voluptas', '1993-10-10', 3, 2, NULL, NULL),
(45, 'Mollitia magni aut quos.', 'Fugit aliquam voluptatem sapiente dicta reiciendis voluptatibus. Ut et ullam et nostrum sint illo aut. Porro magni perferendis dolorem et enim dolorem. Quo eos et doloribus quidem.', 'ut', '2006-10-29', 3, 1, NULL, NULL),
(46, 'Omnis sit voluptatem quia enim.', 'Nulla ad ex iusto fuga aut culpa dolorem aperiam. Laborum et non saepe labore. Quod accusamus illum voluptas laborum nihil voluptas. Harum eos eaque quibusdam ducimus hic.', 'veniam', '2019-03-07', 6, 4, NULL, NULL),
(47, 'Veritatis assumenda minima nihil.', 'Sed sit id a accusantium non. Voluptas ipsum omnis voluptas. Excepturi quos itaque porro suscipit eius. Aspernatur sunt eos sed nesciunt illo laborum. Ut unde iste dicta in distinctio.', 'ea est', '2016-08-16', 9, 1, NULL, NULL),
(48, 'Doloremque dolore est est.', 'Deserunt harum et ut omnis. In necessitatibus ea est in unde. Pariatur unde est soluta architecto itaque. Maiores possimus aut qui dolores architecto aut eius. Recusandae velit aperiam nobis voluptates praesentium.', 'debitis quam', '2008-05-22', 7, 3, NULL, NULL),
(49, 'Odio illo odit omnis sapiente.', 'Ratione molestiae qui error. Cupiditate voluptas ipsum velit corporis dolor sed omnis. Deleniti sed mollitia ut at. Ipsa et cum facere ea tempora molestias.', 'ut', '1977-03-25', 11, 1, NULL, NULL),
(50, 'Voluptas natus cumque sint.', 'A consequatur amet corporis sed. Recusandae est id non dignissimos reiciendis est minima assumenda. Sunt expedita tempore quaerat cum itaque natus omnis. Quo aliquam temporibus beatae quam ut aut.', 'doloribus', '2006-03-18', 4, 1, NULL, NULL),
(51, 'Accusamus officia rerum.', 'Similique sit magnam quo minus voluptas. Enim unde voluptatem aut corporis magni tenetur non quae.', 'ad eius', '1975-01-03', 6, 2, NULL, NULL),
(52, 'Qui sed sit.', 'Natus unde ut eligendi suscipit laudantium non quam vel. Et culpa praesentium natus et sequi ut. Ut neque quos ipsum dolore impedit.', 'fugiat', '1982-09-27', 11, 3, NULL, NULL),
(53, 'Et aliquid consectetur commodi aspernatur dolores.', 'Enim quibusdam omnis totam necessitatibus praesentium qui. Aut hic harum vitae saepe modi quia. Placeat quas facere iure itaque aut autem in. Repellat voluptates molestias qui magnam natus perferendis voluptatum aut.', 'rerum', '2015-02-11', 5, 1, NULL, NULL),
(54, 'Aut repellendus nulla.', 'Praesentium et qui sit commodi amet. Dicta voluptatem dolorem perspiciatis assumenda non. Sequi hic temporibus in doloribus ipsum maiores quia.', 'omnis rem', '1978-08-29', 11, 3, NULL, NULL),
(55, 'Voluptates est maiores quia.', 'Molestias eaque sapiente iure alias autem vel doloremque tenetur. Quidem eaque officia repellendus voluptas minima corporis.', 'mollitia', '2009-11-25', 9, 1, NULL, NULL),
(56, 'Deleniti velit voluptatem qui dolor.', 'Repellendus ducimus nam ut vero ipsa. Non quo dolores cupiditate exercitationem facilis. Et labore asperiores qui recusandae optio aspernatur explicabo.', 'et', '2006-02-28', 11, 4, NULL, NULL),
(57, 'Aliquid cumque commodi molestias.', 'Assumenda eum optio deserunt dolorum commodi corrupti est. Ipsum ea aut dolor aut odio eligendi minima. Consectetur soluta commodi dolorem voluptas consequatur.', 'expedita iste', '1974-04-25', 11, 3, NULL, NULL),
(58, 'Nulla maxime at quia est deserunt.', 'Aliquid error repellat est sunt fugiat in voluptatum. Velit facere voluptatum sapiente hic non enim. Iure omnis quia dolorem quae quam ut. Earum accusantium voluptatum fugit perferendis. Voluptatem laboriosam sunt qui perferendis quaerat consequatur recusandae.', 'voluptatibus ut', '2010-01-20', 8, 4, NULL, NULL),
(59, 'Ut accusamus quibusdam.', 'Voluptatum dolorem dolore nisi accusamus ullam. Ut culpa est consequuntur quasi nostrum porro reprehenderit. Vel est dicta sequi voluptatem. Ut architecto modi dignissimos qui maxime dolor.', 'corrupti omnis', '1976-05-26', 6, 3, NULL, NULL),
(60, 'Unde est repudiandae.', 'Saepe dolorem quas accusamus est similique. Saepe possimus est et repellendus dignissimos tempora. Et assumenda consequatur nobis odio ut et sunt. Explicabo repudiandae ex in architecto aut.', 'nisi', '2009-09-02', 9, 1, NULL, NULL),
(61, 'Autem neque architecto et.', 'Magni animi voluptates animi excepturi voluptas repudiandae dolor. Non ea sit beatae id eum nihil. Beatae autem odio veniam.', 'asperiores', '1972-06-09', 8, 1, NULL, NULL),
(62, 'Velit enim nam.', 'Eaque sit debitis et. Aliquid sunt aperiam ea facilis non quam amet.', 'est illo', '1992-10-07', 2, 4, NULL, NULL),
(63, 'Qui placeat eaque totam.', 'Repellendus aspernatur molestias voluptatem est fugit. Id at aut ut consequatur. Cumque cupiditate veritatis illo assumenda sit aut.', 'inventore expedita', '1985-10-30', 9, 3, NULL, NULL),
(64, 'Animi est sint itaque.', 'Cupiditate molestias atque occaecati distinctio. Minima excepturi aut nulla harum in ad autem. Dignissimos sapiente nisi tenetur error et nihil. Exercitationem aspernatur quia occaecati laboriosam. Hic voluptas earum deleniti aut.', 'itaque', '1970-06-08', 9, 1, NULL, NULL),
(65, 'Dolores voluptatem voluptate unde.', 'Natus iure aut dolores molestias aspernatur fuga. Dolor id qui consectetur veniam autem. Est voluptates animi aut provident eum. Magni voluptate a animi et.', 'ducimus', '1992-12-19', 4, 1, NULL, NULL),
(66, 'Iure autem et perferendis culpa.', 'Quis totam suscipit quo voluptas. Nesciunt architecto assumenda natus itaque. Impedit dolor sapiente tenetur esse maxime.', 'consequatur', '1987-05-14', 3, 2, NULL, NULL),
(67, 'Eos et quo a.', 'Eaque tenetur sint eum libero praesentium illum odio. Voluptas natus consequuntur totam aut. A ut architecto recusandae. Tempore sit vero odio.', 'voluptatum', '2022-05-02', 9, 4, NULL, NULL),
(68, 'Illum quod qui officia adipisci.', 'Porro dignissimos quaerat iure aliquam quisquam. Dolorem porro laborum qui minus laudantium. Id maxime dolor repellat omnis ipsum et. Rerum rerum magni impedit.', 'commodi', '2025-03-08', 8, 4, NULL, NULL),
(69, 'Odit expedita vel totam.', 'Vero temporibus qui mollitia minima. Aspernatur amet itaque neque debitis autem in eius. Fuga dolor odit a molestias minima. Alias vitae veniam ut facilis soluta.', 'vitae earum', '1987-11-15', 4, 1, NULL, NULL),
(70, 'Hic sunt et et quisquam.', 'Qui id voluptatibus similique voluptas qui. Quia sunt saepe sit omnis eveniet itaque. Voluptas quia error recusandae ratione tenetur non. Ea porro at omnis a sit.', 'hic', '1973-10-04', 3, 2, NULL, NULL),
(71, 'Sit aut assumenda autem et.', 'Voluptatum quia officia veritatis mollitia unde quos. Culpa sint est hic cum.', 'ea culpa', '2020-12-20', 10, 3, NULL, NULL),
(72, 'Id non ipsa recusandae.', 'Qui quis non corporis quaerat. Quia adipisci harum sed repudiandae unde et. Ullam aut quia tenetur. Sint facere praesentium eveniet optio.', 'est autem', '2012-04-19', 4, 3, NULL, NULL),
(73, 'Ut dicta adipisci est dolorem.', 'Est quos est aut saepe sequi. Beatae quia vel numquam deleniti. Odio qui ratione voluptatem dolore cupiditate facere corporis.', 'rerum quis', '1987-03-06', 8, 1, NULL, NULL),
(74, 'Natus qui labore ut suscipit.', 'Consequatur repellat omnis expedita magnam beatae pariatur. Ab minus qui itaque. Quia et quia nisi fugit culpa ea autem repellat. Ut eum occaecati nesciunt ipsa aut qui.', 'eos', '1998-05-11', 2, 4, NULL, NULL),
(75, 'Nobis rerum vitae veritatis a.', 'Ullam architecto facilis deserunt expedita eos et. Labore natus ipsa consectetur aliquid laudantium ipsa et. Necessitatibus ratione quis voluptatum velit numquam dolorem sed. Impedit numquam autem nisi sapiente quae ratione rerum.', 'commodi', '1989-05-25', 3, 1, NULL, NULL),
(76, 'Veniam reprehenderit magni vel sunt.', 'Nisi quis cumque unde. Ad quod nulla aut natus omnis dolores eos. Qui soluta qui qui nulla et. Rerum consequatur saepe libero ullam.', 'nesciunt', '2003-10-04', 10, 3, NULL, NULL),
(77, 'Nesciunt id error omnis.', 'Et facilis quasi id. Dolores assumenda est est ut saepe. Impedit earum ea et.', 'officiis nisi', '1972-10-05', 6, 2, NULL, NULL),
(78, 'In dolores dolores voluptatem officiis.', 'Ut facere placeat in ab nesciunt. Placeat et quaerat quos aut doloremque. Eos ut mollitia vero cum.', 'omnis', '1988-06-25', 8, 1, NULL, NULL),
(79, 'Nobis quia eos iste ut.', 'Nam minus fugiat voluptates atque qui. Voluptas ad magnam minus quia. Est perspiciatis unde tempore possimus accusamus ut amet. Nobis animi vitae voluptatum ea aliquid culpa iusto qui.', 'ut', '1988-03-26', 10, 4, NULL, NULL),
(80, 'Eum nulla ut hic sed.', 'Explicabo in expedita et sed aut ea accusantium. Voluptates saepe sed nulla voluptate laborum fugit. Et cupiditate ut non modi at sequi.', 'quaerat porro', '2013-08-01', 2, 1, NULL, NULL),
(81, 'Amet est quae fugit soluta aspernatur.', 'Nihil omnis dolorem dolorum qui deserunt alias ipsum. Esse voluptas consequatur omnis nihil incidunt recusandae eos soluta. Velit eligendi temporibus blanditiis corporis consequatur officia.', 'numquam non', '1979-09-05', 8, 2, NULL, NULL),
(82, 'Cum est numquam illo rerum a.', 'Ab aut quam animi quod aut earum. Recusandae est assumenda sunt iure. Et ut quae omnis fugiat voluptas nam. Sed voluptatem recusandae deserunt voluptatem molestiae quaerat ipsum.', 'voluptas quis', '2007-06-09', 4, 4, NULL, NULL),
(83, 'Perferendis numquam architecto est voluptatem.', 'Quis est voluptatem ipsa nesciunt voluptate. Itaque quia vitae deleniti et. Quia similique minus veritatis consequatur.', 'maiores', '2007-09-24', 5, 1, NULL, NULL),
(84, 'Officiis eaque provident.', 'Dolor aut fuga sed. Ut ea eligendi eius laudantium libero. Occaecati architecto voluptas esse fugit tempora ut hic.', 'illo impedit', '1971-09-14', 8, 3, NULL, NULL),
(85, 'Asperiores aut rerum qui eligendi quisquam.', 'Id qui nesciunt unde doloremque et perspiciatis nobis. Alias explicabo delectus maxime eaque voluptas accusamus illo numquam. Et soluta nesciunt doloremque. Aperiam voluptas qui et est aut voluptatem fugit.', 'corrupti', '2013-06-27', 9, 1, NULL, NULL),
(86, 'Qui beatae eum rerum est.', 'Repellendus dicta enim alias rerum est. Quia pariatur quia quia sapiente repellendus et aliquam. Voluptatum asperiores omnis non labore asperiores consectetur modi. Corrupti vero architecto est iste.', 'qui', '2015-03-04', 4, 3, NULL, NULL),
(87, 'Quae saepe odio deleniti.', 'Maxime aut odio sit. Rerum aut nobis iusto suscipit ut distinctio. Quia et repudiandae est ipsa autem possimus. Maxime inventore at et consectetur iusto.', 'corrupti ut', '1986-03-09', 5, 2, NULL, NULL),
(88, 'Dolore consectetur saepe odio corrupti.', 'Molestiae at et error sunt similique dolor ut eum. Et ipsa ut at qui et qui. Ea animi excepturi quod exercitationem repellat. Voluptates nam est ipsa et asperiores magnam. Aut perspiciatis ad assumenda nulla saepe consequatur.', 'enim', '2022-03-29', 5, 1, NULL, NULL),
(89, 'Tenetur temporibus culpa aut omnis.', 'Perspiciatis laudantium eaque cum ut nulla. Qui distinctio deleniti voluptatem earum omnis quo. Omnis nam laborum magni labore molestiae neque. Laudantium repudiandae qui deserunt nemo.', 'dolorem eius', '2016-06-28', 8, 4, NULL, NULL),
(90, 'Dolorem ducimus nemo explicabo.', 'Adipisci ut neque perferendis ea similique nostrum maxime ab. Numquam fugit perferendis quasi fuga in magni harum officiis. Occaecati voluptatibus repellat sit autem.', 'illo', '2021-07-20', 6, 1, NULL, NULL),
(91, 'Voluptas minima iusto cumque ad illum.', 'Et sit occaecati molestiae ex quia. Nam aut aut animi recusandae praesentium voluptatem ducimus. Veritatis sint qui dolor et praesentium dolor qui inventore.', 'magni atque', '1991-06-20', 3, 1, NULL, NULL),
(92, 'Cum porro consequatur incidunt.', 'Aut quisquam aut consequatur et ipsum est sequi. Veniam id sunt corporis corporis. Voluptate voluptas sed labore veritatis molestias consequuntur nulla.', 'aut', '2021-04-17', 5, 3, NULL, NULL),
(93, 'Animi molestias omnis aspernatur sed.', 'Tempora sunt et non velit id. Ut quidem optio vel architecto deleniti aut omnis. Cupiditate voluptatem eius vitae sit dicta voluptas.', 'sit suscipit', '2004-12-29', 3, 4, NULL, NULL),
(94, 'Aliquam doloremque voluptates tenetur eos.', 'Ipsa hic consequuntur laborum ut alias expedita. Voluptatem ipsum quidem distinctio velit ut. Quae iusto ipsam amet totam quo deleniti voluptatem. Placeat maiores dignissimos non. Mollitia quis aliquid sequi laudantium earum minus aut in.', 'fugit', '2016-08-03', 8, 4, NULL, NULL),
(95, 'Et modi et veniam non.', 'Fugiat illum sunt asperiores dignissimos. Totam animi provident incidunt. Et vero nobis totam possimus. Aliquam at quis deserunt dolor quisquam sint earum fugiat.', 'aut', '2013-07-05', 9, 3, NULL, NULL),
(96, 'Laborum nihil quis optio velit illo.', 'Omnis asperiores commodi in atque reiciendis a. Commodi porro quo neque. Sit in voluptatibus placeat ipsa hic nisi voluptatem.', 'non et', '2015-02-20', 4, 3, NULL, NULL),
(97, 'Corrupti vitae voluptatibus.', 'Eum quod nobis neque delectus aut. Consequatur illum odio id ipsa. Dolores maiores corrupti impedit voluptatem animi animi ipsam. Commodi repellendus optio expedita quas ducimus sed. Fuga doloremque in est blanditiis aut.', 'maiores', '2017-07-26', 4, 4, NULL, NULL),
(98, 'Vitae rerum mollitia temporibus.', 'Porro perferendis aut debitis. Illum expedita tempora et eum vero sed. Quia omnis impedit doloribus saepe.', 'doloribus dignissimos', '2017-10-27', 10, 2, NULL, NULL),
(99, 'Ut atque distinctio.', 'Sed ut tempore commodi nihil ad nemo. Eum accusamus doloribus voluptatem laudantium nam dolorem. Quis aut eos porro vel rerum. Commodi sunt hic et quidem corrupti ut et.', 'et', '2000-05-13', 2, 2, NULL, NULL),
(100, 'Officiis vero et.', 'Aut pariatur distinctio consequatur odit. Quia provident similique ut voluptates rerum libero ex. Delectus iusto sed eaque quae dolor.', 'sit beatae', '1976-02-20', 8, 4, NULL, NULL);

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

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'browse bread 1', 'web', '2025-08-27 09:17:28', '2025-08-27 09:17:28'),
(2, 'read bread 1', 'web', '2025-08-27 09:17:28', '2025-08-27 09:17:28'),
(3, 'edit bread 1', 'web', '2025-08-27 09:17:28', '2025-08-27 09:17:28'),
(4, 'add bread 1', 'web', '2025-08-27 09:17:28', '2025-08-27 09:17:28'),
(5, 'delete bread 1', 'web', '2025-08-27 09:17:28', '2025-08-27 09:17:28');

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

--
-- Table structure for table `product_certifications`
--

DROP TABLE IF EXISTS `product_certifications`;
CREATE TABLE IF NOT EXISTS `product_certifications` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_of_firm` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reg_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mra` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `street` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `plot_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_of_factory` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `factory_telephone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `factory_email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `factory_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `responsible_person_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_person_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_person_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `initial_assessment` date DEFAULT NULL,
  `trade_marks` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `public_notices`
--

DROP TABLE IF EXISTS `public_notices`;
CREATE TABLE IF NOT EXISTS `public_notices` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notice_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `published_date` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'web', '2025-08-27 09:17:25', '2025-08-27 09:17:25'),
(2, 'user', 'web', '2025-08-27 09:17:25', '2025-08-27 09:17:25'),
(3, 'guest', 'web', '2025-08-27 09:17:25', '2025-08-27 09:17:25'),
(4, 'mbsAA', 'web', '2025-08-27 09:17:25', '2025-08-27 09:17:25'),
(6, 'mbsDPT', 'web', '2025-09-01 05:19:13', '2025-09-01 05:19:13');

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

--
-- Table structure for table `role_has_permissions`
--

DROP TABLE IF EXISTS `role_has_permissions`;
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 3),
(2, 3),
(3, 3),
(4, 3),
(5, 3),
(6, 3);

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

--
-- Table structure for table `role_hierarchy`
--

DROP TABLE IF EXISTS `role_hierarchy`;
CREATE TABLE IF NOT EXISTS `role_hierarchy` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_id` int UNSIGNED NOT NULL,
  `hierarchy` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_hierarchy`
--

INSERT INTO `role_hierarchy` (`id`, `role_id`, `hierarchy`) VALUES
(1, 1, 1),
(2, 2, 2),
(3, 3, 3),
(4, 4, 4),
(5, 5, 5),
(6, 6, 6);

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

--
-- Table structure for table `scans`
--

DROP TABLE IF EXISTS `scans`;
CREATE TABLE IF NOT EXISTS `scans` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `data` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
CREATE TABLE IF NOT EXISTS `staff` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `password2` varchar(300) DEFAULT 'Default123',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=327 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `name`, `email`, `password`, `password2`, `created_at`, `updated_at`) VALUES
(1, 'Sarah Msosa', 'sarahmsosa@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHXxLdMdwA6', 'sarah2', '2025-11-18 12:37:53', '2025-11-19 12:07:00'),
(2, '', 'aaronmponda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(3, '', 'aarontembo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(4, '', 'abdulhassan@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(5, '', 'abelmanombo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(6, '', 'ackimchirwa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(7, '', 'adesakabanga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(8, '', 'aggreyfunsani@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(9, '', 'agnesskhembo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(10, '', 'ainamachinjiri@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(11, '', 'airspace@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(12, '', 'alexnguluwe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(13, '', 'alfredmologo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(14, '', 'alfredmoyo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(15, '', 'alicendalama@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(16, '', 'alickkatsonga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(17, '', 'andersonmbolembole@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(18, '', 'andrewbeyadi@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(19, '', 'andrewkachipande@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(20, '', 'anniebanda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(21, '', 'anniemaliha@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(22, '', 'anthonyeliya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(23, '', 'antivirus@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(24, '', 'arnoldnyirenda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(25, '', 'arthurkafanikhale@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(26, '', 'ashleynkhukuzalira@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(27, '', 'asiyagauti@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(28, '', 'atusayemhango@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(29, '', 'aubreybarabara@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(30, '', 'aubreynduna@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(31, '', 'austingomani@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(32, '', 'bahatkawombe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(33, '', 'barackkamzingeni@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(34, '', 'beatricemlande@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(35, '', 'benjaminkanyenda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(36, '', 'bensonnkhoma@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(37, '', 'bernadettamakina@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(38, '', 'bernardthole@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(39, '', 'billgwaza@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(40, '', 'bishophauya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(41, '', 'blessingsgama@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(42, '', 'blessingsmlundira@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(43, '', 'bridgetchiwaya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(44, '', 'brightdzoole@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(45, '', 'carolinempokosa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(46, '', 'chadwicknyanga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(47, '', 'chancyphiri@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(48, '', 'chaonachatepa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(49, '', 'charleschimbaza@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(50, '', 'charleskambauwa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(51, '', 'charlespinifolo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(52, '', 'chawanangwamello@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(53, '', 'chicconyemba@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(54, '', 'chiefbanda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(55, '', 'chifundobvumbwe nyirenda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(56, '', 'chifundoruben@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(57, '', 'chikondichinthenga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(58, '', 'chikondideus byson@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(59, '', 'chikondimatiki@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(60, '', 'chikondimatukuta@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(61, '', 'chikondimlombwa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(62, '', 'chikondindelema@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(63, '', 'chikumbutsobaza@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(64, '', 'chimangochibaya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(65, '', 'chimwemwebanda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(66, '', 'chimwemwekachonde@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(67, '', 'chipliromuruwesi@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(68, '', 'chisomogedion simango@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(69, '', 'chisomomalikita@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(70, '', 'chisomomombanya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(71, '', 'chitanikella@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(72, '', 'chrispinchigona@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(73, '', 'chrissienjiragoma@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(74, '', 'christopernkata@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(75, '', 'christopherdzuwa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(76, '', 'christopherkasonga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(77, '', 'christophermalala@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(78, '', 'christophermtonga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(79, '', 'claimschiyembekezo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(80, '', 'clementgondwe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(81, '', 'cosmasphiri@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(82, '', 'crightonmarorongwe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(83, '', 'damainokumwenda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(84, '', 'danaziokawonga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(85, '', 'danielkamwaza@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(86, '', 'danielmsasata@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(87, '', 'danmwalwayo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(88, '', 'daviejiya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(89, '', 'daviskamkwamba@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(90, '', 'daviskwanjana@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(91, '', 'davlinchokazinga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(92, '', 'daychavula@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(93, '', 'demsterkumvenji@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(94, '', 'dennisgogoda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(95, '', 'deusbyson@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(96, '', 'dickchikopa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(97, '', 'dicksonphiri@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(98, '', 'donnexmsowoya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(99, '', 'dorismhango@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(100, '', 'douglasstenala@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(101, '', 'edmorechihana@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(102, '', 'ednakalinde@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(103, '', 'edwardmagwaya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(104, '', 'edwardsaulo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(105, '', 'elijamanjawira@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(106, '', 'eliyakalitera@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(107, '', 'elizabethkayira@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(108, '', 'elizakunje@mbsmw.org', '', 'Default123', '2025-11-19 07:14:21', '2025-11-19 07:14:21'),
(109, '', 'ellardchirwa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(110, '', 'emmanueljere@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(111, '', 'emmanuelmaonga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(112, '', 'enochkamwala@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(113, '', 'enockgondwe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(114, '', 'enockzuze@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(115, '', 'estherng\'omba@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(116, '', 'ethelcheyo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(117, '', 'eunice miminkungula@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(118, '', 'evelynbanda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(119, '', 'evelynkaliwo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(120, '', 'fatsaninsaliwa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(121, '', 'faymweghama@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(122, '', 'felixchiunjiza@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(123, '', 'fermiasiyadima@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(124, '', 'fiskaniharawa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(125, '', 'floranyirenda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(126, '', 'fostermatewere@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(127, '', 'francisbandawe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(128, '', 'franciskumwima@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(129, '', 'francismapila@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(130, '', 'frankmwafulirwa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(131, '', 'fredricknamatumbo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(132, '', 'freedomchilemba@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(133, '', 'ganizanichateka@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(134, '', 'gaudenciasamu@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(135, '', 'geminimakuti@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(136, '', 'geofreykishombe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(137, '', 'georgenyirongo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(138, '', 'georginakaitano@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(139, '', 'gertrudemwakikunga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(140, '', 'getrudephiri@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(141, '', 'gibsonphiri@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(142, '', 'giftchikabvumba@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(143, '', 'giftkalilombe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(144, '', 'giftnkhambule@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(145, '', 'giftphiri@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(146, '', 'gchaonamwene@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(147, '', 'gloriachirambo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(148, '', 'gloriakayira@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(149, '', 'glpisync@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(150, '', 'glpisystem@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(151, '', 'godwinkhundi@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(152, '', 'goshenchabwera@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(153, '', 'goshenmulomole@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(154, '', 'gracemwaungulu@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(155, '', 'graciouschiromo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(156, '', 'grantnyirenda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(157, '', 'greychisi@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(158, '', 'greysonmasanga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(159, '', 'gunseyodzinjalamala@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(160, '', 'halordhekere@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(161, '', 'hanleckmasangano@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(162, '', 'happy emmanuelchisati@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(163, '', 'happymhango@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(164, '', 'harlodsymon@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(165, '', 'haroldchilowa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(166, '', 'haroldmpunga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(167, '', 'haroldpelenje@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(168, '', 'henrychipeta@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(169, '', 'henryganizani@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(170, '', 'hopemwale@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(171, '', 'howardmkupatsanji@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(172, '', 'ibrahimchikafa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(173, '', 'innocentkawere@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(174, '', 'innoncentvwemu@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(175, '', 'ireenliponjera@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(176, '', 'ireenlikeke@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(177, '', 'isaacchirwa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(178, '', 'isaaclemison@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(179, '', 'jacquelinemoyo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(180, '', 'jamesbanda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(181, '', 'jamesmtambo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(182, '', 'jessicakaranya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(183, '', 'jimmychikwatha@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(184, '', 'jimmynembere@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(185, '', 'jimmythombozi@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(186, '', 'johnmalunga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(187, '', 'josephchelewani@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(188, '', 'josephkandiado@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(189, '', 'josephmchenga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(190, '', 'judithkaperemera@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(191, '', 'justinchimpeni@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(192, '', 'justinmakiyi@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(193, '', 'justinonani@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(194, '', 'juvesiochitsonga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(195, '', 'kenleckchiwaula@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(196, '', 'kennedychinombo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(197, '', 'kennedykadammanja@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(198, '', 'kennedynkhambule@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(199, '', 'kennyirenda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(200, '', 'kephasmseteka@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(201, '', 'kissingerchiunjira@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(202, '', 'kondwanibanda@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(203, '', 'kondwanikadza@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(204, '', 'kondwanikangombe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(205, '', 'kondwanimkhori@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(206, '', 'lameckchiwawula@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(207, '', 'lawrencechilongo@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(208, '', 'layizgo lnyasulu@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(209, '', 'leffanjolomole@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(210, '', 'lemsonliyaya@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(211, '', 'leonardkalepa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(212, '', 'letusgent@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(213, '', 'lewinmagawa@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(214, '', 'lewischando@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(215, '', 'linesskhombe@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(216, '', 'lloydmalenga@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(217, '', 'lnkhata@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(218, '', 'loicenzima@mbsmw.org', '', 'Default123', '2025-11-19 07:14:49', '2025-11-19 07:14:49'),
(219, '', 'lottiekatungwe@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(220, '', 'lucksonzidana@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(221, '', 'lucykwada@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(222, '', 'lukebanda@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(223, '', 'lydiachilimo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(224, '', 'macdulfluhanga@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(225, '', 'macfarlanechinangwa@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(226, '', 'macmillanchisale@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(227, '', 'macwilliamsnkhoma@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(228, '', 'malimbanobanda@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(229, '', 'mariagondwe@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(230, '', 'mariekaunda@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(231, '', 'marksululu@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(232, '', 'marrynkungula@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(233, '', 'marthaziba@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(234, '', 'masangamwane@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(235, '', 'masautsomtuta@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(236, '', 'masozimwenefumbo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(237, '', 'mathewskamwendo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(238, '', 'mayesochibingu@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(239, '', 'mbsintern@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(240, '', 'mbslims@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(241, '', 'mbstraining@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(242, '', 'macbillystory@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(243, '', 'medsongova@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(244, '', 'mercychilunga@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(245, '', 'mercyjere@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(246, '', 'mercymfune@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(247, '', 'michaelpemba@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(248, '', 'mikenambeza@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(249, '', 'miriamngaiyaye@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(250, '', 'mizecksamikwa@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(251, '', 'monicakhombe@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(252, '', 'mortonnyirenda@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(253, '', 'mosesgunda@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(254, '', 'moseskasauka@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(255, '', 'mosespindani@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(256, '', 'msdreception@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(257, '', 'mtenderemandala@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(258, '', 'mwamadimdala@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(259, '', 'natashamtifukanji@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(260, '', 'notasmhone@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(261, '', 'ortonmtengo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(262, '', 'padambomkambanji@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(263, '', 'pasulaniyesaya@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(264, '', 'patiencekalemera@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(265, '', 'patriciankondowe@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(266, '', 'patriciansalangwa@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(267, '', 'patricianyirenda@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(268, '', 'patricklikole@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(269, '', 'patrickmboga@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(270, '', 'paulkambanje@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(271, '', 'paulkhonje@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(272, '', 'paulng\'oma@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(273, '', 'petermalupha@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(274, '', 'petermollande@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(275, '', 'petermpoma@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(276, '', 'peternjala@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(277, '', 'philipalfazema@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(278, '', 'phillipkalonga@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(279, '', 'phillipkamvazina@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(280, '', 'phillipkhembo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(281, '', 'princemkwamba@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(282, '', 'publicrelations@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(283, '', 'rabeccantaba@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(284, '', 'rabsonwisky@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(285, '', 'rachelkabango@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(286, '', 'raheemkhonart@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(287, '', 'rajeshbabu@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(288, '', 'raphaelmpingo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(289, '', 'rmoyo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(290, '', 'rhodamathandalizwe@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(291, '', 'richardbarnaba@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(292, '', 'richardchelewani@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(293, '', 'richardkubwalo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(294, '', 'robertmkwende@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(295, '', 'ronaldmakhole@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(296, '', 'rosenyambalo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(297, '', 'ruthtamani@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(298, '', 'salanzegeorge@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(299, '', 'samsonmagombo@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(300, '', 'samsonmichocha@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(301, '', 'samsonmpaso@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(302, '', 'samsonnyirenda@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(303, '', 'samuelnelson@mbsmw.org', '', 'Default123', '2025-11-19 07:15:08', '2025-11-19 07:15:08'),
(304, 'jmwambene', 'jmwambene@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(305, 'cndala', 'cndala@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(306, 'tmsungama', 'tmsungama@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(307, 'nkalida', 'nkalida@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(308, 'dolenga', 'dolenga@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(309, 'bmkandawire', 'bmkandawire@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(310, 'schirwa', 'schirwa@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(311, 'sjmbewe', 'sjmbewe@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(312, 'mchipanga', 'mchipanga@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(313, 'dmuula', 'dmuula@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(314, 'smtika', 'smtika@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(315, 'mkachale', 'mkachale@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(316, 'jmwale', 'jmwale@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(317, 'dmagombo', 'dmagombo@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(318, 'jntambo', 'jntambo@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(319, 'dhdziwenje', 'dhdziwenje@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(320, 'lchisi', 'lchisi@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(321, 'pnamiwa', 'pnamiwa@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(322, 'jmsusa', 'jmsusa@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(323, 'amamowa', 'amamowa@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(324, 'hsinkha', 'hsinkha@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(325, 'jmdimba', 'jmdimba@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20'),
(326, 'tngweta', 'tngweta@mbsmw.org', '$2y$10$wH8R0YqVbB9F6U9QjFq/Me9wO4vFZLxgF1Y3p6xL3JHxxxxxxxxxxxx', 'Default123', '2025-11-19 07:16:20', '2025-11-19 07:16:20');

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

--
-- Table structure for table `status`
--

DROP TABLE IF EXISTS `status`;
CREATE TABLE IF NOT EXISTS `status` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `class` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`id`, `name`, `class`) VALUES
(1, 'ongoing', 'badge badge-pill badge-primary'),
(2, 'stopped', 'badge badge-pill badge-secondary'),
(3, 'completed', 'badge badge-pill badge-success'),
(4, 'expired', 'badge badge-pill badge-warning');

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

--
-- Table structure for table `testing_calibration_requests`
--

DROP TABLE IF EXISTS `testing_calibration_requests`;
CREATE TABLE IF NOT EXISTS `testing_calibration_requests` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `request_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_sponsor` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `telephone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cellphone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sample_job_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_of_samples_jobs` int DEFAULT NULL,
  `tests_required` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `supporting_docs` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `menuroles` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `menuroles`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'admin', 'admin@admin.com', '2025-08-27 09:17:25', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user,admin', 'rdCPUE1JqmYTwPlxzOc5zl8pjjnvRbSupTuaIlV4xqfgyztefQOs46b8Khml', '2025-08-27 09:17:25', '2025-08-27 09:17:25', NULL),
(2, 'Mrs. Yasmin Gottlieb II', 'eden.beahan@example.com', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', '2bF09DAPVH', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(3, 'Raleigh Raynor', 'kautzer.kyra@example.org', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'ZvFXRExH4l', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(4, 'Caleigh Romaguera PhD', 'morar.emil@example.org', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'msSSmKwOLV', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(5, 'Dr. Lesley Gibson', 'zboncak.kaylee@example.net', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'IfSggLLzAo', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(6, 'Enid Dibbert', 'trevor.bruen@example.org', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'YFexqBkWZ9', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(7, 'Jefferey Rippin', 'lueilwitz.clarabelle@example.com', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', '21sDTNSqev', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(8, 'Mr. Miller Kerluke Sr.', 'antoinette95@example.com', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'IiNocAvS5E', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(9, 'Roxanne Reichel', 'felicita.green@example.org', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'zs4U84tgpJ', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(10, 'Ford Dibbert I', 'prosacco.travon@example.net', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', '0ZYC8S6fi0', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(11, 'Mrs. Rosalee King V', 'meggie.frami@example.com', '2025-08-27 09:17:26', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'wrBkld34Os', '2025-08-27 09:17:26', '2025-08-27 09:17:26', NULL),
(17, 'Sarah Msosa', 'sarahmsosa@mbsmw.org', NULL, '$2y$10$vjpurxnx75QPoYMtkN6sy.q4RyucEGz6WDi2ha6BUT6bePFiUQJkG', 'user', NULL, '2025-09-01 05:02:24', '2025-09-01 05:02:24', NULL),
(15, 'MBS', 'mbs@mbsmw.org', NULL, '$2y$10$2lbNYWmuVff6vL6.3FVJYO/brEm1hp6qOWYhlMWWN92BcT6ylmM0S', 'mbsAA', NULL, '2025-08-28 11:05:23', '2025-10-07 04:54:03', NULL),
(16, 'mbsDPT', 'mbs1@mbsmw.org', NULL, '$2y$10$Rjm/IzBtU79LFyqfgX4Hi.l.Z5gMkZK7AAYWV8lBOCZdrqk2Yu7Qm', 'mbsDPT', NULL, '2025-08-29 10:38:59', '2025-09-01 09:09:39', NULL),
(18, 'Blessings Mlundira', 'blessingsmlundira@gmail.com', NULL, '$2y$10$ISxINiOZAG7j7F6zGyb5uuZ5okC02jUK3G.Gqc90KskkGdMzQPWlq', 'user', NULL, '2025-09-11 05:54:49', '2025-09-11 05:54:49', NULL),
(19, 'john banda', 'johnmanda@gmail.com', NULL, '$2y$10$F5A.hXMg3faY2PPTUQiffe.4PL.fkvVT1NP.lQTW/KPp0OGWpB/y2', 'user', NULL, '2025-09-11 05:56:06', '2025-09-11 05:56:06', NULL);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;