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

START TRANSACTION;



--
-- Database: `malingue_schedule`
--

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

--
-- Structure for view `view2`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view2`  AS SELECT `SSchedule`.`end` AS `end`, `SSchedule`.`start` AS `start`, `SSchedule`.`date` AS `date`, `classname`.`classnames` AS `classnames`, `classroom`.`classroom` AS `classroom`, `type`.`type` AS `type`, `classroom`.`classroomid` AS `classroomid`, `classname`.`classname_id` AS `classname_id`, `SSchedule`.`schedule_id` AS `schedule_id` FROM (((`SSchedule` join `classname`) join `type`) join `classroom`) WHERE ((`SSchedule`.`classname` = `classname`.`classname_id`) AND (`SSchedule`.`classroom` = `classroom`.`classroomid`) AND (`SSchedule`.`type` = `type`.`type_id`)) ;

--
-- VIEW `view2`
-- Data: None
--

COMMIT;

