-- 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. 

sp_rename 'COGIPF_PARAMETER', 'COGIPF_PARAMETER_OLD'

CREATE TABLE COGIPF_PARAMETER (
	COGIPF_LOCALTIMESTAMP 	datetime NULL ,
	COGIPF_SESSIONID 	varchar (255) NULL ,
	COGIPF_REQUESTID 	nvarchar (255) NOT NULL ,
	COGIPF_SUBREQUESTID 	nvarchar (255) NULL ,
	COGIPF_STEPID 		nvarchar (255) NULL ,
	COGIPF_OPERATION 	varchar (255) NULL ,
	COGIPF_TARGET_TYPE 	varchar (255) NULL ,
	COGIPF_PARAMETER_NAME 	varchar (255) NULL ,
	COGIPF_PARAMETER_VALUE 	nvarchar (512) NULL ,
	COGIPF_PARAMETER_VALUE_BLOB 	ntext NULL
)

insert into COGIPF_PARAMETER (COGIPF_REQUESTID,COGIPF_STEPID,COGIPF_OPERATION,COGIPF_TARGET_TYPE,COGIPF_PARAMETER_NAME,COGIPF_PARAMETER_VALUE) select * from COGIPF_PARAMETER_OLD

drop table COGIPF_PARAMETER_OLD