Use safer default TIMESTAMP for MySQL.
This avoids compatibility issues with differing versions of MySQL.
Using 24 hours after the minimum timestamp value allows for any timezone adjustment that MySQL would do to get a UTC value before storing. The timezone suffix is not supported by all current MySQL versions/derivatives.
Fixes
@@ -248,9 +248,9 @@ CREATE TABLE cluster_membership
rpc_address VARCHAR(15) NOT NULL,
rpc_port SMALLINT NOT NULL,
role TINYINT NOT NULL,
- session_start TIMESTAMP DEFAULT '1970-01-01 00:00:01+00:00',
- last_heartbeat TIMESTAMP DEFAULT '1970-01-01 00:00:01+00:00',
- record_expiry TIMESTAMP DEFAULT '1970-01-01 00:00:01+00:00',
+ session_start TIMESTAMP DEFAULT '1970-01-02 00:00:01',
+ last_heartbeat TIMESTAMP DEFAULT '1970-01-02 00:00:01',
+ record_expiry TIMESTAMP DEFAULT '1970-01-02 00:00:01',
INDEX (role, host_id),
INDEX (role, last_heartbeat),
INDEX (rpc_address, role),
