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
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 @@
-- 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");
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 @@
`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',
