สร้างตารางเรียน ตารางเวลา schedule ด้วย php อัพเดทปี 2020

--
-- Table structure for table `tbl_schedule`
--

CREATE TABLE `tbl_schedule` (
  `schedule_id` int(11) NOT NULL,
  `schedule_title` varchar(256) NOT NULL,
  `schedule_detail` text NOT NULL,
  `schedule_room` varchar(150) NOT NULL,
  `schedule_building` varchar(150) NOT NULL,
  `schedule_startdate` date NOT NULL,
  `schedule_enddate` date NOT NULL,
  `schedule_starttime` time NOT NULL,
  `schedule_endtime` time NOT NULL,
  `schedule_repeatday` varchar(20) NOT NULL,
  `schedule_createdate` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_schedule`
--
ALTER TABLE `tbl_schedule`
  MODIFY `schedule_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;