
--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '1') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '1') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '20') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '20') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '20') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '20') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '20') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '21') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '21') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_54`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_54`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_54` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '54')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_49`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_49`*/;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_RANKS`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS` AS select `V_STUDENT_MARK_QUATER`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_QUATER`.`value` * `V_STUDENT_MARK_QUATER`.`weight`) * `V_STUDENT_MARK_QUATER`.`coef`)) / sum((`V_STUDENT_MARK_QUATER`.`weight` * `V_STUDENT_MARK_QUATER`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_QUATER`.`weight` * `V_STUDENT_MARK_QUATER`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_QUATER` group by `V_STUDENT_MARK_QUATER`.`std` order by sum(((`V_STUDENT_MARK_QUATER`.`value` * `V_STUDENT_MARK_QUATER`.`weight`) * `V_STUDENT_MARK_QUATER`.`coef`)) desc */;


