analytics/configuration/schemas/content/sqlserver/dbUpgrade5_0017-to-5_0018_mssqlserver.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 STSAUDITLVL tinyint null

alter table CMOBJPROPS67 add STSAFFCONS int null

alter table CMOBJPROPS67 add STSEXECLMT int null

alter table CMOBJPROPS67 add STSCMAXPROCS int null

alter table CMOBJPROPS67 add STSNONAFFCONS int null

alter table CMOBJPROPS67 add STSPEAKAFFCONS int null

alter table CMOBJPROPS67 add STSPEAKMAXPROCS int null

alter table CMOBJPROPS67 add STSPEAKNONAFFCONS int null

alter table CMOBJPROPS31 add ANSAUDITLVL tinyint null

alter table CMOBJPROPS58 add ANSANNOTATIONLIFE	varchar (50) null

!RunCMScript CMUpgradeScript_configuration_update_29.xml

!RunCMScript CMUpgradeScript_cognos_roles_11_add.xml

!RunCMScript CMUpgradeScript_cognos_roles_11_update.xml