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

--
-- Mobile database table creation scripts for IBM DB2 on z/OS.
--
--  Modifications:
--
--  1) Change COGMOBDB  to the desired database name.
--  2) Note: CCSID is an estimated value, your requirements may differ.

-- MOB_SCHEMA_VERSION

CREATE TABLE MOB_SCHEMA_VERSION (
	MAJOR int NOT NULL,
	MINOR int NOT NULL,
	SUBMINOR varchar (4)
) IN COGMOBDB.COGMOBTS CCSID UNICODE
/
INSERT INTO MOB_SCHEMA_VERSION (MAJOR, MINOR) values (0, 0)
/