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

START TRANSACTION;



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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_12_26_081648_create_pdfs_table', 2),
(5, '2025_12_26_102250_create_sliders_table', 3),
(6, '2025_12_29_094612_add_pdf_to_sliders_table', 4);

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

--
-- Table structure for table `pdfs`
--

CREATE TABLE `pdfs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pdfs`
--

INSERT INTO `pdfs` (`id`, `title`, `file_path`, `created_at`, `updated_at`) VALUES
(9, 'vvvv', 'uploads/pdfs/1767003238_MPANGO BIASHARA WANTUA.pdf', '2025-12-29 07:13:58', '2025-12-29 07:13:58'),
(10, 'jjj', 'uploads/pdfs/1767007632_Warimi Ntuntu AMCOS MKATABA.pdf', '2025-12-29 08:26:46', '2025-12-29 08:27:12'),
(11, 'ubwabwa', 'uploads/pdfs/1767016017_ACFrOgDuza6mIuHrEpx1mQO8qLc4tUkcW-4rsS6HRxoJR0eO4KhPzQL-Q8DGdz3_9I8UYmo2kWtcRnX-y1AArrn9Iuhg1BaVsLmKkUvqJvcAIbYWry_PC13tlbYBqT6SOLplhRL8GQZyd2mAHfdG8eJyTIXPaf9L14B5IxA4jw==.pdf', '2025-12-29 13:46:57', '2025-12-29 13:46:57');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('3SUubKc8rgYCd3TlZP6L6bmpv7jwQqIu1TSlvtLa', NULL, '157.245.125.67', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaG9DQ01ibjlkamlTamJuZEFIT3VnMjA2N1g3YmtXbnZjZkxlRkQ2biI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovb3VyLXRlYW0iO3M6NToicm91dGUiO3M6ODoib3VyLXRlYW0iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1767394969),
('4hd4cPBMJPck2gi5HWqq8CQHTvzph7AA0Rr9ZkzO', NULL, '174.138.82.119', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:136.0) Gecko/20100101 Firefox/136.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUzhpMldLOGpmMWVQTU1wUE5ZcGZjTUlVWHNaMXBIUUVBWU5mVlE1UyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovb3ZlcnNpZ2h0LXVuaW9uLWFzc2V0cyI7czo1OiJyb3V0ZSI7czoxNjoib3ZlcnNpZ2h0LmFzc2V0cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1767395669),
('5Vpy7RPJNbJXjLE8b42ZxVMRO2xUzRX0dSZ00erb', NULL, '165.227.118.77', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQmd6RWt3Sk85SFI2WjlvNUIxUDhUTjlYZlRCeHBZOHVLZm1SMFN3WCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovY290dG9uLWZhcm1pbmciO3M6NToicm91dGUiO3M6MTQ6ImNvdHRvbi5mYXJtaW5nIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1767395667),
('8yFSDt1UMTKE4l2lt39fx9Z22MkgTuEPFxELOcjN', NULL, '197.186.18.170', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSFVQd0JkcmdhR0xwYnFCeUs5MVdiOXMwaURNaENDM3VsT2xZb0dvMCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHoiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1767432390),
('9v8rxfEgMSobDTKuo2MkLDCGOHXb24mlAcIIb8qA', NULL, '159.203.88.149', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:136.0) Gecko/20100101 Firefox/136.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidnFIZmphMUJtZ1hwZ0kyRGU0MjNVOHF4M3dab21RQXdlbWJ0bUNtYyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovcHJvdmlkaW5nLWZhcm1pbmctaW5wdXRzIjtzOjU6InJvdXRlIjtzOjE0OiJmYXJtaW5nLmlucHV0cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1767394270),
('aA5hzbtgRwQWpH18cQzclUS5uFldeNLL1ftRZhoP', NULL, '174.138.65.109', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:136.0) Gecko/20100101 Firefox/136.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQkhGR1R0Snh3Rm1rYzBKa1JrSjN6UGhSUkExcTNveDdUdGh1b3lHOCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovbWl4ZWQtZmFybWluZyI7czo1OiJyb3V0ZSI7czoxMzoibWl4ZWQuZmFybWluZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1767395785),
('DkPnU4WIMfGpl5PFEienVj4iHyZrRgVzsgRWrsb2', 1, '197.186.18.170', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiWTdKdTNIcEJNeE5RR0VtU2hlckJyZkdnY1VFVjdtdEF1V2I4bzhybyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9kZW1vLm5jdWx0ZC5vci50ei9hZG1pbiI7czo1OiJyb3V0ZSI7czo1OiJhZG1pbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6MzA6Imh0dHA6Ly9kZW1vLm5jdWx0ZC5vci50ei9hZG1pbiI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1767434837),
('f0DZ3YhauZx1yzK2tyhJNlwNGFKguK1YcPM0Q8yR', NULL, '104.236.68.148', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNlVGQmVrMVBTZll6M3pSRHVPSTZueDNGWXBWQVAyMDB2U2ZpZ29BSiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovY29udGFjdC11cyI7czo1OiJyb3V0ZSI7czo3OiJjb250YWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1767395962),
('HyN02DGD4eyihEyBP6H8V4FEPgcPAHnwHQBDe2JA', NULL, '45.55.154.244', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:136.0) Gecko/20100101 Firefox/136.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoickkyQlNZM29yOXY2THZwcXdMdjk2Q1FmeXhOcm8wMUhEa3g4NmxDWSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovYWJvdXQtdXMiO3M6NToicm91dGUiO3M6NToiYWJvdXQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1767395908),
('Icr9DSzkvNqVwj8WqvWEgRt3hSz6My4hFWhtQJSO', NULL, '74.7.227.53', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSzVBNGhBbDhvaWFCUkE3VFhxTzRxZXRHOXhFQU81OTJWUnF1bEplVSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjMzOiJodHRwczovL2RlbW8ubmN1bHRkLm9yLnR6L3NsaWRlci9leUpwZGlJNklqTXZkRnBNVFVSRFlVRkVNemRyUlRGcFVtUk5hRUU5UFNJc0luWmhiSFZsSWpvaVprRjBSRlpRVkN0S2NqVnpXRkl4ZGpaS2RUaElkejA5SWl3aWJXRmpJam9pWkRnMk9ERTFaVEZrTVdFMk16UTFaak5qTVdZeVptUXhaVGc0TW1Zd09HVmtabVl6T1RSbE5XRTJZVEZtWkdFd01XWXhOakpsTXpOaE0yVTJNamd5TnlJc0luUmhaeUk2SWlKOSI7czo1OiJyb3V0ZSI7czoxMToic2xpZGVyLnNob3ciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1767389975),
('IyyR6O9iEx0tenyAKF4Ke8SvL184THktW2jrN5jK', NULL, '167.71.240.107', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoienQwSGN1VkZjYkFYaW9zbXpTSlFQcm1aZG01N0IwU2lYUmhRQ21nTiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovY2F0dGxlLWZhcm1pbmciO3M6NToicm91dGUiO3M6MTQ6ImNhdHRsZS5mYXJtaW5nIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1767396593),
('JFluPC6XBIsYa9xf3XMagVuJgK5dARKUVGt1YAD3', NULL, '45.55.135.181', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiR1pUbU93N0pXeWw1b1dEWjFDcEgyeWYwRjE4RnN4ZkxGTVVCNWg4byI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovbWlzc2lvbi12aXNpb24iO3M6NToicm91dGUiO3M6MTQ6Im1pc3Npb24udmlzaW9uIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1767395113),
('Jr54U5zIZcnFLBPMtGFcEWLwaAdTNhR7P3DDxwpR', NULL, '159.65.182.13', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZXp5c2YxYmhHcTBNYmc2NDJyTmZoSG5uUko4NEVmenBaTHBhS2FSZSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovZmlzaC1mYXJtaW5nIjtzOjU6InJvdXRlIjtzOjEyOiJmaXNoLmZhcm1pbmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1767394214),
('kdII7tYe84xQtIfFcLxWmf6rDXDKJqlTqfeeYWqK', NULL, '161.35.187.247', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:136.0) Gecko/20100101 Firefox/136.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieUpMZDZ4QzlsWnBBaWVDRG9ubEFnZTdqWXhhYzBrTEY0aDJEMW5tSSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovZG93bmxvYWRzIjtzOjU6InJvdXRlIjtzOjk6ImRvd25sb2FkcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1767396461),
('O9UE9nn3XNEHl8n0IqTgriw4kRQFVFtgILhrzzzF', NULL, '165.227.103.118', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWmtLMk15VHdydkRjeU5VRktkcGtrQ2NXU0J3Q0NWdlh1N3VRZGZhaiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovb3VyLWFzc2V0cyI7czo1OiJyb3V0ZSI7czo2OiJhc3NldHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1767395193),
('OhL7cnDJJPDZiTUoJCyBDAoa7C0FMHMNHK2cOadw', NULL, '64.225.58.234', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoib29tN2UxTEVWOEZ5eHVkS3NQZmdUc3p6bVc2TGdsVk1uWWZpblE4bCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovbmN1LWNlcnRpZmljYXRlcyI7czo1OiJyb3V0ZSI7czoxMjoiY2VydGlmaWNhdGVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1767396805),
('tYzxeOV8kZxFsPytFSClsupD9jcIHYFST5qwOiRT', NULL, '64.225.24.120', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRW5CYWIxdHRvWmE3UmFzRlRXbE1wMEVyM09yUEJSdFIzVkJZRzlVSCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovZmFjdG9yeS1wcm9jZXNzaW5nIjtzOjU6InJvdXRlIjtzOjE4OiJmYWN0b3J5LnByb2Nlc3NpbmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1767394665),
('UF6v7CAeDAPYLGx6LGR0MNexRRTsGkA6vtxogYbU', NULL, '165.22.43.203', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRHpsV1dvVW84M2kzMVlxOXVNSGJvQzJJTGlaaTV5SmliQmVyYk1seiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHovbmN1LXBhcnRuZXJzIjtzOjU6InJvdXRlIjtzOjg6InBhcnRuZXJzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1767394244),
('WaztQNTAbLck7s10Mc5WTzbyQEyQpb5MjuD9rzDy', NULL, '157.245.127.30', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWUxpNG05WkFLRWpqcWUxQVFYZmFjN0VXSXdMbDZjT1ZmVXJ4Rjc3NCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHoiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1767394402),
('Xqi7OxI0jSut9LQemvQzDkwH8fvnV7ArZfKbTUEV', NULL, '162.142.125.124', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidUxJV1RjTUp4MTdYSXNYVUhKVkNnOE5Pd0NteTNYa0RBNWY2MHVrUCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZGVtby5uY3VsdGQub3IudHoiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1767391833);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `pdf` varchar(255) DEFAULT NULL,
  `thumb` varchar(255) DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `subtitle`, `description`, `image`, `pdf`, `thumb`, `button_text`, `button_link`, `order`, `created_at`, `updated_at`) VALUES
