--liquibase formatted cypher
--changeset jmarais:update_agreement_nodes

MATCH (a:PublishingAgreement)<-[rel:HAS_AGREEMENT]-(p:PublishingPublisher)
WHERE a.pubPublisherID <> p.pubPublisherID
SET
    a.pubPublisherID = p.pubPublisherID,
    a.lastModifiedBy = 'database/PUB-1272_update_agreement_nodes',
    a.lastModifiedAt = datetime()