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

CREATE TABLE CMINDEXQUEUE (
	OBJID 	 		lvarchar(1024) default null,
	ITEMID	 		lvarchar(50) not null,
	QUEUEID			lvarchar(50) not null,
	WORKFLOW 		lvarchar(50) not null,
	CONSUMERNAME	lvarchar(50) default null,
	STATE			integer,
	INSERTIONTIME 	datetime year to fraction not null,
	INDEXACTION		lvarchar(50) NOT NULL,
	INDEXCLASS		lvarchar(255) NOT NULL,
	INDEXPROPS		clob,
	PRIMARY KEY (ITEMID) CONSTRAINT PK_CMINDEXQUEUE  
)lock mode row;

CREATE INDEX CMSCRIPT_CS_IDIDX_CMINDEXQUEUE on CMINDEXQUEUE(STATE, QUEUEID);
