create procedure `putrequest`(in `employeeId` varchar(15),in `reqtype` varchar(15),in `ticketId` varchar(15),in `status` varchar(15),in `details` varchar(100))
begin
declare `rid` int;
declare `reqType` int;
select `requestId` into  `reqType` from `requesttype` where `request`=`reqtype`;
select `reqId` into `rid` from `employee` where `empId`=`employeeId`;
insert into `requests` values(rid,reqType,`ticketId`,NOW(),NOW(),`status`,`details`);
end