-- Licensed Materials - Property of IBM
-- BI and PM: Mobile
-- (C) Copyright IBM Corp. 2013
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
-- 
-- Generated by: com.cognos.mobile.internal.server.database.schemagenerator.SchemaGenerator
-- 
CREATE TRIGGER TGR_MOB_SKR_SYNC_DE
DELETE ON MOB_RENDERS_BY_GROUP
REFERENCING OLD AS pre
FOR EACH ROW (
	DELETE FROM MOB_RENDERS WHERE RENDER_ID = pre.RENDER_ID,
	UPDATE MOB_USERS SET LAST_UPDATED = CURRENT YEAR TO SECOND
);