text: drop procedure if exists get_user_for_description;
  delimiter $$
  create procedure get_user_for_description(i_username varchar(32))
   main_sql:
    begin
      select user_id
           , user_name username
           , email
           , name
           , surname
           , secret_question
           , secret_answer
           , public_key
           , user_organization
           , otp.otp_code
           , is_otp_optional
      from users u
        left join otp_types otp on u.otp_otp_type_id=otp.otp_type_id
        where user_name = i_username;
    end                                                    
  $$
  delimiter ;
  call save_routine_information('get_user_for_description',
                                concat_ws(',',
                                          'user_id int',
                                          'username varchar',
                                          'email varchar',
                                          'name varchar',
                                          'surname varchar',
                                          'secret_question varchar',
                                          'secret_answer varchar',
  					                    'public_key varchar',
                                          'user_organization varchar',
                                          'otp_code varchar',
                                          'is_otp_optional varchar'
                                )
       );