analytics/configuration/schemas/content/oracle/dbUpgrade7_0048-to-7_0049_oracle.sql

-- 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        number(10) not null,
    DOCTYPE     varchar2(64) not null,
    DOCID       varchar2(64) not null,
    CONTENT     clob null,
    CONSTRAINT PK_CMOBJPROPS89 PRIMARY KEY (CMID)
);

create index IDX_CMPROPS89_1 on CMOBJPROPS89(DOCID);

alter table CMOBJPROPS85 add OBJREFS clob null;

!RunCMScript CMUpgradeScript_homeFolder_1.xml