   `te_node_address` VARCHAR(17) NOT NULL DEFAULT '' ,
   `id_so` INT(10) UNSIGNED NOT NULL DEFAULT '0' ,
   `id_software_inventariado` INT(10) UNSIGNED NOT NULL DEFAULT '0' ,
-  `dt_hr_inclusao` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
-  `dt_hr_ult_coleta` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
+  `dt_hr_inclusao` DATETIME NOT NULL ,
+  `dt_hr_ult_coleta` DATETIME NOT NULL ,
   PRIMARY KEY (`te_node_address`, `id_so`, `id_software_inventariado`, `dt_hr_inclusao`) )
 ENGINE = InnoDB
 DEFAULT CHARACTER SET = latin1;

-- Table `log`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `log` (
  `dt_acao` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  `cs_acao` VARCHAR(20) NOT NULL DEFAULT '' ,
  `nm_script` VARCHAR(255) NOT NULL DEFAULT '' ,
  `nm_tabela` VARCHAR(255) NOT NULL DEFAULT '' ,

  `te_node_address` VARCHAR(17) NOT NULL DEFAULT '' ,
  `id_so` INT(11) UNSIGNED NOT NULL DEFAULT '0' ,
  `id_software_inventariado` INT(11) UNSIGNED NOT NULL DEFAULT '0' ,
  `dt_hr_inclusao` DATETIME NOT NULL ,
  `dt_hr_ult_coleta` DATETIME NOT NULL ,
  PRIMARY KEY (`te_node_address`, `id_so`, `id_software_inventariado`) ,
  INDEX `id_software` (`id_software_inventariado` ASC) )
ENGINE = InnoDB
