Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Set MySQL Options
To make use of foreign keys in MySQL, you must declare the table type as InnoDB.
How to
To declare the table type as InnoDB
Step |
Action |
See also |
|---|---|---|
1 |
Add a Tagged Value named Type to the table.
|
|
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 manner include:
Tag |
Value (Example) |
|---|---|
ENGINE |
InnoDB
|
CHARACTER SET |
latin1
|
CHARSET |
latin1
|
COLLATE |
latin1_german2_ci
|
The material ("material" includes all pages, documents and on-line graphics) on this web site is protected by copyright law. (C) 1998-2014 Sparx Systems Pty Ltd.
