| 1234567891011121314151617181920 |
- -- Licensed Materials - Property of IBM
- --
- -- BI and PM: CM
- --
- -- (C) Copyright IBM Corp. 2011
- --
- -- US Government Users Restricted Rights - Use, duplication or disclosure
- -- restricted by GSA ADP Schedule Contract with IBM Corp.
- ALTER TABLE CMOBJECTS ADD column TENANTID INTEGER WITH DEFAULT 0 NOT NULL
- CREATE TABLE CMTENANTID (
- TENANTID INTEGER WITH DEFAULT 0 NOT NULL,
- TENANTNAME VARCHAR(255) NOT NULL,
- CONSTRAINT PK_CMTENANTID PRIMARY KEY (TENANTID),
- CONSTRAINT UN_CMTENANTID_TENANTNAME UNIQUE (TENANTNAME)
- )
- INSERT INTO CMTENANTID (TENANTID,TENANTNAME) VALUES (0,'')
|
