analytics/configuration/schemas/content/informix/dbInitScript_informix.sql

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

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).


create table CMOBJECTS (
	CMID			integer not null, 
	PCMID			integer not null ,
	VERSION			integer default 1 not null,
	CREATED			datetime year to fraction not null,
	MODIFIED		datetime year to fraction not null,
	DISABLED		smallint,
	CLASSID			integer not null,
	DISPSEQ			integer default 0 not null,
	OWNER			integer,
	TENANTID		integer default 0 not null,
	primary key (CMID) constraint PK_CMOBJECTS,
	unique (PCMID, CMID) 	constraint PK_CMPARENT  
) lock mode row;

create index CMSCRIPT_CS_IDIDX_CLASS on CMOBJECTS(CLASSID);

create index CMSCRIPT_CS_IDIDX_CLASS1 on CMOBJECTS(CMID, CLASSID);

create index CMSCRIPT_CS_IDIDX_PARENT on CMOBJECTS(PCMID);

create index CMSCRIPT_CS_IDIDX_CREATED on CMOBJECTS(CREATED);

create table CMOBJNAMES (
	CMID			integer			not null,
	LOCALEID		smallint		not null,
	MAPDLOCALEID		smallint,
	ISDEFAULT		decimal(1,0)	not null,
	NAME			lvarchar(255)	not null,
	primary key (CMID, LOCALEID) constraint	PK_CMOBJNAMES	
) lock mode row;
		
create table CMDATA (
	CMID			integer NOT NULL ,
	CONTENTTYPE		lvarchar (256),
	DATASIZE		bigint,
	DATACOMP		decimal(1,0) default 0 not null,
	DATAURI 		lvarchar(256),
	DATAPROP		blob,
	RESOURCETYPE	lvarchar (32),
	primary key (CMID) constraint PK_CMDATA 
) lock mode row;

CREATE TABLE CMARCHIVESTATUS (
	CMID			integer NOT NULL,
	ARCHSTAT		smallint default 0 not null, 
	primary key (CMID) constraint PK_CMARCHIVESTATUS 
) lock mode row;

CREATE TABLE CMSTOREIDS (
	CMID        integer NOT NULL,
	STOREID     char(33),
	PRIMARY KEY (CMID) CONSTRAINT PK_CMSTOREIDS 
) lock mode row;

create table CMOBJPROPS1 (
	CMID				integer not null,
	BUSPHONE			lvarchar (32),
	COMMONNAME			lvarchar (64),
	EMAIL				lvarchar (128),
	FAXPHONE			lvarchar (32),
	GIVENNAME			lvarchar (128),
	HOMEPHONE			lvarchar (32),
	MOBILEPHONE			lvarchar (32),
	PAGERPHONE			lvarchar (32),
	PADDRESS			lvarchar (512),
	SURNAME				lvarchar (128),
	TIMEZONE			lvarchar (128),
	CLOCALEID			smallint ,
	PRODLOCALE			lvarchar (64),
	OBJID				lvarchar (1024),
	USEACCESSIBILITY		decimal(1,0) default 0,
	USERNAME			lvarchar (128),
	ORIENTATION			smallint,
	HORIZRENDERLIMIT	integer,
	VERTRENDERLIMIT		integer,
	MOBILEDEVID			lvarchar (512),
	NOTIFICATIONEMAIL		lvarchar (512),
	primary key (CMID) constraint PK_CMOBJPROPS1 
) lock mode row;

create table CMOBJPROPS10 (
	CMID			integer not null ,
	CONTACTEMAIL	lvarchar (128) ,
	CONTACT			clob, 
	primary key (CMID) constraint PK_CMOBJPROPS10  
) lock mode row;

create table CMOBJPROPS11 (
	CMID			integer not null ,
	STATUSID		smallint,
	EVENTID			lvarchar(45),
	OWNEREVENTID		lvarchar(45),
	DISPATCHERID		lvarchar(50),
	MAXDETAILSEVTY		smallint,
	SCHEDTRIGNAME		lvarchar(512),
	SCHEDTYPE		smallint,
	RESTARTEVENTID		lvarchar(45),
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS11 
) lock mode row;

create index CMSCRIPT_CS_IDIDX_CMOWNEREVENTID on CMOBJPROPS11(OWNEREVENTID);

create index CMSCRIPT_CS_IDIDX_CMRESTARTID on CMOBJPROPS11(RESTARTEVENTID);

create table CMOBJPROPS13 (
	CMID			integer not null,
	ORD			integer not null,
	PARMNAME		lvarchar(512) not null,
	CPARMVALUE		blob,
	primary key (CMID, ORD) constraint PK_CMOBJPROPS13 
) lock mode row;

create table CMOBJPROPS14 (
	CMID			integer not null,
	RELATED			clob,
	MYPAGE			clob,
	RETENTION		clob,
	RECIPSEMAIL		clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS14 
) lock mode row;

create table CMOBJPROPS15 (
	CMID			integer not null,
	BRSHIAFFINECONS	integer,
	BRSAFFINECONS		integer,
	BRSMAXPROCS		integer,
	METADATAMODEL	clob,
	BRSEXECTIMELIMIT	integer,
	BRSDATASOURCECHG	 datetime year to fraction,
	primary key (CMID) constraint PK_CMOBJPROPS15 
) lock mode row;

create table CMOBJPROPS16 (
	CMID			integer not null,
	RSHIAFFINECONS	integer,
	RSAFFINECONS		integer,
	RSMAXPROCS		integer,
	RSQUEUELIMIT		integer,
	RUNNINGSTATE	smallint,
	ADVSETTINGS		clob,
	RSEXECTIMELIMIT	integer,
	ROUTINGTABLE	blob, 
	primary key (CMID) constraint PK_CMOBJPROPS16 
) lock mode row;

create table CMOBJPROPS17 (
	CMID				integer not null,
	NONPEAKBEGINHOUR	smallint,
	NONPEAKMAXJOBS		integer,
	PEAKBEGINHOUR		smallint,
	PEAKMAXJOBS			integer,
	NEWNONPEAKBEGINHOUR	smallint,
	NEWNONPEAKMAXJOBS		integer,
	NEWPEAKBEGINHOUR		smallint,
	NEWPEAKMAXJOBS			integer,
	USERCAPABILITY		smallint,
	STARTACTIVE			decimal(1,0),
	COMPONENTID 		smallint,
	PREVIMGLOCATION		lvarchar(255),
	RESRCELOCATION		lvarchar(255),
	primary key (CMID) constraint PK_CMOBJPROPS17 
) lock mode row;

