-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 24, 2026 at 01:24 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: `saniyap_fallschedule` -- -- -------------------------------------------------------- -- -- Table structure for table `classMeetings` -- CREATE TABLE `classMeetings` ( `meetingID` int(11) NOT NULL, `courseID` int(11) NOT NULL, `typeID` int(11) NOT NULL, `locationID` int(11) NOT NULL, `meetingDate` date NOT NULL, `startTime` time NOT NULL, `endTime` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `classMeetings` -- INSERT INTO `classMeetings` (`meetingID`, `courseID`, `typeID`, `locationID`, `meetingDate`, `startTime`, `endTime`) VALUES (1, 4, 2, 4, '2026-09-14', '09:30:00', '10:50:00'), (2, 5, 2, 5, '2026-09-14', '11:00:00', '11:50:00'), (3, 1, 1, 1, '2026-09-15', '12:00:00', '13:50:00'), (4, 3, 2, 3, '2026-09-15', '18:00:00', '19:50:00'), (5, 4, 2, 4, '2026-09-16', '09:30:00', '10:50:00'), (6, 5, 2, 5, '2026-09-16', '11:00:00', '11:50:00'), (7, 2, 2, 2, '2026-09-16', '12:00:00', '13:50:00'), (8, 1, 1, 1, '2026-09-17', '12:00:00', '13:50:00'), (9, 5, 2, 5, '2026-09-18', '11:00:00', '11:50:00'), (10, 2, 2, 2, '2026-09-18', '12:00:00', '13:50:00'), (11, 4, 2, 4, '2026-09-21', '09:30:00', '10:50:00'), (12, 5, 2, 5, '2026-09-21', '11:00:00', '11:50:00'), (13, 1, 1, 1, '2026-09-22', '12:00:00', '13:50:00'), (14, 3, 2, 3, '2026-09-22', '18:00:00', '19:50:00'), (15, 4, 2, 4, '2026-09-23', '09:30:00', '10:50:00'), (16, 5, 2, 5, '2026-09-23', '11:00:00', '11:50:00'), (17, 2, 2, 2, '2026-09-23', '12:00:00', '13:50:00'), (18, 1, 1, 1, '2026-09-24', '12:00:00', '13:50:00'), (19, 5, 2, 5, '2026-09-25', '11:00:00', '11:50:00'), (20, 2, 2, 2, '2026-09-25', '12:00:00', '13:50:00'), (21, 4, 2, 4, '2026-09-28', '09:30:00', '10:50:00'), (22, 5, 2, 5, '2026-09-28', '11:00:00', '11:50:00'), (23, 1, 1, 1, '2026-09-29', '12:00:00', '13:50:00'), (24, 3, 2, 3, '2026-09-29', '18:00:00', '19:50:00'), (25, 4, 2, 4, '2026-09-30', '09:30:00', '10:50:00'), (26, 5, 2, 5, '2026-09-30', '11:00:00', '11:50:00'), (27, 2, 2, 2, '2026-09-30', '12:00:00', '13:50:00'), (28, 1, 1, 1, '2026-10-01', '12:00:00', '13:50:00'), (29, 5, 2, 5, '2026-10-02', '11:00:00', '11:50:00'), (30, 2, 2, 2, '2026-10-02', '12:00:00', '13:50:00'), (31, 4, 2, 4, '2026-10-05', '09:30:00', '10:50:00'), (32, 5, 2, 5, '2026-10-05', '11:00:00', '11:50:00'), (33, 1, 1, 1, '2026-10-06', '12:00:00', '13:50:00'), (34, 3, 2, 3, '2026-10-06', '18:00:00', '19:50:00'), (35, 4, 2, 4, '2026-10-07', '09:30:00', '10:50:00'), (36, 5, 2, 5, '2026-10-07', '11:00:00', '11:50:00'), (37, 2, 2, 2, '2026-10-07', '12:00:00', '13:50:00'), (38, 1, 1, 1, '2026-10-08', '12:00:00', '13:50:00'), (39, 5, 2, 5, '2026-10-09', '11:00:00', '11:50:00'), (40, 2, 2, 2, '2026-10-09', '12:00:00', '13:50:00'); -- -------------------------------------------------------- -- -- Table structure for table `courses` -- CREATE TABLE `courses` ( `courseId` int(11) NOT NULL, `courseCode` varchar(10) NOT NULL, `courseTitle` varchar(150) NOT NULL, `instructor` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `courses` -- INSERT INTO `courses` (`courseId`, `courseCode`, `courseTitle`, `instructor`) VALUES (1, 'ACAD-276', 'Dev II', 'Dent, Patrick'), (2, 'ACAD-376', 'Industry Practicum I: Designing and Implementing Real-World Solutions', 'Lim, Yihyun / Dadourian, Thomas'), (3, 'DANC-185A', 'Hip Hop Dance', 'Grimes, d. Sabela'), (4, 'FBE-421', 'Financial Analysis and Valuation', 'Plotts, Julia'), (5, 'WRIT-340', 'Advanced Writing and Critical Engagement', 'Bankard, Jennifer'); -- -------------------------------------------------------- -- -- Table structure for table `location` -- CREATE TABLE `location` ( `locationID` int(11) NOT NULL, `buildingRoom` varchar(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `location` -- INSERT INTO `location` (`locationID`, `buildingRoom`) VALUES (1, 'IYH210/211'), (2, 'THH202'), (3, 'KDC106'), (4, 'JKP110'), (5, 'GFS108'); -- -------------------------------------------------------- -- -- Table structure for table `meetingTypes` -- CREATE TABLE `meetingTypes` ( `typeId` int(11) NOT NULL, `typeName` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `meetingTypes` -- INSERT INTO `meetingTypes` (`typeId`, `typeName`) VALUES (1, 'Lecture'), (2, 'Lecture-Lab'); -- -------------------------------------------------------- -- -- Stand-in structure for view `schedule_view` -- (See below for the actual view) -- CREATE TABLE `schedule_view` ( `meetingDate` date ,`startTime` time ,`endTime` time ,`buildingRoom` varchar(10) ,`typeName` varchar(20) ,`courseCode` varchar(10) ,`courseTitle` varchar(150) ,`meetingID` int(11) ); -- -- Indexes for dumped tables -- -- -- Indexes for table `classMeetings` -- ALTER TABLE `classMeetings` ADD PRIMARY KEY (`meetingID`), ADD KEY `courseID` (`courseID`), ADD KEY `typeID` (`typeID`), ADD KEY `locationID` (`locationID`); -- -- Indexes for table `courses` -- ALTER TABLE `courses` ADD PRIMARY KEY (`courseId`); -- -- Indexes for table `location` -- ALTER TABLE `location` ADD PRIMARY KEY (`locationID`); -- -- Indexes for table `meetingTypes` -- ALTER TABLE `meetingTypes` ADD PRIMARY KEY (`typeId`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `classMeetings` -- ALTER TABLE `classMeetings` MODIFY `meetingID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `courses` -- ALTER TABLE `courses` MODIFY `courseId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `location` -- ALTER TABLE `location` MODIFY `locationID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `meetingTypes` -- ALTER TABLE `meetingTypes` MODIFY `typeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -------------------------------------------------------- -- -- Structure for view `schedule_view` -- DROP TABLE IF EXISTS `schedule_view`; CREATE ALGORITHM=UNDEFINED DEFINER=`saniyap`@`localhost` SQL SECURITY DEFINER VIEW `schedule_view` AS SELECT `classMeetings`.`meetingDate` AS `meetingDate`, `classMeetings`.`startTime` AS `startTime`, `classMeetings`.`endTime` AS `endTime`, `location`.`buildingRoom` AS `buildingRoom`, `meetingTypes`.`typeName` AS `typeName`, `courses`.`courseCode` AS `courseCode`, `courses`.`courseTitle` AS `courseTitle`, `classMeetings`.`meetingID` AS `meetingID` FROM (((`classMeetings` join `courses` on((`classMeetings`.`courseID` = `courses`.`courseId`))) join `meetingTypes` on((`classMeetings`.`typeID` = `meetingTypes`.`typeId`))) join `location` on((`classMeetings`.`locationID` = `location`.`locationID`))) ; -- -- Constraints for dumped tables -- -- -- Constraints for table `classMeetings` -- ALTER TABLE `classMeetings` ADD CONSTRAINT `classMeetings_ibfk_1` FOREIGN KEY (`courseID`) REFERENCES `courses` (`courseId`), ADD CONSTRAINT `classMeetings_ibfk_2` FOREIGN KEY (`typeID`) REFERENCES `meetingTypes` (`typeId`), ADD CONSTRAINT `classMeetings_ibfk_3` FOREIGN KEY (`locationID`) REFERENCES `location` (`locationID`); 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 */;