Bug #36361 default flags annoying: allow primary key flag definition in options
Submitted: 27 Apr 2008 4:41 Modified: 4 Dec 2008 16:28
Reporter: walter stanish Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.0.19 OS:Any (XPSP2)
Assigned to: CPU Architecture:Any
Tags: flags, interface, key, Options, primary key

[27 Apr 2008 4:41] walter stanish
the default setting of an INT column with no flags set is annoying.

i usually need int unsigned, with auto_increment.

please expand the model type options to enable setting custom default type/flags.

How to repeat:
want default 'unsigned', 'auto_increment'
no default option

Suggested fix:
add default 'types' options in model type options dialog: unsigned, auto_increment, etc.
[30 May 2008 4:15] Alfredo Kojima
You can create a user defined type (such as UINT) which is defined as INT with UNSIGNED any and other flags you want. Then just use UINT in your PKs.
[4 Dec 2008 16:28] Susanne Ebrecht
Many thanks to write a feature request.

According to the given workaround we won't fix this bug.