analytics/configuration/schemas/content/sqlserver/dbUpgrade5_0019-to-5_0021_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 RMDSAUDITLVL tinyint null

alter table CMOBJPROPS48 add RMDSAFFCONS int null

alter table CMOBJPROPS48 add RMDSEXECLMT int null

alter table CMOBJPROPS48 add RMDSNONAFFCONS int null

alter table CMOBJPROPS48 add RMDSPEAKAFFCONS int null

alter table CMOBJPROPS48 add RMDSPEAKNONAFFCONS int null

!RunCMScript CMUpgradeScript_configuration_update_30.xml

!RunCMScript CMUpgradeScript_capabilities_45.xml