--
-- Host: 127.0.0.1    Database: boonversenew
-- ------------------------------------------------------


--
-- Table structure for table `article_likes`
--

CREATE TABLE `article_likes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `article_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `article_likes_article_id_user_id_unique` (`article_id`,`user_id`),
  KEY `article_likes_user_id_foreign` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `article_likes`
--

INSERT INTO `article_likes` VALUES (1,11,1,'2026-07-22 18:22:07','2026-07-22 18:22:07'),(5,1,1,'2026-07-24 16:56:16','2026-07-24 16:56:16'),(3,1,2,'2026-07-24 16:54:18','2026-07-24 16:54:18');

--
-- Table structure for table `article_status_events`
--

CREATE TABLE `article_status_events` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `article_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `from_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `article_status_events_user_id_foreign` (`user_id`),
  KEY `article_status_events_article_id_created_at_index` (`article_id`,`created_at`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `article_status_events`
--

INSERT INTO `article_status_events` VALUES (1,2,1,NULL,'draft','Article created','2026-07-22 16:06:52','2026-07-22 16:06:52'),(2,3,1,NULL,'draft','Article created','2026-07-22 16:27:21','2026-07-22 16:27:21'),(3,10,1,NULL,'draft','Article created','2026-07-22 17:03:49','2026-07-22 17:03:49'),(4,10,1,'draft','pending_approval','Submitted for editorial approval.','2026-07-22 17:05:38','2026-07-22 17:05:38'),(5,11,1,NULL,'draft','Article created','2026-07-22 17:14:36','2026-07-22 17:14:36'),(6,11,1,'draft','pending_approval','Submitted for editorial approval.','2026-07-22 17:15:45','2026-07-22 17:15:45'),(7,11,1,'pending_approval','published',NULL,'2026-07-22 17:47:13','2026-07-22 17:47:13'),(8,1,1,NULL,'draft','Article created','2026-07-22 19:38:27','2026-07-22 19:38:27'),(9,1,1,'draft','pending_approval','Submitted for editorial approval.','2026-07-22 19:43:07','2026-07-22 19:43:07'),(10,1,1,'pending_approval','published',NULL,'2026-07-22 19:43:46','2026-07-22 19:43:46'),(11,2,1,'draft','pending_approval','Submitted for editorial approval.','2026-07-24 17:19:03','2026-07-24 17:19:03'),(12,2,1,'pending_approval','published',NULL,'2026-07-24 17:30:01','2026-07-24 17:30:01'),(13,3,4,'draft','pending_approval','Submitted for editorial approval.','2026-07-24 17:35:04','2026-07-24 17:35:04'),(14,3,1,'pending_approval','published',NULL,'2026-07-24 17:36:34','2026-07-24 17:36:34'),(15,4,1,NULL,'draft','Article created','2026-07-24 18:06:27','2026-07-24 18:06:27'),(16,4,1,'draft','pending_approval','Submitted for editorial approval.','2026-07-24 18:07:33','2026-07-24 18:07:33'),(17,4,1,'pending_approval','published',NULL,'2026-07-24 18:07:47','2026-07-24 18:07:47');

--
-- Table structure for table `article_tag`
--

CREATE TABLE `article_tag` (
  `article_id` bigint unsigned NOT NULL,
  `tag_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`article_id`,`tag_id`),
  KEY `article_tag_tag_id_foreign` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `article_tag`
--


--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtitle` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `summary` text COLLATE utf8mb4_unicode_ci,
  `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `featured_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_image_alt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author_id` bigint unsigned DEFAULT NULL,
  `primary_category_id` bigint unsigned DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `visibility` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  `is_breaking` tinyint(1) NOT NULL DEFAULT '0',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `is_editor_pick` tinyint(1) NOT NULL DEFAULT '0',
  `reading_time` int unsigned NOT NULL DEFAULT '1',
  `published_at` timestamp NULL DEFAULT NULL,
  `scheduled_at` timestamp NULL DEFAULT NULL,
  `views_count` bigint unsigned NOT NULL DEFAULT '0',
  `shares_count` bigint unsigned NOT NULL DEFAULT '0',
  `seo_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_sponsored` tinyint(1) NOT NULL DEFAULT '0',
  `allow_comments` tinyint(1) NOT NULL DEFAULT '1',
  `allow_sharing` tinyint(1) NOT NULL DEFAULT '1',
  `feature_on_homepage` tinyint(1) NOT NULL DEFAULT '0',
  `feature_in_category` tinyint(1) NOT NULL DEFAULT '0',
  `is_pinned` tinyint(1) NOT NULL DEFAULT '0',
  `seo_keywords` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `focus_keyword` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `canonical_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `open_graph_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_image_caption` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_image_credit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `editor_id` bigint unsigned DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `autosaved_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `articles_uuid_unique` (`uuid`),
  UNIQUE KEY `articles_slug_unique` (`slug`),
  KEY `articles_author_id_foreign` (`author_id`),
  KEY `articles_primary_category_id_foreign` (`primary_category_id`),
  KEY `articles_status_index` (`status`),
  KEY `articles_is_breaking_index` (`is_breaking`),
  KEY `articles_published_at_index` (`published_at`),
  KEY `articles_editor_id_foreign` (`editor_id`),
  FULLTEXT KEY `boonverse_articles_search` (`title`,`summary`,`body`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articles`
--

INSERT INTO `articles` VALUES (1,'8e91a274-09d2-4291-8108-c7c85db6d117','Google Launches Gemini 3.6 Flash and New AI Models for Faster, More Efficient Tasks','google-launches-gemini-3-6-flash-and-new-ai-models-for-faster-more-efficient-tasks',NULL,'Google has announced Gemini 3.6 Flash, Gemini 3.5 Flash-Lite and Gemini 3.5 Flash Cyber. The new artificial intelligence models are designed to deliver faster performance, improved efficiency and stronger support for coding, research, document analysis and AI agents.','<p data-start=\"429\" data-end=\"613\" class=\"PDq2pG_selectionAnchorContainer\">Google has introduced a new generation of Gemini artificial intelligence models aimed at helping individuals, developers and businesses complete complex digital tasks more efficiently.<span aria-hidden=\"true\" class=\"PDq2pG_selectionAnchor\"></span></p>\n<p data-start=\"615\" data-end=\"960\">The announcement, made on 21 July 2026, includes <strong data-start=\"664\" data-end=\"684\">Gemini 3.6 Flash</strong>, <strong data-start=\"686\" data-end=\"711\">Gemini 3.5 Flash-Lite</strong> and <strong data-start=\"716\" data-end=\"742\">Gemini 3.5 Flash Cyber</strong>. Google says the models are designed to provide improved speed, reliability and cost efficiency, particularly for organisations building AI-powered agents and automated workflows. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"962\" data-end=\"1401\">Gemini 3.6 Flash is positioned as the main model for demanding everyday tasks. It offers improvements in coding, knowledge-based work, document processing, chart analysis and other activities that require the AI to understand different types of information. Google says the model uses fewer output tokens than Gemini 3.5 Flash, which could help developers reduce the cost of operating AI applications. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"1403\" data-end=\"1745\">The company also launched Gemini 3.5 Flash-Lite, a faster and lower-cost model intended for high-volume tasks such as search, document processing, translation and automated customer services. It is designed for organisations that need to process many requests quickly while controlling operational costs. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"1747\" data-end=\"2104\">Gemini 3.5 Flash Cyber is focused on cybersecurity. Google says the specialised model can help identify, analyse and fix software vulnerabilities. Because cybersecurity tools can also be misused, the model will initially be available only to governments and selected trusted partners through a limited-access programme. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"2106\" data-end=\"2368\" class=\"\">Gemini 3.6 Flash and Gemini 3.5 Flash-Lite are available through Google AI Studio, the Gemini API, Android Studio, Gemini Enterprise and the Gemini application. Flash-Lite is also being introduced gradually in Google Search. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"2370\" data-end=\"2585\">The announcement demonstrates the growing competition among major technology companies to provide faster and more affordable artificial intelligence systems for consumers, developers and businesses around the world.</p>','en','http://127.0.0.1:8000/storage/articles/images/zyL3WdXDjU1fD7iMTlCxe37GNnGP8nj6zfE1o96L.png',NULL,1,3,'published','public',0,0,0,2,'2026-07-22 19:43:45',NULL,18,0,NULL,NULL,'2026-07-22 19:38:27','2026-07-24 17:00:54',NULL,0,1,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'2026-07-22 19:43:07'),(2,'ea4cf685-c80b-4475-8d3a-bdf728e8339c','WHO Launches Seven Global Strategies to Prevent Drowning and Save Hundreds of Thousands of Lives','who-launches-seven-global-strategies-to-prevent-drowning-and-save-hundreds-of-thousands-of-lives',NULL,'The World Health Organization (WHO) has launched seven evidence-based strategies aimed at reducing drowning deaths worldwide. The initiative comes ahead of World Drowning Prevention Day and encourages governments to strengthen water safety, improve swimming education, enhance emergency response systems, and promote public awareness to save lives.','<p data-start=\"523\" data-end=\"703\" class=\"PDq2pG_selectionAnchorContainer\">The World Health Organization (WHO) has unveiled a comprehensive set of seven global strategies designed to reduce drowning, one of the world\'s leading causes of preventable death.<span aria-hidden=\"true\" class=\"PDq2pG_selectionAnchor\"></span></p>\n<p data-start=\"705\" data-end=\"1016\">The announcement was made ahead of <strong data-start=\"740\" data-end=\"773\">World Drowning Prevention Day</strong>, observed annually on <strong data-start=\"796\" data-end=\"807\">25 July</strong>, as WHO called on governments, communities and international partners to strengthen efforts to protect people living near rivers, lakes, oceans and other bodies of water. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"1018\" data-end=\"1353\">According to WHO, drowning claims hundreds of thousands of lives every year, with children and young people among the most affected. Many of these deaths occur in low- and middle-income countries where access to swimming lessons, safe water infrastructure and emergency rescue services is limited. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"1355\" data-end=\"1764\">The seven recommended strategies include teaching swimming and water safety skills, improving supervision of children near water, installing barriers around hazardous water bodies, strengthening flood preparedness, improving rescue and emergency medical response, promoting safe boating practices, and integrating drowning prevention into national public health policies. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"1766\" data-end=\"2112\">WHO emphasized that drowning is preventable through coordinated action involving governments, schools, local communities and health organizations. The agency urged countries to invest in education, infrastructure and emergency preparedness to significantly reduce drowning-related deaths in the coming years. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"2114\" data-end=\"2382\">As countries prepare to mark World Drowning Prevention Day, WHO hopes the new guidance will encourage stronger national policies and community initiatives that protect vulnerable populations and save thousands of lives every year.</p>','en','http://127.0.0.1:8000/storage/articles/images/wuGjyOkappYuT99F0sYzF0nwFu4CiYyq18GFd70i.png',NULL,1,10,'published','public',0,0,0,2,'2026-07-24 17:30:01',NULL,6,0,NULL,NULL,'2026-07-24 17:16:41','2026-07-24 17:39:04',NULL,0,1,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'2026-07-24 17:22:09'),(4,'e412a348-6bef-4afd-bedc-e1accb56e131','FAO Launches CropSuit App to Help Farmers Grow the Right Crops in the Right Places','fao-launches-cropsuit-app-to-help-farmers-grow-the-right-crops-in-the-right-places',NULL,'The Food and Agriculture Organization of the United Nations (FAO) has launched CropSuit, a new digital application designed to help farmers identify the most suitable crops for their land using soil, climate and landscape data. The tool aims to improve crop yields, strengthen climate resilience and support smarter agricultural decision-making worldwide.','<p data-start=\"562\" data-end=\"819\" class=\"PDq2pG_selectionAnchorContainer\">The Food and Agriculture Organization of the United Nations (FAO) has officially introduced <strong data-start=\"654\" data-end=\"666\">CropSuit</strong>, an innovative digital platform that helps farmers determine which crops are best suited for specific locations based on local environmental conditions.<span aria-hidden=\"true\" class=\"PDq2pG_selectionAnchor\"></span></p>\n<p data-start=\"821\" data-end=\"1203\">The application combines information on soil characteristics, climate patterns, rainfall, temperature and landscape features to provide science-based recommendations for crop selection. By using this data, farmers can make more informed planting decisions, increase productivity and reduce the risks associated with changing weather conditions. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"1205\" data-end=\"1551\">According to FAO, CropSuit is designed to support governments, agricultural extension officers, researchers and farmers in promoting sustainable agriculture. The platform can assist in identifying suitable areas for different crops while helping communities adapt to climate change and improve food security. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"1553\" data-end=\"1914\">The launch comes at a time when many countries are facing increasing challenges from extreme weather, droughts and shifting rainfall patterns. FAO believes that digital technologies such as CropSuit can play a vital role in helping farmers make better decisions, use natural resources more efficiently and improve harvests. <span class=\"\" data-state=\"closed\"></span></p>\n<p data-start=\"1916\" data-end=\"2259\" class=\"\">Agricultural experts say the new tool could be particularly valuable for developing countries, where access to reliable farming information is often limited. By making scientific data more accessible, CropSuit has the potential to support sustainable farming practices and strengthen global food security.</p>','en','http://127.0.0.1:8000/storage/articles/images/fNRNY4xrEuNCUtNJqMacHMMiiN8YpzIybN7RMr8y.png',NULL,1,12,'published','public',0,0,0,1,'2026-07-24 18:07:47',NULL,4,0,NULL,NULL,'2026-07-24 18:06:27','2026-07-24 18:08:00',NULL,0,1,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'2026-07-24 18:07:33');

--
-- Table structure for table `authors`
--

CREATE TABLE `authors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `display_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bio` text COLLATE utf8mb4_unicode_ci,
  `profile_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `authors_slug_unique` (`slug`),
  KEY `authors_user_id_foreign` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `authors`
--

INSERT INTO `authors` VALUES (1,1,'BoonVerse Newsroom','boonverse-newsroom','BoonVerse’s global reporting and editing team.',NULL,'Editorial Desk',1,'2026-07-22 06:28:59','2026-07-22 06:28:59',NULL),(2,NULL,'ccccc','ccccc','hhh','hh','dddd',0,'2026-07-22 16:43:54','2026-07-24 08:53:32','2026-07-24 08:53:32'),(3,3,'Nelson Chiloro','nelson-chiloro-3',NULL,'profiles/XB5FXSZNnutFIeghiJdqZ82w9SWrdzZ8RVxBZZ85.jpg',NULL,0,'2026-07-24 15:51:56','2026-07-24 15:53:32','2026-07-24 15:53:32'),(4,4,'Nelson Chiloro','nelson-chiloro-4',NULL,'profiles/u41zttovsVEIYzCTQkBwRqBPc2tGsDatCB0DBIyl.jpg',NULL,1,'2026-07-24 16:16:01','2026-07-24 16:16:01',NULL);

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` VALUES ('laravel-cache-homepage','a:2:{s:8:\"sections\";a:7:{i:0;a:6:{s:2:\"id\";i:1;s:5:\"title\";s:11:\"Top Stories\";s:4:\"type\";s:11:\"hero_slider\";s:6:\"layout\";s:4:\"grid\";s:8:\"settings\";N;s:8:\"articles\";a:3:{i:0;a:10:{s:2:\"id\";i:4;s:5:\"title\";s:82:\"FAO Launches CropSuit App to Help Farmers Grow the Right Crops in the Right Places\";s:4:\"slug\";s:82:\"fao-launches-cropsuit-app-to-help-farmers-grow-the-right-crops-in-the-right-places\";s:7:\"summary\";s:355:\"The Food and Agriculture Organization of the United Nations (FAO) has launched CropSuit, a new digital application designed to help farmers identify the most suitable crops for their land using soil, climate and landscape data. The tool aims to improve crop yields, strengthen climate resilience and support smarter agricultural decision-making worldwide.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/fNRNY4xrEuNCUtNJqMacHMMiiN8YpzIybN7RMr8y.png\";s:8:\"category\";s:11:\"Agriculture\";s:13:\"category_slug\";s:11:\"agriculture\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-24 20:07:47.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:1;s:5:\"views\";i:0;}i:1;a:10:{s:2:\"id\";i:2;s:5:\"title\";s:96:\"WHO Launches Seven Global Strategies to Prevent Drowning and Save Hundreds of Thousands of Lives\";s:4:\"slug\";s:96:\"who-launches-seven-global-strategies-to-prevent-drowning-and-save-hundreds-of-thousands-of-lives\";s:7:\"summary\";s:348:\"The World Health Organization (WHO) has launched seven evidence-based strategies aimed at reducing drowning deaths worldwide. The initiative comes ahead of World Drowning Prevention Day and encourages governments to strengthen water safety, improve swimming education, enhance emergency response systems, and promote public awareness to save lives.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/wuGjyOkappYuT99F0sYzF0nwFu4CiYyq18GFd70i.png\";s:8:\"category\";s:6:\"Health\";s:13:\"category_slug\";s:6:\"health\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-24 19:30:01.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:2;s:5:\"views\";i:6;}i:2;a:10:{s:2:\"id\";i:1;s:5:\"title\";s:83:\"Google Launches Gemini 3.6 Flash and New AI Models for Faster, More Efficient Tasks\";s:4:\"slug\";s:82:\"google-launches-gemini-3-6-flash-and-new-ai-models-for-faster-more-efficient-tasks\";s:7:\"summary\";s:267:\"Google has announced Gemini 3.6 Flash, Gemini 3.5 Flash-Lite and Gemini 3.5 Flash Cyber. The new artificial intelligence models are designed to deliver faster performance, improved efficiency and stronger support for coding, research, document analysis and AI agents.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/zyL3WdXDjU1fD7iMTlCxe37GNnGP8nj6zfE1o96L.png\";s:8:\"category\";s:10:\"Technology\";s:13:\"category_slug\";s:10:\"technology\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-22 21:43:45.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:2;s:5:\"views\";i:18;}}}i:1;a:6:{s:2:\"id\";i:2;s:5:\"title\";s:11:\"Latest News\";s:4:\"type\";s:11:\"latest_news\";s:6:\"layout\";s:4:\"grid\";s:8:\"settings\";N;s:8:\"articles\";a:3:{i:0;a:10:{s:2:\"id\";i:4;s:5:\"title\";s:82:\"FAO Launches CropSuit App to Help Farmers Grow the Right Crops in the Right Places\";s:4:\"slug\";s:82:\"fao-launches-cropsuit-app-to-help-farmers-grow-the-right-crops-in-the-right-places\";s:7:\"summary\";s:355:\"The Food and Agriculture Organization of the United Nations (FAO) has launched CropSuit, a new digital application designed to help farmers identify the most suitable crops for their land using soil, climate and landscape data. The tool aims to improve crop yields, strengthen climate resilience and support smarter agricultural decision-making worldwide.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/fNRNY4xrEuNCUtNJqMacHMMiiN8YpzIybN7RMr8y.png\";s:8:\"category\";s:11:\"Agriculture\";s:13:\"category_slug\";s:11:\"agriculture\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-24 20:07:47.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:1;s:5:\"views\";i:0;}i:1;a:10:{s:2:\"id\";i:2;s:5:\"title\";s:96:\"WHO Launches Seven Global Strategies to Prevent Drowning and Save Hundreds of Thousands of Lives\";s:4:\"slug\";s:96:\"who-launches-seven-global-strategies-to-prevent-drowning-and-save-hundreds-of-thousands-of-lives\";s:7:\"summary\";s:348:\"The World Health Organization (WHO) has launched seven evidence-based strategies aimed at reducing drowning deaths worldwide. The initiative comes ahead of World Drowning Prevention Day and encourages governments to strengthen water safety, improve swimming education, enhance emergency response systems, and promote public awareness to save lives.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/wuGjyOkappYuT99F0sYzF0nwFu4CiYyq18GFd70i.png\";s:8:\"category\";s:6:\"Health\";s:13:\"category_slug\";s:6:\"health\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-24 19:30:01.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:2;s:5:\"views\";i:6;}i:2;a:10:{s:2:\"id\";i:1;s:5:\"title\";s:83:\"Google Launches Gemini 3.6 Flash and New AI Models for Faster, More Efficient Tasks\";s:4:\"slug\";s:82:\"google-launches-gemini-3-6-flash-and-new-ai-models-for-faster-more-efficient-tasks\";s:7:\"summary\";s:267:\"Google has announced Gemini 3.6 Flash, Gemini 3.5 Flash-Lite and Gemini 3.5 Flash Cyber. The new artificial intelligence models are designed to deliver faster performance, improved efficiency and stronger support for coding, research, document analysis and AI agents.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/zyL3WdXDjU1fD7iMTlCxe37GNnGP8nj6zfE1o96L.png\";s:8:\"category\";s:10:\"Technology\";s:13:\"category_slug\";s:10:\"technology\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-22 21:43:45.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:2;s:5:\"views\";i:18;}}}i:2;a:6:{s:2:\"id\";i:3;s:5:\"title\";s:6:\"Sports\";s:4:\"type\";s:13:\"category_grid\";s:6:\"layout\";s:4:\"grid\";s:8:\"settings\";N;s:8:\"articles\";a:0:{}}i:3;a:6:{s:2:\"id\";i:4;s:5:\"title\";s:10:\"Technology\";s:4:\"type\";s:13:\"category_grid\";s:6:\"layout\";s:4:\"grid\";s:8:\"settings\";N;s:8:\"articles\";a:1:{i:0;a:10:{s:2:\"id\";i:1;s:5:\"title\";s:83:\"Google Launches Gemini 3.6 Flash and New AI Models for Faster, More Efficient Tasks\";s:4:\"slug\";s:82:\"google-launches-gemini-3-6-flash-and-new-ai-models-for-faster-more-efficient-tasks\";s:7:\"summary\";s:267:\"Google has announced Gemini 3.6 Flash, Gemini 3.5 Flash-Lite and Gemini 3.5 Flash Cyber. The new artificial intelligence models are designed to deliver faster performance, improved efficiency and stronger support for coding, research, document analysis and AI agents.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/zyL3WdXDjU1fD7iMTlCxe37GNnGP8nj6zfE1o96L.png\";s:8:\"category\";s:10:\"Technology\";s:13:\"category_slug\";s:10:\"technology\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-22 21:43:45.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:2;s:5:\"views\";i:18;}}}i:4;a:6:{s:2:\"id\";i:5;s:5:\"title\";s:8:\"Business\";s:4:\"type\";s:13:\"category_grid\";s:6:\"layout\";s:4:\"grid\";s:8:\"settings\";N;s:8:\"articles\";a:0:{}}i:5;a:6:{s:2:\"id\";i:6;s:5:\"title\";s:9:\"Most Read\";s:4:\"type\";s:9:\"most_read\";s:6:\"layout\";s:4:\"grid\";s:8:\"settings\";N;s:8:\"articles\";a:3:{i:0;a:10:{s:2:\"id\";i:1;s:5:\"title\";s:83:\"Google Launches Gemini 3.6 Flash and New AI Models for Faster, More Efficient Tasks\";s:4:\"slug\";s:82:\"google-launches-gemini-3-6-flash-and-new-ai-models-for-faster-more-efficient-tasks\";s:7:\"summary\";s:267:\"Google has announced Gemini 3.6 Flash, Gemini 3.5 Flash-Lite and Gemini 3.5 Flash Cyber. The new artificial intelligence models are designed to deliver faster performance, improved efficiency and stronger support for coding, research, document analysis and AI agents.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/zyL3WdXDjU1fD7iMTlCxe37GNnGP8nj6zfE1o96L.png\";s:8:\"category\";s:10:\"Technology\";s:13:\"category_slug\";s:10:\"technology\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-22 21:43:45.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:2;s:5:\"views\";i:18;}i:1;a:10:{s:2:\"id\";i:2;s:5:\"title\";s:96:\"WHO Launches Seven Global Strategies to Prevent Drowning and Save Hundreds of Thousands of Lives\";s:4:\"slug\";s:96:\"who-launches-seven-global-strategies-to-prevent-drowning-and-save-hundreds-of-thousands-of-lives\";s:7:\"summary\";s:348:\"The World Health Organization (WHO) has launched seven evidence-based strategies aimed at reducing drowning deaths worldwide. The initiative comes ahead of World Drowning Prevention Day and encourages governments to strengthen water safety, improve swimming education, enhance emergency response systems, and promote public awareness to save lives.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/wuGjyOkappYuT99F0sYzF0nwFu4CiYyq18GFd70i.png\";s:8:\"category\";s:6:\"Health\";s:13:\"category_slug\";s:6:\"health\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-24 19:30:01.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:2;s:5:\"views\";i:6;}i:2;a:10:{s:2:\"id\";i:4;s:5:\"title\";s:82:\"FAO Launches CropSuit App to Help Farmers Grow the Right Crops in the Right Places\";s:4:\"slug\";s:82:\"fao-launches-cropsuit-app-to-help-farmers-grow-the-right-crops-in-the-right-places\";s:7:\"summary\";s:355:\"The Food and Agriculture Organization of the United Nations (FAO) has launched CropSuit, a new digital application designed to help farmers identify the most suitable crops for their land using soil, climate and landscape data. The tool aims to improve crop yields, strengthen climate resilience and support smarter agricultural decision-making worldwide.\";s:5:\"image\";s:90:\"http://127.0.0.1:8000/storage/articles/images/fNRNY4xrEuNCUtNJqMacHMMiiN8YpzIybN7RMr8y.png\";s:8:\"category\";s:11:\"Agriculture\";s:13:\"category_slug\";s:11:\"agriculture\";s:12:\"published_at\";O:25:\"Illuminate\\Support\\Carbon\":3:{s:4:\"date\";s:26:\"2026-07-24 20:07:47.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:12:\"reading_time\";i:1;s:5:\"views\";i:0;}}}i:6;a:6:{s:2:\"id\";i:7;s:5:\"title\";s:16:\"Editor’s Picks\";s:4:\"type\";s:12:\"editors_pick\";s:6:\"layout\";s:4:\"grid\";s:8:\"settings\";N;s:8:\"articles\";a:0:{}}}s:12:\"generated_at\";s:25:\"2026-07-24T20:07:50+00:00\";}',1784923970);

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache_locks`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `show_in_homepage` tinyint(1) NOT NULL DEFAULT '1',
  `show_in_navigation` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`),
  KEY `categories_parent_id_foreign` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,NULL,'Breaking News','breaking-news',NULL,'#e11d48',0,1,1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(2,NULL,'Sports','sports',NULL,'#16a34a',1,1,1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(3,NULL,'Technology','technology',NULL,'#2563eb',2,1,1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(4,NULL,'Current Affairs','current-affairs',NULL,'#7c3aed',3,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:52:30','2026-07-22 18:52:30'),(5,NULL,'Vacancies','vacancies',NULL,'#e11d48',4,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:54:18','2026-07-22 18:54:18'),(6,NULL,'Politics','politics',NULL,'#16a34a',5,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:52:21',NULL),(7,NULL,'Business News','business-news',NULL,'#2563eb',6,1,1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(8,NULL,'Opinion','opinion',NULL,'#7c3aed',7,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:51:06','2026-07-22 18:51:06'),(9,NULL,'Entertainment','entertainment',NULL,'#e11d48',8,1,1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(10,NULL,'Health','health',NULL,'#16a34a',9,1,1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(11,NULL,'Education','education',NULL,'#2563eb',10,1,1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(12,NULL,'Agriculture','agriculture',NULL,'#7c3aed',11,1,1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(13,NULL,'World News','world-news',NULL,'#e11d48',12,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:52:45','2026-07-22 18:52:45'),(14,NULL,'Local News','local-news',NULL,'#16a34a',13,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:50:32','2026-07-22 18:50:32'),(15,NULL,'Interviews','interviews',NULL,'#2563eb',14,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:51:24','2026-07-22 18:51:24'),(16,NULL,'Editorials','editorials',NULL,'#7c3aed',15,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:50:47','2026-07-22 18:50:47'),(17,NULL,'Fact Check','fact-check',NULL,'#e11d48',16,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:50:38','2026-07-22 18:50:38'),(18,NULL,'Videos','videos',NULL,'#16a34a',17,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:51:00','2026-07-22 18:51:00'),(19,NULL,'Photo Stories','photo-stories',NULL,'#2563eb',18,1,1,1,'2026-07-22 05:05:43','2026-07-22 18:51:14','2026-07-22 18:51:14');

--
-- Table structure for table `comment_likes`
--

CREATE TABLE `comment_likes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `comment_likes_comment_id_user_id_unique` (`comment_id`,`user_id`),
  KEY `comment_likes_user_id_foreign` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comment_likes`
--


--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `article_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `parent_id` bigint unsigned DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `comments_article_id_foreign` (`article_id`),
  KEY `comments_user_id_foreign` (`user_id`),
  KEY `comments_parent_id_foreign` (`parent_id`),
  KEY `comments_status_index` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` VALUES (1,11,1,NULL,'ssnsnsnsnsnsns','approved','2026-07-22 18:22:18','2026-07-22 18:22:18',NULL),(2,1,2,NULL,'Great!','approved','2026-07-24 16:54:43','2026-07-24 16:54:43',NULL),(3,1,1,2,'@Nelson Chiloro That is really a great development','approved','2026-07-24 17:00:54','2026-07-24 17:00:54',NULL);

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_verified` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `companies_slug_unique` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` VALUES (1,'BoonVerse Media','boonverse-media',NULL,'Independent media and technology company.',NULL,'Blantyre','Malawi',1,1,'2026-07-22 05:05:43','2026-07-22 16:57:18',NULL),(2,'bbbbb','bbbbb',NULL,NULL,NULL,NULL,'Malawi',0,0,'2026-07-22 18:41:19','2026-07-24 08:55:11','2026-07-24 08:55:11'),(3,'Alliance One Tobacco (Malawi) Limited','alliance-one-tobacco-malawi-limited',NULL,NULL,NULL,NULL,'Malawi',0,1,'2026-07-24 17:10:08','2026-07-24 17:10:08',NULL);

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `homepage_sections`
--

CREATE TABLE `homepage_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `section_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint unsigned DEFAULT NULL,
  `layout` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'grid',
  `article_limit` int unsigned NOT NULL DEFAULT '6',
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `settings_json` json DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `homepage_sections_slug_unique` (`slug`),
  KEY `homepage_sections_category_id_foreign` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `homepage_sections`
--

INSERT INTO `homepage_sections` VALUES (1,'Top Stories','top-stories','hero_slider',NULL,'grid',5,0,NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(2,'Latest News','latest-news','latest_news',NULL,'grid',6,1,NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(3,'Sports','sports','category_grid',2,'grid',4,2,NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(4,'Technology','technology','category_grid',3,'grid',4,3,NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(5,'Business','business','category_grid',7,'grid',4,4,NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(6,'Most Read','most-read','most_read',NULL,'grid',5,5,NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(7,'Editor’s Picks','editors-picks','editors_pick',NULL,'grid',4,6,NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL);

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

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

--
-- Dumping data for table `job_batches`
--


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

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` smallint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


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

CREATE TABLE `media` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `article_id` bigint unsigned DEFAULT NULL,
  `uploaded_by` bigint unsigned DEFAULT NULL,
  `disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` bigint unsigned NOT NULL,
  `width` int unsigned DEFAULT NULL,
  `height` int unsigned DEFAULT NULL,
  `folder` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'newsroom',
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alt_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `caption` text COLLATE utf8mb4_unicode_ci,
  `credit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photographer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `media_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'image',
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `duration` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_uploaded_by_foreign` (`uploaded_by`),
  KEY `media_article_id_foreign` (`article_id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` VALUES (1,NULL,1,'public','articles/images/0IAl2Jto70ACZRophWyln8EzUoiTWnhfrxGrNm9e.jpg','IMG_20260219_085141.jpg','image/jpeg',613899,2775,3542,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 17:04:57','2026-07-24 08:54:58','2026-07-24 08:54:58','image',0,0,NULL),(2,NULL,1,'public','articles/images/JQvCsXyx0qmGIshP7xme4UQm954C53xRzwrUvRHW.png','sk_logo.png','image/png',165020,1200,857,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 17:05:09','2026-07-24 08:54:55','2026-07-24 08:54:55','image',0,0,NULL),(3,NULL,1,'public','articles/images/Kr6s7vLz4yf9EPFpsLDK6l5GN5wYX5JeXCKCOE03.jpg','IMG_20260219_085141.jpg','image/jpeg',613899,2775,3542,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 17:05:22','2026-07-24 08:54:51','2026-07-24 08:54:51','image',0,0,NULL),(4,NULL,1,'public','articles/images/ws7UFO7w0t61jT59ZHOSFIznAZ8CSozgvTe2NypR.png','sk_logo.png','image/png',165020,1200,857,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 17:05:28','2026-07-24 08:54:47','2026-07-24 08:54:47','image',0,0,NULL),(5,NULL,1,'public','articles/images/MuwYETeDGMcIkl4QfVejrgALQpeyYltOErksMkPf.jpg','IMG_20260219_085141.jpg','image/jpeg',613899,2775,3542,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 17:15:27','2026-07-24 08:54:43','2026-07-24 08:54:43','image',0,0,NULL),(6,NULL,1,'public','articles/images/rdTzVdYvPOdlT27m0nYPF00ZMJYKkRrVgqtJpyPQ.png','sk_logo.png','image/png',165020,1200,857,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 17:15:31','2026-07-24 08:54:39','2026-07-24 08:54:39','image',0,0,NULL),(7,NULL,1,'public','articles/images/MM1nESKvMYXMsiT9WNuAwc76tzwYzlTN1W4ruyJl.png','Screenshot 2026-07-04 200652.png','image/png',82685,1893,931,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 19:18:46','2026-07-24 08:54:36','2026-07-24 08:54:36','image',0,0,NULL),(8,NULL,1,'public','articles/images/qnk7BAgnQM8c1WjdaSfoBxeTZDa4TIX49LmVAAkq.png','Screenshot 2026-07-22 231743.png','image/png',685943,1781,782,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 19:18:57','2026-07-24 08:54:33','2026-07-24 08:54:33','image',0,0,NULL),(9,NULL,1,'public','articles/images/oEZupUUMgTx12X6hsZ8fZ70M87uj8z5kNdezOlcJ.png','Screenshot 2026-07-22 231743.png','image/png',685943,1781,782,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 19:21:56','2026-07-24 08:54:31','2026-07-24 08:54:31','image',0,0,NULL),(10,NULL,1,'public','articles/images/HjMwWVPLTqC1Q4Dlu0kh8NclbzKYov6D7KrqyZxY.png','Screenshot 2026-07-22 232257.png','image/png',159658,1528,859,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 19:32:58','2026-07-24 08:54:28','2026-07-24 08:54:28','image',0,0,NULL),(11,NULL,1,'public','articles/images/3jShtsI8A6LDOxIQ4E7pUV1fJq6Skl9QvrOTTd6N.png','Screenshot 2026-07-22 231743.png','image/png',685943,1781,782,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 19:33:11','2026-07-24 08:54:25','2026-07-24 08:54:25','image',0,0,NULL),(12,1,1,'public','articles/images/zyL3WdXDjU1fD7iMTlCxe37GNnGP8nj6zfE1o96L.png','Screenshot 2026-07-22 231743.png','image/png',685943,1781,782,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-22 19:43:02','2026-07-22 19:43:07',NULL,'image',0,1,NULL),(13,2,1,'public','articles/images/wuGjyOkappYuT99F0sYzF0nwFu4CiYyq18GFd70i.png','Screenshot 2026-07-24 211801.png','image/png',935905,846,597,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:18:47','2026-07-24 17:19:02',NULL,'image',0,1,NULL),(14,NULL,1,'public','articles/images/faaK5mwBR9IpLNGSjFvtwqkwIE9KTggQmAqdD9wn.png','Screenshot 2026-07-24 211827.png','image/png',970101,850,574,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:18:55','2026-07-24 17:18:55',NULL,'image',0,0,NULL),(15,3,4,'public','articles/images/9o393hvNq0Z5CRVQwNdwlMr2YsFl4Eqj6PMcs75C.png','Screenshot 2026-07-24 213441.png','image/png',884068,1060,603,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:34:56','2026-07-24 18:00:33',NULL,'image',0,0,NULL),(16,3,1,'public','articles/images/XydRRCmXONiCro0Zsy6vaTYqCl4U1jjI3OI2RARC.png','Screenshot 2026-07-24 215726.png','image/png',708506,901,595,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:58:47','2026-07-24 18:00:33',NULL,'image',0,0,NULL),(17,3,1,'public','articles/images/qONVbUdtuWNiN2f2oiRUgnuXbZ6yGyo5ErnZKv6i.png','Screenshot 2026-07-24 215740.png','image/png',806528,897,595,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:58:56','2026-07-24 18:00:33',NULL,'image',0,1,NULL),(18,3,1,'public','articles/images/dcMOP3F4MoVkM9xT3PX8UXvNr6V48s0cl9fGZXnd.png','Screenshot 2026-07-24 215817.png','image/png',825802,589,602,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:59:24','2026-07-24 18:00:33',NULL,'image',0,0,NULL),(19,3,1,'public','articles/images/MWpA1iSVFn6xgh3cBL30B0D9nG1q9mcV5FpgGAux.png','Screenshot 2026-07-24 215757.png','image/png',888338,898,590,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:59:34','2026-07-24 18:00:33',NULL,'image',0,0,NULL),(20,3,1,'public','articles/images/L1OdVGHv7szL9NA4ewfopC2e15FDfdE6k3cqYp6Z.png','Screenshot 2026-07-24 215740.png','image/png',806528,897,595,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:59:45','2026-07-24 18:00:33',NULL,'image',0,0,NULL),(21,3,1,'public','articles/images/fjFFHBpPltYRpMlOAqQDE9htFRoHDs5tTMI10EHJ.png','Screenshot 2026-07-24 213441.png','image/png',884068,1060,603,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:59:55','2026-07-24 18:00:33',NULL,'image',0,0,NULL),(22,4,1,'public','articles/images/fNRNY4xrEuNCUtNJqMacHMMiiN8YpzIybN7RMr8y.png','Screenshot 2026-07-24 215757.png','image/png',888338,898,590,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 18:07:06','2026-07-24 18:07:33',NULL,'image',0,1,NULL),(23,4,1,'public','articles/images/tp4NyQKNsQorJie4viPxK8jGRwVCg3Osw0b2kul9.png','Screenshot 2026-07-24 215817.png','image/png',825802,589,602,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 18:07:14','2026-07-24 18:07:33',NULL,'image',0,0,NULL),(24,4,1,'public','articles/images/2j0udnPjuOtUEdRZUS7IhUnY5oqEQbqiuHgG9yWl.png','Screenshot 2026-07-24 215740.png','image/png',806528,897,595,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 18:07:22','2026-07-24 18:07:33',NULL,'image',0,0,NULL),(25,4,1,'public','articles/images/Hv0cYeDf1Krm2W7XkfakknJogHaN3xnqR8RC9Rcp.png','Screenshot 2026-07-24 215726.png','image/png',708506,901,595,'articles/images',NULL,NULL,NULL,NULL,NULL,'2026-07-24 18:07:28','2026-07-24 18:07:33',NULL,'image',0,0,NULL);

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint unsigned NOT NULL,
  `parent_id` bigint unsigned DEFAULT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint unsigned DEFAULT NULL,
  `page_id` bigint unsigned DEFAULT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_items_parent_id_foreign` (`parent_id`),
  KEY `menu_items_category_id_foreign` (`category_id`),
  KEY `menu_items_page_id_foreign` (`page_id`),
  KEY `menu_items_menu_id_parent_id_sort_order_index` (`menu_id`,`parent_id`,`sort_order`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` VALUES (1,1,NULL,'Home','home','home',NULL,NULL,NULL,'_self',0,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(2,1,NULL,'Latest','latest','custom_url',NULL,NULL,'/news','_self',1,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(3,1,NULL,'Sports','sports','category',2,NULL,NULL,'_self',2,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(4,1,NULL,'Technology','technology','category',3,NULL,NULL,'_self',3,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(5,1,NULL,'Politics','politics','category',6,NULL,NULL,'_self',4,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(6,1,NULL,'Business','business','category',7,NULL,NULL,'_self',5,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(7,1,NULL,'Vacancies','vacancies','vacancies',NULL,NULL,NULL,'_self',6,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(8,2,NULL,'About Us','about','page',NULL,1,NULL,'_self',0,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL);

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

CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_slug_unique` (`slug`),
  UNIQUE KEY `menus_location_unique` (`location`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `menus` VALUES (1,'Main Navigation','main-navigation','header',NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL),(2,'Footer','footer','footer_primary',NULL,1,'2026-07-22 05:05:43','2026-07-22 05:05:43',NULL);

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` 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',2),(4,'2026_07_22_000001_create_boonverse_core_tables',2),(5,'2026_07_22_070251_create_personal_access_tokens_table',2),(6,'2026_07_22_070252_create_permission_tables',3),(7,'2026_07_22_090000_create_search_support_tables',4),(8,'2026_07_22_100000_create_editorial_workflow_tables',5),(9,'2026_07_22_110000_add_country_to_users',6),(10,'2026_07_22_120000_add_workflow_fields_to_vacancies',7),(11,'2026_07_22_130000_create_article_interactions_and_media_links',8),(12,'2026_07_22_140000_normalize_local_media_urls',9),(13,'2026_07_22_150000_approve_existing_comments',10),(14,'2026_07_22_160000_restore_active_menu_categories',11),(15,'2026_07_22_170000_add_soft_deletes_to_admin_resources',12),(16,'2026_07_24_000001_add_profile_fields_and_normalize_roles',13),(17,'2026_07_24_000002_add_application_method_to_vacancies',14);

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(150) 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;

--
-- Dumping data for table `model_has_permissions`
--


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

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(150) 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` VALUES (8,'App\\Models\\User',2),(9,'App\\Models\\User',1),(10,'App\\Models\\User',3),(10,'App\\Models\\User',4);

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `seo_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci,
  `published_at` timestamp NULL 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 `pages_slug_unique` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'About BoonVerse','about-us','BoonVerse is an independent digital newsroom built to inform, explain and connect.','published',NULL,NULL,'2026-07-22 16:57:18','2026-07-22 05:05:43','2026-07-22 16:57:18',NULL);

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--


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

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` VALUES (1,'view_articles','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(2,'create_articles','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(3,'edit_articles','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(4,'delete_articles','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(5,'publish_articles','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(6,'schedule_articles','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(7,'manage_categories','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(8,'manage_tags','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(9,'manage_menus','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(10,'manage_homepage','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(11,'manage_pages','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(12,'manage_users','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(13,'manage_roles','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(14,'manage_comments','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(15,'manage_vacancies','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(16,'manage_companies','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(17,'manage_advertisements','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(18,'manage_newsletter','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(19,'manage_media','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(20,'manage_settings','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(21,'view_analytics','web','2026-07-22 05:05:42','2026-07-22 05:05:42'),(22,'manage_backups','web','2026-07-22 05:05:42','2026-07-22 05:05:42');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`),
  KEY `personal_access_tokens_expires_at_index` (`expires_at`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--

INSERT INTO `personal_access_tokens` VALUES (25,'App\\Models\\User',1,'web','90ce1dcee4f025180930578ebcffc15cbb5861d140b9c1d39ac57bf68d4df85d','[\"*\"]','2026-07-24 18:08:00',NULL,'2026-07-24 17:47:35','2026-07-24 18:08:00');

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

CREATE TABLE `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` VALUES (1,1),(1,2),(1,3),(2,1),(2,2),(2,3),(3,1),(3,2),(3,3),(4,1),(4,2),(5,1),(5,2),(5,3),(6,1),(6,2),(6,3),(7,1),(7,2),(7,3),(8,1),(8,2),(9,1),(9,2),(10,1),(10,2),(11,1),(11,2),(12,1),(12,2),(13,1),(13,2),(14,1),(14,2),(14,3),(15,1),(15,2),(16,1),(16,2),(17,1),(17,2),(18,1),(18,2),(19,1),(19,2),(20,1),(20,2),(21,1),(21,2),(22,1);

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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (8,'visitor','web','2026-07-22 16:57:17','2026-07-22 16:57:17'),(9,'admin','web',NULL,NULL),(10,'author','web',NULL,NULL);

--
-- Table structure for table `search_queries`
--

CREATE TABLE `search_queries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `query` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `normalized_query` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `results_count` int unsigned NOT NULL DEFAULT '0',
  `ip_hash` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `search_queries_user_id_created_at_index` (`user_id`,`created_at`),
  KEY `search_queries_normalized_query_index` (`normalized_query`),
  KEY `search_queries_ip_hash_index` (`ip_hash`),
  KEY `search_queries_created_at_index` (`created_at`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `search_queries`
--

INSERT INTO `search_queries` VALUES (1,NULL,'AI','ai',0,'seed-1','2026-07-22 06:28:59'),(2,NULL,'Manchester United','manchester united',0,'seed-2','2026-07-22 06:27:59'),(3,NULL,'Elections','elections',0,'seed-3','2026-07-22 06:26:59'),(4,NULL,'Apple','apple',0,'seed-4','2026-07-22 06:25:59'),(5,NULL,'Bitcoin','bitcoin',0,'seed-5','2026-07-22 06:24:59'),(6,NULL,'Jobs','jobs',0,'seed-6','2026-07-22 06:23:59'),(7,NULL,'technology','technology',3,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 11:54:33'),(8,NULL,'technology','technology',3,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 11:54:42'),(9,NULL,'technology','technology',3,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 11:58:45'),(10,NULL,'news','news',12,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 11:58:46'),(11,NULL,'boonverse','boonverse',3,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 11:58:46'),(12,NULL,'jobs','jobs',1,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 11:58:47'),(13,NULL,'ai','ai',3,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 12:04:21'),(14,1,'jobs','jobs',1,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 17:34:16'),(15,1,'bitcoin','bitcoin',0,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 20:18:30'),(16,1,'bitco','bitco',0,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 20:18:37'),(17,1,'boonverse','boonverse',3,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-22 20:18:44'),(18,NULL,'ma','ma',1,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:47:33'),(19,NULL,'ki','ki',1,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:47:44'),(20,NULL,'ai','ai',3,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:47:57'),(21,NULL,'gen','gen',2,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:48:17'),(22,NULL,'ge','ge',2,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:48:22'),(23,NULL,'ns','ns',2,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:48:28'),(24,NULL,'nsi','nsi',0,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:48:29'),(25,NULL,'nsima','nsima',0,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:48:32'),(26,NULL,'has','has',1,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 10:48:48'),(27,1,'wh','wh',2,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 19:31:00'),(28,1,'who','who',1,'9171968f19e22cde60dea67981d7a1539db1dc5168cb133e82e8c67cc2154dae','2026-07-24 19:31:00');

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

CREATE TABLE `sessions` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'string',
  `group` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `site_settings_key_unique` (`key`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` VALUES (1,'live_enabled','1','boolean','live_indicator','2026-07-22 06:20:54','2026-07-22 06:20:54'),(2,'live_text','LIVE','string','live_indicator','2026-07-22 06:20:54','2026-07-22 06:20:54'),(3,'live_url','/live','string','live_indicator','2026-07-22 06:20:54','2026-07-22 06:20:54'),(4,'live_dot_color','#22C55E','string','live_indicator','2026-07-22 06:20:54','2026-07-22 06:20:54'),(5,'live_animation_speed','1.6','string','live_indicator','2026-07-22 06:20:54','2026-07-22 06:20:54'),(6,'live_display','both','string','live_indicator','2026-07-22 06:20:54','2026-07-22 06:20:54');

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(140) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tags_slug_unique` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,'Artificial Intelligence','artificial-intelligence',NULL,1,'2026-07-22 06:28:59','2026-07-22 06:28:59',NULL),(2,'Elections','elections',NULL,1,'2026-07-22 06:28:59','2026-07-22 06:28:59',NULL),(3,'Football','football',NULL,1,'2026-07-22 06:28:59','2026-07-22 06:28:59',NULL),(4,'Jobs','jobs',NULL,1,'2026-07-22 06:28:59','2026-07-22 06:28:59',NULL),(5,'Technology','technology',NULL,1,'2026-07-22 06:28:59','2026-07-22 06:28:59',NULL);

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

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` VALUES (1,'BoonVerse Administrator','admin@boonverse.test',NULL,NULL,NULL,NULL,'$2y$12$aM0SCBLEyj7Z3qpokWgpauf3XIlSV3gUQvFIPpha0eV/ydLjp4YhO',NULL,'2026-07-22 05:05:43','2026-07-22 16:57:18',NULL),(2,'Nelson Chiloro','chiloronelson@gmail.com','Malawi','+265990000000',NULL,NULL,'$2y$12$ma.hUaILsz5fx1Vfo85ix.ORQpHPE5KHVa51.b8ZZMUpZ8afG09/C',NULL,'2026-07-24 09:01:21','2026-07-24 16:10:12',NULL),(3,'Nelson Chiloro','2chiloronelson@gmail.com',NULL,'0990426170','profiles/XB5FXSZNnutFIeghiJdqZ82w9SWrdzZ8RVxBZZ85.jpg',NULL,'$2y$12$Ex9mIwKN2AJ5YAoJIN1oDOSLa90SfGHN1EX2A40H4bARMRsj8DegK',NULL,'2026-07-24 15:51:56','2026-07-24 15:53:32','2026-07-24 15:53:32'),(4,'Nelson Chiloro','1chiloronelson@gmail.com',NULL,'0990426170','profiles/u41zttovsVEIYzCTQkBwRqBPc2tGsDatCB0DBIyl.jpg',NULL,'$2y$12$Yc54kwDl66S0faj3rl9YVeN.1HUj6xJFeuf4YcLRYGMRuhjMozi/W',NULL,'2026-07-24 16:16:01','2026-07-24 16:16:01',NULL);

--
-- Table structure for table `vacancies`
--

CREATE TABLE `vacancies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `creator_id` bigint unsigned DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `requirements` longtext COLLATE utf8mb4_unicode_ci,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employment_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `experience_level` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'not_specified',
  `deadline` date DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `views_count` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_method` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banner` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `benefits` text COLLATE utf8mb4_unicode_ci,
  `contact_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `external_application_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `rejection_reason` text COLLATE utf8mb4_unicode_ci,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position_quantity` int unsigned DEFAULT NULL,
  `country_code` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_description` longtext COLLATE utf8mb4_unicode_ci,
  `qualification` longtext COLLATE utf8mb4_unicode_ci,
  `experience` text COLLATE utf8mb4_unicode_ci,
  `application_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_details` text COLLATE utf8mb4_unicode_ci,
  `approved_by` bigint unsigned DEFAULT NULL,
  `submitted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vacancies_slug_unique` (`slug`),
  UNIQUE KEY `vacancies_uuid_unique` (`uuid`),
  KEY `vacancies_company_id_foreign` (`company_id`),
  KEY `vacancies_location_index` (`location`),
  KEY `vacancies_employment_type_index` (`employment_type`),
  KEY `vacancies_deadline_index` (`deadline`),
  KEY `vacancies_status_index` (`status`),
  KEY `vacancies_creator_id_foreign` (`creator_id`),
  KEY `vacancies_approved_by_foreign` (`approved_by`),
  KEY `vacancies_company_name_index` (`company_name`),
  FULLTEXT KEY `boonverse_vacancies_search` (`title`,`description`,`requirements`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vacancies`
--

INSERT INTO `vacancies` VALUES (1,3,1,'CONTROLS AND TECHNICAL ACCOUNTANT','controls-and-technical-accountant-0pus7','CONTROLS AND TECHNICAL ACCOUNTANT\nReporting directly to the Technical Accounting Manager, the successful candidate will among other duties, be responsible for the following:-\nKey responsibilities include:-\nPrepare and review financial statements, control environments, SOPs and Process Improvements.\nManage asset and lease accounting\nSupport capital expenditure and project finance processes.\nEnsure a strong internal control environment and support the organization’s compliance with Sarbanes-Oxley (SOX) requirements.\nPerforming technical accounting reviews\nAssessing journal entries and key controls.\nDocumenting processes, and supporting control testing to ensure accuracy, completeness, and adherence to internal policies and regulatory requirements.\nEnsuring compliance with tax and other regulatory requirements.\n\nQualified and interested candidates should send their applications and Curriculum Vitae (CV) with names of three traceable referees to the address below, no later than 07th August 2026.\nThe Human Resource Services Controller\nAlliance One Tobacco (Malawi) Limited\nP.O. Box 30522\nCapital City,\nLilongwe 3.\nEmail: MWLilongweRecruitment@aointl.com\nOnly shortlisted candidates will be acknowledged.','Qualifications, Experience and Personal Attributes\nBachelors Degree in Accountancy and ACCA qualification or equivalent professional accounting qualification\nMinimum of five (5) years post qualification experience in controls, technical, or audit and accounting roles.\nStrong knowledge of asset accounting, depreciation, and capital project finance.\nProficiency in accounting software (e.g., SAP, Oracle, Microsoft Dynamics)\nAbility to interpret technical specifications and translate them into financial terms.\nExcellent analytical, communication, and problem-solving skills.\nStrong attention to detail and ability to work in a fast-paced, technical environment.\nIntegrity, trustworthy and ethically upright professional in good standing with the Institute of Chartered Accountants in Malawi.','Lilongwe','full_time','not_specified',NULL,'published',0,1,'2026-07-24 17:10:10','2026-07-24 17:10:59',NULL,'Malawi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-07-24 17:10:26',NULL,'55b3a375-e7db-492a-a03c-b00e76d51c9c','Alliance One Tobacco (Malawi) Limited','CONTROLS AND TECHNICAL ACCOUNTANT',1,'MW','Malawi','CONTROLS AND TECHNICAL ACCOUNTANT\nReporting directly to the Technical Accounting Manager, the successful candidate will among other duties, be responsible for the following:-\nKey responsibilities include:-\nPrepare and review financial statements, control environments, SOPs and Process Improvements.\nManage asset and lease accounting\nSupport capital expenditure and project finance processes.\nEnsure a strong internal control environment and support the organization’s compliance with Sarbanes-Oxley (SOX) requirements.\nPerforming technical accounting reviews\nAssessing journal entries and key controls.\nDocumenting processes, and supporting control testing to ensure accuracy, completeness, and adherence to internal policies and regulatory requirements.\nEnsuring compliance with tax and other regulatory requirements.\n\nQualified and interested candidates should send their applications and Curriculum Vitae (CV) with names of three traceable referees to the address below, no later than 07th August 2026.\nThe Human Resource Services Controller\nAlliance One Tobacco (Malawi) Limited\nP.O. Box 30522\nCapital City,\nLilongwe 3.\nEmail: MWLilongweRecruitment@aointl.com\nOnly shortlisted candidates will be acknowledged.','Qualifications, Experience and Personal Attributes\nBachelors Degree in Accountancy and ACCA qualification or equivalent professional accounting qualification\nMinimum of five (5) years post qualification experience in controls, technical, or audit and accounting roles.\nStrong knowledge of asset accounting, depreciation, and capital project finance.\nProficiency in accounting software (e.g., SAP, Oracle, Microsoft Dynamics)\nAbility to interpret technical specifications and translate them into financial terms.\nExcellent analytical, communication, and problem-solving skills.\nStrong attention to detail and ability to work in a fast-paced, technical environment.\nIntegrity, trustworthy and ethically upright professional in good standing with the Institute of Chartered Accountants in Malawi.','5 years+',NULL,NULL,1,'2026-07-24 17:10:10');

--
-- Dumping routines for database 'boonversenew'
--


