analytics/configuration/schemas/mobile/db2zOS/upgrade-02-000-to-02-000d.sql

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

--
--  Modifications:
--
--  1) Change COGMOBDB  to the desired database name.
--  2) Change DB0AUSR   to the desired storage group name.
--  3) Note: CCSID is an estimated value, your requirements may differ.
--

ALTER TABLE MOB_RENDERS DROP CONSTRAINT FK_MOB_R_RSID
/
ALTER TABLE MOB_USER_RENDER DROP CONSTRAINT FK_MOB_UR_UID
/
ALTER TABLE MOB_USER_RENDER DROP CONSTRAINT FK_MOB_UR_RID
/
ALTER TABLE MOB_USER_RESOURCE DROP CONSTRAINT FK_MOB_URS_UID
/
ALTER TABLE MOB_USER_RESOURCE DROP CONSTRAINT FK_MOB_URS_RSID
/
ALTER TABLE MOB_BLOBS DROP CONSTRAINT FK_MOB_BLOBS_RID
/
ALTER TABLE MOB_BLOBS DROP CONSTRAINT FK_MOB_BLOBS_RSID
/
ALTER TABLE MOB_USER_HISTORY DROP CONSTRAINT FK_MOB_UH_UID
/
ALTER TABLE MOB_USER_HISTORY DROP CONSTRAINT FK_MOB_UH_HID
/
ALTER TABLE MOB_RENDER_HISTORY DROP CONSTRAINT FK_MOB_RH_RID
/
ALTER TABLE MOB_RENDER_HISTORY DROP CONSTRAINT FK_MOB_RH_HID
/
DROP TABLE MOB_USER_RESOURCE
/
DROP TABLE MOB_USER_RESOURCE_TYPES
/
DROP TABLE MOB_RESOURCES
/
DROP TABLE MOB_BLOBS
/
DROP TABLE MOB_USER_HISTORY
/
DROP TABLE MOB_RENDER_HISTORY
/
DROP TABLE MOB_HISTORY
/
DROP TABLE MOB_USER_RENDER
/
DROP TABLE MOB_USERS
/
DROP TABLE MOB_RENDERS
/
DROP TABLE MOB_BLOB_FORMATS
/
DROP TABLE MOB_SOURCE_CODES
/
DROP TABLE MOB_STATUS_CODES
/