dbUpgrade7_0047-to-7_0048_oracle.sql 444 B

1234567891011121314151617
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2017
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. CREATE TABLE CMTAGS (
  10. CMID number(10) not null,
  11. ORD number(10) not null,
  12. TAG varchar2(256) null,
  13. constraint PK_CMTAGS primary key (CMID, ORD)
  14. );
  15. create index IDX_CMTAGS on CMTAGS(CMID, TAG);