analytics/configuration/schemas/logging/sqlserver/LS_dbUpgrade0_004-to-0_005_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_EDITQUERY', 'COGIPF_EDITQUERY_OLD'

CREATE TABLE COGIPF_EDITQUERY (
	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_TARGET_TYPE 	varchar (255) NULL ,
	COGIPF_QUERYPATH 	nvarchar (512) NULL ,
	COGIPF_STATUS 		varchar (255) NULL ,
	COGIPF_ERRORDETAILS 	varchar (2000) NULL ,
	COGIPF_RUNTIME 		int NULL ,
	COGIPF_QUERYNAME 	nvarchar (255) NULL ,
	COGIPF_PACKAGE 		nvarchar (512) NULL ,
	COGIPF_MODEL 		nvarchar (255) NULL 
)

insert into COGIPF_EDITQUERY select * from COGIPF_EDITQUERY_OLD

drop table COGIPF_EDITQUERY_OLD

sp_rename 'COGIPF_VIEWREPORT', 'COGIPF_VIEWREPORT_OLD'

CREATE TABLE COGIPF_VIEWREPORT (
	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_TARGET_TYPE 	varchar (255) NULL ,
	COGIPF_REPORTPATH 	nvarchar (512) NULL ,
	COGIPF_STATUS 		varchar (255) NULL ,
	COGIPF_ERRORDETAILS 	varchar (2000) NULL ,
	COGIPF_REPORTNAME 	nvarchar (255) NULL ,
	COGIPF_PACKAGE 		nvarchar (512) NULL ,
	COGIPF_MODEL 		nvarchar (255) NULL ,
	COGIPF_REPORTFORMAT 	varchar (255) NULL 
)

insert into COGIPF_VIEWREPORT select * from COGIPF_VIEWREPORT_OLD

drop table COGIPF_VIEWREPORT_OLD

sp_rename 'COGIPF_RUNREPORT', 'COGIPF_RUNREPORT_OLD'

CREATE TABLE COGIPF_RUNREPORT (
	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_TARGET_TYPE 	varchar (255) NULL ,
	COGIPF_REPORTPATH 	nvarchar (512) NULL ,
	COGIPF_STATUS 		varchar (255) NULL ,
	COGIPF_ERRORDETAILS 	varchar (2000) NULL ,
	COGIPF_RUNTIME 		int NULL ,
	COGIPF_REPORTNAME 	nvarchar (255) NULL ,
	COGIPF_PACKAGE 		nvarchar (512) NULL ,
	COGIPF_MODEL 		nvarchar (255) NULL 
)

insert into COGIPF_RUNREPORT select * from COGIPF_RUNREPORT_OLD

drop table COGIPF_RUNREPORT_OLD