(14, 'Construction of Cotton ginning factory', 'Magu Cotton ginning  factory', 'Nyanza cooperative union NCU(1984)LTD established cotton ginning factory at Magu District to help cotton farmers in processing and packaging of cotton products, also to boost up the economic capacity of union.', 'uploads/sliders/1767115285_kiwanda-ncu.png', NULL, NULL, NULL, NULL, 0, '2025-12-30 17:21:25', '2025-12-30 17:21:25'),
(15, 'Fish farming', 'Fish farming using cages', 'Nyanza cooperative union -NCU(1984)LTD established more than 8 fishing cages in lake victoria  that produces more than 16 Tones of fish product per season', 'uploads/sliders/1767116002_fish-big.png', NULL, NULL, NULL, NULL, 0, '2025-12-30 17:33:22', '2025-12-30 17:34:57');

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

--
-- Table structure for table `team_members`
--

CREATE TABLE `team_members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `photo` varchar(255) NOT NULL,
  `category` enum('board','management') NOT NULL,
  `priority` int(11) NOT NULL DEFAULT 99,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `team_members`
--

INSERT INTO `team_members` (`id`, `name`, `position`, `qualification`, `description`, `photo`, `category`, `priority`, `created_at`, `updated_at`) VALUES
(4, 'ttttt', 'Chairperson', 'Bachelor degree of business administration', 'He is a member of Ng\'humbila Amcos from Magu Distric. He has been a member of Ng\'humbila Amcos for more than 15years.', 'uploads/team/1767433971_james size.png', 'board', 1, '2026-01-02 16:39:29', '2026-01-03 09:52:51'),
(5, 'MARIAM MASHIBE', 'Vice Chair', NULL, 'She is a member of Shirima Amcos from Manawa zone which is in Misungwi District. She has been a member of Shirima Amcos for more than 12 years.', 'uploads/team/1767373203_MARIAM-MASHIBE.jpg', 'board', 2, '2026-01-02 17:00:03', '2026-01-02 17:00:03');

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `pdfs`
--
ALTER TABLE `pdfs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `team_members`
--
ALTER TABLE `team_members`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

