DROP VIEW   IF EXISTS  `t1`;

DROP TABLE  IF EXISTS  `t1`;

CREATE TABLE `t1` (

	`a`      INTEGER UNSIGNED  NULL  DEFAULT NULL,

	`b`      INTEGER UNSIGNED  GENERATED ALWAYS AS (`a`) VIRTUAL

)

	ENGINE      = MyISAM;

DROP VIEW   IF EXISTS  `t2`;

DROP TABLE  IF EXISTS  `t2`;

CREATE TABLE `t2` (

	`c1`      INTEGER UNSIGNED  NOT NULL

)

	ENGINE      = MyISAM;

DELIMITER ||

CREATE TRIGGER `t1_ins_aft`

	AFTER INSERT

	ON `t1`

	FOR EACH ROW

BEGIN

	INSERT INTO `t2` (`c1`) VALUES (NEW.`b`);

END ||

CREATE TRIGGER `t1_del_bef`

	BEFORE DELETE

	ON `t1`

	FOR EACH ROW

BEGIN

	INSERT INTO `t2` (`c1`) VALUES (OLD.`b`);

END ||

DELIMITER ;

INSERT INTO `t1` (`a`) VALUES (1), (2), (3);

DELETE FROM t1;