CREATE OR REPLACE PROCEDURE 
    UpdateVacancyTime( IN Vacancy_id INT )
BEGIN
    UPDATE 
        vacancy
    SET 
        up_date = NOW()
    WHERE
        id = Vacancy_id
    LIMIT 
        1
    ;
END