analytics/configuration/schemas/content/db2/dbUpgrade6_0017-to-6_0018_db2.sql

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

alter table CMOBJPROPS30 drop constraint PK_CMOBJPROPS30

rename table CMOBJPROPS30 to CMOBJPROPS30_OLD

create table CMOBJPROPS30 (
	CMID            integer not null,
	HANDLE          varchar(255),
	BINDING         clob(1M),
	REGISTRATION    clob(1M),
	SERVICEDESCR    clob(1M),
	LAYOUT          clob(1M),
	REQUIREDCAP	clob(1M),
	CANCUSTOMIZE	decimal(1,0),
	CONTEXT         clob(1M),
	DEPLOYREFS	clob(1M),
	constraint PK_CMOBJPROPS30 primary key (CMID)
)

insert into CMOBJPROPS30(CMID,HANDLE,BINDING,REGISTRATION,SERVICEDESCR,LAYOUT,REQUIREDCAP,CANCUSTOMIZE,CONTEXT,DEPLOYREFS) select CMID,HANDLE,BINDING,REGISTRATION,SERVICEDESCR,LAYOUT,REQUIREDCAP,CANCUSTOMIZE,CONTEXT,DEPLOYREFS from CMOBJPROPS30_OLD

drop table CMOBJPROPS30_OLD