analytics/configuration/schemas/logging/sqlserver/LS_dbUpgrade0_012-to-0_013_mssql.sql

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

sp_rename 'COGIPF_ACTION', 'COGIPF_ACTION_OLD'

CREATE TABLE COGIPF_ACTION (
	COGIPF_HOST_IPADDR 	varchar (15) 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 	varchar (255) NOT NULL ,
	COGIPF_STEPID 		varchar (255) NULL ,
	COGIPF_SUBREQUESTID 	varchar (255) NULL ,
	COGIPF_THREADID 	varchar (255) NULL ,
	COGIPF_COMPONENTID 	varchar (64) NULL ,
	COGIPF_BUILDNUMBER 	int NULL ,
	COGIPF_LOG_LEVEL 	int NULL ,
	COGIPF_OPERATION 	varchar (255) NULL ,
	COGIPF_TARGET_TYPE 	varchar (255) NULL ,
	COGIPF_TARGET_PATH 	varchar (1024) NULL ,
	COGIPF_STATUS 		varchar (255) NULL ,
	COGIPF_ERRORDETAILS 	varchar (2000) NULL 
)

insert into COGIPF_ACTION select * from COGIPF_ACTION_OLD

drop table COGIPF_ACTION_OLD

sp_rename 'COGIPF_AGENTBUILD', 'COGIPF_AGENTBUILD_OLD'

CREATE TABLE COGIPF_AGENTBUILD (
	COGIPF_HOST_IPADDR 	varchar (15) 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 	varchar (255) NOT NULL ,
	COGIPF_STEPID 		varchar (255) NULL ,
	COGIPF_SUBREQUESTID 	varchar (255) NULL ,
	COGIPF_THREADID 	varchar (255) NULL ,
	COGIPF_COMPONENTID 	varchar (64) NULL ,
	COGIPF_BUILDNUMBER 	int NULL ,
	COGIPF_LOG_LEVEL 	int NULL ,
	COGIPF_OPERATION	varchar (64) NULL,
	COGIPF_TARGET_TYPE    	varchar (255) NULL,
	COGIPF_TARGET_PATH     	nvarchar (1024) NULL,
	COGIPF_TARGET_NAME     	nvarchar (255) NULL,
	COGIPF_STATUS 		varchar (255) NULL ,
	COGIPF_ERRORDETAILS 	varchar (2000) NULL ,
	COGIPF_AGENT_PATH     	nvarchar (512) NULL,
	COGIPF_SCHEDULETIME	int NULL,
	COGIPF_USER		nvarchar (255) NULL,
	COGIPF_EMAIL		nvarchar (255) NULL
)

insert into COGIPF_AGENTBUILD select * from COGIPF_AGENTBUILD_OLD

drop table COGIPF_AGENTBUILD_OLD

sp_rename 'COGIPF_AGENTRUN', 'COGIPF_AGENTRUN_OLD'

CREATE TABLE COGIPF_AGENTRUN (
	COGIPF_HOST_IPADDR 	varchar (15) 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 	varchar (255) NOT NULL ,
	COGIPF_STEPID 		varchar (255) NULL ,
	COGIPF_SUBREQUESTID 	varchar (255) NULL ,
	COGIPF_THREADID 	varchar (255) NULL ,
	COGIPF_COMPONENTID 	varchar (64) NULL ,
	COGIPF_BUILDNUMBER 	int NULL ,
	COGIPF_LOG_LEVEL 	int NULL ,
	COGIPF_OPERATION	varchar (64) NULL,
	COGIPF_TARGET_TYPE    	varchar (255) NULL,
	COGIPF_TARGET_PATH     	nvarchar (1024) NULL,
	COGIPF_TARGET_NAME     	nvarchar (255) NULL,
	COGIPF_STATUS 		varchar (255) NULL ,
	COGIPF_ERRORDETAILS 	varchar (2000) NULL ,
	COGIPF_AGENT_PATH     	nvarchar (512) NULL,
	COGIPF_SCHEDULETIME	int NULL,
	COGIPF_USER		nvarchar (255) NULL,
	COGIPF_EMAIL		nvarchar (255) NULL,
	COGIPF_MESSAGEID	varchar  (255) NULL
)

insert into COGIPF_AGENTRUN  (COGIPF_HOST_IPADDR,COGIPF_HOST_PORT,COGIPF_PROC_ID,COGIPF_LOCALTIMESTAMP,COGIPF_TIMEZONE_OFFSET,COGIPF_SESSIONID,COGIPF_REQUESTID,COGIPF_STEPID,COGIPF_SUBREQUESTID,COGIPF_THREADID,COGIPF_COMPONENTID,COGIPF_BUILDNUMBER,COGIPF_LOG_LEVEL,COGIPF_OPERATION,COGIPF_TARGET_TYPE,COGIPF_TARGET_PATH,COGIPF_TARGET_NAME ,COGIPF_STATUS,COGIPF_ERRORDETAILS,COGIPF_AGENT_PATH,COGIPF_SCHEDULETIME,COGIPF_USER,COGIPF_EMAIL,COGIPF_MESSAGEID) select  COGIPF_HOST_IPADDR,COGIPF_HOST_PORT,COGIPF_PROC_ID,COGIPF_LOCALTIMESTAMP,COGIPF_TIMEZONE_OFFSET,COGIPF_SESSIONID,COGIPF_REQUESTID,COGIPF_STEPID,COGIPF_SUBREQUESTID,COGIPF_THREADID,COGIPF_COMPONENTID,COGIPF_BUILDNUMBER,COGIPF_LOG_LEVEL,COGIPF_OPERATION,COGIPF_TARGET_TYPE,COGIPF_TARGET_PATH,COGIPF_TARGET_NAME, COGIPF_STATUS,COGIPF_ERRORDETAILS,COGIPF_AGENT_PATH,COGIPF_SCHEDULETIME,COGIPF_USER,COGIPF_EMAIL,SUBSTRING(COGIPF_MESSAGEID, 0, 255) from COGIPF_AGENTRUN_OLD

drop table COGIPF_AGENTRUN_OLD