-- =====================================================================
-- LarCare -- dev/staging seed data
-- Generated from frontend/src/lib/content/*.json -- do not hand-edit;
-- regenerate from the fixtures instead so the two stay identical.
-- =====================================================================

-- ---------- site_settings ----------
INSERT INTO site_settings (id, company_name, tagline, phone, email, address, states_served)
VALUES (1, 'LarCare Services', 'Personal home care for every unique situation', '803-209-8667', 'info@larcareservices.com', '178 Columbia St, Chester, SC 29706', '["South Carolina", "North Carolina", "Georgia"]')
ON DUPLICATE KEY UPDATE
  company_name = VALUES(company_name), tagline = VALUES(tagline),
  phone = VALUES(phone), email = VALUES(email), address = VALUES(address),
  states_served = VALUES(states_served);

-- ---------- social_links ----------
INSERT INTO social_links (platform, url, sort_order, is_active) VALUES ('facebook', 'https://facebook.com/larcareservices', 0, 1) ON DUPLICATE KEY UPDATE url = VALUES(url), sort_order = VALUES(sort_order);
INSERT INTO social_links (platform, url, sort_order, is_active) VALUES ('x', 'https://x.com/larcareservices', 1, 1) ON DUPLICATE KEY UPDATE url = VALUES(url), sort_order = VALUES(sort_order);
INSERT INTO social_links (platform, url, sort_order, is_active) VALUES ('instagram', 'https://instagram.com/larcareservices', 2, 1) ON DUPLICATE KEY UPDATE url = VALUES(url), sort_order = VALUES(sort_order);
INSERT INTO social_links (platform, url, sort_order, is_active) VALUES ('linkedin', 'https://linkedin.com/company/larcareservices', 3, 1) ON DUPLICATE KEY UPDATE url = VALUES(url), sort_order = VALUES(sort_order);

-- ---------- nav_items (header) ----------
DELETE FROM nav_items WHERE location = 'header';
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'header', 'Home', '/', 0, 1);
SET @nav_parent_0 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'header', 'Healthcare', '/healthcare', 1, 1);
SET @nav_parent_1 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_parent_1, 'header', 'Alzheimer''s Disease and Dementia Care', '/healthcare/alzheimers-dementia-care', 0, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_parent_1, 'header', 'End-of-Life Care', '/healthcare/end-of-life-care', 1, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_parent_1, 'header', 'Home and Personal Care Services', '/healthcare/home-and-personal-care-services', 2, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_parent_1, 'header', 'Veteran Care', '/healthcare/veteran-care', 3, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_parent_1, 'header', 'Transitional Care', '/healthcare/transitional-care', 4, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'header', 'About Us', '/about-us', 2, 1);
SET @nav_parent_2 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_parent_2, 'header', 'About LarCare', '/about-us', 0, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_parent_2, 'header', 'Careers', '/about-us/careers', 1, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_parent_2, 'header', 'Contact Us', '/about-us/contact-us', 2, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'header', 'Blog', '/blog', 3, 1);
SET @nav_parent_3 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'header', 'Products', '/products', 4, 1);
SET @nav_parent_4 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'header', 'Forms', '/forms', 5, 1);
SET @nav_parent_5 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'header', 'Portal', '/portal', 6, 1);
SET @nav_parent_6 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'header', 'SamariCare', 'https://samaricare.com', 7, 1);
SET @nav_parent_7 = LAST_INSERT_ID();

-- ---------- nav_items (footer) ----------
DELETE FROM nav_items WHERE location = 'footer';
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'footer', 'Our company', '#', 0, 1);
SET @nav_footer_0 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_0, 'footer', 'Home', '/', 0, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_0, 'footer', 'About LarCare', '/about-us', 1, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_0, 'footer', 'Careers', '/about-us/careers', 2, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_0, 'footer', 'Contact Us', '/about-us/contact-us', 3, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_0, 'footer', 'Privacy Policy & Terms', '/privacy-policy', 4, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_0, 'footer', 'Products', '/products', 5, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (NULL, 'footer', 'Care Services', '#', 1, 1);
SET @nav_footer_1 = LAST_INSERT_ID();
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_1, 'footer', 'Home and Personal Care Services', '/healthcare/home-and-personal-care-services', 0, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_1, 'footer', 'Veteran Care', '/healthcare/veteran-care', 1, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_1, 'footer', 'End-of-Life Care', '/healthcare/end-of-life-care', 2, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_1, 'footer', 'Transitional Care', '/healthcare/transitional-care', 3, 1);
INSERT INTO nav_items (parent_id, location, label, href, sort_order, is_active) VALUES (@nav_footer_1, 'footer', 'Alzheimer''s Disease and Dementia Care', '/healthcare/alzheimers-dementia-care', 4, 1);

-- ---------- care_services ----------
INSERT INTO care_services (uuid, slug, title, short_description, hero_image, body_html, sort_order, featured_on_home, status, meta_title, meta_description)
VALUES ('245f2d80-528c-5e5e-b31b-4ef00bbc1993', 'home-and-personal-care-services', 'Home and Personal Care Services', 'Non-medical assistance, companionship, and daily living support delivered in the comfort of home.', '/images/services/home-personal-care.jpg', '<p>LarCare understands what families are going through and we are here to help. Home Care provides non-medical assistance to older adults or individuals with disabilities, directly within their homes. The core of companion care lies in offering emotional support and fostering social interaction.</p><p>Our certified nurse assistants (CNAs) offer a helping hand with essential activities of daily living such as bathing, dressing, and meal preparation. Beyond these, our services can include help with transportation, managing finances, scheduling appointments, and offering companionship and emotional support.</p>', 1, 1, 'published', 'Home and Personal Care Services', 'Non-medical assistance, companionship, and daily living support delivered in the comfort of home.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), short_description = VALUES(short_description),
  hero_image = VALUES(hero_image), body_html = VALUES(body_html),
  sort_order = VALUES(sort_order), featured_on_home = VALUES(featured_on_home),
  status = VALUES(status), meta_title = VALUES(meta_title),
  meta_description = VALUES(meta_description), deleted_at = NULL,
  uuid = uuid;
SET @svc_id = (SELECT id FROM care_services WHERE slug = 'home-and-personal-care-services');
DELETE FROM care_service_highlights WHERE service_id = @svc_id;
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Meal planning & preparation', 0);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Bathing, grooming & personal hygiene', 1);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Light housekeeping & laundry', 2);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Medication reminders', 3);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Mobility, transferring & toileting assistance', 4);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Errands & transportation', 5);
INSERT INTO care_services (uuid, slug, title, short_description, hero_image, body_html, sort_order, featured_on_home, status, meta_title, meta_description)
VALUES ('8aad329d-7901-5740-8b48-dbbab8e17747', 'alzheimers-dementia-care', 'Alzheimer''s Disease and Dementia Care', 'Specialized, patient-centered memory care for every stage, tailored to each family''s experience.', '/images/services/dementia-care.jpg', '<p>Alzheimer''s disease, a degenerative and incurable disorder, progressively impairs memory, cognitive abilities, and the capacity to carry out daily activities. At LarCare, we recognize the challenges that come with caring for seniors with Alzheimer''s disease or dementia. Our team is specially trained to support individuals with these conditions, ensuring they receive compassionate and expert care.</p>', 2, 0, 'published', 'Alzheimer''s Disease and Dementia Care', 'Specialized, patient-centered memory care for every stage, tailored to each family''s experience.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), short_description = VALUES(short_description),
  hero_image = VALUES(hero_image), body_html = VALUES(body_html),
  sort_order = VALUES(sort_order), featured_on_home = VALUES(featured_on_home),
  status = VALUES(status), meta_title = VALUES(meta_title),
  meta_description = VALUES(meta_description), deleted_at = NULL,
  uuid = uuid;
SET @svc_id = (SELECT id FROM care_services WHERE slug = 'alzheimers-dementia-care');
DELETE FROM care_service_highlights WHERE service_id = @svc_id;
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Structured, memory-focused routines', 0);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Specially trained dementia caregivers', 1);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Behavioral and mood support', 2);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Family guidance and education', 3);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Safety-focused home environment checks', 4);
INSERT INTO care_services (uuid, slug, title, short_description, hero_image, body_html, sort_order, featured_on_home, status, meta_title, meta_description)
VALUES ('490e6d77-a2cf-59e5-a8e6-a065e0c318c5', 'end-of-life-care', 'End-of-Life Care', 'Physical, emotional, and spiritual comfort for patients and families during life''s most crucial time.', '/images/services/end-of-life-care.jpg', '<p>LarCare is dedicated to providing both physical and emotional comfort to our patients and their families during crucial times. Our skilled team of compassionate professionals is committed to delivering exceptional medical, emotional, and spiritual support.</p><p>Hospice care is in-home medical care for people who are no longer seeking a cure for their advanced illness; instead, hospice care focuses on achieving comfort for mind, body and spirit.</p>', 3, 1, 'published', 'End-of-Life Care', 'Physical, emotional, and spiritual comfort for patients and families during life''s most crucial time.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), short_description = VALUES(short_description),
  hero_image = VALUES(hero_image), body_html = VALUES(body_html),
  sort_order = VALUES(sort_order), featured_on_home = VALUES(featured_on_home),
  status = VALUES(status), meta_title = VALUES(meta_title),
  meta_description = VALUES(meta_description), deleted_at = NULL,
  uuid = uuid;
SET @svc_id = (SELECT id FROM care_services WHERE slug = 'end-of-life-care');
DELETE FROM care_service_highlights WHERE service_id = @svc_id;
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Dignity-centered hospice support', 0);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, '24/7 comfort-focused caregiving', 1);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Family emotional support', 2);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Coordination with medical providers', 3);
INSERT INTO care_services (uuid, slug, title, short_description, hero_image, body_html, sort_order, featured_on_home, status, meta_title, meta_description)
VALUES ('ff72b15e-f163-5a9a-a23a-f16ab61abe0d', 'transitional-care', 'Transitional Care', 'Easing the move from hospital or rehab facility back home for a safer post-surgery recovery.', '/images/services/transitional-care.jpg', '<p>We can ease your loved one''s transition from the hospital or rehabilitation facility to home, which can lead to a safer, more comfortable post-surgery recovery. Professional in-home caregivers provide care that can help you avoid hospital readmission.</p>', 4, 0, 'published', 'Transitional Care', 'Easing the move from hospital or rehab facility back home for a safer post-surgery recovery.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), short_description = VALUES(short_description),
  hero_image = VALUES(hero_image), body_html = VALUES(body_html),
  sort_order = VALUES(sort_order), featured_on_home = VALUES(featured_on_home),
  status = VALUES(status), meta_title = VALUES(meta_title),
  meta_description = VALUES(meta_description), deleted_at = NULL,
  uuid = uuid;
SET @svc_id = (SELECT id FROM care_services WHERE slug = 'transitional-care');
DELETE FROM care_service_highlights WHERE service_id = @svc_id;
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Medication reminders', 0);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Doctor-ordered diet support', 1);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Mobility & exercise monitoring', 2);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Fall-risk prevention', 3);
INSERT INTO care_services (uuid, slug, title, short_description, hero_image, body_html, sort_order, featured_on_home, status, meta_title, meta_description)
VALUES ('812e1aa7-7055-53dd-b3f0-20b7b412af6d', 'veteran-care', 'Veteran Care', 'Home Health Aide services for Veterans, coordinated with the VA to support daily living at home.', '/images/services/veteran-care.jpg', '<p>A Home Health Aide is a trained person who can come to a Veteran''s home and help the Veteran take care of themselves and their daily activities. Home Health Aides are not nurses, but they are supervised by a registered nurse who will help assess the Veteran''s daily living needs.</p>', 5, 1, 'published', 'Veteran Care', 'Home Health Aide services for Veterans, coordinated with the VA to support daily living at home.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), short_description = VALUES(short_description),
  hero_image = VALUES(hero_image), body_html = VALUES(body_html),
  sort_order = VALUES(sort_order), featured_on_home = VALUES(featured_on_home),
  status = VALUES(status), meta_title = VALUES(meta_title),
  meta_description = VALUES(meta_description), deleted_at = NULL,
  uuid = uuid;
SET @svc_id = (SELECT id FROM care_services WHERE slug = 'veteran-care');
DELETE FROM care_service_highlights WHERE service_id = @svc_id;
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'VA-contracted Home Health Aide services', 0);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Support for isolated Veterans or overburdened caregivers', 1);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Respite care for family caregivers', 2);
INSERT INTO care_service_highlights (service_id, label, sort_order) VALUES (@svc_id, 'Available regardless of Veteran''s age', 3);

-- ---------- blog_posts ----------
INSERT INTO blog_posts (uuid, slug, title, excerpt, cover_image, body_html, author, published_at, status, meta_title, meta_description)
VALUES ('32231ac1-77ff-5021-b961-915f1cf810ea', '10-signs-your-loved-one-needs-home-health-care-chester-sc', '10 Signs Your Loved One Needs Home Health Care in Chester, SC', 'Caring for an aging parent or loved one is one of life''s most meaningful responsibilities. Here are 10 signs it might be time for professional support.', '/images/blog/10-signs.jpg', '<p>Caring for an aging parent or loved one is one of life''s most meaningful responsibilities — but it can also be overwhelming. Here are ten important signs that it might be time to consider professional home health care assistance.</p><h3>1. Difficulty with Daily Activities</h3><p>If your loved one is struggling with daily routines like dressing, bathing, grooming, or cooking, it''s often one of the earliest signs that extra help is needed.</p><h3>2. Social Isolation or Depression</h3><p>Loneliness is one of the most common challenges older adults face. Caregivers offer companionship, conversation, and social engagement.</p><h3>3. Frequent Falls or Safety Concerns</h3><p>Falls are among the most common causes of injury for seniors. Our caregivers provide mobility support, home safety checks, and fall-prevention strategies.</p>', 'LarCare Services', '2026-06-01', 'published', '10 Signs Your Loved One Needs Home Health Care in Chester, SC', 'Caring for an aging parent or loved one is one of life''s most meaningful responsibilities. Here are 10 signs it might be time for professional support.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), excerpt = VALUES(excerpt), cover_image = VALUES(cover_image),
  body_html = VALUES(body_html), author = VALUES(author),
  published_at = VALUES(published_at), status = VALUES(status),
  meta_title = VALUES(meta_title), meta_description = VALUES(meta_description),
  deleted_at = NULL, uuid = uuid;
SET @post_id = (SELECT id FROM blog_posts WHERE slug = '10-signs-your-loved-one-needs-home-health-care-chester-sc');
DELETE FROM blog_post_tags WHERE post_id = @post_id;
INSERT INTO tags (slug, name) VALUES ('home-care', 'home care') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'home-care');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO tags (slug, name) VALUES ('caregiving', 'caregiving') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'caregiving');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO tags (slug, name) VALUES ('chester-sc', 'chester-sc') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'chester-sc');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO blog_posts (uuid, slug, title, excerpt, cover_image, body_html, author, published_at, status, meta_title, meta_description)
VALUES ('97df56dc-838e-52e6-8241-e5722986ce34', 'complete-guide-home-care-services-chester-county', 'The Complete Guide to Home Care Services in Chester County', 'Everything you need to know about home care services in Chester County — what they are, how they work, and how to choose the right plan.', '/images/blog/complete-guide.jpg', '<p>Caring for a loved one is one of life''s greatest responsibilities. At LarCare Services in Chester, SC, we understand that every family''s situation is unique. This complete guide walks you through everything you need to know about home care services in Chester County.</p>', 'LarCare Services', '2026-05-15', 'published', 'The Complete Guide to Home Care Services in Chester County', 'Everything you need to know about home care services in Chester County — what they are, how they work, and how to choose the right plan.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), excerpt = VALUES(excerpt), cover_image = VALUES(cover_image),
  body_html = VALUES(body_html), author = VALUES(author),
  published_at = VALUES(published_at), status = VALUES(status),
  meta_title = VALUES(meta_title), meta_description = VALUES(meta_description),
  deleted_at = NULL, uuid = uuid;
SET @post_id = (SELECT id FROM blog_posts WHERE slug = 'complete-guide-home-care-services-chester-county');
DELETE FROM blog_post_tags WHERE post_id = @post_id;
INSERT INTO tags (slug, name) VALUES ('home-care', 'home care') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'home-care');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO tags (slug, name) VALUES ('guide', 'guide') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'guide');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO tags (slug, name) VALUES ('chester-county', 'chester-county') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'chester-county');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO blog_posts (uuid, slug, title, excerpt, cover_image, body_html, author, published_at, status, meta_title, meta_description)
VALUES ('4a55233f-7d57-5593-8c83-2b7480f19ceb', 'dementia-care-compassionate-guide-families-caregivers', 'Dementia Care: A Compassionate Guide for Families & Caregivers', 'Understand the stages of dementia and how compassionate, structured in-home care supports both patients and families.', '/images/blog/dementia-guide.jpg', '<p>Dementia care requires patience, structure, and specialized training. This guide walks families through what to expect at each stage.</p>', 'LarCare Services', '2026-04-22', 'published', 'Dementia Care: A Compassionate Guide for Families & Caregivers', 'Understand the stages of dementia and how compassionate, structured in-home care supports both patients and families.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), excerpt = VALUES(excerpt), cover_image = VALUES(cover_image),
  body_html = VALUES(body_html), author = VALUES(author),
  published_at = VALUES(published_at), status = VALUES(status),
  meta_title = VALUES(meta_title), meta_description = VALUES(meta_description),
  deleted_at = NULL, uuid = uuid;
SET @post_id = (SELECT id FROM blog_posts WHERE slug = 'dementia-care-compassionate-guide-families-caregivers');
DELETE FROM blog_post_tags WHERE post_id = @post_id;
INSERT INTO tags (slug, name) VALUES ('dementia', 'dementia') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'dementia');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO tags (slug, name) VALUES ('alzheimers', 'alzheimers') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'alzheimers');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO blog_posts (uuid, slug, title, excerpt, cover_image, body_html, author, published_at, status, meta_title, meta_description)
VALUES ('bcb27e3d-f246-5dc8-a84c-3d439c5915c7', 'aging-in-place-comfort-independence-dignity', 'Aging in Place: Embracing Comfort, Independence, and Dignity', 'Why more seniors are choosing to age in place, and how the right support system makes it possible.', '/images/blog/aging-in-place.jpg', '<p>Aging in place lets seniors stay in the home they love while receiving the professional support they need.</p>', 'LarCare Services', '2026-03-10', 'published', 'Aging in Place: Embracing Comfort, Independence, and Dignity', 'Why more seniors are choosing to age in place, and how the right support system makes it possible.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), excerpt = VALUES(excerpt), cover_image = VALUES(cover_image),
  body_html = VALUES(body_html), author = VALUES(author),
  published_at = VALUES(published_at), status = VALUES(status),
  meta_title = VALUES(meta_title), meta_description = VALUES(meta_description),
  deleted_at = NULL, uuid = uuid;
SET @post_id = (SELECT id FROM blog_posts WHERE slug = 'aging-in-place-comfort-independence-dignity');
DELETE FROM blog_post_tags WHERE post_id = @post_id;
INSERT INTO tags (slug, name) VALUES ('aging-in-place', 'aging in place') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'aging-in-place');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO blog_posts (uuid, slug, title, excerpt, cover_image, body_html, author, published_at, status, meta_title, meta_description)
VALUES ('a567d821-02ff-5983-b044-1bb7c35918ed', 'elder-care-affordability-guide-families', 'Elder Care Affordability: A Compassionate Guide for Families', 'Understanding the true cost of elder care and the financial options available to families in South Carolina.', '/images/blog/affordability.jpg', '<p>The cost of care depends on the level of assistance required, frequency of visits, and type of care needed.</p>', 'LarCare Services', '2026-02-18', 'published', 'Elder Care Affordability: A Compassionate Guide for Families', 'Understanding the true cost of elder care and the financial options available to families in South Carolina.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), excerpt = VALUES(excerpt), cover_image = VALUES(cover_image),
  body_html = VALUES(body_html), author = VALUES(author),
  published_at = VALUES(published_at), status = VALUES(status),
  meta_title = VALUES(meta_title), meta_description = VALUES(meta_description),
  deleted_at = NULL, uuid = uuid;
SET @post_id = (SELECT id FROM blog_posts WHERE slug = 'elder-care-affordability-guide-families');
DELETE FROM blog_post_tags WHERE post_id = @post_id;
INSERT INTO tags (slug, name) VALUES ('affordability', 'affordability') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'affordability');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO tags (slug, name) VALUES ('cost', 'cost') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'cost');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO blog_posts (uuid, slug, title, excerpt, cover_image, body_html, author, published_at, status, meta_title, meta_description)
VALUES ('d4b3c509-e639-5ce2-a9f2-2a254c4404e8', 'medicare-home-care-compassionate-guide-families', 'Medicare Home Care: A Compassionate Guide for Families', 'A breakdown of what Medicare does and doesn''t cover for in-home care, and how to plan around it.', '/images/blog/medicare-guide.jpg', '<p>Understanding Medicare''s coverage of home care services can help families plan and budget with confidence.</p>', 'LarCare Services', '2026-01-29', 'published', 'Medicare Home Care: A Compassionate Guide for Families', 'A breakdown of what Medicare does and doesn''t cover for in-home care, and how to plan around it.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), excerpt = VALUES(excerpt), cover_image = VALUES(cover_image),
  body_html = VALUES(body_html), author = VALUES(author),
  published_at = VALUES(published_at), status = VALUES(status),
  meta_title = VALUES(meta_title), meta_description = VALUES(meta_description),
  deleted_at = NULL, uuid = uuid;
SET @post_id = (SELECT id FROM blog_posts WHERE slug = 'medicare-home-care-compassionate-guide-families');
DELETE FROM blog_post_tags WHERE post_id = @post_id;
INSERT INTO tags (slug, name) VALUES ('medicare', 'medicare') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'medicare');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);
INSERT INTO blog_posts (uuid, slug, title, excerpt, cover_image, body_html, author, published_at, status, meta_title, meta_description)
VALUES ('7619f36d-3ab6-5a8c-8dcf-a263c3276561', 'understanding-medicaid-support-services-caring-guide', 'Understanding Medicaid Support Services: A Caring Guide for Families', 'How Medicaid waivers and support programs can help offset the cost of home care.', '/images/blog/medicaid-guide.jpg', '<p>Medicaid support services vary by state — here''s what South Carolina families should know.</p>', 'LarCare Services', '2026-01-05', 'published', 'Understanding Medicaid Support Services: A Caring Guide for Families', 'How Medicaid waivers and support programs can help offset the cost of home care.')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), excerpt = VALUES(excerpt), cover_image = VALUES(cover_image),
  body_html = VALUES(body_html), author = VALUES(author),
  published_at = VALUES(published_at), status = VALUES(status),
  meta_title = VALUES(meta_title), meta_description = VALUES(meta_description),
  deleted_at = NULL, uuid = uuid;
SET @post_id = (SELECT id FROM blog_posts WHERE slug = 'understanding-medicaid-support-services-caring-guide');
DELETE FROM blog_post_tags WHERE post_id = @post_id;
INSERT INTO tags (slug, name) VALUES ('medicaid', 'medicaid') ON DUPLICATE KEY UPDATE name = VALUES(name);
SET @tag_id = (SELECT id FROM tags WHERE slug = 'medicaid');
INSERT IGNORE INTO blog_post_tags (post_id, tag_id) VALUES (@post_id, @tag_id);

-- ---------- products ----------
INSERT INTO products (uuid, slug, name, description, image, price, currency, external_url, sort_order, status)
VALUES ('f4191fef-e8ff-5915-b6e4-584c2dd5163f', 'standard-wheelchair', 'Standard Folding Wheelchair', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent at metus ac risus vehicula consectetur.', '/images/products/wheelchair.jpg', 99.99, 'USD', 'https://example-partner-store.com/products/standard-wheelchair', 0, 'published')
ON DUPLICATE KEY UPDATE
  name = VALUES(name), description = VALUES(description), image = VALUES(image),
  price = VALUES(price), external_url = VALUES(external_url),
  sort_order = VALUES(sort_order), status = VALUES(status), deleted_at = NULL,
  uuid = uuid;
INSERT INTO products (uuid, slug, name, description, image, price, currency, external_url, sort_order, status)
VALUES ('56520907-9cca-5ca8-b406-755745711bad', 'infrared-thermometer', 'Touchless Infrared Thermometer', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent at metus ac risus vehicula consectetur.', '/images/products/thermometer.jpg', 99.99, 'USD', 'https://example-partner-store.com/products/infrared-thermometer', 1, 'published')
ON DUPLICATE KEY UPDATE
  name = VALUES(name), description = VALUES(description), image = VALUES(image),
  price = VALUES(price), external_url = VALUES(external_url),
  sort_order = VALUES(sort_order), status = VALUES(status), deleted_at = NULL,
  uuid = uuid;
INSERT INTO products (uuid, slug, name, description, image, price, currency, external_url, sort_order, status)
VALUES ('8be66758-0eaf-50a9-8911-c18a08795c33', 'daily-pill-organizer', '7-Day Pill Organizer', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent at metus ac risus vehicula consectetur.', '/images/products/pill-organizer.jpg', 99.99, 'USD', 'https://example-partner-store.com/products/daily-pill-organizer', 2, 'published')
ON DUPLICATE KEY UPDATE
  name = VALUES(name), description = VALUES(description), image = VALUES(image),
  price = VALUES(price), external_url = VALUES(external_url),
  sort_order = VALUES(sort_order), status = VALUES(status), deleted_at = NULL,
  uuid = uuid;

-- ---------- testimonials ----------
DELETE FROM testimonials;
INSERT INTO testimonials (uuid, author_name, rating, quote, sort_order, status) VALUES ('1ec51dcf-93f6-534a-a492-bdb15adec750', 'Ayesha Malik', 5, 'Customer support was extremely helpful and responsive.', 0, 'published');
INSERT INTO testimonials (uuid, author_name, rating, quote, sort_order, status) VALUES ('04885b5a-fb83-54bc-b0e4-c15ed4a3781a', 'Ayesha Malik', 5, 'Customer support was extremely helpful and responsive.', 1, 'published');
INSERT INTO testimonials (uuid, author_name, rating, quote, sort_order, status) VALUES ('84a96338-3b36-5eb2-80e6-3fb44ef3e3a2', 'Ayesha Malik', 5, 'Customer support was extremely helpful and responsive.', 2, 'published');
INSERT INTO testimonials (uuid, author_name, rating, quote, sort_order, status) VALUES ('948399e2-9424-5960-a23e-241b726be87c', 'Ayesha Malik', 2, 'Customer support was extremely helpful and responsive.', 3, 'published');

-- ---------- core_values ----------
DELETE FROM core_values;
INSERT INTO core_values (icon, title, description, sort_order, is_active) VALUES ('dollar', 'Affordable Prices', 'Our prices are competitive and affordable. We aim to work with all budgets and promise to not overextend families financially.', 0, 1);
INSERT INTO core_values (icon, title, description, sort_order, is_active) VALUES ('sparkle', 'Experienced Care Experts', 'We have seasoned, licensed, and experienced care agents with over 100 years of combined service caring for families.', 1, 1);
INSERT INTO core_values (icon, title, description, sort_order, is_active) VALUES ('lock', 'Privacy is Important', 'We ensure secure platforms to protect identity and secure processes that protect our families from harmful acts.', 2, 1);
INSERT INTO core_values (icon, title, description, sort_order, is_active) VALUES ('heart', 'Dedication and Loyalty', 'Your family becomes our family. Our management team and care experts will care for your family like our own.', 3, 1);

-- ---------- about_stats ----------
DELETE FROM about_stats;
INSERT INTO about_stats (icon, title, sort_order, is_active) VALUES ('sparkle', 'Over 100 years of combined licensed experience', 0, 1);
INSERT INTO about_stats (icon, title, sort_order, is_active) VALUES ('shield', 'Certified Care Agents', 1, 1);
INSERT INTO about_stats (icon, title, sort_order, is_active) VALUES ('sliders', 'Custom Care Plan', 2, 1);

-- ---------- job_openings ----------
INSERT INTO job_openings (uuid, slug, title, employment_type, location, summary, sort_order, status)
VALUES ('8bb4c099-07e5-5786-afed-c88ac555b813', 'home-care-services', 'Home Care Services', 'Full-time / Part-time', 'Chester, SC', 'Support clients with non-medical daily living assistance.', 0, 'published')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), employment_type = VALUES(employment_type),
  location = VALUES(location), summary = VALUES(summary),
  sort_order = VALUES(sort_order), status = VALUES(status), deleted_at = NULL,
  uuid = uuid;
INSERT INTO job_openings (uuid, slug, title, employment_type, location, summary, sort_order, status)
VALUES ('12e49bf9-d916-52cc-973c-163958a92cec', 'personal-care-aide', 'Personal Care Aide', 'Full-time / Part-time', 'Chester, SC', 'Assist with bathing, dressing, grooming, and mobility.', 1, 'published')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), employment_type = VALUES(employment_type),
  location = VALUES(location), summary = VALUES(summary),
  sort_order = VALUES(sort_order), status = VALUES(status), deleted_at = NULL,
  uuid = uuid;
INSERT INTO job_openings (uuid, slug, title, employment_type, location, summary, sort_order, status)
VALUES ('ca2661bc-2d34-5335-bc12-1048cefacfbf', 'companion-care', 'Companion Care', 'Part-time', 'Chester, SC', 'Provide companionship, conversation, and social engagement.', 2, 'published')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), employment_type = VALUES(employment_type),
  location = VALUES(location), summary = VALUES(summary),
  sort_order = VALUES(sort_order), status = VALUES(status), deleted_at = NULL,
  uuid = uuid;
INSERT INTO job_openings (uuid, slug, title, employment_type, location, summary, sort_order, status)
VALUES ('a06933da-cab3-52e7-993b-50a004102144', 'certified-nurse-assistant', 'Certified Nurse Assistant (CNA)', 'Full-time', 'Chester, SC', 'Deliver hands-on personal care under RN supervision.', 3, 'published')
ON DUPLICATE KEY UPDATE
  title = VALUES(title), employment_type = VALUES(employment_type),
  location = VALUES(location), summary = VALUES(summary),
  sort_order = VALUES(sort_order), status = VALUES(status), deleted_at = NULL,
  uuid = uuid;

