analytics/configuration/schemas/content/informix/dbUpgrade7_0003-to-7_0004_informix.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 smallint;

alter table CMOBJPROPS31 add REPOSAUDITLVL smallint;

alter table CMOBJPROPS31 add SACAMAUDITLVL smallint;

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


alter table CMOBJPROPS48 add RMDSCONS integer;

alter table CMOBJPROPS48 add RMDSPEAKCONS integer;

alter table CMOBJPROPS48 add QSVERBGCLOGLIMIT integer;

alter table CMOBJPROPS48 add QSMDQUERYSIZELIMIT integer;

alter table CMOBJPROPS48 add QSGENCOMINNATSQL decimal(1,0);

alter table CMOBJPROPS48 add QSDISVERBGCLOG decimal(1,0);

alter table CMOBJPROPS48 add QSINITNURSESIZE integer;

alter table CMOBJPROPS48 add QSNURSESIZELIMIT integer;

alter table CMOBJPROPS48 add QSGCPOLICY smallint;


alter table CMOBJPROPS23 add QSRMEMCACHEROOT lvarchar(256);

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


delete from CMREFNOORD1 where PROPID=54

!RunCMScript CMUpgradeScript_configuration_update_38.xml