This tab helps you to set the parameters, that will be applied as defaults for the newly created tables and generated SQL scripts.
To open this dialog window, please, select Diagram | Diagram Properties from the ribbon-menu, or click on the Properties menu item in diagram's popup menu. Then switch to the Default Database Options tab.
Default Table Type
Use this drop-down list to select MySQL table type from the MyISAM, InnoDB, Falcon etc. This option will be applied as a default table type for the newly created tables.
Default datatype
Use this drop-down list to select the data type from INT, VARCHAR, DECIMAL etc. This option will be applied as a default data type for the newly created columns.
Automatically create indexes for FK columns
Check this option on if you want Database Designer for MySQL to create indexes on columns that will be foreign keys. Starting from MySQL 4.1 indexes for foreign key columns are automatically created by the server, so there is no standard need to create them manually.
SQL Delimiter
This option sets the delimiter that will be used on SQL script generation to separate SQL statements. Default MySQL delimiter symbol is ";". We strongly recommend do not change this property.
Quoted Character
This option sets the character that will be used on SQL script generation to quote table column names and values. Default MySQL quoted symbol is "`" (back-quote symbol). We strongly recommend do not change this property.
Enclose Names with Quoted character
This option forces quoting of the diagram objects names by a quote character, i.e. it makes `Column` and `Table` instead of Column and Table in SQL script.
Trim stored procedure/function, event body strings before generation
Set this option if you want to trim trailing and tailing white-spaces from stored routine or event bodies before generation SQL script.
See also:
Diagram: "General" tab | "Pages" tab | "Preview" tab | "Notes" tab | "Statistics" tab