-- =====================================================
-- Coastal Command Bin Cleaning - Content Updates Script
-- Purpose: Insert new content and update existing content from PDF
-- Date: 2026-01-26
-- Run AFTER content_archive.sql
-- =====================================================

-- =====================================================
-- SECTION 1: NEW CONTENT SECTIONS
-- =====================================================

-- About Us Section
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('about_us_title', 'About Us Title', 'About Us', 'text', 'active', 10),
('about_us_text', 'About Us Text', 'Coastal Command Bin Cleaning provides professional trash bin cleaning, sanitization, and power washing services throughout Florida. Our mission is to close the sanitation gap left by routine trash collection by delivering consistent, environmentally responsible cleaning that protects public health, prevents pest attraction, and extends the life of your property.', 'text', 'active', 11);

-- About the Owner Section (Joe Collins)
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('about_owner_title', 'About the Owner Title', 'About the Owner', 'text', 'active', 20),
('about_owner_name', 'About the Owner Name', 'Joe Collins', 'text', 'active', 21),
('about_owner_tagline', 'About the Owner Tagline', 'From the Beat to the Beach', 'text', 'active', 22),
('about_owner_text', 'About the Owner Text', 'Coastal Command Bin Cleaning was founded by Joe Collins, a retired law enforcement officer with a lifelong commitment to public service. After years of protecting his community, Joe identified another public safety concern hiding in plain sight—unsanitary trash bins that pose ongoing hygiene and environmental challenges. Today, he brings the same dedication, discipline, and integrity to sanitation services, helping safeguard homes and neighborhoods through preventative cleaning practices.', 'text', 'active', 23);

-- The Problem We Solve Section
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('problem_title', 'Problem Section Title', 'The Problem We Solve', 'text', 'active', 30),
('problem_text', 'Problem Section Text', 'Routine trash collection removes garbage but does not sanitize the containers that hold it. Residual waste, liquids, and organic debris left inside bins contribute to bacterial growth, persistent odors, pest attraction, and premature bin deterioration.', 'text', 'active', 31);

-- What Happens If Bins Are Not Cleaned
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('not_cleaned_title', 'Not Cleaned Section Title', 'What Happens If Trash Bins Are Not Cleaned', 'text', 'active', 40),
('not_cleaned_text', 'Not Cleaned Section Text', 'Without regular cleaning, trash bins become breeding grounds for harmful bacteria including E. coli, Salmonella, and Listeria. The warm, humid Florida climate accelerates decomposition and bacterial multiplication. Unclean bins attract rodents, flies, maggots, roaches, and other pests that can spread disease. Foul odors permeate garages, driveways, and outdoor spaces. Over time, acidic residue and biological buildup cause cracks, warping, and permanent damage to bins.', 'text', 'active', 41);

-- Why Monthly Cleaning Section (5 Reasons)
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('why_monthly_title', 'Why Monthly Title', 'Why Monthly Trash Bin Cleaning Is a Necessity in Florida', 'text', 'active', 50),
('why_monthly_intro', 'Why Monthly Intro', 'Florida''s year-round heat, humidity, and pest activity make regular bin cleaning essential—not optional.', 'text', 'active', 51),
('why_monthly_reason_1_title', 'Why Monthly Reason 1 Title', 'Stops Rapid Bacterial Buildup', 'text', 'active', 52),
('why_monthly_reason_1_text', 'Why Monthly Reason 1 Text', 'Decomposing food residue creates dangerous bacteria colonies within days. Monthly cleaning breaks this cycle before contamination spreads.', 'text', 'active', 53),
('why_monthly_reason_2_title', 'Why Monthly Reason 2 Title', 'Reduces Airborne Germ Exposure', 'text', 'active', 54),
('why_monthly_reason_2_text', 'Why Monthly Reason 2 Text', 'Every time you open a dirty bin, bacteria and mold spores become airborne. Regular sanitization protects your family during routine trash handling.', 'text', 'active', 55),
('why_monthly_reason_3_title', 'Why Monthly Reason 3 Title', 'Prevents Pest Infestations', 'text', 'active', 56),
('why_monthly_reason_3_text', 'Why Monthly Reason 3 Text', 'Odors and food residues attract rodents, roaches, flies, and maggots. Removing the source eliminates the attraction before infestations start.', 'text', 'active', 57),
('why_monthly_reason_4_title', 'Why Monthly Reason 4 Title', 'Eliminates Persistent Odors', 'text', 'active', 58),
('why_monthly_reason_4_text', 'Why Monthly Reason 4 Text', 'Surface sprays mask odors temporarily. Professional cleaning removes the organic matter causing the smell at its source.', 'text', 'active', 59),
('why_monthly_reason_5_title', 'Why Monthly Reason 5 Title', 'Protects Property and Environment', 'text', 'active', 60),
('why_monthly_reason_5_text', 'Why Monthly Reason 5 Text', 'Acidic residue damages bins, driveways, and garage floors. Regular cleaning extends the life of your containers and prevents contaminated runoff.', 'text', 'active', 61);

