 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Sep 03, 2015 at 02:06 PM
+-- Generation Time: Sep 03, 2015 at 02:09 PM
 -- Server version: 5.5.44-0ubuntu0.14.04.1
 -- PHP Version: 5.5.9-1ubuntu4.11
 

booking b
JOIN podestrian ps ON b.podestrian = ps.podestrian_id
JOIN pod pd ON b.pod - pd.pod_id
JOIN pod_type pt ON pd.pod_type_id = pt.pod_type_id$$

CREATE DEFINER=`sleepover`@`localhost` PROCEDURE `get_pod`(IN `id` INT(11))
    READS SQL DATA

b.booking_id,
ps.podestrian_id,
pd.pod_id,
CONCAT(ps.first_name,' ',ps.last_name) podestrian,
CONCAT(pd.pod_name,' - ',pt.pod_type) pod,
b.checkin_datetime,
b.checkout_date
