-- 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			number(10) NOT NULL ,
	KSCHEMA			varchar2 (256)  NULL,
	KCATALOG		varchar2 (256)  NULL,
	CPHYSDEF		clob null,
	CPHYSANAL		clob null,
	CBASEDEF		clob null,
	CBASEANAL		clob null,
	STATUSID		number(3) NULL,
	SNAPSHOT       	clob null,
	HISTORY       	clob null,
	SNAPSHOTENBL	number(1) NULL,
	DEPLOYREFS		clob null,
	ALIASROOT		varchar2 (256)  NULL,
	CONSTRAINT PK_CMOBJPROPS86 PRIMARY KEY (CMID) 
);

alter table CMOBJPROPS48 add MAXSTORESZMB number(10) null;

!RunCMScript CMUpgradeScript_capabilities_58.xml

!RunCMScript CMUpgradeScript_configuration_update_40.xml