------------------------------------------------------------------------ -----
-- 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 [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
