-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 21, 2026 at 02:46 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: `mbhou_schedule` -- -- -------------------------------------------------------- -- -- Table structure for table `class_meetings` -- CREATE TABLE `class_meetings` ( `class_ID` int(11) NOT NULL, `name_ID` int(11) NOT NULL, `room_ID` int(11) NOT NULL, `type_ID` int(11) NOT NULL, `meeting_date` date NOT NULL, `start_time` time NOT NULL, `end_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `class_meetings` -- INSERT INTO `class_meetings` (`class_ID`, `name_ID`, `room_ID`, `type_ID`, `meeting_date`, `start_time`, `end_time`) VALUES (1, 2, 2, 1, '2026-08-24', '14:00:00', '15:50:00'), (2, 1, 1, 3, '2026-08-25', '12:00:00', '13:50:00'), (3, 4, 1, 3, '2026-08-25', '16:00:00', '17:50:00'), (4, 5, 1, 3, '2026-08-25', '18:00:00', '19:50:00'), (5, 3, 3, 3, '2026-08-26', '12:00:00', '13:50:00'), (6, 2, 2, 1, '2026-08-26', '14:00:00', '15:50:00'), (7, 1, 1, 3, '2026-08-27', '12:00:00', '13:50:00'), (8, 3, 3, 3, '2026-08-28', '12:00:00', '13:50:00'), (9, 6, 4, 3, '2026-08-28', '15:00:00', '16:50:00'), (10, 2, 2, 1, '2026-08-31', '14:00:00', '15:50:00'), (11, 1, 1, 3, '2026-09-01', '12:00:00', '13:50:00'), (12, 4, 1, 3, '2026-09-01', '16:00:00', '17:50:00'), (13, 5, 1, 3, '2026-09-01', '18:00:00', '19:50:00'), (14, 3, 3, 3, '2026-09-02', '12:00:00', '13:50:00'), (15, 2, 2, 1, '2026-09-02', '14:00:00', '15:50:00'), (16, 1, 1, 3, '2026-09-03', '12:00:00', '13:50:00'), (17, 3, 3, 3, '2026-09-04', '12:00:00', '13:50:00'), (18, 6, 4, 3, '2026-09-04', '15:00:00', '16:50:00'), (19, 2, 2, 1, '2026-09-07', '14:00:00', '15:50:00'), (20, 1, 1, 3, '2026-09-08', '12:00:00', '13:50:00'), (21, 4, 1, 3, '2026-09-08', '16:00:00', '17:50:00'), (22, 5, 1, 3, '2026-09-08', '18:00:00', '19:50:00'), (23, 3, 3, 3, '2026-09-09', '12:00:00', '13:50:00'), (24, 2, 2, 1, '2026-09-09', '14:00:00', '15:50:00'), (25, 1, 1, 3, '2026-09-10', '12:00:00', '13:50:00'), (26, 3, 3, 3, '2026-09-11', '12:00:00', '13:50:00'), (27, 6, 4, 3, '2026-09-11', '15:00:00', '16:50:00'), (28, 2, 2, 1, '2026-09-14', '14:00:00', '15:50:00'), (29, 1, 1, 3, '2026-09-15', '12:00:00', '13:50:00'), (30, 4, 1, 3, '2026-09-15', '16:00:00', '17:50:00'), (31, 5, 1, 3, '2026-09-15', '18:00:00', '19:50:00'), (32, 3, 3, 3, '2026-09-16', '12:00:00', '13:50:00'), (33, 2, 2, 1, '2026-09-16', '14:00:00', '15:50:00'), (34, 1, 1, 3, '2026-09-17', '12:00:00', '13:50:00'), (35, 3, 3, 3, '2026-09-18', '12:00:00', '13:50:00'), (36, 6, 4, 3, '2026-09-18', '15:00:00', '16:50:00'); -- -------------------------------------------------------- -- -- Table structure for table `class_name` -- CREATE TABLE `class_name` ( `name_ID` int(11) NOT NULL, `class_name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `class_name` -- INSERT INTO `class_name` (`name_ID`, `class_name`) VALUES (1, 'ACAD 276: Dev 2'), (2, 'ACAD 324: Practice of Design'), (3, 'ACAD 376: Industry Practicum'), (4, 'ACAD 406: Purpose-Driven Incubator'), (5, 'IDSN 579: Social Media '), (6, 'IDSN 521: Brand Identity for Startups'); -- -------------------------------------------------------- -- -- Table structure for table `class_rooms` -- CREATE TABLE `class_rooms` ( `room_ID` int(11) NOT NULL, `room_name` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `class_rooms` -- INSERT INTO `class_rooms` (`room_ID`, `room_name`) VALUES (1, 'IYH 210/211'), (2, 'IYH 212/213'), (3, 'THH 202'), (4, 'Online'); -- -------------------------------------------------------- -- -- Table structure for table `class_type` -- CREATE TABLE `class_type` ( `type_ID` int(11) NOT NULL, `type_name` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `class_type` -- INSERT INTO `class_type` (`type_ID`, `type_name`) VALUES (1, 'Lecture'), (2, 'Lab'), (3, 'Lecture/Lab'); -- -------------------------------------------------------- -- -- Stand-in structure for view `schedule_view` -- (See below for the actual view) -- CREATE TABLE `schedule_view` ( `schedule_ID` int(11) ,`meeting_date` date ,`start_time` time ,`end_time` time ,`room_name` varchar(30) ,`type_name` varchar(30) ,`class_name` varchar(100) ); -- -- Indexes for dumped tables -- -- -- Indexes for table `class_meetings` -- ALTER TABLE `class_meetings` ADD PRIMARY KEY (`class_ID`), ADD KEY `name_ID` (`name_ID`), ADD KEY `room_ID` (`room_ID`), ADD KEY `type_ID` (`type_ID`); -- -- Indexes for table `class_name` -- ALTER TABLE `class_name` ADD PRIMARY KEY (`name_ID`); -- -- Indexes for table `class_rooms` -- ALTER TABLE `class_rooms` ADD PRIMARY KEY (`room_ID`); -- -- Indexes for table `class_type` -- ALTER TABLE `class_type` ADD PRIMARY KEY (`type_ID`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `class_meetings` -- ALTER TABLE `class_meetings` MODIFY `class_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `class_name` -- ALTER TABLE `class_name` MODIFY `name_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `class_rooms` -- ALTER TABLE `class_rooms` MODIFY `room_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `class_type` -- ALTER TABLE `class_type` MODIFY `type_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -------------------------------------------------------- -- -- Structure for view `schedule_view` -- DROP TABLE IF EXISTS `schedule_view`; CREATE ALGORITHM=UNDEFINED DEFINER=`mbhou`@`localhost` SQL SECURITY DEFINER VIEW `schedule_view` AS SELECT `class_meetings`.`class_ID` AS `schedule_ID`, `class_meetings`.`meeting_date` AS `meeting_date`, `class_meetings`.`start_time` AS `start_time`, `class_meetings`.`end_time` AS `end_time`, `class_rooms`.`room_name` AS `room_name`, `class_type`.`type_name` AS `type_name`, `class_name`.`class_name` AS `class_name` FROM (((`class_meetings` join `class_name`) join `class_rooms`) join `class_type`) WHERE ((`class_meetings`.`name_ID` = `class_name`.`name_ID`) AND (`class_meetings`.`room_ID` = `class_rooms`.`room_ID`) AND (`class_meetings`.`type_ID` = `class_type`.`type_ID`)) ORDER BY `class_meetings`.`meeting_date` ASC, `class_meetings`.`start_time` ASC ; -- -- Constraints for dumped tables -- -- -- Constraints for table `class_meetings` -- ALTER TABLE `class_meetings` ADD CONSTRAINT `class_meetings_ibfk_1` FOREIGN KEY (`name_ID`) REFERENCES `class_name` (`name_ID`), ADD CONSTRAINT `class_meetings_ibfk_2` FOREIGN KEY (`room_ID`) REFERENCES `class_rooms` (`room_ID`), ADD CONSTRAINT `class_meetings_ibfk_3` FOREIGN KEY (`type_ID`) REFERENCES `class_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 */;