--liquibase formatted cypher
--changeset mstead:ACC-8360_create_abacus_profile
MATCH (v:Vendor {id: "*"})
MATCH (i:Identity)
WHERE i.id = '8fa71ad1-f02c-4191-8c78-9ffa45b57346'
MERGE (increment:IncrementId {nodeName: 'Profile'})
    ON CREATE SET increment.id = 2
    ON MATCH SET increment.id = increment.id + 1
CREATE (p:Profile {
    profileId: (increment.id-1),
    profileType: 'AbacusProfile',
    profileName: i.name,
    uuid: apoc.create.uuid(),
    roles: ['administrator'],
    fullCatalogAccess: true,
    brand: 'orchard',
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    createdBy: 'database/ACC-8360_create_abacus_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1',
    lastModifiedBy: 'database/ACC-8360_create_abacus_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1'
})
MERGE (i)-[:HAS_PROFILE]->(p)
MERGE (p)-[:HAS_ACCESS_TO]->(v)
RETURN i,p;