-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Feb 08, 2026 at 01:56 PM -- Server version: 11.4.9-MariaDB-cll-lve-log -- PHP Version: 8.3.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `charkuot_SDI_Portal_Live` -- -- -------------------------------------------------------- -- -- Table structure for table `active_publications` -- CREATE TABLE `active_publications` ( `newsletter_id` int(11) NOT NULL, `title` varchar(1024) NOT NULL, `file` varchar(128) NOT NULL, `link` varchar(60) NOT NULL, `posted_by` int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `active_publications` -- INSERT INTO `active_publications` (`newsletter_id`, `title`, `file`, `link`, `posted_by`, `date`) VALUES (89, 'Urban vulnerability, disaster risk reduction and resettlement in Mzuzu city, Malawi', '250430080520_Urban vulnerability, disaster risk reduction and resettlement in Mzuzu city, Malawi.pdf', 'EaTOWMNFtLqpM4lYyL1XE9MV7tii4cVlkIvX9sZrIyS0lXvrXBo2ppW0', 35, '2025-04-30 08:05:20'), (90, 'Understanding Post-disaster Relocation and Resettlement Challenges and Complexities Through a Serious Game', '250430080700_Understanding Post-disaster Relocation and Resettlement Challenges and Complexities Through a Serious Game.pdf', 'gFmkg6Y', 35, '2025-04-30 08:07:00'), (91, 'The key Gender Issues in Disaster Risk Managemnet in Malawi - Policy Brief 2022', '250430082134_The key Gender Issues in Disaster Risk Managemnet in Malawi - Policy Brief 2022.pdf', '3JA0ZDdcvc3xNA6qNtyFKOeJ6dtoUibmEkploiv5nFEFDMBkBMUWTDEQS', 35, '2025-04-30 08:21:34'), (92, 'Risk, Risk Management and Vulnerability to Poverty in Rural Malawi (2008)', '250430082349_Risk, Risk Management and Vulnerability to Poverty in Rural Malawi (2008).pdf', 'g9c7quVideheHgeneOcfY0w41vL2904zSyp1t', 35, '2025-04-30 08:23:49'), (93, 'Remittances, household food security, and entrepreneurship development- A case study of Mzuzu, Malawi', '250430082632_Remittances, household food security, and entrepreneurship development- A case study of Mzuzu, Malawi.pdf', 'mIiU8diKhYYLUfFekcwd9JQQcx8QWUzzHYv4r', 35, '2025-04-30 08:26:32'), (94, 'Physical Vulnerability of Buildings to Flooding in Lilongwe City', '250430082747_Physical Vulnerability of Buildings to Flooding in Lilongwe City.pdf', 'kbxa7hQUQJ5D50xCnVte1ec', 35, '2025-04-30 08:27:47'), (95, 'Natures Voice -Mwanza Addopts Forest Bylaws Volume 11 Issue 2', '250430083117_Natures Voice -Mwanza Addopts Forest Bylaws Volume 11 Issue 2.pdf', '1U0FuRIkpxLI8Zcsa7H7LUshANeupPe3PoQvaWRrwcnyPiBenhD5T9sS', 35, '2025-04-30 08:31:17'), (96, 'NATIONALLY DETERMINED CONTRIBUTIONS -2021', '250430083614_NATIONALLY DETERMINED CONTRIBUTIONS -2021.pdf', '6Tg5DkKXqe0NAjfgHq', 35, '2025-04-30 08:36:14'), (97, 'Measuring Vulnerability to Assess Households Resilience to Flood Risks in Karonga', '250430084022_Measuring Vulnerability to Assess Households Resilience to Flood Risks in Karonga.pdf', 'IF5RBApUrFd4ASetbwoJJxn0L348m8W', 35, '2025-04-30 08:40:22'), (98, 'Mangochi Disaster Contingency Plan 2020-2021 ', '250430085311_Mangochi Disaster Contingency Plan 2020-2021 .pdf', 'gEM4hHPXGqv7sQUq8Ochj1h2Cld6hsRrOaBxS1aUFG0Yqu', 35, '2025-04-30 08:53:11'), (99, 'Malawi Growth and Development Strategy Volume One (2005)', '250430085437_Malawi Growth and Development Strategy Volume One (2005).pdf', 'rqjC7mBRa6dGLCJSWkdDT1gzjUMgQTmj', 35, '2025-04-30 08:54:37'), (100, 'Malawi Growth and Development Strategy II (2011-2016)', '250430085816_Malawi Growth and Development Strategy II (2011-2016).pdf', 'IrJAMGkH1nznJHm1uF3jiK1qsJWg7feVQF7SzmfQ3nRsAdzdulMJlT', 35, '2025-04-30 08:58:16'), (101, 'Malawi Growth and Development Strategy III (2017)', '250430085955_Malawi Growth and Development Strategy III (2017).pdf', '2bhn1iSe3RQFK', 35, '2025-04-30 08:59:56'), (102, 'Knowledge Matters Issue 35 September 2023 Climate Resilience English', '250430091238_Knowledge Matters Issue 35 September 2023 Climate Resilience English.pdf', 'OLDJusSotKm6MO9Scyf7ufj9dem9B5gigr', 35, '2025-04-30 09:12:38'), (103, 'Habitat for Humanity Malawi\'s DRRR Interventions in Chikwawa', '250430091432_Habitat for Humanity Malawi\'s DRRR Interventions in Chikwawa.pdf', 'I9RE1363U67DjdFUBrcvfMm5uHqU0FfFhB6L', 35, '2025-04-30 09:14:32'), (104, 'Governing WASH for disaster risk reduction in Karonga Town, Malawi', '250430091509_Governing WASH for disaster risk reduction in Karonga Town, Malawi.pdf', '5W4m', 35, '2025-04-30 09:15:09'), (105, 'Floods And Sustainable Development- The Case of Nsanje District', '250430091550_Floods And Sustainable Development- The Case of Nsanje District.pdf', 'JQ40HnD3P', 35, '2025-04-30 09:15:50'), (106, 'FLOOD HAZARD AND RISK ASSESSMENT UNDER CLIMATE CHANGE IN THE LOWER SHIRE BASIN, MALAWI', '250430091630_FLOOD HAZARD AND RISK ASSESSMENT UNDER CLIMATE CHANGE IN THE LOWER SHIRE BASIN, MALAWI.pdf', 'XEKQHgkYqNYUX7zLgyL3CzGO', 35, '2025-04-30 09:16:30'), (107, 'FLOOD HAZARD AND RISK ASSESSMENT UNDER CLIMATE CHANGE IN THE LOWER SHIRE BASIN, MALAWI', '250430091630_FLOOD HAZARD AND RISK ASSESSMENT UNDER CLIMATE CHANGE IN THE LOWER SHIRE BASIN, MALAWI.pdf', 'jKy7m5tyBnHAAZ2uUYpwlrt', 35, '2025-04-30 09:16:30'), (108, 'Emergency Plan of Action (Strong Winds and Heavy Rains)', '250430091729_Emergency Plan of Action (Strong Winds and Heavy Rains).pdf', '0ZyFIKuW99CYk4I6iHOnHBdTNmsyvW', 35, '2025-04-30 09:17:29'), (109, 'Emergency Plan of Action ( Cholera Outbreak)', '250430091808_Emergency Plan of Action ( Cholera Outbreak).pdf', 'IUbz0mO1qKVe7PWrZ25KJpCeY56wrvMBlBLKwhTvMeUBN5od', 35, '2025-04-30 09:18:08'), (110, 'El-Nino Effects in Southern Africa Series No.1-Impacts of El Nin?o-Induced Drought in Malawi', '250430091915_El-Nino Effects in Southern Africa Series No.1-Impacts of El Nin?o-Induced Drought in Malawi.pdf', 'IDaTB7titCIYUIeJ6egrRMeUo44brpQijtRAO34VzOot7xy', 35, '2025-04-30 09:19:15'), (111, 'Community based- flood risk management- experiences and challenges in Malawi', '250430092010_Community based- flood risk management- experiences and challenges in Malawi.pdf', 'fZEAGyUhwxnPdrPMYG2SbDe5cpqQRSyCJ52AgWB8pGeGC', 35, '2025-04-30 09:20:10'), (112, 'An assessment of The Impacts of Climate Change and Disasters-Case of Zomba ', '250430092031_An assessment of The Impacts of Climate Change and Disasters-Case of Zomba .pdf', 'XmeRAt1YwwsEmyNiL', 35, '2025-04-30 09:20:31'), (113, 'Assessment of community-based flood early warning system in Malawi', '250430092112_Assessment of community-based flood early warning system in Malawi.pdf', 'SKORBNUejD2DEq7h9avmzEoA9fo', 35, '2025-04-30 09:21:12'), (114, 'Build Back Better - Guidance on Building Flood Resistant Home', '250430092147_Build Back Better - Guidance on Building Flood Resistant Home.pdf', 'lMJ1Mt', 35, '2025-04-30 09:21:47'), (115, 'Catchment protection and management discussion paper', '250430092215_Catchment protection and management discussion paper.pdf', 'E2yjuh5VgSArwdvzN4L8l6mdTS22pYalHtpnDmafKyh4oxYSzsIjNxWVvE', 35, '2025-04-30 09:22:15'), (116, 'Malawi Disaster Risk Profile', '250430092419_Malawi Disaster Risk Profile.pdf', '2p9yZyJKLg93UL2EqrAjFE1JfFsTHs5EeI', 35, '2025-04-30 09:24:19'), (117, 'Climate Risk Maps- Chikwawa 2022', '250430092726_Climate Risk Maps- Chikwawa 2022.pdf', 'JMfG9QpKsBHbzN8cyUQCT3fkPFsAaFIG9Kl71', 35, '2025-04-30 09:27:27'), (118, 'Climate Risk Maps- Mulanje (2022)', '250430093030_Climate Risk Maps- Mulanje (2022).pdf', 'ssyZ3', 35, '2025-04-30 09:30:30'), (119, 'Climate Risk Maps- Nsanje (2022)', '250430103422_Climate Risk Maps- Nsanje (2022).pdf', 'i79nlS1xcuGPDIQMfjGW8WPpHadYLBoLCDeLiFkXhlt1rz', 35, '2025-04-30 10:34:22'), (120, 'Climate Risk Maps- Phalombe (2022)', '250430114125_Climate Risk Maps- Phalombe (2022).pdf', 'hbbk8v8wA75VWajTozpw2QjzieQXG80GO2wntUY8FDS2SaF3jOwv', 35, '2025-04-30 11:41:25'), (121, 'Climate Risk Maps- Zomba (2022)', '250430114541_Climate Risk Maps- Zomba (2022).pdf', 'UZjrdzEXOtuMuXvhXRcnRmizYXPWeTz', 35, '2025-04-30 11:45:41'), (122, 'Mangochi-Storybook(Titukulane Resilience Food Security Activities)', '250430114737_Mangochi-Storybook(Titukulane Resilience Food Security Activities).pdf', 'opgjhnrH0DeQAchoV79N2pNH8JJdaCcyFKjBRHjiWQ', 35, '2025-04-30 11:47:37'), (123, '2019-2024 Disaster Risk Management Plan for Blantyre City', '250430115057_2019-2024 Disaster Risk Management Plan for Blantyre City.pdf', '7sGFYlgLQjmYpWAhrwZAvUKKF', 35, '2025-04-30 11:50:57'), (124, 'Modeling Potential Impacts of Future Climate Change in Mzimba District, Malawi, 2040-2070', '250430115333_Modeling Potential Impacts of Future Climate Change in Mzimba District, Malawi, 2040-2070.pdf', 'Eiyj8MxfTMdNFyRrd7rw8zz6qjU0BugJC5A6MsIe7iOPDi6coyyTo', 35, '2025-04-30 11:53:33'), (125, 'Disaster Risk Management - A sourcebook for secondary schools', '250430115522_Disaster Risk Management - A sourcebook for secondary schools.pdf', '8o21XXxT7wm', 35, '2025-04-30 11:55:22'), (126, 'The-costs-and-benefits-of-environmental-management-disaster-risk-reduction-in-Malawi-2021', '251109091204_The-costs-and-benefits-of-environmental-management-disaster-risk-reduction-in-Malawi-2021.pdf', 'zcUivadjD2UkOJ4lRTikof9OV8JWKcg3mkr7d1k4jNMTJSrxCcFlMmViHz', 34, '2025-11-09 21:12:04'), (127, 'Assessing Capacity and Implementation Status of the Disaster Risk Management Strategy for Health and Community DisasterResilience in Malawi-2021', '251109091310_Assessing Capacity and Implementation Status of the Disaster Risk Management Strategy for Health and Community Disa', 'kJLYKgNJbeRvQge3ob3GywjwoYiFfUx4vsGe2ReOkjt', 34, '2025-11-09 21:13:10'), (128, 'Mitigating proximate impacts of tropical cyclone landfalls in the Southwest Indian Ocean-2023', '251109091724_Mitigating proximate impacts of tropical cyclone landfalls in the Southwest Indian Ocean-2023.pdf', 'FXwUDD9ECbGWOruVsAlpUZ', 34, '2025-11-09 21:17:24'), (129, 'Malawi-Multihazard-Emergency-Response-Plan-2023-2025-1-1', '251109091904_Malawi-Multihazard-Emergency-Response-Plan-2023-2025-1-1.pdf', 'rKvpoYAcqu71LZY5qtR0', 34, '2025-11-09 21:19:04'), (130, 'PROCUREMENT PLAN- REGIONAL CLIMATE RESILIENCE PROGRAM FOR EASTERN AND SOUTHERN AFRICA 2 2023', '251109091927_PROCUREMENT PLAN- REGIONAL CLIMATE RESILIENCE PROGRAM FOR EASTERN AND SOUTHERN AFRICA 2 2023.pdf', 'LjBbAFp6O9', 34, '2025-11-09 21:19:27'), (131, 'Impact of ARC 2022 Payout in Malawi-2024', '251109092020_Impact of ARC 2022 Payout in Malawi-2024.pdf', 'QDBI4lo1hdo1PXKXlv3W5AMNB3qDYG4GzMLAhovJmKlKdiP7X9c1ATuTpD6', 34, '2025-11-09 21:20:20'), (132, 'CHARTING A PATH FOR ENHANCED DISASTER RISK MANAGEMENT-2024', '251109092039_CHARTING A PATH FOR ENHANCED DISASTER RISK MANAGEMENT-2024.pdf', 'mijpEHf8XzjaWrxzghvGvFa8gvCExMjCGGvSv', 34, '2025-11-09 21:20:39'), (133, '2025-2026 Rainfall Season Outlook', '251123070544_2025-2026 Rainfall Season Outlook.pdf', 'GgqlMyxuNamVB99iUOVUSMwXQCijAOfMNTDg8er', 35, '2025-11-23 19:05:44'); -- -------------------------------------------------------- -- -- Table structure for table `blog_categories` -- CREATE TABLE `blog_categories` ( `category_id` int(11) NOT NULL, `category` varchar(128) NOT NULL, `category_link` varchar(60) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `blog_categories` -- INSERT INTO `blog_categories` (`category_id`, `category`, `category_link`) VALUES (11, 'Disaster Risk Management', 'VhnrlGsLuN73cEDamKo5L7n2mX6SVW1LeSKZQbICx'); -- -------------------------------------------------------- -- -- Table structure for table `blog_comments` -- CREATE TABLE `blog_comments` ( `comment_id` int(11) NOT NULL, `blog_id` int(11) NOT NULL, `comment` varchar(1024) NOT NULL, `user_name` varchar(128) NOT NULL, `user_email` varchar(128) NOT NULL, `date_commented` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `blog_posts` -- CREATE TABLE `blog_posts` ( `blog_id` int(11) NOT NULL, `blog_category` varchar(32) NOT NULL, `blog_title` varchar(1024) NOT NULL, `blog_content` longtext NOT NULL, `posted_by` int(11) NOT NULL, `post_thumb` varchar(128) NOT NULL, `post_image` varchar(128) NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `date_posted` timestamp NOT NULL DEFAULT current_timestamp(), `post_link` varchar(60) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `blog_posts` -- INSERT INTO `blog_posts` (`blog_id`, `blog_category`, `blog_title`, `blog_content`, `posted_by`, `post_thumb`, `post_image`, `status`, `date_posted`, `post_link`) VALUES (23, '11', 'NATURAL DISASTERS', '

Occurred during the night of 03-04/05/2025 at Nkhatabay Police Lines (Camp) and Kakumbi area within Nkhatabay District.

\r\n

The following three police officers namely, (1) Chisomo Luphale, D.O.B: 18/06/1995, Village: Chidothi,T/A: Chimaliro District: Thyolo, (2) Blezwick Mizeck, D.O.B: 09/10/1998, Village: Chibanzi, T/A: Msakambewa, District: Dowa and (3). Joseph Chirwa Bango, Village: Bango, T/A: Kaluluma, District: Kasungu all C/o Nkhatabay Police Station, P.O. Box 3, reported that their houses were extensively damaged and washed away by the prolonged heavy rains associated by strong winds.

\r\n

Brief facts are that during the night of 03-04/05/2025 the district was experiencing heavy rains accompanied by strong winds. As a result, the winds blown off roof tops of the first victim\'s house some of his household properties have been completely damaged.

\r\n

The two victims who live outside the Police Camp in a rented semi-detached house located in Kakumbi area their houses have been washed away by the heavy rains. Some of the properties belonging to the third victim such as kitchen utensils, beddings, sofa-set and clothes were found into Nkhata river but in dilapidated state.

\r\n

Additionally, at around 11:00 hours in the morning the following five (5) victims also reported that their houses have been affected by the heavy rains at Kakumbi area; (1). Juliet Mphande, D.O.B: 08/09/1994, Village: Makoza, T/A: Mkumbira, District: Nkhatabay, (2). Rhoda Mphande, D.O.B: 17/04/1968, Village: Kamoza, T/A: Mkumbira, District: Nkhatabay, (3) Gloria Gama, D.O.B: 01/08/1958, Village: Kamoza, T/A: Mkumbira, District: Nkhatabay, (4). Veronica Kanyinji, D.O.B: 02/03/1997, Village: Kamoza, T/A: Mkumbira, District: Nkhatabay and (5). Carolyne Honde, D.O.B: 17/08/1997, Village: Kamoza, Mkumbira, District: Nkhatabay.

\r\n

Properties worthy millions have been damaged due to the impact of the rains which the district received.

\r\n

Some of the victims are currently seeking for a shelter at Nkhatabay Police Station Victim Support Unit (VSU) together with their families. So far Eight (8) houses have been affected by the natural incident. But there are reports that the rains have damaged several houses around Nkhatabay District.

\r\n

Reported by: Chipiliro Khamula

\r\n\r\n


', 34, '250506014955_Natural Disaster 2.jpg', '250506014955_Natural Disaster.j.jpg', 0, '2025-05-06 13:49:55', 'RtV1Ld1FaD'), (24, '11', 'The Department of Disaster Management Affairs (DoDMA) says the country needs almost K2.451 trillion (approximately USD 1.4 billion) to recover from natural disasters that have hit the country for the past four years.', '

#ZBSNews

\r\n

Director of preparedness and response Moses Chimphepo said this today in Mponela during the official opening of a two-day media training on Disaster Risk Management.

\r\n

According to Chimphepo, property worth K1.6 trillion (USD 921 million) got damaged due to various natural disasters that the country has been experiencing, including Cyclone Freddy and Gombe, among others, since 2010.

\r\n

He added that the frequency of climate-related hazards in Malawi has been increasing in recent decades due to population growth, urbanisation and environmental degradation.

\r\n

(by Henderson Charles Msusa-Dowa:05/06)
#malawismostfollowedpage

\r\n


', 34, '250506015958_DODMA 2.jpg', '250506015958_DODMA.j.jpg', 0, '2025-05-06 13:59:58', '3iVnysCPc9IDaqbceRW6Oo3qqeigFU5wIGQvXRTni1FOVBy6'), (25, '11', 'The Malawi Red Cross Society (MRCS) Briefing', '

#Times360Malawi

\r\n

The Malawi Red Cross Society (MRCS) says it targets to raise K200 million during this year\'s Red Cross Flag week which runs from May 8-17.

\r\n

Speaking during a press briefing in Lilongwe, MRCS director of programmes and development Gloria Kunyenga said they target to utilize the resources as this year\'s start up to support its response to different forms of disasters, blood donation and first aid service interventions across the country.

\r\n

Kunyenga challenged the media to play a critical role in raising awareness about the week.

\r\n

President Lazarus Chakwera who is also MRCS patron is expected to launch the week which will be observed under the theme \"on the side of humanity\", on Thursday.

\r\n

During, last year\'s flag week, MRCS collected K56 million which was used to reach out to people who were affected by various forms of disasters.

\r\n

Reported by Pemphero Malimba

\r\n


', 34, '250508074200_MRCS.jpg', '250508074200_MRCS.jpg', 0, '2025-05-08 07:42:00', 's1ok5dV8l'), (26, '11', '1 Million Donation to Flood Affected People in Nkhata-bay', '

#ZBSNews

\r\n

Some members of the households that were affected by flash floods last weekend at Kakumbi in Senior Chief Mkumbira\'s area in Nkhata Bay have asked the government to support them with food, shelter and non-food items.

\r\n

One of the victims, Florence Chauluka, whose house which was being occupied by a tenant has been washed away, suggests that the government should provide them with safer land for house construction as a long-lasting solution.

\r\n

In trying to cushion their shock while waiting for the government\'s response through the Department of Disaster Management Affairs (DoDMA), the legislator for Nkhata Bay, Symon Vuwa Kaunda, has donated K1 million to thirty affected households.

\r\n

Speaking during the donation yesterday, Kaunda said these are just a few of the many affected households in the area and hence assured them that the government will do the much-needed support, as the district council has already assessed the damage caused.

\r\n

(by Norbert Tambalamtuwa Mzembe-Nkhata Bay: 05/07/2025)

\r\n

#malawismostfollowedpage

\r\n


', 34, '250508080929_donation 2.jpg', '250508080929_donation.j.jpg', 0, '2025-05-08 08:09:29', 'TaqeWXpblRCpOwcW4klre76nna0yVD'), (27, '11', 'Lower Shire’s Turn', '

LOWER SHIRE’S TURN

...Concern Worldwide, DoDMA Train Chikwawa and Nsanje-Based Journalists in DRM Communication

Journalists from lower Shire Districts [Chikwawa and Nsanje] have converged on Nchalo, Chikwawa for a four-day Capacity Building Training on Disaster Risk Management (DRM) Communication.

Speaking during the opening ceremony, DoDMA’s Deputy Director for Disaster Resilience Hastings Mwanjoka stressed the need for participants to report and disseminate information throughout the DRM cycle to create a culture of safety and build the resilience of vulnerable communities in the two disaster-prone districts.

Funded by Concern Worldwide with support from the Climate Resilience Alliance Project, which aims at building resilience amongst communities in Lilongwe City, Chikwawa and Nsanje, the training follows a similar exercise held in Mponela from 5th to 7th May. It drew together journalists from Lilongwe City, Dowa and Kasungu.


', 35, '250513071833_IMG_0760.jpeg', '250513071833_IMG_0761.jpeg', 0, '2025-05-13 07:18:33', 'TNDYunVd1MbQW9DJ'), (28, '11', 'DCCMS Calls for Communication of Understandable Weather Knowledge Amongst Community Members ', '

#Times360Malawi

\r\n

Department of Climate Change and Meteorological Services (DCCMS) Chief Meteorologist and Head of Public Weather Services, Yobu Kachiwanda, on Sunday 25/05/2025 said that it is crucial to impart knowledge of weather among community members.

\r\n

He was speaking at Senior Chief Chamba in Machinga district during training of trainers that the consortium organized on Participatory Scenario planning.

\r\n

Kachiwanda, called on the people to get used to following the weather updates, rating them as crucial.

\r\n

Through Trocaire, a consortium of non-governmental organizations is running an Irish Aid Civil Society Programme (ICSP) initiative, which has three components of sustainable livelihoods, disaster management and women empowerment.

\r\n

Trocaire\'s Climate Justice and Disaster Risk Management Project Officer Phillip Nyasulu said their aim was to empower vulnerable groups, which include women, girls, the elderly and people with disabilities to resilience

\r\n

The organizations under these initiatives are Catholic Development Commission in Malawi (Cadecom) Zomba and Mangochi, Churches Action in Relief and Development (Card), Ujama Pamodzi, Cicod, and government\'s Department of Climate Change and Meteorological Development (DCCMS).

\r\n

Reported by Jarson Malowa, @JarsieM

\r\n


', 34, '250527100058_DCCMS3.jpg', '250527100058_DCCMS4.jpg', 0, '2025-05-27 10:00:58', 'yJH8Dcm3kTWqe7Ly'), (29, '11', 'Strengthening the Voice of Meteorology: Communication Skills Training', '
\r\n
The Department of Climate Change and Meteorological Services (DCCMS) hosts a specialized training program titled “Communication Skills for Meteorologists.” The training equips meteorologists with practical tools to effectively communicate weather and climate information to diverse audiences, including the media, policymakers, and the general public. Through interactive sessions, participants sharpen their ability to simplify technical language, improve public speaking, and tailor messages for different stakeholders. This initiative forms part of DCCMS’s ongoing efforts to enhance the accessibility and impact of weather and climate services in Malawi. By strengthening communication skills, meteorologists improve their ability to support informed decision-making, promote public safety, and raise awareness of climate-related issues. The training represents a crucial step in bridging the gap between science and society, ensuring that forecasts and warnings are not only accurate but also clearly understood and actionable.
\r\n
\r\n
\r\n
https://www.metmalawi.gov.mw/.../strengthening-the-voice.../
\r\n

\r\n
28 May 2025
\r\n
\r\n


', 35, '250528091021_502437709_1015028630807537_2251555692696114700_n.jpg', '250528091021_502437709_1015028630807537_2251555692696114700_n.jpg', 0, '2025-05-28 09:10:21', 'KPkWh4m4WiRpSINVTe9IDLK'), (30, '11', 'China Donates 36,600 Bags of Rice ', '

The Department of Disaster Management Affairs (Dodma) has asked the People\'s Republic of China and other development partners to support Malawi in promoting irrigation Farming in the country.

\r\n

Dodma Commissioner Moses Chimphepo said this during the official handover ceremony of 1,830 metric tonnes of rice which translate to 36,600 bags weighing 50 Kgs each from the government of China, in Lilongwe.

\r\n

Chimphepo said Malawi continues facing climatic change effects characterized by dry spells among others, a development that needs people to be engaging in irrigation activities to ensure food security in their households.

\r\n

He however commended China for its continued support towards people affected by various forms of disasters in the country.

\r\n

Chinese Ambassador to Malawi Lu Xu said the humanitarian assistance signifies China\'s commitment to supporting Malawi through various sectors.

\r\n

Lu Xu further said her government will consider support towards irrigation farming in its programmes for Malawi.

\r\n

China has made the donation in response to the devastating effects of El Nino weather conditions experienced during 2023/2024 rainfall season, in three consignments which started arriving in Malawi in November 2024 and so far, Dodma has distributed the rice to 25,000 out of over 36,000 intended households (164,700 people) in various parts of the country.

\r\n

Reported by Pemphero Malimba

\r\n


', 34, '250624070922_Dodma 11.jpg', '250624070922_Dodma 22.jpg', 0, '2025-06-24 19:09:22', 'TeQDQFSc94Wtgp74xmOR5qwYwfDVLtdiMLQqdv8MDfezvmyQRykQx'), (31, '11', 'PREACHING DRM MAINSTREAMING AT DRR DIALOGUE MEETING', '
\r\n
On Tuesday (15th July, 2025) we participated in a dialogue meeting on disaster risk reduction (DRR) organized by University of East Anglia postgraduate researcher, John Chirwa who is carrying out an academic research on the Role of Communication in DRM in Malawi.
\r\n
\r\n
\r\n
During the meeting held at Capital Hotel, Lilongwe with funding from the Arts and Humanities Research Council, we stressed the need for mainstreaming and ensuring a holistic approach in the implementation of various disaster risk management (DRM) programmes.
\r\n
\r\n
\r\n
Our Deputy Director of Disaster Response Fyawupi Mwafongo emphasized that DRM should be part and parcel of every sector’s normal programming, planning and budgeting for a disaster-resilient nation.
\r\n
\r\n
\r\n
We are optimistic that John’s research, which is focusing on participatory communication, will unearth ideas that will shape the programming and channeling of DRR and early warning information to the most vulnerable communities and assist in building their resilience to climate shocks.
\r\n
\r\n

\r\n


', 35, '250722094301_518340446_1050877270570059_5887598831067814931_n.jpg', '250722094301_519393980_1050877210570065_4749467529150876006_n.jpg', 0, '2025-07-22 09:43:01', '8rpaIfRPWVZwZEcMhaxmhjlW9833iMPIikQLDYdph9'), (32, '11', 'LET’S INVEST IN RESILIENT FOOD SYSTEMS', '
\r\n
…Central-region-based councils, humanitarian
\r\n
partners converge for lean season response after action review
\r\n
\r\n
\r\n
The Department of Disaster Management Affairs (DoDMA) has called on councils, various humanitarian and donor partners to support investments in resilient food systems if the country were to break the food insecurity cycle.
\r\n
\r\n
\r\n
Commissioner for Disaster Management Affairs Rev. Moses Owen Chimphepo made the call on Thursday (17th July, 2025) in Lilongwe when he officially opened the 2024-25 Lean Season Food Insecurity Response Programme (LS-FIRP) After Action Review (AAR) which was held to reflect on successes, experiences and challenges that would improve subsequent programmes.
\r\n
\r\n
\r\n
“It is high time we moved away from depending on rain-fed agriculture. I therefore, call upon all partners to support vulnerable households with interventions that will ensure their food security from their own production. This will also cushion thousands of vulnerable households from climatic shocks and save, significantly, huge amounts of resources that government and partners spend on consumption,” said Chimphepo.
\r\n
\r\n
\r\n
World Food Programme’s (WFP) Deputy Country Director Simon Denhere echoed Chimphepo’s remarks; stressing the need for partners to join hands in building a more self-sustainable and better-prepared future for the most vulnerable households and communities.
\r\n
\r\n
\r\n
The one-day meeting, which has drawn together councils from the central region and various disaster clusters (sector working groups) has been held with support from WFP.
\r\n
\r\n


', 35, '250722094535_518347080_1051778910479895_7910050221300150224_n.jpg', '250722094535_519615334_1051778230479963_3931768441171407636_n.jpg', 1, '2025-07-22 09:45:35', 'gSgmqdykcT8JuJze7oRPkAOBFxiZe'), (33, '11', 'MALAWI DECLARES STATE OF DISASTER FOLLOWING PROLONGED DRY SPELLS-INDUCED FOOD INSECURITY', '

State President Prof. Arthur Peter Mutharika has declared state of disaster in eleven districts of the country following prolonged dry spells-induced food insecurity. The declaration is in line with section 37 (1) of the Disaster Risk Management Act (2023).

In a press statement dated 25th October, 2025 and signed by Chief Secretary to Government Dr. Justin Saidi, Mutharika has declared state of disaster in Blantyre, Chikwawa, Lilongwe, Mulanje, Mwanza, Neno, Nkhotakota, Nsanje, Phalombe, Salima and Thyolo.

The statement further appeals for local and international support to families affected by the food insecurity situation.

“Accordingly, government is facilitating provision of humanitarian assistance to the affected districts and intensify irrigation farming and is therefore, appealing for local and international support for the affected families and the irrigation initiatives as well as other interventions to address the situation,” reads part of the statement.

Recently, the Malawi Vulnerability Assessment Committee released a report which stated that over four million people will be food insecure for during the 2025/26 lean period (October 2025 to March 2026).

', 35, '251205015117_572787795_1134156975575421_4356086213208391418_n.jpg', '251205015117_572787795_1134156975575421_4356086213208391418_n.jpg', 1, '2025-12-05 13:51:17', 'R9UMenY8Fc8GKcBC1iQlNImRHPpc1gU'), (34, '11', 'A LIFELINE OF HOPE AND RESILIENCE', '
\r\n
…Norway Contributes US$ 8.3 Million towards Lean Season Response and Home-Grown School Feeding Programme
\r\n
\r\n
\r\n
The Government of Norway on Wednesday, 19th November, 2025 contributed (through World Food Programme Malawi) US$8.3 million towards the 2025/26 Lean Season Food Insecurity Response and the Home-Grown School Feeding Programmes.
\r\n
\r\n
\r\n
Speaking in Lilongwe during the official handover ceremony, Norwegian Ambassador to Malawi Anne Sofie Bjelland, said her government’s support aims to complement national efforts and ensuring that humanitarian assistance is part of a holistic approach.
\r\n
\r\n
\r\n
In his remarks, Commissioner for Disaster Management Affairs Wilson Moleni described the contribution as not just a financial commitment, but a lifeline of hope and resilience for millions of Malawians.
\r\n
\r\n
\r\n
WFP Malawi Country Director and Representative Hyoung-Joon Lim, said the support is vital for ensuring food security and seeing to it that children receive the nutrition they need to learn and thrive.
\r\n
\r\n
\r\n
Out of the US$8.3 million, 4.5 million will support the implementation of the lean season response whereas 3.8 million will cater for the school feeding programme.
\r\n
\r\n


', 35, '251205021253_585346080_1154541303536988_883953302046067075_n.jpg', '251205021253_585362263_1154541976870254_1154418254004625987_.jpg', 1, '2025-12-05 14:12:53', '8qWSj4ceJxAN6SzNIPHfoRBAK54LgSjVpIFCd5iN4LAobhZTIF'), (35, '11', 'A second-year Bachelor of Science in Geography student at the University of Malawi (Unima) has developed an app that detects weather anywhere in the world within five minutes.', '

A second-year Bachelor of Science in Geography student at the University of Malawi (Unima) has developed an app that detects weather anywhere in the world within five minutes.

\r\n

Fortune Kamphinda who is based in Lilongwe designed the app to combine geography with modern technology.

\r\n

The system gives instant data on rainfall, temperature, clouds, pressure, humidity, wind, and day-night conditions, all displayed through interactive maps, satellite imagery, and elevation models.

\r\n

The app also features six key functions, including Get Weather, 5-Day Forecast, View Map, Dashboard, and Forecast Chart.

\r\n

It also has room to detect unusually high rainfall that may cause flooding in Malawi and other countries, issuing automatic audio and text alerts in English and Chichewa.

\r\n

Using data from NASA, Google Satellite, ESRI, OpenWeatherMap, and others, the tool can as well track global cyclones.
(Reported by Jarson Malowa)

\r\n


', 35, '251213080010_WhatsApp Image 2025-12-13 at 20.15.57.jpeg', '251213080010_WhatsApp Image 2025-12-13 at 20.15.57.jpeg', 1, '2025-12-13 20:00:10', 'Gxhd4M9RZu'); INSERT INTO `blog_posts` (`blog_id`, `blog_category`, `blog_title`, `blog_content`, `posted_by`, `post_thumb`, `post_image`, `status`, `date_posted`, `post_link`) VALUES (37, '11', 'PRESS RELEASE: UPDATE ON DISASTERS AND RESPONSE FOLLOWING INCESSANT RAINS', '


', 35, '251229062743_IMG_9269.JPG', '251229062743_IMG_9268.JPG', 1, '2025-12-29 18:27:43', 'FyKXlyLEHwGx3msYok9gnqk'); INSERT INTO `blog_posts` (`blog_id`, `blog_category`, `blog_title`, `blog_content`, `posted_by`, `post_thumb`, `post_image`, `status`, `date_posted`, `post_link`) VALUES (38, '', 'Vice Presidents Say on Current Floods', '
\r\n
\r\n
\r\n
#ZBSNews
\r\n
\r\n
\r\n
Vice-President, Dr Jane Mayemu Ansah, says government has strengthened contingency measures as heavy rains continue to devastate the country, affecting more than 42,000 people in over 9,300 households, with four people dead and 101 injured.
\r\n
\r\n
\r\n
In a Facebook post, Dr Ansah said relief supplies have been moved closer to high-risk areas, rescue teams placed on standby, and public awareness campaigns intensified to reduce the impact of floods.
\r\n
\r\n
\r\n
She said the situation remains serious, with homes, roads and crops damaged, and livestock swept away in several districts.
\r\n
\r\n
\r\n
The Vice-President added that the Department of Disaster Management Affairs is coordinating response efforts, organising rescues, setting up emergency centres, and working closely with security agencies in affected communities.
\r\n
\r\n
\r\n
Dr Ansah has urged citizens and development partners to follow weather advisories and support affected families, stressing that effective disaster response requires collective action.
\r\n
\r\n
\r\n
(by Chisomo Chingwalu – Lilongwe: 12/31/25) #malawismostfollowedpage
\r\n
\r\n\r\n
\r\n
', 34, '251231071721_1111.jpg', '251231071721_1111.jpg', 1, '2025-12-31 19:17:21', '4Cn3IQ5'), (39, '11', 'Effect of Current Heavy Rain', '
\r\n
#ZBSNews
\r\n
The Malawi Engineering Institution has called for a review of bridge design, construction management, and environmental oversight after heavy rains and floods caused widespread damage to roads and bridges.
\r\n
\r\n
\r\n
Its CEO, Engineer Arthur Wengawenga, says the extreme weather exposed the limits of current infrastructure.
\r\n
\r\n
\r\n
“Several bridges could not handle the volume of water, leading to significant destruction,” Wengawenga explained.
\r\n
\r\n
\r\n
He warned that climate change is increasing rainfall intensity, noting that Kasungu Station may have recorded such heavy rainfall for the first time in years.
\r\n
\r\n
\r\n
Wengawenga has also blamed environmental degradation upstream, including deforestation, which worsens runoff and amplifies flood damage to roads and bridges.
\r\n
\r\n
\r\n
(by Chisomo Chingwalu-Lilongwe: 12/31/25)
\r\n
#malawismostfollowedpage
\r\n
\r\n\r\n


', 34, '251231072602_3333.jpg', '251231072602_2222.jpg', 1, '2025-12-31 19:26:02', 'kEh6Q4zqsS9fqmbleXGLi8QfdCq30yEO'), (40, '11', 'Summary of Disasters Following Incessant Rains', '

The Department of Disaster Management Affairs (DoDMA) reports that between 22nd and 30th December 2025, Malawi experienced widespread disasters following incessant rains, which affected a total of 9,143 households across the country. During this period, 101 people were injured, 4 lives were lost, and 354 people were successfully rescued, while no persons were reported missing. This shows that although the impacts were serious, emergency response and rescue efforts helped prevent further loss of life.

\r\n

The majority of the affected households were impacted by stormy rains, which accounted for 8,191 households, making it the most significant hazard during this period. Heavy rains affected 521 households, while flooding impacted 426 households. Overall, rainfall-related hazards were the main drivers of destruction, with stormy conditions causing the greatest damage to homes and livelihoods.

\r\n

In terms of geographic distribution, the Southern Region was the most affected. Nsanje District recorded the highest number of affected households at 2,549, followed by Chikwawa with 1,913. Other heavily affected districts included Karonga (1,031), Dedza (711), Chiradzulu (597), and Blantyre (516). Moderate impacts were reported in Dowa, Nkhotakota, Likoma, Lilongwe, and Mulanje, while lower numbers were recorded in Zomba City, Kasungu, Lilongwe City, Chitipa, Nkhata Bay, and Salima. The spatial pattern confirms that flood- and storm-prone areas, especially in southern Malawi, remain highly vulnerable to extreme rainfall events.

\r\n

Overall, the information highlights the continued exposure of communities to climate-related disasters in Malawi and underscores the importance of strengthening early warning systems, community preparedness, and disaster risk reduction measures, particularly in districts that are repeatedly affected by heavy and stormy rains.

\r\n\r\n


', 34, '251231073858_44444.jpg', '251231073858_44444.jpg', 1, '2025-12-31 19:38:58', 'ucmJqYFTorZStCZOBBd00L3JezboVViDeoiGADz'), (41, '11', 'MDF Joins Flood Rescue Efforts in Nkhotakota', '
\r\n
#Times360Malawi
\r\n
\r\n
\r\n
The Malawi Defence Force (MDF) has stepped up rescue and evacuation operations in Nkhotakota District following five consecutive days of heavy rainfall that triggered widespread flooding.
\r\n
\r\n
\r\n
Nkhotakota District Council Spokesperson, Wongani Mkandawire, said the soldiers have been deployed to work alongside disaster response teams from the Department of Disaster Management Affairs (DoDMA) to support emergency rescue efforts in the worst-hit areas.
\r\n
\r\n
\r\n
He said the MDF’s involvement is aimed at reinforcing evacuation operations and ensuring that affected residents are safely relocated to designated evacuation camps.
\r\n
\r\n
\r\n
Mkandawire said preliminary assessments indicate that about 30,000 people have been affected by the floods, while five people including a pregnant woman are still missing in Dwangwa, under the jurisdiction of Senior Chief Kanyenda.
\r\n
\r\n
\r\n
Reported Innocent Chunga
\r\n
\r\n\r\n


', 34, '260102115953_66666.jpg', '260102115953_77777.jpg', 1, '2026-01-02 11:59:53', 'NNvbI'), (43, '11', 'Destructive Hailstorm Leaves Trail of Damage in T/A Mwabulambya', '
\r\n
#Times360Malawi
\r\n
\r\n
\r\n
A hailstorm that struck Traditional Authority Mwabulambya in Chitipa District on January 2, 2026, around 3pm has affected 23 households and one church in seven villages: Stanford, Laban, Mweningala, Alufeyo, Namwalika, James and Henry.
\r\n
\r\n
\r\n
Chitipa District Council PRO Aliko Munde said some houses had roofs blown off while others partially collapsed, while the Pentecostal Holiness Church completely collapsed. One 78 year old woman sustained injuries, and farmland growing maize, beans and soya was destroyed.
\r\n
\r\n
\r\n
Munde said the affected households urgently need assistance in the form of food, shelter and agricultural inputs, and appealed to the corporate world and other well-wishers to support the victims as they recover from the disaster.
\r\n
\r\n
\r\n
Vinjeru Betera Mkandawire
\r\n
\r\n\r\n


', 34, '260104113329_8888.jpg', '260104113329_9999.jpg', 1, '2026-01-04 23:33:29', 'AwEWr3NCr28cBuW8tmvRTfskok1tP6WBit6evYQ'), (44, '11', 'UPDATE ON DISASTERS AND RESPONSE OPERATIONS', '

The Department of Disaster Management Affairs (DoDMA) reports that during the 2025/26 rainy season, Malawi has been affected by stormy rains, strong winds, flash floods, and lightning. These hazards have impacted 36,283 households, representing about 163,274 people, across 29 districts. As a result, 40 people lost their lives and 209 were injured, mainly due to lightning strikes and collapsing walls.

\r\n

Flooding alone affected 1,912 households and displaced 2,132 people, who were sheltered in 14 temporary camps. By 19 January 2026, DoDMA had successfully closed 13 of the 14 camps and supported affected families with return-home packages, including food and basic household items. One camp in Nkhata Bay remains open.

\r\n

To respond to the disasters, K8.6 billion has been mobilized for relief and recovery efforts, but there is still a funding gap of K4 billion. DoDMA is therefore appealing to donors, organizations, and individuals to provide additional support to help restore services, prevent further impacts, and support early recovery

\r\n\r\n


', 34, '260126052958_121212121212121212.jpg', '260126052958_121212121212121212.jpg', 1, '2026-01-26 17:29:58', 'x3VEysGTPQ5fSeF0gDkhxf9y5nm1aosC5ZjAkkrKFIpFfkxuoc'), (45, '11', 'Chinese Chamber of Commerce Donates maize worth K80 million and K20 million Cash', '
\r\n
The Chinese community plying their businesses in the country under the banner Chinese Chamber of Commerce on Thursday 22nd January, 2026, donated maize worth K80 million and cash amounting to K20 million towards the 2025-26 Lean Season Food Insecurity Response Programme.
\r\n
\r\n
\r\n
Speaking at Capital Hill, Lilongwe during a symbolic handover ceremony, Chinese Chambers of Commerce’s Chairperson Zhou Shanjian said they felt compelled to make the donation.
\r\n
\r\n
\r\n
“This [Malawi] is our second home. We hope that the donation will continue restoring hope to vulnerable communities affected by food insecurity,” said Shanjian.
\r\n
\r\n
\r\n
In his appreciation speech, Chief Secretary in the Office of the President and Cabinet Dr. Justin Adack Saidi said the gesture is an act of responsibility, solidarity and oneness towards the provision of assistance to households affected by food insecurity.
\r\n
\r\n\r\n


', 34, '260126053630_131313131313131313.jpg', '260126053630_14141414141414.jpg.jpg', 1, '2026-01-26 17:36:30', 'XBsJ6Plw7Bdko7G5vFkFxOLHzQhZCEx4NEo'), (46, '11', 'Zimbabwe Donates Assorted Relief Items to Malawi', '
\r\n
“INSEPARABLE TWINS”
\r\n
\r\n
\r\n
…Zimbabwe Donates Assorted Relief Items to Malawi
\r\n
\r\n
\r\n
…“This is a demonstration of goodwill and solidarity,”-Chaponda
\r\n
\r\n
\r\n
“Zimbabwe and Malawi are inseparable twins and the former’s shoulder is always available for the latter to lean on in her time of need,” said Dr. Nancy Saungweme, Zimbabwe Ambassador to Malawi.
\r\n
\r\n
\r\n
She made the remarks at Capital Hill, Lilongwe when her Government donated assorted relief items that include 300 tons of red sorghum, 800kgs of mealie-mill, 280kgs of sugar, 144 litres of cooking oil, 322 cabin tents and 697 blankets.
\r\n
\r\n
\r\n
She quoted President Emmerson Mnagwagwa’s remarks, stressing that in times of adversity, the spirit of Pan-African solidarity must guide people’s actions.
\r\n
\r\n
\r\n
In his remarks, Minister of Foreign Affairs and International Cooperation Dr. George Thapatula Chaponda described the gesture as a deep of relief.
\r\n
\r\n
\r\n
“We are deeply grateful for this demonstration of goodwill and solidarity which will be remembered as a testament to the strong bonds of our bilateral relations. On behalf of the State President H.E. Prof. Arthur Peter Mutharika and the people of Malawi, kindly extend our heartfelt gratitude to H.E Comrade Dr. Emmerson Dambudzo Mnangagwa and the people of Zimbabwe,” said Chaponda.
\r\n
\r\n\r\n


', 35, '260129090150_620026979_1206202291704222_5600150379910019643_n.jpg', '260129090150_622949355_1206201808370937_221573478448841241_n..jpg', 1, '2026-01-29 09:01:50', 'X851'), (47, '11', 'Information on Tropical Storm Fytia', '

The Department of Climate Change and Meteorological Services (DCCMS) issued an update on Tropical Storm Fytia on 30 January 2026 at 12:00. The storm developed in the Mozambique Channel and, at the time of the report, was located at 15.7° South, 47.2° East, with a central pressure of 987 hPa and moving east–south-east at 24 knots (about 44 km/h). According to the forecast track, the storm was expected to move towards landfall in Madagascar within the next 24 hours.

\r\n

DCCMS indicated that Tropical Storm Fytia was not expected to have a direct impact on Malawi’s weather, but the department committed to continue monitoring the situation and provide updates if conditions changed.

\r\n

However, the bulletin warned that localized heavy rainfall would still likely occur over central, northern, and parts of lakeshore areas of Malawi over the next three days, while conditions in the southern areas were expected to remain mostly dry

\r\n\r\n


', 34, '260131092900_623367064_1209289658048099_5091167717726718092_n.jpg', '260131092900_623367064_1209289658048099_5091167717726718092_n.jpg', 1, '2026-01-31 21:29:00', 'T9kXWaBA0hjHJPUygYhxyMnXvIRVnyW5P2h'), (48, '11', 'DRY SPELL ADVISORY FOR SOUTHERN MALAWI', '
\r\n
Issued: 31/01/2026
\r\n
Valid: Next 7 days
\r\n
\r\n
\r\n
Situation Overview
\r\n
The southern areas of Malawi have experienced a prolonged dry spell over the past week or more. Current weather analysis and forecast indicate that these conditions are likely to persist over the next 7 days.
\r\n
\r\n
\r\n
Areas Most Affected
\r\n
• Category 9: Chikwawa, Nsanje, Blantyre, Thyolo, Mwanza, Neno, Zomba, Pha-lombe, Mulanje, Balaka, Machinga, Mangochi, Salima, Dedza, Ntcheu
\r\n
• Category 4: Parts of Lilongwe, Mchinji, Dowa and Ntchisi.
\r\n
\r\n\r\n


', 34, '260131093653_624779037_1209805781329820_3170629057910721708_n.jpg', '260131093653_624779037_1209805781329820_3170629057910721708_n.jpg', 1, '2026-01-31 21:36:53', 'EX1oaGE1Un1RwaBSULmsps4bmMFLbFtTZA4jpshiG3IjWFXNS6H'); -- -------------------------------------------------------- -- -- Table structure for table `drm_projects` -- CREATE TABLE `drm_projects` ( `newsletter_id` int(11) NOT NULL, `title` varchar(1024) NOT NULL, `file` varchar(128) NOT NULL, `link` varchar(60) NOT NULL, `posted_by` int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `drm_projects` -- INSERT INTO `drm_projects` (`newsletter_id`, `title`, `file`, `link`, `posted_by`, `date`) VALUES (43, 'DRM NATIONAL ', '250424034346_DRM NATIONAL .pdf', 'T7oxYKiUVkwFO2cW4hojAlAATUj1apOsrcNq6eXH1W06nLqTdfh', 44, '2025-04-24 15:43:46'), (44, 'YY', '250424034358_YY.pdf', 'SXcbaGzTPZ4', 44, '2025-04-24 15:43:58'), (45, 'National 1', '250424061234_National 1.pdf', '7ubrFByiH2WA0YD0KWh1BrQu7U8HWRaLwI3cotQPlTG', 44, '2025-04-24 18:12:34'), (46, 'NATO', '250424061906_NATO.pdf', 'MfGAZq1lsk7X4DgQmlB996IQatBzW23UyoiD2fBnl8hwHj5CvUszaav', 44, '2025-04-24 18:19:06'); -- -------------------------------------------------------- -- -- Table structure for table `drm_publications` -- CREATE TABLE `drm_publications` ( `report_id` int(11) NOT NULL, `title` varchar(128) NOT NULL, `file` varchar(128) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `drm_publications` -- INSERT INTO `drm_publications` (`report_id`, `title`, `file`, `date`) VALUES (20, 'DRM iNTERNATIONAL', '250424035536_DRM iNTERNATIONAL.pdf', '2025-04-24 15:55:36'), (21, 'International 1', '250424061315_International 1.pdf', '2025-04-24 18:13:15'), (23, 'yyyyy', '250424082646_yyyyy.pdf', '2025-04-24 20:26:46'), (24, 'ttttoooooooooooo', '250424082806_ttttoooooooooooo.pdf', '2025-04-24 20:28:06'), (25, 'ttttoooooooooooo', '250424082938_ttttoooooooooooo.pdf', '2025-04-24 20:29:38'), (26, '88888 ppppp', '250424082958_88888 ppppp.pdf', '2025-04-24 20:29:58'); -- -------------------------------------------------------- -- -- Table structure for table `drm_reports` -- CREATE TABLE `drm_reports` ( `newsletter_id` int(11) NOT NULL, `title` varchar(1024) NOT NULL, `file` varchar(128) NOT NULL, `link` varchar(60) NOT NULL, `posted_by` int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `event_id` int(11) NOT NULL, `title` text NOT NULL, `venue` varchar(128) NOT NULL, `date` date NOT NULL, `thumb` varchar(128) NOT NULL, `image` varchar(128) NOT NULL, `details` longtext NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `date_posted` timestamp NOT NULL DEFAULT current_timestamp(), `posted_by` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `events` -- INSERT INTO `events` (`event_id`, `title`, `venue`, `date`, `thumb`, `image`, `details`, `status`, `date_posted`, `posted_by`) VALUES (12, 'WARNING ON MWERA WINDS 12TH MAY TO 15TH MAY 2025', 'Lakeshore Areas', '2025-05-10', '250510031450_DCCMS.jpg', '250510031450_DCCMS.jpg', '

???
The Department of Climate Change and Meteorological Services would like to warn the Malawi nation that Mwera winds are expected blow on Lake Malawi and other lake water bodies from Monday night 12th May 2025 with a speed of more than
50 km/h. High water waves of more than 2 meters in height. These winds are expected to subside by Thursday 15th May 2025.

\r\n

Consequently, we are also likely to experience Chiperoni weather, which is associated with rainy, windy, cloudy, and chilly conditions, including fog patches over many areas beginning from the southern Malawi progressing northwards.

\r\n

WhatsApp: https://whatsapp.com/channel/0029VaT21WW8PgsBmJWWGc1A

\r\n

Website: https://www.metmalawi.gov.mw/weather-warnings/mphepo-mwera-pa-nyanja-zathu-zonse/

\r\n


', 1, '2025-05-10 15:14:50', 34), (13, 'FLASH FLOOD WARNING (29 Dec 2025 – 01 Jan 2026)', 'lakeshore, northern and central Areas', '2025-12-29', '251231075204_555.jpg', '251231075204_555.jpg', '
\r\n
\"??\" FLASH FLOOD WARNING (29 Dec 2025 – 01 Jan 2026)
\r\n
\r\n
\r\n
\"??\" Persistent heavy rainfall expected across lakeshore, northern and central Malawi
\r\n
\r\n
\r\n
\"?\" High risk of flash flooding in low-lying and flood-prone areas
\r\n
\r\n
\r\n
\"??\" Weather conditions include intense downpours, moderate Mwera winds, and frequent lightning \"?\"
\r\n
\r\n
\r\n
\"?\" Category 10 alerts issued for Nkhata Bay and Nkhotakota
\r\n
\r\n
\r\n
\"??\" Category 6 and 2 warnings in parts of Karonga, Mzimba, Mzuzu, Likoma, and Kasungu
\r\n
\r\n
\r\n
\"?\" The hazardous weather is due to the prolonged presence of the Inter-Tropical Convergence Zone (ITCZ) over northern Malawi
\r\n
#Department of Climate Change & Meteorological Services# 
\r\n
\r\n\r\n


', 1, '2025-12-31 19:52:04', 34), (14, 'HEAVY RAINS WARNING FROM 07TH JANUARY TO 9TH JANUARY 2026.', 'Nkhotakota, Salima, parts of Mzimba, Kasungu, Nkhata Bay, Dowa Mchinji, and Ntchisi', '2026-04-01', '260106072800_WhatsApp Image 2026-01-06 at 9.20.58 PM.jpeg', '260106072800_WhatsApp Image 2026-01-06 at 9.20.58 PM.jpeg', '
DCCMS is issuing a warning of heavy rainfall expected to affect lakeshore areas and several parts of the country. The adverse weather, characterized by intense downpours accompanied by strong winds and frequent lightning is likely impact Nkhotakota, Salima, parts of Mzimba, Kasungu, Nkhata Bay, Dowa Mchinji, and Ntchisi which are failing under category 10 alerts. Mzuzu, Likoma, Machinga, Mangochi, parts of Zomba, and Balaka which are under falling under category 6 while the remaining districts are under category 5 of warnings. These risky conditions are due to the low-pressure system which is in the Mozambique channel and currently enhancing Congo air mass but expected to pass through Malawi on Wednesday.
\r\n

\r\n
DCCMS wishes also to inform Malawians that the Tropical Storm GRANT which was coming from Australia side has now weakened and is moving towards Madagascar. With the projected path and intensity, GRANT has no direct impact over Malawi.
', 1, '2026-01-06 19:28:00', 35), (15, 'UPDATE ON HEAVY RAINS WARNING EXPECTED OVER MOST AREAS FROM 07TH JANUARY TO 9TH JANUARY 2026.', 'Nkhotakota, Salima, parts of Mzimba, Chitipa, Nkhata Bay, Dowa Mchinji, Mulanje and Phalombe.', '2026-01-06', '260106075959_WhatsApp Image 2026-01-06 at 8.33.45 PM.jpeg', '260106075959_WhatsApp Image 2026-01-06 at 8.33.45 PM.jpeg', '
Date of issue: 6 January, 2026. Issue no: 2025/2026-3
\r\n

\r\n
The Department of Climate Change and Meteorological Services would like to update the nation on the heavy rainfall which is expected to affect lakeshore areas and several parts of the country due to the low-pressure system that is going to pass through the country. The adverse weather, characterized by intense downpours is expected to be accompanied by strong winds and frequent lightning.
\r\n
 
\r\n
  
\r\n

\r\n
Category 10 alerts are currently likely to affect Nkhotakota, Salima, parts of Mzimba, Chitipa, Nkhata Bay, Dowa Mchinji, Mulanje and Phalombe.
\r\n

\r\n
Category 6 covers most of northern, central areas and also Machinga, Mangochi, parts of Zomba, and Balaka while the remaining districts are under category 5 of warnings.
\r\n


', 1, '2026-01-06 19:59:59', 35), (16, 'HEAVY RAINS WARNING FROM 07TH JANUARY TO 9TH JANUARY 2026', 'Nkhotakota, Salima, parts of Mzimba, Kasungu, Nkhata Bay, Dowa Mchinji, and Ntchisi', '2026-01-07', '260106080200_101010101010.jpg', '260106080200_101010101010.jpg', '
\r\n
DCCMS is issuing a warning of heavy rainfall expected to affect lakeshore areas and several parts of the country. The adverse weather, characterized by intense downpours accompanied by strong winds and frequent lightning is likely impact Nkhotakota, Salima, parts of Mzimba, Kasungu, Nkhata Bay, Dowa Mchinji, and Ntchisi which are failing under category 10 alerts. Mzuzu, Likoma, Machinga, Mangochi, parts of Zomba, and Balaka which are under falling under category 6 while the remaining districts are under category 5 of warnings. These risky conditions are due to the low-pressure system which is in the Mozambique channel and currently enhancing Congo air mass but expected to pass through Malawi on Wednesday.
\r\n
\r\n
\r\n
DCCMS wishes also to inform Malawians that the Tropical Storm GRANT which was coming from Australia side has now weakened and is moving towards Madagascar. With the projected path and intensity, GRANT has no direct impact over Malawi.
\r\n
\r\n\r\n


', 0, '2026-01-06 20:02:00', 34); -- -------------------------------------------------------- -- -- Table structure for table `faqs` -- CREATE TABLE `faqs` ( `faq_id` int(11) NOT NULL, `question` text NOT NULL, `answer` text NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `faqs` -- INSERT INTO `faqs` (`faq_id`, `question`, `answer`, `date`) VALUES (8, 'WHAT IS A COOPERATIVE SOCIETY?', 'A cooperative is an autonomous association of persons united voluntarily to meet their common economic and social needs through a jointly-owned and democratically-controlled enterprise/business.', '2023-08-22 05:38:33'), (9, 'WHAT ARE THE COOPERATIVE PRINCIPLES?', 'Voluntary and Open Membership Democratic Member Control Member Economic Participation Autonomy and Independence Education, Training and Information Cooperation amongst Cooperatives Concern for Community', '2023-08-22 05:39:11'), (10, 'WHAT IS A SACCO', 'A Savings and Credit Cooperative Society (SACCO) is a member-owned financial cooperative whose primary objective is to mobilise savings and afford members access to loans (productive and provident) on competitive terms as a way of enhancing their socio-economic well being. It is formed by people having a common bond.', '2023-08-22 05:39:35'), (13, 'HOW DIFFERENT IS A SACCO FROM OTHER BANKS OR MICROFINANCE INSTITUTIONS?', 'SACCOs are member-owned and not profit-oriented. Their philosophy is “people helping people”.', '2023-08-22 05:40:59'), (14, 'WHAT ARE THE BENEFITS OF KEEPING MONEY IN A SACCO?', 'Members have a voice in the running of the SACCO since they own the institution; Members receive dividends at the end of the financial year; Access to financial services is non-discriminatory and affordable Contribution to a positive community', '2023-08-22 05:41:34'), (15, 'HOW SAFE IS ONE'S MONEY IN A SACCO?', 'The SACCO mechanism provides for the safety of members’ money i.e. controls and procedures, committees and reporting structures all provide for the safety of the members’ money.', '2023-08-22 05:41:59'), (16, 'WHERE CAN I FIND A SACCO NEAR ME?', 'Please see our list of affiliated SACCOs and our SACCO map. If you want to form a SACCO see Contacts.', '2023-08-22 05:42:27'), (17, 'WHAT IS A COMMON BOND', 'A common bond is a unifying factor (that which brings people together). Two types of bonds generally exist as follows: Community bond The bond exists where members are resident in a particular locality or neighbourhood. A community bond caters to all people within the community. Occupational or associational bond The bond provides for people of the same occupation or for those employed by a common employer or who belongs to the same profession. *Open Bond SACCOs can be comprised of both Community and Occupational Bonds.', '2023-08-22 05:44:24'), (18, 'WHO CAN JOIN A SACCO', 'Joining a SACCO is easy. Membership is open to all regardless of sex, race, religion or political affiliation. It is voluntary within the SACCO’s common bond. Each SACCO has a membership qualification process, common ones being that you are a member of a particular grouping or company, e.g. if you are a teacher or an employee of a particular organization, or if you belong to a certain community. Everyone from a Farmer to a CEO is able to join a SACCO!', '2023-08-27 12:31:37'); -- -------------------------------------------------------- -- -- Table structure for table `inquiries` -- CREATE TABLE `inquiries` ( `id` int(11) NOT NULL, `link` varchar(60) NOT NULL, `name` varchar(128) NOT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(32) DEFAULT NULL, `subject` text NOT NULL, `message` text NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp(), `status` int(11) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `inquiries` -- INSERT INTO `inquiries` (`id`, `link`, `name`, `email`, `phone`, `subject`, `message`, `date`, `status`) VALUES (21, 'gvcQQzPiFOqypJ', 'Wezzie Mhango', 'wezmhango@hotmail.com', '0991603780', 'Information Inquiry', 'rree', '2023-07-25 12:31:23', 0), (22, 'kzIzJp3KigK57v', 'Dan Imfa', 'bandaowen89@gmail.com', '099882297414', 'system issue', 'How can i join Sacco', '2023-08-21 23:55:20', 0); -- -------------------------------------------------------- -- -- Table structure for table `job_categories` -- CREATE TABLE `job_categories` ( `category_id` int(11) NOT NULL, `category` varchar(128) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `job_categories` -- INSERT INTO `job_categories` (`category_id`, `category`) VALUES (1, 'Full Time'), (2, 'Part Time'), (3, 'Temporary'), (4, 'Internship'), (5, 'Volunteer'); -- -------------------------------------------------------- -- -- Table structure for table `leadership` -- CREATE TABLE `leadership` ( `leader_id` int(11) NOT NULL, `title` varchar(128) NOT NULL, `name` varchar(64) NOT NULL, `type` varchar(32) NOT NULL, `image` varchar(128) NOT NULL, `facebook` varchar(1028) DEFAULT NULL, `twitter` varchar(1028) DEFAULT NULL, `linkedin` varchar(1028) DEFAULT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `leadership` -- INSERT INTO `leadership` (`leader_id`, `title`, `name`, `type`, `image`, `facebook`, `twitter`, `linkedin`, `date`) VALUES (24, 'Chief Executive Officer ', 'Fumbani Nyangulu', 'Management', '1691651634_Fumbani Nyangulu.jpg', 'https://www.facebook.com/ ', 'https://twitter.com/', 'https://www.linkedin.com/', '2023-08-10 07:13:54'), (25, 'Head of Cooperatives Development & Projects', 'Leroy Banda', 'Management', '1691680208_LEROY BANDA .jpg', 'https://www.facebook.com/ ', 'https://twitter.com/?lang=en', 'https://www.linkedin.com/', '2023-08-10 15:10:08'), (27, 'IT Manager', 'Daniel Imfa', 'Management', '1692359518_Daniel Imfa .jpg', 'https://www.facebook.com/ ', 'https://twitter.com/?lang=en', 'https://www.instagram.com/', '2023-08-18 11:51:58'), (28, 'Business Development Manager', 'Ezikiel Thindwa', 'Management', '1692359743_Ezikiel Thindwa.jpg', 'https://www.facebook.com/ ', 'https://twitter.com/?lang=en', 'https://www.linkedin.com/', '2023-08-18 11:55:43'), (29, 'Finance Manager', 'Rose Chalendewa', 'Management', '1692359809_Rose Chalendewa.jpg', 'https://www.facebook.com/ ', 'https://twitter.com/?lang=en', 'https://www.linkedin.com/', '2023-08-18 11:56:49'), (31, 'Board President ', 'Alex Ntungama', 'Board Member', '1732872389_Alex Ntungama.JPG', 'https://www.facebook.com/ ', 'https://twitter.com/', 'https://www.linkedin.com/', '2023-08-22 03:33:51'), (41, 'Head of Finance and Administration', 'Kingsley Mulewa', 'Management', '1733808384_Kingsley Mulewa.jpg', '', '', '', '2024-12-10 05:26:24'), (42, 'Board Vice President', 'Mrs. Jessie Eneya', 'Board Member', '1733811601_Mrs. Jessie Eneya.jpg', '', '', '', '2024-12-10 06:20:01'), (43, 'Board Treasurer', 'Col. Alinine Simwaka', 'Board Member', '1733812553_Col. Alinine Simwaka.jpg', '', '', '', '2024-12-10 06:35:53'), (44, 'Board Secretary', 'His Worship Mphalulo Fatch', 'Board Member', '1733812668_His Worship Mphalulo Fatch.jpg', '', '', '', '2024-12-10 06:37:48'), (45, 'Board Member', 'Mrs. Slyvia Chisama', 'Board Member', '1733812728_Mrs. Slyvia Chisama .jpg', '', '', '', '2024-12-10 06:38:48'), (46, 'Technical Director', 'Mr. Zamdziko Makhambo', 'Board Member', '1733812771_Mr. Zamdziko Makhambo.jpg', '', '', '', '2024-12-10 06:39:31'), (47, 'Technical Director', 'Mr. Makwemba Malonje', 'Board Member', '1733812800_Mr. Makwemba Malonje.jpg', '', '', '', '2024-12-10 06:40:00'), (48, 'Technical Director', 'Mrs. Zaithwa Phambana', 'Board Member', '1733812844_Mrs. Zaithwa Phambana.jpg', '', '', '', '2024-12-10 06:40:44'), (49, 'Registrar Of Cooperatives ', 'Mr. Limbikani Kachiwaya', 'Board Member', '1733812885_Mr. Limbikani Kachiwaya.jpg', '', '', '', '2024-12-10 06:41:25'); -- -------------------------------------------------------- -- -- Table structure for table `newsletters` -- CREATE TABLE `newsletters` ( `newsletter_id` int(11) NOT NULL, `title` varchar(1024) NOT NULL, `file` varchar(128) NOT NULL, `link` varchar(60) NOT NULL, `posted_by` int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `newsletters` -- INSERT INTO `newsletters` (`newsletter_id`, `title`, `file`, `link`, `posted_by`, `date`) VALUES (87, 'The Disaster Preparedness and Relief Act 1991 ', '250430120455_The Disaster Preparedness and Relief Act 1991 .pdf', '4wpwBBUwLx50Cf3h', 35, '2025-04-30 12:04:55'), (88, 'MALAWI NATIONAL DRR FRAMEWORK (2010-2015)', '250430120750_MALAWI NATIONAL DRR FRAMEWORK (2010-2015).pdf', 'SjZmJRHUlauplux7pAR0hmIJ81', 35, '2025-04-30 12:07:50'), (89, 'Climate Change and Disaster Risk Management Advocacy Strategy (2012-2015)', '250430120840_Climate Change and Disaster Risk Management Advocacy Strategy (2012-2015).pdf', 'K0uecjPpZjgsIZIvEzp', 35, '2025-04-30 12:08:40'), (90, 'Climate Change Policy and Legal Framework in Malawi- Towards a Comprehensive Policy Framework', '250430120933_Climate Change Policy and Legal Framework in Malawi- Towards a Comprehensive Policy Framework.pdf', 'eBaviCw1g6z4LWiAs21m3mwILBJC0XZIEyJU9pq5X5KR0fhdffmd4vURLUJa', 35, '2025-04-30 12:09:33'), (91, 'National ClimateChange Investment Plan (2013-18)', '250430121102_National ClimateChange Investment Plan (2013-18).pdf', 'PMmMKR9ZRbbQZMPNgMgIbwx3lQ1UcVggAlmY45', 35, '2025-04-30 12:11:02'), (92, 'National Disaster Risk Management Communication Strategy 2014-2018', '250430121136_National Disaster Risk Management Communication Strategy 2014-2018.pdf', 'pJZrJMab5F5k9nWAy3LnmE4iiKUQxg8h6FZLZSvE3lsMU10SGpsGvI', 35, '2025-04-30 12:11:36'), (93, 'Malawi National Disaster Recovery Framework ', '250430121521_Malawi National Disaster Recovery Framework .pdf', 'p8Z6ZCH1WaCOwewsw6tiJqzG1KRYsGfOZhP', 35, '2025-04-30 12:15:21'), (94, 'Malawi DRM Policy 2015', '250430121546_Malawi DRM Policy 2015.pdf', 'Cg8uKlR8RsNBFZngIhGGrQL57YZjY77Kya0EitFMbKLnVTnhJ', 35, '2025-04-30 12:15:46'), (95, 'Devolution Plan-DoDMA 2016', '250430121627_Devolution Plan-DoDMA 2016.pdf', '0AoFJjMj0XIbMg5ZgAMHorsjkVz2Df9QTs', 35, '2025-04-30 12:16:27'), (96, 'Malawi Food Insecurity Response Plan FIRP (2016-2017)', '250430121706_Malawi Food Insecurity Response Plan FIRP (2016-2017).pdf', 'oKWkubT', 35, '2025-04-30 12:17:06'), (97, 'National Climate Change Management Policy 2016', '250430121755_National Climate Change Management Policy 2016.pdf', 'sh9KiucY3sYFnRCh1', 35, '2025-04-30 12:17:55'), (98, 'National Disaster Recovery Framework. Volume 2-Drought(2017)', '250430121952_National Disaster Recovery Framework. Volume 2-Drought(2017).pdf', 'zQWS60rYMNI511cD7qVVGClSDfO4JuARej37iCymaqza0oZi5wN45', 35, '2025-04-30 12:19:52'), (99, 'National Training Manual on DRM', '250430122151_National Training Manual on DRM.pdf', 'DWvaMunDEW1ckOdUTuY0wyEsUpgdQWUej2tg531Sbo', 35, '2025-04-30 12:21:51'), (100, 'National Guidelines for Community Based Early Warning Systems', '250430122243_National Guidelines for Community Based Early Warning Systems.pdf', 'Fw3MhwvU8hUmXK7zSs3HoHEdjiUbiR9QU85a4ht8ayvSgoZpM', 35, '2025-04-30 12:22:43'), (101, 'National Disaster Risk Management Communication Strategy 2019-2022', '250430122320_National Disaster Risk Management Communication Strategy 2019-2022.pdf', 'MP4QKUh21FjFLX9XG8AxsmtUeWSONkGrsA6UHxN5MUV9ZDQ1', 35, '2025-04-30 12:23:20'), (102, 'National Resilience Strategy (2018-2030)', '250430122445_National Resilience Strategy (2018-2030).pdf', 'bUbhsyl5IrdYtORwJAmWHEQcfTkw7HtR4FHUKEYlqlq', 35, '2025-04-30 12:24:45'), (103, 'DRM Bill, 2019', '250430122525_DRM Bill, 2019.pdf', 'nMeINKF1qJRPZco8hydpQJPMMlwiacwOWVr', 35, '2025-04-30 12:25:25'), (104, 'Disaster Risk Financing Strategy 2019-2024', '250430122545_Disaster Risk Financing Strategy 2019-2024.pdf', '2hnsQACKBjXJ', 35, '2025-04-30 12:25:45'), (105, '2019 Flood Response Plan and Appeal', '250430123101_2019 Flood Response Plan and Appeal.pdf', 'k6sXlK', 35, '2025-04-30 12:31:01'), (106, 'Development of Malawi’s Disaster Risk Management Act 2023', '250430123346_Development of Malawi’s Disaster Risk Management Act 2023.pdf', '1mIbawSlxJ8vik7946NVRUCMFE', 35, '2025-04-30 12:33:46'), (107, 'Tropical Cyclone Freddy Response (2023)', '250430123439_Tropical Cyclone Freddy Response (2023).pdf', 'mLGeEGzx5CWK8kxQzHdfjKjyf', 35, '2025-04-30 12:34:39'), (108, 'The national multihazard contingency plan (2023-2024)', '250430123517_The national multihazard contingency plan (2023-2024).pdf', 'cDciWbqZNUQP6gWMO1Cf5eb8FACZg', 35, '2025-04-30 12:35:17'), (109, 'Malawi Vision 2063', '250430123634_Malawi Vision 2063.pdf', '3WDhMtWmS', 35, '2025-04-30 12:36:34'); -- -------------------------------------------------------- -- -- Table structure for table `overall_projects` -- CREATE TABLE `overall_projects` ( `newsletter_id` int(11) NOT NULL, `title` varchar(1024) NOT NULL, `district` varchar(30) NOT NULL, `file` varchar(128) NOT NULL, `link` varchar(60) NOT NULL, `posted_by` int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `overall_projects` -- INSERT INTO `overall_projects` (`newsletter_id`, `title`, `district`, `file`, `link`, `posted_by`, `date`) VALUES (66, 'Malawi Contigency Emergency Response Project (CERP)', 'national', '250423124044_Malawi Contigency Emergency Response Project (CERP).pdf', 'O4KgeblK5XsNYNm17Uy7N3K7tgXe2A', 34, '2025-04-23 12:40:44'), (67, 'Misuku Hills Improved Livelihood and Biodervity Conservation Project summary report', 'chitipa', '250424082250_Misuku Hills Improved Livelihood and Biodervity Conservation Project summary report.pdf', 'dcFS323', 34, '2025-04-24 08:22:50'), (68, 'PRIDE Irrigation Schemes Project', 'national', '250424082651_PRIDE Irrigation Schemes Project.pdf', 'JAaDHQ3yda4dIjzv5LZSf5TYBudI', 34, '2025-04-24 08:26:51'), (69, 'PRIDE Irrigation Schemes Project', 'chitipa', '250424083815_PRIDE Irrigation Schemes Project.pdf', 'WYAR0tZXlGrKSOhpricJdi2wZflBfxuBtdjdQNmUKLLoAa0', 34, '2025-04-24 08:38:15'), (70, 'PRIDE Irrigation Schemes Project', 'karonga', '250424083937_PRIDE Irrigation Schemes Project.pdf', 'vJq0inxH9PqTRD3BSEaqBRrYNMkObkyCf0o66UKnkDHzAMiXV7sajUj1C', 34, '2025-04-24 08:39:37'), (71, 'PRIDE Irrigation Schemes Project', 'nkhatabay', '250424084005_PRIDE Irrigation Schemes Project.pdf', 'oJ6ZzRHFx9ychOHCD8wtBheIWi8Q7', 34, '2025-04-24 08:40:05'), (72, 'Dedza -TA Kachere Integrated Sustainable Water and Sanitation Project-Jan-Nov, 2010 Report', 'dedza', '250424085233_Dedza -TA Kachere Integrated Sustainable Water and Sanitation Project-Jan-Nov, 2010 Report.pdf', 'I1qMOwTEZ', 34, '2025-04-24 08:52:33'), (77, 'MALAWI WATER AND SANITATION PROJECT – 1', 'blantyre', '250425085147_MALAWI WATER AND SANITATION PROJECT – 1.pdf', 'B0HKM3v6tu2oMzt4Ap4o2r5EfabCXchmtmyt', 35, '2025-04-25 08:51:47'), (78, 'Disaster Risk Reduction and Response in Chikwawa, Malawi', 'chikwawa', '250425085500_Disaster Risk Reduction and Response in Chikwawa, Malawi.pdf', 'rHN0MCjzVH0Oqj', 35, '2025-04-25 08:55:00'), (79, 'DoDMA Intensifies Preparedness Interventions, Dredges Rivers In Lower Shire', 'nsanje', '250425090121_DoDMA Intensifies Preparedness Interventions, Dredges Rivers In Lower Shire.pdf', 'nfSc0FbUTFGArKWXpw3wrBBVQOPN7xVPX1orv9sa', 35, '2025-04-25 09:01:21'), (80, 'Pamawa Project (2016)', 'machinga', '250425090540_Pamawa Project (2016).pdf', 'c82gamhGFPpQxZdWWdgjped31czhATWAP6EPzqiXLamiH', 35, '2025-04-25 09:05:40'), (82, 'Appraisal of the Karonga Rural Development Project-phase II', 'karonga', '250425090936_Appraisal of the Karonga Rural Development Project-phase II.pdf', 'ICAHxL0Isv5S1vJM7uMAdiBy1WM9j', 34, '2025-04-25 09:09:36'), (84, 'Climate Adaptation for Rural Livelihood and Agricuture(CARLA)', 'national', '250425092103_Climate Adaptation for Rural Livelihood and Agricuture(CARLA).pdf', 'vYihApWsedVI', 34, '2025-04-25 09:21:03'), (85, 'The Songwe River Basin Development Programme', 'karonga', '250425092429_The Songwe River Basin Development Programme.pdf', '6ZjqyBFm863WgbPbWPO139Sng', 34, '2025-04-25 09:24:29'), (86, 'Part II of the Mangochi Basic Services Programme (MBSP)', 'mangochi', '250425092738_Part II of the Mangochi Basic Services Programme (MBSP).pdf', 'lhed', 35, '2025-04-25 09:27:38'), (87, 'Climate Proofing Local Development Gains in Urban and Rural areas of Machinga and Mangochi; 2019 Annual Workplan', 'mangochi', '250425093607_Climate Proofing Local Development Gains in Urban and Rural areas of Machinga and Mangochi; 2019 Annual Workplan.pd', 'PC4UdsRRh1oD7', 35, '2025-04-25 09:36:07'), (89, 'Climate Resilience Initiative in Malawi (CRIM)', 'kasungu', '250425094232_Climate Resilience Initiative in Malawi (CRIM).pdf', 'W6yRhwSKsZvrQfmNCPvEjOUEHbQs', 34, '2025-04-25 09:42:32'), (90, 'Climate Resilience Initiative in Malawi (CRIM)', 'mzimba', '250425094317_Climate Resilience Initiative in Malawi (CRIM).pdf', 'f66PgqGFT4ZfeEdiktWWB05nbkf1H4O6D', 34, '2025-04-25 09:43:17'), (91, 'Social Support for Resilient Livelihoods Support (SSRLP).mw', 'national', '250425095054_Social Support for Resilient Livelihoods Support (SSRLP).mw.pdf', 'QDoav9HtuaJgS01408nCt', 34, '2025-04-25 09:50:54'), (92, 'Climate Proofing Local Development Gains in Rural and Urban Areas of Machinga and Mangochi Districts-Project Document (2014) ', 'mangochi', '250425095615_Climate Proofing Local Development Gains in Rural and Urban Areas of Machinga and Mangochi Districts-Project Docume', 'AXW4nsgDStRFGVseCOhKTIYfH540fehr2RPgI', 35, '2025-04-25 09:56:15'), (95, 'Management Response to Midterm Review of Climate Proofing Project', 'mangochi', '250425100737_Management Response to Midterm Review of Climate Proofing Project.pdf', 'lZ5EjMAnwFe7GAy3ZShVVAHzJluRpgArpDucw8GJjL8MpFtbYpfnPD3L4', 35, '2025-04-25 10:07:37'), (96, 'Ttukulane Program Q1 Report', 'mangochi', '250425100911_Ttukulane Program Q1 Report.pdf', 'z4h8ErcXorNPENyjEfykjRAssgRt0Y2iByYyheabLzuuK', 35, '2025-04-25 10:09:11'), (97, 'Lilongwe water and saninitation project', 'lilongwe', '250425101010_Lilongwe water and saninitation project.pdf', '4O3j2dRUCypBtdH2lwOV6LEUT5g', 34, '2025-04-25 10:10:10'), (98, 'Titukulane Project', 'mangochi', '250425101033_Titukulane Project.pdf', 'bzEytGH7iW2', 35, '2025-04-25 10:10:33'), (99, 'Titukulane Baseline Study Malawi Vol. I', 'mangochi', '250425101233_Titukulane Baseline Study Malawi Vol. I.pdf', 'uyPKW5H9MFeJ9yZ', 35, '2025-04-25 10:12:33'), (100, 'Titukulane Baseline Study Malawi Vol. II', 'mangochi', '250425101336_Titukulane Baseline Study Malawi Vol. II.pdf', 'sF7icy', 35, '2025-04-25 10:13:36'), (102, 'Climate Proofing Local Development Gains in Rural and Urban Areas of Machinga and Mangochi Districts-Project Document (2014) ', 'machinga', '250425101737_Climate Proofing Local Development Gains in Rural and Urban Areas of Machinga and Mangochi Districts-Project Docume', 'ZotAhaTkM', 35, '2025-04-25 10:17:37'), (103, 'Management Response to Midterm Review of Climate Proofing Project', 'machinga', '250425102403_Management Response to Midterm Review of Climate Proofing Project.pdf', 'KrRaMpPm8U', 35, '2025-04-25 10:24:03'), (104, 'MASAF Community Development Projects Handbook', 'national', '250425102424_MASAF Community Development Projects Handbook.pdf', '7Cr7eMriLxzcMNiBEvR1I01MUZD4L', 34, '2025-04-25 10:24:24'), (105, 'The Mwanalundu disaster risk reduction project', 'mwanza', '250425103839_The Mwanalundu disaster risk reduction project.pdf', '9akX1FQR6UHC2lZBSCKbf2VXjbzna9MP9eOS10ZPwUy6gqFj2SFv2ppL', 35, '2025-04-25 10:38:39'), (111, 'Titukulane Project', 'zomba', '250425105059_Titukulane Project.pdf', '63fZ0Ds4Il1FFZvf2b9nueVY1CcRXGvJ', 35, '2025-04-25 10:50:59'), (112, 'Ttukulane Program Q1 Report', 'zomba', '250425105146_Ttukulane Program Q1 Report.pdf', 'rnZMT5f63jAumSmB8Kr7rAt8XPWF4tfIdsPha5lbD', 35, '2025-04-25 10:51:46'), (113, 'Titukulane Baseline Study Malawi Vol. I', 'zomba', '250425105324_Titukulane Baseline Study Malawi Vol. I.pdf', 'EXsM4QTb7ivgvKeQm0PWH5P6cWPM', 35, '2025-04-25 10:53:24'), (115, 'Maintenance System Project', 'salima', '250425105620_Maintenance System Project.pdf', 'mb9BGtm', 34, '2025-04-25 10:56:20'), (116, 'Maintenance System Project', 'dowa', '250425105709_Maintenance System Project.pdf', 'TaCbeS1pe8fjbRYDiVu4Vg3clI93V65qIb9KpV5BnbBpTw2pZoC5H31q', 34, '2025-04-25 10:57:09'), (117, 'Maintenance System Project', 'kasungu', '250425105848_Maintenance System Project.pdf', 'hVQAJ1BkeICuiqaZZYsotPtkLjxM33qaBPdYo5yPTQ31HYU79mLYq0Mt', 34, '2025-04-25 10:58:48'), (118, 'Titukulane Baseline Study Malawi Vol. II', 'zomba', '250425110235_Titukulane Baseline Study Malawi Vol. II.pdf', 'TTEiDhaymppGTvIkHMqDAE6m6f1MW', 35, '2025-04-25 11:02:35'), (119, 'Malawi Agricultrual Commercialization Project', 'national', '250425110658_Malawi Agricultrual Commercialization Project.pdf', 'VGX1WR', 34, '2025-04-25 11:06:58'), (122, 'Integrated Water Supply and Sanitation for Ntchisi and Mzimba-Appraisal Report', 'mzimba', '250425115017_Integrated Water Supply and Sanitation for Ntchisi and Mzimba-Appraisal Report.pdf', 'sWJPrLQ9J19lhbNWo3TPJnxmXNHAHNkhywdxLPHtVEYmDAu', 34, '2025-04-25 11:50:17'), (123, 'Integrated Water Supply and Sanitation for Ntchisi and Mzimba-Appraisal Report', 'ntchisi', '250425115128_Integrated Water Supply and Sanitation for Ntchisi and Mzimba-Appraisal Report.pdf', 'fa6L9wnmZHMUIXPTnhrDbPF8VfDheWlv', 34, '2025-04-25 11:51:28'), (127, 'Nkhata Bay Town Water Supply and Sanitation- Appraisal Report', 'nkhatabay', '250425122801_Nkhata Bay Town Water Supply and Sanitation- Appraisal Report.pdf', '3jdsZxnYSNyzxFOlhEza4UCQFNkJqTFycmEDuRiDWm', 34, '2025-04-25 12:28:01'), (128, 'Effective Management of Mchinji Ecosystems for Restoration of Upper Bua River Catchment (2023)', 'mchinji', '250425123945_Effective Management of Mchinji Ecosystems for Restoration of Upper Bua River Catchment (2023).pdf', 'q7gUKpJOmpeo3btVqEcPrTPRLVV4cTMD4F9IUN3RW0kNOgcF', 35, '2025-04-25 12:39:45'), (131, 'Technical Assistance for Catchment-Based Climate Resilient Water Security in Northern Malawi (Nkhata Bay, Rumphi, and Chitipa)', 'chitipa', '250425124446_Technical Assistance for Catchment-Based Climate Resilient Water Security in Northern Malawi (Nkhata Bay, Rumphi, a', '0ij5kks5gF1GdzF3haHmKscVRVUT37ZV02D3i7t9vm0VQJTp', 34, '2025-04-25 12:44:46'), (132, 'The NkhataBay Cook Stove Project', 'nkhatabay', '250425010729_The NkhataBay Cook Stove Project.pdf', '1j8ucyPKyhEE3koUkDQ63KUAqtc1qxSLWvK1OFYkmld1', 34, '2025-04-25 13:07:29'), (133, 'Smart Climate Project', 'karonga', '250425011727_Smart Climate Project.pdf', 'bRVJNZ2IuzhdmBono90PG0TvOvDczzv140Q75', 34, '2025-04-25 13:17:27'), (134, 'Smart Climate Project', 'nkhotakota', '250425011815_Smart Climate Project.pdf', 'MEnAlvdxWjX26QVnbJbkf19p55bWDS', 34, '2025-04-25 13:18:15'), (135, 'Effective Management of Nkhotakota Wildlife Reserve Project', 'nkhotakota', '250425012247_Effective Management of Nkhotakota Wildlife Reserve Project.pdf', 'rhim6vFukHyvYOgWSMmyCvKYir', 34, '2025-04-25 13:22:47'), (139, 'Recent-and-ongoing-projects', 'mzimba', '250425014713_Recent-and-ongoing-projects.pdf', 'VWWo4Qoec0hD', 34, '2025-04-25 13:47:13'), (140, 'Water, Sanitation and Hygiene Promotion Project (1994)', 'ntchisi', '250425015351_Water, Sanitation and Hygiene Promotion Project (1994).pdf', 'vdU96Nu2etYO2IMZ91TlwQZHRQHfYNiTktpnWiqXI', 35, '2025-04-25 13:53:51'), (142, 'INTEGRATED RURAL WATER SUPPLY AND SANITATION PROJECT FOR NTCHISI AND MZIMBA DISTRICTS', 'ntchisi', '250425114954_INTEGRATED RURAL WATER SUPPLY AND SANITATION PROJECT FOR NTCHISI AND MZIMBA DISTRICTS.pdf', 'sjirwy0ECT', 35, '2025-04-25 23:49:54'), (144, 'the Malawi Livestock for Resilience (L4R) project', 'ntchisi', '250425115142_the Malawi Livestock for Resilience (L4R) project.pdf', 'TpqDI90iBvjhziSgDm1uuseM', 35, '2025-04-25 23:51:42'), (146, 'Karonga-Floods-Response-Malawi', 'karonga', '250513093112_Karonga-Floods-Response-Malawi.pdf', 'eYnRlkAyXAwJVronhBoq6bfcG8so0XXKgA4av9Gmw', 34, '2025-05-13 09:31:12'), (147, 'AFB.PPRC_.35.Inf_.35.-Proposal-for-Malawi-Mozambique-Zimbabwe', 'national', '251109092312_AFB.PPRC_.35.Inf_.35.-Proposal-for-Malawi-Mozambique-Zimbabwe.pdf', 'rdZYepWbiS3GcKUl4ZjaisaVBPbYssiYa', 34, '2025-11-09 21:23:12'), (148, 'AFB.PPRC_.33.Inf_.12-Proposal-for-Malawi', 'national', '251109092424_AFB.PPRC_.33.Inf_.12-Proposal-for-Malawi.pdf', 'ClTssQtY1R1bZQycizzG079keaYoYtd711b0OmvP3UF75SP1j', 34, '2025-11-09 21:24:24'); -- -------------------------------------------------------- -- -- Table structure for table `projects` -- CREATE TABLE `projects` ( `project_id` int(11) NOT NULL, `title` text NOT NULL, `details` text NOT NULL, `posted_by` varchar(60) NOT NULL, `thumb` varchar(128) NOT NULL, `image` varchar(128) NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `active` int(11) NOT NULL DEFAULT 0, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `projects` -- INSERT INTO `projects` (`project_id`, `title`, `details`, `posted_by`, `thumb`, `image`, `status`, `active`, `date`) VALUES (17, 'Enhanced Aggregation and Market Linkages among Smallholder Poultry Farmers', '

Malawi Union of Savings and Credit Cooperatives (MUSCCO) and The Commercial Agriculture for Smallholders and Agribusiness (CASA) partnered to implement an Enhanced Aggregation and\r\nMarket Linkages among Smallholder Poultry Farmers Project in Mzimba, Mchinji and Lilongwe.\r\n

\r\n

\r\n The project is expected to increase incentives for the poultry marketing system to improve performance, and trade, and ultimately economic returns for smallholder poultry famers and agribusinesses.

\r\n

This will be achieved through interventions in improved aggregation services among poultry groups, self-financing among poultry producers and linkages to stable markets.\r\n\r\n\r\n

\r\n\r\n


', '23', '1692649100_OWENB.jpg', '1692649100_Untit.jpg', 1, 0, '2023-08-21 20:18:20'), (18, 'Community Economic Participation Enhancement Support to Farmers, Farmer Organizations and Trade Associations', '

Malawi Union of Savings and Credit Cooperatives (MUSCCO) is partnering with We Effect with financial support from Swedish International Development Cooperation Agency (SIDA) to implement a project called community economic participation enhancement support to farmers, farmer organizations and trade associations across the country aimed at addressing challenges of lack access to financial services and weak farmer organizations that limit productivity as well as adaptation of rural communities to impacts of climate change resulting into farming as a non-commercial undertaking across.\r\n\r\n

', '23', '1692649259_OWENB.jpg', '1692649259_servi.jpg', 1, 0, '2023-08-21 20:20:59'), (19, 'Promotion of Agricultural Finance for agri-based Enterprises in Rural Areas partners', '

Malawi Union of Savings and Credit Cooperatives (MUSCCO) partnered with GIZ to implement a project called Promotion of agricultural finance for Agri based enterprises in rural areas in Mchinji, Lilongwe and Dowa districts aimed at contributing to improving formal agricultural financing by Savings and Credit Cooperatives Societies (SACCOs) to farmers and agri-based enterprises in rural areas in the country.\r\n\r\n\r\n

', '23', '1692650013_OWENB.jpg', '1692650013_servi.jpg', 1, 0, '2023-08-21 20:33:33'); -- -------------------------------------------------------- -- -- Table structure for table `publications` -- CREATE TABLE `publications` ( `publication_id` int(11) NOT NULL, `title` varchar(1024) NOT NULL, `file` varchar(128) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp(), `link` varchar(60) NOT NULL, `posted_by` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `publications` -- INSERT INTO `publications` (`publication_id`, `title`, `file`, `date`, `link`, `posted_by`) VALUES (87, 'Mzuzu University Biogas Strategic Energy Project', '250430080203_Mzuzu University Biogas Strategic Energy Project.pdf', '2025-04-30 08:02:03', '8tT7Pk3rjg8iy', 34), (88, 'Flood Vulnerability Assessment in Rural and Urban Informal Settlements- Case Study of Karonga Districts and Lilongwe City', '250430080344_Flood Vulnerability Assessment in Rural and Urban Informal Settlements- Case Study of Karonga Districts and Lilongw', '2025-04-30 08:03:44', 'RD4HbspCn4OkjJkidLmhlxx7KlidbJsjYRHBudUw5', 34), (89, 'COMDEKS Project Tukombo-Kande Region-IPSI Case Study Summary Sheet', '250430080514_COMDEKS Project Tukombo-Kande Region-IPSI Case Study Summary Sheet.pdf', '2025-04-30 08:05:14', 'eTD4aDJHZnQOGdwiWQgH1PDTrrCWbutr', 34), (90, 'Climate and mobility case study (Chikwawa) January 2023', '250430020233_Climate and mobility case study (Chikwawa) January 2023.pdf', '2025-04-30 14:02:33', '9hwnvVJOeBk05fzo', 35), (91, 'Malawi Transforming Disaster Response', '250430020539_Malawi Transforming Disaster Response.pdf', '2025-04-30 14:05:39', 'BTxZod53V0LLDoPDRGZZSWO6kI3ycbG5XX57UO9IHGX1JKR151QODXlgOFi', 35), (92, 'Developments of the Nationwide Earthquake Early Warning System in Japan After the 2011 Mw9.0 Tohoku-Oki Earthquake', '251123071513_Developments of the Nationwide Earthquake Early Warning System in Japan After the 2011 Mw9.0 Tohoku-Oki Earthquake.', '2025-11-23 19:15:13', 'ANF6T', 35), (93, 'Learning from Megadisasters; Lessons from the Great East Japan Earthquake', '251123071900_Learning from Megadisasters; Lessons from the Great East Japan Earthquake.pdf', '2025-11-23 19:19:00', 'Y216SuoNuNTpdTZgK7dYX', 35), (94, 'Lessons Learned from the 2011 Tohoku Tsunami', '251123072149_Lessons Learned from the 2011 Tohoku Tsunami.pdf', '2025-11-23 19:21:49', 'KG1rEVWaoGCElfVoh5bDZclZYx0he', 35), (95, 'Adaptive Social Protection and Disaster Risk Management: A Case Study of Japan', '251123072244_Adaptive Social Protection and Disaster Risk Management: A Case Study of Japan.pdf', '2025-11-23 19:22:44', 'w7DbYMdy5jS5VTWEzy0I52UyFBzuUr2HiXNPuZsO4sL1fpyNhctPQ1yc80n', 35); -- -------------------------------------------------------- -- -- Table structure for table `regions` -- CREATE TABLE `regions` ( `region_id` int(11) NOT NULL, `region_name` varchar(128) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `regions` -- INSERT INTO `regions` (`region_id`, `region_name`) VALUES (1, 'Southern Region (Chapter 1)'), (2, 'Central Region (Chapter 2)'), (3, 'Northern Region (Chapter 3)'); -- -------------------------------------------------------- -- -- Table structure for table `report` -- CREATE TABLE `report` ( `report_id` int(11) NOT NULL, `title` varchar(128) NOT NULL, `file` varchar(128) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `report` -- INSERT INTO `report` (`report_id`, `title`, `file`, `date`) VALUES (27, 'Yokohama Strategy and Plan of Action for Safer World', '250429082314_Yokohama Strategy and Plan of Action for Safer World.pdf', '2025-04-29 08:23:14'), (30, 'AFRICA Disaster Risk Disaster Risk Reduction, Reduction, Governance Governance and Development', '250429082836_AFRICA Disaster Risk Disaster Risk Reduction, Reduction, Governance Governance and Development.pdf', '2025-04-29 08:28:36'), (31, 'Hyogo Framework for Action (2005-2015)', '250429083005_Hyogo Framework for Action (2005-2015).pdf', '2025-04-29 08:30:05'), (32, 'Sendai Framework for Disaster Risk Reduction. 2015-2030', '250429083041_Sendai Framework for Disaster Risk Reduction. 2015-2030.pdf', '2025-04-29 08:30:41'), (33, 'The 2030 Agenda For Sustainable Development', '250429083116_The 2030 Agenda For Sustainable Development.pdf', '2025-04-29 08:31:16'), (34, 'Sustainable Development Goals (SDGs)', '250429083139_Sustainable Development Goals (SDGs).pdf', '2025-04-29 08:31:39'); -- -------------------------------------------------------- -- -- Table structure for table `resources` -- CREATE TABLE `resources` ( `resource_id` int(11) NOT NULL, `resource_title` varchar(128) NOT NULL, `resource_file` varchar(128) NOT NULL, `posted_date` timestamp NOT NULL DEFAULT current_timestamp(), `link` varchar(60) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `resources` -- INSERT INTO `resources` (`resource_id`, `resource_title`, `resource_file`, `posted_date`, `link`) VALUES (113, 'Malawi Food and Security Assessment Report August 2003', '250429093059_Malawi Food and Security Assessment Report August 2003.pdf', '2025-04-29 09:30:59', 'P4K39M8zCpOaCiQ9YIhEnZ2iR6gbnOL'), (114, 'FAO-WFP Crop and Food Supply Assessment Mission to Malawi Special Report-2004', '250429093315_FAO-WFP Crop and Food Supply Assessment Mission to Malawi Special Report-2004.pdf', '2025-04-29 09:33:16', '7mfPOMppVObVnEaknAbs3oGKnOhQT8U5Y3Gn5j6AyEIkB4CRhjiWasjDV'), (115, 'Malawi Food Security Monitoring Report-May 2004', '250429093642_Malawi Food Security Monitoring Report-May 2004.pdf', '2025-04-29 09:36:42', 'uB9du9db7sgKu'), (116, 'Malawi Food Security Update Report November 2005', '250429093817_Malawi Food Security Update Report November 2005.pdf', '2025-04-29 09:38:17', 'TcEfPbJAWwHOJVUb2FJ0K9Wh0Zy8wL7xJe7'), (117, 'Malawi Community and Household Surveillance CHS October 2007', '250429093940_Malawi Community and Household Surveillance CHS October 2007.pdf', '2025-04-29 09:39:40', 'feXTrVXOMXc1uVhMF'), (118, 'Situation Analysis of Disaster Risk Management Programmes and Practices Final Report. Malawi Final Volume 1-Nov 2008', '250429100539_Situation Analysis of Disaster Risk Management Programmes and Practices Final Report. Malawi Final Volume 1-Nov 200', '2025-04-29 10:05:39', 'nAHAd5s9Kz2yY6ump'), (119, 'International Federation of Red Cross and Red Crescent Societies Annual Report 30-April 2010', '250429100711_International Federation of Red Cross and Red Crescent Societies Annual Report 30-April 2010.pdf', '2025-04-29 10:07:11', 'deZwSoVBaCaSA1Sg6VQHSdTnOmV8dpreO'), (120, 'Participatory Vulnerability Assessment (PVA) Consolidated Report- Dec 2011', '250429101245_Participatory Vulnerability Assessment (PVA) Consolidated Report- Dec 2011.pdf', '2025-04-29 10:12:45', 'dk9viBh70rw02JSkn1esD2kxTb2F73'), (121, 'DISCOVER Participatory Vulnerability and Capacity Assessment Report', '250429101402_DISCOVER Participatory Vulnerability and Capacity Assessment Report.pdf', '2025-04-29 10:14:02', 'rZj6fgfLjn3LxqIVaRdpkSuOzdy8XGHxhp4YKT'), (122, 'CEPA ECRP DISCOVER Advocacy Report - Year 2 Quarter 2-2013', '250429102032_CEPA ECRP DISCOVER Advocacy Report - Year 2 Quarter 2-2013.pdf', '2025-04-29 10:20:32', '5FC1d4OmJoiTySuLZLyuxyZZvsVUmvezGy3'), (123, 'DISCOVER Narrative Report - Year 2 Quarter 2', '250429102127_DISCOVER Narrative Report - Year 2 Quarter 2.pdf', '2025-04-29 10:21:27', 'GtFSz5XTdOpfFhloK6Lug5oXaqLRhstN92s0KWENy5SF'), (124, 'Malawi Vulnerability Assessment Committee Report_June-13 2013', '250429102237_Malawi Vulnerability Assessment Committee Report_June-13 2013.pdf', '2025-04-29 10:22:37', 'anoUpD4sB9F'), (125, 'Malawi Nutrition Rehabilitation Units NRUs Assessment Report September 2015', '250429102713_Malawi Nutrition Rehabilitation Units NRUs Assessment Report September 2015.pdf', '2025-04-29 10:27:13', 'myWav7zEqearEFDkyKFX9NVJ4F5h'), (126, 'UNDAC 2015 Floods Assessment Report-Feb 6 2015 ', '250429102951_UNDAC 2015 Floods Assessment Report-Feb 6 2015 .pdf', '2025-04-29 10:29:51', 'HROkTPIGicEvcUXCDmMznxyrtfTOcOtS2jtuI0NaUxB7voD2PKDk0fvv2'), (127, 'National progress report on the implementation of the Hyogo Framework for Action-March ', '250429103101_National progress report on the implementation of the Hyogo Framework for Action-March .pdf', '2025-04-29 10:31:01', 'G9o4HLfT5dA9MAp7kWTSYiHI'), (128, 'Malawi International Disaster Response Law Report Draft LR-2015', '250429103511_Malawi International Disaster Response Law Report Draft LR-2015.pdf', '2025-04-29 10:35:11', 'iy0QOyIFtbsKf51zjifHfS8bqYK7ZDJflusYjxwQ'), (129, 'Assessment report on mainstreaming and implementing disaster risk reduction measures in Malawi', '250429103652_Assessment report on mainstreaming and implementing disaster risk reduction measures in Malawi.pdf', '2025-04-29 10:36:52', 's6r0gNfNOyI8NzxVckHUmeuYaKEruERzx1fpf7zm'), (130, 'Assessment report on mainstreaming and implementing disaster risk reduction measures in Malawi', '250429103745_Assessment report on mainstreaming and implementing disaster risk reduction measures in Malawi.pdf', '2025-04-29 10:37:45', '2OKsGblTuxyOnt6tz1cpDSBuYdaJIxrC7aak4XG3e829KIwOy8H8'), (131, 'Malawi 2015 Floods Post Disaster Needs Assessment Report', '250429104032_Malawi 2015 Floods Post Disaster Needs Assessment Report.pdf', '2025-04-29 10:40:32', '4zmvuQE79X'), (132, 'Second quartery Progress Report on The Disaster Risk Management Programme Support-August 25 2016', '250429104244_Second quartery Progress Report on The Disaster Risk Management Programme Support-August 25 2016.pdf', '2025-04-29 10:42:44', 'pLrsOccV1YljH3'), (133, 'Malawi Drought 2015-2016 Post-Disaster Needs Assessment (PDNA)', '250429110924_Malawi Drought 2015-2016 Post-Disaster Needs Assessment (PDNA).pdf', '2025-04-29 11:09:24', 'Aca5ZY578Ly'), (134, 'Enhancing Communities’ Resilience Programme (ECRP) in Malawi-2017', '250429111303_Enhancing Communities’ Resilience Programme (ECRP) in Malawi-2017.pdf', '2025-04-29 11:13:03', 'cyavFy03XOCcbLFNl1Hx2sjTjDieWNA7VijxHK'), (135, 'Malawi Community Based Resilience Analysis (CoBRA) Assessment Report - Zomba, Nkhata Bay and Ntcheu_Final_May2017', '250429111631_Malawi Community Based Resilience Analysis (CoBRA) Assessment Report - Zomba, Nkhata Bay and Ntcheu_Final_May2017.p', '2025-04-29 11:16:31', '3SGpcKHaqbLvSe4PjsrDQzlp0hz8wNldL9C494WqDs'), (136, 'UNDP-Final Evaluation Report of the Disaster Risk Management Programme August 12 2017', '250429111906_UNDP-Final Evaluation Report of the Disaster Risk Management Programme August 12 2017.pdf', '2025-04-29 11:19:06', '8BTuGIhzxScAmruCjxaFQjhmER9CEwaycduyOpduGLODVc3jWxSYwi7KPKoa'), (137, 'DoDMA Capacity Assessment - Final Report- 2017', '250429112012_DoDMA Capacity Assessment - Final Report- 2017.pdf', '2025-04-29 11:20:12', 'R4XA0Kd8h0P7J8vkhJ5V79pNjzTcEfNoccvTu0ZRMDAZ'), (142, 'UNICEF WFP Collaboration Emergency Nutrition Response-Nov 2018', '250429114534_UNICEF WFP Collaboration Emergency Nutrition Response-Nov 2018.pdf', '2025-04-29 11:45:34', 'acazxCzHR0pBNIzfPDJJd1kF5Di'), (143, 'Comprehensive Baseline Assessment of Disaster Risk Management in Malawi-2018', '250429114730_Comprehensive Baseline Assessment of Disaster Risk Management in Malawi-2018.pdf', '2025-04-29 11:47:30', 'JPUwiQ4uKUHMCQoMBJcoQ8TQMbw22MGqo7cMjvt8r5uwyo0Bgnx6'), (144, 'Chikwawa District Floods Situation report 11th March 2019', '250429114817_Chikwawa District Floods Situation report 11th March 2019.pdf', '2025-04-29 11:48:17', 'H406pS9K8sNcbOJcvyVmCPpqOcKDLvHjWhvWVedGL'), (145, 'Adaptation to Climate Change in the Nkhota-kota District of Malawi-April 2019', '250429114852_Adaptation to Climate Change in the Nkhota-kota District of Malawi-April 2019.pdf', '2025-04-29 11:48:52', 'O6Oiu0VprJkdYWZy9deYsZfZ677wJIxfAR5FDkRPTfa'), (146, 'Climate Change Adaptation Funding Mechanisms in Malawi Report-April 2019', '250429115003_Climate Change Adaptation Funding Mechanisms in Malawi Report-April 2019.pdf', '2025-04-29 11:50:03', 'V5SKWub5tLMLEv0ToG5fSMCHcaIeeztip7BChQRCgYKqvJx2OPHAieuFoG1V'), (147, 'IPC Integrated Food Security Phase Classification _August-2019', '250429115220_IPC Integrated Food Security Phase Classification _August-2019.pdf', '2025-04-29 11:52:20', 'qKmH0GRKpryOVrmsd4uVjOMo'), (148, 'Humanitarian Coordinator Report on the Use of Cerf Funds; Rapid Response Cyclone Idai- 2019', '250429115535_Humanitarian Coordinator Report on the Use of Cerf Funds; Rapid Response Cyclone Idai- 2019.pdf', '2025-04-29 11:55:35', '9MXuq36NTtb'), (150, 'Tropical Cyclone IDAI Multi-Sectral Location Assessment-Chikwawa, Nsanje, Phalombe, Zomba Districts-Round III-May-3 2019', '250429115915_Tropical Cyclone IDAI Multi-Sectral Location Assessment-Chikwawa, Nsanje, Phalombe, Zomba Districts-Round III-May-3', '2025-04-29 11:59:15', 'KMGGXdfQEKr73vIBOTtKPAbzO9S9aPdnu3T8MxWLwArpy'), (151, 'Malawi 2019 Floods Post Disaster Needs Assessment Report', '250429120027_Malawi 2019 Floods Post Disaster Needs Assessment Report.pdf', '2025-04-29 12:00:27', '4UpkxEFNho59jec185hneiQND'), (152, 'The Integrated Risk Management Programme. lessons from mw-June 2020', '250429120313_The Integrated Risk Management Programme. lessons from mw-June 2020.pdf', '2025-04-29 12:03:13', 'zRJXg4srFOv61YXTh2FAJSToKfNaRcOX'), (153, 'The impact of Cyclone Idai Final- 2020', '250429120412_The impact of Cyclone Idai Final- 2020.pdf', '2025-04-29 12:04:12', '8XUDa4DWtRfLvOJEICClDkE2jrK0F3Q5hT8SFk1Xip0LXkcE8iC'), (154, 'Malawi The Cost of Hunger Summary Report ', '250429120606_Malawi The Cost of Hunger Summary Report .pdf', '2025-04-29 12:06:06', 'WanQSmZPattf3MAmQlWJJ6jWOXAyeGC3gZozynlTfFVE'), (155, 'Evaluation of the project Strengthening Community Resilience to Climate Change in Blantyre, Zomba, Neno and Phalombe-2021', '250429121148_Evaluation of the project Strengthening Community Resilience to Climate Change in Blantyre, Zomba, Neno and Phalomb', '2025-04-29 12:11:48', 'zgiOieniksrDK3nrwessejjJaWUyO6wi65b2rdfo'), (156, 'An assessment of Malawi Media in Disaster Risk Reduction- The Case of Cyclone IDAI 2021', '250429121347_An assessment of Malawi Media in Disaster Risk Reduction- The Case of Cyclone IDAI 2021.pdf', '2025-04-29 12:13:47', 'jWrbZPZI1nRp2JxGAuE6v9vPJ'), (157, 'A Cost-Benefit Analysis of Environmental Management and Disaster Risk Reduction in Malawi - Technical Report 2021', '250429121429_A Cost-Benefit Analysis of Environmental Management and Disaster Risk Reduction in Malawi - Technical Report 2021.p', '2025-04-29 12:14:29', 'njSQYk7bql9'), (158, 'Malawi National Human Development Report 2021', '250429121613_Malawi National Human Development Report 2021.pdf', '2025-04-29 12:16:13', 'T6G8YpBc'), (159, 'UNICEF Malawi Emergency Response Situation Report 28 January 2022', '250429121950_UNICEF Malawi Emergency Response Situation Report 28 January 2022.pdf', '2025-04-29 12:19:50', 'jum6qzrpIzH8sxR9wD7jSls69KFaVvFfgQACUaRqH'), (160, 'Rapid Gender Analysis of Disaster Risk Management in Malawi-2022', '250429122123_Rapid Gender Analysis of Disaster Risk Management in Malawi-2022.pdf', '2025-04-29 12:21:23', '3cSYqhC0CwlpyWm1PZ6CHmtYJTedLO8s2IVs4uJFK'), (161, 'Consolidated Report CYCLONE ANA 2022. 2.1', '250429122321_Consolidated Report CYCLONE ANA 2022. 2.1.pdf', '2025-04-29 12:23:21', 'pU8PrdF4CiBkV3OBEgRgidH'), (162, 'Malawi 2022 Voluntary National Review Report for Sustainable Development Goals (SDGs)', '250429122806_Malawi 2022 Voluntary National Review Report for Sustainable Development Goals (SDGs).pdf', '2025-04-29 12:28:06', 'OJi5'), (163, 'Cyclone-Freddy-Mapping-Final-Report 2023', '250429122944_Cyclone-Freddy-Mapping-Final-Report 2023.pdf', '2025-04-29 12:29:44', 'JxKDxgqXUDlwOjF96A0P'), (164, 'Strengthening Smallholder Farmer Resilience, Responding to COVID-19 and Eliminating Food Poverty Impact Evaluation Report-', '250429123109_Strengthening Smallholder Farmer Resilience, Responding to COVID-19 and Eliminating Food Poverty Impact Evaluation ', '2025-04-29 12:31:09', 'p78jBIrcsO5gqH3i6PSq3lxnUyv7YF1g'), (165, 'UNICEF Malawi Humanitarian Situation Report No 1 Updates from 1 January to 15 March 2023', '250429123316_UNICEF Malawi Humanitarian Situation Report No 1 Updates from 1 January to 15 March 2023.pdf', '2025-04-29 12:33:16', '7KOy4h4xPRaTZ'), (166, 'IFRC Tropical Storm Ana Report 2023', '250429123442_IFRC Tropical Storm Ana Report 2023.pdf', '2025-04-29 12:34:42', 'rNYrx'), (167, 'Community-led Resource Mobilization and Early Warning Systems Process Assessment Report ', '250429123606_Community-led Resource Mobilization and Early Warning Systems Process Assessment Report .pdf', '2025-04-29 12:36:06', 'kEchjlZpIaPvLPgzcsk3YNFuMH8ORvFwOsa5RRqLMndHmoxZ77k1PgV'), (168, 'Economic Impacts of Climate Change.', '250429123710_Economic Impacts of Climate Change..pdf', '2025-04-29 12:37:10', '1YE5n3YrvJ'), (169, 'Malawi Climate and Health Vulnerability Assessment', '250429123930_Malawi Climate and Health Vulnerability Assessment.pdf', '2025-04-29 12:39:30', 'Na4S0MEIuV5czRpzLf24XLIzCLWPLqsarJ5'), (170, 'Malawi_ Tropical Cyclone Freddy Flash Update No. 1 16 March', '250429124018_Malawi_ Tropical Cyclone Freddy Flash Update No. 1 16 March.pdf', '2025-04-29 12:40:18', 'cnQw'), (171, 'Tropical Cyclone Freddy After Action Review Report 2023', '250429124621_Tropical Cyclone Freddy After Action Review Report 2023.pdf', '2025-04-29 12:46:21', 'nI3wbWLERlRsZOdv794oOcIXCFuhKoktucmKWmD9FiWk31gF1wEgbb'), (172, 'Tropical Cyclone Freedy Inter Agency Assessment Report_March-13 2023', '250429124739_Tropical Cyclone Freedy Inter Agency Assessment Report_March-13 2023.pdf', '2025-04-29 12:47:39', 'K1Z7gUPbLBqM8FSjf85HUvhF38ttmYne7FqmuXI9i4qCcofbYuESttsr9lVd'), (173, 'Tropical Cyclone Freddy Post Disaster Needs Assessment Government of Malawi', '250429124846_Tropical Cyclone Freddy Post Disaster Needs Assessment Government of Malawi.pdf', '2025-04-29 12:48:46', '47gdE0DBAslud7gdJ'), (174, 'MRC Multi-Sectoral Detailed Needs Assessment Report on Floods in Karonga District-Feb 2024', '250429125030_MRC Multi-Sectoral Detailed Needs Assessment Report on Floods in Karonga District-Feb 2024.pdf', '2025-04-29 12:50:30', 'lSBSB9QwIZPGxPaLoXuzN11KEZD'), (175, 'Malawi-El-Nino-Situation Report-May 2024', '250429125155_Malawi-El-Nino-Situation Report-May 2024.pdf', '2025-04-29 12:51:55', 'qhMZhPHaBSLIwAzuFSAd89iDr3RprRCIQ'), (176, 'Assessment Mechanisms for Supporting Loss and Damage Financing - 2024', '250429125409_Assessment Mechanisms for Supporting Loss and Damage Financing - 2024.pdf', '2025-04-29 12:54:09', 'bKw6p4ywLFSTyMzjZvnFqqKP8g'), (177, 'Emergency Preparedness and Response Roadmap 2023 to 2025 yr 1 Progress Report', '250429125520_Emergency Preparedness and Response Roadmap 2023 to 2025 yr 1 Progress Report.pdf', '2025-04-29 12:55:20', 'AagpB7493XJIONiPPUfLDbOB8'), (178, 'UNDRR Annual Report- 2024', '250429125630_UNDRR Annual Report- 2024.pdf', '2025-04-29 12:56:30', 'XMBXr079zMG4cozyRXV9xBEyOnf5ex2YK'), (181, 'Malawi Floods 2024 - DREF Final Report (MDRMW020)', '250513094558_Malawi Floods 2024 - DREF Final Report (MDRMW020).pdf', '2025-05-13 09:45:58', 'USwbt1eDUxD5QUUj6UDBsLNrahICWNJPLVlFmI'), (182, 'Baseline Assessment of Drought Impact Monitoring', '250527101132_Baseline Assessment of Drought Impact Monitoring.pdf', '2025-05-27 10:11:32', 'Bbt1c6dDCdzsYRdE'), (183, 'Tropical Cyclone Jude Situation Report-11_03_2025', '250617015933_Tropical Cyclone Jude Situation Report-11_03_2025.pdf', '2025-06-17 13:59:33', 'OI1lqjLsANHCivnWS74iclgb9BV67vLLoERQiCIA2nCSYDfhzacBoX4oIIa'), (184, 'UNICEF Malawi Humanitarian Situation Report No. 3, July - September 2025', '251109094020_UNICEF Malawi Humanitarian Situation Report No. 3, July - September 2025.pdf', '2025-11-09 21:40:20', 'j5Fn6qEosE6How8T32K087xtRDAFCeoJpXrKSN8'), (191, 'Final Evaluation of Adapting to Climate Change through Integrated Risk Management Strategies and Enhanced Market Opportunities f', '251109095628_Final Evaluation of Adapting to Climate Change through Integrated Risk Management Strategies and Enhanced Market Op', '2025-11-09 21:56:28', '0nP9EgeaYcs8IKZyT1UVgR8r72'), (192, 'Malawi AA National Dialogue Platform 2024 FINAL Report', '251109095711_Malawi AA National Dialogue Platform 2024 FINAL Report.pdf', '2025-11-09 21:57:11', 'l3nT7cWeVUOe3ef9NcykGoMwqYj6XA9YkLIX'), (193, 'WFP Malawi Country Brief - January 2025', '251109095730_WFP Malawi Country Brief - January 2025.pdf', '2025-11-09 21:57:30', 'k5b0D3YfYL6cJVMy6rnR'), (194, 'Malawi-Humanitarian-SitRep-No.1-01-January-31-March-2025.pdf', '251109095829_Malawi-Humanitarian-SitRep-No.1-01-January-31-March-2025.pdf.pdf', '2025-11-09 21:58:29', 'x5bG'), (195, 'Malawi Resilience and Disaster Risk Management Project Implementation Completion and Results Report 2025', '251109095912_Malawi Resilience and Disaster Risk Management Project Implementation Completion and Results Report 2025.pdf', '2025-11-09 21:59:12', 'uC2eZ1IKB7LEp8f5yX'), (196, 'Gap Analysis Report- Climate and Disaster Risk Finance in Malawi-2025', '251109095940_Gap Analysis Report- Climate and Disaster Risk Finance in Malawi-2025.pdf', '2025-11-09 21:59:40', 'RR3v1xjPZ82AMJibQ95skhPMI4TOI3WY0fOoHigWwooIIMD'), (197, 'UNICEF Malawi Humanitarian Situation Report No. 3, July - September 2025', '251109100121_UNICEF Malawi Humanitarian Situation Report No. 3, July - September 2025.pdf', '2025-11-09 22:01:21', 'Hw24hIMeVfMwkfeK8WFeZHeNpL'), (198, 'DREF 2025 Food Insecurity Report', '251109100219_DREF 2025 Food Insecurity Report.pdf', '2025-11-09 22:02:19', 'TVZ5uhz'), (199, 'World Risk Report (Floods)', '251123063840_World Risk Report (Floods).pdf', '2025-11-23 18:38:40', 'W3X1Zf6to1T9da3BCwDapScxRsEysMyfMpZNO'); -- -------------------------------------------------------- -- -- Table structure for table `saccos` -- CREATE TABLE `saccos` ( `sacco_id` int(11) NOT NULL, `sacco_name` varchar(128) NOT NULL, `region_id` int(11) NOT NULL, `location` varchar(128) NOT NULL, `address` varchar(1028) DEFAULT NULL, `phone` varchar(60) DEFAULT NULL, `email` varchar(60) DEFAULT NULL, `contact_person` varchar(60) NOT NULL, `url` varchar(128) DEFAULT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `saccos` -- INSERT INTO `saccos` (`sacco_id`, `sacco_name`, `region_id`, `location`, `address`, `phone`, `email`, `contact_person`, `url`, `date`) VALUES (23, 'YATHU SACCO', 1, 'Blantyre', 'P.O. Box 5052, Limbe', '0888860680', 'cmotomoto@yahoo.co.uk', 'Chrissie Motomoto', 'https://admarcsacco.com/', '2023-08-28 19:10:07'), (24, 'FUTURE SACCO', 1, 'Blantyre', 'P.O. Box 30548, Chichiri, Blantyre 3', '0888987790', 'tmindozo@futuresacco.com', 'Tendai Mindozo', 'http://www.futuresacco.com/', '2023-08-28 19:12:19'), (25, 'MUDI SACCO', 1, 'Chichiri', 'P.O. Box 31229, Chichiri, Blantyre 3', '0999920954/0111625354', 'tsigat@yahoo.com', 'Triza Magreta', 'http://www.mudisaccomw.com/', '2023-08-28 19:13:53'), (26, 'POLYMED SACCO', 1, 'Blantyre', 'P/B 303, Chichiri, Blantyre 3', '0999688710', 'mtbokosi@gmail.com', 'Mary Bokosi Musona', '', '2023-08-28 19:15:55'), (27, 'PCL GROUP SACCO', 1, 'Blantyre', 'P.O. Box 30402, Chichiri, Blantyre 3', '0882228419', 'info@pclgroupsacco.com', 'Brandy Bande', 'https://www.pclgroupsacco.com/', '2023-08-28 19:17:34'), (28, 'SUNBIRD SACCO', 1, 'Blantyre', 'P.O. Box 284, Blantyre', '01820804/ 0995105213', 'sharon@sunbirdsacco.com', 'Sharon Taona Kalea', 'http://sunbirdsacco.com/', '2023-08-28 19:39:15'), (29, 'Mphuzitsi SACCO', 1, 'Thyolo', 'P.O. Box 175, Thyolo', '+265888066900', 'Jptembo@thyoloteacherssacco.mw', 'James Tembo', '', '2023-08-28 19:41:26'), (34, 'CHILUNGAMO SACCO', 1, '-', '', '0999615677', 'pchimukho@gmail.com', 'Pilirani Chimukho', '', '2023-08-28 19:45:53'), (36, 'CHITUKUKO SACCO', 2, 'Lilongwe', 'P.O. Box 651, Lilongwe', '0999042232', 'eveness.mtowa@chitukukosacco.mw', 'Eveness Butawo Mtowa', 'http://www.chitukukosacco.com/', '2023-08-28 20:33:51'), (38, 'MZINDA SACCO', 2, 'Lilongwe', 'P.O. Box 30396, Lilongwe', '0888546399', 'amaznyale@yahoo.co.uk', 'Maxwel Nyale', '', '2023-08-28 21:13:26'), (39, 'KANDIYA SACCO', 2, 'Lilongwe', 'P/B 6, Lilongwe', '0997221980', 'pmwankenja@gmail.com', 'Paul Mwankenja', '', '2023-08-28 21:14:42'), (40, 'FODYA SACCO', 2, 'Lilongwe', 'P.O. Box 40048, Lilongwe', '888364205', 'loycechinangwa@gmail.com', 'Loyce Chinangwa', 'http://www.fodyasacco.com/', '2023-08-28 21:17:30'), (41, 'UN SACCO', 2, 'Lilongwe', 'P.O. Box 30135, Lilongwe', '+265888528873', 'jaymaluwa899@gmail.com', 'Jayne Maluwa', '', '2023-08-28 21:24:06'), (42, 'UMODZI SACCO', 2, 'Lilongwe', 'P.O. Box 709, Lilongwe', '0995500454', 'echinjala@yahoo.com', 'Eliza Chinjala', '', '2023-08-28 21:25:01'), (43, 'DWANGWA SACCO', 2, 'Dwangwa', 'P.O. Box 46, Dwangwa', '0999248724', 'trezamalata@broadbandmw.com', 'Treza Malata', '', '2023-08-28 21:25:58'), (44, 'TIPINDULE COMMUNITY SACCO', 2, 'Mponela', 'P.O. Box 131, Mponela', '0999314796', 'tipindulesacco@gmail.com', 'Atusaye Mwakhwawa', '', '2023-08-28 21:26:59'), (45, 'Dedza Teachers SACCO', 2, 'Lilongwe', 'P.O. Box 459, Lilongwe', '0995496135', 'jlonjezo@gmail.com', 'Lonjezo Josiah', '', '2023-08-28 21:27:47'), (46, 'Mchinji Civil Service SACCO', 2, 'Mchinji', '', '0999953992', 'manganimike@gmail.com', 'Michael Mangani', '', '2023-08-28 21:28:59'), (47, 'Kuwala SACCO', 2, 'Lilongwe', 'P.O. Box 40035, Lilongwe', '0888727318', 'gkandiona@yahoo.com', 'Grace Kandiwona', 'http://www.ahlsaccomw.com/', '2023-08-28 21:40:31'), (49, 'LIMBE LEAF SACCO', 2, '-', 'Christobel Mbeya 0882211491', '0882211491', 'info@lltcsacco.mw', 'Christobel Mbeya', '', '2023-08-28 21:44:00'), (50, 'POLICE SACCO', 2, 'Lilongwe', '', '0997245286', 'ianmwalungila@gmail.com', 'Ian Mwalungila', 'http://www.malawipolicesacco.com/', '2023-08-28 21:45:11'), (51, 'PLAN MALAWI SACCO', 2, 'Lilongwe', 'Jimmy Kanyangala', '0991656969', 'kanyangalaj@gmail.com', 'Jimmy Kanyangala', '', '2023-08-28 21:49:20'), (52, 'LUANAR SACCO', 2, 'Bunda, Lilongwe', 'Bunda, Lilongwe', '0999375014', 'vincentchinomba@gmail.com', 'Vincent Chinomba', '', '2023-08-28 21:50:21'), (53, 'KASUPE SACCO', 2, '-', '', '0882364515', 'kasupesacco@yahoo.com', 'Florence Mtika', '', '2023-08-28 21:51:32'), (54, 'M-UNITY SACCO', 2, 'Lilongwe', '', '0999922870', 'neema.kachali@yahoo.com', 'Neema Kachali', '', '2023-08-28 21:53:39'), (55, 'MSILIKALI SACCO', 2, 'Lilongwe', '', '0887099426', 'vtembo@msilikalisacco.org', 'Venge Tembo', 'http://msilikalisacco.org/', '2023-08-28 21:55:06'), (59, 'Rumphi Teachers SACCO', 3, 'Rumphi', 'P.O. Box 26, Rumphi', '0888571773', 'kumwendaulemu@yahoo.com', 'Ulemu Kumwenda', '', '2023-08-28 22:24:29'), (61, 'United Civil Servants SACCO', 3, 'Mzimba', 'P.O. Box 194, Mzimba', '0888544765', 'fwaliwa@gmail.com', 'Francis Waliwa', '', '2023-08-28 22:30:22'), (62, 'MZUZU UNIVERSITY SACCO', 3, 'Mzuzu', 'P.O. Box 2, Luwinga, Mzuzu', '0999667738/ 0888940696', 'kachondekathy@yahoo.com', 'Catherine Kachonde', '', '2023-08-28 22:31:24'), (63, 'Kawiruwiru SACCO', 3, 'Mzuzu', 'P/B 94, Mzuzu', '0888300444', 'kayangejoyce@yahoo.com', 'Joyce Kayange', '', '2023-08-28 22:32:50'), (66, 'SUCOMA SACCO', 1, 'Chikhwawa', 'Private Bag 50 Nchalo', '01425215/0888861133', 'sucomasacco@gmail.com', 'Malizani Gamaliel', '', '2023-11-15 14:07:00'), (72, 'KASO Sacco', 2, 'Lilongwe', 'P.O.Box 132 Lilongwe', '0997002288', 'mawangaprecious@gmail.com', 'Precious Mawanga', '', '2024-06-24 09:59:01'), (73, 'Chipatala Sacco', 2, 'Lilongwe', '', '0993040426', 'manenomzumala@gmail.com', 'Maneno Mzumara', '', '2024-06-24 10:00:10'), (74, 'Febco SACCO', 2, 'Lilongwe Old Town', '', '0993705679', '', 'Ethel Musopole', '', '2024-06-24 10:04:47'), (75, 'Light House Sacco', 2, 'Lilongwe Kamuzu Central Premises', '', '0993994445', 'mayendaj@gmail.com', 'Josephine Mayenda', '', '2024-06-24 10:06:07'), (76, 'UNC Sacco', 2, 'Lilongwe UNC Premises', '', '0992657413', 'mhangosolister56@gmail.com', 'Solicitor Mhango', '', '2024-06-24 10:07:08'), (77, 'Mwato Sacco', 3, 'Nkhatabay', '', '0888859089', 'bmzumara@gmail.com', 'Blessings mzumara', '', '2024-06-24 10:12:23'), (78, 'Fincoop SACCO', 2, 'Lilongwe', 'P.O.Box 651 Lilongwe', '0999395098', 'mnankhonya@fincoopmw.org', 'McMillan Nankhonya', 'https://www.fincoopmw.org', '2024-06-24 10:24:14'), (79, 'Solinica SACCO', 3, 'Mzuzu', '', '0999707472', '', 'Rev Vunda Mhango', '', '2024-06-24 10:34:37'); -- -------------------------------------------------------- -- -- Table structure for table `sacco_statistics` -- CREATE TABLE `sacco_statistics` ( `stat_id` int(11) NOT NULL, `title` varchar(1028) NOT NULL, `file` varchar(128) NOT NULL, `type` int(11) NOT NULL DEFAULT 1, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `sacco_statistics` -- INSERT INTO `sacco_statistics` (`stat_id`, `title`, `file`, `type`, `date`) VALUES (70, '30 Innovations for Disaster Risk Reduction', '250429064052_30 Innovations for Disaster Risk Reduction.pdf', 2, '2025-04-29 06:40:52'), (72, 'Status of Science and Technology in Disaster Risk Reduction in Asia Pacific 2024', '250429093736_Status of Science and Technology in Disaster Risk Reduction in Asia Pacific 2024.pdf', 2, '2025-04-29 09:37:36'), (73, 'Innovation in Disaster Management (UNDP , OCHA)', '250429093919_Innovation in Disaster Management (UNDP , OCHA).pdf', 2, '2025-04-29 09:39:19'); -- -------------------------------------------------------- -- -- Table structure for table `services` -- CREATE TABLE `services` ( `service_id` int(11) NOT NULL, `title` text NOT NULL, `details` longtext NOT NULL, `posted_by` varchar(60) NOT NULL, `image` varchar(128) NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `services` -- INSERT INTO `services` (`service_id`, `title`, `details`, `posted_by`, `image`, `status`, `date`) VALUES (19, 'Capacity Building ', '

CDI capacity building provision for solicited courses/sessions uses three consultations levels which are; Basic Technical Capacity Building, Technical Capacity Development, and Intensive Technical Capacity Development. Costs for such services are varied depending on customer needs. 

\r\n

General cooperatives and financial cooperatives specific training are delivered following a pre designed curriculum which clients can apply or request to delivered as inhouse or attending an arranged training session. Provision for online or virtual session are provided on need basis for this capacity building component.

\r\n\r\n


', '23', '1692639412_service.jpg', 1, '2023-08-21 17:36:52'), (20, 'Central Finance Facility', '

The purpose of the CFF is to provide the affiliate SACCOs with a liquidity management system and a source of short-term financing.  It also affords the affiliated SACCOs main banking facilities where they invest and borrow at a competitive rate of return.  The facility is also designed to mop up liquidity (in both shares and deposits) from SACCOs and to pay a competitive rate of return.  CFF products and services include;\r\n\r\n

', '23', '1692639655_service 2.jpg', 1, '2023-08-21 17:40:55'), (21, 'Consultancy Service', '

CDI’s consulting service is to provide expert cooperatives, organizational and consulting solutions to ensure our clients make informed decisions, based on reliable information. We assist our clients in increasing the top-line as well as the bottom-line by improving processes and approaches in line with client’s business philosophy. With many years of experience in Cooperatives development that CDI Consultants have drawn from a wider Malawi Cooperative sector, we optimize and problem-solve any process.\r\n\r\n

', '23', '1692639819_service.jpg', 1, '2023-08-21 17:43:39'), (22, 'Research', '

The institute undertakes research in a wide range of areas besides cooperatives. On cooperatives CDI continue to search for approaches that can support sustainable growth of cooperatives in Malawi and contribute to continental cooperative development. To this end, CDI liaises with the continental Africa Cooperative Development Foundation (ACDF) and local universities for knowledge sharing in in-depth policy and problem –centred research with a view of providing recommendations that refocus member-based organizations options and direction.  
\r\n\r\n

', '23', '1692639935_research .jpg', 1, '2023-08-21 17:45:35'), (23, 'Cooperatives Development Institute (CDI)', '

COOPERATIVES DEVELOPMENT INSTITUTE (CDI) is a skills development hub and research institute established based on the long experience of cooperatives development, research and training in Malawi and abroad by cooperatives practitioners. The institute has a broaden delivery scope to ably contribute to domestic driven development founded on self help and support. CDI services are for member-based organizations at both micro and macro levels, programmes/projects, trade associations, individuals and researchers.  To capacitate micro level member-based organizations, Cooperatives\r\nDevelopment Institute (CDI) uses rights based and participatory approaches to mobilize, advocate for and facilitate community dialogue and action. For general cooperatives training, a modular course has been designed that is delivered in workshops and also with an option of online/virtual delivery. 

\r\n

 WHY WORK WITH COOPERATIVES DEVELOPMENT INSTITUTE\r\n\r\n

\r\n

CDI has pooled experts from both public and private sector in and not limited to cooperatives development, academia, research, strategy development, rural outreach approaches, finance, agriculture, gender and climate financing.

\r\n\r\n


', '23', '1692640260_research .jpg', 1, '2023-08-21 17:51:00'), (24, 'Technical and Administrative Support', '

MUSCCO provide technical and administrative support through facilitation of technology transfer, staff search and placements, products design, business strategies reviews, advisory services, standardization of operations and systems.\r\n\r\n

', '23', '1692640331_service.jpg', 1, '2023-08-21 17:52:11'), (25, 'Representation and Advocacy', '

MUSCCO as part of strengthening the financial cooperatives sector, does represent its members in different fora both local and international where sector interests are presented through dialogue and position papers presentation, and also advocate for an enabling operating environment by ensuring that the legal framework is supportive of growth of SACCOs. \r\n\r\n

', '23', '1692640589_Untitled-4.jpg', 1, '2023-08-21 17:56:29'); -- -------------------------------------------------------- -- -- Table structure for table `subscribers` -- CREATE TABLE `subscribers` ( `id` int(11) NOT NULL, `link` varchar(60) NOT NULL, `email` varchar(128) NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `date` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `subscribers` -- INSERT INTO `subscribers` (`id`, `link`, `email`, `status`, `date`) VALUES (1, '3yvU1gc5xH7k1hVsRiCBKK31qnCBR0ak3j6iT2ToW', 'chawe@hotmail.com', 0, '2022-05-23 12:24:20'), (2, 'nzcQ3TWMhaGfVQ4lOfZ', 'wezmhango@hotmail.com', 1, '2022-05-24 11:22:09'), (3, 'VRWNBHrn9', 'mwezzie@gmail.com', 0, '2022-05-24 11:22:16'), (4, 'jyVwEJ5EnpK35XulGtY9N8xBKbalP9PPRgyX6Er9qFq', 'khumbiro@gmail.com', 0, '2022-05-30 09:18:15'), (5, '3HwrA', '', 0, '2023-07-25 11:36:05'), (6, 'dKnwtzKyq1G0tJhBJufDjKfGYOo79afjg6n7oZr5Sz37Fex0QAvE', '', 0, '2023-07-25 11:37:10'), (7, 'R80ww8hO60WjpnJsje0G', '', 0, '2023-07-25 11:38:03'), (8, 'Il6sBJ8ByUHrd5BD6DFSFS84m0W8x9R1VL5T0lux7afAXBJ05mAiywnsiok0', 'wezmhango@hotmail.com', 0, '2023-07-25 11:38:15'), (9, 'ZAa4V6PKcF', 'ametakpaul@icloud.com', 0, '2023-07-25 11:40:20'), (10, 'C9wrasfRnXF8fWNu', 'ametakpaul@icloud.com', 0, '2023-07-25 11:40:53'), (11, 'Sx77r2s32', 'francis@macoha.mw', 0, '2023-07-25 11:41:14'), (12, 'yrU1vWtKNHZNuqB6ZQxXdxkDiWUk', 'chikandakondwani@gmail.com', 0, '2023-07-25 11:42:01'), (13, 'NLy964mPWxO8aWmRNUtlQRJHC9595ZXuj2okChsCYTWAW', 'ametakpaul@icloud.com', 0, '2023-07-25 11:42:16'), (14, 'tPijyfDtVumMtD4F9263g9GvnQgzRvoe3P5wZPhD68Y0UL0v2T4v2z3hm', 'ametakpaul@icloud.com', 0, '2023-07-25 11:44:27'), (15, 'G3u4Ai2pv9IIC37gc1cVCVD17x', 'eve@macoha.mw', 0, '2023-07-25 11:45:11'), (16, '2bZaQoA6b5nDd2zKyoy53IW46T', 'wezmhango@hotmail.com', 0, '2023-07-25 11:45:37'), (17, '1ho29PAat7jYu0BwO0gR7OhwSfiYVyBhUQh1KaTLGxzyIRtA9GA4Un0k', 'dkananza@quantacubeenergy.com', 0, '2023-07-25 11:53:51'), (18, 'u86fbdxKnapErTjzkEi7VXwIqOlE', 'ob@gmail.com', 0, '2023-08-04 21:21:53'), (19, 'MhwE7OR', 'kg@gmail.com', 0, '2023-08-19 12:15:15'), (20, '2T4DDG9Xc4OTQxx01ADDSi3sIbT7HVpHBjJ9BncDB', 'kh6@yahoo.com', 0, '2023-08-19 12:15:28'), (21, 'ihAQNs0zvAyry1Pm06oJC4ywXrzAynEm4DKvS5cyG', 'cathy@obdesign.com', 0, '2023-08-20 19:22:04'), (22, 'gcLNo07qQwwSMV3neR8h', 'owen89@gmail.com', 0, '2023-08-21 22:57:51'); -- -------------------------------------------------------- -- -- Table structure for table `success_stories` -- CREATE TABLE `success_stories` ( `story_id` int(11) NOT NULL, `link` varchar(60) NOT NULL, `title` varchar(1024) NOT NULL, `details` longtext NOT NULL, `thumb` varchar(128) NOT NULL, `image` varchar(128) NOT NULL, `posted_by` int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp(), `status` int(11) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `success_stories` -- INSERT INTO `success_stories` (`story_id`, `link`, `title`, `details`, `thumb`, `image`, `posted_by`, `date`, `status`) VALUES (1, 'oiqipUomPfrngrRBoKm', 'Chawezi the brains behind tikhute app', '
\r\n

Malawi Blood Transfusion Service (MBTS)

\r\n
\r\n
\r\n

Malawi Blood Transfusion Service (MBTS) is a Trust that was established to provide a safe and adequate supply of blood and blood products to meet the needs of all patients in authorised hospitals in Malawi. It is committed to meet its objective of collecting, processing and testing all blood from voluntary non-remunerated blood donors in low-risk populations to international standards, in a cost efficient manner.

\r\n

The MBTS is seeking suitable candidates to fill the following vacant post:

\r\n

Driver (3 Positions) tenable at Lilongwe Office

\r\n

Job Summary
Reporting to the Human Resources and Administration officer. Driving assigned MBTS vehicles with responsibility and avoid putting the vehicles with responsibility and avoid putting the
lives of the passengers in danger.

\r\n

Qualifications, Experience and Competencies
» Malawi School Certificate of Education
» Driving License
» Having worked in this position for not less than one year

\r\n

Responsibilities

\r\n \r\n

Application letters, copies of certificates and Curriculum Vitae with at least three traceable referees from suitably qualified persons should be addressed to;

\r\n

The Chief Executive Officer
Malawi Blood Transfusion Services

\r\n

P.O.Box 2681\r\n\r\n

\r\n


 

\r\n

 

\r\n

  
Blantyre

\r\n

The closing date for receipt of application letters is 27 May, 2022

\r\n

Only shortlisted candidates will be invited for interviews

\r\n

MBTS is an egual opportunity employer. Women are encouraged to apply.

\r\n
', '220520101353__CIN2974.jpg', '220520101353__CIN2977.jpg', 16, '2022-05-20 10:13:53', 0); -- -------------------------------------------------------- -- -- Table structure for table `system_users` -- CREATE TABLE `system_users` ( `user_id` int(11) NOT NULL, `first_name` varchar(32) NOT NULL, `last_name` varchar(32) NOT NULL, `email_address` varchar(32) DEFAULT NULL, `username` varchar(32) NOT NULL, `password` varchar(254) NOT NULL, `user_type` varchar(32) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `system_users` -- INSERT INTO `system_users` (`user_id`, `first_name`, `last_name`, `email_address`, `username`, `password`, `user_type`) VALUES (34, 'Khumbo', 'Mayongo', 'kmayongo3@gmail.com', 'khumbo', '787bdd448d054a4f1a76b38bd6c9a61191248f37', 'user'), (33, 'Hope', 'Matemba', 'info@sdidrmportal.com', 'Hope', '0144c14b9618147ec95c557ab388f3b620b5fe6d', 'Admin'), (35, 'Hope', 'Matemba', 'hopematemba99@gmail.com', 'Hope', '4423524f2776222c65daae383fa911925731ae4f', 'user'), (44, 'Owen', 'Banda', 'ob@gmail.com', 'owen', '381c43fe6d171a3bae6344162b53b7c9cc6a7072', 'user'); -- -------------------------------------------------------- -- -- Table structure for table `vacancies` -- CREATE TABLE `vacancies` ( `vacancy_id` int(11) NOT NULL, `job_category` varchar(32) NOT NULL, `closing_date` date NOT NULL, `job_title` varchar(1024) NOT NULL, `job_description` longtext NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `date_posted` timestamp NOT NULL DEFAULT current_timestamp(), `posted_by` int(11) NOT NULL, `link` varchar(60) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `active_publications` -- ALTER TABLE `active_publications` ADD PRIMARY KEY (`newsletter_id`); -- -- Indexes for table `blog_categories` -- ALTER TABLE `blog_categories` ADD PRIMARY KEY (`category_id`); -- -- Indexes for table `blog_comments` -- ALTER TABLE `blog_comments` ADD PRIMARY KEY (`comment_id`); -- -- Indexes for table `blog_posts` -- ALTER TABLE `blog_posts` ADD PRIMARY KEY (`blog_id`); -- -- Indexes for table `drm_projects` -- ALTER TABLE `drm_projects` ADD PRIMARY KEY (`newsletter_id`); -- -- Indexes for table `drm_publications` -- ALTER TABLE `drm_publications` ADD PRIMARY KEY (`report_id`); -- -- Indexes for table `drm_reports` -- ALTER TABLE `drm_reports` ADD PRIMARY KEY (`newsletter_id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`event_id`); -- -- Indexes for table `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`faq_id`); -- -- Indexes for table `inquiries` -- ALTER TABLE `inquiries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `job_categories` -- ALTER TABLE `job_categories` ADD PRIMARY KEY (`category_id`); -- -- Indexes for table `leadership` -- ALTER TABLE `leadership` ADD PRIMARY KEY (`leader_id`); -- -- Indexes for table `newsletters` -- ALTER TABLE `newsletters` ADD PRIMARY KEY (`newsletter_id`); -- -- Indexes for table `overall_projects` -- ALTER TABLE `overall_projects` ADD PRIMARY KEY (`newsletter_id`); -- -- Indexes for table `projects` -- ALTER TABLE `projects` ADD PRIMARY KEY (`project_id`); -- -- Indexes for table `publications` -- ALTER TABLE `publications` ADD PRIMARY KEY (`publication_id`); -- -- Indexes for table `regions` -- ALTER TABLE `regions` ADD PRIMARY KEY (`region_id`); -- -- Indexes for table `report` -- ALTER TABLE `report` ADD PRIMARY KEY (`report_id`); -- -- Indexes for table `resources` -- ALTER TABLE `resources` ADD PRIMARY KEY (`resource_id`); -- -- Indexes for table `saccos` -- ALTER TABLE `saccos` ADD PRIMARY KEY (`sacco_id`); -- -- Indexes for table `sacco_statistics` -- ALTER TABLE `sacco_statistics` ADD PRIMARY KEY (`stat_id`); -- -- Indexes for table `services` -- ALTER TABLE `services` ADD PRIMARY KEY (`service_id`); -- -- Indexes for table `subscribers` -- ALTER TABLE `subscribers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `success_stories` -- ALTER TABLE `success_stories` ADD PRIMARY KEY (`story_id`); -- -- Indexes for table `system_users` -- ALTER TABLE `system_users` ADD PRIMARY KEY (`user_id`); -- -- Indexes for table `vacancies` -- ALTER TABLE `vacancies` ADD PRIMARY KEY (`vacancy_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `active_publications` -- ALTER TABLE `active_publications` MODIFY `newsletter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=134; -- -- AUTO_INCREMENT for table `blog_categories` -- ALTER TABLE `blog_categories` MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `blog_comments` -- ALTER TABLE `blog_comments` MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blog_posts` -- ALTER TABLE `blog_posts` MODIFY `blog_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49; -- -- AUTO_INCREMENT for table `drm_projects` -- ALTER TABLE `drm_projects` MODIFY `newsletter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47; -- -- AUTO_INCREMENT for table `drm_publications` -- ALTER TABLE `drm_publications` MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `drm_reports` -- ALTER TABLE `drm_reports` MODIFY `newsletter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `faqs` -- ALTER TABLE `faqs` MODIFY `faq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `inquiries` -- ALTER TABLE `inquiries` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `job_categories` -- ALTER TABLE `job_categories` MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `leadership` -- ALTER TABLE `leadership` MODIFY `leader_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT for table `newsletters` -- ALTER TABLE `newsletters` MODIFY `newsletter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113; -- -- AUTO_INCREMENT for table `overall_projects` -- ALTER TABLE `overall_projects` MODIFY `newsletter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149; -- -- AUTO_INCREMENT for table `projects` -- ALTER TABLE `projects` MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `publications` -- ALTER TABLE `publications` MODIFY `publication_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96; -- -- AUTO_INCREMENT for table `regions` -- ALTER TABLE `regions` MODIFY `region_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `report` -- ALTER TABLE `report` MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `resources` -- ALTER TABLE `resources` MODIFY `resource_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=200; -- -- AUTO_INCREMENT for table `saccos` -- ALTER TABLE `saccos` MODIFY `sacco_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80; -- -- AUTO_INCREMENT for table `sacco_statistics` -- ALTER TABLE `sacco_statistics` MODIFY `stat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74; -- -- AUTO_INCREMENT for table `services` -- ALTER TABLE `services` MODIFY `service_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `subscribers` -- ALTER TABLE `subscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `success_stories` -- ALTER TABLE `success_stories` MODIFY `story_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `system_users` -- ALTER TABLE `system_users` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `vacancies` -- ALTER TABLE `vacancies` MODIFY `vacancy_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;