Adding Foreign Key Constraints with Mac

[dbexternal]

Greetings,

I'm currently evaluating DB Solo, and running into issues with foreign
key constraints. I've added, both initially when I created the table
and after using the add constraint option, and don't get any sort of
error. But, they don't show up in the Constraints or References tabs
- guess they're not really being added.

I'm using a Mac, DB Solo v3.5 with MySQL using the mysql-connector-
java-5.0.6 JDBC driver.

Any ideas?

Thanks!

[DB Solo]

What is the table type of your table? I think only InnoDB tables
actually do anything with foreign keys.

Marko

[dbexternal]

Thanks Marko, that did it. Is there anyway of creating the table as
InnoDB? I could only figure out how to alter the engine type after
the fact.

On Jan 2, 5:07 pm, "DB Solo" <mhant...@gmail.com> wrote:
> What is the table type of your table? I think only InnoDB tables
> actually do anything with foreign keys.
>
> Marko
>

[DB Solo]

Unfortunately this is not yet supported, but will probably be
supported soon. Like you said, you can only change the type after
you've created the table.

marko