analytics/configuration/schemas/content/oracle/dbUpgrade4_0009-to-4_0011_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 CMOBJPROPS28 add (  FILTERDATAITEM	varchar2(768) NULL );

CREATE TABLE CMOBJPROPS55 (
	CMID			number(10) NOT NULL ,
	ICONURI			varchar2 (3000) NULL ,
	CONSTRAINT PK_CMOBJPROPS55 PRIMARY KEY (CMID) 
);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (65, 6, 4, 34, 33, 47, 155, 12, 9, 42, 13, 177, 40, 14, 43, 50, 52, 170, 171, 172, 67, 64, 70, 176, 32, 8, 58, 59, 72, 133, 134, 174, 25, 0, 135, 75, 76, 77, 156, 60, 61, 24, 73, 161, 83, 84, 138, 147, 99, 102, 116, 79, 88, 92, 164, 165, 166, 185);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (5);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (11);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (48);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (15);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (178);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (180);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (145);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (1);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (54);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (173);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (55);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (57);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (38);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (181);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (18);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (142);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (159);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (37);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (10);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (139);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (80);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (19);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (17);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (26);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (175);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (157);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (158);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (39);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (63);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (144);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (146);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (20);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (81);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (82);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (85);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (86);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (87);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (93);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (151);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (152);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (153);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (154);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (103);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (104);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (105);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (106);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (107);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (108);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (111);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (117);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (162);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (167);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (168);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (169);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (182);

INSERT INTO CMOBJPROPS55(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (186, 187, 191, 198);