analytics/configuration/schemas/mobile/oracle/initialize-schema-version-table.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.

--
-- Mobile database table creation scripts for MS SQL 2000.

-- MOB_SCHEMA_VERSION
DECLARE
	TABLE_EXISTS_EXCEPTION EXCEPTION;
	PRAGMA EXCEPTION_INIT (TABLE_EXISTS_EXCEPTION, -955);
BEGIN
	EXECUTE IMMEDIATE 'CREATE TABLE MOB_SCHEMA_VERSION ( MAJOR INT NOT NULL, MINOR INT NOT NULL, SUBMINOR VARCHAR (4) NULL )';
	EXECUTE IMMEDIATE 'INSERT INTO MOB_SCHEMA_VERSION (MAJOR, MINOR) values (0, 0)';
EXCEPTION
	WHEN TABLE_EXISTS_EXCEPTION THEN
		NULL;
END;
/