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

alter table CMOBJPROPS31 add
			   IDVIZAUDITLVL tinyint null,
			   REPOSAUDITLVL tinyint null,
			   SACAMAUDITLVL tinyint null

insert into CMOBJPROPS31(CMID) select CMID from CMOBJECTS
		where (CLASSID in (240))

alter table CMOBJPROPS48 add
			   RMDSCONS  int null,
			   RMDSPEAKCONS int null,
			   QSVERBGCLOGLIMIT int null,
			   QSMDQUERYSIZELIMIT int null,
			   QSGENCOMINNATSQL bit null,
			   QSDISVERBGCLOG bit null,
			   QSINITNURSESIZE int null,
			   QSNURSESIZELIMIT int null,
			   QSGCPOLICY tinyint null

alter table CMOBJPROPS23 add
				QSRMEMCACHEROOT nvarchar(256) null

insert into CMOBJPROPS23(CMID) select CMID from CMOBJECTS where (CLASSID=227)

delete from CMREFNOORD1 where PROPID=54

!RunCMScript CMUpgradeScript_configuration_update_38.xml