INSERT INTO site_settings (setting_key, setting_value) VALUES
('site_name', 'Pan African Centre for Climate Policy'),
('tagline', 'Climate action connecting communities in Africa and Canada.'),
('email', 'info@paccpolicy.org'),
('phone', '+233-302-942-565'),
('address', 'GM-001-399 Nikoi Atsen Avenue, Madina, Accra, Ghana'),
('facebook_url', 'https://www.facebook.com/paccpol'),
('linkedin_url', '#'),
('x_url', 'https://twitter.com/paccpolicy'),
('footer_text', 'We connect communities in Africa and Canada through climate policy, learning and locally led resilience.')
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value);

INSERT INTO homepage_slides (title, subtitle, image, cta_text, cta_url, is_active, display_order) VALUES
('Climate action, shaped across Africa and Canada.', 'We connect community knowledge, policy and learning to support a more resilient future across two continents.', '/assets/images/pacc/homepage-community.jpg', 'Explore our programmes', '/programmes', 1, 1),
('Climate solutions begin with local knowledge.', 'From Ghana to Canada, we work alongside communities, educators and partners to turn local insight into lasting climate resilience.', '/assets/images/pacc/hero-about.jpg', 'Explore our programmes', '/programmes', 1, 2)
ON DUPLICATE KEY UPDATE title = VALUES(title), subtitle = VALUES(subtitle), image = VALUES(image), cta_text = VALUES(cta_text), cta_url = VALUES(cta_url), is_active = VALUES(is_active), display_order = VALUES(display_order);

INSERT INTO programmes (title, slug, description, objectives, image, status, is_featured) VALUES
('Global Conference on Environmental Education & Lifelong Learning (EELL)', 'eell', 'An annual platform advancing environmental education and lifelong learning as vital tools for climate action and sustainability. EELL convenes educators, policymakers, activists and learners for dialogue, innovation and collaboration.', 'Promote environmental awareness; encourage lifelong learning; foster cross-sector collaboration; inform policy; and support community-led action.', '/assets/images/pacc/programme-eell.webp', 'published', 1),
('Eco-Connect', 'eco-connect', 'A community-led environmental education initiative based in Etobicoke North, Toronto. Eco-Connect works with BIPOC communities through multilingual learning resources, local Eco-Connect Ambassadors, neighbourhood clean-ups, eco-fairs and product swaps.', 'Make environmental learning accessible in local communities; share practical, safer and eco-friendly alternatives; support neighbourhood leadership; and advance environmental justice and health equity in Toronto.', '/assets/images/pacc/programme-eco-connect.png', 'published', 1),
('Regional Learning Hub – Africa', 'regional-learning-hub-africa', 'Voices of BIPOC and Racialized Communities: Building Environmental Justice from the Ground Up. This initiative centres community knowledge and amplifies marginalized women and youth.', 'Strengthen feminist and youth leadership; document community evidence; build inclusive learning networks; and bring local knowledge into climate governance.', '/assets/images/pacc/programme-learning-hub.jpg', 'published', 1)
ON DUPLICATE KEY UPDATE title = VALUES(title), description = VALUES(description), objectives = VALUES(objectives), image = VALUES(image), status = VALUES(status);

