-- Licensed Materials - Property of IBM
-- BI and PM: Mobile
-- (C) Copyright IBM Corp. 2012, 2013
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

DROP INDEX [IDX_CAM_ID] ON [MOB_USERS]
ALTER TABLE [MOB_USERS] ALTER COLUMN [CAM_ID] nvarchar (1024) NULL
CREATE INDEX [IDX_CAM_ID] ON [MOB_USERS]([CAM_ID])

ALTER TABLE [MOB_BLOBS] ADD [TOTAL_BLOB_SIZE] int NULL