gistfile1.sql

CREATE DEFINER = CURRENT_USER TRIGGER `task`.`user_AFTER_INSERT`
AFTER INSERT ON `user` FOR EACH ROW
    INSERT INTO `task`.`event` SET `type` = 'create',
                                   `user_id` = NEW.`id`,
                                   `timestamp` = NULL,
                                   `created_at` = NULL,
                                   `modified_at` = NULL;

CREATE DEFINER = CURRENT_USER TRIGGER `task`.`user_AFTER_UPDATE`
AFTER UPDATE ON `user` FOR EACH ROW
  BEGIN
    IF (OLD.`deleted_at` IS NULL && NEW.`deleted_at` IS NOT NULL) THEN
      SET @event_type = 'delete';
    ELSE
      SET @event_type = 'update';
        END IF;
    INSERT INTO `task`.`event` SET `type` = @event_type,
                                   `user_id` = NEW.`id`,
                                   `timestamp` = NULL,
                                   `created_at` = NULL,
                                   `modified_at` = NULL;