How to write trigger body in yii1 migration?

Question

MySQL

A trigger has been created in the database, you need to transfer it to the project. I created the migration file in the project. in up I can't figure out how to spell it correctly

BEGIN 
DECLARE cnt INT; 
SELECT COUNT(*) FROM phone WHERE FIO_ID = OLD. FIO_ID INTO cnt; 
IF cnt = 1 THEN 
SIGNAL SQLSTATE '45000' 
SET MESSAGE_TEXT = 'Отмена удаления'; 
END IF; 
END

Answer 1

$this->execute("
CREATE TRIGGER last_number_fio
BEFORE DELETE ON phone
FOR EACH ROW
BEGIN
DECLARE cnt INT;
SELECT COUNT(*) FROM phone WHERE FIO_ID = OLD. FIO_ID INTO cnt;
IF cnt = 1 THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Cancel deletion';
END IF;
END");
in short, here is the final version of the trigger in the migration