Entity Modeler SQL Generation - differences between WO 5.3 and 5.4
Entity Modeler SQL Generation - differences between WO 5.3 and 5.4
- Subject: Entity Modeler SQL Generation - differences between WO 5.3 and 5.4
- From: "J Stephanos" <email@hidden>
- Date: Tue, 15 Apr 2008 14:09:16 -0400
When I use Mike's WO53 -> WO54 script (See
http://lists.apple.com/archives/Webobjects-dev/2007/Oct/msg00357.html)
to switch between 5.3 and 5.4, here are the differences seen in
Entity Modeler when used to Generate SQL:
MySQL 5.0.51a
Eclipse 3.3.1.1
WOLips 5085
with WO 5.3
-------------------
CREATE TABLE Address ( address1 varchar(40), address2 varchar(40),
city varchar(30), zip char(10), identifier bigint NOT NULL,
retailStoreID bigint NOT NULL, state varchar(30) );
ALTER TABLE Address ADD PRIMARY KEY (identifier);
with WO 5.4
-------------------
CREATE TABLE Address ("address1" varchar(40), "address2" varchar(40),
"city" varchar(30), "zip" varchar(10), "identifier" bigint NOT NULL,
"retailStoreID" bigint NOT NULL, "state" varchar(30) );
ALTER TABLE Address ADD PRIMARY KEY (identifier);
ALTER TABLE Address ADD CONSTRAINT Address_retailStore_FK FOREIGN KEY
(retailStoreID) REFERENCES RetailStore (identifier);
5.4 adds quotes - fails to create the table in MySQL. Adds all the
FK constraints.
5.3 does not generate FK constraint.
Is there a workaround to generate sql correctly with 5.4. Of course,
I could generate with 5.4 and remove quotes - is this advisable?
TIA.
--jst
_______________________________________________
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