MySQL Workbench Manual  /  ...  /  Modeling Preferences

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

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

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

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.

Preferences: Modeling: Diagram

Figure 3.14 Preferences: Modeling: Diagram

Preferences: Modeling: Diagram

All Objects

  • [ ] Expand New Objects: Enabled by default.

  • [ ] Propagate Object Color Changes to All Diagrams: Enabled by default.

Tables

  • [ ] Show Column Types: Enabled by default.

  • [ ] Show Schema Name:

  • Max. Length of ENUMs and SETs to Display: [20]

  • [ ] Show Column Flags:

  • Max. Number of Columns to Display: [30] Larger tables will be truncated.

Routines

  • Trim Routine Names Longer Than: [20] characters.

Relationships / Connections

  • [ ] Draw Line Crossings (slow in large diagrams):

  • [ ] Hide Captions: Enabled by default.

  • [ ] Center Captions Over Line:

Preferences: Modeling: Appearance

Use this tab to set the available colors for the objects that appear on an EER diagram canvas. You can also add colors if you wish.

For related information, see Section 3.1, “User Accessibility Options”.

Figure 3.15 Preferences: Modeling: Appearance

Preferences: Modeling: Appearance

Color Presets

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.

Fonts

These define the fonts and font sizes used while modeling.


User Comments
Sign Up Login You must be logged in to post a comment.