analytics/configuration/schemas/content/sqlserver/dbUpgrade7_0028-to-7_0029_mssqlserver.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.

drop index IDX_CLASS on CMOBJECTS

drop index IDX_CLASS1 on CMOBJECTS

alter table CMOBJECTS alter column CLASSID int not null

create index IDX_CLASS on CMOBJECTS(CLASSID)

create index IDX_CLASS1 on CMOBJECTS(CMID, CLASSID)


alter table CMCLASSES drop constraint PK_CMCLASSES

alter table CMCLASSES alter column CLASSID int not null

alter table CMCLASSES add constraint PK_CMCLASSES primary key(CLASSID)


alter table CMOBJPROPS25 alter column DEPLOYOBJCLASSID int null


alter table CMSIZEINFO drop constraint PK_CMSIZEINFO

alter table CMSIZEINFO alter column CLASSID int not null

alter table CMSIZEINFO alter column TOTALFORCLASSID int not null

alter table CMSIZEINFO add constraint PK_CMSIZEINFO primary key (STOREID, TOTALFORCLASSID)