dbUpgrade0_99991-to-0_99992_db2.sql 990 B

123456789101112131415161718192021222324252627282930313233
  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 CMREFNOORD1 (
  12. PROPID smallint NOT NULL,
  13. CMID integer not null ,
  14. REFCMID integer not null ,
  15. constraint PK_CMREFNOORD1 primary key (CMID, PROPID) )
  16. create index IDX_CMREFNOORD1 on CMREFNOORD1(REFCMID, PROPID)
  17. CREATE TABLE CMREFORD1 (
  18. PROPID smallint NOT NULL,
  19. CMID integer not null ,
  20. ORD integer NOT NULL,
  21. REFCMID integer not null ,
  22. constraint PK_CMREFORD1 primary key (CMID, PROPID, ORD) )
  23. create index IDX_CMREFORD1 on CMREFORD1(REFCMID, PROPID, ORD)
  24. !RunCMScript CMUpgradeScript_deletedObjectFolder_add.xml
  25. !RunCMScript CMUpgradeScript_deletedObjectFolder_update.xml