--liquibase formatted cypher

--changeset cbeesley:IN-16797-1 runOnChange:true
-- Merge duplicate GlobalParticipant into canonical GP ba40487d-4781-4aef-b679-a2275d6a1112
MATCH (duplicate:GlobalParticipant {id: 'f67a8f7b-5ec9-4658-a22b-191f6e47eef9'})
MATCH (canonical:GlobalParticipant {id: 'ba40487d-4781-4aef-b679-a2275d6a1112'})
MERGE (duplicate)-[:MERGED_TO]->(canonical);

--rollback MATCH (duplicate:GlobalParticipant {id: 'f67a8f7b-5ec9-4658-a22b-191f6e47eef9'})-[r:MERGED_TO]->(canonical:GlobalParticipant {id: 'ba40487d-4781-4aef-b679-a2275d6a1112'}) DELETE r;

--changeset cbeesley:IN-16797-2 runOnChange:true
-- Merge duplicate GlobalParticipant into canonical GP ba40487d-4781-4aef-b679-a2275d6a1112
MATCH (duplicate:GlobalParticipant {id: '72165b8f-7ff2-432c-867f-800d1ff46c1f'})
MATCH (canonical:GlobalParticipant {id: 'ba40487d-4781-4aef-b679-a2275d6a1112'})
MERGE (duplicate)-[:MERGED_TO]->(canonical);

--rollback MATCH (duplicate:GlobalParticipant {id: '72165b8f-7ff2-432c-867f-800d1ff46c1f'})-[r:MERGED_TO]->(canonical:GlobalParticipant {id: 'ba40487d-4781-4aef-b679-a2275d6a1112'}) DELETE r;

--changeset cbeesley:IN-16797-3 runOnChange:true
-- Merge duplicate GlobalParticipant into canonical GP ba40487d-4781-4aef-b679-a2275d6a1112
MATCH (duplicate:GlobalParticipant {id: '6be99984-3d4b-49ea-a3c0-14cd1accb868'})
MATCH (canonical:GlobalParticipant {id: 'ba40487d-4781-4aef-b679-a2275d6a1112'})
MERGE (duplicate)-[:MERGED_TO]->(canonical);

--rollback MATCH (duplicate:GlobalParticipant {id: '6be99984-3d4b-49ea-a3c0-14cd1accb868'})-[r:MERGED_TO]->(canonical:GlobalParticipant {id: 'ba40487d-4781-4aef-b679-a2275d6a1112'}) DELETE r;

--changeset cbeesley:IN-16797-4 runOnChange:true
-- Merge duplicate GlobalParticipant into canonical GP ba40487d-4781-4aef-b679-a2275d6a1112
MATCH (duplicate:GlobalParticipant {id: '74eba591-d67a-4500-8fc1-922dce417003'})
MATCH (canonical:GlobalParticipant {id: 'ba40487d-4781-4aef-b679-a2275d6a1112'})
MERGE (duplicate)-[:MERGED_TO]->(canonical);

--rollback MATCH (duplicate:GlobalParticipant {id: '74eba591-d67a-4500-8fc1-922dce417003'})-[r:MERGED_TO]->(canonical:GlobalParticipant {id: 'ba40487d-4781-4aef-b679-a2275d6a1112'}) DELETE r;