-- Page Titles Table
CREATE TABLE
  IF NOT EXISTS `page_titles` (
    `id` int (11) NOT NULL AUTO_INCREMENT,
    `url` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `url` (`url`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

-- Insert all page titles (105+ pages)
INSERT INTO
  `page_titles` (`url`, `title`)
VALUES
  (
    '/',
    'The Best Fireplace & Chimney Services Near Me - CSIA Certified'
  ),
  (
    '/about-us/',
    'Read More About The 2023 Best Chimney & Fireplace Co. in USA'
  ),
  ('/about-us/careers/', 'Careers - Crest Chimney'),
  ('/about-us/financing/', 'Financing - Crest Chimney'),
  (
    '/about-us/maintenance-program/',
    'Maintenance Program - Crest Chimney'
  ),
  ('/about-us/our-team/', 'Our Team - Crest Chimney'),
  ('/about-us/reviews/', 'Reviews - Crest Chimney'),
  (
    '/blog/',
    'Latest Chimney Updates You Must Know Before The Winter - Blog'
  ),
  (
    '/blog/4-major-benefits-why-adding-a-fireplace-to-your-home-is-a-must/',
    '4 Major Benefits Why Adding a Fireplace to Your Home is a Must!'
  ),
  (
    '/blog/chimney-crown-repair/',
    'Chimney Crown Repair: What Cracks Mean and When to Fix Them'
  ),
  (
    '/blog/chimney-flashing-problems/',
    'Chimney Flashing Problems: Causes, Signs, and Fixes'
  ),
  (
    '/blog/chimney-repair-article/',
    'Chimney Repair: How to Stop Roof Leaks Before Major Damage'
  ),
  (
    '/blog/chimney-repair-tips/',
    'Chimney Repair Tips'
  ),
  (
    '/blog/chimney-waterproofing-matters/',
    'Chimney Waterproofing Matters: Why It Does and When to Do It'
  ),
  (
    '/blog/everything-you-need-to-know-about-chimney-caps/',
    'Everything You Need to Know About Chimney Caps'
  ),
  (
    '/blog/everything-you-need-to-know-about-chimney-sweeping/',
    'Everything You Need to Know About Chimney Sweeping'
  ),
  (
    '/blog/fireplace-cleaning-how-to-ensure-a-safe-home/',
    'How to Ensure a Safe Home with Fireplace Cleaning - Crest Chimney'
  ),
  (
    '/blog/how-to-choose-the-best-chimney-sweep-service/',
    'How to Choose the Best Chimney Sweep Service'
  ),
  (
    '/blog/how-to-fix-chimney-leaks/',
    'How to Fix Chimney Leaks'
  ),
  (
    '/blog/how-to-improve-fireplace-efficiency/',
    'How to Improve Fireplace Efficiency'
  ),
  (
    '/blog/how-to-maintain-a-clean-fireplace-at-home/',
    'How to Maintain a Clean Fireplace at Home'
  ),
  (
    '/blog/how-to-prepare-your-fireplace-for-winter-use/',
    'How to Prepare Your Fireplace for Winter Use'
  ),
  (
    '/blog/how-to-spot-chimney-problems-early/',
    'How to Spot Chimney Problems Early'
  ),
  (
    '/blog/page/2/',
    'Latest Chimney Updates You Must Know Before The Winter - Blog'
  ),
  (
    '/blog/who-are-chimney-sweepers-how-to-hire-professionals/',
    'Who Are Chimney Sweepers & How to Hire Professionals?'
  ),
  (
    '/chimney-cap-installation/',
    '2023 Best Chimney Cap Installation in the USA - Crest Chimney'
  ),
  (
    '/chimney-inspection-level-1/',
    '2023 Best Chimney Inspection Level 1 in the USA - Crest Chimney'
  ),
  (
    '/chimney-repair/',
    '2023 Best Chimney Repair in the USA - Crest Chimney'
  ),
  (
    '/chimney-sweep/',
    '2023 Best Chimney Sweep in the USA - Crest Chimney'
  ),
  (
    '/contact-us/',
    'Contact Us We''re The Best Chimney & Fireplace Company in USA'
  ),
  (
    '/faq/',
    'Frequently Asked Questions - 2023 FAQ''s - Crest Chimney'
  ),
  (
    '/inspection-terms-and-conditions/',
    'Terms & Conditions - Crest Chimney'
  ),
  (
    '/online-scheduling/',
    'Online Scheduling - Crest Chimney'
  ),
  (
    '/our-locations/',
    'Crest Chimney Providing Best Chimney & Fireplace Services in USA'
  ),
  (
    '/our-services/',
    'Professional Chimney, Fireplace & Masonry Services - Crest Chimney'
  ),
  (
    '/our-services/2/',
    'Professional Chimney, Fireplace & Masonry Services - Crest Chimney'
  ),
  (
    '/our-services/3/',
    'Professional Chimney, Fireplace & Masonry Services - Crest Chimney'
  ),
  (
    '/our-services/4/',
    'Professional Chimney, Fireplace & Masonry Services - Crest Chimney'
  ),
  (
    '/our-services/5/',
    'Professional Chimney, Fireplace & Masonry Services - Crest Chimney'
  ),
  (
    '/our-services/6/',
    'Professional Chimney, Fireplace & Masonry Services - Crest Chimney'
  ),
  (
    '/our-services/chimney-animal-removal/',
    '2023 Best Chimney Animal Removal in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-bricks-repair/',
    '2023 Best Chimney Bricks Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-cap-installation/',
    '2023 Best Chimney Cap Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-cap-repair/',
    '2023 Best Chimney Cap Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-chase-covering/',
    '2023 Best Chimney Chase Covering in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-construction/',
    '2023 Best Chimney Construction in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-cricket-installation/',
    '2023 Best Chimney Cricket Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-crown-repair/',
    '2023 Best Chimney Crown Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-damper-repair/',
    '2023 Best Chimney Damper Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-deep-cleaning-pcr/',
    '2023 Best Chimney Deep Cleaning (PCR) in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-exterior-wood-replacement/',
    '2023 Best Chimney Exterior Wood Replacement in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-fan-installation/',
    '2023 Best Chimney Fan Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-flashing/',
    '2023 Best Chimney Flashing in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-flue-installation/',
    '2023 Best Chimney Flue Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-flue-repair/',
    '2023 Best Chimney Flue Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-framing-rebuild/',
    '2023 Best Chimney Framing Rebuild in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-framing-repair/',
    '2023 Best Chimney Framing Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-inspection-level-1/',
    '2023 Best Chimney Inspection Level 1 in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-inspection-level-2/',
    '2023 Best Chimney Inspection Level 2 in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-inspection-level-3/',
    '2023 Best Chimney Inspection Level 3 in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-liner-installation/',
    '2023 Best Chimney Liner Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-liner-repair/',
    '2023 Best Chimney Liner Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-maintenance/',
    '2023 Best Chimney Maintenance in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-masonry-repair/',
    '2023 Best Chimney Masonry Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-nest-removal/',
    '2023 Best Chimney Nest Removal in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-rebuild/',
    '2023 Best Chimney Rebuild in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-repair/',
    '2023 Best Chimney Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-restoration/',
    '2023 Best Chimney Restoration in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-siding-repair/',
    '2023 Best Chimney Siding Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-siding-replace/',
    '2023 Best Chimney Siding Replace in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-spark-arrestor-installation/',
    '2023 Best Chimney Spark Arrestor Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-sweep-near-me/',
    '2023 Best Chimney Sweep Near Me in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-sweep/',
    '2023 Best Chimney Sweep in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-tuckpointing/',
    '2023 Best Chimney Tuckpointing in the USA - Crest Chimney'
  ),
  (
    '/our-services/chimney-vent-installation/',
    '2023 Best Chimney Vent Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/downdraft-repair/',
    '2023 Best Downdraft Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/dryer-vent-cleaning/',
    '2023 Best Dryer Vent Cleaning in the USA - Crest Chimney'
  ),
  (
    '/our-services/electric-fireplace-installation/',
    '2023 Best Electric Fireplace Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/electric-fireplace-repair/',
    '2023 Best Electric Fireplace Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/fireplace-gas-burner-installation/',
    '2023 Best Fireplace Gas Burner Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/fireplace-gas-valve-repair/',
    '2023 Best Fireplace Gas Valve Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/fireplace-gas-valve-replace/',
    '2023 Best Fireplace Gas Valve Replace in the USA - Crest Chimney'
  ),
  (
    '/our-services/fireplace-installation/',
    '2023 Best Fireplace Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/fireplace-masonry-repair/',
    '2023 Best Fireplace Masonry Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/fireplace-panels-repair/',
    '2023 Best Fireplace Panels Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/fireplace-panels-replace/',
    '2023 Best Fireplace Panels Replace in the USA - Crest Chimney'
  ),
  (
    '/our-services/flexible-chimney-liner-installation/',
    '2023 Best Flexible Chimney Liner Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/gas-fireplace-repair/',
    '2023 Best Gas Fireplace Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/glass-door-fireplace/',
    '2023 Best Glass Door Fireplace in the USA - Crest Chimney'
  ),
  (
    '/our-services/pellet-stove-inspection/',
    '2023 Best Pellet Stove Inspection in the USA - Crest Chimney'
  ),
  (
    '/our-services/pellet-stove-installation/',
    '2023 Best Pellet Stove Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/pellet-stove-repair/',
    '2023 Best Pellet Stove Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/pilot-assembly-replacement/',
    '2023 Best Pilot Assembly Replacement in the USA - Crest Chimney'
  ),
  (
    '/our-services/pilot-light-installation/',
    '2023 Best Pilot Light Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/remote-control-for-a-pilot-light/',
    '2023 Best Remote Control for a Pilot Light in the USA - Crest Chimney'
  ),
  (
    '/our-services/smoke-chamber-cleaning/',
    '2023 Best Smoke Chamber Cleaning in the USA - Crest Chimney'
  ),
  (
    '/our-services/smoke-chamber-rebuild/',
    '2023 Best Smoke Chamber Rebuild in the USA - Crest Chimney'
  ),
  (
    '/our-services/smoke-chamber-repair/',
    '2023 Best Smoke Chamber Repair in the USA - Crest Chimney'
  ),
  (
    '/our-services/vented-gas-logs-installation/',
    '2023 Best Vented Gas Logs Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/ventless-gas-logs-installation/',
    '2023 Best Ventless Gas Logs Installation in the USA - Crest Chimney'
  ),
  (
    '/our-services/waterproofing-bricks/',
    '2023 Best Waterproofing Bricks in the USA - Crest Chimney'
  ),
  ('/our-work/', 'Our Work - Crest Chimney'),
  ('/privacy-policy/', 'Privacy Policy - Crest Chimney'),
  ('/sitemap/', 'Sitemap - Crest Chimney'),
  (
    '/terms-and-conditions/',
    'Terms & Conditions - Crest Chimney'
  ),
  (
    '/yith-store-locator/',
    '2023 Best Store Locator in the USA - Crest Chimney'
  );