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 Goncalo Luiz <ge...@rnl.ist.utl.pt> on 2003/04/27 20:03:06 UTC

the script

The script I forgot in my last mail:
#----------------------------
# Table structure for ojb_dlist
#----------------------------
drop table if exists OJB_DLIST;
create table OJB_DLIST (
   ID int(11) not null default '0',
   SIZE_ int(11),
   primary key (ID))
   type=InnoDB;

#----------------------------
# Table structure for ojb_dlist_entries
#----------------------------
drop table if exists OJB_DLIST_ENTRIES;
create table OJB_DLIST_ENTRIES (
   ID int(11) not null default '0',
   DLIST_ID int(11) not null default '0',
   POSITION_ int(11),
   OID_ longblob,
   primary key (ID))
   type=InnoDB;

#----------------------------
# Table structure for ojb_dmap
#----------------------------
drop table if exists OJB_DMAP;
create table OJB_DMAP (
   ID int(11) not null default '0',
   SIZE_ int(11),
   primary key (ID))
   type=InnoDB;

#----------------------------
# Table structure for ojb_dmap_entries
#----------------------------
drop table if exists OJB_DMAP_ENTRIES;
create table OJB_DMAP_ENTRIES (
   ID int(11) not null default '0',
   DMAP_ID int(11) not null default '0',
   KEY_OID longblob,
   VALUE_OID longblob,
   primary key (ID))
   type=InnoDB;

#----------------------------
# Table structure for ojb_dset
#----------------------------
drop table if exists OJB_DSET;
create table OJB_DSET (
   ID int(11) not null default '0',
   SIZE_ int(11),
   primary key (ID))
   type=InnoDB;

#----------------------------
# Table structure for ojb_dset_entries
#----------------------------
drop table if exists OJB_DSET_ENTRIES;
create table OJB_DSET_ENTRIES (
   ID int(11) not null default '0',
   DLIST_ID int(11) not null default '0',
   POSITION_ int(11),
   OID_ longblob,
   primary key (ID))
   type=InnoDB;

#----------------------------
# Table structure for 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 int(11),
   GRAB_SIZE int(11),
   primary key (TABLENAME, FIELDNAME))
   type=InnoDB;

#----------------------------
# Table structure for ojb_lockentry
#----------------------------
drop table if exists OJB_LOCKENTRY;
create table OJB_LOCKENTRY (
   OID_ varchar(250) not null,
   TX_ID varchar(50) not null,
   TIMESTAMP_ decimal(10,0),
   ISOLATIONLEVEL int(11),
   LOCKTYPE int(11),
   primary key (OID_, TX_ID))
   type=InnoDB;

#----------------------------
# Table structure for ojb_nrm
#----------------------------
drop table if exists OJB_NRM;
create table OJB_NRM (
   NAME varchar(250) not null,
   OID_ longblob,
   primary key (NAME))
   type=InnoDB;

#----------------------------
# Table structure for ojb_seq
#----------------------------
drop table if exists OJB_SEQ;
create table OJB_SEQ (
   TABLENAME varchar(175) not null,
   FIELDNAME varchar(70) not null,
   LAST_NUM int(11),
   primary key (TABLENAME, FIELDNAME))
   type=InnoDB;



Gonçalo D. Luiz (gedl@rnl.ist.utl.pt) | Tlm: 933 480 059



no validation checking of attributes

Posted by onno <on...@onnos.com>.
Hiyall i've mentioned this before but it actually now caused me a few hours
:)

