-- Populate FAQ data for all 10 campaign niches
-- Run this after adding the FAQ fields

-- 10. Pest Control
UPDATE `campaigns` SET
  faq_1_question = 'How often should I have pest control service?',
  faq_1_answer = 'Quarterly service (every 3 months) provides best year-round protection against common pests. Some situations require monthly treatments initially, then can transition to quarterly maintenance. We\'ll recommend the right schedule for your needs.',
  faq_2_question = 'Are your pest control products safe for children and pets?',
  faq_2_answer = 'Yes! We use EPA-approved products and apply them according to strict safety protocols. We offer eco-friendly and botanical options for sensitive situations. Products are applied in targeted areas and dry quickly.',
  faq_3_question = 'How long does pest control treatment last?',
  faq_3_answer = 'Interior treatments typically last 60-90 days. Exterior barrier treatments last 90 days with quarterly reapplication. Effectiveness depends on pest pressure, weather, and property conditions. Our quarterly program provides continuous protection.',
  faq_4_question = 'What pests are covered in your general service?',
  faq_4_answer = 'Our general pest control covers ants, spiders, roaches, silverfish, crickets, and other common household pests. Specialized services are available for termites, bed bugs, rodents, mosquitoes, and wildlife.',
  faq_5_question = 'Do I need to leave my home during treatment?',
  faq_5_answer = 'For standard interior treatments, you can stay home. We treat specific areas while avoiding food prep surfaces. For specialized treatments like fogging or heat treatment for bed bugs, temporary evacuation may be required.',
  faq_6_question = 'How do you treat for termites?',
  faq_6_answer = 'We offer both liquid barrier treatments (Termidor) and bait station systems (Sentricon). Treatment choice depends on your home\'s construction and infestation severity. Both methods are effective - we\'ll recommend the best option for your situation.',
  faq_7_question = 'What should I do to prepare for pest control service?',
  faq_7_answer = 'Remove items from under sinks, pull appliances slightly from walls if treating kitchen, ensure access to all rooms, and remove pet bowls during treatment. We\'ll provide specific preparation instructions when scheduling service.',
  faq_8_question = 'Why do I still see pests after treatment?',
  faq_8_answer = 'Some pest activity is normal for 7-10 days as products work. Pests may emerge from hiding or travel through treated areas before dying. If you see activity beyond 2 weeks, contact us for a free re-treatment.',
  faq_9_question = 'Can you get rid of bed bugs?',
  faq_9_answer = 'Yes! We offer multiple bed bug treatment methods including heat treatment, chemical applications, and integrated approaches. Complete elimination typically requires 2-3 treatments. We provide detailed preparation instructions and treatment guarantees.',
  faq_10_question = 'Do you offer wildlife removal services?',
  faq_10_answer = 'Yes! We handle raccoons, squirrels, bats, opossums, and other nuisance wildlife through humane trapping and exclusion. We also seal entry points to prevent re-entry and provide damage repair and cleanup services.'
WHERE campaign_key = 'pest_control';

-- 11. Painting
UPDATE `campaigns` SET
  faq_1_question = 'How long does it take to paint a house interior?',
  faq_1_answer = 'A typical 1,500-2,000 sq ft home takes 3-5 days including prep work. Larger homes or those requiring extensive prep (repair, priming) may take 1-2 weeks. We provide detailed timelines during your estimate.',
  faq_2_question = 'What type of paint should I use?',
  faq_2_answer = 'We recommend Sherwin-Williams or Benjamin Moore premium paints. For interiors, use satin/eggshell in living areas, semi-gloss for trim and kitchens, and flat for ceilings. Exteriors require weather-resistant acrylic paints. We\'ll recommend the best products for each surface.',
  faq_3_question = 'Do I need to move my furniture?',
  faq_3_answer = 'We move and cover furniture as part of our service. You should remove small valuables, wall decor, and fragile items. We protect floors, furniture, and fixtures with drop cloths and plastic sheeting.',
  faq_4_question = 'How often should I repaint my home\'s exterior?',
  faq_4_answer = 'Most exteriors need repainting every 5-10 years depending on climate, sun exposure, and paint quality. Wood siding needs painting more frequently than vinyl or brick. We assess condition and recommend the right timing.',
  faq_5_question = 'Can you match my existing paint color?',
  faq_5_answer = 'Yes! We can match any existing color using paint matching technology. If you have the original paint can, brand and color name, or even a paint chip, we can create a perfect match.',
  faq_6_question = 'What\'s included in your painting prep work?',
  faq_6_answer = 'Prep includes cleaning surfaces, repairing holes/cracks, sanding rough areas, caulking gaps, priming bare wood or new drywall, and protecting floors/furniture. Proper prep is essential for quality, long-lasting results.',
  faq_7_question = 'Do you paint kitchen cabinets?',
  faq_7_answer = 'Yes! Cabinet painting is a cost-effective kitchen update. We remove doors/hardware, clean and sand all surfaces, apply primer and multiple coats of durable paint or lacquer, and reinstall everything. Results rival new cabinets at a fraction of the cost.',
  faq_8_question = 'Will paint fumes bother my family?',
  faq_8_answer = 'Modern low-VOC and zero-VOC paints have minimal odor and are safe when dry. We can schedule work when you\'re away if preferred. Ensure good ventilation during and after painting for comfort.',
  faq_9_question = 'How long before I can move furniture back?',
  faq_9_answer = 'Paint is dry to touch in 1-2 hours but needs 24 hours before moving furniture back. Full curing takes 30 days - avoid heavy scrubbing or placing items against walls during this time.',
  faq_10_question = 'Do you repair drywall before painting?',
  faq_10_answer = 'Yes! We repair holes, cracks, water damage, and texture damage as part of our prep work. Extensive damage may require additional charges, but we provide upfront pricing for all needed repairs.'
WHERE campaign_key = 'painting';
