DROP TRIGGER IF EXISTS `TR_TableUpdate`;

CREATE TRIGGER `TR_TableUpdate`
    AFTER UPDATE
    ON `Table`
    FOR EACH ROW
BEGIN
    INSERT INTO `TableHistory` (Id, ..., Deleted, EditorId, Created, Updated)
    VALUES (OLD.Id, ..., OLD.Deleted, OLD.Created, CURRENT_TIMESTAMP());
END;

DROP TRIGGER IF EXISTS `TR_TableDelete`;

CREATE TRIGGER `TR_TableDelete`
    AFTER DELETE
    ON `Table`
    FOR EACH ROW
BEGIN
    INSERT INTO `TableHistory` (Id, ..., Deleted, EditorId, Created, Updated)
    VALUES (OLD.Id, ..., TRUE, OLD.Created, CURRENT_TIMESTAMP());
END;