in a descriptor i mispelled "column" by "colmn". Parsing OJB gave no issues
(or it doens't throw) an error... so i continued.
Needless to say i got a few weird errors along the way and after staring
myself blind , somebody else spotted it in a few
secs... Perhaps validation of attributes would be usefull as well as all
other checking?

Onno


Re: the script

Posted by Armin Waibel <ar...@code-au-lait.de>.
----- Original Message -----
From: "Goncalo Luiz" <ge...@rnl.ist.utl.pt>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Sunday, April 27, 2003 9:17 PM
Subject: Re: the script


> It works know. I've changed LONGBINARYVAR to BLOB.
> I have two more questions:
> 1- Is BLOB enough or its better change it to longblob ?

sorry, I don't have experience with that

> 2- Does this tables need to be transactional? If so, I need to add the
> Type=InnoDB instruction.

yes!

regards,
Armin

>
> Thank you very much,
> Gonçalo D. Luiz (gedl@rnl.ist.utl.pt) | Tlm: 933 480 059
> ----- Original Message -----
> From: "Armin Waibel" <ar...@code-au-lait.de>
> To: "OJB Users List" <oj...@db.apache.org>
> Sent: Sunday, April 27, 2003 7:11 PM
> Subject: Re: the script
>
>
> > Try this one (maybe you have to do
> > some modification for your mysql
> > database)
> >
> > OJB internal tables
> > (ojb_seq is completely removed):
> >
> > CREATE TABLE OJB_HL_SEQ(
> > TABLENAME VARCHAR(175) NOT NULL,
> > FIELDNAME VARCHAR(70) NOT NULL,
> > MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,
> > CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
> >
> > CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID
VARCHAR(50)
> > NOT NULL,TIMESTAMP_ TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE
> > INTEGER,CONSTRAINT SYS_PK_OJB_LOCKENTRY PRIMARY KEY(OID_,TX_ID))
> >
> > CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_
> > LONGVARBINARY)
> > CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_
INTEGER)
> >
> > CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY
KEY,DLIST_ID
> > INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
> > CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
> >
> > CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY
KEY,DLIST_ID
> > INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
> > CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
> >
> > CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY
KEY,DMAP_ID
> > INTEGER,KEY_OID LONGVARBINARY,VALUE_OID LONGVARBINARY)
> >
> > regards,
> > Armin
> >
> >
> > ----- Original Message -----
> > From: "Goncalo Luiz" <ge...@rnl.ist.utl.pt>
> > To: "OJB Users List" <oj...@db.apache.org>
> > Sent: Sunday, April 27, 2003 8:03 PM
> > Subject: the script
> >
> >
> > > The script I forgot in my last mail:
> > > #----------------------------
> > > # Table structure for ojb_dlist
> > > #----------------------------
> > > drop table if exists OJB_DLIST;
> > > create table OJB_DLIST (
> > >    ID int(11) not null default '0',
> > >    SIZE_ int(11),
> > >    primary key (ID))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for ojb_dlist_entries
> > > #----------------------------
> > > drop table if exists OJB_DLIST_ENTRIES;
> > > create table OJB_DLIST_ENTRIES (
> > >    ID int(11) not null default '0',
> > >    DLIST_ID int(11) not null default '0',
> > >    POSITION_ int(11),
> > >    OID_ longblob,
> > >    primary key (ID))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for ojb_dmap
> > > #----------------------------
> > > drop table if exists OJB_DMAP;
> > > create table OJB_DMAP (
> > >    ID int(11) not null default '0',
> > >    SIZE_ int(11),
> > >    primary key (ID))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for ojb_dmap_entries
> > > #----------------------------
> > > drop table if exists OJB_DMAP_ENTRIES;
> > > create table OJB_DMAP_ENTRIES (
> > >    ID int(11) not null default '0',
> > >    DMAP_ID int(11) not null default '0',
> > >    KEY_OID longblob,
> > >    VALUE_OID longblob,
> > >    primary key (ID))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for ojb_dset
> > > #----------------------------
> > > drop table if exists OJB_DSET;
> > > create table OJB_DSET (
> > >    ID int(11) not null default '0',
> > >    SIZE_ int(11),
> > >    primary key (ID))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for ojb_dset_entries
> > > #----------------------------
> > > drop table if exists OJB_DSET_ENTRIES;
> > > create table OJB_DSET_ENTRIES (
> > >    ID int(11) not null default '0',
> > >    DLIST_ID int(11) not null default '0',
> > >    POSITION_ int(11),
> > >    OID_ longblob,
> > >    primary key (ID))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for 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 int(11),
> > >    GRAB_SIZE int(11),
> > >    primary key (TABLENAME, FIELDNAME))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for ojb_lockentry
> > > #----------------------------
> > > drop table if exists OJB_LOCKENTRY;
> > > create table OJB_LOCKENTRY (
> > >    OID_ varchar(250) not null,
> > >    TX_ID varchar(50) not null,
> > >    TIMESTAMP_ decimal(10,0),
> > >    ISOLATIONLEVEL int(11),
> > >    LOCKTYPE int(11),
> > >    primary key (OID_, TX_ID))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for ojb_nrm
> > > #----------------------------
> > > drop table if exists OJB_NRM;
> > > create table OJB_NRM (
> > >    NAME varchar(250) not null,
> > >    OID_ longblob,
> > >    primary key (NAME))
> > >    type=InnoDB;
> > >
> > > #----------------------------
> > > # Table structure for ojb_seq
> > > #----------------------------
> > > drop table if exists OJB_SEQ;
> > > create table OJB_SEQ (
> > >    TABLENAME varchar(175) not null,
> > >    FIELDNAME varchar(70) not null,
> > >    LAST_NUM int(11),
> > >    primary key (TABLENAME, FIELDNAME))
> > >    type=InnoDB;
> > >
> > >
> > >
> > > Gonçalo D. Luiz (gedl@rnl.ist.utl.pt) | Tlm: 933 480 059
> > >
> > >
> > >
> >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail: ojb-user-help@db.apache.org
> > >
> > >
> > >
> >
> >
>
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>



