upgrade-02-001-to-02-002.sql 500 B

123456789
  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. ALTER TABLE [MOB_USERS] ADD [LAST_UPDATED] datetime DEFAULT GETDATE() NOT NULL
  6. ALTER TABLE [MOB_USER_RESOURCE] DROP CONSTRAINT [PK_MOB_USERRSRC]
  7. ALTER TABLE [MOB_USER_RESOURCE] ADD CONSTRAINT [PK_MOB_USERRSRC] PRIMARY KEY([USER_ID], [RESOURCE_ID], [USER_RESOURCE_TYPE])