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.
