-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 26, 2024 at 05:05 PM -- Server version: 5.7.44 -- PHP Version: 8.1.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; 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 utf8mb4 */; -- -- Database: `muvvala_classschedule` -- -- -------------------------------------------------------- -- -- Table structure for table `schedule` -- CREATE TABLE `schedule` ( `schedule_id` int(11) NOT NULL, `schedule_date` date NOT NULL, `start_time` time NOT NULL, `end_time` time NOT NULL, `class_id` int(11) NOT NULL, `lecture_id` int(11) NOT NULL, `room_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `schedule` -- INSERT INTO `schedule` (`schedule_id`, `schedule_date`, `start_time`, `end_time`, `class_id`, `lecture_id`, `room_id`) VALUES (1, '2024-09-16', '09:00:00', '10:50:00', 1, 6, 1), (2, '2024-09-16', '15:00:00', '16:50:00', 2, 6, 2), (3, '2024-09-17', '09:00:00', '11:50:00', 3, 6, 3), (4, '2024-09-17', '15:00:00', '16:50:00', 4, 6, 5), (5, '2024-09-17', '18:00:00', '21:20:00', 5, 6, 4), (6, '2024-09-18', '15:00:00', '16:50:00', 2, 6, 1), (7, '2024-09-19', '09:00:00', '11:50:00', 3, 6, 3), (8, '2024-09-19', '14:00:00', '16:50:00', 4, 6, 5), (9, '2024-09-23', '09:00:00', '10:50:00', 1, 6, 1), (10, '2024-09-23', '15:00:00', '16:50:00', 2, 6, 2), (11, '2024-09-24', '09:00:00', '11:50:00', 3, 6, 3), (12, '2024-09-24', '14:00:00', '16:50:00', 4, 6, 5), (13, '2024-09-24', '18:00:00', '21:20:00', 5, 6, 4), (14, '2024-09-25', '15:00:00', '16:50:00', 2, 6, 2), (15, '2024-09-26', '09:00:00', '11:50:00', 3, 6, 3), (16, '2024-09-26', '14:00:00', '16:50:00', 4, 6, 5), (17, '2024-09-30', '09:00:00', '10:50:00', 1, 6, 1), (18, '2024-09-30', '15:00:00', '16:50:00', 2, 6, 2), (19, '2024-10-01', '09:00:00', '11:50:00', 3, 6, 3), (20, '2024-10-01', '14:00:00', '16:50:00', 4, 6, 5), (21, '2024-10-01', '18:00:00', '21:20:00', 5, 6, 4), (22, '2024-10-02', '15:00:00', '16:50:00', 2, 6, 2), (23, '2024-10-03', '09:00:00', '11:50:00', 3, 6, 3), (24, '2024-10-03', '14:00:00', '16:50:00', 4, 6, 5), (25, '2024-10-07', '09:00:00', '11:50:00', 1, 6, 1), (26, '2024-10-07', '15:00:00', '16:50:00', 2, 6, 2), (27, '2024-10-08', '09:00:00', '11:50:00', 3, 6, 3), (28, '2024-10-08', '14:00:00', '16:50:00', 4, 6, 5), (29, '2024-10-08', '18:00:00', '21:20:00', 5, 6, 4), (30, '2024-10-09', '15:00:00', '16:50:00', 2, 6, 2), (31, '2024-10-10', '09:00:00', '11:50:00', 3, 6, 3), (32, '2024-10-10', '14:00:00', '16:50:00', 4, 6, 5), (33, '2024-10-14', '09:00:00', '10:00:00', 1, 6, 1), (34, '2024-10-14', '09:00:00', '10:00:00', 1, 6, 1), (35, '2024-10-14', '09:00:00', '10:00:00', 1, 6, 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `schedule` -- ALTER TABLE `schedule` ADD PRIMARY KEY (`schedule_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `schedule` -- ALTER TABLE `schedule` MODIFY `schedule_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; COMMIT; /*!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 */;