intente hacer eso y no me funciono
Código SQL:
Ver originalCREATE
TRIGGER `covenios`.`convenios_AINS`
AFTER INSERT ON `covenios`.`convenios`
FOR EACH ROW
INSERT INTO History (DATA,idSequenceTT,ModifiedBy) VALUES (NEW.DATA,NEW.idSequence,USER())
$$
CREATE
TRIGGER `covenios`.`convenios_AUPD`
AFTER UPDATE ON `covneios`.`convenios`
FOR EACH ROW
INSERT INTO History (DATA,idSequenceTT,ModifiedBy) VALUES (NEW.DATA,NEW.idSequence,USER())
$$
delimiter $$
CREATE TABLE `history` (
`HistoryId` INT(11) NOT NULL AUTO_INCREMENT,
`id_con` INT(11) NOT NULL,
`dtModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ModifiedBy` VARCHAR(45) NOT NULL,
`data` VARCHAR(45) DEFAULT NULL,
PRIMARY KEY (`HistoryId`),
KEY `fk1_con_HIST_idx` (`id_con`),
CONSTRAINT `fk1_con_HIST` FOREIGN KEY (`id_con`) REFERENCES `convenios` (`id_con`) ON DELETE NO ACTION ON UPDATE NO ACTION
)