-- 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			varchar (512),
	KCATALOG		varchar (512),
	CPHYSDEF		clob(10M),
	CPHYSANAL		clob(10M),
	CBASEDEF		clob(10M),
	CBASEANAL		clob(10M),
	STATUSID		smallint,
	SNAPSHOT       	clob(1M),
	HISTORY       	clob(10M),
	SNAPSHOTENBL	decimal(1,0),
	DEPLOYREFS		clob(1M),
	ALIASROOT		varchar (512),
	CONSTRAINT PK_CMOBJPROPS86 PRIMARY KEY (CMID) 
)

ALTER TABLE CMOBJPROPS48 ADD column MAXSTORESZMB integer

!RunCMScript CMUpgradeScript_capabilities_58.xml

!RunCMScript CMUpgradeScript_configuration_update_40.xml


