TIMESTAMP column in protector_log table
List posts in the topic
TIMESTAMP column in protector_log table
msg# 1
Dave_L
From: Virginia, USA
Posts: 35
[Feature change request]
The TIMESTAMP column in the protector_log table is causing some issues with compatibility across different MySQL versions, when using mysqldump to export databases from one version to another.
Since rows are only inserted into that table, and never updated, I don't see any real benefit to using the TIMESTAMP column type.
I suggest changing that column type to DATETIME, and manually setting it when a row is inserted in that table:
INSERT INTO `protector_log` ... `timestamp`=NOW()
Votes:1
Average:10.00
Posts tree