Description:
When trying to add a column of type TIMESTAMP, the sql that is generated for the DEFAULT value is incorrect
How to repeat:
Create a table, then add a column of type TIMESTAMP. In the Default Value field, enter CURRENT_TIMESTAMP. The SQL generated is
ALTER TABLE `WFG-UM`.`Patron_Info` MODIFY COLUMN `timestamp` TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT 'Date and Time that this information was gathered';
When executed, the application throws
MySQL Error Number 1067
Invalid default value for 'timestamp'.
Additionally, after making the alteration manually, the default value is shown correctly, but the NOTNULL column is unchecked, when in reality the column is not checked
Suggested fix:
Remove the single quotes from the default value when generating timestamp default values that are based on functions.
Example that seems to work fine:
ALTER TABLE `WFG-UM`.`Patron_Info` MODIFY COLUMN `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and Time that this information was gathered';
