create table J2EE_CONFIG(
		CID fixed(19) primary key, 
		PARENTCID fixed(19),
		PATHPREFIX varchar(127) UNICODE,
		CPATH varchar(300) UNICODE,
		PATHHASH integer,
		CACHEMODE integer,
		CTYPE integer,
		LINKEDCPATH varchar(300) UNICODE
)
//
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 fixed(19),
		NAMEHASH integer,
        ISFILE smallint,
		NAME varchar(256) UNICODE,
		DTYPE fixed(19),
		VBIGINT fixed(19),
		VDOUBLE float,
		VSTR varchar(2000) UNICODE,
		VBYTES varchar(2000) byte,
        FBLOB long byte
)
//
create index J2EE_CFGENTRY_I0 on J2EE_CONFIGENTRY(CID, NAMEHASH, ISFILE)
//
create table J2EE_KEYSEQUENCE(
		SEQUENCE_ID integer primary key,
		INC_VALUE fixed(19)
)