-----------------------------------------------------------------------------
-- OJB_HL_SEQ
-----------------------------------------------------------------------------



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




-----------------------------------------------------------------------------
-- OJB_LOCKENTRY
-----------------------------------------------------------------------------



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




-----------------------------------------------------------------------------
-- OJB_NRM
-----------------------------------------------------------------------------



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




-----------------------------------------------------------------------------
-- OJB_DLIST
-----------------------------------------------------------------------------



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




-----------------------------------------------------------------------------
-- OJB_DLIST_ENTRIES
-----------------------------------------------------------------------------



CREATE TABLE OJB_DLIST_ENTRIES
(
    ID INTEGER NOT NULL,
    DLIST_ID INTEGER,
    POSITION_ INTEGER,
    OID_ BYTEA,
    PRIMARY KEY (ID)
);




-----------------------------------------------------------------------------
-- OJB_DSET
-----------------------------------------------------------------------------



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




-----------------------------------------------------------------------------
-- OJB_DSET_ENTRIES
-----------------------------------------------------------------------------



CREATE TABLE OJB_DSET_ENTRIES
(
    ID INTEGER NOT NULL,
    DLIST_ID INTEGER,
    POSITION_ INTEGER,
    OID_ BYTEA,
    PRIMARY KEY (ID)
);




-----------------------------------------------------------------------------
-- OJB_DMAP
-----------------------------------------------------------------------------



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




----------------------------------------------------------------------
-- OJB_DMAP                                                      
----------------------------------------------------------------------


----------------------------------------------------------------------
-- OJB_HL_SEQ                                                      
----------------------------------------------------------------------


----------------------------------------------------------------------
-- OJB_LOCKENTRY                                                      
----------------------------------------------------------------------


----------------------------------------------------------------------
-- OJB_NRM                                                      
----------------------------------------------------------------------


----------------------------------------------------------------------
-- OJB_DLIST                                                      
----------------------------------------------------------------------


----------------------------------------------------------------------
-- OJB_DLIST_ENTRIES                                                      
----------------------------------------------------------------------


----------------------------------------------------------------------
-- OJB_DSET                                                      
----------------------------------------------------------------------


----------------------------------------------------------------------
-- OJB_DSET_ENTRIES                                                      
----------------------------------------------------------------------