Probably the MySQL Migration Helper code is not done yet in Wonder migrations to support this MySQL indexes. You could just do it using SQL on the command line.
BTW, if using MySQL 5.0.XX, I would recommend latest 5.0.XX connector.
On Jan 15, 2009, at 7:27 PM, Jerome Chan wrote: Is anyone getting SQL errors trying to generate indexes with MySQL? How do I correct this?
I get the following code when I choose generate SQL.
CREATE INDEX name_idx FOR Account (name); CREATE INDEX fromId_idx FOR Follow (fromId);
but according to the MySQL docs its suppose to be CREATE [ONLINE|OFFLINE] [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name
[index_type ]
ON tbl_name (index_col_name ,...)
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
|