Unified Navigation refresh SQL Script

I am using Unified Navigation in my Portal (Interaction Hub) environment. When a database that is refreshed from production I needed a quick way to update the Unified Navigation configuration information with SQL. Here is the updates I have found useful in my environment. 

--Interaction Hub Unified Navigation refresh:

--Remote Content

UPDATE PS_PTUN_DDMENUCFG

SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%'), 

DESCR30 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%'),

PORTAL_OBJNAME1 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%') || ':PORTAL_ROOT_OBJECT'

WHERE MSGNODENAME = '<HR_PRODUCTION_NODE>';

UPDATE PS_PTUN_DDMENUCFG

SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%'), 

DESCR30 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%'),

PORTAL_OBJNAME1 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%') || ':PORTAL_ROOT_OBJECT'

WHERE MSGNODENAME = '<CS_PRODUCTION_NODE>';

--Message Nodes

--HCM Node

UPDATE PSUN_CFGHNODE

SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')

WHERE MSGNODENAME = '<HR_PRODUCTION_NODE>';

--Campus Node

UPDATE PSUN_CFGHNODE

SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')

WHERE MSGNODENAME = '<CS_PRODUCTION_NODE>';

--Structure & Content

UPDATE PSPRSMDEFN 

SET PORTAL_LABEL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')

WHERE PORTAL_CNTPRV_NAM = '<HR_PRODUCTION_NODE>';

UPDATE PSPRSMDEFN 

SET PORTAL_LABEL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')

WHERE PORTAL_CNTPRV_NAM = '<CS_PRODUCTION_NODE>';

--Folder Attributes

UPDATE PSPRSMSYSATTRVL 

SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')

WHERE PORTAL_ATTR_VAL LIKE '<HR_PRODUCTION_NODE>';

UPDATE PSPRSMSYSATTRVL 

SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')

WHERE PORTAL_ATTR_VAL LIKE '<CS_PRODUCTION_NODE>';

UPDATE PSPRSMSYSATTRVL 

SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%') || ':PORTAL_ROOT_OBJECT'

WHERE PORTAL_ATTR_VAL LIKE 'CS%ROOT%';

UPDATE PSPRSMSYSATTRVL 

SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%') || ':PORTAL_ROOT_OBJECT'

WHERE PORTAL_ATTR_VAL LIKE 'HR%ROOT%';