-- 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     varchar(64) not null,
    DOCID       varchar(64) not null,
    CONTENT     clob(10M),
    CONSTRAINT PK_CMOBJPROPS89 PRIMARY KEY (CMID)
)

create index IDX_CMPROPS89_1 on CMOBJPROPS89(DOCID)

ALTER TABLE CMOBJPROPS85 ADD column OBJREFS clob(1M)

!RunCMScript CMUpgradeScript_homeFolder_1.xml