USE db_abos_v0.1;

-- One-off content fix: remove em-dashes from TechMAC's CMS-authored entries (site_id 6),
-- which read as AI-generated boilerplate. Uses JSON_SET on the specific field so nothing
-- else in each entry's data_json is touched.

UPDATE fact_web_entries
SET data_json = JSON_SET(data_json, '$.description',
    'One platform for CRM, Finance, HR, Projects, Procurement, and your public website, with role-based access so admins, managers and staff each only see what they''re provisioned for, from onboarding to daily use.')
WHERE id = 38 AND site_id = 6;

UPDATE fact_web_entries
SET data_json = JSON_SET(data_json, '$.description',
    'Integration engineering and agentic architecture: the layer that makes your systems reason instead of wait.')
WHERE id = 44 AND site_id = 6;

UPDATE fact_web_entries
SET data_json = JSON_SET(data_json, '$.answer',
    'Yes, that is the core of the work. The integration layer holds explicit contracts to the systems you keep, validated at every boundary.')
WHERE id = 63 AND site_id = 6;

-- Homepage layout_json (dim_web_pages.id = 19, site_id = 6): hero subheading and ticker lines.
UPDATE dim_web_pages
SET layout_json = JSON_SET(
        layout_json,
        '$.blocks[0].props.subheading',
        'We engineer bespoke ecosystems that unify CRM, ERP and CMS into a single intelligent engine, so your systems stop needing a human to bridge them.',
        '$.blocks[1].props.lines[0]',
        'SYS.ERR: CRM and ERP disagree on 1,412 records',
        '$.blocks[1].props.lines[1]',
        'DIAGNOSING: mapping manual bridges across 4 systems',
        '$.blocks[1].props.lines[2]',
        'DEPLOYED: agentic sync live, 0 manual handovers'
    )
WHERE id = 19 AND site_id = 6;

-- Form success messages (dim_web_forms, site_id = 6).
UPDATE dim_web_forms
SET success_message = 'Thanks. The architects will get back to you shortly.'
WHERE id = 16 AND site_id = 6;

UPDATE dim_web_forms
SET success_message = 'Thanks, we will be in touch to schedule your discovery call (Mon-Fri, 18:00-22:00 UK).'
WHERE id = 15 AND site_id = 6;