Bug #57569 Add handling of flags such as UNSIGNED to the Model preferences
Submitted: 19 Oct 2010 13:03 Modified: 30 Jun 2011 9:28
Reporter: Craig Fowler Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.2.28 OS:Any
Assigned to: CPU Architecture:Any
Tags: DEFAULT, model, preferences

[19 Oct 2010 13:03] Craig Fowler
Description:
Currently the Model preferences which can be found globally at:

Edit » Preferences » Model

... and per-model at:

Model » Model Options

... do not permit the addition of flags such as UNSIGNED or AUTO_INCREMENT (there is even some tooltip text to say as much).

I would like to request the addition of support for flags here please.  I am frequently forgetting to manually tick Unsigned and Auto-increment on new INT pKey columns as I create new tables.  It would be great if I could set them as a default.

How to repeat:
N/A - feature request

Suggested fix:
This could work by allowing the flags to be typed directly into the text box (and parsing the user input) or alternatively a multi-select list-box control could be presented alongside the "data type" text field, offering the possible flags to choose from.

The listbox would probably alleviate the problems with parsing and spelling mistakes etc.  Since the OSS edition doesn't provide much in the way of validation (that's a perk of the SE) then I don't think it would matter if WB doesn't validate which options are chosen against the chosen data-type (EG: AUTO_INCREMENT wouldn't be valid for VARCHAR columns) but that's something that I think users could live with.
[19 Oct 2010 14:39] Valeriy Kravchuk
Thank you for the feature request.
[30 Jun 2011 9:28] Jon Stephens
Duplicate of BUG#55487.