Da

✏️ Editing: booktaet_wedding.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: booktaet_wedding
-- ------------------------------------------------------
-- 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: `booktaet_wedding`
--

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

USE `booktaet_wedding`;

--
-- Table structure for table `guest`
--

DROP TABLE IF EXISTS `guest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `group` text NOT NULL,
  `relation` text NOT NULL,
  `follower` int(11) NOT NULL,
  `u_date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `guest`
--

LOCK TABLES `guest` WRITE;
/*!40000 ALTER TABLE `guest` DISABLE KEYS */;
INSERT INTO `guest` VALUES (27,'พี่มด','Both','workmate',3,'2025-04-30 17:26:18',1),(28,'น้องแอล Marcom THG','Book','workmate',1,'2025-05-03 13:04:20',1),(29,'ท็อบบี้','Tae','friend',0,'2025-05-03 13:52:41',1),(30,'ฝน','Tae','friend',0,'2025-05-04 02:41:57',1),(31,'Macc','Tae','friend',0,'2025-05-04 02:42:05',1),(34,'โอ๊ต','Both','workmate',1,'2025-05-13 15:22:45',1),(35,'Meparu','Book','workmate',0,'2025-05-13 15:24:18',1),(36,'เอิ๊ก','Tae','friend',2,'2025-05-15 14:34:16',1),(37,'บี้','Book','friend',1,'2025-05-17 20:59:16',1),(38,'น้องนิวไง','Tae','friend',0,'2025-05-19 00:28:05',1),(39,'Big Popboy','Tae','friend',1,'2025-06-01 14:32:33',1),(40,'ปิ่น','Book','family',2,'2025-06-08 20:38:32',1),(41,'pon','Book','friend',0,'2025-06-09 11:27:37',1),(42,'พี่ตาล','Book','workmate',1,'2025-06-09 12:00:47',1),(43,'มน','Book','friend',1,'2025-06-09 12:13:50',1),(44,'เพชรพลอย ','Book','friend',2,'2025-06-09 12:16:38',1),(45,'กาดี้','Book','friend',1,'2025-06-09 12:28:48',1),(46,'โบ','Book','friend',0,'2025-06-09 12:33:27',1),(47,'เปียว','Book','friend',0,'2025-06-09 23:05:14',1),(48,'นันท์กิกี้','Book','friend',1,'2025-06-10 22:01:56',1),(49,'Klai','Book','friend',1,'2025-06-11 23:53:54',1),(50,'Minktood','Book','friend',2,'2025-06-12 21:14:50',1),(51,'โสม','Book','friend',0,'2025-06-12 22:48:43',1),(52,'มะตอง','Book','friend',1,'2025-06-13 00:16:06',1),(53,'Test','Book','family',0,'2025-06-13 08:25:42',1),(54,'บิว คนสวยยยยยยยยยยยย','Tae','workmate',0,'2025-06-13 08:41:01',1),(55,'น้าปุ๋ย','Book','family',0,'2025-06-13 21:11:18',1),(56,'คุณตาปรีชา-คุณยายพรรณี','Book','family',2,'2025-06-14 08:15:12',1),(57,'น้าเกษม-น้ายุเย','Book','family',2,'2025-06-14 17:05:39',1),(58,'มิม','Book','friend',1,'2025-06-14 20:04:18',1),(59,'เป้โชวา','Book','friend',2,'2025-06-15 12:37:14',1),(60,'แม่ปิ่น','Book','guest_family',4,'2025-06-15 12:55:41',1),(61,'มิม','Book','friend',1,'2025-06-15 20:00:28',1),(62,'คุณรัตนา อินทรแก้ว','Book','relative',4,'2025-06-17 08:56:19',1),(63,'คุณรัตนา อินทรแก้ว','Book','relative',4,'2025-06-17 08:56:19',1),(64,'คุณรัตนา อินทรแก้ว','Book','relative',4,'2025-06-17 08:56:19',1),(65,'ผึ้ง','Both','workmate',0,'2025-06-19 14:09:31',1),(66,'น้าศกุนตลา น้าต๋อย','Book','guest_family',0,'2025-06-23 11:50:20',1),(67,'น้าดุษณีย์','Book','guest_family',0,'2025-06-23 11:50:41',1),(68,'น้าประพรรณพักตร์','Book','guest_family',0,'2025-06-23 11:51:08',1),(69,'น้าต้อม','Book','guest_family',0,'2025-06-23 11:51:19',1),(70,'น้าทัดโรงงานยา','Book','guest_family',1,'2025-06-23 11:51:27',1),(71,'พ.ต.อ.ธำรงค์','Book','guest_family',1,'2025-06-23 11:51:46',1),(72,'น้าแดง ไฟฟ้า','Book','guest_family',0,'2025-06-23 11:52:02',1),(73,'พล.ต.ต. ธีรยุทธ','Book','guest_family',1,'2025-06-23 11:52:08',1),(74,'บุ๊ค','Book','friend',2,'2025-07-23 21:22:53',1),(75,'','Book','family',0,'2025-07-29 10:45:54',1),(76,'อาว์อู๊ดอาว์เล็ก','Book','family',0,'2025-07-29 10:49:19',1),(77,'เต้','Tae','friend',0,'2025-08-01 08:35:22',1),(78,'ไผ่ pccst','Tae','friend',0,'2025-08-01 18:48:24',1),(79,'บังมี','Tae','workmate',0,'2025-08-10 14:01:02',1),(80,'เสรี ตนายะพงศ์ (รพ.ราษฎร์ยินดี)','Tae','workmate',3,'2025-08-12 18:35:26',1),(81,'พี่แอม','Book','workmate',0,'2025-08-13 10:59:12',1),(82,'พี่แอนนา','Book','workmate',0,'2025-08-13 11:00:36',1),(83,'ว่าน IT','Tae','workmate',2,'2025-08-16 16:57:01',1),(84,'ณาย ','Tae','workmate',1,'2025-08-16 16:57:32',1);
/*!40000 ALTER TABLE `guest` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `message`
--

DROP TABLE IF EXISTS `message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `group` text NOT NULL,
  `relation` text NOT NULL,
  `message` text NOT NULL,
  `img` text NOT NULL,
  `u_date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `message`
--

LOCK TABLES `message` WRITE;
/*!40000 ALTER TABLE `message` DISABLE KEYS */;
INSERT INTO `message` VALUES (2,'Test','Book','family','ยินดีด้วยค่ะ','','2025-06-13 08:25:29',1);
/*!40000 ALTER TABLE `message` 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:19:04

📁 Sid Gifari File Manager