create table CMOBJPROPS18 (
	CMID				integer not null,
	OUTPUTREFS			clob,
	PATHS				clob,
	primary key (CMID) constraint PK_CMOBJPROPS18 
) lock mode row;

create table CMOBJPROPS2 (
	CMID			integer not null,
	TASKID			lvarchar(32),
	STARTDATE		 datetime year to fraction,
	ENDDATE			 datetime year to fraction,
	ENDTYPE			smallint,
	EVERYNPERIODS	integer,
	DAILYPERIOD		smallint,
	MONTHLYABSDAY	smallint,
	MONTHLYRELDAY	smallint,
	MONTHLYRELWEEK	smallint,
	TYPE			smallint,
	YEARLYABSDAY	smallint,
	YEARLYABSMONTH	smallint,
	YEARLYRELDAY	smallint,
	YEARLYRELMONTH	smallint,
	YEARLYRELWEEK	smallint,
	ACTIVE			decimal(1,0) default 0 not null,
	WEEKLYMONDAY	decimal(1,0) default 0 not null,
	WEEKLYTUESDAY	decimal(1,0) default 0 not null,
	WEEKLYWEDNESDAY	decimal(1,0) default 0 not null,
	WEEKLYTHURSDAY	decimal(1,0) default 0 not null,
	WEEKLYFRIDAY	decimal(1,0) default 0 not null,
	WEEKLYSATURDAY	decimal(1,0) default 0 not null,
	WEEKLYSUNDAY	decimal(1,0) default 0 not null, 
	PRIORITY	integer,
	INTRARECURSTART		char (13),
	INTRARECUREND		char (13),
	INTRARECURINTERVAL	lvarchar (50),	
	primary key (CMID) constraint PK_CMOBJPROPS2  
) lock mode row;

create index CMSCRIPT_CS_IDIDX_TASKID on CMOBJPROPS2(TASKID);

create index CMSCRIPT_CS_IDIDX_PRIORITY on CMOBJPROPS2(PRIORITY);

create table CMOBJPROPS20 (
	CMID               integer not null,
	EXECLOCALEID       smallint,
	EXECFORMAT         smallint,
	EXECPAGEORIENT     smallint,
	EXECPROMPT         decimal(1,0) default 1 not null,
	DEFPORTACT         smallint,
	ALLOWSUBSCRIBE     decimal(1,0),
	ALLOWNOTIFICATION  decimal(1,0),
	OBJREFS            clob,
	primary key (CMID) constraint PK_CMOBJPROPS20 
) lock mode row;

create table CMOBJPROPS23 (
	CMID			integer not null,
	LSAUDITADMINLVL	smallint,
	LSAUDITLVL		smallint,
	LSAUDITOTHERLVL	smallint,
	LSAUDITUSAGELVL	smallint,
	LSAUDITNATIVEQRY	decimal(1,0),
	QSRMEMCACHEROOT   lvarchar (256),
	primary key (CMID) constraint PK_CMOBJPROPS23 
) lock mode row;

create table CMOBJPROPS24 (
	CMID			integer not null,
	LOCATION		lvarchar(1024),
	MODELNAME		lvarchar(512),
	PRINTERADDRESS	lvarchar(2048),
	primary key (CMID) constraint PK_CMOBJPROPS24 
) lock mode row;

create table CMOBJPROPS25 (
	CMID				integer not null,
	DEPLOYOBJECT		clob,
	DEPLOYOBJANC		clob,
	DEPLOYOBJCLASSID	integer,
	DEPLOYOBJDEFNAME	lvarchar(255),
	DEPLOYOBJDEFSTATUS	smallint,
	DEPLOYOBJUSAGE		smallint,
	MESSAGE				blob,
	primary key (CMID) constraint PK_CMOBJPROPS25 
) lock mode row;

CREATE TABLE CMOBJPROPS26 (
	CMID			integer not null,
	DELIVOPTIONS			clob,
	 primary key (CMID) constraint PK_CMOBJPROPS26
) lock mode row;

CREATE TABLE CMOBJPROPS27 (
	CMID				integer not null,
	CUBECONTNAME			lvarchar (2048),
	GATEWAY				lvarchar (1024),
	HASPROMPTS			decimal(1,0) default 0 not null,
	PPOPTIONS			clob ,
	DATABLOCKS			blob,
	PPDEFPORTACT			smallint,
	primary key (CMID) constraint PK_CMOBJPROPS27 
) lock mode row;

CREATE TABLE CMOBJPROPS28 (
	CMID            integer not null,
	EVENTKEY        clob ,
	EVENTTYPES      clob ,
	FILTERDATAITEM	lvarchar (512),
	PARMASSIGN	blob, 
	SEQUENCING	smallint,
	ALLOWNOTIFICATION decimal(1,0),
	DEFPORTACTION		smallint,
	RUNCOND		smallint,
	SPEC		clob,	
	primary key (CMID) constraint PK_CMOBJPROPS28 
) lock mode row;

create table CMOBJPROPS3 (
	CMID			integer not null,
	PROPNAME		lvarchar(50) not null,
	LOCALEID		smallint not null,
	VALUE			lvarchar (3700),
	ISDEFAULT		decimal(1,0),
	MAPDLOCALEID		smallint,
	primary key (CMID, PROPNAME, LOCALEID) constraint PK_CMOBJPROPS3  
) lock mode row;

create table CMOBJPROPS30 (
	CMID            integer not null,
	HANDLE          lvarchar(255),
	BINDING         clob,
	REGISTRATION    clob,
	SERVICEDESCR    clob,
	LAYOUT          clob,
	REQUIREDCAP	clob,
	CANCUSTOMIZE	decimal(1,0),
	CONTEXT         clob,
	DEPLOYREFS	clob,
	primary key (CMID) constraint PK_CMOBJPROPS30 
) lock mode row;

