create table "J2EE_CONFIG" (
	"CID" int8 not null primary key,
	"PARENTCID" int8,
	"PATHPREFIX" nvarchar(255),
	"CPATH" lvarchar,
	"PATHHASH" integer,
	"CACHEMODE" integer,
	"CTYPE" integer,
	"LINKEDCPATH" lvarchar
)
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" int8 not null,
	"NAMEHASH" integer not null,
	"ISFILE" smallint not null,
	"NAME" lvarchar not null,
	"DTYPE" int8,
	"VBIGINT" int8,
	"VDOUBLE" float,
	"VSTR" lvarchar,
	"VBYTES" blob,
	"FBLOB" blob
);
create index J2EE_CFGENTRY_I0 on J2EE_CONFIGENTRY(CID, NAMEHASH, ISFILE);
create table "J2EE_KEYSEQUENCE" (
	"SEQUENCE_ID" integer not null,
	"INC_VALUE" int8,
	primary key ("SEQUENCE_ID")
);