Bug #56530 Common data types like url, email, username, password using regex validation
Submitted: 3 Sep 2010 9:31 Modified: 16 Sep 2010 12:02
Reporter: Mutlu Tevfik Kocak Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5 OS:Any
Assigned to: CPU Architecture:Any
Tags: common, data, types

[3 Sep 2010 9:31] Mutlu Tevfik Kocak 
Description:
Would be very time saving if common data types like mail, url, username, password were defined by default on the database.

How to repeat:
Now we have to define generally Varchar 255 for fatal fields like username, url, email, password. And after we have to define other regex rules or javascript form validation. Any fix would decrease the need of ajax form validation tools that slows online applications overall performance.

Suggested fix:
Any rapid data type, with customizable regex validation, would help developers at rapid prototyping.

Thanks,
Mutlu Tevfik Kocak
mtkocak@gmail.com
[3 Sep 2010 9:33] Mutlu Tevfik Kocak 
Forgot to provide version.
[16 Sep 2010 12:02] Susanne Ebrecht 
Many thanks for writing a feature request.

Your feature request is very individual.

What you could do when you want pre-defined data types is to use MySQL Workbench.

There you can pre-define data types.