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.
Show SQL command before applying changes
toggles whether the MySQL Table Editor will show you the
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.
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
is the datatype used when
creating a PRIMARY KEY
column.
Def. Datatype
is the default datatype
assigned to all new columns that are not part of a
PRIMARY KEY
.