CREATE TABLE CMOBJPROPS31 (
	CMID			integer not null,
	ASAUDITLVL		smallint,
	BRSAUDITLVL		smallint,
	CMSAUDITLVL		smallint,
	DISPAUDITLVL		smallint,
	DSAUDITLVL		smallint,
	EMSAUDITLVL		smallint,
	JSAUDITLVL		smallint,
	MDSAUDITLVL		smallint,
	MMSAUDITLVL		smallint,
	MSAUDITLVL		smallint,
	PACSAUDITLVL		smallint,
	PDSAUDITLVL		smallint,
	PRSAUDITLVL		smallint,
	PSAUDITLVL		smallint,
	PTSAUDITLVL		smallint,
	RSAUDITLVL		smallint,
	SSAUDITLVL		smallint,
	BRSAUDITNATIVEQRY	decimal(1,0),
	RSAUDITNATIVEQRY	decimal(1,0),
	DISAUDITLVL		smallint,
	RSDATASOURCECHG	 datetime year to fraction,
	IDSAUDITLVL		smallint,
	ISSAUDITLVL		smallint,
	IUSAUDITLVL		smallint,
	RDSAUDITLVL		smallint,
	RDSMAXDATASIZE		integer,
	MBSAUDITLVL		smallint,
	DDSAUDITLVL		smallint,
	DDSLISPERPRCSR		integer,
	DMSAUDITLVL		smallint,
	MISAUDITLVL		smallint,
	MDSAFFINECONNECTIONS	integer,
	MDSNONAFFINECONNCTS	integer,
	MDSPEAKCONS		integer,
	MDSPEAKNONAFFINECONNCTS	integer,
	MDSPEAKMAXPROCS 	integer,	
	MDSMAXPROCESSES		integer,	
	MDSEXECUTIONTIMELIMIT	integer,	
	MDSQUEUELIMIT		integer,
	MDINFOURI		clob,
	DIMSAUDITLVL        	integer,
	EVSAUDITLVL        	integer,
	GSAUDITLVL		integer,
	AASAUDITLVL         	smallint,
	HTSAUDITLVL		smallint,
	CMCSAUDITLVL		smallint,
	QSAUDITLVL		smallint,
	BCSAUDITLVL		smallint,
	CSAUDITLVL		smallint,
	FSAUDITLVL		smallint,
	STSAUDITLVL		smallint,
	ANSAUDITLVL		smallint,
	RMDSAUDITLVL		smallint,
	IDVIZAUDITLVL		smallint,
	REPOSAUDITLVL		smallint,
	SACAMAUDITLVL		smallint,
	primary key (CMID) constraint PK_CMOBJPROPS31 
) lock mode row;

create table CMOBJPROPS32 (
	CMID			integer not null,
	STOREDPROCNAME	lvarchar(255),
	primary key (CMID) constraint PK_CMOBJPROPS32 
) lock mode row;

create table CMOBJPROPS33 (
	CMID           integer not null,
	NAME           lvarchar(255),
	USERID         lvarchar(1024),
	LASTLOGIN      datetime year to fraction,
	CAPABILITIES   lvarchar(64),
	LICENSE        smallint,
	primary key (CMID) constraint PK_CMOBJPROPS33 
) lock mode row;

create table CMOBJPROPS34 (
	CMID			integer not null,
	ACTION			smallint,
	BOOKMARKITEM		lvarchar(255),
	BOOKMARKTEXT		lvarchar(255),
	DRILLPARMASSIGN		blob,
	SCOPE			blob,
	SPEC			clob,	
	TARGETOPTIONS		clob,
	DEPLOYREFS		clob,
	primary key (CMID) constraint PK_CMOBJPROPS34 
) lock mode row;

create table CMOBJPROPS35 (
	CMID			integer not null,
	BINDINGNAME		lvarchar (512),
	INPUTMESSNAME		lvarchar (512),
	OPERATIONNAME		lvarchar (512),
	OUTPUTMESSNAME		lvarchar (512),
	SERVICENAME		lvarchar (512),
	BULKEVENTS		decimal(1,0),
	primary key (CMID) constraint PK_CMOBJPROPS35 
) lock mode row;

create table CMOBJPROPS36 (
	CMID			integer not null,
	ACTION			smallint,
	primary key (CMID) constraint PK_CMOBJPROPS36 
) lock mode row;

create table CMOBJPROPS37 (
	CMID                integer not null,
	ROUTINGHINTS        clob,
	PROFILESETTINGS     clob,
	PROFILERANK         integer default 0 NOT NULL,
	primary key (CMID) constraint PK_CMOBJPROPS37 
) lock mode row;

create table CMOBJPROPS38 (
	CMID			integer not null,
	CTITEMCOUNTDEFAULT	integer,
	CTITEMCOUNTLIMIT	integer,
	MBRITEMCOUNTDEFAULT	integer,
	MBRITEMCOUNTLIMIT	integer,
	primary key (CMID) constraint PK_CMOBJPROPS38 
) lock mode row;

CREATE TABLE CMOBJPROPS39 (
	PROPID		smallint NOT NULL,
	CMID		integer not null ,
	VALUE		smallint NOT NULL
) lock mode row;

create index CMSCRIPT_CS_IDIDX_CMOBJPROPS39 on CMOBJPROPS39 (CMID);
	
create table CMOBJPROPS4 (
	CMID			integer not null,
	HEIGHT			lvarchar(20),
	WIDTH			lvarchar(20),
	UNIT			smallint, 
	primary key (CMID) constraint PK_CMOBJPROPS4  
) lock mode row;

CREATE TABLE CMOBJPROPS40 (
	CMID			integer not null,
	APPGUID			lvarchar(50),
	APPID			lvarchar (512),
	APPSTATE		smallint,
	APPURL			clob ,
	primary key (CMID) constraint PK_CMOBJPROPS40  
) lock mode row;

CREATE TABLE CMOBJPROPS41 (
	CMID			integer not null,
	DEPTH			integer,
	ITEMID			lvarchar (512),
	PARENTID		lvarchar (512),
	primary key (CMID) CONSTRAINT PK_CMOBJPROPS41 
) lock mode row;

