Da

✏️ Editing: designco_activity_game.sql

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

/*!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: `designco_activity_game`
--

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

USE `designco_activity_game`;

--
-- Table structure for table `activity`
--

DROP TABLE IF EXISTS `activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activity` (
  `activity_id` int(11) NOT NULL AUTO_INCREMENT,
  `topic` varchar(75) NOT NULL,
  `detail` text NOT NULL,
  `condition` text DEFAULT NULL,
  `img_cover` varchar(75) NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1' COMMENT '1=open,0=stop',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`activity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `activity`
--

LOCK TABLES `activity` WRITE;
/*!40000 ALTER TABLE `activity` DISABLE KEYS */;
INSERT INTO `activity` VALUES (1,'ทายผลการแข่งขัน','กิจกรรมทายผลการแข่งขันลุ้นรับ 30,000 บาท','พิเศษ สำหรับสมาชิกที่มียอดเดิมพันย้อนหลัง 7 วัน ขึ้นไป รับรางวัลX2 \r\n- สมาชิกต้องมียอดเทิร์น 300 ขึ้นไปของวัน ที่ 07 พฤศจิกายน 2566\r\n( นับเฉพาะยอดเทิร์นกีฬา นับยอดเทิร์นกิจกรรมตั้งแต่ 11.00-22.00 น. ) \r\n- หากเล่นบิลสเต็ปคู่ที่เล่นต้องเคลียร์ก่อน 22.00 น. เท่านั้น \r\n- รางวัลหารตามจำนวนคนที่ตอบถูก \r\n- ทายเสมอ 0-0 เลือกทีมใดยิงก่อนก็ได้ \r\n- ผลการแข่งขันนับเฉพาะ 90 นาทีในเวลาเท่านั้น \r\n- 1 User ทายผลได้เพียง 1 ครั้ง เท่านั้น (หากมีคำตอบมากกว่า 1 ยึดคำตอบแรกเท่านั้น) \r\n- หมดเวลาร่วมสนุก 07 พฤศจิกายน เวลา 22.00 น. \r\n- การตัดสินของทีมงานถือเป็นที่สิ้นสุด','88660efc-4750-4865-81aa-2ec39ff605dc.png','1','2023-11-05 20:00:59','admin','2025-09-28 18:58:17','admin'),(2,'ทายผลผู้ชนะ','กิจกรรมทายผลผู้ชนะลุ้นรับ 50,000 บาท','- ทายผลมวย ฝ่ายใดจะชนะ และชนะแบบใด\r\nชนะคะแนน,ชนะน็อค \r\n- สมาชิกต้องมียอดเทิร์น 300 ขึ้นไปของวัน ที่ 24 พฤศจิกายน 2566 \r\n(นับเฉพาะยอดเทิร์นกีฬา นับยอดเทิร์นตั้งแต่ 11.00 น. - 19.30 น.) \r\n- หากเล่นบิลสเต็ปคู่ที่เล่นต้องเคลียร์ก่อน 19.30 น. เท่านั้น \r\n- หากผลออกเสมอจะถือเป็นโมฆะ \r\n- รางวัลหารตามจำนวนคนที่ตอบถูก \r\n- 1 User ทายผลได้เพียง 1 ครั้ง เท่านั้น (หากมีคำตอบมากกว่า 1 ยึดคำตอบแรกเท่านั้น) \r\n- หมดเวลาร่วมสนุก 24 พฤศจิกายน 2566 เวลา 19.30 น. \r\n- การตัดสินของทีมงานถือเป็นที่สิ้นสุด','81f34de8-e414-4fc0-96a2-5674b696ebb2.jpeg','1','2023-11-05 20:00:59','admin','2025-09-28 19:00:22','admin');
/*!40000 ALTER TABLE `activity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `activity_announcement`
--

DROP TABLE IF EXISTS `activity_announcement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activity_announcement` (
  `activity_announcement_id` int(11) NOT NULL AUTO_INCREMENT,
  `cover_image` varchar(75) NOT NULL,
  `folder` varchar(75) DEFAULT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1' COMMENT '1=open,0=stop',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`activity_announcement_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `activity_announcement`
--

LOCK TABLES `activity_announcement` WRITE;
/*!40000 ALTER TABLE `activity_announcement` DISABLE KEYS */;
INSERT INTO `activity_announcement` VALUES (1,'d8e1396c-3775-451c-a500-ce8e3ceaa82f.jpeg','lottery','1','2023-12-01 18:49:41','admin','2023-12-11 13:51:00','admin'),(2,'f130d294-bd31-4829-9120-7420caa354ef.jpeg','football','1','2023-12-01 18:52:16','admin','2023-12-08 16:18:59','admin'),(3,'0fdd3837-34cd-41bd-abed-1ac50bd9dfba.jpeg','football','1','2023-12-08 13:57:43','admin','2023-12-10 22:03:12','admin'),(4,'4f43833c-299e-4813-8296-23f865de2d21.jpeg','lottery','1','2023-12-08 16:16:49','admin','2023-12-11 13:50:35','admin'),(5,'831f5ab1-17dc-48b6-8af7-b9a59ec6a4d3.jpeg','boxing','1','2023-12-08 16:18:10','admin',NULL,NULL),(6,'dd5c6dcf-b063-410b-9599-20f760663f23.jpeg','boxing','1','2023-12-08 16:18:18','admin',NULL,NULL),(7,'453161d8-e65c-4c4f-a94c-c19b9d1ea65b.jpeg','football','1','2023-12-08 16:18:40','admin',NULL,NULL),(8,'8459b3ee-f86b-4c3d-a23b-19d406adf413.jpeg','football','1','2023-12-08 16:18:49','admin',NULL,NULL);
/*!40000 ALTER TABLE `activity_announcement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `authorized`
--

DROP TABLE IF EXISTS `authorized`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `authorized` (
  `auth_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `activity` int(11) NOT NULL DEFAULT 0,
  `football` int(11) NOT NULL DEFAULT 0,
  `boxing` int(11) NOT NULL DEFAULT 0,
  `lottery` int(11) NOT NULL,
  `news` int(11) NOT NULL DEFAULT 0,
  `promote` int(11) NOT NULL DEFAULT 0,
  `setting` int(11) NOT NULL DEFAULT 0,
  `auth` int(11) NOT NULL DEFAULT 0,
  `user_admin` int(11) NOT NULL DEFAULT 0,
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `authorized`
--

LOCK TABLES `authorized` WRITE;
/*!40000 ALTER TABLE `authorized` DISABLE KEYS */;
INSERT INTO `authorized` VALUES (1,'เปิดทั้งหมด',1,1,1,1,1,1,1,1,1,'1','admin','2022-01-02 13:30:00','admin','2023-06-27 18:05:57');
/*!40000 ALTER TABLE `authorized` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `boxing_activity`
--

DROP TABLE IF EXISTS `boxing_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boxing_activity` (
  `boxing_activity_id` int(11) NOT NULL AUTO_INCREMENT,
  `activity_id` int(11) NOT NULL DEFAULT 2,
  `competition` text NOT NULL,
  `master_team_red` varchar(75) NOT NULL,
  `master_team_blue` varchar(75) NOT NULL,
  `logo_team_red` varchar(45) DEFAULT NULL,
  `logo_team_blue` varchar(45) DEFAULT NULL,
  `match_date` date NOT NULL,
  `score_team_win` enum('team_blue','team_red') DEFAULT NULL,
  `score_type` enum('knock','score') DEFAULT NULL,
  `cover_image` varchar(45) DEFAULT NULL,
  `activity_announcement_id` int(11) DEFAULT NULL,
  `background_image` varchar(45) DEFAULT NULL,
  `confirm_activity` varchar(45) DEFAULT NULL,
  `activity_start_date` datetime NOT NULL,
  `activity_end_date` datetime NOT NULL,
  `detail` text DEFAULT NULL,
  `status` enum('1','2','3','0') NOT NULL DEFAULT '1' COMMENT '1=open,2=pause,3=close,4=remove',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`boxing_activity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `boxing_activity`
--

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

--
-- Table structure for table `boxing_activity_player`
--

DROP TABLE IF EXISTS `boxing_activity_player`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boxing_activity_player` (
  `boxing_activity_player_id` int(11) NOT NULL AUTO_INCREMENT,
  `boxing_activity_id` int(11) NOT NULL,
  `username` varchar(75) NOT NULL,
  `name_surname` text NOT NULL,
  `player_seleced` enum('team_blue','team_red') NOT NULL,
  `score_type` enum('knock','score','all') NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1' COMMENT '1=open,0=stop',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`boxing_activity_player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `boxing_activity_player`
--

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

--
-- Table structure for table `football_activity`
--

DROP TABLE IF EXISTS `football_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `football_activity` (
  `football_activity_id` int(11) NOT NULL AUTO_INCREMENT,
  `activity_id` int(11) NOT NULL DEFAULT 1,
  `competition` text NOT NULL,
  `master_team_home` varchar(75) NOT NULL,
  `master_team_away` varchar(75) NOT NULL,
  `logo_team_home` varchar(45) DEFAULT NULL,
  `logo_team_away` varchar(45) DEFAULT NULL,
  `match_date` datetime NOT NULL,
  `score_team_home` int(11) DEFAULT NULL,
  `score_team_away` int(11) DEFAULT NULL,
  `score_team_firstscore` enum('team_a','team_b') DEFAULT NULL,
  `cover_image` varchar(45) DEFAULT NULL,
  `activity_announcement_id` int(11) DEFAULT NULL,
  `background_image` varchar(45) DEFAULT NULL,
  `confirm_activity` varchar(45) DEFAULT NULL,
  `activity_start_date` datetime NOT NULL,
  `activity_end_date` datetime NOT NULL,
  `detail` text DEFAULT NULL,
  `status` enum('1','2','3','0') NOT NULL DEFAULT '1' COMMENT '1=open,2=pause,3=close,4=remove',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`football_activity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `football_activity`
--

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

--
-- Table structure for table `football_activity_player`
--

DROP TABLE IF EXISTS `football_activity_player`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `football_activity_player` (
  `football_activity_player_id` int(11) NOT NULL AUTO_INCREMENT,
  `football_activity_id` int(11) NOT NULL,
  `username` varchar(75) NOT NULL,
  `name_surname` text NOT NULL,
  `player_seleced` enum('final_score','first_score') NOT NULL,
  `score_team_a` int(11) DEFAULT 0,
  `score_team_b` int(11) DEFAULT 0,
  `score_team_firstscore` enum('team_a','team_b') NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1' COMMENT '1=open,0=stop',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`football_activity_player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `football_activity_player`
--

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

--
-- Table structure for table `lottery_activity`
--

DROP TABLE IF EXISTS `lottery_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lottery_activity` (
  `lottery_activity_id` int(11) NOT NULL AUTO_INCREMENT,
  `activity_id` int(11) NOT NULL DEFAULT 3,
  `competition` text NOT NULL,
  `period_date` date NOT NULL,
  `last_2_digits` int(2) DEFAULT NULL,
  `last_3_digits` int(3) DEFAULT NULL,
  `cover_image` varchar(45) DEFAULT NULL,
  `activity_announcement_id` int(11) DEFAULT NULL,
  `background_image` varchar(45) DEFAULT NULL,
  `confirm_activity` varchar(45) DEFAULT NULL,
  `activity_start_date` datetime NOT NULL,
  `activity_end_date` datetime NOT NULL,
  `detail` text DEFAULT NULL,
  `condition` text DEFAULT NULL,
  `status` enum('1','2','3','0') NOT NULL DEFAULT '1' COMMENT '1=open,2=pause,3=close,4=remove',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`lottery_activity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lottery_activity`
--

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

--
-- Table structure for table `lottery_activity_player`
--

DROP TABLE IF EXISTS `lottery_activity_player`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lottery_activity_player` (
  `lottery_activity_player_id` int(11) NOT NULL AUTO_INCREMENT,
  `lottery_activity_id` int(11) NOT NULL,
  `username` varchar(75) NOT NULL,
  `name_surname` text NOT NULL,
  `last_2_digits` varchar(2) DEFAULT NULL,
  `last_3_digits` varchar(3) DEFAULT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1' COMMENT '1=open,0=stop',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`lottery_activity_player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lottery_activity_player`
--

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

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `topic` varchar(75) NOT NULL,
  `detail` text NOT NULL,
  `condition` text DEFAULT NULL,
  `cover_image` varchar(75) NOT NULL,
  `background_image` varchar(75) NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1' COMMENT '1=open,0=stop',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `news`
--

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

--
-- Table structure for table `promote`
--

DROP TABLE IF EXISTS `promote`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `promote` (
  `promote_id` int(11) NOT NULL AUTO_INCREMENT,
  `topic` varchar(75) NOT NULL,
  `url` text NOT NULL,
  `cover_image` varchar(75) NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1' COMMENT '1=open,0=stop',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`promote_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `promote`
--

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

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `auth_id` int(11) DEFAULT NULL,
  `username` varchar(25) NOT NULL,
  `name` varchar(205) DEFAULT NULL,
  `password` varchar(75) NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,1,'admin','แอดมิน','d54d1702ad0f8326224b817c796763c9','1','Website','2022-01-03 01:17:22','admin','2022-06-17 18:35:43','2025-09-29 13:48:16');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_authentication`
--

DROP TABLE IF EXISTS `user_authentication`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_authentication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `expired_at` datetime NOT NULL DEFAULT current_timestamp(),
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `member_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_authentication`
--

LOCK TABLES `user_authentication` WRITE;
/*!40000 ALTER TABLE `user_authentication` DISABLE KEYS */;
INSERT INTO `user_authentication` VALUES (113,1,'rPQE0hYc9lgnFOszNRYHgui8RfPZXQznOw','2025-10-02 01:48:16','2025-09-29 13:48:16','2025-09-29 13:48:16');
/*!40000 ALTER TABLE `user_authentication` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_history`
--

DROP TABLE IF EXISTS `user_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_history` (
  `user_history_id` int(11) NOT NULL AUTO_INCREMENT,
  `activity_id` varchar(25) DEFAULT NULL,
  `detail_id` varchar(25) DEFAULT '-',
  `topic` varchar(75) DEFAULT NULL,
  `detail` text DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  PRIMARY KEY (`user_history_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_history`
--

LOCK TABLES `user_history` WRITE;
/*!40000 ALTER TABLE `user_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_history` 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-31 13:20:00

📁 Sid Gifari File Manager