dbUpgrade0_999992-to-0_999993_oracle.sql 794 B

1234567891011121314151617181920212223242526
  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 CMOBJPROPS27 add PPDEFPORTACT number(3) null
  12. update CMOBJPROPS27 set PPDEFPORTACT=0 where CMID in (select CMID from CMOBJECTS where CLASSID=81)
  13. create table CMOBJPROPS34 (
  14. CMID number(10) NOT NULL,
  15. ACTION number(3) NULL,
  16. BOOKMARKITEM varchar2(768) NULL,
  17. BOOKMARKTEXT varchar2(768) NULL,
  18. DRILLPARMASSIGN blob NULL,
  19. SCOPE blob NULL,
  20. constraint PK_CMOBJPROPS34 primary key (CMID)
  21. )