analytics/configuration/schemas/content/db2/dbUpgrade2_0033-to-2_0034_db2.sql

-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2008, 2009
--
-- US Government Users Restricted Rights - Use, duplication or disclosure
-- restricted by GSA ADP Schedule Contract with IBM Corp.

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).


alter table CMOBJPROPS31 drop constraint PK_CMOBJPROPS31

rename CMOBJPROPS31 to CMOBJPROPS31_OLD

CREATE TABLE CMOBJPROPS31 (
	CMID			integer not null,
	ASAUDITLVL		smallint,
	BRSAUDITLVL		smallint,
	CMSAUDITLVL		smallint,
	DISPAUDITLVL		smallint,
	DSAUDITLVL		smallint,
	EMSAUDITLVL		smallint,
	JSAUDITLVL		smallint,
	MDSAUDITLVL		smallint,
	MMSAUDITLVL		smallint,
	MSAUDITLVL		smallint,
	PACSAUDITLVL		smallint,
	PRSAUDITLVL		smallint,
	PSAUDITLVL		smallint,
	PTSAUDITLVL		smallint,
	RSAUDITLVL		smallint,
	SSAUDITLVL		smallint,
	BRSAUDITNATIVEQRY	decimal(1,0),
	RSAUDITNATIVEQRY	decimal(1,0),
	DISAUDITLVL		smallint,
	RSDATASOURCECHG		timestamp,
	IDSAUDITLVL		smallint,
	ISSAUDITLVL		smallint,
	IUSAUDITLVL		smallint,
	constraint PK_CMOBJPROPS31 primary key (CMID)
)

insert into CMOBJPROPS31(CMID,ASAUDITLVL,BRSAUDITLVL,CMSAUDITLVL,DISPAUDITLVL,DSAUDITLVL,EMSAUDITLVL,JSAUDITLVL,MDSAUDITLVL,MMSAUDITLVL,MSAUDITLVL,PACSAUDITLVL,PRSAUDITLVL,PSAUDITLVL,PTSAUDITLVL,RSAUDITLVL,SSAUDITLVL,BRSAUDITNATIVEQRY,RSAUDITNATIVEQRY,DISAUDITLVL,RSDATASOURCECHG,IDSAUDITLVL,ISSAUDITLVL,IUSAUDITLVL) select CMID,ASAUDITLVL,BRSAUDITLVL,CMSAUDITLVL,DISPAUDITLVL,DSAUDITLVL,EMSAUDITLVL,JSAUDITLVL,MDSAUDITLVL,MMSAUDITLVL,MSAUDITLVL,PACSAUDITLVL,PRSAUDITLVL,PSAUDITLVL,PTSAUDITLVL,RSAUDITLVL,SSAUDITLVL,BRSAUDITNATIVEQRY,RSAUDITNATIVEQRY,DISAUDITLVL,RSDATASOURCECHG,IDSAUDITLVL,ISSAUDITLVL,IUSAUDITLVL from CMOBJPROPS31_OLD

drop table CMOBJPROPS31_OLD