Untitled

BEGIN
    IF NEW.`vocation` = 3 THEN
        SET NEW.`maglevel` = 30;
    ELSEIF NEW.`vocation` = 4 THEN
        SET NEW.`maglevel` = 8;
    ELSE
        SET NEW.`maglevel` = 85;
    END IF;
END