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


--CMSCRIPT_UPGRADE_SKIP_COMMAND(5.00010102,5.0002)
ALTER TABLE CMOBJPROPS31 ADD EVSAUDITLVL	integer;

--CMSCRIPT_UPGRADE_SKIP_COMMAND(5.00010102,5.0002)
CREATE TABLE CMOBJPROPS74 (
	CMID      	integer not null,
	DEPLOYREFS	clob,
	LAUNCHTYPE	lvarchar (512),
	SPEC		blob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS74
) lock mode row;

--CMSCRIPT_UPGRADE_SKIP_COMMAND(5.00010102,5.0002)
create index CMSCRIPT_CS_IDIDX_LAUNCHTYPE on CMOBJPROPS74(LAUNCHTYPE);