# -----------------------------------------------------------------------
# OJB_HL_SEQ
# -----------------------------------------------------------------------
drop table if exists OJB_HL_SEQ;

CREATE TABLE OJB_HL_SEQ
(
    TABLENAME VARCHAR(175) NOT NULL,
    FIELDNAME VARCHAR(70) NOT NULL,
    MAX_KEY MEDIUMINT,
    GRAB_SIZE MEDIUMINT,
    VERSION MEDIUMINT,
    PRIMARY KEY(TABLENAME,FIELDNAME));

# -----------------------------------------------------------------------
# OJB_LOCKENTRY
# -----------------------------------------------------------------------
drop table if exists OJB_LOCKENTRY;

CREATE TABLE OJB_LOCKENTRY
(
    OID_ VARCHAR(250) NOT NULL,
    TX_ID VARCHAR(50) NOT NULL,
    TIMESTAMP_ TIMESTAMP,
    ISOLATIONLEVEL MEDIUMINT,
    LOCKTYPE MEDIUMINT,
    PRIMARY KEY(OID_,TX_ID));

# -----------------------------------------------------------------------
# OJB_NRM
# -----------------------------------------------------------------------
drop table if exists OJB_NRM;

CREATE TABLE OJB_NRM
(
    NAME VARCHAR(250) NOT NULL,
    OID_ LONGBLOB,
    PRIMARY KEY(NAME));

# -----------------------------------------------------------------------
# OJB_DLIST
# -----------------------------------------------------------------------
drop table if exists OJB_DLIST;

CREATE TABLE OJB_DLIST
(
    ID MEDIUMINT NOT NULL,
    SIZE_ MEDIUMINT,
    PRIMARY KEY(ID));

# -----------------------------------------------------------------------
# OJB_DLIST_ENTRIES
# -----------------------------------------------------------------------
drop table if exists OJB_DLIST_ENTRIES;

CREATE TABLE OJB_DLIST_ENTRIES
(
    ID MEDIUMINT NOT NULL,
    DLIST_ID MEDIUMINT,
    POSITION_ MEDIUMINT,
    OID_ LONGBLOB,
    PRIMARY KEY(ID));

# -----------------------------------------------------------------------
# OJB_DSET
# -----------------------------------------------------------------------
drop table if exists OJB_DSET;

CREATE TABLE OJB_DSET
(
    ID MEDIUMINT NOT NULL,
    SIZE_ MEDIUMINT,
    PRIMARY KEY(ID));

# -----------------------------------------------------------------------
# OJB_DSET_ENTRIES
# -----------------------------------------------------------------------
drop table if exists OJB_DSET_ENTRIES;

CREATE TABLE OJB_DSET_ENTRIES
(
    ID MEDIUMINT NOT NULL,
    DLIST_ID MEDIUMINT,
    POSITION_ MEDIUMINT,
    OID_ LONGBLOB,
    PRIMARY KEY(ID));

# -----------------------------------------------------------------------
# OJB_DMAP
# -----------------------------------------------------------------------
drop table if exists OJB_DMAP;

CREATE TABLE OJB_DMAP
(
    ID MEDIUMINT NOT NULL,
    SIZE_ MEDIUMINT,
    PRIMARY KEY(ID));