dbUpgrade3_0068-to-4_0001_oracle.sql 869 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. CREATE TABLE CMOBJPROPS47 (
  12. CMID number(10) NOT NULL,
  13. LOWAVETHRESH varchar2 (100) NULL,
  14. LOWAVETHRESHEXCL number(1) default(0) NOT NULL,
  15. LOWPOORTHRESH varchar2 (100) NULL,
  16. LOWPOORTHRESHEXCL number(1) default(0) NOT NULL,
  17. SYSTEMMETRIC number(3) NULL,
  18. UPAVETHRESH varchar2 (100) NULL,
  19. UPAVETHRESHEXCL number(1) default(0) NOT NULL,
  20. UPPOORTHRESH varchar2 (100) NULL,
  21. UPPOORTHRESHEXCL number(1) default(0) NOT NULL,
  22. constraint PK_CMOBJPROPS47 primary key (CMID)
  23. );