analytics/configuration/schemas/content/db2zOS/dbUpgrade7_0047-to-7_0048_db2zOS.sql

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

CREATE TABLE CMTAGS (
	CMID      integer not null,
	ORD       integer not null,
	TAG       varchar(256),
	constraint PK_CMTAGS primary key (CMID, ORD)
) IN CMSCRIPT_CREATE_IN;

CREATE UNIQUE INDEX PK_CMTAGS ON CMTAGS (CMID, ORD) USING STOGROUP CMSCRIPT_STOGROUP;

CREATE INDEX IDX_CMTAGS on CMTAGS(CMID, TAG) USING STOGROUP CMSCRIPT_STOGROUP;