CREATE TABLE `TPD` (
  `tpd_id` int(11) NOT NULL AUTO_INCREMENT,
  `tpd_tpr_id` int(11) NOT NULL,
  `tpd_month` char(7) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `tpd_data` bit(31) NOT NULL DEFAULT b'0',
  `tpd_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tpd_created` timestamp NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`tpd_id`),
  UNIQUE KEY `tpd_tpr_id-tpd_month` (`tpd_tpr_id`,`tpd_month`),
  CONSTRAINT `TPD-TPR` FOREIGN KEY (`tpd_tpr_id`) REFERENCES `TPR` (`tpr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;