timestamp set to current_timestamp CANNOT BE UN-DONE
Database management in a single PHP file
Brought to you by:
jakubvrana
Create a table with this
CREATE TABLE bug
(
id
int NOT NULL AUTO_INCREMENT PRIMARY KEY,
currentTimeStampBug
timestamp NULL ON UPDATE CURRENT_TIMESTAMP
);
And then, using the UI, try to REMOVE the "ON UPDATE CURRENT_TIMESTAMP".
It will ALWAYS be set, regardless of what you click / try to do.
If the field is 'datetime' though, all seems working fine
I can not reproduce this problem with MariaDB 11.5.2 and latest Adminer.
It's the default behavior of this type.