Bug #102452 FR Change default behaviour for PK creation
Submitted: 2 Feb 15:50 Modified: 21 Oct 4:22
Reporter: John King Email Updates:
Status: Analyzing Impact on me:
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:8.0.23 OS:Any (Microsoft Windows 10 Pro)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[2 Feb 15:50] John King
In the designer the default first column is a primary key. The first field is create automatically, withou user intervention, with PK (primary key index) and NN (NOT NULL) attributes. In addition the configuration allows to change the default column name pattern and the default type (INT). 

It would be helpful to also allow the default to
1) Allow creation of INSIGNED INT or make this the default (just like PK and NN)
2) Create the column as AUTO_INCREMENT (Just like PK and NN)

How to repeat:
These could be a fixed default (just like the key creation) or an optional value. But I can see no detrimental effects of creating the PK as UNISIGNED rather as SIGNED value. Typically the PK of a table is auto increment. The combination of default AI and UNSIGNEDness allows for the widest key space.