Re: the script

Posted by Goncalo Luiz <ge...@rnl.ist.utl.pt>.
It works know. I've changed LONGBINARYVAR to BLOB.
I have two more questions:
1- Is BLOB enough or its better change it to longblob ?
2- Does this tables need to be transactional? If so, I need to add the
Type=InnoDB instruction.

Thank you very much,
Gonçalo D. Luiz (gedl@rnl.ist.utl.pt) | Tlm: 933 480 059
----- Original Message -----
From: "Armin Waibel" <ar...@code-au-lait.de>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Sunday, April 27, 2003 7:11 PM
Subject: Re: the script


> Try this one (maybe you have to do
> some modification for your mysql
> database)
>
> OJB internal tables
> (ojb_seq is completely removed):
>
> CREATE TABLE OJB_HL_SEQ(
> TABLENAME VARCHAR(175) NOT NULL,
> FIELDNAME VARCHAR(70) NOT NULL,
> MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,
> CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
>
> CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50)
> NOT NULL,TIMESTAMP_ TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE
> INTEGER,CONSTRAINT SYS_PK_OJB_LOCKENTRY PRIMARY KEY(OID_,TX_ID))
>
> CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_
> LONGVARBINARY)
> CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
>
> CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID
> INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
> CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
>
> CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID
> INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
> CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
>
> CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID
> INTEGER,KEY_OID LONGVARBINARY,VALUE_OID LONGVARBINARY)
>
> regards,
> Armin
>
>
> ----- Original Message -----
> From: "Goncalo Luiz" <ge...@rnl.ist.utl.pt>
> To: "OJB Users List" <oj...@db.apache.org>
> Sent: Sunday, April 27, 2003 8:03 PM
> Subject: the script
>
>
> > The script I forgot in my last mail:
> > #----------------------------
> > # Table structure for ojb_dlist
> > #----------------------------
> > drop table if exists OJB_DLIST;
> > create table OJB_DLIST (
> >    ID int(11) not null default '0',
> >    SIZE_ int(11),
> >    primary key (ID))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for ojb_dlist_entries
> > #----------------------------
> > drop table if exists OJB_DLIST_ENTRIES;
> > create table OJB_DLIST_ENTRIES (
> >    ID int(11) not null default '0',
> >    DLIST_ID int(11) not null default '0',
> >    POSITION_ int(11),
> >    OID_ longblob,
> >    primary key (ID))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for ojb_dmap
> > #----------------------------
> > drop table if exists OJB_DMAP;
> > create table OJB_DMAP (
> >    ID int(11) not null default '0',
> >    SIZE_ int(11),
> >    primary key (ID))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for ojb_dmap_entries
> > #----------------------------
> > drop table if exists OJB_DMAP_ENTRIES;
> > create table OJB_DMAP_ENTRIES (
> >    ID int(11) not null default '0',
> >    DMAP_ID int(11) not null default '0',
> >    KEY_OID longblob,
> >    VALUE_OID longblob,
> >    primary key (ID))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for ojb_dset
> > #----------------------------
> > drop table if exists OJB_DSET;
> > create table OJB_DSET (
> >    ID int(11) not null default '0',
> >    SIZE_ int(11),
> >    primary key (ID))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for ojb_dset_entries
> > #----------------------------
> > drop table if exists OJB_DSET_ENTRIES;
> > create table OJB_DSET_ENTRIES (
> >    ID int(11) not null default '0',
> >    DLIST_ID int(11) not null default '0',
> >    POSITION_ int(11),
> >    OID_ longblob,
> >    primary key (ID))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for 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 int(11),
> >    GRAB_SIZE int(11),
> >    primary key (TABLENAME, FIELDNAME))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for ojb_lockentry
> > #----------------------------
> > drop table if exists OJB_LOCKENTRY;
> > create table OJB_LOCKENTRY (
> >    OID_ varchar(250) not null,
> >    TX_ID varchar(50) not null,
> >    TIMESTAMP_ decimal(10,0),
> >    ISOLATIONLEVEL int(11),
> >    LOCKTYPE int(11),
> >    primary key (OID_, TX_ID))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for ojb_nrm
> > #----------------------------
> > drop table if exists OJB_NRM;
> > create table OJB_NRM (
> >    NAME varchar(250) not null,
> >    OID_ longblob,
> >    primary key (NAME))
> >    type=InnoDB;
> >
> > #----------------------------
> > # Table structure for ojb_seq
> > #----------------------------
> > drop table if exists OJB_SEQ;
> > create table OJB_SEQ (
> >    TABLENAME varchar(175) not null,
> >    FIELDNAME varchar(70) not null,
> >    LAST_NUM int(11),
> >    primary key (TABLENAME, FIELDNAME))
> >    type=InnoDB;
> >
> >
> >
> > Gonçalo D. Luiz (gedl@rnl.ist.utl.pt) | Tlm: 933 480 059
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>