-- Who We Serve Section
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('who_we_serve_title', 'Who We Serve Title', 'Who We Serve', 'text', 'active', 70),
('who_we_serve_list', 'Who We Serve List', 'Residential homeowners|Apartment complexes and HOAs|Restaurants and retail businesses|Offices and commercial properties|Municipal and community organizations', 'text', 'active', 71);

-- Commitment to Sustainability Section
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('sustainability_title', 'Sustainability Title', 'Commitment to Compliance & Sustainability', 'text', 'active', 80),
('sustainability_text', 'Sustainability Text', 'Coastal Command Bin Cleaning operates in full compliance with Florida environmental regulations. Our wastewater is captured and disposed of responsibly—never discharged into storm drains or waterways. We use biodegradable, eco-friendly cleaning agents that are safe for families, pets, and the environment.', 'text', 'active', 81);

-- Sanitation Gap Section (Florida Market Positioning)
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('sanitation_gap_title', 'Sanitation Gap Title', 'Closing a Critical Sanitation Gap in Florida', 'text', 'active', 90),
('sanitation_gap_text', 'Sanitation Gap Text', 'While garbage collection removes waste, it does not address the ongoing hygiene risks of unsanitized containers. Coastal Command Bin Cleaning fills this gap with professional-grade cleaning designed specifically for Florida''s challenging climate. We help protect families, businesses, and communities through consistent, preventative sanitation services.', 'text', 'active', 91);

-- =====================================================
-- SECTION 2: UPDATE EXISTING CONTENT
-- =====================================================

-- Update Hero Section - Remove promotional messaging, add professional content
UPDATE content_sections SET content = 'From the Beat to the Beach' WHERE section_key = 'hero_promo_badge';
UPDATE content_sections SET content = 'Professional Trash Bin Cleaning, Sanitization & Power Washing' WHERE section_key = 'hero_title';
UPDATE content_sections SET content = 'Florida''s heat and humidity create ideal conditions for bacterial growth, pest attraction, and persistent odors in your trash bins. Coastal Command Bin Cleaning delivers professional sanitization services that protect your home, health, and property.' WHERE section_key = 'hero_subtitle';

-- Update Benefits/Why Choose Section
UPDATE content_sections SET content = 'Why Choose Coastal Command Bin Cleaning' WHERE section_key = 'benefits_title';
UPDATE content_sections SET content = 'Service-Driven Leadership' WHERE section_key = 'benefits_card_1_title';
UPDATE content_sections SET content = 'Founded by a retired law enforcement officer with a lifelong commitment to protecting communities through service and integrity.' WHERE section_key = 'benefits_card_1_desc';
UPDATE content_sections SET content = 'Prevention, Not Reaction' WHERE section_key = 'benefits_card_2_title';
UPDATE content_sections SET content = 'We focus on stopping bacterial buildup, pest attraction, and odors before they become problems—not just masking symptoms.' WHERE section_key = 'benefits_card_2_desc';
UPDATE content_sections SET content = 'Built for Florida' WHERE section_key = 'benefits_card_3_title';
UPDATE content_sections SET content = 'Our services are specifically designed for Florida''s year-round heat, humidity, and pest conditions that accelerate contamination.' WHERE section_key = 'benefits_card_3_desc';
UPDATE content_sections SET content = 'Environmentally Responsible' WHERE section_key = 'benefits_card_4_title';
UPDATE content_sections SET content = 'Eco-friendly cleaning agents, responsible wastewater recovery, and full compliance with Florida environmental regulations.' WHERE section_key = 'benefits_card_4_desc';

-- Add 5th benefit card for cost savings
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('benefits_card_5_title', 'Benefits Card 5 Title', 'Long-Term Cost Savings', 'text', 'active', 105),
('benefits_card_5_desc', 'Benefits Card 5 Description', 'Regular cleaning prevents damage, infestations, and premature bin replacement—reducing your long-term maintenance costs.', 'text', 'active', 106);

