Post by Manjuka SoysaI am using the latest (CVS) version of middlegen, the
latest mysql server (3.23.49), and mm mysql 2.0.11.
Here is the sql to create the tables - the foreign key
is clearly defined in the wf_task table, process_id
column. However, middlegen does not detect the link.
create table wf_process (
id integer primary key AUTO_INCREMENT,
name varchar(32) not null,
label varchar(50) not null,
created_by varchar(32) not null,
status integer);
create table wf_task (
id integer primary key AUTO_INCREMENT,
process_id integer not null references wf_process(id),
name varchar(32) not null,
booked_by varchar(32),
status integer
);
Post by Steve KnightYou must have Foreign keys defined for your
tables...see MySQL docs or
InnoDB docs for example syntax.
You must be using a fairly recent version of the
MM.MySQL driver...I am
using 2.0.11 with no problems.
Steve
----- Original Message -----
Sent: Tuesday, April 09, 2002 10:03 PM
Subject: [Middlegen-user] Generating relationships
Post by Manjuka SoysaHi,
I just tried using middlegen with MySql.
Everythings
Post by Manjuka Soysasmooth with individual tables.
However, I thought middle gen detects foreign key
relationships automatically, and generates CMRs.
That
Post by Manjuka Soysadid not happen.
Is there any way to give a hint about foreign keys
in
Post by Manjuka Soysathe build.xml, under the <table> element? I could
not
Post by Manjuka Soysafind any documentation.
thanks,
manjuka
http://www.sold.com.au - SOLD.com.au Auctions
- 1,000s of Bargains!
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user
Post by Steve Knight_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user
http://www.sold.com.au - SOLD.com.au Auctions
- 1,000s of Bargains!
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user