---

-- 3.e.i. Создаём команду 'lost'
INSERT INTO TEAM (team_name) VALUES ('lost'); -- id станет 1

-- 3.e.ii. Устанавливаем default для поля kom
ALTER TABLE STUDENT MODIFY COLUMN kom INT DEFAULT 1;

-- 3.e.iii. Триггер
DELIMITER //
CREATE TRIGGER tr_student_to_lost_on_team_delete
BEFORE DELETE ON TEAM
FOR EACH ROW
BEGIN
    IF OLD.id != 1 THEN -- Не трогаем саму команду 'lost'
        UPDATE STUDENT SET kom = 1 WHERE kom = OLD.id;
    END IF;
END //
DELIMITER ;

-- Проверка:
INSERT INTO TEAM (team_name) VALUES ('TempTeam'); -- id=2
INSERT INTO STUDENT (lastName, name, kom) VALUES ('Иванов', 'Иван', 2);
DELETE FROM TEAM WHERE id = 2;
SELECT kom FROM STUDENT WHERE lastName = 'Иванов'; -- Вернёт 1