\c pam-simulator
UPDATE app_configuration SET value = '#root_oid#.1.1' where variable = 'application_universal_id';
UPDATE app_configuration SET value = '#PAMnamespaceID#' where variable = 'application_namespace_id';
UPDATE app_configuration SET value = '#root_oid#.1.12' where variable = 'hl7v3_organization_oid';
UPDATE app_configuration SET value = '#root_oid#.1.13' where variable = 'hl7v3_pdq_pdc_device_id';
UPDATE app_configuration SET value = '#root_oid#.1.14' where variable = 'hl7v3_pdq_pds_device_id';
UPDATE app_configuration SET value = '#root_oid#.1.8' where variable = 'hl7v3_pix_consumer_device_id';
UPDATE app_configuration SET value = '#root_oid#.1.10' where variable = 'hl7v3_pix_mgr_device_id';
UPDATE app_configuration SET value = '#root_oid#.1.9' where variable = 'hl7v3_pix_organisation_oid';
UPDATE app_configuration SET value = '#root_oid#.1.10' where variable = 'hl7v3_pix_mgr_device_id';
UPDATE app_configuration SET value = '#root_oid#.1.11' where variable = 'hl7v3_pix_src_device_id';
UPDATE app_configuration SET value = '#root_oid#.1.15' where variable = 'hl7v3_xcpd_initgw_device_id';
UPDATE app_configuration SET value = '#root_oid#.1.16' where variable = 'hl7v3_xcpd_respgw_device_id';
UPDATE app_configuration SET value = '#root_oid#.12' where variable = 'hl7v3_xcpd_initgw_home_community_id';
UPDATE app_configuration SET value = '#root_oid#.12' where variable = 'hl7v3_xcpd_respgw_home_community_id';
UPDATE pam_message_id_generator set oid = '#root_oid#.1.4' where issuing_actor_id = 1 ;
UPDATE pam_message_id_generator set oid = '#root_oid#.1.5' where issuing_actor_id = 2;
UPDATE pam_message_id_generator set oid = '#root_oid#.1.6' where issuing_actor_id = 5;
UPDATE pam_message_id_generator set oid = '#root_oid#.1.7' where issuing_actor_id = 6;
UPDATE pam_message_id_generator set oid = '#root_oid#.1.8' where issuing_actor_id = 7;
UPDATE pam_message_id_generator set oid = '#root_oid#.1.18' where issuing_actor_id = 12;
UPDATE pam_message_id_generator set oid = '#root_oid#.1.17' where issuing_actor_id = 11;

\c order-manager
UPDATE app_configuration set value = '#root_oid#.8.8' where variable = 'analyzer_serial_number';
UPDATE om_number_generator set universal_id = '#root_oid#.8.3' where namespace_id = 'IHE_OM_ANALYZER_MGR';
UPDATE om_number_generator set universal_id = '#root_oid#.8.4' where namespace_id = 'IHE_OM_ANALYZER';
UPDATE om_number_generator set universal_id = '#root_oid#.8.5' where namespace_id = 'IHE_OM_OF';
UPDATE om_number_generator set universal_id = '#root_oid#.8.6' where namespace_id = 'IHE_OM_OP';
UPDATE om_number_generator set universal_id = '#root_oid#.8.7' where namespace_id = 'IHE_OM_AM';

\c demographic-data-server
UPDATE app_configuration SET value = '#root_oid#.9' where variable = 'DDS_OID';

\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 gazelle
UPDATE cmn_application_preference set preference_value = '#root_oid#.2' where preference_name = 'app_instance_oid';

\c evs-client-prod
UPDATE cmn_application_preference set preference_value = '#root_oid#.13.' where preference_name = 'root_oid';
UPDATE evsc_calling_tool set oid = '#root_oid#.2' where tool_type = 1;

\c gss
UPDATE app_configuration SET value='#root_oid#.4.1' WHERE variable='audit_message_root_oid';
UPDATE app_configuration SET value='#root_oid#.4.2' WHERE variable='proxy_oid';

\c gazelle-webservice-tester
UPDATE app_configuration SET value='#root_oid#.13' WHERE variable='tool_instance_oid';
