-- OPTIONAL demonstration entries; all marked SAMPLE. Safe to import once.
INSERT INTO content(type,title,slug,summary,body,image_url,status,created_at,updated_at) VALUES
('project','Community Health Listening Programme','sample-community-health-listening','Illustrative project: listening to community priorities to shape practical research questions.','SAMPLE CONTENT — Replace this entry with an approved SAHRI project description, location, dates, partners, outputs and outcomes.','/assets/img/community-health.webp','published',NOW(),NOW()),
('project','Digital Health Access Lab','sample-digital-health-access','Illustrative concept exploring accessible digital tools for frontline health services.','SAMPLE CONTENT — Describe the real project scope, partners, ethics approvals, technologies and results when available.','/assets/img/hero-research.webp','published',NOW(),NOW()),
('project','Evidence to Action Partnership','sample-evidence-to-action','Illustrative collaboration concept connecting research insights with community-led decisions.','SAMPLE CONTENT — Replace with verified information before describing this as an active initiative.','/assets/img/community-health.webp','published',NOW(),NOW()),
('publication','Community-Centred Research: A Working Perspective','sample-community-centred-research','Sample publication entry demonstrating the research library layout.','SAMPLE CONTENT — This is not an actual published paper. Replace with a verified publication, DOI, author list and abstract.','/assets/img/hero-research.webp','published',NOW(),NOW()),
('news','Welcome to SAHRI','sample-welcome-to-sahri','Introducing a space for evidence, innovation and community health conversations.','SAMPLE CONTENT — This is demonstration copy, not an official announcement. Edit or remove before launch.','/assets/img/community-health.webp','published',NOW(),NOW()),
('news','Why community voices matter in health research','sample-community-voices','Exploring how community perspectives can inform better research questions.','SAMPLE CONTENT — An editorial placeholder to demonstrate the news layout. Replace with an approved article.','/assets/img/hero-research.webp','published',NOW(),NOW()),
('event','Community Research Exchange','sample-community-research-exchange','Illustrative event listing to demonstrate event management.','SAMPLE CONTENT — No event is scheduled. Replace with confirmed date, venue and programme.','/assets/img/community-health.webp','published',NOW(),NOW()),
('team','Research Team Profile','sample-research-team-profile','Placeholder team profile — replace with a real staff member and approved biography.','SAMPLE CONTENT — This is not a real person. Add approved role, credentials and portrait.','/assets/img/hero-research.webp','published',NOW(),NOW()),
('partner','Collaboration Opportunity','sample-collaboration-opportunity','Placeholder partner entry demonstrating the partnership page.','SAMPLE CONTENT — Not an existing partnership. Replace with confirmed partners and logos.','/assets/img/community-health.webp','published',NOW(),NOW())
ON DUPLICATE KEY UPDATE slug=slug;