CREATE TABLE CMOBJPROPS42 (
	CMID			integer not null,
	SPEC			clob,
	primary key (CMID) constraint PK_CMOBJPROPS42  
) lock mode row;

CREATE TABLE CMOBJPROPS43 (
	CMID			integer not null,
	SPEC			clob,
	primary key (CMID) constraint PK_CMOBJPROPS43  
) lock mode row;

CREATE TABLE CMOBJPROPS44 (
	CMID			integer not null,
	RDSGATEWMAPPING		blob,
	primary key (CMID) CONSTRAINT PK_CMOBJPROPS44  
) lock mode row;

create table CMOBJPROPS45 (
	CMID			integer not null,
	LINK			smallint,
	primary key (CMID) constraint PK_CMOBJPROPS45 
) lock mode row;

CREATE TABLE CMOBJPROPS46 (
	CMID			integer not null,
	DOCTYPE			lvarchar (512),
	primary key (CMID) constraint PK_CMOBJPROPS46 
) lock mode row;

CREATE TABLE CMOBJPROPS47 (
	CMID			integer not null,
	SYSTEMMETRIC		smallint,
	PROPERTIES		blob,
	primary key (CMID) constraint PK_CMOBJPROPS47 
) lock mode row;

CREATE TABLE CMOBJPROPS48 (
	CMID			integer not null,
	ASCONNECTIONS		integer,
	CMSCONNECTIONS		integer,
	DDSCONNECTIONS		integer,
	DISCONNECTIONS		integer,
	DSCONNECTIONS		integer,
	IDSCONNECTIONS		integer,
	ISSCONNECTIONS		integer,
	IUSCONNECTIONS		integer,
	JSCONNECTIONS		integer,
	MBSCONNECTIONS		integer,
	MMSCONNECTIONS		integer,
	PACSCONNECTIONS		integer,
	PDSCONNECTIONS		integer,
	PRSCONNECTIONS		integer,
	PTSCONNECTIONS		integer,
	BRSCHHOTSPOTLIMIT	integer,
	RSCHHOTSPOTLIMIT	integer,
	CAPACITY		float,
	LOADBALMODE		smallint,
	DMSCONNECTIONS		integer,
	MISCONNECTIONS 		integer,
	DSCOMPATTACHLIMIT	integer,
	QSDIAGENABLED		decimal(1,0),
	QSMETENABLED		decimal(1,0),
	QSQUERYEXECTR		decimal(1,0),
	QSPLANTRC		decimal(1,0),
	BCSAFFCONS		integer,
	BCSEXECLMT		integer,
	BCSMAXPROCS		integer,
	BCSNONAFFCONS		integer,
	BCSPEAKAFFCONS		integer,
	BCSPEAKMAXPROCS		integer,
	BCSPEAKNONAFFCONS	integer,
	CSAFFCONS		integer,
	CSEXECLMT		integer,
	CSMAXPROCS		integer,
	CSNONAFFCONS		integer,
	CSPEAKAFFCONS		integer,
	CSPEAKMAXPROCS		integer,
	CSPEAKNONAFFCONS	integer,
	FSAFFCONS 		integer,
	FSEXECLMT		integer,
	FSCMAXPROCS		integer,
	FSNONAFFCONS		integer,
	FSPEAKAFFCONS		integer,
	FSPEAKMAXPROCS		integer,
	FSPEAKNONAFFCONS	integer,
	RMDSAFFCONS 		integer,
	RMDSEXECLMT		integer,
	RMDSNONAFFCONS		integer,
	RMDSPEAKAFFCONS		integer,
	RMDSPEAKNONAFFCONS	integer,
	DASAUDITLVL		smallint,
	RMDSCONS		integer,
	RMDSPEAKCONS		integer,
	QSVERBGCLOGLIMIT	integer,
	QSMDQUERYSIZELIMIT	integer,
	QSGENCOMINNATSQL	decimal(1,0),
	QSDISVERBGCLOG		decimal(1,0),
	QSINITNURSESIZE		integer,
	QSNURSESIZELIMIT	integer,
	QSGCPOLICY		smallint,
	REPOSCACHEOBJTTL	integer,
	REPOSNUMOBJDISK		integer,
	REPOSNUMOBJMEM		integer,
	MAXSTORESZMB		integer,
	primary key (CMID) constraint PK_CMOBJPROPS48 
) lock mode row;

CREATE TABLE CMOBJPROPS49 (
	CMID			integer not null,
	URI				clob ,
	primary key (CMID) constraint PK_CMOBJPROPS49 
) lock mode row;

create table CMOBJPROPS5 (
	CMID			integer not null,
	ACTEXECTIME		 datetime year to fraction,
	ACTCOMPTIME		 datetime year to fraction,
	REQEXECTIME		 datetime year to fraction,
	USERREF			clob, 
	DETAILTIME		 datetime year to fraction,
	DETAIL			clob,
	SEVERITY		smallint, 
	DETAILTYPE		lvarchar(64),
	INFO			clob, 
	primary key (CMID) constraint PK_CMOBJPROPS5 
) lock mode row;

create index CMSCRIPT_CS_IDIDX_REQEXECTIME on CMOBJPROPS5(REQEXECTIME);

create table CMOBJPROPS50 (
	CMID            integer not null,
	CONTEXT         blob,
	CONTEXTCOUNT    integer,
	LASTPAGE        lvarchar(512),
	DATADESCRIPTOR  clob,
	METADATA        blob,
	primary key (CMID) constraint PK_CMOBJPROPS50
) lock mode row;

create table CMOBJPROPS51 (
	CMID                 integer not null ,
	SERVERGROUP          lvarchar (512),
	RUNASOWNER           decimal(1,0),
	CANBURST             decimal(1,0),
	SCHEDTRIGNAME        lvarchar(255),
	RUNWITHOWNERCAPS     decimal(1,0),
	QUERYMODE            clob,
	RUNINADVANCEDVIEWER  decimal(1,0),
	DSMODE               lvarchar(4000),
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS51 
) lock mode row;

CREATE TABLE CMOBJPROPS52 (
	CMID             integer NOT NULL ,
	CONNECTSTR       lvarchar (2048),
	ISOLEVEL         smallint,
	QUALIFIER        smallint,
	REPLACEMENT      lvarchar (512),
	CLOSECONNECTCMD  clob,
	OPENCONNECTCMD   clob,
	CLOSESESSCMD     clob,
	OPENSESSCMD      clob,
	APITOKEN         clob,
	NOTIFYONCHANGE   decimal(1,0),
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS52 
) lock mode row;

