missing default value for "date" field of "property_device_hist" table

Context:

Brand new Tango installation.

Running Tango DB from Conda package, using mysql version: 8.0.25 from Conda too.

create_db.sql script from Conda package was used to initialize the tables.

Problem:

Starting some ESRF vacuum monitoring servers, error about missing value for field date in table property_device_hist

Solution (when Tango DB schema has already been created):

ALTER TABLE property_device_hist MODIFY date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

Discussion:

I guess the creation script has to be modified to have the current timestamp by default. Maybe other similar fields should have a default value too ?