-- Update Footer About Text
UPDATE content_sections SET content = 'Coastal Command Bin Cleaning provides professional trash bin cleaning, sanitization, and power washing services throughout Florida. Founded by a retired law enforcement officer, we bring the same dedication to public service into every cleaning.' WHERE section_key = 'footer_about_text';

-- =====================================================
-- SECTION 3: INSERT NEW FAQ CONTENT (5 questions from PDF)
-- =====================================================

-- Note: The HTML will be updated to use these new FAQ entries
INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('faq_1_question', 'FAQ 1 Question', 'Is trash bin cleaning really necessary if my trash is picked up weekly?', 'text', 'active', 200),
('faq_1_answer', 'FAQ 1 Answer', 'Yes. Trash collection removes waste but does not sanitize the container. Residue, liquids, and organic debris left behind create ongoing bacterial growth, odors, and pest attraction between pickups.', 'text', 'active', 201),
('faq_2_question', 'FAQ 2 Question', 'How often should trash bins be cleaned in Florida?', 'text', 'active', 202),
('faq_2_answer', 'FAQ 2 Answer', 'Monthly cleaning is recommended due to Florida''s year-round heat and humidity, which accelerate bacterial growth and pest activity. Quarterly cleaning may be sufficient for low-use bins in cooler months.', 'text', 'active', 203),
('faq_3_question', 'FAQ 3 Question', 'Is this service worth the cost?', 'text', 'active', 204),
('faq_3_answer', 'FAQ 3 Answer', 'Professional bin cleaning prevents pest infestations, reduces health risks, eliminates odors, and extends the life of your bins. It often costs less than a single pest control visit or bin replacement.', 'text', 'active', 205),
('faq_4_question', 'FAQ 4 Question', 'Is the cleaning process environmentally responsible?', 'text', 'active', 206),
('faq_4_answer', 'FAQ 4 Answer', 'Yes. We use biodegradable, eco-friendly cleaning agents. All wastewater is captured and disposed of properly—never discharged into storm drains or waterways. We comply with all Florida environmental regulations.', 'text', 'active', 207),
('faq_5_question', 'FAQ 5 Question', 'Do I need to be home during service?', 'text', 'active', 208),
('faq_5_answer', 'FAQ 5 Answer', 'No. Simply leave your bins curbside on your scheduled service day. We clean, sanitize, and return them to your curb. You''ll receive notification when service is complete.', 'text', 'active', 209);

-- =====================================================
-- SECTION 4: SERVICE SECTION UPDATES (5 services)
-- =====================================================

INSERT INTO content_sections (section_key, section_name, content, content_type, status, position_order)
VALUES
('service_1_title', 'Service 1 Title', 'Residential Trash Bin Cleaning & Sanitization', 'text', 'active', 300),
('service_1_desc', 'Service 1 Description', 'Complete cleaning and sanitization for household trash and recycling bins. Eliminates bacteria, odors, and pest-attracting residue.', 'text', 'active', 301),
('service_2_title', 'Service 2 Title', 'Commercial Trash Bin & Dumpster Cleaning', 'text', 'active', 302),
('service_2_desc', 'Service 2 Description', 'Professional cleaning for businesses, restaurants, and commercial properties. Maintain hygiene standards and comply with health regulations.', 'text', 'active', 303),
('service_3_title', 'Service 3 Title', 'Pest & Odor Prevention Treatments', 'text', 'active', 304),
('service_3_desc', 'Service 3 Description', 'Specialized treatments that create an inhospitable environment for pests while neutralizing odors at their source.', 'text', 'active', 305),
('service_4_title', 'Service 4 Title', 'Power Washing Services', 'text', 'active', 306),
('service_4_desc', 'Service 4 Description', 'Professional pressure washing for driveways, patios, sidewalks, and exterior surfaces. Remove stains, mold, and buildup.', 'text', 'active', 307),
('service_5_title', 'Service 5 Title', 'Environmentally Responsible Wastewater Recovery', 'text', 'active', 308),
('service_5_desc', 'Service 5 Description', 'All wastewater is captured and properly disposed of—never discharged into storm drains. Full compliance with Florida environmental regulations.', 'text', 'active', 309);

-- =====================================================
-- VERIFICATION QUERIES (Run separately)
-- =====================================================
-- SELECT section_key, LEFT(content, 50) as content_preview FROM content_sections WHERE status = 'active' ORDER BY position_order;
-- SELECT COUNT(*) as new_sections FROM content_sections WHERE section_key LIKE 'about_%' OR section_key LIKE 'problem_%' OR section_key LIKE 'why_monthly_%';
