#807 Create table: CURRENT_TIMESTAMP not possible for timestamp fields

[Anonymous]

Originally created by: dhahler@gmail.com

The "Create table..." dialog does not allow setting the default to
CURRENT_TIMESTAMP for a timestamp field.

The "Default Value" field is a text field here and HeidiSQL appears to
automatically wrap the value given here in quotes for the CREATE TABLE
statement.
This is what HeidiSQL executes when using "CURRENT_TIMESTAMP" for the
default value:
CREATE TABLE [...] `timestamp` TIMESTAMP DEFAULT 'CURRENT_TIMESTAMP' [...]

It seems like the best fix would be to use the same logic/fields like with
"Update Column", where you have a combination of dropdown ("No default
value", "NULL", "CURRENT_TIMESTAMP", "Custom string ...") and input field.

Version currently used (if relevant)?
HeidiSQL revision: 1866

[Anonymous]

Originally posted by: rosenfie...@gmail.com

Related to issue #436.

Status: Accepted

[Anonymous]

Originally posted by: a...@anse.de

Fixed by the recently implemented new table editor

Status: Fixed