__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
WHERE SCRIPT_FILE_NAME = 'FW45010_POSTDATA_UGBUPD-1185B.SQL'
   AND END_DTTM IS NOT NULL
/
__THEN__
__EXIT__
__ENDIF__

-- Latest upgrade logic  

UPDATE F1_CRYPTO_KEY_RING SET KEY_RING_CAT_FLG  = 'F1OA'  WHERE KEY_RING_CLASS_FLG='F1OA' AND (TRIM(KEY_RING_CAT_FLG) IS NULL or KEY_RING_CAT_FLG = 'F1EX')
/

UPDATE F1_CRYPTO_KEY_RING SET BUS_OBJ_CD = 'F1-InternalEncryptionKey' WHERE KEY_RING_CLASS_FLG='F1EN' AND KEY_RING_CAT_FLG = 'F1IN'
/
