Set MySQL Options

To make use of Foreign Keys in MySQL, you must declare the Database Table type as InnoDB.

Declare the Table type as InnoDB

Step

Action

See also

1

Add a Tagged Value named Type to the Table.

 

Assign a Tagged Value to an Item

 

2

Set the Value field to InnoDB.

 

 

 

When you generate DDL for this Table, the Table type is included in the SQL script.

To allow for later versions of MySQL, additional Table options that can be added in the same way include:

Tag

Value (Example)

ENGINE

InnoDB

 

CHARACTER SET

latin1

 

CHARSET

latin1

 

COLLATE

latin1_german2_ci