--liquibase formatted cypher
--changeset ingaku:REVIEW-2395_grant_profile_vendor_access

MATCH (p:Profile {profileType: 'ContentProfile', uuid: 'd5c965e6-7606-4030-ae87-661a9bc9b293'})
MATCH (v:Vendor {vendorId: '*', id: '*'})
MATCH (p)-[r:DELETED_HAS_ACCESS_TO]->(v)
DELETE r
MERGE (p)-[:HAS_ACCESS_TO]->(v)
RETURN p;