text: -- phpMyAdmin SQL Dump
  -- version 4.0.10.18
  -- https://www.phpmyadmin.net
  --
  -- المزود: localhost
  -- أنشئ في: 02 أغسطس 2018 الساعة 19:56
  -- إصدارة المزود: 10.1.27-MariaDB
  -- PHP إصدارة: 5.3.28
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  
  --
  -- قاعدة البيانات: `cl43-bd-retnec`
  --
  
  -- --------------------------------------------------------
  
  --
  -- بنية الجدول `classroom_lectures`
  --
  
  CREATE TABLE IF NOT EXISTS `classroom_lectures` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `classrooms_id` int(11) NOT NULL,
    `lecture_no` int(11) NOT NULL,
    `start_time` time NOT NULL,
    `end_time` time NOT NULL,
    `lecture_time` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=157 ;
  
  --
  -- إرجاع أو استيراد بيانات الجدول `classroom_lectures`
  --
  
  INSERT INTO `classroom_lectures` (`id`, `classrooms_id`, `lecture_no`, `start_time`, `end_time`, `lecture_time`, `created_at`, `updated_at`) VALUES
  (1, 1, 1, '08:00:00', '09:30:00', 90, '2018-01-31 08:19:19', '2018-04-19 06:43:13'),
  (2, 1, 2, '09:30:00', '11:00:00', 90, '2018-01-31 08:20:05', '2018-04-19 06:44:32'),
  (3, 1, 3, '11:00:00', '12:30:00', 90, '2018-01-31 08:21:22', '2018-04-19 06:45:08'),
  (4, 2, 1, '08:00:00', '09:30:00', 90, '2018-01-31 08:22:11', '2018-03-23 13:33:50'),
  (5, 2, 2, '09:30:00', '11:00:00', 90, '2018-01-31 08:23:22', '2018-03-23 13:34:42'),
  (6, 17, 1, '08:00:00', '09:30:00', 90, '2018-01-31 08:24:16', '2018-04-22 14:27:36'),
  (7, 17, 2, '09:30:00', '11:00:00', 90, '2018-01-31 08:25:02', '2018-04-22 14:27:54'),
  (8, 17, 3, '11:00:00', '12:30:00', 90, '2018-01-31 08:25:46', '2018-04-22 14:28:13'),
  (13, 7, 1, '08:00:00', '09:30:00', 90, '2018-03-17 09:23:06', '2018-04-22 14:39:19'),
  (14, 7, 2, '09:30:00', '11:00:00', 90, '2018-03-17 10:31:10', '2018-04-22 14:39:48'),
  (15, 7, 3, '11:00:00', '12:30:00', 90, '2018-03-17 10:31:42', '2018-04-22 14:40:03'),
  (16, 7, 4, '12:30:00', '14:00:00', 90, '2018-03-17 10:32:24', '2018-04-22 14:40:22'),
  (17, 4, 6, '15:30:00', '17:00:00', 90, '2018-03-17 10:35:48', '2018-03-23 18:18:41'),
  (18, 11, 1, '08:00:00', '09:30:00', 90, '2018-03-19 10:49:58', NULL),
  (19, 11, 2, '09:30:00', '11:00:00', 90, '2018-03-19 10:50:48', NULL),
  (20, 11, 3, '11:00:00', '12:30:00', 90, '2018-03-19 10:51:27', NULL),
  (21, 11, 4, '12:30:00', '14:00:00', 90, '2018-03-19 10:52:15', NULL),
  (22, 11, 5, '14:00:00', '15:30:00', 90, '2018-03-19 10:52:49', NULL),
  (23, 11, 6, '15:30:00', '17:00:00', 90, '2018-03-19 10:53:24', NULL),
  (24, 11, 7, '17:00:00', '18:30:00', 90, '2018-03-19 10:53:52', NULL),
  (25, 11, 8, '18:30:00', '20:00:00', 90, '2018-03-19 10:54:27', NULL),
  (26, 11, 9, '20:00:00', '21:30:00', 90, '2018-03-19 10:54:53', NULL),
  (27, 5, 1, '08:00:00', '09:30:00', 90, '2018-03-19 10:56:19', '2018-04-19 11:42:25'),
  (28, 5, 2, '09:30:00', '11:00:00', 90, '2018-03-19 10:56:50', '2018-04-19 11:43:26'),
  (29, 5, 3, '11:00:00', '12:30:00', 90, '2018-03-19 10:57:25', '2018-04-19 11:44:35'),
  (30, 5, 4, '12:30:00', '14:00:00', 90, '2018-03-19 10:57:58', '2018-04-19 11:50:04'),
  (31, 5, 5, '14:00:00', '15:30:00', 90, '2018-03-19 10:58:34', '2018-04-19 11:51:25'),
  (32, 5, 6, '15:30:00', '17:00:00', 90, '2018-03-19 10:59:03', '2018-04-19 11:52:40'),
  (33, 5, 7, '17:00:00', '18:30:00', 90, '2018-03-19 10:59:26', '2018-04-19 11:54:08'),
  (34, 6, 1, '08:00:00', '09:30:00', 90, '2018-03-19 11:01:10', NULL),
  (35, 6, 2, '09:30:00', '11:00:00', 90, '2018-03-19 11:01:35', NULL),
  (36, 6, 3, '11:00:00', '12:30:00', 90, '2018-03-19 11:02:01', NULL),
  (37, 6, 4, '12:30:00', '14:00:00', 90, '2018-03-19 11:02:39', NULL),
  (38, 6, 5, '14:00:00', '15:30:00', 90, '2018-03-19 11:03:09', NULL),
  (39, 6, 6, '15:30:00', '17:00:00', 90, '2018-03-19 11:03:53', NULL),
  (40, 6, 7, '17:00:00', '18:30:00', 90, '2018-03-19 11:05:09', NULL),
  (41, 6, 8, '18:30:00', '20:00:00', 90, '2018-03-19 11:05:40', NULL),
  (42, 6, 9, '20:00:00', '21:30:00', 90, '2018-03-19 11:06:04', NULL),
  (43, 7, 5, '14:00:00', '15:30:00', 90, '2018-03-19 11:12:02', '2018-04-22 14:40:38'),
  (44, 7, 6, '15:30:00', '17:00:00', 90, '2018-03-19 11:12:41', '2018-04-22 14:40:59'),
  (45, 7, 7, '17:00:00', '18:30:00', 90, '2018-03-19 11:13:59', '2018-04-22 14:41:20'),
  (46, 3, 1, '08:00:00', '09:30:00', 90, '2018-03-19 11:17:15', '2018-04-22 14:35:11'),
  (47, 3, 2, '09:30:00', '11:00:00', 90, '2018-03-19 11:17:51', '2018-04-22 14:35:28'),
  (48, 3, 3, '11:00:00', '12:30:00', 90, '2018-03-19 11:18:23', '2018-04-22 14:35:45'),
  (49, 3, 4, '12:30:00', '14:00:00', 90, '2018-03-19 11:18:49', '2018-04-22 14:36:00'),
  (50, 3, 5, '14:00:00', '15:30:00', 90, '2018-03-19 11:19:19', '2018-04-22 14:36:23'),
  (51, 3, 6, '15:30:00', '17:00:00', 90, '2018-03-19 11:19:44', '2018-04-22 14:36:46'),
  (52, 3, 7, '17:00:00', '18:30:00', 90, '2018-03-19 11:20:08', '2018-04-22 14:37:08'),
  (53, 17, 4, '12:30:00', '14:00:00', 90, '2018-03-19 11:22:41', '2018-04-22 14:28:34'),
  (54, 17, 5, '14:00:00', '15:30:00', 90, '2018-03-19 11:23:13', '2018-04-22 14:29:19'),
  (55, 17, 6, '15:30:00', '17:00:00', 90, '2018-03-19 11:23:36', '2018-04-22 14:29:40'),
  (56, 17, 7, '17:00:00', '18:30:00', 90, '2018-03-19 11:24:04', '2018-04-22 14:30:03'),
  (57, 2, 3, '11:00:00', '12:30:00', 90, '2018-03-23 13:35:40', NULL),
  (58, 2, 4, '12:30:00', '14:00:00', 90, '2018-03-23 13:36:15', '2018-08-01 09:37:29'),
  (59, 2, 5, '14:00:00', '15:30:00', 90, '2018-03-23 13:36:49', NULL),
  (60, 2, 6, '15:30:00', '17:00:00', 90, '2018-03-23 13:37:18', NULL),
  (61, 2, 7, '17:00:00', '18:30:00', 90, '2018-03-23 13:37:42', NULL),
  (62, 2, 8, '18:30:00', '20:00:00', 90, '2018-03-23 13:38:05', NULL),
  (63, 2, 9, '20:00:00', '21:30:00', 90, '2018-03-23 13:38:39', NULL),
  (64, 1, 4, '12:30:00', '14:00:00', 90, '2018-03-23 13:43:54', '2018-04-19 06:57:03'),
  (65, 1, 5, '14:00:00', '15:30:00', 90, '2018-03-23 13:44:28', '2018-04-19 18:34:39'),
  (66, 1, 6, '15:30:00', '17:00:00', 90, '2018-03-23 13:45:12', '2018-04-19 18:35:20'),
  (67, 16, 1, '16:00:00', '19:00:00', 180, '2018-03-23 13:45:46', NULL),
  (68, 16, 2, '19:00:00', '22:00:00', 180, '2018-03-23 13:46:15', NULL),
  (69, 8, 1, '08:00:00', '09:30:00', 90, '2018-03-23 13:47:01', '2018-04-19 07:09:48'),
  (70, 8, 2, '09:30:00', '11:00:00', 90, '2018-03-23 13:47:22', '2018-04-19 07:10:45'),
  (71, 8, 3, '11:00:00', '12:30:00', 90, '2018-03-23 13:47:47', '2018-04-19 07:11:15'),
  (72, 8, 4, '12:30:00', '14:00:00', 90, '2018-03-23 13:48:12', '2018-04-19 07:11:42'),
  (73, 8, 5, '14:00:00', '15:30:00', 90, '2018-03-23 13:48:42', '2018-04-19 07:12:14'),
  (74, 8, 6, '15:30:00', '17:00:00', 90, '2018-03-23 13:49:06', '2018-04-19 07:12:57'),
  (75, 8, 7, '17:00:00', '18:30:00', 90, '2018-03-23 13:49:29', '2018-04-19 07:14:07'),
  (76, 4, 1, '08:00:00', '09:30:00', 90, '2018-03-23 18:19:27', NULL),
  (77, 4, 2, '09:30:00', '11:00:00', 90, '2018-03-23 18:20:06', NULL),
  (78, 4, 3, '11:00:00', '12:30:00', 90, '2018-03-23 18:20:39', NULL),
  (79, 4, 4, '12:30:00', '14:00:00', 90, '2018-03-23 18:21:09', NULL),
  (80, 4, 5, '14:00:00', '15:30:00', 90, '2018-03-23 18:21:33', NULL),
  (81, 4, 7, '17:00:00', '18:30:00', 90, '2018-03-23 18:22:04', NULL),
  (82, 4, 8, '18:30:00', '20:00:00', 90, '2018-03-23 18:22:30', NULL),
  (83, 4, 9, '20:00:00', '21:30:00', 90, '2018-03-23 18:22:57', NULL),
  (84, 15, 1, '08:00:00', '09:30:00', 90, '2018-03-23 18:26:35', '2018-04-22 14:17:39'),
  (85, 15, 2, '09:30:00', '11:00:00', 90, '2018-03-23 18:27:06', '2018-04-22 14:18:04'),
  (86, 15, 3, '11:00:00', '12:30:00', 90, '2018-03-23 18:27:27', '2018-04-22 14:18:30'),
  (87, 15, 4, '12:30:00', '14:00:00', 90, '2018-03-23 18:27:52', '2018-04-22 14:18:57'),
  (88, 15, 5, '14:00:00', '15:30:00', 90, '2018-03-23 18:28:28', '2018-04-22 14:19:27'),
  (89, 15, 6, '15:30:00', '17:00:00', 90, '2018-03-23 18:30:04', '2018-04-22 14:19:50'),
  (90, 15, 7, '17:00:00', '18:30:00', 90, '2018-03-23 18:30:35', '2018-04-22 14:17:13'),
  (91, 13, 1, '08:00:00', '09:30:00', 90, '2018-03-23 18:35:21', '2018-04-22 14:10:54'),
  (92, 13, 2, '09:30:00', '11:00:00', 90, '2018-03-23 18:35:52', '2018-04-22 14:11:24'),
  (93, 13, 3, '11:00:00', '12:30:00', 90, '2018-03-23 18:36:20', '2018-04-22 14:11:53'),
  (94, 13, 4, '12:30:00', '14:00:00', 90, '2018-03-23 18:36:47', '2018-04-22 14:12:22'),
  (95, 13, 5, '14:00:00', '15:30:00', 90, '2018-03-23 18:37:18', '2018-04-22 14:12:42'),
  (96, 13, 6, '15:30:00', '17:00:00', 90, '2018-03-23 18:37:38', '2018-04-22 14:13:08'),
  (97, 13, 7, '17:00:00', '18:30:00', 90, '2018-03-23 18:38:07', '2018-04-22 14:13:55'),
  (98, 10, 1, '08:00:00', '09:30:00', 90, '2018-03-30 18:43:50', '2018-04-19 07:15:55'),
  (99, 10, 2, '09:30:00', '11:00:00', 90, '2018-03-30 18:44:24', '2018-04-19 07:16:32'),
  (100, 10, 3, '11:00:00', '12:30:00', 90, '2018-03-30 18:46:07', '2018-04-19 07:16:54'),
  (101, 10, 4, '12:30:00', '14:00:00', 90, '2018-03-30 18:46:33', '2018-04-19 07:17:22'),
  (102, 10, 5, '14:00:00', '15:30:00', 90, '2018-03-30 18:47:09', '2018-04-19 07:18:07'),
  (103, 10, 6, '15:30:00', '17:00:00', 90, '2018-03-30 18:47:37', '2018-04-19 07:20:01'),
  (104, 10, 7, '17:00:00', '18:30:00', 90, '2018-03-30 18:48:20', '2018-04-19 07:20:37'),
  (105, 14, 1, '08:00:00', '09:30:00', 90, '2018-04-03 08:43:39', '2018-04-19 16:07:16'),
  (106, 14, 2, '09:30:00', '11:00:00', 90, '2018-04-03 08:44:00', '2018-04-19 16:08:00'),
  (107, 14, 3, '11:00:00', '12:30:00', 90, '2018-04-03 08:44:20', '2018-04-19 16:09:07'),
  (108, 14, 4, '12:30:00', '14:00:00', 90, '2018-04-03 08:44:48', '2018-04-19 16:09:53'),
  (109, 14, 5, '14:00:00', '15:30:00', 90, '2018-04-03 08:45:23', '2018-04-19 16:12:23'),
  (110, 14, 6, '15:30:00', '17:00:00', 90, '2018-04-03 08:45:46', '2018-04-19 16:13:49'),
  (111, 14, 7, '17:00:00', '18:30:00', 90, '2018-04-03 08:46:04', '2018-04-19 16:14:36'),
  (112, 12, 1, '08:00:00', '09:30:00', 90, '2018-04-03 08:47:32', '2018-04-17 19:02:50'),
  (113, 12, 2, '09:30:00', '11:00:00', 90, '2018-04-03 08:47:54', '2018-04-17 19:03:17'),
  (114, 12, 3, '11:00:00', '12:30:00', 90, '2018-04-03 08:48:30', '2018-04-17 19:03:40'),
  (115, 12, 4, '12:30:00', '14:00:00', 90, '2018-04-03 08:49:51', '2018-04-17 19:04:21'),
  (116, 12, 5, '14:00:00', '15:30:00', 90, '2018-04-03 08:50:12', '2018-04-17 19:04:47'),
  (117, 12, 6, '15:30:00', '17:00:00', 90, '2018-04-03 08:50:53', '2018-04-17 19:05:12'),
  (118, 12, 7, '17:00:00', '18:30:00', 90, '2018-04-03 08:52:01', '2018-04-17 19:05:41'),
  (119, 12, 8, '18:30:30', '20:00:30', 90, '2018-04-17 19:06:30', NULL),
  (120, 12, 9, '20:00:00', '21:30:00', 90, '2018-04-17 19:15:10', NULL),
  (121, 1, 7, '17:00:00', '18:30:00', 90, '2018-04-19 07:01:56', '2018-04-19 18:29:27'),
  (122, 1, 8, '18:30:00', '20:00:00', 90, '2018-04-19 07:08:43', '2018-04-19 18:30:09'),
  (124, 3, 8, '18:30:00', '20:00:00', 90, '2018-04-19 08:00:25', NULL),
  (125, 8, 8, '18:30:00', '20:00:00', 90, '2018-04-19 08:01:31', NULL),
  (126, 14, 8, '18:30:00', '20:00:00', 90, '2018-04-19 08:04:02', NULL),
  (127, 5, 8, '18:30:00', '20:00:00', 90, '2018-04-19 11:55:38', NULL),
  (128, 14, 8, '18:30:00', '20:00:00', 90, '2018-04-19 16:15:44', NULL),
  (129, 14, 9, '20:00:00', '21:30:00', 90, '2018-04-19 16:16:09', NULL),
  (130, 1, 9, '20:00:00', '21:30:00', 90, '2018-04-19 18:37:27', NULL),
  (131, 8, 9, '20:00:00', '21:30:00', 90, '2018-04-19 18:41:16', NULL),
  (132, 13, 8, '18:30:00', '20:00:00', 90, '2018-04-22 14:15:07', NULL),
  (133, 13, 9, '20:00:00', '21:30:00', 90, '2018-04-22 14:16:01', NULL),
  (134, 15, 8, '18:30:00', '20:00:00', 90, '2018-04-22 14:20:48', NULL),
  (135, 15, 9, '20:00:00', '21:30:00', 90, '2018-04-22 14:21:36', NULL),
  (136, 17, 8, '18:30:00', '20:00:00', 90, '2018-04-22 14:31:07', NULL),
  (137, 17, 9, '20:00:00', '21:30:00', 90, '2018-04-22 14:31:55', NULL),
  (138, 3, 9, '20:00:00', '21:30:00', 90, '2018-04-22 14:38:08', NULL),
  (139, 7, 8, '18:30:00', '20:00:00', 90, '2018-04-22 14:41:50', NULL),
  (140, 7, 9, '20:00:30', '21:30:00', 89, '2018-04-22 14:42:32', NULL),
  (141, 19, 1, '08:00:00', '09:30:00', 90, '2018-08-01 08:56:47', NULL),
  (142, 19, 2, '09:30:00', '11:00:00', 90, '2018-08-01 08:57:22', NULL),
  (143, 19, 3, '11:00:00', '12:30:00', 90, '2018-08-01 08:58:15', NULL),
  (144, 19, 5, '14:00:00', '15:30:00', 90, '2018-08-01 08:58:51', '2018-08-01 08:59:36'),
  (145, 19, 4, '12:30:00', '14:00:00', 90, '2018-08-01 09:00:34', NULL),
  (146, 19, 6, '15:30:00', '17:00:00', 90, '2018-08-01 09:22:17', NULL),
  (147, 19, 7, '17:00:00', '18:30:00', 90, '2018-08-01 09:24:00', NULL),
  (148, 20, 2, '09:30:00', '11:00:00', 90, '2018-08-01 09:24:25', '2018-08-01 09:27:15'),
  (149, 20, 3, '11:00:00', '12:30:00', 90, '2018-08-01 09:25:38', '2018-08-01 09:29:09'),
  (150, 20, 4, '12:30:00', '14:00:00', 90, '2018-08-01 09:30:51', NULL),
  (151, 20, 1, '08:00:00', '09:30:00', 90, '2018-08-01 09:31:42', NULL),
  (152, 20, 5, '14:00:00', '15:30:00', 90, '2018-08-01 09:32:15', NULL),
  (153, 20, 6, '15:30:00', '17:00:00', 90, '2018-08-01 09:32:48', NULL),
  (154, 20, 7, '17:00:00', '18:30:00', 90, '2018-08-01 09:33:24', NULL),
  (155, 20, 8, '18:30:00', '20:00:00', 90, '2018-08-01 09:34:18', NULL),
  (156, 19, 8, '18:30:00', '20:00:00', 90, '2018-08-01 09:34:59', NULL);
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  