-- 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			int not null,
	KSCHEMA			nvarchar (256) null,
	KCATALOG		nvarchar (256) null,
	CPHYSDEF		ntext null,
	CPHYSANAL		ntext null,
	CBASEDEF		ntext null,
	CBASEANAL		ntext null,
	STATUSID		tinyint null,
	SNAPSHOT       	ntext null,
	HISTORY       	ntext null,
	SNAPSHOTENBL	bit null,
	DEPLOYREFS		ntext null,
	ALIASROOT		nvarchar (256) null,
	CONSTRAINT PK_CMOBJPROPS86 PRIMARY KEY (CMID) 
)

alter table CMOBJPROPS48 add MAXSTORESZMB int null

!RunCMScript CMUpgradeScript_capabilities_58.xml

!RunCMScript CMUpgradeScript_configuration_update_40.xml