analytics/configuration/schemas/content/sqlserver/dbUpgrade4_0049-to-4_0051_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 CMOBJPROPS58 add BRSPDFCHARENC tinyint null

alter table CMOBJPROPS58 add BRSPDFCOMPRSLVL int null

alter table CMOBJPROPS58 add BRSPDFCOMPRSTYPE tinyint null

alter table CMOBJPROPS58 add BRSPDFEMBEDFONTS tinyint null

alter table CMOBJPROPS58 add RSPDFCHARENC tinyint null

alter table CMOBJPROPS58 add RSPDFCOMPRSLVL int null

alter table CMOBJPROPS58 add RSPDFCOMPRSTYPE tinyint null

alter table CMOBJPROPS58 add RSPDFEMBEDFONTS tinyint null

insert into CMOBJPROPS58(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (65, 25)

!RunCMScript CMUpgradeScript_configuration_update_15.xml