-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 23, 2026 at 11:57 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: `gladysyu_schedule` -- -- -------------------------------------------------------- -- -- Table structure for table `courses` -- CREATE TABLE `courses` ( `course_id` int(11) NOT NULL, `course_code` varchar(20) NOT NULL, `course_name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `courses` -- INSERT INTO `courses` (`course_id`, `course_code`, `course_name`) VALUES (1, 'ACAD 185', 'Analytics and Marketing for Challenge-Based Innovation'), (2, 'ACAD 276', 'Dev II'), (3, 'IDSN 533', 'iOS Application and Development'), (4, 'IDSN 579', 'Social Media Incubator: Data-Driven Growth for Founders'), (5, 'MOR 454', 'Applied Product Management and Leadership'); -- -------------------------------------------------------- -- -- Table structure for table `meetings` -- CREATE TABLE `meetings` ( `meeting_id` int(11) NOT NULL, `meeting_date` date NOT NULL, `start_time` time NOT NULL, `end_time` time NOT NULL, `location` varchar(50) NOT NULL, `course_id` int(11) NOT NULL, `type_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `meetings` -- INSERT INTO `meetings` (`meeting_id`, `meeting_date`, `start_time`, `end_time`, `location`, `course_id`, `type_id`) VALUES (1, '2026-09-01', '10:00:00', '12:00:00', 'IYH 210/211', 1, 1), (2, '2026-09-01', '12:00:00', '14:00:00', 'IYH 210/211', 2, 3), (3, '2026-09-01', '16:00:00', '18:00:00', 'IYH 110', 3, 3), (4, '2026-09-01', '18:00:00', '20:00:00', 'IYH 210/211', 4, 1), (5, '2026-09-02', '14:00:00', '17:30:00', 'BRI 5', 5, 1), (6, '2026-09-03', '10:00:00', '12:00:00', 'IYH 210/211', 1, 1), (7, '2026-09-03', '12:00:00', '14:00:00', 'IYH 210/211', 2, 3), (8, '2026-09-03', '16:00:00', '18:00:00', 'IYH 110', 3, 3), (9, '2026-09-08', '10:00:00', '12:00:00', 'IYH 210/211', 1, 1), (10, '2026-09-08', '12:00:00', '14:00:00', 'IYH 210/211', 2, 3), (11, '2026-09-08', '16:00:00', '18:00:00', 'IYH 110', 3, 3), (12, '2026-09-08', '18:00:00', '20:00:00', 'IYH 210/211', 4, 1), (13, '2026-09-09', '14:00:00', '17:30:00', 'BRI 5', 5, 1), (14, '2026-09-10', '10:00:00', '12:00:00', 'IYH 210/211', 1, 1), (15, '2026-09-10', '12:00:00', '14:00:00', 'IYH 210/211', 2, 3), (16, '2026-09-10', '16:00:00', '18:00:00', 'IYH 110', 3, 3), (17, '2026-09-15', '10:00:00', '12:00:00', 'IYH 210/211', 1, 1), (18, '2026-09-15', '12:00:00', '14:00:00', 'IYH 210/211', 2, 3), (19, '2026-09-15', '16:00:00', '18:00:00', 'IYH 110', 3, 3), (20, '2026-09-15', '18:00:00', '20:00:00', 'IYH 210/211', 4, 1), (21, '2026-09-16', '14:00:00', '17:30:00', 'BRI 5', 5, 1), (22, '2026-09-17', '10:00:00', '12:00:00', 'IYH 210/211', 1, 1), (23, '2026-09-17', '12:00:00', '14:00:00', 'IYH 210/211', 2, 3), (24, '2026-09-17', '16:00:00', '18:00:00', 'IYH 110', 3, 3), (25, '2026-09-22', '10:00:00', '12:00:00', 'IYH 210/211', 1, 1), (26, '2026-09-22', '12:00:00', '14:00:00', 'IYH 210/211', 2, 3), (27, '2026-09-22', '16:00:00', '18:00:00', 'IYH 110', 3, 3), (28, '2026-09-22', '18:00:00', '20:00:00', 'IYH 210/211', 4, 1), (29, '2026-09-23', '14:00:00', '17:30:00', 'BRI 5', 5, 1), (30, '2026-09-24', '10:00:00', '12:00:00', 'IYH 210/211', 1, 1), (31, '2026-09-24', '12:00:00', '14:00:00', 'IYH 210/211', 2, 3), (32, '2026-09-24', '16:00:00', '18:00:00', 'IYH 110', 3, 3); -- -------------------------------------------------------- -- -- Table structure for table `meeting_types` -- CREATE TABLE `meeting_types` ( `type_id` int(11) NOT NULL, `type_name` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `meeting_types` -- INSERT INTO `meeting_types` (`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` ( `meeting_id` int(11) ,`meeting_date` date ,`start_time` time ,`end_time` time ,`location` varchar(50) ,`meeting_type` varchar(30) ,`course_code` varchar(20) ,`course_name` varchar(100) ); -- -- Indexes for dumped tables -- -- -- Indexes for table `courses` -- ALTER TABLE `courses` ADD PRIMARY KEY (`course_id`); -- -- Indexes for table `meetings` -- ALTER TABLE `meetings` ADD PRIMARY KEY (`meeting_id`), ADD KEY `course_id` (`course_id`), ADD KEY `type_id` (`type_id`); -- -- Indexes for table `meeting_types` -- ALTER TABLE `meeting_types` ADD PRIMARY KEY (`type_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `courses` -- ALTER TABLE `courses` MODIFY `course_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `meetings` -- ALTER TABLE `meetings` MODIFY `meeting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `meeting_types` -- ALTER TABLE `meeting_types` 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=`gladysyu`@`localhost` SQL SECURITY DEFINER VIEW `schedule_view` AS SELECT `meetings`.`meeting_id` AS `meeting_id`, `meetings`.`meeting_date` AS `meeting_date`, `meetings`.`start_time` AS `start_time`, `meetings`.`end_time` AS `end_time`, `meetings`.`location` AS `location`, `meeting_types`.`type_name` AS `meeting_type`, `courses`.`course_code` AS `course_code`, `courses`.`course_name` AS `course_name` FROM ((`meetings` join `courses` on((`meetings`.`course_id` = `courses`.`course_id`))) join `meeting_types` on((`meetings`.`type_id` = `meeting_types`.`type_id`))) ORDER BY `meetings`.`meeting_date` ASC, `meetings`.`start_time` ASC ; -- -- Constraints for dumped tables -- -- -- Constraints for table `meetings` -- ALTER TABLE `meetings` ADD CONSTRAINT `meetings_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`), ADD CONSTRAINT `meetings_ibfk_2` FOREIGN KEY (`type_id`) REFERENCES `meeting_types` (`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 */;