analytics/configuration/schemas/content/db2/dbUpgrade5_0017-to-5_0018_db2.sql

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

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).

alter table CMOBJPROPS31 add column STSAUDITLVL smallint

alter table CMOBJPROPS67 add column STSAFFCONS integer

alter table CMOBJPROPS67 add column STSEXECLMT integer

alter table CMOBJPROPS67 add column STSCMAXPROCS integer

alter table CMOBJPROPS67 add column STSNONAFFCONS integer

alter table CMOBJPROPS67 add column STSPEAKAFFCONS integer

alter table CMOBJPROPS67 add column STSPEAKMAXPROCS integer

alter table CMOBJPROPS67 add column STSPEAKNONAFFCONS integer

alter table CMOBJPROPS31 add column ANSAUDITLVL smallint

alter table CMOBJPROPS58 add column ANSANNOTATIONLIFE	varchar (50)

!RunCMScript CMUpgradeScript_configuration_update_29.xml

!RunCMScript CMUpgradeScript_cognos_roles_11_add.xml

!RunCMScript CMUpgradeScript_cognos_roles_11_update.xml