Customization: how to add new Table Type option to MySQL models
Hi,
today you will find out how to add new Table Type (Engine) option to MySQL models in Toad Data Modeler. By default, the following Table Types are available:
- Default
- MEMORY
- MyISAM
- MERGE
- BDB
- InnoDB
- NDBCluster
- ARCHIVE
- CSV
- FEDERATED
What if we want to use Partner-Developed storage engines, e.g. BrightHouse? Is it possible to customize Toad Data Modeler and use this engine? Of course 
To add the BrightHouse option to MySQL 5.1 model, do the following:
1. Turn on the Expert mode. Click Settings | Options and in section General, check the Expert Mode checkbox.
2. Open a model for MySQL 5.1. Add a new entity to the model and edit the entity. Then right click the Entity Properties form and select the Customize Form item.
3. The form will re-load in a customizable mode. Click the Table Type combo box.
4. Double click the (IDispatch) item in Component Inspector to open list of values and add there the BRIGHTHOUSE option.
5. Close the Edit mode by clicking the red cross icon on top right corner of the largest form (standard icon for closing a dialog).
6. Save the changes. Right click the form immediately after closing the Edit mode and select Save Form option.
7. Now you can edit any entity and choose the BRIGHTHOUSE option from the Table Type combo box.
8. See SQL preview:
That’s all.
Have a great day,
Vaclav