dbUpgrade7_0002-to-7_0003_oracle.sql 502 B

12345678910111213141516171819
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2011
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. ALTER TABLE CMOBJECTS ADD TENANTID NUMBER(10) DEFAULT(0) NOT NULL;
  10. CREATE TABLE CMTENANTID (
  11. TENANTID NUMBER(10) NOT NULL,
  12. TENANTNAME VARCHAR2(255) NULL,
  13. CONSTRAINT PK_CMTENANTID PRIMARY KEY (TENANTID)
  14. );
  15. INSERT INTO CMTENANTID (TENANTID,TENANTNAME) VALUES (0,'');