dbUpgrade7_0008-to-7_0009_oracle.sql 457 B

12345678910111213141516
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2012
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. CREATE TABLE CMOBJPROPS82 (
  10. CMID number(10) NOT NULL ,
  11. BPMRESTURI varchar2 (4000) NULL ,
  12. CONSTRAINT PK_CMOBJPROPS82 PRIMARY KEY (CMID)
  13. );
  14. insert into CMOBJPROPS82 (CMID) select CMID from CMOBJECTS where CLASSID in (4);