Once you add a index in EntityModeler (Entity Modeler/WOLips 3.4.5693) this
is what is generated:

CREATE INDEX stateCode_idx *FOR* State (stateCode);

But the correct SQL for MySQL (5.1) is:

CREATE INDEX stateCode_idx1 *ON* State (stateCode);

After this manual correction, the index gets created fine.
BTW, I didn't see any index creation code in migrations.

--JSt

 http://dev.mysql.com/doc/refman/5.0/en/create-index.html
 _______________________________________________
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