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

CREATE TABLE OJB_HL_SEQ
(
    TABLENAME VARCHAR2(175) NOT NULL,
    FIELDNAME VARCHAR2(70) NOT NULL,
    MAX_KEY NUMBER(10,0),
    GRAB_SIZE NUMBER(10,0),
    VERSION NUMBER(10,0)
);

ALTER TABLE OJB_HL_SEQ
    ADD CONSTRAINT OJB_HL_SEQ_PK
PRIMARY KEY (TABLENAME,FIELDNAME);






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

CREATE TABLE OJB_LOCKENTRY
(
    OID_ VARCHAR2(250) NOT NULL,
    TX_ID VARCHAR2(50) NOT NULL,
    TIMESTAMP_ TIMESTAMP,
    ISOLATIONLEVEL NUMBER(10,0),
    LOCKTYPE NUMBER(10,0)
);

ALTER TABLE OJB_LOCKENTRY
    ADD CONSTRAINT OJB_LOCKENTRY_PK
PRIMARY KEY (OID_,TX_ID);






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

CREATE TABLE OJB_NRM
(
    NAME VARCHAR2(250) NOT NULL,
    OID_ LONG RAW
);

ALTER TABLE OJB_NRM
    ADD CONSTRAINT OJB_NRM_PK
PRIMARY KEY (NAME);






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

CREATE TABLE OJB_DLIST
(
    ID NUMBER(10,0) NOT NULL,
    SIZE_ NUMBER(10,0)
);

ALTER TABLE OJB_DLIST
    ADD CONSTRAINT OJB_DLIST_PK
PRIMARY KEY (ID);






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

CREATE TABLE OJB_DLIST_ENTRIES
(
    ID NUMBER(10,0) NOT NULL,
    DLIST_ID NUMBER(10,0),
    POSITION_ NUMBER(10,0),
    OID_ LONG RAW
);

ALTER TABLE OJB_DLIST_ENTRIES
    ADD CONSTRAINT OJB_DLIST_ENTRIES_PK
PRIMARY KEY (ID);






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

CREATE TABLE OJB_DSET
(
    ID NUMBER(10,0) NOT NULL,
    SIZE_ NUMBER(10,0)
);

ALTER TABLE OJB_DSET
    ADD CONSTRAINT OJB_DSET_PK
PRIMARY KEY (ID);






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

CREATE TABLE OJB_DSET_ENTRIES
(
    ID NUMBER(10,0) NOT NULL,
    DLIST_ID NUMBER(10,0),
    POSITION_ NUMBER(10,0),
    OID_ LONG RAW
);

ALTER TABLE OJB_DSET_ENTRIES
    ADD CONSTRAINT OJB_DSET_ENTRIES_PK
PRIMARY KEY (ID);






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

CREATE TABLE OJB_DMAP
(
    ID NUMBER(10,0) NOT NULL,
    SIZE_ NUMBER(10,0)
);

ALTER TABLE OJB_DMAP
    ADD CONSTRAINT OJB_DMAP_PK
PRIMARY KEY (ID);