# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: db.schoolrevs.com (MySQL 5.7.30-log)
# Database: school14_gjc823
# Generation Time: 2022-12-17 6:16:30 PM +0000
# ************************************************************




# Dump of table student_rooms
# ------------------------------------------------------------


CREATE TABLE `student_rooms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `dateTime` datetime NOT NULL,
  `session_id` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `student_id` (`student_id`,`session_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;


INSERT INTO `student_rooms` (`id`, `student_id`, `room_id`, `dateTime`, `session_id`)
VALUES
	(1,88,5,'2021-12-27 21:01:20',9),
	(2,31,5,'2021-12-27 21:01:20',9),
	(3,29,5,'2021-12-27 21:01:20',9),
	(4,43,5,'2021-12-27 21:01:20',9),
	(5,47,5,'2021-12-27 21:01:20',9),
	(6,26,5,'2021-12-27 21:01:20',9),
	(7,66,5,'2021-12-27 21:01:20',9),
	(8,15,5,'2021-12-27 21:01:20',9),
	(9,14,5,'2021-12-27 21:01:20',9),
	(10,79,5,'2021-12-27 21:01:20',9),
	(11,80,5,'2021-12-27 21:01:20',9),
	(12,84,5,'2021-12-27 21:01:20',9),
	(13,77,1,'2021-12-27 21:01:20',9),
	(14,35,1,'2021-12-27 21:01:20',9),
	(15,3,1,'2021-12-27 21:01:20',9),
	(16,86,1,'2021-12-27 21:01:20',9),
	(17,82,1,'2021-12-27 21:01:20',9),
	(18,55,1,'2021-12-27 21:01:20',9),
	(19,56,1,'2021-12-27 21:01:20',9),
	(20,60,1,'2021-12-27 21:01:20',9),
	(21,81,1,'2021-12-27 21:01:20',9),
	(22,17,1,'2021-12-27 21:01:20',9),
	(23,8,1,'2021-12-27 21:01:20',9),
	(24,13,1,'2021-12-27 21:01:20',9),
	(25,61,7,'2021-12-27 21:01:20',9),
	(26,53,7,'2021-12-27 21:01:20',9),
	(27,52,7,'2021-12-27 21:01:20',9),
	(28,75,7,'2021-12-27 21:01:20',9),
	(29,76,7,'2021-12-27 21:01:20',9),
	(30,45,7,'2021-12-27 21:01:20',9),
	(31,32,7,'2021-12-27 21:01:20',9),
	(32,19,7,'2021-12-27 21:01:20',9),
	(33,21,7,'2021-12-27 21:01:20',9),
	(34,22,7,'2021-12-27 21:01:20',9),
	(35,28,7,'2021-12-27 21:01:20',9),
	(36,5,7,'2021-12-27 21:01:20',9),
	(37,27,7,'2021-12-27 21:01:20',9),
	(38,6,3,'2021-12-27 21:01:20',9),
	(39,74,3,'2021-12-27 21:01:20',9),
	(40,70,3,'2021-12-27 21:01:20',9),
	(41,18,3,'2021-12-27 21:01:20',9),
	(42,12,3,'2021-12-27 21:01:20',9),
	(43,67,3,'2021-12-27 21:01:20',9),
	(44,59,3,'2021-12-27 21:01:20',9),
	(45,7,3,'2021-12-27 21:01:20',9),
	(46,51,3,'2021-12-27 21:01:20',9),
	(47,48,3,'2021-12-27 21:01:20',9),
	(48,30,3,'2021-12-27 21:01:20',9),
	(49,44,3,'2021-12-27 21:01:20',9),
	(50,38,3,'2021-12-27 21:01:20',9),
	(51,34,6,'2021-12-27 21:01:21',9),
	(52,1,6,'2021-12-27 21:01:21',9),
	(53,24,6,'2021-12-27 21:01:21',9),
	(54,42,6,'2021-12-27 21:01:21',9),
	(55,37,6,'2021-12-27 21:01:21',9),
	(56,41,6,'2021-12-27 21:01:21',9),
	(57,85,6,'2021-12-27 21:01:21',9),
	(58,4,6,'2021-12-27 21:01:21',9),
	(59,65,6,'2021-12-27 21:01:21',9),
	(60,78,6,'2021-12-27 21:01:21',9),
	(61,72,2,'2021-12-27 21:01:21',9),
	(62,36,2,'2021-12-27 21:01:21',9),
	(63,10,2,'2021-12-27 21:01:21',9),
	(64,20,2,'2021-12-27 21:01:21',9),
	(65,58,2,'2021-12-27 21:01:21',9),
	(66,57,2,'2021-12-27 21:01:21',9),
	(67,9,2,'2021-12-27 21:01:21',9),
	(68,46,2,'2021-12-27 21:01:21',9),
	(69,49,2,'2021-12-27 21:01:21',9),
	(70,11,8,'2021-12-27 21:01:21',9),
	(71,33,8,'2021-12-27 21:01:21',9),
	(72,73,8,'2021-12-27 21:01:21',9),
	(73,69,8,'2021-12-27 21:01:21',9),
	(74,63,8,'2021-12-27 21:01:21',9),
	(75,62,8,'2021-12-27 21:01:21',9),
	(76,23,8,'2021-12-27 21:01:21',9),
	(77,50,8,'2021-12-27 21:01:21',9),
	(78,39,8,'2021-12-27 21:01:21',9),
	(79,71,4,'2021-12-27 21:01:21',9),
	(80,68,4,'2021-12-27 21:01:21',9),
	(81,64,4,'2021-12-27 21:01:21',9),
	(82,54,4,'2021-12-27 21:01:21',9),
	(83,25,4,'2021-12-27 21:01:21',9),
	(84,83,4,'2021-12-27 21:01:21',9),
	(85,40,4,'2021-12-27 21:01:21',9),
	(86,87,4,'2021-12-27 21:01:21',9),
	(87,2,4,'2021-12-27 21:01:21',9),
	(88,90,6,'2022-11-25 07:06:09',10),
	(89,107,6,'2022-11-25 07:06:09',10),
	(90,121,6,'2022-11-25 07:06:09',10),
	(91,123,6,'2022-11-25 07:06:09',10),
	(92,126,6,'2022-11-25 07:06:09',10),
	(93,131,6,'2022-11-25 07:06:09',10),
	(94,146,6,'2022-11-25 07:06:09',10),
	(96,160,6,'2022-11-25 07:06:09',10),
	(97,163,6,'2022-11-25 07:06:09',10),
	(98,164,6,'2022-11-25 07:06:09',10),
	(99,167,6,'2022-11-25 07:06:09',10),
	(100,89,5,'2022-11-25 07:07:54',10),
	(101,103,5,'2022-11-25 07:07:54',10),
	(102,113,5,'2022-11-25 07:07:54',10),
	(103,122,5,'2022-11-25 07:07:54',10),
	(104,124,5,'2022-11-25 07:07:54',10),
	(105,125,5,'2022-11-25 07:07:54',10),
	(106,133,5,'2022-11-25 07:07:54',10),
	(107,137,5,'2022-11-25 07:07:54',10),
	(108,142,5,'2022-11-25 07:07:54',10),
	(109,149,5,'2022-11-25 07:07:54',10),
	(110,151,5,'2022-11-25 07:07:54',10),
	(111,177,5,'2022-11-25 07:07:54',10),
	(112,97,2,'2022-11-25 07:09:23',10),
	(113,106,2,'2022-11-25 07:09:23',10),
	(114,108,2,'2022-11-25 07:09:23',10),
	(115,130,2,'2022-11-25 07:09:23',10),
	(116,139,2,'2022-11-25 07:09:23',10),
	(117,140,2,'2022-11-25 07:09:23',10),
	(118,141,2,'2022-11-25 07:09:23',10),
	(119,148,2,'2022-11-25 07:09:23',10),
	(120,156,2,'2022-11-25 07:09:23',10),
	(121,159,2,'2022-11-25 07:09:23',10),
	(122,162,2,'2022-11-25 07:09:23',10),
	(123,171,2,'2022-11-25 07:09:23',10),
	(124,94,1,'2022-11-25 07:10:48',10),
	(125,118,1,'2022-11-25 07:10:48',10),
	(126,120,1,'2022-11-25 07:10:48',10),
	(127,127,1,'2022-11-25 07:10:48',10),
	(128,136,1,'2022-11-25 07:10:48',10),
	(129,138,1,'2022-11-25 07:10:48',10),
	(130,145,1,'2022-11-25 07:10:48',10),
	(131,153,1,'2022-11-25 07:10:48',10),
	(132,161,1,'2022-11-25 07:10:48',10),
	(133,165,1,'2022-11-25 07:10:48',10),
	(134,178,1,'2022-11-25 07:10:48',10),
	(135,179,1,'2022-11-25 07:10:48',10),
	(136,110,4,'2022-11-25 07:12:23',10),
	(137,111,4,'2022-11-25 07:12:23',10),
	(138,114,4,'2022-11-25 07:12:23',10),
	(139,143,4,'2022-11-25 07:12:23',10),
	(140,150,4,'2022-11-25 07:12:23',10),
	(141,152,4,'2022-11-25 07:12:23',10),
	(142,158,4,'2022-11-25 07:12:23',10),
	(143,168,4,'2022-11-25 07:12:23',10),
	(144,172,4,'2022-11-25 07:12:23',10),
	(145,176,4,'2022-11-25 07:12:23',10),
	(146,182,4,'2022-11-25 07:12:23',10),
	(147,92,3,'2022-11-25 07:14:19',10),
	(148,96,3,'2022-11-25 07:14:19',10),
	(149,101,3,'2022-11-25 07:14:19',10),
	(150,116,3,'2022-11-25 07:14:19',10),
	(151,119,3,'2022-11-25 07:14:19',10),
	(152,129,3,'2022-11-25 07:14:19',10),
	(153,144,3,'2022-11-25 07:14:19',10),
	(154,157,3,'2022-11-25 07:14:19',10),
	(155,166,3,'2022-11-25 07:14:19',10),
	(156,169,3,'2022-11-25 07:14:19',10),
	(157,174,3,'2022-11-25 07:14:19',10),
	(158,175,3,'2022-11-25 07:14:19',10),
	(159,98,3,'2022-11-25 07:14:19',10),
	(160,93,8,'2022-11-25 07:15:37',10),
	(161,95,8,'2022-11-25 07:15:37',10),
	(162,100,8,'2022-11-25 07:15:37',10),
	(163,102,8,'2022-11-25 07:15:37',10),
	(164,109,8,'2022-11-25 07:15:37',10),
	(165,112,8,'2022-11-25 07:15:37',10),
	(166,128,8,'2022-11-25 07:15:37',10),
	(167,173,8,'2022-11-25 07:15:37',10),
	(168,180,8,'2022-11-25 07:15:37',10),
	(169,181,8,'2022-11-25 07:15:37',10),
	(170,91,7,'2022-11-25 07:17:28',10),
	(171,99,7,'2022-11-25 07:17:28',10),
	(172,104,7,'2022-11-25 07:17:28',10),
	(173,105,7,'2022-11-25 07:17:29',10),
	(174,115,7,'2022-11-25 07:17:29',10),
	(175,117,7,'2022-11-25 07:17:29',10),
	(176,132,7,'2022-11-25 07:17:29',10),
	(177,134,7,'2022-11-25 07:17:29',10),
	(178,135,7,'2022-11-25 07:17:29',10),
	(179,154,7,'2022-11-25 07:17:29',10),
	(180,155,7,'2022-11-25 07:17:29',10),
	(181,170,7,'2022-11-25 07:17:29',10),
	(182,183,7,'2022-11-25 07:17:29',10),
	(183,147,5,'2022-11-25 11:57:09',10),
	(184,184,8,'2022-12-01 11:20:54',10),
	(185,2,4,'2022-12-14 16:54:26',10),
	(186,25,4,'2022-12-14 16:54:26',10),
	(187,40,4,'2022-12-14 16:54:26',10),
	(188,54,4,'2022-12-14 16:54:26',10),
	(189,64,4,'2022-12-14 16:54:26',10),
	(190,68,4,'2022-12-14 16:54:26',10),
	(191,71,4,'2022-12-14 16:54:26',10),
	(192,83,4,'2022-12-14 16:54:26',10),
	(193,87,4,'2022-12-14 16:54:26',10),
	(194,6,3,'2022-12-14 16:57:32',10),
	(195,7,3,'2022-12-14 16:57:32',10),
	(196,12,3,'2022-12-14 16:57:32',10),
	(197,30,3,'2022-12-14 16:57:32',10),
	(198,38,3,'2022-12-14 16:57:32',10),
	(199,44,3,'2022-12-14 16:57:32',10),
	(200,48,3,'2022-12-14 16:57:32',10),
	(201,51,3,'2022-12-14 16:57:32',10),
	(202,59,3,'2022-12-14 16:57:32',10),
	(203,67,3,'2022-12-14 16:57:32',10),
	(204,70,3,'2022-12-14 16:57:32',10),
	(205,74,3,'2022-12-14 16:57:32',10),
	(206,5,7,'2022-12-14 16:59:29',10),
	(207,19,7,'2022-12-14 16:59:29',10),
	(208,21,7,'2022-12-14 16:59:29',10),
	(209,22,7,'2022-12-14 16:59:29',10),
	(210,27,7,'2022-12-14 16:59:29',10),
	(211,28,7,'2022-12-14 16:59:29',10),
	(212,32,7,'2022-12-14 16:59:29',10),
	(213,45,7,'2022-12-14 16:59:29',10),
	(214,52,7,'2022-12-14 16:59:29',10),
	(215,53,7,'2022-12-14 16:59:29',10),
	(216,61,7,'2022-12-14 16:59:29',10),
	(217,75,7,'2022-12-14 16:59:29',10),
	(218,76,7,'2022-12-14 16:59:29',10),
	(219,11,8,'2022-12-14 17:00:39',10),
	(220,23,8,'2022-12-14 17:00:39',10),
	(221,33,8,'2022-12-14 17:00:39',10),
	(222,39,8,'2022-12-14 17:00:39',10),
	(223,50,8,'2022-12-14 17:00:39',10),
	(224,62,8,'2022-12-14 17:00:39',10),
	(225,63,8,'2022-12-14 17:00:39',10),
	(226,69,8,'2022-12-14 17:00:39',10),
	(227,73,8,'2022-12-14 17:00:39',10),
	(228,3,1,'2022-12-14 17:02:15',10),
	(229,8,1,'2022-12-14 17:02:15',10),
	(230,13,1,'2022-12-14 17:02:15',10),
	(231,35,1,'2022-12-14 17:02:15',10),
	(232,55,1,'2022-12-14 17:02:15',10),
	(233,60,1,'2022-12-14 17:02:15',10),
	(234,77,1,'2022-12-14 17:02:15',10),
	(235,81,1,'2022-12-14 17:02:15',10),
	(236,82,1,'2022-12-14 17:02:15',10),
	(237,86,1,'2022-12-14 17:02:15',10),
	(238,9,2,'2022-12-14 17:04:08',10),
	(239,10,2,'2022-12-14 17:04:08',10),
	(240,20,2,'2022-12-14 17:04:08',10),
	(241,36,2,'2022-12-14 17:04:08',10),
	(242,46,2,'2022-12-14 17:04:08',10),
	(243,49,2,'2022-12-14 17:04:08',10),
	(244,57,2,'2022-12-14 17:04:08',10),
	(245,58,2,'2022-12-14 17:04:08',10),
	(246,14,5,'2022-12-14 17:05:15',10),
	(247,15,5,'2022-12-14 17:05:15',10),
	(248,26,5,'2022-12-14 17:05:15',10),
	(249,29,5,'2022-12-14 17:05:15',10),
	(250,31,5,'2022-12-14 17:05:15',10),
	(251,43,5,'2022-12-14 17:05:15',10),
	(252,47,5,'2022-12-14 17:05:15',10),
	(253,66,5,'2022-12-14 17:05:15',10),
	(254,79,5,'2022-12-14 17:05:15',10),
	(255,80,5,'2022-12-14 17:05:15',10),
	(256,84,5,'2022-12-14 17:05:15',10),
	(257,88,5,'2022-12-14 17:05:15',10),
	(258,1,6,'2022-12-14 17:06:03',10),
	(259,4,6,'2022-12-14 17:06:03',10),
	(260,24,6,'2022-12-14 17:06:03',10),
	(261,34,6,'2022-12-14 17:06:03',10),
	(262,37,6,'2022-12-14 17:06:03',10),
	(263,41,6,'2022-12-14 17:06:03',10),
	(264,42,6,'2022-12-14 17:06:03',10),
	(265,65,6,'2022-12-14 17:06:03',10),
	(266,78,6,'2022-12-14 17:06:03',10),
	(267,85,6,'2022-12-14 17:06:03',10);




