create table J2EE_CONFIG (
		CID bigint primary key,
		PARENTCID bigint,
		PATHPREFIX nvarchar(127),
		CPATH nvarchar(300),			
		PATHHASH integer,
		CACHEMODE integer,
		CTYPE integer,
		LINKEDCPATH nvarchar(300)
);
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 bigint,
		NAMEHASH integer,
		ISFILE smallint,
		NAME nvarchar(256),
		DTYPE bigint,
		VBIGINT bigint,
		VDOUBLE float(53),
		VSTR nvarchar(2000),
		VBYTES varbinary(2000),
		FBLOB image
);
create index J2EE_CFGENTRY_I0 on J2EE_CONFIGENTRY(CID, NAMEHASH, ISFILE);
create table J2EE_KEYSEQUENCE (
		SEQUENCE_ID integer primary key,
		INC_VALUE bigint
);
