\c pam-simulator
UPDATE pam_message_id_generator set oid = '#root_oid#.4' where issuing_actor_id = 1 ;
UPDATE pam_message_id_generator set oid = '#root_oid#.5' where issuing_actor_id = 2;
UPDATE pam_message_id_generator set oid = '#root_oid#.6' where issuing_actor_id = 5;
UPDATE pam_message_id_generator set oid = '#root_oid#.7' where issuing_actor_id = 6;
UPDATE pam_message_id_generator set oid = '#root_oid#.8' where issuing_actor_id = 7;
UPDATE pam_message_id_generator set oid = '#root_oid#.18' where issuing_actor_id = 12;
UPDATE pam_message_id_generator set oid = '#root_oid#.17' where issuing_actor_id = 11;

\c gazelle-hl7-validator
UPDATE oid_generator SET root = '#root_oid#.3.2.' where target = 'message';
UPDATE oid_generator SET root = '#root_oid#.3.3.' where target = 'profile';
UPDATE oid_generator SET root = '#root_oid#.3.1.' where target = 'resource';

\c evs-client-prod
UPDATE evsc_calling_tool set oid = '#root_oid#.1.2' where tool_type = 1;
UPDATE evsc_calling_tool set oid = '#root_oid#.1.22' where tool_type = 2 and label = 'GWT';
UPDATE evsc_calling_tool set oid = '#root_oid#.1.22.1' where tool_type = 2 and label = 'GWT_oid_mock';
UPDATE evsc_calling_tool set oid = '#root_oid#.1.21' where tool_type = 0;

\c evsclient
UPDATE evsc_calling_tool set oid = '#root_oid#.1.2' where tool_type = 1;
UPDATE evsc_calling_tool set oid = '#root_oid#.1.22' where tool_type = 2 and label = 'GWT';
UPDATE evsc_calling_tool set oid = '#root_oid#.1.22.1' where tool_type = 2 and label = 'GWT_oid_mock';
UPDATE evsc_calling_tool set oid = '#root_oid#.1.21' where tool_type = 0;
