VCL-1082 - monitor_vcld.pl throws incorrect lastcheckin time exception after Daylight Savings Time Roles Back
vcl.sql: changed definition of managementnode.lastcheckin from datetime to timestamp update-vcl.sql: added alter table statement to change managementnode.lastcheckin from datetime to timestamp Project: http://git-wip-us.apache.org/repos/asf/vcl/repo Commit: http://git-wip-us.apache.org/repos/asf/vcl/commit/c212dfd9 Tree: http://git-wip-us.apache.org/repos/asf/vcl/tree/c212dfd9 Diff: http://git-wip-us.apache.org/repos/asf/vcl/diff/c212dfd9 Branch: refs/heads/VCL-1082_lastcheckin_db_epoch Commit: c212dfd9c30b906e7b61afadce8c9e13639a2d66 Parents: 5743cf3 Author: Josh Thompson <[email protected]> Authored: Tue Dec 11 17:52:09 2018 -0500 Committer: Josh Thompson <[email protected]> Committed: Tue Dec 11 17:52:09 2018 -0500 ---------------------------------------------------------------------- mysql/update-vcl.sql | 1 + mysql/vcl.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/vcl/blob/c212dfd9/mysql/update-vcl.sql ---------------------------------------------------------------------- diff --git a/mysql/update-vcl.sql b/mysql/update-vcl.sql index 03ac8a0..48714f5 100644 --- a/mysql/update-vcl.sql +++ b/mysql/update-vcl.sql @@ -1114,6 +1114,7 @@ CALL AddIndexIfNotExists('loginlog', 'code'); -- Table structure change for table `managementnode` -- +ALTER TABLE `managementnode` CHANGE `lastcheckin` `lastcheckin` timestamp default NULL; CALL AddColumnIfNotExists('managementnode', 'publicIPconfiguration', "enum('dynamicDHCP','manualDHCP','static') NOT NULL default 'dynamicDHCP'"); CALL AddColumnIfNotExists('managementnode', 'publicSubnetMask', "varchar(56) default NULL"); CALL AddColumnIfNotExists('managementnode', 'publicDefaultGateway', "varchar(56) default NULL"); http://git-wip-us.apache.org/repos/asf/vcl/blob/c212dfd9/mysql/vcl.sql ---------------------------------------------------------------------- diff --git a/mysql/vcl.sql b/mysql/vcl.sql index 720fbf8..7c6a9b8 100644 --- a/mysql/vcl.sql +++ b/mysql/vcl.sql @@ -682,7 +682,7 @@ CREATE TABLE IF NOT EXISTS `managementnode` ( `hostname` varchar(50) NOT NULL default '', `ownerid` mediumint(8) unsigned NOT NULL default '1', `stateid` tinyint(3) unsigned NOT NULL default '0', - `lastcheckin` datetime default NULL, + `lastcheckin` timestamp default NULL, `checkininterval` tinyint(3) unsigned NOT NULL default '12', `installpath` varchar(100) NOT NULL default '/install', `imagelibenable` tinyint(1) unsigned NOT NULL default '0',
