MySQL Bugs: #36557: alias for column definition TS O_U_C_TS NOT NULL DEFAULT C

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

Thank you for the bug report.