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
>
>
>