ALTER TABLE `hospitals` ADD `consultation` BOOLEAN NOT NULL DEFAULT FALSE AFTER `hasStore`, ADD `patient` BOOLEAN NOT NULL DEFAULT FALSE AFTER `consultation`;


DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `update_hospital_info`(IN `in_consultation` BOOLEAN, IN `in_patient` BOOLEAN, IN `in_id` VARCHAR(100))
UPDATE `hospitals` SET `consultation`=in_consultation,`patient`=in_patient WHERE id=in_id$$
DELIMITER ;