You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Steve Linabery <sl...@worldcycling.com> on 2003/02/19 18:58:52 UTC

DDL for OJB_ tables

Hello,

Tried reading the archive first, but link was broken.

I want to use OJB in an existing production database (PostgreSQL).

But I don't want all the test relations created (artikel, etc.) when you
do the prepare-test-db target.

Does anyone have plain SQL to create all the OJB_ tables?  I don't want
to play with turbine if I can avoid it...too busy.

Thanks!
Steve
-- 
Steve Linabery, sysadmin/developer
World Cycling Productions

Re: DDL for OJB_ tables

Posted by "Robert S. Sfeir" <sf...@mail.nih.gov>.
On Wednesday, Feb 19, 2003, at 12:58 US/Eastern, Steve Linabery wrote:

> Hello,
>
> Tried reading the archive first, but link was broken.
>
> I want to use OJB in an existing production database (PostgreSQL).
>
> But I don't want all the test relations created (artikel, etc.) when 
> you
> do the prepare-test-db target.
>
> Does anyone have plain SQL to create all the OJB_ tables?  I don't want
> to play with turbine if I can avoid it...too busy.
>
> Thanks!
> Steve
> -- 
> Steve Linabery, sysadmin/developer
> World Cycling Productions
> <signature.asc>
R

--
Robert S. Sfeir
Senior Java Engineer
National Institutes of Health
Center for Information Technology
Department of Enterprise Custom Applications
sfeir@mail.nih.gov

Re: DDL for OJB_ tables

Posted by "Robert S. Sfeir" <ro...@sfeir.net>.
------------------------------------------------------------------------ 
-----
-- OJB_HL_SEQ
------------------------------------------------------------------------ 
-----
DROP TABLE OJB_HL_SEQ;


CREATE TABLE OJB_HL_SEQ
(
                             TABLENAME varchar (175) NOT NULL,
                             FIELDNAME varchar (70) NOT NULL,
                             MAX_KEY integer,
                             GRAB_SIZE integer,
     PRIMARY KEY (TABLENAME,FIELDNAME)
);


------------------------------------------------------------------------ 
-----
-- OJB_LOCKENTRY
------------------------------------------------------------------------ 
-----
DROP TABLE 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
------------------------------------------------------------------------ 
-----
DROP TABLE OJB_NRM;


CREATE TABLE OJB_NRM
(
                             NAME varchar (250) NOT NULL,
                             OID_ bytea,
     PRIMARY KEY (NAME)
);


------------------------------------------------------------------------ 
-----
-- OJB_DLIST
------------------------------------------------------------------------ 
-----
DROP TABLE OJB_DLIST;


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


------------------------------------------------------------------------ 
-----
-- OJB_DLIST_ENTRIES
------------------------------------------------------------------------ 
-----
DROP TABLE OJB_DLIST_ENTRIES;


CREATE TABLE OJB_DLIST_ENTRIES
(
                             ID integer NOT NULL,
                             DLIST_ID integer NOT NULL,
                             POSITION_ integer,
                             OID_ bytea,
     PRIMARY KEY (ID)
);


------------------------------------------------------------------------ 
-----
-- OJB_DSET
------------------------------------------------------------------------ 
-----
DROP TABLE OJB_DSET;


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


------------------------------------------------------------------------ 
-----
-- OJB_DSET_ENTRIES
------------------------------------------------------------------------ 
-----
DROP TABLE OJB_DSET_ENTRIES;


CREATE TABLE OJB_DSET_ENTRIES
(
                             ID integer NOT NULL,
                             DLIST_ID integer NOT NULL,
                             POSITION_ integer,
                             OID_ bytea,
     PRIMARY KEY (ID)
);


------------------------------------------------------------------------ 
-----
-- OJB_DMAP
------------------------------------------------------------------------ 
-----
DROP TABLE OJB_DMAP;


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


------------------------------------------------------------------------ 
-----
-- OJB_DMAP_ENTRIES
------------------------------------------------------------------------ 
-----
DROP TABLE OJB_DMAP_ENTRIES;


CREATE TABLE OJB_DMAP_ENTRIES
(
                             ID integer NOT NULL,
                             DMAP_ID integer NOT NULL,
                             KEY_OID bytea,
                             VALUE_OID bytea,
     PRIMARY KEY (ID)
);


----------------------------------------------------------------------
-- OJB_DMAP_ENTRIES                                                      
----------------------------------------------------------------------


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


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


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


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


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


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


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


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


On Wednesday, Feb 19, 2003, at 12:58 US/Eastern, Steve Linabery wrote:

> Hello,
>
> Tried reading the archive first, but link was broken.
>
> I want to use OJB in an existing production database (PostgreSQL).
>
> But I don't want all the test relations created (artikel, etc.) when  
> you
> do the prepare-test-db target.
>
> Does anyone have plain SQL to create all the OJB_ tables?  I don't want
> to play with turbine if I can avoid it...too busy.
>
> Thanks!
> Steve
> -- 
> Steve Linabery, sysadmin/developer
> World Cycling Productions
> <signature.asc>
R

--
Robert S. Sfeir
Senior Java Engineer
National Institutes of Health
Center for Information Technology
Department of Enterprise Custom Applications
sfeir@mail.nih.gov