-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `relovsky_schedule`
--

-- --------------------------------------------------------

--
-- Structure for view `all_sessions`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`relovsky`@`localhost` SQL SECURITY DEFINER VIEW `all_sessions`  AS SELECT `sessions`.`date` AS `date`, `sessions`.`startTime` AS `startTime`, `sessions`.`endTime` AS `endTime`, `locations`.`locationName` AS `locationName`, `types`.`typeName` AS `typeName`, `classes`.`className` AS `className` FROM (((`sessions` join `types`) join `locations`) join `classes`) WHERE ((`sessions`.`location_id` = `locations`.`location_id`) AND (`sessions`.`type_id` = `types`.`type_id`) AND (`sessions`.`class_id` = `classes`.`class_id`)) ;

--
-- VIEW `all_sessions`
-- Data: None
--

COMMIT;

