--liquibase formatted cypher

--changeset tnozhkina:1 runOnChange:true

MERGE (incId1:IncrementId {nodeName: 'Profile'})
    ON MATCH SET incId1.id = incId1.id + 1
CREATE (ap:Profile {profileId: (incId1.id-1), profileType: 'Account360Profile'})
    SET ap.profileName = 'vzhyvotkov+readonly Account360Profile',
        ap.roles = ['account360'],
        ap.uuid = apoc.create.uuid(),
        ap.createdAt = datetime(),
        ap.createdBy = 'database/PLATFORM-4451'
WITH ap
MATCH (i:Identity {email: 'vzhyvotkov+readonly@sonymusic-pde.com'})
MERGE (i)-[rel:HAS_PROFILE]->(ap)
    SET rel.createdAt = datetime(),
        rel.createdBy = 'database/PLATFORM-4451'
WITH ap
MATCH (v:Vendor { id: 7123 })
MERGE (ap)-[:HAS_ADMIN_ACCESS_TO]->(v)
SET ap.fullCatalogAccess = true