INSERT INTO publications (title, slug, author, abstract, cover_image, document_file, publication_date, status) VALUES
('Strengthening Ghana’s Climate (Environmental) Resilience: The Role of the Environmental Protection Authority (EPA)', 'strengthening-ghanas-climate-resilience-epa', 'EELL 2025 presentation', 'Presentation from the Global Conference on Environmental Education & Lifelong Learning.', '/assets/images/pacc/publication-epa.jpg', '/assets/documents/pacc/eell-2025-epa-resilience.pdf', '2025-12-12', 'published'),
('The Kahuzi-Biega – Itombwe Corridor for Landscape and Wildlife Restoration', 'kahuzi-biega-itombwe-corridor', 'EELL 2025 presentation', 'Conference presentation on landscape restoration and wildlife corridors.', '/assets/images/pacc/publication-restoration.jpg', '/assets/documents/pacc/kahuzi-itombwe-restoration.pdf', '2025-12-12', 'published'),
('Corporate Land Use and Indigenous Health: Uncovering the Public Health Burden of Resource Extraction', 'corporate-land-use-indigenous-health', 'EELL 2025 presentation', 'Conference presentation on land use, resource extraction and Indigenous health.', '/assets/images/pacc/publication-health.jpg', '/assets/documents/pacc/corporate-land-use-indigenous-health.pdf', '2025-12-12', 'published'),
('Assessing Urban Heat Island in West Africa', 'assessing-urban-heat-island-west-africa', 'EELL 2025 presentation', 'Research presentation on urban heat islands in West Africa.', '/assets/images/pacc/publication-heat.jpg', '/assets/documents/pacc/urban-heat-islands-west-africa.pdf', '2025-12-12', 'published'),
('AI in Green Business – Technology Meets Tradition, Innovation Meets Humanity', 'ai-in-green-business', 'Nancy Githumbi · EELL 2025', 'Presentation exploring the role of AI in green business and human-centred innovation.', '/assets/images/pacc/publication-ai-green-business.jpg', '/assets/documents/pacc/ai-in-green-business.pdf', '2025-12-12', 'published'),
('Culture, Care, and Climate: Africa’s Path to Environmental Stewardship and Empowerment', 'culture-care-and-climate', 'EELL 2025 presentation', 'A perspective on culture, care and environmental stewardship across Africa.', '/assets/images/pacc/publication-culture-care.jpg', '/assets/documents/pacc/culture-care-climate.pdf', '2025-12-12', 'published'),
('Reclaiming Narrative Sovereignty in the Age of Green Revolutions', 'reclaiming-narrative-sovereignty', 'EELL 2025 presentation', 'A decolonial critique of food security narratives and the coloniality of knowledge.', '/assets/images/pacc/publication-narrative.jpg', '/assets/documents/pacc/reclaiming-narrative-sovereignty.pdf', '2025-12-12', 'published'),
('Natural Farming in Andhra Pradesh, India: Importance, Models, and Impact', 'natural-farming-andhra-pradesh', 'EELL 2025 presentation', 'Research on natural farming models and their impact in Andhra Pradesh, India.', '/assets/images/pacc/publication-natural-farming.jpg', '/assets/documents/pacc/natural-farming-andhra-pradesh.pdf', '2025-12-12', 'published'),
('Behavioural Climate Action: The Missing Link in Sustainability', 'behavioural-climate-action', 'Neha Devapuja · EELL 2025', 'Presentation on behavioural approaches to climate action and sustainability.', '/assets/images/pacc/publication-behavioural.jpg', '/assets/documents/pacc/behavioural-climate-action.pdf', '2025-12-12', 'published'),
('Mining, Climate Change, and Sustainable Development: Balancing Resource Extraction with Environmental Resilience in Ghana', 'mining-climate-change-sustainable-development-ghana', 'EELL 2025 presentation', 'Presentation examining mining, climate change and sustainable development in Ghana.', '/assets/images/pacc/publication-mining.jpg', '/assets/documents/pacc/mining-climate-sustainable-development.pdf', '2025-12-12', 'published'),
('Greening Skills and Youth Empowerment Through TWESEP', 'greening-skills-youth-empowerment-twesep', 'Gideon Mumbai · EELL 2025', 'Presentation on green skills and youth empowerment through TWESEP.', '/assets/images/pacc/publication-greening-skills.jpg', '/assets/documents/pacc/greening-skills-twesep.pdf', '2025-12-12', 'published'),
('Cultivating Equity: The Shangani People and the Sugar Industry in Zimbabwe’s Lowveld', 'cultivating-equity-shangani-sugar-industry', 'EELL 2025 presentation', 'A presentation on equity, the Shangani people and the sugar industry in Zimbabwe’s Lowveld.', '/assets/images/pacc/publication-cultivating-equity.png', '/assets/documents/pacc/cultivating-equity-shangani.pdf', '2025-12-12', 'published'),
('Creating Funding for Girls’ Education Through Green Bonds', 'funding-girls-education-green-bonds', 'EELL 2025 presentation', 'A proposal linking green bonds, girls’ education, climate mitigation and population growth.', '/assets/images/pacc/publication-girls-education.png', '/assets/documents/pacc/girls-education-green-bonds.pdf', '2025-12-12', 'published'),
('Women’s Recognition and Involvement in REDD+ and Other Policy Processes in the Bimbia Bonadikombo Community Forest, Cameroon', 'womens-recognition-involvement-redd-cameroon', 'PACC Policy research', 'Research on women’s participation in forest and climate policy processes in Cameroon.', '/assets/images/pacc/brand-logo-footer.png', '/assets/documents/pacc/women-redd-cameroon.pdf', '2025-12-12', 'published')
ON DUPLICATE KEY UPDATE title = VALUES(title), abstract = VALUES(abstract), cover_image = VALUES(cover_image), document_file = VALUES(document_file), status = VALUES(status);

INSERT INTO events (title, slug, description, event_date, event_time, venue, registration_url, cover_image, status) VALUES
('EELL Accra Conference 2026', 'eell-accra-conference-2026', 'The 2026 African regional gathering of the Global Conference on Environmental Education & Lifelong Learning. This conference has concluded.', '2026-07-23', '09:00:00', 'Accra, Ghana', 'https://env-edu-learning.ca/eell-2026-african-region-conference/', '/assets/images/pacc/hero-eell-2026.jpg', 'published'),
('EELL Toronto Conference 2026', 'eell-toronto-conference-2026', 'The 2026 North American gathering of the Global Conference on Environmental Education & Lifelong Learning, held October 15–16. This conference has concluded.', '2026-10-15', '09:00:00', 'Toronto, Canada', 'https://env-edu-learning.ca/eell-2026-north-american-conference/', '/assets/images/pacc/hero-about.jpg', 'published')
ON DUPLICATE KEY UPDATE title = VALUES(title), description = VALUES(description), venue = VALUES(venue), registration_url = VALUES(registration_url), cover_image = VALUES(cover_image), status = VALUES(status);