-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: sql113.infinityfree.com
-- Generation Time: Oct 01, 2026 at 09:29 AM
-- Server version: 11.4.13-MariaDB
-- PHP Version: 7.2.22
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `if0_42413220_rhif`
--
-- --------------------------------------------------------
--
-- Table structure for table `activity_log`
--
CREATE TABLE `activity_log` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(10) UNSIGNED NOT NULL,
`action` varchar(120) NOT NULL,
`entity_type` varchar(80) DEFAULT NULL,
`entity_id` int(10) UNSIGNED DEFAULT NULL,
`details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ;
-- --------------------------------------------------------
--
-- Table structure for table `admins`
--
CREATE TABLE `admins` (
`id` int(10) UNSIGNED NOT NULL,
`username` varchar(80) NOT NULL,
`email` varchar(190) NOT NULL,
`password_hash` varchar(255) NOT NULL,
`role` enum('super_admin','editor') NOT NULL DEFAULT 'editor',
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`last_login` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `admins`
--
INSERT INTO `admins` (`id`, `username`, `email`, `password_hash`, `role`, `created_at`, `last_login`) VALUES
(1, 'isaacokello', 'okelloc48@gmail.com', '$2y$12$yXTP4RHpXmTI9idoUdmHGeXXufhGc3j7hJsxICBUlp0UhSXKqu7jy', 'super_admin', '2026-09-06 09:30:43', '2026-10-01 06:27:02');
-- --------------------------------------------------------
--
-- Table structure for table `board_members`
--
CREATE TABLE `board_members` (
`id` int(10) UNSIGNED NOT NULL,
`full_name` varchar(160) NOT NULL,
`role_title` varchar(160) NOT NULL,
`bio` text DEFAULT NULL,
`photo_id` int(10) UNSIGNED DEFAULT NULL,
`email` varchar(190) DEFAULT NULL,
`display_order` int(11) NOT NULL DEFAULT 0,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `board_members`
--
INSERT INTO `board_members` (`id`, `full_name`, `role_title`, `bio`, `photo_id`, `email`, `display_order`, `is_active`, `created_at`) VALUES
(2, 'ISAAC OKELLO', 'Executive Director', 'I am a seasoned public health practitioner and health marketing strategist with over 9 years of progressive experience in pharmaceutical industry, strategic health advocacy across Uganda and Africa.', 13, NULL, 0, 1, '2026-09-06 09:57:08'),
(3, 'MILLICENT BULAFU', 'Board Chairperson', 'Couselling Psychologist | CEO LivingWell Counselling center | Social worker | Nutritionist | Humanitarian Emergency worker.', 14, NULL, 1, 1, '2026-09-06 09:57:08'),
(4, 'DR. RONAH A. RUHIGWA', 'Board Secretary', 'A transformational coach passionate about personal and professional growth. Helping people live fulfilling anf purposeful lives', 15, NULL, 2, 1, '2026-09-06 09:57:08'),
(5, 'TWAMBALE DENIS HARIS', 'Board Member', 'Medical Insurance and Tech', 16, NULL, 3, 1, '2026-09-06 09:57:08'),
(6, 'DR. GRACE NAMBATYA KYEYUNE', 'Board Member', 'PhD Medicinal Chemistry Loughborough University UK | Executive Director, Natural Chemotherapy Research Institute, Ministry of Health - UG', 17, NULL, 4, 1, '2026-09-06 09:57:08'),
(7, 'MR. AKUGIZIBWE ADOLF', 'Legal Advisor', '', 18, NULL, 5, 1, '2026-09-06 09:57:08');
-- --------------------------------------------------------
--
-- Table structure for table `contact_submissions`
--
CREATE TABLE `contact_submissions` (
`id` int(10) UNSIGNED NOT NULL,
`full_name` varchar(160) NOT NULL,
`email` varchar(190) NOT NULL,
`phone` varchar(40) DEFAULT NULL,
`subject` varchar(255) DEFAULT NULL,
`message` text NOT NULL,
`status` enum('new','read','archived') NOT NULL DEFAULT 'new',
`created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `email_campaigns`
--
CREATE TABLE `email_campaigns` (
`id` int(10) UNSIGNED NOT NULL,
`subject` varchar(255) NOT NULL,
`body` mediumtext NOT NULL,
`sent_by` int(10) UNSIGNED NOT NULL,
`sent_at` datetime DEFAULT NULL,
`recipient_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
`related_event_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `email_campaigns`
--
INSERT INTO `email_campaigns` (`id`, `subject`, `body`, `sent_by`, `sent_at`, `recipient_count`, `related_event_id`) VALUES
(1, 'hello', 'test', 1, NULL, 1, NULL),
(2, 'helo', 'testing', 1, '2026-09-06 09:32:57', 0, NULL),
(3, 'jj', 'mmm', 1, '2026-09-06 09:34:19', 0, NULL),
(4, 'hello', 'testing', 1, '2026-09-06 09:36:36', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `email_campaign_recipients`
--
CREATE TABLE `email_campaign_recipients` (
`id` int(10) UNSIGNED NOT NULL,
`campaign_id` int(10) UNSIGNED NOT NULL,
`subscriber_id` int(10) UNSIGNED NOT NULL,
`status` enum('sent','failed','bounced') NOT NULL DEFAULT 'sent'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `email_campaign_recipients`
--
INSERT INTO `email_campaign_recipients` (`id`, `campaign_id`, `subscriber_id`, `status`) VALUES
(1, 2, 1, 'failed'),
(2, 3, 1, 'failed'),
(3, 4, 1, 'sent');
-- --------------------------------------------------------
--
-- Table structure for table `events`
--
CREATE TABLE `events` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) NOT NULL,
`description` text DEFAULT NULL,
`content_html` mediumtext DEFAULT NULL,
`location` varchar(255) DEFAULT NULL,
`start_date` datetime NOT NULL,
`end_date` datetime DEFAULT NULL,
`status` enum('draft','upcoming','ongoing','completed') NOT NULL DEFAULT 'draft',
`cover_image_id` int(10) UNSIGNED DEFAULT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `events`
--
INSERT INTO `events` (`id`, `title`, `description`, `content_html`, `location`, `start_date`, `end_date`, `status`, `cover_image_id`, `created_by`, `created_at`, `updated_at`) VALUES
(2, 'RHIF Sports Football Gala 2026', 'Raising Hope International Friends is proud to announce our inaugural Sports Football Gala — a special sporting event that brings together sickle cell warriors, families, supporters, and the community.', '
About the Event
\r\n
\r\n Welcome to the Raising Hope Internantion friends soccer galla which is at Kampala Quality Primary school stadium - Bahai Temple\r\n
\r\n
\r\n Whether you are living with Sickle Cell Disease, caring for a warrior, or standing in solidarity with our cause, this event offers vital resources, medical guidance, and uplifting fellowship.\r\n
\r\n\r\n
What to Expect
\r\n
\r\n
Expert Medical Talks: Insights from leading hematologists on managing crises, nutrition, and mental health.
\r\n
Free Health Consultations: Opportunities for warriors and families to consult with healthcare professionals.
\r\n
Warrior Stories & Testimonies: Inspiring real-life experiences shared by resilient community champions.
\r\n
Community Solidarity: Connect with peer support groups, caregivers, and partners across Uganda.
\r\n
\r\n\r\n
Program & Schedule
\r\n
\r\n
\r\n 08:30 AM – 09:30 AM\r\n
Arrival, Registration & Refreshments
\r\n
Check-in at the front desk and receive your event materials and welcome kit.
\r\n
\r\n
\r\n 09:30 AM – 11:00 AM\r\n
Keynote Address & Expert Medical Panel
\r\n
Presentations from healthcare specialists on advances in sickle cell care and crisis management.
\r\n
\r\n
\r\n 11:30 AM – 01:00 PM\r\n
Warrior Testimonies & Caregiver Circle
\r\n
An open space for sharing personal experiences, challenges, and support systems.
\r\n
\r\n\r\n\r\n
Who Should Attend?
\r\n
\r\n
Sickle cell warriors and their family members.
\r\n
Parents, caregivers, and guardians seeking guidance and community.
\r\n
Healthcare workers, nurses, medical students, and advocates.
\r\n
Supporters, partners, and community members passionate about health equity.
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', 'KAMPALA QUALITY STADIUM - BAHAI TEMPLE', '2026-09-12 08:00:00', '2026-09-12 07:00:00', 'completed', 91, 1, '2026-09-06 09:57:09', '2026-10-01 06:27:37'),
(3, '5th Annual Uganda Sickle Cell Convention', 'Join hundreds of warriors, doctors, and advocates for our biggest annual event. Expect insightful panel discussions, free medical consultations, and powerful testimonies from our community leaders.', '
About the Event
Join hundreds of warriors, doctors, and advocates for our biggest annual event. Expect insightful panel discussions, free medical consultations, and powerful testimonies from our community leaders.
The 5th Annual Uganda Sickle Cell Convention aims to bring comprehensive healthcare discussions to the forefront. Experts will be presenting new treatments and discussing mental health resilience for sickle cell warriors and their caregivers.
This year\'s theme, \"Building Sustainable Sickle Cell Support Systems Using a Multisectoral Approach,\" reflects our belief that lasting progress against sickle cell disease requires collaboration across healthcare providers, government, researchers, and community organizations working together.
Agenda Highlights
1
Keynote Speech
Advancements in Sickle Cell Disease management globally and in Uganda.
2
Panel Discussion: The Caregiver\'s Journey
A deep dive into the everyday challenges and support systems for caregivers.
3
Free Consultations & Screenings
Medical professionals will be available for quick consultations throughout the afternoon.
Why This Matters
Since RHIF\'s founding in 2016, our community screening drives have reached over 5,400 individuals, registering 900 confirmed sickle cell patients and identifying 595 sickle cell trait carriers who now have access to counseling and care. Past events, including our 2020 sickle cell marathon in Jinja City and community walks in Buyende District, have helped connect warriors directly to the hospitals and clinics that provide ongoing sickle cell services.
This convention builds on that track record, bringing together healthcare professionals, researchers, policymakers, and the sickle cell community for a day of education, advocacy, and connection.
Join Us!
Register today to secure your spot. Kits and information packages will be provided at the registration desk.
', 'Makerere University School of Public Health Auditorium', '2026-07-03 08:30:00', NULL, 'completed', NULL, 1, '2026-09-06 09:57:09', '2026-09-06 11:32:12'),
(4, '4th Annual Uganda Sickle Cell Convention', 'We partnered with local clinics to provide free Sickle Cell screenings, genetic counseling, and basic healthcare supplies for underserved families in the Kampala region.', '
About the Event
We are partnering with local clinics to provide free Sickle Cell screenings, genetic counseling, and basic healthcare supplies for underserved families in the Kampala region.
Our 4th annual event focuses on grassroots support. Bringing essential care closer to those who need it most, this convention highlights the importance of genetic awareness and proactive healthcare in our communities.
What to Expect
Free Mass Screening
Early detection saves lives. Get tested to know your status.
Genetic Counseling
Experts will be available to answer all questions regarding traits, transmission, and family planning.
Healthcare Supply Distribution
Providing vital, basic health kits for registered warriors in attendance.
Support This Cause
Want to help us reach more families? Your donation makes a difference.
', 'Jinja Town Mall', '2025-07-11 08:30:00', NULL, 'completed', NULL, 1, '2026-09-06 09:57:09', '2026-09-06 11:32:12'),
(5, '3rd Annual Uganda Sickle Cell Convention', 'Our annual convention helped raise vital funds for emergency pain management medications for children living with SCD, bringing together warriors, families, and advocates.', '
About the Event
Run for a cause! Our annual marathon helps raise vital funds for emergency pain management medications for children living with SCD. Register early to get your running kit.
The 3rd Annual Convention brought a new flavor by integrating a charity run to mobilize the public and generate critical awareness and funding. It\'s a great opportunity for fitness enthusiasts and families alike to show solidarity with sickle cell warriors.
Event Features
5KM & 10KM Runs
Choose your pace and distance! Medals await those who cross the finish line.
Aerobics & Warm-up Session
Guided morning workout led by top fitness instructors before the flag-off.
Entertainment & Refreshments
Enjoy post-run performances by local artists and healthy refreshments.
Get Your Kit
Registration includes a running t-shirt, a water bottle, and a branded wristband.
Through the National Sickle Cell Convention and continuous engagements, we advocate for the development and implementation of policies that strengthen sickle cell disease care and promote sustainable, earmarked government funding.
Advocacy efforts are aligned with Uganda’s existing health and social policy frameworks, including the Health Sector Development Plan (HSDP), the National Non-Communicable Diseases (NCD) Strategy, and the National Sickle Cell Strategy.
Advocacy Priorities
Sustainable Funding
Advocating for sustainable, earmarked government funding for sickle cell disease programs in Uganda.
Essential Medicines
Ensuring sustained access to proven, cost-effective interventions and essential medicines for all patients.
National Guidelines Scale-up
Advocating for the adoption and scale-up of evidence-based SCD interventions in line with national guidelines.
Policy Alignment
Aligning SCD initiatives with the Health Sector Development Plan and the National NCD Strategy.
Help Us Spread Awareness
Partner with us to bring educational campaigns to your community and help break the silence around sickle cell disease.
Contact Us ', 19, 29, 'active', '2026-09-06 09:57:08', '2026-09-06 11:47:42'),
(3, 'Educational Campaigns', 'Challenging misconceptions and stigma around SCD through community awareness and public education.', '
Breaking the Silence
Through community outreach, media campaigns, school-based education, and stakeholder engagement, the program disseminates accurate information on SCD causes, inheritance, prevention, early signs, and available treatment options.
Advocacy and awareness activities are designed to encourage early health-seeking behavior, promote premarital and antenatal screening, and empower individuals and families to make informed decisions.
Our Campaign Initiatives
Community Engagement
Engaging community leaders, religious institutions, schools, youth groups, and patient champions to amplify messaging.
Media & Digital Campaigns
Using mass media and digital platforms to disseminate accurate information on SCD and dispel myths.
School-Based Education
Educating students and teachers to create supportive school environments and foster peer awareness.
Screening Advocacy
Promoting premarital and antenatal screening to help families make informed health decisions.
Help Us Spread Awareness
Partner with us to bring educational campaigns to your community and help break the silence around sickle cell disease.
Contact Us ', 20, 32, 'active', '2026-09-06 09:57:08', '2026-09-06 11:47:42'),
(4, 'Community Engagement', 'Bringing together patients, families, and caregivers to build a lasting network of support.', '
Strength in Unity
Living with sickle cell disease can be isolating. Patients and families often face physical challenges, emotional strain, and social stigma. Our community engagement programme creates safe spaces where people with SCD and their loved ones can connect, share experiences, and find strength in unity.
We believe that community support is as vital as medical treatment in improving quality of life and building resilience.
Community Programs
Support Groups
Regular meetups organized by region where patients and families share experiences, coping strategies, and emotional support in a confidential and caring environment.
Youth Programs
Specialized activities for young people with SCD including mentorship, recreational activities, and career guidance to inspire confidence and ambition.
Caregiver Support
Dedicated support for parents and caregivers including wellness workshops, stress management, and resources to help them care for themselves while supporting their loved ones.
Peer Mentorship
Connect with trained peer mentors who understand your journey and can provide guidance, encouragement, and practical advice for managing SCD.
Our Community Impact
2,000+ Members
Active members across all regional support groups connected by shared experience and mutual support.
50+ Monthly Meetups
Regular community gatherings across Uganda providing safe spaces for connection and support.
500+ Lives Mentored
Peer mentorship pairs helping individuals navigate life with SCD with confidence and resilience.
30+ Caregivers Trained
Caregiver workshops equipping families with knowledge and self-care strategies for better outcomes.
Join Our Community
Connect with others, share your story, and find strength in a supportive community that truly understands your journey.
Get Involved ', 21, 21, 'active', '2026-09-06 09:57:08', '2026-09-06 11:46:51');
INSERT INTO `programmes` (`id`, `title`, `description`, `content_html`, `cover_image_id`, `inner_image_id`, `status`, `created_at`, `updated_at`) VALUES
(5, 'Patient Support & Advocacy', 'Standing with warriors and their families with guidance, resources, and compassionate support.', '
Holistic Care & Support
While awareness, screening, capacity building, and advocacy are critical, their impact can only be realized when individuals diagnosed with sickle cell disease are successfully linked to continuous, high-quality care and receive the social and emotional support necessary to live healthy, productive lives.
The program strengthens referral pathways from community screening outreaches, newborn screening services, schools, and health facilities into comprehensive sickle cell care clinics.
Our Support Systems
Clinical Linkage
Facilitating timely enrollment into care, routine clinical follow-up, access to essential medicines, and laboratory monitoring.
Continuity of Care
Promoting continuity through patient navigation, appointment reminders, and family-centered case management to reduce loss to follow-up.
Psychosocial Counseling
Providing counseling services for children, adolescents, adults, parents, and caregivers to cope with emotional and social challenges.
Peer & Community Support
Integrating peer support groups, youth mentorship, caregiver education, and mental health support into service delivery.
Help Us Spread Awareness
Partner with us to bring educational campaigns to your community and help break the silence around sickle cell disease.
Contact Us ', 22, 36, 'active', '2026-09-06 09:57:08', '2026-09-06 11:47:42'),
(6, 'Annual SCD Convention', 'A shared platform to exchange experience, knowledge, and ideas that inspire new solutions.', '
Bringing People Together
The Annual SCD Convention is our flagship event, bringing together patients, healthcare professionals, policymakers, researchers, and caregivers for three days of learning, networking, and celebration. It\'s a gathering that transforms lives, builds alliances, and creates momentum for change.
This convention showcases the resilience of our community and demonstrates the power of collective action in addressing sickle cell disease challenges.
What to Expect
Expert Speakers
International and local experts share the latest research, clinical insights, and best practices in sickle cell disease management.
Interactive Workshops
Hands-on sessions covering topics from disease management, nutrition, mental health, to career development for people with SCD.
Networking Sessions
Connect with peers, healthcare providers, and leaders in the SCD community in a relaxed and supportive environment.
Resource Fair
Organizations, health providers, and vendors showcase resources, products, and services beneficial to the SCD community.
Awards Ceremony
Celebrate inspiring individuals and organizations making extraordinary contributions to the SCD community.
Entertainment & Celebration
Evening events, cultural performances, and social gatherings to celebrate our community and create lasting memories.
Convention Highlights
2023 Convention
✓ 500+ participants attended
✓ 25+ expert speakers
✓ 12 interactive workshops
✓ 30+ organizations exhibited
Learning Outcomes
✓ Participants gained practical knowledge
✓ New partnerships formed
✓ Policy recommendations drafted
✓ Community strengthened
Testimonials
✓ \"Life-changing experience\"
✓ \"Found my support system\"
✓ \"Inspired to continue advocacy\"
✓ \"Connected with the community\"
Join Us at the Next Convention
Be part of Uganda\'s premier gathering for the sickle cell disease community. Learn, connect, and celebrate with hundreds of passionate individuals.
Register Your Interest ', 23, 31, 'active', '2026-09-06 09:57:09', '2026-09-06 11:47:42');
INSERT INTO `programmes` (`id`, `title`, `description`, `content_html`, `cover_image_id`, `inner_image_id`, `status`, `created_at`, `updated_at`) VALUES
(7, 'Sickle Cell Marathon', 'Run for a cause — every step raises funds and awareness for those living with SCD.', '
Moving for Change
The Sickle Cell Marathon is more than just a race—it\'s a movement. Hundreds of participants run, jog, and walk to raise funds for SCD programmes while raising awareness about the disease. Every kilometer covered represents hope, resilience, and solidarity with the SCD community.
Whether you\'re a seasoned runner or joining us for the first time, the marathon welcomes all fitness levels and celebrates the courage of people living with SCD.
Marathon Details
When
Held annually in June during World Sickle Cell Awareness Month. Check our website for exact dates of the next marathon.
Where
Multiple routes available starting from Kampala. 5km fun run, 10km half marathon, and 21km full marathon options accommodate all fitness levels.
Participation
All ages and fitness levels welcome! Register as an individual or form a team. People with SCD are especially celebrated.
Benefits
Finisher medals, t-shirts, refreshments, and the satisfaction of supporting a cause that saves and improves lives.
How to Participate
1
Register Online
Sign up on our website or at our office. Choose your preferred route (5km, 10km, or 21km) and provide your contact details.
2
Start Fundraising
Set up a fundraising page and invite friends, family, and colleagues to sponsor your run. Every shilling raised supports SCD programmes.
3
Collect Pledges
Share your personal motivation and the impact your fundraising will make. Whether collecting individually or as a team, every contribution matters.
4
Race Day
Join us for a day of celebration, movement, and solidarity. Run your race, celebrate with our community, and witness the impact of your effort.
', 24, 33, 'active', '2026-09-06 09:57:09', '2026-09-06 11:47:42');
-- --------------------------------------------------------
--
-- Table structure for table `projects`
--
CREATE TABLE `projects` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) NOT NULL,
`summary` text DEFAULT NULL,
`description` text DEFAULT NULL,
`cover_image_id` int(10) UNSIGNED DEFAULT NULL,
`status` enum('draft','active','completed') NOT NULL DEFAULT 'draft',
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `projects`
--
INSERT INTO `projects` (`id`, `title`, `summary`, `description`, `cover_image_id`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Healthcare Provider Capacity Building', 'Training sessions for doctors, nurses, and health workers to improve diagnosis, treatment, and care.', 'We conduct comprehensive training sessions for healthcare professionals including doctors, nurses, and health workers. These programs focus on improving the diagnosis, treatment, and overall care of people living with Sickle Cell Disease. By equipping healthcare providers with the latest knowledge and best practices, we ensure better health outcomes for warriors across Uganda.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(3, 'Financial Literacy for Caregivers and Warriors', 'Empowering caregivers and warriors with basic financial skills to manage healthcare costs and savings.', 'We empower caregivers and Sickle Cell warriors with essential financial literacy skills. Our programs teach basic financial management, including how to handle healthcare costs, develop savings strategies, and explore income-generating opportunities. This economic empowerment helps families better manage the financial burden of living with SCD.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(4, 'Annual Sickle Cell Convention', 'National gathering bringing together patients, families, experts, and policymakers to share experiences.', 'Our annual national convention is a landmark event that brings together patients, families, medical experts, and policymakers. Participants share experiences, learn from each other, and collectively shape the Sickle Cell agenda in Uganda. This platform fosters collaboration and drives policy changes at the national level.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(5, 'Sickle Cell Awareness & Fundraising Run', 'High-impact annual run to raise awareness, break stigma, and mobilize resources for warriors.', 'We host a high-impact annual run that serves multiple purposes: raising public awareness about Sickle Cell Disease, breaking down stigma, and mobilizing resources. Funds raised support warriors and community-based Sickle Cell programs, ensuring sustainable care and support for those in need.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(6, 'Gene Clubs in Schools', 'Establishing Gene Clubs in schools to promote Sickle Cell education and peer awareness among students.', 'We establish and support Gene Clubs in primary and secondary schools across Uganda. These clubs promote Sickle Cell education, foster peer awareness, and encourage responsible health practices among students. Early education helps reduce stigma and creates a more informed, supportive generation.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(7, 'Scholarship and Education Support', 'Providing scholarships, scholastic materials, and mentorship for children and youth affected by SCD.', 'We have launched a dedicated project to provide scholarships, scholastic materials, and mentorship for children and youth living with SCD or from affected families. This initiative aims to reduce school dropouts and boost academic success, ensuring that warriors have equal opportunities to pursue their educational dreams.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(8, 'Village Health Team (VHT) Training', 'Building capacity of VHTs at grassroots level to improve community awareness and early case identification.', 'We build the capacity of Village Health Teams at the grassroots level. These trained community members improve awareness, identify Sickle Cell cases early, and strengthen referral systems for timely care. VHTs serve as the critical link between communities and formal healthcare services.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(9, 'Peer Support & Mentorship Circles', 'Facilitating peer groups where warriors share experiences and mentor newly diagnosed individuals.', 'We facilitate peer support groups where warriors can safely share experiences, offer emotional support, and mentor newly diagnosed individuals. These circles promote resilience, hope, and a sense of belonging. Knowing they are not alone in their journey helps warriors navigate challenges with confidence.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(10, 'Mobile Outreach Clinics', 'Bringing screening, counseling, and basic care closer to underserved communities in hard-to-reach areas.', 'Through our mobile clinics, we bring screening, counseling, and basic healthcare services closer to underserved communities. This initiative is particularly vital in hard-to-reach areas where access to healthcare facilities is limited. We ensure no warrior is left behind regardless of their location.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(11, 'Policy & Advocacy Engagement', 'Working with stakeholders and government agencies to advocate for national Sickle Cell policies and funding.', 'We actively work with stakeholders and government agencies to advocate for national Sickle Cell policies. Our efforts focus on securing increased funding and ensuring SCD is prioritized in public health agendas. Systemic change is essential for sustainable impact at the national level.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(12, 'Caregiver Empowerment Workshops', 'Equipping caregivers with skills on nutrition, home care, stress management, and rights advocacy.', 'These workshops equip caregivers with essential skills including nutrition management, home care techniques, stress management, and rights advocacy. By enhancing caregiving capabilities at the household level, we improve the quality of life for both warriors and their families, creating a supportive home environment.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05'),
(13, 'Mental Health and Psychosocial Support', 'Providing counseling, peer support groups, and mental health awareness.', 'We provide comprehensive counseling, peer support groups, and mental health awareness programs for warriors and families. This project specifically addresses trauma, stress, anxiety, and depression caused by the disease, recognizing that mental well-being is as crucial as physical health in the holistic care of sickle cell disease.', NULL, 'active', '2026-09-06 09:57:09', '2026-09-06 10:03:05');
-- --------------------------------------------------------
--
-- Table structure for table `site_settings`
--
CREATE TABLE `site_settings` (
`setting_key` varchar(100) NOT NULL,
`setting_value` text DEFAULT NULL,
`updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `subscribers`
--
CREATE TABLE `subscribers` (
`id` int(10) UNSIGNED NOT NULL,
`full_name` varchar(160) DEFAULT NULL,
`email` varchar(190) NOT NULL,
`age` tinyint(3) UNSIGNED DEFAULT NULL,
`phone` varchar(40) DEFAULT NULL,
`location` varchar(190) DEFAULT NULL,
`password_hash` varchar(255) DEFAULT NULL,
`subscribed_at` datetime NOT NULL DEFAULT current_timestamp(),
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`source` varchar(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `subscribers`
--
INSERT INTO `subscribers` (`id`, `full_name`, `email`, `age`, `phone`, `location`, `password_hash`, `subscribed_at`, `is_active`, `source`) VALUES
(1, 'KABANDA ARTHUR', 'nanfukaannet308@gmail.com', 34, '+256706062559', 'Kampala', NULL, '2026-09-06 12:27:40', 1, 'public_registration');
-- --------------------------------------------------------
--
-- Table structure for table `team_members`
--
CREATE TABLE `team_members` (
`id` int(10) UNSIGNED NOT NULL,
`full_name` varchar(160) NOT NULL,
`role_title` varchar(160) NOT NULL,
`bio` text DEFAULT NULL,
`photo_id` int(10) UNSIGNED DEFAULT NULL,
`email` varchar(190) DEFAULT NULL,
`member_type` enum('team','volunteer') NOT NULL DEFAULT 'team',
`display_order` int(11) NOT NULL DEFAULT 0,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `team_members`
--
INSERT INTO `team_members` (`id`, `full_name`, `role_title`, `bio`, `photo_id`, `email`, `member_type`, `display_order`, `is_active`, `created_at`) VALUES
(4, 'Deborah Nanyonga', 'Assistant Administrator Officer', 'A nurse by profession and passionate about teamwork, organization, and helping ensure our work run smoothly.', 4, NULL, 'team', 0, 1, '2026-09-06 09:57:08'),
(5, 'Kiyemba Dinton', 'Project Officer', 'A medical laboratory technician by profession who brings discipline and care to our fieldwork.', 5, NULL, 'team', 1, 1, '2026-09-06 09:57:08'),
(6, 'Dr. Muwanguzi Kenneth', 'Head of Research and Innovation', 'A certified medical doctor and health services leader with strong experience in sickle cell care and research.', 6, NULL, 'team', 2, 1, '2026-09-06 09:57:08'),
(7, 'Nakalema Winnie Sarah', 'Head of Volunteers', 'A nutritionist and dietitian whose work supports wellness, education, and care for affected families.', 7, NULL, 'team', 3, 1, '2026-09-06 09:57:08'),
(8, 'Kaweesa Charles Sam', 'Sustainability and Marketing Director', 'Focused on building partnerships and helping RHIF sustain its impact through strong outreach.', 8, NULL, 'team', 4, 1, '2026-09-06 09:57:08'),
(9, 'Atwiine Cynthia', 'Volunteer', '', 9, NULL, 'volunteer', 5, 1, '2026-09-06 09:57:08'),
(11, 'Nangendo Sharifah', 'Volunteer', '', 11, NULL, 'volunteer', 7, 1, '2026-09-06 09:57:08'),
(12, 'Okurut Deogracious', 'Volunteer', '', 12, NULL, 'volunteer', 8, 1, '2026-09-06 09:57:08');
-- --------------------------------------------------------
--
-- Table structure for table `volunteer_applications`
--
CREATE TABLE `volunteer_applications` (
`id` int(10) UNSIGNED NOT NULL,
`full_name` varchar(160) NOT NULL,
`email` varchar(190) NOT NULL,
`phone` varchar(40) DEFAULT NULL,
`interest` varchar(160) DEFAULT NULL,
`message` text DEFAULT NULL,
`status` enum('new','reviewing','accepted','declined') NOT NULL DEFAULT 'new',
`created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `username` (`username`),
ADD UNIQUE KEY `email` (`email`);
--
-- Indexes for table `board_members`
--
ALTER TABLE `board_members`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_board_photo` (`photo_id`);
--
-- Indexes for table `contact_submissions`
--
ALTER TABLE `contact_submissions`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_contact_status_date` (`status`,`created_at`);
--
-- Indexes for table `email_campaigns`
--
ALTER TABLE `email_campaigns`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_campaign_admin` (`sent_by`),
ADD KEY `fk_campaign_event` (`related_event_id`);
--
-- Indexes for table `email_campaign_recipients`
--
ALTER TABLE `email_campaign_recipients`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_campaign_subscriber` (`campaign_id`,`subscriber_id`),
ADD KEY `fk_campaign_recipient_subscriber` (`subscriber_id`);
--
-- Indexes for table `events`
--
ALTER TABLE `events`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_event_cover` (`cover_image_id`),
ADD KEY `fk_event_admin` (`created_by`);
--
-- Indexes for table `event_media`
--
ALTER TABLE `event_media`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_event_media` (`event_id`,`media_id`),
ADD KEY `fk_event_media_media` (`media_id`);
--
-- Indexes for table `event_notes`
--
ALTER TABLE `event_notes`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_event_note_event` (`event_id`),
ADD KEY `fk_event_note_admin` (`created_by`);
--
-- Indexes for table `gallery_items`
--
ALTER TABLE `gallery_items`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_gallery_media` (`media_id`),
ADD KEY `idx_gallery_category` (`category`,`is_active`,`display_order`);
--
-- Indexes for table `media`
--
ALTER TABLE `media`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_media_admin` (`uploaded_by`);
--
-- Indexes for table `programmes`
--
ALTER TABLE `programmes`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_programme_cover` (`cover_image_id`),
ADD KEY `fk_programme_inner` (`inner_image_id`);
--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_project_cover` (`cover_image_id`);
--
-- Indexes for table `site_settings`
--
ALTER TABLE `site_settings`
ADD PRIMARY KEY (`setting_key`);
--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `email` (`email`),
ADD KEY `idx_subscribers_active_date` (`is_active`,`subscribed_at`);
--
-- Indexes for table `team_members`
--
ALTER TABLE `team_members`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_team_photo` (`photo_id`);
--
-- Indexes for table `volunteer_applications`
--
ALTER TABLE `volunteer_applications`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_volunteer_status_date` (`status`,`created_at`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `board_members`
--
ALTER TABLE `board_members`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `contact_submissions`
--
ALTER TABLE `contact_submissions`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `email_campaigns`
--
ALTER TABLE `email_campaigns`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `email_campaign_recipients`
--
ALTER TABLE `email_campaign_recipients`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `event_media`
--
ALTER TABLE `event_media`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `event_notes`
--
ALTER TABLE `event_notes`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `gallery_items`
--
ALTER TABLE `gallery_items`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
--
-- AUTO_INCREMENT for table `programmes`
--
ALTER TABLE `programmes`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `team_members`
--
ALTER TABLE `team_members`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `volunteer_applications`
--
ALTER TABLE `volunteer_applications`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `board_members`
--
ALTER TABLE `board_members`
ADD CONSTRAINT `fk_board_photo` FOREIGN KEY (`photo_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `email_campaigns`
--
ALTER TABLE `email_campaigns`
ADD CONSTRAINT `fk_campaign_admin` FOREIGN KEY (`sent_by`) REFERENCES `admins` (`id`),
ADD CONSTRAINT `fk_campaign_event` FOREIGN KEY (`related_event_id`) REFERENCES `events` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `email_campaign_recipients`
--
ALTER TABLE `email_campaign_recipients`
ADD CONSTRAINT `fk_campaign_recipient_campaign` FOREIGN KEY (`campaign_id`) REFERENCES `email_campaigns` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk_campaign_recipient_subscriber` FOREIGN KEY (`subscriber_id`) REFERENCES `subscribers` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `events`
--
ALTER TABLE `events`
ADD CONSTRAINT `fk_event_admin` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`),
ADD CONSTRAINT `fk_event_cover` FOREIGN KEY (`cover_image_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `event_media`
--
ALTER TABLE `event_media`
ADD CONSTRAINT `fk_event_media_event` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk_event_media_media` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `event_notes`
--
ALTER TABLE `event_notes`
ADD CONSTRAINT `fk_event_note_admin` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`),
ADD CONSTRAINT `fk_event_note_event` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `gallery_items`
--
ALTER TABLE `gallery_items`
ADD CONSTRAINT `fk_gallery_media` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `media`
--
ALTER TABLE `media`
ADD CONSTRAINT `fk_media_admin` FOREIGN KEY (`uploaded_by`) REFERENCES `admins` (`id`);
--
-- Constraints for table `programmes`
--
ALTER TABLE `programmes`
ADD CONSTRAINT `fk_programme_cover` FOREIGN KEY (`cover_image_id`) REFERENCES `media` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `fk_programme_inner` FOREIGN KEY (`inner_image_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
ADD CONSTRAINT `fk_project_cover` FOREIGN KEY (`cover_image_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `team_members`
--
ALTER TABLE `team_members`
ADD CONSTRAINT `fk_team_photo` FOREIGN KEY (`photo_id`) REFERENCES `media` (`id`) ON DELETE SET NULL;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
![\"Convention](\"/RHIF/images/conference/cf-7.JPG\")
![\"Convention](\"/RHIF/images/conference/cf-1.JPG\")
![\"Convention](\"/RHIF/images/conference/cf-9.jpeg\")
![\"Convention](\"/RHIF/images/conference/cf-4.JPG\")
![\"Convention](\"/RHIF/images/conference/cf-10.jpeg\")
![\"Convention](\"/RHIF/images/conference/cf-8.JPG\")
![\"Educational](\"/RHIF/images/health-camp/h-15.jpeg\")
![\"Educational](\"/RHIF/images/education/ed-5.jpeg\")
![\"Community](\"/RHIF/images/health-camp/h-12.jpeg\")
![\"Educational](\"/RHIF/images/health-camp/h-18.jpeg\")
![\"SCD](\"/RHIF/images/conference/cf-5.JPG\")
![\"Sickle](\"/RHIF/images/sicklecell-run/sr-8.jpeg\")