The Editors
section is used to configure options
specific to the different editors available within the MySQL GUI
Suite. At the time of writing this is limited to the
MySQL Table Editor.
Currently, configuring editors is only available on the Windows platform.
Show SQL command before applying changes
:
Toggles whether the MySQL Table Editor will show you the
CREATE TABLE
or ALTER
TABLE
statement it is about to execute for
confirmation when you click Apply
Changes.
All columns Not Null per default
: Determines
whether the MySQL Table Editor will designate columns as being
NOT NULL
by default when creating new
columns.
All integer columns unsigned per default
:
Sets whether integer columns are declared
UNSIGNED
by default when creating new
columns.
Default storage engine
: Sets the storage
engine to be assigned to newly created tables. This value is
independent of the default storage engine of the MySQL server.
PK Naming
: Dictates the format that should be
used to name PRIMARY KEY
columns that are
automatically generated. The
%tablename%
portion will be replaced
with the name of the appropriate table.
Index Naming
: Sets the name automatically
generated for new indexes. The %nr%
string will be replaced with an automatically incrementing
number.
FK Naming
: Configures the name used when
creating new foreign keys.
PK Datatype
: The datatype used when creating
a PRIMARY KEY
column.
Def. data type
The default datatype assigned
to all new columns that are not part of a PRIMARY
KEY
.