Repository: vcl Updated Branches: refs/heads/VCL-1082_lastcheckin_db_epoch c212dfd9c -> dade55fb2
VCL-1082 - monitor_vcld.pl throws incorrect lastcheckin time exception after Daylight Savings Time Roles Back vcl.sql: changed definition of managementnode.lastcheckin to have a default value of 0 instead of NULL update-vcl.sql: modified alter table statement for managementnode.lastcheckin to have default value of 0 instead of NULL Project: http://git-wip-us.apache.org/repos/asf/vcl/repo Commit: http://git-wip-us.apache.org/repos/asf/vcl/commit/dade55fb Tree: http://git-wip-us.apache.org/repos/asf/vcl/tree/dade55fb Diff: http://git-wip-us.apache.org/repos/asf/vcl/diff/dade55fb Branch: refs/heads/VCL-1082_lastcheckin_db_epoch Commit: dade55fb2d1908c33c6effe0e48e6c5f03776f14 Parents: c212dfd Author: Josh Thompson <[email protected]> Authored: Tue Dec 11 17:57:04 2018 -0500 Committer: Josh Thompson <[email protected]> Committed: Tue Dec 11 17:57:04 2018 -0500 ---------------------------------------------------------------------- mysql/update-vcl.sql | 2 +- mysql/vcl.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/vcl/blob/dade55fb/mysql/update-vcl.sql ---------------------------------------------------------------------- diff --git a/mysql/update-vcl.sql b/mysql/update-vcl.sql index 48714f5..1dea030 100644 --- a/mysql/update-vcl.sql +++ b/mysql/update-vcl.sql @@ -1114,7 +1114,7 @@ CALL AddIndexIfNotExists('loginlog', 'code'); -- Table structure change for table `managementnode` -- -ALTER TABLE `managementnode` CHANGE `lastcheckin` `lastcheckin` timestamp default NULL; +ALTER TABLE `managementnode` CHANGE `lastcheckin` `lastcheckin` timestamp default 0; 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/dade55fb/mysql/vcl.sql ---------------------------------------------------------------------- diff --git a/mysql/vcl.sql b/mysql/vcl.sql index 7c6a9b8..00a4418 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` timestamp default NULL, + `lastcheckin` timestamp default 0, `checkininterval` tinyint(3) unsigned NOT NULL default '12', `installpath` varchar(100) NOT NULL default '/install', `imagelibenable` tinyint(1) unsigned NOT NULL default '0',
