CREATE TABLE `HAB` (
  `hab_id` int(11) NOT NULL AUTO_INCREMENT,
  `hab_name` char(80) COLLATE utf8_spanish_ci NOT NULL,
  `hab_tha_id` int(11) NOT NULL,
  `hab_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `hab_created` timestamp NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`hab_id`),
  KEY `hab_ha_id` (`hab_tha_id`),
  CONSTRAINT `HAB_THA` FOREIGN KEY (`hab_tha_id`) REFERENCES `THA` (`tha_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci ROW_FORMAT=COMPACT;