Re: EOModeler 5.3 (Xcode2.2) many-to-many SQL generation bug
Re: EOModeler 5.3 (Xcode2.2) many-to-many SQL generation bug
- Subject: Re: EOModeler 5.3 (Xcode2.2) many-to-many SQL generation bug
- From: David LeBer <email@hidden>
- Date: Wed, 16 Nov 2005 11:18:00 -0500
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden