upgrade-03-001-to-03-002.sql 547 B

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