I need to make it possible to change the publication date of a record, but I encountered such a problem that when editing a record in MIGXdb using CMP, the field with the date of publication is not updated. In the tab for this field, input TV type is specified as date. In the scheme, this field is described as follows:
<field key = "publishedon" dbtype = "int" precision = "20" phptype = "timestamp" null = "false" default = "0" />. Similar to the field of the same name in the site_content table.
There was a suspicion that it did not work because of dbtype = “int” in the scheme, but changing it to datetime and changing
default = "0" to
default = "" did not help, it just stopped showing the date in the grid in CMP.
I also have an editedon field with similar attributes in the schema, which, unlike publishedon, changes when a record in MIGXdb changes.
Tell me, please, what could be the problem?