HEX
Server: Apache/2.2.15 (CentOS)
System: Linux ip-10-0-2-146.eu-west-1.compute.internal 2.6.32-754.35.1.el6.centos.plus.x86_64 #1 SMP Sat Nov 7 11:33:42 UTC 2020 x86_64
User: root (0)
PHP: 5.6.40
Disabled: NONE
Upload Files
File: /www/exchange2/sql/custom/TK92904-fix-CM-role-mapping-entries.sql
/* Update Queries for TK92904 */

/* Jeremiah & Joan Kirby, Investor ID: 20211214002161 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2434 WHERE entity_id = 1144 AND entity_type = 2;

/* Bernice Galvin, Investor ID: 20190905001812 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2176 WHERE entity_id = 886 AND entity_type = 2;

/* Una Aisling Sheehan PRB, Investor ID: 20210609002069 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2358 WHERE entity_id = 1069 AND entity_type = 2;

/* Ronnie Dorney, Investor ID: 20160316000656 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1604 WHERE entity_id = 330 AND entity_type = 2;

/* Helen and Pat Casey, Investor ID: 20131115000094 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1288 WHERE entity_id = 40 AND entity_type = 2;

/* Catherine Murray, Investor ID: 20180607001530 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1981 WHERE entity_id = 697 AND entity_type = 2;

/* Deirdre Seery ARF, Investor ID: 20171124001333 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1892 WHERE entity_id = 610 AND entity_type = 2;

/* Stephen Patchett PRSA, Investor ID: 20220518002257 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2492 WHERE entity_id = 1198 AND entity_type = 2;

/* Edward McAuliffe PRSA, Investor ID: 20220506002252 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2488 WHERE entity_id = 1194 AND entity_type = 2;

/* Patrick & Laura Murphy, Investor ID: 20210513002052 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2345 WHERE entity_id = 1056 AND entity_type = 2;

/* Helena Mary Grogan PRSA, Investor ID: 20220406002236 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2473 WHERE entity_id = 1181 AND entity_type = 2;

/* Mary O'Connor, Investor ID: 20220411002241 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 2477 WHERE entity_id = 1184 AND entity_type = 2;

/* Phillip Parsons, Investor ID: 20170117001004 */
/* Fixes for the relationship for Role Mapping in Credebt Machine DB */
UPDATE public.ledgers_role_mapping SET entity_id = 1731 WHERE entity_id = 455 AND entity_type = 2;