dbUpgrade0_9988-to-0_9989_oracle.sql 660 B

1234567891011121314151617181920212223
  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. CREATE TABLE CMOBJPROPS27 (
  12. CMID number(10) not null,
  13. CUBECONTNAME varchar2 (2048) NULL,
  14. GATEWAY varchar2 (4000) NULL,
  15. HASPROMPTS number(1) default(0) not NULL,
  16. PPOPTIONS clob null,
  17. DATABLOCKS blob null,
  18. constraint PK_CMOBJPROPS27 primary key (CMID)
  19. )