3.2.4 Modeling Preferences

This section provides configuration options that affect the
Modeling functionality in MySQL Workbench.

Preferences: Modeling: Main

Figure 3.11 Preferences: Modeling

EER Modeler

Automatically reopen previous model at
start: Check this if you want the model on which
you previously worked to be automatically reopened when you
start MySQL Workbench.

Force use of software based rendering
for EER diagrams: MySQL Workbench will use OpenGL for
rendering when available. However, due to faulty drivers,
problems do occasionally occur. These issues can be resolved
by selecting the software rendering option here.

Model undo history size:
You can limit the size of the undo history here. Set this
value to 0 to have an unlimited undo history.

Auto-save model interval:
An open model that has not been saved will automatically be
saved after this period. On loading a model file,
MySQL Workbench will notify the user if the file was not
previously saved correctly, due to a crash or power failure.
MySQL Workbench can then attempt to recover the last auto-saved
version. For automatic recovery to be available for a new
file, it will have to have been saved at least once by the
user.

Preferences: Modeling: Defaults

Sets default values for modeling object names.

Figure 3.12 Preferences: Modeling: Defaults

The following tables show the object names and their default
values.

Column Defaults

Object Name

Default Value

PK Column Name

id%table%

PK Column Type

INT

Column Name

%table%col

Column Type

VARCHAR(45)

Foreign Key/Relationship
Defaults

Object Name

Default Value

FK Name

fk%stable_%dtable%

Column Name

%table%_%column%

ON UPDATE

NO ACTION

ON DELETE

NO ACTION

Associative Table Name

%stable%_has_%dtable%

Preferences: Modeling: MySQL

This enables you to set model related options specific to your
MySQL version.

Figure 3.13 Preferences: Modeling: MySQL

Model

Default Target MySQL Version: A limited
subset of validation procedures and table editor options are
affected by this MySQL version number.

Supported MySQL Server 5.6 features include fraction seconds
support for TIME,
DATETIME, and
TIMESTAMP, automatic initialization and
updates for TIMESTAMP and
DATETIME (for example, setting them to
CURRENT_TIMESTAMP), and FULLTEXT index
types with the InnoDB engine.

Model Table Defaults

Default Storage Engine: Tables created
in MySQL Workbench will be defined using this default storage
engine.

Forward Engineering and
Synchronization

SQL_MODE to be used in generated
scripts: Defaults to
"TRADITIONAL,ALLOW_INVALID_DATES", this defines the
SQL_MODE used by Forward Engineering and
Synchronization.

These are the available colors used while modeling, and they are
divided into two sections. First, the colors used when creating
tables and views. The second section are available colors for
items such as layers and notes.