dbUpgrade5_0004-to-5_0005_db2.sql 680 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. alter table CMOBJPROPS31 add column EVSAUDITLVL integer
  12. CREATE TABLE CMOBJPROPS74 (
  13. CMID integer not null,
  14. DEPLOYREFS clob(1M),
  15. LAUNCHTYPE varchar (512),
  16. SPEC blob(1G),
  17. CONSTRAINT PK_CMOBJPROPS74 PRIMARY KEY (CMID)
  18. )
  19. create index IDX_CMLAUNCHTYPE on CMOBJPROPS74(LAUNCHTYPE)