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

create table CMOBJPROPS89 (
    CMID        integer not null,
    DOCTYPE     lvarchar (64) not null,
    DOCID       lvarchar (64) not null,
    CONTENT     clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS89
) lock mode row;

create index IDX_CMOBJPROPS89_1 on CMOBJPROPS89(DOCID);

alter table CMOBJPROPS85 add OBJREFS clob;

!RunCMScript CMUpgradeScript_homeFolder_1.xml