create table J2EE_CONFIG (
		"CID" numeric(19) not null,
		"PARENTCID" numeric(19),
		"PATHPREFIX" vargraphic(127),
		"CPATH" vargraphic(300),
		"PATHHASH" integer,
		"CACHEMODE" integer,
		"CTYPE" integer,
		"LINKEDCPATH" vargraphic(300),
		primary key (CID)
);
create unique index J2EE_CONFIG_I0 on J2EE_CONFIG(CPATH);
create index J2EE_CONFIG_I1 on J2EE_CONFIG(PATHPREFIX);
create index J2EE_CONFIG_I2 on J2EE_CONFIG(PATHHASH);
create index J2EE_CONFIG_I3 on J2EE_CONFIG(PARENTCID);
create index J2EE_CONFIG_I4 on J2EE_CONFIG(CTYPE);
create table J2EE_CONFIGENTRY(
		"CID" numeric(19) not null,
		"NAMEHASH" integer not null,
		"ISFILE" smallint not null,
		"NAME" vargraphic(256) not null,
		"DTYPE" numeric(19),
		"VBIGINT" numeric(19),
		"VDOUBLE" double,
		"VSTR" vargraphic(2000),
		"VBYTES" varchar(2000) FOR BIT DATA,
		"FBLOB" blob(2G)
);
create index J2EE_CFGENTRY_I0 on J2EE_CONFIGENTRY(CID, NAMEHASH, ISFILE);
create table J2EE_KEYSEQUENCE (
		"SEQUENCE_ID" integer not null,
		"INC_VALUE" numeric(19),
		primary key (SEQUENCE_ID)
);