ON UPDATE current_timestamp loss on DDL changes

I have numerous tables where the "ON UPDATE " value is set to "current_timestamp", providing row change dates.

When I manipulate DDL using DataGrip, these column settings are lost unless I remember they are there and I manually enter them into the script window prior to column update.

Will the application be made aware of these settings and persist them (even if the UI doesn't allow for addition or amendment of them)?

 

Please advise-

1
3 comments

What database do you use? 

0

This is an issue when working with MySQL databases.  

Ticket created: DBE-5320

0

Ok, thanks, let's continue there.

0

Please sign in to leave a comment.