   `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;

CREATE  TABLE IF NOT EXISTS `patrimonio` (
  `id_unid_organizacional_nivel1a` INT(11) NOT NULL ,
  `id_so` INT(11) NOT NULL DEFAULT '0' ,
  `dt_hr_alteracao` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  `te_node_address` VARCHAR(17) NOT NULL ,
  `id_unid_organizacional_nivel2` INT(11) NULL DEFAULT NULL ,
  `te_localizacao_complementar` VARCHAR(100) NULL DEFAULT NULL ,

  `id_so` INT(11) NOT NULL DEFAULT '0' ,
  `campo_alterado` VARCHAR(45) NULL DEFAULT '' ,
  `valor_antigo` VARCHAR(45) NULL DEFAULT '' ,
  `data_anterior` DATETIME NULL ,
  `novo_valor` VARCHAR(45) NULL DEFAULT '' ,
  `nova_data` DATETIME NULL ,
  PRIMARY KEY (`te_node_address`, `id_so`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