CREATE TABLE CMOBJPROPS53 (
	CMID			integer NOT NULL ,
	SEQUENCING		smallint,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS53 
) lock mode row;

CREATE TABLE CMOBJPROPS54 (
	CMID			integer NOT NULL ,
	FORMAT			smallint,
	OLOCALEID		smallint,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS54 
) lock mode row;

CREATE TABLE CMOBJPROPS55 (
	CMID			integer not null,
	ICONURI			lvarchar (2000),
	UCPOLICIES		blob, 
	HIDDEN			decimal(1,0) default 0 not null,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS55  
) lock mode row;

CREATE TABLE CMOBJPROPS56 (
	CMID			integer not null,
	SPEC			clob,
	primary key (CMID) constraint PK_CMOBJPROPS56 
) lock mode row;

CREATE TABLE CMOBJPROPS57 (
	CMID			integer not null,
	SPEC			clob,
	primary key (CMID) constraint PK_CMOBJPROPS57 
) lock mode row;

CREATE TABLE CMOBJPROPS58 (
	CMID			integer not null,
	PDSELISTAXSCACHE	integer,
	PDSSHOWCELLANN		decimal(1,0),
	PDSMAXPROCS		integer,
	PPSHIAFFINECONS		integer,
	PPSAFFINECONS		integer,
	PPSAUDITLEVEL		smallint,
	PPSQUEUELIMIT		integer,
	PPSEXECTIMELIMIT	integer,
	BRSPDFCHARENC		smallint,
	BRSPDFCOMPRSLVL		integer,
	BRSPDFCOMPRSTYPE	smallint,
	BRSPDFEMBEDFONTS	smallint,
	RSPDFCHARENC		smallint,
	RSPDFCOMPRSLVL		integer,
	RSPDFCOMPRSTYPE		smallint,
	RSPDFEMBEDFONTS		smallint,
	DMSAFFINECONNECTIONS	integer,
	DMSEXECUTIONTIMELIMIT	integer,
	DMSMAXPROCESSES		integer,
	DMSNONAFFINECONNCTS	integer,
	DMSPEAKMAXPROCESSES	integer,
	DMSPEAKNONAFFINECONNCTS	integer,
	DMSQUEUELIMIT		integer,
	PERDOCVERSRETAGE	lvarchar (50),
	PERDOCVERSRETCOUNT	integer,
	EDITION			lvarchar(20),
	EDITIONS		blob,
	DIMSAFFINECONNECTIONS   integer,
    DIMSEXECUTIONTIMELIMIT  integer,
    DIMSMAXPROCESSES        integer,
    DIMSQUEUELIMIT          integer,
	GLOSSARYURI				clob ,
	GSAFFINECONNECTIONS		integer,
	GSEXECUTIONTIMELIMIT	integer,
	GSMAXPROCESSES			integer,
	GSNONAFFINECONNCTS		integer,
	GSPEAKMAXPROCESSES		integer,
	GSPEAKNONAFFINECONNCTS	integer,
	GSQUEUELIMIT			integer,
	GSPEAKCONS			integer,	
	AASAFFINECONNECTIONS	integer,
	AASEXECUTIONTIMELIMIT   integer,
	AASMAXPROCESSES		    integer,
	HTSCOMPTASKLIFE		lvarchar (50),
	CMCSHEAPLIM		integer,
	ANSANNOTATIONLIFE	lvarchar (50),
	primary key (CMID) constraint PK_CMOBJPROPS58  
) lock mode row;

create table CMOBJPROPS59 (
	CMID			integer not null,
	CONFIGURATION		clob ,
	USERINTERFACE		smallint,
 	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS59 
) lock mode row;

create table CMOBJPROPS6 (
	CMID			integer not null,
	URI				clob ,
	TARGET			clob ,
	STEPOBJECT		clob ,
	BASE			clob ,
	CREDENTIAL		clob ,
	DISPATCHERPATH	lvarchar (3220),
	PAGE			clob ,
	CREDNAMESPACES	clob ,
	primary key (CMID) constraint PK_CMOBJPROPS6  
) lock mode row;

create table CMOBJPROPS60 (
	CMID            integer not null,
	CONTEXT         blob,
	CONTEXTCOUNT	integer,
	LASTPAGE	lvarchar(512),
	primary key (CMID) constraint PK_CMOBJPROPS60 
) lock mode row;

create table CMOBJPROPS61 (
	CMID			integer not null,
	BURSTKEY		lvarchar (3982),
	primary key (CMID) constraint PK_CMOBJPROPS61 
) lock mode row;

create table CMOBJPROPS62 (
	CMID integer not null,
	EXPIRATION	 datetime year to fraction,
	ALLOWANNOTATION 	decimal(1,0),
	primary key (CMID) constraint PK_CMOBJPROPS62 
) lock mode row;

create index CMSCRIPT_CS_IDIDX_EXPIRATION_62 on CMOBJPROPS62(EXPIRATION);

CREATE TABLE CMOBJPROPS63 (
	CMID			integer not null,
	SPEC			clob,
	primary key (CMID) constraint PK_CMOBJPROPS63 
) lock mode row;

CREATE TABLE CMOBJPROPS64 (
	CMID			integer NOT NULL ,
	CONTENTTYPE		lvarchar (256),
	DATASIZE		bigint,
	DATACOMP		decimal(1,0) default 0 not null,
	DATAPROP		blob, 
	primary key (CMID) constraint PK_CMOBJPROPS64 
) lock mode row;

CREATE TABLE CMOBJPROPS65 (
	CMID			integer not null,
	BURSTID			lvarchar (3869),
	BURSTIDINDEX	character (44),
	primary key (CMID) constraint PK_CMOBJPROPS65  
) lock mode row;

CREATE INDEX CMSCRIPT_CS_IDIDX_BURSTIDINDEX ON CMOBJPROPS65(BURSTIDINDEX);

