Da

✏️ Editing: lilildev_svt.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: lilildev_svt
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

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

--
-- Current Database: `lilildev_svt`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `lilildev_svt` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `lilildev_svt`;

--
-- Table structure for table `health_check_logs`
--

DROP TABLE IF EXISTS `health_check_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `health_check_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `event_type` varchar(50) NOT NULL COMMENT 'ประเภทของเหตุการณ์ เช่น PRIMARY_FAIL, UNHEALTHY_JSON',
  `check_url` varchar(255) NOT NULL COMMENT 'URL หลักที่ตรวจสอบ',
  `status_code` int(11) DEFAULT NULL COMMENT 'HTTP Status Code ที่ได้รับ',
  `curl_error` text DEFAULT NULL COMMENT 'ข้อความ error จาก cURL (ถ้ามี)',
  `response_body` text DEFAULT NULL COMMENT 'เนื้อหา Response ที่ได้รับจาก URL',
  `details` text DEFAULT NULL COMMENT 'รายละเอียดของข้อความที่ส่งแจ้งเตือน',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `health_check_logs`
--

LOCK TABLES `health_check_logs` WRITE;
/*!40000 ALTER TABLE `health_check_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `health_check_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_downloaded_bucket_files_progress`
--

DROP TABLE IF EXISTS `log_downloaded_bucket_files_progress`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_downloaded_bucket_files_progress` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ref_id` int(3) NOT NULL,
  `user_id` int(3) NOT NULL,
  `company_id` int(3) NOT NULL,
  `fileName` varchar(250) NOT NULL,
  `status` varchar(250) NOT NULL,
  `created_at` datetime NOT NULL,
  `timestamp` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `action` varchar(10) NOT NULL DEFAULT 'open',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_downloaded_bucket_files_progress`
--

LOCK TABLES `log_downloaded_bucket_files_progress` WRITE;
/*!40000 ALTER TABLE `log_downloaded_bucket_files_progress` DISABLE KEYS */;
INSERT INTO `log_downloaded_bucket_files_progress` VALUES (1,4884,2030,13,'2023-08-01-00-00_to_2023-08-14-23-59','IN_PROGRESS','2023-08-15 07:59:28','2023-08-15 08:00:05','open'),(2,4887,3292,27,'2023-08-11-00-00_to_2023-08-11-23-59','IN_PROGRESS','2023-08-17 09:35:10','2023-08-17 11:00:08','close'),(3,4892,7461,72,'2023-08-21-00-00_to_2023-08-23-23-59','IN_PROGRESS','2023-08-23 09:33:28','2023-08-23 10:30:04','close'),(4,4893,8731,89,'2023-08-22-00-00_to_2023-08-23-23-59','IN_PROGRESS','2023-08-23 17:19:57','2023-08-23 18:30:04','close'),(5,4894,8731,89,'2023-08-23-00-00_to_2023-08-24-23-59','IN_PROGRESS','2023-08-24 08:38:02','2023-08-24 09:31:06','close'),(6,4900,7461,72,'2023-08-27-00-00_to_2023-08-27-23-59','IN_PROGRESS','2023-08-28 15:41:55','2023-08-28 16:30:08','close'),(7,4913,2463,18,'2023-10-08-00-00_to_2023-10-08-03-00','IN_PROGRESS','2023-09-08 11:28:50','2023-09-08 11:30:04','open'),(8,4914,2463,18,'2023-09-08-11-30_to_2023-09-08-11-30','IN_PROGRESS','2023-09-08 11:30:32','2023-09-08 12:30:04','close'),(9,4917,8509,7,'2023-09-08-15-54_to_2023-09-08-17-54','IN_PROGRESS','2023-09-08 17:55:18','2023-09-08 18:00:06','open'),(10,4919,8509,7,'2023-09-07-18-47_to_2023-09-08-18-47','IN_PROGRESS','2023-09-08 19:49:28','2023-09-08 20:00:09','open'),(11,4922,8509,7,'2023-09-08-10-53_to_2023-09-09-10-53','IN_PROGRESS','2023-09-09 10:54:11','2023-09-09 11:00:05','open'),(12,4925,7234,68,'2023-09-08-00-00_to_2023-09-10-00-00','IN_PROGRESS','2023-09-11 10:42:40','2023-09-11 11:30:04','close'),(13,4930,7461,72,'2023-09-01-00-00_to_2023-09-11-23-59','IN_PROGRESS','2023-09-12 09:45:56','2023-09-12 10:30:04','close'),(14,4934,2030,13,'2023-09-01-00-00_to_2023-09-12-23-59','IN_PROGRESS','2023-09-13 17:29:08','2023-09-13 17:30:05','open'),(15,4952,7784,78,'2023-09-01-00-00_to_2023-09-30-23-59','IN_PROGRESS','2023-10-01 05:29:12','2023-10-01 05:30:04','open'),(16,4964,7680,76,'2023-10-11-00-00_to_2023-10-11-23-59','IN_PROGRESS','2023-10-12 11:28:59','2023-10-12 11:30:07','open'),(17,4965,8509,7,'2023-09-12-00-00_to_2023-10-12-23-59','IN_PROGRESS','2023-10-12 15:28:38','2023-10-12 15:30:05','open'),(18,4971,7680,76,'2023-10-14-00-03_to_2023-10-14-23-59','IN_PROGRESS','2023-10-15 08:59:00','2023-10-15 09:00:05','open'),(19,4995,8731,89,'2023-10-24-00-00_to_2023-10-25-00-00','IN_PROGRESS','2023-10-25 10:29:05','2023-10-25 10:30:04','open'),(20,5017,7680,76,'2023-10-26-00-00_to_2023-10-26-23-59','IN_PROGRESS','2023-10-27 10:29:12','2023-10-27 10:30:10','open'),(21,5082,8731,89,'2023-11-11-23-01_to_2023-11-12-23-00','IN_PROGRESS','2023-11-14 15:29:52','2023-11-14 15:31:14','open'),(22,5102,8731,89,'2023-11-13-23-01_to_2023-11-14-23-00','IN_PROGRESS','2023-11-17 10:29:59','2023-11-17 10:30:08','open'),(23,5108,8731,89,'2023-11-17-23-01_to_2023-11-18-23-00','IN_PROGRESS','2023-11-23 11:29:48','2023-11-23 11:30:49','open');
/*!40000 ALTER TABLE `log_downloaded_bucket_files_progress` 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-10-26 21:38:52

📁 Sid Gifari File Manager