analytics/configuration/schemas/logging/sqlserver/LS_dbUpgrade102_003-to-102_006_mssql.sql

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


drop index COGIPF_RUNREPORT.COGIPF_RUNREP_IDX;

ALTER TABLE COGIPF_RUNREPORT ALTER COLUMN COGIPF_PACKAGE nvarchar(1024);

ALTER TABLE COGIPF_RUNREPORT ALTER COLUMN COGIPF_MODEL nvarchar(512);

create index COGIPF_RUNREP_IDX on COGIPF_RUNREPORT (COGIPF_REQUESTID, COGIPF_STEPID);

drop index COGIPF_EDITQUERY.COGIPF_EDTQRY_IDX;

ALTER TABLE COGIPF_EDITQUERY ALTER COLUMN COGIPF_PACKAGE nvarchar(1024);

ALTER TABLE COGIPF_EDITQUERY ALTER COLUMN COGIPF_MODEL nvarchar(512);

create index COGIPF_EDTQRY_IDX on COGIPF_EDITQUERY (COGIPF_REQUESTID, COGIPF_STEPID);

ALTER TABLE COGIPF_VIEWREPORT ALTER COLUMN COGIPF_PACKAGE nvarchar(1024);

ALTER TABLE COGIPF_VIEWREPORT ALTER COLUMN COGIPF_MODEL nvarchar(512);

UPDATE COGIPF_SYSPROPS set PROPVALUE='102.006' where PROPNAME='IPFStoreVersion';