CREATE TABLE CMOBJPROPS66 (
	CMID			integer not null,
	DEFPORTACT		smallint,
	SPEC			clob,
	POWERPLAY8CONFIGURATION clob,
	primary key (CMID) constraint PK_CMOBJPROPS66 
) lock mode row;

CREATE TABLE CMOBJPROPS67 (
	CMID				integer not null,
	NONPEAKDEMANDBGNH	integer,
	PEAKDEMANDBEGINH	integer,
	ASPEAKCONS			integer,
	BRSPEAKAFFINECONS	integer,
	BRSPEAKMAXPROCS		integer,
	BRSPEAKNONAFFCONS	integer,
	CMSPEAKCONS			integer,
	DDSPEAKCONS			integer,
	DISPEAKCONS			integer,
	DMSPEAKCONS			integer,
	DSPEAKCONS			integer,
	IDSPEAKCONS			integer,
	ISSPEAKCONS			integer,
	IUSPEAKCONS			integer,
	JSPEAKCONS			integer,
	MBSPEAKCONS			integer,			
	MISPEAKCONS			integer,
	MMSPEAKCONS			integer,
	PACSPEAKCONS		integer,
	PDSPEAKCONS			integer,
	PDSPEAKMAXPROCS		integer,
	PPSPEAKAFFINECONS	integer,
	PPSPEAKNONAFFCONS	integer,
	PRSPEAKCONS			integer,
	PTSPEAKCONS			integer,
	RSPEAKAFFINECONS	integer,
	RSPEAKMAXPROCS		integer,
	RSPEAKNONAFFCONS	integer,
   	DIMSNONAFFINECONNCTS    integer,
   	DIMSPEAKCONS         integer,
   	DIMSPEAKMAXPROCS    integer,
   	DIMSPEAKNONAFFINECONNCTS    integer,
	TEMPOBJLOCATION		smallint,
	TEMPOBJLIFETIME		lvarchar (50),		
	AASNONAFFINECONNCTS     integer,  
   	AASPEAKCONS             integer,
   	AASPEAKMAXPROCS         integer,  
   	AASPEAKNONAFFINECONNCTS     integer,
	STSAFFCONS		integer,
	STSEXECLMT		integer,
	STSCMAXPROCS		integer,
	STSNONAFFCONS		integer,
	STSPEAKAFFCONS		integer,
	STSPEAKMAXPROCS		integer,
	STSPEAKNONAFFCONS	integer,	
	OVERRIDEOPTS		clob,
	SERVRDEFOPTS		clob,
	STSQUEUELIM			integer,
	COLLABDISCURI		clob,
	BRSMAXATTACHSIZE	integer,
	DSMAXATTACHSIZE		integer,
	RSMAXATTACHSIZE		integer,
	ASMAXATTACHSIZE		integer,
	PPSMAXATTACHSIZE	integer,
	QSIDLECONTIMEOUT integer,
	QSDUMPMODEL decimal(1,0),
	QSDISPLAN decimal(1,0),
	ACTIVEJMXPROXYURI	clob,
	QSADDJVMARG		lvarchar (2048),
	QSINITJVMHEAP		integer,
	QSMANCUBESTRT		decimal(1,0),
	QSMAXJVMHEAP		integer,
	QSROLAPCUBECONF		blob,
	QSROLAPCADMINCT		integer,
	QSRSETQUERYTHRES		integer,
	COOKIECAMPASSHTTP		decimal(1,0),
	primary key (CMID) constraint PK_CMOBJPROPS67 
) lock mode row;

CREATE TABLE CMOBJPROPS68 (
	CMID			integer not null,
	SPEC			clob,
	primary key (CMID) constraint PK_CMOBJPROPS68  
) lock mode row;


create table CMOBJPROPS69 (
	CMID			integer not null,
	ORD			integer not null,
	PARMNAME		lvarchar(512) not null,
	CPARMVALUE		blob,
	primary key (CMID, ORD) constraint PK_CMOBJPROPS69 
) lock mode row;


create table CMOBJPROPS7 (
	CMID			integer not null,
	EXECERROR		clob,
	CONFIGURATION		clob,
	PORTALPREFS		clob,
	CCREDENTIALS		clob,
	CMODEL			blob,
	SRC			clob,
	SPEC			clob,
	STATE			clob,
	GOVERNORS		clob,
	NAMESPFORMAT		clob,
	primary key (CMID) constraint PK_CMOBJPROPS7 
) lock mode row;

create table CMOBJPROPS70 (
	CMID            integer not null,
	CONTEXT         clob,
	DEPLOYREFS	clob,
	primary key (CMID) constraint PK_CMOBJPROPS70 
) lock mode row;

create table CMOBJPROPS71 (
	CMID            integer not null,
	CONTEXT         clob,
	DEPLOYREFS	clob,
	primary key (CMID) constraint PK_CMOBJPROPS71 
) lock mode row;

create table CMOBJPROPS72 (
	CMID            integer not null,
	CONTEXT         clob,
	primary key (CMID) constraint PK_CMOBJPROPS72 
) lock mode row;

CREATE TABLE CMOBJPROPS73 (
	CMID         integer not null,
	ALIASROOT    lvarchar (512),
	URI          clob ,
	UNIXURI      clob ,
	WINDOWSURI   clob ,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS73
) lock mode row;

CREATE TABLE CMOBJPROPS74 (
	CMID      	integer not null,
	DEPLOYREFS	clob,
	LAUNCHTYPE	lvarchar (512),
	SPEC		blob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS74
) lock mode row;

create index CMSCRIPT_CS_IDIDX_LAUNCHTYPE on CMOBJPROPS74(LAUNCHTYPE);

CREATE TABLE CMOBJPROPS75 (
	CMID         	integer not null,
	RESOURCETYPE	lvarchar (512),
	SPEC		blob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS75
) lock mode row;

create index CMSCRIPT_CS_IDIDX_RESOURCETYPE on CMOBJPROPS75(RESOURCETYPE);

CREATE TABLE CMOBJPROPS76 (
	CMID         	integer not null,
	CONTENTTYPE	lvarchar (512),
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS76
) lock mode row;

CREATE TABLE CMOBJPROPS77 (
	CMID			integer NOT NULL ,
	DSCONNECTIONNAME	lvarchar (512),
	DSNAME			lvarchar (512),
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS77 
) lock mode row;

