analytics/configuration/schemas/content/oracle/dbUpgrade2_0027-to-2_0028_oracle.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 PACSAUDITLVL number(3) null

alter table CMOBJPROPS31 add PRSAUDITLVL number(3) null

alter table CMOBJPROPS31 add PTSAUDITLVL number(3) null

CREATE TABLE CMOBJPROPS40 (
	CMID			number(10) NOT NULL ,
	APPGUID			varchar2 (50) NULL ,
	APPID			varchar2 (768) NULL ,
	APPSTATE		number(3) NULL ,
	APPURL			varchar2 (4000) NULL ,
	CONSTRAINT PK_CMOBJPROPS40 PRIMARY KEY (CMID) 
)

CREATE TABLE CMOBJPROPS41 (
	CMID			number(10) NOT NULL,
	DEPTH			number(10) null,
	ITEMID			varchar2 (768) NULL,
	PARENTID		varchar2 (768) NULL,
	CONSTRAINT PK_CMOBJPROPS41 PRIMARY KEY (CMID) 
)

CREATE TABLE CMOBJPROPS42 (
	CMID			number(10) NOT NULL,
	SPEC			clob NULL,
	CONSTRAINT PK_CMOBJPROPS42 PRIMARY KEY (CMID) 
)

!RunCMScript CMUpgradeScript_configuration_update_4.xml

!RunCMScript CMUpgradeScript_cognos_roles2_add.xml

!RunCMScript CMUpgradeScript_cognos_roles2_update.xml

!RunCMScript CMUpgradeScript_capabilities_22_add.xml

!RunCMScript CMUpgradeScript_capabilities_22_update.xml