On 16-Nov-05, at 11:09 AM, Dev WO wrote:

I filled the column/table name.
To make sure, I tried on a previous EOModel that worked, and same error, so bugreport tonight;)

But now I feel stupid, because I don't know how to generate my table in MySQL:( I was able to add the first primary key, but it seems I cannot add the second one (index)... Could someone copy/paste something here so I have a sample of the command line I have to enter to generate the join table?

Oops I read your post wrong, generate SQL, not generate Java. Got it.

Anyway, I tested generate SQL on a simple model and that worked too.

For generating the join table, this is what EOModeler would generate:

CREATE TABLE r_join (c_id INT NOT NULL, c_id1 INT NOT NULL);

ALTER TABLE r_join ADD PRIMARY KEY (c_id, c_id1);

Alternately you could use something like CocoaMySQL.

--
;david

--
David LeBer
Codeferous Software
'co-defer-ous' adj. producing or containing code
site:   http://www.codeferous.com
blog: http://david.codeferous.com




Attachment: smime.p7s
Description: S/MIME cryptographic signature

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to