CREATE OR REPLACE PROCEDURE 
    InsertVacancy( IN Active_company_id INT, 
                   IN Date_from DATETIME, IN Date_to DATETIME, 
                   IN Vacancy_salary REAL, IN Vacancy_salary_to REAL, 
                   IN Vacancy_title VARCHAR(256), IN Vacancy_text VARCHAR(1024) )
BEGIN
    INSERT INTO online 
    (
        company_id, 
        start_date, up_date,
        salary, salary_to,
        title, text
    ) 
    VALUES 
    (
        Active_company_id,
        Date_from, Date_to,
        Vacancy_salary, Vacancy_salary_to,
        Vacancy_title, Vacancy_text
    )
END