upgrade-02-003-to-02-004.sql 422 B

123456789101112
  1. -- Licensed Materials - Property of IBM
  2. -- BI and PM: Mobile
  3. -- (C) Copyright IBM Corp. 2007, 2012
  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  5. CREATE TRIGGER TGR_M_UPI_SYNC_DE
  6. AFTER DELETE ON MOB_USER_PORTALITEM
  7. REFERENCING OLD AS pre
  8. FOR EACH ROW
  9. UPDATE MOB_USERS SET LAST_UPDATED = CURRENT_TIMESTAMP
  10. WHERE USER_ID = pre.USER_ID
  11. /