Bug #36557 alias for column definition TS O_U_C_TS NOT NULL DEFAULT C_TS
Submitted: 7 May 2008 10:15 Modified: 7 May 2008 11:25
Reporter: Sebastian Mendel (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[7 May 2008 10:15] Sebastian Mendel
Description:
it would be nice to have an alias for

TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

like SERIAL

f. e. ALTERATIONTIME

How to repeat:
ALTER TABLE ADD `ts` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

Suggested fix:
ALTER TABLE ADD `ts` ALTERATIONTIME
[7 May 2008 11:25] MySQL Verification Team
Thank you for the bug report.