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

RENAME COLUMN MOB_USERS.CAM_ID to CAM_ID_OLD;
ALTER TABLE MOB_USERS ADD CAM_ID LVARCHAR(1024);
UPDATE MOB_USERS SET MOB_USERS.CAM_ID = MOB_USERS.CAM_ID_OLD; 
ALTER TABLE MOB_USERS DROP CAM_ID_OLD;

ALTER TABLE MOB_BLOBS ADD TOTAL_BLOB_SIZE INT;