CREATE TABLE CMOBJPROPS78 (
	CMID         		integer not null,
	BINDINGNAME		lvarchar (512),
	INPUTMESSNAME		lvarchar (512),
	OPERATIONNAME		lvarchar (512),
	OUTPUTMESSNAME		lvarchar (512),
	SERVICENAME		lvarchar (512),
	BULKEVENTS		decimal(1,0),
	URI			clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS78
) lock mode row;

CREATE TABLE CMOBJPROPS79 (
	CMID         	integer not null,
	PUBLISHED	decimal(1,0),
	SPEC		clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS79
) lock mode row;

create table CMOBJPROPS80 (
	CMID              integer not null,
	REPOSITORYRULES   clob,
	NSCAPS            clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS80 
) lock mode row;

create table CMOBJPROPS81 (
	CMID			integer not null,
	AGGREGATES		clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS81
) lock mode row;

create table CMOBJPROPS82 (
	CMID			integer not null,
	BPMRESTURI		clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS82
) lock mode row;

create table CMOBJPROPS83 (
	CMID			integer not null,
	MOBILECONFIG		blob,
	primary key (CMID) constraint PK_CMOBJPROPS83 
) lock mode row;

create table CMOBJPROPS84 (
	CMID		integer not null,
	SPEC		clob,
	DATASIZE	bigint,
	DATAMODTIME	datetime year to fraction,
	primary key (CMID) constraint PK_CMOBJPROPS84 
) lock mode row;

create table CMOBJPROPS85 (
	CMID             integer not null,
	DATA             clob,
	DEPLOYREFS       clob,
	OBJREFS          clob,
	BIVARS           clob,
	EMBEDDING        clob,
	STATUS           clob,
	USAGETRACKMODEL  clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS85
) lock mode row;

create table CMOBJPROPS86 (
	CMID			integer not null,
	KSCHEMA			lvarchar (256),
	KCATALOG		lvarchar (256),
	CPHYSDEF		clob,
	CPHYSANAL		clob,
	CBASEDEF		clob,
	CBASEOVER		clob,
	CBASEANAL		clob,
	STATUSID		smallint,
	SNAPSHOT       	clob,
	HISTORY       	clob,
	SNAPSHOTENBL	decimal(1,0),
	DEPLOYREFS		clob,
	ALIASROOT		lvarchar (256),
	primary key (CMID) constraint PK_CMOBJPROPS86 
) lock mode row;

create table CMOBJPROPS87 (
	CMID        integer not null,
	EXT         clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS87
) lock mode row;

create table CMOBJPROPS88 (
	CMID        integer not null,
	SCHEMATYPE		lvarchar (256),
	STATUS			lvarchar (256),
	STATUSINFO		clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS88
) lock mode row;

create table CMOBJPROPS89 (
	CMID        integer not null,
	DOCTYPE     lvarchar (64) not null,
	DOCID       lvarchar (64) not null,
	CONTENT     clob,
	PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS89
) lock mode row;

create index IDX_CMOBJPROPS89_1 on CMOBJPROPS89(DOCID);

create table CMOBJPROPS9 (
	CMID			integer not null,
	ASOFTIME		 datetime year to fraction, 
	CANBURST		decimal(1,0),
	primary key (CMID) constraint PK_CMOBJPROPS9 
) lock mode row;

CREATE TABLE CMOBJPROPS90 (
	CMID        integer not null,
	SPEC        clob,
	primary key (CMID) constraint PK_CMOBJPROPS90 
) lock mode row;

CREATE TABLE CMOBJPROPS91 (
	CMID        integer not null,
	SKDATA      clob,
	primary key (CMID) constraint PK_CMOBJPROPS91
) lock mode row;

CREATE TABLE CMOBJPROPS92 (
	CMID        integer not null,
	CONTYPE     lvarchar (64),
	URI         clob,
	SPEC        clob,
	primary key (CMID) constraint PK_CMOBJPROPS92
) lock mode row;

CREATE TABLE CMOBJPROPS93 (
	CMID                 integer NOT NULL,
	PROGRESS             lvarchar(1024),
	JOBID                lvarchar(64),
	STATE                lvarchar(64),
	CONFIGURATION        clob,
	primary key (CMID) constraint PK_CMOBJPROPS93
) lock mode row;

create table CMTAGS (
	CMID      integer not null,
	ORD       integer not null,
	TAG       lvarchar(256),
	primary key (CMID, ORD) constraint PK_CMTAGS
) lock mode row;

create index IDX_CMTAGS on CMTAGS(CMID, TAG);

create table CMPOLICIES (
	CMID			integer not null,
	POLICIES		blob, 
	primary key (CMID) constraint PK_CMPOLICIES 
) lock mode row;

create table CMVIEWED (
	CMID			integer not null,
	OBJID			lvarchar(1024) default '-',
	VIEWED			decimal(1,0) default 0, 
	primary key (CMID) constraint PK_CMVIEWED 
) lock mode row;

create table CMPROPERTIES (
	PROPID			smallint NOT NULL,
	NAME			lvarchar(50) NOT NULL,
	DEF			blob,
	primary key(PROPID) constraint PK_CMPROPERTIES 
) lock mode row;

create table CMCLASSES (
	CLASSID			integer NOT NULL,
	NAME			lvarchar(50) NOT NULL,
	USAGE			smallint,
	DEF			blob,
	primary key(CLASSID) 	constraint PK_CMCLASSES 
) lock mode row;

create table CMLOCALES (
	LOCALEID		smallint	not null,
	MAPDLOCALEID		smallint	not null,
	LOCALE			lvarchar(20)	not null,
	primary key (LOCALEID) 	constraint PK_CMLOCALES 
) lock mode row;

create table CMGUIDS_BASE (
	CMID			integer not null ,
	GUID			lvarchar(50),
	primary key (CMID) constraint PK_CMGUIDS 
) lock mode row;

create view CMGUIDS as select CMID, GUID from CMGUIDS_BASE;

CREATE SEQUENCE UNIQUE_ID_GENERATOR;

