dbUpgrade4_0015-to-4_0016_oracle.sql 698 B

123456789101112131415161718192021222324
  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 ( MISAUDITLVL number(3) null);
  12. alter table CMOBJPROPS48 add ( MISCONNECTIONS number(10) null);
  13. CREATE TABLE CMOBJPROPS57 (
  14. CMID number(10) NOT NULL,
  15. SPEC clob NULL,
  16. CONSTRAINT PK_CMOBJPROPS57 PRIMARY KEY (CMID)
  17. );
  18. !RunCMScript CMUpgradeScript_configuration_update_10.xml