-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 23, 2026 at 01:25 PM -- Server version: 5.7.44 -- PHP Version: 8.1.34 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: `sahilkoc_schedule` -- -- -------------------------------------------------------- -- -- Table structure for table `location` -- CREATE TABLE `location` ( `location_id` int(11) NOT NULL, `location` varchar(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `location` -- INSERT INTO `location` (`location_id`, `location`) VALUES (1, 'ACC-310'), (2, 'IYH-212'), (3, 'IYH-210/211'), (4, 'HOH1'), (5, 'JFFLL125'); -- -------------------------------------------------------- -- -- Table structure for table `main` -- CREATE TABLE `main` ( `schedule_id` int(11) NOT NULL, `date` date NOT NULL, `name_id` int(11) NOT NULL, `start` time NOT NULL, `end` time NOT NULL, `location_id` int(11) NOT NULL, `type_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `main` -- INSERT INTO `main` (`schedule_id`, `date`, `name_id`, `start`, `end`, `location_id`, `type_id`) VALUES (1, '2026-09-14', 1, '15:30:00', '16:50:00', 1, 1), (2, '2026-09-15', 2, '10:00:00', '11:50:00', 2, 1), (3, '2026-09-15', 3, '12:00:00', '13:50:00', 3, 1), (4, '2026-09-15', 4, '15:30:00', '16:50:00', 4, 1), (5, '2026-09-15', 5, '17:00:00', '18:20:00', 5, 1), (6, '2026-09-16', 6, '10:00:00', '11:50:00', 3, 1), (7, '2026-09-16', 1, '15:30:00', '16:50:00', 1, 1), (8, '2026-09-17', 3, '12:00:00', '13:50:00', 3, 1), (9, '2026-09-17', 4, '15:30:00', '16:50:00', 4, 1), (10, '2026-09-17', 5, '17:00:00', '18:20:00', 5, 1), (11, '2026-09-21', 1, '15:30:00', '16:50:00', 1, 1), (12, '2026-09-22', 2, '10:00:00', '11:50:00', 2, 1), (13, '2026-09-22', 3, '12:00:00', '13:50:00', 3, 1), (14, '2026-09-22', 4, '15:30:00', '16:50:00', 4, 1), (15, '2026-09-22', 5, '17:00:00', '18:20:00', 5, 1), (16, '2026-09-23', 6, '10:00:00', '11:50:00', 3, 1), (17, '2026-09-23', 1, '15:30:00', '16:50:00', 1, 1), (18, '2026-09-24', 3, '12:00:00', '13:50:00', 3, 1), (19, '2026-09-24', 4, '15:30:00', '16:50:00', 4, 1), (20, '2026-09-24', 5, '17:00:00', '18:20:00', 5, 1), (21, '2026-09-28', 1, '15:30:00', '16:50:00', 1, 1), (22, '2026-09-29', 2, '10:00:00', '11:50:00', 2, 1), (23, '2026-09-29', 3, '12:00:00', '13:50:00', 3, 1), (24, '2026-09-29', 4, '15:30:00', '16:50:00', 4, 1), (25, '2026-09-29', 5, '17:00:00', '18:20:00', 5, 1), (26, '2026-09-30', 6, '10:00:00', '11:50:00', 3, 1), (27, '2026-09-30', 1, '15:30:00', '16:50:00', 1, 1), (28, '2026-10-01', 3, '12:00:00', '13:50:00', 3, 1), (29, '2026-10-01', 4, '15:30:00', '16:50:00', 4, 1), (30, '2026-10-01', 5, '17:00:00', '18:20:00', 5, 1), (31, '2026-10-05', 1, '15:30:00', '16:50:00', 1, 1), (32, '2026-10-06', 2, '10:00:00', '11:50:00', 2, 1), (33, '2026-10-06', 3, '12:00:00', '13:50:00', 3, 1), (34, '2026-10-06', 4, '15:30:00', '16:50:00', 4, 1), (35, '2026-10-06', 5, '17:00:00', '18:20:00', 5, 1), (36, '2026-10-07', 6, '10:00:00', '11:50:00', 3, 1), (37, '2026-10-07', 1, '15:30:00', '16:50:00', 1, 1), (38, '2026-10-08', 3, '12:00:00', '13:50:00', 3, 1), (39, '2026-10-08', 4, '15:30:00', '16:50:00', 4, 1), (40, '2026-10-08', 5, '17:00:00', '18:20:00', 5, 1); -- -------------------------------------------------------- -- -- Table structure for table `name` -- CREATE TABLE `name` ( `name_id` int(11) NOT NULL, `name` varchar(40) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `name` -- INSERT INTO `name` (`name_id`, `name`) VALUES (1, 'BUAD-281: Managerial Accounting'), (2, 'ACAD-177: Design Toolbox'), (3, 'ACAD-276: Dev II'), (4, 'BUAD-306: Business Finance'), (5, 'ECON-352: Macroeconomics'), (6, 'ACAD-191: Python for ML'); -- -------------------------------------------------------- -- -- Stand-in structure for view `schedule_view` -- (See below for the actual view) -- CREATE TABLE `schedule_view` ( `schedule_id` int(11) ,`date` date ,`start` time ,`end` time ,`location` varchar(15) ,`type` varchar(7) ,`name` varchar(40) ); -- -------------------------------------------------------- -- -- Table structure for table `type` -- CREATE TABLE `type` ( `type_id` int(11) NOT NULL, `type` varchar(7) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `type` -- INSERT INTO `type` (`type_id`, `type`) VALUES (1, 'Lecture'); -- -- Indexes for dumped tables -- -- -- Indexes for table `location` -- ALTER TABLE `location` ADD PRIMARY KEY (`location_id`); -- -- Indexes for table `main` -- ALTER TABLE `main` ADD PRIMARY KEY (`schedule_id`), ADD KEY `location_id` (`location_id`), ADD KEY `name_id` (`name_id`), ADD KEY `type_id` (`type_id`); -- -- Indexes for table `name` -- ALTER TABLE `name` ADD PRIMARY KEY (`name_id`); -- -- Indexes for table `type` -- ALTER TABLE `type` ADD PRIMARY KEY (`type_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `location` -- ALTER TABLE `location` MODIFY `location_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `main` -- ALTER TABLE `main` MODIFY `schedule_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `name` -- ALTER TABLE `name` MODIFY `name_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `type` -- ALTER TABLE `type` MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -------------------------------------------------------- -- -- Structure for view `schedule_view` -- DROP TABLE IF EXISTS `schedule_view`; CREATE ALGORITHM=UNDEFINED DEFINER=`sahilkoc`@`localhost` SQL SECURITY DEFINER VIEW `schedule_view` AS SELECT `main`.`schedule_id` AS `schedule_id`, `main`.`date` AS `date`, `main`.`start` AS `start`, `main`.`end` AS `end`, `location`.`location` AS `location`, `type`.`type` AS `type`, `name`.`name` AS `name` FROM (((`main` join `location`) join `type`) join `name`) WHERE ((`main`.`location_id` = `location`.`location_id`) AND (`main`.`type_id` = `type`.`type_id`) AND (`main`.`name_id` = `name`.`name_id`)) ; -- -- Constraints for dumped tables -- -- -- Constraints for table `main` -- ALTER TABLE `main` ADD CONSTRAINT `main_ibfk_1` FOREIGN KEY (`location_id`) REFERENCES `location` (`location_id`), ADD CONSTRAINT `main_ibfk_2` FOREIGN KEY (`name_id`) REFERENCES `name` (`name_id`), ADD CONSTRAINT `main_ibfk_3` FOREIGN KEY (`type_id`) REFERENCES `type` (`type_id`); 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 */;