-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2008, 2009
--
-- US Government Users Restricted Rights - Use, duplication or disclosure
-- restricted by GSA ADP Schedule Contract with IBM Corp.

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).


CREATE TABLE CMOBJPROPS39 (
	PROPID		smallint NOT NULL,
	CMID		integer not null ,
	VALUE		smallint NOT NULL
)

create index IDX_CMOBJPROPS39 on CMOBJPROPS39 (CMID)

!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>'