--liquibase formatted cypher
--changeset gmaroulis:NR-3015_add_missing_subaccounts runAlways:true

UNWIND [
  "NL33X1900016",
  "NLE3T1400069",
  "NLE3T1400071",
  "NLE3T1400073",
  "NLE3T1400075",
  "NLE3T1400077",
  "NLE3T1400079",
  "NLE3T1400081",
  "NLE3T1400083",
  "NLE3T1400085",
  "NLE3T1400087",
  "NLE3T1400089",
  "NLE3T1400092",
  "NLE3T1400094",
  "NLE3T1400096",
  "NLE3T1400097",
  "NLE3T1900000",
  "NLE3T1400098",
  "NLE3T1900005",
  "NLE3T1900006",
  "NLE3T1900007",
  "NLE3T1900008",
  "NLE3T1900009",
  "NLE3T2000001",
  "NLE3T2000003",
  "NLE3T2000004",
  "NLE3T2000005",
  "NLEST2100001",
  "NLEST2100002",
  "NLEST2100003",
  "NLEST2100004"
] as isrc
MATCH (s:NrSoundRecording:NrOwnership)-[r:HAS_OWNERSHIP_RULE_MONETIZE]->(se:NrOwnershipService)
  WHERE s.isrc=isrc and r.vendorId = 68250
SET r.subaccountId = 0,
    r.percentage = toFloat(r.percentage);