analytics/configuration/schemas/content/db2zOS/dbUpgrade7_0028-to-7_0029_db2zOS.sql

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

alter table CMOBJECTS alter column CLASSID set data type integer;

alter table CMOBJPROPS25 alter column DEPLOYOBJCLASSID set data type integer;

alter table CMSIZEINFO alter column CLASSID set data type integer;

alter table CMSIZEINFO alter column TOTALFORCLASSID set data type integer;

drop table CMCLASSES;

create table CMCLASSES (
	CLASSID  integer not null,
	NAME     varchar(50) not null,
	USAGE    smallint,
	DEF      blob(100K),
	constraint PK_CMCLASSES primary key(CLASSID)
) IN CMSCRIPT_CREATE_IN;

CREATE  UNIQUE  INDEX PK_CMCLASSES ON CMCLASSES (CLASSID) USING STOGROUP CMSCRIPT_STOGROUP;

CREATE AUXILIARY TABLE CMATB094
   IN CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML094
   STORES CMCLASSES
   COLUMN DEF;

CREATE UNIQUE INDEX CMIDX094 ON CMATB094 USING STOGROUP CMSCRIPT_STOGROUP;