-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2013
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 


CREATE TABLE COGIPF_MOBILESERVICE (
	COGIPF_HOST_IPADDR 	varchar (128) NULL ,
	COGIPF_HOST_PORT 	int NULL ,
	COGIPF_PROC_ID 		int NULL ,
	COGIPF_LOCALTIMESTAMP 	datetime NULL ,
	COGIPF_TIMEZONE_OFFSET 	int NULL ,
	COGIPF_SESSIONID 	varchar (255) NULL ,
	COGIPF_REQUESTID 	nvarchar (255) NOT NULL ,
	COGIPF_STEPID 		nvarchar (255) NULL ,
	COGIPF_SUBREQUESTID 	nvarchar (255) NULL ,
	COGIPF_THREADID 	varchar (255) NULL ,
	COGIPF_COMPONENTID 	varchar (64) NULL ,
	COGIPF_BUILDNUMBER 	int NULL ,
	COGIPF_LOG_LEVEL 	int NULL ,
	COGIPF_REPORT_TYPE 	varchar (255) NULL ,
	COGIPF_REPORT_PATH 	nvarchar (512) NULL ,
	COGIPF_STATUS 		varchar (255) NULL ,
	COGIPF_ERRORDETAILS 	nvarchar (2000) NULL,
	COGIPF_EVENT_TYPE		varchar (255) NULL,
	COGIPF_REPORT_NAME 	nvarchar (255) NULL,	
	COGIPF_STORE_ID 	nvarchar (255) NULL,
	COGIPF_RUNTIME		int NULL,
	COGIPF_DEVICE_ID		nvarchar (255) NULL, 
	COGIPF_CLIENT_CATEGORY  nvarchar (255) NULL,
	COGIPF_USER_AGENT 	nvarchar (512) NULL,	
	COGIPF_USER_NAME 	nvarchar (512) NULL,
	COGIPF_USER_UID 	nvarchar (255) NULL
)

create index COGIPF_MOBILE_IDX on COGIPF_MOBILESERVICE (COGIPF_REQUESTID, COGIPF_USER_UID)


