dbUpgrade0_9992-to-0_9993_mssqlserver.sql 843 B

1234567891011121314151617181920212223242526272829
  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 CMOBJPROPS30 (
  12. CMID integer not null,
  13. HANDLE nvarchar (255) NULL,
  14. BINDING ntext NULL,
  15. REGISTRATION ntext NULL,
  16. SERVICEDESCR ntext NULL,
  17. LAYOUT ntext NULL,
  18. CONTEXT ntext NULL,
  19. CONSTRAINT PK_CMOBJPROPS30 PRIMARY KEY (CMID)
  20. )
  21. insert into CMOBJPROPS30(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID=5
  22. !RunCMScript CMUpgradeScript_portal_1.xml
  23. !RunCMScript CMUpgradeScript_portal_2.xml