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

create table CMOBJPROPS86 (
	CMID			integer not null,
	KSCHEMA			lvarchar (256),
	KCATALOG		lvarchar (256),
	CPHYSDEF		clob,
	CPHYSANAL		clob,
	CBASEDEF		clob,
	CBASEANAL		clob,
	STATUSID		smallint,
	SNAPSHOT       	clob,
	HISTORY       	clob,
	SNAPSHOTENBL	decimal(1,0),
	DEPLOYREFS		clob,
	ALIASROOT		lvarchar (256),
	primary key (CMID) constraint PK_CMOBJPROPS86 
) lock mode row;

ALTER TABLE CMOBJPROPS48 ADD MAXSTORESZMB integer;

!RunCMScript CMUpgradeScript_capabilities_58.xml

!RunCMScript CMUpgradeScript_configuration_update_40.xml

