-- MySQL dump 10.13  Distrib 8.0.26, for Win64 (x86_64)
--
-- Host: hanyu-db.mysql.database.azure.com    Database: nsysu_booking
-- ------------------------------------------------------
-- Server version	8.0.40-azure

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `reservations`
--

DROP TABLE IF EXISTS `reservations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reservations` (
  `reservation_id` int NOT NULL AUTO_INCREMENT COMMENT '預約ID',
  `room_id` int NOT NULL COMMENT '會議室ID',
  `user_id` int NOT NULL COMMENT '預約人ID',
  `room_no` varchar(100) DEFAULT NULL COMMENT '教室代號',
  `title` varchar(100) NOT NULL COMMENT '會議標題',
  `description` varchar(500) DEFAULT NULL COMMENT '會議說明',
  `start_time` datetime NOT NULL COMMENT '開始時間',
  `end_time` datetime NOT NULL COMMENT '結束時間',
  `is_recurring` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否為周期性會議',
  `recurrence_type` varchar(30) DEFAULT NULL COMMENT '周期類型ENUM(''daily'', ''weekly'', ''monthly'', ''custom'')',
  `recurrence_pattern` varchar(100) DEFAULT NULL COMMENT '周期模式(例如: 每週一三五/每月1號/每月第一個星期一)',
  `recurrence_end_date` date DEFAULT NULL COMMENT '週期結束日期',
  `slot_name` varchar(100) DEFAULT NULL COMMENT '時段名稱',
  `borrower` varchar(100) DEFAULT NULL COMMENT '借用人',
  `status` varchar(30) NOT NULL DEFAULT 'pending' COMMENT '預約狀態ENUM(''pending'', ''approved'', ''rejected'', ''cancelled'', ''completed'')',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  `updated_by` varchar(100) DEFAULT NULL COMMENT '更新人員',
  `root_id` int DEFAULT '0' COMMENT '預約ID-表頭',
  PRIMARY KEY (`reservation_id`),
  KEY `room_id` (`room_id`),
  KEY `user_id` (`user_id`),
  KEY `root_id` (`root_id`),
  CONSTRAINT `reservations_ibfk_1` FOREIGN KEY (`room_id`) REFERENCES `meeting_rooms` (`room_id`),
  CONSTRAINT `reservations_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=258 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='會議預約記錄';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reservations`
--

LOCK TABLES `reservations` WRITE;
/*!40000 ALTER TABLE `reservations` DISABLE KEYS */;
INSERT INTO `reservations` VALUES (1,5,2,'國5015','我愛華語aa','','2025-03-13 14:10:00','2025-03-13 15:00:00',1,'weekly','每週週四','2025-03-26','第6節','系辦','approved','2025-03-14 11:21:08','2025-03-12 10:28:50','u01',1),(2,5,2,'國5015','我愛華語aa','','2025-03-20 14:10:00','2025-03-20 15:00:00',1,'weekly','每週週四','2025-03-26','第6節','系辦','approved','2025-03-14 11:21:08','2025-03-12 10:28:50','u01',1),(47,1,1,'國4006-2','菲律賓團','','2025-04-29 09:10:00','2025-04-29 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:34','u01',47),(51,1,1,'國4006-2','菲律賓團','','2025-04-30 09:10:00','2025-04-30 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(52,1,1,'國4006-2','菲律賓團','','2025-05-01 09:10:00','2025-05-01 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(53,1,1,'國4006-2','菲律賓團','','2025-05-02 09:10:00','2025-05-02 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(54,1,1,'國4006-2','菲律賓團','','2025-05-05 09:10:00','2025-05-05 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(55,1,1,'國4006-2','菲律賓團','','2025-05-06 09:10:00','2025-05-06 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(56,1,1,'國4006-2','菲律賓團','','2025-05-07 09:10:00','2025-05-07 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(57,1,1,'國4006-2','菲律賓團','','2025-05-08 09:10:00','2025-05-08 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(58,1,1,'國4006-2','菲律賓團','','2025-05-09 09:10:00','2025-05-09 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(59,1,1,'國4006-2','菲律賓團','','2025-05-12 09:10:00','2025-05-12 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(60,1,1,'國4006-2','菲律賓團','','2025-05-13 09:10:00','2025-05-13 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(61,1,1,'國4006-2','菲律賓團','','2025-05-14 09:10:00','2025-05-14 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(62,1,1,'國4006-2','菲律賓團','','2025-05-15 09:10:00','2025-05-15 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(63,1,1,'國4006-2','菲律賓團','','2025-05-16 09:10:00','2025-05-16 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(64,1,1,'國4006-2','菲律賓團','','2025-05-19 09:10:00','2025-05-19 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(65,1,1,'國4006-2','菲律賓團','','2025-05-20 09:10:00','2025-05-20 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(66,1,1,'國4006-2','菲律賓團','','2025-05-21 09:10:00','2025-05-21 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-22','','CLC','approved','2025-03-14 11:31:41','2025-03-13 18:03:35','u01',47),(77,6,1,'國4006-1','商務中文','','2025-02-19 09:10:00','2025-02-19 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 13:13:34','2025-03-14 13:13:34','u01',77),(78,2,1,'國4006-1','商務中文','','2025-02-26 09:10:00','2025-02-26 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:02:12','2025-03-14 13:13:34','u01',77),(79,6,1,'國4006-1','商務中文','','2025-03-05 09:10:00','2025-03-05 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 13:13:34','2025-03-14 13:13:34','u01',77),(80,2,1,'國4006-1','商務中文','','2025-03-12 09:10:00','2025-03-12 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:00:54','2025-03-14 13:13:34','u01',77),(81,2,1,'國4006-1','商務中文','','2025-03-19 09:10:00','2025-03-19 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(82,2,1,'國4006-1','商務中文','','2025-03-26 09:10:00','2025-03-26 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(83,2,1,'國4006-1','商務中文','','2025-04-02 09:10:00','2025-04-02 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(84,2,1,'國4006-1','商務中文','','2025-04-09 09:10:00','2025-04-09 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(85,2,1,'國4006-1','商務中文','','2025-04-16 09:10:00','2025-04-16 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(86,2,1,'國4006-1','商務中文','','2025-04-23 09:10:00','2025-04-23 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(87,2,1,'國4006-1','商務中文','','2025-04-30 09:10:00','2025-04-30 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(88,2,1,'國4006-1','商務中文','','2025-05-07 09:10:00','2025-05-07 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(89,2,1,'國4006-1','商務中文','','2025-05-14 09:10:00','2025-05-14 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(90,2,1,'國4006-1','商務中文','','2025-05-21 09:10:00','2025-05-21 12:00:00',1,'weekly','每週週三','2025-05-28','','蔡淑芬','approved','2025-03-14 14:01:09','2025-03-14 13:13:34','u01',77),(209,3,1,'國5013','TEST','','2025-03-24 09:00:00','2025-03-24 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(210,3,1,'國5013','TEST','','2025-03-25 09:00:00','2025-03-25 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(211,3,1,'國5013','TEST','','2025-03-26 09:00:00','2025-03-26 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(212,3,1,'國5013','TEST','','2025-03-27 09:00:00','2025-03-27 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(213,3,1,'國5013','TEST','','2025-03-28 09:00:00','2025-03-28 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(214,3,1,'國5013','TEST','','2025-03-31 09:00:00','2025-03-31 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(215,3,1,'國5013','TEST','','2025-04-01 09:00:00','2025-04-01 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(219,3,1,'國5013','TEST','','2025-04-07 09:00:00','2025-04-07 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(220,3,1,'國5013','TEST','','2025-04-08 09:00:00','2025-04-08 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(221,3,1,'國5013','TEST','','2025-04-09 09:00:00','2025-04-09 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(222,3,1,'國5013','TEST','','2025-04-10 09:00:00','2025-04-10 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(223,3,1,'國5013','TEST','','2025-04-11 09:00:00','2025-04-11 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(224,3,1,'國5013','TEST','','2025-04-14 09:00:00','2025-04-14 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(225,3,1,'國5013','TEST','','2025-04-15 09:00:00','2025-04-15 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(226,3,1,'國5013','TEST','','2025-04-16 09:00:00','2025-04-16 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(227,3,1,'國5013','TEST','','2025-04-17 09:00:00','2025-04-17 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(228,3,1,'國5013','TEST','','2025-04-18 09:00:00','2025-04-18 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(229,3,1,'國5013','TEST','','2025-04-21 09:00:00','2025-04-21 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(230,3,1,'國5013','TEST','','2025-04-22 09:00:00','2025-04-22 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(231,3,1,'國5013','TEST','','2025-04-23 09:00:00','2025-04-23 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(232,3,1,'國5013','TEST','','2025-04-24 09:00:00','2025-04-24 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(233,3,1,'國5013','TEST','','2025-04-25 09:00:00','2025-04-25 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(234,3,1,'國5013','TEST','','2025-04-28 09:00:00','2025-04-28 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(235,3,1,'國5013','TEST','','2025-04-29 09:00:00','2025-04-29 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(236,3,1,'國5013','TEST','','2025-04-30 09:00:00','2025-04-30 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(237,3,1,'國5013','TEST','','2025-05-01 09:00:00','2025-05-01 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(238,3,1,'國5013','TEST','','2025-05-02 09:00:00','2025-05-02 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(239,3,1,'國5013','TEST','','2025-05-05 09:00:00','2025-05-05 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(240,3,1,'國5013','TEST','','2025-05-06 09:00:00','2025-05-06 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(241,3,1,'國5013','TEST','','2025-05-07 09:00:00','2025-05-07 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(242,3,1,'國5013','TEST','','2025-05-08 09:00:00','2025-05-08 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(243,3,1,'國5013','TEST','','2025-05-09 09:00:00','2025-05-09 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(244,3,1,'國5013','TEST','','2025-05-12 09:00:00','2025-05-12 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(245,3,1,'國5013','TEST','','2025-05-13 09:00:00','2025-05-13 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(246,3,1,'國5013','TEST','','2025-05-14 09:00:00','2025-05-14 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(247,3,1,'國5013','TEST','','2025-05-15 09:00:00','2025-05-15 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(248,3,1,'國5013','TEST','','2025-05-16 09:00:00','2025-05-16 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(249,3,1,'國5013','TEST','','2025-05-19 09:00:00','2025-05-19 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(250,3,1,'國5013','TEST','','2025-05-20 09:00:00','2025-05-20 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(251,3,1,'國5013','TEST','','2025-05-21 09:00:00','2025-05-21 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(252,3,1,'國5013','TEST','','2025-05-22 09:00:00','2025-05-22 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(253,3,1,'國5013','TEST','','2025-05-23 09:00:00','2025-05-23 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(254,3,1,'國5013','TEST','','2025-05-26 09:00:00','2025-05-26 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(255,3,1,'國5013','TEST','','2025-05-27 09:00:00','2025-05-27 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(256,3,1,'國5013','TEST','','2025-05-28 09:00:00','2025-05-28 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209),(257,3,1,'國5013','TEST','','2025-05-29 09:00:00','2025-05-29 12:00:00',1,'weekly','每週週一、週二、週三、週四、週五','2025-05-30','','CLC','approved','2025-03-24 14:57:59','2025-03-24 14:57:59','u01',209);
/*!40000 ALTER TABLE `reservations` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-04-08 13:54:32
