Bug #36863 TIMESTAMP column missing options
Submitted: 21 May 2008 21:44 Modified: 6 Feb 2013 3:06
Reporter: Jeremy Tinley Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.0.21 OS:Windows (XP Pro SP2)
Assigned to: CPU Architecture:Any
Tags: CHECKED, timestamp

[21 May 2008 21:44] Jeremy Tinley 
Description:
When selecting a TIMESTAMP column, there are additional options which should be definable in the application. Specifically:

colname TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

See: http://dev.mysql.com/doc/refman/5.0/en/timestamp.html  for more detail.  

How to repeat:
Open the Workbench app and look at the options for TIMESTAMP

Suggested fix:
Add support for variations of this column definition.
Generate proper SQL for this column definition.
[23 May 2008 4:43] Valeriy Kravchuk 
Thank you for a reasonable feature request. Note though that can just type "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" in Default field for the column.
[25 Jun 2010 9:21] Mike Lischke 
TIMESTAMP has a few more conditions attached as what can be covered by the default value, so we should add a better handling for this type.
[6 Feb 2013 3:06] Alfredo Kojima 
Closing old bug report, this was already implemented.