-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 12, 2025 at 03:43 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.1.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `home_services_leads`
--

-- --------------------------------------------------------

--
-- Table structure for table `campaigns`
--

CREATE TABLE `campaigns` (
  `id` int(11) NOT NULL,
  `campaign_key` varchar(50) NOT NULL,
  `campaign_name` varchar(100) NOT NULL,
  `service_type` varchar(50) NOT NULL,
  `headline` varchar(200) NOT NULL,
  `subheadline` varchar(200) NOT NULL,
  `primary_cta` varchar(100) NOT NULL,
  `secondary_cta` varchar(100) NOT NULL,
  `hero_title` varchar(200) NOT NULL,
  `hero_subtitle` varchar(300) NOT NULL,
  `bullet_1` varchar(150) NOT NULL,
  `bullet_2` varchar(150) NOT NULL,
  `bullet_3` varchar(150) NOT NULL,
  `bullet_4` varchar(150) NOT NULL,
  `bullet_5` varchar(150) NOT NULL,
  `bullet_6` varchar(150) NOT NULL,
  `bullet_7` varchar(150) NOT NULL,
  `why_us` varchar(100) NOT NULL,
  `why_us_text` text NOT NULL,
  `award_1` varchar(150) NOT NULL,
  `award_2` varchar(150) NOT NULL,
  `award_3` varchar(150) NOT NULL,
  `award_4` varchar(150) NOT NULL,
  `award_5` varchar(150) NOT NULL,
  `services_title` varchar(100) NOT NULL,
  `service_1_title` varchar(100) NOT NULL,
  `service_1_description` text NOT NULL,
  `service_2_title` varchar(100) NOT NULL,
  `service_2_description` text NOT NULL,
  `service_3_title` varchar(100) NOT NULL,
  `service_3_description` text NOT NULL,
  `service_4_title` varchar(100) NOT NULL,
  `service_4_description` text NOT NULL,
  `service_5_title` varchar(100) NOT NULL,
  `service_5_description` text NOT NULL,
  `service_6_title` varchar(100) NOT NULL,
  `service_6_description` text NOT NULL,
  `mid_headline` varchar(150) NOT NULL,
  `mid_subheadline` varchar(150) NOT NULL,
  `brand_headline` varchar(150) NOT NULL,
  `process_headline` varchar(150) NOT NULL,
  `process_1_headline` varchar(150) NOT NULL,
  `process_1` text NOT NULL,
  `process_2_headline` varchar(150) NOT NULL,
  `process_2` text NOT NULL,
  `process_3_headline` varchar(150) NOT NULL,
  `process_3` text NOT NULL,
  `bottom_headline` varchar(150) NOT NULL,
  `bottom_subheadline` text NOT NULL,
  `reviews_title` varchar(150) NOT NULL,
  `mon_hours` varchar(20) NOT NULL,
  `tue_hours` varchar(20) NOT NULL,
  `wed_hours` varchar(20) NOT NULL,
  `thur_hours` varchar(20) NOT NULL,
  `fri_hours` varchar(20) NOT NULL,
  `sat_hours` varchar(20) NOT NULL,
  `sun_hours` varchar(20) NOT NULL,
  `mon_24` tinyint(1) NOT NULL DEFAULT 0,
  `tue_24` tinyint(1) NOT NULL DEFAULT 0,
  `wed_24` tinyint(1) NOT NULL DEFAULT 0,
  `thur_24` tinyint(1) NOT NULL DEFAULT 0,
  `fri_24` tinyint(1) NOT NULL DEFAULT 0,
  `sat_24` tinyint(1) NOT NULL DEFAULT 0,
  `sun_24` tinyint(1) NOT NULL DEFAULT 0,
  `color_primary` varchar(9) NOT NULL,
  `color_secondary` varchar(9) NOT NULL,
  `color_accent` varchar(9) NOT NULL,
  `color_background` varchar(9) NOT NULL,
  `color_header_bg` varchar(9) DEFAULT NULL COMMENT 'Header/navigation background - defaults to darkened primary',
  `color_button_hover` varchar(9) DEFAULT NULL COMMENT 'Button hover state - defaults to slightly darker primary',
  `color_cta_background` varchar(9) DEFAULT NULL COMMENT 'CTA button background - defaults to secondary',
  `color_bullet` varchar(9) DEFAULT NULL COMMENT 'Bullet points/icons - defaults to accent',
  `color_form_bg` varchar(9) DEFAULT NULL COMMENT 'Form background with alpha transparency',
  `color_overlay` varchar(9) DEFAULT NULL COMMENT 'Hero image overlay for text readability',
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `campaigns`
--

INSERT INTO `campaigns` (`id`, `campaign_key`, `campaign_name`, `service_type`, `headline`, `subheadline`, `primary_cta`, `secondary_cta`, `hero_title`, `hero_subtitle`, `bullet_1`, `bullet_2`, `bullet_3`, `bullet_4`, `bullet_5`, `bullet_6`, `bullet_7`, `why_us`, `why_us_text`, `award_1`, `award_2`, `award_3`, `award_4`, `award_5`, `services_title`, `service_1_title`, `service_1_description`, `service_2_title`, `service_2_description`, `service_3_title`, `service_3_description`, `service_4_title`, `service_4_description`, `service_5_title`, `service_5_description`, `service_6_title`, `service_6_description`, `mid_headline`, `mid_subheadline`, `brand_headline`, `process_headline`, `process_1_headline`, `process_1`, `process_2_headline`, `process_2`, `process_3_headline`, `process_3`, `bottom_headline`, `bottom_subheadline`, `reviews_title`, `mon_hours`, `tue_hours`, `wed_hours`, `thur_hours`, `fri_hours`, `sat_hours`, `sun_hours`, `mon_24`, `tue_24`, `wed_24`, `thur_24`, `fri_24`, `sat_24`, `sun_24`, `color_primary`, `color_secondary`, `color_accent`, `color_background`, `color_header_bg`, `color_button_hover`, `color_cta_background`, `color_bullet`, `color_form_bg`, `color_overlay`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'hvac', 'HVAC Services', 'HVAC', '0% Down On New AC Installations & Replacements', 'Call Us Or Fill Out The Form For A FREE No Obligation Quote', 'Get A Free Estimate', 'View Our Services', 'A Customer Focused Approach To Your Comfort', 'Every Year, Hundreds Of Happy Customers Choose our AC experts.', '0% Interest For 72 Months', 'Up To 20% Off Select HVAC Systems', '10 Year Labor & Parts Warranty', '<strong>100% Fixed Pricing</strong> - No Hidden Costs', '99% Of Installs Completed The Same Day', 'FREE Old System Removal and Disposal', 'Licensed, Bonded & Insured For Your Piece Of Mind', 'Why We Are The Best For Your AC Repair & Installation', 'We know that customers want to hire an HVAC company that exhibits integrity and employs contractors who are willing to listen to customer needs and answer questions in a way they can understand.<br><br>That’s why we’ve focused on building the best heating and cooling service team around!  Animated call button to attract more attention to your website visitors.', 'Angies List Super Service Award (2018 - 2021)', 'BBB Accredited Business', 'Train Partner Of The Year Austin, Tx (2020, 2021)', '', '', 'Our Featured Services', 'AC Installation & Repair', 'Stay cool all summer with our expert air conditioning services. We install and repair all major brands.', 'Heating Services', 'Keep your home warm and comfortable with our reliable heating solutions and 24/7 emergency repairs.', 'Maintenance Plans', 'Protect your investment with regular maintenance. Our plans keep your system running efficiently year-round.', 'Indoor Air Quality', 'Breathe easier with our air quality solutions including purifiers, humidifiers, and duct cleaning.', 'Heat Pumps', 'We provide a wide-range of ultra-high-efficiency heat pumps that utilize advanced modulating technology to deliver the ultimate in  comfort and energy savings, even when it’s very cold outside. ', 'Alternative Energy', 'Our experts are ready to take you off the grid with cost-effective, sustainable alternative energy solutions like a solar energy system with a whole-home battery backup. ', '0% Down On New AC Installations & Replacements', 'Call Us Or Fill Out The Form For A FREE No Obligation Quote', 'We Work With The Best Brands', 'What Happens Next, Our Proven Process<br>To keeping Your Family Comfortable', 'Call Us For Service Or Repair & Book An Appointment', 'You will get advice and pricing upfront before before you agree to go with any installation or repair service.', 'High Quality Installs Or Repairs With Workmanship Guarantee', 'Once you have agreed to move forward, our friendly team comes out to your home and gets the job done.', 'Keep Your Home Running Smooth With No Mess Left Behind', 'Most of our installation and repairs are completed the same day so you can stay cool and comfortable.', 'Your Families Comfort Is Our Top Priority', 'Whether You Need A New AC System Or Repair Your Existing System We Here For you!', 'Here\'s What Our Customers Have To Say', '8AM-5PM', '8AM-5PM', '8AM-5PM', '8AM-5PM', '8AM-5PM', 'Closed', 'Closed', 1, 1, 1, 1, 1, 1, 1, '#1E40AF', '#3B82F6', '#60A5FA', '#F8FAFC', '#192029', '#1A3A9F', '#3B82F6', '#60A5FA', '#FFFFFFA8', '#00000099', 1, '2025-11-20 15:04:24', '2025-12-11 12:36:19'),
(2, 'plumbing', 'Plumbing Services', 'Plumbing', 'Emergency Plumbing Services Available 24/7', 'Fast, Reliable Service From Licensed Plumbers You Can Trust', 'Schedule Service', 'Emergency Service Types', 'Your Local Plumbing Experts Ready To Help', 'Every Year, Hundreds Of Happy Customers Choose Our Expert Plumbing Services', 'Same-Day Emergency Service Available', 'Upfront Pricing - No Hidden Fees', 'Lifetime Warranty On Workmanship', '<strong>Licensed & Insured</strong> Professional Plumbers', 'Background Checked Technicians', 'Senior & Military Discounts Available', 'Clean, Courteous Service Guaranteed', 'Why Choose Our Plumbing Services', 'We know that plumbing emergencies are stressful and inconvenient. That\'s why we focus on providing fast, reliable service from licensed plumbers who treat your home with respect.<br><br>Our team arrives on time, diagnoses the problem quickly, and provides upfront pricing before any work begins. No surprises, no hidden fees - just honest, professional plumbing service you can trust.', 'BBB A+ Rated Plumbing Company', 'Angie\'s List Super Service Award', 'HomeAdvisor Top Rated Professional', 'Best of [City] Plumber (2022, 2023)', 'Master Plumber Certified Technicians', 'Complete Plumbing Solutions', 'Emergency Plumbing Repairs', 'Plumbing emergencies don\'t wait. We offer 24/7 emergency service for burst pipes, major leaks, sewer backups, and more. Our rapid response team is ready when you need us most.', 'Drain Cleaning & Clog Removal', 'Stubborn clogs and slow drains driving you crazy? Our professional drain cleaning service uses advanced equipment to clear blockages and get your pipes flowing smoothly again.', 'Water Heater Installation & Repair', 'From traditional tank water heaters to energy-efficient tankless systems, we handle all types of water heater installation, repair, and maintenance to keep your hot water flowing.', 'Leak Detection & Repair', 'Hidden leaks can cause serious damage. Our leak detection specialists use advanced technology to locate and repair leaks in walls, under slabs, and in hard-to-reach areas.', 'Fixture Installation & Upgrades', 'Upgrade your home with new faucets, toilets, sinks, and shower fixtures. Our expert installation ensures proper function and a professional finish that enhances your home\'s value.', 'Sewer Line Services', 'From routine cleaning to complete sewer line replacement, we handle all your sewer and main line needs with minimal disruption to your property using trenchless technology when possible.', 'Emergency Plumbing Services Available 24/7', 'Fast Response Times - Upfront Pricing - Licensed Plumbers', 'We Work With Premium Brands You Trust', 'Our Simple 3-Step Process<br>To Solving Your Plumbing Problems Fast', 'Call Us & Schedule Your Service Appointment', 'Contact us by phone or online and we\'ll schedule a convenient appointment time. For emergencies, we offer same-day service and can often arrive within hours.', 'Expert Diagnosis With Upfront Pricing', 'Our licensed plumber arrives on time, diagnoses the problem, and provides clear upfront pricing before any work begins. You\'ll know exactly what to expect - no surprises.', 'Professional Repair With Lifetime Warranty', 'Once you approve the work, we complete the repair efficiently and clean up completely. Every job is backed by our lifetime workmanship warranty for your peace of mind.', 'Reliable Plumbing Solutions For Your Home', 'Whether You Need Emergency Repairs Or New Installation We\'re Here For You!', 'What Our Plumbing Customers Say', '7AM-7PM', '7AM-7PM', '7AM-7PM', '7AM-7PM', '7AM-7PM', '8AM-4PM', 'Emergency Only', 1, 1, 1, 1, 1, 1, 1, '#1E40AF', '#0284C7', '#38BDF8', '#F0F9FF', '#192029', '#1A3A9F', '#3B82F6', '#60A5FA', '#FFFFFFA8', '#00000099', 1, '2025-11-20 15:04:24', '2025-12-11 12:36:26'),
(3, 'electrical', 'Electrical Services', 'Electrical', 'Licensed Electrical Contractors Serving Your Area', 'Safe, Code-Compliant Electrical Solutions For Home & Business', 'Free Quote', 'Some Services Offered', 'Expert Electrical Services You Can Depend On', 'Every Year, Hundreds Of Satisfied Customers Trust Our Licensed Electricians', 'Licensed, Bonded & Insured Electricians', 'Same-Day Service Available', 'Lifetime Warranty On Our Work', '<strong>Safety First</strong> - Code Compliant Installations', 'Upfront Flat-Rate Pricing', 'Background Checked Technicians', 'Emergency Electrical Services 24/7', 'Why Trust Our Electrical Services', 'Electrical work requires expertise, precision, and a commitment to safety. Our licensed electricians have the training and experience to handle any electrical project safely and correctly.<br><br>We stay current with all electrical codes, use quality materials, and stand behind our work with a lifetime warranty. When you choose us, you\'re choosing peace of mind knowing the job is done right.', 'Master Electrician Certified', 'BBB Accredited Business A+ Rating', 'Angie\'s List Super Service Award', 'HomeAdvisor Elite Service Provider', 'Best Electrician [City] (2022, 2023)', 'Professional Electrical Services', 'Electrical Repairs & Troubleshooting', 'From flickering lights to faulty outlets and circuit breaker issues, we diagnose and repair all electrical problems safely and efficiently. Our electricians get to the root cause fast.', 'Electrical Panel Upgrades', 'Outdated electrical panel causing problems? We upgrade panels to meet modern power demands, improve safety, and ensure your home can handle today\'s electrical needs.', 'Indoor & Outdoor Lighting', 'Enhance your home or business with professional lighting installation. From recessed lighting to landscape illumination, we design and install lighting that transforms your space.', 'Whole Home Wiring & Rewiring', 'Safe, code-compliant wiring for new construction, additions, and whole-home rewiring projects. We ensure your electrical system meets all current safety standards.', 'Generator Installation & Service', 'Never lose power again with a standby generator. We install and service both portable and whole-home generators to keep your lights on during outages.', 'EV Charger Installation', 'Ready to charge your electric vehicle at home? We install Level 2 EV charging stations with proper wiring and dedicated circuits for fast, safe charging.', 'Licensed Electrical Contractors Serving Your Area', 'Safe, Professional Service - Code Compliant - Lifetime Warranty', 'We Install Premium Electrical Products', 'Our Proven Electrical Service Process<br>Ensuring Safety & Quality Every Step', 'Schedule Your Electrical Service Call', 'Call or book online and we\'ll schedule a convenient time for your service. For electrical emergencies, we offer 24/7 availability and rapid response.', 'Expert Diagnosis & Transparent Pricing', 'Our licensed electrician inspects your system, explains the issue clearly, and provides upfront flat-rate pricing. You approve the work before we start.', 'Safe Installation With Lifetime Warranty', 'We complete the work safely, to code, and efficiently. All work is inspected and cleaned up completely. Every job includes our lifetime workmanship warranty.', 'Safe And Reliable Electrical Service You Can Trust', 'Whether You Need Panel Upgrades Or Rewiring We\'re Here For You!', 'Electrical Service Customer Reviews', '7AM-6PM', '7AM-6PM', '7AM-6PM', '7AM-6PM', '7AM-6PM', '8AM-3PM', 'Emergency Only', 0, 0, 0, 0, 0, 0, 0, '#CA8A04', '#EA580C', '#FB923C', '#FFF7ED', '#7C3A00', '#B47804', '#F59E0B', '#FCD34D', '#FFFFFFA8', '#00000099', 1, '2025-11-20 15:04:25', '2025-12-11 12:36:08'),
(4, 'roofing', 'Roofing Services', 'Roofing', 'Expert Roofing Contractors Protecting<br>Your Home', 'Quality Roof Installation, Repair & Replacement Since [Year]', 'Get Estimate', 'Emergency Services', 'Your Trusted Roofing Experts', 'Every Year, Hundreds Of Homeowners Choose Our Professional Roofing Services', 'Manufacturer Certified Installers', 'Lifetime Workmanship Warranty', 'FREE Roof Inspections & Estimates', '<strong>Insurance Claim Specialists</strong> - We Handle The Paperwork', '50-Year Material Warranties Available', 'Licensed, Bonded & Insured', 'Emergency Storm Damage Repairs', 'Why Choose Our Roofing Company', 'Your roof is your home\'s first line of defense against the elements. We take roof installation and repair seriously, using only premium materials and certified installation techniques.<br><br>Our roofing contractors are factory-trained and certified, ensuring your roof is installed correctly the first time. We stand behind our work with industry-leading warranties and a commitment to your complete satisfaction.', 'GAF Master Elite Certified Contractor', 'Owens Corning Preferred Contractor', 'BBB A+ Accredited Business', 'Best Roofer [City] (2021, 2022, 2023)', 'Angie\'s List Super Service Award', 'Complete Roofing Solutions', 'Roof Replacement & Installation', 'Complete roof replacement with premium materials and expert installation. We work with all major brands and help navigate insurance claims for storm damage replacement.', 'Roof Repair & Storm Damage', 'From minor leaks to major storm damage, our emergency repair services protect your home from further damage. We respond quickly and repair it right the first time.', 'Roof Inspections & Maintenance', 'Comprehensive roof inspections identify problems early before they become expensive repairs. Free inspections include detailed reports with photos and maintenance recommendations.', 'Gutter Installation & Repair', 'Protect your roof and foundation with professional gutter installation, repair, and gutter guard systems. Proper drainage extends your roof\'s life and prevents water damage.', 'Skylight Installation', 'Bring natural light into your home with professionally installed skylights. We install Velux and other premium brands with proper flashing to prevent leaks.', 'Ventilation & Insulation', 'Proper attic ventilation and insulation extend your roof\'s life and reduce energy costs. We assess and upgrade your attic system for optimal performance.', 'Expert Roofing Contractors Protecting Your Home', 'Certified Installers - Premium Materials - Lifetime Warranty', 'We Install The Best Roofing Brands', 'Our Professional Roofing Process<br>From Inspection To Final Cleanup', 'Free Roof Inspection & Detailed Estimate', 'We provide a thorough roof inspection with photos and a detailed written estimate. For insurance claims, we\'ll meet with your adjuster and handle the paperwork.', 'Quality Installation By Certified Crews', 'Our certified roofing crews arrive on schedule and work efficiently. We use premium materials and follow manufacturer specifications for proper installation.', 'Final Inspection & Complete Cleanup', 'We conduct a final inspection to ensure quality, then clean up completely using magnetic sweepers. Your new roof comes with both material and workmanship warranties.', 'Protecting Your Home With Quality Roofing', 'Whether You Need A New Roof Or Storm Damage Repair We\'re Here For You!', 'Homeowner Roofing Reviews', '7AM-5PM', '7AM-5PM', '7AM-5PM', '7AM-5PM', '7AM-5PM', '8AM-12PM', 'Closed', 0, 0, 0, 0, 0, 0, 0, '#7C2D12', '#BE185D', '#F472B6', '#FDF2F8', '#431407', '#6B2712', '#B45309', '#EA580C', '#FFFFFFA8', '#00000099', 1, '2025-11-20 15:04:25', '2025-12-11 12:36:00'),
(5, 'landscaping', 'Landscaping Services', 'Landscaping', 'Professional Landscaping & Lawn Care Services', 'Creating Beautiful Outdoor Spaces You\'ll Love For Years', 'Get Quote', 'View Portfolio', 'Transform Your Outdoor Living Space', 'Every Year, Hundreds Of Happy Customers Trust Our Landscaping Expertise', 'Custom Landscape Design Services', 'Weekly & Bi-Weekly Maintenance Plans', 'Licensed Landscape Contractors', '<strong>Satisfaction Guaranteed</strong> On Every Project', 'Year-Round Service Including Snow Removal', 'FREE Estimates & Design Consultations', 'Eco-Friendly & Sustainable Practices', 'Why Choose Our Landscaping Services', 'We\'re passionate about creating beautiful outdoor spaces that enhance your home\'s curb appeal and provide enjoyment for years to come. Our team combines creative design with horticultural expertise.<br><br>From initial concept to final installation and ongoing maintenance, we handle every detail with professionalism and care. Your satisfaction is our priority, and we won\'t rest until you love your outdoor space.', 'Landscape Design Excellence Award', 'BBB A+ Accredited Business', 'Best of [City] Landscaper (2022, 2023)', 'Certified Landscape Professional', 'Angie\'s List Super Service Award', 'Complete Landscaping Services', 'Custom Landscape Design & Installation', 'Transform your property with custom landscape design that enhances beauty and value. From concept drawings to complete installation, we bring your vision to life.', 'Lawn Care & Maintenance Programs', 'Keep your lawn healthy and beautiful year-round with our comprehensive maintenance programs. Mowing, edging, trimming, fertilization, and weed control included.', 'Hardscaping & Outdoor Living', 'Create stunning outdoor living spaces with custom patios, walkways, retaining walls, fire pits, and outdoor kitchens. Quality materials and expert craftsmanship.', 'Irrigation System Installation', 'Professional irrigation system design and installation keeps your landscape healthy while conserving water. We install, repair, and maintain all major brands.', 'Seasonal Cleanup & Services', 'Year-round property care including spring cleanup, mulching, fall leaf removal, winter snow removal, and seasonal plantings to keep your property looking its best.', 'Tree & Shrub Care', 'Professional tree and shrub pruning, trimming, fertilization, and disease treatment. We keep your trees healthy and your landscape looking manicured and beautiful.', 'Professional Landscaping & Lawn Care Services', 'Custom Design - Expert Installation - Year-Round Maintenance', 'We Use Premium Landscaping Products', 'Our Landscaping Process<br>From Design To Beautiful Results', 'Free Consultation & Custom Design', 'We meet at your property to discuss your vision, assess the space, and understand your budget. Then we create a custom design plan with plant selections and materials.', 'Professional Installation By Experts', 'Our experienced landscaping crews bring the design to life with attention to detail and quality craftsmanship. We communicate throughout the project to ensure satisfaction.', 'Ongoing Care & Maintenance Support', 'After installation, we provide guidance on care and offer maintenance programs to keep your landscape looking beautiful. We\'re here for the long term.', 'Transform Your Outdoor Space Into Paradise', 'Whether You Need Complete Landscape Design Or Regular Maintenance We\'re Here For You!', 'What Our Landscaping Clients Say', '7AM-5PM', '7AM-5PM', '7AM-5PM', '7AM-5PM', '7AM-5PM', '8AM-2PM', 'Closed', 0, 0, 0, 0, 0, 0, 0, '#15803D', '#15803D', '#4ADE80', '#F0FDF4', '#0F3A21', '#166534', '#22C55E', '#4ADE80', '#FFFFFFA8', '#00000099', 1, '2025-11-20 15:04:25', '2025-12-11 12:35:53'),
(6, 'carpet_cleaning', 'Carpet Cleaning Services', 'Carpet Cleaning', 'Professional Carpet & Upholstery Cleaning Services', 'Deep Cleaning That Removes Dirt, Stains & Allergens', 'Book Now', 'Get Quote', 'Cleaner Carpets, Healthier Home', 'Every Year, Hundreds Of Families Trust Our Professional Cleaning Services', 'Truck-Mounted Steam Cleaning Equipment', 'Eco-Friendly, Pet & Child Safe Products', '100% Satisfaction Guarantee', '<strong>Same-Day Service</strong> Available', 'Free Stain & Odor Treatment', 'Licensed & Insured Technicians', 'Carpet Protector Application Available', 'Why Choose Our Carpet Cleaning Service', 'We understand that your carpets are a significant investment in your home or business. That\'s why we use professional truck-mounted equipment and proven cleaning methods that deep clean without over-wetting.<br><br>Our certified technicians are trained in the latest cleaning techniques and use eco-friendly products that are safe for your family and pets. We don\'t just clean the surface - we extract deep-down dirt and allergens for a truly clean carpet.', 'IICRC Certified Technicians', 'BBB A+ Accredited Business', 'Angie\'s List Super Service Award', 'Best Carpet Cleaner [City] (2022, 2023)', 'Carpet & Rug Institute Certified', 'Professional Cleaning Services', 'Carpet Deep Cleaning', 'Our professional truck-mounted hot water extraction removes embedded dirt, stains, and allergens. We pre-treat problem areas and ensure fast drying times.', 'Upholstery Cleaning', 'Restore your furniture to like-new condition with professional upholstery cleaning. We clean all fabric types safely and effectively, including delicate materials.', 'Pet Stain & Odor Removal', 'Specialized enzymatic treatments break down pet urine and eliminate odors at the source. We handle even the toughest pet stains and odors with guaranteed results.', 'Area Rug Cleaning', 'Professional area rug cleaning for all rug types including Oriental, Persian, and wool rugs. We offer pickup, cleaning, and delivery service for your valuable rugs.', 'Tile & Grout Cleaning', 'Restore dingy tile and grout to original beauty with high-pressure steam cleaning. We clean and seal grout lines to prevent future staining and make cleaning easier.', 'Commercial Carpet Cleaning', 'Professional commercial carpet cleaning for offices, retail spaces, and commercial properties. We work around your schedule with evening and weekend appointments available.', 'Professional Carpet & Upholstery Cleaning Services', 'Deep Cleaning - Fast Drying - Safe Products - Satisfaction Guaranteed', 'We Use Professional Grade Equipment', 'Our Professional Cleaning Process<br>For Outstanding Results Every Time', 'Schedule Your Cleaning Appointment', 'Call or book online for a convenient appointment time. We offer same-day service and provide upfront pricing with no hidden fees or charges.', 'Pre-Treatment & Deep Cleaning', 'We pre-vacuum, pre-treat stains, then deep clean using truck-mounted equipment for maximum soil extraction. Problem areas get extra attention.', 'Final Inspection & Speed Drying', 'We inspect the results with you and address any concerns immediately. Our powerful extraction ensures fast drying - typically 4-6 hours. 100% satisfaction guaranteed.', 'Fresh Clean Carpets For A Healthier Home', 'Whether You Need Deep Cleaning Or Stain Removal We\'re Here For You!', 'Customer Carpet Cleaning Reviews', '8AM-6PM', '8AM-6PM', '8AM-6PM', '8AM-6PM', '8AM-6PM', '9AM-3PM', 'Closed', 0, 0, 0, 0, 0, 0, 0, '#0891B2', '#9333EA', '#C084FC', '#FAF5FF', '#134E4A', '#0D7B7A', '#14B8A6', '#5EEAD4', '#FFFFFFA8', '#00000099', 1, '2025-11-20 15:04:25', '2025-12-11 12:35:43'),
(7, 'windows_doors', 'Window and Doors', 'Windows Doors', 'Energy-Efficient Window & Door Replacement', 'Improve Comfort, Lower Energy Bills, Increase Home Value', '', 'View Service Types', 'Premium Windows & Doors Installed Right', 'Every Year, Hundreds Of Homeowners Choose Our Expert Installation Services', 'Lifetime Warranty On Installation', 'Energy Star Certified Products', 'FREE In-Home Estimates', '<strong>Factory Certified</strong> Installers', 'Financing Options Available', 'Licensed, Bonded & Insured', 'Custom Sizes & Styles Available', 'Why Choose Our Window & Door Installation', 'New windows and doors are a significant investment in your home. We take installation seriously, using factory-certified techniques that ensure proper fit, energy efficiency, and long-lasting performance.<br><br>Our professional installers are trained and certified by leading manufacturers. We handle every detail from precise measurements to final caulking and cleanup. Your satisfaction and your home\'s comfort are our top priorities.', 'Pella Certified Contractor', 'Andersen Certified Installer', 'BBB A+ Accredited Business', 'Best Window Installer [City] (2022, 2023)', 'Angie\'s List Super Service Award', 'Window & Door Solutions', 'Replacement Windows', 'Energy-efficient replacement windows that reduce heating and cooling costs while improving comfort. We offer vinyl, wood, and fiberglass windows in all styles and configurations.', 'Entry Door Installation', 'Beautiful, secure entry doors that make a statement while providing energy efficiency and security. Choose from steel, fiberglass, and wood doors in unlimited styles.', 'Patio Doors', 'Sliding and French patio doors that connect your indoor and outdoor living spaces. Energy-efficient glass and smooth operation for years of enjoyment.', 'Storm Doors & Windows', 'Add an extra layer of protection and energy efficiency with quality storm doors and windows. Increases the life of your primary doors and windows.', 'Bay & Bow Windows', 'Create a dramatic focal point and add living space with custom bay and bow windows. Perfect for dining rooms, living rooms, and master bedrooms.', 'Window & Door Repair', 'Expert repair services for broken glass, faulty hardware, damaged frames, and weatherstripping. We repair all major brands and can source hard-to-find parts.', 'Energy-Efficient Window & Door Replacement', 'Certified Installation - Premium Products - Lifetime Warranty', 'We Install Premium Window & Door Brands', 'Our Professional Installation Process<br>Ensuring Perfect Fit & Performance', 'Free In-Home Consultation & Estimate', 'We visit your home to take precise measurements, discuss your goals, and show you product samples. You\'ll receive a detailed written estimate with all costs clearly explained.', 'Expert Installation By Certified Crews', 'Our factory-certified installers handle every detail from old window removal to final caulking and trim work. We protect your home and clean up completely.', 'Final Inspection & Warranty Registration', 'We conduct a thorough quality inspection, explain operation and care, and register your warranty. Your installation is backed by both manufacturer and labor warranties.', 'Beautiful Energy Efficient Windows And Doors', 'Whether You Need Window Replacement Or New Door Installation We\'re Here For You!', 'Window & Door Customer Reviews', '8AM-5PM', '8AM-5PM', '8AM-5PM', '8AM-5PM', '8AM-5PM', '9AM-2PM', 'Closed', 0, 0, 0, 0, 0, 0, 0, '#0369A1', '#0EA5E9', '#38BDF8', '#F0F9FF', '#0C2E4E', '#075985', '#0EA5E9', '#38BDF8', '#FFFFFFA8', '#00000099', 1, '2025-11-28 17:49:13', '2025-12-11 12:34:56'),
(8, 'garage_doors', 'Garage Doors', 'Garage Doors', 'Garage Door Installation, Repair & Maintenance', 'Same-Day Service On Repairs - Lifetime Warranty On New Doors', '', 'Our Services', 'Your Local Garage Door Experts', 'Every Year, Hundreds Of Homeowners Trust Our Professional Garage Door Services', 'Same-Day Repair Service Available', 'Lifetime Warranty On Door Installation', 'FREE Estimates On New Doors', '<strong>Licensed & Insured</strong> Technicians', 'All Major Brands Serviced', 'Spring Replacement Starting At $XXX', 'Smart Garage Door Openers Available', 'Why Choose Our Garage Door Service', 'A malfunctioning garage door is more than an inconvenience - it\'s a security risk. Our experienced technicians diagnose problems quickly and have the parts and expertise to fix most issues on the first visit.<br><br>Whether you need a simple repair or a complete new door installation, we provide honest recommendations, upfront pricing, and quality workmanship. We\'re locally owned and committed to earning your trust with every service call.', 'Clopay Master Authorized Dealer', 'LiftMaster ProVantage Dealer', 'BBB A+ Accredited Business', 'Best Garage Door Company [City] (2022, 2023)', 'Angie\'s List Super Service Award', 'Complete Garage Door Services', 'Garage Door Repair', 'Fast, reliable repair for broken springs, cables, rollers, tracks, and panels. We service all makes and models and offer same-day service on most repairs.', 'New Garage Door Installation', 'Transform your home\'s curb appeal with a beautiful new garage door. We offer styles from traditional to modern in steel, wood, and composite materials with insulation options.', 'Garage Door Opener Installation', 'Upgrade to a quiet, reliable garage door opener with smartphone control. We install LiftMaster, Chamberlain, and other premium brands with battery backup.', 'Spring Replacement', 'Broken springs are the most common garage door problem. We replace torsion and extension springs quickly and safely, and offer high-cycle springs for longer life.', 'Preventive Maintenance', 'Annual tune-ups extend the life of your garage door and prevent breakdowns. We lubricate, adjust, and inspect all components for safe, reliable operation.', 'Commercial Garage Doors', 'Professional installation and service for commercial and industrial garage doors. We handle overhead doors, loading dock equipment, and high-speed doors.', 'Garage Door Installation, Repair & Maintenance', 'Same-Day Repairs - Lifetime Installation Warranty - All Brands Serviced', 'We Install & Service Premium Brands', 'Our Garage Door Service Process<br>Fast, Professional, Reliable', 'Call For Service - Same-Day Available', 'Contact us by phone and we\'ll schedule a convenient appointment. For urgent repairs like broken springs, we offer same-day service and arrive in a fully-stocked truck.', 'Expert Diagnosis & Upfront Pricing', 'Our technician inspects your door, diagnoses the problem, and provides clear upfront pricing before starting work. No hidden fees or surprise charges.', 'Quality Repair With Parts Warranty', 'We complete the repair efficiently using quality parts and test the door thoroughly. All repairs come with a parts warranty and our workmanship guarantee.', 'Secure And Smooth Operating Garage Doors', 'Whether You Need New Door Installation Or Opener Repair We\'re Here For You!', 'Garage Door Service Reviews', '7AM-6PM', '7AM-6PM', '7AM-6PM', '7AM-6PM', '7AM-6PM', '8AM-4PM', 'Emergency Only', 0, 0, 0, 0, 0, 0, 0, '#475569', '#64748B', '#94A3B8', '#F8FAFC', '#1E293B', '#334155', '#64748B', '#94A3B8', '#FFFFFFA8', '#00000099', 1, '2025-11-28 17:49:49', '2025-12-11 12:35:08'),
(9, 'pest_control', 'Pest Control', 'Pest Control', 'Professional Pest Control & Extermination Services', 'Safe, Effective Treatment For Residential & Commercial Properties', '', 'Our Services', 'Protect Your Home From Unwanted Pests', 'Every Year, Hundreds Of Satisfied Customers Choose Our Pest Control Experts', 'Licensed & Certified Technicians', 'Eco-Friendly Treatment Options', '100% Satisfaction Guarantee', '<strong>Same-Day Service</strong> Available', 'Free Inspections & Estimates', 'Pet & Child Safe Products', 'Quarterly Service Plans Available', 'Why Choose Our Pest Control Service', 'Pest problems require professional expertise and the right treatment methods. Our licensed technicians are trained in the latest integrated pest management techniques that eliminate pests while minimizing environmental impact.<br><br>We don\'t just treat the symptoms - we identify and address the root causes of pest problems. Our comprehensive approach provides long-term protection and peace of mind for your family and property.', 'QualityPro Certified Company', 'BBB A+ Accredited Business', 'Angie\'s List Super Service Award', 'Best Pest Control [City] (2022, 2023)', 'State Licensed & Certified', 'Complete Pest Control Solutions', 'General Pest Control', 'Comprehensive treatment for ants, spiders, roaches, silverfish, and other common household pests. Interior and exterior treatment with quarterly service plans available.', 'Termite Inspection & Treatment', 'Protect your home\'s structure with professional termite inspections and treatment. We offer both liquid treatments and bait systems with damage repair warranties.', 'Rodent Control & Exclusion', 'Complete rodent control including trapping, exclusion work to seal entry points, and sanitation. We handle mice, rats, and other rodent problems safely and effectively.', 'Bed Bug Treatment', 'Effective bed bug elimination using heat treatment or chemical methods. We inspect thoroughly and provide follow-up treatments to ensure complete eradication.', 'Mosquito & Tick Control', 'Enjoy your yard again with professional mosquito and tick control. Monthly treatments during warm months reduce populations by up to 90%.', 'Commercial Pest Management', 'Professional pest control for restaurants, offices, warehouses, and commercial properties. We provide discreet service and comprehensive documentation for health inspections.', 'Professional Pest Control & Extermination Services', 'Licensed Technicians - Safe Products - Guaranteed Results', 'We Use Professional-Grade Products', 'Our Proven Pest Control Process<br>Effective Treatment & Prevention', 'Free Inspection & Customized Plan', 'We inspect your property thoroughly to identify pest types, entry points, and conducive conditions. Then we create a customized treatment plan for your specific situation.', 'Professional Treatment Application', 'Our licensed technicians apply targeted treatments using the most effective products and methods. We treat both interior and exterior areas for complete protection.', 'Follow-Up & Ongoing Prevention', 'We schedule follow-up visits to ensure treatment effectiveness and provide ongoing quarterly service to prevent re-infestation. All work is 100% guaranteed.', 'Protect Your Home From Unwanted Pests', 'Whether You Need One-Time Treatment Or Ongoing Protection We\'re Here For You!', 'Pest Control Customer Reviews', '8AM-5PM', '8AM-5PM', '8AM-5PM', '8AM-5PM', '8AM-5PM', '9AM-1PM', 'Closed', 0, 0, 0, 0, 0, 0, 0, '#DC2626', '#EF4444', '#F87171', '#FEF2F2', '#7F1D1D', '#B91C1C', '#EF4444', '#F87171', '#FFFFFFA8', '#00000099', 1, '2025-11-28 17:50:30', '2025-12-11 12:35:21'),
(10, 'painting', 'Painting', 'Painting', 'Professional Interior & Exterior Painting Services', 'Transform Your Home With Expert Painters & Quality Results', '', 'Our Services', 'Your Trusted Painting Contractors', 'Every Year, Hundreds Of Homeowners Choose Our Professional Painting Services', 'FREE Color Consultation & Estimates', '3-Year Warranty On Workmanship', 'Premium Sherwin-Williams & Benjamin Moore Paints', '<strong>Meticulous Prep Work</strong> For Lasting Results', 'Licensed, Bonded & Insured', 'Respectful Of Your Home & Schedule', 'Commercial Painting Available', 'Why Choose Our Painting Services', 'A quality paint job starts with proper preparation. Our professional painters take the time to prep surfaces correctly - cleaning, sanding, caulking, and priming - ensuring paint adheres properly and lasts for years.<br><br>We use only premium paints from Sherwin-Williams and Benjamin Moore, and our attention to detail shows in every brush stroke. From protecting your furniture to final cleanup, we treat your home with the respect it deserves.', 'Sherwin-Williams ProMar Certified', 'BBB A+ Accredited Business', 'Angie\'s List Super Service Award', 'Best Painter [City] (2022, 2023)', 'Master Painters Institute Member', 'Professional Painting Services', 'Interior Painting', 'Complete interior painting for walls, ceilings, trim, doors, and cabinets. We protect your furniture and floors, and provide a clean, dust-free finish.', 'Exterior Painting', 'Professional exterior house painting that protects and beautifies your home. Thorough surface prep, premium exterior paints, and attention to detail ensure long-lasting results.', 'Cabinet Refinishing', 'Transform your kitchen or bathroom with professional cabinet painting or staining. A cost-effective alternative to replacement that delivers stunning results.', 'Deck & Fence Staining', 'Protect and enhance your deck and fence with professional staining or painting. Proper prep and premium products extend the life of your wood structures.', 'Drywall Repair', 'Expert drywall repair for holes, cracks, water damage, and texture matching. We make walls look perfect before painting for flawless results.', 'Commercial Painting', 'Professional commercial painting for offices, retail spaces, restaurants, and industrial facilities. We work around your schedule to minimize business disruption.', 'Professional Interior & Exterior Painting Services', 'Expert Prep Work - Premium Paints - 3-Year Warranty', 'We Use Premium Paint Brands', 'Our Professional Painting Process<br>Quality Results From Start To Finish', 'Free Color Consultation & Estimate', 'We visit your home for a color consultation and detailed estimate. We discuss your vision, provide color recommendations, and give you a written quote with no obligation.', 'Thorough Prep & Expert Application', 'We protect your home, prep surfaces properly (the key to quality results), and apply paint with professional techniques. Clean lines, smooth finish, attention to detail.', 'Final Walkthrough & Satisfaction', 'We conduct a thorough cleanup and final walkthrough to ensure your complete satisfaction. Touch-ups if needed, and everything is backed by our 3-year workmanship warranty.', 'Beautiful Lasting Paint Jobs Done Right', 'Whether You Need Interior Painting Or Complete Exterior Refresh We\'re Here For You!', 'Painting Customer Reviews', '7AM-5PM', '7AM-5PM', '7AM-5PM', '7AM-5PM', '7AM-5PM', '8AM-2PM', 'Closed', 0, 0, 0, 0, 0, 0, 0, '#7C3AED', '#A855F7', '#C084FC', '#FAF5FF', '#3B1B6D', '#6D28D9', '#A855F7', '#C084FC', '#FFFFFFA8', '#00000099', 1, '2025-11-28 17:51:20', '2025-12-11 12:35:31');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `campaigns`
--
ALTER TABLE `campaigns`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `campaign_key` (`campaign_key`),
  ADD KEY `idx_service_type` (`service_type`),
  ADD KEY `idx_campaign_key` (`campaign_key`),
  ADD KEY `idx_active` (`is_active`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `campaigns`
--
ALTER TABLE `campaigns`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
