analytics/configuration/schemas/content/oracle/dbUpgrade7_0003-to-7_0004_oracle.sql

-- 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 number(3) null,
				REPOSAUDITLVL number(3) null,
				SACAMAUDITLVL number(3) null);

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

alter table CMOBJPROPS48 add (
				RMDSCONS  number(10) null,
				RMDSPEAKCONS number(10) null,
				QSVERBGCLOGLIMIT number(10) null,
				QSMDQUERYSIZELIMIT number(10) null,
				QSGENCOMINNATSQL number(1) null,
				QSDISVERBGCLOG number(1) null,
				QSINITNURSESIZE number(10) null,
				QSNURSESIZELIMIT number(10) null,
				QSGCPOLICY number(3) null);

alter table CMOBJPROPS23 add (
				QSRMEMCACHEROOT varchar2(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