-- 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).


delete from CMOBJPROPS7 where CMID not in (select CMID from CMOBJECTS o where o.CLASSID in (10, 13, 139, 14, 17, 23, 26, 32, 34, 37, 38, 4, 48, 5, 54, 68, 75, 76, 77, 80))

delete from CMOBJPROPS11 where CMID not in (select CMID from CMOBJECTS o where o.CLASSID in (1, 10, 11, 111, 139, 14, 151, 152, 153, 154, 17, 179, 18, 19, 27, 33, 34, 37, 39, 4, 42, 5, 55, 75, 76, 77, 80, 85, 87, 9))

insert into CMOBJPROPS44 (CMID) select CMID from CMOBJECTS o where o.CLASSID in (4,34,14) and not exists (select p.CMID from CMOBJPROPS44 p where p.CMID=o.CMID)

insert into CMOBJPROPS26 (CMID) select CMID from CMOBJECTS o where o.CLASSID in (54,26) and not exists (select p.CMID from CMOBJPROPS26 p where p.CMID=o.CMID)
