dbUpgrade2_0018-to-2_0019_oracle.sql 1.1 KB

12345678910111213141516171819202122
  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 CMOBJPROPS39 (
  12. PROPID number(5) NOT NULL,
  13. CMID number(10) not null,
  14. VALUE number(3) not null
  15. )
  16. create index IDX_CMOBJPROPS39 on CMOBJPROPS39 (CMID)
  17. !MigratePropertyStorage '<property name="userInterfaces" table="CMOBJPROPS36" column="COMPONENTS" type="bibus:uiComponentEnumArray"/>' '<property name="userInterfaces" table="CMOBJPROPS39" column="VALUE" type="bibus:uiComponentEnumArray" isStoredAsArray="1" propID="36"><enumeration class="*" name="uiComponentEnum"><item value="eventStudio" id="0"/><item value="metricStudio" id="3"/><item value="analysisStudio" id="4"/><item value="queryStudio" id="5"/><item value="reportStudio" id="6"/></enumeration></property>'