dbUpgrade0_9990-to-0_9991_mssqlserver.sql 875 B

123456789101112131415161718192021222324252627
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2008, 2009
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
  10. -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
  11. alter table CMOBJPROPS26 add DELIVOPTIONS ntext null
  12. insert into CMOBJPROPS26(CMID) SELECT CMID FROM CMOBJECTS WHERE (CLASSID = 17 OR CLASSID = 39 OR CLASSID = 55 OR CLASSID = 57) AND (CMID NOT IN (SELECT CMID FROM CMOBJPROPS26))
  13. CREATE TABLE CMOBJPROPS28 (
  14. CMID int NOT NULL,
  15. EVENTKEY ntext NULL,
  16. EVENTTYPES ntext NULL,
  17. CONSTRAINT PK_CMOBJPROPS28 PRIMARY KEY (CMID)
  18. )
  19. !RunCMScript CMUpgradeScript_transient_1.xml
  20. !RunCMScript CMUpgradeScript_transient_2.xml