Re: the script

Posted by Armin Waibel <ar...@code-au-lait.de>.
Try this one (maybe you have to do
some modification for your mysql
database)

OJB internal tables
(ojb_seq is completely removed):

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

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

CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_
LONGVARBINARY)
CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)

CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID
INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)

CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID
INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)

CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID
INTEGER,KEY_OID LONGVARBINARY,VALUE_OID LONGVARBINARY)

regards,
Armin


----- Original Message -----
From: "Goncalo Luiz" <ge...@rnl.ist.utl.pt>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Sunday, April 27, 2003 8:03 PM
Subject: the script


> The script I forgot in my last mail:
> #----------------------------
> # Table structure for ojb_dlist
> #----------------------------
> drop table if exists OJB_DLIST;
> create table OJB_DLIST (
>    ID int(11) not null default '0',
>    SIZE_ int(11),
>    primary key (ID))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for ojb_dlist_entries
> #----------------------------
> drop table if exists OJB_DLIST_ENTRIES;
> create table OJB_DLIST_ENTRIES (
>    ID int(11) not null default '0',
>    DLIST_ID int(11) not null default '0',
>    POSITION_ int(11),
>    OID_ longblob,
>    primary key (ID))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for ojb_dmap
> #----------------------------
> drop table if exists OJB_DMAP;
> create table OJB_DMAP (
>    ID int(11) not null default '0',
>    SIZE_ int(11),
>    primary key (ID))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for ojb_dmap_entries
> #----------------------------
> drop table if exists OJB_DMAP_ENTRIES;
> create table OJB_DMAP_ENTRIES (
>    ID int(11) not null default '0',
>    DMAP_ID int(11) not null default '0',
>    KEY_OID longblob,
>    VALUE_OID longblob,
>    primary key (ID))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for ojb_dset
> #----------------------------
> drop table if exists OJB_DSET;
> create table OJB_DSET (
>    ID int(11) not null default '0',
>    SIZE_ int(11),
>    primary key (ID))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for ojb_dset_entries
> #----------------------------
> drop table if exists OJB_DSET_ENTRIES;
> create table OJB_DSET_ENTRIES (
>    ID int(11) not null default '0',
>    DLIST_ID int(11) not null default '0',
>    POSITION_ int(11),
>    OID_ longblob,
>    primary key (ID))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for 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 int(11),
>    GRAB_SIZE int(11),
>    primary key (TABLENAME, FIELDNAME))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for ojb_lockentry
> #----------------------------
> drop table if exists OJB_LOCKENTRY;
> create table OJB_LOCKENTRY (
>    OID_ varchar(250) not null,
>    TX_ID varchar(50) not null,
>    TIMESTAMP_ decimal(10,0),
>    ISOLATIONLEVEL int(11),
>    LOCKTYPE int(11),
>    primary key (OID_, TX_ID))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for ojb_nrm
> #----------------------------
> drop table if exists OJB_NRM;
> create table OJB_NRM (
>    NAME varchar(250) not null,
>    OID_ longblob,
>    primary key (NAME))
>    type=InnoDB;
>
> #----------------------------
> # Table structure for ojb_seq
> #----------------------------
> drop table if exists OJB_SEQ;
> create table OJB_SEQ (
>    TABLENAME varchar(175) not null,
>    FIELDNAME varchar(70) not null,
>    LAST_NUM int(11),
>    primary key (TABLENAME, FIELDNAME))
>    type=InnoDB;
>
>
>
> Gonçalo D. Luiz (gedl@rnl.ist.utl.pt) | Tlm: 933 480 059
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>