-- MySQL dump 10.13  Distrib 8.0.45, for Linux (x86_64)
--
-- Host: localhost    Database: onlineleave
-- ------------------------------------------------------
-- Server version	8.0.45-0ubuntu0.22.04.1

/*!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 utf8mb4 */;
/*!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 `calendar`
--

DROP TABLE IF EXISTS `calendar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `calendar` (
  `calendar_id` int NOT NULL AUTO_INCREMENT,
  `calendar_year` varchar(4) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `calendar_date` date NOT NULL,
  `calendar_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `calendar_remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`calendar_id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calendar`
--

LOCK TABLES `calendar` WRITE;
/*!40000 ALTER TABLE `calendar` DISABLE KEYS */;
INSERT INTO `calendar` VALUES (1,'2023','2023-01-02','New Year\'s Day (Substitution Day for 1 January 2023)',NULL,'2025-06-13 15:21:53','2025-06-13 15:22:02'),(2,'2023','2023-03-06','Makha Bucha Day',NULL,'2025-06-13 15:26:45','2025-06-13 15:26:45'),(3,'2023','2023-04-06','Chakri Memorial Day',NULL,'2025-06-13 15:28:02','2025-06-13 15:28:02'),(4,'2023','2023-04-13','Songkran Festival Day',NULL,'2025-06-13 15:28:34','2025-06-13 15:28:34'),(5,'2023','2023-04-14','Songkran Festival Day',NULL,'2025-06-13 15:28:48','2025-06-13 15:28:48'),(6,'2023','2023-04-17','Songkran Festival Day',NULL,'2025-06-13 15:28:59','2025-06-13 15:28:59'),(7,'2023','2023-05-04','Coronation Day',NULL,'2025-06-13 15:29:23','2025-06-13 15:29:23'),(8,'2023','2023-05-17','Royal Ploughing Ceremony Day',NULL,'2025-06-13 15:29:44','2025-06-13 15:29:44'),(9,'2023','2023-06-05','Visakha Bucha Day and Her Majesty the Queen\\\\\\\'s Birthday',NULL,'2025-06-13 15:30:36','2025-06-13 15:30:36'),(10,'2023','2023-07-28','H.M. The King\\\'s Birthday',NULL,'2025-06-13 15:30:59','2025-06-13 15:31:05'),(11,'2023','2023-08-01','Asarnha Bucha Day',NULL,'2025-06-13 15:31:39','2025-06-13 15:31:39'),(12,'2023','2023-08-02','Buddhist Lent Day',NULL,'2025-06-13 15:32:07','2025-06-13 15:32:07'),(13,'2023','2023-08-14','National Mother\\\'s Day',NULL,'2025-06-13 15:33:03','2025-06-13 15:33:03'),(14,'2023','2023-10-13','King Bhumibol Memorial Day',NULL,'2025-06-13 15:33:46','2025-06-13 15:33:46'),(15,'2023','2023-10-23','King Chulalongkorn Memorial Day',NULL,'2025-06-13 15:34:14','2025-06-13 15:34:14'),(16,'2023','2023-12-05','National Father\\\'s Day',NULL,'2025-06-13 15:34:46','2025-06-13 15:34:46'),(17,'2023','2023-12-11','Constitution Day',NULL,'2025-06-13 15:35:03','2025-06-13 15:35:03'),(18,'2024','2024-01-01','New Year\'s Day',NULL,'2025-06-13 15:36:30','2025-06-17 09:24:14'),(21,'2024','2024-02-26','Makha Bucha Day (Substitution Day for 24 February 2024)',NULL,'2025-06-13 15:38:05','2025-06-13 15:38:05'),(22,'2024','2024-04-08','Chakri Memorial Day (Substitution Day for 6 April 2024)',NULL,'2025-06-13 15:38:24','2025-06-13 15:38:24'),(23,'2024','2024-04-15','Songkran Festival Day',NULL,'2025-06-13 15:38:41','2025-06-13 15:38:41'),(24,'2024','2024-04-16','Songkran Festival Day (Substitution Day for 13-14 April 2024)',NULL,'2025-06-13 15:39:08','2025-06-13 15:39:08'),(25,'2024','2024-05-06','Coronation Day (Substitution Day for 4 May 2024)',NULL,'2025-06-13 15:39:45','2025-06-13 15:39:45'),(26,'2024','2024-05-10','Royal Ploughing Ceremony Day',NULL,'2025-06-13 15:40:05','2025-06-13 15:40:05'),(27,'2024','2024-05-22','Visakha Bucha Day',NULL,'2025-06-13 15:40:19','2025-06-13 15:40:19'),(28,'2024','2024-06-03','Her Majesty the Queen\'s Birthday',NULL,'2025-06-13 15:40:41','2025-06-17 09:24:26'),(29,'2024','2024-07-22','Buddhist Lent Day (Substitution Day for 21 July 2024)',NULL,'2025-06-13 15:41:40','2025-06-13 15:41:40'),(30,'2024','2024-07-29','H.M. The King\'s Birthday (Substitution Day for 28 July 2024)',NULL,'2025-06-13 15:42:12','2025-06-17 09:24:36'),(31,'2024','2024-08-12','National Mother\'s Day',NULL,'2025-06-13 15:42:33','2025-06-17 09:24:47'),(32,'2024','2024-10-14','King Bhumibol Memorial Day (Substitution Day for 13 October 2024)',NULL,'2025-06-13 15:42:50','2025-06-13 15:42:50'),(33,'2024','2024-10-23','King Chulalongkorn Memorial Day',NULL,'2025-06-13 15:43:10','2025-06-13 15:43:10'),(34,'2024','2024-12-05','National Father\'s Day',NULL,'2025-06-13 15:43:26','2025-06-17 09:25:00'),(35,'2024','2024-12-10','Constitution Day',NULL,'2025-06-13 15:43:41','2025-06-13 15:43:41'),(36,'2024','2024-12-30','Additional Official Holiday',NULL,'2025-06-13 15:45:02','2025-06-13 15:45:02'),(37,'2024','2024-12-31','Year\'s End Day',NULL,'2025-06-13 15:45:34','2025-06-17 09:25:11'),(38,'2025','2025-01-01','New Year\'s Day',NULL,'2025-06-13 15:47:18','2025-06-16 14:00:33'),(39,'2025','2025-02-12','Makha Bucha Day',NULL,'2025-06-13 15:47:39','2025-06-13 15:47:39'),(40,'2025','2025-04-07','Chakri Memorial Day (Substitution Day for 6 April 2025)',NULL,'2025-06-13 15:47:56','2025-06-13 15:47:56'),(41,'2025','2025-04-14','Songkran Festival Day',NULL,'2025-06-13 15:48:15','2025-06-13 15:48:15'),(42,'2025','2025-04-15','Songkran Festival Day',NULL,'2025-06-13 15:48:30','2025-06-13 15:48:30'),(43,'2025','2025-04-16','Songkran Festival Day (Substitution Day for 13 April 2025)',NULL,'2025-06-13 15:48:52','2025-06-13 15:48:52'),(44,'2025','2025-05-05','Coronation Day (Substitution Day for 4 May 2025)',NULL,'2025-06-13 15:49:08','2025-06-13 15:49:08'),(45,'2025','2025-05-09','Royal Ploughing Ceremony Day',NULL,'2025-06-13 15:49:33','2025-06-13 15:49:33'),(46,'2025','2025-05-12','Visakha Bucha Day (Substitution Day for 11 May 2025)',NULL,'2025-06-13 15:49:46','2025-06-13 15:49:46'),(47,'2025','2025-06-02','Additional Official Holiday',NULL,'2025-06-13 15:50:01','2025-06-13 15:50:01'),(48,'2025','2025-06-03','Her Majesty the Queen\'s Birthday',NULL,'2025-06-13 15:50:12','2025-06-17 09:22:07'),(49,'2025','2025-07-10','Asarnha Bucha Day',NULL,'2025-06-13 15:50:24','2025-06-13 15:50:24'),(50,'2023','2023-05-05','Special Holiday',NULL,'2025-06-13 15:50:36','2025-06-13 15:50:36'),(51,'2025','2025-07-11','Buddhist Lent Day',NULL,'2025-06-13 15:50:37','2025-06-13 15:50:37'),(52,'2023','2023-12-29','Special Holiday',NULL,'2025-06-13 15:51:00','2025-06-13 15:51:00'),(53,'2025','2025-07-28','H.M. The King\'s Birthday',NULL,'2025-06-13 15:51:05','2025-06-17 09:22:00'),(54,'2025','2025-08-11','Additional Official Holiday',NULL,'2025-06-13 15:51:20','2025-06-13 15:51:20'),(55,'2025','2025-08-12','National Mother\'s Day',NULL,'2025-06-13 15:51:36','2025-06-17 09:22:28'),(56,'2025','2025-10-13','King Bhumibol Memorial Day',NULL,'2025-06-13 15:51:46','2025-06-13 15:51:46'),(57,'2025','2025-10-23','King Chulalongkorn Memorial Day',NULL,'2025-06-13 15:52:12','2025-06-13 15:52:12'),(58,'2025','2025-12-05','National Father\'s Day',NULL,'2025-06-13 15:52:25','2025-06-17 09:22:17'),(59,'2025','2025-12-10','Constitution Day',NULL,'2025-06-13 15:52:36','2025-06-13 15:52:36'),(60,'2025','2025-12-31','Year\'s End Day',NULL,'2025-06-13 15:52:48','2025-06-16 14:00:05'),(61,'2024','2024-04-12','Special Holiday',NULL,'2025-06-13 16:01:06','2025-06-13 16:01:06'),(63,'2026','2026-01-01','New Year\'s Day',NULL,'2025-11-27 15:01:44','2025-11-27 15:01:44'),(64,'2026','2026-01-02','Additional Official Holiday',NULL,'2025-11-27 18:05:56','2025-11-29 15:10:53'),(65,'2026','2026-03-03','Makha Bucha Day',NULL,'2025-11-29 15:10:22','2025-11-29 15:11:14'),(66,'2026','2026-04-06','Chakri Memorial Day',NULL,'2025-11-29 15:12:11','2025-11-29 15:12:11'),(67,'2026','2026-04-13','Songkran Festival Day',NULL,'2025-11-29 15:12:46','2025-11-29 15:12:46'),(68,'2026','2026-04-14','Songkran Festival Day',NULL,'2025-11-29 15:12:57','2025-11-29 15:12:57'),(69,'2026','2026-04-15','Songkran Festival Day',NULL,'2025-11-29 15:13:09','2025-11-29 15:13:09'),(70,'2026','2026-05-04','Coronation Day',NULL,'2025-11-29 15:13:43','2025-11-29 15:13:43'),(71,'2026','2026-05-13','Royal Ploughing Ceremony Day',NULL,'2025-11-29 15:14:23','2025-11-29 15:14:23'),(72,'2026','2026-06-01','Visakha Bucha Day (Substitution Day for 31 May 2026)',NULL,'2025-11-29 15:15:34','2025-11-29 15:15:34'),(73,'2026','2026-06-03','Her Majesty the Queen\'s Birthday',NULL,'2025-11-29 15:16:02','2025-11-29 15:16:02'),(74,'2026','2026-07-28','H.M. The King\'s Birthday',NULL,'2025-11-29 15:16:32','2025-11-29 15:16:32'),(75,'2026','2026-07-29','Asarnha Bucha Day',NULL,'2025-11-29 15:17:15','2025-11-29 15:17:15'),(76,'2026','2026-07-30','Buddhist Lent Day',NULL,'2025-11-29 15:17:48','2025-11-29 15:17:48'),(77,'2026','2026-08-12','National Mother\'s Day',NULL,'2025-11-29 15:18:23','2025-11-29 15:18:23'),(78,'2026','2026-10-13','Nawamindra Maharaj day',NULL,'2025-11-29 15:19:56','2025-11-29 15:19:56'),(79,'2026','2026-10-23','King Chulalongkorn Memorial Day',NULL,'2025-11-29 15:20:19','2025-11-29 15:20:19'),(80,'2026','2026-12-07','National Father\'s Day (Substitution Day for 5 December 2026)',NULL,'2025-11-29 15:21:19','2025-11-29 15:21:19'),(81,'2026','2026-12-10','Constitution Day',NULL,'2025-11-29 15:21:47','2025-11-29 15:21:47'),(82,'2026','2026-12-31','Year\'s End Day',NULL,'2025-11-29 15:22:22','2025-11-29 15:22:22');
/*!40000 ALTER TABLE `calendar` 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 2026-05-27 10:00:02
