-- 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.

ALTER TABLE [MOB_USERS] ADD [LAST_UPDATED] datetime DEFAULT GETDATE() NOT NULL

ALTER TABLE [MOB_USER_RESOURCE] DROP CONSTRAINT [PK_MOB_USERRSRC]
ALTER TABLE [MOB_USER_RESOURCE] ADD CONSTRAINT [PK_MOB_USERRSRC] PRIMARY KEY([USER_ID], [RESOURCE_ID], [USER_RESOURCE_TYPE])