-- Sample Resources for Horizon Drilling Website
-- Run these INSERT statements to populate the resources table

INSERT INTO resources (title, description, resource_type, category, file_url, external_url, icon, display_order, status) VALUES

-- Guides
('Borehole Drilling Guide', 
 'A comprehensive guide to understanding borehole drilling, from site selection to maintenance. Learn about the drilling process, equipment used, and best practices for water well installation.',
 'guide', 
 'Drilling', 
 NULL, 
 NULL, 
 'fa-book', 
 1, 
 'active'),

('Solar Pump Installation Manual', 
 'Step-by-step manual for installing and maintaining solar-powered water pumps. Includes wiring diagrams, troubleshooting tips, and maintenance schedules.',
 'guide', 
 'Solar', 
 NULL, 
 NULL, 
 'fa-solar-panel', 
 2, 
 'active'),

('Water Quality Testing Guide', 
 'Learn how to test and maintain water quality in your borehole. Includes testing procedures, safety standards, and treatment recommendations.',
 'guide', 
 'Water Quality', 
 NULL, 
 NULL, 
 'fa-flask', 
 3, 
 'active'),

-- Documents
('Borehole Maintenance Checklist', 
 'Download our comprehensive maintenance checklist to keep your borehole operating at peak efficiency. Regular maintenance ensures long-term reliability.',
 'document', 
 'Maintenance', 
 'borehole_maintenance_checklist.pdf', 
 NULL, 
 'fa-file-pdf', 
 4, 
 'active'),

('Solar System Sizing Calculator', 
 'Calculate the right solar pump system size for your water needs. This Excel spreadsheet helps you determine panel capacity, battery requirements, and pump specifications.',
 'document', 
 'Solar', 
 'solar_sizing_calculator.xlsx', 
 NULL, 
 'fa-file-excel', 
 5, 
 'active'),

('Project Case Study: Community Water Project', 
 'Read about our successful community water project in rural Kenya. Learn how we provided clean water access to over 500 households.',
 'document', 
 'Case Studies', 
 'community_water_case_study.pdf', 
 NULL, 
 'fa-file-alt', 
 6, 
 'active'),

-- Videos
('Borehole Drilling Process Explained', 
 'Watch our detailed video explaining the complete borehole drilling process from start to finish. See our equipment in action and understand each step.',
 'video', 
 'Drilling', 
 NULL, 
 'https://www.youtube.com/watch?v=example1', 
 'fa-video', 
 7, 
 'active'),

('Solar Pump Installation Tutorial', 
 'Visual guide to installing a solar-powered water pump system. Perfect for DIY enthusiasts and professionals alike.',
 'video', 
 'Solar', 
 NULL, 
 'https://www.youtube.com/watch?v=example2', 
 'fa-play-circle', 
 8, 
 'active'),

-- Blog Posts (External Links)
('5 Signs Your Borehole Needs Maintenance', 
 'Learn to identify early warning signs that your borehole requires attention. Early detection can save you time and money.',
 'blog', 
 'Maintenance', 
 NULL, 
 'https://example.com/blog/borehole-maintenance-signs', 
 'fa-newspaper', 
 9, 
 'active'),

('Renewable Energy Solutions for Rural Communities', 
 'Explore how solar energy is transforming water access in rural areas. Real stories from communities we serve.',
 'blog', 
 'Solar', 
 NULL, 
 'https://example.com/blog/renewable-energy-rural', 
 'fa-blog', 
 10, 
 'active'),

-- External Links
('Water Resources Management Authority', 
 'Official website of the Water Resources Management Authority (WRMA) in Kenya. Access permits, regulations, and water resource information.',
 'link', 
 'Regulations', 
 NULL, 
 'https://www.wrma.or.ke', 
 'fa-external-link-alt', 
 11, 
 'active'),

('Kenya National Water Master Plan', 
 'Access the national water master plan document outlining Kenya water development strategy and policies.',
 'link', 
 'Policy', 
 NULL, 
 'https://example.com/national-water-plan', 
 'fa-link', 
 12, 
 'active'),

('Groundwater Mapping Resources', 
 'Interactive groundwater mapping tools and resources for Kenya. Find information about aquifers and water availability in your area.',
 'link', 
 'Research', 
 NULL, 
 'https://example.com/groundwater-mapping', 
 'fa-map', 
 13, 
 'active'),

-- More Guides
('Irrigation System Design Guide', 
 'Complete guide to designing efficient irrigation systems for agriculture. Learn about drip irrigation, sprinkler systems, and water management.',
 'guide', 
 'Irrigation', 
 NULL, 
 NULL, 
 'fa-tint', 
 14, 
 'active'),

('Home Solar System Buyer Guide', 
 'Everything you need to know before purchasing a home solar system. Compare options, understand costs, and make informed decisions.',
 'guide', 
 'Solar', 
 NULL, 
 NULL, 
 'fa-home', 
 15, 
 'active');