analytics/configuration/schemas/mobile/oracle/upgrade-02-006-to-02-007.sql

-- Licensed Materials - Property of IBM
-- BI and PM: Mobile
-- (C) Copyright IBM Corp. 2007, 2012
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

CREATE OR REPLACE TRIGGER TGR_MOB_UR_SYNC_UP 
AFTER UPDATE ON MOB_USER_RENDER
REFERENCING NEW AS pre
FOR EACH ROW
BEGIN
	UPDATE MOB_USERS SET LAST_UPDATED = SYSDATE
		WHERE USER_ID = :pre.USER_ID;
END;
/