analytics/configuration/schemas/content/oracle/dbUpgrade5_0011-to-5_0012_oracle.sql

-- 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 CMOBJPROPS75 (
	CMID			number(10)      NOT NULL,
	RESOURCETYPE		varchar2 (768)  NULL,
	SPEC			blob 		NULL,
	CONSTRAINT PK_CMOBJPROPS75 PRIMARY KEY (CMID)
);

create index IDX_CMRESOURCETYPE on CMOBJPROPS75(RESOURCETYPE);

CREATE TABLE CMOBJPROPS76 (
	CMID			number(10)      NOT NULL,
	CONTENTTYPE		varchar2 (768)  NULL,
	CONSTRAINT PK_CMOBJPROPS76 PRIMARY KEY (CMID)
);

CREATE TABLE CMOBJPROPS78 (
	CMID			number(10)      NOT NULL,
	BINDINGNAME		varchar2 (768)  NULL,
	INPUTMESSNAME		varchar2 (768)  NULL,
	OPERATIONNAME		varchar2 (768)  NULL,
	OUTPUTMESSNAME		varchar2 (768)  NULL,
	SERVICENAME		varchar2 (768)  NULL,
	BULKEVENTS		number(1) null,
	URI			clob 		NULL,
	CONSTRAINT PK_CMOBJPROPS78 PRIMARY KEY (CMID)
);

insert into CMOBJPROPS76 (CMID) select CMID from CMOBJECTS where CLASSID = 20;