create trigger CMGUIDS_TR instead of insert on CMGUIDS referencing new as NG for each row ( insert into CMGUIDS_BASE (CMID, GUID) values (NG.CMID, CAST(UNIQUE_ID_GENERATOR.NEXTVAL AS lvarchar)));

CREATE TABLE  CMREFNOORD1 (
	PROPID		smallint NOT NULL,
	CMID		integer not null ,
	REFCMID		integer not null ,
	primary key (CMID, PROPID) constraint PK_CMREFNOORD1  
) lock mode row;

create index CMSCRIPT_CS_IDIDX_CMREFNOORD1 on CMREFNOORD1(REFCMID, PROPID);

CREATE TABLE  CMREFNOORD2 (
	CMID		integer not null ,
	REFCMID		integer not null ,
	primary key (CMID) constraint PK_CMREFNOORD2
) lock mode row;

create index CMSCRIPT_CS_IDIDX_CMREFNOORD2 on CMREFNOORD2(REFCMID);

CREATE TABLE  CMREFORD1 (
	PROPID		smallint,
	CMID		integer ,
	ORD		integer ,
	REFCMID		integer ,
	primary key (CMID, PROPID, ORD) constraint PK_CMREFORD1  
) lock mode row;

create index CMSCRIPT_CS_IDIDX_CMREFORD1 on CMREFORD1(REFCMID, PROPID, ORD);

CREATE TABLE  CMREFORD2 (
	CMID		integer not null ,
	ORD		integer NOT NULL,
	REFCMID		integer not null ,
	primary key (CMID, ORD) constraint PK_CMREFORD2 
) lock mode row;

create index CMSCRIPT_CS_IDIDX_CMREFORD2 on CMREFORD2(REFCMID, ORD);

CREATE TABLE CMNOTIFICATIONTABLE (
	STOREID		char(33) NOT NULL,	
	OPERATION	lvarchar(25) NOT NULL,
	CLASSNAME	lvarchar(25) NOT NULL,
	EVENTTIME	 datetime year to fraction NOT NULL,
	primary key (STOREID,OPERATION,EVENTTIME) constraint PK_CMNOTIFICATION  
) lock mode row;

create view CMOWNERCOUNT(OBJID, OWN_NUMBER) as 
   SELECT p2.OBJID, count(o.CMID)  
   FROM CMOBJECTS o left outer join CMREFNOORD2 p1 on p1.CMID = o.CMID
                    left outer join CMOBJPROPS1 p2 on p1.REFCMID = p2.CMID
   GROUP BY p2.OBJID;

CREATE TABLE CMDATAUPGRADE (
	PLUGINNAME 	lvarchar (255) NOT NULL ,
	CI_PLUGINNAME	lvarchar (255) NOT NULL ,
	VERSION		lvarchar (64) ,
	PRIMARY KEY (CI_PLUGINNAME) CONSTRAINT PK_CMDATAUPGRADE 
) lock mode row;

CREATE TABLE CMSIZEINFO (
	STOREID          lvarchar (255) NOT NULL,
	CLASSID          integer NOT NULL,
	TOTALFORCLASSID  integer NOT NULL,
	TOTALCOUNT       bigint ,
	TOTALSIZE        bigint ,
	PRIMARY KEY (STOREID, TOTALFORCLASSID) CONSTRAINT PK_CMSIZEINFO 
) lock mode row;

CREATE TABLE  CMSPLIT (
	CMID		integer NOT NULL,
	TRANSACTIONID	lvarchar (255) NOT NULL,
	PRIMARY KEY (CMID, TRANSACTIONID) CONSTRAINT PK_CMSPLIT 
) lock mode row;

CREATE TABLE CMARCHIVEQUEUE (
	OBJID 	 	lvarchar(255) default null,
	ITEMID	 	lvarchar(255) not null,
	QUEUEID		lvarchar(255) not null,
	WORKFLOW 	lvarchar(255) not null,
	CONSUMERNAME	lvarchar(255) default null,
	STATE		integer,
	INSERTIONTIME 	datetime year to fraction not null,
	PRIMARY KEY (ITEMID) CONSTRAINT PK_CMARCHIVEQUEUE  
)lock mode row;

CREATE TABLE CMDELETEQUEUE (
	OBJID 	 	lvarchar(255) default null,
	ITEMID	 	lvarchar(255) not null,
	QUEUEID		lvarchar(255) not null,
	WORKFLOW 	lvarchar(255) not null,
	CONSUMERNAME	lvarchar(255) default null,
	STATE		integer,
	INSERTIONTIME 	datetime year to fraction not null,
	PRIMARY KEY (ITEMID) CONSTRAINT PK_CMDELETEQUEUE  
)lock mode row;

CREATE TABLE CMINDEXQUEUE (
	OBJID 	 		lvarchar(1024) default null,
	ITEMID	 		lvarchar(50) not null,
	QUEUEID			lvarchar(50) not null,
	WORKFLOW 		lvarchar(50) not null,
	CONSUMERNAME	lvarchar(50) default null,
	STATE			integer,
	INSERTIONTIME 	datetime year to fraction not null,
	INDEXACTION		lvarchar(50) NOT NULL,
	INDEXCLASS		lvarchar(255) NOT NULL,
	INDEXPROPS		clob,
	PRIMARY KEY (ITEMID) CONSTRAINT PK_CMINDEXQUEUE  
)lock mode row;

CREATE INDEX CMSCRIPT_CS_IDIDX_CMINDEXQUEUE on CMINDEXQUEUE(STATE, QUEUEID);

CREATE TABLE CMQUEUELOCK (
	QUEUEID		lvarchar(255) not null,
	PRIMARY KEY (QUEUEID) CONSTRAINT PK_CMQUEUELOCK 
)lock mode row;

CREATE TABLE CMTENANTID (
	TENANTID	INTEGER NOT NULL,
	TENANTNAME	LVARCHAR(255) NOT NULL,
	PRIMARY KEY (TENANTID) CONSTRAINT PK_CMTENANTID
)lock mode row;

INSERT INTO CMTENANTID (TENANTID,TENANTNAME) VALUES (0,'');

insert into CMSYSPROPS (PROPNAME, CI_PROPNAME, PROPVALUE)
	values ('CMStoreVersion', upper('CMStoreVersion'), '7.7003');