-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 30, 2025 at 10:51 AM
-- Server version: 5.7.44
-- PHP Version: 8.1.31

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: `ttshim_schedule`
--

-- --------------------------------------------------------

--
-- Table structure for table `ClassNameID`
--

CREATE TABLE `ClassNameID` (
  `ClassNameID` int(11) NOT NULL,
  `Class Name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ClassNameID`
--

INSERT INTO `ClassNameID` (`ClassNameID`, `Class Name`) VALUES
(1, 'CTAN504 Virtual Reality Production'),
(2, 'ACAD230 Physical Computing'),
(3, 'ACAD276 Dev 2'),
(4, 'ACAD309 Dreams and Madness: The Art of Japan\'s Golden Age of Animation'),
(5, 'IDSN599 Social Media Incubator');

-- --------------------------------------------------------

--
-- Table structure for table `Lecture/Lab`
--

CREATE TABLE `Lecture/Lab` (
  `Lecture/LabID` int(11) NOT NULL,
  `Lecture/Lab` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Lecture/Lab`
--

INSERT INTO `Lecture/Lab` (`Lecture/LabID`, `Lecture/Lab`) VALUES
(1, 'Lecture'),
(2, 'Lab');

-- --------------------------------------------------------

--
-- Table structure for table `LocationID`
--

CREATE TABLE `LocationID` (
  `LocationID` int(11) NOT NULL,
  `Location` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `LocationID`
--

INSERT INTO `LocationID` (`LocationID`, `Location`) VALUES
(1, 'RZC117'),
(2, 'IYH110'),
(3, 'IYH210'),
(4, 'SLH100'),
(5, 'IYH212/213');

-- --------------------------------------------------------

--
-- Table structure for table `schedule`
--

CREATE TABLE `schedule` (
  `Date` date NOT NULL,
  `Start Time` time NOT NULL,
  `End Time` time NOT NULL,
  `LocationID` int(11) NOT NULL,
  `Lecture/LabID` int(11) NOT NULL,
  `ClassNameID` int(11) NOT NULL,
  `ID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `schedule`
--

INSERT INTO `schedule` (`Date`, `Start Time`, `End Time`, `LocationID`, `Lecture/LabID`, `ClassNameID`, `ID`) VALUES
('2025-09-09', '09:00:00', '11:50:00', 1, 1, 1, 1),
('2025-09-16', '09:00:00', '11:50:00', 1, 1, 1, 2),
('2025-09-23', '09:00:00', '11:50:00', 1, 1, 1, 3),
('2025-09-30', '09:00:00', '11:50:00', 1, 1, 1, 4),
('2025-09-12', '10:00:00', '12:50:00', 1, 2, 1, 5),
('2025-09-19', '10:00:00', '12:50:00', 1, 2, 1, 6),
('2025-09-26', '10:00:00', '12:50:00', 1, 2, 1, 7),
('2025-10-03', '10:00:00', '12:50:00', 1, 2, 1, 8),
('2025-09-10', '14:00:00', '15:50:00', 5, 1, 5, 9),
('2025-09-17', '14:00:00', '15:50:00', 5, 1, 5, 10),
('2025-09-24', '14:00:00', '15:50:00', 5, 1, 5, 11),
('2025-10-01', '14:00:00', '15:50:00', 5, 1, 5, 12),
('2025-09-09', '16:00:00', '18:50:00', 4, 1, 4, 13),
('2025-09-16', '16:00:00', '18:50:00', 4, 1, 4, 14),
('2025-09-23', '16:00:00', '18:50:00', 4, 1, 4, 15),
('2025-09-30', '16:00:00', '18:50:00', 4, 1, 4, 16),
('2025-09-09', '12:00:00', '13:50:00', 2, 1, 2, 17),
('2025-09-16', '12:00:00', '13:50:00', 2, 1, 2, 18),
('2025-09-23', '12:00:00', '13:50:00', 2, 1, 2, 19),
('2025-09-30', '12:00:00', '13:50:00', 2, 1, 2, 20),
('2025-09-11', '12:00:00', '13:50:00', 2, 1, 2, 21),
('2025-09-18', '12:00:00', '13:50:00', 2, 1, 2, 22),
('2025-09-25', '12:00:00', '13:50:00', 2, 1, 2, 23),
('2025-10-02', '12:00:00', '13:50:00', 2, 1, 2, 24),
('2025-09-09', '14:00:00', '15:50:00', 3, 1, 3, 25),
('2025-09-16', '14:00:00', '15:50:00', 3, 1, 3, 26),
('2025-09-23', '14:00:00', '15:50:00', 3, 1, 3, 27),
('2025-09-30', '14:00:00', '15:50:00', 3, 1, 3, 28),
('2025-09-11', '14:00:00', '15:50:00', 3, 1, 3, 29),
('2025-09-18', '14:00:00', '15:50:00', 3, 1, 3, 30),
('2025-09-25', '14:00:00', '15:50:00', 3, 1, 3, 31),
('2025-10-02', '14:00:00', '15:50:00', 3, 1, 3, 32);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ClassNameID`
--
ALTER TABLE `ClassNameID`
  ADD PRIMARY KEY (`ClassNameID`);

--
-- Indexes for table `Lecture/Lab`
--
ALTER TABLE `Lecture/Lab`
  ADD PRIMARY KEY (`Lecture/LabID`);

--
-- Indexes for table `LocationID`
--
ALTER TABLE `LocationID`
  ADD PRIMARY KEY (`LocationID`);

--
-- Indexes for table `schedule`
--
ALTER TABLE `schedule`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `ClassNameID` (`ClassNameID`),
  ADD KEY `Lecture/LabID` (`Lecture/LabID`),
  ADD KEY `schedule_ibfk_3` (`LocationID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ClassNameID`
--
ALTER TABLE `ClassNameID`
  MODIFY `ClassNameID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `Lecture/Lab`
--
ALTER TABLE `Lecture/Lab`
  MODIFY `Lecture/LabID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `LocationID`
--
ALTER TABLE `LocationID`
  MODIFY `LocationID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `schedule`
--
ALTER TABLE `schedule`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `schedule`
--
ALTER TABLE `schedule`
  ADD CONSTRAINT `schedule_ibfk_1` FOREIGN KEY (`ClassNameID`) REFERENCES `ClassNameID` (`ClassNameID`) ON UPDATE CASCADE,
  ADD CONSTRAINT `schedule_ibfk_2` FOREIGN KEY (`Lecture/LabID`) REFERENCES `Lecture/Lab` (`Lecture/LabID`) ON UPDATE CASCADE,
  ADD CONSTRAINT `schedule_ibfk_3` FOREIGN KEY (`LocationID`) REFERENCES `LocationID` (`LocationID`) ON UPDATE CASCADE;
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 */;
